Business

Expense tracker for a mobile repair shop owner in India: what to record

Expense tracker for a mobile repair shop owner in India: parts, margin per repair, categories, cash items and a monthly routine, with a worked example.

Editorial illustration for Expense tracker for a mobile repair shop owner in India: what to record

A mobile repair shop lives on the gap between what a customer pays for a repair and what the spare part cost you. Record parts, labour and accessories as separate lines, and you will see which jobs actually earn money and which just keep you busy.

Where the money comes from, and where it goes

Income at a repair shop has at least three kinds: repair charges, accessory sales (covers, chargers, tempered glass) and sometimes buying and selling used phones. Costs are parts, rent, power, tools and your helper's pay. Keep income lines separate, and your cost of parts attached to the sales they relate to.

Category list for a repair shop

CategoryExamplesBusiness or personal?
Spare partsScreens, batteries, charging ports, speakersBusiness
Accessories stockCovers, cables, earphones, protectorsBusiness
Tools and consumablesSoldering tools, hot air station, adhesiveBusiness
PremisesRent, electricity, shop licence renewalsBusiness
StaffTechnician, helperBusiness
Online or local advertisingBoards, listings, bannersBusiness
Used phone purchasesPhones bought from customers for resaleBusiness, keep papers
Returns to suppliersFaulty parts sent backReduce part cost when credited
Personal useYour own phone repairs, family accessoriesPersonal

How do you work out margin on one repair?

Say a customer is charged ₹2,800 for a screen replacement. The screen cost you ₹1,900 and you spent ₹60 on adhesive and a protector. Your part margin is ₹2,800 − ₹1,900 − ₹60 = ₹840, from which you still pay rent, the technician and tools. If the new screen fails in the first week and you replace it free, you lose the extra part cost and an hour of labour; note that on the same job so the real result shows. The prices above are invented for illustration.

What does a hypothetical month look like?

Suppose repairs bring ₹86,000 and accessories ₹24,000, a total of ₹1,10,000. Parts used cost ₹41,000, accessory stock sold ₹14,000, rent ₹12,000, power ₹3,000, technician ₹15,000, tools and other ₹4,000. Costs add up to ₹89,000, leaving ₹21,000. The accessory side earned ₹24,000 − ₹14,000 = ₹10,000, while repairs earned ₹86,000 − ₹41,000 = ₹45,000 before overheads.

What gets forgotten?

  • Parts bought from a local market dealer in cash.
  • Advances taken from customers for hard-to-find parts.
  • Faulty parts returned to the supplier and credited later.
  • Phones left unclaimed by customers, which tie up parts and money.
  • Tea, fuel and courier charges for picking up parts.

Warranty matters here. If you give customers a short warranty on a replaced part, keep a note of it on the job card, and set aside a small amount each month for free redo jobs. Even a rough figure, such as ₹1,000 a month, stops a single bad batch of screens from surprising you.

What about buy-and-sell of used phones?

If you buy used phones from customers and sell them on, treat each one as its own small transaction. Note what you paid, what you spent on repairs and the price you finally sold at. Suppose you pay ₹7,500 for a phone, spend ₹900 on a new battery and sell it for ₹9,800: the result is ₹9,800 − ₹7,500 − ₹900 = ₹1,400. Phones that sit unsold are money tied up, so keep a short list with purchase dates and look at it each month.

A monthly routine

  1. Match each job card with payment received.
  2. Enter supplier bills and any cash purchases.
  3. Count the stock of fast-moving parts and accessories.
  4. Compare parts cost with repair income.
  5. Note the advances held and the devices waiting.

SpendixAI can bring in the bank statement and categorise what it can with your own rules, and you can add cash purchases in batches. It does not track repair jobs or stock, so a job register in a notebook or sheet is still needed.

SPENDIXAI JOURNAL

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

Explore your reports