UK Expense Report Generator

What a compliant expense claim should contain

There is no single statutory UK expense-report form, but the underlying records must be sufficient to show that expenditure was genuinely incurred for the business. Record the claimant, date, supplier, amount, currency, category, business reason and who paid. For travel, retain the destination, route and reason for the journey. Separate a company-card payment from an amount personally paid by the claimant so it is not reimbursed twice.

Receipts should support the report wherever possible. HMRC asks employers to retain evidence showing how each expense or benefit was treated. Employer expense and benefit records are generally kept for three years after the end of the relevant tax year, while VAT records and invoices are generally retained for at least six years.

• Use a unique report number and define the claim period.
• Reference the receipt or VAT invoice against the matching line item.
• Show the original currency and the exchange rate used for foreign costs.
• Record advances and company-paid items separately from reimbursable expenses.

VAT receipts and reclaim

A reimbursement is not automatically a VAT claim. The business must be VAT-registered, the purchase must be for its taxable business activities, and it normally needs valid VAT evidence. A card slip or bank statement proves payment but is not necessarily a VAT invoice. Enter the gross amount and choose whether VAT is included, added, exempt or entered manually; the report then shows the recoverable-tax figure separately.

Mixed business and private expenditure, entertainment, blocked input tax and simplified invoices can require different treatment. The calculator organises the figures but does not replace checking the invoice and the business-use rules.

HMRC mileage rates for 2026/27

For journeys from 6 April 2026, the approved car and van rate is 55p for the first 10,000 business miles in the tax year and 25p thereafter. Motorcycles use 24p per business mile and bicycles 20p. A qualifying passenger payment for a fellow employee is 5p per passenger per business mile.

The threshold applies across qualifying business mileage in the tax year, not afresh to every report. Ordinary commuting between home and a permanent workplace is normally private travel. Keep the journey date, start and end points, mileage and business purpose; the mileage template captures those details and calculates the tiered amount.

Create and approve the report step by step

1. Choose basic, itemised, mileage or mileage-and-per-diem format.
2. Complete employer, claimant, report date, period and cost-centre fields.
3. Enter one line per receipt and use the receipt reference to preserve the audit trail.
4. Mark costs paid directly by the company so they remain visible but are excluded from reimbursement.
5. Check VAT, mileage, advance and amount-due totals, then export the approved record.

Excel, PDF or Word expense report template?

An Excel expense report is useful for finance teams that want to filter categories or import data. PDF is better for a fixed approval record. Word can work for a short narrative claim but is error-prone for totals. This tool produces PDF, genuine Excel and CSV from the same data, so there is no need to maintain separate templates.