Exporting a Batch File to Quickbooks
QuickBooks Software recognizes and is compatible only with .IIF format for importing data into QuickBooks. When generating the General Ledger file from the batch profile, the file should be saved to the desktop to be imported.
The file generated is in the following format:
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!SPL TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!ENDTRNS
TRNS 1 GENERAL JOURNAL 07/25/2008 100000000000 netFORUM -0.79 JD Test 3
SPL 2 GENERAL JOURNAL 07/25/2008 1000100-CA netFORUM 63.79 JD Test 3
SPL 3 GENERAL JOURNAL 07/25/2008 111144445555 netFORUM -7 JD Test 3
SPL 4 GENERAL JOURNAL 07/25/2008 125-224-2244 netFORUM -1 JD Test 3
SPL 5 GENERAL JOURNAL 07/25/2008 4000990-RV netFORUM -20 JD Test 3
SPL 6 GENERAL JOURNAL 07/25/2008 4455556666666 netFORUM -35 JD Test 3
ENDTRNS
In Excel the format is as follows:
| !TRNS | TRNSID | TRNSTYPE | DATE | ACCNT | NAME | AMOUNT | MEMO |
| !SPL | TRNSID | TRNSTYPE | DATE | ACCNT | NAME | AMOUNT | MEMO |
|
!ENDTRNS |
|||||||
| TRNS | 1 | GENERAL JOURNAL | 7/25/2008 | 100000000000 | netFORUM | -0.79 | JD Test 3 |
| SPL | 2 | GENERAL JOURNAL | 7/25/2008 | 1000100-CA | netFORUM | 63.79 | JD Test 3 |
| SPL | 3 | GENERAL JOURNAL | 7/25/2008 | 111144445555 | netFORUM | -7 | JD Test 3 |
| SPL | 4 | GENERAL JOURNAL | 7/25/2008 | 125-224-2244 | netFORUM | -1 | JD Test 3 |
| SPL | 5 | GENERAL JOURNAL | 7/25/2008 | 4000990-RV | netFORUM | -20 | JD Test 3 |
| SPL | 6 | GENERAL JOURNAL | 7/25/2008 | 4455556666666 | netFORUM | -35 | JD Test 3 |
|
ENDTRNS |
|||||||
The first three rows are header information for the file.
Column 1: Column indicator (TRNS line indicates the beginning of the transaction; SPL lines indicate the distributions for TRNS).
Column 2: Sequential count
Column 3: GENERAL JOURNAL (fixed text)
Column 4: NetFORUM batch date
Column 5: netFORUM G/L account
Column 6: netFORUM (fixed text)
Column 7: $ amount (positive for debit and negative for credit)
Column 8: Net Forum batch name
QuickBooks Version Notes
These are version notes for QuickBooks.
All Versions
To import files, create a customer named netFORUM in the client list within QuickBooks. Instructions to import .IIF files can be found at:
http://support.QuickBooks.intuit.com/support/pages/executable/iif/iif_import_kit.zip
QuickBooks 2006-2008
If there are sub-accounts setup in QuickBooks, the accounts must be setup in netFORUM Pro with both the account and sub-account as the General Ledger Account, separating the two with a colon.
Example: Account:Sub-Account
If there are sub-accounts within sub-accounts, the following would be used:
Example: Account:Sub-Account:Sub-Account
If this is not done, during the import, QuickBooks will create a new account and make entries against the newly created account.