How to Create a Mileage Log from Calendar Data on iPhone

Use Apple Calendar events to build IRS-compliant mileage logs for tax deductions. Export origin, destination, distance, and purpose to spreadsheets automatically.

The IRS standard mileage rate for 2026 is 70 cents per mile for business use. That number sounds modest until you multiply it across a year of driving. A real estate agent who drives 15,000 business miles annually is looking at a $10,500 deduction. A home health aide who visits patients across a metropolitan area and logs 20,000 miles can claim $14,000. A sales representative covering a multi-state territory at 25,000 miles per year has a potential deduction of $17,500.

These are not hypothetical numbers. According to the Bureau of Labor Statistics, over 30 million American workers drive personal vehicles for business purposes. The average business driver logs 12,000 to 15,000 business miles per year. At the current mileage rate, that represents $8,400 to $10,500 in deductions that are available to anyone who can document them.

The operative phrase is “anyone who can document them.” The IRS requires substantiation for mileage deductions – contemporaneous records showing date, destination, business purpose, and miles driven for each trip. Without these records, the deduction is disallowed. And according to a 2023 analysis by the National Association of Tax Professionals, mileage deductions are among the most frequently challenged items in IRS audits of self-employed individuals and small businesses. An estimated 40% of taxpayers who claim mileage deductions lack adequate records to fully support them.

The problem is not ignorance. Most business drivers know they should keep a mileage log. The problem is friction. Paper logs require you to write down the details of every trip before, during, or immediately after driving. Dedicated mileage tracking apps use GPS, which drains battery, raises privacy concerns, and still requires you to classify each trip as business or personal. Both methods add a step to every drive, and both suffer from the same compliance decay: rigorous use for the first few weeks, gradual lapses, and eventual abandonment.

But there is a method that avoids the friction problem entirely. If you schedule your business appointments, client visits, property showings, or patient visits in Apple Calendar – and most business drivers do – your calendar already contains the core data for a mileage log. The date is there. The destination is there (in the event location or title). The business purpose is there (in the event title or notes). The only missing element is distance, and that can be calculated from origin and destination after export.

What the IRS Actually Requires for Mileage Deductions

Before building your mileage logging system, you need to understand exactly what the IRS requires. The rules come from IRS Publication 463 (Travel, Gift, and Car Expenses) and are rooted in IRC Section 274(d), which mandates “adequate records” for vehicle expense deductions.

The Five Required Elements

For each business trip, your mileage log must document:

  1. Date – The date of the trip.
  2. Destination – Where you drove (or the general area if you made multiple stops).
  3. Business purpose – Why the trip was made. “Client meeting” is acceptable. “Business” alone is not specific enough.
  4. Miles driven – The distance of the trip.
  5. Total annual miles – Your total miles driven during the year, broken into business, commuting, and personal categories.

Contemporaneous Recording

The IRS strongly prefers records made at or near the time of the trip. Publication 463 states that “a record of the elements of an expenditure or use made at or near the time of the expenditure or use, supported by sufficient documentary evidence, has more value than a statement prepared later.” In practice, this means logs created from memory weeks or months after the fact are given less weight than logs maintained in real time.

This is where calendar-based mileage tracking has a structural advantage. Calendar events are created before or at the time of the appointment, not reconstructed later. The timestamps are system-generated. When you export calendar events to a spreadsheet, the dates and times are pulled directly from the Calendar database – they are not typed from memory.

What Happens in an Audit

The IRS examines mileage deductions by requesting your mileage log and comparing it against other records: your calendar, appointment books, client lists, and receipts. If your mileage log is derived from your calendar – with locations, purposes, and dates matching your actual appointment schedule – the internal consistency strengthens your position. If your mileage log was reconstructed from memory and does not match your calendar, the inconsistency weakens your claim.

A 2022 Tax Court case (Smith v. Commissioner, T.C. Memo 2022-34) is instructive. The taxpayer claimed 18,000 business miles but provided only a spreadsheet created “at tax time” with round-number estimates. The court disallowed the deduction, noting the lack of contemporaneous records. In contrast, taxpayers who present calendar-derived mileage logs with specific destinations and purposes consistently fare better in disputes.

Structuring Calendar Events for Mileage Tracking

The calendar-based mileage method works best when your events contain the right information in a consistent format.

Use a structured title that encodes the business purpose clearly:

  • **“Client Visit: Anderson Corp 123 Oak Street, Springfield”**
  • **“Property Showing: 456 Elm Ave, Unit 3B Buyer: Thompson”**
  • **“Patient Visit: Johnson Residence 789 Pine Road”**
  • **“Sales Call: Regional Medical Center Purchasing Dept”**
  • **“Site Inspection: 1200 Industrial Blvd Project: Warehouse Renovation”**
The pattern is **“Purpose: Detail Location or Additional Info”**. The title establishes the business purpose. The location provides the destination.

Using the Location Field

Apple Calendar has a dedicated Location field that integrates with Apple Maps. When you enter an address in the Location field, Calendar displays it as a tappable link that opens Maps with directions. For mileage tracking, this field is valuable because:

  • It stores a clean, exportable address
  • CalXPort extracts it into a separate Destination column
  • The address format is consistent (standardized by Apple Maps autocomplete)
  • It provides independent verification that the location was entered before the trip

Always use the Location field rather than embedding the address only in the title. CalXPort’s mileage template reads both the title and the location field, but having the address in the dedicated field produces cleaner exports.

Adding Origin Information

For mileage calculations, you need both origin and destination. Most business trips start from either your home or your office, but some trips go from one client to another. To capture the origin, add it to the event notes:

Notes field:

Origin: Home Office (123 Main St)
Estimated miles: 24

Or for a multi-stop day:

Notes field:

Origin: Anderson Corp (123 Oak St)
Previous appointment ended 2:15 PM
Estimated miles: 18

My Agenda & Planning provides an enhanced view of your calendar that makes it easier to plan multi-appointment days with structured titles and notes. When you are scheduling a day of client visits, the visual planning interface helps you sequence appointments geographically and add consistent location details.

Handling Multi-Stop Days

Many business drivers visit multiple locations in a single day. A real estate agent might show four properties. A service technician might visit six clients. A medical professional might see patients at three facilities.

For multi-stop days, create a separate calendar event for each stop. This gives you:

  • Individual trip segments with distinct origins and destinations
  • Separate business purposes for each visit
  • Accurate time records for each appointment
  • Clean export rows that map to individual mileage log entries

Do not combine multiple stops into a single all-day event. The IRS wants trip-level detail, not a daily summary.

Using CalXPort’s Mileage Log Template

CalXPort includes a template designed specifically for mileage documentation. Here is how it processes your calendar data.

How the Template Works

When you select the Mileage Log template, CalXPort applies the following parsing rules:

  • Date – Extracted from the event start date
  • Departure Time – Event start time
  • Return Time – Event end time
  • Destination – Extracted from the Location field, or parsed from the event title if no Location is set
  • Origin – Parsed from the Notes field if present (looks for “Origin:” prefix), otherwise defaults to the previous event’s location or a configurable default (e.g., “Home Office”)
  • Business Purpose – Extracted from the event title, stripped of the location component
  • Calendar – Which calendar the event belongs to (useful for separating business travel from personal)
  • Notes – Any additional content from the notes field

Adding Distance After Export

CalXPort exports the origin, destination, date, and purpose from your calendar. The distance component requires one additional step: looking up the driving distance between origin and destination.

There are several ways to handle this after export:

Manual lookup. For a modest number of trips (under 50 per month), use Apple Maps or Google Maps to look up the distance for each origin-destination pair and enter it in the spreadsheet. Many business drivers have a limited set of regular destinations, so the same distances recur.

Distance formula in the spreadsheet. If you use Google Sheets, the Google Maps API can be accessed through custom functions to calculate driving distance between two addresses. Excel users can use the Bing Maps API through Power Query.

Odometer readings. If you record odometer readings at the start and end of each trip (or photograph the odometer with your phone), you can enter the actual miles driven. This is the gold standard for IRS documentation but requires the most effort.

The IRS accepts reasonable estimates calculated from mapping applications. You do not need to record odometer readings for every trip, though doing so for a sample of trips strengthens your documentation.

CalXPort
CalXPort — Event & Reminder to Excel Download

The Monthly Export Workflow

A sustainable mileage tracking system uses monthly exports:

  1. Throughout the month: Create calendar events for every business trip with structured titles, locations, and origin notes.
  2. End of month: Open CalXPort, select your business calendar(s), set the date range to the month, and choose the Mileage Log template.
  3. Export to Excel. The spreadsheet contains one row per trip with date, origin, destination, purpose, and time fields.
  4. Add distances. Fill in the miles column using your preferred method.
  5. Calculate the deduction. Multiply miles by the current IRS standard rate to calculate the deduction amount for each trip.
  6. Archive the file. Save the monthly export as part of your tax records.

At tax time, combine all 12 monthly exports into an annual summary. The total business miles, multiplied by the standard mileage rate, is your deduction on Schedule C (self-employed) or Form 2106 (employee).

For a comprehensive guide to the export process itself, see how to export Apple Calendar events to Excel and CSV.

Standard Mileage Rate vs. Actual Expense Method

The IRS offers two methods for vehicle expense deductions. Your mileage log supports both.

Standard Mileage Rate

The simpler method. Multiply your total business miles by the IRS-published rate (70 cents per mile for 2026). This rate covers gas, depreciation, insurance, repairs, and maintenance in a single per-mile figure.

Advantages: Simple calculation, minimal record-keeping beyond the mileage log itself, predictable deduction amount.

Requirements: You must use the standard mileage rate in the first year a vehicle is placed in service if you want to use it in subsequent years. You cannot use it if you operate five or more vehicles simultaneously.

Actual Expense Method

Track all vehicle expenses – gas, oil, tires, insurance, registration, depreciation, loan interest, lease payments, repairs, parking, tolls – and multiply the total by the percentage of miles that were business-related.

Advantages: Can produce a larger deduction than the standard rate for expensive vehicles or high-maintenance vehicles.

Requirements: You need records of every vehicle expense in addition to the mileage log. The mileage log is still required to establish the business-use percentage.

Your calendar-based mileage log works for both methods. For the standard rate, you need total business miles and trip details. For the actual expense method, you need total business miles and total annual miles (business + personal + commuting) to calculate the business-use percentage.

For tracking vehicle-related assets, maintenance schedules, and associated costs, Equipt provides equipment and asset tracking that complements your mileage records. If you use a vehicle for business, tracking its maintenance history alongside your mileage data gives you a complete picture of vehicle operating costs.

Employer Reimbursement Documentation

Not all mileage documentation is for tax deductions. Employees who drive personal vehicles for business purposes often submit mileage reports for employer reimbursement.

Accountable Plan Requirements

Under an accountable plan (the most common employer reimbursement structure), employees must:

  1. Incur the expense in connection with the employer’s business
  2. Adequately account to the employer within a reasonable time
  3. Return any excess reimbursement

“Adequately account” means providing a mileage report with dates, destinations, business purposes, and miles – the same elements the IRS requires. A CalXPort export provides exactly this documentation.

Monthly Reimbursement Workflow

Most employers with accountable plans require monthly mileage submissions. The calendar-based workflow aligns perfectly:

  1. Maintain your business calendar with structured events throughout the month
  2. Export at month-end using CalXPort’s Mileage Log template
  3. Add distances to the spreadsheet
  4. Submit the completed mileage report to your employer
  5. Retain a copy for your records

Save as PDF can convert your completed spreadsheet or reimbursement form into a PDF for submission and archival. Many employers accept PDF submissions through expense management systems.

For an overview of the full calendar export and analysis ecosystem, see the best apps for calendar export and time tracking on iPhone.

Industry-Specific Mileage Tracking

Different professions have different mileage patterns. Here is how to adapt the calendar-based method.

Real Estate Agents

Real estate agents drive more business miles than almost any other profession. The National Association of Realtors reports that the average agent drives 11,000 to 16,000 business miles per year, with top-producing agents exceeding 25,000 miles.

Structure your calendar events around showings, open houses, inspections, and client meetings:

  • **“Showing: 456 Elm St Buyer: Thompson Family”**
  • **“Open House: 789 Oak Ave 2-4 PM”**
  • **“Inspection: 123 Pine Rd Inspector: BuildRight Inc”**
  • **“Listing Appointment: 321 Cedar Ln Seller: Martinez”**

Each event becomes a mileage log entry with a clear business purpose.

Sales Representatives

Sales reps often cover large territories with regular client visits. Create recurring events for regular client calls and one-time events for new prospects:

  • **“Sales Call: Acme Manufacturing Quarterly Review”**
  • **“Prospect Visit: Pacific Industries Intro Meeting”**
  • **“Trade Show: Convention Center Industry Expo 2026”**

Healthcare Providers

Home health aides, physical therapists, and other visiting healthcare providers often see multiple patients per day. Structure events by patient (use initials or case numbers for HIPAA compliance if needed):

  • **“Patient Visit: JD-4421 45 Center St, Apt 2”**
  • **“Home Assessment: MK-3307 678 Birch Dr”**

For tracking health-related data exports more broadly, Health Export provides tools for exporting Apple Health data in multiple formats. Read more about health data portability in our guide on exporting and analyzing Apple Health data.

Contractors and Service Technicians

Service calls, site visits, and inspections follow predictable patterns. Use Equipt alongside CalXPort to track not just your travel but the equipment you bring to each job site. Combined exports give you a complete record of where you went, what you brought, and how long you spent.

Tax Preparation: From Calendar to Schedule C

At tax time, your monthly mileage exports combine into the documentation your CPA needs. The workflow is straightforward.

Annual Summary

Combine all 12 monthly exports into a single annual spreadsheet. Add a summary tab with:

  • Total business miles: Sum of all trip distances
  • Total commuting miles: If applicable (commuting miles are not deductible)
  • Total personal miles: Estimated based on odometer readings
  • Total annual miles: Sum of all categories
  • Business use percentage: Business miles divided by total annual miles
  • Standard mileage deduction: Business miles multiplied by the IRS rate

What Your CPA Needs

When you hand your mileage data to a tax preparer, the most useful format is:

  1. An annual summary with total business miles and the calculated deduction
  2. The detail-level spreadsheet with every trip for reference and audit support
  3. A note explaining your tracking method (calendar-based with monthly exports)

The detail-level data stays in your files unless the IRS requests it. The summary provides the numbers for Schedule C, Line 9 (Car and truck expenses).

For a comprehensive guide to preparing tax documentation from calendar data – combining timesheets, mileage, and expenses – see how to prepare tax documentation from time tracking data on iPhone. For freelancer-specific billing and tax workflows, read how to create freelancer timesheets from Apple Calendar.

Insurance Documentation

Your mileage records serve a secondary purpose: insurance documentation. Many auto insurance policies offer lower rates for vehicles driven fewer miles annually. If you maintain separate personal and business vehicles, your mileage log demonstrates the business vehicle’s annual usage.

Safe helps you maintain a home inventory for insurance purposes. Combined with your CalXPort mileage records and Equipt’s asset tracking, you have a comprehensive documentation system for insurance claims, vehicle depreciation, and equipment-in-transit coverage.

For more on insurance documentation, see how to create a home inventory for insurance.

Building Your Mileage Tracking Habit

The most important factor in mileage documentation is consistency. A partial log is better than no log, but a complete log is dramatically more defensible.

Week 1-2: Set Up the System

  • Choose your event title convention and write it down
  • Configure CalXPort with the Mileage Log template
  • Set the Location field as a required element in every business appointment
  • Practice the format with this week’s appointments

Week 3-4: Build the Habit

  • Create a calendar event for every business trip, no exceptions
  • At the end of week 2, do your first test export
  • Review the output and adjust your title convention if needed
  • Note any trips you missed and add them retroactively

Month 2 and Beyond: Sustain

  • Monthly export becomes routine – schedule a recurring 15-minute event on the last business day of each month
  • Keep monthly exports in a dedicated folder
  • Review quarterly totals against your deduction expectations
  • Adjust driving patterns if the business-use percentage is lower than expected

For a broader view of productivity systems and tracking methods, see the best productivity apps for iPhone and Mac. And for insights on tracking accomplishments beyond mileage, explore the Done List method for tracking what you have achieved.

Frequently Asked Questions

Does the IRS accept calendar-based mileage logs as adequate records? The IRS requires contemporaneous records showing date, destination, business purpose, and miles driven. It does not mandate a specific tool or format. Calendar-based mileage logs meet the contemporaneous recording standard because calendar events are created at or near the time of the trip. The exported spreadsheet with dates, destinations, purposes, and miles satisfies the substantiation requirements of IRC Section 274(d) and IRS Publication 463.

Do I need to record odometer readings for every trip? No. The IRS accepts reasonable distance estimates calculated from mapping applications (Apple Maps, Google Maps). However, recording your odometer reading at the beginning and end of the year is recommended to establish your total annual miles. Some advisors recommend periodic odometer spot-checks (quarterly) to validate your estimates.

Can I use the standard mileage rate if I also use my vehicle for personal driving? Yes. Most business drivers use their vehicle for both business and personal purposes. You claim the standard mileage rate only for business miles. Your mileage log documents which trips were business-related, and your annual summary separates business miles from personal and commuting miles. The personal miles are not deductible.

How far back should I keep mileage records? The IRS can audit returns up to three years after filing (six years if there is a substantial understatement of income). Keep your mileage logs, monthly exports, and annual summaries for at least seven years from the filing date. Digital files stored in a backed-up location take negligible space and provide protection well beyond the statute of limitations.

What qualifies as a “business purpose” for mileage deductions? Driving from your office or home office to a client location, job site, or temporary work location qualifies. Driving between two work locations (e.g., from one client to another) qualifies. Regular commuting from home to your permanent office does not qualify. Travel to professional development events (conferences, continuing education) qualifies if the primary purpose is business-related.

Can I deduct mileage for driving to a coworking space? If your tax home is your residence (common for self-employed individuals), driving to a coworking space is generally not deductible as it is considered commuting. However, driving from a coworking space to a client site is deductible. The rules depend on whether the coworking space is your “regular place of business.” Consult your tax advisor for your specific situation.

How do I handle trips with both business and personal purposes? If the primary purpose of the trip is business, the mileage to and from the business destination is deductible. Personal side trips or detours during a business trip are not deductible. For example, if you drive 30 miles to a client meeting and stop at a grocery store 2 miles off your route on the way home, the 30 miles of direct business travel are deductible, but the 4 extra miles for the grocery detour are not. Document the direct business distance in your mileage log.