Dear All,
We have a scenario, with respect to Tax calculation in Odoo 17 Community or Enterprise Edition. Need clarification on the same. Indian customer with GST is applicable.
E.g.,
DATE | TRANS | PRODUCT | SP | RATE | QTY | SP TAXABLE | ODOO TAX | CGST | SGST |
01-08-2025 | 1 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
02-08-2025 | 2 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
03-08-2025 | 3 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
04-08-2025 | 4 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
05-08-2025 | 5 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
05-08-2025 | 6 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
06-08-2025 | 7 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
07-08-2025 | 8 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
08-08-2025 | 9 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
09-08-2025 | 10 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
10-08-2025 | 11 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
11-08-2025 | 12 | ALL VARIETY RICE | 70 | 5 | 1 | 66.66 | 3.34 | 1.67 | 1.67 |
TOTAL | 799.92 | 40.08 | 20.04 | 20.04 |
In the above case, if we recalculate the tax from 66.66 with 5% tax, then the tax comes to Rs. 66.66*5/100 = 3.333 and not Rs. 3.34.
Also when a total report for the period 01-Aug to 11-Aug is taken we show the total Taxable value as Rs. 799.92 as per the table and Tax value as Rs. 40.08.
But users calculate the tax outside the system from Rs. 799.92 which comes to 39.996 which is not equal to 40.08 as per the table above.
So is the tax calculation in Odoo correctly calculated. Or how to handle this scenario when we need to submit it to accounts.
Regards
Odoo@tenthplanet