Auto Repair Shop Expenses Spreadsheet — Free Monthly Template

Contents

• Why Tracking Expenses Changes How You Run Your Shop
• Fixed vs. Variable Costs in an Auto Repair Shop
• The Key Expense Categories for Auto Repair Shops
• Reading Your Cash Flow Numbers
• How to Use the Free Expenses Spreadsheet
• Frequently asked questions
• Conclusion

At the end of a busy week, most shop owners can tell you roughly how many cars came through. But ask them what their net cash flow was last month — or whether labor costs are creeping up as a share of revenue — and the answer is usually a vague shrug or a long pause before opening a bank statement.

Tracking expenses and cash flow isn’t glamorous, but it’s the difference between a shop that survives slow months and one that doesn’t. This page gives you a free auto repair shop expenses spreadsheet you can download instantly — no email, no sign-up — along with a plain-language guide to what numbers matter and how to read them.

What this spreadsheet tracks at a glance

Revenue lines	Labor revenue, parts revenue, other — total for each month
Expense categories	12 line items: rent, utilities, parts/inventory, payroll, taxes/benefits, shop supplies, tools, insurance, marketing, software, loan payments, misc
Net Cash Flow	Revenue minus total expenses — the number that matters most
Time horizon	All 12 months across a single row — spot seasonal patterns instantly
Format	Excel / Google Sheets compatible (.xlsx) — no formulas to break

Why Tracking Expenses Changes How You Run Your Shop

Most shop owners have a gut feel for how business is going. When the bays are full and the phone is ringing, things feel good. When it’s quiet, things feel bad. The problem is that gut feel doesn’t tell you which cost category is eroding your margin, or whether a slow February was a cash-flow problem or just a seasonal dip you could have planned for.

Consistent expense tracking gives you three things gut feel can’t:

• Visibility into cost creep. Parts costs up 4% this quarter? You won’t notice in the noise of daily operations — but a monthly spreadsheet will flag it immediately.
• Cash-flow forecasting. Knowing that your shop spends roughly $12,000/month in fixed costs tells you exactly how many repair orders you need to break even. That number is powerful when planning staffing, equipment purchases, or slow-season survival.
• Evidence for decisions. Should you hire another tech? Add a second lift? The answer lives in your expense and revenue data — not in a feeling.

The free spreadsheet below organizes all of this into a single monthly view. Fill in the numbers once a month — it takes about 20 minutes if your records are in order — and within three months you’ll see patterns you’ve never seen before.

Fixed vs. Variable Costs in an Auto Repair Shop

Before you start tracking, it helps to understand which costs behave differently. Every expense in a shop falls into one of two buckets:

Fixed costs

These stay roughly constant regardless of how many cars you service. They show up every month whether you’re slammed or dead slow:

• Rent or mortgage on your building
• Base payroll for any salaried staff
• Insurance premiums
• Loan payments on equipment or vehicles
• Software and subscription fees

Fixed costs are dangerous in slow months because they don’t shrink with your revenue. A shop with $8,000 in fixed monthly costs needs to generate at least $8,000 in gross profit before paying the owner or reinvesting anything. Knowing that number cold is the foundation of cash-flow planning.

Variable costs

These scale — at least partially — with car count and revenue:

• Parts and inventory (directly tied to repair volume)
• Payroll for hourly technicians
• Payroll taxes and benefits (tied to hours worked)
• Shop supplies (fluids, rags, shop towels — scale with throughput)
• Credit card processing fees (tied to revenue)

Variable costs are easier to manage in slow periods but they also set a floor on your gross margin. If your parts cost is consistently running above 40% of parts revenue, you’re either pricing parts too low or your supplier costs are out of line — and your expense spreadsheet will surface that trend before it becomes a crisis.

The Key Expense Categories for Auto Repair Shops

The spreadsheet template uses 12 expense line items. Here’s what goes in each one and why it matters:

Rent / Mortgage

Your single largest fixed cost. If you’re leasing, record the monthly lease payment. If you own the building with a loan, record the mortgage payment. Industry benchmarks put rent at 5–10% of gross revenue for a well-located independent shop — if yours is higher, that’s a flag worth watching.

Utilities

Electricity, gas, water, internet, and phone. Shops are heavy electricity users — compressors, lifts, lighting, and diagnostic equipment add up. Tracking utilities monthly lets you catch an unusually high bill before it compounds across quarters.

Parts / Inventory

What you actually pay for parts and fluids that go into customer vehicles. This is typically the largest variable cost line. A healthy independent shop runs parts cost at 40–50% of parts revenue. Above 55% usually means pricing or supplier issues; below 35% sometimes means under-billing on parts.

Payroll & Wages

All compensation paid to technicians, service advisors, and any other hourly or salaried staff. Track gross wages — before tax withholding — so you can compare apples to apples month over month. Labor cost typically runs 25–35% of total revenue in a profitable shop.

Payroll Taxes / Benefits

Employer-side FICA, unemployment insurance, workers’ comp premiums, and any health insurance contributions. These are easily forgotten because they’re not in the paycheck, but they add 15–25% on top of gross wages for most shops.

Shop Supplies

Chemicals, rags, shop towels, nitrile gloves, absorbent material, brake cleaner, and similar consumables. This category tends to creep up slowly and go unnoticed — tracking it monthly catches the drift.

Tools & Equipment

New tool purchases, equipment repairs, calibration costs, and subscription-based scan tools. Large equipment purchases may be capitalized rather than expensed — check with your accountant — but smaller tools and ongoing maintenance costs belong here.

Insurance

General liability, garagekeepers liability, commercial auto, and any other business insurance premiums. Some policies bill annually — spread the cost evenly across 12 months for a more accurate monthly picture.

Marketing / Advertising

Google Ads spend, postcard mailers, Yelp or Google Business Profile paid upgrades, website costs, and social media ads. Tracking this against new customer acquisition over time shows you what’s actually working. For more on getting new customers in the door, see our auto repair shop forms kit — having professional intake forms builds trust from the first visit.

Software / Subscriptions

Shop management software, parts catalog subscriptions (Mitchell, Alldata), accounting software, payment processors, and any SaaS tools your shop uses. A full-featured shop management platform like Garage runs $39–$69/month — a small line in this category that returns leverage across nearly every other line.

Loan Payments

Monthly payments on equipment loans, SBA loans, business lines of credit, or vehicle notes. Track the full payment here; your accountant will split it into principal and interest for tax purposes.

Miscellaneous

Everything that doesn’t fit cleanly above — bank fees, professional dues, licenses, small office supplies, uniforms, and one-off costs. If miscellaneous consistently runs above 3–4% of revenue, it’s worth breaking out into its own categories to understand what’s hiding there.

Reading Your Cash Flow Numbers

Once your spreadsheet has two or three months of real data, the Net Cash Flow row at the bottom becomes your most important diagnostic. Here’s how to read it:

Positive but volatile

If net cash flow is positive most months but swings wildly — say, $4,000 in March and $600 in April — you likely have a seasonality pattern and a need for a cash reserve. Identify your slow months from the data and build the reserve during your strong months. Most independent shops see softer demand in January–February and often in late summer.

Consistently thin margins

If net cash flow is positive but always small relative to revenue, compare your expense categories to the benchmarks above. Common culprits: parts cost running above 50%, payroll creeping above 35%, or rent above 10% of revenue. The fix is usually a combination of pricing adjustments and cost discipline — but you can only find it in the data.

Negative months

A negative cash flow month isn’t always a crisis — a large equipment purchase or an unusually slow stretch can cause it. But two or three negative months in a row is a serious signal. Cross-reference with your revenue lines: is revenue flat while costs are rising, or did revenue drop while costs held steady? The answer points to very different solutions.

For a deeper look at how labor revenue connects to shop profitability, our effective labor rate calculator shows you exactly how much revenue you’re leaving on the table per paid tech hour.

How to Use the Free Expenses Spreadsheet

The template is designed to be filled in once a month — ideally within the first week of the following month, when invoices are fresh and bank statements are available. Here’s a simple workflow:

1. Download the .xlsx file and open it in Excel, Google Sheets, or Numbers.
2. At month end, pull your bank statement or accounting software report.
3. Enter your total revenue from labor invoices in the Labor revenue row, and your total parts revenue in the Parts revenue row.
4. Work through each expense category and enter what you actually spent — not what you budgeted, but actual dollars out.
5. The Net Cash Flow row shows Revenue minus Total Expenses for each month.
6. After three months, look at the patterns: which costs are rising? Which months are softer? Where are you leaving money on the table?

If you want to add formulas, the Total Revenue, Total Expenses, and Net Cash Flow rows can easily be turned into SUM formulas — but the template intentionally leaves them as fill-in cells so it works for owners who prefer simplicity.

For a clean, professional format to send customers — which ultimately drives the revenue side of this spreadsheet — download our free auto repair invoice template.

Frequently asked questions

What is the most important expense category for an auto repair shop?

Payroll and parts/inventory together typically make up 55–65% of total revenue in an auto repair shop — making them the categories that most directly determine profitability. Payroll (wages plus payroll taxes and benefits) usually runs 25–35% of revenue; parts cost typically runs 40–50% of parts revenue. If either number is consistently above these ranges, it’s the first place to investigate when margins are thin.

What’s the difference between cash flow and profit in a shop?

Profit is an accounting concept that spreads certain costs (like depreciation of equipment) over time. Cash flow is simply money in minus money out in a given period. For day-to-day shop management, cash flow is more useful — it tells you whether you can pay your bills this month. A shop can be ‘profitable’ on paper but cash-flow negative if it has a large loan payment or is carrying a lot of parts inventory. The spreadsheet tracks cash flow, not accounting profit.

How much should an auto repair shop spend on parts?

A common benchmark is 40–50% of parts revenue — meaning if you billed $10,000 in parts to customers, your cost for those parts should be $4,000–$5,000. Below 40% may mean you’re billing parts at strong margins, which is healthy. Above 55% typically means your parts markup is too low, your supplier pricing is uncompetitive, or you’re absorbing supplier freight costs that should be passed through.

Can I use this spreadsheet if I already have accounting software?

Yes — the two serve different purposes. Accounting software (QuickBooks, Wave, etc.) handles bookkeeping, taxes, and detailed transaction records. This spreadsheet gives you a monthly bird’s-eye view of the major expense categories as they relate to your shop operations. Many owners pull summary numbers from their accounting software and paste them into the spreadsheet for a quick monthly review, rather than digging into the full P&L every time.

What software do auto repair shops use to track expenses and invoices?

Options range from general accounting tools (QuickBooks, Wave) to shop-specific management platforms. General accounting tools handle the financial side well but don’t track repair orders, labor, or vehicle history. Shop management software like Garage ($39/mo) combines repair orders, estimates, invoicing, customer and vehicle history, and reporting in one place — so the expense data flows naturally from the jobs you’re already closing, rather than needing to be entered separately.

Conclusion

Profitable shops aren’t just busy shops — they’re shops where someone is watching the numbers. The expense spreadsheet on this page gives you a structured monthly view of every major cost category, so you stop finding out where the money went three months after the fact.

Download it, fill it in for the last month, and see what you find. Most shop owners who do this exercise for the first time spot at least one category that’s quietly running higher than they expected. That one discovery usually pays for the 20 minutes it took to fill in the template.

When you’re ready to move beyond spreadsheets — with repair orders, invoices, customer history, and reporting all in one place for $39/mo instead of the $200-plus tools — Garage is built for exactly that.