Reconciling an account in QuickBooks Online is the single most important monthly habit a small business owner can build — and the one most commonly skipped. If your books show a balance that doesn't match your statement, or you've never reconciled since setup, this guide walks you through it exactly.
As an Advanced QuickBooks ProAdvisor based in New York City with 20+ years working exclusively with QuickBooks, I've cleaned up hundreds of business files where skipped reconciliations produced books that couldn't be trusted for tax filing, financing, or basic decisions. Reconciliation is how you prevent that entirely.
Reconciliation is the process of matching every transaction recorded in QuickBooks Online to a corresponding transaction on your official bank or credit card statement. When every item lines up and the difference reads $0.00, your books are reconciled for that month.
Here's why this matters in practice: QuickBooks pulls transactions from multiple sources simultaneously — manual entries, Bank Feed imports, vendor bill payments, invoices, payroll runs. Each is an entry point for errors. A Bank Feed import can duplicate a transaction. A manual entry can be entered twice. A payment can be recorded for the wrong amount. None of these errors are visible until you sit down and compare QuickBooks line by line against your statement — which is exactly what reconciliation does.
For a New York City small business owner, where transaction volume is high and the cost of a CPA-led cleanup is significant, monthly reconciliation is the cheapest form of bookkeeping insurance available.
Before opening the reconciliation screen in QuickBooks Online, have the following ready:
Reconcile one month at a time, starting with the oldest unreconciled month. If you've never reconciled, start with the month your QuickBooks file begins. Always use each statement's actual closing date — never today's date. Using today's date pulls in transactions that belong to future periods and makes a clean $0.00 balance nearly impossible to reach.
In QuickBooks Online, click Accounting in the left sidebar, then select Reconcile. Use the desktop or browser version for this — the mobile app works but the interface is significantly harder to navigate for reconciliation.
Choose the account you want to reconcile from the dropdown at the top of the screen — your checking account, savings account, or a specific credit card. Reconcile each account separately. Start with your primary operating checking account.
You'll see two fields:
QuickBooks will also display a beginning balance. This should match the ending balance from your prior reconciliation. If it doesn't, you have a discrepancy carried over from a previous period — flag it before proceeding, because it will follow you into every future reconciliation until it's corrected. Click Start reconciling.
QuickBooks displays two columns: deposits and credits on one side, payments and checks on the other. Work through your bank statement line by line and check off each transaction in QuickBooks that appears on the statement. As you go, watch the Difference field in the upper right — your target is $0.00.
Two rules to follow without exception:
If the Difference field isn't $0.00 after working through the full statement, something needs to be found and fixed. The most common causes:
Do not click "Finish Now" with a non-zero difference. QuickBooks will post an automatic adjusting entry that hides the error rather than fixing it, and it compounds into every reconciliation that follows.
When the Difference reads $0.00, click Finish now. QuickBooks marks every matched transaction with an "R" in the reconciliation status column and generates a Reconciliation Report. Export it as a PDF and file it alongside that month's bank statement. Your CPA will want it at tax time.
Every account, every month, within the first 10 business days of the following month. That cadence catches errors while they're still recent and traceable. A reconciliation done 45 days after month-end is harder — transactions are older, context is harder to reconstruct, and errors have had more time to compound.
Credit card accounts: Reconcile monthly against your credit card statement, not against individual card transactions. The statement is the authoritative record.
Payment processors (Stripe, PayPal, Square): Treat each processor as its own account in QuickBooks and reconcile it separately against the processor's monthly settlement statement — not against your bank account, where the deposits arrive as net figures that don't match individual transactions.
Multiple bank accounts: Each account gets its own monthly reconciliation. There are no shortcuts here — a business checking account and a business savings account are two separate reconciliations even if they appear on the same PDF statement from your bank.
Using "Finish Now" with a remaining balance. QuickBooks posts an automatic adjusting entry that masks the error instead of fixing it. That entry then distorts your beginning balance for every reconciliation that follows. Never do this unless your CPA has specifically directed it and explained why.
Reconciling to today's date instead of the statement date. This pulls in transactions that belong to the next period and makes a clean $0.00 balance nearly impossible to reach. Always use the statement's actual closing date.
Editing a previously reconciled transaction. Once a transaction carries an "R" status, editing or deleting it breaks the beginning balance for all future reconciliations. QuickBooks will flag this the next time you open the reconciliation screen. If a reconciled transaction needs a correction, there is a right process — ask your bookkeeper or ProAdvisor rather than editing it directly.
Catching up multiple months with a single wide date range. Reconciling January through June by entering June 30 as the ending date doesn't work accurately — transactions from different periods get mixed together and the math doesn't close cleanly. Month by month is the only reliable approach.
Trusting the Bank Feed without reviewing it. The Bank Feed is a data import tool, not a reconciliation. Accepting auto-categorized transactions without matching them to your statement is how duplicate entries and missing transactions go undetected for months.
If reconciliation has never been done, or hasn't been done in more than 90 days, the most efficient path is a formal QuickBooks cleanup — a structured process of going back to the beginning, reconciling month by month, and correcting errors along the way. It is more involved than a single session, and it almost always uncovers transactions that were entered incorrectly, duplicated, or missing entirely.
As an Advanced QuickBooks ProAdvisor in New York City, this is one of the most common engagements I take on. Business owners who have been running QuickBooks for a year or two without ever reconciling are often surprised at what surfaces — and equally surprised at how clean and usable their books are once the work is done.
The longer reconciliation is deferred, the more it costs to fix. Every month of unreconciled transactions is another month of compounding errors that your CPA has to untangle at year-end — at your expense.
If you're staring at a difference that won't close, months of unreconciled statements, or a beginning balance that's off — that's a cleanup project, not a 15-minute fix.
Every inquiry to Stilz Bookkeeping gets a personal reply the same business day. Based in New York City, 100% US-based, serving small business owners and founders who need QuickBooks done right.
Schedule a free consultation and describe what you're seeing. I'll tell you honestly what it will take to fix it.
