Expense Report
Travel, meals, hotels and mileage in one table. The summary is already set up to print on A4, with space for signatures.
File preview: click the tabs at the bottom to switch sheets
=SE(E7="";"";E7*F7)| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | foglio=furboNota spese | |||||||
| 2 | Celle verdi: da compilare · grigie: calcolate (protette) · dati di esempio | |||||||
| 3 | data | categoria | descrizione | importo_eur | km | tariffa_km_eur | rimborso_km | totale_riga |
| 4 | 03/02/2027 | Trasferta | Treno Milano–Bologna A/R | 59,80 | 59,80 | |||
| 5 | 03/02/2027 | Vitto | Pranzo con cliente | 32,00 | 32,00 | |||
| 6 | 03/02/2027 | Alloggio | Hotel, 1 notte | 89,00 | 89,00 | |||
| 7 | 10/02/2027 | Km | Visita cliente a Bergamo | 104 | 0,42 | 43,68 | 43,68 | |
| 8 | 12/02/2027 | Altro | Parcheggio | 8,50 | 8,50 | |||
| 9 | 17/02/2027 | Km | Fornitore a Brescia | 186 | 0,42 | 78,12 | 78,12 | |
What's inside
| 1. Istruzioni | The steps to follow, what to fill in and what not to touch. |
| 2. Spese | Date, category, description, amount, km and rate, with the refund calculated. |
| 3. Riepilogo stampabile | Total per category, header, signatures, A4 print area. |
Works with
Excel 2019 and Microsoft 365
Windows and Mac, .xlsx file. Formulas use Italian function names and the ; separator.
Google Sheets
Built in Sheets, not converted. "Make a copy" link, from your phone too.
No macros
No VBA or Apps Script to enable: it works as soon as you open it.
Tested before it's sold
Excel for Windows, Excel for Mac and Google Sheets. No errors on an empty file.
Questions about this template
Answers to the questions we get most often about the Expense Report.
We reply within 2 working days.
Write to usDoes it work out mileage?
Yes. Enter the kilometres and the rate per km and the refund is calculated for you. Your company sets the rate (in Italy often from the ACI tables).
Does it print well?
The printable summary sheet already has an A4 portrait print area, a header and space for signatures.
Can I use it every month?
Yes. Duplicate the file, or clear the rows and change the period in the header.
You might also need
"Organize 2027" Bundle
All 5 templates in one purchase: save €10.70.
2027 Goals Planner
Goals and progress month by month, with a status that updates itself.
2027 Leave and Attendance
Team holidays and leave, with 2027 public holidays and working days counted.