To aid the entry of a nominal journal, PostTrans allow the user to specify a contra nominal account, and calculate the total Credits/Debits listed in your Sage Nominal Journal, and post the opposite side on the journal to the specified Sage Contra account.

Example: Press Help, on the PostTrans toolbar, then select example “Contra Nominal Journal” which is the example discussed below.  You should also have read the "Importing Transactional Data" on the Training page for a basic understanding of PostTrans basics.

Simply open a blank Excel spreadsheet and press Import button.  PostTrans will then offer you all of the import tags to create a new PostTrans template.  Double click on the PostTrans tag Sage50TransNom.  A new Journal template will be created:

To specify the Contra Nominal, Department and Description select cell D6, then Double click on Tag THTaxContNom, in the PostTrans Tags side bar.  This will define the Nominal Contra Nominal code.  Next we add THContraDept, and THContrDesc in cells D7 and D8.

Now move back to cell D6, and press space and then tab to select the contra nominal code, and then the Department in D7.

This gives us:

Now when we press the import button, PostTrans will show the Sage 50 Nominal Journal summary:

Pressing Post Transaction button will post the transaction.

Demonstration Video

 

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name	Data Type	Description
THContraNom^	Text	Post the opposite side of the nominal value to this nominal code. For Header use only.
THContraDept^	Text	Department for Contra line
THContraDesc	Text	Description for Nominal Contra line

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a lookup field (Popup search), delete ^ at end of tag, to turn off lookup search