Bank Reconciliation in QuickBooks: The Right Order to Run It (and the 3 Mistakes That Cost Most)

What bank reconciliation actually does

Reconciliation compares two records of the same money: your bank statement and your QuickBooks register. When they match to the penny, your books are accurate. When they don’t, you have a problem — duplicate entry, missing transaction, bank error, or a mis-categorised charge. Reconciliation is the single highest-value monthly bookkeeping activity because it catches errors before they compound.

The right order to reconcile

Reconcile in this order: (1) Operating bank account, (2) Credit cards, (3) Loan/line of credit, (4) Merchant accounts (Stripe, Square, PayPal), (5) Payroll-related accounts last. Why this order? Because credit card transactions often draw from the operating account, payroll uses the operating account, and merchant deposits hit the operating account. If you reconcile operating last, every fix you make has to flow downstream.

Step-by-step in QuickBooks Online

1. Go to Accounting → Reconcile.
2. Select the account to reconcile.
3. Enter the statement date and ending balance from your bank statement.
4. Check each transaction that appears on both QuickBooks and the statement.
5. The difference should equal zero at the end. If it doesn’t, find the discrepancy before finishing.
6. Click “Finish now” only when the difference is $0.

The 3 mistakes that cost most

Mistake 1 — Finishing reconciliation with a non-zero difference. QuickBooks lets you force a reconciliation by booking a “reconciliation discrepancy” entry. Never do this. The difference is hiding a real error.

Mistake 2 — Reconciling months out of order. Always reconcile chronologically. If you skip July and do August, July’s errors flow into August and compound.

Mistake 3 — Treating the reconciliation report as decorative. Save the PDF of every reconciliation. Auditors ask for them. Disputes over which transactions cleared depend on them.

How to reconcile after a QuickBooks conversion

The first reconciliation after a QuickBooks conversion is a different job from a monthly one, and treating it like a monthly one is why so many migrations look broken when they are fine. In a normal month you are proving that QuickBooks matches the bank. In the first pass after a conversion you are proving that the new file matches the old file. Those are two different tie-outs, and doing them in the wrong order turns a five-minute check into a week of hunting.

Reconcile to the legacy closing balance first, not the bank statement. Your cutover balance came from the old system, so that is the number the new file has to agree with before anything else is meaningful.

1. Before you migrate, reconcile the final period in the old system and export the reconciliation report to PDF. Once the legacy file is decommissioned you cannot regenerate it, and it is the only evidence of which items had cleared.
2. Export the list of outstanding (uncleared) items as at the cutover date from that same report. This list explains almost every difference you are about to see.
3. In QuickBooks, run a reconciliation with the statement ending date set to your cutover date and the ending balance set to the legacy closing balance. This is a tie-out, not a bank reconciliation.
4. The difference must be zero. If it is not, the data did not come across cleanly — stop and fix the file. Do not force-finish, and do not book a reconciliation discrepancy to make it close.
5. Check the opening balance equity account. A conversion that dumped an unexplained plug into it has told you something did not map.
6. Only then reconcile your first post-cutover bank statement as a normal monthly reconciliation.

The trap: cleared status often does not survive the move. Many conversion routes bring historical transactions across as uncleared even though they were reconciled years ago in the old system. If you tick those back through in the current period you will corrupt the current-period reconciliation and destroy the historical record at the same time. Reconcile them as at their original dates, or leave them and rely on the tie-out in step 3.

A non-zero difference at step 4 is almost always one of four things: outstanding items that existed at cutover and were not carried over, duplicated transactions from a partial re-import, a date-range mismatch between the two systems, or a rounding or currency difference on a converted account. Work the list from step 2 before you assume the migration failed. More of these patterns — and how to avoid them in the first place — are in common QuickBooks conversion mistakes, and the realistic timeline for the whole exercise is in how long a QuickBooks conversion takes.

Do this once, properly, at cutover, and every month afterwards is the ordinary process described above. Skip it and every future reconciliation inherits an error you can no longer date.