Linnworks QuickBooks Integration: Step-by-Step Setup Guide (2026)
Linnworks processes orders from Amazon, eBay, Shopify, and every other channel — but each channel pays out on a different schedule with a different fee structure, and none of them reconcile cleanly in QuickBooks without a proper mapping. This guide covers the correct chart of accounts setup, step-by-step SyncTools connection, and how to reconcile Linnworks channel payouts automatically in QuickBooks.
Linnworks aggregates orders from Amazon, eBay, Shopify, Etsy, OnBuy, and every other channel you sell on into a single management layer. That centralisation makes Linnworks powerful as an OMS — and it creates a specific bookkeeping problem in QuickBooks. Every channel pays out on a different schedule with a different fee structure: Amazon’s referral and FBA fees settle every 14 days in a net payment that bundles multiple fee types. eBay Managed Payments deducts final value fees, promoted listing fees, and refunds before depositing every 1–2 business days. Shopify Payments settles daily. Recording those net deposits as income gives you wrong books — understated revenue, invisible fees, and a P&L that can’t show you which channels are actually profitable.
TL;DR: Linnworks has no native QuickBooks Online integration. SyncTools connects Linnworks to QuickBooks Online through the Linnworks App Store — automatically syncing multichannel sales orders, purchase orders, marketplace fees, refunds, and channel payouts to the correct accounts. Channel-level P&Ls via QuickBooks classes, grouped invoicing for high-volume stores, and automated payout reconciliation. Setup takes under 25 minutes.
Using Xero instead of QuickBooks? See the Linnworks Xero integration guide.
Related: Linnworks accounting guide — chart of accounts, channel fee structures, and multichannel reconciliation principles before connecting any integration.
Why Linnworks Sellers Need QuickBooks Integration
Linnworks is an order management and inventory system, not an accounting platform. It tracks stock quantities, order statuses, and channel listings — but it does not post to a general ledger, produce financial statements, or handle tax filings. Every Linnworks seller needs a separate accounting platform, and QuickBooks Online holds approximately 62% of the US small business accounting market (ElectroIQ, 2025).
The accounting problem specific to Linnworks multichannel sellers has three layers:
Different fee structures per channel. Amazon charges referral fees (6–15% depending on category) plus FBA pick-and-pack fees plus storage fees — all deducted separately across different settlement reports. eBay charges a final value fee (typically 12.9% on most categories) plus optional promoted listing fees before the Managed Payments deposit. Shopify and direct channels charge gateway processing fees (typically 2.9% + $0.30 per transaction). Pooling these into a single “Marketplace Fees” account in QuickBooks makes it impossible to know whether margin compression is coming from Amazon’s fee structure, eBay’s final value fees, or payment processing costs.
Different payout schedules per channel. Amazon settles every 14 days. eBay Managed Payments settles every 1–2 business days. Shopify Payments settles daily. If you record the deposit as income when it hits your bank rather than when the order ships, your monthly P&L is driven by payout timing rather than actual sales performance — a distortion that compounds when you’re managing four or five channels.
Multichannel inventory COGS. Linnworks tracks stock quantities in real time across multiple warehouses and channels, decrementing inventory as orders fulfil. But quantity tracking does not automatically update COGS in QuickBooks. Without connecting purchase orders from Linnworks to QuickBooks as bills — with actual unit costs per SKU — your gross margin figures are estimates, not facts.
SyncTools observation: The most common Linnworks bookkeeping failure is treating the Linnworks order total as QuickBooks revenue without adjusting for channel fees. Amazon’s referral and FBA fees alone reduce net proceeds by 25–40% on mid-priced products — but those fees don’t appear in Linnworks’s order view, only in Seller Central’s settlement reports. Recording the Linnworks order total as income overstates revenue by every dollar in fees.
What Data Gets Synced: Orders, Fees, Purchase Orders, and Payouts
Understanding exactly what a Linnworks QuickBooks integration moves between the two platforms is the first step to configuring it correctly.
| Linnworks Transaction Type | QuickBooks Account | Notes |
|---|---|---|
| Sales order (per channel) | Income: [Channel] Sales | Gross value before fees |
| Amazon referral fee | Expense: Amazon Referral Fees | 6–15% by category |
| Amazon FBA fee | Expense: Amazon FBA Fees | Pick, pack, ship, storage |
| eBay final value fee | Expense: eBay Final Value Fees | ~12.9% on most categories |
| Payment gateway fee | Expense: Payment Processing Fees | Shopify, direct channels |
| Purchase order received | Bill: Inventory Asset | At actual unit cost per SKU |
| Refund / credit note | Sales Returns and Allowances | Linked to original transaction |
| Sales tax collected | Current Liability: Sales Tax Payable | Marketplace facilitator or self-collected |
| Channel payout deposit | Bank: [Channel] Clearing Account | Net amount after fee deductions |
What does not sync:
- Customer names, email addresses, and shipping addresses (Linnworks CRM data)
- Linnworks analytics (pick rates, despatch times, channel conversion rates)
- Stock quantity movements — COGS posts when orders fulfil, but live inventory counts stay in Linnworks
- eBay or Amazon listing data (titles, images, categories)
Related: multi-channel inventory accounting — how to handle COGS tracking, channel-level P&L, and inventory valuation when selling across multiple platforms.
Setting Up Your QuickBooks Chart of Accounts for Linnworks
Build the right account structure in QuickBooks before connecting SyncTools. Retrofitting a chart of accounts after months of synced data is significantly more work than setting it up correctly at the start.
Recommended Linnworks Accounts in QuickBooks
Income accounts — one per active channel:
- Amazon Sales — gross product sales from Amazon, before referral fees and FBA fees
- eBay Sales — gross product sales from eBay, before final value fees
- Shopify Sales — gross product sales from your Shopify store
- Other Channel Sales — Etsy, OnBuy, or any additional channels
Separate income accounts per channel are not optional if you want meaningful P&Ls. Consolidating all Linnworks revenue into one income line makes it structurally impossible to compare channel profitability or track how each channel’s margin evolves over time.
Expense accounts — one per fee type:
- Amazon FBA Fees — pick, pack, ship, and monthly storage fees
- Amazon Referral Fees — percentage-based commission per Amazon order (6–15% by category)
- eBay Final Value Fees — percentage-based fee per eBay sale (~12.9%)
- Payment Processing Fees — gateway fees for Shopify, direct website, or other non-marketplace channels
- Shipping and Fulfilment Costs — carrier costs for self-fulfilled orders not using Amazon FBA
Liability account:
- Sales Tax Payable — tax collected from buyers but not yet remitted. For Amazon and eBay orders in states where they are marketplace facilitators, these platforms collect and remit sales tax directly. Map their collected tax to this liability account — it is not your income.
Contra-revenue account:
- Sales Returns and Allowances — refunds across all channels. Recording refunds as contra-revenue rather than negative sales preserves your gross revenue figure for trend analysis and makes refund rate by channel visible.
Clearing accounts — bank type, one per major channel:
- Amazon Clearing — posts all Amazon transaction components at gross value as they occur; zeroes out when the Amazon 14-day settlement hits your bank
- eBay Clearing — same structure for eBay Managed Payments deposits
- Shopify Clearing — for Shopify Payments daily payouts
These clearing accounts are what enable one-click reconciliation when each settlement arrives in your QuickBooks bank feed.
How to Connect Linnworks to QuickBooks with SyncTools
Step 1: Set Up Your Chart of Accounts in QuickBooks
Create the accounts listed above in QuickBooks before you connect SyncTools. Go to Chart of Accounts → New and add each account with the correct type (Income, Expense, Other Current Liability, Contra Income, Bank). The channel clearing accounts must be set as Bank type — this is what enables QuickBooks’ bank reconciliation module to match settlement deposits to them.
Step 2: Install SyncTools from the Linnworks App Store
- In Linnworks, navigate to Apps → App Store.
- Search for SyncTools QuickBooks Online connector and click Install.
- SyncTools’ onboarding team receives a notification and will contact you to help complete configuration — but most sellers can self-configure from the SyncTools dashboard.
Alternatively, start from SyncTools directly at app.synctools.io, navigate to Add Integration, and select Linnworks. Authorize via Linnworks OAuth — SyncTools reads your channels, order sources, and fulfilment locations automatically.
Step 3: Connect QuickBooks Online to SyncTools
- In SyncTools, click Add Accounting System and select QuickBooks Online.
- Click Connect — you’ll be redirected to Intuit’s OAuth authorization page.
- Sign in to QuickBooks Online and grant SyncTools access to your transactions, chart of accounts, tax codes, and bank feeds.
- SyncTools reads your existing chart of accounts and pre-populates a recommended account mapping for Linnworks transaction types.
No API keys or developer credentials required for either Linnworks or QuickBooks.
Step 4: Map Linnworks Channels and Transaction Types to QuickBooks
In the SyncTools account mapping screen, assign each Linnworks source and transaction type to the correct QuickBooks account. Work through each row:
Channel income mapping:
- Map Amazon gross sales → Amazon Sales income account
- Map eBay gross sales → eBay Sales income account
- Map Shopify gross sales → Shopify Sales income account
- Map each additional channel → its dedicated income account
Fee expense mapping:
- Map Amazon FBA fees → Amazon FBA Fees expense
- Map Amazon referral fees → Amazon Referral Fees expense
- Map eBay final value fees → eBay Final Value Fees expense
- Map payment gateway fees → Payment Processing Fees expense
Other transaction mapping:
- Map refunds and credit notes → Sales Returns and Allowances
- Map sales tax collected → Sales Tax Payable liability (critical: not income)
- Map payout clearing → the matching channel clearing account (Amazon Clearing, eBay Clearing, etc.)
QuickBooks classes: In the same mapping screen, assign each Linnworks source to a QuickBooks class. This enables per-channel P&L reports in QuickBooks — filtering the P&L by class shows you revenue, fees, and net margin for Amazon vs. eBay vs. Shopify independently.
Tax handling note: For Amazon and eBay transactions in US states where they are marketplace facilitators, these platforms collect and remit sales tax directly to state authorities. SyncTools maps this to a pass-through clearing account or your Sales Tax Payable liability — confirming it does not inflate your QuickBooks income. For UK VAT-registered sellers, SyncTools applies the correct QuickBooks tax rate per transaction type.
Step 5: Configure Sync Settings and Run Your First Sync
Sync mode:
- Individual invoice sync — one QuickBooks invoice per Linnworks order. Best for lower-volume stores where you want transaction-level detail in QuickBooks.
- Grouped invoice sync — one daily invoice per channel, bearing the channel name. Recommended for stores processing more than 6,000 orders per month. Keeps QuickBooks clean and prevents hitting transaction limits on lower QuickBooks plans.
Grouping can be done by subsource, country, or multiple combinations (source + subsource + country) depending on how granular you need your QuickBooks reporting.
Historical backfill: On Standard and Plus plans, SyncTools supports historical backfill of Linnworks transaction data — useful if you’re switching from manual bookkeeping or a different sync tool mid-year.
Click Sync Now. Open QuickBooks and verify:
- Each channel’s gross sales appear in the correct income account
- Each fee type (FBA, referral, final value, gateway) appears as a separate expense line
- Sales tax is in the Sales Tax Payable liability account, not income
- Channel clearing account balances match your next expected settlement amounts from each platform
Payout Reconciliation: How Channel Clearing Accounts Work
Amazon pays out every 14 days. eBay Managed Payments pays out every 1–2 business days. Shopify Payments pays out daily. Each settlement is a net figure — gross sales for the period minus all fee deductions minus any refunds processed. QuickBooks sees the net bank deposit; your P&L needs the gross components.
Concrete example — Amazon 14-day settlement:
Your Amazon US store earns $8,000 in gross sales during the settlement period. Amazon deducts:
- $960 in referral fees (12% average across categories)
- $720 in FBA pick, pack, and ship fees ($9 average per unit at 80 units)
- $120 in storage fees (monthly average for your FBA inventory)
- $160 in refunds (two customer returns processed during the period)
Net Amazon settlement deposit: $6,040
What SyncTools posts to QuickBooks as transactions occur:
- $8,000 → Amazon Sales (income)
- $960 → Amazon Referral Fees (expense)
- $720 → Amazon FBA Fees (expense)
- $120 → Amazon Storage Fees (expense)
- $160 → Sales Returns and Allowances (contra-revenue)
Amazon Clearing account balance: $6,040
In QuickBooks bank feed: $6,040 appears from Amazon. You click Match — QuickBooks matches it to the Amazon Clearing account showing the same $6,040. Reconciliation complete.
Your QuickBooks P&L shows:
- Revenue: $8,000 gross Amazon sales ($160 refund contra, so net $7,840)
- Expenses: $1,800 total Amazon fees (broken out by category)
- Net from Amazon: $6,040 before COGS and other operating costs
Without automation, you would extract each fee line from the Amazon Settlement Report in Seller Central, create a split transaction or journal entry in QuickBooks, then match the bank deposit manually — for every 14-day settlement cycle, across every channel.
Channel-Level P&Ls in QuickBooks: Using Classes for Linnworks
QuickBooks classes are the mechanism that gives Linnworks multichannel sellers per-channel income statements without running multiple QuickBooks accounts or maintaining separate spreadsheets.
The structure SyncTools sets up:
- Every Amazon transaction is tagged with the Amazon class
- Every eBay transaction is tagged with the eBay class
- Every Shopify transaction is tagged with the Shopify class
In QuickBooks, running a Profit & Loss by Class report shows you revenue, cost of revenue, and gross margin for each channel side by side. This answers the questions that matter at scale:
- Is my eBay channel still profitable after the fee increase in March?
- Is my Amazon gross margin improving as I optimise my product mix for lower-referral-fee categories?
- Which channels are growing faster than their fee burden?
Without class mapping, all Linnworks revenue and expenses pool into consolidated accounts — and those questions become impossible to answer from QuickBooks data alone.
Sales Tax Handling for Linnworks Sellers Using QuickBooks
Linnworks multichannel sellers face three distinct sales tax scenarios, and each requires a different QuickBooks mapping.
Marketplace Facilitator Tax (Amazon, eBay)
Amazon and eBay are marketplace facilitators for sales tax in all US states that have one. They collect and remit sales tax on eligible transactions directly to state tax authorities — the tax appears in your Linnworks order data and in settlement reports, but it is not your revenue and creates no tax remittance obligation for you (for those transactions).
SyncTools maps marketplace-collected tax to a pass-through liability account in QuickBooks — keeping it out of your income, since eBay or Amazon already remitted it. If you run economic nexus analysis, you still count these sales toward your nexus threshold; you just don’t remit the tax yourself.
Self-Collected Sales Tax (Shopify, Direct Channels)
For sales through your own Shopify store or direct website, you may be collecting sales tax and remitting it yourself (depending on your nexus states). SyncTools maps Shopify-collected tax to your Sales Tax Payable liability account in QuickBooks — accurately recording the liability until you remit to each state.
UK VAT
For UK VAT-registered Linnworks sellers, SyncTools applies the correct QuickBooks tax code per transaction type. Amazon’s cross-border VAT (where Amazon is the deemed supplier) maps to a pass-through account. Your own VAT on domestic UK sales maps to VAT Control liability with the correct 20% Standard Rate code, so your VAT return pulls from QuickBooks data automatically.
Connecting to the Linnworks QuickBooks Integration Page
For a technical feature overview, supported data types, sync frequency options, individual vs. grouped invoice modes, and plan availability, see the Linnworks QuickBooks integration page. The integration page covers channel class mapping, subsource filtering, payout reconciliation, and historical backfill details by plan.
Common Linnworks QuickBooks Setup Mistakes
Mistake 1 — Recording net channel payouts as income. The Amazon settlement, eBay payout, and Shopify payout are all net figures after fee deductions. Recording them as income understates gross revenue by the full fee amount and hides every expense category. Always record gross sales as income and fees as expenses — even though the bank deposit is the net.
Mistake 2 — One income account for all channels. Consolidating Amazon, eBay, and Shopify sales into a single “eCommerce Sales” income account makes per-channel profitability analysis impossible. Three minutes of chart of accounts setup saves months of reporting workarounds.
Mistake 3 — Mapping sales tax to income. For marketplace-collected tax (Amazon, eBay as facilitators), mapping the tax line to an income account overstates revenue by the full tax amount — often 7–10% of gross sales. Set it to a liability account.
Mistake 4 — Skipping COGS from purchase orders. Linnworks tracks inventory quantities, but those quantities need associated purchase costs in QuickBooks to calculate gross margin accurately. Record purchase orders from Linnworks as bills in QuickBooks at the actual unit cost per SKU. SyncTools automates this as part of the purchase order sync.
Mistake 5 — Not enabling grouped invoices at volume. If you process 200+ orders per day and have individual sync enabled, QuickBooks can accumulate thousands of invoices per month — slowing performance and creating noise in your accounts receivable. Switch to grouped invoice sync (daily summary per channel) before you hit that threshold.
Frequently Asked Questions
Does Linnworks integrate with QuickBooks?
Yes. Linnworks integrates with QuickBooks Online via SyncTools, which installs directly from the Linnworks App Store. SyncTools automatically syncs Linnworks sales orders, purchase orders, marketplace fees, refunds, and multichannel payouts into QuickBooks without manual CSV exports or spreadsheet intermediaries. Setup takes under 25 minutes and requires no developer access or API keys.
How do I connect Linnworks to QuickBooks Online?
Install the SyncTools connector from Linnworks → Apps → App Store, then connect QuickBooks Online via the Intuit OAuth flow in the SyncTools dashboard. Map each Linnworks channel and transaction type to the correct QuickBooks account, choose individual or grouped invoice sync, and click Sync Now. SyncTools’ onboarding team also provides assisted setup for sellers who prefer a guided walkthrough.
What Linnworks fees sync to QuickBooks?
SyncTools syncs all major Linnworks channel fee types to separate QuickBooks expense accounts: Amazon referral fees (6–15% by category), Amazon FBA pick/pack/ship fees, Amazon storage fees, eBay final value fees (~12.9%), and payment gateway processing fees for Shopify and direct channels. Each fee maps to its own account — not a single “Marketplace Fees” catch-all — so your QuickBooks P&L shows the cost structure of each channel separately.
How does Linnworks payout reconciliation work in QuickBooks?
SyncTools uses a clearing account per channel — a bank-type account in QuickBooks that acts as a staging ledger for each channel’s transactions. Every Linnworks sales order, fee, and refund posts to the appropriate clearing account at gross value as it occurs. When Amazon, eBay, or Shopify deposits the net settlement to your bank, the clearing account balance matches the deposit — one-click reconciliation per payout cycle without manual journal entries.
Can I see per-channel P&L in QuickBooks from Linnworks data?
Yes. SyncTools maps each Linnworks source (Amazon, eBay, Shopify, etc.) to a QuickBooks class. Running a Profit & Loss by Class report in QuickBooks shows revenue, fee expenses, and gross margin for each channel independently — letting you compare channel profitability and track how each channel’s economics evolve over time.
Does Linnworks QuickBooks sync support grouped invoices for high-volume sellers?
Yes. For stores processing more than 6,000 orders per month, SyncTools consolidates Linnworks orders into a single grouped invoice per channel per day in QuickBooks. Grouping reduces QuickBooks transaction volume, prevents hitting the invoice limits on lower QuickBooks plan tiers, and keeps your accounts receivable clean — while preserving full transaction-level detail in Linnworks.
Does SyncTools sync Linnworks purchase orders to QuickBooks?
Yes. SyncTools syncs delivered purchase orders from Linnworks as bills in QuickBooks, with each line item mapped to the correct inventory asset account at the actual unit cost on the PO. When orders ship, SyncTools posts the corresponding COGS entry at the SKU purchase cost — giving you accurate gross margin figures rather than estimates.
Ready to connect Linnworks to QuickBooks Online? Start your free SyncTools trial — installation from the Linnworks App Store takes under five minutes, and full configuration is typically complete within 25 minutes.
Using Xero instead of QuickBooks? See how to connect Linnworks to Xero.
Related guides:
- Linnworks accounting guide — chart of accounts, channel fee structures, payout timing, and multichannel reconciliation principles
- Linnworks QuickBooks integration page — feature overview, sync options, and plan details
- Multi-channel inventory accounting — COGS tracking and inventory valuation across multiple Linnworks channels
- QuickBooks automation for eCommerce — how to configure QuickBooks rules so Linnworks transactions post without manual review
- Amazon QuickBooks integration — deep dive on Amazon-specific fee accounting within a QuickBooks setup
- eBay QuickBooks integration — for Linnworks sellers who need eBay Managed Payments accounting detail
- eCommerce bookkeeping guide — accounting fundamentals behind every marketplace integration
See the integration page
Linnworks QuickBooks Connector
Ready to automate your accounting?
Connect Shopify, WooCommerce, or Linnworks to QuickBooks, Xero & more. Setup in minutes.