Blog · Finance metrics and formulas · Financial services
Connect financial-services revenue, customer activity and operating costs in a business-line review. See a worked contribution example, the checks behind it and the decisions each owner makes.
Data analysis in the financial industry connects revenue, service costs and customer activity so business leaders can explain performance and choose an action. A useful review shows which business line generates contribution, what work consumes capacity and whether the figures agree with finance records. The starting point is the company's own exports and a clearly defined operating question.
For a fee-based business, the basic comparison is recognized revenue against the costs of delivering the service. Activity explains the workload behind those costs: active customers, completed requests, specialist hours or exceptions requiring manual attention. Revenue alone cannot show whether additional business is economical to serve.
Choose measures that fit the line. An advisory service may compare fees and staff hours by engagement. A merchant-support operation may compare service fees, account activity and support cases. An administration service may compare contract revenue with processing workload and corrections. Do not force unlike activities into one company productivity ratio.
These measures sit inside a broader financial analysis. They answer operating questions about the business rather than predicting securities returns.
Start the review with a question that someone can resolve. “Why did this line's contribution fall?” leads to a comparison of revenue, workload and cost. “What patterns are in the file?” leaves the team with observations that may have no decision attached.
Use the same reporting period, legal-entity scope and business-line definitions across the records. A customer ID identifies an account consistently even when its display name changes. The guide to exports by industry gives the wider file context; an operating review usually needs the following records.
| Business question | File and useful fields | Measure | Accountable owner |
|---|---|---|---|
| Which line contributes most? | Revenue ledger and expenses: period, line, account, amount | Revenue less mapped costs | Finance and line leader |
| Where is service workload rising? | Activity export: case ID, account ID, completion date, type | Completed cases and hours by type | Operations |
| Are customers using the service? | Account activity: account ID, period, qualifying event | Active customers under a stated definition | Commercial leader |
| Are common costs changing the result? | Allocation workbook: cost pool, driver, line, amount | Contribution before and after allocations | Finance |
Keep revenue rows and service events separate until each has been summarized to the intended comparison. Copying an account's entire monthly fee onto every service case multiplies revenue. Keep unmapped records visible and resolve them before treating the report as complete.
Consider an illustrative US financial-services company reviewing September 2026. It earns service fees through the three lines below. Revenue is recognized fees after credits. Direct service costs include the labor and vendor costs assigned to each line; shared allocations follow a documented finance policy.
| Business line | Revenue (USD) | Direct costs (USD) | Shared allocation (USD) | Contribution (USD) | Margin |
|---|---|---|---|---|---|
| Commercial advisory | 900,000 | 480,000 | 120,000 | 300,000 | 33.3% |
| Merchant support | 600,000 | 360,000 | 90,000 | 150,000 | 25.0% |
| Benefits administration | 300,000 | 210,000 | 60,000 | 30,000 | 10.0% |
| Total | 1,800,000 | 1,050,000 | 270,000 | 480,000 | 26.7% |
Operating contribution = Recognized fee revenue − Direct service costs − Shared allocation
Contribution margin = Operating contribution / Recognized fee revenue
All percentages are rounded to one decimal place after calculation. This contribution excludes financing, income taxes and any company expenses outside the defined cost pools; it is not net income.
If the table occupies A:F, with headers in row 1, contribution in E2 is =B2-C2-D2 and margin in F2 is =E2/B2. Fill both down through row 4. The total margin is =SUM(E2:E4)/SUM(B2:B4), which preserves each line's revenue weight.
The proof is $1,800,000 − $1,050,000 − $270,000 = $480,000. Finance must tie revenue and direct costs to the mapped ledger accounts and the $270,000 allocation to the shared cost pool. If expenses remain outside that pool, show them in the company reconciliation. The broader identity by industry explains why these ties matter.
The same company also records the activity below. “Active” means an account had a qualifying service event in the month, and each line counts distinct account IDs within its own records.
| Business line | Active customers | Completed cases | Revenue per active customer (USD) | Direct cost per completed case (USD) |
|---|---|---|---|---|
| Commercial advisory | 300 | 1,500 | 3,000 | 320 |
| Merchant support | 1,200 | 3,000 | 500 | 120 |
| Benefits administration | 500 | 1,000 | 600 | 210 |
Revenue per active customer divides each line's revenue by its active customers. Direct cost per case divides direct costs by completed cases. Neither ratio establishes causation: direct costs may also support work in progress, and case complexity differs across lines. Customers can use multiple lines, so adding these customer counts would not establish the company's distinct customer total.
The administration line's lower margin gives its leader a question: are contract terms, labor intensity or shared costs responsible? Operations should examine case types and rework before changing staffing. Finance should show the contribution before and after allocations so a cost-allocation change is not mistaken for a service improvement.
Give each issue an owner, an explanation to test and the next reporting period for follow-up. The merchant-support manager might investigate repeated exception cases. The advisory leader might review high-workload engagements before renewing terms. Risk and compliance owners should review any proposed change that affects the required service or control activity.
For lenders, adapt the revenue definition. The New York Fed describes bank operating revenue as net interest income plus noninterest income. A fee-business contribution table therefore cannot stand in for a bank earnings review; funding costs and credit-loss provisions need their own treatment.
Also distinguish recorded earnings from cash received. The SEC explains that income and cash flow are related but different. Follow up on collection timing separately instead of interpreting all recognized fees as cash available to spend.
Upload your revenue, cost and activity file or Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains business-line differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See Covirage for financial services for supporting industry context.
Start with recognized revenue, expense detail, customer or account records and service activity. Use matching periods and consistent business-line definitions. Lending businesses also need the applicable funding-cost and credit-loss records; fee-business contribution alone does not describe their full economics.
Match recognized revenue to directly attributable service costs and a documented share of common costs. State what the subtotal excludes. Compare customers within similar products and service arrangements, because a high revenue account can also require substantial specialist time or exception handling.
Finance owns account mappings, cost definitions and reconciliation. Operations owns activity definitions and service workload explanations. Business-line leaders own commercial decisions, while the relevant risk and compliance owners review changes that affect service obligations or controls. Each finding needs a named action owner.