How to Calculate Your Effective Processing Rate From a Statement

Start with the merchant statement or transaction export. Save the processor’s itemised fee report or invoice and the bank entries that show payouts and separate fee withdrawals. If your gateway invoices independently, pull that bill too. Choose one merchant account and one currency before trying to combine several stores. Note the report’s time zone and whether its dates refer to capture, settlement or payout.

Helcim’s monthly statement identifies gross sales, refunds and deducted processing fees separately, and shows effective rates by card brand. Its funding documentation also describes gross deposits with fees withdrawn as a separate bank entry, and net deposits with fees deducted before funding. A bank debit helps locate a charge; match it to the statement or invoice before adding it. Otherwise the same fee can be counted twice. [1][2]

If your calculation covers October captures, include the fees attached to those captures even when the money reaches the bank in November. Assign recurring charges to the month they cover where you can identify that month. For fees on later refunds or disputes, use a consistent convention, such as recording them when billed and disclosing that they may relate to earlier sales. If your only reliable records are settlement-based, calculate a settlement-period rate using fees and sales from the same settled population. Label it clearly.

Stripe’s balance summary covers movements in a selected period in settlement currency. Its payout reconciliation report can include transactions from before that period when they belong to payouts in it, and it shows gross, fee and net in the stated currency. That makes it useful for tracing a deposit. It can give the wrong sales population for a capture-month comparison if you take the payout dates as sales dates. [3][4]

Check currency before adding rows. Dividing USD settlement fees by EUR checkout sales does not produce a comparable percentage. Calculate separately where possible. If you consolidate, put both amounts in one reporting currency using a documented conversion basis, and record separately identifiable conversion fees once. If conversion cost is bundled into an exchange rate and you cannot isolate it, say so rather than estimating a fee from the payout gap.

Use a positive number for an expense and a negative number for a genuine fee credit. Start with charge-level fees. Then add the relevant costs that you want the broader measure to cover, such as the monthly gateway bill, batch charges and charges for processing refunds or disputes. Keep one-off equipment or setup charges visible separately so they do not distort your ongoing comparison. If a common bill covers cards and bank transfers, allocate it with a documented rule or report it separately.

Adyen’s Settlement details report illustrates why labels matter. It can show a total commission or its component fees, depending on the reporting detail supplied. Its invoice deductions can also contain costs such as terminals, and reserve adjustments appear as their own record type. Check whether a statement total already includes the components, and whether an invoice deduction is the collection of an amount you have already counted. [5]

The amount returned to a customer and the fee for making that refund belong on different lines. The same applies to the disputed sale amount and an administration fee. An original processing fee that the provider keeps remains part of the cost; include any actual fee credit once. Check your agreement and statement for the treatment that applies to your account.

Suppose one online store captured USD80,000 of card sales. For this example, the sales and fees shown post in one period and currency, with no unsettled sales carried into or out of the month and no taxes or FX charges. The store refunded USD6,000 and lost USD1,000 of dispute principal. The processor withheld USD8,000 as reserves and released USD2,000 from an earlier reserve balance. It also made a USD40 fee correction. A gateway supplier billed USD80 separately.

The provider’s payouts total USD64,720. The gateway debit takes the overall bank cash movement to USD64,640. The difference between that cash and gross sales is USD15,360; calling that gap a fee would produce a misleading 19.20%. The amount charged for accepting and administering payments under the chosen scope is USD2,360. The rest of the gap is refunded or disputed money and the net reserve movement. The reserve release increases cash this month without reducing what the processor charged.

Now suppose the same USD64,720 of provider payouts was sent, but USD3,200 of the last transfer did not reach the bank until the next month. In that case you would see only USD61,520 of provider deposits during this month. After the separate gateway debit, the bank shows USD61,440. Nothing in that timing change alters the USD2,360 fee total. Carry the USD3,200 as a transfer in transit in your reconciliation and verify the next bank credit. Do not add it to the reserve total: the provider has already sent it.

If a payout has not been sent at all, reconcile the provider balance first. Compare the opening available and pending amounts with sales, customer refunds, disputes, fees and reserve movements in the period. Separate amounts left in the provider balance from payments already sent to the bank. A reserve may have its own balance and release records, so avoid including it twice when the report already rolls it into the balance.

Where a provider debits an invoice separately, match the amount and the billing reference before deciding whether it is new. In the example, the gateway bill is a separate cost because the USD2,280 provider fee subtotal does not include it. If the provider had collected the very same USD80 through settlement, you would expect a smaller payout rather than a second expense. The bank check tells you where the money moved; the invoice tells you what it paid for.

For the example, transaction fees before the separate fee correction are USD2,240, or 2.80% of gross sales. The broader calculation adds refund and dispute administration charges and the gateway bill, then deducts the fee credit: USD2,360 ÷ USD80,000 = 2.95%. If your management team wants fee burden relative to sales retained after refunds, divide by USD74,000 instead and label the result “fees as a share of sales after refunds”: 3.19%. This second denominator subtracts refunds only; it does not silently net off disputes or reserves.

When a percentage changes, compare the currency, channels, card mix, transaction count and average order size first. A fixed fee takes a bigger share of a smaller purchase. A fee credit, annual bill or unusual dispute month can also move the broader rate even if every contractual charge stayed the same. If you are checking a price change, compare like-for-like batches and inspect the actual fee entries. A blended rate alone cannot tell you which line changed.