Business

Expense tracker for a cyber cafe owner in India: what to record

Expense tracker for a cyber cafe owner in India: separate service income from pass-through fees, set up categories and keep a monthly routine.

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

The biggest trap in a cyber cafe's accounts is mixing your own service charge with fees you collect for someone else. A customer hands you ₹500 for a form; part of it is yours, and part goes straight to a portal or office. A tracker that splits the two shows what the cafe really earns.

Income you keep and money you pass on

Make two columns for every sale: your service charge, and any government or third-party fee you collected and paid out. Take an application where the customer pays ₹350 in total. If ₹200 is the portal fee you paid on their behalf and ₹150 is your charge, only ₹150 is your earning. The same rule applies to a ticket booking, a bill payment or an exam form. The money that passes through is not yours, even though it flows through your drawer or UPI.

Cost lines of a cyber cafe

CategoryExamplesNotes
PremisesRent, maintenance, shop licence renewalFixed monthly
InternetBroadband, backup line, routerBilled monthly, often with a lock-in
PowerElectricity, UPS battery replacementRises with long hours
Printing and stationeryPaper, toner, cartridges, lamination pouchesBuy in bulk, note the date
Computers and devicesRepairs, upgrades, new peripheralsFlag big purchases
SoftwareLicences, antivirus, form softwareAnnual renewals are easy to forget
StaffAssistant, part-time operatorOften paid in cash
Pass-through fees paidPortal and office fees collected from customersNot a cost of the cafe
MarketingBanner, visiting cards, listingsOccasional

What does a hypothetical month look like?

Say you earn ₹48,000 in service charges, mostly printing, scans and form assistance, and handle ₹62,000 in pass-through fees that you collect and pay out. Costs: rent ₹14,000, internet ₹2,400, power ₹5,500, paper and toner ₹6,000, assistant ₹10,000, software and repairs ₹3,000, and other ₹1,500, totalling ₹42,400. Your surplus is ₹48,000 − ₹42,400 = ₹5,600. If you had counted the ₹62,000 as income, you would have thought you earned ₹1,10,000, which would be wrong. All numbers here are made up for the example.

Which items are easy to miss?

  • Customer deposits left with you for a pending form.
  • Small UPI payments from many customers that blur together in the bank statement.
  • Cash spent on a toner refill or a data cable at the market.
  • Refunds when a customer cancels a booking after paying.
  • Money you spent from the till for tea or a quick repair.

How should you handle customer information?

Cyber cafes see Aadhaar copies, photos, certificates and login details. Do not keep customers' passwords or OTPs in a notebook, and delete scanned files from the computers after the job is done. This protects your customers and also keeps your shop out of trouble. Ask your CA or a local advisor if you are unsure what the law expects from you.

How do you price against your costs?

Printing and scanning feel cheap per page, but they carry paper, toner, power and machine wear. Look at a month's printing: if you printed 2,400 pages, spent ₹6,000 on paper and toner, and took ₹9,600 from printing, the average take is ₹4 a page and the supplies cost ₹2.50 a page, leaving ₹1.50 a page before rent and electricity. That is thin, so check whether colour printing or bulk jobs are priced to cover their own toner. Your tracker should let you see the supplies line next to the printing income line.

Do the same for form-filling help: if one assisted application takes twenty minutes of your assistant's time, the service charge needs to pay for that time as well as the electricity and the seat.

A monthly routine for a cafe owner

  1. Daily: close the till and write service income, pass-through money and cash spending.
  2. Weekly: match UPI credits with the day's entries.
  3. Monthly: import the bank statement, check each category, and compare printing supplies with printing income.
  4. At year end: list computers and printers bought, with dates and costs.

SpendixAI can take the bank statement, let you review rows and add cash spending in a batch. It does not understand which portion of a payment is a pass-through fee, so you would label those yourself using a category or a note.

SPENDIXAI JOURNAL

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

Explore your reports