About the Expense Report Generator
This expense report generator turns a list of receipts into a clean, totalled reimbursement report. Type one expense per line as “date | category | description | amount”, add the business miles you drove in your own car, and enter any cash advance you already received. The report totals each category, adds mileage at the per-mile rate, subtracts the advance and shows exactly how much the company owes you — or how much you owe back.
It is built for employees submitting travel and client-visit expenses, contractors billing out-of-pocket costs to a client, and small-business owners who want a tidy record for their books. The finished report appears as plain text you can paste into an email or your company’s form, and the itemized table and category chart print cleanly from your browser.
The default mileage rate is the IRS business standard mileage rate of 76 cents a mile for miles driven from July 1, 2026 (it was 72.5 cents from January 1 to June 30, 2026); change it if your employer uses its own rate. Under an IRS accountable plan, reimbursements are tax-free to employees only when each expense has a business purpose, is substantiated with receipts or records, and any excess advance is returned — so keep your receipts.
With the default inputs, the reimbursement due is $818.48. Change any value above to recalculate instantly.
How to use the expense report generator
- 1Enter your name, department or client, business purpose and the report period.
- 2List each expense on its own line as Date | Category | Description | Amount.
- 3Add business miles driven in your own vehicle and check the mileage rate.
- 4Enter any cash advance you already received.
- 5Copy the report text or print the page, attach receipts and submit it for approval.
Formula and method
Each line’s amount is added to the itemized total and to its category subtotal. Mileage for business driving in a personal vehicle is miles × the per-mile rate, rounded to the cent, and is shown as its own category. Any cash advance received before the trip is subtracted to give the amount still owed to the employee; a negative result means the employee should return the difference.
The default rate is the IRS business standard mileage rate for the second half of 2026 (76 cents a mile from July 1, 2026). The per-mile rate is meant to cover fuel, maintenance, insurance and depreciation, so do not also claim fuel receipts for the same miles. Parking and tolls can be listed as separate expenses.
- rate
- Reimbursement rate per business mile
- advance
- Cash advance paid before the expenses were incurred
Worked examples
Three-day client trip with an advance
Six receipts total $1,082.00 and 48 miles to and from the airport at 76¢ add $36.48, for $1,118.48 in expenses. After the $300 advance, the company owes $818.48. Airfare is the largest category at $412.60.
Local sales calls, mileage only
Using the first-half-2026 IRS rate of 72.5¢, 212 business miles are worth $153.70. Adding $18 parking and a $54.30 lunch gives $226.00, all due back because no advance was taken.
Advance larger than spending
Expenses come to $142.50 against a $200 advance, so the result is −$57.50: the employee should return $57.50 to the company.
Frequently asked questions
What should an expense report include?+
List the date, category, description and amount of each expense, the business purpose, the period covered, mileage with distance and rate, any advance received, and the net amount due. Attach receipts and get a manager’s approval signature.
What is the IRS mileage rate for 2026?+
The IRS business standard mileage rate is 72.5 cents per mile for miles driven January 1 to June 30, 2026, and 76 cents per mile from July 1, 2026, after a mid-year increase. Employers may reimburse at a different rate.
Are expense reimbursements taxable?+
Not when they are paid under an accountable plan: the expense must have a business connection, be substantiated within a reasonable time, and any excess advance must be returned. Reimbursements that fail those tests are treated as taxable wages.
Do I need receipts for every expense?+
For tax purposes the IRS generally requires documentary evidence such as receipts for lodging and for other expenses of $75 or more, plus a record of the amount, time, place and business purpose. Many employers require receipts for every item.
Can I claim gas if I am reimbursed for mileage?+
No. The per-mile rate already covers fuel, oil, maintenance, insurance and depreciation. You can, however, claim business parking fees and tolls separately.