Journal

Connecting Shopify POS to QuickBooks

Bastien DaxheletOperations and growth

6 min read

What to know before you start

Shopify's point of sale, Shopify POS, isn't a separate system. A sale made in store is a Shopify order, just like a sale made on the online store. That's what makes the link with the books possible: there's a single source to connect.

On the other side, there are two QuickBooks. QuickBooks Online connects through an app from the Shopify App Store. Intuit, the maker of QuickBooks, publishes one, and other publishers offer their own. QuickBooks Desktop goes through a different connector, with its own limits. Everything that follows is about QuickBooks Online.

A connector does only one thing: it reads what happened in Shopify and writes it into QuickBooks. It doesn't decide for you where each amount should go. That's where the work is.

The steps, in order

Choose how sales are recorded

There are two ways to do it, and not every connector offers both. Either each sale becomes an entry in QuickBooks. Or the connector writes a summary, per day or per payout: so much in sales, so much in taxes, so much in fees.

A store that makes fifty small sales a day doesn't need fifty entries. The summary keeps the books readable, and it matches the deposit you see arrive at the bank. One entry per sale is useful when you want to find a specific order in QuickBooks.

Map each thing to its account

The connector asks where to put sales, discounts, refunds, shipping charges, card processing fees, gift cards and store credits. Your accountant already has a chart of accounts. We start from theirs; we don't invent a new one.

Set up GST and QST

Shopify calculates two taxes, on two lines. QuickBooks has to receive them separately, each with the right tax code, otherwise the end-of-period return won't balance. We check it with a real sale, then with a real refund.

Reconcile the deposits

Card sales reach the bank as payouts: a single deposit for several sales, fees already taken off. The connector has to record the payout and its fees so that the amount in QuickBooks is the one on the bank statement.

Cash doesn't go through any payout. It stays in the drawer until the bank deposit. It needs its own account in QuickBooks, otherwise cash sales float somewhere between the till and the bank.

Test on a real day

Before trusting the link, we run a full day: a card sale, a cash sale, a refund, a credit issued, a credit used. Then we compare Shopify's sales report with what went into QuickBooks. The two totals have to be identical.

The pitfalls

  • Store credits and gift cards. A credit issued isn't revenue. It's a debt to the customer until the day she uses it. Set up wrong, the connector counts the sale twice: when the credit is issued, then when it's spent.
  • The start date. The connector imports from a given date. If your accountant has already entered the month's sales, you'll get duplicates. We pick the start of a period, with them.
  • Refunds and exchanges. An exchange at the till is a return and a sale in the same transaction. We check that both halves come through.
  • Inventory. Shopify already keeps the inventory. Nothing requires copying every item into QuickBooks. For a business whose items change every day, it's actually best avoided.

What we did at Bon Flow

Bon Flow sells in store only. It needed a site, a point of sale for the store, drop-off credits to track, and books that keep up with all of it.

We built the site and set up the store's Shopify point of sale. Drop-off credits are managed in the point of sale, not on the side.

Then we connected the point of sale to QuickBooks: the store's sales flow into the books.

When it's not the right solution

If you make a few sales a week, a connector to keep an eye on isn't worth it. Shopify's monthly report, handed to your accountant, does the job.

If you're on QuickBooks Desktop, the path is different. Before connecting anything, ask whether it's time to move to QuickBooks Online.

If you don't have accounting software yet, the question is a different one. We connect a Shopify store to QuickBooks or to Zoho Books: the choice depends on the rest of your tools. That's the subject of our page Websites and e-commerce.

Questions

Frequently asked questions

Does Shopify POS connect to QuickBooks Online without development?

Yes. Shopify POS connects to QuickBooks Online through a connector from the Shopify App Store, including the one Intuit publishes. There's no code to write. There are settings to get right: the accounts, the taxes, the start date and how store credits are handled.

In QuickBooks, do you need one entry per Shopify sale or one summary per day?

For a store with many small sales, a summary per day or per payout keeps the books readable and is easier to reconcile with the bank deposit. One entry per sale is useful when you invoice named customers or want to find each order in QuickBooks. It's a decision to make with your accountant, before choosing the connector: not all of them offer both.

How should Shopify store credits be handled in QuickBooks?

A store credit that's been issued isn't a sale: it's an amount the business owes the customer until she uses it. In QuickBooks, it goes into a liability account, and comes out when the customer pays with her credit. If the connector counts it as revenue, the same sale shows up twice.

How much does it cost to connect Shopify POS to QuickBooks?

It depends on the connector chosen and what there is to set up: store credits, cash, the number of locations. At Actif, the first call is free, and the price is written in the proposal, before we start.

Journal

Read next

All articles
Websites and e-commerce

Your point of sale and your books don't talk to each other?

Bastien DaxheletThe first call is free. You'll talk to Bastien.

Book 25 minutes
Book 25 minutes · free, by video, with Bastien
Your project (optional)

Your information is used to prepare the call and follow up on your request; it is kept in our Zoho tools, along with the page you came from. Privacy policy (in French)