Expense Report Generator

How to use the expense report generator

1. Enter the employee, optional department, purpose and the period the report covers.
2. Add each receipt under Expenses with a date, a category, a description and an amount. Use Add expense for more rows.
3. Add driving under Mileage with a date, the route and the miles. Type your mileage rate in dollars per mile. The tool prices each trip.
4. If you received a cash advance, enter it to see the amount due to you or owed back.
5. Check the totals, then press Download PDF, Print, Download CSV or Copy totals.

How mileage and totals are worked out

Each trip is priced as miles multiplied by your mileage rate, then rounded to the nearest cent with halves rounded up. Because each trip is rounded on its own, as it appears on the report, the total can differ by a cent from pricing all the miles at once. For example, at a rate of 0.655 dollars per mile, 123.4 miles is 80.83 and two trips of 10.1 miles are 6.62 each, which makes 94.07 in total. The same 143.6 miles priced together would be 94.06.

The total is all expenses plus mileage. Category totals are shown for Travel, Lodging, Meals, Ground transport, Supplies and Other. With a cash advance, the report shows the amount due to the employee when the total is larger, or the amount owed back when the advance was larger. In the example, expenses of 303.94 and mileage of 94.07 total 398.01, and after a 100.00 advance the amount due is 298.01.

The mileage rate is whatever you enter. The value shown when you open the tool is an example only. Your employer, client or tax authority sets the rate that applies, and that rate can change, so use the current one from your own policy or the official source.

Making a report that gets approved

Reports are approved faster when every line is easy to check. Give each expense a short description that says what it was and who or what it was for, keep the date of the receipt, and attach the receipts themselves, since the report only lists them. Group a trip together with one purpose line, such as Client visit, so the approver sees the reason at a glance.

The printed report lists expenses and trips in date order, followed by a summary and two signature lines, one for the employee and one for the approver. Reports of up to 100 expenses and 60 trips fit, and long reports continue onto extra pages with repeated headings.

Limits and privacy

This is a layout and a calculator, not a policy. It does not know what your employer reimburses, per-diem limits or tax rules, and it is not tax or legal advice. Everything is processed in your browser, nothing is uploaded, and saved entries, if you tick Remember, stay on this device. To work out reimbursement for a single trip, use the mileage reimbursement calculator.

Assumptions and limits

• The mileage rate is entered by you in dollars per mile with up to three decimals. The example value shown is not an official rate.
• Each trip is rounded to the cent before totals are added, using half up rounding. Pricing all miles at once could differ by a cent.
• Amounts are US dollars with up to two decimals. Negative amounts, such as a refund, are allowed on expenses.
• Reimbursement policy, per-diem limits and tax treatment are not modeled. Check your employer's rules.

Formulas reviewed October 10, 2026. See the calculation methodology for how SumPanda rounds, tests and sources its formulas.

Frequently asked questions