Let’s suppose there are 3 items in a
Item1 for a net total of 100 and VAT @ 20%
Item1 for a net total of 50 and VAT @ 10%
Item1 for a net total of 150 and VAT @ 20%
So the total net amount on which taxes are calculated are:
250 for VAT @ 20% => VAT @ 20% = 50
50 for VAT @ 10% => VAT @ 10% = 5
where is possible to find the net total amount (250 and 50) on which taxes are calculated? I cant find it in
Sales Taxes and Charges …
Will be best to maintain separate Tax account of VAT based on tax rate.
---- VAT 10
---- VAT 20
In the Item master, mention VAT account applied on that item.
In the Sales Invoice, select both VAT 10 and 20% account, but keep rate as zero. Tax rate will be fetched from item master.
In the Print Format, after Net Total, you will see total for VAT 10% and VAT 20% separately.
yeah, and that’s fine …but what’s the net total amount that generated VAT amounts for 10% and 20%?
250 for VAT @ 20%
50 for VAT @ 10%
Why don’t you give it a try?
i tried …can you tell me where the value is stored? i cant find it …i need it to export not to print
Accounts > Sales Register report
Still cant find the total net amount per tax, can u be so kind to share an animated gif?
In the report, you will see column for each tax account… If you have created separate tax account, and also used in the Sales Invoice (submitted)… then for the row of that Sales Invoice, you will see VAT 20% and VAT 10% in the separate columns.
Ok, let me double check …
Unfortunately it doesn’t work as expected, see pic:
Invoice: Test 1 VAT @22, Test 2 VAT@ 10
I need to get the total net amount for each VAT, means: 12 for VAT @ 22, and 30 for VAT @ 10
Any hint on how to get total net amount per tax?