Credit Bundles
One-time purchase
- No monthly commitment
- Credits valid for one year
- Access to all tools
- Full file downloads
Enter your email to receive a sign-in link
Import Shopify orders to QuickBooks Pro, Premier & Enterprise. The IIF format Intuit discontinued but Desktop still accepts.
Orders → Export → Export orders
Upload Orders Export CSV and choose IIF File format
Review converted data, download Quickbooks Desktop-ready file
File → Utilities → Import → IIF Files → Select File
256-bit SSL encryption. Same standards as major financial institutions.
Files are processed directly in browser. No calls to our servers.
Full EU data protection compliance. Your privacy rights protected.
How Shopify Orders fields map to Quickbooks Desktop Iif
| Shopify Orders | Source Value | Quickbooks Desktop Iif | Target Value | Note | |
|---|---|---|---|---|---|
Name |
#1001 |
→ | DOCNUM |
#1001
|
Order number as document ID |
Created at |
2025-01-15T10:30:00-05:00 |
→ | DATE |
01/15/2025
|
Transaction date MM/DD/YYYY |
Billing Name |
John Smith |
→ | NAME |
John Smith
|
Customer name (max 41 chars) |
Total |
149.99 |
→ | AMOUNT |
149.99
|
Transaction amount |
Subtotal |
129.99 |
→ | AMOUNT (SPL) |
|
Product sales to income account |
Shipping |
10.00 |
→ | AMOUNT (SPL) |
|
Shipping to shipping income |
Taxes |
10.00 |
→ | AMOUNT (SPL) |
|
Tax to Sales Tax Payable |
Generates proper IIF structure with !TRNS, !SPL, and !ENDTRNS markers. Ready for File → Import → IIF Files.
Works with QuickBooks Pro, Premier, and Enterprise versions 2020-2025.
Works with standard Shopify CSV export. No Shopify app, no API connection.
Shopify exports one row per product. We aggregate into single Desktop transactions.
Files process entirely in your browser. No calls to our servers.
Shipping, discounts, and taxes mapped to separate accounts for proper reporting.
Line items aggregated per order, then each order expands to IIF TRNS/SPL rows
One row per line item (same order appears multiple times)
Name,
Total,
Subtotal,
Shipping,
Taxes
Each order becomes a TRNS header + multiple SPL splits + ENDTRNS
Issues you might encounter when importing Orders Export data to IIF File - and how we solve them
QuickBooks Desktop requires exact account name matches
Account: 'Sales Income' (not in your Chart)
Account: 'Sales' (matches your Chart of Accounts)
Configure account names to match your QuickBooks Desktop setup
Check File → Chart of Accounts and update settings
QuickBooks Desktop can't parse the IIF file structure
Missing header row or wrong delimiters
!TRNS header with tab-delimited data
IIF files require specific header and structure - we handle this
Our converter generates valid IIF with correct !TRNS/!SPL headers
QuickBooks Desktop limits names to 41 characters (vs 100 for Online)
Long Customer Name With Extra Details...
Long Customer Name With Extra...
Customer names are truncated to 41 characters for Desktop
Names are automatically shortened to fit QBD limits
IIF transactions require TRNS amount = sum of SPL amounts
TRNS: $100, SPL: $90 + $5 (missing $5)
TRNS: $100, SPL: $90 + $10 (balanced)
All transactions are auto-balanced with proper split lines
TRNS and SPL rows are calculated to always balance
Buy bundles and get up to 27% off. Check our pricing options below.
// PRICING //
One-time purchase
Best for professionals and content creators
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.
Files process entirely in your browser. We're GDPR compliant with TLS encryption.
Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.
Terms of service applies. VAT included where applicable.
All available data flows from Shopify to Quickbooks Desktop
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus