@Chookje wrote:
Unless I'm missing something, that solution to convert IIF files to CSV does not work. As far as I can tell, CSV files have a 3-4 column format that only imports to 1 account in Quickbooks. How are you supposed to take an IIF file (which has splits across multiple accounts) and use a CSV file to import it? Please let me know if I'm missing something here, but it seems like this solution does not work at all.
How can Intuit not support it's own file format in QBO? This is simply unacceptable.
If I may add my twopen'orth ... 3-4 column csv import is for Bank Transaction import only (for reconcile).
You can import other transactions (with splits) - Invoices, Credit Notes, Sales Receipts, Bills, Journals - via https://app.qbo.intuit.com/app/importdata
Each option in there has it's own Import Guide, Preview & Sample csv file.
You can't import Expenses or Cheques by csv - you could (sort of) enter these as Journals as a workaround.
You can't import Bill Payments by csv - they must be entered into QBO in order to make the link between the Bill & the Payment.
My guess is that iif files will never be supported by QBO - even later versions of QBD didn't exactly shout about it - it's old technology (for want of a better phrase). CSV import is purely there as a feature to tick a box (it works but I don't think I'd want to rely on it).
In the programmers' minds, the way forward for linking different systems are APIs. They allow for much more "complete" connection.
Hope this helps.
