Journals
Journals are uploaded on a line by line basis. Only journals which balance (total of zero) will be uploaded.
Field Mapping (mandatory fields in RED)
|
E2S Field |
SAGE Field |
Location within Sage |
Length |
Notes |
|
NomCode |
Nominal Code |
Nominal Ledger Record - Activity Screen |
8 |
Nominal Code this Journal is for. Please note that this must also be a valid Bank Account in Sage. |
|
Ref |
Ref |
Nominal Ledger Record - Activity Screen |
30 |
The key field for this tab. We will check that grouped records on the Ref field balance to zero before uploading. |
|
ExtRef |
Ex. Ref. |
Nominal Ledger Record - Activity Screen |
30 |
|
|
Date |
Date |
Nominal Ledger Record - Activity Screen |
10 |
|
|
Details |
Details |
Nominal Ledger Record - Activity Screen |
60 |
|
|
Dept |
n/a Dept |
n/a |
2 |
Not visible on Journal Activity screen |
|
TaxCode |
n/a Tax Code |
n/a |
2 |
Not visible on Journal Activity screen |
|
Value |
Credit / Debit |
Nominal Ledger Record - Activity Screen |
8 |
Any positive value will result in a Debit and negatives a Credit transaction |
|
Total |
n/a - Not uploaded |
n/a - Not uploaded |
|
This is used as a guide only to ensure you have a value of zero for the sheet. however, as the NomCode and Ref fields are used to separate journals you should take extra care to ensure all will balance. |
NB: Sage will accept one side of a journal but reject another with an error such as invalid nominal code causing one-sided postings. In the event of this happening a balancing journal will be required to solve the imbalance.