Free Excel template and checklist for travel expense reports

What does an accountant really look at?

An expense report is almost always rejected on form, never on substance. A client lunch is legitimate, so is a hotel night; what causes trouble is an approximate date, a rounded amount or a receipt nobody can find. Before opening a spreadsheet, it helps to understand the reasoning of whoever reviews your document: they are trying to connect every reimbursed euro to a specific piece of paper, and to confirm the spending had an identifiable business purpose.

In practice that means four things. Each expense takes its own line, with the exact date printed on the receipt rather than the day you typed it in. The amount is copied to the cent, never rounded, and VAT is split by rate with its net base alongside. The business reason fits in one word — a client name, a site, a trade show — but it has to exist, otherwise the expense can no longer be tied to the activity. Finally, every line points to a numbered receipt, and that number also appears on the paper or image you archive.

This last point is the most often skipped and the most risky. A reimbursement with no attached receipt can be reclassified as additional pay, with social contributions on top. The 'document reference' column is not decoration: it is what turns your table into a defensible file the day somebody asks you to produce a two-year-old expense.

A good habit: write the number on the receipt as you enter it, then carry it straight into the table. Six months later, nobody will be able to reconstruct the order any other way.

What does the Excel template look like?

The template below is deliberately classic: it opens in any spreadsheet, transmits without discussion to an accounting firm, and covers ordinary business travel. The header takes your name, the period concerned and the purpose of the assignment; below it, one sheet per month and one line per expense.

The table below is directly editable: click a cell, replace the examples with your own expenses, add as many rows as you need, then download the matching .xlsx file.

How do you download the ready-to-use template?

The file uses exactly the columns above, with totals already formulated at the bottom, a control row that must display zero if your VAT splits are consistent, and a second sheet for mileage where the amount calculates itself from the distance and the scale rate.

What spreadsheet mistakes cost the most?

The most frequent one is the duplicate: the same receipt entered once by you and once by the accountant, quietly inflating deducted VAT without any warning. Next comes the row added outside a formula's range — the expense is visible, but it has vanished from the total, and the file still looks perfectly credible.

Two other traps show up constantly. Amounts pasted from a banking app sometimes land as text: they display normally but are never added up. And on a receipt mixing several rates, applying an average VAT rate distorts the return in both directions, which is worse than a rounding error.

Finally there is the silly risk: the file kept locally and never backed up anywhere. A lost drive takes the only trace of several months of expenses with it, and no formula will save you. A synced cloud folder, with the receipt images alongside, solves that in ten minutes.

What will Excel never do for you?

A spreadsheet is an excellent container, but it does not read your receipts. It does not spot a duplicate, does not notice an inconsistent date, never warns you 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. Between collecting receipts, typing line by line, splitting VAT and hunting missing documents, a single trip costs about ten minutes. 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 what tips most freelancers over. The Excel template is not bad, it has simply become the last place where information a camera reads in two seconds is still typed by hand.

How do you get the same report without typing?

ScanCompta keeps the structure described 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. Duplicates are flagged before saving, and mileage is calculated at the current scale from the route you enter.

At month end, the export produces exactly the table you just saw — same columns, same split by rate, same verified totals — together with the receipt images. The accountant gets a clean file, and you never opened a spreadsheet.

What should you remember?

The template above is enough to produce a flawless expense report, and you can download it then adapt it freely to your business. Just keep in mind what it really costs: a few dozen hours a year of manual entry that a photo now replaces in two seconds.

Frequently asked questions

Read next

• Mileage allowance 2026: scale and calculator
• Expense report software: how to choose
• Several VAT rates on one receipt
• Automate your expense reports with ScanCompta