tervra.
Menu

Reconciliation

Unapplied cash: money you have, against invoices you cannot close.

Cash sitting unallocated is not a bookkeeping tidiness problem. It makes your debtors wrong, your collections wrong, and your customers annoyed. Here is why it builds up and how to clear it.

Every business that takes money from more than a handful of payers has some. A credit arrives, nobody can say with confidence what it settles, and it goes into a holding position: a suspense account, a payments-on- account balance, or an unallocated column in the sales ledger. The money is real, it is in the bank, and the invoice it belongs to is still showing as unpaid.

Short answer

Unapplied cash is money you have received but have not matched to what it settles. Clear it payer by payer rather than payment by payment, oldest payer first, using the payer’s account and the amount before the reference. Anything still unexplained belongs in a suspense position that somebody owns, not spread across the nearest open invoices.

What it actually is

Unapplied cash is a mismatch between two true statements. The bank says you have the money. The ledger says the customer still owes it. Both are correct until somebody joins them, and until they do, the business is running on figures that disagree with each other.

It is not the same as an unidentified receipt. A payment can be confidently attributed to a customer and still be unapplied, because knowing who paid is not the same as knowing what for. That distinction matters when you come to clear a backlog, because the two need different work.

Why it accumulates

  • One payment against many invoices. A single credit settles eleven invoices and matches none of them individually.
  • Part payments. The amount matches nothing because it was never meant to match anything in full.
  • Deductions. The payment is short on purpose, and until the reason is established nobody is willing to close the invoice.
  • The remittance is elsewhere. It exists, in an inbox, unread by the person doing the reconciliation.
  • The easy ones get done first. The rational daily choice is to allocate the payments that are obvious and leave the rest. The residue is therefore selected for difficulty, which is why a backlog never gets easier on its own.

What it costs

The bookkeeping consequence is the least of it.

  1. Your aged debtors are wrong. Invoices show as outstanding that have been paid, so the ageing profile overstates what is owed and misplaces where the risk sits.
  2. Collections chase the wrong people. Somebody calls a customer about an invoice that customer paid three weeks ago. That call costs more than the allocation would have.
  3. Credit decisions are made on bad data. A customer can appear over their limit purely because their payments have not been applied.
  4. Cash reporting drifts. Received-but-unapplied money is in the bank and absent from the receivables picture, so the two views of the same month do not agree.
  5. It gets harder with age. The people who remember move on, the customer’s own records get archived, and a twelve-month-old unapplied payment is often unresolvable at any reasonable cost.

Clearing a backlog

The instinct is to work down the list of unapplied payments in date order. That is the slowest route, because it treats each payment as an isolated puzzle when most of them belong to a handful of payers.

  1. Group by payer first. Sort the backlog by paying account, not by date. One conversation with one customer can frequently clear a dozen payments.
  2. Start with the payer holding the most value, not the oldest single payment. The oldest payment is usually the hardest and the least worth solving.
  3. Reconstruct the account, not the payment. Take everything that payer has paid and everything they have been invoiced over the period, and reconcile the totals. Individual allocations often fall out of that arithmetic.
  4. Ask the customer, plainly. Most will tell you. “We have £14,200 from you across four payments in March and we have not applied it correctly” is a normal request, not an embarrassing one.
  5. Write off deliberately, and record why. Some of a long backlog is not economically recoverable. Deciding that is legitimate. Letting it sit unresolved indefinitely is not a decision, it is an absence of one.

Keeping it low

  • Allocate on the day, or not at all. The cost of allocating a payment rises steeply with age. A same-day rule allocates more in total than a weekly one.
  • Remittances to a shared address, so the explanation is available to whoever is reconciling rather than to one person.
  • Give suspense an owner and a review date. A holding position nobody is accountable for is a place things go to be forgotten.
  • Measure it. Unapplied cash as a proportion of receipts, tracked monthly, is a better indicator of reconciliation health than the aged debtor report, because it moves first.

The part that stays hard

Every step above assumes somebody can see the payment, the invoices, the remittance and the agreement in one place. In practice they are in four systems, and a person holds the connection between them in their head for as long as it takes to make the allocation.

That is the gap Tervra is being built to close. Your bank sees a payment; what it settles is recorded somewhere else in your business. Tervra is designed to assemble a receipt against what is actually outstanding, to say plainly when it cannot establish an answer rather than allocating to the nearest plausible invoice, and to keep the unexplained visible so that it is a decision rather than a residue. How money in works.

Sources

  • Bacs Direct Credit scheme information, Pay.UK
  • FRS 102, the Financial Reporting Standard applicable in the UK and Republic of Ireland, on the presentation of trade and other receivables
  • Practitioner guidance on suspense-account treatment and cash allocation in UK SME finance functions

Your next step

Get to know Tervra.

Explore the product, follow a fictional journey or tell us what matters in your business account.

Explore early access