You can see the preview of it in the image below: Therefore, Reimbursement = Expenses – Advance. In this section, the left-hand side consists of a section for the authorized signatory whereas the right-hand side consists of the summary for reimbursements.įurthermore, Cell L24 reflects the subtotal of expenses and L25 reflects the Advance amount paid by the Accounts department or any other authority. The last column is for Total.Ĭell C12 to K22 is the Data Input section. In the end, it consists of expense wise Totals. This section contains subheadings like Date, Description of expenses, different heads for different kinds of expenses, and other miscellaneous expenses. This section consists of subheadings for Data Input. In addition to the above, it also contains employee and department details like Name of employee, Employee Id, Department name, and Manager’s name. On the right-hand side, cell J5 and J6 consist of the period of the expense report. It can be for a particular project, department, or business trip by an employee, etc.Ĭell B6 consists of Statement number. Moreover, Cell B5 consists of Purpose for which expense report is made. Heading of sheet “Expense Report or Reimbursement Form”. The expense report template contains 2 parts: Header Section and Data Input Section Header SectionĬells B2 to 元 are merged cells. Let’s discuss in detail about the Expense report template. Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu.Īdditionally, you can download other accounting templates like Cash Book, Petty Cash Book, and Purchase Return Book. We have created a simple Expense Report template that helps you to quickly input details of specific expenses incurred obtain approvals from department heads as and when required.Ĭlick here to Download All Accounting Excel Templates for ₹299. Expense reports help to save fraudulent use.It helps the management to curb unnecessary overheads.Businesses use the expense report for analytical purposes.Reporting and recording business expenses. Reimbursement of expenses paid by an employee on behalf of the company.The employer reimburses the expenses to the employees.īeing a business owner, it is necessary to ensure that the expenses are as per the company policy. For proper recording of expenses, an employee prepares an expense report. Usually, companies keep it mandatory for the employees to attach the receipts. Generally, businesses allow their employees to spend money to enhance their business. Date of the actual occurrence of the expenses.Employee details along with Employee ID, department, and the reporting authority. Purpose of expenses such as meeting a client, survey of the market, procurement of goods, purchase of machinery, etc.Here are common elements of an expense report: Elements of an Expense ReportĬomponents of an expense report might vary from business to business. After approval, the employer pays to the employee if the claim is in line with guidelines and reimbursement policies. An employee must attach the receipts of expenses along with the report.įurthermore, the authorized personnel examines the expense report for accuracy and validity. The employee submits the expense report for approval. It provides a quick track of expenses and relevant documentation.Īn employee prepares the expense report against the actual spending made by him/her for the business. An expense report is a reimbursement form that a company uses to track its business spending. It helps you to keep track of business expenses for an employee’s business trip, a particular department, or any project for a company.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |