Shopify Payouts to
QuickBooks — Instant CSV Conversion

Why Shopify Payout Exports Need Conversion for QuickBooks

Shopify provides payout reports designed to help merchants track their payment settlements, but the CSV format isn't directly compatible with QuickBooks. The payout export includes transaction types like charges, refunds, chargebacks, adjustments, and payout transfers all mixed together in a single file. QuickBooks needs clean, categorized transaction data with properly formatted dates and amounts to import correctly. Without conversion, you'll spend hours manually cleaning spreadsheets, filtering out internal Shopify operations, and reformatting columns — a tedious process that's prone to errors and doesn't scale as your store grows.

Common Shopify Import Errors in QuickBooks

When attempting to import a raw Shopify payout CSV export into QuickBooks, users commonly encounter these issues:

• “Date format not recognized” — Shopify exports dates in ISO format (2025-02-10) or with timezone offsets (2025-02-10 14:30:22 -0500). QuickBooks requires MM/DD/YYYY format (02/10/2025) and will refuse to import any file containing dates it can't parse.
• Mixed transaction types — Shopify's payout export includes charges, refunds, chargebacks, adjustments, payout transfers, and reserved funds all in one file. Importing everything would create duplicate entries and internal transfers that don't belong in your general ledger.
• Fee reconciliation issues — Shopify Payments deducts processing fees before settling payouts to your bank account. The fees appear in a separate “Fee” column rather than as distinct transactions, making it impossible to track processing costs as a categorized expense in QuickBooks without manual intervention.
• Chargeback confusion — Chargebacks appear as “chargeback” type rows with negative amounts, but without clear labeling. If imported without conversion, they can be mistaken for regular refunds, leading to inaccurate financial reporting.
• Multi-currency complications — Stores accepting multiple currencies have mixed currency values in the same export. QuickBooks needs to know which currency each transaction uses to maintain accurate multi-currency books.

How the Converter Fixes These Issues

The Shopify to QuickBooks Converter addresses every compatibility gap between Shopify's export format and QuickBooks' import requirements:

• Automatic date reformatting — Every date is converted from Shopify's ISO format (with or without timezone offsets) to MM/DD/YYYY, the format QuickBooks expects across all versions.
• Smart transaction filtering — Only actual business transactions (charges, refunds, chargebacks) are included. Payout transfers, reserved funds, and adjustments are automatically excluded to prevent double-counting and internal transfer noise.
• Fee splitting — Each Shopify Payments processing fee is extracted and added as a separate negative line item. This creates trackable expense entries so you can categorize fees under “Payment Processing Fees” in your chart of accounts.
• Chargeback labeling — Chargebacks are clearly labeled as “Shopify Chargeback” with the order number, so they're immediately identifiable in your QuickBooks register. They're treated as negative amounts separate from regular refunds.
• Multi-currency support — When enabled, the converter appends currency codes (e.g., [EUR], [GBP]) to transaction descriptions, helping you sort and categorize by currency in QuickBooks.
• Column mapping — Shopify's column names are mapped to the exact headers QuickBooks requires. QBO and Self-Employed get Date/Description/Amount; Desktop gets Date/Description/Credit/Debit.

Understanding Shopify Payments Fees

Shopify Payments charges processing fees on every transaction, and understanding how these fees work is essential for accurate bookkeeping:

• Standard rates — Basic Shopify plan charges 2.9% + $0.30 per online transaction. Shopify plan is 2.6% + $0.30, and Advanced Shopify is 2.4% + $0.30. In-person rates are lower.
• International cards — An additional 1.5% fee applies to international cards and currency conversion. If your store accepts multiple currencies, these extra fees appear in the Fee column alongside standard processing fees.
• Chargeback fees — Shopify charges a $15.00 chargeback fee (in the US) when a customer disputes a transaction. This fee is refunded if you win the dispute. The converter includes these as part of the chargeback transaction handling.
• Net settlement — Shopify settles payouts as net amounts (gross sale minus fees). The converter can split these into gross payment + separate fee line items, making bank reconciliation straightforward.

Chargeback Accounting Best Practices

Properly accounting for chargebacks in QuickBooks is important for accurate financial reporting:

• Record chargebacks as separate transactions — Don't combine chargebacks with regular refunds. The converter labels them distinctly as “Shopify Chargeback” so you can categorize them under a separate “Chargebacks” expense or contra-revenue account.
• Track chargeback fees separately — The $15 chargeback fee should be categorized under “Payment Processing Fees” or a dedicated “Chargeback Fees” sub-account, not lumped with the disputed amount.
• Reverse won disputes — If you win a chargeback dispute, Shopify refunds both the transaction amount and the fee. Create a reversing entry in QuickBooks to zero out the original chargeback.

Supported Shopify Export Types

The converter works with the two most common Shopify export configurations:

• Payout export — The standard CSV export from Settings → Payments → View payouts. Includes per-transaction rows with columns for Transaction Date, Type, Order, Amount, Fee, Net, Card Brand, Card Source, Payout ID, Order ID, Payment Method, and Currency.
• Finance Summary export — The aggregate report from Analytics → Reports → Finances summary. Includes daily/weekly/monthly summary rows with Gross Sales, Discounts, Returns, Net Sales, Shipping, Tax, Total Sales, Payments, and Balance columns.

Importing into QuickBooks Online

After converting your Shopify CSV, follow these steps to import into QuickBooks Online:

1. Log into QuickBooks Online and navigate to Banking from the left sidebar.
2. Click Upload transactions (or “Link account” → “Upload from file” if this is your first import).
3. Select the converted CSV file from your computer.
4. QuickBooks will display a column mapping preview — verify that Date, Description, and Amount are mapped correctly.
5. Choose the QuickBooks account to import into (e.g., “Shopify Payments” or “Payment Processing”).
6. Click Import to complete the process. Transactions will appear in the “For Review” tab.

Tip: Use “Shopify Payments” as the account name to match your bank deposits from Shopify's payout schedule.

Importing into QuickBooks Desktop

For QuickBooks Desktop (Pro, Premier, or Enterprise), use the Web Connect import method:

1. Open QuickBooks Desktop and go to File → Utilities → Import → Web Connect Files.
2. Browse to and select your converted file.
3. QuickBooks will prompt you to select the account for the imported transactions.
4. Click Continue to import. Transactions will appear in the bank register for review.

After import, verify that chargebacks and chargeback reversals appear as separate entries for proper dispute tracking.

Alternatively, you can use our CSV to IIF Converter to generate an IIF file, which can be imported via File → Utilities → Import → IIF Files.

Shopify Fee Accounting Best Practices

Properly tracking Shopify Payments processing fees is essential for accurate financial reporting. Here are the recommended practices:

• Create a dedicated expense category — Set up a “Payment Processing Fees” account under Expenses in your chart of accounts. This keeps Shopify fees separate from bank fees and other transaction costs.
• Use fee splitting for automatic journal entries — Enable the fee splitting option in the converter to generate separate line items for each processing fee. This eliminates manual fee entry and ensures every charge is captured.
• Reconcile net deposits against bank statements — Shopify settles payments as net amounts (gross payment minus processing fee). When reconciling, match your bank deposits against the net amounts, and verify that the sum of fee line items accounts for the difference between gross and net totals.
• Track plan-specific rates — If you changed Shopify plans during the reporting period, your processing rates may vary. The converter captures the actual fee amount from each transaction, so your books will reflect the true cost regardless of rate changes.

Want to go beyond conversion and master the full Shopify accounting workflow? Read our comprehensive Shopify Accounting Guide — covering Shopify Payments reconciliation, multi-currency bookkeeping, chargeback journal entries, and tax compliance strategies for Shopify merchants.

Related Free Accounting Tools

The Shopify to QuickBooks Converter is part of our complete suite of free QuickBooks conversion tools:

• CSV to QBO Converter — Convert cleaned bank CSVs into Web Connect (.qbo) files for QuickBooks Online and Desktop.
• CSV to IIF Converter — Convert CSVs into Intuit Interchange Format (.iif) for QuickBooks Desktop import.
• Bank CSV Cleaner — Clean and normalize messy bank CSV exports before importing into QuickBooks.
• Stripe to QuickBooks Converter — Convert Stripe payment exports to QuickBooks-compatible CSV with fee splitting.
• PayPal to QuickBooks Converter — Convert PayPal transaction exports to QuickBooks format.
• Amazon to QuickBooks Converter — Convert Amazon seller reports to QuickBooks-compatible CSV.
• Square to QuickBooks Converter — Convert Square payment exports to QuickBooks format.
• Chart of Accounts Generator — Generate a customized chart of accounts for your QuickBooks company file.
• QBO to IIF Converter — Convert QBO/OFX files to IIF format.
• IIF to QBO Converter — Upgrade legacy IIF files to Web Connect QBO format.
• IIF File Viewer — Preview and validate IIF files before importing.
• PDF to QBO Converter — Convert PDF bank statements to QBO, CSV, or IIF format.
• OFX to QBO Converter — Convert OFX bank statement files to QuickBooks Web Connect QBO format.
• QFX to QBO Converter — Convert Quicken QFX files to QuickBooks QBO format for seamless migration.
• QBO to CSV Converter — Export QBO transaction files to clean CSV spreadsheets for Excel and Google Sheets.
• OFX to CSV Converter — Convert OFX bank files to CSV format for spreadsheet analysis.
• OFX to IIF Converter — Convert OFX bank statements directly to QuickBooks Desktop IIF format.
• CSV to OFX Converter — Transform bank CSV exports into standard OFX format for financial software.
• QIF to QBO Converter — Upgrade legacy Quicken QIF files to modern QuickBooks QBO format.
• QBO to PDF Converter — Generate professional PDF bank statements from QBO transaction files.
• MT940 to QBO Converter — Convert SWIFT MT940 European bank statements to QuickBooks QBO format.
• QIF to CSV Converter — Convert legacy Quicken QIF files to clean CSV spreadsheets for analysis.
• QIF to IIF Converter — Convert Quicken QIF files directly to QuickBooks Desktop IIF format.
• IIF to CSV Converter — Export QuickBooks Desktop IIF files to CSV for spreadsheet analysis.
• QBO to OFX Converter — Convert QuickBooks QBO files to standard OFX format for other financial software.
• MT940 to CSV Converter — Convert SWIFT MT940 European bank statements to CSV spreadsheets.
• QBO File Viewer — Preview and inspect QBO Web Connect files before importing into QuickBooks.
• OFX File Viewer — Preview and inspect OFX bank statement files in a readable format.
• XLSX to QBO Converter — Convert Excel spreadsheets directly to QuickBooks Web Connect QBO format.
• Etsy to QuickBooks Converter — Convert Etsy shop payment exports into QuickBooks-compatible format.
• Duplicate Transaction Detector — Scan QuickBooks files to find and flag duplicate transactions before import.
• Import Troubleshooter — Diagnose and fix common QuickBooks file import errors automatically.
• File Format Detector — Identify unknown financial file formats and get conversion recommendations.
• CAMT.053 to QBO Converter — Convert ISO 20022 CAMT.053 bank statements to QuickBooks QBO format.