What is Bank2IIF?
Converta CSV / XLS / XLSX, PDF, QFX / OFX / QBO / QIF para IIF
Easy-to-use secure solution to review/convert your transactions and import into your accounting software. Convert CSV/XLS/XLSX, PDF, QFX/OFX/QBO/QIF into IIF and import to QuickBooks (Win/Mac), (Win/Mac)
What can I do with Bank2IIF (CSV/XLS/XLSX converter, PDF, QFX/OFX/QBO/QIF for IIF)?
- Download, install and run the software
- Select a file with transactions
- Review transactions and click Convert to create an IIF file
- Import file created for Quickbooks
Why should I trust Bank2IIF?
- It runs and processes your files on your computer - no data leaves your computer
- It doesn't send your transactions anywhere
Converta CSV, Excel, PDF, QFX, QBO, OFX, QIF para IIF e importe para Quickbooks (Win / Mac)
Step-by-step instructions for Windows
- Make sure you are using the latest version of Bank2IIF. Download it from the Bank2IIF download page. Start Bank2IIF and select a transaction file (can be QBO file, OFX file, QFX file, QIF file, or PDF file).
- Review transactions before conversion, make sure the dates are correct, if the year is correct, if deposits and cashouts are in the correct places.
- Enter the name of the main account to match the bank account in Quickbooks.
- Map the names of beneficiaries or payers to the names of Suppliers or Customers in Quickbooks. In our case, we have three expense transactions (requires vendor assignment) and one revenue transaction (requires customer assignment). Bookstore Invoice, Gas Company, Hydro and Microsoft are Beneficiary names.
- For example, for 'Bookstore invoice', the vendor name is 'Indigo'.
- Click on the 'Beneficiary/Categories' tab. For 'Incoming Recipient', type the name in the 'Checkout' column, as in Quickbooks (for 'Bookstore invoice', type 'Indigo'). Everything else you can leave blank because the converter will not change it.
- The name has been changed.
- Check the customer name (in our case 'Microsoft') in Quickbooks. If you don't have the same name in Quickbooks, you can add it here.
- Map categories or beneficiary names to expense account names in Quickbooks. In our case, we have four categories: Office supplies, Utilities, Utilities and Payroll.
- Click 'Lists' - 'Account plan'.
- In Utilities (Expenses), they are corresponding as well as 'Office material' (expense).
- For Payroll - Income category. It must be revenue consulting.
- Click on the 'Beneficiary/Categories' tab. For 'Entry category' (Payroll), type the name in the 'Output category' column (Consulting revenue).
- Now, all things are in the right order. Make sure that all accounts, vendors, and customers exist in Quickbooks.
- Click the 'Convert' button to create an IIF file.
- Confirm the name and location of the file.
- Import IIF file created for Quickbooks
- Now that the IIF file has been created, switch to Quickbooks and import the created IIF file. Be sure to back up the Quickbooks data file before any IIF import. Click 'Archive' - 'Utilities' - 'Import' - 'IIF Files'. Find the IIF file you just created.
- Done! Transactions are imported.
System requirements
Windows
Microsoft Windows 10/8.1/8/7/2008/2003/Vista/2000/XP
Works with Linux Wine too
User with administrator privileges (see file version below to use without administrator privileges)
Mac
Mac OS X 10.12 or higher (Supports macOS Catalina)
Allow "Mac App Store apps and identified developers" in System Preferences, Security, and Privacy.
