Short answer
A spreadsheet is flexible and free to start, but it relies on you to build and check every formula and to make a quote look professional. A web calculator built for merchant statements has the structure, checks and quote output ready. Choose a spreadsheet for one-off or unusual cases and a purpose-built calculator when you analyse many statements and send quotes.
Part of How payments work. Start with the main guide: How a card payment works: authorisation, clearing and settlement
Key takeaways
- Spreadsheets are flexible and familiar, but accuracy depends entirely on how well your formulas are built and checked.
- A purpose-built calculator brings structure, built-in checks such as the bill check and a ready quote output.
- The trade-off is flexibility against speed and consistency.
- Whichever you use, test it against statements you have worked out by hand.
- Many consultants start in a spreadsheet and move to a dedicated tool as volume grows.
Most payment consultants begin with a spreadsheet. It is the obvious tool: it is on every computer, it does arithmetic and you can shape it to fit. Plenty of good analysis has been done in a sheet. But a spreadsheet is also a blank page, and a blank page asks you to design the method, the checks and the output before you can analyse your first statement.
This guide compares spreadsheets and web calculators honestly. We build a web calculator, so we have a view, and we say where it applies. We also say where a spreadsheet is the better choice, because for some jobs it is.
What do you need from a tool?
Whatever you use, the job is the same. A good statement analysis tool should:
- Capture the statement figures accurately and in a consistent structure.
- Calculate the effective rate and every cost correctly.
- Check itself: flag a bill that does not match, a missing figure or an impossible total.
- Compare the merchant's cost with your offer, line by line.
- Produce something you can send, a quote the merchant can read and keep.
- Be repeatable, so the tenth analysis uses the same method as the first.
Judge any tool against those six, including a spreadsheet you built yourself.
What are the strengths and weaknesses of spreadsheets?
Where a spreadsheet is strong
- Flexibility. You can add any column, model any odd pricing structure and change the layout in a minute.
- Familiarity. Most people already know the basics.
- Low cost to start. You may already have the software.
- Control. You can see and change every formula.
- Good for one-offs. An unusual statement that does not fit a standard form may be easiest in a sheet.
Where a spreadsheet struggles
- Accuracy depends on you. A single wrong cell reference, a formula that does not copy down or a hidden row can change the result without a warning.
- No built-in checks. Unless you build them, nothing flags a bill that does not match the statement.
- Version drift. Copies of the sheet multiply and get out of step. A fix in one is not in the others.
- Presentation takes time. A sheet is not a quote. Turning it into a clear PDF means extra work each time.
- Hard to hand over. A colleague has to learn your layout.
- Mobile and sharing. Sheets are awkward on a phone, and sending one exposes your formulas and workings.
What are the strengths and weaknesses of web calculators?
Where a purpose-built calculator is strong
- Structure built in. The fields match a statement: card types, per-transaction fees, monthly fees, terminals and extras.
- Checks built in. A bill check, required fields and tools for missing figures catch errors early.
- Consistent method. Everyone using it follows the same steps.
- Quote output. The comparison turns into a clean document with your details.
- Fast. Entering figures into a form is quicker than building and checking a sheet.
- Works anywhere, including on a phone at the counter.
Where it is weaker
- Less flexible. If a statement has a structure the tool does not support, you have to adapt.
- You depend on the tool's design. Its assumptions are built in, so you need to understand them.
- Data handling. Check where your entries are stored. Our calculator saves them on your own device. Other tools may store them on a server.
- Cost, in some cases. Some tools are paid. Ours is free for now.
A side-by-side
| Question | Spreadsheet | Purpose-built web calculator |
|---|---|---|
| Time to start | Hours to build a good one | Minutes |
| Accuracy | As good as your formulas and checking | Built-in logic, tested |
| Built-in checks | Only what you add | Bill check, required fields, missing-figure tools |
| Unusual structures | Easy to adapt | May need a workaround |
| Quote output | Manual formatting | Ready-made |
| Consistency across a team | Needs discipline | Built in |
| On a phone | Awkward | Designed for it |
| Cost | Software you may already own | Varies. Ours is free for now |
| Learning curve | You learn your own sheet | You learn the tool |
Where do errors come from?
The most important difference is not speed. It is how mistakes are caught.
- Entering the figuresA typo or a misread digit. A tool with required fields and sense checks catches some.
- Calculating the totalsA wrong formula or a missed row. Tested logic avoids it. A sheet relies on you.
- Comparing the offersAn omitted fee on one side. A fixed layout with both sides shown helps.
- Checking the billA gap with the amount actually charged. A built-in bill check flags it.
- Presenting the quoteAn inconsistent figure copied across. One source of truth avoids it.
The earlier a check, the cheaper the fix.
None of this means spreadsheets cannot be accurate. It means accuracy in a spreadsheet is something you build and keep up, while in a dedicated tool much of it is already there.
How do you test any tool?
Whatever you choose, test it before you trust it.
- Take three statements you have already analysed by hand, with different pricing models.
- Enter them and compare the effective rate, every fee and the total.
- Test an awkward case: a statement with a missing rate, a minimum charge or a separate terminal invoice.
- Test a quiet month to see how fixed fees behave.
- Check the quote output for anything that looks off.
- Ask how it handles rounding, tax and gross versus net turnover.
The calculator on this site has 26 built-in tests with hand-checked results, which you can see by adding #tests to its address. That is the standard to hold any tool to, including your own spreadsheet. See merchant statement analysis in five minutes for the method it supports.
How do you move from a spreadsheet to a tool?
If you have a working sheet and want to move, do it carefully.
- Keep the sheet while you test the tool on live work.
- Run both on the same statements for a few weeks and compare.
- Note the differences and understand each one. Either the sheet or the tool has a mistake.
- Move your templates and habits, such as the record you keep for each merchant.
- Retire the sheet only when you are confident.
You may find the sheet remains useful for unusual cases, and that is fine.
- How many statements a month?A handful of unusual ones points to a sheet. Many routine ones points to a tool.
- Do you send quotes?A ready quote output saves time every time.
- Do you need built-in checks?A bill check and required fields catch errors a sheet will not.
- Do you work in a team or on the move?A shared, phone-friendly tool helps.
- Test before you trustRun statements you have already worked out by hand.
A short path through the decision.
For the underlying method, see how to read a merchant statement and effective rate explained.
Which should you choose?
Use a spreadsheet if:
- You analyse a few statements a month and each is different
- You need to model structures a standard tool does not cover
- You are happy to build and check your own formulas
- You do not send formal quotes
Use a purpose-built calculator if:
- You analyse many statements and want consistency
- You send quotes and want them professional and quick
- You want built-in checks such as the bill check
- You work on the move or with a team
Many consultants use both: a tool for the routine cases and a sheet for the oddities.
What our calculator does
The checkmyrates calculator is built around the six needs above. It has a section for each card type, extra fees and equipment. It has tools to work out a missing rate, turnover or fee. A required bill-check field flags a gap between the statement and the amount charged. It compares your offer line by line, shows savings over one to ten years and produces a three-page quote PDF with your details. It works in 11 currencies, and your entries are saved on your own device. You can see the output on the sample quote page. It does not yet read PDFs, as explained in can AI read your merchant statement.
Frequently asked questions
Can I use Excel to analyse merchant statements?
Yes. A well-built spreadsheet can do it. The risks are formula errors, missing checks and the time it takes to turn the result into a clear quote.
What is the best merchant statement calculator?
It depends on how you work. Judge any calculator on whether it captures the statement accurately, calculates correctly, checks itself, compares offers and produces a quote you can send.
Is a web calculator more accurate than a spreadsheet?
Not automatically. A tested calculator has its logic built in and checked, while a spreadsheet is only as accurate as its formulas. Either can be wrong, so test against statements you have done by hand.
How do I test a calculator?
Run statements you have already analysed by hand, including awkward ones, and compare every figure. Also check how it treats rounding, tax and gross versus net turnover.
Where does the checkmyrates calculator store my data?
Entries are saved in your own browser, on your own device. They are not sent to us.
Should I move my team to a dedicated tool?
If you analyse many statements and send quotes, a dedicated tool improves consistency and speed. Test it alongside your sheet first.
Sources and further reading
Figures in this guide are examples to show the method. Fees, rules and rates change, so check your own statement, contract and current rules before you decide. This is general information, not financial or legal advice.