Skip to content

Dashboard templates

Healthcare · Finance & accounting

A clinic or clinic chain keeping books under Circular 200 (VN accounting). Visits, service revenue and the insurance-covered share plus booked revenue, cost of drugs and supplies, expenses against budget by facility and insurance receivables.

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

For accountants at clinics and clinic chains keeping books under Thông tư 99/2025/TT-BTC. The "Books and visits" dashboard links the general ledger to clinical activity: drug and supply cost per visit, operating cost per visit, and the gap between booked revenue and visit service revenue. The "Business results and budget" and "Receivables and payables" dashboards cover profit, spend vs budget by location and insurance receivables. Needs location, doctor, visit, service fee, chart of accounts and general ledger entry data.

Use this template to

  • Check whether booked revenue matches visit service revenue at each location.
  • Track drug and supply cost per visit to spot leakage.
  • Chase overdue insurance receivables by payer.

5 ready-made dashboards

Books and visits

Reconcile booked revenue with clinic system service revenue, drug and supply costs, operating cost per visit, and overdue insurance receivables.

  • Booked revenue
  • Service revenue
  • Booked vs visit service revenue gap
  • Drug and supply cost per visit
  • Drug costs
  • Monthly operating cost per visit
  • Overdue insurance receivables by payer

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

Clinic overview

Visits, patients, service revenue and insurance-covered share by facility and specialty.

  • Visits
  • Unique patients
  • Service revenue
  • Revenue per visit
  • Weekly visits by facility
  • Monthly visits by specialty
  • Results by facility
  • Revenue by service group
  • Insurance-covered share by patient type

Appointment operations

No-show rate, cancellations, wait time and doctor productivity by facility, specialty and doctor.

  • Appointments
  • No-show rate
  • Average wait time (minutes)
  • Visits per doctor day
  • No-show rate by facility
  • Average wait time by facility
  • Weekly wait time by facility
  • Productivity by doctor
  • Follow-up visit share by specialty

Ask Si as soon as the build finishes

  • “How did drug and supply cost per visit change compared with last month?”
  • “What is driving operating expense per visit this quarter?”
  • “Show booked vs visit service revenue gap by month for the last six months.”
  • “Where is vendor payments highest this month, and why?”

32 defined metrics

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

MetricDefinitionUnit
Drug and supply cost per visitBooked cost of goods sold (drugs, medical supplies, test strips, account 632) divided by completed visits in the period.= Cost of goods sold (ledger) / VisitsCurrency
Operating expense per visitBooked selling and administrative expenses (salaries, rent, marketing, utilities) divided by completed visits.= Selling and administrative expenses / VisitsCurrency
Booked vs visit service revenue gapBooked revenue (account 511 less deductions in account 521) minus service revenue computed from completed visits. Negative means the books show less than the clinic system: insurance rejected claims, or timing differences in recognition.= Booked revenue - Service revenueCurrency
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
AppointmentsTotal appointments by appointment date, in every status (completed, no-show, cancelled).Count
Average wait time (minutes)Average minutes from check-in to the start of the consultation, over completed visits that have both timestamps.= hc_wait_minutes_total / hc_wait_measured_visitsNumber
Cancellation rateCancelled appointments divided by total appointments.= hc_cancellations / AppointmentsRatio (%)
Insurance-paid amountTotal amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits.Currency
Insurance shareInsurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenueRatio (%)
New patientsDistinct patients with a completed visit of type new (not a follow-up) in the period.Count
No-show rateNo-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows)Ratio (%)
No-showsAppointments with the standard status no_show (the patient did not attend).Count
Patient-paid amountTotal service charges minus the insurance-paid amount, for completed visits.Currency
Follow-up visit shareFollow-up visits divided by completed visits.= hc_return_visits / VisitsRatio (%)
Service revenueTotal service charges of completed visits (insurance portion plus patient portion), by visit date.Currency
Revenue per visitService revenue divided by completed visits.= Service revenue / VisitsCurrency
Unique patientsDistinct patients with at least one completed visit in the period.Count
VisitsAppointments with the standard status completed, by visit date.Count
Visits per doctor dayCompleted visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_daysNumber

Data you need

Required

clinic, doctor, visit, visit_charge, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

patient, service, 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: clinic, doctor, visit, visit_charge, 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 5 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 Healthcare · Finance & accounting with your own data

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