Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
GST Rate Calculator
The Bot is used for calculating GST Rate, inclusive/exclusive to the item with respect to its' amount
Top Benefits
- GST rate calculation for large number of items
- Reduce the manual efforts in calculation
Tasks
- Prompts for the GST Rate calculation items in the Excel
- Compare the GST calculation sheet and GSTSlab and calculates the GST rate
- GST calculation equation is used for calculating the result
- Output will be updated in the same GST calculation sheet as GST%, TotalGST, Pre/PostGSTAmount
- Output can be sent through the user defined email
This bot prompts for the GST Rate calculation of items included in an Excel file. Input: an Excel file containing two sheets. First Sheet includes Item, Amount, and User prompts to GST inclusive/exclusive for the GST Rate calculation process or displaying output. The second sheet includes the GST Slab for comparing the Item and Tax Rate with the percentage. The calculation process will be done while the bot runs. Equations for GST Rate calculation are used. The output will be updated on the Excel sheet including GST%, Total GST, Pre/Post GST Amount. The Output file will be attached and sent to the user-defined e-mail address.