RSA_VAT_Change
     
 
South African VAT Change from 14% to 15% on the 1st April 2018  
 
Enter the details in the blue cells and decide what the final price will be  
As is- Pre 1 April 2018- VAT @ 14%      
   
Product Name/ Code    
Price Including VAT  
Price excl VAT  
VAT @ 14%  
 
Option 1- We keep the same total price and take the VAT knock ourselves    
 
Product Name/ Code  
Price Including VAT @ 15%  
therefore, Price excl VAT is  
VAT @ 15%  
Change in our income (-=loss, +=profit)  
Change in client payment (-= pays more, + pays less)  
   
Option 2- We change the VAT rate and make the client bear the full cost    
 
Product Name/ Code  
Price Including VAT @ 15%  
Price excl VAT  
VAT @ 15%  
Change in our income (-=loss, +=profit)  
Change in client payment (-= pays more, + pays less)  
 
Final Decision- Based on the results above, find a price that is fairest on all parties  
 
Product Name/ Code  
Current Price Excl VAT  
Option 1- Price excl VAT (you take knock)  
Option 2 Price excl VAT (they take knock)  
     
Your Final Decision- Price excl VAT  
VAT @ 15%  
Total Price  
     
Change in our income (-=loss, +=profit)  
Change in client payment (-= pays more, + pays less)  
 
Email us if you want a copy of the spreadsheet based version where you can compare more than  
one price at a time  
info@AuditExcel.co.za