How to Reconcile a Bank Statement in QuickBooks Online
Reconciling checks your QuickBooks records against your actual bank statement until the two agree. It is the control that catches missing transactions, duplicates and errors before they reach your tax return. This guide walks through reconciling a bank statement in QuickBooks Online step by step, where to find the reconciliation report, and exactly what to check when the balance refuses to match.
What reconciling actually means
Reconciling is the process of checking your QuickBooks records against your actual bank statement, line by line, until the two agree. When they match, you know your books reflect reality. When they do not, you have found either a missing transaction, a duplicate, or an error, which is precisely the point of doing it.
It is the single most valuable monthly control a small business has. Unreconciled books look fine right up until you rely on them for a tax return, a loan application, or a decision about whether you can afford to hire.
Before you start
Have your bank statement for the period in front of you, either the PDF or the online version. You need two numbers from it: the closing balance and the statement end date.
Then make sure everything for that period is actually in QuickBooks. If transactions are still sitting in the For Review tab, categorise and accept them first, or they will not appear in the reconciliation.
Reconcile one account at a time, in date order, starting from the oldest unreconciled period. Skipping around is how people end up with balances that will not resolve.
How to reconcile a bank statement in QuickBooks Online
Step 1. Go to Settings (the gear icon) → Reconcile, or navigate to Transactions and choose Reconcile.
Step 2. Select the bank or credit card account you are reconciling.
Step 3. Enter the ending balance and the ending date exactly as they appear on your statement. QuickBooks will fill in the beginning balance from your last reconciliation, do not change it.
Step 4. Select Start reconciling. You will see your QuickBooks transactions listed alongside a running difference.
Step 5. Work down your bank statement and tick off each transaction that also appears in QuickBooks. The difference figure at the top will fall as you go.
Step 6. When the difference reaches zero, select Finish now. QuickBooks locks the period and generates a reconciliation report.
Do not force a reconciliation to close by adding an adjusting entry to make the difference disappear. That hides the underlying error and it will resurface, usually at year end.
The reconciliation report, and why you should keep it
Once you finish, QuickBooks produces a reconciliation report showing the statement balance, the cleared transactions, and anything still outstanding. You can find past reports under Settings → Reconcile → History by account.
Save or export each one. When an accountant prepares your year-end accounts, or a lender asks how your figures were verified, the reconciliation reports are the evidence that your books were checked against real bank records every month.
When the balance will not match
A difference that will not clear almost always comes down to one of five things. Work through them in this order.
A missing transaction. Something on the statement was never entered in QuickBooks. Add it.
A duplicate. The same transaction was entered manually and also imported through the feed. Delete one.
A wrong amount. A typo, or a payment recorded at the invoice amount rather than the amount actually received. Open the transaction and correct it.
Wrong date. A transaction dated outside the statement period will not appear where you expect it. Check the days either side of your start and end dates.
A changed prior reconciliation. If your opening balance is wrong, someone edited or deleted a transaction that was previously reconciled. QuickBooks flags this, and the reconciliation history will show you which period broke.
Reconciling credit cards
Credit card accounts reconcile exactly the same way, but the signs run in reverse: purchases increase what you owe, and payments reduce it. Use the closing balance from the credit card statement, not the amount you paid.
Reconcile credit cards monthly alongside your bank accounts. They are where undocumented spending accumulates fastest, and where duplicated expense claims tend to surface.
QuickBooks Desktop
In Desktop the process is the same in substance. Go to Banking → Reconcile, choose the account, enter the statement date and ending balance, tick off cleared transactions, and finish when the difference is zero.
Desktop offers a Discrepancy Report which is genuinely useful, it lists transactions that were altered after a previous reconciliation, which is the most common reason an opening balance stops matching.
How often, and who should do it
Monthly, without exception, as soon as the statement is available. Reconciling twelve months at once in March is how small discrepancies become untraceable.
For most owners this is 30 to 60 minutes per account per month once transactions are already categorised. If your accounts have not been reconciled in months, or the balances have stopped matching and you cannot find why, that is usually the point to bring in a bookkeeper. Untangling a broken reconciliation history takes experience, and doing it wrong compounds the problem.
Never Chase a Reconciliation Again
Our Ex-PwC Chartered Accountants reconcile your accounts every month and tell you what the numbers mean.
Only have PDF statements? Our free bank statement converter turns them into a QuickBooks-ready CSV in seconds — it runs in your browser, so nothing is uploaded.
Talk to a BookkeeperFrequently Asked Questions
Go to Settings, then Reconcile, choose your account, and enter the ending balance and ending date from your bank statement. Tick off each transaction that appears on both the statement and in QuickBooks until the difference reads zero, then select Finish now.
Check for five things in order: a transaction on the statement that was never entered, a duplicate entered twice, an incorrect amount, a transaction dated outside the statement period, and a previously reconciled transaction that was later edited or deleted. Do not post an adjusting entry to force the difference to zero, it hides the real error.
Go to Settings, then Reconcile, then History by account. That lists every completed reconciliation for the account, and you can open or export the report for any period. Keep these, they are the evidence your books were checked against actual bank records.
Monthly, as soon as each statement is available. Reconciling regularly keeps discrepancies small and traceable, whereas reconciling a whole year at once often makes differences impossible to find.
Yes, and you should. The process is identical, but purchases increase the balance owed and payments reduce it. Use the closing balance from the credit card statement rather than the payment amount.
Categorising decides which account a transaction belongs to, such as rent or software. Reconciling verifies that your records match the bank's records. Both matter, but only reconciliation proves nothing is missing or duplicated.