cancel
Showing results for 
Search instead for 
Did you mean: 
JENN_L
Level 1

Bank balance and QB Balance

Question: My bank balance and Quickbooks balances do not match.  This is not a new account and I am able to reconcile my account to my bank statement every month.  Where should I look to find what has thrown the balance off? TIA

2 Comments 2
Teri
Level 9

Bank balance and QB Balance

@JENN_L  When you "reconcile" an account, you are matching bank balance to account balance on books.  So what do you mean when you say you "are able to reconcile?  Most common item to miss is bank fees.

Jen_D
Moderator

Bank balance and QB Balance

Good day, @JENN_L,

 

Teri is correct. When reconciling in QuickBooks, make sure the bank statement matches with the data in QuickBooks Online.

 

If you're unable to reconcile, make sure all entries are entered into the program. Also, make sure there are no modified or deleted transactions that may affect the balance.

 

To find modified transactions, use the Audit Log. This report will show you the history or detail of a modified or deleted entry. Here's to use it:

 

  1. Click the Gear icon, then select Audit Log under Tools.
  2. Use the Filter button then choose Show only these events.
  3. Mark the Transactions box to show all the actions made to a certain entry.
  4. If you only want to find deleted entries, pick Deleted/Voided Transactions from the Show drop-down.
  5. Hit Apply.
    del.PNG
  6. From there, locate the deleted transaction and press View.
    del1.PNG
  7. Click on Show all to get the details needed to recreate the entry.

 

If there are deleted item, recreate them if necessary by clicking on the + New button on the toolbar. Here's an article to guide you on how to utilize the Audit Log: Use the audit log in QuickBooks Online.

 

Additionally, try checking this article to learn more about fixing balances in Banking: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online

 

Get back to us if there are any other things you need help with. I'll be more than happy to assist you further. Have a good one!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us