Skip to content
Alternative Finance

Lending software · Funders and platforms

Loan portfolio dashboard builder

This loan portfolio dashboard builder reads a pasted CSV of funded deals and computes the KPIs a funder's dashboard shows: outstanding balance, accounts, total funded, average deal, weighted gross yield, share of purchased amount delivered, 30-plus and 90-plus day delinquency by balance, largest industry and state, and balance by vintage with its delinquency. It is for funders, platforms and investors who need portfolio numbers without a BI build. Watch concentration: in a small book one large account can be a third of the balance and the dashboard will show it.

Outstanding balance
$270,300
Accounts
8
Total funded
$445,000
Average deal
$55,625
Weighted gross yield
28.4%
Purchased amount delivered
53%
30+ day delinquency
4.8%
90+ day delinquency
1.1%
Largest industry
Manufacturing 36%
Largest state
OH 36%

Everything is computed in your browser; the file is not uploaded. Match the header names exactly or rename the columns in your export.

Balance by industry
$98,000Manufacturing$66,000Medical$41,000Construction$24,100Restaurants$19,000Salons$12,400Trucking$9,800Retail
Balance by vintage
VintageBalanceShare30+ DPD share
2026-Q2$205,00076%0%
2026-Q1$52,40019%0%
2025-Q4$9,8004%100%
2025-Q3$3,1001%100%

Formula

Outstanding balance = Σ balance. Total funded = Σ funded. Average deal = Total funded ÷ Accounts.

Weighted gross yield = Σ funded × (factor − 1) ÷ Σ funded. Purchased amount delivered = 1 − Outstanding balance ÷ Σ funded × factor.

30+ day delinquency = Σ balance where days_past_due ≥ 30 ÷ Outstanding balance; 90+ the same with ≥ 90. Both are balance-weighted, not account counts.

Concentration = balance in the largest industry (or state) ÷ Outstanding balance. Vintage table = balance, share of balance and 30+ day share for each vintage label.

Worked examples

Example 1: the sample portfolio of eight deals

Balances: 21,000 + 12,400 + 66,000 + 9,800 + 41,000 + 3,100 + 98,000 + 19,000 = $270,300. Funded: 50,000 + 30,000 + 80,000 + 25,000 + 60,000 + 45,000 + 120,000 + 35,000 = $445,000; average deal $445,000 ÷ 8 = $55,625. Gross yield: each deal's funded × (factor − 1) is 15,000 + 10,500 + 20,000 + 10,000 + 16,800 + 14,400 + 26,400 + 13,300 = $126,400; divided by $445,000 that is 28.4 percent. Total purchased amount: $445,000 + $126,400 = $571,400; delivered 1 − 270,300 ÷ 571,400 = 52.7 percent, shown as 53 percent. Delinquency: accounts 1004 (45 days, $9,800) and 1006 (95 days, $3,100) are 30-plus, $12,900 ÷ $270,300 = 4.8 percent; only 1006 is 90-plus, $3,100 ÷ $270,300 = 1.1 percent. Both are inside the tool's warning thresholds of 8 and 3 percent and show green. Largest industry: Manufacturing, $98,000, 36 percent of balance; largest state: Ohio, the same $98,000, 36 percent, because one deal is both. Vintage table: 2026-Q2 $205,000 (76 percent, 0 percent 30-plus), 2026-Q1 $52,400 (19 percent, 0 percent), 2025-Q4 $9,800 (4 percent, 100 percent), 2025-Q3 $3,100 (1 percent, 100 percent). The older vintages are entirely delinquent, which is typical: deals that are still open long after their expected delivery are the ones that have slowed or stopped.

Example 2: the same book without the largest deal

Delete the row for 1007 (Manufacturing, Ohio, $120,000 funded at 1.22, $98,000 balance). Balance: $270,300 − $98,000 = $172,300. Funded: $325,000; average deal $325,000 ÷ 7 = $46,429. Gross yield: $126,400 − $26,400 = $100,000 ÷ $325,000 = 30.8 percent, higher because the large deal was priced lowest. Purchased amount: $571,400 − $146,400 = $425,000; delivered 1 − 172,300 ÷ 425,000 = 59.5 percent, shown as 59 percent. Delinquency: the same $12,900 over a smaller balance, 30-plus $12,900 ÷ $172,300 = 7.5 percent, close to the 8 percent warning; 90-plus $3,100 ÷ $172,300 = 1.8 percent. Largest industry becomes Medical at $66,000, 38 percent, and largest state Florida at 38 percent. One account changed every KPI by several points. That is the lesson of a small portfolio: the dashboard numbers are driven by a handful of deals, and a reader should look at the account count before trusting any percentage.

Example 3: one account crossing 30 days

Return to the full sample and change account 1002 (Trucking, Texas, $12,400 balance) from 12 days past due to 35. The 30-plus balance becomes $12,900 + $12,400 = $25,300, and 30-plus delinquency $25,300 ÷ $270,300 = 9.4 percent, above the 8 percent threshold, so the output turns amber. The 90-plus figure is unchanged at 1.1 percent. In the vintage table, 2026-Q1 now shows a 30-plus share of $12,400 ÷ $52,400 = 23.7 percent, shown as 24 percent, while 2026-Q2 stays at zero. Nothing else moves. This is the kind of change a weekly dashboard refresh exists to catch: the balance is the same, yield is the same, but one deal moving from early to serious delinquency changes the loss outlook, and the vintage view shows which funding quarter it came from. The loan delinquency rate calculator goes deeper on roll rates between buckets.

What the dashboard computes and how to prepare the file

The builder expects a header row with eight columns: id, funded, factor, balance, days_past_due, industry, state and vintage. Column names are matched case-insensitively but must be spelled exactly; rows whose funded or balance cells do not parse as numbers are dropped. funded is the amount advanced or lent; factor is the payback multiple (1.30 for an advance; for a loan, enter total of payments divided by principal, or 1 if you only want balance metrics); balance is the current outstanding principal or undelivered purchased amount; days_past_due is the age of the oldest missed payment, zero if current; industry and state are free text and are grouped as typed, so Restaurants and Restaurant are different groups; vintage is any label, usually a quarter. Everything is computed in your browser and nothing is uploaded. The loan data validation tool checks a file for blanks, bad numbers and duplicate ids before you paste it here.

KPIs and what each one tells you
KPIComputed asWhat to look for
Outstanding balanceSum of balanceThe exposure; compare with capital and credit lines
Average dealFunded ÷ accountsDrift upward means larger, often lower-yield deals
Weighted gross yieldFunded-weighted (factor − 1)Price of the book before losses and cost of funds
Purchased amount delivered1 − balance ÷ total paybackMaturity of the book; low means young, high means seasoned
30+ / 90+ delinquencyDelinquent balance ÷ balanceEarly and serious trouble; thresholds 8 and 3 percent in the tool
Largest industry / stateTop group's balance shareConcentration; one account can dominate a small book
Vintage mixBalance and 30+ share by labelWhich funding periods carry the problems

Reading the KPIs and avoiding false comfort

Weighted gross yield is the contractual markup on the book, not a return. From it come losses, cost of funds, commissions and operating cost; the loan portfolio yield calculator annualizes it and the funding portfolio ROI calculator nets it down. A rising gross yield can mean better pricing or riskier deals; read it with delinquency. Purchased amount delivered is a seasoning measure: a book at 20 percent delivered has not yet had time to show defaults, so a low delinquency rate on it means little. Delinquency by balance is the standard, but it hides counts: five small delinquent accounts can be a lower balance share than one large one. Look at the vintage table, where the 30-plus share by funding period shows whether a problem is spread across the book or concentrated in one period's underwriting.

  • A delinquency rate measured on balance falls as delinquent accounts are written off; a book that charges off aggressively looks cleaner than one that keeps accounts on the books. Compare with the loan recovery rate calculator and track charge-offs separately.
  • Days past due on a daily-pay advance ages faster than on a monthly loan; a 30-day figure means roughly 21 missed debits. Decide the convention and apply it to the whole file.
  • Industry and state labels must be consistent; the NAICS classification is a workable standard for industry if you want to compare with public data on business survival by sector.
  • Factor rates below 1 or above 2.5 are almost always data errors; the validator catches them.
  • Eight accounts is a demonstration. Percentages on fewer than a few dozen accounts move by whole points when one account changes, as Example 2 shows.

How funders, investors and lenders use these numbers

A funder's credit committee reads the dashboard weekly for three decisions: whether to keep funding at the current pace, whether pricing or underwriting needs to tighten in a sector or state, and whether reserves are adequate. Capital providers (credit facilities, syndicate participants, note investors) receive the same KPIs monthly as covenants: typical facility terms cap 30-plus and 90-plus delinquency as a share of eligible balance, cap concentration by industry, state and single obligor, and set a minimum weighted yield; breaching one triggers a borrowing-base reduction. The loan portfolio concentration calculator computes the single-obligor and sector concentrations in the form facility agreements use, and the Herfindahl index is the summary statistic for how spread out a book is.

For lenders that report under U.S. GAAP, the current expected credit loss standard (CECL) requires a lifetime loss allowance on funded loans from origination, estimated from historical loss experience adjusted for current conditions and reasonable forecasts; the Federal Reserve's CECL resource page collects the supervisory guidance, and the vintage table is the natural input, because loss rates by vintage age are how most small lenders build the estimate. The expected credit loss calculator and the loan loss reserve calculator turn delinquency and historical roll rates into an allowance. Bank lenders and their funders can also expect the FDIC and other supervisors to ask for concentration and delinquency reporting in this form during examinations of purchased or participated loans.

Public data gives context for the concentration figures. The Census Bureau's Annual Business Survey and the Bureau of Labor Statistics' Business Employment Dynamics series report establishment counts, births and deaths by industry and state; a book that is 36 percent manufacturing in a state where manufacturing establishments are closing is a different risk from the same share in a growing sector. The Federal Reserve's Small Business Credit Survey reports which industries sought financing and how they fared, which is useful when deciding whether a sector concentration is a choice or an accident of lead flow.

From one dashboard to a monitoring routine

  1. 1

    Export weekly from the servicing system

    Map the export's columns to the eight the builder expects; keep the mapping in a saved query so every week's file is identical in structure.

  2. 2

    Validate before pasting

    Run the file through the validator; fix duplicates and bad numbers in the source system, not in the spreadsheet.

  3. 3

    Record the KPI download

    The builder's CSV download has the headline figures; append them to a history so trends are visible.

  4. 4

    Set thresholds and owners

    The tool flags 30-plus above 8 percent and 90-plus above 3 percent; set your own facility and policy limits and name who acts when a figure crosses.

  5. 5

    Review vintages quarterly

    A funding quarter whose 30-plus share is rising at the same age where earlier quarters were flat is the earliest signal of an underwriting change that went wrong.

The dashboard is descriptive. Pricing decisions that follow from it use the risk-based loan pricing calculator; the servicing economics of a book this size are in the loan servicing fee calculator.

Glossary

Terms used in the loan portfolio dashboard
TermMeaning
VintageThe period in which a group of deals was funded; performance is compared at the same age across vintages
SeasoningHow far through its life a deal or book is; measured here as purchased amount delivered
Days past dueAge of the oldest unpaid scheduled payment; zero when current
Balance-weightedA rate computed on dollars outstanding rather than on account counts
ConcentrationShare of balance in one obligor, industry, state or vintage
Gross yieldContractual markup (factor − 1) before losses, cost of funds and expenses
Roll rateShare of balance that moves from one delinquency bucket to the next in a period

Questions people ask

What columns does the loan portfolio dashboard need?

A header row with id, funded, factor, balance, days_past_due, industry, state and vintage, in any order, matched case-insensitively. Rows with non-numeric funded or balance values are skipped. If your export uses different names, rename the header line before pasting. Nothing is uploaded; the computation runs in your browser.

How is weighted gross yield different from APR?

Gross yield here is the funded-weighted average of factor minus one: the contractual markup on the book regardless of how long delivery takes. APR annualizes cost over time and depends on the term. Two books with the same gross yield can have very different annualized returns if one is collected in four months and the other in twelve.

Why is delinquency measured on balance rather than accounts?

Because losses are in dollars. One $98,000 account past due matters more than three $5,000 accounts. Facility covenants and reserve calculations use balance-weighted rates for the same reason. Track the account-count rate too, since it signals how widespread a problem is.

What are reasonable delinquency thresholds?

The tool flags 30-plus above 8 percent and 90-plus above 3 percent of balance as a general alert for short-term commercial books; your own limits should come from your historical loss experience and your credit facility's covenants, which commonly set caps in this range or tighter. A young book with low seasoning should be held to a stricter standard because it has not had time to show losses.

Can I use the dashboard for term loans rather than advances?

Yes. Enter factor as total scheduled payments divided by principal (for example 1.19 for a loan whose payments sum to 119 percent of principal), or 1 if you want yield left out. Balance is the current principal. Delivered then means share of scheduled payments received. Days past due works the same way.

Sources and further reading

Related tools and guides

More lending software

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Turn the estimate into real offers

One request, several funding partners, side-by-side payback. Nothing is binding until you accept an offer.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

See what you may qualify for

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.