Skip to content

Guide

Export your mileage log

Download the year's mileage log as a spreadsheet (CSV) — each drive's date, route, purpose, miles, the rate that day and its worth — for your records or your tax preparer.

On the web and the phone appUpdated

Your mileage log is kept for you, drive by drive, all year. When your tax preparer asks for it — or you simply want a copy — export the year as a spreadsheet. File the drives still waiting first (see File your drives): an unfiled drive isn't business miles yet.

  1. Open Mileage.

  2. Choose Export log, at the top right. This year's log downloads as a CSV file, which opens in Excel, Numbers or Google Sheets.

    Mileage, with Export log at the top right
    Mileage, with Export log at the top right

What's in it

One row for every drive of the year, with the Date, Start and End times, From and To, the Miles, its Class (business, personal or commute), the Business purpose, the Job # and Client for a signing, the IRS rate on that day, the Deduction, How it was measured (recorded by GPS, estimated from the route, or entered by hand), and the device that recorded it. A drive you added by hand on Mileage says Added on the web there, and has its day with no Start or End time.

Personal and commuting drives are in it too — marked, and worth nothing: a log that shows all your driving is what makes the business share believable. Removed drives aren't. Nor is the second recording of a trip that two of your devices recorded: the log has each trip once, so its miles add up to the miles you drove (Two of my devices recorded the same drive).

Everything for your accountant at once

Books → For your accountant downloads a whole year — the books as files QuickBooks Online and Xero import, a summary for any accountant, and this mileage log — in one go.

Bringing an old log in

Kept a mileage log in another app or a spreadsheet before? Bring it in on the web from Settings → Import, as a CSV file: the drives join your log here.

Tax information, not tax advice

What your log must show, and whether you deduct mileage at the standard rate, are tax questions — ask your tax preparer.

Was this helpful?

Still stuck? Contact support — a person reads every message and answers by email.

Theme