![]() ![]() Here, you can start using the template or customize it for your own needs using the tools you already know and love. Click on the file you downloaded to open the template in Excel.Make sure to only download from safe sources! Download the template you want to use.The steps below are universal to all templates you download from the internet, as built-in Excel templates already show up on your Welcome screen upon launching the application. Once you have Microsoft Excel installed on your computer, using a template is as easy as one-two-three. Top Expense Tracking Templates in Excel for Free.Tip : Need help with Microsoft Excel? Visit our Help Center for free guides, tricks, and more templates! Table of Contents The templates below guide you in using the software to effectively track your expenses without having to hire a professional or spend money on premium services. Submit Your Expense Report: Submit your completed report, including all receipts, to your manager or other authorizer so they can complete the authorization section and quickly issue reimbursement.Select reviewed more than a dozen expense tracker MS Excel templates and found the top choices for monitoring your spending.Īll the templates below are free to use, easy to customize, and incredibly user-friendly. ![]() Most templates will calculate this amount automatically. Calculate the Total Reimbursement: Subtract any advances from your total expenses.Enter Any Advances: Include any money that was advanced to the employee requesting reimbursement.Calculate the Total Expenses: Once you’ve entered each individual expense, calculate the subtotal of all expenses paid.Entertainment: Record the cost of any reimbursable entertainment purchases.Meals: Record the cost of any business meals.Fuel and Mileage Cost: Record the amount spent on gas or the total mileage at the beginning and end of expensed car trips. ![]() Lodging Cost: List any costs related to accommodations.Air and Transportation Cost: List the amount of any travel-related expenses.Description: Briefly describe the expense.Date: List the date the expense was paid.Fill in Expenditure Information: For each reimbursable expenditure, provide relevant details for each of the following categories:.Pay Period: Select a date range for the expenses.Statement Number: Assign a statement number to the report.Purpose: Provide the purpose of the expenses.Department: Identify the department issuing the reimbursement.Manager: Enter the name of the approving manager.Employee ID: Enter that employee’s unique ID number.Employee Name: Enter the name of the person requesting reimbursement. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |