cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

Reconciliation discrepancies report technical error

Hello,

When we reviewed CC reconciliation discrepancies report, we have found a technical error - the report shows that the beginning balance is off by $-11,013.23, but when we open the discrepancies report, the total amount of transactions is no greater than $-1,000.00. What is the best way to resolve this issue?

Thank you,
KH
Solved
Best answer 4 weeks ago

Accepted Solutions
QuickBooks Team

Hi  KH, Thanks for the screenshot. The difference of your...

Hi  KH,

Thanks for the screenshot. The difference of your reconciled total amount and beginning balance is caused by an edited or deleted reconciled transaction. Let me guide you on how to identify the transaction so you can fix this issue.

  1. Click the Gear icon.
  2. Under Tools, select Reconcile. Note the opening balance.
  3. Click the Gear icon.
  4. Select Chart of Accounts.
  5. Select the account you're trying to reconcile.
  6. From the Action column drop-down menu, click Run Report.
  7. Click Customize.
  8. Set the Report period to All Dates.
  9. In the Rows/Columns section, select Change Columns, then select the Last Modified checkbox. In the Filter section, select the Cleared checkbox and select Reconciled from the drop-down list.
  10. Click Run report.

Here's an article for more information in case the steps above doesn't fix the issue: Fix An Opening Balance To Match A Bank Statement.

I have this link in case you have other questions about QuickBooks Online (QBO): Help Articles For QuickBooks Online.

Fill me in if you need anything else. I'd be here to help.

View solution in original post

3 Comments
QuickBooks Team

Hi  KH, Thanks for the screenshot. The difference of your...

Hi  KH,

Thanks for the screenshot. The difference of your reconciled total amount and beginning balance is caused by an edited or deleted reconciled transaction. Let me guide you on how to identify the transaction so you can fix this issue.

  1. Click the Gear icon.
  2. Under Tools, select Reconcile. Note the opening balance.
  3. Click the Gear icon.
  4. Select Chart of Accounts.
  5. Select the account you're trying to reconcile.
  6. From the Action column drop-down menu, click Run Report.
  7. Click Customize.
  8. Set the Report period to All Dates.
  9. In the Rows/Columns section, select Change Columns, then select the Last Modified checkbox. In the Filter section, select the Cleared checkbox and select Reconciled from the drop-down list.
  10. Click Run report.

Here's an article for more information in case the steps above doesn't fix the issue: Fix An Opening Balance To Match A Bank Statement.

I have this link in case you have other questions about QuickBooks Online (QBO): Help Articles For QuickBooks Online.

Fill me in if you need anything else. I'd be here to help.

View solution in original post

Experienced Member

Thank you, IntuitMariaS, it's very helpful to learn about...

Thank you, IntuitMariaS, it's very helpful to learn about the customized report. I will keep looking for the difference.
QuickBooks Team

Hi @KH, You're very much welcome. Just let me know if yo...

Hi @KH,

You're very much welcome. Just let me know if you need anything else. I'd be here to help.

Need to get in touch?

Contact us