# Tire and Wheel Spending Log: Tracking Tire Expenses in a Spreadsheet

Build a tire expense tracker in a spreadsheet: columns for tire purchase records, mounting and balancing fees, receipts, and a cost per mile figure.

A tire and wheel spending log is a spreadsheet that records what you pay for tires, wheels, and the labor around them. Keeping a tire expense tracker in one file turns scattered receipts into a cost history you can read. The page shows the columns to set up, the cost categories to separate, and how to turn the totals into a cost per mile figure. 

## Columns that carry the record 

A car tire cost tracking spreadsheet needs one row per purchase event, not one row per tire. Typical columns cover the date, the vehicle, the tire size from the sidewall, the quantity, the unit price, and the vendor. Add a column for the receipt or invoice number so paper and screen stay linked. A notes column holds what the invoice does not, such as a road hazard policy or a treadwear rating. 

## Split the cost categories 

Tire money arrives in parts, and mixing them hides where the spending goes. Keep the tire price, wheel price, mounting and balancing fees, valve stems, disposal charges, and taxes in separate columns. A total column then adds those parts for each event. This split lets you compare a [tire replacement cost](/articles/average-tire-replacement-cost/) history across seasons and see whether labor or hardware drove the bill. 

## Cost per mile from the log 

Cost per mile for tires divides the total spent on a set by the distance that set covered. The log supplies the first number, and the odometer readings at fitting and removal supply the second. Enter an odometer column at each tire change so the distance is recorded, not estimated. The result depends on driving conditions and tire type, so treat it as a comparison between your own sets rather than a fixed figure. 

## Questions about the tire spending log 

### What should a tire expense tracker include? 

A tire expense tracker includes the date, vehicle, tire size, quantity, unit price, and vendor for each purchase. Add the mounting and balancing fees, taxes, and the receipt or invoice number in their own columns. Keep an odometer reading at each change so the log can support a cost per mile figure later. 

### How do I track tire purchase records across several vehicles? 

Tire purchase records stay clear across several vehicles when every row carries a vehicle name or plate column. A monthly tire spending summary then groups by that column instead of by calendar month alone. Keep one sheet for entries and a separate summary sheet that reads from it. 

### Where do mounting and balancing fees go in the log? 

Mounting and balancing fees belong in their own column, apart from the tire price. These charges are labor and hardware rather than the tire itself, and separating them shows the true cost of a set. The same applies to valve stems, disposal charges, and wheel alignment when it is billed with the tires. 

### How is cost per mile for tires calculated from the log? 

Cost per mile for tires is the total paid for a set divided by the distance that set covered. The spending log gives the total, and the odometer readings at fitting and removal give the distance. Record those readings as they happen, because a missing figure forces an estimate that weakens the comparison.
