Skip to content

Dashboard templates

Financial services · HR

Consumer finance company with loan officers at branches and partner dealers, plus underwriting and collections teams at head office. Applications, disbursements and bad debt, plus average headcount, terminations, payroll cost, overtime, recruiting and disbursements per branch employee.

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

For HR teams at consumer finance companies with loan officers at branches and dealers, plus underwriting and collections teams. The "Loan officer productivity" dashboard calculates disbursements per branch employee and per company employee. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards cover average headcount, attrition rate, payroll cost, overtime hours, time to hire and offer acceptance rate. Needs branch, loan product, loan and employee data. Payroll and timekeeping are optional.

Use this template to

  • Compare disbursement productivity across branches before allocating hiring quotas.
  • Spot branches with unusually high attrition in the quarter.
  • Track collections team overtime at month end.

6 ready-made dashboards

Loan officer productivity

Disbursements against average headcount by branch and company-wide.

  • Disbursements per branch employee
  • Disbursements per employee (company-wide)
  • Average branch headcount
  • Disbursed amount
  • Disbursements per employee by branch
  • Monthly disbursements per branch employee

Headcount and attrition

Average headcount, new hires, leavers and attrition rate by department.

  • Average headcount
  • New hires
  • Terminations
  • Turnover rate
  • Headcount movement by department
  • Attrition rate by department
  • Monthly leavers by department

Payroll cost and recruiting

Payroll, overtime, absence costs and recruiting effectiveness.

  • Payroll cost
  • Overtime hours
  • Absence rate
  • Offer acceptance rate
  • Monthly payroll cost by department
  • Weekly overtime hours by department
  • Recruiting by department

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 average branch headcount change compared with last month?”
  • “What is driving disbursements per branch employee this quarter?”
  • “Show disbursements per employee (company-wide) by month for the last six months.”
  • “Where is absence days highest this month, and why?”

33 defined metrics

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

MetricDefinitionUnit
Average branch headcountAverage daily number of employees working at lending branches (loan officers, branch managers) in the period. Excludes head-office staff.= fs_hr_branch_headcount_days / fs_hr_branch_snapshot_daysNumber
Disbursements per branch employeeAmount disbursed in the period divided by average branch headcount (loan officers and branch managers). When broken down by branch or region, numerator and denominator are both filtered to that branch.= Disbursed amount / Average branch headcountCurrency
Disbursements per employee (company-wide)Amount disbursed in the period divided by average headcount of the whole company (branches and head office).= Disbursed amount / Average headcountCurrency
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
ApplicantsNumber of candidates who applied in the period (by application date).Count
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
Average monthly cost per employeePayroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslipsCurrency
New hiresNumber of employees with a start date in the period.Count
Offer acceptance rateOffers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sentRatio (%)
Job offers sentNumber of candidates sent a job offer in the period (by offer date).Count
Overtime hoursTotal overtime hours recorded in timesheets.Number
Payroll costTotal employer cost of personnel: base salary, allowances, overtime pay and employer-paid insurance. Payroll is recorded monthly, on the first day of the month.Currency
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Average time to hire (days)Average number of days from application to offer date for hired candidates, by offer date.= hr_hire_days_total / hr_offers_acceptedNumber
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary terminationsNumber of employees who resigned, with their last working day in the period.Count
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
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, hr_employee

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, repayment, loan_balance_monthly, hr_payroll, hr_attendance, hr_candidate

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 33 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 · HR with your own data

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