First Previous - Page 1 of 1 - Next Last

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

  • Companion Fellow PM.Dip
  • Practice Licence
  • 1137 posts
  • # 70203

Hi 

This procedure can be used for all Global Changes and not just vat.  I sure there are many more vat changes to come  

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  




Edited at 13 Apr 2011 07:17 PM GMT

  • Companion Fellow PM.Dip
  • Practice Licence
  • 1137 posts
  • # 70204

The Below are my responses to some various items mentioned but are also useful for reference. 

Using Codes

A very good point was raised about not highlighting the customers and suppliers you don,t want to change.  With regards to which code to use or just to change ererything over . if it is only me that has access to the accounts then I do like to have two different codes and I agree with you it is neater, and yes there is no problem if you are not running cash accounting for vat but a lot of businesses have changed over to improve cash flow 

My advice for cash accounting to pick T1 is for the following to try and cover people in business as well as accountants 

 from experience if you have other people entering invoices and payments this can be come a nightmare .  No matter how much you tell people which code to use they are still getting confused , some of my clients found when they were allocating credit notes to invoices in Sales Receipts and Purchase receipts in the cash accounting system it would not allow them to allocate as there would be a message that there was a mismatch of codes.  

What then happened became a nightmare as clients just then entered payments on accounts and picked the wrong vat code when sage gave them the  option for a vat code .  Sage is actually correct when it comes to cash accounting making sure the right vat is in the detailed vat report and something the recent governments never seemed to consider .

This then resulted in companies having inaccurate and extremely untidy  Aged Debtors and Creditors.  In one of my clients case they paid customers twice because of Invoices not allocated, of course I spotted it, but it was a genuine mistake and it has highlighted to me the lessons to be learned this time and what to advise my clients .  I hope this helps 



Edited at 13 Apr 2011 07:23 PM GMT

  • Companion Fellow PM.Dip
  • Practice Licence
  • 1137 posts
  • # 70205

Hope this helps .this procedure can be used for other Global changes that may be required.

Hi 

 I would suggest to do a batch change is if you want to set up a different vat  codes.

 There has now been 3 vat changes and I noticed that some of my clients decided to use a second code for cash accounting and they did change the default codes in all the modules to reduce manual error so using the Batch change does allow you to use it as a tidy up exercise to try and reduce data entry errors by staff 

This procedure can be used for many other changes not just vat if you follow the same procedure , for example you could use it to flag suppliers due to be paid in eg 30 days or 14 days for your cash flow in customers and suppliers and use the invoice overdue report and cashflow reports, or for a quick calculation changing some debtors due dates if you know there always late just to do some cash flow projections and then change them quickly back. 

 As explained above and learning from experience and speaking to sage it should be T1 for cash accounting  and the batch change could be used as tidy up exercise, if you had tried to use two codes like I did the last time for cash accounting .  I had wanted to keep track of vat in case of inspection but it was when I was trying to allocate credit notes I had mismatch of codes. It led to a bit of a mess in the Debtors and creditors ,  so it was to try and help anyone avoid that issue as explained above hope this helps.

First Previous - Page 1 of 1 - Next Last
bottomBanner
loading