expense report spreadsheet template excel

#Expense report spreadsheet template excel how to

You might include the purpose for the meal in the Description if you are listing many items on a single form. Important: Keep a copy of your receipts and your reimbursement request form for your own records!īusiness Meals: For business meals to be tax-deductible, there must be a clear business purpose, along with a receipt. Use this free income and expense tracker template to track your income and expenses. It doesn’t hurt that they’re free, either. We curated our template page to select 10 of the essential manufacturing templates for Excel that all manufacturers can benefit from. Don't forget to attach copies of your receipts. ProjectManager has dozens of free templates to download.

#Expense report spreadsheet template excel how to

If you have questions about how to use the form, ask your employer.

For Employeesįor each expense, choose an appropriate category. See IRS Publication 463 for detailed rules. If you write a check, make sure to write Expense Reimbursement in the Memo field or otherwise indicate that the check is a reimbursement rather than a normal paycheck. Employees may appreciate being reimbursed as soon as possible, instead of waiting for the normal paycheck. Processing a Payment: For accounting purposes (assuming you are using an 'accountable plan' - see IRS Publication 463), I find it simpler to write a separate check than to include the reimbursement in a payroll check. It would probably be good to write-up a short document that you can give your employees as a guide for what types of expenses you will reimburse and any other policies that you want to put into place (such as requiring an employee to get prior approval for any purchase over $XX).

Remember to customize the list of items in the Categories worksheet and keep the mileage rate note up-to-date (see the references below for the current rates). Make sure they know to attach a copy of their receipts. Customize the template and then give a copy of the form to your employees when they need to submit a request for expense reimbursement.