How to Tell Whether Your Books Are Actually Reconciled

The one test that settles it

Reconciled has a precise meaning, and it is narrower than most owners assume. For a given date, the cleared balance in QuickBooks for an account has to equal the closing balance the bank printed on the statement for that same date. Anything left over has to be explained by a transaction that has not cleared yet, like a check written on the twenty-eighth that the bank saw in the first week of the following month. If somebody tells you the books are reconciled, that is the claim they are making, and it is a claim you can check.

The good part is that you don't need anybody's cooperation to verify it. Everything below happens inside your own file, with your own login, in about the time it takes to drink a coffee.

Four checks you can run yourself

Check one: the reconciliation history

In QuickBooks, open the reconciliation history for each bank and credit card account. It lists every reconciliation, the statement date, the ending balance and who ran it. Look at the most recent entry for each account. If your business checking was reconciled through last month and the credit card stops eleven months ago, you have found the gap already, and it will be the card that causes the problem at tax time.

Check two: the balance sheet against today

Pull up the balance sheet, find the bank line, then open your banking app and compare. These two figures will differ a little, because outstanding items take a few days to clear, and that is normal. A difference of a few hundred is worth a look. A difference of several thousand means something structural, usually a duplicate feed connection or a deposit recorded twice.

Check three: Undeposited Funds

On the same balance sheet, look for Undeposited Funds. It's a holding account. A payment lands there when you record it against an invoice, and it leaves when you group it into a deposit that matches what actually hit the bank. Money passing through is normal. A balance that only ever grows means the second half never happened, and the usual consequence is that the real deposit gets entered separately as income, so the same money is counted twice and neither the bank line nor the profit and loss can be trusted.

Check four: Opening Balance Equity and anything impossible

Opening Balance Equity should be zero once the file's setup is finished. A balance sitting there is a difference somebody parked at some point and never came back to. While you're there, scan for anything that cannot be true: a bank account showing negative when it never overdrew, a loan balance that has not moved in two years, accounts receivable holding invoices from customers who paid you long ago.

What reconciliation proves, and what it leaves open

Reconciliation answers one question well: did the money move the way the bank says it moved. That is the foundation for everything else, which is why monthly bookkeeping starts there. It stops short of telling you the entries are coded correctly.

A file can reconcile perfectly with every fuel purchase sitting in office supplies, an owner draw recorded as a business expense, or sales tax collected for NCDOR mixed into general income. So after the four checks, open your profit and loss for the last quarter and read it as a person rather than an accountant. If a category looks far too large or suspiciously round, ask what's in it. Owners catch these faster than anybody else does, because you remember what you actually spent money on in March.

What to ask whoever does your books

If something looks wrong, the useful request is specific. Ask for the reconciliation report for a named month and the statement it was reconciled against. Those two documents sit side by side and either agree or they don't, and producing them takes a couple of minutes when the work has been done.

It's a reasonable question and a good bookkeeper will be pleased you asked, because it's easier to explain a discrepancy in March than to untangle it in January when a filing depends on it. If your file came to you from a previous arrangement, say so when you ask. A gap can be older than whoever is working on the file now, and framing it that way keeps the conversation about the books instead of about blame.

If the checks come back clean

Then trust your numbers and use them. Reconciled books mean the profit and loss reflects real money, the balance sheet reflects what you own and owe, and a lender or a tax preparer can be handed a report without a covering explanation. That is the whole point of doing any of it. Run the same four checks once a quarter and they get quicker each time, because you learn where your own file tends to drift. Ten minutes every three months is how you stay the person who knows whether the numbers are right, whether you run a shop in Greenville, Winterville or one of the other towns in Pitt County.