And why bookkeeping cleanup wasn’t the mountain it appeared to be.
Note: This case study is a composite drawn from multiple Bonita Springs client scenarios. Details have been blended and anonymized to protect confidentiality while preserving the real patterns and lessons.
Most bookkeeping cleanup projects don’t start with a tidy list of issues. They start with a feeling — usually something like, “The numbers don’t look right, but I can’t tell what’s wrong.” That was the situation for a Bonita Springs business that reached out earlier this month.
Their reports weren’t holding their shape.
Balances shifted from week to week.
And the dashboard kept showing more than $40,000 in unpaid bills.
From their perspective, it looked like a major financial problem.
From mine, it looked like a file that needed a steady cleanup path.
The Situation
This business had been growing quickly, and their bookkeeping hadn’t kept pace. Bills were entered, payments were made, but the connections between them weren’t always clear. The owner kept seeing the same large A/P balance every time they logged in, and it shaped every decision they made.
They delayed equipment purchases.
They held off on hiring.
They carried the weight of a liability that didn’t feel like it was shrinking.
They weren’t sure if the number was real — but they didn’t feel confident enough in the file to challenge it.
The Challenge
The symptoms were familiar:
- Reports changed depending on the date range
- Vendor balances didn’t match what the owner believed they owed
- Payments appeared in the bank feed but not in the subledger
- The P&L shifted every time they opened it
From the outside, it looked like everything was broken.
But the real issue wasn’t the volume of problems — it was the order in which they were being approached.
Cleanup work becomes overwhelming when everything is touched at once.
It becomes manageable when the file is approached in a steady sequence.
The Approach
We followed the same operator‑grade cleanup path I use in every project, but each step revealed something important about how the file had been behaving.
1. Start with the Balance Sheet
This is always the first place the structure reveals itself — not because it shows every detail, but because it reflects the impact of everything that isn’t lining up underneath.
The Balance Sheet doesn’t display the Unpaid Bills Report or vendor‑level balances, but it absorbs the consequences when those supporting reports drift out of alignment. That’s exactly what we saw here: the A/P total on the Balance Sheet didn’t make sense once we compared it to the activity in the bank, the vendor history, and the timing of payments.
The deeper signals showed up quickly:
- The A/P balance didn’t reconcile with what the Unpaid Bills Report suggested the business owed
- Vendor balances didn’t match the pattern of real‑world payments
- Credit card and loan accounts hadn’t been reconciled, which distorted liabilities
- Deposits in Undeposited Funds didn’t match customer activity
- Customer invoices weren’t matched to bank deposits, causing A/R and cash to drift apart
This is the kind of misalignment you only see when you understand how the Balance Sheet interacts with the supporting reports. The Balance Sheet doesn’t tell you why something is off — but it tells you where to look.
Once we saw these signals, the path forward became clear.
2. Reconcile the Accounts
Reconciliation isn’t just about the bank accounts.
It includes:
- checking accounts
- savings accounts
- credit cards
- lines of credit
- loan accounts
- merchant processors
- any account where money moves
Once every account was reconciled through the current period, the file stopped shifting.
The numbers finally had a place to land, and the “moving target” effect disappeared.
This is the moment when cleanup work becomes calmer — when the file stops rewriting itself.
3. Clean A/R and A/P
This is where the real story surfaced.
In QBO terms, the Unpaid Bills Report showed more than $40,000 in open vendor balances. But when we traced the activity, we found:
- payments recorded in the bank feed
- deposits sitting in Undeposited Funds
- bill payments entered as expenses instead of linked transactions
- vendor credits not applied
- deposits unmatched to customer invoices
The system wasn’t wrong — it was incomplete.
The links were missing.
Once the bills, payments, and credits were connected properly, the A/P balance dropped to a number that reflected reality.
4. Review the P&L
Only after the structure was stable did the P&L start to make sense.
And even then, it took several passes.
Each pass surfaced something different:
- misclassified expenses
- duplicated vendor payments
- income recorded to the wrong products/services
- deposits that needed to be matched to open invoices
- transactions sitting in Uncategorized Income and Uncategorized Expense
With each pass, the picture sharpened.
The P&L became a reflection of the business instead of a collection of guesses.
5. Final Month‑by‑Month Check
This is the part most owners never see — the quiet, methodical verification that ties the entire file together.
Month by month, we confirmed:
- beginning balances matched the prior month
- reconciliations held
- subledgers aligned with the Balance Sheet
- no new duplicates surfaced
- no transactions were orphaned
- no accounts carried unexplained swings
This is where the file moves from “cleaned up” to structurally sound.
It’s the difference between a quick fix and a stable foundation.
The Outcome
Once the structure was restored, the picture changed.
The $40,000 in “unpaid bills” wasn’t a real liability.
It was a series of unlinked transactions.
The true amount owed was less than half of what the dashboard had been showing.
The owner didn’t need to delay purchases.
They didn’t need to hold off on hiring.
They didn’t need to carry the stress of a number that wasn’t telling the truth.
The mountain wasn’t a mountain.
It was a missing connection.
The Insight
This is the quiet reality of bookkeeping cleanup in growing Bonita Springs businesses:
The work feels big when the reports don’t feel trustworthy.
But once you move through the file in the right order, the size of the problem shrinks.
Cleanup isn’t about fixing everything everywhere.
It’s about restoring the structure that holds everything in place.
When the structure returns, the numbers settle.
And when the numbers settle, decision‑making becomes lighter.
In Conclusion
This week’s theme is simple: Bookkeeping cleanup isn’t the mountain it appears to be.
The Bonita Springs business in this case study didn’t need a rebuild — they needed a path.
Once the path was followed, the file stabilized, the reports held their shape, and the owner could finally trust what they were seeing.
Cleanup work is never about volume.
It’s about sequence.
For the full operator‑grade sequence, download The Bookkeeping Cleanup Diagnostic Guide in Prime Entry Bookkeeping’s Resource Library. It contains a clear, structured walkthrough of the full diagnostic path — the same operator‑grade process I use to stabilize every cleanup file. You’ll see how the Balance Sheet, reconciliations, subledgers, and month‑by‑month checks fit together to bring the numbers back to solid ground.
👉 You can download it here: The Bookkeeping Cleanup Diagnostic Guide
Next Week’s Theme: Why Reconciliation is the Most Misunderstood Part of Bookkeeping
If your books feel unsteady and you’d like to talk through what you’re seeing, you can schedule a Clarity Call with Prime Entry Bookkeeping.
It’s a calm, no‑judgment conversation designed to help you understand what’s happening in your books and what a grounded next step might look like.
© 2026 Prime Entry Bookkeeping. All rights reserved. This article may be shared with attribution, but it may not be reproduced, republished, or adapted without written permission. “Clarity Call” is a proprietary term of Prime Entry Bookkeeping.