How to Reconcile a Bank Statement in QuickBooks: Step-by-Step Guide for Small Businesses
If you run a business in New York, Pennsylvania, New Jersey or anywhere nearby, the numbers on your profit and loss report are only as good as your last reconciliation. An unreconciled account can hide duplicate entries, missing deposits and payments that never cleared. This guide walks through reconciling a bank statement in QuickBooks Online, what to do when the numbers will not match, and how reconciliation connects to knowing your real profit or loss.
What is bank reconciliation and why does it matter?
Bank reconciliation is the process of comparing the transactions in your books with the transactions on your bank or credit card statement, and confirming that the ending balances agree. Anything in your books that is not on the statement (an outstanding check, a deposit in transit) or on the statement but not in your books (a bank fee, an interest credit) gets explained or corrected.
It matters for three reasons:
- Accuracy: it catches duplicates, wrong amounts, missing transactions and possible fraud before they distort your reports.
- Real profit and loss: if income or expenses are missing, your profit figure is wrong, so pricing and hiring decisions rest on bad data.
- Tax readiness: your CPA needs reconciled books to prepare a return without guessing, which usually lowers preparation time and the risk of errors.
What you need before you start
- The bank or credit card statement for the period, with the statement ending date and ending balance.
- The account connected or entered in QuickBooks Online, with all transactions for the period categorized.
- The prior period already reconciled. If earlier months were skipped, start with the oldest unreconciled month.
How to reconcile in QuickBooks Online, step by step
The menu names can shift slightly as QuickBooks updates its layout, but the workflow is the same.
- Open the Reconcile page (from the gear icon, or the Accounting menu depending on your version).
- Choose the account you are reconciling, such as your business checking account.
- Enter the statement ending date and the ending balance exactly as printed on the statement.
- Select Start reconciling. QuickBooks lists the payments and deposits recorded in your books for the period.
- Tick each transaction that also appears on the statement. Compare the amount and date, not just the payee name.
- Watch the Difference figure at the top. When every matching item is ticked, it should read $0.00.
- Select Finish now. Save or print the reconciliation report for your records.
Why your difference will not reach $0.00 (and how to fix it)
This is where most owners get stuck. Work through the usual causes in this order:
| Symptom | Likely cause | Fix |
|---|---|---|
| Difference equals one transaction amount | A transaction is on the statement but not in the books, or the reverse | Add the missing entry, or delete the duplicate |
| Difference is a small round amount | Bank fee, interest income or a card processing fee never recorded | Record the fee or interest as a transaction |
| Difference is exactly double a transaction | That transaction was ticked but should not have been, or it was entered twice | Untick it and search for a duplicate |
| Difference is a transposed number (for example 45 vs 54) | Typing error when entering the amount | Correct the amount to match the statement |
| Opening balance is off | A previously reconciled transaction was edited or deleted | Review the reconciliation discrepancy report and undo the change |
If the opening balance does not agree with the prior statement, the problem is in an earlier period. Fix that first, because errors carry forward.
From reconciled books to your actual profit or loss
Once every account is reconciled, the Profit and Loss report becomes reliable. Before you trust it, check three things:
- Nothing sits in Uncategorized: uncategorized income or expense lines mean profit is misstated.
- Personal and business are separated: owner draws and personal spending should not be booked as business expenses.
- Accrual timing is understood: if you invoice customers or receive bills, unpaid items affect profit even though no cash has moved.
Profit is not the same as cash in the bank. A business can show a profit and still run short of cash because of unpaid invoices, inventory, loan payments or owner draws. Reconciled books plus an accounts receivable and payable review show both numbers.
How reconciliation connects to tax filing
Your tax return starts from your books. Reconciled statements give your CPA supportable totals for income and deductible expenses, and they make it much easier to respond if a taxing authority ever asks questions. Businesses in New York, Pennsylvania and New Jersey also have state-level filings, including sales tax where applicable, and those depend on the same records. Rules and deadlines change, so confirm current requirements with a licensed CPA in your state.
How often should you reconcile?
Monthly is the standard. Higher-volume businesses such as restaurants, retail and trucking often reconcile weekly or use daily bank feeds with a monthly formal close. Waiting until tax season means one large, painful cleanup instead of twelve small checks.
When to hand it off
If you are several months behind, the difference never reaches zero, or you simply do not have the hours, a bookkeeping team can catch up and take over. SolveLedger's CA, CPA and ACCA-qualified team reconciles your accounts, cleans up backlog as a fixed-scope project, and delivers a monthly close with a profit and loss you can rely on, so your CPA receives tax-ready books.
Hire your own remote bookkeeper for $2,000 a month
Experienced bookkeepers from India or the Philippines, up to 70% cheaper than in-house. Or try us first: 3 months of bank and credit card statements reconciled for $89.
Book a Free Call → Try for $89Frequently asked questions
How do I reconcile a bank statement in QuickBooks Online?
Open the Reconcile page, pick the account, enter the statement ending date and ending balance, tick each transaction that matches the statement, and finish when the Difference shows $0.00.
What if my bank reconciliation does not balance?
Check for missing bank fees or interest, duplicate transactions, transposed digits and edited past transactions. If the opening balance is wrong, fix the earlier period first.
How often should a small business reconcile its bank accounts?
At least monthly. Busy businesses often review weekly and complete the formal reconciliation at month end.
Can someone reconcile my books for me if I am months behind?
Yes. A bookkeeping firm can perform catch-up and cleanup work, reconcile each missing month, and move you onto a regular monthly close.
Does reconciling my books tell me if I am making a profit?
It makes your profit and loss report reliable, but profit and cash are different. You also need to review receivables, payables and owner draws.
This article is general educational information, not tax, legal or accounting advice for your specific situation. Rules and deadlines change and vary by state; confirm details with a licensed professional before acting.