Business

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

How a mobile phone shop owner in India can track expenses: cost lines, personal versus shop money, 10 categories, missed cash items and a monthly routine.

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

A mobile phone shop owner should track expenses under about ten categories, with phones, accessories, repairs and recharges kept as separate income lines. Do that, and it becomes easy to see which part of the shop earns and which only keeps stock moving.

What does a mobile shop really spend on?

Handset stock ties up the most cash, but the small lines make the month. A shop that sells a few phones, many covers and a stream of screen repairs has costs that look different from a general store.

  • Handsets and feature phones bought from distributors, including those taken on credit
  • Accessories: chargers, covers, tempered glass, earphones, memory cards
  • Spare parts for repair work, such as screens, batteries and charging ports
  • Rent, electricity and the shop's internet connection
  • Technician pay, helper pay and your own drawings
  • Recharge and bill-payment wallet top-ups, if you run that counter
  • Display racks, counter glass, signage and promotional boards

Which ten categories should I set up?

CategoryWhat goes in it
Handset stockNew and refurbished handsets bought
Accessory stockCovers, glass, chargers, cables
Repair partsScreens, batteries, tools, solder
Rent and powerRent, electricity, broadband
StaffTechnician, helper, festival bonus
Wallet top-upsMoney loaded for recharge services
MarketingBanners, local ads, festival offers
Fees and interestCard charges, loan interest
Shop upkeepDisplay, repairs to fittings
Owner drawingsMoney moved to personal use

What is shop money and what is personal?

A phone shop invites personal blurring because you handle devices all day. Your family's phone, a new handset for your child, or a recharge for relatives paid from the wallet are all personal. Record each as a drawing, with the amount and the model or purpose. It also helps to keep the recharge wallet balance in a separate sheet from the till.

Which cash items do owners forget?

  • Small parts bought from a neighbouring shop when a repair is urgent
  • Courier charges for sending a handset to a service centre
  • Tea and snacks for walk-in repair customers
  • Cash refunds when a cover or charger is returned
  • Advance paid to a distributor for a model launch

Keep a small notebook by the counter. Date, amount, one-word reason. It takes seconds.

How might a month look, with simple numbers?

Say the month's takings are ₹5,50,000: handsets ₹4,00,000, accessories ₹80,000, repairs ₹50,000 and recharge commission ₹20,000. Handset purchases for the month are ₹3,40,000, accessories ₹45,000, repair parts ₹15,000, rent and power ₹35,000, staff ₹40,000, marketing ₹6,000, fees and interest ₹9,000 and upkeep ₹4,000. The outgoings add up to ₹4,94,000, leaving ₹56,000 before drawings.

Now split the takings. Accessories brought ₹80,000 against ₹45,000 of stock, a gap of ₹35,000. Repairs brought ₹50,000 against ₹15,000 of parts, a gap of ₹35,000. Handsets brought ₹4,00,000 against ₹3,40,000, a gap of ₹60,000. The shop does most of its work on handsets, but repairs and accessories earn well for the money tied up.

What should my routine be at month end?

  1. Enter bank and card lines from the statement.
  2. Add the cash notebook and voucher slips.
  3. Match each distributor bill with its payment.
  4. Check the recharge wallet balance against its loads.
  5. Note the stock left on the shelf for the month.

SpendixAI can import the shop account statement as PDF, CSV or Excel, and show the rows for you to check before they are saved. You can add cash entries by hand, and use sub-categories under stock, such as handsets and accessories, to see each line's total in a report.

Next step

List the last twenty cash payments you remember. If more than five do not fit your categories, add one more category before next month begins.

SPENDIXAI JOURNAL

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

Explore your reports