Disclaimer: QuickBooksUsers.com is an independent service operated by E-Tech Corporation and is not affiliated with, endorsed by, or sponsored by Intuit Inc. "QuickBooks" is a registered trademark of Intuit Inc., used for identification and reference purposes only. See our Terms of Service.

QuickBooks

How to Set Up Shopify Bookkeeping in QuickBooks Online

QuickBooksUsers.com TeamUpdated 2026-08-052 min read

Managing a Shopify store in QuickBooks does not have to mean manually entering every single order. By connecting your store and mapping your transactions correctly, you can keep clean books and see exactly how your business is performing. We will walk you through the best way to structure this workflow.

Connect Your Store

The most reliable way to link Shopify to QuickBooks Online is through the QuickBooks App Center. There are several integration apps available that automatically pull your sales data into your accounting software.

When choosing an app, look for one that summarizes your daily Shopify sales rather than importing hundreds of individual invoices. Summarized daily journal entries keep your chart of accounts manageable and prevent your company file from becoming bloated with unnecessary data.

Map Your Income Accounts

Before the integration starts pulling data, you need to tell it where to send the money. Set up specific income accounts and products in your settings:

  • Sales Revenue: An income account for your gross product sales.
  • Shipping Income: A separate account if you charge customers for shipping.
  • Sales Tax Payable: A current liability account for the taxes you collect.
  • Payment Processing Fees: An expense account for Shopify Payments and credit card fees.

Reconcile Your Bank Deposits

Shopify does not deposit your gross sales into your bank account. It deducts its transaction fees and remits your sales tax before sending you a payout. Your bookkeeping needs to reflect this reality.

When a Shopify payout hits your checking account, match it to the summarized sales receipt created by your integration app. The gross amount goes to your sales income, the fees are pulled into your expense account, and the net deposit clears against your bank feed.

Handle Inventory Correctly

If you sell physical products, inventory tracking is critical. You can either let Shopify manage your stock levels entirely and adjust your Cost of Goods Sold (COGS) manually at month-end, or use an advanced inventory management app to sync stock quantities and costs between your store and QuickBooks.

Next Steps

Once your integration is active, run a test for a single day’s sales. Check the resulting summary entry in QuickBooks to ensure your gross sales, fee deductions, and tax liabilities are landing in the correct accounts before relying on the automation for your entire month.

Need Professional Help?

Contact Us