Shopify QuickBooks integration for payout reconciliation

Connect Shopify to QuickBooks, import Shopify Payments payouts, and post reconciliation-ready sales, discounts, fees, refunds, taxes, and deposits into QuickBooks.

Import Shopify Payments payout summaries—not every order—to keep QuickBooks cleaner.

Separate sales, discounts, refunds, fees, shipping, and taxes around the net deposit.

Review the summary before posting, then match it to the Shopify bank deposit.

14-day free trial

Set up in minutes

Shopify

QuickBooks

  • Sales
  • Discounts
Shopify Sales
  • Shipping
Shopify Shipping
  • Refunds
Shopify Refunds
  • Payment fees
Shopify Fees
  • Tax
Shopify Sales Tax Collected
Default account names from Quick Setup. You can change any mapping.

The accounting model

A payout summary, not an order-by-order mirror

Taxomate starts with the Shopify Payments payout, organizes the activity behind it into a mapped QuickBooks summary, and gives you a clear net deposit to reconcile.

  1. Source

    1

    Shopify Payments payout

    Sales, discounts, shipping, tax, refunds, fees, and adjustments are grouped around the payout.

  2. QuickBooks

    2

    A mapped summary

    Review how each category maps to your accounts before the summarized entry is posted.

  3. Reconciliation

    3

    The net bank deposit

    Match the posted result to the corresponding Shopify deposit in the QuickBooks bank feed.

Best fit for

  • Stores using Shopify Payments that want payout-level bookkeeping
  • Teams that want to review account mappings before posting
  • Sellers keeping order detail in Shopify and summarized accounting in QuickBooks

Know before you choose

  • This workflow does not provide live Shopify inventory or product-quantity sync
  • It does not create one QuickBooks transaction for every Shopify order
  • External payment gateways should be tested separately for mapping and reconciliation

Taxomate or the Shopify Connector by QuickBooks?

Intuit has its own Shopify Connector for QuickBooks Online. The two tools record Shopify sales in different ways, so compare them before you choose.

Topic Shopify Connector by QuickBooks Taxomate
Who builds it Intuit. Taxomate.
What it creates in QuickBooks A sales receipt and a fee expense for each Shopify sale, and a deposit for each payout. One summarized journal entry or invoice for each Shopify payout, based on your posting setting.
Bank reconciliation You match the deposit it creates to the Shopify deposit in the bank feed. The posted total is the payout total, so it matches the bank deposit. Auto deposit can also record the deposit for you.
History Up to 12 months back. All of Shopify's history on annual plans. Monthly plans include this year.
Other sales channels Shopify only. Amazon, eBay, Etsy, and Walmart can post to the same QuickBooks company.
  • The Shopify Connector can suit you if you want each Shopify sale as its own transaction in QuickBooks.
  • Taxomate suits you if you want one summary for each payout, so QuickBooks holds fewer transactions and each entry matches one bank deposit.
  • Taxomate also suits you if you sell on Amazon, eBay, Etsy, or Walmart and want one tool for all of them.

Shopify Connector by QuickBooks details from Intuit's Shopify Connector help article, checked 19 October 2026.

Compare bookkeeping for Shopify across QuickBooks, Xero, and other accounting software

Before and after

68 Shopify transactions become one QuickBooks entry.

Every order adds its own sale, fee and shipping lines to the Shopify payout. Taxomate adds them up by category, so QuickBooks gets one entry with the same total as the bank deposit.

Shopify payout lines 68 lines

  • #1041 Sale $24.99
  • #1041 Shipping $4.99
  • #1041 Payment fee −$1.17
  • #1042 Sale $18.50
  • #1042 Payment fee −$0.84
  • #1043 Sale $31.00
  • #1043 Payment fee −$1.20
  • #1044 Sale $12.99
  • #1044 Shipping $4.99
  • #1044 Payment fee −$0.82
  • #1045 Sale $44.00
  • … 57 more lines

QuickBooks · One summarized entry

Shopify sales and shipping
$765.78
Refunds
−$55.00
Shopify fees
−$30.62
Bank deposit
$680.16

Posted as a journal entry or an invoice, based on your setting.

Example figures for 28 orders. Your categories and accounts follow your own payout and mappings.

Setup

How to connect Shopify to QuickBooks

  1. 01

    Connect Shopify

    Connect your Shopify store. You approve access in Shopify. Taxomate then fetches your Shopify Payments payouts. It also handles orders paid through other gateways such as PayPal.

  2. 02

    Connect QuickBooks

    Connect QuickBooks Online. You sign in with Intuit and approve access to your company file.

  3. 03

    Set your account mappings

    Run Quick Setup to create default income, expense, and cost of goods accounts in QuickBooks, or pick accounts you already have. Then check the account for each category. You can change any mapping later. Taxomate does not post until the required mappings are set.

  4. 04

    Review a Shopify payout

    Open a Shopify payout in Taxomate. It shows sales, discounts, refunds, shipping, tax, and fees grouped by category, with the payout total.

  5. 05

    Post to QuickBooks

    Post the payout. Taxomate creates one summarized entry in QuickBooks as a journal entry or an invoice, based on your posting setting. You can also turn on auto-post so new payouts post after the deposit date.

  6. 06

    Reconcile with your bank deposit

    Match the posted entry to the bank deposit in QuickBooks. The posted total is the payout total, so it lines up with the deposit. If you turned on auto deposit, Taxomate also records the deposit to your bank account.

Posting

What Taxomate posts to QuickBooks

Taxomate groups each payout by category and posts them to the QuickBooks accounts you map. The table lists the categories and where each one goes.

Transaction type Where it goes Default account
Sales Income account Shopify Sales
Discounts Income account Shopify Sales
Shipping Income account Shopify Shipping
Refunds Income account Shopify Refunds
Tax Liability account Shopify Sales Tax Collected
Payment and selling fees Expense account Shopify Fees
Gateway transactions Clearing account Shopify Clearing Account
Gift card liabilities Liability account Shopify Gift Card Liabilities
Carried balance Asset account Shopify Carried Balances

Good to know

  • Taxomate posts the totals as a journal entry or as an invoice with sales items, based on your setting. When you post journal entries, it can also create the bank deposit.
  • You can turn on QuickBooks classes to track amounts by class.
  • Every mapping is yours to change. The default account names are a starting point.

Questions to settle before you connect

A payout-based integration works best when you want QuickBooks to explain each deposit without recreating your entire Shopify order book.

Does Shopify integrate with QuickBooks Online?

Yes. Taxomate connects Shopify to QuickBooks Online for summarized payout accounting. This page covers QuickBooks Online; it does not promise a QuickBooks Desktop connection, live inventory sync, or one transaction per order.

Will this create one QuickBooks transaction for every Shopify order?

No. Taxomate groups the activity behind a Shopify Payments payout into a summarized QuickBooks entry instead of mirroring every order.

How does the payout reconcile to the QuickBooks bank feed?

The summary separates the activity that explains the net Shopify deposit. For an illustrative payout with $100 of sales, $8 of tax, and $3 of fees, with no refunds, shipping, reserves, or adjustments, the bank receives $105. Keep the $100 revenue, $8 tax liability, and $3 fee expense separate, then match the $105 deposit. Your actual accounts depend on your mappings.

What should I test during the trial?

Use one representative Shopify Payments payout. Review its mappings, post the summary, and confirm that the result matches the bank deposit before importing more history.

Before you import history

Test Shopify to QuickBooks with one Shopify Payments payout

Before you move historical Shopify data, use one representative Shopify Payments payout to confirm the QuickBooks post and bank reconciliation path.

  1. 1 Import one recent Shopify Payments payout with sales, discounts, refunds, fees, and taxes.
  2. 2 Review the QuickBooks summary and confirm the net payout matches the bank feed.
  3. 3 Confirm the first successful post in QuickBooks before expanding to more payouts or historical imports.

Reconciliation playbook

Shopify QuickBooks payout reconciliation playbook

The goal is a QuickBooks entry that matches the bank deposit. Taxomate builds that entry from the Shopify Payments payout.

Start with Shopify Payments
Import the Shopify Payments payout and summarize the connected sales, discounts, refunds, fees, tax, and adjustments around the net deposit.
Post a QuickBooks-ready summary
Review the QuickBooks summary before posting so revenue, fee, refund, tax, and clearing lines are separated for reconciliation.
Use one payout as proof
Confirm the first successful QuickBooks post matches the Shopify bank deposit before expanding into historical imports.

Activation checklist

  • Shopify Payments payout imports with sales, discounts, refunds, fees, and taxes.
  • QuickBooks summary separates revenue, fees, refunds, taxes, and deposit clearing.
  • The first successful post in QuickBooks reconciles to the Shopify bank deposit.

Comparing ecommerce accounting tools?

A2X vs Link My Books for Shopify to QuickBooks

See how A2X, Link My Books, and Taxomate compare for this exact Shopify to QuickBooks payout workflow before you test your first import and post.

Compare Options

Shopify to QuickBooks questions

Does Shopify integrate with QuickBooks Online?

Yes. Taxomate connects Shopify to QuickBooks Online and posts mapped summaries of payout activity. It is a payout accounting workflow, not a QuickBooks Desktop, live inventory, or order-by-order synchronization promise.

What Shopify data does Taxomate post to QuickBooks?

Taxomate summarizes the activity behind a Shopify Payments payout, including mapped sales, discounts, shipping, taxes, refunds, fees, adjustments, and clearing amounts. The exact accounts depend on your mappings.

What if I use payment gateways other than Shopify Payments?

Shopify Payments is the clearest payout workflow. If you use external gateways, test how each gateway is mapped and reconciled before importing historical activity.

Can I test one payout before importing Shopify history?

Yes. Start with one representative payout, review the proposed QuickBooks summary, post it, and confirm the bank deposit matches before expanding the import.

Does Taxomate sync Shopify inventory quantities to QuickBooks?

No. This Shopify to QuickBooks workflow is for payout accounting and reconciliation; it does not provide live Shopify inventory or product-quantity sync.