- Calculates the amount of applicable GST on certain items
- Calculates Pre/Post GST amounts
Input: The bot takes an excel sheet from user containing the details of the goods such as: Item Name, Price, Price inclusive/exclusive of GST.
Action: The applicable amount of GST is calculated using the Formula based on inclusion/exclusion of GST.
Output: The calculated amount of GST and total amount inclusive/exclusive of GST is filled in the sheet.
- Bot Security Program
- Business Process
- Finance and Accounting
- Automation Type
- Last Updated
- July 24, 2020
- First Published
- March 19, 2020
- Enterprise Version
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Input file containing the data of items including the item type, price, price inclusive/exclusive of GST
- GST slabs file containing the details of GST% applicable on different items