Blog · Board and management reporting · Financial services
Business intelligence in financial services connects business-unit results to management decisions. Compare revenue and operating costs against plan, reconcile the figures, and assign the next action.
Business intelligence in financial services helps managers compare business-unit revenue and operating costs against plan, then explain the gap. The useful output is a reconciled answer to a decision: which unit needs attention, what changed, and who will investigate it.
Ask a specific question: did additional revenue produce the operating contribution expected in the approved plan? Revenue growth alone cannot answer it. Expenses may have increased faster, or a different business mix may have changed the total.
Keep the reporting scope explicit. The SEC's guide to financial statements distinguishes income statements, which cover results over a period, from balance sheets, which describe assets and liabilities at a point in time. Customer balances or assets administered do not substitute for earned service revenue in this comparison.
Industry statistics answer another question. The FDIC Quarterly Banking Profile covers the aggregate condition of insured institutions, including earnings, lending, deposits, and asset quality. Such context does not replace a company's own approved business-unit plan. Use the broader business intelligence definition for the general reporting discipline; this page concentrates on the operating comparison.
For a fee-based business, establish the revenue accounts included, the operating expenses charged directly, and the shared expenses allocated to units. Apply identical definitions to actuals and plan.
Operating contribution = Service revenue − Operating costs
Contribution variance = Actual contribution − Planned contribution
Contribution variance = Revenue variance − Cost variance
A positive revenue variance is favorable. A positive cost variance means costs exceed plan and reduces contribution. Writing that sign convention beside the report prevents a favorable cost reduction from receiving the wrong label.
Operating contribution here is an internal management subtotal. It is not a claim about consolidated net income. Keep financing, taxes, and any other excluded items in a separate reconciliation. For banking or insurance businesses, finance must define the appropriate income and expense lines rather than borrowing this fee-business subtotal unchanged.
Use the same closed month, legal entities, currency, and business-unit structure in both files. An actuals export should identify period, entity, business unit, account, and amount. The budget export needs those same identifiers plus its approved version.
Map account codes to revenue or operating cost. Preserve the original codes so finance can inspect the mapping. If an organizational change moved a team between units, prepare a consistent comparison before interpreting its variance.
Summarize each file separately to the agreed reporting level before combining it. Matching detailed actual transactions to repeated budget rows can multiply amounts. Retain unassigned accounts in a visible exception group until their owner resolves them.
The broader reporting strategy establishes audiences and ownership across reports. Here, the practical requirement is that every unit's actual and plan numbers use the same boundaries.
The following fictional company earns service fees through payments, commercial services, and wealth administration. All figures are for the same closed month in USD. Operating costs include the agreed shared-cost allocation.
| Business unit | Plan revenue (USD) | Actual revenue (USD) | Plan operating costs (USD) | Actual operating costs (USD) |
|---|---|---|---|---|
| Payments | 1,200,000 | 1,260,000 | 840,000 | 900,000 |
| Commercial services | 800,000 | 740,000 | 520,000 | 550,000 |
| Wealth administration | 600,000 | 660,000 | 420,000 | 430,000 |
| Total | 2,600,000 | 2,660,000 | 1,780,000 | 1,880,000 |
Subtract operating costs from revenue for each unit, then compare actual contribution with plan:
| Business unit | Plan contribution (USD) | Actual contribution (USD) | Revenue variance (USD) | Cost variance (USD) | Contribution variance (USD) |
|---|---|---|---|---|---|
| Payments | 360,000 | 360,000 | 60,000 | 60,000 | 0 |
| Commercial services | 280,000 | 190,000 | -60,000 | 30,000 | -90,000 |
| Wealth administration | 180,000 | 230,000 | 60,000 | 10,000 | 50,000 |
| Total | 820,000 | 780,000 | 60,000 | 100,000 | -40,000 |
Commercial services explains the adverse result. Its revenue shortfall of $60,000 and cost overrun of $30,000 produce a $90,000 contribution shortfall. Wealth administration offsets $50,000; payments matches planned contribution despite higher revenue.
At company level, revenue is above plan by 60,000 / 2,600,000 = 2.3%, while costs exceed plan by 100,000 / 1,780,000 = 5.6%. Percentages are rounded to one decimal place. The dollar bridge provides the decisive answer: $60,000 of additional revenue minus $100,000 of additional cost leaves contribution $40,000 below plan.
First, match the actual revenue and operating-cost totals to the ledger control report for the included accounts. Match planned totals to the approved budget version. The example's contribution check is:
820,000 + 60,000 − 100,000 = 780,000
0 − 90,000 + 50,000 = −40,000
The first check reconciles actual contribution; the second reconciles its variance against plan. Allocations must also balance: amounts charged to units must match the shared-cost pool being allocated.
The controller confirms those ties. FP&A verifies the plan version and bridge. Commercial services' leader then investigates fee volume, timing, staffing, and purchased services. The table identifies where the gap sits; it does not prove the operational cause.
Use business intelligence charts to choose a suitable comparison view, and the neighboring financial services dashboard article when deciding what belongs in a recurring view. Software selection is covered separately in choosing analytics software for financial services.
Bring a sample of your own ledger and approved plan in a file; Covirage maps the columns, and its tools compute the unit comparisons and check the totals. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your export.
See Covirage for financial services for supporting context.
Finance and operating leaders use it to compare unit performance, locate revenue or cost gaps, and decide where investigation is needed. For management reporting, a useful starting point is actual revenue and operating expense against the same approved plan.
Include revenue, operating costs, operating contribution, and their variances against plan. State the account definitions and allocations. Add activity measures only when they help explain the result, and keep balance sheet measures distinct from income statement measures.
The controller owns the tie to the ledger, FP&A owns the approved plan and variance definitions, and business-unit leaders own explanations and actions. A report owner should resolve mapping or allocation changes before management compares units.
Revenue can exceed plan while operating contribution misses it. Check how much additional operating cost accompanied that revenue. Also examine timing, shared-cost allocations, and the scope of the contribution measure before treating the result as improved profitability.