Skip to content

Dashboard templates

Technology · Finance & accounting

A subscription (SaaS) software company keeping books under Circular 200 (VN accounting). MRR, churn and subscription invoice collections plus ledger results, expenses against budget by department, implementation fee receivables, and reconciliation of booked revenue with MRR.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For accountants and CFOs at SaaS companies keeping books under Thông tư 99/2025/TT-BTC. The "Books and MRR" dashboard puts the general ledger next to subscriptions: the gap between booked revenue and MRR, and operating cost over MRR. The "Business results and budget" and "Receivables and payables" dashboards cover profit, spend vs budget by department and implementation fee receivables, with the MRR, retention and collections dashboards in the same place. Needs account, subscription, MRR movement, MRR snapshot, chart of accounts and general ledger entry data.

Use this template to

  • Reconcile booked revenue with MRR before reporting to investors.
  • Measure operating cost as a multiple of MRR to decide how fast to hire.
  • Chase customers with overdue implementation fees.

6 ready-made dashboards

Books and MRR

Reconcile booked revenue with cumulative MRR, and operating expenses against subscription revenue.

  • Booked revenue
  • Average MRR
  • Booked revenue vs MRR gap
  • Operating expenses to MRR
  • Monthly non-subscription revenue
  • Monthly operating expenses over MRR
  • Operating expenses by department

Business results and budget

Ledger revenue, COGS and profit, and selling and admin expenses against budget by cost center.

  • Booked revenue
  • Gross margin %
  • Operating profit
  • Net profit after tax
  • Monthly gross margin
  • Monthly expenses by cost center
  • Expenses vs budget by cost center
  • Expenses by account

Receivables and payables

Credit sales, collections, overdue receivables, days sales outstanding and supplier payments.

  • Credit sales
  • Receivables collected
  • Overdue receivables
  • Average days to collect
  • Receivables by customer
  • Weekly collections
  • Payments by supplier

MRR overview

Average MRR, new, expansion and churned MRR, and paying customers of a subscription software company.

  • Average MRR
  • Net new MRR
  • Average paying accounts
  • Average revenue per account (ARPA)
  • MRR movement by segment
  • Month-end MRR by segment
  • Net new MRR by plan

Retention and trials

Churned customers, lost MRR, trial conversion rate and product usage.

  • Logo churn rate
  • Churned MRR
  • Trial conversion rate
  • Daily active users (average)
  • Retention by plan
  • Monthly churned MRR by plan
  • Trial conversion rate by plan
  • Weekly daily active users

Billing and collections

Subscription invoice amounts issued and collection rate by segment and billing cycle.

  • Invoiced amount
  • Invoice collection rate
  • Collection rate by segment
  • Amount invoiced by billing cycle
  • Monthly amount invoiced by segment

Ask Si as soon as the build finishes

  • “How did operating expenses to MRR change compared with last month?”
  • “What is driving booked revenue vs MRR gap this quarter?”
  • “Show vendor payments by month for the last six months.”
  • “Where is receivables collected highest this month, and why?”

32 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Operating expenses to MRRBooked selling and administrative expenses divided by cumulative MRR in the period (sum of month-end MRR snapshots). Above 1 means operating expenses exceed subscription revenue and the company is burning cash to grow.= Selling and administrative expenses / tech_mrr_snapshot_totalRatio (%)
Booked revenue vs MRR gapBooked revenue minus cumulative MRR (sum of month-end MRR snapshots in the period). Subscription revenue is recognized monthly, so a positive gap is usually non-subscription revenue (implementation, training); negative means under-booking or timing differences in recognition.= Booked revenue - tech_mrr_snapshot_totalCurrency
Vendor paymentsTotal value of payable invoices paid, by payment date.Currency
Receivables collectedTotal value of receivable invoices collected, by collection date.Currency
Credit salesTotal value of credit sales invoices (creating accounts receivable) by invoice date.Currency
Average days to collectAverage days from invoice date to collection date for invoices collected in the period.= fin_collect_days_total / fin_ar_collected_countNumber
Expense budgetBudget for selling and administrative expense accounts. Budgets are set monthly, recorded on the first day of the month.Currency
Cost of goods sold (ledger)Debit postings minus credit postings on the cost of goods sold account (account 632).Currency
Gross margin %Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenueRatio (%)
Gross profitBooked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger)Currency
Net profit after taxCredits minus debits across all income statement accounts (revenue, cost of goods sold, expenses, financial income and expenses, other income and expenses, corporate income tax).Currency
Operating profitGross profit minus selling and administrative expenses. Excludes financial income and expenses and other income and expenses.= Booked revenue - Cost of goods sold (ledger) - Selling and administrative expensesCurrency
Selling and administrative expensesDebit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422.Currency
Expenses vs budgetActual selling and administrative expenses divided by budget. Above 100% means over budget.= Selling and administrative expenses / Expense budgetRatio (%)
Overdue receivablesTotal value of invoices due in the period that remain uncollected as of the data date.Currency
Booked revenueGeneral ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income.Currency
Average revenue per account (ARPA)Average MRR per paying account = total MRR across snapshots divided by the number of paying-account occurrences in those snapshots.= tech_mrr_snapshot_total / tech_paying_account_snapshotsCurrency
Daily active users (average)Average number of active users per day in the period = total daily active users divided by the number of days.= tech_active_user_days / tech_usage_daysNumber
Average MRRAverage monthly recurring revenue in the period = total MRR across month-end snapshots divided by the number of snapshot dates.= tech_mrr_snapshot_total / tech_snapshot_countCurrency
Average paying accountsNumber of accounts with positive MRR, averaged over the month-end snapshots in the period.= tech_paying_account_snapshots / tech_snapshot_countNumber
Churned accountsAccounts with at least one churn event (subscription cancellation) in the period.Count
Churned MRRTotal MRR lost from customers cancelling their subscriptions in the period, as a positive number.Currency
Invoice collection rateAmount collected divided by amount invoiced, for invoices issued in the period.= tech_invoice_paid_amount / Invoiced amountRatio (%)
Contraction MRRTotal MRR decrease from retained customers (fewer seats, plan downgrades) in the period, as a positive number.Currency
Expansion MRRTotal MRR increase from existing customers (more seats, plan upgrades) in the period.Currency
Invoiced amountTotal amount of subscription invoices issued in the period (by issue date).Currency
Logo churn rateChurned accounts in the period divided by average paying accounts in the period.= Churned accounts / Average paying accountsRatio (%)
Net new MRRNew MRR plus expansion, minus contraction and churn, in the period.= New MRR + Expansion MRR - Contraction MRR - Churned MRRCurrency
New MRRTotal MRR from subscriptions that start paying in the period (events of type new), by effective date.Currency
Trial conversion rateTrials converted to paid divided by trials started in the period.= Trials converted / Trials startedRatio (%)
Trials convertedSubscriptions that started a trial in the period and converted to paid (up to the data cut-off date).Count
Trials startedSubscriptions that started a trial in the period (by trial start date).Count

Data you need

Required

account, subscription, mrr_movement, mrr_snapshot, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

plan, invoice, usage_daily, fin_cost_center, fin_budget, fin_ar_invoice, fin_ap_bill

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: account, subscription, mrr_movement, mrr_snapshot, fin_account, fin_journal_line.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 32 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Technology · Finance & accounting with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes