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 bank statements from CSV or Excel directly into QuickBooks Pro, Premier, or Enterprise. No API required.
Free preview — then from $5. Save with bundles.Log in → Reports → Export → Exported reports → Download CSV
Upload Bank CSV Transactions CSV and choose IIF File format
Review converted data, download Quickbooks Desktop-ready file
File → Utilities → Import → IIF Files → Select File
Output is in QuickBooks Desktop IIF format — ready to import directly, no manual reformatting needed.
At minimum, your file needs 'Date' and 'Amount' columns. Optional columns include 'Payee', 'Account', 'Memo', 'CheckNum', and 'Class'. Column names are case-insensitive.
IIF import works with QuickBooks Pro, Premier, and Enterprise versions 2000-2025.
You can create CHECK, DEPOSIT, INVOICE, BILL, or CREDIT CARD transactions. Use 'Auto' to automatically classify based on amount sign.
All conversion runs in your browser. Files are never uploaded to any server.
Nothing is stored after conversion. Close the tab and your data is gone.
Full EU data protection compliance. Your privacy rights are fully protected.
How Banking Csv fields map to Quickbooks Desktop Iif
| Banking Csv | Source Value | Quickbooks Desktop Iif | Target Value | Note | |
|---|---|---|---|---|---|
Date |
01/15/2025 |
→ | DATE |
01/15/2025
|
Transaction date |
Amount |
-50.00 |
→ | AMOUNT |
-50.00
|
Transaction amount (negative=debit, positive=credit) |
Payee |
AMAZON PURCHASE |
→ | NAME |
AMAZON PURCHASE
|
Payee or vendor name |
Account |
Checking |
→ | ACCNT |
Checking
|
Expense/income account for split line |
Memo |
AMAZON PURCHASE |
→ | MEMO |
AMAZON PURCHASE
|
Transaction memo or description |
CheckNum |
REF123456 |
→ | DOCNUM |
REF123456
|
Check number or reference |
Class |
Sales |
→ | CLASS |
Sales
|
QuickBooks class for tracking |
Accepts .csv, .xls, and .xlsx files.
CHECK, DEPOSIT, INVOICE, BILL, or CREDIT CARD.
Auto-detects common column name variations.
Works with QuickBooks Pro, Premier, and Enterprise.
Optional QuickBooks class tracking.
Files process locally. Your data never leaves your computer.
Each CSV row becomes a TRNS/SPL/ENDTRNS block
One row per transaction
Date,
Amount,
Payee,
Account
Hierarchical structure for QuickBooks Desktop import
Issues you might encounter when importing Bank CSV Transactions data to IIF File - and how we solve them
CSV/Excel file must have a 'Date' column
File has 'Transaction Date' instead of 'Date'
Rename column to 'Date' (case-insensitive)
Ensure your file has Date, Amount columns (required)
Download our sample template for correct format
CSV/Excel file must have an 'Amount' column
File has 'Debit' and 'Credit' columns
Combine into single 'Amount' column (negative for debits)
Use negative values for payments, positive for deposits
Edit your spreadsheet before uploading
QuickBooks can't find the specified account name
Account 'Bank Account' not in Chart of Accounts
Create the account first or use exact name
Verify account names match your Chart of Accounts exactly
Edit account names in the tool options before converting
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
// PRICING //
Just start processing on any tool page
Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.
One-time purchase
Best for professionals and content creators
One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.
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 Banking to Quickbooks Desktop
Date → DATE
Amount → AMOUNT
Payee → NAME
FITID → DOCNUM
DTPOSTED → DATE
TRNAMT → AMOUNT
Date → DATE
Amount → AMOUNT
Payee → NAME
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli