Expense reports exist because businesses need a way to separate legitimate work costs from everything else. Without one, there’s no clear line between what the company owes an employee and what simply happened to be spent.
A template makes that line easier to draw. It standardizes what information is captured and how totals are calculated, so reviewers aren’t reorienting themselves with every new submission. It also reduces the errors that tend to creep in when each employee builds a report from scratch, like missing fields, inconsistent categories, and manual calculation mistakes.
Simple Expense Report Template by WordLayouts supports this process with a ready-to-use Excel template with automatic calculations and neat categories.
Download the template and use this guide to see how you can easily integrate this template into your payment processes.
What Is a Simple Expense Report?
A simple expense report is an internal document used to itemize business expenses incurred by an employee during a specified period and calculate the amount eligible for reimbursement or settlement.
Depending on the employer’s process, it may include the claimant’s details, reporting dates, business purpose, transaction information, receipt status, advances, review adjustments, and signatures. An expense report doesn’t independently prove that each cost is authorized or reimbursable.
Benefits of a Simple Expense Report
The following are the benefits of preparing a simple expense report:
- Supports the reimbursement review: A detailed breakdown helps the reviewer follow the claim quickly instead of receiving an unexplained final amount. They can check the calculation and approve or ask questions as needed, since the basic information is already organized in one place.
- Creates a traceable review record: Once completed, the report conveys information about the employee, the adjustments, and the approver. Storing it with the related receipts and payment record can help in retracing the transaction.
- Supports reconciliation and recordkeeping: The completed report provides a transaction summary that can be reconciled with reimbursement payments, card activity, and employee advances. It may be filed with the underlying evidence. However, it does not replace that evidence or determine the accounting or federal tax treatment of a cost.
Who Can Use a Simple Expense Report Template?
This template is primarily intended for HR, administration, and finance personnel who establish and manage an organization’s expense-reporting process. They configure the master copy, make it available to employees, and review completed reports. Employees complete individual copies, while managers or finance personnel review the reported expenses and record the approval decision. Contractors may adapt the template only where the organization accepts expense claims under its contractor workflow.
Key Features of Simple Expense Report Template?
Instead of drafting a report from scratch, we recommend users download and use the simple expense report template by WordLayouts. It’s two separate sheets: one for template configuration and one for expense-claim preparation. Apart from that, you can get the following benefits from it:
- Standardizes expense submissions: Employees use the company’s assigned report with proper fields and classifications instead of preparing claims in different formats. This is especially useful when several departments send reports to the same finance or administration team.
- Saves time: The template also saves preparation time without hiding the transactions inside a single total. An approver can compare one reported amount with one receipt or card entry, then move to the next row. If a personal portion or another excluded amount is found, it remains visible in the reimbursement summary.
- Calculates totals automatically: Built-in formulas calculate expense totals and determine the remaining reimbursable amount after accounting for advances and non-reimbursable expenses.
- Available in Google Sheets and Excel: The Google Sheets version is suitable when the sheet needs to be distributed via a shared link as per the organization’s workflow. The Excel version is preferred for file-based completion and storage.
A Walkthrough of the Simple Expense Report Template
The template’s working structure is divided between the Config sheet and the Expense Report sheet. Here is how you can set up the template and use it.
Config sheet
The Config sheet maintains separate lists for expense categories and payment methods. HR, administration, finance, or the responsible personnel can review these categories and make adjustments as per the organization’s policies. The instruction panels beside each list explain how the available options are applied when recording expenses in the report.
Users should note that these lists supply the Category and Payment Method dropdowns in the main report. Keeping them outside the transaction table allows the organization to establish consistent classifications across different submissions.
Company and employee information
The upper part of the Expense Report separates the organization’s information from the employee’s information.
The company block contains:
- Company Name
- Address
- Phone No.
- Email Address
The administration-related personnel may fill in the company-related information, adding the name, address, contact number, and email address.
They create a master sheet and share the file according to the company’s workflow. The employee can either download the Excel version or make a copy in Google Sheets to fill it.
The employee block contains:
- Employee Name
- Employee ID
- Department
- Designation
- Contact No.
- Email Address
This employee information identifies the person associated with the expenses and connects the report with the organization’s personnel or expense records. The employee typically completes this block when preparing an individual report.
Reporting period and business purpose
Report From and Report To define the period covered by the listed expenses. Each date entered under Expense Details needs to fall within that period.
These dates show when the expenses occurred. On the other hand, Date Submitted records when the employee provided the completed report for review. When a company reimburses an employee for legitimate business expenses, such as travel, meals, mileage reimbursement, or office supplies, the reimbursement is generally not considered taxable income if it follows an IRS-compliant accountable plan. The IRS treats expenses reported within 60 days after they are paid or incurred as substantiated within a reasonable period. Check IRS Publication 15 (2026) and Publication 463 (2025) for details on when something is considered wages and what classifies as a business expense.
However, this is a safe harbor, rather than a universal filing deadline. Follow the employer’s weekly, monthly, trip-based, or project-based reporting cycle rather than choosing dates simply to fit the available transactions.
The Purpose of Expense Report field provides the business context behind the costs. It may refer to a business trip, client meeting, conference, project, or another work-related activity. This context helps the reviewer understand why the transactions belong in the same report.
These fields are generally completed by the employee along with the expense information.
Expense details
The Expense Details table forms the main transaction record. Each row represents a separate expense, while the columns capture the information needed to identify and review it.
- Date: The date on which the transaction or purchase occurred.
- Category: It classifies the expenses. Choose the suitable option from the dropdown.
- Description: The item or service purchased and, where relevant, its connection to the stated purpose.
- Paid To: The merchant, vendor, or service provider that received the payment.
- Payment Method: It records how the transaction was funded, such as Cash, Credit Card or Company Card.
- Amount: The value of the expense incurred for that transaction. You may get this number from a receipt or invoice.
- Receipt: Select the checked box if a receipt is present against the transaction.
Expense and reimbursement summary
The summary brings together the financial effect of the transactions. The sheet automatically combines the amounts recorded in the expense table to give you Total Expense.
The Non-Reimbursable and Advance Received fields are completed manually according to the organization’s workflow. The employee may enter these amounts for review, or the organization may reserve the fields for finance or administration personnel to fill. The assigned reviewer can then confirm or adjust the entries.
Non-reimbursable may cover a personal portion or other policy-defined exclusions. Advance Received is also entered, as per the company’s policy. It is the amount that is provided before or during the expense activity.
Both non-reimbursable and advance received should be entered as positive values. The template automatically subtracts them from Total Expense to give you a Total Reimbursable. Read this value as the amount submitted after those adjustments, not as an automatic authorization for payment.
Submission information
The Submitted By section contains:
- Submitted By
- Signature
- Date Submitted
These fields identify the person presenting the report and record when it moved into the review process. Date Submitted is separate from the reporting period because the report may be prepared after the covered expenses have already occurred. This section is normally completed by the employee.
Review and approval
The final block contains:
- Approved By
- Signature
- Date Approved
This section records the decision of the manager, department head, finance representative, or other assigned reviewer. Keeping it separate from Submitted By distinguishes the employee’s submission from the organization’s approval.
Note that approval records the reviewer’s decision. It does not independently establish the tax or accounting treatment of an expense. If the approved reimbursement will be issued by check, an employee check request form can document the subsequent payment request.
Notes
The Notes section provides space for information that does not fit the information fields in the rest of the template. It may explain:
- Missing or separately stored supporting records
- Refunds or credits connected with a transaction
- Unusual expenses requiring context
- Amounts excluded from reimbursement
- Questions requiring attention during review
The wording already present in this area is sample content showing how supporting documents and travel details may be referenced. It does not form part of every expense report.
The employee may use this section to explain the submitted expenses. A manager or finance reviewer may also refer to it when recording the reason for an adjustment.
Customizing the Template
This template for expense reports is fully customizable and you can easily tailor it to your business requirements.
Add a claim or report number
A unique reference can connect the report with its approval and payment record. To add a number, you can include a column in the table.
State the reporting currency
The Amount and Summary fields display a dollar format, but the workbook has no currency label or conversion area. If employees incur costs in different currencies, identify the currency used for the report.
Add more expense rows
Additional rows may be added when more transactions need to be reported. Check that the dropdowns, receipt controls, automatic totals, formatting, and print layout continue to cover the extended area.
Apply company details and branding
Company information belongs in the master header. A logo can be added, and you can customize the colors to match your brand’s identity.
