WCapsuleM8

Quote to Cash · step 11 of 11

Payment and cash application

The money arrives — and then has to be matched to the right invoices, on the right accounts, so the ledger reflects reality and nobody chases a customer who has already paid.

Also called: Cash allocation · Cash posting · Remittance processing · Settlement

Owned by
Credit Controller
Also involved
Account Manager, Inside Sales / Sales Coordinator
Documents
Sales Invoice, Credit Note
Measured by
Days Sales Outstanding (DSO), Gross Margin

What it is

The last step in the chain, and the one most companies assume needs no attention. Money arrives in the bank; it is matched to the invoices it settles; the account returns to zero and the order is finally, genuinely complete.

The reason it needs attention is that payments and invoices do not arrive in matching shapes. A customer pays £41,308.62 covering nineteen invoices, less two credit notes, less a deduction for something nobody recognises, with a remittance advice that arrives separately or not at all. Until someone works out which invoice each pound belongs to, the ledger is wrong — and a wrong ledger produces chasing letters to customers who have paid.

It is also where the truth about the whole chain finally shows up. Short payments and deductions are the accumulated cost of every earlier failure: the concession that never reached the invoice, the quantity discrepancy at despatch, the freight charge that was supposed to be included.

Why companies do it

Cash in the bank is not the same as a settled account. Without allocation you cannot tell who owes what, credit limits become meaningless, collections chases the wrong people, and the aged debt report — the basis of the cash forecast — describes a company that does not exist. Allocation is what converts a bank balance back into information.

Inputs and outputs

What has to be there first

What it produces

How it is done

  1. 01Get the remittance advice, and ask for it as standard

    Without it, allocating a bulk payment is reverse-engineering. Request it as part of account setup, name the email address it should go to, and chase the customers who never send one — most will, if asked once by the right person.

  2. 02Allocate to specific invoices, never to the account balance

    Posting a payment as a lump against the account leaves every invoice technically open and destroys the ageing profile. Match it line by line, even when the total is right, because the total being right is not the same as knowing what was paid.

  3. 03Investigate the difference before writing it off

    When the payment does not equal the invoices it claims to cover, the gap has a cause: a credit note applied that you have not issued, a deduction for a delivery shortage, an early settlement discount taken, a bank charge, an exchange difference. Each has a different owner and a different fix.

  4. 04Route deductions back to whoever caused them

    A short payment for a quantity discrepancy is a despatch issue. One for an unagreed price is an order entry issue. One for damaged goods is a packaging issue. Absorbing them quietly in finance means the cause is never corrected and the same deduction arrives every quarter.

  5. 05Clear unapplied cash quickly

    Money received but not matched to anything is the worst state on the ledger — the customer is chased for invoices they have paid, and the cash is not recognised as collected. Set a short deadline for clearing it and report the balance.

  6. 06Handle overpayments and duplicates honestly

    Customers pay twice more often than anyone expects. Refunding or offsetting promptly, and telling them, is both correct and one of the cheapest pieces of goodwill available. Holding it until they notice is not.

  7. 07Close the order

    With the invoice settled, the whole chain — quote, order, works order, delivery, invoice, payment — is complete and can be reconciled end to end. This is the only point where the actual margin on the job can be compared with the quoted one.

  8. 08Feed the outcome back to the front of the chain

    Actual margin against quoted margin, actual payment days against agreed terms, deductions by cause. These belong with estimating, sales and credit control respectively, and they are the only mechanism by which the chain improves.

What needs approval

Approvals only work when they happen before the commitment. Retrospective approval is a manager being told what has already been promised.

TriggerApprover
Writing off a short payment below a thresholdAbove it, finance manager — otherwise small deductions become policy.Credit controller, within a set limit
Refunding an overpaymentFinance
Accepting an unagreed early settlement discountFinance manager
Reallocating cash between accounts within a customer groupCredit manager

One payment, seven invoices, four differences

A worked example with real numbers.

A customer pays £24,187.40 by transfer with no remittance advice. The ledger shows seven open invoices totalling £24,905.15. The £717.75 gap takes an afternoon to explain, and every pound of it was created somewhere earlier in the chain.

£310.00 is a credit note the customer applied for a short delivery — issued, correct, and simply not yet matched. £284.25 is a deduction for freight the customer says was quoted as delivered; the quotation says ex-works, but the negotiation email agreed delivered and the quotation was never reissued. The customer is right in substance.

£98.50 is an early settlement discount taken on an invoice paid four days outside the qualifying period. £25.00 is an unexplained deduction described only as 'admin charge' on a portal, which turns out to be a fee for an invoice submitted by email rather than through their required portal.

The freight and the admin charge are both preventable and both recur monthly on this account. The freight one traces back to negotiation; the admin one traces to invoicing using the wrong route. Neither would have been visible without allocating the payment properly.

Reconciling a £717.75 short payment
AmountCauseOriginated atRecurring?
£310.00Credit note not yet matchedInvoicingNo
£284.25Freight — concession never reissued on the quoteNegotiationYes, monthly
£98.50Settlement discount taken outside termsCustomer APOccasionally
£25.00Portal non-compliance feeInvoicing routeYes, every invoice
£717.75Total difference

The point
Only one of the four differences was a genuine one-off. Two were monthly leaks caused three and four steps earlier in the chain, and both were invisible to everyone except the person allocating the cash.

Common mistakes

  • MistakePosting payments to the account rather than to invoices

    Why it happens: It clears the bank reconciliation quickly and the balance looks right. Every invoice stays open, the ageing report becomes meaningless, and collections chases paid invoices.

    What to do instead: Allocate at invoice level always. If the remittance is missing, allocate oldest first as a documented policy and flag it, rather than leaving it unallocated.

  • MistakeWriting off small deductions without recording the reason

    Why it happens: £40 is not worth investigating. Then it arrives every month from the same customer, on the same cause, and after two years it is £960 nobody ever looked at.

    What to do instead: Record a reason code on every write-off, however small, and review the codes quarterly. The value is in the pattern, not the individual amount.

  • MistakeLeaving unapplied cash to accumulate

    Why it happens: It is difficult, it requires contacting the customer, and there is always something more urgent. Meanwhile the same customer receives a dunning letter.

    What to do instead: Report unapplied cash as a headline number with an age. Anything unallocated after a week gets a named owner.

  • MistakeTreating a deduction as a finance problem

    Why it happens: It arrives in finance, so finance resolves it — usually by crediting it. The despatch error or the missed concession that caused it is never touched.

    What to do instead: Route every deduction to the function that caused it, with the evidence. Finance owns the ledger, not the root cause.

  • MistakeNot checking whether the customer took a discount they were not entitled to

    Why it happens: Settlement discount terms are sometimes taken outside the qualifying period, and the difference is small enough to look like a rounding error.

    What to do instead: Check the payment date against the discount terms. Where it does not qualify, ask — once, politely, with the dates. It is usually a system default on their side rather than a decision.

  • MistakeNever comparing actual margin to quoted margin

    Why it happens: By the time the cash arrives the job is four months old and everyone has moved on. The estimate that was wrong stays wrong for the next order.

    What to do instead: Reconcile a sample of completed orders end to end each month — quoted price, actual cost, deductions, actual cash. It is the only closed loop the chain has.

Where the work happens

  • Accounting or ERP receivables ledger
  • Bank feeds and statement imports
  • Customer accounts payable portals
  • Cash application automation and matching tools

Terminology

Cash application
Matching received payments to the specific invoices they settle.
Remittance advice
The customer's breakdown of which invoices a payment covers, and any deductions applied.
Unapplied cash
Money received that has not been matched to an invoice. Cash you have but cannot account for.
Short payment
A payment for less than the invoice value. Always has a cause, whether or not it is stated.
Deduction or chargeback
An amount withheld by the customer for a claimed failure — shortage, damage, late delivery, non-compliance with their process.
Settlement discount
A reduction offered for early payment, such as 2% for payment within 10 days. Expensive credit if it is routinely taken.
On account
A payment posted to the customer balance without being matched to invoices. Almost always a problem deferred.
Write-off
A deliberate decision to abandon a balance, recorded with a reason rather than allowed to age away.

Common questions

What is cash application and why does it matter?

It is the matching of incoming payments to specific invoices. It matters because without it your ledger cannot tell you who owes what. The visible consequence is chasing customers who have already paid, which does more damage to a relationship than almost anything else in the chain.

What should you do when a customer pays less than the invoice?

Find the cause before deciding anything. It will be a credit note, a deduction for a claimed failure, a discount taken, a bank or exchange difference, or an error. Each has a different owner. Writing it off without identifying which one guarantees it happens again.

How should a payment be allocated when there is no remittance advice?

Apply a documented default — usually oldest invoice first — flag it as an assumption, and ask the customer to confirm. What you should not do is post it to the account balance, because that leaves every invoice open and makes the ageing report useless.

Are settlement discounts worth offering?

Rarely, once the arithmetic is done. A 2% discount for paying 20 days early is an annualised cost in the region of 37%, which is far more expensive than almost any borrowing. They make sense as a deliberate liquidity purchase, not as a standing term.

What does the end of the chain tell you about the start of it?

More than any other step. Deductions and short payments are the accumulated cost of everything that went wrong earlier — the concession that never reached the invoice, the quantity mismatch at despatch, the wrong invoicing route. Reconciled by cause, they are the closest thing the chain has to an honest self-assessment.

When is the order actually complete?

When the cash is allocated and the balance is zero — not when the goods ship and not when the invoice is raised. Companies that treat despatch as the finish line consistently discover the last 10% of the work is where the margin was lost.

Tools for this

Downloadable, self-contained, and yours to keep — they run in a browser with no account and no data leaving your machine.

Reviewed 2026-08-15. Nothing here is legal, tax or accounting advice — contractual and tax practice varies by jurisdiction.