|
|
|
|
|
Navigator > Tasks > General Ledger > Import Batch
The Accredo General Ledger Export option in IMS Payroll produces a comma separated value (CSV) file in the following format, this is imported as shown:
Field |
Width |
Description |
Imported as |
Period Number |
2 N |
From GL Export Wizard |
Period in current year - (if outside the range 1..12, Accredo aborts the import) |
Transaction Date |
"dd/mm/yyyy" |
Common Reporting Date of pay period that this transaction was posted from. |
Journal date |
Reference Code |
"1 Alpha" |
Default of "G" |
Ignored |
General Ledger Code |
"Alpha" |
Account Code that his transaction will be posted to. |
GL Account Code |
Reference |
"Alpha" |
From GL Export Wizard. This is a Reference code to identify transactions in this interface file. The user enters the reference when creating the file in IMS. |
Reference |
Journal |
"Alpha" |
From GL Export Wizard. This is a Journal reference used to identify transactions in this interface file. The user enters the journal reference when creating the file in IMS. |
Comment |
Amount |
Numeric |
Transaction Amount, may be negative, includes two decimals. |
Amount Credits are negative Debits are positive |
Required Field |
1 N |
Value 0 |
Ignored |
Required Field |
1 N |
Value 0 |
Ignored |
Required Field |
"1 Alpha" |
Value ' ' (1 space) |
Ignored |
Required Field |
"5 Alpha" |
Value ' ' (5 spaces) |
Ignored |
Branch Code (Accredo Saturn Only) |
"4 Alpha" |
An optional field. The first set of a maximum of 4 characters following a General Ledger Code - delimited by a nominated delimiter. For example, if the General Ledger code was "3340.000:HO:SAL", and the Delimiter ":" was selected in the output, "HO" would be returned. |
Branch Code
|
Department Code (Accredo Saturn Only) |
"4 Alpha" |
An optional field. The second set of a maximum of 4 characters following a General Ledger Code - delimited by a nominated delimiter. For example, if the General Ledger code was 3340.000:HO:SAL, and the Delimiter ":" was selected in the output, "SAL" would be returned. |
Department Code |
All Alpha fields, including the Transaction Date, are enclosed in double quotes. All fields are separated by commas.
For Accredo Saturn, if no Branch and Department code are supplied, the user default Branch and Department code will be used. (Saturn only)
NOTE: When exporting the General Ledger file from IMS Payroll. If you have entered Branch and Department codes with the General Ledger Account Codes in IMS, it is important to enter the Delimiter used to separate the GL Account Code, Branch Code and Department code. For example, if a sample General Ledger Code entered in IMS was "3340.000:HO:SAL", you would select the Delimiter : (colon) in the General Ledger Export.
An example line from the file is:
6,"30/09/2025","G"," 3350.000","TEST","J1",2000.00,0,0," "," ","HO",SAL"