A2019 - 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.

Get Bot

Free

Bot Security Program
Level 1
Applications
Category
Vendor
Automation Type
Bot
Last Updated
March 30, 2021
First Published
March 30, 2021
Platform
Automation 360
ReadMe
ReadMe
Support

See the Bot in Action

Input Excel sheet includes GSTCalculation and GSTSlab
Prompt for the email id
Updated output Excel sheet with the result
PREV NEXT
Input Excel sheet includes GSTCalculation and GSTSlab
Prompt for the email id
Updated output Excel sheet with the result

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Inputs an Excel file including the GSTCalculation sheet and GST Slab