ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Plan efficient routes for your techs with Smarfle. From $19/month. Start free.
2
Google Sheets Mileage Log
3
Record business trips, review mileage and prepare a monthly reimbursement log.
4
Make a copy to use it privately in your Google Drive
5
Download for Excel (.xlsx)Works in Excel. A few Google-only formulas work best in Google Sheets.
6
Crew in the field? Get the Smarfle app.
7
Get it on Google Play
8
Download on the App Store
9
Quick start
10
1. Make a copy using the link above. Keep your copy Restricted before entering real customer or employee details.
11
2. Clear only yellow input cells in Trips rows 6:11. Remove their Sample labels too. Clear contents rather than deleting whole rows so prepared formulas and dropdowns stay in place.
12
3. Set the business name, your approved mileage rate and driver and vehicle lists in Settings, then enter the next trip in Trips. Clear the date in Settings to use today.
13
Who this is for
14
This mileage log is for a local service business whose owner or staff drive between customer visits, suppliers and other business stops. It gives you a consistent trip record and a reimbursement estimate without connecting to a vehicle or tracking anyone automatically. You decide which trips are business travel under your policy and the rules that apply. This is bookkeeping help, not tax advice.
15
What you can track
16
Trips records the date, driver, vehicle, start and end locations, purpose, customer or job reference and odometer readings. You may enter miles instead when readings are unavailable. Personal trips can be logged to explain vehicle continuity but are excluded from business reimbursements. Keep the reimbursement flag and payment date current so the office knows what is still owed.
17
How the tabs connect
18
Trips owns mileage and reimbursement calculations. Settings supplies the example rate, report month, driver and vehicle lists, print filters and gap tolerance. Dashboard summarizes the selected year and month by driver and vehicle. Its customer-or-job section accepts reference names to summarize. Monthly Log pulls matching trips in date and numeric ID order for a signature-ready page with up to 15 lines.
19
Setup steps
20
1. Set the business name, your approved mileage rate and driver and vehicle lists in Settings, then enter the next trip in Trips.
21
2. Clear Settings B6 for today and the current month. Set print driver and vehicle filters in Settings B11:B12, or clear them for all recorded drivers and vehicles.
22
3. Use a unique positive numeric Trip ID below 1,000,000. For multiple trips on one date, give later trips larger IDs. Keep the ID permanent; this makes previous-trip comparisons work after sorting.
23
4. Choose either actual odometers for the full trip or Entered miles. Entered miles overrides the odometer calculation. Round trip doubles entered one-way miles only. Never double odometer readings, because they already record the driven distance.
24
Worked examples
25
Sample trips 1001 and 1002 record 12 miles each from odometers. Even though 1002 says round trip, its 12-mile odometer difference is not doubled. Trip 1004 enters 15 one-way miles with Round trip Yes, producing 30 miles.
26
At the fictional $0.70 rate, 64 business miles produce $44.80 reimbursement. The $21.00 for trip 1004 is marked reimbursed, leaving $23.80 owed. The five personal miles are excluded. Trip 1006 has a falling odometer and no purpose, so its miles and amounts stay blank and its alerts remain visible.
27
Definitions
28
A gap compares the current start odometer with the previous odometer-recorded trip for the same vehicle, ordered by date and ID. It can mean personal travel was not logged, another driver used the vehicle or a reading is wrong. It is a prompt to review, not proof of fraud or a disallowed expense.
29
Reimbursement amount equals business miles times the current Settings rate, rounded per trip to cents. Reimbursement owed includes only Business trips marked Reimbursed No. The example rate is not stated to be an IRS rate. Update it each year under your policy, and keep a separate dated file or freeze approved historical amounts privately before changing a rate used by old trips.
30
Practical checks
31
Check Needs attention for falling readings, gaps, missing purpose and incomplete fields. Invalid mileage is omitted from totals, so review blank results instead of assuming the totals are complete. Do not use this log to decide whether commuting or another trip is deductible; ask your adviser.
32
The first recorded trip has no earlier odometer to compare. Entered-mile trips cannot prove odometer continuity. Include personal travel if you need a continuous vehicle log. Driver and vehicle summaries use the editable Settings lists, so keep their spelling consistent.
33
Review the 15-line print guard and narrow filters before printing. If more than 15 trips match, filter and print Trips for a complete multi-page monthly record. The PDF link works after you enter your private copy URL in Settings; File > Print needs no URL setup. Signing approves your record, not a tax deduction. Never place real addresses or employee travel in the public master.
34
Capacity and protection
35
Prepared for 500 trips in rows 6:505, 30 driver and vehicle list entries and 20 customer or job summary references. Sample reference names in Dashboard A96:A98 are editable; clear them when replacing the examples. Yellow cells accept inputs, and blue cells calculate. USD and MM/DD/YYYY are used throughout. Keep permanent record IDs unique. Sort complete rows, never individual columns. Technical calculations are in collapsed groups, but the results people read remain visible. Check the Needs attention column at the end of each row; alerts are separated by semicolons and an empty cell means no listed alert is active. Headers, instructions and formulas are protected. Smarfle banners, About Smarfle and the author line show an editing warning. Owners may remove protections in their own copies. No scripts, macros, automatic messages or account connections are used.
36
Private use
37
This is a public master with fictional examples, not a place for customer records. Make your own copy, clear the samples and keep its sharing Restricted. Give staff access only where needed. Review any exported document before sending it outside the business. Formula results reflect the information entered; missing records and incorrect dates can still produce incomplete reports. Save dated private backups before major changes and use a separate file when a new year needs different assumptions.
38
About Smarfle
39
Manage customers, jobs and invoices with Smarfle when you need a connected service-business platform. Plans start at $19/month. Plan limits and usage charges apply. Check current features and pricing on the website.
40
Created by Ihor Lavrenenko, founder of Smarfle
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100