Skip to Content
Menú
This question has been flagged
2 Respostes
145 Vistes

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

Avatar
Descartar
Autor Best Answer

Hi

Thanks for your input.  Is there anyway in which we can store the Tax value in 3 or 4 decimals.  Because when we split 3.33 Tax into CGST, SGST, then 3.33/2 comes to Rs. 1.665/-.

Regards

Avatar
Descartar
Best Answer

Hi,


What’s Happening in Your Example

       * Product Selling Price (SP) = ₹70

       * GST 5% is included in the price (Tax-Included method).

       * Taxable Base = ₹66.66 (approx).

       * Tax = ₹3.34 (split into CGST ₹1.67 + SGST ₹1.67).

- On each line, Odoo is rounding per line, not at the global report level.

Now, when you sum over 12 transactions:

     * Odoo way (line-level rounding):

                - Taxable = 12 × 66.66 = ₹799.92

                - Tax = 12 × 3.34 = ₹40.08


      * Manual way (global rounding):

                    - Tax = 799.92 × 5% = ₹39.996 → 40.00


So the difference of 0.08 arises because Odoo rounds per line, while your accountants are rounding on the total.


Odoo is mathematically correct. It’s just following its default rounding method:


    By default, Odoo rounds at line level (per invoice line).


    This is standard accounting practice in most countries, but in India GST returns are usually computed on the total, not per line.


So Odoo’s result differs slightly from what your accountants expect.



Global Rounding (Preferred for GST Filing in India)


    You can configure "Tax Rounding Method" in Odoo:


        Go to Invoicing → Configuration → Settings → Taxes → Tax Calculation Rounding Method


        Options:


            Round per line (default, what you’re seeing).


            Round globally (round at invoice total).


    If you set Round Globally, Odoo will compute the tax on the invoice total instead of per line.

    In your example, it would show:


                   Taxable = ₹799.92

                    Tax = ₹39.996 → ₹40.00 (instead of 40.08).



Hope it helps

Avatar
Descartar
Related Posts Respostes Vistes Activitat
3
d’oct. 19
9868
1
de març 15
5807
7
d’abr. 20
8973
4
d’abr. 20
10828
1
de jul. 25
2107