Updating the Expense Report

As you probably know, the IRS has updated the business mileage allowance for 2008 to 50.5¢ per mile. If you are using the Expense Report form that came with your AgencyCentral Intranet, you need to update the formula for this new amount. This can be done from any workstation with Microsoft Excel.

1. From Windows Explorer, open your INTRANET folder
2. Open the forms folder
3. Open the accounting folder
4. Right-click on the Expense Report file and select Open from the shortcut menu
5. This will open the file in Microsoft Excel
6. Update the message field (usually A29) to read:
   Mileage reimbursement for 2008: 50.5¢ per mileNOTE: Effective 7/01/08, the IRS increased the mileage allowance to 58.5¢ for the remainder of the year. For official details, click here.
7. Click on the TOTAL MILEAGE REIMBURSEMENT field (usually L30) and update the formula bar to read as follows:
   =D27*0.505
8. Save and exit Microsoft Excel
9. From now on, the total miles shown in the MILEAGE column (usually D27) will be multiplied by .505 (the decimal equivalent of 50.5¢) and the mileage allowance will be displayed in the TOTAL MILEAGE REIMBURSEMENT field (usually L30)