Business

A fixed-cost sheet for a shop: rent, power, wages and loans

A one-page fixed-cost sheet for a small shop: list monthly costs with amount, due date and payee, then find the total and the daily figure.

Editorial illustration for A fixed-cost sheet for a shop: rent, power, wages and loans

A fixed-cost sheet is a one-page list of everything you falls due each month whether or not the shop sells well: rent, power, wages, loan instalments and the phone bill. Write the amount, the due date and who you pay, then add the amounts. Divide the total by your trading days and you get the daily figure your shop has to cover before it earns anything for you.

What goes on the sheet?

Four columns are enough: cost, payee, due date and amount. Sort the rows by due date so you can see the month in order. Here is a made-up shop that opens six days a week.

CostPayeeDue dateAmount
Shop rentLandlord5th₹18,000
Helper 1 wagesHelper 11st₹9,000
Helper 2 wagesHelper 21st₹8,000
Shutter loan instalmentBank10th₹4,500
Electricity (usual bill)Power company18th₹3,200
Phone and internetProvider22nd₹600
Total--₹43,300

The total is 18,000 + 9,000 + 8,000 + 4,500 + 3,200 + 600 = ₹43,300. In a spreadsheet with the amounts in D2 to D7, the total is =SUM(D2:D7).

How do you get a daily figure?

Say the shop trades 26 days in the month, closed on Sundays. The fixed cost per trading day is 43,300 / 26 = ₹1,665.38, so about ₹1,665. In a spreadsheet, =D8/26.

This tells you something practical. If your average margin on sales is 20 percent, you need sales of about 1,665.38 / 0.20 = ₹8,327 a day just to pay the fixed costs. Anything above that starts to become profit, and anything below it is a loss for the day. Use your own margin from your own records.

Is electricity really a fixed cost?

Not entirely. It moves with the season and your hours. Treat the figure as an average of the last three or four bills and mark it as usual. The same goes for the phone bill if it includes extra usage.

What about costs that come once or twice a year?

Annual items are easy to forget until the day the bill arrives. Convert them to a monthly figure by dividing the yearly amount by 12. If your licence renewal is ₹6,000 a year, put ₹500 a month on the sheet. If you set it aside every month, the bill will not be a shock.

What should you add that people often miss?

  • Society or market association charges.
  • Insurance premiums, if you have any.
  • Shop licence or registration renewals.
  • Accountant or CA fees, spread across twelve months.
  • Software, billing machine rental or a recharge for the card machine.
  • Your own drawings, if you pay yourself a fixed amount each month.

Why is the due-date column worth having?

Cash does not come in evenly through the month, but costs fall due on fixed dates. Seeing that rent on the 5th, the instalment on the 10th and wages on the 1st all land in the first ten days shows you why money feels tight early in the month. In the example, 9,000 + 8,000 + 18,000 + 4,500 = ₹39,500 is due by the 10th. If you keep a weekly cash note, you can set money aside before those dates.

How to use the sheet each month

  1. On the 1st, print or open the sheet and tick each cost as you pay it.
  2. Note the actual amount when it differs, such as a higher power bill.
  3. Compare each month's total with the last, and ask what changed.
  4. Update the daily figure whenever the total or the trading days change.

SpendixAI Pro has budgets, bills and savings goals, so a list like this can also live next to the statements you import, if you prefer one place for both.

SPENDIXAI JOURNAL

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

Explore your reports