n-QuickBooks Online: How to Reconcile an Account (and What to Do When It Won't Balance)
Reconciling means matching every transaction in QuickBooks against your real bank or credit card statement until the two agree. Go to Transactions, then Reconcile, pick the account and statement date, enter the ending balance from your statement, and check off every transaction until the difference hits zero. Here's the full monthly process, including what to do when it doesn't balance on the first try.
The full walkthrough
1. Get your statement first. You need the exact ending balance and ending date from your actual bank or credit card statement before you start; reconciling from memory is how discrepancies happen.
2. Go to Reconcile. Select Transactions in the left navigation, then Reconcile. Choose the account you're reconciling.
3. Enter the statement details. QuickBooks shows you the beginning balance automatically, carried over from your last reconciliation. Enter the statement's ending date and ending balance.
4. Check off matching transactions. Go line by line through the list of cleared transactions and check off everything that appears on your statement: payments, deposits, fees, all of it.
5. Watch the difference. As you check things off, QuickBooks shows the running difference between your books and the statement. The goal is zero.
6. Investigate anything left over. If the difference isn't zero once everything's checked, look for a missing transaction, a duplicate, or one entered for the wrong amount, rather than forcing it to balance.
7. Finish the reconciliation. Once the difference reads zero, select Finish now. QuickBooks locks that period's reconciled status.
Where reconciling turns from routine into a time sink
Most months, this is mechanical: everything on the statement is already in QuickBooks, and checking boxes takes ten minutes. The problem shows up when it doesn't line up, a duplicate transaction from a bank feed glitch, a payment recorded twice, something a bookkeeper entered by hand that doesn't quite match what actually cleared.
Tracking down one wrong transaction in a list of hundreds is tedious even for someone who knows exactly what they're looking for. It gets worse when the mismatch traces back to an outside system, a payment processor, a POS, an e-commerce platform, that doesn't talk to QuickBooks directly, because now you're cross-checking two systems by hand instead of one.
That cross-checking is exactly the part that doesn't need a human doing it every time. If the data in both places is structured, the matching can happen automatically, flagging only the transactions that genuinely don't have a match instead of making someone review every single line.
What we've built on top of QuickBooks reconciliation
Cross-system matching before reconciliation starts
Transactions from a payment processor, POS, or e-commerce platform get matched against the bank feed automatically before anyone opens the Reconcile screen, so the only things left to check by hand are the genuine exceptions.
Mismatch alerts the day they happen
Instead of discovering a duplicate or missing entry once a month during reconciliation, a mismatch between two connected systems gets flagged the day it occurs, while it's still easy to trace back to the cause.
What keeps throwing off your reconciliation?
Those are two ways it tends to happen. If there's a specific system or a specific kind of transaction that always causes the trouble, tell us and we'll tell you if it can be caught automatically.
Reconciliation always turning into a hunt for one bad transaction?
Tell us which systems feed into your books and where the mismatches usually come from, and we'll tell you whether the matching can happen before you ever open the Reconcile screen. And if reconciliation isn't actually your biggest time sink, that's fine too; the same question applies to anything else you're doing by hand.
Let's talk