Skip to content

Dashboard templates

Financial services · Finance & accounting

A consumer finance company booking accrued interest income, funding costs, operating expenses and credit loss provisions. Applications, disbursements, collections and bad debt plus ledger results, expenses against budget, insurance commission receivables, and reconciliation of booked interest against interest actually collected.

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

For chief accountants and CFOs at consumer finance companies. The "Books and loan portfolio" dashboard puts the general ledger next to the portfolio: net income over average outstanding balance, operating expenses over average outstanding balance, and booked revenue not yet collected as interest in cash. The "Business results and budget" and "Receivables and payables" dashboards cover gross profit, operating profit, spend vs budget and overdue balances. Needs branch, loan product, loan, repayment, monthly balance, chart of accounts and general ledger entry data.

Use this template to

  • Reconcile booked interest with interest actually collected before closing the monthly report.
  • Track provisioning and operating expenses against budget by branch.
  • Find insurance partners with overdue commission payments.

6 ready-made dashboards

Books and loan portfolio

Reconcile booked revenue with interest collected, net income and operating cost over average outstanding balance.

  • Booked revenue
  • Interest income collected
  • Booked revenue not collected as interest
  • Net income on average outstanding
  • Monthly booked revenue not collected as interest
  • Monthly operating cost over average outstanding balance

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

Credit overview

Company-wide disbursements, approval rate, outstanding balance and bad debt by branch and product.

  • Disbursed amount
  • Approval rate
  • Average outstanding balance
  • NPL ratio
  • Weekly disbursements by product group
  • Disbursements by branch
  • Results by branch

Applications and disbursements

Loan applications by acquisition channel, approval rate, and disbursements by product and partner dealer.

  • Loan applications
  • Approval rate
  • Loans disbursed
  • Average loan size
  • Weekly approval rate
  • Approval rate by acquisition channel
  • Disbursements by loan product
  • Disbursements via partner dealers

Portfolio quality and collections

Outstanding balance by risk group, NPL ratio, PAR30, collection rate and interest income.

  • NPL ratio
  • Portfolio at risk 30+ days (PAR30)
  • Collection rate
  • Interest income collected
  • Outstanding balance by risk group
  • Monthly NPL ratio by product group
  • NPL ratio by branch
  • Monthly collection rate by product group

Ask Si as soon as the build finishes

  • “How did net income on average outstanding change compared with last month?”
  • “What is driving operating expenses to average outstanding this quarter?”
  • “Show booked revenue not collected as interest 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
Net income on average outstandingLedger gross profit (booked revenue minus funding costs recorded in cost of goods sold) divided by the average of month-end outstanding balance snapshots in the period. A rate for the period asked, not annualized.= Gross profit / Average outstanding balanceRatio (%)
Operating expenses to average outstandingBooked selling and administrative expenses (including salaries, dealer commissions, premises rent and credit loss provisions) divided by the average of month-end outstanding balance snapshots in the period. A rate for the period asked, not annualized.= Selling and administrative expenses / Average outstanding balanceRatio (%)
Booked revenue not collected as interestBooked accounting revenue (accrued interest income, insurance commissions) minus interest income actually collected from repayment schedules in the period. Positive means the books recognize more than the interest customers paid: accrued interest not yet collected, accrued interest on bad debt not yet reversed, or non-interest revenue.= Booked revenue - Interest income collectedCurrency
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
Loan applicationsNumber of loan applications submitted in the period (by submission date), across all decisions: approved, rejected, pending review and withdrawn by the customer.Count
Approval rateApproved applications divided by decided applications (approved plus rejected), by submission date. Applications pending review or withdrawn by the customer are excluded.= Approved applications / (Approved applications + Rejected applications)Ratio (%)
Approved applicationsApplications submitted in the period that were approved for a loan (by submission date).Count
Average NPL balanceOutstanding principal in debt groups 3-5, averaged over the month-end snapshots in the period.= fs_npl_outstanding_total / fs_snapshot_countCurrency
Average outstanding balanceOutstanding principal averaged over the month-end snapshots in the period = total outstanding across snapshots / number of snapshots.= fs_outstanding_snapshot_total / fs_snapshot_countCurrency
Average loan sizeDisbursed amount divided by the number of loans disbursed in the period.= Disbursed amount / Loans disbursedCurrency
Collected amountTotal paid by customers (principal and interest) in the period, by payment date.Currency
Collection rateAmount collected on installments falling due in the period divided by the amount due on those installments (by due date, with collections counted up to the data date).= fs_collected_for_due / Amount dueRatio (%)
Disbursed amountTotal principal disbursed for loans in the period (by disbursement date).Currency
Amount dueTotal principal and interest of repayment installments falling due in the period (by due date).Currency
Interest income collectedThe interest portion of customer payments in the period (by payment date). Payments are applied first to the interest of earlier installments, the remainder to principal.Currency
Loans disbursedNumber of loans (credit contracts) disbursed in the period.Count
NPL ratioOutstanding balance in debt groups 3-5 (more than 90 days past due) divided by total outstanding, on the month-end snapshots in the period.= fs_npl_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Portfolio at risk 30+ days (PAR30)Outstanding principal of loans more than 30 days past due divided by total outstanding, on the month-end snapshots in the period.= fs_par30_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Rejected applicationsApplications submitted in the period that were declined (by submission date).Count

Data you need

Required

branch, loan_product, loan, repayment, loan_balance_monthly, fin_account, fin_journal_line

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, 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: branch, loan_product, loan, repayment, loan_balance_monthly, 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 Financial services · Finance & accounting with your own data

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