You find the €2,881 Shopify payout in the bank feed and mark it as matched. Then month-end arrives and someone asks: how much of the original customer activity was fees, refunds, disputes, or adjustments?
The bank tick cannot answer. This is the gap that makes payout reconciliation feel finished before the useful bookkeeping trail actually exists.
Leafy’s Quick Answer
Reconcile every Shopify Payments payout in two directions: match the net payout to the bank, then explain how charges, refunds, fees, disputes, holds, and adjustments produced it. Shopify provides the source activity; LedgerLeaf Pro keeps payout reporting and exportable evidence in the Shopify-admin workflow so the same check is easier to repeat and hand off.
This is operational guidance, not accounting or tax advice; use the treatment appropriate to your business.
This is exactly where LedgerLeaf Pro belongs in the workflow: Shopify supplies the transaction evidence, while LedgerLeaf keeps the payout report and exportable trail close to the other Shopify bookkeeping records the month-end review needs.
A bank match is not the finish line
At Studio Eucalipto, our view is simple: a reconciliation should leave an explanation you can reuse, not just a deposit you can tick off. Otherwise the next close begins with the same spreadsheet search.
A complete payout check connects three records:
- Store and payment activity: what customers paid and what was refunded.
- Shopify Payments balance activity: charges, fees, disputes, holds, adjustments, and the resulting payout.
- The bank statement: the cash that actually arrived.
Shopify’s payout reconciliation report explains movement through the Shopify Payments balance. It reflects funds received, not revenue for accounting purposes: the payout belongs in the cash trail, while sales reports describe what the store sold.
The image’s €2,881 payout can be explained like this:
| Activity behind one payout | Amount |
|---|---|
| Customer charges | €3,200 |
| Refunds | −€180 |
| Dispute activity | −€60 |
| Processing fees | −€94 |
| Adjustment | +€15 |
| Shopify Payments payout | €2,881 |
| Bank deposit | €2,881 |
The payout and bank agree, but the activity bridge is what prevents €319 of refunds, dispute activity, and fees from disappearing inside one unexplained net deposit. The adjustment remains visible too. That is the useful proof.
Keep Shopify’s source detail in a LedgerLeaf payout trail
Use Finance → Documents → Payout Reconciliation Report for a summary across a date range and payout currency. Its balances, activity, fees, and total payouts show how the Shopify Payments balance moved.
Use Finance → Payouts to inspect one payout and its transactions. Shopify’s payout-details documentation lists its amount, status, bank destination, transfer reference where available, and breakdown of charges, refunds, adjustments, and reserves. Exports include amount, fee, and net columns.
Those native views provide the transaction detail. The recurring friction is turning it into consistent payout evidence every close.
That is why payout reporting belongs in LedgerLeaf Pro. Merchants can review Shopify Payments payout activity and export it for reconciliation without another external account, then keep that file beside the sales evidence for the same period. The memorable connection is: LedgerLeaf keeps the payout trail ready for review.
A four-step LedgerLeaf payout workflow
1. Match the payout to the bank
Start from the payout activity in LedgerLeaf Pro and identify the deposit you are reconciling. For each deposited payout, record:
- payout date, status, currency, and net amount;
- bank account and deposit date;
- transfer reference and any difference to investigate.
Match the exact amount and currency rather than a nearby sales total. Shopify notes that Deposited means the payout was sent to the bank; the bank can still need processing time. A cutoff, weekend, or bank delay can therefore move the cash date without changing the payout.
Leafy’s Watch-Out
Posting the net bank deposit as one sales number hides the movements that explain it. Keep sales activity and payout cash distinct so fees and refunds remain visible.
2. Explain the activity behind the net amount
Use the payout report and its underlying Shopify detail to review every activity type that applies:
- customer charges;
- refunds and related fee adjustments;
- processing fees;
- disputes and chargebacks;
- reserves or holds;
- currency conversion or other adjustments.
Confirm that the components add to the payout net. Compare them with the relevant payment and sales records instead of forcing the sales report to equal the deposit. This is where the check changes from “cash arrived” to “we can explain why this amount arrived.”
3. Carry timing differences forward
Recent activity can remain outside the deposited payout. Shopify currently notes a three-day report delay, while payout timing follows its own schedule. Pending charges, refunds, holds, and weekends can cross the reporting boundary legitimately.
Keep an explained outstanding balance and carry it into the next period. Investigate it if it does not clear as expected; do not erase it by changing the reporting period or inventing an adjustment.
4. Save evidence the next close can reuse
Export the payout evidence from LedgerLeaf and save it with the payout identifier, currency, bank match, and notes using the same naming pattern each period. Then the trail stays readable without reconstructing how the file was assembled.
LedgerLeaf’s payout reports and exports make that repeatability the default outcome rather than a separate spreadsheet-cleanup project after the bank has already been matched.
When the numbers still do not agree
Check these before treating the difference as an error:
- the reports use the same dates and time zone;
- the payout and bank currencies match;
- the bank has finished processing the transfer;
- recent activity is not still pending or delayed in the report;
- reserves, disputes, or adjustments are included;
- third-party gateways have been reconciled separately.
Work in one payout currency at a time. Shopify’s reconciliation report covers Shopify Payments, so other payment routes need their own reports and bank matches. If a transfer is missing or failed after these checks, use its reference and status when contacting Shopify or the bank.
So, what is still missing after the payout matches? The explanation—and the reusable evidence behind it.
If payout checks still mean rebuilding that trail from scratch each month, LedgerLeaf Pro changes the recurring outcome: Shopify Payments payout reporting, exportable evidence, and the rest of the Shopify bookkeeping workflow stay together inside admin, ready for the next review.
