4/23/2024 0 Comments Travel expense report templateThey let you track expenses over timeĮxpense reports also let you track spending over time and see whether any particular expense category is driving costs. An itemized expense report (with receipts attached) lets you do exactly that. If an employee pays for something out of pocket and asks for a reimbursement, you need some way of making sure the expenses they’re claiming are accurate. So why do it? They let you reimburse employees properly If you run a small business that already does bookkeeping and produces financial statements, it might not be clear why you need expense reports. Pretty straightforward! Download Templateĭownload Template Why do we need expense reports? Each line asks for the date the expense was made, a brief description of the expense, the expense type and the expense amount. In addition to the employee’s personal information and the relevant pay period for which the report is being submitted, all it asks for is a one-line description of each business expense. If your employees don’t make many regular business expenses and you just need a form to capture the odd travel or project expense, a simple one-time expense report might work. We’ve come up with three templates that we think should cover most use cases. Google “expense report” and you’ll find an endless variety of templates, all of which seem slightly different. Room to explain certain expenditures that don’t fit clearly into one category.The total reimbursement figure being requested by the employee submitting the report.Subtotals for each expense type, to make it easier for a bookkeeper to input that data into your accounting system.Most expense reports also contain information like: Which account in your company’s chart of accounts the expense will be billed to.A date and dollar amount for each expense, matching the date and dollar amount on the receipt provided for that expense.Information identifying the person submitting the report (department, position, contact info, SSN, etc.).You can record all your expenses as the day passes, to ensure that you have a complete compilation of your expense report, which is important for the company, particularly its finance department, with each and every trip.At minimum, an expense report should include all of the following information: You can also add more rows for the many days you are away on your business trip. There is also a grand total at the very bottom of the table to show you the total of each expense category. Such a format allows you and your manager or accounting personnel to see how much is spent in one day. Each column represents each information, such as Date, Description of Expense, Airfare, Lodging, Ground Transportation, Meals and Tips, Conferences and Seminars, Miles, Mileage Reimbursement, Miscellaneous, Currency Exchange Rate, Expense Currency, and Total. You can fill it out following the guide and with the help of the column headers. This information includes your Name, Department, Period, Authorized by, Date Submitted, Per Mile Reimbursement, Total Reimbursement Due.īelow this is a table where you can list all your the items in your travel expense. Under this header is a set of blank rectangles corresponding to the required information you have to fill out. This ensures that you or your company knows at first glance that the document will be all about travel. This travel expense report template features a header that contains beautiful icons of a plane, train, and car. This is specially created for the purpose of taking the frustration of the travelling employees as well as the accounting personnel out of the equation each time the company sends someone out for a business trip. The Travel Expense Report Template for Excel is one of the latest Excel templates that you can use to record, collate and classify your travel expenses.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |