IIF to QBO Converter
Upload your IIF file and download clean QBO. Fast conversion, no manual copy-paste.
QBO/QFX files may need a bank-specific Intuit ID to import into QuickBooks or Quicken without a warning.
Free · preview before you download · free account to export.
How to convert IIF to QBO
- 1
Upload your IIF file
Drag and drop your .iif file, or click to browse.
- 2
Convert it
Statement to Sheets reads the file and creates a clean QBO output.
- 3
Download your QBO file
Your QBO (.qbo) file downloads automatically, ready to import.
Why convert IIF to QBO?
Use this when you have a file in one format and need a clean QBO file without rebuilding it by hand.
- Upload your IIF file and download QBO
- Avoid manual copy-paste and formatting cleanup
- Works with real-world exports that do not follow a perfect template
Example: before and after
A sample IIF file and the exact QBO this tool produces from it.
Input · .iif
!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT
!ENDTRNS
TRNS DEPOSIT 06/02/2026 Checking Direct Deposit ACME Payroll 4200.00
SPL DEPOSIT 06/02/2026 Income -4200.00
ENDTRNSOutput · .qbo
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO</STATUS><DTSERVER>20260602120000<LANGUAGE>ENG<FI><ORG>Statement to Sheets<FID>10000</FI><INTU.BID>3000</SONRS></SIGNONMSGSRSV1><BANKMSGSRSV1><STMTTRNRS><TRNUID>1<STATUS><CODE>0<SEVERITY>INFO</STATUS><STMTRS><CURDEF>USD<BANKACCTFROM><BANKID>000000000<ACCTID>000000000<ACCTTYPE>CHECKING</BANKACCTFROM><BANKTRANLIST><DTSTART>20260602<DTEND>20260602<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260602<TRNAMT>4200.00<FITID>202606020<NAME>Direct Deposit ACME Payroll<MEMO>Direct Deposit ACME Payroll</STMTTRN></BANKTRANLIST><LEDGERBAL><BALAMT>0.00<DTASOF>20260602</LEDGERBAL></STMTRS></STMTTRNRS></BANKMSGSRSV1></OFX>What ends up in your QBO file
| QBO field | Comes from |
|---|---|
| DTPOSTED | Transaction date (YYYYMMDD) |
| TRNAMT | Signed amount |
| TRNTYPE | DEBIT or CREDIT, derived from the amount sign |
| NAME / MEMO | Description |
| INTU.BID | QuickBooks Web Connect branding block (generic by default) |
Tips
- QBO/QFX files carry a generic Intuit bank ID. QuickBooks or Quicken may ask you to confirm the bank on first import.
- Files up to 8 MB are supported. Very large files may be summarized before AI conversion.
Frequently asked questions
Is the IIF to QBO converter free?
Yes — it's completely free, with no sign-up required.
What is a IIF file?
IIF (Intuit Interchange Format) is a tab-delimited format for importing lists and transactions into QuickBooks Desktop.
What can I do with the QBO file?
QBO is the QuickBooks Web Connect file used to import bank transactions directly into QuickBooks.
Is my financial data private?
Your file is processed only for the conversion, never sold, and not stored by this converter after the conversion runs.
Is there a file size limit?
Files up to 8 MB are supported, which covers even multi-year exports.
Will the QBO file import into QuickBooks or Quicken?
QBO/QFX files may need a bank-specific Intuit ID to import into QuickBooks or Quicken without a warning.
Other IIF conversions
Convert other files to QBO
Related guides
Got a bank statement PDF instead?
Statement to Sheets turns statement PDFs into clean Excel, CSV, and accounting exports. Free to try.
Convert a statement