Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 9, 2025
Question

Update bank reconciliation report for changes made after reconciliation

  • September 9, 2025
  • 1 reply
  • 9 views

QB Desktop for accountant's has a toggle to switch between showing a PDF reconciliation report as of the reconciliation date, or a 'live' report with changes made afterward. Example: if I had two duplicate uncleared checks when I reconciled the bank account, then I delete the duplicate, the register balance on the bank reconciliation report no longer agrees to the balance sheet.

 

Am I missing a setting to let me view a QBO reconciliation report with changes made after the date?

 

As an accountant trying to tie out this report to the balance sheet, I sometimes have to:

  a. copy-paste the existing rec report into excel (because export to excel is not an option),

  b. manually add uncleared transactions recorded later than the bank rec by running the bank transaction detail sorted by create date,

  c. dig through the audit log (which is not filterable at all) to find any uncleared transactions that were deleted after the reconciliation.

 

Has anyone else found a better workaround for getting/creating a report updated for changes after the reconciliation date?

1 reply

QuickBooks Team
September 9, 2025

I appreciate you sharing your detailed experience with reconciliation reporting in QuickBooks Online (QBO), KM.

 

The reconciliation report in QBO is locked to the reconciliation date and will not dynamically update to reflect edits or deletions of uncleared transactions made after the reconciliation date.

 

Your current workarounds, copying the reconciliation report into Excel, manually adding uncleared transactions from detailed bank transaction reports sorted by date, and reviewing Audit logs, are consistent with the recommended approach given QBO's current capabilities.

 

As a best practice, if you encounter significant discrepancies after the reconciliation, you may consider undoing the reconciliation and redoing it once all adjustments are finalized.

 

Additionally, exploring customized reports or third-party solutions may provide enhanced visibility tailored to your reconciliation workflow.

 

If you have any questions about the reconciliation report in QBO, please let us know in this thread. We are here to help.