SME Monthly MIS Pack
A month-end pack that turns your Tally or Zoho export into a P&L, cash flow, debtor and creditor ageing and a one-page KPI sheet.
What's inside
- Data tab: paste your trial balance or ledger export, mapped once to a standard chart of accounts
- P&L by month with prior-month and budget comparison
- Cash flow statement built from the P&L and balance sheet movements
- Receivables and payables ageing with DSO and DPO
- One-page KPI dashboard: revenue, gross margin, EBITDA, cash, DSO
- Month-end checklist so the pack is ready by the 7th
Who it's for
SME owners and accountants. If you can fill in a spreadsheet you can use it; the read-me tab explains every input, and the walkthrough video takes about eight minutes.
How it's built
- Inputs in blue, formulas in black, results on the first tab
- Formulas protected so they don't break; input cells unlocked
- Sample data filled in, plus a blank copy
- Tested in Microsoft Excel 2016+ and Google Sheets
Try the free version first
GST Calculator, Working Capital & Cash Conversion Cycle Calculator, Inventory Turnover & Days of Stock Calculator, GST Late Fee & Interest Calculator covers part of this model online.
Questions
How do I get the file?
Right after payment you get an email with a download link for the .xlsx file and a Google Sheets copy link.
Can I use it for clients?
The licence is for one user. You can use it for your own clients' work, but you cannot resell or share the file.
Do I get updates?
Yes. Updates for rule changes, such as tax or GST revisions, are emailed free for 12 months.
What if it doesn't work for me?
Digital downloads are not refundable, but if the file doesn't work as described we will fix it or help you set it up. See the refund policy.