Accountio / Templates / Debt recovery / Late payment calculator

Late payment interest calculator for UK business debts

Work out what you can add to a late invoice from a business customer under the Late Payment of Commercial Debts (Interest) Act 1998: statutory interest by the day and the fixed compensation sum. This late payment interest calculator is one Excel workbook with the base rates already filled in from 2023.

UK practices
$15
In the pack
Debt recovery pack
Files
5, Word and Excel
Buy the pack · $15
Global library · 110 packs

Get this pack and 109 more for $99

Debt recovery · this packAML complianceCharity accountsEstate administrationMTD for Income TaxP11D and payrollingUK SRS readinessReference lettersCarbon reduction plan+ 101 more

What the calculator looks like

Late payment calculator template
What the calculator works outSheet or column in the calculator
The date to calculate interest to
✓
Calculate interest toToday, or the date of your letter
One row for each late payment
✓
Customer, Invoice number, Amount of the debtRoom for 100 invoices, amounts including VAT
When payment was due
✓
Agreed payment date, Invoice date (if no agreed date), Last day for paymentWith no agreed date, the last day of the 30 days from the invoice date
When interest starts and stops
✓
Interest starts, Date paid (blank if unpaid), Interest toStarts the day after payment was due, stops on the date paid
The right statutory rate for each debt
✓
Statutory rate8% over the base rate on 30 June or 31 December before interest starts
Interest so far and per day
✓
Days late, Interest, Daily interestYearly interest divided by 365, so you can quote the daily figure in a letter
The fixed compensation sum
✓
Fixed sum£40, £70 or £100 by the size of the debt, once for each late payment
What to claim in total
✓
Total to claim, Total interest, Total fixed sumsThe debt plus interest and fixed sum, or only the extras once the debt is paid
Base rates by half year
✓
RatesFrom 2023 to 2028, with yellow cells for each new rate
Mistakes caught as you type
✓
CheckMissing dates, a paid date after the calculation date, a missing base rate

When you need it

The Act gives a business the right to statutory interest and a fixed sum when another business pays late for goods or services, unless the contract already gives a substantial remedy for late payment. It does not apply to consumers. Use the calculator when:

  • A business customer has paid late and you want to claim interest on top
  • You are sending a final notice or letter before action and need the amount to the penny
  • A customer has paid the invoice late and you want to claim the interest and fixed sum on their own
  • You run credit control for clients and need the same sum worked out the same way each time

How to use the late payment interest calculator

  1. Enter the date to calculate to. Use today, or the date your letter will go out.
  2. Add each late invoice. Customer, invoice number and the amount including VAT, one row per invoice.
  3. Enter the payment date. Use the date agreed in the contract or on the invoice. If none was agreed, leave it blank and enter the invoice date.
  4. Add the date paid if the customer has paid. Interest stops on that date, and the total becomes the interest and fixed sum only.
  5. Keep the Rates sheet current. After 30 June and 31 December each year, enter the Bank of England base rate on that date. Debts that start earning interest in the next half year pick it up.

Questions

How is late payment interest calculated?

Multiply the debt by the statutory rate to get the yearly interest, divide by 365 for the daily interest, then multiply by the number of days late. On a £1,000 debt at 11.75%, that is about 32p a day.

What is the statutory late payment interest rate?

8% a year over the Bank of England base rate. The base rate used is the one in force on 30 June for interest that starts from 1 July to 31 December, and on 31 December for interest that starts from 1 January to 30 June. For interest starting from 1 July to 31 December 2026 the rate is 11.75%.

How much compensation can I claim for late payment?

A fixed sum once for each late payment: £40 for a debt under £1,000, £70 for a debt of £1,000 or more but under £10,000, and £100 for £10,000 or more. If your reasonable recovery costs are higher, you can claim the difference as well.

When is a payment late if no date was agreed?

30 days after the customer receives the invoice, or after you deliver the goods or service if that is later. Interest starts the day after.

Can I charge late payment interest to consumers?

Not under the Act. It covers contracts between businesses for goods and services. Interest on a consumer debt depends on what the contract says.

Is this the same as HMRC late payment interest?

No. HMRC charges its own interest on tax paid late. This calculator is for business customers who pay your invoices late.

Also in the debt recovery pack

Aged debtors reportChase lettersLetters before action

See the whole pack →

Who it's for

Accountancy practices chasing their own fees or running credit control for clients, and finance teams of small businesses.

Last checked

Checked against the Late Payment of Commercial Debts (Interest) Act 1998 and the Bank of England base rate history in November 2026.