How to record Shopify sales in Quickbooks

how to record sales in shopify

Shopify is a fantastic ecommerce platform for startup businesses and it integrates well with the accountancy software Quickbooks. Shopify is much favoured by small and medium-sized businesses thanks to being low-cost and easy to set up, although it also accommodates bigger brands as well. Many of these sellers may be looking to automate more of their bookkeeping process, including recording their Shopify sales in Quickbooks.

Recording Shopify sales in Quickbooks online is a vital task for any Shopify seller. If you set it up incorrectly, you could be misreport your income from the platform, a big issue when it comes to submitting a tax return.

However, keeping track of the different sources of income including deductions and payment processor fees inside and outside Shopify can get tricky, even for experienced ecommerce sellers.

This introduction will help you find and record the data you need so you can stay on top of your Quickbooks and Shopify integration for flawless bookkeeping.

Here’s how to get started recording your Shopify sales in Quickbooks.

1. Run Shopify Payout report

Start by running a Shopify payout report:

  • On the Shopify home screen, look for payouts.
  • Next, scroll down and find the payout schedule located on the right.
  • Now select view all payouts.

You’ll see a list of all your Shopify payouts in date order. Select the date of any payout to see more details including gross, fees, charges including any refunds or adjustments, and the total amount received in your bank account.

2. Run Shopify Finances Summary report

Next, you’re going to run a finances summary report. Find the reports tab under analytics and scroll down until you find finances. 

Under report, click on finances summary. You’ll need to select the transaction dates you need from the payout report to get the information you need. Enter your date range and the finances report appears, showing:

  • Sales including gross and net sales, discounts and returns.
  • Liabilities including gift card sales and tips
  • Shopify payments

It’s worth bearing in mind that the amount shown for Shopify payments on the finance report is different to the total amount of the Shopify payout received in your bank account.

Here’s why. The Shopify payout that is paid into your bank = your Shopify payment minus any fees, and plus or minus any adjustments.

This is where things can start to get complicated and you’ll need to make some adjustments when you enter the amount into Quickbooks. Let’s take a look at how you create a journal entry to record Shopify sales.

3. Import into Quickbooks

You’ll need data from the Shopify payout and finances report to start creating your journal entry. From the finance report you’ll record:

  • Sales income
  • Shipping income
  • Discounts
  • Sale tax payable
  • Shopify fees

From the payout report you’ll need the Shopify clearing amount – in other words the amount that was deposited in your account.

Laying the data out as a journal entry allows you to account for the adjustments shown in the finance report so the transaction matches the incoming bank feed.

4. Record your payment processors

If you use other payment processors, including Amazon and PayPal, the fees will need to be recorded in your journal entry.

The problem is, Shopify reports only include information about Shopify Payments. You’ll need to get the data on Amazon, PayPal or other fees directly from the payment processor.

Ultimately, you need the following information for each Quickbooks journal entry:

  • Income
  • Deductions
  • Fees

The trick is keeping your eye on the different sources of data and pulling them all together so that Quickbooks can reconcile your entries with the payments you receive in your bank account.

Further information:

All you need to know about about VAT on Shopify

The Bottom Line

As we said at the beginning, keeping all these plates spinning when it comes to tracking down sources of income, deduction and payment processor fees can be tricky.

And although it takes work, and can get complicated, the journal entry method is worth a try if you’re looking to streamline your accounts using Quickbooks.

If you are struggling with any aspect of recording Shopify sales in Quickbooks, we can help.

We are specialist ecommerce accountants that help online businesses including Shopify sellers with their accounting every day. 

Get in touch today for a free 30 minute consultation on the accounting for your Shopify business.

Book your Free Consultation

Free 30 Minute Consultation

Why not grab a Free 30 Minute Consultation with Ben, he can answer any questions you have about your e-commerce or marketplace business, guide you on tax efficiency and see if we can help you.

You Have Nothing to Lose & A Lot to Gain
Ben Sztejka ACA

Ben Sztejka ACA

We are a leading e-commerce accounting firm, focused on assisting UK and EU businesses in thriving online. With expertise in Amazon FBA, Shopify, Etsy, and eBay, we provide customised tax compliance and reporting solutions. Our team combines 10 years of experience as ICAEW chartered accountants with 15 years in e-commerce, offering unparalleled support to both e-commerce businesses and accountants.

Ben Sztejka ACA

Ben Sztejka ACA

Head Accountant & Director here at Your Ecommerce Accountant. Specialises in Ecommerce Accounting drawn from his own experience in Ecommerce and selling on marketplaces like eBay, Amazon & ETSY.

Why Not Book A Free 30-Minute Chat with Ben & Ask Any Questions You May Have...

Recent posts

Read More
Ben was incredibly friendly, helpful and honest, and produced the accounts very quickly and at a fair price. He dealt with all the submissions and paperwork for me included in the price.
Read More
Ben and the team and really helpful & knowledgeable. The thought of doing our own accounts is headache educing. Accounts is a part of our business we don't have to worry about and we trust the team to take care of things. Furthermore, they really understand ecommerce accounting and the nuances it involves -do not go to a traditional accountant if you sell online.
Read More
Ben was very prompt with his consultation call, and very friendly. He explained what needs to happem first, and was honest enough to let me know that he won't be needed until the business is up and running and making money. I look forward to working with Ben and his team in the future!
Read More
I had a free consultation and it was so so helpful. The advice was simplified and I came away feeling really sure of what I needed and didn’t need to do in what seems like a minefield. I could not recommend enough! Thank you so much!

Get Really Useful Emails From Us Every Few Weeks...