← All prebuilt solutions
Tax & Company

HMRC Penalty & Interest Calculator

Work out what being late really costs – and whether to appeal

£20

Secure checkout. Your download link is sent as soon as payment clears.

HMRC Penalty & Interest Calculator

Overview

Late returns and late payments are expensive, and since 2025 the rules have become tougher: late payment interest went up to Bank Rate plus 4%, VAT late payment penalties increased, CT600 late filing penalties doubled from April 2026 and Making Tax Digital for Income Tax brings a new points-based system. This workbook puts every rule in one place. Enter the dates and amounts and it works out each penalty and the interest day by day across every HMRC rate change, keeps a running log of up to 200 items with your total exposure, and helps you decide whether a penalty is worth appealing.

Price
£20
Who it’s for
Tax & Company
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Penalty Log

The running log of up to 200 items – the heart of the workbook. What you do: set the as-at date and enter the yellow columns.

Penalty Log
Self Assessment

Step 2

Self Assessment

Late filing and late payment penalties plus interest for one tax return, and a cost-of-delay chart. What you do: enter the return's dates and tax.

Step 3

VAT

Penalty points for late returns, and late payment penalties with part-payments and Time to Pay. What you do: enter your returns and one late payment.

VAT
Corporation Tax

Step 4

Corporation Tax

CT600 late filing penalties (old and doubled amounts) and late payment interest. What you do: enter the period end and filing / payment dates.

Who it is for

Made for people like you

  • Example – text
  • Business owners – A clear figure for what being late is costing – and what it will cost if you wait another month.
  • Bookkeepers & payroll bureaux – PAYE, CIS and VAT penalty checks across all your clients, with appeal deadlines flagged.
  • Accountancy practices – A client penalty log, quick checks of HMRC penalty notices and a reasonable excuse checklist.
  • Anyone with a penalty notice – A way to check HMRC's figures and the 30-day appeal deadline before paying.

Quick start

Up and running in minutes

  1. Example – text
  1. Set the as-at date – At the top of the Penalty Log, leave the as-at date blank to use today, or enter a date to see what the position will be then. Anything not yet filed or paid is worked out up to this date.
  2. Log each item – Add one line per late return, late payment or interest charge: who it's for, the penalty type, the due date, the date filed or paid (blank if not yet) and the amount.
  3. Fill in Count and Option where needed – Some penalty types need one extra fact – points already held, the number of employees, whether it's the third late return in a row. The grey 'What Count / Option mean' column tells you what to enter.
  4. Read the Dashboard – See total exposure, what's still outstanding and growing, open appeal windows and the breakdown by penalty type and client.
  5. Use a calculator for detail – For a single item, the calculator sheets show every step – when each penalty kicks in, how points build up, and the interest for each rate period.
  6. Check the appeal – Before paying a penalty, run through the Appeal Checklist. You normally have 30 days from the date on the penalty notice.

Key features

  • A running log of up to 200 penalties, points and interest charges across all your clients or businesses, with total and outstanding exposure.
  • Calculators for Self Assessment, VAT points and late payment, corporation tax, PAYE, CIS, Companies House and MTD for Income Tax – dates in, penalty and interest out.
  • Late payment and repayment interest worked out day by day across every HMRC rate change, with the full rate history from 2016.
  • Updated for the April 2025 interest and penalty increases, the doubled CT600 penalties from April 2026 and the 4% late payment penalties from April 2027, plus a reasonable excuse appeal checklist.

What’s included

  • Dashboard – Exposure at a glance
  • Penalty Log – Your running log of up to 200 items
  • Self Assessment – Late filing, payment & interest
  • VAT – Points tracker and late payment
  • Corporation Tax – CT600 penalties and interest
  • PAYE – Defaults and late FPS
  • CIS – Monthly return penalties
  • Companies House – Late accounts penalties
  • MTD Income Tax – Points and new late payment rules
  • Interest – Day-by-day interest calculator
  • Appeal Checklist – Reasonable excuse and 30-day deadline
  • Rates & Rules – Rates and rules used
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions