Shopify Payouts to QuickBooks — Reconcile Fees & Deposits

🥦

QuickBooks Journal Entry / Bank Deposit Format

Ready for download

Orders converted

Finally reconcile Shopify deposits with your bank statement. Automatically breaks out processing fees so your books balance.

No API required

Browser-based processing

Run on Google Cloud Platform

Download Sample Shopify Payouts

Sample payout CSV to test the converter

Download Sample

Rate this tool

4.8 / 5 (5,381 votes)

How It Works

Export Payouts from Shopify

Settings → Payments → View payouts → Transactions → Export

Upload & Preview

Drop your payout CSV. See fee breakdown instantly.

Choose Output Format

Journal Entry (professional) or Bank Deposit (simple)

Download & Import

Import to QuickBooks. Watch your bank reconcile perfectly.

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files under 50MB process in your browser. Your data never touches our servers.

Auto-Delete

Server-processed files automatically deleted within 24 hours.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

What Gets Converted

See how Shopify payouts transform into QuickBooks entries

Shopify Transactions

Journal Entry

Converts to Quickbooks Online format

Field Mapping

How Shopify payout fields become QuickBooks entries

Shopify Transactions	Source Value		Quickbooks Online Journal Entry	Target Value	Note
`processed_at`	`2025-01-15T10:30:00-05:00`	→	`JournalDate`	`01/15/2025`	Transaction date to MM/DD/YYYY
`payout_id`	`Sample Text`	→	`JournalNo`	`JE-PO-20250115`	Groups entries by payout
`amount`	`100.00`	→	`Credit`	`100.00`	Gross sales credited to revenue
`fee`	`3.20`	→	`Debit`	`3.20`	Processing fees debited to expense
`net`	`96.80`	→	`Debit`	`96.80`	Net amount debited to bank account
`type`	`charge`	→	`Description`	`charge`	Transaction type determines entry
`currency`	`USD`	→	`Currency`	`USD`	ISO currency code

Problems We Fix Automatically

Common payout reconciliation errors this tool prevents

Journal Entry Doesn't Balance

Total debits must equal total credits to the penny

All entries validated to balance before export. Rounding differences auto-corrected.

Fees Not Showing in Expenses

Importing just net deposits hides processing costs

Fees extracted and mapped to expense account

Deposit Amount Doesn't Match Bank

If you import gross instead of net, bank won't reconcile

Net amount calculated to match your actual bank deposit

Multiple Transactions per Payout

Shopify batches many transactions into single payout

Transactions grouped by Payout ID automatically

Refunds Showing as Positive

Refunds in payout export need opposite treatment

Refund rows detected and signs handled correctly

Why Use This Tool?

Fee Breakdown

Processing fees extracted from net payouts and mapped to expense account. See your true profit margin.

Bank-Ready Output

Net deposit amounts match your bank statement exactly. No more reconciliation mysteries.

Balanced Entries Guaranteed

Every journal entry is validated: debits = credits. QuickBooks will accept without errors.

Payout Grouping

Multiple transactions bundled into single payout? We group them correctly by Payout ID.

Refund Handling

Refunds in payout exports are detected and handled with correct signs.

Browser-Based Privacy

Files under 50MB process entirely in your browser. Financial data never leaves your computer.

Frequently Asked Questions

Shopify withholds processing fees (2.9% + $0.30) before depositing. Your bank sees the NET amount. This tool breaks out the gross sales and fees so your books show both correctly.

Journal Entry gives full double-entry accounting with separate lines for income, fees, and deposits—preferred by accountants. Bank Deposit is simpler—just matches your bank feed with fees as a negative line.

Go to Settings → Payments → View payouts → click any payout → View transactions → Export. Or Finance → Balance → Transactions → Export for all at once.

Yes. Every journal entry is validated to ensure total debits equal total credits. QuickBooks will accept all entries without balance errors.

Refunds appear in payout exports with negative amounts. We detect these and handle them with the correct accounting treatment (reducing income, not adding expense).

Chargebacks appear in the payout export with type='dispute'. We map these to appropriate accounts. The $15 dispute fee is also captured.

Yes. Export your full date range from Shopify. Each payout date creates separate entries.

At minimum: a bank account, an income account (Sales Income), and an expense account (Merchant Fees or Payment Processing). We use standard names you can customize in QBO.