How to Import Shopify Transactions into QuickBooks

Short answer: The Shopify Connector by QuickBooks syncs into QuickBooks Online and imports orders from a start date you choose, up to about one year back. Shopify's own exports are CSV files and PDF summaries, which Desktop will not take for banking and Online only accepts with manual column mapping. For anything older than a year, for a closed store, or for QuickBooks Desktop, convert the Shopify payout statement to a Web Connect .QBO file and import that. Shopify never produces a .QBO of its own.

Shopify runs the checkout for a very large number of US ecommerce businesses, and the accounting for almost all of them goes wrong in the same two places: the history does not reach far enough back, and the money that lands in the bank is not the money the store actually made. Both problems are fixable once you know which route into QuickBooks does what.

Can you import Shopify transactions into QuickBooks?

Yes, and there are three routes. The official Shopify Connector by QuickBooks is a QuickBooks Online app that syncs orders, fees, and payouts on an ongoing basis. A CSV export from Shopify admin can be mapped and uploaded by hand. And a converted payout statement gives you a Web Connect .QBO file that both QuickBooks Online and QuickBooks Desktop import like a bank download, for any period. They differ mainly in how much history they reach and how much manual work they leave you.

Route 1: the Shopify Connector by QuickBooks

This is the path most stores take, and for a store you are setting up today it is the right one. You install the app from inside QuickBooks Online, connect the store, and pick a start date. From that date forward it brings orders, Shopify Payments fees, refunds, and payouts into your books automatically.

The catch is the start date. The connector reaches back about one year, no further. If you are doing a catch-up for a period earlier than that, or you are rebuilding the books for a store that has since closed, the connector cannot help you. It also only exists for QuickBooks Online. There is a QuickBooks Desktop Connector inside Shopify admin, but that one is a one-time migration bridge for merchants moving off QuickBooks Desktop POS, not an ongoing accounting sync, and it can only be run once.

Route 2: the Shopify CSV export

In Shopify admin, Finances then Payouts lets you export a date range. Choose the plain CSV rather than the summary, and you get one row per transaction with Transaction Date, Type, Order, Amount, Fee, and Net columns. That is genuinely useful data. It is just not in a shape QuickBooks wants.

QuickBooks Online will accept a CSV bank upload, but only after you map its columns to Date, Description, and Amount, and the Shopify file does not arrive in that shape. QuickBooks Desktop will not accept a CSV for banking at all without a third-party tool. So this route works, but it means reshaping a spreadsheet by hand every time, and it is where most of the small errors in ecommerce books come from.

Route 3: convert the statement to a QBO file

This is the route that has no history limit and no version limit. Upload the Shopify payout statement, the finances summary, or the payouts CSV to the Shopify statement to QBO converter, pick QBO as the output, and you get a real Web Connect file.

Import it the same way you would a bank download:

• QuickBooks Online: Transactions, then Bank transactions, then Upload from file. Select your Shopify clearing account.
• QuickBooks Desktop: File, Utilities, Import, Web Connect Files. Select the Shopify account.

Because it arrives as a bank feed file, the transactions land in the For Review queue, your bank rules fire on them, and QuickBooks runs its duplicate check. That is the practical difference between importing a bank feed and simply filing transactions into a register.

How far back can Shopify sync to QuickBooks?

About one year. When you connect the app you choose the date it should start importing orders from, and roughly twelve months is as far back as that date can go. This is the single most common wall people hit, because catch-up bookkeeping almost never conveniently starts inside the last twelve months. A converted payout statement has no such window: it carries whatever period the report covers, so a two-year rebuild is just a series of files.

Does Shopify have a QBO file?

No. Shopify exports payouts and orders as CSV and the finances summary as a PDF. Web Connect is not offered anywhere in Shopify admin. This matters more than it sounds, because QuickBooks Desktop imports bank activity through Web Connect files, and QuickBooks Online treats a QBO upload as the cleanest file it takes. Shopify produces neither, which is why converting the statement is not a shortcut around an export that already exists. It is the only way to get the file at all.

Should Shopify be a bank account in QuickBooks?

Yes, set it up as a clearing account of the bank type. Orders and fees post into it, payouts leave it, and the payout then matches the deposit on your real bank feed as a transfer between two accounts. That structure is what makes the balance meaningful: money customers have paid but Shopify has not yet released sits in the clearing account, where it belongs, instead of being invisible until it lands.

If you skip the clearing account and post the bank deposit straight to sales income, you have recorded the net as revenue, lost the fee entirely, and made it impossible to tie any deposit back to the orders behind it.

Why does my Shopify payout not match my sales?

Because Shopify Payments takes its cut before it pays you. A payout is gross sales, minus processing fees, minus any refunds issued in that window, minus chargebacks and dispute fees. A week with 10,000 dollars of orders might deposit around 9,600. Book the deposit as revenue and you have understated income by the fee, and the processing cost never appears on your profit and loss at all, which quietly distorts margin for the whole year.

The fix is to import the payout detail, not the deposit. When the gross sale, the fee, and the refund each land on their own line, the arithmetic works out on its own and the payout matches the bank. The full version of that arithmetic is in why ecommerce sales never match the bank deposit.

How do I record Shopify fees in QuickBooks?

Book the sale at its gross amount and the Shopify Payments fee as a separate merchant fee expense. Never post the net. The gross belongs in sales income, the fee belongs in an expense account, and the difference between them is what actually shows up in the bank. A converted payout statement keeps the two on separate lines automatically, which is most of the reason to convert rather than retype.

Avoiding duplicates when you backfill

Duplicates appear when a live sync and a converted file overlap. The rule is simple: load history behind the sync, never on top of it. Open the Shopify clearing account register, find the oldest transaction the connector brought in, and end your converted file the day before that date.

Also check the row count before you start. A QuickBooks Online file upload caps at 1,000 transactions, and a year of orders on a busy store clears that without trying, so split the period into monthly files. The details are in how many transactions you can import into QuickBooks at once.

Sales tax inside the payout

Shopify collects sales tax on the order and pays it to you inside the payout. If the tax never gets split out, it rides along as revenue and then shows up again as a liability you cannot reconcile to anything. Keep it as its own line from the start. This is easier to fix during import than at year end, when you are trying to reverse engineer twelve months of it from a spreadsheet.

A practical order of operations

For a store with a year or more of untouched books, the sequence that works is: set up the Shopify clearing account, connect the app so the current period keeps itself current, then work backwards with converted payout statements month by month until you reach the beginning of the period you owe. Reconcile each month against the Shopify payout report as you go rather than saving it all for the end.

If part of the mess is receipts and supplier invoices rather than sales, it is worth pulling the line items off those bills automatically at the same time, because the expense side of an ecommerce cleanup is usually where the second week disappears.

The short version

The Shopify connector is fine for keeping the current year current, and useless for anything older than about twelve months. Shopify has no QBO export. So for catch-up work, closed stores, and every QuickBooks Desktop user, converting the payout statement to a Web Connect file is the route that actually reaches. Set Shopify up as a clearing account, import the payout detail rather than the deposit, and the fee, the refund, and the sales tax all end up where they belong.