Blog · Finance metrics and formulas · Retail banking
Compare branch and channel operating costs using documented activity drivers. Build a cost-per-transaction worksheet, reconcile allocated expenses and separate volume effects from spending changes.
Retail banking cost analysis compares branch and channel operating expenses with the activity those resources support. Assign direct costs, make shared allocations explicit and calculate cost per transaction from consistent counts before comparing locations or periods.
This operating view answers a different question from a bank financial statement ratio. A branch can have expensive transactions yet perform valuable service work, so use the measure to investigate resource use alongside service quality and business purpose.
Collect the operating expense ledger, branch cost-center mapping, transaction summary and approved budget. The transaction file should identify period, branch or channel, activity category and completed count. Summarize both files to the same grain before combining them.
Decide what counts as a transaction. For example, include a defined set of completed routine service events and exclude retries, test records and incomplete requests. Keep account inquiries separate if the work differs substantially. Preserve the original counts so the report can show how its denominator was formed.
Use incurred costs for the reporting period rather than whichever bills happened to be paid. The IRS explanation of accounting methods distinguishes accrual expenses from payment timing; that distinction explains why an accounts payable payment export may not represent a month's operating expense. Follow the controller's accounting policy when preparing the ledger scope.
For external context, the FDIC Quarterly Banking Profile summarizes aggregate financial conditions, including earnings, loans and deposits, for insured institutions. Those institution-level results do not provide a directly comparable branch transaction denominator. Build this operating measure from your own activity records.
Branch or channel cost = Direct operating expenses + Allocated shared operating expenses
Cost per transaction = Branch or channel cost / Completed transactions
Assign costs directly when a ledger line clearly belongs to one location or channel. Payroll and rent tagged to a branch need no transaction-based allocation. For shared expenses, document the cost pool, allocation driver and period separately.
One driver rarely fits everything. A processing support pool may follow transaction counts, while an occupancy pool may follow usable space. Keep these pools separate when resource use differs. In the illustration below, only one shared processing pool is allocated; all other selected costs have already been assigned directly.
Use retail banking revenue analysis for revenue questions. Combining revenue and cost is useful later, but it should not obscure the operating costs and counts being tested here.
An illustrative US retail bank compares three operating units for one month. Its direct expenses and completed routine transactions appear below, along with a budget for the same expense scope. Put these inputs in columns A through D, rows 2 through 4.
| Unit | Direct expense (USD) | Completed transactions | Cost budget (USD) |
|---|---|---|---|
| Central branch | 120,000 | 20,000 | 145,000 |
| West branch | 90,000 | 10,000 | 105,000 |
| Digital channel | 80,000 | 70,000 | 145,000 |
| Total | 290,000 | 100,000 | 395,000 |
The shared processing pool is $100,000, entered in K2. The example assumes the selected routine activities consume comparable shared processing support. A real report should use separate pools or activity categories when that assumption does not hold.
Add columns E through I for allocation share, allocated expense, total expense, cost per transaction and budget variance. Fill these row 2 formulas down through row 4:
E2 = C2/SUM($C$2:$C$4)
F2 = $K$2*E2
G2 = B2+F2
H2 = IF(C2=0,NA(),G2/C2)
I2 = G2-D2
Keep full precision in the formulas. Display transaction costs to two decimal places and dollar totals as whole numbers. A unit with no completed transactions keeps its expenses, but its cost per transaction is undefined.
| Unit | Activity share | Allocated expense (USD) | Total expense (USD) | Cost/transaction (USD) | Budget variance (USD) |
|---|---|---|---|---|---|
| Central | 20.0% | 20,000 | 140,000 | 7.00 | -5,000 |
| West | 10.0% | 10,000 | 100,000 | 10.00 | -5,000 |
| Digital | 70.0% | 70,000 | 150,000 | 2.14 | 5,000 |
| Total | 100.0% | 100,000 | 390,000 | 3.90 | -5,000 |
Central's calculation is $120,000 + $20,000 = $140,000, divided by 20,000 transactions = $7.00. Positive variance means expense above budget. Digital is above budget even though it has the lowest cost per transaction; those measures describe different things.
Allocated expenses must exhaust the shared pool. Total expense must equal direct expenses plus that pool, and completed counts must agree with the selected activity summary.
Allocation check = SUM(F2:F4)-K2
Expense check = SUM(G2:G4)-SUM(B2:B4)-K2
Blended cost per transaction = SUM(G2:G4)/SUM(C2:C4)
Both checks return zero. Expense is $290,000 + $100,000 = $390,000, and the blended transaction cost is $390,000 / 100,000 = $3.90. Never average the displayed unit costs; the blended figure uses the summed expenses and summed transactions.
Maintain a short bridge from the selected operating accounts to the broader ledger. Report expenses excluded from scope rather than treating this worksheet as the bank's complete cost base. Commercial banking cost analysis addresses a neighboring business context, while investment banking cost analysis uses deal work as its activity base.
West's higher unit cost is a reason to review staffing, operating hours and transaction mix. It is not sufficient evidence that its workforce is inefficient. Its service area or activity complexity may differ from Central's.
For a clean volume comparison, temporarily isolate Central's direct cost. The same $120,000 divided by 20,000 transactions is $6.00; divided by 18,000 transactions it is $6.67, rounded. No direct spending changed. The higher rate comes from lower throughput, before considering how shared allocation might also change.
Use retail banking analytics for related operating questions, then have finance and branch operations agree the explanation before changing resources.
Bring a sample of your own branch expense and transaction summaries: Covirage maps the columns, and its tools compute and check costs, allocations and variances. 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 your file.
See cost variance analysis for the supporting business use case.
No. Cost per transaction divides a defined operating cost pool by an activity count. An efficiency ratio compares expense with a revenue measure. They have different denominators and purposes, so a branch activity measure should not be labeled a bank efficiency ratio.
You can show a blended figure if both counts follow a documented definition, but retain separate channel results. A simple digital inquiry and a complex branch service require different work, so a low blended cost can reflect channel mix rather than operating improvement.
Start with directly attributable payroll, occupancy, supplies and service expenses. Add only the shared costs included in the report's stated scope, using an explicit allocation driver. Show excluded items and keep credit losses, funding costs and capital measures outside a narrowly defined operating cost view.