Menu

Blog

Search

Category

AutoUpdated

Save time updating

Sage 50

Stock/Product Creation
Customer/Supplier Prices
Bill of Material
Project Creation
Location Bins

Sage 200

Simply extract, edit and import

Import from Excel

50 Trans

Nominal Journals
Quotes/Invoices/Orders
Remote Orders
Product/Stock Adjustments
Sales Receipts
Quick OrderPad

200 Trans

Transaction from Manual Input

Multiple Transactions from CSV file

Solve the Puzzle?

Sage 50

Help on every type of import
Demo Video of all functionality
Loads of Examples included
Online Training
We can help too…

Sage 200

Great Customer Satisfaction

Customer Comments

Full Trial with Demo Data
Low cost Subscription
Cancel anytime
From a £1 a day
Saving you hours

Simply extract, edit and import

Power of Excel

Sage 50

Quick Template Creation
Customise with:
    Formula
    Macros
    VBA

Sage 200

To reach your goals quickly

Sage 200 Bins

Sage 200 Warehouse & Bins

Create Sage 200 Bins
Stock Take Bins
Move Bin Stock

Fast, cost effective, easy…

Manufacturing

200 Manufact.

Create BOM Stock Easily
Create Bill of Materials
Labour, Machine, Tools

Complex tasks quicker...

50 BOM

Project Accounting

200 Projects

Create Project Structure
Update Budgets
Simple Project Entry

Make life easier...

50 Projects

PostTrans Blog

Why not sign up to recieve news, tips, ideas, training.  Sign up for bi-weekly newsletter.

Blog Search

Posting Contra Nominal Journal in Sage 50

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:

image

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:

image

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

image

Pressing Post Transaction button will post the transaction.

Demonstration Video

 
 
   Sage 50 - Posting a Nominal Journal with VAT PostTrans
  0:00 Video Introduction
  0:50 Opening Nominal Journal Example
  2:30 Posting a normal Nominal Journal into Sage 50
  3:25 Posting a Nominal Journal with Contra Nominal line
  4:00 Using In cell searching to enter nominal lines
  6:10 Posting a VAT Nominal Journal into Sage 50
  7:20 How to find more information and Training
 
 

 

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

Categories: | Tags: | Return

Post a Comment

Blog Categories