📣 Top up ฿1,000+ get 5% bonus · ฿3,000+ get 10% bonus

Excel / Google Sheets Templates

Ready-made templates with formulas for Excel and Google Sheets

Car Garage Job Cards & Parts
เทมเพลต Excel / Google Sheets

Car Garage Job Cards & Parts

  • Job cards by plate, labour and parts, totals with VAT, job status, parts stock and next service reminders
  • Job cards tab: Job no., plate, issue, mechanic, status
  • Parts stock tab: Cost, price, stock and margin
  • Parts used tab: Parts per job, price and qty
  • Invoices tab: Labour, parts, 7% VAT and next service
  • Dashboard with key numbers and charts that update automatically
  • Formulas, drop-downs and colour highlights are ready. Works in Excel and Google Sheets (copy link included)
฿99Lifetime
 

About this template

Job cards by plate, labour and parts, totals with VAT, job status, parts stock and next service reminders

Screenshots from the real file

Dashboard overview and charts
Dashboard overview and charts
Job cards tab
Job cards tab
Parts stock tab
Parts stock tab

Who it is for

  • Car garages
  • Motorbike repair shops
  • Tyre centres

What you get out of it

  • Know every car's status
  • Bill customers correctly
  • Bring customers back for service
  • One file for both Excel and Google Sheets

What is inside the file

How to useGetting-started steps, list of tabs and what the colors mean
DashboardKey numbers and charts that update as you enter data
Job cardsJob no., plate, issue, mechanic, status
Parts stockCost, price, stock and margin
Parts usedParts per job, price and qty
InvoicesLabour, parts, 7% VAT and next service

How to use it

  1. Open "วิธีใช้" (How to use) to see the tabs and colour legend
  2. In "Job cards", clear the sample rows and enter: job no., plate, issue, mechanic, status
  3. In "Parts stock", clear the sample rows and enter: cost, price, stock and margin
  4. In "Parts used", clear the sample rows and enter: parts per job, price and qty
  5. In "Invoices", clear the sample rows and enter: labour, parts, 7% vat and next service
  6. Open "Dashboard" for the overview and charts, calculated instantly

What you receive

  • Excel file (.xlsx), 53 KB, ready to download right after payment
  • A Google Sheets link that makes your own copy in Google Drive, usable on mobile
  • Sample data on every tab so you can see how to fill it in, then replace it with yours
  • Built-in formulas, drop-downs and color alerts

Frequently asked questions

Which programs does this template work with?

It works in both Microsoft Excel and Google Sheets. You get the .xlsx file to download plus a link to copy it into your own Google Drive.

Who is Car Garage Job Cards & Parts for?

Car garages; Motorbike repair shops; Tyre centres

What's inside the file?

5 tabs: Dashboard, Job cards, Parts stock, Parts used, Invoices, with all formulas built in.

Do I need to be good at Excel?

No. Just type into the marked cells; the file calculates and summarises everything, and includes a how-to sheet.

How do I get the file, and how much is it?

It costs ฿99. Once payment is confirmed, download the file and the Google Sheets link right away from your account page.

Product reviews

No reviews yet