Chained VAT / Tax calculations on Sage 50 US

SOLVED

Hi all,

I've been going through the sales taxes of sage 50 for sometime and I'm trying to find a way how to calculate chained vat or tax calculations.

Further explaining the chained vat / tax scenario.

If an invoice is issued to a customer for two items each costing 50 the sub total without taxes will be 100. so under the same tax organization the taxes are mentioned separately as NBT = 2.4% and VAT=8.0% 

With reference to the image mentioned below it is required to calculate the sub taxes appearing under the same tax agency as 

(Total amount without taxes * NBT%)+ (Total amount without taxes+(Total amount without taxes * NBT%)) * VAT%

and the total billing amount will be Total amount without taxes + ((Total amount without taxes * NBT%)+ (Total amount without taxes+(Total amount without taxes * NBT%)) * VAT%)

If someone knows the solution please kindly help me to solve this.

  • +1
    verified answer

    Sage 50 US Edition does not have to ability to calculate tax on another tax. The closest you could get would be to manually calculate the NBT and enter it as a taxable line item on the invoice. Then you could use the sales tax functions to calculate the VAT. Or if the overall rate is always the same, you could make one tax rate that is 8.192%. I know that neither of those are great options but I don't think you have any other choices in Sage 50 US. You could check into Sage 50 Canadian Edition. It supports VAT so it might be able to do what you need.

  • 0
    SUGGESTED

    If you need to pay VAT tax, the best solution is to move to the Sage 50 Canadian version (Formerly Simply Accounting)  I do sell that program and I would be happy to send you a quote.   Please feel free to reach me at  [email protected]

    I am a Sage 50 Certified Consultant.  304-233-2612

  • 0 in reply to StephenC

    Dear Stephen,

    The solution worked I allocated the VAT% as 8.192%=((2.4%*8%)+8%) and NBT as 2.4% such that the total tax rate displays as 10.592%. As the tax rates don't fluctuate in Sri Lanka the solution would work. If the tax rates are changed it will be updated.

    Thanks a lot Slight smile