Shopify Payout Report Versus Bank Statement: What Should Match?

Two records, two questions

The Shopify payout report answers, Which payment activity and adjustments contributed to this settlement? The bank statement answers, What amount did the bank credit, and when did it post? Neither record is a complete sales ledger by itself. A clean reconciliation uses each for the question it can answer.

Shopify's payout reconciliation report should provide the detail needed to explain the payout total. The bank statement should provide an independent confirmation of the net deposit. A sales report may use a different date or definition, so do not force its total to match either record.

Match identifiers, amount, currency, and date

Begin with the payout identifier or a unique reference where available. Confirm the store, currency, payout status, report period, and bank account. Then compare the payout's net total with the bank credit. A bank line may post on a different date from the processor's payout event; record both dates rather than editing one to resemble the other.

If the amount matches but the date differs, document the timing and keep the evidence together. If the amount differs, do not immediately change sales. Recheck refunds, processing fees, disputes, reserves, and other adjustments shown in the payout evidence. A held amount is not automatically a fee, an open dispute is not automatically a final loss, and a refund does not guarantee that any fee is returned.

• Match like-for-like currency; do not hide an FX question in a payout variance.
• Compare net settlement to bank cash, not gross captured receipts.
• Record a reason and source for every approved difference.

Worked example: the report and statement agree

Fictional simplified example, not a fee quote: payout report P-091 shows $2,400 of captured payment receipts, $120 of refunds, $72 of processing fees, and a $20 adjustment that the report identifies. The expected settlement is $2,400 − $120 − $72 + $20 = $2,228. These figures are illustrative accounting amounts; gross means before the listed deductions and adjustment, not tax-inclusive sales, and no tax conclusion is implied.

The bank statement has a $2,228 credit with reference P-091 two days after the payout event. The amount is matched, while the two dates are retained as separate evidence. The bank credit is a settlement of the processor balance, not a new $2,228 sale. The captured receipts, refund, fee, and adjustment should be handled under the business's documented accounting policy.

Check: $2,400 − $120 = $2,280; $2,280 − $72 = $2,208; $2,208 + $20 = $2,228. Showing the calculation in the workpaper helps a reviewer see why the net deposit is smaller than captured receipts.

Investigate a mismatch in layers

First, check whether the bank line is the right account and currency. Second, check whether the report is final, pending, or for a different payout. Third, compare every report component with the expected accounting entries. Fourth, check for a date boundary: a captured payment near month-end can be included in a later payout.

Shopify's payout timing guidance explains why the arrival date depends on the payout schedule and bank processing. For a remaining difference, create an exception with the amount, likely category, source reference, owner, and next review date. Do not post a plug to revenue just to close the bank reconciliation.

Make the review useful to the whole team

Merchants need to know whether cash is delayed or genuinely missing. Bookkeepers need a traceable support file. Finance teams need consistent cutoff evidence. A one-page payout workpaper can meet all three needs: report link or export, bank screenshot or statement reference, calculation, accounting treatment, and open questions.

For Shop Pay Installments or other payment arrangements, read the applicable Shopify terms and status information rather than assuming all payment methods settle in the same way. Shopify's Shop Pay Installments FAQ is an authoritative starting point for that product's questions, not a substitute for store-specific settlement evidence.

Sources and further reading

Shopify: Payout reconciliation report and Payout timing. For Shop Pay Installments context, see the Shop Pay Installments FAQ.

Payout Explainer is coming soon

Product note: SlayCommerce's Payout Explainer is coming soon. It is planned to help a person review report-to-bank evidence before posting, without automatic posting or tax and FX advice.