Business

Expense tracker for a coworking space owner in India: what to record

Expense tracker for a coworking space owner in India: income and cost lines, business versus personal, category ideas and a monthly routine to follow.

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

A coworking space earns from desks, cabins and meeting rooms, and spends most of it on rent, power, internet and housekeeping before the first member walks in. Track income by type and costs by a short, fixed list of categories, and you will see quickly whether your seats are paying for the space.

Start with income lines, not just costs

Coworking income is more varied than a shop's. Keep separate lines for each so you can tell what is growing.

  • Dedicated desk and private cabin memberships, usually monthly.
  • Hot desk plans and day passes.
  • Meeting-room and event-hall hours, often paid by the hour.
  • Add-ons: printing, locker rent, mail handling, virtual office address.
  • Security deposits taken from members, which are held rather than earned.

Which cost lines does a coworking space carry?

CategoryWhat goes inMark as
PremisesRent, maintenance charge, property taxBusiness
PowerGrid electricity, generator diesel, UPS battery serviceBusiness
InternetPrimary line, backup line, router replacementBusiness
HousekeepingCleaners, consumables, pest controlBusiness
PantryTea, coffee, water cans, snacksBusiness
StaffCommunity manager, receptionist, maintenanceBusiness
Software and accessBooking tool, door access, CCTV subscriptionBusiness
Repairs and furnitureChair replacement, AC service, paintFlag big purchases
Marketing and eventsListings, brokers, member meetupsBusiness
Your own spendPersonal travel, family use of the spacePersonal, keep out

What does a hypothetical month look like?

Say you have 30 dedicated desks at ₹8,000 and 10 hot desks at ₹3,500, plus ₹12,000 from meeting rooms. Income: 30 × ₹8,000 = ₹2,40,000, plus 10 × ₹3,500 = ₹35,000, plus ₹12,000, totalling ₹2,87,000. Costs: rent and maintenance ₹1,25,000, power ₹28,000, internet ₹9,000, housekeeping ₹18,000, pantry ₹14,000, staff ₹60,000, software ₹6,000, and repairs and other ₹10,000, totalling ₹2,70,000. That leaves ₹17,000. If five dedicated desks stand empty, you lose 5 × ₹8,000 = ₹40,000 and the month turns into a loss of ₹23,000. All figures here are invented to show the method.

Where do receipts and cash go missing?

  • Pantry runs done on the owner's personal UPI because the business account was not handy.
  • Day-pass money taken in cash at the desk and never entered.
  • Meeting-room refunds when a booking is cancelled at short notice.
  • Advance rent paid to the landlord, or an advance taken from a corporate client for a team of desks.
  • Generator diesel bought in cans from a neighbouring pump with no bill.

How do you treat one-off set-up spending?

Fit-out, furniture and wiring done when you open are not like a monthly cleaner's bill. Keep the invoices, list each item with date and cost, and ask your CA how such purchases are handled. In your tracker, tag them separately so they do not distort one month's picture. If you later add a floor, tag the new spending the same way.

How do you see which plan earns the most?

Tag each income entry with its plan. At month end, divide plan income by the number of seats on that plan. If hot desks bring in ₹35,000 across 10 seats, that is ₹3,500 a seat, against ₹8,000 for a dedicated desk. Then think about the space each takes: a hot desk that is used by many people in rotation may justify its price, while a cabin that sits half-empty may not. The tracker does not decide this for you, but it puts the numbers on one screen so you can.

Look at the pantry and power lines too. They rise with footfall, so a month with new members should show them moving up. If power climbs with no new members, check for a faulty AC or a meter shared with a neighbouring tenant.

A routine that fits a busy community manager

  1. Weekly: enter pantry, repair and cash items before the bills pile up.
  2. Monthly: import the bank statement, check each member's payment, and list who is yet to pay.
  3. Quarterly: read the cost lines for jumps, especially power and internet.
  4. Year end: ask your CA what list of fixed assets they want.

SpendixAI can take the account statement as a PDF, CSV or Excel file, show you the rows to review before saving, and group spending into the categories you set up. It does not run memberships, invoicing or desk bookings, so keep those in your coworking software.

SPENDIXAI JOURNAL

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

Explore your reports