Skip to content

Dashboard templates

Financial services · Operations

A consumer finance company that buys card blanks, pre-printed application and contract forms and point-of-sale equipment; each branch keeps a supplies stock and sends original documents to the archive. Applications, disbursements and bad debt plus supplier on-time rate, inventory, stockouts and the late archive shipment rate by branch.

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

For operations teams at consumer finance companies who buy card blanks, pre-printed forms and point-of-sale equipment, and send original loan files to the archive. The "Original files to archive" dashboard shows file shipments, late or lost shipments and the late rate by branch. The "Purchasing and inventory" and "Warehouse deliveries" dashboards track supplier on-time delivery, fill rate, average inventory and stockout days. Needs branch, loan product, loan and shipment data.

Use this template to

  • Remind the branches that are latest in sending original files to the archive.
  • Replace card blank suppliers that often deliver late.
  • Avoid running out of supplies at branches by tracking stockout days.

6 ready-made dashboards

Original files to archive

Shipments of original files and contracts from branches to the archive, next to each branch's disbursements and NPL.

  • Late or lost archive shipment rate
  • Late or lost archive shipments
  • Archive document shipments
  • Loans disbursed
  • Late or lost file rate by branch
  • Weekly late file rate by region
  • Branches - disbursement, NPL and original files
  • Late rate by carrier

Purchasing and inventory

Purchase orders, supplier on-time and in-full delivery, lead time, average inventory and stockouts.

  • Purchase order value
  • Supplier on-time rate
  • Average inventory value
  • Stockout item-days
  • Results by supplier
  • Average inventory by item group
  • Stockout days by item group
  • Weekly average inventory by warehouse

Warehouse deliveries

Deliveries, on-time and failed delivery rates by warehouse and carrier.

  • Shipments
  • On-time delivery rate
  • Failed delivery rate
  • Failed shipments
  • Delivery results by warehouse
  • Failed delivery rate by carrier
  • Weekly failed delivery rate by warehouse

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 late or lost archive shipment rate change compared with last month?”
  • “What is driving late or lost archive shipments this quarter?”
  • “Show archive document shipments by month for the last six months.”
  • “Where is average inventory value highest this month, and why?”

31 defined metrics

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

MetricDefinitionUnit
Late or lost archive shipment rateLate or lost document shipments divided by all document shipments sent to the archive in the period (by ship date).= Late or lost archive shipments / Archive document shipmentsRatio (%)
Late or lost archive shipmentsShipments of original documents sent in the period (by ship date) that reached the archive after the promised date, were lost or were returned to the branch. Shipments still in transit are not counted.Count
Archive document shipmentsShipments of original documents and contracts from branches to the archive in the period (by ship date), any outcome. Joined to branches by warehouse name matching branch name, so it can be broken down by branch and region.Count
Average inventory valueAverage end-of-day inventory value in the period = sum of snapshot values divided by the number of days with a snapshot.= ops_inventory_value_total / ops_snapshot_daysCurrency
Average supplier lead time (days)Average days from order to receipt for purchase orders received in the period.= ops_lead_days_total / Received purchase ordersNumber
Failed delivery rateFailed or returned shipments divided by all outbound shipments in the period.= Failed shipments / ShipmentsRatio (%)
Failed shipmentsOutbound shipments in the period that failed delivery or were returned to the warehouse.Count
On-time delivery rateOn-time deliveries divided by all outbound shipments in the period (by ship date).= ops_on_time_deliveries / ShipmentsRatio (%)
Purchase ordersPurchase orders placed in the period (by order date), excluding cancelled orders.Count
Purchase order valueTotal ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders.Currency
Received purchase ordersPurchase orders received in the period (by receipt date), including partial receipts.Count
Received goods valueTotal received quantity times unit price for purchase orders received in the period (by receipt date).Currency
ShipmentsOutbound shipments from the warehouse in the period (by ship date), any outcome.Count
Stockout item-daysInventory snapshots with zero (or negative) quantity in the period: each item out of stock at one warehouse on one day counts as 1.Count
Supplier fill rateReceived value divided by ordered value of purchase orders received in the period. 100% means delivered in full; lower means the supplier short-shipped.= Received goods value / ops_closed_po_valueRatio (%)
Supplier on-time rateOn-time PO receipts divided by received purchase orders in the period (by receipt date).= ops_on_time_receipts / Received purchase ordersRatio (%)
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, ops_shipment

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, repayment, loan_balance_monthly, ops_supplier, ops_item, ops_purchase_order, ops_purchase_order_line, ops_inventory_snapshot

Three steps to this dashboard

  1. 1

    Connect your data

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

  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 31 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 · Operations with your own data

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