Monthly MIS pack
P&L, balance sheet, cash flow, KPIs and compliance status in one workbook — the pack a founder or a board can read in ten minutes.
XLSX · 10 KB · no sign-up, no watermark
One workbook, closed the same way every month. The KPI sheet computes from the P&L and balance sheet rather than asking you to key numbers twice, which is where most in-house packs start disagreeing with themselves.
The compliance sheet sits inside the pack deliberately. A month-end review that covers the numbers but not the filings is half a review.
What is inside
Every sheet and what it holds, so you can tell whether it fits before you download it.
P&L
Columns: Current month · Year to date · Budget (month) · Variance %
- REVENUE
- Sales — goodsauto
- Sales — servicesauto
- Other incomeauto
- Total revenueauto
- DIRECT COSTS
- Cost of goods soldauto
- Direct services costauto
- Total direct costsauto
- GROSS PROFIT
- OPERATING EXPENSES
- Employee costs — salaries and benefitsauto
- Employer PF, ESI and gratuityauto
- Rent, utilities and facilitiesauto
- Professional, audit and compliance feesauto
- Marketing and business developmentauto
- Technology and softwareauto
- Travel and conveyanceauto
- Administrative and otherauto
- Total operating expensesauto
- EBITDA
- BELOW EBITDA
- Depreciation and amortisationauto
- Finance costsauto
- Exceptional itemsauto
- Totalauto
- PROFIT BEFORE TAX
- Tax expense — current and deferred
Balance sheet
Columns: Current month · Previous month · Movement
- CURRENT ASSETS
- Cash and bank balancesauto
- Trade receivablesauto
- Inventoryauto
- GST input tax credit receivableauto
- Advance tax and TDS receivableauto
- Prepaid expenses and other advancesauto
- Total current assetsauto
- NON-CURRENT ASSETS
- Property, plant and equipment (net)auto
- Intangible assetsauto
- Security depositsauto
- Other non-current assetsauto
- Total non-current assetsauto
- TOTAL ASSETS
- CURRENT LIABILITIES
- Trade payablesauto
- GST payableauto
- TDS payableauto
- Statutory dues — PF, ESI, professional taxauto
- Employee benefits payableauto
- Short-term borrowingsauto
- Other current liabilitiesauto
- Total current liabilitiesauto
- NON-CURRENT LIABILITIES
- Long-term borrowingsauto
- Deferred tax liabilityauto
- Provision for gratuity and leave encashmentauto
- Total non-current liabilitiesauto
- EQUITY
- Share capitalauto
- Securities premiumauto
- Retained earningsauto
- Other reservesauto
- Total equityauto
- TOTAL LIABILITIES AND EQUITY
- Check — must be nilauto
- If this row isn't zero, the pack isn't ready to circulate.
Cash flow
Columns: Current month · Year to date
- Opening cash and bank balance
- Operating cash flow
- Investing cash flow
- Financing cash flow
- Net movementauto
- Closing cash and bank balanceauto
- Per balance sheet (cash and bank)auto
- Check — must be nilauto
KPIs
| Metric | Unit | What it tells you |
|---|---|---|
| Gross margin | % | Pricing and delivery cost, before overhead |
| EBITDA margin | % | Operating profitability, ignoring capital structure |
| Net margin | % | What actually reaches retained earnings |
| Operating cost ratio | % | Overhead as a share of revenue |
| Current ratio | x | Short-term assets against short-term dues |
| Quick assets (current assets less inventory) | INR | Inventory is row 9 on the balance sheet |
| Quick ratio | x | The same test without relying on stock selling |
| Working capital | INR | Headroom in the operating cycle |
| Days sales outstanding | days | Receivables ÷ revenue × days in period |
| Days payable outstanding | days | Payables ÷ purchases × days in period |
| Net working capital days | days | Positive means you fund the gap |
| Return on equity (annualised) | % | Monthly profit annualised over closing equity |
Compliance status
Columns: Item · Due · Status · Comment
- GSTR-1
- GSTR-3B and GST payment
- TDS deposit
- PF contribution
- ESI contribution
- Professional tax
- Input tax credit reconciled to GSTR-2B
- Bank reconciliation
- Books closed and trial balance drawn
- Inter-company balances agreed
- Statutory registers updated
- Any ROC filing falling due
- Prepared by
- Reviewed by
- Date
How to use it
Work in sheet order: P&L, balance sheet, cash flow, then let the KPI sheet calculate. Fill the compliance status last, from your own filing records rather than from memory.
Talk it through with a CA
Thirty minutes on one problem — a cash gap you can’t explain, a notice you don’t understand, books that stopped making sense. You’ll leave with a straight answer and the next two steps. No charge, and no obligation to work with us afterwards.
BizFinAffairs and BizFinLabs are both VCXOS Management and Technologies LLP. Advisory engagements are delivered by BizFinLabs.