Clearing a Suspense Account That Has Been Growing for Two Years
A suspense account is a list of decisions nobody made, and clearing it is mostly the act of finally making them.
Nothing in a suspense account arrived there by accident. Every line is a moment where somebody had a transaction, did not know what it was, and chose not to ask. That is not a criticism of the bookkeeper. Asking costs a phone call and a wait, posting to suspense costs nothing and clears the queue, and a process that measures how quickly the queue empties will produce a suspense account whether or not anyone intended one.
Which means the clearance is not a bookkeeping exercise. It is the exercise of finally asking two years of questions, in a batch, and the technique that makes it survivable is that you clear a suspense account in layers, not transaction by transaction.
Almost everybody starts at the oldest item. It is the natural instinct and it is the worst possible order. The oldest items are the ones whose counterparties have moved on, whose documents are furthest away and whose amounts are usually smallest, so you spend the first two days on the hardest and least valuable part of the balance and then stop. Age the account first, sort it by source and by size, and the shape of the work changes completely.
What follows is one clearance from an opening balance to a nil close. The company is a composite and the figures are illustrative, not a client’s. They are here because the layering is obvious once you watch it and abstract until then. All amounts are Canadian dollars.
The opening position
A suspense account carried since a system change roughly two years earlier. Nobody had reviewed it in that time. The trial balance showed a single line.
| Amount | |
|---|---|
| Suspense, per trial balance | 47,300 debit |
That number is the least useful fact about the account, and printing it first is how the clearance gets scoped wrongly. Pull the detail and it looks like this.
| Items | Amount | |
|---|---|---|
| Gross debits | 128 | 186,400 |
| Gross credits | 86 | 139,100 |
| Net | 214 | 47,300 debit |
The gross is four times the net. That is the normal case, and it is the first thing to establish, because a company looking at the trial balance line believes it has a modest problem and a company looking at the gross knows it has two hundred unanswered questions of which a few are large. A small net balance is not evidence of a small problem. It is frequently two significant errors in opposite directions that have never been separated.
Layer one: age it
Three buckets. Current year, prior year, older than that.
| Period the item was posted | Items | Debits | Credits | Net |
|---|---|---|---|---|
| Current year | 96 | 61,200 | 48,900 | 12,300 debit |
| Prior year | 78 | 74,800 | 61,700 | 13,100 debit |
| Two years and older | 40 | 50,400 | 28,500 | 21,900 debit |
| Total | 214 | 186,400 | 139,100 | 47,300 debit |
Ageing tells you where the recoverable evidence is. Current year items are almost all resolvable, because the bank statements, the emails and the people are all still at hand. The oldest bucket rarely is. It also tells you something the company usually has not registered: the account is still being fed. Ninety six items landed in it this year, which means clearing the balance without changing the process buys you about eleven months.
Layer two: sort by source, which is where the work actually collapses
Every line in a suspense account came from somewhere, and there are never as many somewheres as there are lines. This is the table that decides the plan.
| Source | Items | Net |
|---|---|---|
| Bank feed items with no match | 84 | 9,600 debit |
| Payroll import differences | 41 | 4,200 debit |
| Sales tax adjustments and rounding | 26 | 1,700 debit |
| Customer receipts never applied to an invoice | 33 | 18,900 credit |
| Two one-sided journals from the old system | 2 | 38,400 debit |
| Genuinely unidentified | 28 | 12,300 debit |
| Total | 214 | 47,300 debit |
Read the fifth row again. Two lines out of two hundred and fourteen carry more than four fifths of the net balance. That is not unusual, it is close to typical, and it is the entire argument for sorting by source before touching anything. A clearance run in date order would have reached those two lines somewhere in the second week.
The other thing this table does is convert a two hundred item problem into a six item problem. Five of the six rows are groups with a single cause, and a group with a single cause has a single answer.
Clearing the batches
The order below is by value and by tractability, not by age.
The two old journals, 38,400. These were traced to the system conversion. One was the unposted half of an entry that should have brought across an opening loan balance. The other was half of a disposal, where the asset had come off the register and the corresponding side had never landed anywhere.
Both of those change figures in a period that has already been reported on. Neither was resolved by us, and neither should have been. The company’s accountant was sent the two items, the conversion working papers and the specific question, and the treatment came back from them. That is the boundary and it is not a soft one: an item that alters a prior period, or that is large enough to matter to how the statements read, is a determination for whoever reports on those statements. A finance function that decides it quietly has made a decision it was not asked to make, and the fact that the decision is probably right does not change who owned it.
Customer receipts never applied, 18,900 credit. Purely mechanical. Thirty three deposits had reached the bank, been recognised as customer money and posted to suspense because nobody matched them to an invoice. Every one was matched off the receivables aging, mostly within a day, and the exercise incidentally cleared a set of old receivables that the aging had been carrying as outstanding. Two of the thirty three turned out to be overpayments with no invoice to match, and those went onto the escalation list rather than into revenue.
Bank feed items with no match, 84 items, 9,600 net. Batched by counterparty, which reduced eighty four lines to about a dozen names. Most were recurring: a payment processor’s fee, a monthly software charge on a card the feed did not recognise, a financing debit. Each name was coded once, a feed rule was written so it never returns, and the remaining one-off items were sorted by amount and worked from the top.
Payroll import differences, 41 items, 4,200 net. One cause, as it almost always is. The integration was mapping an employer contribution to an account that did not exist in the new chart, and the difference had been landing in suspense every pay run for two years. Fixing the mapping cost twenty minutes. The accumulated balance was cleared as a single entry against the correct account.
Sales tax adjustments and rounding, 26 items, 1,700 net. Small, and worth naming only because this is the row companies plug. It should be reconciled against the filings for the periods concerned before anything is written anywhere, because a persistent difference in a statutory account is a symptom rather than a balance.
The residue, and the decision that is not yours
After the five batches, twenty eight items and 12,300 remained. This is where a clearance either finishes properly or gets quietly plugged.
Split the residue on one question: can this be reconstructed, and what would it cost.
| Group | Items | Net | Disposition |
|---|---|---|---|
| Reconstructable with real effort, individually meaningful | 6 | 9,100 debit | Investigated. Four resolved to their correct accounts, totalling 6,700. Two, totalling 2,400, did not resolve. |
| Reconstructable in principle, individually trivial | 19 | 2,400 debit | Not investigated. The investigation costs more than the amount and saying so out loud is better than pretending otherwise. |
| Not reconstructable at all | 3 | 800 debit | The counterparty is gone or the records do not exist. |
Four items resolved, leaving twenty four items and 5,600. The recommendation that goes to the owner is that those twenty four are written off. The recommendation is not the decision. What we hand over is the list, item by item, with what was tried against each one, what it would cost to go further, and a plain statement of what is being given up. The owner decides, and where the residue is large enough to matter to the statements, or where any part of it touches a statutory account, the accountant is asked before anything is posted.
That sequence matters more than it sounds. A write-off decided inside the finance function and posted as a tidy-up is indistinguishable, six months later, from a balance that was never investigated. A write-off decided by the owner on a written recommendation is a documented decision with a name on it, and that is what an outside reader is actually looking for.
The close-out entry
One entry, dated, with a line per batch. Not one line with the word “suspense” in the description.
| Line | Debit | Credit |
|---|---|---|
| Prior period conversion items, split between two accounts exactly as the accountant directed | 38,400 | |
| Accounts receivable, thirty three receipts applied to invoices | 18,900 | |
| Suspense, receipts batch | 18,900 | |
| Expense and payable accounts, bank feed items, by counterparty | 9,600 | |
| Employer contribution expense, payroll mapping correction | 4,200 | |
| Sales tax payable, adjustments reconciled to the filings | 1,700 | |
| Correctly identified residue items, four accounts | 6,700 | |
| Unidentified items written off, approved by the owner in writing | 5,600 | |
| Suspense, cleared to nil | 66,200 |
The first line is deliberately vague about which accounts received the 38,400 and in what proportion, because that was not our determination and reproducing the reasoning here would suggest it was. The accountant said where the two conversion items belonged, we posted what they said, and their instruction is in the file beside the entry.
Two features of the entry are the whole point of writing it this way.
The write-off is its own line, described as what it is. Not absorbed into an expense account with a neutral name, not spread across the batches, not netted against the receipts that went the other way. It is the one line an outside reader will ask about and it should be findable in four seconds. Burying it does not make the question go away, it makes the question worse when it arrives.
Every other line names its source, not just its account. A year from now somebody will ask why 4,200 landed in an employer contribution account in one lump, and “payroll mapping correction” answers it from the entry itself rather than from a person’s memory. Descriptions that read “clear suspense” answer nothing and are the reason the account was opaque in the first place.
File the ageing, the source analysis, the residue list with its dispositions, the owner’s written approval and the accountant’s instruction together, as one working paper. That file is what makes the clearance defensible. The entry on its own is not.
Closing the door
The account is now nil and it will be back inside a year unless something changes. Four rules, and the third is the one that does the work.
- Rename it. Not “suspense”. Something that reads as an alarm: unidentified items, pending resolution. An account named suspense sounds like a place things are supposed to go.
- Nothing is posted to it without a note. What the item is, where it came from, who was asked, and on what date. A posting with no note is not allowed, and the person posting it is the person who has to write it.
- Give it a maximum age, not a maximum balance. No item may sit in it longer than one close cycle. A balance cap fails because the balance is a net, and a net can look calm while two hundred items pile up underneath. An age cap cannot be gamed the same way.
- It is nil at close, or the close is not finished. The month end close treats a non-nil suspense account as an open item with an owner and a date, in the same way as an unreconciled bank account, because that is exactly what it is.
A suspense clearance is rarely the only thing wrong when it is found, which is why it sits inside close remediation rather than standing alone. If the underlying cause was a system conversion, and it usually is, the rest of the ledger is worth the same suspicion. Mapping errors do not occur in one account. A chart of accounts rebuild has its own set of proofs for exactly this reason, and running them after the fact is a reasonable use of a week.
What we do not do
We do not clear a suspense account by posting a single balancing entry to an expense account, in any amount, for any reason.
We do not determine the treatment of an item that changes a period somebody has already reported on. That goes to the accountant with the documents and the question attached, and we wait for the answer rather than proposing one and treating silence as agreement.
We do not decide a write-off on a client’s behalf. We do the investigation, we say what we recommend and what it would cost to go further, and the owner signs it.
And we do not hand back a nil suspense account without also handing back the reason it filled up, because a clearance without a process change is a service you will be buying again in eleven months.