Shopify sellers often assume that every deposit arriving in their bank account represents sales revenue. However, a Shopify payout is usually a net settlement rather than gross revenue.
Before sending the money to your bank, Shopify may deduct payment-processing fees, refunds, chargebacks and other adjustments. Sales tax and timing differences can also affect the relationship between orders, payouts and bank deposits.
If you record only the net bank deposit as revenue, your sales and expenses may be understated, sales-tax liabilities may be inaccurate, and financial reports may not reflect the true performance of your ecommerce business.
This guide explains how US ecommerce businesses can reconcile Shopify payouts in QuickBooks Online and identify when a more structured accounting system is necessary.
What Is a Shopify Payout?
A Shopify payout is the amount transferred from your Shopify Payments balance to your bank account.
Depending on the transactions included, a payout may contain:
- Customer payments
- Shopify Payments processing fees
- Refunds
- Chargebacks and dispute fees
- Adjustments
- Reserves or holds
- Other balance activity
The payout amount appearing in your bank is therefore not necessarily the same as your gross sales.
For example, assume your Shopify activity includes:
- Customer payments: $10,000
- Refunds: $500
- Payment-processing fees: $290
- Chargeback: $150
- Chargeback fee: $15
The resulting bank payout would be:
$10,000 − $500 − $290 − $150 − $15 = $9,045
If the $9,045 bank deposit is recorded entirely as sales revenue, both revenue and the related deductions will be misstated.
Why Shopify Payouts Should Not Be Recorded Directly as Revenue
Shopify payouts represent movements of cash, while revenue should reflect the underlying sales activity.
The difference matters because financial statements should separately show:
- Gross or net sales
- Discounts
- Returns and refunds
- Shipping income
- Sales tax collected
- Payment-processing fees
- Chargebacks
- Other adjustments
Recording the entire payout as revenue hides these components. It can make it difficult to calculate gross margin, evaluate payment costs, reconcile sales-tax liabilities or identify unusual refund and chargeback activity.
Accurate Shopify bookkeeping should connect three separate records:
- Shopify sales and payment activity
- The Shopify payout
- The deposit recorded by the bank
Reports Needed to Reconcile Shopify Payouts
Before beginning the reconciliation, collect the following information:
- Shopify payout report or payout transaction export
- Shopify Payments activity report
- Shopify sales or finance reports
- Bank statement
- QuickBooks Online bank transactions
- Refund and chargeback details
- Sales-tax reports
- Reports from any third-party gateways
The Shopify Payments activity report shows gross activity, fees, payouts and changes in the Shopify Payments balance. For an individual deposit, the payout details provide the transactions and adjustments included in that payout.
Remember that Shopify Payments reports do not include transactions processed through every third-party payment provider. PayPal, Amazon Pay, Klarna or another gateway may require a separate reconciliation.
Step 1: Create a Shopify Clearing Account in QuickBooks Online
A Shopify clearing account acts as a temporary holding account between Shopify and your bank.
Sales, refunds, fees and other Shopify activity are recorded through this account. When Shopify sends a payout, the amount is transferred from the clearing account to the bank account.
The clearing account helps explain why the amount deposited into the bank differs from total sales.
In QuickBooks Online, create an account such as:
- Account name: Shopify Payments Clearing
- Account type: Bank
- Detail type: Cash on hand or another appropriate clearing-account classification
The exact configuration should be consistent with your accounting method and existing chart of accounts.
Step 2: Record Shopify Sales Activity
Record Shopify sales using an appropriate daily, weekly or monthly summary. You should also follow consistent Shopify bookkeeping practices for recording sales, taxes, refunds and payment activity.
Depending on the business, the entry may include:
- Product sales
- Discounts
- Returns and refunds
- Shipping income
- Sales tax collected
- Gift-card activity
- Other income or adjustments
Sales tax collected should generally be recorded as a liability rather than revenue because it is collected for remittance to the relevant tax authority.
The offsetting amount is recorded in the Shopify clearing account, representing money processed by Shopify but not yet deposited into the bank.
Step 3: Record Shopify Fees and Adjustments
Shopify Payments fees should be recorded separately as an expense.
Refunds, chargebacks, dispute fees, reserves and adjustments should also be assigned to the appropriate accounts. They should not be combined into one unidentified difference simply to make the payout match.
Separating these amounts allows the business to measure:
- Payment-processing costs
- Refund rates
- Chargeback exposure
- Net sales
- Channel profitability
- Changes in funds held by Shopify
Use the payout details to determine exactly which transactions were included in each settlement.
Step 4: Record the Transfer to the Bank Account
Once the Shopify activity has been entered, record the payout as a transfer from the Shopify clearing account to the business bank account.
For example:
- Gross customer payments: $10,000
- Refunds: $500
- Processing fees: $290
- Chargeback and fee: $165
- Net bank payout: $9,045
The $9,045 deposit should reduce the Shopify clearing account and increase the bank account. It should not create another $9,045 of revenue because the underlying sales have already been recorded.
Step 5: Match the Deposit in QuickBooks Online
When the payout appears in QuickBooks Online’s bank transactions, match it to the payout or transfer already recorded.
Before confirming the match, verify:
- The payout amount agrees with Shopify
- The correct bank account received the deposit
- The transaction date is reasonable
- The payout has not already been recorded
- The clearing-account entry includes the relevant activity
Do not select Add and categorize the payout as sales if the underlying activity has already been recorded. Doing so may duplicate revenue.
Step 6: Reconcile the Shopify Clearing Account
After recording all sales activity, deductions and payouts, reconcile the Shopify clearing account.
A non-zero balance may be legitimate when Shopify is still holding funds at the end of the reporting period. However, unexplained differences may indicate:
- Missing payouts
- Transactions assigned to the wrong period
- Unrecorded refunds or chargebacks
- Duplicate revenue
- Incorrect sales-tax treatment
- Third-party gateway transactions
- Currency-conversion differences
- Reserves or holds
- Incorrect opening balances
Compare the QuickBooks clearing-account balance with Shopify’s ending balance for the same reporting date and payout currency.
Common Shopify Reconciliation Mistakes
Payout errors are only one source of inaccurate reporting. Review these common Shopify accounting mistakes that can affect revenue, expenses and profitability.
Recording Net Deposits as Revenue
This understates sales and payment-processing expenses and prevents accurate reporting.
Duplicating Shopify Sales
This can happen when an integration records sales and the bank deposit is added as additional income instead of being matched.
Ignoring Refunds and Chargebacks
Refunds and disputes directly affect net sales, cash flow and profitability. They should be recorded in the correct accounts.
Treating Sales Tax as Revenue
Sales tax collected is generally a liability owed to a state or local authority, not income earned by the business. Sellers operating across states should also understand how ecommerce sales-tax nexus can create registration and filing obligations.
Mixing Shopify Payments With Other Gateways
Shopify’s reports may include orders paid through different gateways, while the Shopify Payments payout contains only eligible Shopify Payments transactions. PayPal and other providers should be reconciled separately.Businesses that also sell through Amazon should reconcile that marketplace separately using the appropriate Amazon settlement accounting process.
Ignoring Payout Timing
An order may be placed in one month while its payout reaches the bank in the following month. This creates a valid clearing-account balance at month-end.
Forcing the Clearing Account to Zero
A clearing account should reconcile to the amount legitimately held by the payment processor. It should not automatically be forced to zero using an unexplained adjustment.
Manual Reconciliation vs Ecommerce Accounting Software
A small Shopify store with limited monthly transactions may be able to use summarized manual entries.
As transaction volume grows, manual reconciliation becomes slower and more prone to error. An ecommerce accounting integration can help summarize sales, fees, refunds, taxes and payouts before posting them to QuickBooks Online.
However, automation does not eliminate the need for review. Incorrect mappings, duplicated feeds, missing gateways or poorly configured tax settings can still produce inaccurate financial statements.
The appropriate system depends on:
- Monthly order volume
- Number of sales channels
- Number of payment gateways
- Inventory complexity
- Sales-tax exposure
- Refund and chargeback volume
- Reporting requirements
- Number of currencies
How Often Should Shopify Payouts Be Reconciled?
Shopify payouts should generally be reviewed throughout the month and fully reconciled as part of the monthly close.
High-volume sellers may benefit from daily or weekly monitoring. Waiting several months allows missing payouts, duplicated sales and incorrect mappings to accumulate, making the eventual cleanup more expensive and time-consuming.
At month-end, the business should confirm that:
- Shopify activity agrees with the accounting records
- Bank payouts have been matched
- Payment fees and refunds are recorded
- Sales-tax liabilities are reasonable
- Third-party gateways are reconciled
- The Shopify clearing-account balance is supported
- Revenue is recorded in the correct period
When Should You Hire an Ecommerce Accountant?
Specialized support may be appropriate when:
- Shopify deposits do not match QuickBooks
- Revenue is duplicated or understated
- The clearing account has an unexplained balance
- Inventory and COGS are inaccurate
- Several payment gateways are used
- The business sells through Shopify, Amazon or Walmart
- Sales-tax liabilities cannot be reconciled
- Monthly financial statements are consistently late
- Management cannot determine true product or channel profitability
AYBE Finance provides ecommerce accounting services for Shopify, Amazon and multichannel businesses across the US. We help reconcile sales channels and payouts, clean up QuickBooks Online, track inventory and COGS, and produce reliable financial reports.
Frequently Asked Questions
Are Shopify payouts considered revenue?
No. A Shopify payout is a net transfer to the bank that may include sales, fees, refunds, chargebacks and adjustments. The underlying components should be recorded appropriately.
Why doesn’t my Shopify payout match my sales?
The payout may differ because of processing fees, refunds, chargebacks, reserves, adjustments, taxes, payout timing or transactions processed through another payment gateway.
What is a Shopify clearing account?
A Shopify clearing account is a temporary account used to record funds processed by Shopify before they are transferred to the business bank account.
Should Shopify fees be recorded separately?
Yes. Recording payment-processing fees separately provides more accurate revenue, expense and profitability reporting.
Can QuickBooks Online automatically reconcile Shopify payouts?
Integrations can automate parts of the process, but account mappings, payout matching and clearing balances should still be reviewed regularly.
How often should Shopify payouts be reconciled?
Businesses should generally complete the reconciliation monthly. High-volume stores may need daily or weekly monitoring.
Get Clear, Reliable Shopify Financials
Shopify payout reconciliation is not simply a matter of matching deposits. Accurate accounting requires sales, taxes, refunds, fees, chargebacks and timing differences to be recorded separately and reconciled to both Shopify and the bank.
If your Shopify deposits do not match QuickBooks or you are unsure whether your ecommerce reports are accurate, AYBE Finance can help.
