Free Expense Report Template Generator

How to make an expense report

Making an expense report with this expense report template takes five short steps.

1. Add your header and branding. Upload a logo, add your company name and address, and set the report title. A short business purpose line, like "Client kickoff trip", tells the approver why the costs were incurred.
2. Fill in the report details. Enter who submitted the report, the manager it goes to, an optional employee ID and department, the reporting period, and the currency. The report number auto-fills as ER-10001 and stays fully editable.
3. Add your expenses. For each cost, add a row with the date, category, description, merchant, and amount. Use the Mileage category to log miles and let the tool calculate the amount for you.
4. Pick a template and style. Choose from 20 templates, spanning clean, corporate, elegant serif, ledger, dark, and vibrant looks. Then set an accent color, a font, and your date format.
5. Download. Export a print-ready PDF for US Letter, a crisp PNG, or a CSV that opens in Excel and Google Sheets.

The live preview updates as you type, so the report you see is the report you download.

What to include on an expense report

A good expense report is easy to scan and quick to approve. Include these parts.

• Company name and logo. Put your employer at the top so the report is clearly tied to the business.
• Who submitted it and their manager. The approver needs to know whose costs these are and who signs off.
• A report number and reporting period. These make the report easy to file and match to a trip or month.
• Line items with a category. Each expense needs a date, a category, a description, a merchant, and an amount. Categories let you total by type.
• Mileage, if you drove. Log the miles and let the rate do the math instead of adding up receipts by hand.
• A subtotal, cash advance, and reimbursement due. These three figures tell the approver exactly what to pay.
• An approval and signature line. A place to sign turns the sheet into an official reimbursement record.

Expense categories that cover most trips

The generator ships with the categories most companies use: Airfare, Lodging, Meals & Entertainment, Ground Transport, Mileage, Fuel, Office Supplies, Client/Marketing, and Other. Each category rolls up into a summary so you and your approver can see, for example, that lodging was $324.00 and meals were $126.40 at a glance. Grouping by category also makes the report easier to code into your accounting software later.

How mileage reimbursement is calculated

Mileage is one of the most common expense claims, and it is easy to get wrong by hand. Pick the Mileage category on a row and enter the miles you drove. The tool multiplies the miles by the mileage rate you set at the top of the report. So 48 miles at a rate of $0.67 per mile becomes $32.16, added straight into your subtotal. You can change the rate to match your company policy or the current IRS business rate. Nothing is rounded away, so the numbers always add up.

How the totals work

The math is simple and always visible.

• Subtotal is the sum of every line item, including mileage.
• Cash advance is any money the company paid you before the trip.
• Reimbursement due is the subtotal minus the cash advance.

If you were given a $150 advance and spent $1,050, the reimbursement due is $900. If the advance was larger than what you spent, the figure goes negative, which means you owe the balance back to the company. Blank amounts never break the total, so a half-finished report still shows a clean number.

Expense report vs invoice vs receipt

These three documents get mixed up often, but they do different jobs.

• An expense report is internal. An employee or contractor uses it to claim back money they already spent for the company, grouped by category with an approval line.
• An invoice is external. A seller sends it to a customer to request payment for goods or services.
• A receipt is proof of a single payment. You attach receipts to an expense report as evidence for each line.

Use the expense report to get reimbursed, an invoice to get paid by a client, and a receipt to prove a purchase happened.

Expense report template for Excel and printing

Many people search for an expense report template excel file or a printable expense report template. This tool covers both without the fragile formulas of a spreadsheet. Export the CSV to open your line items in Excel, Google Sheets, or Numbers, where you can sort and filter them. Export the PDF for a printable version that fits US Letter paper, ready to sign and file. Because the report is generated fresh each time, you never fight with a broken template or a stray formula.

Tips for a report that gets approved fast

• Be specific in the description. "Client dinner, 3 people" is easier to approve than "food".
• Match the merchant to the receipt. Approvers cross-check merchant names against attached receipts.
• Keep the period tight. One trip or one month per report is easier to review than a mixed pile.
• Round nothing yourself. Enter the exact amount from the receipt and let the tool total it.
• Use mileage instead of fuel when you drove your own car. Most policies reimburse mileage, not gas, for personal vehicles.

Frequently asked questions

What is an expense report?

An expense report is a document that lists the business costs an employee or contractor paid out of pocket, so the company can review and reimburse them. Each line shows the date, category, description, merchant, and amount. Totals roll up by category and end in a reimbursement due figure. Companies keep expense reports for bookkeeping, budgeting, and tax records.

How do I make an expense report with this generator?

Add your company name and logo, fill in who submitted the report and their manager, then add a line for each expense with its date, category, description, merchant, and amount. Add a Mileage row and the tool multiplies your miles by the rate. Pick one of the 20 templates, set an accent color, font, and date format, then download a PDF, PNG, or CSV. The preview updates as you type.

Is this expense report template really free with no watermark?

Yes. It is 100% free with no signup and no watermark on any export. You can create and download as many expense reports as you like as a print-ready PDF, a PNG, or a CSV. Your data never leaves your browser because the whole tool runs client-side.

How does the mileage reimbursement work?

Choose the Mileage category on any row and enter the miles you drove. The tool multiplies the miles by the mileage rate, which you can edit at the top of the report details. The default rate follows the common IRS-style business rate, but you can set any rate your company uses. The computed amount flows into the subtotal and the category summary automatically.

Can I import expenses from a spreadsheet or Excel?

Yes. Use the CSV import to upload a file with Date, Category, Description, Merchant, and Amount columns, and the rows populate the table instantly. Download the sample CSV first to see the exact format. You can also paste tabular lines straight from Excel or Google Sheets, and the Export CSV button gives you a spreadsheet-ready copy back.

What is the difference between an expense report and an invoice?

An expense report is an internal reimbursement document. An employee or contractor uses it to claim back money they already spent on the company's behalf, grouped by category with an approval line. An invoice is an external billing document that a seller sends a customer to request payment for goods or services. Use the expense report to get reimbursed and an invoice to get paid by a client.

How is the reimbursement due calculated?

The tool adds every line item to get a subtotal, including any mileage rows. It then subtracts the cash advance you enter, which is money the company already paid you before the trip. The result is the reimbursement due, the net amount the company still owes you. If the advance is larger than the subtotal, the figure goes negative, meaning you owe money back.

Can I use this for a non-profit or a printable expense report?

Yes. The tool works for any organization, including non-profits, freelancers, and small businesses. Add your categories, fill in the line items, and pick a clean template. The PDF prints cleanly on US Letter paper, so you get a printable expense report you can sign, scan, or file with your accounting records.