Its very easy to import Sage 50 VAT Nominal Journals. 

 Example: Press Help, on the PostTrans toolbar, then select example “Nominal Journal with VAT” 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:

If we wish to see a total of the VAT element of each journal line we can add the tag TLTaxAmount to our tag row in row 28. 

To do this click on cell H35.  The portion of the sheet where your nominal lines will be entered.  Now press Tags to display the available PostTrans Tags for Nominal Journal.  Find tag TLTaxAmount and double click on it to add to template.  The tag text TLTaxAmount should now be added to cell H28.

The contents of row 28 defines the data which PostTrans will import into the lines of the nominal journal.

Now if we enter the following we will see the VAT amount calculated on the line when a nominal line has VAT content.

Next we can add a VAT total to F5, with formula =SUM(H30:H1501)

And then select cell D6, then Double click on Tag THTaxContNom,in the tag list.  This will define the VAT control account the VAT will be posted to in Sage Line 50 for Sales or Purchase side.  Press space and then tab to select the nominal code.

So now if we press Import on the PostTrans toolbar, we see a summary of the Sage Line 50 Nominal Journal we are about to post:

Now after adding the THTaxContNom tag PostTrans will have moved the cursor down the sheet, so next we can add a Contra line to the journal for the sum of the journal.  Select cell D7, add Tags ThContraNom, THContraDept, and THContrDesc, from under the “Header” tab of the Tags side bar.

We can then enter the contra Nominal by simply entering the start of the Sage Line 50 Nominal code, or space and any part of the nominal description.

Next we can post the Nominal Journal into Sage 50, by simply pressing Import button.  You will then see the following summary window, allowing you to review the Sage 50 Journal, before posting.

This could be then used to import a credit card file, or similar data.

Demonstration Video

 

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name	Data Type	Description
TLTaxAmount	Text	VAT Amount calculated based on Credit/Debit and Tax code on line
THTaxContNom^	Text	VAT Control Nominal Code for Sales or Purchase
THContraNom^	Text	Post the opposite side of the nominal value to this nominal code. For Header use only.
THContraDept^	Integer	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 Code Search field (Popup search window), delete ^ at end of tag, to turn off code search