An expense report template is a very useful document to keep track of business expenses for an employee’s business trip, a particular department, or any project for a company. It provides a quick track of expenses and relevant documentation.
This template can be used for reimbursement purposes for business trips and can also be helpful to analyze expenses pertaining to a specific department or a project.
Thus, the analytical study of expenses can be useful for companies to cut down costs on unnecessary expenses and increase profits.
Expense Report Excel Template
I have created a simple Expense Report template that can be used to quickly input details of specific expenses incurred obtain approvals from department heads and higher authorities as and when required.
Let’s discuss in detail about the Expense report template.
Content of Expense Report Excel Template
The expense report template contains 2 parts which are mentioned below:
- Header Section
- Data Input Section
1. Header Section
Cells B2 to L3 are merged cells. Enter your Company/Business Name.
Heading of sheet “Expense Report or Reimbursement Form”. Cells B4 to L4 merged.
Cell B5 consists of Purpose for which expense report is made. It can be for a particular project, department or a business trip by an employee, etc.
Cell B6 consists of Statement number. On the right-hand side, cell J5 and J6 consist of the period of the expense report.
It also contains employee and department details like Name of employee, Employee Id, Department name and Manager’s name.
Let’s call it the header section. You can see the preview of it in the image below:
2. Data Input Section
This section consists of subheadings for Data Input. Cell B11 to L11 Data Part. This section contains subheadings like Date, Description of expenses, different heads for different kinds of expenses and other miscellaneous expenses. The last column is for Total.
Cell C12 to K22 is the Data Input section. In the end, it consists of expense wise Totals.
In this section on the left-hand side, we have authorized signatory and on the right-hand side, we have calculations for reimbursement.
Cell L24 reflects the subtotal of expenses and L25 reflects the Advance amount paid by the Accounts department or any other authority.
Therefore, Reimbursement = Expenses – Advance.
The formula applied here is =L24-L25.
You can see the preview of it in the image below:
We would like to express our gratitude to our viewers for encouraging us by liking and sharing our content on different social media platforms, especially facebook viewers.
If you have any queries share them in the comments below and I will be more than happy to help you.