Shopify QuickBooks Integration: How to Connect and Sync Your Store (2026 Guide)

Running a Shopify store means every sale, refund, fee, and payout needs to show up accurately in your books. Whether you use QuickBooks Online yourself or work with an accountant who does, the Shopify QuickBooks integration question comes up early — and the wrong answer costs real time every month.

There are three ways to connect Shopify to QuickBooks: recording transactions manually by building journal entries from your payout reports, using Shopify's limited built-in CSV export, or automating the sync so every payout creates a balanced journal entry without any manual work. This guide covers all three methods in detail — including step-by-step instructions for the manual approach — so you can choose the right setup for your store.

Why You Need to Connect Shopify to QuickBooks

Shopify and QuickBooks Online are separate systems. Shopify processes your orders, collects payments, and deducts its fees before depositing a net payout to your bank. QuickBooks tracks your income, expenses, and cash flow. Neither one knows what the other is doing.

Without a connection between the two, your QuickBooks records show bank deposits with no context — no split between revenue, fees, and refunds, no expense categorization, and no way to generate an accurate profit and loss statement. This creates problems at tax time (your accountant can't reconcile the numbers), during bookkeeping cleanup (every deposit has to be manually researched), and whenever you need to understand your actual margins.

The IRS expects you to report gross revenue, not net deposits. Recording Shopify payouts as lump-sum income means you're understating both revenue and expenses simultaneously — a category of bookkeeping error that distorts your P&L and can raise flags during an audit.

Method 1: How to Record Shopify Sales in QuickBooks Manually

Manual recording gives you full control over every journal entry. It's the right approach if you want to verify every line yourself, your store processes fewer than 50–75 orders per month, or you're a bookkeeper learning the Shopify data structure for the first time.

Step 1: Download Your Shopify Payout Report

1. Log in to your Shopify admin
2. Navigate to Finances > Payouts (or Settings > Payments > Payouts depending on your Shopify version)
3. Click the payout you want to record
4. Click Download CSV — this exports a transaction-level breakdown of everything included in that payout

The CSV includes individual rows for each order, refund, and fee within the payout period. This is different from the orders export — the payout CSV is scoped to the specific settlement that generated your bank deposit.

Step 2: Group Transactions by Category

Open the CSV in Excel or Google Sheets and sort by transaction type. The main transaction types you'll see, and how to categorize each in QuickBooks:

Transaction Type	What It Is	Accounting Treatment
Sale	Gross revenue from orders	Credit: Sales Revenue
Shipping collected	Shipping charged to buyers	Credit: Shipping Revenue
Refund	Customer refund amounts	Debit: Sales Returns & Allowances
Transaction fee	Shopify's per-transaction fee (0.5–2%)	Debit: Payment Processing Fees
Processing fee	Shopify Payments card processing rate	Debit: Payment Processing Fees
Chargeback	Lost dispute amounts	Debit: Payment Processing Fees
Adjustment	One-time corrections from Shopify	Debit or Credit as applicable
Payout	Net transfer to your bank	Debit: Bank Account

Sum each category across all rows. These totals become the line items in your journal entry.

Step 3: Build the Journal Entry in QuickBooks

In QuickBooks Online, go to + New > Journal Entry. Set the date to the payout deposit date — the date the money arrived in your bank account.

Here's an example of a balanced journal entry for a $4,247.83 payout:

Account	Debit	Credit
Checking Account	$4,247.83
Sales Returns & Allowances	$312.00
Payment Processing Fees	$189.17
Shopify Subscription Fees	$29.00
Sales Revenue		$4,568.00
Shipping Revenue		$210.00
Totals	$4,778.00	$4,778.00

Shopify deducted fees ($218.17 total) and refunds ($312.00) from gross sales ($4,778.00), resulting in a net payout of $4,247.83. Your bank account gets debited for the actual deposit amount, while the expense and revenue accounts tell the complete story.

Step 4: Verify the Balance

A properly built journal entry must balance — total debits must equal total credits. If yours doesn't balance, common culprits include:

• Missed fee line: Shopify occasionally adds new fee types. Check for Shopify Capital repayments, shipping label costs, or app subscription fees deducted at payout
• Rounding error: Sum your CSV amounts in the spreadsheet before rounding to cents
• Separate chargeback fee: Chargebacks appear as a reversal line plus a separate dispute fee line — both need to be captured
• Payout hold: If Shopify placed a reserve on part of your funds, the held amount won't appear as a payout line until it's released

Once your entry balances, save it in QuickBooks. The bank debit amount should match your bank statement deposit exactly.

Step 5: Reconcile in QuickBooks

After entering the journal entry, run the bank reconciliation in QuickBooks (Accounting > Reconcile) and match the bank line of your journal entry to the corresponding deposit in your bank feed. This confirms the entry is correctly recorded and prevents double-counting.

This manual process takes 20–45 minutes per payout. With daily payouts from Shopify, that adds up quickly. For stores processing more than 75 orders per month, the time cost of manual entry typically justifies an automated Shopify QuickBooks integration.

Method 2: Using Shopify's Built-In QuickBooks Export

Shopify has a built-in option to export order data in IIF format (Intuit Interchange Format), which QuickBooks Desktop can import. This is different from the payout CSV — it covers order-level data, not payout-level settlement data.

How to Use It

1. In Shopify admin, go to Orders
2. Select the orders you want to export
3. Click More actions > Export
4. Choose QuickBooks as the export format
5. Import the IIF file into QuickBooks Desktop via File > Utilities > Import > IIF Files

Why This Method Has Significant Limitations

It only works with QuickBooks Desktop, not QuickBooks Online. Most small businesses and accountants now use QBO, so this option won't apply to the majority of Shopify sellers.

Even for QuickBooks Desktop users, the built-in export has gaps:

• No fee mapping: Shopify transaction fees, Shopify Payments processing fees, and subscription costs are not included in the export
• No refund handling: Refund transactions don't export cleanly and require manual journal entries to reverse properly
• No payout reconciliation: The export is order-level, not payout-level, so you can't directly reconcile it against your bank deposits
• Manual process: You have to remember to export and import regularly — nothing happens automatically

For QBO users specifically, Method 2 isn't viable. You'll need Method 1 or Method 3.

Method 3: Automated Shopify-QuickBooks Integration (Recommended)

For stores processing more than 50–100 orders per month, automation is the practical answer. An automated Shopify QuickBooks integration reads your Shopify settlement data, categorizes every line item, and creates a balanced journal entry in QuickBooks — without any manual steps.

What an Automated Integration Handles

A proper Shopify QuickBooks sync should process every component of your payout:

• Gross sales revenue — all order revenue during the payout period
• Shipping collected — buyer-paid shipping, recorded separately from product revenue
• Shopify transaction fees — the per-transaction percentage charged when using a third-party payment processor
• Shopify Payments processing fees — the card processing rate for Shopify Payments users
• Shopify subscription fees — monthly or annual plan cost, when deducted from payout
• Refunds — full and partial refunds, reversed correctly as contra-revenue entries
• Chargebacks — disputed transactions and associated dispute fees
• Sales tax — tax collected on behalf of customers, mapped to tax liability accounts in QBO
• Net payout — the actual deposit amount posted to your bank account in QuickBooks
• Adjustments — one-time corrections, Shopify Capital repayments, and other non-standard lines

The output is a balanced journal entry. Debits equal credits. The bank line matches the bank deposit. Your accountant can review a clean, categorized record instead of an unexplained deposit.

How Automated Shopify QuickBooks Sync Works

1. Connect your Shopify store — authorize the integration to read your Shopify payout and settlement data via the Shopify API
2. Connect QuickBooks Online — authorize the tool to create journal entries in your QBO account
3. Map your accounts — specify which QuickBooks accounts to use for each transaction type (most tools provide sensible defaults you can customize)
4. Let it run — when each Shopify payout settles, the integration creates the corresponding journal entry in QuickBooks within minutes

No manual downloads. No spreadsheet formulas. No risk of missing a fee category or miscounting a refund.

SettleBooks for Shopify-QuickBooks Integration

SettleBooks is built specifically for e-commerce settlement data. Upload your Shopify settlement report and get a balanced, reviewed journal entry in under 60 seconds — ready to import directly into QuickBooks, Xero, or Sage.

SettleBooks understands the structure of Shopify payout reports at the line-item level — every fee code, every refund type, every payout component — and maps them to the right QuickBooks accounts based on your configuration. Try SettleBooks free — no credit card required.

How to Categorize Shopify Sales in QuickBooks

Regardless of whether you record manually or use an automated Shopify QuickBooks integration, you need a clear categorization scheme in your QuickBooks chart of accounts. Here's how to handle each major transaction type.

Revenue Categories

Sales Revenue (Income): All gross product revenue from Shopify orders. Some businesses create sub-accounts by product category or channel, but a single Sales account works for most stores. Record gross revenue — before Shopify deducts fees — so your P&L accurately shows both your income and your cost of accepting payments.

Shipping Revenue (Income): Shipping amounts charged to customers, tracked separately from product revenue. This lets you see whether your shipping rates cover your actual label costs. If customers pay $8.99 for shipping and your labels cost $6.50, you're generating margin. If the reverse is true, it's a cost that deserves visibility.

Gift Card Revenue: Gift card redemptions are recognized as revenue when the card is used, not when it's purchased. Gift card sales create a liability (deferred revenue), which is cleared when the card is redeemed.

Shopify Fee Categories

Fee Type	Recommended QuickBooks Account
Shopify transaction fee (0.5–2% of order)	Payment Processing Fees
Shopify Payments processing (2.4–2.9% + 30¢)	Payment Processing Fees
Shopify monthly/annual subscription	Software Subscriptions
Shopify shipping labels	Postage & Delivery
Shopify Capital repayment	Loan Repayment
Chargeback fee	Payment Processing Fees

Group transaction fees and processing fees together — they represent the same type of cost. Keep subscription fees in a separate account for clean software cost visibility.

How to Categorize Shopify Sales Tax in QuickBooks

In marketplace facilitator states — now including California, Texas, New York, Florida, and most other US states — Shopify collects and remits sales tax on your behalf. You never receive this money; it flows through Shopify directly to the state tax authority.

For marketplace facilitator states: map Shopify tax lines to a Sales Tax Collected pass-through account or simply exclude them from your journal entry entirely. The money is never yours, so it shouldn't inflate your revenue or your liability.

In the few remaining states where you're responsible for collecting and remitting yourself: track the liability in QuickBooks' sales tax center and remit directly to the state on your filing schedule.

Refunds and Returns

Use a Sales Returns & Allowances contra-revenue account to track refunds separately from your gross revenue. This gives you immediate visibility into your refund rate as a percentage of gross sales — useful data for pricing decisions and policy reviews.

Partial refunds require the same treatment: reduce the revenue line by the refunded product amount, and reverse the applicable fee portions if they were also refunded by Shopify.

How to Record Shopify Payouts in QuickBooks

The most common source of confusion in Shopify bookkeeping: Shopify doesn't pay you once per order. Sales accumulate and pay out on a rolling schedule — every business day on Shopify Plus, every 3 business days on standard plans, though timing varies by country and account status.

Each payout in your bank account represents multiple orders, sometimes spanning several days. You're reconciling a settlement, not a single transaction.

The Right Method

Don't record the Shopify payout as a simple bank deposit with no line items. If you import your bank feed and categorize the lump sum as income, you're understating revenue (because fees and refunds were already deducted) and missing all expense categorization. Your P&L will be wrong.

Do create a journal entry with: - Gross revenue credited to your income accounts - Fees debited to expense accounts - Refunds debited to Sales Returns & Allowances - The net payout amount debited to your bank account

The bank debit should match the actual deposit on your bank statement.

Choosing a Transaction Date

Use the payout deposit date as your journal entry date — this matches what appears on your bank statement and simplifies reconciliation and month-end close. If you're on accrual accounting and need revenue recognized on each order date, you'll need a more granular system that records individual orders rather than payout-level settlements.

Handling Payouts That Span Month-End

If a payout period straddles two months (e.g., a period running December 28 through January 3), you may need to split the entry to keep revenue in the correct accounting period for accurate monthly reporting. For most small stores using cash-basis or modified cash-basis accounting, using the payout date regardless of the order dates is an acceptable simplification.

Common Shopify QuickBooks Integration Errors (and How to Fix Them)

Duplicate Revenue from Double-Counting

Problem: Some approaches record revenue both at the order level (when each order is placed) and at the payout level (when the deposit is processed), counting the same sale twice.

Fix: Decide on one recording method — order-level or payout-level — and stick to it. SettleBooks and most settlement-based tools work at the payout/settlement level, which avoids this issue by design. If you're combining an order-level sync tool with manual payout recording, you'll need to reconcile carefully.

Shopify Fees Showing Up as Negative Revenue

Problem: Shopify fee amounts are negative numbers in the raw payout data. Some import processes or manual errors treat these as reductions to revenue instead of debits to expense accounts.

Fix: Shopify transaction fees and processing fees should always be debited to an expense account (Payment Processing Fees), not credited against Sales Revenue. Check your chart of accounts mapping and review any journal entries where fees appear on the credit side.

Sales Tax Mismatch Between Shopify and QuickBooks

Problem: The tax amounts in QuickBooks differ from what Shopify collected. This is especially common in marketplace facilitator states where Shopify handles remittance.

Fix: In marketplace facilitator states, Shopify's tax lines represent pass-through taxes you shouldn't record as your own tax liability. Map these to a clearing account or exclude them entirely — Shopify remits directly and you have no additional obligation. Only record tax liability for states where you collect and remit yourself.

Missing Fee Categories After a Shopify Update

Problem: Your journal entry doesn't balance because Shopify introduced a new fee type that wasn't in your mapping. Shopify Capital repayments, Shopify Balance transfers, and new app charges sometimes appear without warning.

Fix: Always verify your journal entry total against the actual payout amount. If there's a discrepancy, check the raw payout CSV for line items that weren't captured in your totals. SettleBooks flags unrecognized fee types before finalizing the entry so you can add them to your mapping.

Currency Conversion Differences for International Orders

Problem: Stores selling internationally receive orders in multiple currencies. Shopify converts to your home currency at payout, but QuickBooks may apply a different exchange rate, creating small discrepancies.

Fix: Use the Shopify payout amount in your home currency as the definitive figure in your journal entry. Shopify's converted amount is what actually hit your bank — that's the number QuickBooks should match.

Shopify QuickBooks Integration: Frequently Asked Questions

Does Shopify integrate with QuickBooks natively?

Shopify does not have a real-time, two-way native integration with QuickBooks Online. Shopify offers a limited QuickBooks Desktop IIF export for order data, but it doesn't cover fees, doesn't work with QBO, and requires manual triggering. Most businesses use a third-party tool or manual journal entries to connect Shopify to QuickBooks.

Is there a free Shopify QuickBooks integration?

Fully automated, real-time sync tools are typically paid ($30–$100/month depending on order volume). Manual entry is free but time-intensive. SettleBooks offers a free plan for low-volume stores — you can convert a limited number of settlement reports per month without a subscription. Useful for stores processing fewer than 10 payouts per month or for bookkeepers who want to verify their manual entries against an automated result.

How do I sync Shopify inventory with QuickBooks?

Inventory sync — tracking product quantities across both systems — is a different problem from accounting sync. SettleBooks handles the financial/accounting side: revenue, fees, refunds, and payouts. For inventory quantity sync between Shopify and QuickBooks, you need a dedicated inventory management integration.

Can QuickBooks Online connect to Shopify automatically?

QuickBooks Online's core product doesn't include a built-in Shopify connector. You can connect via apps listed in the QuickBooks App Store or through third-party tools built specifically for Shopify-QuickBooks sync. SettleBooks processes Shopify settlement reports and exports journal entries in QuickBooks-compatible formats that can be imported directly into QBO.

How often should I record Shopify payouts in QuickBooks?

Record each payout as a separate journal entry using the payout deposit date. If you're on daily payouts (Shopify Plus), that's one entry per business day — exactly the scenario where automation saves the most time. On standard Shopify plans with 3-business-day payouts, you'll create roughly 8–12 journal entries per month. With an automated Shopify QuickBooks integration, these entries are created without any manual input.

What's the difference between Shopify QuickBooks sync and Shopify QuickBooks integration?

These terms are used interchangeably. "Sync" often implies automatic, real-time data transfer. "Integration" is broader — it can mean anything from a manual export/import workflow to fully automated two-way sync. When evaluating tools, ask specifically whether the connection is automatic and whether it runs at each payout or requires you to trigger it manually.

---

Ready to automate your Shopify accounting? SettleBooks converts Shopify settlement reports into balanced journal entries for QuickBooks, Xero, or Sage in under 60 seconds. Try SettleBooks free — no credit card required.