Prompt: Create a template for a monthly board financial pack for a Series A SaaS company in SA. What metrics, charts, and commentary sections should it include? Make it practical, not theoretical.
Monthly Board‑Pack Template
Series A SaaS – South Africa
> Purpose: Deliver the data the board needs to decide quickly on strategy, funding, cost control, and compliance. Keep it concise (1–2 pages per section) so the CEO can hand it over with just a 15‑minute recap.
---
1️⃣ Cover Page
| Item | How to Present |
|------|----------------|
| Company name & logo | Centre top |
| Pack title: “Monthly Financial Review – <Month/Year>” | Bold |
| Period covered | e.g. 01 Jun–30 Jun 2026 |
| Current board‑member name + date of presentation | Bottom right |
| Executive Snapshot (3‑line bullets) | • ARR up 12% YoY • Cash runway 10 months • CAC declining 8% |
---
2️⃣ Executive Summary – “What’s Happening Today?”
- Revenue: Total MRR/ARR, growth vs prior month and YoY.
- Profitability: Gross margin %, EBITDA margin, net burn.
- Cash Position: Closing cash, runway, key upcoming large outflows (e.g., 3‑month payroll).
- Key Risks / Decisions Needed: e.g., “Need to re‑negotiate a £x 000 vendor contract before Q2 ends” or “Potential new customer pipeline will add +R1M ARR in Q3 – request capital raise”.
Keep the language plain (no jargon) and frame every bullet with a next‑step recommendation.
---
3️⃣ Income Statement (P&L) – Highlighted
| Item | Current Month (R) | YoY % | MoM % | Variance to Budget | Commentary |
|------|------------------|-------|-------|--------------------|------------|
| MRR / ARR | … | +12 % | +1.2 % | +R120k | New subscription sign‑ups from marketing push |
| Churned MRR | … | –5 % | –0.3 % | –R30k | Churn reduced after support upgrade |
| Expansion MRR | … | +10 % | +0.8 % | +R90k | Add‑on sales from upsell program |
| Gross Margin % | 72 % | +2 % | +0.3 % | – | Cost of services (cloud hosting) flat |
| SG&A (incl. salaries) | … | –8 % | +1 % | – | Marketing spend higher due to campaign |
| EBITDA | … | –15 % | +0.5 % | – | EBITDA margin 20 % |
| Net Cash Burn | –R480k | –12 % | – | – | Cash burn falling due to higher ARR |
> Chart: 3‑month line of MRR, churn and expansion; bars for gross profit.
---
4️⃣ Balance Sheet Snapshot (Key Numbers)
| Item | Current Month (R) | YoY % | Variance vs Budget | Commentary |
|------|------------------|-------|--------------------|------------|
| Cash & Cash Equivalents | … | +15 % | +R1.2M | Increased due to 30‑day invoicing |
| Debtors (ARR) | … | –3 % | –R200k | DSO improved from 48 → 42 days |
| Creditors | … | –5 % | –R150k | Payables cycle lengthed by 10 days |
| Short‑term debt | … | – | – | No new borrowing this month |
| Equity (Retained earnings) | … | + | + | Positive net income |
> Chart: Cash‑runway waterfall (cash at beginning, inflows/outflows, closing cash).
---
5️⃣ Cash Flow & Runway
| Item | Current Month | YoY % | Comments |
|------|--------------|-------|----------|
| Operating Cash Flow | +R600k | –10 % | Cash‑positive due to higher ARR |
| Investing Cash Flow (CapEx) | –R200k | –30 % | Server upgrade |
| Financing Cash Flow | – | 0 | No new debt/Equity |
| Net Change in Cash | +R400k | –5 % | |
| Runway | 12 months | | Burn = R480k / 12 months |
> Chart: 13‑week rolling cash‑flow forecast (line with projected shortfall bars).
---
6️⃣ SaaS KPI Dashboard (1‑page snapshot)
Use a table or small icons for quick visual impact.
| KPI | Current | Target | Trend | Action |
|-----|---------|--------|-------|--------|
| ARR | R12 M | R13 M | ↑ | Close pipeline deals |
| MRR Growth | 1.2 % | 1.5 % | ↑ | Accelerate upsell training |
| Churn (Net) | 4.8 % | ≤4 % | ↓ | Customer success review |
| CAC (3‑month average) | R12k | R10k | ↓ | Optimize ad spend |
| LTV / CAC | 6× | ≥5× | ↑ | Expand pricing tiers |
| Gross Margin % | 72 % | 75 % | ↑ | Negotiate hosting discounts |
| Payables Days (DPO) | 45 | ≤30 | ↑ | Push supplier terms |
| Debtors Days (DSO) | 42 | ≤35 | ↓ | Enforce early payment discount |
> Charts:
- Bubble chart of CAC vs LTV per customer segment.
- Bar chart for monthly churn vs expansion.
---
7️⃣ Capital & Funding Status
| Item | Value | Notes |
|------|-------|-------|
| Current Equity | R5 M | Series A closed last quarter |
| Outstanding Options Pool | 12 % | Next grant to be scheduled |
| Debt / Credit Lines | – | None at present |
| Funding Gap to Next Milestone | R2 M | Target Q4 product launch |
> Commentary: “If runway drops below 8 months, consider a bridge round or cost‑cutting (staff attrition).”
---
8️⃣ Compliance & Tax Snapshot
| Item | Status | Due Date | Comments |
|------|--------|----------|----------|
| PAYE / UIF / SDL (EMP201) | Paid 07 Jul | – | No variance |
| VAT (Category B, bi‑monthly) | Filed 25 Jun | – | Output tax + R500k; Input tax claim R460k |
| Provisional Tax Return 1 | Filed 01 Jul | – | Estimated tax R240k |
| Corporate Income Tax return 2025 | Due 31 Dec 2026 | – | On track, no issues |
> Risk: “If the company crosses R10 M turnover next quarter, B‑category VAT may change to A. Plan for higher filing frequency.”
---
9️⃣ Risk & Action Items (Board Decision Log)
| # | Issue | Impact | Owner | Due By | Status |
|---|-------|--------|-------|--------|--------|
| 1 | DSO creeping >45 days | Cash strain | CFO | 31 Jul | ✔️ |
| 2 | CAC increasing due to ad spend | Cost of growth | Head of Marketing | 15 Aug | Pending |
| 3 | Vendor contract renewal for SaaS infra | Price risk | COO | 30 Sep | In progress |
> Use this column to capture board decisions, deadlines and owners.
---
🔍 How to Populate the Pack (Practical Steps)
- Data pull
- Use QuickBooks Online API or Xero to pull revenue, expenses, cash balance, and aged debtor/creditor reports.
- Export the data into a single CSV for consistency; feed it into your reporting tool (Excel, Google Sheets, Power BI).
- Metric calculation
- Build small formulas: e.g.,
DSO = (Debtors / MRR) * 30.
- Store formulas in a “Data Model” sheet so you can adjust assumptions.
- Chart creation
- Stick to 1‑line or 2‑line charts for trend, bar charts for absolute values, and a waterfall for cash flow.
- Color code: green = good trend, red = warning, blue = neutral.
- Commentary drafting
- For each KPI, answer “What happened? Why did it happen? What is the next step?”
- Keep commentary to 3‑5 sentences per section; let the charts tell most of the story.
- Compliance check
- Use a checklist (PAYE, VAT, Provisional Tax) that automatically flags overdue filings.
- Include a quick “SARS eFiling status” button if your system supports it.
- Review cycle
- Week 1 – CFO pulls data and drafts the pack.
- Week 2 – CEO reviews for strategic alignment.
- Week 3 – Board receives PDF + 15‑minute PowerPoint.
---
Quick “Appendix” Ideas (if you need more detail)
| Appendix | When to use |
|----------|-------------|
| Full P&L, BS & CF | For auditors or investor requests |
| Detailed CAC/LTV model | Pre‑fundraising or valuation prep |
| 13‑week cash forecast table | CFO to keep running updates |
---
📌 Final Tips
- Focus on the board’s pain points: Cash runway, growth metrics (ARR, churn), and cost efficiency.
- Limit text, maximise visuals. A single chart can replace several paragraphs of description.
- Use SA‑specific markers: VAT code, PAYE, Provisional Tax dates—highlight them in a small “Compliance Box” so you never miss a deadline.
- Add an “Ask the CFO” slide where management can pose quick questions; this shows proactive engagement.
With this template, the CEO and CFO can assemble a monthly board pack that is data‑rich yet digestible, ready to drive informed decisions for your Series A SaaS company in South Africa.