Business

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

Expense tracker for a homestay owner in India: platform commissions, guest income by UPI and cash, shared home costs, categories and a worked month.

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

A homestay owner's tracker has to deal with three awkward facts: guests pay in different ways, platforms keep a commission before paying you, and the home you live in is also the business. Track gross booking value, commission and what you actually receive as separate numbers, tag shared costs, and you will see what the homestay really earns. Below are categories, a worked month and the usual blind spots.

How do guests pay, and how should it be recorded?

Bookings may come through an online platform that pays you after deducting its commission, from direct UPI transfers, or as cash at check-in. Record each booking at its full value, then record the platform's commission as an expense, then record what arrived in your account. That way your bank statement matches your records, and you can see what each channel costs you.

Advance deposits need care. Money received to hold a date is not income for a stay that has not happened and may need to be refunded. Note them as advances and mark them done when the guest has stayed.

Which categories should a homestay use?

  • Booking income by channel: platform, direct UPI, cash
  • Platform commission
  • Housekeeping and laundry
  • Food and breakfast supplies
  • Cook or helper pay
  • Electricity, water and gas
  • Internet and phone
  • Repairs and maintenance
  • Guest amenities and linen
  • Own drawings and personal use

What does a month look like in numbers?

Say bookings through a platform were worth ₹60,000, but the platform kept ₹8,000 and paid you ₹52,000. Direct UPI bookings were ₹25,000 and cash was ₹9,000. Gross booking value is ₹60,000 plus ₹25,000 plus ₹9,000, which is ₹94,000. Money actually received is ₹52,000 plus ₹25,000 plus ₹9,000, which is ₹86,000.

Cost lineAmount in ₹
Housekeeping and laundry12,000
Food and breakfast14,000
Cook or helper10,000
Electricity and water6,500
Internet1,000
Repairs4,500
Total running costs48,000

Gross ₹94,000 less platform commission ₹8,000 less running costs ₹48,000 leaves ₹38,000. It is a hypothetical month, but it shows why watching only the amount that reaches your account can mislead you.

How do I handle costs shared with the family?

If you live in the same house, electricity, water, gas and internet serve both guests and family. Choose a reasonable share, for instance by the number of rooms in use, and apply it the same way every month. Write the rule down. Groceries bought for the family kitchen are personal; breakfast supplies for guests are business. If you are unsure how to treat a shared cost for tax, ask your CA once.

Which receipts and cash items are most often missed?

  1. Cash paid to the cleaner who comes only on checkout days.
  2. Last-minute supplies, such as toiletries and gas cylinders.
  3. Refunds to a guest after a cancellation.
  4. Small repairs paid in cash to a local mechanic or plumber.
  5. Commission to a local agent who sent guests directly.

How do off-season months look?

Fixed costs such as the cook, internet and base electricity carry on when rooms are empty. Say an off-season month brings ₹30,000 gross and fixed costs are ₹14,000. That leaves ₹16,000 before breakfast supplies, laundry and repairs. Seeing that number in advance helps you decide on minimum stays or a lower rate, instead of discovering a loss after the season ends.

What routine will keep this simple?

  • At check-in, note the booking, the amount and how it was paid.
  • At checkout, note the final amount and any refund or deposit adjustment.
  • Weekly, note supplies and cash costs.
  • Monthly, match platform payout reports against your bank statement.

SpendixAI can take a bank statement as PDF, CSV or Excel, let you review rows before saving, and keep cash entries added by hand. It does not manage bookings or calendars, so keep those on your booking platform or in your diary.

SPENDIXAI JOURNAL

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

Explore your reports