Bike Repair Job Log Kit - Excel & Google Sheets
Job log for bike repair shops and mobile mechanics. Price repairs from your own rate list, track parts costs, and see revenue and money still owed.
TRACKS
- Settings: your repairs (tune-ups, brakes, wheels) with prices
- - Jobs: date, customer, bike, repair (dropdown), parts cost you type, an optional price override for one-off jobs, status (Received, Working, Done, Paid, Cancelled)
- - Month rollups for any months you type (no hardcoded years)
CALCULATES
- Job total = repair price + parts cost
- - Jobs, revenue, money collected, and amounts outstanding, overall and per month
- - Value of work in progress and parts spend on completed jobs- Status-based: no partial payments. Cancelled jobs are ignored. Month rollups count Done and Paid jobs only. A repair name not on your Settings list shows in red, and a check row flags jobs with a total but no status.
No tax or filing features.
WHAT'S INSIDE
- Bike Repair Job Log.xlsx with Jobs, Dashboard, Settings, Monthly, Instructions
- - Fictional sample rows you can delete in seconds to start fresh
- - Quick-start README with step-by-step instructions for Excel and Google Sheets
INSTANT DOWNLOAD
One ZIP file: the spreadsheet (xlsx) and a README (txt). Works in Microsoft Excel and Google Sheets (upload the xlsx to Google Drive). Designed for Excel and Google Sheets; tested in LibreOffice Calc.
Created with AI assistance and reviewed before publication.