Thursday, October 15, 2009
Managing Business Expense Reports With Microsoft Excel
Posted on 8:15 AM by programlover
Managing Business Expense Reports With Microsoft Excel by T Miller
in Accounting (submitted 2009-10-14)
0
votes
vote
Keeping track of your business receipts should be mandatory and not optional. Your employee should understand the importance of this and realize how this may impact the accuracy of their report if the receipts are not present. Lost receipts can be retrieved by contacting the vendor to get a copy. The employee should realize that this is their responsibility especially if they expect reimbursement for those types of expenses.
Your standardized business expense report should have different areas to account for your employee expenses. There should be an area of general ledger accounts numbers, general ledger account names, date and location of expenses, and if necessary mileage calculations. This information will greatly assist your accounting team when they reconcile the expenses!
Lastly, your business expense reports should be submitted on a set timed schedule. It should be encouraged to submit them weekly or monthly. This should be mandatory and not optional. The goal is to reconcile for expenses in a timely manner so they company can see where their funds are being spent and if they are being used responsibly. To get employees on board with this, try incentive based rewards in the first few months to get them used the new timed schedule.
Excel templates are an excellent tool to use when you are standardizing your business expense report. Most companies already have Office or a similar product loaded on their company computers so using templates can assist in this standardization process. Below is an example of an excel business expense report. This expense report contains a sheet that allows you enter up to 30 general ledger accounts names and numbers. It also contains a weekly business expense report area that allows you to select the appropriate general ledger account and detail the expense prior to printing.
Your standardized business expense report should have different areas to account for your employee expenses. There should be an area of general ledger accounts numbers, general ledger account names, date and location of expenses, and if necessary mileage calculations. This information will greatly assist your accounting team when they reconcile the expenses!
Lastly, your business expense reports should be submitted on a set timed schedule. It should be encouraged to submit them weekly or monthly. This should be mandatory and not optional. The goal is to reconcile for expenses in a timely manner so they company can see where their funds are being spent and if they are being used responsibly. To get employees on board with this, try incentive based rewards in the first few months to get them used the new timed schedule.
Excel templates are an excellent tool to use when you are standardizing your business expense report. Most companies already have Office or a similar product loaded on their company computers so using templates can assist in this standardization process. Below is an example of an excel business expense report. This expense report contains a sheet that allows you enter up to 30 general ledger accounts names and numbers. It also contains a weekly business expense report area that allows you to select the appropriate general ledger account and detail the expense prior to printing.