Journal Import File Parameters

This table is triggered when a data from an external .txt file is imported into a journal in Miscellaneous Journals.

The file name is displayed and each of the field descriptions is listed.
A Excel spreadsheet column letter is assigned to each field description. These Excel Column letters can be changed to match the data fields to the corresponding columns.

Note: To ensure the tab-delimited file is saved in the correct format when creating the spreadsheet manually without using the template, leave a blank row with an * in the first column before entering the rows of data.

Click ACCEPT when the sequence is correct, to view the transactions to post with the debit and credit details, including the 'G/L Account#', 'Division', 'Amount', Debit or Credit, 'Source', 'Reference', and 'Details'.
The Tax Code fields 'Tax Code' and 'Tax Rec Code' are only included in the import if the Calculate Tax On flag in the Company Taxing Parameters is set to 'Journals/Checks' or ' Both'.

Click EXP/CON or press <F9> to view the Reference, Details and any errors on the transactions that may prevent the file from being loaded.

Errors:
Any data errors will trigger a warning and will cause the import to be aborted.

Data File requirements:

Data is not in the correct columns
The G/L accounts must be valid in Chart Of Accounts.
G/L Control accounts for A/R or for A/P cannot be used unless the user is the SCS operator.
Divisions must be valid in Divisions file and be flagged as a G/L Division, or Both.
Debits and Credits must be in balance and identified with D or C.
An associated Tax Code must be assigned if the G/L account is not already in the Tax table, if the Calculate Tax On flag in the Company Taxing Parameters is set to 'Journals/Checks' or ' Both'.
The corresponding Tax 'Rec' Code must be assigned if this is a tax transaction and the G/L posting account is in the Tax table, if the Calculate Tax On flag in the Company Taxing Parameters is set to 'Journals/Checks' or ' Both'.

Click OK to accept the import file and to be either prompted to continue to Add the Transactions to the Journal and continue, or to acknowledge a loading error.
Fix any errors in the import data and re-import the file.

ACTIONS:
Additional actions provided by buttons on the Journal Import File Parameters screen include: