Merchant Statement Analysis Software: Convert Credit Card Processing Statements to Excel and CSV

Turn merchant processing statements into a spreadsheet of fee lines with volumes, rates, and totals. Built for merchant services agents, payment consultants, controllers, and any business that suspects it is overpaying. Start free, no credit card.

Free to try, no credit card
256-bit encryption
Convert a year of statements at once

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Extract:

Merchant statement analysis, in short

A merchant processing statement is the monthly document your payment processor sends showing card volume, interchange, network assessments, processor markup, and every monthly or per item fee. It arrives as a PDF that can run twenty pages and carry hundreds of fee lines, which is why almost nobody checks it. Upload those statements here and each line comes back as a row with the description, card type, volume, rate, per item amount, and total charge, so you can total the fees, divide by card volume, and see the effective rate you are actually paying. Last updated July 2026.

Why Nobody Checks a Merchant Statement

The fees are all disclosed. They are just disclosed in a format designed to be filed rather than audited, and no two processors lay it out the same way.

The Statement Is a Long PDF

A single month can run past twenty pages once the interchange detail is included. A PDF cannot be sorted by fee type, totaled by category, or compared to last month without retyping the whole thing first.

Every Processor Uses a Different Layout

First Data, Worldpay, Global Payments, Square, Stripe, Elavon, and the thousands of ISOs that resell them all print a different structure. A template that reads one statement will not read the next.

Hundreds of Interchange Lines per Month

Interchange detail breaks volume down by card brand, product type, and qualification level, which produces dozens or hundreds of rows a month. That is the part with the money in it and the part nobody reads.

Tiered Pricing Hides the Markup

Tiered pricing buckets transactions into qualified, mid qualified, and non qualified rates so the processor markup is blended into a single number you cannot pull apart by eye.

Padded Line Items Look Official

Charges labeled network access fee, regulatory compliance fee, technology fee, or non qualified surcharge sit next to genuine pass through costs and read the same way on a printed page.

A Comparison Needs Months, Not One Month

A rate that drifted at a repricing only becomes obvious when you line twelve statements up beside each other, and that is a spreadsheet job.

What the Converter Gives a Statement Review

The processing statement flattened into the columns a fee analysis actually needs, from the documents you already hold.

One Row per Fee Line

Description, card brand, volume, transaction count, rate, per item amount, and total charge, each in its own column instead of running across a printed page.

Effective Rate in One Formula

Once total fees and total card volume are cells rather than paragraphs, the effective rate is a division. That single number is what makes two processors comparable.

Twelve Months in One Sheet

Convert a full year together and get one date ordered file, which is how a rate that moved mid year or a fee that appeared quietly becomes visible.

Works Across Processors

Statements from different processors convert into the same column layout, which is the precondition for comparing an incumbent against a proposal.

Excel or CSV Output

An .xlsx workbook to build the analysis in, or a CSV to load into your own model or proposal tool.

No Portal Login Required

Nothing connects to a processor account. You upload a statement you already have and download a spreadsheet.

Run a Merchant Statement Analysis in 3 Steps

The sequence agents and consultants use before quoting against an incumbent processor.

1

Convert the Statements

Upload the monthly processing statements for the period under review and get back one sheet of fee lines per processor.

Tip: Three months is the minimum, twelve is better.

2

Calculate the Effective Rate

Total every fee on the statement, divide by total card volume, and multiply by 100. That is the number to quote against, not the headline rate on the first page.

Tip: Include monthly and per item fees, not just the percentages.

3

Split Pass Through From Markup

Group the lines into interchange, network assessments, and processor markup. Interchange and assessments are fixed. Everything left is the part that is negotiable.

Tip: Markup is where a switch actually saves money.

Who Analyzes Merchant Statements

Anyone quoting against an incumbent processor, and anyone accountable for what card acceptance costs.

Merchant Services Agents and ISOs

Turn a prospect PDF into a comparison in minutes instead of keying it by hand, and show the effective rate side by side with your proposal.

Payments and Cost Reduction Consultants

Load a client history fast when the client can only produce PDFs, which is the normal starting position on a first engagement.

Controllers and CFOs

Understand what card acceptance costs as a percentage of revenue and whether the number has drifted since the contract was signed.

Restaurant, Retail, and Ecommerce Owners

Check a statement before renewing, especially where card volume is high and a fraction of a percent is real money.

Common Search Terms

merchant statement analysis merchant statement analysis tool merchant statement analysis software merchant services statement analysis credit card processing statement analysis merchant statement to excel

Transaction Types We Handle

Interchange by card brand and product
Network assessment fees
Processor discount rate and markup
Per authorization and per item fees
Monthly, statement, and PCI fees
Chargebacks and retrieval requests
Batch and settlement fees
Gateway and terminal charges

What is a merchant statement?

A merchant statement is the monthly account document a payment processor sends to a business that accepts cards. It reports total card volume and transaction counts for the period, then itemizes every cost applied against them: interchange owed to card issuing banks, assessments owed to the card networks, the processor markup, and any flat monthly or per item charges. It is the only document that shows what card acceptance actually cost, which makes it the basis for every processor negotiation and every switch.

How do I calculate my effective rate?

Add every fee on the statement, including monthly and per item charges, then divide by total card volume for the month and multiply by 100. If a business processed $180,000 and paid $4,500 in total fees, the effective rate is 2.5 percent. This single number is the only fair way to compare two processors, because a headline rate ignores the flat fees and a tiered quote hides the markup inside blended buckets.

What are the three parts of a processing fee?

Interchange, assessments, and markup. Interchange goes to the bank that issued the customer card, is set by Visa, Mastercard, Discover, and American Express, and is identical for every merchant at a given card and transaction type. Assessments go to the card networks and are also fixed. The markup is the processor share, and it is the only one of the three anybody can negotiate. Splitting a statement into those three buckets is the whole point of the analysis.

Fee componentWho receives itTypical rangeNegotiable
InterchangeThe card issuing bankRoughly 1.5 to 2.5 percent plus a per item amount, by card and transaction typeNo
Network assessmentsVisa, Mastercard, Discover, AmexAround 0.13 to 0.14 percent of volumeNo
Processor markupYour processor or ISOCommonly a fraction of a percent plus a per authorization feeYes
Monthly and service feesProcessor, gateway, or ISOStatement, PCI, gateway, terminal, and minimum feesUsually
Incident chargesProcessor and networksChargeback, retrieval, and returned item feesPartly

What is the difference between interchange plus and tiered pricing?

Interchange plus prints the true interchange cost and the processor markup as two separate figures, so you can see exactly what the processor is keeping. Tiered pricing sorts the same transactions into qualified, mid qualified, and non qualified buckets and quotes one rate per bucket, which blends the pass through cost and the markup into a number that cannot be taken apart from the statement alone. Flat rate pricing, the model Square and Stripe use, does the same blending at a single headline rate. None of them is automatically cheaper, but only interchange plus lets you audit the split, which is why a converted statement matters more under the other two.

What fees on a merchant statement are worth questioning?

Interchange and assessments are pass through and are not worth arguing about. The lines worth attention are the ones with vague names, because those are where markup is often relabeled: network access fee, regulatory compliance or PCI non compliance fee, technology or annual service fee, non qualified surcharge, and any monthly minimum. None of these are automatically improper. The point of putting them in a spreadsheet is that you can total them, express them as a share of volume, and ask what each one buys.

How many months should a statement analysis cover?

Three months is the working minimum and twelve is better. One month cannot show whether a rate changed at a repricing, cannot separate a seasonal volume spike from a genuine trend, and cannot reveal a fee that only bills quarterly or annually. An annual PCI fee or an equipment charge that appears once a year will be missed entirely by a single month review, which is exactly why processors are comfortable being quoted on one.

Where the numbers go next

A processing statement only tells you what the processor charged. What actually landed in the account is a separate question, because deposits arrive net of fees, refunds, and chargebacks, so gross sales never match the bank line. Converting the bank side too is what lets you tie the two together: the Square statement converter, the Stripe statement converter, and the Clover statement converter handle the payout side for those platforms, and the bank reconciliation workflow matches each payout to its deposit. If you are also reviewing what the bank itself charges, that is a separate document and a separate exercise covered by the bank fee analysis software page. Restaurants and retailers usually arrive here from the restaurant converter or the retail converter, and once the fee lines are coded you can push them into the ledger with a CSV to QBO converter.

Why Agents and Consultants Convert Statements Here

Any processor
one column layout across statement formats
Line level
interchange detail, not just the summary page
Minutes
instead of keying a prospect PDF by hand

Security & Privacy

  • No processor login or portal credentials requested
  • 256-bit encryption on every upload
  • Delete your uploaded files at any time
  • No reselling or sharing of your financial data

Merchant Statement Analysis: Common Questions

A merchant statement is the monthly document a payment processor sends a business that accepts cards. It shows total card volume and transaction counts, then itemizes interchange, network assessments, the processor markup, and every flat monthly or per item fee applied during the period.

Start at the summary for total card volume and total fees, then work into the fee detail. Add every charge, divide by volume, and multiply by 100 to get the effective rate. Then sort the lines into interchange, assessments, and markup, because only the markup is negotiable.

It depends on card mix, average ticket, and whether transactions are swiped or keyed, so there is no universal number. What is reliable is the comparison: calculate the same effective rate on your current statement and on any proposal, over the same months, and compare those two figures rather than headline rates.

Yes. Upload the PDF statement and each fee line comes back as a row with description, card brand, volume, rate, per item amount, and total charge. Download it as an .xlsx workbook or a CSV and build the analysis from there.

The converter reads the statement document rather than connecting to a processor account, so it is not tied to a specific provider. Statements from the large acquirers, from ISOs that resell them, and from flat rate platforms all convert into the same column layout.

No. Interchange is set by the card networks and paid to the bank that issued the customer card, and it is the same for every merchant at a given card and transaction type. Assessments are fixed too. Only the processor markup and the flat service fees can move.

Yes, once both statements are converted into the same columns. Compare effective rates over the same months, then compare the markup lines specifically. Comparing headline rates across different pricing models is the mistake the analysis exists to prevent.

It gives you the numbers to judge that, not a verdict. The converter turns the statement into rows so you can calculate the effective rate, isolate the markup, and total the flat fees. Whether those figures are reasonable is a judgment about your card mix and your contract.

Related Resources

Other Bank Statement Converters

ICICI Bank JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Capital One TD Bank Charles Schwab Fidelity Vanguard E*TRADE TD Ameritrade Bank of New York Mellon State Street BMO USA Ally Financial Regions Fifth Third Bank Huntington KeyBank Citizens Financial Group First Citizens Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bank East West Bank First National of Nebraska Frost Bank BOK Financial Fulton Financial Associated Banc-Corp Valley National Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Bank Webster Bank Cadence Bank Old National First Interstate BancSystem Umpqua Bank First Hawaiian Bank Prosperity Bank SouthState First Merchants First Bank Holding Glacier Bank First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Pacific Premier Bancorp Bank OZK United Community Banks Customers Bank Texas Capital SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial Flagstar Bank Synovus Bank Santander Bank Commonwealth Bank (CommBank) ANZ Bank Westpac NAB ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA

From the same family of tools