← All prebuilt solutions
Bookkeeping & Compliance

VAT Bad Debt Relief Tracker

Know when you can reclaim the VAT on unpaid invoices – and when you must repay VAT on supplier bills you have not paid

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

VAT Bad Debt Relief Tracker

Overview

When a customer does not pay, you have still paid HMRC the VAT on the invoice. Bad debt relief lets you claim that VAT back once the debt is at least six months overdue. The same rules work in reverse: if you claim VAT on a supplier's invoice and do not pay it within six months, you must repay that VAT.

Price
£20
Who it’s for
Bookkeeping & Compliance
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

Unpaid Sales

Each unpaid invoice with its eligible date and VAT to reclaim. What you do: one row per invoice.

Unpaid Sales
Unpaid Purchases

Step 2

Unpaid Purchases

Supplier invoices unpaid for six months. What you do: one row per invoice.

Step 3

Settings

The check date and time limits. What you do: set for each return.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • VAT-registered businesses with unpaid invoices – Reclaim the VAT you have already paid HMRC.
  • Bookkeepers preparing VAT returns – Know what to include each quarter.
  • Accountants – Check bad debt relief and input VAT repayments.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Set the check date – usually the end of the VAT period you are preparing.
  2. Unpaid Sales – Enter each unpaid invoice, any part payments, and confirm the output VAT was paid and the debt written off in your VAT records.
  3. Unpaid Purchases – Enter supplier invoices you have not paid.
  4. Dashboard – Add "Reclaim now" to box 4 and "Input VAT to repay" to box 1 (or deduct it from box 4) on your VAT return.

Key features

  • Lists unpaid sales invoices and works out the date each becomes eligible for VAT bad debt relief and the last date you can claim.
  • Calculates the VAT you can reclaim (1/6 of the unpaid amount at 20%) and tells you which invoices to claim on this return.
  • Tracks unpaid supplier invoices and warns when you must repay input VAT because a bill has been unpaid for more than six months.

What’s included

  • Dashboard – What to claim and repay
  • Settings – Check date and time limits
  • Unpaid Sales – Bad debt relief on your invoices
  • Unpaid Purchases – Input VAT to repay
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal 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 file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

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