The Weekly Expense Report template provides a way to include more details and more expense categories. The Business Mileage Tracking Log lets you keep track of daily mileage for record keeping and reporting. Our Reimbursement Form template is great for general employee expense reimbursements (for non-travel expenses). For each day of the week, enter expenditures by category, such as lodging, mileage, or meals. For an official and detailed list that includes explanations and examples, we highly recommend visiting the Business Travel Expenses page on IRS.gov: ) Other Helpful Expense Report Templates Get week-by-week reimbursements from your employer with this weekly expense report template.
This will help you categorize and track your expenses efficiently. Here are some key formatting tips: Column headers: Use the first row to create column headers such as Date, Description, Category, Amount, and Notes. We've based the expense types in our templates on these common expenses. Formatting the sheet for easy data entry can make it simpler for you to record your daily expenses. The expense tracker template will open in a new workbook. How To Maintain Income, Expense, Savings & Cash Balance in Excel Budget SpreadsheetIn this Tutorial, we will show you how to create and use a daily expen. To access the expense tracker template, go to File > New > Templates > Tracking > Expenses. Some of the most common tax deductible travel expenses include: flights, car rentals, mileage, uber rides, lodging, meals, tips, dry cleaning and laundry. Does Excel have an expense tracker Yes, Excel has a built-in expense tracker template that you can use to track your daily spending. What business travel expenses are tax deductible? Place an "x" in this column (or check the box in the Google Sheets version) if you want the amount to be added to the "Amount to Reimburse" total. Update : I've added a new worksheet to this version of the expense report that lets you mark specific expenses "to be reimbursed" in case you use both a company card as well as personal money. Use the description column for any additional information you want. Under the category column, list down all expenses you have spent daily, e.g., home expenses (i.e., groceries, meals, or others), transportation expenses, recreation & entertainment, etc. There is also a designated place to specify the rate for mileage reimbursement.įor a blank, printable expense form that you can fill out by hand, simply remove the sample data and fill in the information you want printed. Categorize your expenses and add its description (if preferred). The expense type can be selected from a drop-down that is easy to customize. The Simple Expense Report template uses one column for all expense types.