01
Charges add balance activity.
The synthetic charges contribute US$5,000 before their US$145 fee, leaving US$4,855 of signed Net. Do not substitute a total sales report for these payout-linked rows; order and capture scopes can differ.
Synthetic Shopify Payments example
How charges, fees, refunds, a dispute, and a reserve become one payout
Start with the signed balance movement that belongs to one payout. Tie that movement to Shopify's displayed net payout before comparing the payout with the bank deposit.
Shopify Payments only · One payout and currency · Invented values
Quick answer
Use one net total, not a pile of unrelated report numbers.
Shopify documents each balance transaction with an Amount, Fee, and resulting Net value. The Net value is what affects the Shopify Payments balance. For one payout, add the signed Net values of the transactions that the Shopify admin establishes as belonging to that payout, then compare the result with the payout total.
Only after that first tie passes should a payout that Shopify marks Deposited be checked against an observed same-currency bank line. Deposited means Shopify has sent the funds; Shopify notes that a bank can still take 1–3 business days to process them. A fee or reserve that already reduced the payout cannot be subtracted again to explain a later bank variance.
Sources: Shopify payout details and transaction export and Shopify Payments balance-transaction fields.
Worked example
A synthetic US$3,910 payout, category by category.
Assume the Shopify admin has already established that the five invented row groups below belong to one payout in USD. The Fee column is shown as a positive magnitude so each row follows Net = Amount − Fee. A real export's row types, values, fee treatment, and signs control the real calculation; copy its signed Net values rather than forcing this pattern onto another payout.
For the later bank check, assume this invented payout is in USD, is directed to the account ending 4821, carries the synthetic transfer reference EXAMPLE-3910, is dated August 28, 2026 in Shopify, and posts to that same account on August 29, 2026 at the bank.
| Synthetic row group | Amount | Fee | Signed Net |
|---|---|---|---|
| Charges | + US$5,000.00 | US$145.00 | + US$4,855.00 |
| Refunds | − US$400.00 | US$0.00 | − US$400.00 |
| Dispute debit | − US$250.00 | US$15.00 | − US$265.00 |
| Reserve placed | − US$300.00 | US$0.00 | − US$300.00 |
| Adjustment credit | + US$20.00 | US$0.00 | + US$20.00 |
Charge-row NetUS$5,000.00 − US$145.00 = US$4,855.00
All signed Net valuesUS$4,855.00 − US$400.00 − US$265.00 − US$300.00 + US$20.00 = US$3,910.00
Shopify displayed payoutUS$3,910.00 → composition tie passes
Observed bank lineUS$3,910.00 in USD · account •4821 · EXAMPLE-3910 · payout Aug 28 / bank post Aug 29 → variance is US$0.00
The US$145 processing fee, US$400 refund, US$265 dispute movement, and US$300 reserve are already represented in the US$3,910 payout. They explain the first tie—from included balance activity to the net payout. They do not become four new deductions after the payout is sent to the bank.
Read the rows
What each synthetic line is doing.
02
Refunds reduce the balance in their own timing.
The example uses a US$400 refund row with no separate fee. A real payout can contain refund and fee-adjustment behavior that differs by market and account, so preserve the exported row rather than assuming this zero.
03
A dispute can contain more than the disputed amount.
This invented dispute has a US$250 debit plus a US$15 fee, so its signed Net is −US$265. The amounts are not a Shopify price quote or a prediction for another store.
04
A reserve placement holds funds back.
Shopify says a negative reserve transaction represents funds placed in reserve and reduces the amount available in a payout. The US$300 line is held balance activity, not a second processing fee or proof that the funds were lost.
05
An adjustment keeps its own sign and source.
The example includes a US$20 credit. In a real review, retain the adjustment's source and reason where available; do not use an unsupported positive or negative adjustment as a plug.
06
The bank check starts from the payout total.
Shopify's specific-payout view supplies the total, status, destination account, transfer reference where available, and included transactions. Those are the bridge to the bank—not the original charge total.
Reserve direction
A reserve placement and a reserve release point opposite ways.
Negative reserve transaction
Shopify describes this as the part of payout funds placed in reserve. It reduces the current payout. Reconcile it against Shopify's Reserved funds balance rather than subtracting it again from the bank deposit.
Positive reserve transaction
Shopify describes this as reserved funds becoming available for payout after the reserve is complete. A later release can increase a payout even though it is not a new sale in that later period.
Shopify separates the payout balance from reserved funds and documents both reserve-transaction directions in its Shopify Payments reserve guide. The terms and timing of a real reserve come from the store's Shopify notice and admin; this example does not calculate, appeal, or predict them.
Before using the example
First prove which rows belong to one payout.
This page starts after payout membership has been established and focuses on how different transaction types move the net amount. For the extraction, membership, signed-Net tie-out, and bank-match steps, use the Shopify payout CSV reconciliation guide. Do not select rows by date and currency alone.
Why this example exists
A merchant team asked for dummy payout data before going live.
In a current Shopify Community thread, one team asked how gross sales, refunds, disputes, and fees roll into a net payout and which source supports bank reconciliation. A second participant asked for a sample with dummy data because the store's live Shopify Payments reports were still empty. That request motivates this synthetic walkthrough; the procedural and field claims above come from Shopify's official documentation, not from community replies.
Merchant-language source: Payout Breakdown + Bank Remittance clarity. The thread is evidence of the explanation need, not evidence that the example fits another store or that anyone will buy the workbook.
Keep the two ties separate
Carry one verified Shopify net payout into a manual review.
The US$9 Shopify Payout Reconciliation Workbook starts after Shopify's native records have identified the payout and its evidence. It keeps the payout-composition check separate from the payout-to-bank check and leaves unsupported differences visible instead of forcing a match.
The ZIP contains one editable .xlsx workbook with worked synthetic examples and a checklist tab. It does not import reports, connect to Shopify or a bank, calculate or appeal a reserve, recover money, decide accounting treatment, or make tax or bookkeeping entries.
View the US$9 workbook on GumroadShopify Payments only. One currency per workbook. Requires an app that can open and recalculate Excel formulas; compatibility with Google Sheets, Apple Numbers, mobile apps, and browser-only editors is not verified.
Boundary
An arithmetic walkthrough—not a universal payout formula.
The numbers are invented. This guide does not establish a store's real fees, reserve terms, dispute cost, payout timing, revenue, tax result, accounting treatment, processor fault, bank fault, underpayment, or missing funds. Preserve the controlling Shopify and bank records and route unresolved provider, bank, bookkeeping, accounting, tax, or legal questions to the qualified party that controls them.