{"id":18597,"date":"2026-05-27T12:05:07","date_gmt":"2026-05-27T12:05:07","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=18597"},"modified":"2026-07-07T07:37:46","modified_gmt":"2026-07-07T07:37:46","slug":"how-to-configure-the-tax-in-idempiere-for-retail","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-the-tax-in-idempiere-for-retail\/","title":{"rendered":"How to Configure the Tax in iDempiere for Retail"},"content":{"rendered":"\n

Learn how to configure GST, CGST, SGST, and IGST tax records in iDempiere for retail. Enable accurate tax calculation and accounting posting.<\/p>\n\n\n\n

Introduction<\/strong><\/h2>\n\n\n\n

The Tax<\/strong> window in iDempiere is used to define tax calculation rules applied during purchasing, sales, invoicing, and accounting transactions. Tax records determine how tax percentages are computed and how tax values are posted during each transaction.<\/p>\n\n\n\n

Business Value<\/strong> In retail, iDempiere Tax configuration supports GST (intra-state) and IGST (interstate) tax structures \u2014 enabling automatic tax splitting, correct invoice generation, and accurate financial postings across sales and purchase transactions.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Prerequisites<\/strong><\/h2>\n\n\n\n

Before starting, ensure the following:<\/p>\n\n\n\n

    \n
  • Initial Tenant Setup completed successfully<\/li>\n\n\n\n
  • Tax Categories configured<\/li>\n\n\n\n
  • Chart of Accounts and Accounting Schema configured<\/li>\n\n\n\n
  • Logged in with a role that has sufficient access rights<\/li>\n<\/ul>\n\n\n\n

    Business Rules<\/strong><\/h2>\n\n\n\n
      \n
    • Parent tax records must be configured as Summary records with a 0% rate, while tax calculations are performed by the associated child tax records.<\/li>\n\n\n\n
    • Each combined tax structure must contain the required child tax records, with each child linked to the correct parent tax and configured with the appropriate percentage.<\/li>\n\n\n\n
    • Standalone tax records must be configured as non-summary records and assigned the full applicable tax rate.<\/li>\n\n\n\n
    • Tax records must be active, assigned to Organization *, configured for both Sales and Purchase transactions, and have a valid effective date.<\/li>\n\n\n\n
    • Tax Categories must be correctly mapped to both products and tax records to ensure accurate tax calculation and accounting during transactions.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n

      Menu \u2192 Performance Analysis and Accounting \u2192 Accounting Rules \u2192 Tax<\/strong><\/p>\n\n\n\n

      The window displays all existing Tax records. Use the search filter to locate a specific record.<\/p>\n\n\n\n

      Step-by-Step Configuration<\/strong><\/h2>\n\n\n\n

      Step 1: Open Tax Window<\/strong><\/h3>\n\n\n\n

      Navigate to the path above. The window lists all existing Tax records configured in iDempiere.<\/p>\n\n\n\n

      Step 2: Create New Record<\/strong><\/h3>\n\n\n\n

      Click New Record (+)<\/strong> to open a blank form. To modify an existing record, open it and update the values directly.<\/p>\n\n\n\n

      Common Field Reference<\/strong><\/h3>\n\n\n\n
        \n
      • Organization – <\/strong>Set to * \u2014 makes tax records available across all organizations<\/li>\n\n\n\n
      • Name – <\/strong>Display name of the tax record \u2014 include rate percentage for clarity<\/li>\n\n\n\n
      • Tax Category – <\/strong>Links the tax record to the applicable Tax Category (e.g., GST 18%, IGST 5%)<\/li>\n\n\n\n
      • Country – <\/strong>Set to India \u2014 restricts tax applicability to Indian transactions<\/li>\n\n\n\n
      • SO \/ PO Type – <\/strong>Set to Both \u2014 allows use in both sales and purchase transactions<\/li>\n\n\n\n
      • Valid From – <\/strong>Defines the effective start date for the tax record<\/li>\n\n\n\n
      • Rate – <\/strong>Tax percentage applied during calculation (0 for Summary tax parents)<\/li>\n\n\n\n
      • Summary Level – <\/strong>Enable for parent GST taxes \u2014 child taxes perform actual calculations<\/li>\n\n\n\n
      • Parent Tax – <\/strong>Links a child tax (CGST \/ SGST) to its parent summary tax record<\/li>\n\n\n\n
      • Posting Indicator – <\/strong>Set to Separate Tax Posting \u2014 creates individual accounting entries per tax<\/li>\n\n\n\n
      • Default – <\/strong>Set CGST\/SGST 5% as default \u2014 auto-selected during record creation<\/li>\n\n\n\n
      • Active – <\/strong>Must be enabled \u2014 makes the tax available in transactions<\/li>\n<\/ul>\n\n\n\n

        Step 3: Configure GST Summary Tax Records<\/strong><\/h3>\n\n\n\n

        Create the following GST Summary Tax<\/strong> records. These are parent tax structures for intra-state transactions. Each summary tax holds child taxes (CGST + SGST) that perform the actual calculation.<\/p>\n\n\n\n

        Name<\/strong><\/td>Description<\/strong><\/td>Rate<\/strong><\/td>Summary Level<\/strong><\/td>Active<\/strong><\/td><\/tr><\/thead>
        GST 0%<\/strong><\/td>Zero-rated tax \u2014 exempt transactions<\/td>0<\/td>Yes<\/td>Yes<\/td><\/tr>
        CGST\/SGST 3%<\/strong><\/td>Combined GST summary \u2014 low-rate transactions<\/td>0<\/td>Yes<\/td>Yes<\/td><\/tr>
        CGST\/SGST 5%<\/strong><\/td>Combined GST summary \u2014 reduced-rate transactions<\/td>0<\/td>Yes<\/td>Yes<\/td><\/tr>
        CGST\/SGST 18%<\/strong><\/td>Combined GST summary \u2014 standard-rate transactions<\/td>0<\/td>Yes<\/td>Yes<\/td><\/tr>
        CGST\/SGST 40%<\/strong><\/td>Combined GST summary \u2014 high-rate transactions<\/td>0<\/td>Yes<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Notes \u2014 Summary Tax Rules<\/strong> Summary Tax Rate must always be set to 0. Enable Summary Level on all parent GST tax records. Child taxes (CGST and SGST) perform the actual tax calculation \u2014 the parent only groups them.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        GST Parent\u2013Child Structure<\/strong><\/h3>\n\n\n\n
        \n

        CGST\/SGST 3% \u2192 CGST 1.5% + SGST 1.5%<\/p>\n\n\n\n

        CGST\/SGST 5% \u2192 CGST 2.5% + SGST 2.5%<\/p>\n\n\n\n

        CGST\/SGST 18% \u2192 CGST 9% + SGST 9%<\/p>\n\n\n\n

        CGST\/SGST 40% \u2192 CGST 20% + SGST 20%<\/p>\n<\/div>\n\n\n\n

        Step 4: Configure Child GST Tax Records (CGST and SGST)<\/strong><\/h3>\n\n\n\n

        Create the following CGST and SGST child tax<\/strong> records. Each child tax is linked to its parent summary tax and performs the actual tax calculation during transactions.<\/p>\n\n\n\n

        Name<\/strong><\/td>Parent Tax<\/strong><\/td>Rate (%)<\/strong><\/td>Summary Level<\/strong><\/td>Posting Indicator<\/strong><\/td><\/tr><\/thead>
        CGST 1.5%<\/strong><\/td>CGST\/SGST 3%<\/td>1.5<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        SGST 1.5%<\/strong><\/td>CGST\/SGST 3%<\/td>1.5<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        CGST 2.5%<\/strong><\/td>CGST\/SGST 5%<\/td>2.5<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        SGST 2.5%<\/strong><\/td>CGST\/SGST 5%<\/td>2.5<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        CGST 9%<\/strong><\/td>CGST\/SGST 18%<\/td>9<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        SGST 9%<\/strong><\/td>CGST\/SGST 18%<\/td>9<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        CGST 20%<\/strong><\/td>CGST\/SGST 40%<\/td>20<\/td>No<\/td>Separate Tax Posting<\/td><\/tr>
        SGST 20%<\/strong><\/td>CGST\/SGST 40%<\/td>20<\/td>No<\/td>Separate Tax Posting<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        Notes \u2014 Child Tax Rules<\/strong> Summary Level must be Disabled for all child tax records. Parent Tax must be correctly selected for each CGST and SGST child. Posting Indicator must be set to Separate Tax Posting on all child records.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Step 5: Configure IGST Tax Records<\/strong><\/h3>\n\n\n\n

        Create the following IGST Tax<\/strong> records for interstate transactions. Unlike GST, IGST does not use a parent\u2013child structure \u2014 each IGST tax is a standalone record.<\/p>\n\n\n\n

        Name<\/strong><\/td>Description<\/strong><\/td>Rate (%)<\/strong><\/td>Summary Level<\/strong><\/td>Active<\/strong><\/td><\/tr><\/thead>
        IGST 0%<\/strong><\/td>Interstate zero-rated tax<\/td>0<\/td>No<\/td>Yes<\/td><\/tr>
        IGST 3%<\/strong><\/td>Interstate low-rate tax<\/td>3<\/td>No<\/td>Yes<\/td><\/tr>
        IGST 5%<\/strong><\/td>Interstate reduced-rate tax<\/td>5<\/td>No<\/td>Yes<\/td><\/tr>
        IGST 18%<\/strong><\/td>Interstate standard-rate tax<\/td>18<\/td>No<\/td>Yes<\/td><\/tr>
        IGST 40%<\/strong><\/td>Interstate high-rate tax<\/td>40<\/td>No<\/td>Yes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
        \"\"<\/figure>\n\n\n\n

        Step 6: Save the Record<\/strong><\/h3>\n\n\n\n

        Click Save<\/strong>. The Tax record is immediately available for use in product configuration and transactions.<\/p>\n\n\n\n

        Configuration Summary<\/strong><\/h2>\n\n\n\n
        Tax Record<\/strong><\/td>Type<\/strong><\/td>Rate (%)<\/strong><\/td>Structure<\/strong><\/td><\/tr><\/thead>
        GST 0%<\/strong><\/td>GST Summary<\/td>0<\/td>Parent only \u2014 no child taxes<\/td><\/tr>
        CGST\/SGST 3%<\/strong><\/td>GST Summary<\/td>0<\/td>Parent \u2192 CGST 1.5% + SGST 1.5%<\/td><\/tr>
        CGST\/SGST 5%<\/strong><\/td>GST Summary<\/td>0<\/td>Parent \u2192 CGST 2.5% + SGST 2.5%<\/td><\/tr>
        CGST\/SGST 18%<\/strong><\/td>GST Summary<\/td>0<\/td>Parent \u2192 CGST 9% + SGST 9%<\/td><\/tr>
        CGST\/SGST 40%<\/strong><\/td>GST Summary<\/td>0<\/td>Parent \u2192 CGST 20% + SGST 20%<\/td><\/tr>
        IGST 0%<\/strong><\/td>IGST<\/td>0<\/td>Standalone \u2014 no child taxes<\/td><\/tr>
        IGST 3%<\/strong><\/td>IGST<\/td>3<\/td>Standalone \u2014 no child taxes<\/td><\/tr>
        IGST 5%<\/strong><\/td>IGST<\/td>5<\/td>Standalone \u2014 no child taxes<\/td><\/tr>
        IGST 18%<\/strong><\/td>IGST<\/td>18<\/td>Standalone \u2014 no child taxes<\/td><\/tr>
        IGST 40%<\/strong><\/td>IGST<\/td>40<\/td>Standalone \u2014 no child taxes<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Tax Processing Flow<\/strong><\/h2>\n\n\n\n

        iDempiere Tax processing follows this sequence for every sales and purchase transaction:<\/p>\n\n\n\n

        \n

        Product \/ Charge \/ Service<\/p>\n\n\n\n

        \u2193<\/p>\n\n\n\n

        Tax Category (e.g. GST 18% \/ IGST 5%)<\/p>\n\n\n\n

        \u2193<\/p>\n\n\n\n

        Tax Record (e.g. CGST\/SGST 18% or IGST 5%)<\/p>\n\n\n\n

        \u2193<\/p>\n\n\n\n

        Purchase Order \/ Sales Order<\/p>\n\n\n\n

        \u2193<\/p>\n\n\n\n

        Invoice (tax lines split: CGST + SGST or IGST)<\/p>\n\n\n\n

        \u2193<\/p>\n\n\n\n

        Accounting Posting (Separate Tax Posting)<\/p>\n<\/div>\n\n\n\n

        Why Use Tax Categories<\/strong> Tax Categories act as the intermediate layer between products and tax rules. Assigning taxes through categories \u2014 rather than directly to products \u2014 simplifies future tax rate changes across the entire product catalogue.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Transaction Validation<\/strong><\/h2>\n\n\n\n

        Use the following sample to verify tax split calculation before going live.<\/p>\n\n\n\n

        Sample Calculation \u2014 CGST\/SGST 5%<\/strong><\/h3>\n\n\n\n
        Element<\/strong><\/td>Value<\/strong><\/td><\/tr><\/thead>
        Product Price<\/strong><\/td>\u20b91,000.00<\/td><\/tr>
        Selected Tax<\/strong><\/td>CGST\/SGST 5%<\/td><\/tr>
        CGST 2.5%<\/strong><\/td>\u20b925.00<\/td><\/tr>
        SGST 2.5%<\/strong><\/td>\u20b925.00<\/td><\/tr>
        Total Tax<\/strong><\/td>\u20b950.00<\/td><\/tr>
        Grand Total<\/strong><\/td>\u20b91,050.00<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Accounting Validation<\/strong><\/h2>\n\n\n\n

        Verify the accounting posting generated by the invoice matches the expected tax split entries.<\/p>\n\n\n\n

        \n

        Purchase Invoice Posting \u2014 CGST\/SGST 5%<\/strong><\/h3>\n\n\n\n

        Inventory \/ Expense Account Dr 1,000.00<\/p>\n\n\n\n

        CGST Tax Credit Account Dr 25.00<\/p>\n\n\n\n

        SGST Tax Credit Account Dr 25.00<\/p>\n\n\n\n

        Accounts Payable Cr 1,050.00<\/p>\n<\/div>\n\n\n\n

        Accounting Verification<\/strong> Separate Tax Posting creates individual debit entries for CGST and SGST. If both taxes appear as a single combined line, verify that Posting Indicator is set to Separate Tax Posting on each child tax record.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Common Issues<\/strong><\/h2>\n\n\n\n
        Issue<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
        Tax calculated twice on invoice<\/strong><\/td>Set Parent Summary Tax Rate to 0<\/td><\/tr>
        Wrong tax total generated<\/strong><\/td>Verify Parent Tax mapping on each child record<\/td><\/tr>
        CGST and SGST not split in invoice<\/strong><\/td>Verify Summary Level is enabled on the parent tax<\/td><\/tr>
        Incorrect accounting posting amount<\/strong><\/td>Verify Posting Indicator is set to Separate Tax Posting<\/td><\/tr>
        Tax unavailable in transactions<\/strong><\/td>Verify the Active checkbox is enabled<\/td><\/tr>
        Wrong tax applied on interstate order<\/strong><\/td>Verify IGST record is linked to the correct Tax Category<\/td><\/tr>
        Changes not reflected after save<\/strong><\/td>Run Cache Reset and log in again<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

        Best Practices<\/strong><\/h2>\n\n\n\n
          \n
        • Always set Parent Summary Tax Rate to 0 \u2014 child taxes handle all calculations<\/li>\n\n\n\n
        • Enable Summary Level only on parent GST tax records, never on IGST or child records<\/li>\n\n\n\n
        • Set Posting Indicator to Separate Tax Posting on all child tax records for clean accounting entries<\/li>\n\n\n\n
        • Set SO\/PO Type to Both to allow tax usage in both sales and purchase transactions<\/li>\n\n\n\n
        • Set Organization = * so tax records are available across all business units<\/li>\n\n\n\n
        • Validate transaction calculation and accounting posting before going live<\/li>\n\n\n\n
        • Set CGST\/SGST 5% as the Default tax to reduce manual selection during record creation<\/li>\n<\/ul>\n\n\n\n

          Next Steps<\/strong><\/h2>\n\n\n\n

          After completing Tax configuration in iDempiere, continue with:<\/p>\n\n\n\n

            \n
          • Price List \u2014 configure sales and purchase price lists<\/li>\n\n\n\n
          • Unit of Measure \u2014 define measurement units for products<\/li>\n\n\n\n
          • Product Setup \u2014 assign Tax Categories and pricing to products<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

            Learn how to configure GST, CGST, SGST, and IGST tax records in iDempiere for retail. Enable accurate tax calculation and […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[67,68],"tags":[],"class_list":["post-18597","post","type-post","status-publish","format-standard","hentry","category-retail","category-masters"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=18597"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/18597\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=18597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=18597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=18597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}