Journals

From version 2025.10.1 Journals are loaded in a new format which collects detail lines and posts them under a header record which makes it impossible to post an unbalanced journal. This new method is also faster. Previously, they were uploaded on a line by line basis.

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		No longer needed from v2025.10.1. Previously this was 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.