Skip to content

Dashboard templates

Financial services · Sales

A consumer finance company whose sales team signs installment partnerships with dealers (motorbike, electronics and phone stores) and loan programs for corporate employees. Applications, disbursements and bad debt plus opportunities, win rate, targets and disbursements via dealers brought in by sales.

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

For sales teams at finance companies signing installment partnerships with motorbike, electronics and phone dealers. The "Dealers brought in by sales" dashboard shows disbursements, loan count and the share of disbursements from dealers the sales team signed. The "Opportunities and quota" dashboard tracks new opportunities, win rate, won contract value, sales cycle and quota attainment, while the credit dashboards show loan quality. Needs branch, loan product, loan and sales opportunity data.

Use this template to

  • Reward reps on real disbursements from the dealers they signed, not on contract count.
  • Know whether newly signed dealers bring in good-quality loans.
  • Track quota attainment by month.

5 ready-made dashboards

Dealers brought in by sales

Disbursements through new dealers signed by the sales team, and their share of company-wide disbursements.

  • Disbursements via sales-signed dealers
  • Sales-signed dealer share of disbursements
  • Loans via sales-signed dealers
  • Won opportunities
  • New-dealer disbursements by salesperson
  • Weekly share of disbursements from new dealers
  • New dealers by disbursement

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

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 disbursements via sales-signed dealers change compared with last month?”
  • “What is driving loans via sales-signed dealers this quarter?”
  • “Show sales-signed dealer share of disbursements by month for the last six months.”
  • “Where is average deal size highest this month, and why?”

28 defined metrics

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

MetricDefinitionUnit
Disbursements via sales-signed dealersTotal principal disbursed in the period (by disbursement date) for loans originated at dealers the sales team has signed (dealer name matches the customer of a won opportunity). Attributed to the rep of the first won opportunity.Currency
Loans via sales-signed dealersLoans disbursed in the period at dealers the sales team has signed (with a won opportunity).Count
Sales-signed dealer share of disbursementsDisbursements via sales-signed dealers divided by the company's total disbursements in the period.= Disbursements via sales-signed dealers / Disbursed amountRatio (%)
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close date.Count
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, opportunity

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, repayment, loan_balance_monthly, sales_rep, sales_target

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: branch, loan_product, loan, opportunity.

  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 28 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 · Sales with your own data

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