Tools & templates
Free Excel template and checklist for travel expense reports
Key takeaways
- A valid expense report rests on 12 columns and one receipt per line.
- VAT must be split by rate, otherwise it cannot be reclaimed.
- Number your receipts: the 'document ref' column is what saves an audit.
- Budget ~10 minutes per trip in Excel, versus a few seconds when scanning.
Here is the complete checklist for a travel expense report and the exact Excel template structure to copy into your spreadsheet — then an honest look at what those columns really cost you every month.
What you will learn
- The complete checklist to tick before sending an expense report.
- The exact Excel template structure, column by column.
- Useful formulas and the most frequent spreadsheet mistakes.
- What a spreadsheet will never do for you.
The checklist before you send your expense report
Before any table, there is a list of checks. A rejected expense report is almost always rejected for one of these reasons, not for the substance of the spending. Run through it every time: it takes a minute and avoids back-and-forth.
- Identity and period: claimant's name, month concerned, purpose of the trip in one clear sentence.
- One line per expense: never group 'miscellaneous meals' across a whole week.
- Exact date of each expense, the one on the receipt and not the day you typed it.
- Gross amount copied to the cent from the receipt, not rounded.
- VAT split by rate, with the matching net base.
- Nature of the expense: meal, accommodation, toll, fuel, transport, supplies.
- Business reason: client visited, site, trade show, assignment — one word is enough, but it must exist.
- Receipt attached and numbered, with the same number carried into the table.
- Payment method: company card, personal card to reimburse, cash.
- Mileage calculated at the current scale, with route, distance and vehicle rating.
- Verified total: the table sum must match the total of the receipts, to the euro.
- Signature or approval from the manager, then archiving of the whole set for ten years.
A reimbursement with no attached receipt can be reclassified as additional pay, with social contributions on top. The 'document reference' column is not decorative.
The Excel template: structure column by column
This template is deliberately classic: it works in any spreadsheet, transmits easily to an accounting firm, and covers ordinary business travel. Create one sheet per month and copy the header below onto the first rows.
Document header
- Cell A1: 'Expense report — [Full name]'.
- Cell A2: period concerned, for example 'August 2026'.
- Cell A3: purpose or assignment, for example 'Client visits — southern region'.
- Cell A4: company, department and any file or site number.
The table columns
- A — Date (DD/MM/YYYY, the one on the receipt).
- B — Document ref (number written on the receipt itself).
- C — Nature (meal, accommodation, transport, toll, fuel, supplies).
- D — Supplier (retailer name exactly as printed).
- E — Reason / client (assignment, site or client visited).
- F — Gross amount.
- G — Net base 10% and H — VAT 10%.
- I — Net base 20% and J — VAT 20%.
- K — Payment method (company card, personal card, cash).
- L — Reimbursable (yes / no, to isolate spending already paid by the company).
The mileage block
Mileage allowances deserve their own table underneath the first, because they carry no VAT and follow an annual scale.
- Date, route (from → to), reason, distance in kilometres.
- Vehicle tax rating and the scale rate applied.
- Amount = distance × rate, produced by formula rather than by hand.
Formulas for the bottom of the table
- Gross total: `=SUM(F5:F200)`.
- Total recoverable VAT: `=SUM(H5:H200)+SUM(J5:J200)`.
- Consistency check: `=SUM(G5:G200)+SUM(H5:H200)+SUM(I5:I200)+SUM(J5:J200)-SUM(F5:F200)`, which must display 0.
- Total to reimburse: sum of rows marked 'yes' in column L, via `SUMIF`.
The spreadsheet mistakes that cost the most
- Duplicates: the same receipt entered twice, once by you and once by the accountant, inflates deducted VAT.
- The row outside the range: an expense added on row 201 while the formula stops at 200 vanishes from the total.
- Amounts pasted as text: they are not added up, and the total still looks credible.
- An average VAT rate applied to a multi-rate receipt, distorting the return both ways.
- An unsaved local file: a lost drive takes the only trace of three months of expenses with it.
- Unnumbered receipts: six months later, nobody knows which line matches which slip.
What Excel will never do for you
A spreadsheet is an excellent container, but it does not read your receipts, does not spot a duplicate, does not know a date is inconsistent, does not warn you that a document is missing, and does not keep the receipt image next to the row. All that verification work stays on your desk, every month, indefinitely.
Let us do the arithmetic honestly. Ten minutes per trip between collecting, typing, splitting VAT and hunting missing documents. Thirty trips a month is five hours. Over a year, more than sixty hours spent retyping figures already printed on paper sitting in your pocket.
That calculation is exactly what tips most freelancers over: the Excel template is not bad, it is simply the last place where information a camera can read in two seconds is still typed by hand.
The alternative: the same report, without typing
ScanCompta keeps the structure above and removes the keyboard. You photograph the receipt, the AI extracts the date, supplier, gross amount and VAT split, the expense files itself into the right client folder, and the image stays attached to the line as evidence.
At month end, the export produces exactly the table described above — columns, split by rate, mileage, verified totals — together with the receipt images. The accountant gets a clean file, and you never opened a spreadsheet.
- Automatic extraction of date, supplier, amount and VAT.
- Duplicate detection before saving.
- Mileage calculated at the current scale, route included.
- Monthly CSV + images export, ready for the accounting firm.
In short
The checklist and template above are enough to produce a flawless expense report, and you can copy them straight into your spreadsheet. Just keep in mind what they really cost: a few dozen hours a year of manual entry that a photo now replaces in two seconds.
Questions & comments
A question about this guide? Ask below — I answer personally within one business day.
- J
Julien
August 12, 2026
If I lose a €9 toll receipt, can I still claim it with just a bank statement?
ScanComptaAuthorYes — for a small amount, a bank statement plus a signed statement is usually accepted. You cannot reclaim VAT without the original receipt though.
- S
Sonia
August 3, 2026
Do I need to keep the paper receipts after scanning them with your app?
ScanComptaAuthorNo. If the scan is a faithful and durable copy, the digital version is enough. We store everything for 10 years for you.
The stray-receipt challenge
Curious how the AI handles it? Take a photo of the receipt lying on your desk and test the extraction in 2 seconds, no account needed.
Try the scan live
No account needed. Nothing is stored.
No account needed. Nothing is stored.
Frequently asked questions
What details must a travel expense report contain?
The claimant's name, the date and purpose of the trip, each expense with its date, nature, gross amount and matching VAT, the payment method, and the reference of the attached receipt. Without these, a reimbursement can be reclassified as a taxable benefit.
Is an Excel template enough for a small business?
It is enough while volume stays low and receipts are archived alongside. The file becomes a liability as soon as you need last year's receipt, several VAT rates or duplicate control: Excel checks nothing on your behalf.
Do I still need paper receipts if everything is in Excel?
Yes, unless the receipts are digitised in conditions that guarantee the integrity and legibility of the copy. The spreadsheet alone carries no evidential value: proof comes from the document attached to each line.
How much time does an Excel expense report really cost?
Between collecting receipts, typing line by line, splitting VAT, hunting missing documents and back-and-forth with the accountant, budget roughly ten minutes per trip. Over thirty trips a month, that is half a working day spent retyping figures that were already printed.
Spending too much time on your expense receipts?
Try ScanCompta for free — 5 scans a month, no card required.