Skip to main content
September 24, 2023
Question

Reconciling

  • September 24, 2023
  • 1 reply
  • 0 views

Hello. I use QBO. I'm reconciling trying to find my large balance error. I've triple checked to make sure all deposits and expenses are listed as "C" cleared and match my bank statement. Each month prior has always been balanced $0.00 and the stating/ending balances along with ending bank statement date are correct.

I noticed under the reconcile page at the top header it states "76 deposits and 377 expenses". However; in reality, not only does my bank statement show 68 deposits and 267 expenses, but so does the QBO below transactions where you clear (check off) items.  

Apparently somewhere in the past it logs these additional expenses & deposits for it to show and I need to find and remove them.  But I can't find them.  Please help!  Thank you.

1 reply

September 25, 2023

Thanks for outlining the details of your concern with the reconciliation issues in your account in QuickBooks Online (QBO), QueensPizza.

 

We can review the Quickreport of the account you want to reconcile. This way, you can locate the transactions that cause the discrepancy.

 

Here's how:

 

  1. Go to the Gear icon.
  2. Select Chart of Accounts.
  3. Choose the account you want to reconcile.
  4. Click the drop-down arrow beside the View register.
  5. Tap Run report.

 

I'd also suggest checking the Audit log to verify if there are duplicate transactions. I'll guide you on how to do it.

 

  1. Go to the Gear icon.
  2. Under Tools, select Audit log.
  3. Modify the Date Changed and Events.

 

You can check this article to learn more on how to reconcile accounts so they always match your bank and bank statements: Reconcile an account in QuickBooks Online.

 

Please keep in touch with me here should you have any additional questions or concerns, I want to ensure your success. Thanks for dropping in and have a wonderful rest of your day.