Setting up journal entry import

Set up journal entry import

1. From the > Manage menu, click Import Journal Entries.
2. Select Settings.
3. Under Import File Detail, enter:

Field delimiter	Select a field delimiter being used in the .csv file. Note: For a .csv file the delimiter will be a comma (,), other fields might separate fields differently.
Text qualifier	Select a text qualifier (None, ", '). By default, " is selected.
Decimal symbol	Enter a symbol to use as a decimal.
Date delimiter	Enter a date delimiter. By default, / is selected.
Date order	Select the order the date appears in the file.
File contains a header	Check if the file contains a header.
Date leading zeros	Check if the date leads with zeros.
Four digit year	Check to use a four digit year.

4. Under Fields to Import, select from the available columns:

Reference	Reference associated with the journal entry
Notes	Additional information associated with the journal entry that does not fit into other columns
Detail Notes	Notes about the detail entry
Account ID	The ID for the account for the journal entry
Account Key	The database identifier of the account associated with the journal entry
Department Key	The database identifier of the department associated with the journal entry

To delete columns, click the next to the column. The following are default columns and cannot be removed:

Basis	The basis of the journal entry
Accounting Date	The accounting date associated with the journal entry
Description	The description of the journal entry
Account Description	The account description of the journal entry
Department	The name of the department associated with the journal entry
Debit Amount	The debit amount of the journal entry
Credit Amount	The credit amount of the journal entry

5. Click Save.

Note:

A journal entry is created based on common Basis, Accounting dates, Description, and Reference (if included). Total Debits and Credits must equal zero.