Banking KPI dashboard: income, funding, and service

A banking KPI dashboard should connect monthly income, funding balances, and service results so managers can explain the bank total through its business units. Show the underlying dollars and counts beside each ratio. A useful overview answers what changed, which unit contributed, and which source total proves the result.

Set the scope before choosing the charts

Use this layout for a bank-wide commercial management review. The FDIC's Quarterly Banking Profile covers earnings, loan and deposit activity, and asset quality across insured institutions; those categories provide useful context, but an internal monthly dashboard needs the bank's own definitions and files.

Start with a closed monthly income statement, average earning-asset balances, closing loan and deposit balances, and an aggregate service export. Record the period, balance basis, business unit mapping, and treatment of internal transfers. External income and expense must appear once across the bank. Any internal allocations must cancel at the bank total.

Keep customer relationship detail in relationship KPIs for commercial banking. A retail banking dashboard addresses branch and customer activity, while an investment banking dashboard serves a different operating review. The overview here links those audiences through common totals without reproducing their layouts.

A monthly example for a US bank

Cedar Basin Bank is an illustrative US bank reviewing September 2026, a completed month with 30 days. The income export contains these amounts. Noninterest expenses include the bank's agreed operating cost allocations. Fee income has already been adjusted for reversals.

Calculate income in successive steps so readers can reconstruct the subtotal rather than trust a card:

Net interest income = Interest income − Interest expense

Management net revenue = Net interest income + Fee income

Pre-provision operating contribution = Management net revenue − Noninterest expense

The proof is $4,200,000 − $1,800,000 + $400,000 − $1,700,000 = $1,100,000. The business unit contributions also sum to that amount. This management subtotal excludes credit loss provision and taxes; it is not net income.

Retail's negative contribution needs investigation, but it does not alone establish the unit's full relationship value. Check cost attribution and the allocation of funding benefits before making a staffing or pricing decision.

Put balances beside income, with their basis visible

The balance export uses average earning assets for September and closing balances on September 30, 2026. Amounts are in USD, without scaling into millions.

The Federal Reserve's H.8 release presents commercial bank assets and liabilities, including loans and deposits, separately. Preserve that distinction in your own dashboard: a funding balance is not revenue, and a balance change is not an income change.

For this example, use an actual-day annualization convention and no tax-equivalent adjustment. Show the convention beside the result.

Percentages are rounded to two decimal places after calculation. The efficiency ratio here uses only the revenue and expense definitions shown above; any comparison with another report must use matching adjustments. The loans-to-deposits ratio is a management comparison, not a complete liquidity assessment.

Add service without averaging unit percentages

The service file counts completed requests and those completed within each request's agreed deadline. It includes the same period and consistent request types across units. Treasury has no eligible customer requests in this file, so its service percentage is blank rather than zero.

The bank result is 2,386 / 2,600, calculated from counts. Requests still open at month end need a separate backlog count; they cannot quietly disappear from the service discussion. Operations owns the classification and deadlines, while finance checks that the dashboard uses the approved extract.

Use the KPI dashboard template for generic target and status rules. Keep this page's banking definitions attached to those rules rather than adopting a target without its denominator.

Change one input: retail interest expense

Suppose retail interest expense changes from $800,000 to $900,000. All other exported amounts remain unchanged. This is a sensitivity case, not a prediction about depositor behavior or future rates.

The extra $100,000 of expense reduces contribution by $100,000. Efficiency worsens despite unchanged noninterest expense because its revenue denominator falls. Closing loans, deposits, and service results do not change in this case. The CFO can therefore assign a funding-cost review without attributing the movement to service productivity.

Where banking dashboards go wrong

• Mixing balance bases. Closing earning assets in one month and daily averages in the next can move margin without any change in underlying economics.
• Counting internal transfers as bank income. Unit allocations need an explicit elimination check before consolidation.
• Treating missing activity as zero. No eligible requests means no service percentage, not failed service.
• Changing ratio adjustments silently. Tax-equivalent income or excluded expenses create a new calculation basis that must be labeled.
• Skipping ledger ties. Reconcile each income column, each closing balance, and the request counts before interpreting unit performance.

Review your own bank exports in Covirage

Bring a monthly income file, balance workbook, and aggregate service export; Covirage maps the columns, and its tools compute and check the figures while the external AI model explains movements 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 commercial banking for the industry context.