Skip to Content
Menu
This question has been flagged
2 Replies
197 Views

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
Discard
Author 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
Discard
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
Discard
Related Posts Replies Views Activity
3
Oct 19
9869
1
Mar 15
5812
7
Apr 20
8982
4
Apr 20
10831
1
Jul 25
2107