How to Import Shopify Payouts into QuickBooks

The Shopify Payout Accounting Challenge

Shopify sellers who use Shopify Payments receive payouts every few days, each representing a batch of orders, refunds, and fees. Recording these payouts correctly in QuickBooks requires breaking down the gross sales, processing fees, and net deposit — not just recording the bank deposit amount.

This guide covers the complete workflow from downloading your Shopify payout CSV to having a balanced journal entry in QuickBooks.

Understanding Shopify Payout Reports

When you export a payout from Shopify, you get a CSV file with these key columns:

• Transaction Type: charge, refund, chargeback, payout, etc.
• Amount: The gross transaction amount
• Fee: Shopify's payment processing fee (negative)
• Net: Amount minus Fee (what you actually receive)

Each row represents a single transaction within the payout period. The final "payout" row shows the total deposited to your bank.

Transaction Types Explained

charge — A completed sale. The Amount is the gross sale, the Fee is Shopify's cut, and the Net is what counts toward your payout.

refund — A customer refund. Amount is negative (money going back to the customer). Shopify typically refunds their processing fee on refunds, so the Fee column may be positive.

chargeback — A disputed charge. Similar to a refund but initiated by the customer's bank. These come with an additional chargeback fee.

payout — The summary row showing the total deposited to your bank account. This is the sum of all Net amounts in the payout.

Step 1: Download the Payout CSV

1. Log in to your Shopify Admin
2. Go to Settings > Payments > View payouts
3. Click on the specific payout you want to export
4. Click Export transactions

You'll get a CSV file containing all transactions for that payout period.

Step 2: Build the Journal Entry

From the Shopify payout data, you need to create a journal entry with these lines:

Credits (money earned)

• Product Sales: Sum of all charge Amount values
• This represents your gross revenue before fees

Debits (money spent or deducted)

• Payment Processing Fees: Sum of all Fee values (Shopify's per-transaction fees)
• Refunds Issued: Sum of all refund Amount values (negative amounts)
• Chargebacks: Sum of chargeback amounts
• Bank Account: The payout amount (net deposit)

The Balance Check

Your journal entry must balance: total debits = total credits. Verify that:

Gross Sales - Processing Fees - Refunds - Chargebacks = Net Payout

If this equation doesn't hold, check for adjustments, reserves, or partial payouts.

Step 3: Import into QuickBooks

Method 1: Manual Journal Entry

In QuickBooks Online: 1. Go to + New > Journal Entry 2. Enter each line with the account, debit/credit amount, and memo 3. Verify the entry balances 4. Save

This works for low volume but is tedious and error-prone at scale.

Method 2: CSV Import

QuickBooks Online supports journal entry imports via CSV. The file needs columns for Date, Account, Debit, Credit, and Memo.

Format your Shopify payout data as:

Date,Account,Debit,Credit,Memo
2025-01-15,Sales Revenue,,1250.00,Shopify Payout #1234
2025-01-15,Payment Processing Fees,37.50,,Shopify Payout #1234
2025-01-15,Refunds,75.00,,Shopify Payout #1234
2025-01-15,Checking Account,1137.50,,Shopify Payout #1234

Method 3: IIF Import (QuickBooks Desktop)

QuickBooks Desktop uses the IIF (Intuit Interchange Format) for imports. This is a tab-separated format with specific header rows. If you're still on Desktop, you'll need to convert your data to IIF format.

Method 4: Automated Conversion

Tools like SettleBooks can take your raw Shopify payout CSV and output a properly formatted file for your specific QuickBooks version — QBO CSV, IIF for Desktop, or generic CSV for manual review.

Handling Edge Cases

Multi-Currency Payouts

If you sell internationally, some payouts include currency conversion. The converted amount should be used for your journal entry, with the conversion fee recorded separately.

Partial Payouts

Shopify may hold a reserve on new accounts. The reserve amount appears as a separate transaction type and shouldn't be recorded as revenue — it's a timing difference.

Shopify Subscription Fees

Your monthly Shopify subscription is billed separately from payouts. Don't look for it in the payout CSV — it appears on your credit card statement.

Best Practices

1. Record each payout as a separate journal entry. Don't batch multiple payouts together — this makes bank reconciliation much easier.

2. Match the journal entry date to the payout date, not the individual order dates. The payout is when the money moves.

3. Use consistent account names. If you call it "Payment Processing Fees" in one entry, don't switch to "Shopify Fees" in the next.

4. Reconcile monthly. At the end of each month, verify that the sum of all recorded payouts matches your Shopify Payments balance.

5. Keep the CSV files. Store the original payout CSVs as supporting documentation. They're your audit trail.

Summary

Importing Shopify payouts into QuickBooks requires converting the payout CSV into a balanced journal entry with gross sales, fees, refunds, and the net deposit. Whether you do this manually, via CSV import, or with an automated tool, the key is consistency and accuracy. Every payout should produce a balanced entry that matches the bank deposit.