How to Record Shopify Sales in QuickBooks

How to Record Shopify Sales in QuickBooks

If you're running a Shopify store and using QuickBooks for your accounting needs, you may be wondering how to properly record your sales transactions. In this article, we'll explore how to record Shopify sales in QuickBooks and ensure accurate financial reporting.

Connect Your Shopify and QuickBooks Accounts

To begin recording your Shopify sales in QuickBooks, you need to connect your Shopify and QuickBooks accounts. This can be done through a third-party integration tool such as Zapier or OneSaas. Once the accounts are connected, you can set up the integration to automatically record your sales transactions in QuickBooks.

Create a Sales Receipt in QuickBooks

Once your accounts are connected, you can create a sales receipt in QuickBooks for each Shopify sale. To create a sales receipt, go to the "+" icon in the top right corner of your QuickBooks dashboard and select "Sales Receipt" under the "Customers" tab. From there, you can input the customer name, product sold, and the sale amount.

Record Payment in QuickBooks

After creating a sales receipt, you'll need to record the payment received for the sale. To record a payment in QuickBooks, select the "Receive Payment" option under the "Customers" tab. Input the customer name and the payment amount. If the payment was made using a payment processor like Shopify Payments, you can also link the payment to the sales receipt in QuickBooks.

Reconcile Your Accounts

To ensure accurate financial reporting, it's important to reconcile your Shopify and QuickBooks accounts regularly. This involves comparing the transactions in QuickBooks to the transactions in Shopify to ensure they match. If there are any discrepancies, you'll need to investigate and correct them.

Accounting Supports

Managing the finances of your Shopify store can be overwhelming, but Accounting Supports can help. We are a fully online virtual bookkeeping company that provides monthly online bookkeeping for as little as $99/month. Our team of experts is proficient in all accounting software, including QuickBooks, and can help ensure your financial success.


Recording your Shopify sales in QuickBooks is essential for accurate financial reporting. By connecting your accounts, creating sales receipts, recording payments, and reconciling your accounts, you can ensure your financial records are accurate and up-to-date. And if you need help managing your finances, be sure to partner with Accounting Supports for expert bookkeeping services.