Xero Shopify Payout Reconciliation - Manual Workflow and Checks
A payout-first workflow for explaining Shopify payout deposits before matching or reviewing them in Xero.
Try with sample files | View sample report
Problem statement
Xero review usually starts from the bank statement line, while Shopify explains the cash movement through payout rows, fees, refunds, adjustments, reserves, and payout status. If you accept the bank line or connector summary before the payout support is clear, the deposit can look matched while the payout logic is still weak.
Numeric example
| Line item | Amount |
|---|
| Gross Shopify orders inside the payout | $3,480.00 |
| Refunds | -$210.00 |
| Shopify fees | -$104.40 |
| Adjustment or reserve movement | -$35.60 |
| Xero bank statement line | $3,130.00 |
Why the numbers do not match
- Xero bank reconciliation sees the net statement line, not the gross Shopify order total.
- Shopify payout details can reduce the deposit through fees, refunds, adjustments, or reserve-style rows before the cash reaches the bank.
- Payout status and bank arrival timing can differ from the original order date.
- One payout can cover many orders, while some non-Shopify gateways may sit outside the Shopify Payments payout entirely.
- Connector-created summaries or manual entries can duplicate or oversimplify the payout if the export review is skipped.
What files to export
- Shopify payout details export with payout ID, status, payout date, transfer reference, gross, fees, refunds, adjustments, reserves, and net amount.
- Shopify orders export with order number, paid date, payment method, gross sales, and refund detail behind the payout.
- Xero bank statement or bank feed export with statement date, amount, and description for the deposit being reviewed.
- Optional connector or invoice export when you need to check whether Xero already contains a duplicated or oversimplified entry.
Reconciliation workflow
- Start from the Shopify payout ID, payout status, transfer reference, and net amount before you accept the Xero bank match.
- Keep the Xero statement line open when the payout status is pending, delayed, failed, or otherwise not yet final.
- Separate gross sales, refunds, fees, adjustments, and reserve-style rows inside the payout support.
- Compare the expected net payout to the Xero bank statement line by amount, date, and transfer reference where available.
- Use the Shopify orders export only to explain what sits behind the payout after the payout-level cash movement already makes sense.
- Check whether Xero already contains a connector-created summary or manual entry that duplicates the same payout evidence.
- Retain the reviewed payout report before any Xero bank rule, reconciliation click, or downstream bookkeeping handoff is treated as final.
Review checks
- The Xero bank line was accepted from amount alone without the Shopify payout support.
- Gross Shopify sales were compared directly to the Xero statement line.
- Payout status or transfer reference was ignored before the bank match was called final.
- A connector summary or manual entry in Xero duplicated the payout that was already being reviewed.
- Orders from another gateway were mixed into the Shopify Payments payout explanation.
How Reconcile Locally helps
- Keeps Shopify payout support, Xero bank rows, and optional connector evidence in one local review workflow.
- Separates matched deposits from amount differences, unknown bank payments, and grouped-row cases instead of forcing a clean match too early.
- Preserves payout-first evidence before Xero bank reconciliation, accountant handoff, or month-end close.
- Exports a report you can attach to the Xero review package instead of burying the payout logic in notes.
What still needs manual review
- Reconcile Locally does not post to Xero, clear statement lines, or decide final ledger mapping.
- Exact tax treatment, clearing-account structure, and accounting classification still require human review.
- Grouped deposits, weak transfer references, and cross-gateway cases can still need one more export before the difference is fully explained.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Can I use this workflow without a Xero connector?
Yes. Export the relevant files and reconcile the payout detail before recording or reviewing the bank deposit.
Should I start from Shopify orders or from the payout inside Xero review?
Start from the payout. Orders are supporting detail, but the Xero-side bank line usually matches the net payout after deductions, timing, and payout-status review.
What if the Xero amount looks right but the payout date or reference does not?
Keep it in review. A delayed payout, bank-processing lag, or weak transfer description can make the amount look correct before the payout evidence is actually strong enough.
Does Reconcile Locally clear or post the Xero bank transaction?
No. It prepares a review-ready report from exported files. Clearing, posting, and approving accounting entries remain separate human workflows.