Shopify payout reconciliation connects captured payments to fees, refunds, adjustments, and the deposit in your bank account. The payout is a net deposit, so it usually won’t equal your sales dashboard total.
A reliable process follows transaction IDs through a Shopify Clearing account, then matches each payout to the bank. Start with the payout report, because order totals alone don’t explain where the money went.
Key Takeaways
- Match each deposit by payout ID, currency, and included transactions, rather than sales date alone.
- Record sales separately from processing fees, refunds, and liabilities.
- A fully settled payout batch should leave $0.00 in clearing. Pending batches can leave a supported balance.
Shopify Payout Reconciliation Starts With Reports
Separate Shopify Payments from other providers
Open Finances > Payouts in Shopify Admin. Some interfaces show Finance > Payout balance > View payouts. Older guidance uses Settings > Payments > View payouts.
For Shopify payouts processed through Shopify Payments, use a dedicated clearing account. PayPal and other third-party providers have separate settlement reports, fees, and deposits. Keep a separate clearing account for each provider and settlement currency.
Shopify can also bill third-party transaction fees separately. Identify these Shopify fees from the separate bill rather than treating them as payout deductions.
Export the transaction-level detail
Open the payout and retain its ID, status, currency, destination account, and bank reference when available. Shopify’s payout details and export guidance explains the available breakdown.
Use Amount, Fee, and Net to bridge transaction values to settlement. Preserve transaction type, order reference, transaction ID, and date wherever the export provides them.
Map captured charges to clearing, fees to expense, refunds to returns and applicable liability reversals, and adjustments according to their description. A payout summary groups fees by settlement. Calendar-month order matching needs transaction-level data or a custom report.
Work Through the Payout Arithmetic
Use signed amounts from the report, rather than estimating deductions from your plan’s advertised rate.
The figures below show how captured transactions and deductions bridge gross sales to the bank deposit.
| Component | Amount |
|---|---|
| Gross captured sales | $2,100.00 |
| Processing fees | -$61.20 |
| Refunds | -$87.50 |
| Shipping-related deduction | -$104.00 |
| Calculated deposit | $1,847.30 |
These deductions total $252.70. Therefore, a reported bank deposit of $1,847.32 leaves $0.02 unexplained. Find the supporting rounding or adjustment entry before posting it.
Also establish what the shipping deduction represents. Customer-paid shipping increases receipts; it isn’t automatically a payout deduction. Record the $104 as shipping expense only when supporting records identify an actual shipping charge.
This arithmetic check matters before automation. A connector can reproduce an incorrect mapping across every payout.
Post Sales, Deductions, and the Bank Deposit
A Shopify Clearing account tracks money collected by the processor but not yet deposited. For captured sales without invoices, the three rows below form a journal entry sequence.
| Entry | Debit | Credit |
|---|---|---|
| Record captured sales | Shopify Clearing $2,100.00 | Sales Revenue $2,100.00 |
| Record deductions | Processing Fees $61.20; Sales Returns $87.50; Shipping Expense $104.00 | Shopify Clearing $252.70 |
| Record settlement | Checking $1,847.30 | Shopify Clearing $1,847.30 |
This example assumes the $104 is documented shipping expense and excludes tax and gift-card complications.
If you issue invoices, first debit Accounts Receivable and credit Sales Revenue. On capture, debit Shopify Clearing and credit Accounts Receivable. That capture transfer replaces the first row above; don’t recognize revenue twice.
Refund entries should also reverse any refunded sales tax or shipping income in the appropriate accounts. Inventory and cost-of-goods-sold adjustments require separate return records.
When the bank feed imports the deposit, match the existing settlement entry. Adding another sale duplicates revenue.
The completed batch now clears to $0.00. However, the overall clearing account can retain other unsettled payouts, reserves, or captured payments. Every remaining amount needs supporting detail.
Handle Timing Without Forcing a Match
Separate revenue recognition from settlement
Under accrual accounting, recognize revenue when earned under your accounting policy, often when goods ship. Order date and payout date aren’t universal revenue-recognition rules.
A payout initiated January 30 might reach the bank February 1 or February 2, depending on weekends and processing. Match its payout ID and included transactions, then carry the unsettled amount through month-end.
Shopify describes the Payments activity report as a way to review balance activity. Choose a date range that covers the payout period, then compare that activity with payout-level detail.
Cash-basis reporting also needs a consistent policy. Don’t assume the bank’s posting date resolves every recognition question.
Distinguish pending payments from pending refunds
An authorization isn’t a capture, and a capture isn’t a bank deposit. Exclude uncaptured authorizations from the settlement bridge.
For refunds, retain both the refund transaction date and the payout containing the deduction. A refund approved in January can reduce a February payout.
Shopify Payments refunds can remain pending for up to two business days. Customer receipt can take up to ten business days. Those events differ, as our refund status guidance explains.
Don’t ask a customer to pay again while the original capture remains uncertain. Reconcile provider records first.
Keep Liabilities and Adjustments Out of Sales
Separate tax, gift cards, and currencies
Sales tax collected generally belongs in Sales Tax Payable, not revenue. Likewise, selling a gift card creates a liability: debit clearing or cash and credit Gift Card Liability.
On redemption, debit that liability and credit the appropriate sales and tax accounts. Only additional cash paid enters the processor settlement. Booking both issuance and redemption as sales inflates revenue.
For international orders, retain presentment, settlement, and ledger currencies. Match the bank in settlement currency, then account for conversion fees and exchange differences separately. Our multi-currency Shopify guide explains the storefront setup.
Give disputes and financing their own accounts
Chargebacks deduct disputed funds and can include a separate dispute fee. Record the principal as a dispute receivable or loss according to your accounting policy, then track the case ID.
A successful dispute creates an opposite-direction adjustment in a later payout. Reverse the original treatment when that credit posts. Don’t assume 75 days is a guaranteed release deadline; dispute timelines vary.
For a Shopify Capital loan, record the advance as debit Cash and credit Loan Payable. Sales-linked repayments reduce principal, with financing costs accounted for separately. The advance isn’t sales revenue.
Capital financing structures differ, so the loan entry applies to a loan agreement rather than every financing product.
Investigate Differences and Preserve the Evidence
Use this bank reconciliation sequence for each payout:
- Match the payout ID, currency, amount, and bank reference to the deposit shown on the bank statement.
- Add captured transactions and signed refunds, fees, reserves, and adjustments.
- Trace unmatched lines to order, payment, refund, or dispute IDs.
- Reconcile the remaining clearing balance to identifiable unsettled items.
For lower deposits, inspect reserves, chargebacks, negative balances, conversion costs, and failed-payout retries. Shopify’s lower or missing payout guidance describes these deductions and account issues.
Also compare connector totals against the export. Missing fees, duplicate imports, incorrect currencies, and refunds assigned to the original sale’s payout can all break the tie-out.
For bookkeeping, retain payout summaries, transaction CSVs, bank statements, order and refund records, dispute correspondence, financing statements, and journal references. Preserve timestamps and identifiers, but never store raw card details.
Record each exception’s amount, cause, owner, and expected resolution. Revisit aged items rather than carrying an unexplained clearing balance indefinitely.
Choose Automation Around the Settlement Workflow
Match tools to your ledger and payment mix, rather than choosing solely by order volume.
These options handle different parts of the workflow.
| Option | Useful role |
|---|---|
| Xero’s Shopify integration | Sales, payouts, fees, and tax synchronization |
| A2X | Payout-focused accounting summaries |
| Synder | Transaction synchronization across payment channels |
| Report Pundit | Custom reporting and transaction analysis |
Xero’s US listing supports daily summaries or separate sales transactions, plus payout matching. The older description that its native connector only imports orders is incomplete.
Ottit’s comparison quotes entry prices around $29/month for A2X and $48/month for Synder. Treat those as comparison-era references, not November 2026 price quotes.
Ottit also reports fee-sync shortfalls of 5% to 15% and manual-work reductions of 60% to 80% through bank rules. These are practitioner estimates, not guaranteed results.
Use rules for SHOPIFY, STRIPE, or PAYPAL to route or match transactions against clearing. Don’t automatically categorize those deposits as revenue.
Frequently Asked Questions
Are Shopify Payments fees always 2.4% to 2.9% plus $0.30?
Rates depend on the plan, country, card, and transaction. US standard-card examples include 2.9% plus $0.30 on Basic, 2.7% plus $0.30 on Grow, and 2.5% plus $0.30 on Advanced. Book actual report fees.
Should my 1099-K equal net sales?
A Shopify Payments 1099-K reports gross processing volume, not net ledger revenue. Reconcile it separately for refunds, fees, tax, timing, and other differences. Don’t force it to equal bank deposits.
Does Shopify return the original processing fee after a refund?
Shopify Payments doesn’t return the original credit-card processing fee. Therefore, refunding the customer’s full payment doesn’t reverse the original fee expense.
Close Each Payout With an Explained Balance
Reliable Shopify payout reconciliation leaves a clear trail between captured payments, deductions, and the bank. Explained clearing balances matter more than forcing the entire account to zero.
Start with one payout, retain its supporting records, and resolve every difference. Repeat that process consistently before handing the matching work to automation.
