Quick Answer: How Do You Reconcile Shopify Payments in QuickBooks?
To reconcile Shopify Payments in QuickBooks Online, export your Shopify payout transactions, record gross sales and applicable liabilities, categorize fees and refunds, and match the resulting net payout to your bank deposit. A Shopify-compatible accounting connector can automate much of this process.
Important: Shopify Payments deposits are not the same as sales revenue. Shopify deducts processing fees and other adjustments before transferring funds to your bank.
Why Shopify Payments Reconciliation Matters
Shopify stores often process hundreds or thousands of orders, but receive fewer bank deposits. One payout may contain several orders, refunds, fees, chargebacks, and other adjustments.
If you record the deposit as sales income without accounting for those components, your books can misstate revenue, expenses, sales tax liabilities, and profit.
Accurate reconciliation helps you prepare financial statements, evaluate cash flow, and maintain documentation for business tax returns.
Example: Understanding a Shopify Payout
| Transaction | Amount |
|---|---|
| Customer payments collected, including sales tax | $10,000 |
| Refunds | −$400 |
| Payment processing fees | −$300 |
| Net bank payout | $9,300 |
This simplified example assumes no reserves or additional adjustments. The $9,300 deposit should not automatically become $9,300 in sales revenue. Sales tax must be separated from revenue, while refunds and fees require appropriate accounting entries.
Step-by-Step: Reconcile Shopify Payments in QuickBooks Online
Step 1: Download Shopify Payment Reports
Open your Shopify Admin and navigate to Finance → Payouts. Select an individual payout to examine its related transactions, charges, fees, refunds, and adjustments.
Export the payout transactions as a CSV file. Shopify also provides a Payments activity report under Finance → Documents for period-level reconciliation.
See Shopify's official payout reporting instructions.
Step 2: Connect Shopify to QuickBooks
QuickBooks Online supports the Shopify Connector by QuickBooks, which can import Shopify sales, refunds, fees, and payouts. Configure the correct bank account, sales items, tax mappings, and fee categories before approving transactions.
Other payout-based accounting tools may work for certain stores. Choose one primary workflow to prevent duplicate accounting entries.
Step 3: Configure Your Chart of Accounts
Your QuickBooks file needs appropriate accounts for Shopify Sales, Refunds, Payment Processing Fees, Sales Tax Payable, Gift Card Liabilities, and Shopify Payments Clearing or Undeposited Funds.
The clearing account tracks money Shopify holds before depositing it into your bank. Your exact setup depends on your connector and accounting method.
Step 4: Record Sales, Fees, and Refunds
Review imported Shopify transactions before posting them. Categorize sales, discounts, refunds, processing fees, and tax liabilities correctly.
If your integration records both individual sales and payout summaries, confirm it is not recording revenue twice. Some systems automatically create the corresponding fee expenses and payout transfers.
Step 5: Match the Shopify Deposit
In QuickBooks, open your bank transactions and locate the Shopify deposit. Match it against the recorded payout or transfer from the clearing account.
Check that the payout amount, bank amount, and reference details agree. Do not create a new sales transaction when the related sales and payout are already recorded.
Step 6: Reconcile Your Monthly Balances
At month-end, compare QuickBooks against Shopify's payout records and Payments activity report. Review outstanding balances, pending payouts, reserves, and transactions that have not yet reached your bank.
Timing differences are normal. Unexplained balances that accumulate month after month are not.
Common Shopify-to-QuickBooks Reconciliation Problems
| Problem | What to Check |
|---|---|
| Shopify deposit does not match | Refunds, fees, chargebacks, reserves, and payout adjustments |
| Revenue appears twice | Duplicate connector imports or deposits recorded as new sales |
| Sales tax included in income | Incorrect sales tax liability mapping |
| Clearing account never reaches the expected balance | Missing payouts, timing differences, or incorrectly categorized transfers |
| Orders and payouts differ | Different accounting dates, pending transactions, or outside payment processors |
Remember that PayPal and other external processors may deposit funds separately. Shopify Payments reports should not be expected to reconcile payments handled outside Shopify Payments.
Should You Automate Shopify Accounting?
Automation can reduce manual entry, but an integration is only as reliable as its configuration. Incorrect tax mapping, duplicated sales, mismatched refunds, and missing fees can still create inaccurate books.
The Online Seller CPA provides Shopify accounting and bookkeeping services, including QuickBooks setup, payout reconciliation, historical cleanup, and monthly financial reporting.
For additional guidance, review Intuit's Shopify Connector documentation.
FAQ: Shopify Payments and QuickBooks
Why don't Shopify payouts match sales?
Payouts reflect payment activity after applicable fees, refunds, adjustments, and timing differences. Sales reporting and bank deposits measure different things.
Can Shopify Payments sync automatically with QuickBooks?
Yes. The Shopify Connector by QuickBooks and compatible ecommerce accounting applications can import transactions, fees, and payouts. Configuration and review are still necessary.
Should Shopify processing fees be recorded as expenses?
Yes, qualifying payment processing fees should generally be categorized separately from sales revenue to provide accurate financial reporting.
How often should Shopify payouts be reconciled?
Monthly reconciliation is a practical minimum. High-volume merchants may benefit from weekly reviews to identify missing transactions and mismatched deposits sooner.
Stop Guessing About Your Shopify Profit
The Online Seller CPA helps Shopify businesses reconcile payouts, maintain accurate QuickBooks records, track inventory, and prepare tax-ready financial statements.
Book a Free Strategy Call →Explore our CPA Services for Shopify Stores.