Blog · Board and management reporting · Retail banking
A retail banking dashboard connects branch income with product activation and customer balances. A worked branch example shows the calculations, a single-input variation and the checks needed before explaining performance.
A retail banking dashboard compares branch income, product activation and customer balances from finance and operating exports. It should show whether income improved, whether balances grew and whether customers started using newly opened products, with a separate definition for each measure.
Start with a clear purpose: a regional manager needs to identify where the movement requires a pricing, customer-service or branch-operations discussion. A higher balance does not automatically explain higher income, and a newly opened account is not automatically an active product.
The FDIC's Quarterly Banking Profile reports bank earnings alongside loan and deposit activity. That is a useful reminder to review financial outcomes and balance activity together. Its industry totals are a different reporting level from the internal branch comparison here.
For established definitions across customer relationships, start with customer KPIs for financial services firms. This page arranges a smaller set into a branch operating review. The neighboring banking KPI dashboard provides the broader banking view.
Bring three controlled exports. The first contains monthly branch-assigned net interest income and net fee income, using finance's approved management attribution. The second contains branch-level deposit balances at each reporting date. The third contains aggregate new-product cohort counts, eligible openings and qualifying activations.
Use branch summaries without customer names or account numbers for this review. Keep the underlying records within the bank's established controls. Agree on whether relationships belong to an originating branch, servicing branch or another assignment, and apply that rule consistently to both periods.
Consider an illustrative community bank reviewing July and August 2026 at Central, Lake and West branches. Assigned net interest income already includes finance-approved internal funding attribution. Net fee income is after refunds and reversals. The dashboard does not independently allocate the bank's interest results from deposit balances.
Branch income shown here = Assigned net interest income + Net fee income
This is an income subtotal before operating costs, credit costs and taxes. It is not branch profit.
| Branch | July assigned net interest income (USD) | July net fees (USD) | August assigned net interest income (USD) | August net fees (USD) |
|---|---|---|---|---|
| Central | 120,000 | 20,000 | 126,000 | 24,000 |
| Lake | 80,000 | 15,000 | 78,000 | 16,000 |
| West | 60,000 | 10,000 | 66,000 | 12,000 |
| Total | 260,000 | 45,000 | 270,000 | 52,000 |
Add the income components for each month, then subtract the prior month:
| Branch | July income calculation (USD) | August income calculation (USD) | Income movement (USD) |
|---|---|---|---|
| Central | 120,000 + 20,000 = 140,000 | 126,000 + 24,000 = 150,000 | 10,000 |
| Lake | 80,000 + 15,000 = 95,000 | 78,000 + 16,000 = 94,000 | −1,000 |
| West | 60,000 + 10,000 = 70,000 | 66,000 + 12,000 = 78,000 | 8,000 |
| Total | 305,000 | 322,000 | 17,000 |
The component proof is (270,000 − 260,000) + (52,000 − 45,000) = $10,000 + $7,000 = $17,000. The branch proof is $10,000 − $1,000 + $8,000 = $17,000. Both reproduce the same movement.
Lake's fees improved while its assigned net interest income declined. That is the first question for finance and the branch manager; the total alone would conceal it.
Use balances at July 31 and August 31, 2026. Activation covers August checking-account openings, observed for a complete 30-day period after each opening. The review is prepared after those observation windows have closed. Each eligible account is counted once and qualifies only after its first settled customer-initiated payment within that window.
The qualifying event and observation length are this bank's illustrative operating definition. They are not an industry benchmark or a regulatory definition.
| Branch | July-end deposits (USD) | August-end deposits (USD) | Eligible August openings | Activated within window | Activation calculation |
|---|---|---|---|---|---|
| Central | 12,000,000 | 13,000,000 | 100 | 70 | 70 / 100 = 70.0% |
| Lake | 8,000,000 | 8,500,000 | 80 | 64 | 64 / 80 = 80.0% |
| West | 6,000,000 | 6,500,000 | 60 | 36 | 36 / 60 = 60.0% |
| Total | 26,000,000 | 28,000,000 | 240 | 170 | 170 / 240 = 70.8% |
Deposit balances increase by 28,000,000 − 26,000,000 = $2,000,000. The branch changes of $1,000,000, $500,000 and $500,000 reproduce that total. These are ending balances, not average balances, so do not use them to claim an income yield for the month.
Activation is 170 / 240 = 70.8%, rounded to one decimal place. Calculate from summed counts; retain the unrounded result for comparisons. West has rising deposits and income but the lowest activation rate in this example. That calls for a review of the onboarding cohort, not an assumption that all growth represents broader product use.
Do not compare unlike opening cohorts. Different products, opening channels or promotional campaigns may have different qualifying events and usage patterns. Keep those dimensions visible before interpreting a branch difference.
Suppose only West's qualifying activations change from 36 to 48. Its eligible openings remain 60, and every income and balance row stays as shown above.
| Revised measure | Calculation | Result |
|---|---|---|
| West activation rate | 48 / 60 | 80.0% |
| Total qualifying activations | 70 + 64 + 48 | 182 |
| Total activation rate | 182 / 240 | 75.8% |
| Increase in total rate | (182 − 170) / 240 | 5.0 percentage points |
This variation improves activation without changing reported income of $322,000 or deposits of $28,000,000. It demonstrates why activity and financial outcomes belong beside each other rather than being treated as interchangeable evidence. Any later income effect needs its own observed records.
Put the income subtotal, deposit balances and activation rate at the top. Below them, keep the branch rows, income components and eligible cohort counts. Display the financial month and the activation observation cutoff separately so a manager can tell which records are complete.
Finance owns income assignment and reconciliation. Deposit operations owns the balance control total. Branch operations owns the activation definition, duplicate checks and follow-up on incomplete records. A changed branch assignment should have a visible explanation and a comparable prior-period view.
The FDIC's Call Report forms and instructions provide the bank-level condition and income reporting materials. Reconcile this internal view through finance's approved management reports; do not label a branch subtotal as a published Call Report line or imply that these three branches represent the whole bank.
Keep investment-banking mandate and fee activity in the separate investment banking dashboard. For the cost side of branch performance, use retail banking cost analysis, rather than calling the income subtotal a margin.
Bring branch-level income, balance and aggregate activation files, or a Google Sheet with those summaries. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for retail banking for the supporting industry context.
A practical branch review starts with assigned net interest income, net fee income, customer balances and new-product activation. Add comparison periods and source coverage. Keep income separate from profit unless operating expenses and the relevant allocations are also included.
Use a documented qualifying event and observation window for each product. For a checking product, that might be a first settled customer-initiated payment within a fixed period after opening. Exclude accounts without a complete observation window from a mature-cohort comparison.
It can be one contributor, but it is not sufficient evidence on its own. Pricing, balance timing, product mix and internal funds-transfer assignments can also matter. Use the finance-approved attribution and compare average balances when analyzing period income against a balance base.