If you're curious about how it works, here's a quick rundown of how to calculate mileage reimbursement after you've entered all of your trips.Īssume you drive your own vehicle for business and receive reimbursement by the cents per km rate.įor example, you keep track of your mileage and you have driven 1300 kilometres for work.

Because the formula is already present in the template, it is set to automatically calculate your reimbursement (note: this sheet uses the ATO official rate). How to use the car log book templateĪfter you have logged everything in, you can use the data to calculate your reimbursement. Keep all receipts related to those expenses, as these will be used to support your claims to the ATO or your employer. The percentage of business-related kilometres travelled.įor each trip recorded, the following information is required:Įxpenses such as fuel, servicing, and other operating costs can be claimed based on the percentage of business driving throughout the year - for example, if your business use percentage is 50%, your operating costs can be deducted at the same 50% rate.The odometer readings at the start and end of the period.

When using the logbook method, the following information is required: The ATO outlines clear rules on what information you need to fill out in your log book template. What to include in the car log book templateĪccording to the logbook method, there are a few things that you must always remember to include in your log book.

Your team will save time by having all trips tracked for them automatically.

Invite and remove users, as well as assign roles quickly.

In seconds, you can approve or reject mileage reports:.

Your team will provide you with accurate and consistent mileage reports.

Some of the benefits of using a mileage tracking app for your team are:

While using the Sheet or Excel car log book template may suffice for your team to report their mileage, an app will save you and your employees a lot of time by automating the reporting and reimbursement process. If you are a manager or an employer in need of a solution for your entire team, you can try Driversnote Teams.

Do you need a vehicle log book template for your team?

Excel spreadsheet pilot logbook free