Excel Expense Report Template Generator
Build an expense report workbook with a date and category per line and a total ready to submit.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | EXPENSE REPORT | |||||||
| 2 | ||||||||
| 3 | Employee | Department | Report number | EXP-001 | ||||
| 4 | Employee Name | Department | Period start | |||||
| 5 | Address line 1 | Address line 1 | Period end | |||||
| 6 | Address line 2 | Address line 2 | ||||||
| 7 | Email / phone | Email / phone | ||||||
| 8 | ||||||||
| 9 | Date | Category | Description | Qty | Unit cost | Amount | ||
| 10 | =IF(COUNT(D10,E10)=2,D10*E10,"") | |||||||
| 11 | =IF(COUNT(D11,E11)=2,D11*E11,"") | |||||||
| 12 | =IF(COUNT(D12,E12)=2,D12*E12,"") | |||||||
| 13 | =IF(COUNT(D13,E13)=2,D13*E13,"") | |||||||
| 14 | =IF(COUNT(D14,E14)=2,D14*E14,"") | |||||||
| 15 | =IF(COUNT(D15,E15)=2,D15*E15,"") | |||||||
| 16 | =IF(COUNT(D16,E16)=2,D16*E16,"") | |||||||
| 17 | =IF(COUNT(D17,E17)=2,D17*E17,"") | |||||||
| 18 | =IF(COUNT(D18,E18)=2,D18*E18,"") | |||||||
| 19 | =IF(COUNT(D19,E19)=2,D19*E19,"") | |||||||
| 20 | =IF(COUNT(D20,E20)=2,D20*E20,"") | |||||||
| 21 | =IF(COUNT(D21,E21)=2,D21*E21,"") | |||||||
| 22 | =IF(COUNT(D22,E22)=2,D22*E22,"") |
Preview of the first 22 rows. Cells shown as =SUM(...) are live formulas in the downloaded workbook, not pasted numbers.
What you get
- •One row per expense with date, category, description, and amount.
- •An employee and reporting-period block at the top.
- •A total that sums every line, plus an optional tax line for reclaimable amounts.
- •Dates formatted as yyyy-mm-dd so they sort correctly regardless of locale.