JoEz
December 11, 2017, 7:49pm
1
Hi there,
Let’s suppose there are 3 items in a Sales Invoice
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
…
Thx
umair
December 15, 2017, 6:46pm
2
Will be best to maintain separate Tax account of VAT based on tax rate.
umair
December 15, 2017, 6:52pm
4
-Liabilities
– Taxes
---- 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.
1 Like
JoEz
December 15, 2017, 6:57pm
5
yeah, and that’s fine …but what’s the net total amount that generated VAT amounts for 10% and 20%?
umair
December 15, 2017, 6:59pm
6
Should be
250 for VAT @ 20%
50 for VAT @ 10%
Why don’t you give it a try?
JoEz
December 15, 2017, 7:01pm
7
i tried …can you tell me where the value is stored? i cant find it …i need it to export not to print
umair
December 15, 2017, 7:02pm
8
Check
Accounts > Sales Register report
JoEz
December 15, 2017, 7:07pm
9
Still cant find the total net amount per tax, can u be so kind to share an animated gif?
umair
December 15, 2017, 7:09pm
10
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.
JoEz
December 15, 2017, 7:10pm
11
Ok, let me double check …
JoEz
December 15, 2017, 7:23pm
12
Unfortunately it doesn’t work as expected, see pic:
Invoice: Test 1 VAT @22 , Test 2 VAT@ 10
Tax
!
I need to get the total net amount for each VAT, means: 12 for VAT @ 22, and 30 for VAT @ 10
JoEz
December 20, 2017, 7:03am
13
Any hint on how to get total net amount per tax?