Ecommerce Payment Reconciliation: Match Payouts to Orders
Industry Payment Guides

Reconciling Processor Payouts to Your Online Store's Orders

Ecommerce payment reconciliation, step by step: trace each processor payout to its orders, fees, refunds and holds so your books close every month.

Cheese shop with wooden shelves of cheese wheels, large cut wedges on the counter and handwritten chalkboard price tags

Photo: Pixabay

On this page 6 sections
  1. Why Your Bank Deposit Doesn't Match Your Sales Report
  2. Reading a Payout Report Line by Line
  3. Match Stripe Payouts to Orders Across Every Gateway
  4. Ecommerce Bookkeeping for Payouts: Where Each Line Goes
  5. Accounting Integrations That Automate Matching
  6. A Monthly Ecommerce Payment Reconciliation Checklist

Key takeaways

  • Match each deposit to the processor's payout report, not your store's sales report. The payout is a net figure for one settlement window.
  • Give every payment source its own clearing account. At month-end, each balance should equal money still in transit and nothing else.
  • Book a reserve as money owed to you (a receivable), never as an expense.
  • Busy stores get cleaner books by posting one summary entry per payout instead of syncing every order.

Your deposit doesn't match your sales because a processor payout is a net number. It starts with the gross card sales captured in one settlement window. Then it subtracts fees, refunds, chargebacks and reserve holds, and adds back any reserve the processor releases. Ecommerce payment reconciliation means taking that net figure apart until every dollar ties to an order or a specific deduction. Work from the processor's payout report and keep a clearing account for each payment source. Then the books close each month without a plug line labeled "miscellaneous adjustment."

Why Your Bank Deposit Doesn't Match Your Sales Report

Your store's sales report and your processor's payout measure different things on different clocks. Four gaps explain nearly every mismatch.

Timing. The store dates a sale when the customer checks out. The processor dates it when the payment is captured and settled. If you authorize at checkout and capture at shipment, a Friday order lands in a payout the following week. Each processor also closes its business day at a fixed cutoff in its own time zone. A late-evening sale after that cutoff belongs to the next day's batch, whatever your store's report says.

Scope. Store sales totals include orders paid through PayPal, buy now, pay later providers, gift cards and store credit. None of that money arrives in your card processor's deposit. Gift card redemptions are the classic trap. The sale is real, but the cash arrived months earlier, when the card was sold.

Math. Your sales report shows what customers paid, with shipping and sales tax included. The payout takes out deductions before any money moves. A refund issued today comes out of today's payout even when the original sale was deposited last month.

Batching. One deposit covers several days whenever a weekend or bank holiday falls inside the window. That's why matching one day of orders to one deposit breaks down on Mondays.

So stop comparing the deposit to the sales report. Compare the deposit to the payout report, then tie each line of that report back to orders.

Reading a Payout Report Line by Line

Stripe and Shopify Payments both let you open a single payout, see the transactions inside it and export that detail. Report names and layouts change, so use your processor's current help pages to find the right export. The structure is the same everywhere:

  • Gross charges: each captured payment, tagged with an order or invoice ID you can match to the store.
  • Fees: per-transaction processing fees, plus account-level charges such as gateway or dispute fees drawn from the balance.
  • Refunds: money returned to customers. Your processor's terms decide whether the original fee comes back. Our piece on whether you get processing fees back on online refunds explains the common arrangements.
  • Disputes: the chargeback amount and its dispute fee. If you win, a reversal appears in a later payout.
  • Adjustments: reserve movements and currency conversion, along with any manual corrections.

Traditional merchant accounts handle fees in one of two ways, and you need to know which one yours uses. Net settlement deducts fees from each deposit. Gross settlement deposits full sales every day and takes the whole month's fees in one debit early the next month. Under gross settlement, daily deposits track sales closely, and the reconciliation work shifts to that single monthly debit. Ask your provider which method applies before you build a process around it.

A Worked Example: Tracing One Payout to the Penny

Every number below is illustrative. None comes from a real store, and none reflects any processor's pricing. Your contract sets your real fees and reserve terms. Here are the assumptions:

AssumptionIllustrative value
Settlement windowThree days of card sales
Orders captured142 orders totaling $12,480.00
Processing fees for the window$404.52
Refunds issued (two orders)$186.00, original fees not returned
Chargeback debited$94.00, plus a $15.00 dispute fee
Reserve withheld from this payout$624.00
Reserve released from an earlier period$580.00

The payout then works out like this:

LineAmount
Gross card sales$12,480.00
Processing fees−$404.52
Refunds−$186.00
Chargeback−$94.00
Dispute fee−$15.00
Reserve withheld−$624.00
Reserve released+$580.00
Net deposit$11,736.48

The owner's sales report for the same three days shows a larger total, because it includes PayPal orders and gift card redemptions. That gap is expected. Those amounts reconcile against their own sources. The real test has two parts. Does the bank deposit tie exactly to the payout report? Does the gross figure tie to the order IDs in the store? When both answers are yes, this payout is reconciled.

Match Stripe Payouts to Orders Across Every Gateway

Few stores collect money from a single source. A card processor sits alongside PayPal, and a marketplace or a BNPL provider adds more payouts on top. Give each source its own clearing account in your books. A clearing account is a temporary holding account. Sales go in when they happen, and payouts come out when they reach the bank. Whatever remains at month-end should be money in transit and nothing else.

To match Stripe payouts to orders, the order number has to be written to each charge's description or metadata. Platform integrations commonly do this for you. Open one charge in the dashboard to confirm yours does. Then join the payout export to your order export on that ID in a spreadsheet. For Shopify payouts reconciliation, the payout transaction list already references order numbers. The real work is separating Shopify Payments orders from orders paid other ways.

Watch for fees that never touch a payout. Some platforms charge their own transaction fee when a store uses an outside gateway, and they bill it with the subscription instead of deducting it from payouts. Subscription and app charges belong in expenses. Keep them out of the clearing account.

Marketplaces need their own treatment. Amazon and Etsy pay on their own schedules and take their selling fees before you see a dollar. They also hold balances when their risk systems call for it. If a disbursement shrank without warning, our explainer on the Amazon account level reserve covers the usual causes. Tax is the other trap. In states that require marketplaces to collect and remit sales tax, that tax shows on the marketplace report but never reaches you. Keep it out of your sales tax liability account, and confirm the treatment for your states with a tax professional.

Foreign currency adds one more line. If you sell abroad, the payout reflects conversion at the processor's exchange rate, with cross-border fees on top. Our guide to cross-border card fees for international customers explains where those charges come from.

Ecommerce Bookkeeping for Payouts: Where Each Line Goes

The most common shortcut is recording the net deposit as revenue. That understates sales and buries fees, so your margins stop making sense. What follows is general information about common practice. Have your accountant confirm how it fits your books and tax filings.

Using the illustrative payout above, one summary entry looks like this:

AccountDebitCredit
Bank$11,736.48
Merchant fees expense$404.52
Sales returns and refunds$186.00
Chargeback losses$94.00
Dispute fees expense$15.00
Processor reserve receivable$624.00
Processor reserve receivable$580.00
Processor clearing$12,480.00
Totals$13,060.00$13,060.00

Four rules keep this entry honest.

Fees are an expense, booked gross. A separate fee account lets you track your effective rate month to month. Bring that number to any pricing review. Our breakdown of what online stores should pay in processing fees gives you a benchmark to compare it against.

Reserves are your money, held. A reserve is not a cost. Book it as a receivable, which is an asset, and reduce it as releases arrive. If the receivable keeps growing while your volume stays flat, ask your processor why.

Chargebacks have a lifecycle. Record the debit when the processor takes it. A win comes back as a credit in a later payout, and you book it against the same account. Keep a separate open-dispute list so that a March win doesn't show up as unexplained income in May. For the evidence that wins these cases, see our guide to 'item not received' chargebacks.

Sales tax stays a liability. Split collected tax out of revenue when you record sales into the clearing account. Doing it at payout time is too late.

Accounting Integrations That Automate Matching

Integrations save hours. What you choose to sync matters more than which tool you pick, and the choice comes down to two approaches.

Order-level sync pushes every order and refund into your accounting software as its own transaction, with fees attached. It suits low-volume stores. Once a store reaches a few hundred orders a month, it floods the ledger. Edited and partially refunded orders also start producing duplicate entries.

Payout-level summaries post one entry per payout, like the table above. The order detail stays in the store and processor, where it already lives. This is the better default for a store of any real size. Every bank deposit gets exactly one matching entry, and an auditor can still drill down through the payout report.

Before you trust any integration, run it against a month you've already reconciled by hand. Confirm that refunds land in the right period. Then check that fees aren't counted twice, once by the integration and again from the monthly statement.

The processing setup decides how clean that data is in the first place, because a gateway that passes order IDs through reliably makes every later step easier. MannyPay offers payment gateways including Authorize.net and NMI, along with store integrations for platforms such as Shopify and WooCommerce. For the books, it supports a QuickBooks integration. If you're deciding whether to run a dedicated merchant account behind your store, our comparison of a payment gateway vs. a merchant account explains how the pieces connect.

A Monthly Ecommerce Payment Reconciliation Checklist

Run this in the first week of each month for the month just closed.

  1. Export every payout dated in the month from each source: the card processor, PayPal, each marketplace and each BNPL provider.
  2. Tie each payout's net total to a bank deposit. Investigate any deposit without a payout, or any payout that never arrived.
  3. Post one summary entry per payout to that source's clearing account. Split out gross, fees, refunds, disputes and reserve movements.
  4. Export the month's store orders by payment method. Confirm that each source's gross matches the orders paid through it.
  5. Review each clearing account balance. It should equal late-month sales that hadn't paid out yet. List those payouts and confirm they land in the first days of the new month.
  6. Reconcile the reserve receivable to the reserve balance your processor reports.
  7. Update your open-dispute list with new chargebacks and resolved ones.
  8. If your account takes fees in a single monthly debit, match that debit to the processor's statement line by line.
  9. Calculate your effective rate (total fees divided by gross card sales) and compare it with prior months.

Once the clearing accounts close cleanly for a full quarter, the same data can feed a 13-week cash flow forecast, because you'll know how long sales take to become cash. If step 9 shows your effective rate creeping up and you can't trace the cause, send a recent statement with a free quote request. A MannyPay specialist responds within one business day.

About the author

Isabella Cruz

Isabella Cruz is Business Growth & Commerce Editor for Beyond the Swipe, writing for small businesses, restaurants, retailers, entertainment venues and e-commerce sellers.

This article is for general educational purposes and is not legal, tax or financial advice. Card network rules and state laws change; confirm current requirements for your business.

Related reading