Hello colleagues,
Could you please clarify how I can find a "Base amount" field for the invoice in the European bandle?
The filed means the sum of money to which a particular tax type and its percent should be applied. And it is possible that there is more than one base amount value for a single invoice.
Examples:
Example 1:
The invoice has only one line item and one base amount:
Price = 50
Quantity = 1
Tax Code = S
Tax rate = 20%
Then calculations -> Subtotal = Base amount= 50 (in this case subtotal equals base amount), Tax = 5, Total = 55
Example 2:
The invoice has 5 line items with different tax codes and rates and 3 base amounts (attached).
Calculations:
• 2 lines with VAT tax code S of 17% → 50€ and 160€
• 2 lines with VAT tax code S of 10 % → 15, 33€ and 199€
• 1 line with E: 380€
The result of Base Amount should be:
1. Base of S (17%) = 50+160 = 210€
VAT = 210*17% = 35,7€
2. Base of S (10%) = 15,33 + 199 = 214,33€
VAT = 214,33*10% = 21,43€
3. Base of E (0%) = 380€
VAT = 0%
So, 210, 214,33, and 380 should be shown somewhere as base amounts.
Totals based on it:
• Subtotal = 210+214,33+380 = 804,33€ (in this case subtotal is not equal base amount)
• Tax = 35,7+21,43+0 = 57,13€
• Total = 804,33+57,13 = 861,46€
I've reviewed financial fields that exist but do not see something called "Base amount". Maybe it's called differently? Please help to find it.