This Excel spreadsheet tracks mileage tax deductions and business mileage reimbursements for you. Print a professional mileage report, including colorful graphs, showing deductable amounts, miles, and numbers of trips monthly, quarterly, and annually. Mileage report and graphs are updated automatically every time you make an entry for a new trip or update the information for a trip already recorded.
Customize reports with your name (or company name) and the year, so you will have a one-page report at the end of the year for your tax records. Keep the IRS and other tax officials happy by having proper documentation for your mileage deductions. Tax officials are watching expense reports closely for accuracy and completeness, and tax-deductable mileage must be documented properly to support deductions.
Enter start and end odometer readings and let the spreadsheet automatically calculate everything for you. Track trips for business, charitable, medical, moving, and other categories. Monthly entry forms let you specify mileage rate amount for each trip category. The Data page allows you to set whatever mileage rate you want and offers suggestions for each category, guided by IRS allowable deductable rate.
Spreadsheet includes help page and links to assorted online tax documents for US, UK, and Canada. You can expand the reference section by adding your own tax reference hyperlinks, as needed. The help page gives easy instruction about how to add new hyperlinks to your reference list. Registered version includes bonus page of mileage record slips you can print out and take with you on your trip.
System requirements are the same as those required to run MS Excel. This spreadsheet is designed to work with any version of MS Excel and will work with Open Office Calc. It contains no macros or custom functions, so you can use with any software that opens, edits, and saves Excel spreadsheets. Download a free demo from www.mileagespreadsheet.com.