Business

Expense tracker for a garage owner in India: what to record

How a garage owner in India can track parts, labour, wages and shop costs: ten categories, business versus personal money and a worked monthly example.

Editorial illustration for Expense tracker for a garage owner in India: what to record

A garage owner has to track two flows that look alike but are not: money for labour and money for spare parts. Record what each job brought in, what the parts cost you, and what the shop itself spent on wages, rent and power, and you will see where your margin really sits.

What are a garage's real cost lines?

CategoryWhat goes in itEasy to miss
Spare parts boughtParts purchased for customer jobs and stockParts bought on credit from suppliers
Mechanic wagesSalary, daily pay, advancesOvertime for urgent jobs
RentWorkshop rent, parking spaceA neighbouring yard rented for waiting cars
ElectricityLift, compressor, welding, lightsGenerator fuel
Lubricants and consumablesEngine oil, coolant, grease, rags, cleaningSmall tins bought across the counter
Tools and equipmentSpanners, jacks, scannersTools replaced after a loss
Equipment servicingLift, compressor, wheel balancerCalibration visits
Outside workDenting, painting, machining sent to othersPaid to another workshop by UPI
Disposal and cleaningOld oil, scrap removal, floor cleaningPaid in cash to a collector
Phone and softwareJob cards, customer messagesSubscriptions that renew by themselves

How do I separate parts from labour?

On each job card, write two amounts: parts and labour. Parts you bought for that job are a cost; the price you charged for them is part of the job's income. Labour is what you earn for the work. Keeping the two columns lets you compare month by month and see, for instance, that you are working more but selling fewer parts.

What about advances, credit and insurance jobs?

  • Customer advances: record date, vehicle number and amount, then adjust against the final bill
  • Credit from a parts supplier: note the bill, the amount and the date you paid
  • Insurance jobs: write the claim reference and note when the insurer's money arrives, since it comes later
  • Regular fleet customers: keep a ledger with dates and balances

What does a hypothetical month look like?

Say a garage receives ₹90,000 in cash and ₹1,50,000 by UPI: ₹2,40,000 in total. Costs: parts bought ₹95,000, rent ₹30,000, mechanic wages ₹50,000, electricity ₹8,000, lubricants and consumables ₹10,000, tools ₹3,000, equipment servicing ₹4,000 and cleaning and disposal ₹1,000. Added up, that is ₹2,01,000.

₹2,40,000 minus ₹2,01,000 leaves ₹39,000. If you drew ₹28,000, ₹11,000 stayed in the business. Only an example to show the arithmetic.

What is a simple monthly routine?

  1. Each day, total the job cards closed and the cash and UPI received.
  2. Each time you buy parts, keep the bill and write the supplier name and amount.
  3. Each week, update the advances list and the credit list.
  4. Each month, download the statement and match it to job card totals.
  5. Each month, split costs into parts, wages, shop costs and tools, and compare with the last month.

A quiet month tells you things too. If labour money drops while parts money holds, customers may be buying parts and going elsewhere for fitting. If both drop together, look at the calendar: monsoon, a long festival week or a road closure near the workshop. Write a one-line reason beside each month so next year's figures can be read fairly.

When might an app help?

SpendixAI can import the garage account's statement as PDF, CSV or Excel, let you review each row before saving, and sort rows into categories you set up, such as parts or consumables. You can add cash costs by hand, several at once. It does not manage job cards or inventory.

Month-end checklist

  • Job card totals match the statement
  • Parts bills filed with supplier names
  • Advances and credit lists updated
  • Drawings written as drawings
  • Any doubt noted for your CA
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports