How to Transfer Shopify Sales and Payout Data to QuickBooks Using CSV

To move Shopify data to QuickBooks with a CSV file, export the right report from Shopify, reformat it to match a QuickBooks import template and upload it through QuickBooks’ import tools. Most stores use one of three approaches: payouts uploaded as bank transactions, sales summarized in journal entries, or individual orders imported as sales transactions.

A CSV workflow costs nothing beyond your time and works without connecting another app to your books. It does take careful formatting, though, so it helps to know which Shopify export fits each QuickBooks import before you start.

How to Move Shopify Data to QuickBooks With CSV

There’s no single Shopify file that QuickBooks can read as-is, so you pick an approach based on how much detail your books need. Each one uses a different Shopify export and QuickBooks import, as this comparison shows the three common routes:

Summary entries are a common choice, because they keep your books accurate without filling QuickBooks with thousands of individual orders. Whichever you choose, use it consistently so sales aren’t recorded twice.

Step 1: Export the Right Shopify Data

Each approach starts with a different Shopify export. Pick the one that matches the QuickBooks import you plan to use.

Payout transactions

For Shopify Payments, go to Finance > Payouts, open a payout and choose Export payout transactions, or export all balance transactions for a date range. The CSV includes the transaction date, type, order, amount, fee and net amount for every charge, refund and adjustment.

This is the only standard export that shows Shopify Payments fees line by line. It covers Shopify Payments only, so payments through providers such as PayPal need exports from those providers.

Orders

Go to Orders, filter by date, click Export and choose Export orders. The file includes order totals, subtotal, shipping, taxes, discounts, refunded amounts and line item details such as quantity, price and SKU.

The orders export doesn’t include payment processing fees. Each additional line item also sits on its own row with many order fields left blank, so you’ll need to tidy the file before importing it.

Finance and sales reports

For summary entries, use Shopify’s finance and sales reports for the period you’re recording. They break sales into gross sales, discounts, returns, net sales, taxes and shipping, which map neatly to accounts in your chart of accounts.

Export the report for the same period each time, such as a single day or month. Consistent periods make it easier to match entries with payouts and bank deposits later.

Step 2: Format the CSV for QuickBooks

QuickBooks Online accepts CSV, Excel and Google Sheets files, but only with specific fields for each data type. Download the sample file for your import type from your QuickBooks account and match its columns exactly.

A few rules apply to every import. Each file needs fewer than 1,000 rows, the first row is used as headers for mapping, and larger files should be split into several smaller ones.

Bank transaction format

Payout data goes into QuickBooks as bank transactions, which need a simple layout. QuickBooks can’t handle extra columns here, so use one of these formats, with only these columns in this order:

• Three columns: Date, Description and Amount, with deposits as positive amounts and payments as negative amounts.
• Four columns: Date, Description, Credit and Debit, with headers that read only “Credit” and “Debit.”

Keep dates in one consistent format, leave empty cells blank rather than entering zeros and make sure descriptions contain text, not just numbers. Including the order number in the description makes each transaction easier to identify later.

Summary journal entries

A summary journal entry records a period’s sales in one balanced entry. Each line names an account and a debit or credit amount, and total debits must equal total credits.

A typical daily sales entry might credit sales revenue and shipping income, credit sales tax payable, debit discounts and refunds, debit merchant fees and debit a Shopify clearing account for the amount waiting to be paid out. When the payout lands in your bank, you record a transfer from the clearing account, which should bring it back to zero.

Check with your accountant on the exact accounts and treatment before you build a template. Once it’s set up, you can reuse the same layout every period and simply update the amounts.

Orders as invoices or sales receipts

To bring in individual orders, reshape the orders export to match QuickBooks’ invoice or sales receipt template. That usually means renaming headers, fixing date formats, filling order details down to every line item row and mapping products, tax and income accounts.

This approach gives you the most detail but takes the most work. Customers and products also need to exist in QuickBooks, or be imported first, for each line to match.

Step 3: Import the File Into QuickBooks Online

The import location depends on the kind of data you’re bringing in. Bank transactions and other records use different tools:

• Bank transactions. Go to the banking area, choose to upload transactions from a file, select the CSV and pick the account it belongs to, then map the columns and review the transactions before accepting them.
• Customers, products, invoices and journal entries. Click the settings gear, choose Import data, select the data type, upload your file and map each column to a QuickBooks field before importing.

The data types you can import vary by QuickBooks version and region, so check the Import data list in your own account. Imported contacts can’t be bulk deleted afterward, so test with a small file first.

Set Up Your Accounts Before Importing

A clean chart of accounts makes every import easier, because each Shopify amount needs somewhere to go. Creating them before your first import saves remapping later, and accounts many Shopify sellers set up include:

• Shopify revenue as an income account
• Shopify fees as an expense account
• Shopify payouts bank as the bank account receiving deposits
• Shopify clearing as an asset account for sales awaiting payout or paid through other gateways
• Sales tax liability for tax you’ve collected
• Inventory and cost of goods if you track stock value in QuickBooks

Import lists before transactions so everything has something to link to. QuickBooks suggests this order: chart of accounts, customers, vendors, products and services, invoices, bills and then journal entries.

If you use QuickBooks Desktop or Enterprise, the process is different. Desktop exports lists such as the chart of accounts as IIF files, so follow Desktop-specific instructions for importing data.

Reconcile Payouts After Importing

Recording sales is only half the job, because the money arrives later and with fees taken out. Reconciling confirms that every Shopify payout matches a deposit in your bank account.

Compare each payout’s net amount with the matching bank deposit, then check that the sales, refunds and fees behind it are recorded. If you use a clearing account, its balance should return to zero once each payout is matched.

Watch for duplicates if your bank already feeds deposits into QuickBooks. Uploading payouts as bank transactions and also accepting the same deposits from the bank feed records the money twice.

When an Integration Is Better Than CSV

CSV imports work well for low volumes and occasional catch-up bookkeeping. As orders grow, the time spent exporting, reformatting and checking files adds up, and one formatting error can break a whole batch.

Integration apps connect Shopify to QuickBooks and post data automatically. Depending on the app, they can post individual orders or daily summaries, map accounts and taxes, and record fees and payouts, with tools such as A2X focusing on summarized entries and Webgility offering order-level detail and multichannel syncing.

Consider switching when CSV bookkeeping takes hours each week, when you sell through several channels or when fee and payout matching keeps causing errors. Compare what each app posts, how it handles fees and refunds and which QuickBooks version it supports.

Common Shopify to QuickBooks CSV Problems

Many CSV issues come from formatting or from mixing approaches. Watch for these:

• Rejected files. Extra columns, inconsistent dates or headers that don’t match the QuickBooks template.
• Files too large. Imports over 1,000 rows need splitting into smaller files.
• Missing fees. Fees were taken from the orders export, which doesn’t include them, instead of the payouts export.
• Duplicate income. Sales were imported as orders and also recorded from payouts or the bank feed.
• Payouts that don’t match. Refunds, chargebacks, reserves or adjustments changed the deposit amount.
• Other gateways left out. PayPal and other provider payments weren’t recorded because they aren’t in Shopify payout exports.
• Sales tax in the wrong account. Tax collected was recorded as income instead of a liability.

Conclusion

A Shopify to QuickBooks CSV workflow gives you a low-cost way to keep your books up to date, as long as you choose the right export and format it carefully. Using one consistent approach and reconciling payouts regularly keeps your sales, fees and taxes accurate. We hope this guide helps you set up your Shopify to QuickBooks CSV process with confidence.