QuickBooks Beginning Balance Doesn't Match Your Bank Statement

When you start a new reconciliation in QuickBooks Desktop and the beginning balance doesn’t match your bank statement, a previously reconciled transaction has been altered. QuickBooks calculates the beginning balance for the current month by adding up all transactions marked as reconciled from prior months. If that number suddenly changes, it means a past transaction was modified, deleted, or unreconciled after the fact.

Find the Changed Transaction

You do not have to hunt through your register manually. QuickBooks provides a specific report to identify exactly what changed.

1. Go to Reports > Banking > Reconciliation Discrepancy.
2. Select the affected bank account and the date range covering your last few reconciliations.
3. Review the report for any non-zero amounts.

This report will show you the exact date a transaction was modified, deleted, or marked as unreconciled. You will typically see the exact dollar amount of your beginning balance discrepancy listed here.

Fix the Discrepancy

The cleanest repair is to restore the transaction to its original reconciled state. If a transaction was accidentally unreconciled—such as a single line item within a larger payroll journal entry—simply go into the bank register and click the checkmark column to mark that specific transaction as reconciled (“R”) again.

If the transaction was deleted entirely, you must recreate it using the original date and amount, then manually mark it as reconciled in the register. This preserves your reconciliation history without forcing an artificial adjustment into the current month.

When to Use a Reconciliation Adjustment

If the original transaction cannot be recreated, or the discrepancy represents a genuine bookkeeping error that needs to be cleared, you can enter a one-time reconciliation adjustment.

During the reconciliation process, QuickBooks will prompt you with a window stating that you are out of balance. You can choose to have QuickBooks automatically enter an adjustment transaction to force the reconciliation to balance. If you do this, add a clear memo to the transaction explaining exactly why the adjustment was made (e.g., “Adjustment for deleted $4.61 Paychex ACH debit from 6/18”).

Preventing Future Mismatches

The most common cause of this issue is editing a transaction after the month has been closed. This frequently happens when bookkeepers correct payroll journal entries. If you need to fix how a deduction or withdrawal is recorded after the fact, make the correction, but ensure you do not uncheck the reconciled status of the original transaction in the bank register.