Commercial banking cost analysis by activity and client

Commercial banking cost analysis connects operating expenses to the activities that consume resources, then explains whether costs changed because volumes rose or each activity cost more. Start with reconciled cost pools, apply a suitable driver to each pool, and allocate the result to client segments only after those checks pass. An allocation is useful evidence for a servicing discussion, but it is not proof of avoidable expense.

This workflow serves a US commercial banking finance or operations team using ledger, payroll allocation and servicing exports. It covers operating service costs; funding costs, credit losses and capital charges need separate treatment in a full relationship profitability review.

Define the expense boundary

Write down the business unit, period, accounts and activities included. Keep the reporting basis consistent across both periods. The FFIEC Schedule RI instructions distinguish salaries and employee benefits, premises and fixed-asset expense, and other noninterest expense. Map the internal accounts to those reporting categories while preserving the activity view used by operations.

Do not confuse statutory expense categories with service activities. A payment-processing pool may include payroll, software and vendor charges from several ledger accounts. Each account amount must enter the scoped analysis once, even when an internal department performs several activities.

Use the bank's efficiency ratio as context, not as an explanation of service cost changes. The Federal Reserve Bank of New York's study of bank operating costs notes that the ratio is sensitive to revenue movements. An improved ratio does not establish that onboarding or servicing became cheaper.

Build the cost and activity files

The cost export needs period, cost center, ledger account, expense amount, activity pool and allocation status. Retain payroll allocations and vendor references supporting the pool. The activity export needs period, activity type, client or segment ID, completed quantity and any complexity classification.

Keep personally identifying client information out of the working example and use the minimum identifiers needed in the actual analysis. Stable client IDs are sufficient for joining the finance and service summaries.

Choose a driver that fits each pool. Completed onboarding cases can support onboarding costs; processed payments can support a payment-processing pool; servicing hours may fit relationship support better than account balances. If cases vary materially in effort, separate the complexity groups before calculating unit cost.

Keep corporate overhead separate when no defensible service driver exists. For wider business context, commercial banking revenue analysis handles the income side of the same relationships.

Calculate cost per activity

A hypothetical US commercial bank compares the second and third quarters of 2026 for three defined operating pools. For clarity, onboarding cases within this example have comparable effort, and service cases are also a single complexity group. The figures are constructed records, not peer benchmarks.

Columns A through G below form the spreadsheet layout. Prior and current pool costs come from the ledger mapping; the unit costs are calculated from those amounts and activity quantities.

Calculate the rates in C2 and F2, respectively, and fill down:

=IF(B2=0,"",D2/B2)
=IF(E2=0,"",G2/E2)

Do not add the volume column across different activities. Its units differ, so an overall cost per transaction would mix unrelated work. The cost total is additive.

The operating pools increased by $41,800, or 27.9%, calculated as (191800-150000)/150000 and rounded to one decimal place. Reconcile the broader scoped cost as well:

The current $211,800 must tie to the selected ledger accounts. It is not presented as the bank's entire noninterest expense.

Explain the variance before allocating it

Use prior unit cost to isolate the effect of changed volumes. Apply the unit-cost change to current volume, which assigns the interaction to that component.

Volume effect = (Current volume - Prior volume) × Prior unit cost

Unit-cost effect = Current volume × (Current unit cost - Prior unit cost)

Enter the volume effect, unit-cost effect and residual check in H2, I2 and J2, respectively, then fill down:

=(E2-B2)*C2
=E2*(F2-C2)
=ROUND(G2-D2-H2-I2,2)

Every J cell must equal zero. The total identity is $150,000 + $32,000 + $9,800 = $191,800. Payments cost more overall while becoming cheaper per payment; onboarding and service cases have increases in both volume and unit cost.

The unit-cost effect is a diagnostic, not a pure wage or supplier-price variance. It can include staffing changes, unused capacity, case complexity and a changed expense boundary. Operations must verify which explanation fits the source records.

Allocate current activity costs to client segments

Apply the current unit costs to each segment's recorded volumes. The segment quantities below sum to the activity totals above. Costs are rounded to whole dollars because these calculations produce exact dollar amounts.

For a segment table starting in row 10, with the columns shown, enter these formulas in E10, F10, G10 and H10, respectively:

=B10*$F$2
=C10*$F$3
=D10*$F$4
=SUM(E10:G10)

The allocated total must equal the activity pool total. Keep the $20,000 of corporate overhead visible outside this table unless management approves a separate basis for assigning it.

Use the result to investigate onboarding effort, service demand and process capacity. Do not rank relationship profitability from cost alone or assume a client closure would remove its allocated amount. Retail banking cost analysis and investment banking cost analysis use different activity boundaries; their unit costs are not interchangeable with these pools.

Where it goes wrong

• One driver allocates every expense. Loan balances or revenue may not explain payment or onboarding work. Choose drivers within each pool.
• Shared payroll enters twice. Reconcile personnel allocations back to the source payroll amount before adding vendor or overhead costs.
• Quarterly activity meets year-to-date expense. Align periods before calculating unit costs, including reversals and accruals.
• Closed cases hide unfinished work. Track work in progress and capacity separately when current expense supports cases completed later.
• Allocated expense becomes a savings claim. Confirm which staffing, contracts or capacity would change before treating the allocation as cash savings.

Analyze your own banking cost file in Covirage

Bring a sample of your own operating expense and activity summaries to Covirage, with the pool definitions and ledger controls identified. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.

See Covirage for commercial banking for the supporting industry context.