|
|
GST Computation Agent
Author: Venkata Sudhakar
ShopMax India sells electronics across states in India, making GST computation non-trivial. Intrastate sales attract CGST and SGST; interstate sales attract IGST. Different product categories carry different GST rates. A computation agent that takes the month's transactions, applies the correct tax rules, and produces a filing-ready summary saves the accounts team hours of manual work each month and reduces the risk of incorrect filing. This tutorial builds a GST Computation Agent using ADK and Gemini. The agent classifies transactions by type (intrastate or interstate), applies the applicable GST rate per product category, computes CGST, SGST, and IGST breakdowns, and generates a GSTR-3B ready summary. The below example shows monthly GST computation for ShopMax India sales transactions.
It gives the following output,
GST Computation - ShopMax India (Monthly)
5 transactions | Total Taxable Value: Rs 19,30,000
Txn | Category | Taxable Value | Rate | Type | CGST | SGST | IGST | Tax
-----|-------------|---------------|------|-------------|---------|---------|---------|--------
T001 | TV | Rs 6,20,000 | 18% | Intrastate | 55,800 | 55,800 | 0 | 1,11,600
T002 | Audio | Rs 2,90,000 | 18% | Interstate | 0 | 0 | 52,200 | 52,200
T003 | Tablet | Rs 7,40,000 | 18% | Intrastate | 66,600 | 66,600 | 0 | 1,33,200
T004 | Phone | Rs 1,85,000 | 12% | Interstate | 0 | 0 | 22,200 | 22,200
T005 | Accessories | Rs 95,000 | 18% | Intrastate | 8,550 | 8,550 | 0 | 17,100
GSTR-3B Summary:
Total Outward Taxable Supplies : Rs 19,30,000
CGST Payable : Rs 1,30,950
SGST Payable : Rs 1,30,950
IGST Payable : Rs 74,400
Total GST Liability : Rs 3,36,300
In production, pull transaction data directly from BigQuery using a monthly Cloud Scheduler trigger. Cross-reference with input tax credit (ITC) from purchase invoices to compute net GST payable. Store the GSTR-3B summary in Firestore and generate a PDF using Cloud Functions for the chartered accountant's review before filing on the GSTN portal.
|
|