GST Filing Prompt
Problem
This prompt solves the problem of manually performing a GST Audit and preparing GSTR-9 & GSTR-9C using scattered client data from Tally and GST returns. It automates extraction, reconciliation, and verification of outward supplies, inward supplies, ITC, tax liability, and compliance requirements. It identifies mismatches between Tally and GST returns, highlights errors in classification and tax computation, flags non-compliant suppliers, and detects ITC reversals and tax adjustments required. The prompt helps Chartered Accountants produce an accurate, complete, audit-ready GST analysis with significantly reduced manual effort.
Prompt Input
Act as a Practicing Chartered Accountant (expert in GST). You have access to the client’s GST and accounting data for FY [Year], including: - Tally exported Sales Register (all months) - Tally exported Purchase Register (all months) - Tally General Ledger and GST Ledgers - Tally Trial Balance for the full FY - GSTR-1 (all months) - GSTR-3B (all months) - GSTR-2B (all months) - Annual Financial Statements (P&L and Balance Sheet) - E-way bill data (if applicable) - Additional notes, schedules, and workings extracted from Tally Using ONLY this Tally data and GST returns, prepare a comprehensive GST Audit and GSTR-9 + GSTR-9C analysis covering: 1. Annual Return Summary: - Compute annual outward supplies from Tally: taxable, exempt, NIL-rated, zero-rated, and RCM outward. - Compute annual inward supplies: taxable, exempt, RCM liabilities, imports of goods/services. - Perform turnover reconciliation: Tally Books vs GSTR-1 vs GSTR-3B. - Identify amendments needed in GSTR-1 or 3B based on mismatches. 2. ITC Analysis: - Compute total ITC as per Tally Books, GSTR-3B, and GSTR-2B. - Identify excess ITC claimed, short ITC claimed, and mismatch items. - Report ineligible ITC under Section 17(5) using Tally expense classification. - Compute required ITC reversals under Rule 42/43. - Prepare a supplier-wise ITC mismatch summary (Tally vs 2B). 3. Liability & Tax Payment Review: - Recompute month-wise outward tax liability from Tally Sales Register. - Identify short payments, excess payments, and interest/late fee exposures. - Verify IGST vs CGST/SGST classification based on place-of-supply in Tally. - Check RCM liability recording and ITC claim accuracy on RCM payments. 4. Reconciliation Statements (Core of GSTR-9C): - Reconcile Tally Books with GSTR-9. - Prepare turnover reconciliation (GSTR-9C Table 5). - Prepare tax paid reconciliation (GSTR-9C Table 9). - Prepare ITC reconciliation (GSTR-9 Table 8) using Tally + GSTR-2B. - Identify required adjustments and provide explanations. 5. Compliance Review: - Review HSN/SAC reporting based on Tally item masters. - Check applicability and compliance of e-invoice rules. - Match e-way bills with outward supplies from Tally. - Identify non-compliant suppliers, 2B mismatches, or repeated mismatching vendors. - Review late filing, interest, penalties, and any pending litigations. 6. Observations for Audit Report: - Deviations between Tally Books and GST returns. - Incorrect tax rates or wrong place-of-supply treatment. - Frequent amendments or corrections observed in the year. - Significant variances or inconsistencies requiring reporting. - Potential exposure to departmental notices or assessments. 7. Final Output Required: - GSTR-9 ready summary (all tables filled using Tally data). - GSTR-9C reconciliation summary with clear explanations. - Month-wise mismatch tables (liability, ITC, turnover). - Supplier-wise ITC mismatch and reversal report. - Audit observations with corrective action points. - Recommendations for improving GST compliance next year. Formatting Guidelines: - Present output in structured sections with clean reconciliation tables. - Clearly list assumptions wherever any data is missing from Tally. - Use audit-ready, precise wording suitable for statutory documentation.
Prompt Output
The prompt generates the following outputs: Annual outward and inward supply summary (taxable, exempt, zero-rated, RCM) Turnover reconciliation: Tally Books vs GSTR-1 vs GSTR-3B Complete ITC analysis: eligible ITC, ineligible ITC, 17(5) disallowance, Rule 42/43 reversals Supplier-wise ITC mismatch report (Tally vs GSTR-2B) Month-wise tax liability recomputation and variance report IGST vs CGST/SGST classification review RCM liability & ITC verification GSTR-9 reconciliation tables GSTR-9C reconciliation (Tables 5, 8, 9) with explanations E-invoice and e-way bill compliance review High-risk vendor list and mismatch summary Audit observations and inconsistencies requiring reporting Final audit-ready outputs: GSTR-9 summary GSTR-9C summary Month-wise mismatch tables (liability, ITC, turnover) Supplier mismatch and reversal sheet Compliance recommendations for next year