Once a month, put sales, raw material, staff, rent and other costs on one page, subtract, and see what's left for you. Compare it with last month and the same month last year, and look at each cost as a share of sales. It takes an hour if your daily sheets and purchase register are in order, and it tells you about a problem ten months before your CA's year-end figures would.
This is general information, not legal, tax or financial advice. Rules and fees change and differ by state; check the official source, the Income Tax Department (incometax.gov.in), or ask a CA or lawyer before you act.
Why it matters
A full bank account isn't profit. Cash can be high because a supplier hasn't been paid yet, or low because you bought a month's stock at once. Many owners only learn what they earned when the CA files returns, long after anything could be done about a bad quarter.
The inputs already exist: the daily reconciliation sheets give you sales, the purchase register gives you material costs, and the bank statement shows the rest. This page is about the habit and the first reading of it. Finding exactly which cost is creeping up belongs to comparing costs with sales; judging whether a whole year is steady enough to expand is a separate check.
How to do it
Pick a fixed date, such as the seventh of each month, when last month's bills have all come in.
Total last month's sales
Add up the daily sheets or take the month's report from your billing system. If you're registered for GST, use sales without the GST collected; that money isn't yours. Keep delivery-app or marketplace sales on a separate line, because their commissions are large.
Work out what the goods actually cost you
Purchases from the register, adjusted for stock: opening stock + purchases − closing stock = material used. You don't need a perfect count; a rough count of the high-value items at month end is far better than ignoring stock. Without this adjustment, a month when you stocked up looks like a loss and the next like a windfall.
List the running costs
Salaries and any PF/ESI contributions, rent and maintenance, electricity, gas, internet, commissions, payment charges, packaging, repairs, marketing, accounting fees and loan interest. Take them from the bank statement and the cash book so nothing is missed. Put annual bills (licence renewals, insurance) in as one-twelfth each month.
Subtract, then subtract your own pay
Sales minus material minus running costs is the business's operating profit. Now take out what you drew for the household. If what's left is negative month after month, the business is living on your unpaid work. Income tax is worked out on the year's profit; your CA will tell you whether presumptive taxation or full books suit you, so don't try to compute the tax here.
Compare three ways
Against last month, against the same month last year (festivals, weddings, exams and monsoon move most small businesses), and as shares of sales: material as a percentage of sales, staff as a percentage, rent as a percentage. The shares matter more than the rupees, because they show a leak even when sales are rising.
Pick one thing to act on
Write one line: what moved, why you think it moved, and the one action for this month. Then check it next month. A monthly check that never leads to a decision becomes a chore that gets dropped by March.
| One-page P&L | This month | Last month | % of sales |
|---|---|---|---|
| Sales (without GST) | ₹ | ₹ | 100% |
| Material used | ₹ | ₹ | |
| Staff (incl. PF/ESI) | ₹ | ₹ | |
| Rent and maintenance | ₹ | ₹ | |
| Utilities, commissions, other | ₹ | ₹ | |
| Operating profit | ₹ | ₹ | |
| Owner's drawing | ₹ | ₹ |
Your result
A monthly page with profit, three comparisons and one action.
Month: ____ checked on: ____ Sales (no GST): ₹____ vs last month ₹____ vs last year ₹ Material used: ₹____ (___% of sales) Staff: ₹____ (___%) Rent: ₹____ (___%) Other costs: ₹ Operating profit: ₹____ after my drawing: ₹ Biggest change and likely reason: One action this month: Result of last month's action:
Worked example (made up, to show how it reads)
Made up to show the format: sales ₹4.2 lakh, material used ₹1.68 lakh (40%, up from 36%), staff ₹84,000 (20%), rent ₹45,000, other ₹38,000. Operating profit ₹85,000, about ₹15,000 after the owner's drawing. Action: count wastage for two weeks, since material rose while prices didn't.
Fill it in on your checklist, next to this topic. It stays in this browser.
Time and cost
- Time
- Two to three hours the first time, while you set up the sheet and find the numbers. About an hour a month after that, if daily sheets and the purchase register are kept up.
- Cost
- Free in Google Sheets or Excel. If your CA already does monthly bookkeeping, ask them for a monthly profit statement; some include it, some charge a small extra fee.
Ballparks to verify: prices and fees change by city and over time, so check current rates before you budget.
Common mistakes
Treating the bank balance as profit
Unpaid supplier bills, advance payments and stock purchases all distort the balance. Work from sales and costs, not the balance.
Skipping the stock adjustment
Purchases aren't costs until the stock is used. A quick count of costly items fixes most of the distortion.
Leaving out yearly costs
Licence renewals, insurance and annual maintenance hit one month hard. Spread them across twelve so every month is honest.
Mixing personal and business spending
Household bills paid from the business account inflate costs. Record them as owner's drawing, not expenses.
Go deeper
Questions people ask
Isn't this the CA's job?
The CA prepares accounts and files returns, usually after the year ends. The monthly check is a management habit: it's for you to decide things in time. Your CA can help set up the sheet once.
What if profit drops one month?
One month can be a festival, a holiday or a big repair. Look at the shares of sales to find what changed, and act only if the same line rises two months running.
Can a spreadsheet do this, or do I need software?
A spreadsheet is enough. A billing system that records sales and stock makes the sales and material lines much faster to fill.