Most travel expense report templates fail at the same moment, and it is never the one their author planned. The claim comes back three years later, an HMRC compliance review selects it, and somebody has to show that a hotel in Lisbon on a Tuesday in February was a business journey rather than a holiday. A travel expense report template with only columns for date, description and amount cannot answer that. One that was built to answer it will, without anyone having to reconstruct anything.
That is the whole difference between a travel expense report template and a pretty spreadsheet, and it is worth being precise because the phrase is used loosely for both. A template is not a document you fill in. It is the evidence system that lets a third party — an auditor, a tax office, a finance director who was not there — verify a claim without asking the person who made it. Everything below is built from what the two authorities that actually test these claims require: HMRC’s record-keeping rules for employers on one side, and the IRS accountable-plan and substantiation rules on Publication 463 on the other.
What a travel expense report template has to prove
Strip away the formatting and both regimes ask for the same four things. Did the expenditure have a business connection? When and where did it happen? How much was it? And has any excess over the real cost been returned? Every field in a travel expense report template earns its place by answering one of those, and a template with a column that answers none of them is decoration. The six blocks that follow are the ones that consistently do the work.
The US rules make this explicit. A reimbursement arrangement only avoids being treated as taxable wages if it operates as an accountable plan, and an accountable plan has to satisfy three conditions: business connection, adequate accounting, and the return of any excess. Fail any one of the three and the arrangement is nonaccountable, at which point the payments are reported as wages and become subject to income tax withholding and employment taxes. That is a large penalty for a missing field, which is why the structure of a travel expense report template is not a formatting preference — it is the difference between an exempt payment and a taxable one.
“Adequate accounting” has an equally specific definition, and it is the part most travel expense report templates misread. It is not enough to have records filed somewhere — the record must be “an account book, diary, log, statement of expense, trip sheet, or similar record maintained by the employee” in which each element of the expenditure is recorded at or near the time of the expenditure.
Reconstructing last year’s expenses in December from memory and a bank statement is not adequate accounting. It is the single most common reason a claim gets disallowed, and it is entirely avoidable by design — the requirement is that evidence is captured as it happens, which a travel expense report template can prompt but never substitute for.
Field one: the trip header, because it makes every line below it provable
The single most valuable block in a travel expense report template is the one at the top, and it is the one most often reduced to a name and a date. Four fields do an enormous amount of work:
- Who travelled — the employee, and the cost centre or department the trip is charged to.
- When — departure and return dates, which together determine the number of days any per diem or subsistence limit will be calculated against.
- Where — the destination, and every intermediate country if the itinerary crosses more than one.
- Why — the business purpose, in a sentence that would still make sense to a stranger in three years.
HMRC is explicit that where you reimburse travel expenses you need to keep a record of when and why the employee travelled, and where possible the receipts as evidence. That “when and why” lives in the header, and it is what lets a reviewer judge whether an item further down the sheet belongs to this trip at all.
An item with no header context is an item that has to be argued for; an item sitting under a dated, reasoned trip is self-explanatory. Any travel expense report template worth adopting will make you complete this block first, before a single line of expenditure, because everything below it depends on it. It is four fields, completed once per trip, in exchange for every line beneath them being defensible.
Write the business purpose before the trip, not after. “Client site visit — quarterly review” is a purpose. “Travel” is a destination label. A travel expense report template cannot rescue a purpose that was never stated, and retrofitting one from the calendar invite is how a claim ends up describing a trip in language that matches nothing the employee actually did.
Field two: date, place and amount on every line
Each expense line needs its own date, its own place and its own amount. This is the least glamorous requirement in the whole exercise and the one that does the most work, because it is what both authorities test first. The US regulations require each element of the expenditure — time, place and amount — to be recorded, and where a receipt does not establish all of them, the claim is exposed regardless of how well documented the rest of the sheet is.
A travel expense report template that lets a single line stand in for a whole trip is therefore not saving anyone time. It is manufacturing the exact gap a reviewer will find.
The corollary is that a single row cannot cover several items. “Dinner, 14–16 Feb, €85” covering three days and two cities fails on all three elements at once. Three rows, one per date, pass. The extra rows cost seconds and are the difference between a travel expense report template whose claims survive review and one whose do not.
Place means the actual place, not the country of the trip’s headline destination. A taxi in Brussels on a trip billed to a London office is Brussels. The distance between the two matters because place is what connects an expense to a journey, and a location the trip never touched is a location the reviewer will query.
Getting these three right is unglamorous, and it is the part of a travel expense report template that determines whether anything else on the sheet survives contact with a reviewer. None of the three is hard to capture. All three are only hard to capture late.
Field three: the currency and rate, recorded at the time
Travel expense report templates that handle more than one currency need four separate columns, not one: the amount as spent, the currency code, the exchange rate used, and the amount in the reporting currency. Collapsing these into a single converted figure is the most common failure in international claims, and it fails in a particularly annoying way — the arithmetic can be perfect and the claim can still be wrong, because nothing on the sheet records which rate was used or when.
Recording the rate is what makes the conversion auditable. A rate that can be reconstructed from a published source on a given date is defensible; a rate that exists only inside a spreadsheet formula is not, because the rate moves and the formula silently changes with it. Write the rate into the row as a value, not as a reference to a live feed. The cost is that you must remember to update it deliberately. The benefit is that a claim submitted in March still describes the conversion that actually happened in February.
There is a related point about receipts in foreign currency. The amount on the receipt is in the local currency; the amount you claim may be in another. Keeping both, on the same line, is the difference between a substantiated claim and a claim that depends on the reviewer trusting a conversion.
HMRC’s guidance is that records should be kept in their original form — for example, where an employee hands over a receipt to back a signed expenses form, both items must be kept even if the information is transferred onto a computer. A travel expense report template that replaces the paper with a spreadsheet is not in breach of that rule so long as the paper survives, but one that treats the spreadsheet entry as the record and bins the receipt is. Digitising is not destroying, and the distinction is worth stating explicitly in whatever policy accompanies a travel expense report template.
Field four: which expenses were claimed against a rate rather than a cost
This is where travel expense report templates most often misrepresent what they are, and the distinction has real consequences in both regimes. A sheet that claims per diem against actual receipts, or vice versa, cannot support either treatment, because the reviewer cannot tell which basis each payment rests on.
A per diem or a mileage allowance is not a record of what you spent. It is a substitute for spending, sanctioned at a published rate in place of itemising every cost, and a travel expense report template has to say which of the two it is recording. The US treatment is that an amount paid under a per diem is deemed substantiated without receipts — provided the employee still substantiates the time, place and business purpose of the travel — and only if the allowance is at or below the applicable federal rate.
Above that rate, the excess is taxable as wages. The GSA per diem rates are published by locality and by fiscal year, and you must use the same table consistently across the return you are filing. A travel expense report template that lets someone pick a rate by eye is therefore not a convenience — it is an uncontrolled liability.
HMRC draws the same line from the other direction. If an employer pays a round sum allowance for business travel, that is not regarded as a reimbursement of actual expenditure, and the whole allowance should be treated as gross pay for PAYE purposes — unless HMRC has agreed, in an approval notice, that the payment was clearly intended to do no more than reimburse an expense actually incurred. An allowance is therefore not a simplification of the claim. It is a different claim with a different test attached, and only a travel expense report template that records which one is being claimed can satisfy either.
So the template needs to distinguish, per line or per day, between substantiated actual cost and rate-based allowance, and to record the rate applied. A travel expense report template that treats them as the same number cannot support an accountable plan, because it cannot demonstrate which basis each payment rests on — and that is the difference between a payment that is exempt from tax and one that is reported as wages.
Field five: mileage, split at the threshold that actually matters
For anyone claiming for their own vehicle, the rates are published and the arithmetic is exact — which is precisely why the template should not be doing it by hand. Mileage is the easiest number on the sheet to get right and the easiest to get wrong, because the rate depends on both the distance band and the date.
UK approved mileage allowance payments for cars and vans are 55p per business mile for the first 10,000 miles in the tax year and 25p for each mile over, following an increase from 45p effective 6 April 2026. Motorcycles are 24p and bicycles 20p throughout. The AMAP rate is advisory — an employer can reimburse more or less — but anything paid above it is taxable to the employee as pay, and anything paid below it may be reclaimed through Mileage Allowance Relief. The rate belongs in a travel expense report template as a dated value, not in a staff member’s memory.
The US standard mileage rate moved twice inside 2026: 72.5 cents per mile from 1 January, then 76 cents from 1 July. The split matters, because an allowance straddling 1 July may fall under two different rates, and the applicable one follows both when the mileage was incurred and when the employee was paid. A travel expense report template that applies a single annual rate to the whole claim will be wrong for every trip spanning that boundary.
Two further details belong in the field itself rather than in a footnote. The business miles must be business miles, not total miles driven — the ordinary commute is not claimable, and an audit will reconstruct your route. And the vehicle’s value can disqualify the rate-based method entirely: for 2026 you cannot use the cents-per-mile rule for a vehicle first made available to an employee for personal use in 2026 worth more than $61,700. A travel expense report template that does not capture which vehicle was used cannot apply either test.
Field six: the receipt, with an honest status
US rules set the receipt threshold in a way that surprises people, because lodging is treated differently from everything else. Documentary evidence is required for expenditure for lodging while away from home in the United States, and for any other expenditure of $75 or more — with the exception that for transportation charges documentary evidence is not required where it is not readily available. Lodging therefore needs a receipt at any value; everything else gets a $75 threshold, and a travel expense report template that applies one rule to both will be wrong about whichever it gets wrong.
The regulations also describe what a sufficient receipt looks like, and it is a short list worth building into a travel expense report template as a checkbox: amount, date, place, and the essential character of the expenditure. A hotel receipt showing separately for lodging, meals and telephone satisfies it. A restaurant receipt should carry the number of people served and an indication where the charge is something other than food and drink. A cancelled cheque by itself establishes nothing about business purpose. Baking those four elements into a travel expense report template means the traveller learns them once, rather than each reviewer rediscovery them per claim.
UK practice runs along the same lines: keep the receipt as evidence wherever possible, and keep it in original form. A travel expense report template should therefore carry a receipt status per line rather than a single attachment at the end — attached, lost, not applicable, or claimed on a rate basis — because “lost” is a fact the reviewer needs and an empty cell does not tell them. A claim that declares a lost receipt is a claim that can be assessed; a claim with a blank is one that has to be sent back.
Where the two systems meet on a trip like this
If you are combining a business trip with personal time, the reporting does not get simpler. HMRC’s position is that tax relief is only available for subsistence costs attributable to the business travel — costs additional to what you would ordinarily have incurred — and that relief is not available for expenditure arising from your personal circumstances, such as a babysitter. The rules on taking no account of savings from not making the ordinary commuting journey work the same way.
Which is the practical reason a well-built travel expense report template has a mixed-use field rather than a totals field. A trip that is four days business and three days personal needs the claim to be split at the boundary, with the personal days excluded from the per diem calculation and the personal elements excluded from the claim. A template that asks for a trip total makes that split difficult to express, and a split that is difficult to express is a split that does not happen.
Our guide to business travel packages covers how the wider programme is usually structured, and executive air travel is where the highest-value claims — and therefore the ones most likely to be reviewed — tend to concentrate. Those are the claims where the cost of getting a travel expense report template wrong is measured in four figures rather than in goodwill.
What the travel expense report template is actually for
Pull the six fields together and the shape of a defensible travel expense report template becomes obvious. It is a header that frames the journey, a set of rows where each one independently establishes time, place and amount, a currency block that survives exchange rate movement, a rate block that distinguishes actual cost from allowance, a mileage block that applies the right rate to the right period, and a receipt block that records status honestly rather than attaching everything at the end and hoping.
That structure serves the traveller too, and not only the auditor. A claim built from the evidence at the time is faster to assemble and much faster to approve, because the reviewer is checking rather than reconstructing. Our guide to travel expense tracking covers the day-to-day mechanics of capturing costs as they happen, which is the part that makes or breaks the rest of this.
If the trips being reported are corporate rather than personal, the surrounding framework usually matters as much as the sheet. Corporate travel planning covers how policy gets set before anyone books anything, and corporate travel management companies covers the outsourcing option — both of which determine how much discretion a travel expense report template actually has to accommodate. Where spend is being benchmarked against the market, business travel market is the relevant comparison.
On the cost of getting it wrong, the two regimes again agree. Where reimbursed expenses were not covered by an exemption and tax and National Insurance were not deducted, HMRC will normally ask the employer to account for them; in the US the same failure reports the amounts as wages subject to withholding. The expense was paid by the business either way. The tax treatment of it is not optional, and no travel expense report template can fix a claim after the fact — it can only avoid creating one.
Questions worth asking before you adopt a travel expense report template
Seven questions, each of which has an answer somewhere in the rules rather than in opinion:
- Does it record the business purpose of the trip, and is that purpose stated before the trip rather than reconstructed after?
- Does every expense line independently carry its own date, place and amount?
- Can it hold a foreign-currency amount, a currency code, the rate used and the converted figure as separate fields?
- Does it distinguish actual cost from a per diem or mileage allowance, and record which rate applied?
- Does it split mileage at the first-10,000-mile threshold, and can it handle a claim that straddles a rate change?
- Does it record a receipt status per line rather than a single attachment list?
- Does it support a mixed business-and-personal trip, so the personal days can be excluded rather than quietly claimed?
The bottom line
A travel expense report template is not a document. It is the standing answer to a question nobody has asked yet: can you show that this money was spent, on what, where, when, and why? The authorities that test these claims want four things — business connection, time, place and amount, plus the return of any excess — and every field in a good template exists to supply one of them.
Read the rest as a specification rather than a checklist of nice-to-haves. Each of the six fields below exists because a specific rule somewhere requires the evidence behind it.
Build it so the evidence is captured at the time, because “at or near the time of the expenditure” is the actual standard and a reconstruction is not a record. Record the exchange rate as a value rather than a formula. Keep mileage split at the threshold, and across a rate change. Distinguish what you spent from what you were allowed, because those are different claims with different tests. And keep the receipt in its original form, which in both systems is a requirement rather than a preference.
Get those six fields right and the travel expense report template stops being the place where claims go to be questioned. It becomes the reason they do not have to be — which is the cheapest compliance control available to any organisation that spends money on travel.