An expense report template with formulas lets you record business expenses, calculate reimbursement amounts, and total a report without adding each line by hand. Use the blank template below in a spreadsheet or print it, then enter expenses consistently and check that the formulas match your organization’s reimbursement rules.
What an Expense Report Template Includes
An expense report is a record of costs an employee or other authorized person paid while carrying out work-related activities. A useful report identifies who is submitting it, the period covered, what each expense was for, and how much reimbursement is requested. It also gives a reviewer enough detail to understand and verify the entries.
At a minimum, a line-item table generally needs a date, merchant or payee, business purpose, category, and amount. A receipt or reference field helps connect the entry to supporting documentation. The template below also includes a column for any portion that is not being claimed, so its formula can calculate the amount requested for reimbursement.
Keep the report to one currency unless your organization has a process for recording and converting multiple currencies. A currency label in the report heading makes the unit clear. If a report combines currencies without a defined conversion method, its total can be misleading.
Expense Report Template With Formulas
Blank template
Employee: ____________________ Department: ____________________ Report period: ____________________
Approver: ____________________ Currency: ____________________ Submission date: ____________________
| Date | Merchant or payee | Business purpose | Category | Payment method | Receipt or reference | Currency | Gross amount | Not claimed | Reimbursement requested |
|---|---|---|---|---|---|---|---|---|---|
| =H2-I2 | |||||||||
| =H3-I3 | |||||||||
| =H4-I4 | |||||||||
| =H5-I5 | |||||||||
| =H6-I6 | |||||||||
| Total | =SUM(H2:H6) | =SUM(I2:I6) | =SUM(J2:J6) | ||||||
Formula setup: Enter expenses in rows 2 through 6. Column J calculates gross amount minus the amount not claimed. The total row adds each amount column. If you add more lines, copy the column J formula down and expand each total formula to cover the new rows. In some spreadsheet settings, a formula may require semicolons instead of commas between arguments; the SUM formulas shown here have only one range argument.
Sample only — fictional details: An entry dated 2026-04-08 for a fictional supplier, Northstar Paper, might say ‘printed meeting handouts’ under business purpose, ‘office supplies’ under category, and show 42.50 in gross amount, 0.00 not claimed, and 42.50 requested. These details are illustrative, not a reimbursement rule.
How the Formulas Work
The line formula in column J is =H2-I2. It subtracts the amount marked not claimed from the gross amount on that row. For example, if a 60.00 expense includes 10.00 that the submitter is not requesting, the requested amount is 50.00. Copying the formula down changes the row references, so the next line uses H3 and I3.
The summary formulas add the values in each column: =SUM(H2:H6), =SUM(I2:I6), and =SUM(J2:J6). The requested total should equal gross total minus the not-claimed total, assuming every line has been entered consistently. The spreadsheet’s formula cells should contain formulas rather than typed totals; otherwise, later edits will not automatically update the result.
These formulas do not decide whether an expense qualifies for reimbursement. They only perform arithmetic on the amounts entered. An employer may have rules about eligible categories, documentation, limits, approvals, or timing, so confirm the applicable process before submitting a report.
How to Fill In and Submit the Report
Completing the report in a consistent order makes it easier to review and reduces avoidable corrections. A practical workflow is:
- Enter the employee or submitter, reporting period, currency, and other identifying details.
- Add one expense per row, using the transaction date and a concise description of its work purpose.
- Choose a category and payment method that match the organization’s instructions.
- Enter the full amount paid in the gross amount column, then record any portion not being claimed in its own column.
- Attach or identify the supporting receipt or reference using the required submission method.
- Check the calculated line amounts and totals against the underlying records before sending the report for approval.
Use a clear business purpose rather than a label that merely repeats the category. ‘Taxi’ identifies a type of purchase; ‘travel from the station to the client meeting’ explains why it was incurred. A reviewer should not have to infer the connection to work from a merchant name alone.
Choosing Categories and Recording Receipts
Categories make reports easier to sort, compare, and review. Common examples include travel, meals, lodging, transport, office supplies, and training, but the right list depends on the organization. Use an approved category list where one exists. Too many overlapping labels can make reporting inconsistent, while one broad category for everything makes meaningful review more difficult.
Receipt requirements also vary. The template’s receipt or reference column can hold a file name, document number, or other pointer; it does not itself store the receipt. Keep the supporting record in the required location and make the reference specific enough to find it. If a receipt is unavailable, follow the organization’s process for explaining or documenting that situation rather than assuming the blank field is sufficient.
For a purchase that covers more than one purpose or category, follow the organization’s method for splitting or describing it. If the report needs additional detail, add a note or an extra field instead of disguising several transactions as one unexplained amount. For personal information or sensitive details, include only what the review process requires and use an appropriate submission channel.
Common Formula and Reporting Problems
A formula can produce a correct answer from incorrect or incomplete inputs, so reviewing the arithmetic alone is not enough. Common issues include:
- Amounts stored as text: A value pasted with symbols or unusual spacing may not behave like a number. Check whether the spreadsheet recognizes the cell as numeric.
- Formula not copied down: A new row may show no requested amount if its formula was not extended. Copy the formula and verify its row references.
- Total range stops too soon: If new entries are added below row 6, the sample total formulas will not include them until their ranges are expanded.
- Duplicate expenses: The same receipt or transaction may be entered twice. Compare dates, amounts, and references to identify possible duplicates.
- Mixed currencies: A sum of amounts in different currencies is not a meaningful single-currency total without an approved conversion process.
- Incorrect not-claimed entry: If the not-claimed amount exceeds the gross amount, the requested formula becomes negative. Check the source amount and the intended treatment.
It is also easy to confuse the amount charged to a payment card with the amount an employee personally paid. Record the transaction according to the requested report method, and distinguish amounts already paid directly by the organization from amounts for which reimbursement is being requested. If the organization needs that distinction, add a separate payment-status field rather than trying to infer it from the total.
Spreadsheet, Printable, or Digital Form?
A spreadsheet is useful when formulas, sorting, or repeated reporting periods matter. It can recalculate totals when entries change and can be adapted with additional rows or columns. Its main limitation is that formulas and ranges can be overwritten or left incomplete, especially when a user copies only part of a worksheet. Protecting formula cells, if available, and checking totals after edits can help prevent accidental changes.
A printed template can be easier for someone who prefers handwriting or needs a paper record, but printed pages will not calculate totals automatically. The user must complete the arithmetic and check it independently. A digital form may guide people through required fields, but its setup and submission features depend on the system used. Choose the format that fits the actual review process, not simply the one with the most features.
Whatever the format, retain a clean copy of the blank template and avoid reusing a completed report by merely changing its heading. Starting with a fresh copy helps prevent old entries, formulas, or attachments from carrying into a new reporting period.
Adjusting the Template for Your Process
The blank version is intentionally generic. An organization may need fields for a project, client, location, approval status, or payment date. Add only fields that support a real reporting or review need, and use consistent labels so different submitters interpret them the same way. If a field is mandatory, make that instruction clear near the form rather than relying on users to guess.
To extend the sample spreadsheet, insert additional expense rows before the total row or copy the existing line formulas into new rows. Then update the SUM ranges so every entry is included and the total row remains below the data. Test the revised sheet with a few clearly marked example amounts, verify the expected result, and remove the examples before distributing the blank copy.
Keep policy decisions separate from arithmetic. A formula can apply a defined calculation, such as subtracting a non-claimed portion, but it should not silently encode a rule about eligibility or approval unless the organization has deliberately specified that rule. Requirements can differ by workplace and location; for a situation involving tax or legal treatment, ask a qualified professional.
Frequently Asked Questions
What formula calculates the reimbursement amount for each expense?
With gross amount in column H and not-claimed amount in column I, use =H2-I2 in J2, then copy it down. Change the cell references if your columns are arranged differently.
What formula adds the total reimbursement?
For requested amounts in J2 through J6, use =SUM(J2:J6). Expand the range whenever you add expense rows beyond row 6, or the new entries will be excluded from the total.
Can I use the template without a spreadsheet?
Yes. Print the blank table and write in the details, but calculate each requested amount and the totals manually. Check the arithmetic before submitting because the printed version cannot update formulas.
Should the report include tax?
That depends on the organization’s reporting instructions and the type of transaction. The sample template records the gross amount without defining how tax should be treated. Follow the applicable process or ask a qualified professional if tax treatment is unclear.
What should I do if I have more expenses than the template rows?
Add rows and copy the line formula down, then extend the total formulas to include every entry. Keep the total row outside the expense range so it is not accidentally counted as another expense.