Old Balances, Stale Rules, and the Junk That Builds Up in Your Books

TL;DR: The strange balances on an old balance sheet come from a handful of sources: receivables and payables that were never cleared, an opening balance equity account that was never resolved, reconciliation adjustments that hid a difference instead of explaining it, duplicates from overlapping imports, and bank rules that quietly went wrong. Each one has a source transaction. Find it, decide it, and write down what you couldn't. Prosper keeps every entry attached to its evidence so old items don't become mysteries. TidyMonth scopes the cleanup before you pay and handles the monthly work so the junk stops accumulating.

The balance sheet has a line called "opening balance equity" with $14,300 in it. Accounts receivable shows $9,000 owed by clients you haven't worked with since 2023. There's an $811 balance in "reconciliation discrepancies." And a category called "uncategorized expense" that hasn't been empty in two years.

Nobody knows what any of it is. That's the actual problem. Not the numbers, but the fact that the numbers have no story behind them.

This is what makes an annual cleanup expensive. Working bookkeepers describing the books they inherit list the same things every time: duplicate bank feeds, uncategorized transfers, negative receivables and payables, opening balance equity, forced reconciliations, stale balances, unexplained journal entries. None of it is hard individually. All of it together, with no record of why, is a project.

Where the junk comes from

Stale receivables and payables. Accounts receivable is money clients owe you. Accounts payable is money you owe vendors. Both accumulate ghosts. An invoice that was paid but never marked paid stays in receivables forever. A bill that was entered and then paid directly from the bank feed, without being marked paid, stays in payables forever. Negative balances in either are usually a payment recorded without the invoice or bill it belongs to. See The Client Paid. Why Does the Invoice Still Show Open?

Opening balance equity. When you set up an account in your books and give it a starting balance, some software puts the other side of that entry in a holding account called opening balance equity. It's meant to be cleared once the real history is entered and reconciled. Most people never clear it. Years later it's a number with no explanation.

Forced reconciliations. When the books and the statement don't agree and the difference gets pushed into an adjustment so the reconciliation can be marked complete. The account reconciles. The error is still there, now hidden. A reconciliation discrepancy account with a balance is the tell.

Duplicates from overlapping imports. A CSV imported for a period the bank feed already covered. A feed disconnected and reconnected with an overlap. Every transaction in the window, twice. See How Income Gets Counted Twice

Stale bank rules. A rule that was right when it was written and stopped being right when a vendor changed its description, a card payment got a new label, or a transfer started matching an income rule. Rules don't announce when they go wrong. They just apply the wrong category every month until someone looks. See Money Moved Between Your Own Accounts

Unexplained journal entries. Manual entries, often from a previous bookkeeper or a year-end adjustment, with no memo. They may be right. Nobody can tell.

The uncategorized bucket. Everything that was entered but never decided.

How to clean it up in any bookkeeping software

The principle for all of it: every balance came from transactions. Find the transactions, decide each one, and write down what you can't decide. Don't adjust a balance to a number that looks right. That's how the junk got there.

Step 1: List every balance you can't explain. Go through the balance sheet line by line. Anything you can't describe in one sentence goes on the list. Then look at the reconciliation discrepancy account, the uncategorized accounts, and any equity account you didn't create on purpose.

Step 2: Stale receivables. Run the receivables aging report. For each old invoice, check the bank for the payment. Found it: apply the payment. Never paid and never will be: that's a write-off, and how to record it is your CPA's call. Negative balance: find the payment that has no invoice and either create the invoice it belongs to or reclassify it.

Step 3: Stale payables. Same process from the other side. For each old bill, check whether it was paid from the bank feed without being marked paid. Match the payment to the bill. Bills that were never real go to the open list for your CPA.

Step 4: Opening balance equity. Find the entry that created it. Usually it's the starting balance of a bank or card account. Reconcile that account back to the statement as of the start date. If the starting balance was right, the offset belongs somewhere else, most often in retained earnings or owner's equity. Which one is your CPA's decision. Don't zero it out with a guess.

Step 5: Reconciliation discrepancies. Each entry in that account is a difference someone didn't chase. Open each one. The date tells you which reconciliation. Go back to that month, find the missing or duplicated transaction that caused the difference, fix it, and remove the adjustment.

Step 6: Duplicates. Sort by amount and date. Same amount, same date, same description is a duplicate. Delete one of each pair. Check the transaction count for the month against the statement afterward.

Step 7: Bank rules. Open every rule. For each, ask whether it's still true. Delete or fix the ones that aren't. Then look at what those rules applied over the last year and recategorize what they got wrong.

Step 8: Journal entries. For each one without a memo, find out who made it and why. Previous bookkeeper, prior CPA, year-end adjustment. If nobody knows, it goes on the open list. Don't delete an entry you don't understand. It may be the thing that made a prior year's return correct.

Step 9: Write the open list. Everything you couldn't resolve, with what you know. This goes to your CPA. Some of these balances will need their decision, not yours.

Illustrative example. A design agency's balance sheet carried $14,300 in opening balance equity, $9,000 in receivables older than a year, and $811 in reconciliation discrepancies. The opening balance equity traced to a card account set up with a starting balance in 2022 and never reconciled to that month's statement. The receivables were four invoices, three of which had been paid and added as income from the bank feed without touching the invoice, and one that the client had disputed and would never pay. The $811 was two forced reconciliations covering a duplicated deposit and a missing fee. Applying the three payments cleared $7,200 of receivables. The disputed $1,800 invoice and the opening balance equity offset went to the CPA as open items. The discrepancies were removed once the duplicate and the fee were fixed. Nothing was adjusted to a number that looked right.

How this works in Prosper

Prosper is the platform TidyMonth uses for the monthly work, and you can use it yourself with your CPA.

Most of the junk above exists because entries got separated from their reasons. A balance was set with no reconciliation behind it. An adjustment was made with no cause recorded. A rule applied a category with nobody watching.

In Prosper, entries don't get separated from their reasons. Every transaction that needed a decision keeps the decision, the evidence, and any note attached to it. Transfers are confirmed as pairs. Deposits that match an invoice are linked to it, so receivables don't go stale silently. If Prosper can't verify something, it flags it instead of adjusting it. There's no forced reconciliation, because a difference stays a question until it's answered.

Prosper learns your business patterns and proposes the same treatment for the same kind of activity, but it shows you the decision before applying it. That's the difference from a bank rule. A rule runs unwatched. A proposal is approved, and every change is reversible.

When you prepare the CPA packet, each balance on the balance sheet can be traced to the transactions and decisions behind it. That's what makes the books easy for your accountant to trace and explain, which is the whole point of a cleanup.

If you'd rather hand it off: TidyMonth by Prosper

If you'd rather someone else chased the old balances and then kept the junk from coming back, TidyMonth by Prosper scopes exactly that.

Start with a free Books Check. No card required, and nothing in your accounts is changed while we look. The results show which month your books are reliable through, how many months need cleanup, and what couldn't be verified from the records available. A Books Check reads bank activity, so historical balances and old journal entries are things it can point to, not things it can fully diagnose on its own. Those get reviewed once the work starts.

If your business fits, you see a scoped cleanup price before you pay. Up to three months behind is included with the $199 per month subscription. Four to six months is $399. Seven to twelve is $799. More than that, or more than three active accounts, or more than about 300 transactions a month, gets a fixed price from a person. Then TidyMonth handles the agreed monthly work in Prosper, and a bookkeeper reviews each close so the junk doesn't accumulate again. You answer the questions only you can.

If the first close isn't worth it, your first $199 is refunded in full. Cancel in one click. Export your books any time.

What your CPA still decides

Tracing every balance to its transactions gets the mystery out of the balance sheet. It doesn't decide how to write off a bad receivable, where an opening balance equity offset belongs, whether an old journal entry from a prior year can be changed, or what any of it means for a return that was already filed. Those are your CPA's calls. A historical balance isn't proof of an error on its own. Prosper and TidyMonth make each one traceable and put the unresolved ones on a list, so your accountant can decide with the source in front of them.