Your accountant wants clean numbers: revenue, cost of goods, tax collected, fees and refunds, all landing in the right QuickBooks accounts. Typing that in from Shopify works for a handful of orders a week. Past that, a sync app saves hours and removes the copy-paste errors. The main decision is how much detail you actually need in QuickBooks.
Apps
These are the connectors merchants mention most when they ask us about accounting. Check each listing for current features and pricing, because they change often:
- Intuit's own QuickBooks app on the Shopify App Store. A sensible starting point for small stores.
- Synder. Can sync each order in detail or post daily summaries, and handles several sales channels and payment processors.
- A2X. Built around payouts: it posts summarized journal entries per Shopify payout so your bank deposits reconcile cleanly.
Summary sync or per-order sync?
This is the choice that matters most, and it's where most setups go wrong.
| Summary (per payout or per day) | Per order | |
|---|---|---|
| What lands in QuickBooks | One journal entry with totals for sales, tax, fees, refunds | One sales receipt or invoice per order, with line items |
| Bank reconciliation | Easy: entries match deposits | Harder: many orders per deposit |
| Per-variant sales in QuickBooks | No (use Shopify reports instead) | Yes, if products map to QuickBooks items |
| Best for | Most small and mid-size stores | Stores that manage inventory or job costing in QuickBooks |
Many accountants prefer summaries and pull product-level detail from Shopify's own reports. Ask yours before you pick an app.
What syncs
- Sales, split into product revenue, shipping income and discounts.
- Sales tax collected, posted to a tax liability account rather than revenue.
- Payment processing fees, posted as an expense so net revenue is correct.
- Refunds and adjustments.
- Products and variants as QuickBooks items, in per-order mode.
Setup
- Install the connector and authorize both Shopify and QuickBooks.
- Map accounts: sales income, shipping income, discounts, sales tax payable, merchant fees, and a clearing account for payouts.
- Choose summary or per-order mode.
- In per-order mode, map Shopify products to QuickBooks items by SKU. Unique, consistent SKUs make this painless; see our SKU naming strategy.
- Run a test sync for one week and compare totals against Shopify's finance reports.
- Reconcile monthly against your bank deposits.
COGS per variant
Open a variant and fill Cost per item. Shopify then reports gross margin by product and variant. A 2XL hoodie that costs you $4 more than a Medium should carry that higher cost, or the margin numbers mislead you.
Whether QuickBooks receives those costs depends on the connector and mode. Mode, many stores post COGS as a monthly journal entry from Shopify's reports. If you're working out what each product should earn, our POD profit margin guide walks through the math.
Personalization fees and add-ons
Personalized products add a wrinkle: the customer's name, font and photo aren't accounting data, but the fee for them is revenue.
With Print It My Way, the personalization details are saved on the order as line-item properties. The add-on fee (for example $5 for engraving or $0.50 per character) shows as its own cart line. To your accounting app that fee is just another line with an amount, so it syncs like any product sale. In per-order mode, map it to a QuickBooks item called "Personalization fee" so you can see how much that revenue adds up to each month.
The text the customer typed doesn't need to reach QuickBooks. It stays on the Shopify order for fulfillment. Our line-item properties guide explains where that data lives.
Sales tax on options
Add-on fees are usually taxed the same way as the product they're attached to, but rules vary by state and country. Make sure the add-on line uses the right tax setting in Shopify before you sync, or the error carries straight into your books. Our article on tax considerations for add-on pricing covers the common cases.
Refunds on personalized orders
Partial refunds are common with custom products, for example refunding the engraving fee when an engraving is late. Check that your connector posts partial refunds against the right lines. Our guide to returns and refunds for personalized products covers the policy side.
Common mistakes
- Posting gross payouts as revenue, so fees and refunds disappear.
- Counting sales tax as income.
- Running two connectors at once and double-counting every sale.
- Leaving Cost per item blank on new variants, so margins look better than they are.
Frequently asked questions
How to sync Shopify variants with QuickBooks?
Install a connector such as Intuit's QuickBooks app, Synder or A2X, map your accounts, and choose summary or per-order sync. Per-variant detail in QuickBooks needs per-order mode with products mapped to QuickBooks items by SKU.
Does QuickBooks track per-variant sales?
Only if your connector syncs orders in detail and each variant maps to a QuickBooks item. Mode, use Shopify's reports for per-variant sales.
How to set variant COGS in Shopify?
Open the variant and fill the Cost per item field. Shopify then reports margin by product and variant.
Sales tax sync?
Yes. A correctly mapped connector posts the tax collected to a sales tax liability account, not to revenue.
Real-time or daily sync?
It depends on the app. Per-payout or daily summaries are easiest to reconcile, while per-order sync suits stores that manage inventory in QuickBooks.
Payment fees deducted?
They should be posted as an expense, with the gross sale recorded as revenue. That keeps net revenue correct and makes payouts match your bank.
Best QuickBooks app for Shopify + personalization?
Any good connector works, because personalization fees appear as normal order lines with an amount. The personalization text stays on the Shopify order as line-item properties and doesn't need to sync.
Related reading
Sources & further reading
Primary sources referenced in this article. We link to official platform documentation and standards bodies rather than secondary summaries so you can verify claims directly.
- Shopify Help Center: Product variants
- Shopify.dev: Product variant limits
- Shopify Help Center: Line item properties (customization)
Try it free on Shopify
Print It My Way's permanent Free plan includes live preview, custom options, and Cart Transform pricing.
Install Print It My Way