Payment Reconciliation: Match Payouts to Orders, Fees, and Refunds
Your sales report shows gross revenue. Your bank receives a smaller net payout. Payment reconciliation explains every difference by rebuilding the payout from its settlement report.
The bank deposit matches the net payout. The settlement lines explain the difference from gross sales.
Your store reports $300 in sales, but the payment processor deposits $251.30. If you compare those two numbers directly, the payout looks short. The missing amount may include a refund and processing fees, all grouped into one settlement.
Payment reconciliation traces the deposit back through that settlement. You match the bank deposit to one payout, rebuild the payout from its transaction lines, and connect those lines to the source orders. Each difference gets a name instead of becoming a month-end mystery.
Why a bank deposit does not match gross sales
Sales dashboards and bank accounts answer different questions. The store dashboard records customer activity. The bank shows net cash transferred by a processor. Between those records, the processor can deduct refunds, fees, disputes, reserves, and other adjustments.
Timing creates another gap. An order placed late Friday may settle on Monday. A refund issued today may reduce a payout that also includes older orders. Marketplaces and payment processors choose which transactions belong to each settlement period, so a calendar-day sales total rarely equals one deposit.
Trying to match gross sales straight to the bank hides those mechanics. It also encourages weak fixes, such as searching for a combination of orders that happens to equal the deposit. Start with the report that defines the payout.
Start with the settlement report
A settlement report, also called a payout or disbursement report, lists the activity included in one transfer. It normally includes captured payments, refunds, fees, disputes, reserves, adjustments, and the final payout amount. Pipe17 gives the same breakdown in its overview of ecommerce settlement reconciliation (settlement report guide).
The payout ID is the anchor. Match that payout to the bank by amount, currency, and transfer reference. Dates may sit a day or two apart because the processor can initiate the transfer before the bank posts it. Amazon Pay also tells merchants to match the settlement transfer amount to the bank and notes that report and bank dates may differ (Amazon Pay reconciliation procedure).
Once the deposit and payout match, explain the payout from the inside. Add the positive transaction lines and subtract the negative lines. Keep each category separate so your accounting system can record sales, refunds, and fees in the right places.
A worked payout example
Consider a hypothetical skincare store with four captured orders in one settlement: $120, $80, $60, and $40. Captured payments total $300. Before the processor closes the settlement, the customer on the $40 order receives a full refund. The processor also charges $8.70 in payment fees.
The payout calculation is $300 in captured payments, minus the $40 refund, minus $8.70 in fees. The processor sends $251.30 to the bank. The deposit is correct even though it does not match the store's $300 gross-sales figure.
Next, match each captured payment to its order using transaction and order IDs. Match the refund to the original payment. Record the fees from the settlement report. If the $60 payment has no order reference, leave the rest of the payout reconciled and send that one line to an exception queue. A missing link should not block every clean transaction in the settlement.
Build the reconciliation from payout to order
Follow the money in the same order the processor moved it. Match the deposit first, explain the settlement second, then connect each line to its source record.
Work the exceptions instead of rechecking everything
A useful reconciliation process separates matched lines from unresolved ones. Common exceptions include a payout with no bank deposit, a transaction with no order reference, a refund amount that differs from the source order, or a fee category the accounting map does not recognize.
Give every exception a reason, owner, and next action. The finance owner may investigate a missing deposit. The ecommerce operator may trace a manual order. A developer may repair an integration that dropped transaction IDs. Keep the source payout and transaction references attached to the case.
Track how long exceptions remain open and which reason repeats. If manual refunds often lose the original transaction link, fix that workflow. If one marketplace fee lands in the wrong account every week, update the mapping. Reconciliation then improves the systems creating the differences instead of becoming a monthly hunt through spreadsheets.
Where ShopDucky fits
ShopDucky can read order, payment, payout, and accounting records across an ecommerce stack, match clean transactions, and route unresolved differences to the right operator. Teams can keep journal entries and other financial actions behind human approval while the AI employee prepares the evidence and reconciliation work. The Reporting OSshows how recurring source-based reports run, while theecommerce operations page shows how unresolved items become assigned actions.
Payment reconciliation, answered
What is payment reconciliation in ecommerce?+
Payment reconciliation matches customer payments, refunds, fees, disputes, and other settlement adjustments to the net payouts deposited in the bank. It creates a traceable link from each payout back to the processor report and source orders.
Why does a Shopify payout differ from sales revenue?+
A payout covers a specific settlement period and usually arrives net of processing fees, refunds, disputes, reserves, or adjustments. The sales dashboard and the payout can also use different timing rules, so gross sales for a calendar day rarely equal one bank deposit.
Should you reconcile every order directly to the bank?+
No. Match the bank deposit to the processor payout first. Then match the payout's transaction lines to orders, refunds, fees, and adjustments. This follows the way processors group many transactions into one net transfer.
How often should an ecommerce brand reconcile payouts?+
Use a cadence that prevents unresolved items from piling up. Many teams reconcile each payout or review them daily, then close remaining exceptions before the accounting period ends. Higher transaction volume usually calls for more frequent automated matching and a daily exception review.
