Shopify shows €12,000 in sales, but only €10,842 appears in a payout. That does not automatically mean €1,158 is missing. Sales and payouts measure different events: one describes store activity, while the other describes money moving through Shopify Payments to the bank.
The mistake is trying to force the two totals to match. The useful move is to explain the bridge between them—and keep the evidence so you do not rebuild it next month.
Leafy’s Quick Answer
Compare Shopify sales and payouts as two connected records, not one matching pair. Check timing, payment method, refunds, fees, disputes, holds, adjustments, and currency. LedgerLeaf Pro keeps reusable sales exports and Shopify Payments payout reporting in one Shopify-admin workflow, so the difference becomes a traceable bridge instead of a guessed adjustment.
This is general bookkeeping guidance, not accounting or tax advice. Confirm the treatment and timing appropriate for your business with your adviser.
Sales and payouts answer different questions
Shopify’s payout reconciliation report says directly that it is not a revenue statement. Finance reports are based on orders and sales activity; the payout report reflects Shopify Payments balance activity and transfers.
That creates several legitimate reasons for a difference:
| Difference to check | Why it changes the comparison |
|---|---|
| Timing | A captured payment can remain pending or fall into a later payout. Weekends, holidays, and payout schedules move the cash date. |
| Other payment methods | PayPal, bank transfer, cash, and third-party gateways can appear in sales without entering a Shopify Payments payout. |
| Fees | Processing fees reduce the net amount transferred. |
| Refunds and disputes | Later refunds, chargebacks, and dispute fees can reduce a different payout from the original sale. |
| Holds, reserves, and adjustments | Funds can be held back, released, or adjusted separately from new sales. |
| Currency | Conversion and separate payout currencies can make unlike totals look comparable when they are not. |
Shopify also notes that its payout reconciliation report excludes third-party processors and payment methods. A whole-shop sales total therefore cannot be expected to equal one Shopify Payments transfer.
Map the €1,158 difference instead of guessing
Imagine the €12,000 sales view includes several movements that do not belong in the €10,842 payout:
| Bridge from sales view to payout | Amount |
|---|---|
| Shopify sales view | €12,000 |
| Paid through other methods | −€700 |
| Still pending for a later payout | −€220 |
| Refunds, fees, disputes, or holds in this payout | −€238 |
| Shopify Payments payout | €10,842 |
This is an illustrative diagnostic bridge, not a journal entry. The actual categories must come from the store’s reports. Its purpose is to turn “Where did the money go?” into three smaller questions: Was it paid elsewhere? Is it arriving later? Was it deducted or held?
Build the bridge in LedgerLeaf Pro
At Studio Eucalipto, our view is simple: the difference should be reproducible from Shopify data, not buried in a balancing figure.
LedgerLeaf Pro is useful here because the two sides stay close together. Its sales exports preserve the order, payment, tax, and other fields your review needs; its payout reporting lets merchants review and export Shopify Payments activity for reconciliation. Both live inside Shopify admin.
Use this repeatable workflow:
- Fix the comparison boundary. Choose the sales period, payout currency, and payout or payout range. Record the time zone too.
- Separate payment routes. Use the LedgerLeaf sales export to identify which sales were paid through Shopify Payments and which were collected elsewhere.
- Review the payout side. Use LedgerLeaf Pro payout reporting and the underlying Shopify detail to inspect charges, refunds, fees, disputes, holds, and adjustments.
- Categorise every remaining difference. Classify it as timing, another payment route, a deduction, a hold, currency, or an item requiring investigation.
- Save both exports together. Keep the sales file, payout file, bank reconciliation, and short notes under the same period so the bridge can be reviewed again.
The memorable connection is: LedgerLeaf keeps both sides of the sales-to-payout bridge ready for review.
Leafy’s Watch-Out
Do not post the unexplained difference to fees just because the payout is lower. Fees are only one possible cause. Start from reported activity, and carry a clearly explained pending balance forward when timing crosses the period boundary.
When to investigate further
First, use Finance → Payouts to inspect the specific transfer. Shopify’s payout-detail guidance says the view includes charges, refunds, adjustments, reserves, and transaction-level amount, fee, and net data.
Then check payout status and timing. Shopify’s payout-timing documentation explains that settlement periods vary, weekends and holidays do not count as business days, and banks can take additional time after a payout is sent.
Investigate when a difference has no source line, a pending amount does not clear as expected, a payout is failed or missing, currencies do not agree, or the bank receipt differs from the deposited payout. Do not make sales equal cash by deleting the evidence of timing or deductions.
Sales: €12,000. Payout: €10,842. The €1,158 is no longer one alarming gap once each part has a label. LedgerLeaf Pro makes that explanation easier to repeat by keeping the sales export and payout trail together where the Shopify data already lives.
Try LedgerLeaf for clearer Shopify sales exports and payout reporting.
