For an overview of EQ to QuickBooks compatibility and data that can be exported from EQ and imported into QuickBooks Desktop see this QuickBooks IIF article. This article covers how to export sales invoices from EQ into an IIF export file ready for QuickBooks (desktop).
Exporting sales invoices/credits
To follow these steps you will need to have raised at least 1 invoice or credit note for a sales order. See sales invoices overview. You may also want to export your customer list so that your customers and same account codes exist both in EQ and QuickBooks. See export customers (csv).
1. From the top menubar click File > Export... > Export Sales Invoices:
2. In the screen that opens enter invoice date range to search for invoices:
3. Click Search and a list of invoices and credit notes will be shown (as above)
4. Tick all of the invoices/credits you wish to export (or click Select All at the bottom).
Then click Export Sales Invoices.
5. The final screen allows you to set a location by clicking the options (...) button and browsing your computer for a folder.
Select File Type as QuickBooks2003
6. Click Export.
The IIF file will be saved to your chosen folder.
Import to Quick Books
- Open Quick Books at the main screen.
- Click File > Utilities > Import > Import IIF Files.
- Browse to the file you just created and begin the import. (Unless you changed location, it will be in C drive named SalesInvoices.iif)
- Quick Books will inform you the import has been successful.
As QuickBooks enforces ‘double-entry’ bookkeeping, the export creates two ledger entries for each sales invoice. One entry is made into the customer’s account and another entry is made into the ‘Accounts Receivable’ account for the opposite amount to ensure that the ledger balances.
All exports and imports should be carried out on a regular basis to ensure your accounts software is kept up-to-date.
For more detail about importing see the QuickBooks article here: QuickBooks instructions on how to import your transactions.