You can import a journal by dropping the file (using windows drag-drop) onto the Journal Entry Screen.
The file must be a .TXT or .CSV and must be comma separated.
The first row of the file must contain the field names as shown below.
Where more than one field name is shown, either can be used.
Not all fields need to be specified, and the order is not important.
If the amounts are in cents (ie no decimal point) then use CENTS, otherwise use AMOUNT.
If you only have one branch, then BRANCH can be omitted.
"DATE"
"ACCOUNT", "ACCT_CODE", "ACC"
"REF1", "REFERENCE", "REFERENCE1"
"REFTYPE1", "REF_TYPE1"
"CLIENTID", "CLIENT", "CUST_NO", "CUSTOMER"
"TYPE", "TRAN_TYPE"
"DESCRIPTION", "NARRATION"
"AMOUNT"
"CENTS"
"REF2", "REFERENCE2"
"REFTYPE2", "REF_TYPE2"
"BRANCHID", "BRANCH_ID", "BRANCH"
Example Templates in .CSV Format - With Branch:
Import Journal With Branch Template.csv
Example Templates in .CSV Format - Without Branch:
Import Journal Without Branch Template.csv