Bulk GST percentage update

How do I add, edit, and bulk-update the GST rates, effective September 22, 2025

Purpose - 

Based on the 56th GST Council meeting, the tax slab structure has been simplified. The GST Council's reforms, effective September 22, 2025. To add, edit, and bulk-update your tax rates and associated items to align with the new tax changes.

Quick steps to update the GST tax rate 

  • Step 1 - Navigate to Tools >> Master Migration and Select Item Update migration from the list.
  • Step 2 - Enable the item code and GST% field and Click "Save config" and download the sheet.
  • Step 3 - Fill the item code and GST% (new GST %) value for which items you require to update the GST%.
  • Step 4 - Go to >> Upload sheet Tab , select "Item update" from the list and choose the file which you field in sheet 
  • Step 5 - Wait for uploaded successfully message and verify Tax % change in item master / Item master reports

InfoNote: There is no need to manually create the 40% GST tax rate because it is already included in the Default Tax master.

Steps to update tax in detail :

Step 1. Navigate to Tools, select on Master Migration and Select your Item Update migration from the list.

IU0


iu1



Step 2 -  Enable the item code and GST% field in the sheet and download the sheet.



Step 3. After enabling the column name, Kindly save the configuration and download the sheet.




Step 4. Fill the item code and GST% (new GST %) value for the items you require to update the GST%.

Notes
Note - In GST % column enter only Number, no need to enter % symbol

iu5



Step 5.  Navigate to Upload sheet Tab , select "Item Update" from the list and click on Choose File button browse the filled sheet and click 'Upload File'.



Step 6. You will get a file uploaded successfully message.

iu7




7. Verify that the uploaded Item data. Navigate, Master >> Item >> Item >> Search the item >> Edit >> verify under GST tab.

iu8

FAQ :

Q1) Error while uploading the item Update sheet, getting the below message?

mig8


Solution - You will get this message if the column value does not satisfy column conditions. In the same master migration menu, click on upload status menu, select the same master from the dropdown and click on the load button. The invalid records will be loaded along with the reason. You can correct the invalid record in the same menu and click on the Save master button. The data will get saved successfully.

Q2) Error While updating the sheet, getting the message as "FAILED" 

Solution - Checked for the mentioned special characters  " ' \ & : !  & @ $ %   in the sheet. Remove the same, and then you can upload the sheet again.

Q3) How to edit the Tax Percentage in Transaction screen?

Solution - Go to Tools >> Configuration >> Business Configuration >> Search Tax and Map it as "Allow to Edit" and Click on Save button.


2. In Purchase invoice screen. once you load the supplier and item details, place the cursor on Tax column and press Enter , it will display the LOV of Tax rate, you can select the required tax rate for the list.

pitax

Q4) How to get all item detail with GST % to import in the sheet?

Solution - 
*Go to Reports >> Master >> Item Master report  .
*In report settings , Kindly enable only the item code and GST % under export column and download the reports to use for GST bulk update in migration.

Q5) How to confirm the accuracy of the uploaded Item Update Migration data..

Solution - Navigate Master >> Item  >> Item >> Search item >> Edit >> verify under GST tab.

iu8

Q6) Which GST rate will apply ? when a sales order or purchase order is created using old GST rate but SO/PO is converted as invoice after the GST rate change.  

Solution - The GST tax rate will be affected from the item master. When the sales order, quotation, and purchase order are converted into an invoice.

Example-   
Item: Chocolate Brownie
Old GST Tax %(Before 21st Sept 2025): 12%
New GST Tax %(From 22nd Sept 2025): 5%
Sales Order:
Date: 20th September 2025
GST Applied: 12% (as per old gst tax % at the time of order)
Invoice:
Date: On or after 22nd September 2025
GST Applied: 5%  (new GST tax applies at invoice time)

Info
Note: GST is calculated based on the invoice date, not the order date.

Q7) Which rate will apply? if the transfer out was made at the old GST rate but the transfer in was made after the new GST rate change?  

Solution - The GST rate used at Transfer Out will continue to apply at Transfer In, even if GST rates change before Transfer In entry.  

Example -
Item:LED TV
Old GST Tax %(at Transfer Out before 21st Sept 2025): 28%
New GST Tax % (at Transfer In completed on 22nd Sept 2025): 18%
Transfer Out:
Date: 20th September 2025
GST Applied: 28%
Transfer In:
Date: 23rd Sept 2025
GST Applied: 28% (same as Transfer Out)

Info
Note: GST Tax % is fixed at Transfer Out and stays the same during Transfer In, even if GST Tax % change in between.
 

Q8) How to change Selling Rate for items?

Solution - Bulk Update: Use the "Change Selling Upload" migration utility to update multiple items at once.
Manual Update:Use the " Change selling" screen to update rates for individual items.
 

Q9) What happens if an old invoice is edited after the GST rate change on September 22nd?  

Solution -
SCE 1. If no items removed & added / newly added in edited mode, the original GST tax %will not change.

      Example -
      Invoice Date: 20th Sep 2025
      GST Change Date: 22nd Sep 2025
      Bill edited on/after 22nd Sep: The remarks or payment alone gets edited (no item changes)

Result: old GST tax (28%) remains unchanged.
Info
Note: GST stays the same if no item details are modified.

SEC 2. If items are removed & re-added OR Newly added, the new GST rate applies for those items.

Example -
      Item: LED TV
      Old GST: 28%
      Invoice Edit Date: 22nd September 2025 (after GST reduced to 18%)
      Action: Removed and re-added the item.

 Result: Re-added item takes new GST tax – 18% 

Info
Note: When an item is re-added after GST change, the system applies the new Gst Tax %.  
Warning
Avoid adding a new item in the existing invoices.

Q10) How will GST be applied to sales returns or purchase returns? When the original invoice was created before to the change in the GST rate but the return was submitted after the new GST rate.  

Solution - The user can decide which GST tax % should apply while return entry.

Navigate Tools >> Configuration >> Business Configuration >> find "Load GST% for Return Based On" - Choose either "Master" or "Transaction" based on the need.  
Info
Note - As per new GST reform, return must be done with revised GST Tax% .
 
Config 1: (if Master is chosen) The GST Tax percentage mapped in the item master will be applied at the time of the sales or purchase return .  
Example:  
Item: LED TV
GST Tax % in Master at Return: 18%
while Return 18% tax rate will be calculated

Config 2:(If Transaction is chosen), The GST tax percentage from the invoice will be applied when the sales or purchase is returned.
Example:
Item: LED TV
GST Tax % at Transaction: 28%
while Return 28% tax rate will be calculated


Q11) In the franchise flow, how does GST tax rate will reflect?  

Solution - In the franchise flow. The GST tax % on the sales bill is carried over to the purchase invoice to the franchise outlet. there will be no tax changes. 

 Example Scenario:  
Item: LED TV
GST tax % on Sales Bill (HO): 18%
Franchise Purchase Invoice Advice: Auto-picks 18% GST

 Result: Franchise receives the item with the same GST Tax (18%) as applied in the sales bill.
Info
Note: No manual GST entry needed at franchise end — it's carried forward from the parent sales bill.


Q12) How to change the Tax Slab for an item?  

Solution -
Navigate, Master >> Item >> Tax Slab.
Create a new "Tax Slab".
Map the new Tax Slab to the item via Item Master (single) or Item Update migration (bulk).

Q13) How to enable the specific user for edit GST tax in transaction screen?  

Navigate Tools >> Configuration >> Userwise Configuration >> Search "Tax" ->Click on "View"


Select the "User" you want to edit the tax rate in transaction screen from Employee list .

 

From the Drop down select the "Allow to Edit" to the user ->save.


 

Q14) In backdated Purchase or Sales, which GST rate will be applied — old GST rate or new GST rate?  

Solution - In backdated Purchase or Sales the NEW GST rate will be applied.

Notes
Note - You change the tax rate by enable the configuration

Q15) How to create 40% tax rate in TruePOS

Solution - There is no need to manually create the 40% GST tax rate because it is already included in the Default Tax master.


    • Related Articles

    • Item Master

      Purpose: Item (also known as Product, Part, Article and SKU - Stock Keeping Unit) refers to the name of the service or a thing which is produced or served. The term "Item Master" constitutes an item database where we can define the features and ...

    • GST Tax

      TruePOS allows for flexible GST tax configuration in the Sales module. By default, tax amounts for each item are calculated based on the item and tax settings. Users can also modify tax settings during billing, depending on the configuration. Taxes ...

    • GST Master

      The GST Master in TruePOS is a centralised module designed to manage all GST-related configurations efficiently. This feature helps businesses maintain compliance with GST regulations by enabling accurate tax calculations for transactions, reporting, ...

    • Change Selling Migration

      Change Selling Migration Change selling facilitates to change the selling price and MRP of the items. The selling price of the products will change more often in accordance with market change. Especially, the prices of the items in supermarkets and ...

    • What is the purpose of Change selling migration in TruePos ?

      Change Selling Migration Purpose :By using the Change Selling Migration option, we may amend or update the old adjustments for Selling Price or MRP in bulk. Page Navigation :- Tools >> Master Migration Process involved in creating change selling ...