Tuesday, November 20, 2012

Managing Business Expense Reports With Microsoft Excel

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.


  1. expense reporting systems provides
    qualitative services to creating powerful business solutions for clients around the world.
    Thanks for providing us information.

  2. Old idea it seems. Expense reporting with excel has been taken over by much more advanced version of tools and softwares.

    Previously I was also dependent on excel but the day from when I came across cloud based expense reporting software my sort of work has given a real boost.

    Starting from data feeding to report generating, everything is been taken care by the automated software.

  3. This is a very useful topic indeed. In most businesses nowadays managing their business expense through MS excel. I'm delighted to learn how to keep track business receipts through MS excel. This can be measured by analytics software such as PanXpan's finance summary research module.