CSV to IIF for QuickBooks: use QBO instead
RowBalance does not write IIF. For bank transactions, QBO is usually the better file anyway. Here is the difference.
No statement to hand? Try a sample: ·
What IIF is
IIF (Intuit Interchange Format) is a tab-delimited text format with header rows such as !TRNS, !SPL and !ENDTRNS, used to import lists and transactions into QuickBooks Desktop. It writes journal-style entries: you must supply the accounts for each side, so a bank CSV needs mapping to a chart of accounts before it can become IIF.
Why QBO fits bank data better
A QBO (Web Connect) file is a bank statement. QuickBooks puts the transactions in the bank feed, where you categorise and match them, and it uses each transaction ID to avoid importing the same transaction twice. No account mapping is needed in the file.
When you still want IIF
If you need to post pre-categorised journal entries to QuickBooks Desktop, IIF is the tool, and it needs a spreadsheet of your own. Use the converter below to get clean, balance-checked CSV for that spreadsheet.
How to do it
- Drop the bank CSV or PDF statement above.
- Check the balance badge.
- For bank-feed style import, download QuickBooks (.qbo). For IIF, download CSV and map the accounts yourself.
Excel and CSV are free for up to 5 pages a day. QuickBooks, Xero and OFX files and batch conversion are on paid plans, from a $9 one-off pass: see pricing or go back to the converter.
Questions
Does RowBalance export IIF?
No. It exports Excel, CSV, QuickBooks QBO, Xero CSV and OFX.
Does QuickBooks Online import IIF?
No. IIF is for QuickBooks Desktop. QuickBooks Online imports bank transactions from QBO, CSV and similar files through its upload screen.