Skip to content

What Happens When You’ve Never Reconciled Your Books? (A Real Case)

  • by
Bookkeeper working on tax documents and financial papers in New Braunfels, TX.
Case Study

What Happens When You’ve Never Reconciled Your Books? (A Real Case)

When a contractor walks into our office and says “I think my books are a little off,” I have learned to ask one question first: when was the last time you reconciled?

If the answer is “a couple months ago,” we are in the realm of small problems.

If the answer is “I don’t really know what that means,” we are in the realm of this story.

The Scope of What We Walked Into

A contractor came to us earlier this year with twelve months of unreconciled books. Their American Express card had never been imported into QuickBooks at all. Their payroll had been entered but not verified against the W-3. They could not tell me their year-to-date profit within $20,000 either direction.

This is not a careless business owner. This is a person running a real company, generating real revenue, paying real employees and contractors. They had simply never been shown what their books were supposed to do.

The cleanup was a full-year scope: reconcile twelve months of bank and credit card activity, import and categorize an entire year of credit card spend that had never been in the system, verify payroll against quarterly and annual filings, and produce a clean set of books their tax preparer could actually work from.

It took one focused afternoon.

What We Found

Three things stood out, and any one of them would have been a serious year-end problem on its own.

$144,000 of payroll needed to be reclassified. The payroll had been entered into QuickBooks, but the categories were wrong. Some payroll was sitting in Contractor Expense. Some was in Owner’s Draw. None of it tied out to the actual W-3 filed with the IRS. We rebuilt the payroll posting from scratch and reconciled it line by line against the W-3 totals.

$14,304 of customer payments were sitting unapplied. This is more common than most owners realize. A customer pays an invoice. The payment lands in QuickBooks. Nobody matches the payment to the invoice. The result: revenue gets understated, accounts receivable looks artificially high, and the bank balance does not match the books. We resolved every unapplied payment through payment matching, invoice creation, and where necessary, journal entries.

$24,000 of sales tax had been collected and never remitted. This is the kind of finding that turns a cleanup into an urgent conversation. The client had been collecting sales tax on invoices, but the liability was not being tracked in QuickBooks. Twenty-four thousand dollars was sitting in the operating account that was not actually theirs. It was the state’s. We surfaced it, tracked it through the proper liability account, and walked the client through catching the filings up.

The takeaway: None of this is about negligence. It’s about the gap between “having QuickBooks” and “having books.” Most small business owners think the software is the answer. It isn’t. QuickBooks is a tool. Without someone running it correctly, it produces a record of activity that looks like books — but isn’t.

Why This Happens to Good Business Owners

A real set of books has three properties:

  1. Every transaction is in the correct category.
  2. Every account is reconciled to its statement.
  3. The reports tie out to other systems: payroll filings, sales tax filings, bank balances.

If any one of those is missing, the books do not tell the truth. And business owners make decisions based on books that do not tell the truth. That is the actual cost of “I’ll deal with it later.”

What a Real Cleanup Actually Looks Like

When we take on a full-year cleanup, the work follows a sequence. There is no shortcut.

We start with the bank and credit card statements. Every account, every month, reconciled to the statement balance. If transactions are missing, we import them. If they are miscategorized, we recategorize them. The reconciliation difference must be exactly zero before we move on.

Then we verify payroll. The W-2 totals, the W-3 summary, the payroll tax deposits, and the entries in QuickBooks all have to match. When they don’t, we trace the difference and fix it at the source.

Then we look at receivables and payables. Unapplied payments get matched. Stale invoices get reviewed for collectibility. Bills get matched to vendor accounts.

By the time we deliver, the client has three things: a clean set of books that ties out to every filing, a CPA cover note that explains the changes we made, and a set of work paper PDFs that document the entire cleanup.

What Changed for the Client

The contractor walked out of that engagement with a clean year, a defensible audit trail, and the first set of books they had ever owned that actually told them what their business was doing.

The $24K of sales tax got caught up. The $14K of unapplied cash became recognized revenue. The $144K of payroll reclass meant their tax return reflected what actually happened.

They also, for the first time, knew their real YTD profit number. Not a guess. The actual number.

That is what a real set of books does.

If Your Books Have Drifted

Most cleanups we run land somewhere in this story. A contractor, a retailer, a remote services team, a professional practice. The industries change. The pattern doesn’t.

If you have not reconciled in months, if you have a card that has never been in QuickBooks, if your books look like a record of activity instead of a tool you can run a business with — the fix is the same one we ran here. It takes less time than you think. And it costs less than the surprise it prevents.

We do this for our clients. We can do it for yours.

Jimmie Needles

Jimmie Needles
Founder & Lead Advisor, J2 Bookkeeping

Jimmie has been in accounting and bookkeeping since 2007 — remote-first from day one, before virtual was a buzzword. He holds an MBA in Accounting & Finance, is an Intuit Elite ProAdvisor, and has helped 50+ businesses get their books to a place where they can actually make decisions. He founded J2 in New Braunfels, TX in 2019.

Ready to Fix This?
Book a Free 20-Minute Call
No pitch. No pressure. Just a look at where your books actually stand.



Book Your Free Call



Or grab the free Year-End Bookkeeping Checklist →