Hi I am using sage instants v16 and having a bit of trouble woth products and invoicing;
In the product records I have entered the gross because I cannot get the net and vat to add up to the gross. So when I invoice uk customers I have to go in to each product and press calc net which is fine.
There are 2 foreign customers, one is from the EU so I use the T4 code and the other is not in the EC so I use T0. Both do NOT pay vat.
For the Foreign invoices, I try and do the same by going in to product description and calc net then I change the tax code to either T0 or T9 and this just gives me the net and takes the vat off for MOST products which is fine but there are some products which it will not let me take the vat off.
I have tried a few things to see if it would fix the problem but none have worked:
Settings Invoice Defaults unchecked invoice default to a/c ref which would have worked if the net figure was in the product description (but I cannot do this due to the vat and net not adding up to the gross).
Customer record (for the foreign customers) defaults ticked use default code tax for sales so that the foreign customers set up on T4 and T0 codes would default to this in their invoices but again it brings up the gross.
Is there a solution to this? There has got to be if some of the products I can take the vat off.
I can only think it is a product code set up issue. You mention you set up the products with a gross figure. It doesn't make sense that the net & VAT would not add up correctly - I would try and look back at the product set up - if helps you could print screen & email to me and I will try to work through that way info@completebookkeeping.co.uk
__________________
Donna Curling - Complete Book-Keeping Ltd (CBKLtd) - 07939 101900
Hi Donna, thank you for your reply. Sorry I don't think I have been very clear - i have a product that is £4.35 - If i try to put the net in as 3.62 it puts in the vat to 0.72 and the gross is 4.34, i also have tried 3.63 and sage puts in the vat of 0.73 so that adds up to 4.36 - so I don't see what I can possibly do apart from enter 4.35 as the net, and then once creating an invoice to click in to every product and calc net
