How to make Global Vat changes to Customers, Suppliers, Products, Sales Orders , Quotes, Purchases Orders , Bank Payments and R

 Hi 

I thought this information maybe useful for accountants in Business.  There are two points I would like to mention first 

1) If you using  cash Vat Accounting it is the T1 code you need to change 

2) Otherwise if you want you can set a different code for the new vat rate our use T1 and change it , it is advised not to use T9 as this is the default code for items that should not appear in the Vat return.

Steps to follow to change all your customers , Suppliers , Products ,Sales orders , Purchase orders ,Sales Qoutes, Bank Payments and Receipts  by Batch 

Settings 

• Go to settings at top menu 

• Configuration 

• Tax Codes Tab ( Codes wil appear) Edit your code and remember to tick the box Include in Vat Return.

• Click Apply (not save) and close.

 

 

To Change Customers / Sales  by Batch 

• Go to your Customer Module and make sure your  view is the list of Customers 

• Make sure none of them are highlighted 

• Click Swap Button in between the Search and Clear button .

• You will now see the Batch Change Button light up in the same grey area 

• Click the Batch Change Button and go to the Defaults tab 

• under Miscellaneous Defaults go to the Default Tax code drop down box and pick your tax code at 20% 

• tick the box to Use Default Tax code for Sales and then Save 

You will get a message saying you have chosen to make changes to multiple records .Do you want to save changes ?

• Pick YES 

 

 

To Change Purchases/ Suppliers by Batch 

Exactly the same procedure as above. and tick the Use Default Tax Code for Purchases .

PLEASE NOTE YOU CAN OVERIDE THE DEFAULT CODE FOR PURCHASE INVOICES BANK PAYMENTS OR RECEIPTS IF YOU RECEIVED OLD INVOICES  WITH 17.5% AND IF YOU NEED TO SEND OUT A SALES INVOICE YOU CAN OVERRIDE THE CODE BY PRESSING F3 SO YOU  EDIT ITEM LINE (INCLUDING VAT CODE 

IF YOUR HEAT AND LIGHT IS AT 5% YOU CAN HIGHLIGHT THESE SUPPLIERS AND DEFAULT THEM TO 5%

  

To Change Products  by Batch for those who use stock and product Invoicing, sales orders. Purchase orders and Qoutes  

• Go to your Products Module and make sure your  view is the list of Products

• Make sure none of them are highlighted 

• Click Swap Button in between the Search and Clear button .

• You will now see the Batch Change Button light up in the same grey area 

• Click the Batch Change Button and there is only one tab details. 

• under  Defaults second area down go to the  Tax code drop down box and pick your tax code at 20% and pick save

You will get a message saying you have chosen to make changes to multiple records .Do you want to save changes ?

• Pick Yes

 

 

Please note You do not need to change Bank payments and Receipts 

If you changed all the above they will be the same, as above you can overide the codes during entry.

If you are using Cash accounting on Sage if you get a Customer receipt or make a puchase payment the Vat will still be worked out correctly .

It is very important to mention if you pick a different code for when you receive a Customer Receipt or Purchase payment when you go to Allocate those payments you will not be allowed to sometimes and it will come up with a message mismatch tax codes.  ( Note : This is the reason you must pick the same T code as you have been using.  But using the above procedure help to prevent errors.

Hope this Helps  

Kindest Regards 

Sarah @Douglas Accountancy and Bookkeeping Services .  Bearsden, Glasgow 

 

 

Add comment
Log in or register to post comments
Group: Sage 50 Accounts discussion group
An independent forum for Sage users to share ideas, tips and gripes