Review dated service and document records against the explicit review date and recorded odometer.
Suggested for your taskVehicles / connected records for an ordinary job
Vehicle Records & Costs Workbook
The date, the reading and the receipt together.
Use your manufacturer or qualified provider’s intervals, dated odometer readings and actual completed work to calculate the next date and distance threshold. Keep costs and verified document dates alongside.
- Format
- Excel · .xlsx
- Inside
- 10 worksheets
- Included
- Clean file + example + guide
$5.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
Which confirmed vehicle tasks and documents need reviewing?
Use your manufacturer or qualified provider’s intervals, dated odometer readings and actual completed work to calculate the next date and distance threshold. Keep costs and verified document dates alongside. The rule begins at 10,000 km on 01 Jan. A later recorded service at 12,000 km on 01 Jul advances a six-month / 5,000 km interval. The current reading is dated; the workbook does not extrapolate it.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Set a review date and period. Enter current readings yourself; nothing reads the vehicle.
Suggested for your taskKeep a dated odometer reading with its km or mile unit and vehicle status.
Suggested for your taskEnter a confirmed interval and source. The latest valid service resets the next date and distance.
Suggested for your taskRecord completed service, its actual date, reading, unit and paid cost.
Suggested for your taskKeep fuel, parking and other paid costs separate from service-log spending.
Suggested for your taskRecord a confirmed document deadline and where the original is kept.
Suggested for your taskCheck the next confirmed date and odometer threshold against the dated reading.
Suggested for your taskReview paid service and other costs by month without counting the service cost twice.
Suggested for your taskRead how vehicle IDs, confirmed rules, service records and units fit together.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 10 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 10 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
See a completed service reset both thresholds.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Review dated service and document records against the explicit review date and recorded odometer.
- Settings: Set a review date and period. Enter current readings yourself; nothing reads the vehicle.
- Vehicles: Keep a dated odometer reading with its km or mile unit and vehicle status.
- Service Rules: Enter a confirmed interval and source. The latest valid service resets the next date and distance.
- Service Log: Record completed service, its actual date, reading, unit and paid cost.
- Costs: Keep fuel, parking and other paid costs separate from service-log spending.
- Documents: Record a confirmed document deadline and where the original is kept.
- Due Review: Check the next confirmed date and odometer threshold against the dated reading.
- Monthly: Review paid service and other costs by month without counting the service cost twice.
- Start: Read how vehicle IDs, confirmed rules, service records and units fit together.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. vehicle-records-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. vehicle-records-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
See a completed service reset both thresholds.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Read the current vehicle record
Vehicles V-01 has a 15,200 km reading dated 8 October 2026. Service rule SR-01 uses a fictional confirmed interval of six months or 5,000 km.
Inspect VehiclesFind the completed service
Service Log SL-01 links to SR-01: completed 1 July 2026 at 12,000 km, with 90.00 paid. This valid record replaces the earlier baseline for that rule.
Inspect Service LogCompare the next date and distance
Due Review SR-01 shows 1 January 2027 and 17,000 km. The dated reading is 1,800 km below that threshold. This is a record comparison; obtain real intervals from your vehicle’s confirmed instructions.
Inspect Due Review
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 10 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E39. Image only; entries are made in your downloaded workbook.
Dashboard
Review dated service and document records against the explicit review date and recorded odometer.
- You enter
- No routine entries
- Calculated or supplied reference
- Linked review and navigation
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Set a review date and period. Enter current readings yourself; nothing reads the vehicle.
- You enter
- Currency, review date and labelled period
- Calculated or supplied reference
- Visible settings check
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Vehicles
Keep a dated odometer reading with its km or mile unit and vehicle status.
- You enter
- 20 rows: Vehicle ID, Vehicle / own label, Distance unit, Current odometer, Reading date, Status, Own notes, Recorded reading unit
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:N14. Image only; entries are made in your downloaded workbook.
Service Rules
Enter a confirmed interval and source. The latest valid service resets the next date and distance.
- You enter
- 120 rows: Rule ID, Vehicle ID, Confirmed task, Baseline done date, Baseline odometer, Interval months / opt, Interval distance / opt, Instruction source, Recorded baseline unit
- Calculated or supplied reference
- Latest done date, Latest done reading, Next date, Next odometer
Actual example worksheet · Preview range A1:J14. Image only; entries are made in your downloaded workbook.
Service Log
Record completed service, its actual date, reading, unit and paid cost.
- You enter
- 300 rows: Service ID, Rule ID, Completed date, Actual odometer, Paid amount, Provider / receipt ref, Recorded distance unit
- Calculated or supplied reference
- Vehicle ID, Latest for rule
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Costs
Keep fuel, parking and other paid costs separate from service-log spending.
- You enter
- 300 rows: Cost ID, Vehicle ID, Actual date, Category, Paid amount, Receipt / own notes
- Calculated or supplied reference
- Input and link checks
Actual example worksheet · Preview range A1:H14. Image only; entries are made in your downloaded workbook.
Documents
Record a confirmed document deadline and where the original is kept.
- You enter
- 100 rows: Document ID, Vehicle ID, Document / record, Confirmed end / due, Original file location, Status
- Calculated or supplied reference
- Date state
Actual example worksheet · Preview range A1:I19. Image only; entries are made in your downloaded workbook.
Due Review
Check the next confirmed date and odometer threshold against the dated reading.
- You enter
- No routine entries; review the source records
- Calculated or supplied reference
- Vehicle / unit, Next date, Next odometer, Current reading, Read on, Date state, Distance state
Actual example worksheet · Preview range A1:D19. Image only; entries are made in your downloaded workbook.
Monthly
Review paid service and other costs by month without counting the service cost twice.
- You enter
- No routine entries; review the source records
- Calculated or supplied reference
- Other costs, Total paid
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Read how vehicle IDs, confirmed rules, service records and units fit together.
- You enter
- No routine entries
- Calculated or supplied reference
- Instructions and practical limits
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
See a completed service reset both thresholds.
The rule begins at 10,000 km on 01 Jan. A later recorded service at 12,000 km on 01 Jul advances a six-month / 5,000 km interval. The current reading is dated; the workbook does not extrapolate it.
- V-01 / reading dated 8 October 2026
- 15,200 km
- SR-01 / confirmed fictional interval
- 6 months or 5,000 km
- SL-01 / completed 1 July 2026
- 12,000 km; EUR 90 paid
- Latest actual service reading
- 12,000 km
- Next confirmed distance threshold
- 17,000 km
- Next confirmed date
- 01 Jan 2027
FOLLOW THE ACTUAL EXAMPLE FILE
See a completed service reset both thresholds.
Fictional records from the supplied example XLSX. Follow the same references through the sheets, then start your own clean copy.
The records behind the result
V-01 / reading dated 8 October 2026 15,200 km
SR-01 / confirmed fictional interval 6 months or 5,000 km
SL-01 / completed 1 July 2026 12,000 km; EUR 90 paid
The rule begins at 10,000 km on 01 Jan. A later recorded service at 12,000 km on 01 Jul advances a six-month / 5,000 km interval. The current reading is dated; the workbook does not extrapolate it.
- Latest actual service reading
- 12,000 km
- Next confirmed distance threshold
- 17,000 km
- Next confirmed date
- 01 Jan 2027
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. 20 vehicles; 120 service rules; 300 service log records; 300 other cost records; 100 document records.
Inspect the actual worksheetsFrom setup to a regular review
How you use it.
Open the 4-step setup and review routineInputs, calculations and the decision each step supports
- 01
Record the vehicle and reading
You enterChoose km or miles per vehicle. Record the current odometer and the date you read it; keep the same unit in all linked service records. The review date does not invent a more recent reading.
CalculatedVehicles V-01 has a 15,200 km reading dated 8 October 2026. Service rule SR-01 uses a fictional confirmed interval of six months or 5,000 km.
Your next stepOpen Vehicles and compare the linked reference with the records above.
- 02
Copy confirmed service rules
You enterEnter intervals only from the actual manufacturer or qualified provider. Set a baseline completion date and reading. Leave an unused interval blank. At least one interval is needed.
CalculatedService Log SL-01 links to SR-01: completed 1 July 2026 at 12,000 km, with 90.00 paid. This valid record replaces the earlier baseline for that rule.
Your next stepOpen Service Log and compare the linked reference with the records above.
- 03
Log actual work
You enterLink completed work to the rule ID. The latest valid entry through the review date replaces the rule baseline for its next due calculation. Changing an interval changes the next estimate, never historical paid amounts.
CalculatedDue Review SR-01 shows 1 January 2027 and 17,000 km. The dated reading is 1,800 km below that threshold. This is a record comparison; obtain real intervals from your vehicle’s confirmed instructions.
Your next stepOpen Due Review and compare the linked reference with the records above.
- 04
Review dates and costs
You enterDue Review shows next date, next odometer and separate due flags. A dated reading is shown alongside the distance result. Documents records dates you verify yourself. Monthly separates servicing from other costs.
CalculatedDue Review SR-01 shows 1 January 2027 and 17,000 km. The dated reading is 1,800 km below that threshold. This is a record comparison; obtain real intervals from your vehicle’s confirmed instructions.
Your next stepOpen Due Review and compare the linked reference with the records above.
10 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Linked review and navigation
Review dated service and document records against the explicit review date and recorded odometer.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- Currency, review date and labelled period
Calculated or reference
- Visible settings check
Set a review date and period. Enter current readings yourself; nothing reads the vehicle.
Inspect the actual Settings sheetVehiclesOpen sheet details
Editable inputs
- 20 rows: Vehicle ID, Vehicle / own label, Distance unit, Current odometer, Reading date, Status, Own notes, Recorded reading unit
Calculated or reference
- Input and link checks
Keep a dated odometer reading with its km or mile unit and vehicle status.
Inspect the actual Vehicles sheetService RulesOpen sheet details
Editable inputs
- 120 rows: Rule ID, Vehicle ID, Confirmed task, Baseline done date, Baseline odometer, Interval months / opt, Interval distance / opt, Instruction source, Recorded baseline unit
Calculated or reference
- Latest done date, Latest done reading, Next date, Next odometer
Enter a confirmed interval and source. The latest valid service resets the next date and distance.
Inspect the actual Service Rules sheetService LogOpen sheet details
Editable inputs
- 300 rows: Service ID, Rule ID, Completed date, Actual odometer, Paid amount, Provider / receipt ref, Recorded distance unit
Calculated or reference
- Vehicle ID, Latest for rule
Record completed service, its actual date, reading, unit and paid cost.
Inspect the actual Service Log sheetCostsOpen sheet details
Editable inputs
- 300 rows: Cost ID, Vehicle ID, Actual date, Category, Paid amount, Receipt / own notes
Calculated or reference
- Input and link checks
Keep fuel, parking and other paid costs separate from service-log spending.
Inspect the actual Costs sheetDocumentsOpen sheet details
Editable inputs
- 100 rows: Document ID, Vehicle ID, Document / record, Confirmed end / due, Original file location, Status
Calculated or reference
- Date state
Record a confirmed document deadline and where the original is kept.
Inspect the actual Documents sheetDue ReviewOpen sheet details
Editable inputs
- No routine entries; review the source records
Calculated or reference
- Vehicle / unit, Next date, Next odometer, Current reading, Read on, Date state, Distance state
Check the next confirmed date and odometer threshold against the dated reading.
Inspect the actual Due Review sheetMonthlyOpen sheet details
Editable inputs
- No routine entries; review the source records
Calculated or reference
- Other costs, Total paid
Review paid service and other costs by month without counting the service cost twice.
Inspect the actual Monthly sheetStartOpen sheet details
Editable inputs
- No routine entries
Calculated or reference
- Instructions and practical limits
Read how vehicle IDs, confirmed rules, service records and units fit together.
Inspect the actual Start sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | A manual list | Vehicle Records & Costs Workbook 1.0 |
|---|---|---|
| Records | Separate notes | 10 connected XLSX sheets |
| Calculation | Manual arithmetic | Use your manufacturer or qualified provider’s intervals, dated odometer readings and actual completed work to calculate the next date and distance threshold. Keep costs and verified document dates alongside. |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
vehicle-records-clean.xlsx
10 connected sheets. Empty customer registers; supplied reference definitions are identified in Start.
vehicle-records-example.xlsx
Separate fictional worked example with the same formulas and fixed capacities.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English labels and guides. One currency, explicit dates and stable text IDs.
Before you choose
Fit and practical limits.
- A household with one or several vehicles
- someone keeping service receipts and confirmed due dates.
Understand the boundaries.
- 20 vehicles; 120 service rules; 300 service log records; 300 other cost records; 100 document records.
- User-entered intervals only. No recommended servicing, repairs, roadworthiness, legal, insurance or safety advice.
- One odometer unit per vehicle. No km/mile conversion, telemetry, live mileage, reminders or diagnostic connections.
- Latest service is determined by completed date, then later physical log row when dates tie. Manual odometer updates remain essential.
- One currency, no depreciation, resale valuation, tax or fuel-efficiency inference. Native Excel verification pending.
Desktop spreadsheet software is separate. Native Excel verification remains pending; Google Sheets and Numbers support has not been established.
Vehicle Records & Costs Workbook / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$5.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
How do I know what to edit?
Blue cells accept records. Grey cells contain formulas. Begin with the separate fictional example and follow START_HERE.pdf. Each register has visible input checks.
Can I add unlimited rows?
No. Capacities are fixed and listed sheet by sheet. Adding rows requires extending formulas, validation and review ranges; it is not a supported automatic expansion.
Does the file send my records anywhere?
No macros or external connections are supplied. Your spreadsheet application and cloud-storage settings are separate.