Sales Tax on Partial Net Total

ERPNext
, , ,
1

Dear All,

Recently, our country implemented a new VAT rule that states that VAT is at 12%, however the Tax Basis (Net Total) is 11/12 * Net Total. So, for example:

Net Total: USD 1.000,-
Tax Basis (11/12 * Net Total): USD 1.000,- * 11 / 12 = USD 916,67
VAT (12% * Tax Basis): USD 916,67 * 12% = USD 110,-
Grand Total (Net Total + VAT) = USD 1.110,-

Before you said “just calculate it as 11%”, unfortunately we cannot do it this time. We must display and print the calculation on all Quotation and Sales Order as follows:

Subtotal____________________: USD 1.000,00
Tax Basis (11/12 x Subtotal): USD 916,67
VAT (12% x Tax Basis)______: USD 110,00
Grand Total_________________: USD 1.110,00

On Sales Tax Template, how can I do this? And how to display it on custom print format?

Thank you :pray:

2

you can add multiple line in tax table for this calculations

3

But what about the tax basis (the 11/12 of Net Total) line? Because this is a problem since in tax table I need to insert the account for every row, but tax basis is not part of the accounting, since it is basically just a temporary value for calculating tax that should not be part of ledger.