Skip to main content
September 19, 2022
Question

Hello: Re manual csv upload. When I did this I hit Exclude. I see the reconciliation diff is zero but does the bank register include excluded? there is 25k difference. T

  • September 19, 2022
  • 1 reply
  • 0 views
Bank Register is 25k more than the actual cash balance which agrees to reconciliation. How do I fix the register? Something to do with my excluded transactions? Thanks

1 reply

September 19, 2022

Let me provide answers to your banking queries in QuickBooks, @773515.

 

Once you exclude transactions, they won't affect your bank register. Only added and matched transactions will be marked as cleared on your account. They will be marked as C once you started to reconcile. 

 

The 25k difference may vary on the actual ending balance you've entered, including uncleared or unreconciled transactions. You can also review your opening and beginning balances. When you know they're accurate, please move to other steps in this article: What to do if QuickBooks Online doesn't match your bank statement at the end of reconciliation.
 

If you need help reviewing your accounts, I'd suggest getting in touch with your accountant. They can help you find the discrepancies and ensure your bank register matches with your bank statements. 

 

You can also check out our reconciliation workflow in QuickBooks. Use this guide anytime you need help doing or fixing a reconciliation. 

 

Please let me know if you need further help when reconciling your accounts. I'll be here to help you out. Have a good one.