Blog · Territory, capacity and quota planning · Financial services
Build a fintech operating plan from transaction counts, fee rates, processing charges and losses. Compare plan with actual results, then reconcile operating profit to company cash.
A fintech financial model connects transaction activity to fee revenue, operating costs and company cash in a monthly planning workbook. Build it from product exports and finance records, then compare actual results with the assumptions your team supplied. For a fee-earning payments business, customer payment volume is an activity driver; it is not automatically company revenue.
Consider a fictional US payments company preparing its September operating review. It earns a percentage fee, pays a processor per completed transaction, and bears specified transaction losses. This example covers that operating business; lending portfolios and regulatory capital require separate schedules and specialist review.
Export one row per completed transaction with date, product, currency, customer payment amount and company fee. Match processor statements by transaction identifier. Keep refunds, reversals and chargebacks identifiable rather than deleting their history. Use a consistent definition of completed activity in both budget and actuals.
Add monthly expense accounts, loss records and corporate bank movements. Separate money held or transferred for customers from money owned by the company. The Federal Reserve's payment-system description explains transfers between sender and receiver accounts through clearing and settlement; your workbook needs the actual payout schedule and ownership of each balance.
Retain product rows before consolidating. The approach in asking questions of a sales workbook also applies here: keep source labels and reporting periods intact so a total can be explained without losing its supporting rows.
Put row labels in column A, plan in B, actual in C and a supplied scenario in D. These are illustrative assumptions, not industry benchmarks. Money is USD; rates are shown as percentages, with dollar results rounded to whole dollars.
| Row and measure | Plan B (USD unless stated) | Actual C (USD unless stated) | Scenario D (USD unless stated) |
|---|---|---|---|
| 2: Completed transactions, count | 200,000 | 220,000 | 220,000 |
| 3: Average payment amount | 50.00 | 50.00 | 50.00 |
| 4: Company fee rate | 2.00% | 1.90% | 2.00% |
| 5: Processing cost per transaction | 0.25 | 0.27 | 0.27 |
| 6: Loss rate on payment volume | 0.10% | 0.12% | 0.12% |
| 7: Operating expenses | 90,000 | 95,000 | 95,000 |
| 8: Payment volume | 10,000,000 | 11,000,000 | 11,000,000 |
| 9: Company fee revenue | 200,000 | 209,000 | 220,000 |
| 10: Processing costs | 50,000 | 59,400 | 59,400 |
| 11: Transaction losses | 10,000 | 13,200 | 13,200 |
| 12: Contribution after processing and losses | 140,000 | 136,400 | 147,400 |
| 13: Operating profit | 50,000 | 41,400 | 52,400 |
Enter the following Excel formulas in B8 through B13, respectively, then copy them across to D:
=B2*B3
=B8*B4
=B2*B5
=B8*B6
=B9-SUM(B10:B11)
=B12-B7
Microsoft documents SUM as adding values, references or ranges. Covirage is not affiliated with Microsoft.
For actuals, derive average payment amount from total payment value divided by completed transaction count. Derive the effective company fee rate from booked fee revenue divided by payment volume. If contractual rates vary, a simple average of those rates will not reproduce revenue.
This schedule supports an operating review across products and months. It does not replace the detailed cost allocation needed for individual transaction profitability. Broader ownership of the planning process belongs with FP&A.
Actual operating profit is $8,600 below plan even though transaction activity increased. A sequential bridge makes the reasons explicit. Apply the volume change at planned economics first; then apply actual rates and expenses to actual volume.
| Step | Calculation | Profit movement (USD) |
|---|---|---|
| Additional transactions | (220,000 - 200,000) × (50 × 2.00% - 0.25 - 50 × 0.10%) | 14,000 |
| Lower company fee rate | 11,000,000 × (1.90% - 2.00%) | -11,000 |
| Higher processing charge | -220,000 × (0.27 - 0.25) | -4,400 |
| Higher loss rate | -11,000,000 × (0.12% - 0.10%) | -2,200 |
| Higher operating expenses | -(95,000 - 90,000) | -5,000 |
| Total movement | Sum of movements | -8,600 |
The proof is $50,000 + $14,000 - $11,000 - $4,400 - $2,200 - $5,000 = $41,400. State the bridge order because interacting drivers can be allocated differently with another order.
Scenario D changes only the fee rate to 2.00%. The $11,000 revenue increase produces an equal profit increase because all other operating assumptions stay fixed. Commercial staff must validate whether the rate is achievable before finance includes it in an approved plan. A startup financial model addresses the wider funding context.
Assume opening fee receivables and operating payables are zero. There is no depreciation, capital spending, tax, financing or other cash movement in this simplified period. Collections and payments below are supplied bank assumptions, with customer funds excluded.
| Cash schedule | Plan (USD) | Actual (USD) | Scenario (USD) |
|---|---|---|---|
| Opening company cash | 400,000 | 400,000 | 400,000 |
| Company fee collections | 180,000 | 190,000 | 190,000 |
| Company operating payments | 145,000 | 155,000 | 155,000 |
| Closing fee receivables | 20,000 | 19,000 | 30,000 |
| Closing operating payables | 5,000 | 12,600 | 12,600 |
| Closing company cash | 435,000 | 435,000 | 435,000 |
Actual costs are $59,400 + $13,200 + $95,000 = $167,600. Payments of $155,000 leave $12,600 unpaid. Actual profit of $41,400 less $19,000 of uncollected fees plus $12,600 of unpaid costs equals the $35,000 cash increase. The higher scenario fee remains uncollected, so closing cash stays unchanged.
Bring your supplied planning workbook, transaction export and company settlement records to Covirage. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for financial services for the industry context.
No. For a fee-earning payment intermediary, payment volume measures funds processed for customers, while fee revenue measures the company's earnings from that activity. Your controller should confirm the appropriate gross or net revenue presentation for the specific contracts.
Use transaction activity, fee invoices or settlement statements, processor charges, loss records, payroll and other operating expenses, and company bank activity. Give every file the same reporting period and retain product identifiers so totals can be traced.
Yes. More activity can come with lower fee rates, higher processing charges, larger losses or additional operating expenses. Compare each driver separately before assuming that a transaction-count increase should create an equivalent increase in profit.