- Calculates the amount of applicable GST for certain items
- Calculates Pre/Post GST amounts
Input: Bot takes an Excel sheet containing the details of the goods such as Item Name, Price, Price inclusive/exclusive of GST.
Action: Applicable amount of GST is calculated using the formula based on inclusion/exclusion of GST.
Output: Calculated amount of GST and total amount inclusive/exclusive of GST is updated in the sheet.
- Bot Security Program
- Business Process
- Finance & Accounting
- Automation Type
- Last Updated
- December 11, 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 for different items