Vehicle Log Book / Mileage Tracker for Taxation and Record Keeping - Multi Year Tracker with Slicers and Analysis Tools - US and AUS version



Only 1 available

GST Included

  • Digital download
  • Digital file type(s): 1 PDF, 1 PNG, 2 other files

Vehicle Log Book / Mileage Tracker for Taxation and Record Keeping - Multi Year Tracker with Slicers and Analysis Tools - US and AUS version - Formatted for easy printing.

This spreadsheet contains 2 sheets (tabs) including:

◆ Info Table - This is an automated pivot table that groups up your entries on the data entry tab (Tab 2) by month and year. It also allows you to view data by calendar year, fiscal year (US), or financial year (Australian). It suits miles or kilometre distance measurements.
◆ Log Book / Mileage Tab - This is the data entry tab. Simply enter your data into the grey fields (leave the white fields empty). Fields include - date (manual field), start time (manual field), finish time (manual field), odometer start (manual field), odometer finish (manual field), total distance traveled (auto-calculated), Measure (auto-calculated), the purpose of the trip (manual field), Name of the driver (optional field), and date entered (optional field).

My goal with this workbook is to try to make using Microsoft Excel easy, and it has been designed:

◆ With a very simple user interface with buttons to add and delete rows as needed.
◆ To be simple to use with instructions for use embedded into the worksheet.
◆ With Macros embedded within the worksheet to make this easy to use.
◆ Each worksheet has been formatted to be printable for you (if desired)
◆ To be a once-off buy no need to buy another tracker for next year. You can use this workbook for the next year or the next 10 years (or more).

What you will receive when you purchase the Vehicle Log Book / Mileage Tracker for Taxation and Record-Keeping - Multi-Year Tracker with Slicers and Analysis Tools - US and AUS version:

◆ Two Versions of the Excel Spreadsheet (one is set up for US style calendar and one is set up for Australian calendar - please make sure- you use the right one or the table will show an error).
◆ One 2 page Quick Start Guide (in addition to instructions built into the spreadsheet itself)


◆ Created on Microsoft Excel 2016 (only works with Microsoft Excel desktop on Windows, not Excel online, Google Sheets, or Excel for MAC). Will work on desktop versions of Excel 2010 upwards.
◆ Please note that this spreadsheet uses Macros so please ensure when you open this file you 'enable macros'.
◆ Please note that every sheet on this spreadsheet has built-in instruction buttons to assist you with completing each sheet.
◆ Please ensure you don't change the sheet names or column names.
◆ Please note that this is a DIGITAL DOWNLOAD file. You will NOT receive a physical product.

© Copyright
All designs are copyrighted by TheFrankBasics. You may not resell or redistribute any of these files. If you would like to use any of these templates commercially, please get in touch to discuss licensing.

💌 Due to this being a digital download, refunds are not available on this item for change of mind. However, please get in touch should you have any issues with the item as I will ensure that the item is working as described. Additionally, I'm keen to receive feedback to make the product better for everyone so please feel free to get in touch.

💻 How To Download Your Digital Purchase:

◆ A link to download the PDF pattern will be sent to your Etsy email address. All PDF purchases are available in your Etsy account. Once payment has been confirmed, go to "My Account" > "Purchase".
◆ To view or print your PDF file, you will need Adobe Reader (free download link):
◆ Your file should be available here, in your purchases:
◆ To access your digital file(s), go to Your Account > Purchases and reviews and look for the order.
◆ To the right of the order, click Download Files. This goes to the Downloads page for all the files attached to your order.
◆ There are generally no limits for when or how many times you can download a file. In most cases, you can access a file any time on your Purchases page, provided the transaction hasn't been canceled or removed.
◆ If your payment is still processing, the Download Files button will be grey.

Thank you for visiting The Frank Basics!!!! Feel free to get in touch if you have any questions, issues or if you want a custom Excel Product.

Instant Download

Your files will be available to download once payment is confirmed. Here's how.

I don't accept returns, exchanges or cancellations. But please contact me if you have any problems with your order.

Frank On Fire

Frank On Fire

Owner of TheFrankBasics

Message Frank

4 shop reviews

5 out of 5 stars
5 out of 5 stars

I love this template. It has made invoicing a breeze.

Aliya Hutchison 12 Aug, 2021

5 out of 5 stars

Thank you!

deebright3863 23 Mar, 2021

5 out of 5 stars

Jimwel 25 Jul, 2022

More from this shop

See more