Been searching for something like this for months. Our Shopify store processes 500+ orders monthly and this handles everything perfectly. Date formats, tax columns, refunds - all correct.
Import Shopify Payouts to QuickBooks — With Fee Breakdown
or drop .csv, .xls, .xlsx files here
or
Invoice import blocked if Sales Tax enabled in QBO
Import Complete
QuickBooks Journal Entry Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
imported
Rows skipped
credits
Credits Calculation:
rows → rows (rounded to 1K) → credits
then credit per 1K rows
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
CSV, Excel, Google Sheets — pay once, download any format
Use credits to download
Click any download button to use your credits
All formats unlocked - download as many times as you need
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
What Our Users Say
works good, wish it had batch mode
I was spending 4-5 hours every month reformatting exports manually. This tool paid for itself in the first use. The preview feature helped me verify the mapping before paying.
exactly what i needed thx!!
Super straightforward. Upload, convert, download. No account needed which is nice. Would give 5 stars if they add Xero support.
saved me hours of work
My accountant was so happy when I sent her the converted file. No more back-and-forth about date formats or missing columns. Everything imported correctly on first try.
fast and easy 10/10 would recommend
Been using this for 6 months for monthly reconciliations. Handles all the edge cases - partial refunds, multi-line orders, currency conversions. Very reliable tool.
Good tool, does what it says. Interface could be bit better but conversion quality is excellent. Using it for my 3 Shopify stores.
Switched from A2X to this. Way simpler for my needs - I don't need real-time sync, just clean data once a month. This delivers exactly that.
finally!! something that works with QB desktop!!
// PRICING //
Need more credits?
Credit Bundles
$
/Credit
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Monthly Bundles Pro
$
/Credit
Best for professionals and content creators
Annual Discount
Per month, billed annually:
Save 20% more
- Credits refresh monthly
- Priority processing
Purchase Credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
How are credits calculated?
Credits are based on rows in your file. Each tool shows its rate (e.g., 2,000 rows = 4 credits). We round up to the nearest step. Minimum 1 credit per conversion.
Is my data secure?
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Can I get a refund?
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Powered by
Paddle
Terms of service applies. VAT included where applicable.
Ready to import your own data?
Import your Shopify payouts to QuickBooks with processing fees broken out.
No API required
Browser-based processing
Run on Google Cloud Platform
How It Works
1
Export
Export payouts from Shopify Settings → Payments → View payouts → Transactions → Export, or Finance → Balance → Transactions → Export
2
Upload and Configure
Upload your payout CSV file and configure account mappings (Bank Account, Sales Account, Fees Account)
3
Preview and Export
Review fee breakdown preview and download the Journal Entry CSV
4
Import to Target
Import to QuickBooks Online via Settings → Import Data → Journal Entries
Your Data is Safe
Bank-Level Security
256-bit SSL encryption. Same standards as major financial institutions.
No Data Storage
Files are processed directly in browser. No calls to our servers.
GDPR Compliant
Full EU data protection compliance. Your privacy rights protected.
Field Mapping
How Shopify Transactions fields map to Quickbooks Online Journal Entry
| Shopify Transactions | Source Value | Quickbooks Online Journal Entry | Target Value | Note | |
|---|---|---|---|---|---|
Date |
2025-01-15 |
→ | JournalDate |
01/15/2025
|
Transaction date to MM/DD/YYYY |
Amount |
100.00 |
→ | Credits |
100.00
|
Gross sales credited to revenue |
Fees |
2.90 |
→ | Debits |
2.90
|
Processing fees debited to expense |
Data Transformation
Transactions aggregated by payout, then each payout expands to 3-7 JE lines
Input
Shopify Balance Transactions
Multiple transactions per payout (charges, refunds, fees, disputes)
Key columns:
Amount,
Fee,
Net,
Type,
Payout ID
N:M — Complex transformation
Output
Journal Entry Lines
3-7 rows per
input
Double-entry accounting separating gross sales, fees, and net deposit
DR
Bank Deposit
DEBIT bank: net amount that hit your bank
DR
Processing Fees
DEBIT expense: Shopify/payment processing fees
CR
Gross Sales
CREDIT income: gross sales revenue (matches 1099-K)
DR
Refunds
DEBIT income: reduce revenue for refunds
DR
Disputes
DEBIT income: chargebacks reduce revenue
DR
Dispute Fees
DEBIT expense: $15 chargeback fee per dispute
Debits must equal Credits (Bank + Fees = Gross - Refunds - Disputes)
Why Shopify Deposits Never Match Your Bank
The Net Deposit Problem
You sold $1,000 on Shopify. Your bank shows a $970 deposit. Where did $30 go?
Shopify withholds processing fees (2.9% + $0.30 per transaction) before depositing.
Your bank sees $970. QuickBooks sees $970. But your sales were $1,000.
Without breaking out fees, your books show $970 revenue instead of $1,000 revenue + $30 expense.
What This Tool Does
We parse your Shopify payout export and create QuickBooks entries that show:
- Gross sales: $1,000 (what you actually sold)
- Processing fees: -$30 (the expense)
- Net deposit: $970 (what hit your bank)
Now your revenue is correct AND your bank reconciles.
Common Journal Entry Import Errors
Issues you might encounter when importing Payouts/Transactions data to Journal Entry - and how we solve them
Unbalanced Journal Entry
QuickBooks requires Debits = Credits for each journal entry
Debit: $970, Credit: $1000 (unbalanced)
Debit: $970 + $30, Credit: $1000 (balanced)
We auto-calculate balanced entries: Bank + Fees = Sales
Each payout creates a balanced entry with fee breakdown
Account Names Not Found
QuickBooks import fails if account names don't match your Chart of Accounts
Account: 'Shopify Sales' (not in your QB)
Account: 'Sales Income' (matches your QB)
Configure your actual account names before converting
Use the account settings to match your QuickBooks Chart of Accounts
Duplicate Journal Number
Importing the same payout twice creates duplicate entries
Payout #12345 imported twice
Each payout ID is unique
Journal numbers include payout ID to prevent duplicates
Check your date range to avoid re-importing processed payouts
Bank Deposit Doesn't Match
Your bank shows $970 but you recorded $1000 in sales
$1000 sales recorded, $970 bank deposit (where's $30?)
$1000 sales - $30 fees = $970 bank deposit
Journal entries separate gross sales from processing fees
Fees are tracked separately so bank reconciliation works
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 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 is the only correct way to import payouts. It provides full double-entry accounting with separate lines for income, fees, and deposits. Bank Deposit format loses fee detail and creates incorrect books.
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.
Shopify → Quickbooks Online Data Ecosystem
All available data flows from Shopify to Quickbooks Online
Shopify
Customers Export
Customer profiles with contact info, addresses, and marketing preferences
→
Quickbooks Online
Customer Import
Customer profiles with contact and billing information
First Name → First Name
Last Name → Last Name
Email → Email
Shopify
Orders Export
Customer orders with line items, shipping, taxes, discounts, addresses
→
Quickbooks Online
Invoice
Accrual-basis B2B sales (payment pending)
Name → InvoiceNo
Created at → InvoiceDate
Created at → DueDate
Shopify
Orders Export
Customer orders with line items, shipping, taxes, discounts, addresses
→
Quickbooks Online
Sales Receipt
Cash-basis B2C sales (payment received at checkout)
Name → RefNumber
Created at → TxnDate
Billing Name → Customer
Shopify
Payouts/Transactions
Shopify Payments transactions, fees, and bank deposits
→
Quickbooks Online
Journal Entry
Double-entry accounting with debits/credits
Date → JournalDate
Amount → Credits
Fees → Debits
Shopify
Products Export
Product catalog with variants, pricing, inventory, and images
→
Quickbooks Online
Products and Services Import
Product and service items for invoicing and sales
Title → Name
Variant SKU → SKU
Variant Price → Sales Price/Rate
Shopify
Refunds (via Orders Export)
Refunded orders filtered from Orders export. Filter by Financial Status = refunded.
→
Quickbooks Online
Journal Entry
Double-entry accounting with debits/credits
Created at → JournalDate
Name → JournalNo
Refunded Amount → Debits
Shopify
Tax Summary Report
Sales tax collected by jurisdiction for liability posting
→
Quickbooks Online
Journal Entry
Double-entry accounting with debits/credits
Period End → JournalDate
Tax Jurisdiction → Account Name
Tax Collected → Credits