How can I change a completed reconciliation report? I made a mistake.

How do I correct a mistake in a completed reconciliation in QuickBooks Online (like a wrong statement date)?

The reconciliation report itself can't be edited, since QuickBooks generates it as a fixed snapshot each time you reconcile, so correcting a detail like the ending statement date means undoing that reconciliation and redoing it with the right date. Good news first though: a wrong statement date is only a label on the report and doesn't change any of your balances or transactions, so if it won't cause confusion later, it's often fine to leave as is.

Step 1: Decide whether you need to fix it

If the only mistake is the ending statement date and your transactions and balances are all correct, your books are accurate and you may not need to do anything. Consider redoing it mainly if the wrong date could throw off next month's reconciliation or if you need the report to read correctly for your accountant or an audit.

Step 2: Undo the reconciliation

How you do this depends on your access, which is why some people don't see an Undo button.

If you have an accountant on QuickBooks Online Accountant: they can undo the specific reconciliation for you.

1. They sign in to QuickBooks Online Accountant and open your company.
2. They go to the Accounting menu, then Reconcile, then History by account.
3. They find the account and the reconciliation, select Undo, and confirm.

Steps: Undo a client's entire reconciliation in QuickBooks Online Accountant.

If you don't have that access (which is why the Undo button isn't showing), you can undo the period, or unreconcile the affected transactions one at a time from the register: Undo or remove transactions from reconciliations in QuickBooks Online.

Step 3: Redo the reconciliation with the correct date

1. Go to All apps, then Accounting, then Reconcile (or select Resume reconciling).
2. Enter the correct ending statement date and ending balance.
3. Confirm the difference shows $0.00, then finish.

Guide: Reconcile an account in QuickBooks Online.

Step 4: View or print the corrected report

1. Go to Reports, then Standard reports.
2. In "Find report by name," type Reconciliation Report and select it.
3. Choose the account and the reconcile period, then select View Report.

Note this report can't be exported to Excel directly, so to save it that way you highlight, copy, and paste it into Excel. Details: View, print, or export a reconciliation report in QuickBooks Online.

If you let us know what your reconciliation concern is, we can help you determine your next steps.