Check a Shopify payout by identifying the payment provider, matching its settlement reference to the bank record and explaining the transactions, fees and adjustments inside it. Start with eligibility: this guide describes Shopify Payments records conditionally and does not imply Shopify Payments availability in Zambia. Use the worksheet to keep sales, settlement and bank receipt distinct.
Which provider actually settles the store’s payments?
Read the store’s configured payment arrangement before looking for a payout screen. Identify the provider holding the transaction, the account that receives settlement and the person responsible for reconciliation. A store’s order record and a provider’s settlement statement serve different parts of the investigation.
Shopify restricts Shopify Payments to businesses located in its listed supported countries. Documentation. Shopify directs businesses in unlisted countries or unsupported categories to third-party payment providers. Documentation. Shopify requires checking business eligibility and the documentation needed for the relevant country. Documentation. For a Zambian business, establish the relevant provider and its requirements directly. Use the Shopify gateway eligibility guide for that selection boundary. Do not apply Shopify Payments screen instructions to a different provider’s settlement arrangement.
Once the provider is established, collect the actual settlement reference and reporting scope. Record the currency, account, period and export filters alongside the file. This article’s worksheet can organise a reconciliation discussion, while field names and adjustment treatment must follow the provider actually used.
Why can a sale, payout and bank receipt have different dates?
The Shopify Payments payout date records when Shopify sends the payout to the bank. Documentation. Shopify describes pending amounts and payout dates as estimates. Documentation. Keep the order event, provider settlement and bank receipt in separate worksheet fields. That makes the intended comparison explicit when someone asks why a transaction has not appeared in the account expected.
A Deposited payout status does not establish that the funds are available in the bank account. Documentation. When checking receipt, locate the bank’s own record as well as the provider status. If the bank evidence is not available, leave that part of the reconciliation open and assign a follow-up. Avoid changing a provider estimate into an internal promise about when money will be usable.
Agree the date basis of each report before comparing totals. Write whether a working file groups transactions by order date, transaction date or settlement date. Keep its time-zone information intact. The proposed process should explain which records are being compared rather than forcing unrelated reporting periods to balance.
An original settlement-to-bank worksheet
Use this practical checklist for one actual settlement. Fill in monetary values privately from the source records; the table supplies no prices, fee assumptions or invented example amounts. Retain the original exports and record any working transformations separately.
| Reconciliation line | Record to identify | Question before closing |
|---|---|---|
| Provider and account | Actual settlement provider and merchant account | Are these instructions applicable to this account? |
| Settlement reference | Payout or batch identifier and currency | Which specific settlement is being reconciled? |
| Transaction scope | Export filter and included transaction references | Does the file cover the intended payout? |
| Deductions and adjustments | Fees, refunds and other stated movements | Is every movement explained by the source statement? |
| Expected transfer | Provider’s stated settlement amount and status | Is the amount final or still estimated? |
| Bank observation | Account reference, receipt date and observed amount | Has the bank record been located? |
| Unresolved difference | Difference, evidence missing and follow-up owner | What information would resolve it? |
Add an evidence-reference column in the working copy. Link each adjustment to its original transaction or provider explanation where available. Keep the calculation transparent so another person can reproduce it without changing the source file.
Record the report-generation time as well as the covered period. If a later export changes the picture, preserve both versions and explain the difference. A revised file should not silently replace the evidence that led to an earlier escalation or accounting decision.
What belongs inside the settlement breakdown?
Shopify payout details include charges, refunds, adjustments, fees, reserves and retried payouts. Documentation. Start from the provider’s own breakdown and retain its categories. Ask the person doing the reconciliation to trace each consequential movement back to the underlying record. Keep an unresolved adjustment separate from an assumed fee or a guessed refund.
Shopify allows exporting the transactions in a specific payout for reconciliation. Documentation. When using that export, confirm that the selected payout identifier is the one on the worksheet. If the purpose is to reconcile one bank deposit, an export of every transaction may create an unnecessary scope problem. Write the chosen filter in the working copy so another reviewer can repeat it.
Shopify defines the Net CSV field as the transaction amount less its fee. Documentation. Read the complete export definition before using a field in a calculation. A field called net should be interpreted according to its documented scope, rather than assumed to explain every possible movement in a bank deposit. Preserve separate lines for categories the provider reports separately.
For a store using a third-party provider, ask for the equivalent statement, field definitions and settlement references. Keep the same reconciliation questions while replacing Shopify Payments-specific labels with the actual provider’s documented records. The workflow should follow the commercial arrangement in use.
Hypothetical example: a refund appears after the first export
Imagine the finance team exports a proposed payout while its amount is still pending. A later statement includes a refund or adjustment, and the bank receipt differs from the first worksheet. This hypothetical example tests version handling and scope, rather than predicting any account’s settlement outcome.
Locate the final provider statement and preserve the earlier pending export. Compare the included transaction references and adjustment lines. Record which information changed and when it became available. Update the working calculation with an explanation, leaving the original evidence accessible.
If the final provider statement and bank observation still differ, identify the exact unanswered question. It could concern the account reference, a movement included in the settlement or the bank’s handling of the transfer. Assign the enquiry to the person with access to the relevant organisation rather than inventing a balancing entry.
What should an escalation contain?
Shopify provides a payout bank reference number for bank enquiries when available. Documentation. Prepare a concise enquiry with the payout reference, relevant dates, currency, provider status and the specific discrepancy. Share financial information through the approved support route and give the recipient enough context to locate the record.
Close the worksheet only when the defined comparison has been resolved or an authorised owner has recorded a specific outstanding treatment. A useful handover distinguishes the provider’s statement, the bank observation and the organisation’s accounting decision.
For broader store requirements, see online stores. Keep eligibility questions with the Shopify availability guide. Get started with the reporting boundaries and evidence you need your store workflow to retain.
By Spout Team. AI-assisted drafting by Codex using the linked primary documentation.