Reviewed & updated by WordNExcel Team — Updated November 6, 2026
An expense report is the form an employee uses to claim back money spent on work, such as travel, hotels, meals with clients, supplies and mileage in a personal car. It lists each cost, groups it by category, takes off any cash advance and shows how much the company owes. On this page you can download five free expense report templates in Excel: a standard expense report with category totals, a mileage log, and a weekly travel expense report laid out by day, plus a weekly expense report and a team expense summary.
Every file is a real, editable .xlsx spreadsheet. Type in the yellow cells and the formulas add up each category, the total claim, the advance and the reimbursement due. This page also has a free expense report calculator for a quick total before you fill in the full form.
Expense Report Calculator
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is an Expense Report?
An expense report, also called an expense claim or reimbursement form, is a record of business costs an employee has paid personally. The employee lists each expense with the date, a description, the category and the amount, attaches receipts and signs the form. A manager checks and approves it, and the finance team pays the employee back.
Expense reports matter for everyone involved:
- Employees get back the money they spent on behalf of the company.
- Managers can see what is being spent and check it against policy.
- Finance teams can record costs in the right accounts and keep receipts for audits and tax.
- The business controls travel and entertainment spending.
Download Free Expense Report Templates
The templates open in Microsoft Excel, Google Sheets and LibreOffice Calc. Enter your details in the yellow cells; everything else is calculated.
1. Expense Report Template

A general expense claim for any period. The header records the employee, department or manager, the claim period and the purpose. The table has fifteen rows for the date, description, category and receipt, plus the amount. Category and receipt are drop-down lists, with travel, lodging, meals, supplies, phone and other as the categories. Below the table, SUMIF formulas total each category, and the summary shows total expenses, less cash advance, reimbursement due, any amount owed back to the company and the number of items without a receipt. Signature lines for the employee and approver finish the form.
2. Mileage Log

For employees who use their own car for work. Enter the driver, the vehicle and the rate per mile or kilometre once at the top. Each of the twenty trip rows records the date, from, to, purpose, start odometer and end odometer. The log works out the distance and the amount for each trip, and shows "Check" if the end reading is lower than the start. Totals at the bottom give the distance driven and the total mileage claim. A note reminds you to use the rate in your company policy or the one your tax authority publishes.
3. Weekly Travel Expense Report

Built for business trips. Enter the traveller, the trip and the week starting date, and the seven day columns fill in automatically, Monday to Sunday. Rows cover airfare or train, lodging, breakfast, lunch, dinner, taxi or car hire, fuel or parking, conference fees, phone or internet and other costs. Each row and each day is totalled, and the summary takes off any advance to show the balance due. A negative balance means money is owed back to the company.
4. Weekly Expense Report

A simple one-week claim sheet for an individual. Enter each date, description, category (travel, meals, office, software, lodging or other), amount and whether a receipt is attached. Rows without a receipt are highlighted so managers can query them before approving. The header holds the employee, week starting date, department and a total. Submit it with photo receipts every Friday. It is lighter than a full travel report when most costs are local.
5. Team Expense Summary

Rolls individual claims into one view for the manager. Enter each employee’s totals for travel, meals, office and other; the row total calculates. Mark Approved Yes, No or Query. The header shows the team total and how many rows still need approval. Use it before the payroll or accounts payable cut-off so nothing sits in limbo. Filter for No or Query to chase people who have not replied.
How to Fill In an Expense Report
- Download the template that matches your claim and save a copy for the period.
- Enter your name, department, manager and the claim period.
- Add each expense on its own line with the date, a clear description, the category and the amount.
- Mark whether you have a receipt for each item.
- Enter any cash advance you were given before the trip.
- Check the category totals and the reimbursement due.
- Attach receipts, scanned or photographed, in the same order as the lines.
- Sign the form and send it to your manager for approval.
What to Include on an Expense Report
- Employee details: name, ID, department and manager.
- Period and purpose: the dates covered and the business reason.
- Itemised expenses: date, description, category and amount.
- Receipts: a receipt for each item, or a note explaining why one is missing.
- Mileage: trips, distances and the rate used.
- Advances: any money paid to the employee in advance.
- Totals: by category and overall.
- Approval: employee and manager signatures and dates.
Expense Categories Explained
- Travel: flights, trains, buses, taxis, car hire, fuel, parking and tolls.
- Lodging: hotel rooms and other accommodation, usually with the room rate and taxes.
- Meals: meals while travelling and meals with clients, often with daily limits.
- Supplies: items bought for work, such as stationery or small equipment.
- Phone and internet: business calls, roaming charges or hotel Wi-Fi.
- Other: conference fees, training, postage or anything that does not fit elsewhere.
Use the same categories as your accounting system so that finance can post the costs quickly. You can change the drop-down list under Data, Data Validation.
Tips for Faster Approval
- Submit on time. Many companies set a deadline, such as 30 days after the expense.
- Keep receipts as you go. Take a photo of each one straight away.
- Write clear descriptions. "Taxi from airport to client office" is better than "Taxi".
- Note who attended client meals and the business reason.
- Follow the policy on hotel rates, meal limits and class of travel.
- Separate personal items. Do not claim minibar, personal calls or upgrades you chose yourself.
- Check the maths and the totals before you submit.
Tracking Mileage Correctly
If you drive your own car for work, record each trip on the day. Note the start and end odometer readings, the places and the purpose. Your normal commute between home and your usual workplace is usually not claimable, but trips from the office to clients, suppliers or other sites usually are. The mileage rate covers fuel, wear and insurance, so you normally cannot also claim fuel receipts for the same trips. Check your company policy and local tax rules for the rate and what counts as business mileage.
For Managers and Finance Teams
When you review an expense report:
- Check that each expense has a business purpose.
- Compare amounts with the expense policy.
- Match the receipts to the lines.
- Look at items without receipts and ask for an explanation.
- Approve, query or reject items and sign the form.
- Pass it to finance for payment, usually with the next payroll or by bank transfer.
Keep approved reports and receipts for as long as your local tax rules require.
Writing a Simple Expense Policy
An expense report works best alongside a short written policy. It should explain what can be claimed, the limits for hotels and meals, which receipts are needed, the mileage rate, the deadline for submitting claims and who approves them. Share the policy with the template so employees know the rules before they spend. Review the limits each year, since hotel and travel prices change.
Expense Report or Corporate Card?
Some businesses give employees a company card so that costs are paid directly. Even then, an expense report is still useful: employees list each card transaction, add the business purpose and attach the receipt, and the report is used to reconcile the card statement. The standard template works for this too. Add a column for "Paid by" with options such as personal card, company card or cash, and only the personal items will need reimbursement.
Common Expense Report Mistakes
- Claiming the same expense twice, for example a hotel paid by card and also listed from the receipt.
- Mixing several trips on one report without dates, which makes approval slow.
- Forgetting to deduct the cash advance.
- Claiming fuel and mileage for the same journey.
- Missing the deadline, so the claim falls into a later pay period.
- Leaving out the business purpose for client meals and entertainment.
Related Templates
You can also check these useful templates like the marketing budget plan templates for planning spending, and the employee timesheet templates for tracking hours.
You may also like the purchase order templates and the checkbook register templates.
Frequently Asked Questions
What is an expense report?
A form an employee uses to claim back business costs paid personally. It lists each expense with date, category and amount, attaches receipts and shows the reimbursement due.
What should be included in an expense report?
Employee details, the period and purpose, itemised expenses with receipts, mileage, any cash advance, totals and approval signatures.
How do I calculate mileage reimbursement?
Multiply the business distance driven by the mileage rate. The mileage log does this for each trip using the end odometer minus the start odometer.
What if I lost a receipt?
Mark the item as "No" in the receipt column and add a note. Many companies accept a short written explanation for small amounts, but check your policy.
Can I use these expense report templates in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and drop-down lists keep working.
