Use this bad debt allowance calculator to estimate a target allowance from receivables aging buckets and your own expected loss rates. See the implied collectible balance and the difference from an existing allowance. The preset rates are illustrative, not a recommended policy.
Bad debt allowance results
Allowance by aging bucket
| Age bucket | Open balance | Loss rate | Estimated loss |
|---|
Positive difference indicates a higher target allowance than the entered credit balance; negative indicates a lower target. This is a planning estimate, not an automatic accounting entry.
How the bad debt allowance calculator works
The bad debt allowance calculator multiplies each bucket’s open receivables by its expected loss percentage. It adds those five amounts to estimate the target allowance. Subtracting the target allowance from gross receivables gives an estimated collectible amount. The blended loss rate expresses total estimated loss as a percentage of gross receivables.
Target allowance = sum of bucket expected losses.
Estimated collectible AR = gross AR − target allowance.
Blended loss rate = target allowance ÷ gross AR × 100%.
Difference = target allowance − existing allowance credit balance.
The existing allowance field uses a credit-positive sign convention. For example, enter 100 for a $100 credit balance or −20 for a $20 debit balance. The bad debt allowance calculator shows this difference for comparison with a target, before considering write-offs, recoveries, other adjustments or your accounting policy. A negative difference is possible and does not automatically require a reversal.
Worked example with five aging buckets
The illustrative preset has $1,200 current at 0.5%, $800 in 1–30 at 2%, $600 in 31–60 at 5%, $400 in 61–90 at 10%, and $200 in 91+ at 25%. The respective expected losses are $6, $16, $30, $40 and $50. Summed together, the bad debt allowance calculator returns a $142 target allowance against $3,200 gross AR.
Estimated collectible receivables are $3,200 − $142 = $3,058. The blended expected loss rate is $142 ÷ $3,200 × 100 = 4.44% when rounded to two decimals. If the existing allowance has a $100 credit balance, the difference to the estimate is $42. This arithmetic illustrates the method; the example rates do not predict any particular customer’s outcome.
Choosing defensible rates
The bad debt allowance calculator deliberately asks you to supply the rates. Aging can be a useful segmentation method, but invoices of the same age need not have the same credit risk. Historical payment and loss experience, customer characteristics, current conditions and reasonably supportable expectations can affect the estimate. Consider whether a significant customer, disputed invoice or concentration needs separate review rather than a broad bucket rate.
For trade receivables under IFRS 9, a provision matrix is described as a practical expedient for measuring expected credit losses, with loss rates adjusted where appropriate for current and forward-looking information. See the IFRS 9 Financial Instruments standard. US GAAP and other frameworks have their own requirements. The bad debt allowance calculator is a simple arithmetic aid; it cannot determine compliance with a particular framework or replace a documented estimate.
Use an Accounts Receivable Aging Calculator to assemble bucket balances from invoice due dates. Use a consistent reporting date, apply payments and credits, and reconcile gross AR to the ledger. A current bucket may still have risk, while an old bucket may include secured or disputed amounts with a different outlook. Update rates when the evidence changes instead of carrying the sample values forward.
Interpreting the result
A higher target allowance means a larger estimated portion of receivables may not be collected. It is not a prediction that each invoice will fail. The bad debt allowance calculator is an aggregate estimate using user-entered assumptions. Review unusually high bucket contributions to see whether the rate or balance is driving the result. If one balance dominates an age bucket, consider an individual assessment where your accounting policy calls for one.
The bad debt allowance calculator also shows the difference from an existing allowance. That comparison can flag a need to investigate the ledger balance and assumptions. It is not necessarily the expense for a period: write-offs, recoveries, acquisitions, foreign exchange and other movements may affect the allowance. Check the roll-forward and applicable reporting rules before recording entries.
For collection efficiency, compare Accounts Receivable Turnover or Days Sales Outstanding. Those metrics use sales and average receivables to describe timing; they do not by themselves measure expected credit losses. A lower DSO does not guarantee lower losses, especially when customer mix changes.
Assumptions and limitations
- The bad debt allowance calculator applies one rate to each of five due-date aging buckets; it does not model individual cash-flow timing, collateral, guarantees or recoveries.
- It accepts nonnegative receivable balances and rates from 0% through 100%. Zero gross AR produces a 0% blended rate.
- Existing allowance may be positive, zero or negative. The difference is a mathematical comparison under the stated sign convention.
- Currency selection formats output only. Convert and reconcile mixed-currency receivables before using one set of inputs.
- Rounding occurs in the displayed amounts. The internal calculation uses the entered decimal values; your ledger may apply separate rounding policies.
- The example rates are arbitrary teaching inputs. Use company-specific evidence, credit information and the relevant accounting guidance.
Export the bad debt allowance calculator CSV to review balances, rates and bucket expected losses in a spreadsheet. The Print / save PDF button opens the browser print dialog. Keep an audit trail of your source aging report, rate development, qualitative adjustments and approval process outside this tool.
Bad debt allowance calculator FAQs
Is bad debt allowance the same as a write-off?
No. An allowance estimates expected uncollectible amounts across receivables. A write-off removes a specific balance under the applicable policy and may reduce an existing allowance.
Why are loss rates higher for older buckets in the example?
The preset is illustrative. Older balances often warrant review, but the actual rate should follow your evidence and customer circumstances rather than the sample progression.
What if the existing allowance has a debit balance?
Enter it as a negative number. A $20 debit is −20, so a $142 target is $162 above that entered balance.
Can I use one rate for all buckets?
Yes. Enter the same percentage in each rate field. Separate rates are useful only when supported by your approach and data.
Does this make a journal entry?
No. The result is an estimate and difference. Review the allowance roll-forward, reporting requirements and approvals before any accounting entry.
How do I get bucket balances?
Use a reconciled receivables aging report as of the reporting date. Our aging calculator can group manually entered invoices by due date.