Summarizing the GST Tax File to Match with GSTR2A

Before you can match the transactions in the GST Tax File table (F75I807) with the GSTR2A report, you must summarize the tax information in the F75I807 table in a format that can be matched with the report.

You use the GST Tax File Summarization program (R75I803) to summarize the tax information in the F75I807 table. The system selects tax records for summarization from the F75I807 and F0411 tables. Only posted transactions that are not voided and are not matched are eligible for the summarization.

The system searches the F75I807 and F0411 tables for transactions that match the values in these fields in the order listed below:

1. GSTIN of the purchaser

2. GSTIN of the supplier

3. Invoice date

4. Invoice number

5. GST Rate Type

For each set of transactions with matching values, the system sums the amounts for the tax types (CGST, SGST, IGST, and Cess), the taxable amount, and the gross amount, and inserts a record in the GST Tax File Summarization Detail Workfile table (F75IUI83). If the value changes for any of these fields, then a new record is inserted in the F75IUI83 table.

You can run this report any number of times with any date range. The system generates a summarization job ID every time you run this report. The summarization job ID is saved in the GST Tax File Summarization Header Workfile table (F75IUI82). For each report run, the system adds only one record in the F75IUI82 table with the unique summarization job ID. When you match the summarized information with the GSTR2 report later in the process, you can select a specific job ID for matching.