Correcting a reconciliation in QuickBooks Online is important when your bank statement does not match your accounting records or a previously reconciled transaction contains an error. Common issues include incorrect transaction amounts, deleted entries, duplicate payments, and changes to reconciled transactions. Identifying and correcting these problems helps maintain accurate financial reports and reliable bookkeeping records.
In this guide, you will learn how to correct a reconciliation in QuickBooks Online, identify common discrepancies, and prevent similar issues in the future.
Having trouble correcting a reconciliation in QuickBooks Online? Call 1-866-513-4656 for assistance with reconciliation errors, incorrect balances, and discrepancies in previously reconciled transactions.
Correcting a reconciliation means investigating and fixing errors that affect the balance or transactions in a completed bank reconciliation. You may need to correct a current reconciliation or investigate an earlier period if a transaction was accidentally changed or deleted.
QuickBooks Online provides reconciliation history and transaction records that can help you identify discrepancies. The appropriate correction depends on the type of error and whether the transaction has already been reconciled.
Before making changes, identify the possible cause of the discrepancy. Common reasons include:
Incorrect beginning or ending balance.
Missing bank transactions.
Duplicate deposits or expenses.
Incorrect transaction dates or amounts.
Previously reconciled transactions that were edited or deleted.
Transactions mistakenly marked as reconciled or unreconciled.
Bank fees or interest that were not recorded correctly.
Understanding the cause can help you avoid making unnecessary adjustments.
Follow these steps to identify and correct reconciliation errors.
Open QuickBooks Online and navigate to the Reconcile section. Review the account and statement period that contains the discrepancy.
Check the beginning balance, ending balance, and difference displayed by QuickBooks. Compare these details with the original bank statement to determine whether the issue relates to statement information or individual transactions.
If the beginning balance is incorrect, a transaction from a previous reconciliation may have been edited, deleted, or marked as unreconciled.
Review your previous reconciliation report and account register. Look for transactions whose amounts, dates, or reconciliation status have changed.
Where available, open the Reconciliation Discrepancy Report to identify changes affecting previously reconciled transactions.
You can also review the Audit Log to investigate changes made to transactions, including edits and deletions. Compare the results with your bank statements and earlier reconciliation reports before deciding what to correct.
Compare your QuickBooks records with the bank statement.
If a transaction is missing, enter it using the correct date, amount, and account. If a duplicate entry exists, confirm that it represents the same bank activity before correcting or removing it.
Avoid creating a new transaction when the original entry already exists under a different description.
If a transaction contains an incorrect amount, date, or account, determine whether the error affects a completed reconciliation.
Correct the underlying error carefully and review the impact on the current and subsequent reconciliation periods. If the transaction belongs to a closed accounting period or affects tax reporting, consult your accountant before making changes.
After correcting the identified error, return to the reconciliation screen and review the difference.
Confirm that the statement details are accurate and that all selected transactions match the bank statement. A difference of $0.00 indicates that the reconciliation balances, but you should still verify the accuracy of the entries.
Sometimes, correcting individual transactions is not enough, and you may need to undo a completed reconciliation.
QuickBooks Online does not provide the same reconciliation-undo options to every user. In some versions or workflows, an accountant user can undo a reconciliation, while other users may need to correct individual transactions instead.
Before undoing a reconciliation:
Save a copy of the reconciliation report.
Identify the period and account affected.
Review transactions that may have changed.
Consider how undoing the reconciliation could affect later periods.
Consult your accountant if you are unsure which correction is appropriate.
Avoid changing reconciliation statuses indiscriminately because this can create additional discrepancies.
If your reconciliation difference remains incorrect, use the following checks:
Verify the statement balance: Make sure the ending date and ending balance match the bank statement exactly.
Check for missing entries: Look for deposits, withdrawals, checks, and electronic payments that appear on the statement but not in QuickBooks.
Identify duplicate transactions: Review bank-feed entries and existing transactions to ensure the same activity has not been recorded twice.
Review older reconciliations: Investigate changes to previously reconciled transactions if the beginning balance is incorrect.
Check bank fees and interest: Record these transactions when appropriate and confirm they have not already been entered.
Do not force the reconciliation to zero by adding an unexplained adjustment. An unsupported adjustment can conceal an accounting error.
Follow these best practices to reduce future problems:
Reconcile bank and credit card accounts monthly.
Save copies of bank statements and reconciliation reports.
Review transactions before marking them as cleared.
Match downloaded transactions instead of adding duplicates.
Avoid editing previously reconciled transactions unnecessarily.
Investigate beginning balance changes promptly.
Maintain accurate transaction descriptions and account assignments.
Consult an accounting professional before changing closed periods.
Yes. You can investigate and correct errors affecting earlier reconciliations. The available options depend on the transaction, your permissions, and the QuickBooks Online workflow. Changes may affect later periods, so review the impact before proceeding.
The beginning balance may change if a previously reconciled transaction was edited, deleted, or marked as unreconciled. Review your reconciliation history, transaction register, and Audit Log to investigate.
Deleting a reconciled transaction can affect the beginning balance and later reconciliations. Before deleting anything, confirm that the entry is incorrect and consider whether a correction or reversal is more appropriate.
An adjustment should not be used simply to hide an unexplained difference. Investigate missing transactions, duplicate entries, incorrect balances, and changes to previous reconciliations first.
Correcting a reconciliation in QuickBooks Online requires careful review of bank statements, transaction records, and reconciliation history. By identifying the source of the discrepancy, correcting verified errors, and checking the results, you can maintain accurate accounting records. Regular reconciliation and careful handling of previously reconciled transactions can also help prevent recurring problems and improve the reliability of your financial reports.