BusinessPlanHub

Free Transaction-Based Financial Model for Fintech and Payments

The Transaction-Based financial model is a free Excel download that calculates revenue as transaction volume times take rate. It runs 60 months and builds all three financial statements.

Download the free model Book a free consultation

Free · Excel (.xlsx) · Imports into Google Sheets

Download the Transaction-Based financial model

Pick this if you earn a cut of each transaction you process.

We use your email to send you the model and offer a free consultation. No spam.

How does a transaction-based model make money?

Revenue is total transaction volume multiplied by your take rate. Customers matter only because they create volume.

The file chains it like this: web traffic and conversion produce new customers. Add the returning customer rate and you get total customers. Multiply by average monthly transactions per customer for total transactions. Multiply by average transaction size for gross volume. Apply the take rate and you have revenue.

That is six assumptions before a single dollar of revenue appears. Each one needs a source.

What is the difference between gross volume and revenue?

Gross volume is the money moving through your system. Revenue is only your share.

If customers move a million in a month and you keep 1.5%, your revenue is 15,000, not a million. Founders sometimes report volume as if it were income. An investor will correct them in the first meeting.

Keep both figures visible in your plan, and label them. Volume shows scale. Revenue pays the bills.

Which inputs does the Assumptions tab ask for?

InputWhy it matters
Returning customer rateRetention drives volume more cheaply than acquisition
Average monthly transactions per customerUsage frequency, not sign-ups
Average transaction sizeLarge tickets and small tickets behave differently
Take rateYour fee as a share of each transaction
Ten acquisition channelsSwitch on only those you can run
People plan25 rows of roles and salaries
CostsCOGS, G&A, sales and marketing, professional fees

The file also takes starting cash, fixed assets, income tax rate and equity rounds. The file arrives full of placeholder numbers. Overwrite them all.

Why does take rate pressure matter?

Take rate can fall as customers get bigger. Large merchants and high-volume users negotiate. Competitors undercut. A model that holds the rate flat while volume grows is assuming away the most obvious risk.

The template has one take rate input. So test it by hand: run the model at your starting rate, then at a lower one, and compare gross profit. If the business only works at the higher rate, say so plainly.

Where do payment processing costs belong?

Put them in cost of goods sold. Card networks, banks and processors take a cut before you do, and that cut moves with volume.

This is where many fintech forecasts go wrong. They count the full fee as margin. In reality a large share of it may pass straight to a processor. Your gross profit should reflect what you keep.

Then check whether those costs rise in step with volume. If they do, scale will not widen your margin on its own.

What do lenders and investors ask first?

They ask where the volume comes from and whether the take rate holds.

Be ready to answer:

  • How many transactions does a typical customer make, and what is that based on?
  • Why would the average transaction size be that figure?
  • What happens to profit if the take rate drops?
  • When does cash run out before volume pays for the team?

What investors look for in a business plan explains how they read forecasts like this. Our own view: a modest volume assumption with evidence beats an ambitious one with none.

When should you use the marketplace model instead?

Use the marketplace model when you must attract two groups, such as buyers and sellers, and take a cut between them. It runs on the same take-rate engine, but the two-sided case has its own supply-and-demand questions.

Use this one when you charge a fee on transactions and your customer is on one side: a payment tool, a booking service, a broker.

How should you test volume growth?

Run three cases: slow, expected and fast. Change transactions per customer first, since usage is the assumption founders overstate most often.

Then check the people plan. A fast case needs support, compliance and engineering hires earlier. If cash cannot fund them, the fast case is not a good outcome, it is a funding gap.

What should you do next?

Fill in the Assumptions tab from real data where you have it, and written reasoning where you do not.

Then read the business plan financial projections guide to see how the statements fit into a plan.

If you would like someone to look over the numbers, book a free 30-minute consultation.

Transaction-Based financial model: common questions

What is the take rate in this model?

It is the share of each transaction's value that you keep as revenue. Revenue equals total transaction volume times the take rate.

Is this the right model for a two-sided marketplace?

Not usually. It suits single-sided businesses that charge a fee on transactions. A marketplace with buyers and sellers should use the marketplace model.

Where do payment processing costs go?

Put them in cost of goods sold, so gross profit shows what is left after you pay the processors.

Can I use it in Google Sheets?

Yes. Import the .xlsx into Google Sheets with File > Import, then check the formulas calculate.