Bad Debts Provision: SME Calculation & Management 2026
2026-06-13
You send the invoice on time. The customer says they’ll pay next week. Next week becomes next month. Then your finance lead shows you an aging report with a cluster of old balances that still sit in accounts receivable as if they were cash-in-waiting.
That’s where many SME managers get caught. Sales look healthy. Revenue has been booked. The balance sheet shows receivables. But some of that money may never arrive.
A bad debts provision is the accounting answer to that problem. It forces the business to stop pretending every invoice will be collected and to record a more realistic view of what those receivables are worth. For a business owner, that matters far beyond bookkeeping. It affects profit, cash planning, lending conversations, bonus decisions, and how early you spot customer risk.
The challenge gets harder in unstable markets. Historical payment patterns can stop being reliable very quickly when customers face pressure, sectors slow down, or disputes rise. A formula that worked last year may understate risk this quarter. That’s why a good provision process isn’t just about compliance. It’s a management discipline.
An Introduction to Unpaid Invoices
A typical SME story goes like this. You’ve delivered the work, the client approved it, the invoice went out, and nobody in sales is worried because the customer is “usually good for it.” Then the month-end review arrives. A few invoices are late. One large balance has rolled into the next aging bucket. Another customer has gone quiet.
At that point, the receivables list stops being an admin report and becomes a risk report.
If you’re tightening your collections process, it helps to pair finance discipline with legal and operational follow-up. A practical resource on business strategies for late payments can help managers think through reminders, escalation, and recovery options before balances become unrecoverable.
The first control point is often simpler than people think. Invoice clearly, send promptly, and make sure the customer received it. Many delays start with messy communication rather than insolvency. If your team wants a cleaner process, this guide on sending an invoice via email is a useful operational checkpoint.
Why optimism is expensive
When a business leaves doubtful invoices untouched, two things happen:
- Profit looks better than reality. Revenue stays in the accounts with no corresponding recognition that some customers may not pay.
- Assets look stronger than reality. Accounts receivable can include balances that are old, disputed, or increasingly unlikely to convert into cash.
- Managers make poor decisions. They may hire, invest, or distribute cash based on numbers that overstate financial strength.
Old receivables create a special kind of risk because they look like assets until the moment everyone admits they are not.
The safety net mindset
A bad debts provision is best understood as a financial safety net. It doesn’t mean every overdue invoice is lost. It means management accepts a basic truth of trading on credit: some portion of receivables won’t be collected in full, and that risk belongs in the accounts now, not later.
That shift matters. Strong finance teams don’t wait for certainty. They estimate loss early enough to keep reporting honest.
The Core Concept What Is a Bad Debt Provision
A bad debts provision is an accounting estimate of receivables that probably won’t be collected. You may also hear the term allowance for doubtful accounts. The two are closely related in practice.
Under the allowance method, the provision sits as a contra-asset. That means it reduces the value of accounts receivable rather than appearing as a separate operating asset. Harvard Business School Online describes it this way: under the allowance method, bad debt provision is an estimated contra-asset that reduces accounts receivable to the expected collectable amount, and when an actual write-off happens, the business debits the allowance and credits accounts receivable instead of recognizing a new expense then (Harvard Business School Online on bad debt provision).
The simplest analogy
Think of accounts receivable as the full amount customers owe you. The bad debts provision is the umbrella you carry because you know some rain is likely.
You are not moving cash into a reserve account. You are not admitting defeat on each invoice. You are adjusting the reported value of receivables to reflect expected reality.
So the logic is:
| Item | Meaning |
|---|---|
| Accounts receivable | Gross amount customers owe |
| Bad debts provision | Estimated amount that may not be collected |
| Net realizable value | What you realistically expect to collect |
Why finance teams record it before the loss is certain
Non-specialists often pause at this point. “Why book an expense before we know the customer won’t pay?”
Because the sale and the credit risk belong to the same period. If you recognize revenue today but wait several months to recognize the likely loss, the original period looks too profitable and the later period looks worse than it really was.
That’s the practical heart of the matching principle. Match the expected cost of giving credit to the same period as the related revenue.
Practical rule: If your business earns revenue by offering credit, part of the economic cost is the risk that some customers won’t pay.
For SME leaders, this isn’t just accounting hygiene. It improves management reporting, lender conversations, and board discussions. If you want a broader risk lens around customer payment behaviour, this essential guide for UAE SME finance leaders is a useful complement to the accounting view.
Choosing Your Estimation Method
Not every business needs the same method. The best approach depends on volume, customer mix, data quality, and how quickly credit conditions change.
Some SMEs start with a simple percentage and move to aging analysis as they grow. Others need a more forward-looking model because customer risk shifts quickly and historic averages stop being reliable.
The three common approaches
The simplest method applies one percentage to a broad base, usually sales or receivables. It’s easy to run and easy to explain. It also smooths over important differences between a current invoice from a strong customer and a very old balance from a struggling one.
A stronger method is the aging of accounts receivable approach. It groups balances by how overdue they are and applies different expected-loss percentages to each bucket. That’s more informative because delinquency usually tells you something about risk.
The most forward-looking approach in formal accounting settings is an expected credit loss mindset. Even if your SME doesn’t use the full IFRS language in daily management reporting, the discipline is useful: look beyond the past and ask what current conditions say about future collections.
A benchmark for aging schedules
Aging schedules are widely used because they reflect an obvious truth: older debts are usually riskier. The University of Cambridge’s financial procedure uses 25% provision for balances 60 to 182 days past due, 50% for 183 to 364 days, and 100% for debts 365 days or more past due, with 100% also required for debts at significant or immediate risk of non-payment (University of Cambridge bad debt procedure).
That doesn’t mean your business should copy those rates exactly. It does show the logic of scaling provision severity as invoices age.
Comparison of bad debt estimation methods
| Method | Best For | Accuracy | Complexity |
|---|---|---|---|
| Percentage of sales or receivables | SMEs with stable patterns and limited finance capacity | Lower | Low |
| Aging of accounts receivable | Businesses with meaningful credit exposure and usable aging reports | Higher | Moderate |
| Forward-looking expected loss approach | Firms in volatile sectors or with concentrated customer risk | Potentially strongest if well governed | Higher |
How to choose without overengineering
Use these decision criteria:
- Stable customer base: A simpler method can work if payment patterns are steady and invoice values are not heavily concentrated.
- Longer overdue cycles: Aging is usually better once old balances start to build and you need sharper visibility.
- Sector volatility: If your customers react quickly to market pressure, add management judgment rather than relying only on old averages.
- Reporting expectations: Banks, investors, and auditors usually prefer a method that clearly ties to observable risk.
For teams trying to improve the wider working-capital picture around receivables and payables, this guide to accounts payable and accounts receivable for UK SMEs helps frame where bad debts provision fits in the broader cash cycle.
Step by Step Calculation and Journal Entries
Theory only helps if your team can turn it into entries in the ledger. The aging method is often the most practical place to start because it mirrors how finance managers already review overdue invoices.
Here is the visual workflow first.
A clean five-step process
- Export your receivables listing. Use your ledger or ERP and sort invoices by due date.
- Create aging buckets. Group invoices into sensible delinquency bands used by your business.
- Assign expected loss rates. Base these on historical write-offs, collections experience, and any known customer issues.
- Calculate the required ending allowance. Multiply each bucket by its expected loss rate and total the result.
- Post the adjustment entry. Compare the required allowance to the current allowance balance, then post only the difference needed.
A worked example from accounting guidance shows the basic mechanics clearly: a 4% estimated loss rate applied to a £12,500 debtor balance gives a £500 provision, recorded as bad debt expense with a credit to the allowance account (Agicap worked example on bad debt).
What the journal entry looks like
When you need to increase the provision, the entry is:
- Debit bad debt expense
- Credit allowance for doubtful accounts
That entry recognizes the expected loss in the income statement and reduces receivables indirectly on the balance sheet.
Later, when a specific invoice is confirmed as uncollectible, the write-off entry is different:
- Debit allowance for doubtful accounts
- Credit accounts receivable
The key point is that the expense was recognized earlier through the provision. The later write-off uses the allowance already built.
Don’t confuse the estimate with the clean-up. Provisioning records the expected loss. Writing off removes a specific balance.
A short walkthrough video can help if you want to see the mechanics in a more visual format.
Where teams usually get confused
The most common issues are not technical. They’re procedural.
- Using the wrong base: Teams sometimes apply a rate to total sales when the objective is to estimate the ending receivables risk.
- Ignoring the opening allowance: If an allowance already exists, you post the adjustment required, not the full new estimate again.
- Treating every old invoice the same: A disputed balance, a strategic customer with a payment plan, and a silent customer in distress may belong in different risk categories.
- Forgetting to review write-offs against estimates: If actual losses keep exceeding the provision, your assumptions need updating.
A practical spreadsheet mindset
If you build this in Excel, keep separate tabs for:
| Tab | Purpose |
|---|---|
| Receivables extract | Raw customer invoice data |
| Aging analysis | Bucketed balances by overdue status |
| Risk overlays | Notes on customer-specific concerns |
| Journal support | Calculation of required adjustment |
That structure makes month-end easier and gives your auditor or reviewer a clear trail.
Managing Provisions in a Volatile Economy
Judgment truly begins here. Historical collection data is useful until it isn’t.
In a stable period, last year’s write-off pattern may be a fair starting point. In a volatile period, it can become dangerously reassuring. Customers may pay later, dispute more aggressively, request extended terms, or run out of cash faster than your model expects.
The problem is simple. A bad debts provision is an estimate, not a machine output. Hyperbots notes that many explainers stop at historical methods and don’t address how to update provisions in volatile periods, even though users need guidance on when historical averages become misleading and may cause systematic under-provisioning (Hyperbots glossary on bad debt provision).
What to change when conditions shift
Start with your normal model, then challenge it.
Ask questions like these:
- Are customers paying more slowly than before?
- Has one sector in your customer base come under pressure?
- Are more invoices disputed, even if they are not yet written off?
- Has a major customer asked for longer payment terms or partial settlements?
- Are collections staff escalating more accounts than usual?
If the answer is yes to several of these, finance should consider a management overlay. That means adjusting the formula-based provision to reflect facts the historical model hasn’t captured yet.
Avoiding two common mistakes
The first mistake is under-provisioning. Management wants to protect profit, so it leaves assumptions unchanged even though warning signs are building. That creates a balance sheet that looks stronger than the collections team believes.
The second mistake is over-provisioning. Management reacts to uncertainty by becoming excessively conservative and depressing profit beyond what the evidence supports. That can distort period comparisons and make performance harder to read.
In uncertain periods, the best provision is rarely the most optimistic or the most pessimistic one. It’s the one you can explain with evidence.
For SME managers, one of the best companion disciplines is regular cash planning. A provision affects reported profit, but deteriorating collections affect survival. This guide on the advantages of cash flow forecasting is useful because it forces finance and operations to connect accounting estimates with real cash timing.
A review rhythm that works
A practical cadence is to review provisions alongside your month-end receivables pack and perform a deeper challenge quarterly. In more stressed conditions, finance teams often shorten that review loop and involve sales, credit control, and leadership directly.
Compliance Internal Controls and Reporting
A strong bad debts provision process depends on more than year-end accounting. It depends on the controls that shape credit decisions, invoice quality, follow-up discipline, and the evidence behind management judgment.
That’s why the best finance teams treat bad debt as a full-cycle issue. Sales creates the risk. Operations can increase or reduce disputes. Credit control sees early warning signs. Finance translates that into reporting.
The control checklist
These controls matter most:
- Credit approval discipline: Set clear criteria before extending terms, especially for new or concentrated customers.
- Accurate invoicing: Wrong names, purchase order mismatches, or missing delivery evidence often become slow-pay problems.
- Segregation of duties: The person approving credit shouldn’t be the only person posting adjustments or approving write-offs.
- Aging review cadence: Finance should review overdue accounts regularly with sales and collections.
- Write-off authorization: Specific balances should require documented approval before removal from receivables.
- Documentation of estimates: Keep the assumptions, customer notes, and rationale behind management overlays.
If your finance team is tightening governance generally, this guide on internal controls for teams offers a helpful management perspective beyond the accounting entry itself.
How it appears in the financial statements
The provision has two visible effects.
First, it reduces profit through bad debt expense. Second, it reduces the carrying value of accounts receivable through the allowance.
Investopedia gives a practical benchmark example: a wholesale distributor might observe that about 3.2% of total accounts receivable becomes uncollectible on average and use that rate to estimate the allowance on current receivables. The provision directly reduces reported profit while improving the realism of the balance sheet (Investopedia on allowance for doubtful accounts).
One area managers often overlook
Tax treatment and accounting treatment are not always identical. A business may recognize an accounting provision based on expected loss, while tax rules may require a different threshold before a deduction is allowed. That’s why controllers should keep tax advisors and external accountants close to the process when balances become material.
If your team is working through overdue balances operationally as well as accounting for them, this guide to small business debt collection can help align collections activity with the finance review.
Good controls reduce bad debts twice. They prevent weak credit decisions up front, and they improve the evidence behind the provision at month-end.
Frequently Asked Questions on Bad Debts Provision
What’s the difference between a provision and a write-off
A provision is an estimate. It records the expected loss before you know exactly which invoices will fail.
A write-off is the later accounting action that removes a specific receivable once it is judged uncollectible.
Why is the allowance method better than the direct write-off method
Because it gives a more realistic picture of both profit and receivables in the period when the sale happened. The direct write-off approach delays recognition until later, which can make earlier results look too strong.
Is the provision cash set aside somewhere
No. It’s an accounting estimate, not a separate bank balance.
How often should an SME review bad debts provision
Monthly is sensible for businesses with meaningful credit exposure. Quarterly may be enough for smaller firms with low volume and stable customers. In uncertain trading conditions, review more often.
What’s the biggest practical mistake
Treating the provision as a routine percentage that never changes. If customer behaviour changes, the estimate should change too.
Should sales teams be involved
Yes. Finance owns the accounting, but sales and account managers often know first when a customer is struggling, disputing invoices, or asking for concessions. That information belongs in the review.
What should management ask at month-end
Ask three things:
- Which balances have aged unexpectedly?
- Which customers show signs of stress or dispute?
- Does the current provision still reflect today’s conditions, not just last year’s averages?
If your finance team also handles payment and collection files, GenerateSEPA can help streamline the operational side. It converts Excel, CSV, JSON, and legacy AEB files into valid SEPA XML, supports API-based automation, and adds validation steps that reduce avoidable processing errors. For SMEs and finance departments working with remittances and bank files, it’s a practical way to make the payment workflow cleaner and more reliable.
Frequently Asked Questions
- What's the difference between a provision and a write-off?
- A provision is an estimate. It records the expected loss before you know exactly which invoices will fail. A write-off is the later accounting action that removes a specific receivable once it is judged uncollectible, using the allowance already built.
- Why is the allowance method better than the direct write-off method?
- Because it gives a more realistic picture of both profit and receivables in the period when the sale happened. The direct write-off approach delays recognition until later, which can make earlier results look too strong and later periods worse than they really were.
- Is the provision cash set aside somewhere?
- No. It is an accounting estimate, not a separate bank balance. It reduces the carrying value of accounts receivable on the balance sheet and recognizes an expected loss in the income statement, but no cash actually moves into a reserve account.
- How often should an SME review its bad debts provision?
- Monthly is sensible for businesses with meaningful credit exposure, while quarterly may be enough for smaller firms with low volume and stable customers. In uncertain trading conditions, review more often and add a management overlay when historical averages stop reflecting current risk.
