Reconciling in QuickBooks means comparing the transactions in your QuickBooks account to the transactions on your bank or credit card statement for the same time period, then confirming they match. The goal is to reach a $0.00 difference between what your bank says and what QuickBooks says, so you know your books are accurate.
Think of it as balancing a checkbook, but inside your accounting software. You pull up a bank statement, tell QuickBooks the ending date and ending balance, then check off each transaction that appears in both places. When everything lines up, your account is reconciled for that period.
Why Reconciliation Matters
Reconciliation catches problems you might never notice otherwise. A duplicate entry, a missing deposit, a transaction you recorded for $250 that the bank processed as $205. These small errors compound over time, and if you don’t catch them, your financial reports will be wrong. That means your profit numbers, your tax filings, and your understanding of how much cash you actually have could all be off.
Regular reconciliation also protects against fraud. If someone makes an unauthorized charge on your business credit card or a check gets altered, reconciliation is often where you spot it. Beyond error-catching, reconciled books give you a real-time picture of your business’s net worth, and they make tax season significantly less painful because your accountant isn’t starting from messy data.
How Reconciliation Differs From Bank Feeds
If you connect your bank account to QuickBooks, transactions download automatically through what’s called a bank feed. It’s tempting to think this replaces reconciliation, but it doesn’t. Bank feeds help you categorize and record transactions as they come in. Reconciliation is a separate, more rigorous step where you verify that everything QuickBooks recorded actually matches the official bank statement for a closed period.
There is some overlap. When you open the reconciliation window, QuickBooks can automatically check off transactions that already matched through your bank feed. But if QuickBooks can’t find a match, you’ll need to review and match those transactions manually. The bank feed is a time-saver for data entry; reconciliation is the quality check.
What You Need Before You Start
To reconcile an account, you need your bank or credit card statement for the period you’re reconciling. This can be a paper statement or a PDF from your bank’s website. From that statement, you’ll need two pieces of information: the ending balance and the statement ending date. You’ll enter both into QuickBooks when you begin the reconciliation process.
Before you type anything, check that the opening balance QuickBooks shows matches the beginning balance on your statement. If this is your first time reconciling the account, the opening balance should match whatever balance the account had when you set it up in QuickBooks. If the opening balance is wrong from the start, everything downstream will be off, and you’ll need to fix it before proceeding.
The Reconciliation Process Step by Step
In QuickBooks Desktop, go to Banking, then select Reconcile. In QuickBooks Online, go to Settings, then Reconcile. Choose the account you want to reconcile from the dropdown menu.
Enter the statement ending date and ending balance from your bank statement, then continue. QuickBooks will display two lists of transactions: deposits and other credits on one side, checks and payments on the other. Your job is to go through each transaction on your bank statement and check it off in QuickBooks. As you work through the list, QuickBooks shows a running “difference” at the bottom of the screen. When that number hits $0.00, you’re done and can click Reconcile Now (in Desktop) or Finish Now (in Online).
If you find a transaction on your bank statement that isn’t in QuickBooks at all, you’ll need to add it before you can finish. If you find a transaction in QuickBooks that isn’t on the statement, leave it unchecked. It may simply be a payment or deposit that hasn’t cleared the bank yet and will show up on next month’s statement.
When Your Beginning Balance Is Wrong
One of the most common reconciliation headaches is an incorrect beginning balance. This happens when previously reconciled transactions were later voided, deleted, or edited. It can also occur if the account wasn’t set up with the right starting balance, or if you converted your file from a different version of QuickBooks.
To track down the problem, QuickBooks Desktop offers a few built-in reports. The Reconciliation Discrepancy report (under Reports, then Banking) shows transactions that were changed after being reconciled. The Previous Reconciliation report lets you compare what was reconciled in earlier periods. Between these two, you can usually identify which transaction was altered and fix it.
If the problem is that you never had a correct opening balance to begin with, you can create a journal entry dated to your first statement date. Debit the account for the correct opening balance and credit Opening Balance Equity. Then reconcile that first period using the journal entry as the only transaction. This establishes a clean starting point for all future reconciliations.
What To Do When the Difference Isn’t Zero
Sometimes you’ve checked off every transaction you can find and there’s still a small difference remaining. Before you accept it, double-check for common culprits: a transaction entered with the wrong amount, a duplicate entry, or a bank fee you forgot to record. Even a few cents off can indicate a data entry mistake that’s worth finding.
If you genuinely cannot locate the source of a discrepancy, you have two options. First, you can undo the last reconciliation and redo it. In QuickBooks Desktop, go to Banking, then Reconcile, then select Undo Last Reconciliation. Back up your company file before doing this, since undoing a reconciliation clears all the checkmarks from that period.
Second, you can let QuickBooks handle it by clicking Enter Adjustment. QuickBooks will create a journal entry that posts the difference to a special expense account called Reconciliation Discrepancies. This gets you to zero and lets you move forward, but it’s essentially sweeping a mystery amount into an expense line. For a few pennies caused by rounding, that’s fine. For larger amounts, it’s worth investigating before you take this shortcut.
How Often To Reconcile
Monthly is the standard. Each time you receive a bank or credit card statement, reconcile that account. Waiting longer means more transactions to sort through, more chances for errors to pile up, and a harder time remembering whether a questionable charge was legitimate. If you reconcile monthly and keep up with it, each session typically takes just a few minutes for a small business with moderate transaction volume. The payoff is books you can trust every time you look at them.