Expenses Claim Form Excel - Free Template

1. Open the Claims sheet and enter the claimant, claim date and expense lines. Use one row per item so the form stays readable and easy to total.
2. Choose the expense category from the list rather than typing your own wording. That keeps the records consistent when you review several months of claims.
3. Add amounts, mileage or VAT details where needed, then check the totals before approval. A £147.60 claim with three receipts is much easier to verify when each line is separated.
4. Use the Summary sheet to review claims by period or claimant. That is the quickest way to see whether one person has submitted £400 of fuel in a month.
5. Refer to the Lists sheet if you need the standard options used in the drop-downs. This is the part that keeps coding and terminology stable.
6. Follow the Instructions sheet when you hand the file to a colleague. It tells them how to enter claims without breaking the format.

The Claims sheet is for the person who has spent money on behalf of the business or organisation and wants paying back cleanly. In practice, that is often an office manager in a trades firm, a bookkeeper at a small Ltd, a charity treasurer or a self-employed assistant claiming back business travel.

Image 1 shows the Claims sheet set out like a paper form on screen, with the title across the top and a wide input area below it. Because the sheet is frozen at row 3, you can keep the header visible while you work through a batch of claims.

Typical claim situations

A builder with 4 employees might submit 12 mileage and parking claims after a week of site visits, while a club secretary may only process 6 claims at month end. The same workbook also works for a sole trader who has £186.40 of train fares, lunch and tolls to reclaim before the month-end bookkeeping run.

Why the structure matters

The point is speed without losing the audit trail. If you are approving 20 lines at £18.50 each, you need to see the claimant, the date and the reason in one place rather than chasing email attachments.

If the claim feeds into your accounts, you need supporting records that show what was spent, when, and why it was business-related. For HMRC purposes, companies keep records for 6 years, and the self-employed keep records for 5 years after the 31 January Self Assessment deadline that follows the tax year.

Image 2 is the Summary sheet, which is where the totals are pulled together for review. That is useful when you need to see £1,248.60 of claims for March or check whether mileage and receipts have been separated properly before posting.

Mileage, VAT and reimbursement

If you pay mileage, the standard approved rate is 45p per mile for the first 10,000 miles and 25p per mile after that. So 180 business miles would normally be £81.00 at the main rate, while a £64.00 hotel bill may carry VAT at 20% if the supplier charged it and you are entitled to reclaim it.

Practical record detail

The workbook is most useful when the claim includes the date, supplier or journey, the amount paid, and whether a receipt exists. If you are VAT-registered and reclaiming tax, you need the VAT amount shown separately on the receipt or invoice, not just one combined total.

Those VAT details are easiest to confirm when the supplier’s bill is tracked alongside the claim in an invoice record.

The usual problem is not the total, it is the missing detail. A claim for £214.75 with no receipt, no mileage breakdown and no business reason can leave you paying twice, rejecting the claim, or spending 20 minutes reconstructing the evidence from email and bank statements.

Image 3 shows the Lists sheet, which helps reduce entry mistakes by keeping the choices fixed. That matters because a typo in a category can split what should be one total into two, and a small business doing 30 claims a month will feel that quickly at month end.

Typical errors

A mileage claim without the start and end points may be challenged, especially if someone has submitted 420 miles in a week and the journey pattern looks odd. A VAT reclaim on a receipt that does not show VAT separately can also be lost, which is frustrating when the claim total is only £37.80 but the bookkeeping work has already been done.

The real cost

The real cost is usually time and cash flow. If 8 claims are held back for clarification, and each one takes 10 minutes to fix, you have lost well over an hour before the payment run even starts.

That kind of delay quickly feeds into bookkeeping records, where each missing detail has to be chased before the payment run can move on.

The workbook works best when you tie it to a fixed routine. Most small firms do better if claims are checked once a week, or on the same day as payroll or supplier payments, rather than letting receipts pile up for a month.

Image 4 is the Instructions sheet, which gives you the simple operating notes. That is the part to hand to new staff so they know how to enter claims in the same way every time.

Simple habits that keep it alive

• Set one weekly cut-off, such as Friday at 4.00 p.m., so claims arrive in a batch.
• Copy the previous month’s file structure instead of starting again, which saves setup time.
• Use the Lists sheet to stop category drift, especially when 15 people are all describing the same expense differently.
• Check totals before approval so you catch mistakes while the receipt is still in front of you.

Once you are dealing with several hundred claims a month, or needing workflow approval and live attachments, you have outgrown a spreadsheet and should move to an expense system. For a small team with 5 to 20 claimants, though, this workbook is usually the simplest way to keep control.