Shopify exports CSV and PDF summaries, never a .QBO file. The official QuickBooks connector only reaches about a year back, and only into QuickBooks Online. Upload your Shopify payout statement or finances report here and get a real Web Connect QBO that both versions of QuickBooks import. Start free, no credit card.
Last updated July 2026
Upload your bank statement
Drop file here or click to upload
PDF, JPG, PNG, BMP, HEIC, TIFF, MT940
Uploading...
Upload the Shopify payout statement, finances summary, or plain CSV payouts export to BankXLSX and pick QBO as the download format. Shopify has no QBO export of its own: every report it produces is a CSV or a PDF summary. The converted QBO imports into the Shopify clearing account in QuickBooks exactly like a bank download, for any period, including everything older than the connector can reach.
Shopify keeps your whole payout history, but hands it over in formats QuickBooks will not take as a feed.
Payouts export as a plain CSV with Transaction Date, Type, Order, Amount, Fee, and Net columns. Orders export as CSV. The finances summary is a PDF. Web Connect is not offered anywhere in Shopify admin, so there is no .QBO to download.
When you set up the official Shopify Connector by QuickBooks you pick a start date, and it goes back roughly one year. Rebuilding an earlier year, or a store you closed, is outside what the app will import.
The Shopify connector is a QuickBooks Online app. The QuickBooks Desktop Connector inside Shopify admin is a different thing entirely: it exists for merchants migrating off QuickBooks Desktop POS, it runs once, and it is not a general Desktop accounting bridge.
Shopify Payments deducts processing fees, refunds, and chargebacks before it pays you, so the deposit in your bank is never the same number as your gross sales. Book the deposit as revenue and you understate both income and expenses at once.
One bank deposit covers a batch of orders across several days. Without the payout detail behind it, nobody can tell you which orders that deposit represents, which is what makes reconciliation stall.
Shopify collects tax on the order and pays it to you inside the payout. If the tax is never split out, it rides along as revenue and shows up again as a liability you cannot tie back to anything.
Upload the payout statement and get a valid Web Connect file, for any period, with the fee kept as its own line.
You get an actual .qbo with the structure QuickBooks expects, the only format QuickBooks Desktop Web Connect takes and the cleanest one for a QuickBooks Online upload.
A statement carries no sync window with it. Convert a period from two years ago, or rebuild a closed store, without the connector deciding how far back you are allowed to go.
The Shopify Payments fee stays its own line rather than disappearing into the deposit, so revenue books at gross and processing cost books as the expense it is.
Refunds, chargebacks, and dispute fees come across with the right sign, so the Shopify balance in QuickBooks tracks what Shopify actually shows.
Each payout stays intact as its own transaction, which is what lets you match a Shopify payout to the deposit sitting on your bank feed.
256-bit encryption in transit, and you can delete your uploaded files whenever you want.
No software to install and no credit card to start.
In Shopify admin open Finances, then Payouts, set the date range, and export. Choose the plain CSV rather than the summary if you want every transaction line. The finances summary PDF works too. Drag the file into the box above.
Tip: Plain CSV gives you Date, Type, Order, Amount, Fee, and Net.
Once the transactions are read, pick QBO as the download format. QFX, OFX, CSV, and Excel sit next to it.
Tip: Pick QFX if the target is Quicken.
QuickBooks Online: Transactions, Bank transactions, Upload from file. Desktop: File, Utilities, Import, Web Connect Files. Select the Shopify clearing account, which most books set up as a bank account.
Tip: One account per file.
Shopify sits between the customer and the bank, and it keeps its cut on the way through. Everything an accountant needs to know about a month of sales, the gross, the fees, the refunds, the chargebacks, and which orders made up each deposit, exists only inside Shopify. The bank sees a series of round numbers arriving with no explanation.
The client sends the payout export, not the store login. Convert the period you were handed and post it properly, without waiting on access you may never get.
You want the deposit in the bank to tie back to the orders behind it, so revenue is right and the fee is visible on the profit and loss.
The connector will not backfill the year you are rebuilding. Converted payout statements will, month by month, as far back as your reports go.
There is no Shopify accounting app for Desktop. Web Connect is the supported route in, and a converted statement is a proper Web Connect file.
Yes, and there are three real routes. The official Shopify Connector by QuickBooks syncs into QuickBooks Online and reaches about a year back. A CSV export can be reshaped and uploaded by hand. And a converted payout statement produces a Web Connect .QBO that both QuickBooks Online and QuickBooks Desktop import, for any period. The route you pick decides how much history you get and whether the processing fee survives as its own line, so it is worth knowing what each one reaches before you start a cleanup.
| Path | File or method | History reach | Works with QuickBooks Desktop? |
|---|---|---|---|
| Shopify Connector by QuickBooks | Live app sync | Start date up to about one year back | No, QuickBooks Online only |
| Shopify payouts export | Plain CSV or summary CSV | Any period the store recorded | Not as a bank feed |
| QuickBooks Desktop Connector in Shopify | One-time POS migration bridge | Migration only, runs once | Only for QuickBooks Desktop POS migrations |
| Converted Shopify statement | A real .QBO Web Connect file | Any period | Yes |
The pattern repeats everywhere in ecommerce accounting: the live connection owns the current period, and everything behind it has to arrive as a file. Shopify makes it sharper than most, because the one file format QuickBooks treats as a bank feed is the one format Shopify does not produce.
No. Shopify exports payouts and orders as CSV, and the finances summary as a PDF. There is no Web Connect option in the export menu, and there never has been. This matters because QuickBooks Desktop imports bank activity through Web Connect files, and QuickBooks Online treats a QBO upload as the cleanest file it accepts. Shopify produces neither, so converting the statement is not a shortcut around an export. It is the only way to produce the file at all.
Because Shopify Payments takes its cut before it pays you. A payout is gross sales minus processing fees, minus refunds issued in that window, minus any chargebacks and dispute fees. So a week with 10,000 dollars of orders might deposit around 9,600. If you book the deposit as revenue, you have understated income by the fee and never recorded the processing cost at all. Import the payout detail instead, and the gross, the fee, and the refund each land on their own line.
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 Shopify balance meaningful: money that customers have paid but Shopify has not yet released sits in the clearing account, exactly where it belongs, instead of being invisible until it lands.
Duplicates appear when a live sync and a converted file overlap. Open the Shopify clearing account register, find the oldest transaction the connector brought in, and end your converted file the day before it. Load history behind the sync, never on top of it. If you are rebuilding a busy year, check how many transactions QuickBooks accepts at once first, because a QuickBooks Online upload caps at 1,000 lines and a year of orders clears that without trying.
The same upload produces more than a QuickBooks file. Take XLSX or CSV instead with the Shopify statement to Excel converter when you want to sort and total a year for a tax return. The step-by-step version of this page is how to import Shopify transactions into QuickBooks, and if the deposit that does not match your sales is what sent you here, why ecommerce sales never match the bank deposit works through the arithmetic. The sibling processor pages are Stripe statement to QBO, PayPal statement to QBO, and Square statement to QBO, and the general case is the bank statement to QBO converter. If the one-year wall is the problem, why QuickBooks only imports 90 days of transactions explains what each connection type reaches.
If you already pulled the Shopify payouts CSV and simply need it in Web Connect form, a dedicated CSV to QBO converter does that one job. When statements from several institutions are all heading into the same QuickBooks file, a purpose-built bank statement to QuickBooks converter runs the PDF to QBO workflow across all of them.
Yes. The Shopify Connector by QuickBooks syncs into QuickBooks Online and reaches about a year back. For anything older, or for QuickBooks Desktop, convert the Shopify payout statement to a QBO Web Connect file and import it into your Shopify clearing account like a bank download.
No. Shopify exports payouts and orders as CSV and the finances summary as a PDF. Web Connect is not offered anywhere in Shopify admin, so the only way to get a .QBO from Shopify data is to convert the export or the statement.
About one year. When you connect the app you choose a start date, and roughly twelve months is the limit on how far back it will import orders. Earlier periods, and closed stores, have to come in as a converted file.
Not for normal accounting. The Shopify connector is a QuickBooks Online app. The QuickBooks Desktop Connector inside Shopify admin exists for merchants migrating from QuickBooks Desktop POS, it runs once, and it is not an ongoing bookkeeping bridge. Desktop users import a Web Connect QBO file instead.
Shopify Payments deducts processing fees, refunds, and chargebacks before it releases the payout, so the bank deposit is always less than gross sales. Booking the deposit as revenue understates income and hides the fee. Import the payout detail so each piece lands on its own line.
Yes, as a clearing account of the bank type. Sales and fees post into it and payouts leave it, which lets you match each Shopify payout against the deposit on your real bank feed as a transfer rather than double counting the revenue.
Book the sale at gross and the Shopify Payments fee as a separate merchant fee expense. Recording only the net that landed understates revenue and leaves the processing cost off the profit and loss entirely. A converted payout statement keeps the two on separate lines.
The same payout report as XLSX or CSV instead.
The processor whose only Desktop file is a legacy IIF.
The processor that never made a QBO file at all.
Convert any bank statement to a QBO file.
Every QuickBooks import path, and the limits on each.
Z tej samej rodziny narzędzi
Get started converting bank statements to spreadsheets.
USD
per month
billed as
$288 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
billed as
$888 yearly
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
billed as
$ yearly
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
