Take your last three months of sales and costs, group the costs into six to eight lines, and work out each line as a share of sales: how many paise of every rupee it eats. The line whose share keeps rising is where the money is leaking. Fix that one first instead of cutting everything a little.
Why it matters
Costs in rupees always look scary, and they always go up when you get busier. The useful question is different: out of each ₹100 a customer pays, how much goes to raw material, how much to staff, how much to rent? If raw material took ₹34 in August and ₹39 in October while your prices didn't change, something in buying, portions or wastage has slipped, and that's worth more than a new marketing push.
Before opening, every number was an estimate. Now you have real bills, real purchase invoices and a billing app or UPI history that shows what came in. Three months is enough to see a trend and smooth out one odd week, and it's the first time you can check whether the costs you planned in your break-even sum match the ones you actually pay.
How to do it
Set aside an evening with your bank statement, purchase invoices, salary register and billing app reports. A Google Sheet with one column per month is enough.
Get sales for three full months
Use the sales report from your billing app if you have one; otherwise add up cash, UPI settlements and card settlements from the bank statement and your cash book. If you charge GST, use sales without GST. Note anything unusual next to the month: a festival, a week closed for repairs, a big one-off catering order.
Sort every rupee spent into a few lines
Go through the bank statement and invoices and put each payment into one of these: raw material and stock, packaging, staff (salaries, overtime, staff food, PF/ESI if you pay it), rent and maintenance, electricity and gas, commissions and payment charges, and everything else. Leave out loan principal and what you put into new equipment; those aren't running costs. If you're registered for regular GST, record purchases without the input tax you'll claim back.
Adjust raw material for stock on the shelf
A big stock-up at month end makes that month look terrible and the next one look great. If you count stock, use opening stock plus purchases minus closing stock. If you don't, look at the three-month total for raw material rather than reading too much into a single month.
Turn each line into paise per rupee
Divide each cost line by that month's sales. ₹1,26,000 of raw material on ₹3,60,000 of sales is 35%, or 35 paise of every rupee. Put the three months side by side. You're looking for a share that moves in one direction, not one that wobbles by a point.
Ask why the rising line rose
A rising variable cost (raw material, packaging, commissions) usually means one of four things: the supplier's rate went up, portions or usage grew, more is being thrown away, or more orders came through a channel with higher costs. A rising fixed cost (rent, staff) usually means sales fell, so the same rent is a bigger share. The cure for each is different, so check purchase invoices for rate changes before blaming the kitchen.
Pick one line and one action
Write down the line, the likely cause, and what you'll do this month: recheck prices on your main items, start a wastage log, change a portion, or move some orders to a cheaper channel. Then repeat the sheet next month to see if the share came back down.
| Illustrative small cafe | Aug | Sep | Oct |
|---|---|---|---|
| Sales (no GST) | ₹3,40,000 | ₹3,55,000 | ₹3,60,000 |
| Raw material | 34% | 36% | 39% |
| Staff | 24% | 23% | 23% |
| Rent | 15% | 14% | 14% |
| Commissions and payment charges | 6% | 7% | 8% |
| Electricity and gas | 5% | 5% | 6% |
In that example the owner would check whether milk and coffee rates rose, whether portions grew as new staff joined, and whether more orders came through a delivery app. Five points on ₹3,60,000 is ₹18,000 a month, more than a helper's salary.
Your result
One sheet with three months side by side, the line that's rising, and the action you'll take. Fill it again next month, in the same columns.
Months compared: ____ / ____ / ____ Sales (no GST): ₹____ / ₹____ / ₹____ Raw material share: ___% / ___% / ___% Staff share: ___% / ___% / ___% Rent share: ___% / ___% / ___% Commissions and charges: ___% / ___% / ___% Line that's rising: ________ Likely cause: rate / portions / wastage / channel mix / lower sales Action this month: ________ Check again on: ____
Fill it in on your checklist, next to this topic. It stays in this browser.
Time and cost
- Time
- Three to four hours the first time, mostly sorting the bank statement. Once the sheet and categories exist, about an hour each month.
- Cost
- Free in Google Sheets or a notebook. If your accountant already keeps your books, ask them for a month-wise expense summary; many will share it at no extra charge.
Ballparks to verify: prices and fees change by city and over time, so check current rates before you budget.
Common mistakes
Comparing rupees instead of shares
A busier month always has bigger bills. Only the share of sales tells you whether a cost is growing faster than the business.
Reading one month on its own
Stock-ups, a festival or a five-week month can swing a single month badly. Look at the direction over three.
Cutting what customers notice
Smaller portions or a cheaper main ingredient may lower the share and lose regulars. Look first at buying rates, wastage and commissions.
Leaving out the owner's own costs
Fuel, phone and the owner's drawing paid from the shop account belong somewhere. Put them in a separate line so they don't hide inside "other".
Go deeper
- Read nextLook at profit every month →The monthly habit this cost sheet fits into.
- Read nextCheck what you pay for your top ten items →If raw material is the rising line, rates are the first thing to check.
- Business playbookSoftware to run it: restaurant →Billing and inventory tools for a restaurant, which can give you sales and purchase reports without hand-sorting.
- Business playbookSoftware to run it: kirana store →Billing options for a kirana, where many small purchases make a sales report especially useful.
The playbooks are written for one business each. Start with the full playbook or find yours.
Questions people ask
What share of sales should raw material be?
It depends on the business: a food business, a salon and a kirana have very different shares. The number that matters is your own trend and what your break-even plan assumed. If it's several points above your plan, find out why.
Is this the same as a monthly profit check?
It uses the same numbers but asks a narrower question: which cost is growing. The monthly profit check is the wider habit of looking at profit every month; this sheet can sit inside it.
I don't have a billing app. Can I still do this?
Yes. UPI and card settlements are in your bank statement, and a daily cash total in a notebook covers the rest. It's slower, but three months of rough numbers still show a trend.