Skip to content

Dashboard templates

Manufacturing · Finance & accounting

A make-to-order plant keeping books under Circular 200 (VN accounting) and costing by workshop. Output, OEE and downtime plus ledger results, expenses against budget, receivables and payables, and production cost (accounts 621, 622, 627) against good output.

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

For cost accountants and CFOs at make-to-order factories. The "Production cost" dashboard puts production cost from the general ledger next to good output: average cost per good unit and cost as a share of output value. The "Business results and budget" and "Receivables and payables" dashboards cover gross profit, operating profit, spend vs budget and overdue balances, while the production dashboards (OEE, downtime) explain why unit cost changed. Needs machine, item, production order, machine shift, chart of accounts and general ledger entry data.

Use this template to

  • Explain whether a rise in unit cost comes from downtime, scrap or overhead.
  • Track departments going over their cost budget before the quarter ends.
  • Prioritize collecting the largest overdue customer balances.

6 ready-made dashboards

Production cost

Production cost by workshop and cost element (materials, labor, overhead), cost per good unit and cost-to-output-value ratio.

  • Production cost
  • Average cost per good unit
  • Production cost to output value ratio
  • Gross margin %
  • Monthly cost per good unit
  • Monthly cost over output value
  • Production cost by workshop
  • Production cost by cost element

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

Output and OEE

Good output, output value and OEE broken into availability, performance and quality rate by workshop, machine and shift.

  • Good output
  • Output value
  • OEE (overall equipment effectiveness)
  • Scrap rate
  • OEE by machine
  • Weekly OEE by workshop
  • Performance by shift
  • Weekly good output by workshop

Downtime

Machine downtime by reason, machine and workshop; unplanned downtime drags availability down.

  • Downtime minutes
  • Unplanned downtime share
  • Availability
  • Downtime minutes by reason
  • Downtime minutes by machine
  • Weekly downtime minutes by workshop

Quality and production orders

Scrap and inspection defects by item and defect type; completed production orders and on-time rate.

  • First pass yield (FPY)
  • Inspection defect rate
  • Completed work orders
  • On-time completion rate
  • Quality by item
  • Defect rate by defect type
  • On-time rate by workshop
  • Monthly on-time rate

Ask Si as soon as the build finishes

  • “How did production cost to output value ratio change compared with last month?”
  • “What is driving production cost this quarter?”
  • “Show average cost per good unit by month for the last six months.”
  • “Where is vendor payments highest this month, and why?”

30 defined metrics

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

MetricDefinitionUnit
Production cost to output value ratioProduction cost (accounts 621, 622, 627) for the period divided by the value of good output at standard selling price in the same period. Close to 1 means cost is near the selling price and gross margin is thin.= Production cost / Output valueRatio (%)
Production costTotal debit postings to production cost accounts: direct materials (account 621), direct labor (account 622) and manufacturing overhead (account 627), by posting date. The total production cost for the period before transfer.Currency
Average cost per good unitProduction cost (accounts 621, 622, 627) for the period divided by good units (net of scrap) produced in the same period.= Production cost / Good outputCurrency
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
AvailabilityRun minutes divided by planned minutes. The first component of OEE.= mfg_run_minutes / mfg_planned_minutesRatio (%)
Completed work ordersWork orders completed in the period, by completion date.Count
Inspection defect rateDefective samples divided by inspected samples across the inspection lots in the period.= mfg_defect_qty / mfg_inspected_qtyRatio (%)
Downtime minutesTotal machine downtime minutes recorded in the period, for every reason (including changeovers and scheduled maintenance).Number
First pass yield (FPY)Good output divided by total output. The quality component of OEE.= Good output / Total outputRatio (%)
OEE (overall equipment effectiveness)Availability x performance x first pass yield, computed on the period totals.= (mfg_run_minutes / mfg_planned_minutes) * (Total output / mfg_ideal_output) * (Good output / Total output)Ratio (%)
On-time completion rateWork orders completed on time divided by work orders completed in the period.= mfg_on_time_work_orders / Completed work ordersRatio (%)
Good outputGood units (total output minus scrap) produced in the period's shifts, by shift date.Count
Output valueGood output multiplied by the item's standard selling price, by machine shift date.Currency
PerformanceTotal output divided by the ideal output for the run time. The second component of OEE.= Total output / mfg_ideal_outputRatio (%)
Total outputTotal units produced in the period's shifts, including both good units and scrap.Count
Scrap rateScrap units (total output minus good output) divided by total output.= (Total output - Good output) / Total outputRatio (%)
Unplanned downtime shareUnplanned downtime minutes divided by total downtime minutes.= mfg_unplanned_downtime_minutes / Downtime minutesRatio (%)

Data you need

Required

machine, item, work_order, machine_shift, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, 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: machine, item, work_order, machine_shift, 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 30 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 Manufacturing · Finance & accounting with your own data

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