Free template

Expenses claim form template (Excel)

A working Excel expenses claim form for an employee or director claiming back what they paid for the business. List each receipt with its date, category, net and VAT, add any business miles, and the claim sheet totals it by category for the period, works out the mileage, and gives one figure to be repaid with space to sign. Free, no sign-up and no email address.

Download the template (.xlsx)

What is in it

SheetOne row perWhat it does for you
ExpensesReceipt or journeyDate, what it was for, a category from a dropdown, the receipt number, net amount and VAT. The total is added up for you. A journey in your own vehicle goes in as miles, and the sheet prices it at the rate on the claim.
ClaimCategoryYour name, the claim period and the mileage rate, then receipts by category, the VAT within them, miles and the mileage claim, and the total to be repaid, with lines for the claimant and the approver to sign.

How to fill it in

Put your name and the first and last day of the claim on the Claim sheet. Then add one line to the Expenses sheet for each receipt: number the receipt, write the same number on the line, and enter the net amount and the VAT as they appear on it. If a receipt shows no VAT, leave VAT empty or enter 0 and put the whole amount under net.

Only lines dated inside the claim period are counted, so one file can hold a year of claims: change the two dates and the claim sheet shows that month alone.

Mileage

A journey in your own car is not claimed from a fuel receipt. Enter the business miles on a line of their own and the sheet multiplies them by the rate at the top of the Claim sheet. The rate is set to 55p a mile, which is HMRC's approved rate for cars and vans for the first 10,000 business miles in a tax year from 6 April 2026. Change it if your employer pays a different rate, if you have passed 10,000 miles, or for a motorcycle or bicycle. For a full record of journeys, use the mileage log template.

Why the receipt number matters

Whoever approves the claim, and later whoever does the books, needs to get from a line to the piece of paper behind it. A number written on the receipt and typed on the line does that. Keep the receipts with the signed claim. Whether the VAT on a receipt can be reclaimed by the business depends on having a valid VAT receipt and on what was bought, which is a question for HMRC's guidance or an accountant; this form records it and does not decide it.

When the receipts are a pile

If you approve claims for a team, or you are catching up on months of your own, typing every receipt is the slow part. Invoices to Spreadsheets reads a folder of receipts and invoices, including phone photos, into one checked table with the date, supplier, net, VAT and total, which you can export to Excel and paste in. Try one free, without an account.

Is the expenses claim form free?

Yes. Download it, use it, change it. No account, no email address, no card.

What mileage rate does it use?

It is set to 55p a mile, HMRC’s approved rate for cars and vans for the first 10,000 business miles in a tax year from 6 April 2026. The rate is one cell on the Claim sheet; change it and every mileage line follows.

Can I use one file for several months?

Yes. Keep adding lines to the Expenses sheet. The Claim sheet counts only lines dated between the two dates at the top, so set those to the month you are claiming for.

Can I change the categories?

Yes. Rename a category in the dropdown on the Expenses sheet and in the list on the Claim sheet, using the same words in both, so the totals still match.

Does it work in Google Sheets or Numbers?

Yes. It is a standard .xlsx file using SUMIFS, with an ordinary dropdown. Set your locale to United Kingdom before importing so dates are read day first.

Start my free trial

7 days · 50 documents · No card needed

All free tools and templates · Business mileage log template · Petty cash log template