Keeping a detailed mileage log is the easiest way to make sure you can claim your mileage deductions. Throughout the year, you'll need to keep track of each business trip, the destination, the reason for the trip, and the vehicle's distance traveled for business and personal purposes. You must keep a complete logbook record if you're self-employed and wish to claim costs on an automobile used for business purposes. The CRA vehicle log book template provided here uses the standard CRA mileage rates. Remember that if you are logging any trips for 2022, you should use the 2022 CRA mileage rates instead.Īlternatively, you can try the Driversnote km log book app for even quicker mileage logging - recommended by accountants in Canada.Ī logbook is a year-long record of your business travel that the CRA or your employer requires for your tax deduction or reimbursement. If you use the printable PDF version, you will have to do all calculations manually. If you use the free Excel or Sheets mileage form, there is a formula already set up to calculate your reimbursement based on the CRA mileage rates for 2023. After that, the rate changes to $0.62 per kilometre.

Note that the rate included in the template, $0.68, is for the first 5000 kilometres you drive for business purposes in 2023. Use the other Sheets tab for an empty version which you can use to log your own trips. The Excel and Sheets versions include a mileage log example for you to see how the mileage log template should be filled out. Use the buttons above to download the free Driversnote Template as an Excel, Sheet or a printable PDF version. Download the Mileage Log Template for 2023 - PDF, Excel, Sheets The template includes the formula you need to calculate your deductions based on the CRA mileage rates for 2023. In this article, we will walk you through some frequently asked questions about keeping a mileage log book and provide you with a free template to use. You must keep CRA-compliant records in order to claim your mileage deductions of reimbursement from your employer.

Using the mileage log template in Excel or PDF How to use the mileage log template to calculate your reimbursementĪre you a manager looking for a free mileage log template for your team?įor how long you should keep your mileage logbook Using the mileage log book template as an employee Using the mileage log book template as a self-employed individual What you need to log in the mileage log book template Download the Mileage Log Template for 2023 - PDF, Excel, SheetsĬan I use this mileage log template as a logbook?

Free income and expense wps template