How to Reconcile a Bank Statement in QuickBooks Online

Short answer: To reconcile a bank statement in QuickBooks Online, go to Settings (the gear icon) > Reconcile, choose the account, and enter the ending balance and ending date printed on your statement. QuickBooks then lists every transaction for that period. Tick off each one that also appears on the statement until the difference at the top reads 0.00, then select Finish now.

Reconciliation is the monthly check that your books agree with the bank. It catches missing transactions, duplicates, bank fees you forgot to record, and the occasional fraudulent charge. Done every month, it takes ten minutes. Skipped for a quarter, it turns into a hunt through hundreds of lines. Here is the full process, plus the two problems that stop most people cold: a beginning balance that will not match and an ending difference that will not clear.

What you need before you start

You need the official bank statement for the account, either the PDF from online banking or the paper copy, showing the statement period, the ending balance, and every transaction in between. You also need every transaction from that period already entered in QuickBooks, whether it came in through the bank feed or a file import. If some are missing, add them first. Reconciling against an incomplete register is the number one reason the numbers never line up.

If the transactions are not in QuickBooks yet because the account is not connected or the feed only reaches back 90 days, download the statement and bring the data in first. You can turn the PDF statement into a QuickBooks-ready file in a couple of minutes, then import it before you reconcile. Reconciliation only works when the register is complete.

How to reconcile a bank account in QuickBooks Online (step by step)

1. Open Reconcile. Select Settings, the gear icon in the top right, then Reconcile under Tools. You can also reach it from Transactions > Reconcile.
2. Pick the account. Choose the bank or credit card account that matches the statement in front of you.
3. Enter the statement details. Type the ending balance and the ending date exactly as they appear on the statement. Add any bank service charge or interest earned in the fields provided so you do not have to enter them by hand later.
4. Select Start reconciling. QuickBooks shows every transaction dated on or before the ending date that has not been reconciled yet.
5. Match line by line. Compare the QuickBooks list to the statement. Tick the checkmark column for each transaction that appears on both. Many people work top to bottom through deposits first, then payments.
6. Watch the Difference. The top of the screen shows Statement ending balance minus Cleared balance. As you check off matching lines, the Difference moves toward zero.
7. Finish at zero. When the Difference reads 0.00, select Finish now. QuickBooks marks those transactions as reconciled with an R in the register and saves a reconciliation report you can reopen any time.

How do I reconcile a bank statement in QuickBooks Online?

Open Settings > Reconcile, select the account, and enter the ending balance and ending date from your statement. Check off every transaction in QuickBooks that also shows on the statement until the Difference field reads 0.00, then click Finish now. QuickBooks stamps each cleared line with an R and files a report for that period.

Why is my beginning balance wrong in QuickBooks Online?

A beginning balance that does not match your statement almost always means a previously reconciled transaction was later edited, deleted, or had its amount or date changed. Reconciliation builds each month on the last, so one altered historical line shifts the starting point for every month after it. It is rarely a new mistake. It is an old one surfacing.

When the beginning balance is off on an account you have reconciled before, QuickBooks usually shows an alert that reads "We can help you fix it." Select that link to open the Reconciliation Discrepancy Report, which lists every transaction that changed since the last successful reconciliation, along with what changed and when. Restore the original amount or date, or re-enter a deleted transaction, and the beginning balance snaps back into place.

If this is the very first reconciliation on the account, a wrong starting figure is instead an opening balance problem. Open the Chart of Accounts, select View register on the account, and find the oldest entry, which should post to Opening Balance Equity. Compare its amount and date to your bank balance on that same day and correct it if it is off.

What if there's a difference at the end of reconciliation?

A leftover difference means the transactions you cleared do not add up to the statement's ending balance. Do not force it by creating a random adjusting entry. Work the list instead. The usual culprits are a transaction on the statement that was never entered in QuickBooks, a duplicate you checked off twice, a payment entered as a deposit or the reverse, or an amount typed with transposed digits.

Recheck the count first: the number of cleared items in QuickBooks should equal the number of lines on the statement. If QuickBooks has more, you likely have a duplicate. If it has fewer, a transaction is missing and needs to be added. Small differences often trace to a fee or interest charge you skipped in the setup screen. Only after you have genuinely exhausted the search should you let QuickBooks post an adjustment, and even then, make a note of why.

How to undo a reconciliation in QuickBooks Online

If you closed a reconciliation with a forced adjustment or matched the wrong month, you can reverse it. With QuickBooks Online Accountant, open the reconciliation history, find the period, and select Undo from the Action column. Without the Accountant version, you cannot undo a whole reconciliation in one click, but you can open the account register and change individual transactions from reconciled (R) back to cleared (C) or blank by clicking the status field. Do this carefully, since editing reconciled lines is exactly what breaks future beginning balances.

Reconciling several months at once (catch-up)

Reconcile one statement period at a time, oldest first, even when you are months behind. QuickBooks reconciles chronologically, and each month's ending balance becomes the next month's beginning balance, so you cannot skip ahead. If you are catching up a full year, the slow part is usually getting all the transactions into QuickBooks, not the ticking-off. Bring in each month's statement, confirm the register is complete, then reconcile that month before moving to the next.

This is where clean source data pays off. Once every transaction sits in QuickBooks with the right date and amount, and each charge is matched to its receipt or supporting document, reconciliation becomes a quick confirmation rather than an investigation. Categorized, complete data reconciles fast. Messy imports do not.

Reconcile versus match: they are not the same

People mix these up. Matching happens in the bank feed, where QuickBooks pairs a downloaded transaction to one you already entered so it is not recorded twice. Reconciling is the separate, periodic check that your entire QuickBooks balance agrees with the bank statement for a set period. You can match transactions all month and still need to reconcile at month end. Matching keeps the feed tidy; reconciling proves the books are right.

If your feed is not matching cleanly or is missing transactions, sort that out before reconciling. Our guides on fixing a bank feed that stopped working and importing bank transactions into QuickBooks Online cover the import side. For the format QuickBooks expects, the import template guide shows the exact columns.

Frequently asked questions

Where is the Reconcile button in QuickBooks Online?

Select Settings, the gear icon in the top right corner, then choose Reconcile under the Tools column. You can also open it from Transactions > Reconcile in the left menu. Both routes land on the same screen where you pick the account and enter the statement's ending balance and date.

What is the difference between cleared and reconciled in QuickBooks?

Cleared, shown as C, means the transaction came through the bank feed or was matched but has not been through a formal reconciliation. Reconciled, shown as R, means you confirmed it against a bank statement during the Reconcile process. Only reconciled transactions count toward a completed monthly reconciliation.

Can I reconcile in QuickBooks Online without connecting my bank?

Yes. You do not need a live bank connection to reconcile. You need the transactions entered in QuickBooks and the paper or PDF statement to check them against. If the account is not connected, convert the statement to a CSV or QuickBooks file, import it, then reconcile against the statement as usual.

How often should I reconcile in QuickBooks Online?

Reconcile every account once a month, as soon as the statement closes. Monthly reconciliation catches errors and fraud while they are easy to trace and keeps your beginning balances clean. Waiting a quarter or a year turns a ten-minute task into hours of detective work across many statements.

What do I do if QuickBooks says my beginning balance changed?

Select the "We can help you fix it" link to open the Reconciliation Discrepancy Report. It lists every reconciled transaction that was later edited or deleted. Restore each one to its original amount and date, or re-enter what was removed, and the beginning balance will match your statement again.

The short version

Reconciling in QuickBooks Online is three moves: enter the statement's ending balance and date, tick off every transaction that appears on both the statement and your books, and finish when the difference hits zero. A beginning balance that will not match points to an edited historical transaction, findable through the discrepancy report. An ending difference that will not clear points to a missing, duplicated, or mistyped line, findable by comparing counts. Keep the register complete and reconcile monthly, and the whole thing stays a quick monthly confirmation instead of a quarterly ordeal.