

Using the IIF Transaction Creator, you can import these types of transactions:ĭownload the IIF Transaction Creator for a free trial before you purchase. Most QuickBooks transaction types are supported for import. Integrate with your QuickBooks company to create a custom IIF file designed just for your company for a smooth and reliable import.Optional automatic extended amounts for sales (enter the Qty and Rate only, for example) as well as optional automatic sales tax calculation on sales transactions.Automatic name and account conflict resolution for easy import into QuickBooks, for both existing and new “list” records like customers, accounts, and items.Built-in error checking for better results.Include just one or up to thousands of transactions in your IIF files at a time.Import financial transactions from Excel into QuickBooks.Examples are available from the IIF Transaction Creator’s menu and can be used as templates.

Several layout options are supported including a simple single-row layout and more complex multi-row layouts that resemble a QuickBooks Journal report.

To use the IIF Transaction Creator, arrange your data in row/column layouts on a spreadsheet. It integrates with and is used from within Excel. The IIF Transaction Creator converts worksheet data into IIF files for import into QuickBooks. Import transactions from Excel into QuickBooks The IIF Transaction Creator helps you import transactions from Excel worksheets into QuickBooks.
