24 July 2024
In the GSTR Excel workbook template, if you need to fill Reverse Charge Mechanism (RCM) details, follow these steps:
1. **Download the GSTR Excel Workbook Template:** - Ensure you have downloaded the latest GSTR Excel workbook template from the GST portal. This template is designed to help taxpayers prepare their GSTR-1 and GSTR-2 returns offline.
2. **Open the Workbook:** - Open the Excel workbook after downloading it. The workbook typically contains multiple sheets or tabs for different sections of GSTR-1 and GSTR-2.
3. **Navigate to the GSTR-1 Worksheet:** - In the workbook, find and navigate to the sheet labeled "GSTR-1." This is where you will enter details for outward supplies.
4. **Identify the RCM Section:** - Look for the section or table where you need to enter details for supplies attracting reverse charge. In the GSTR-1 sheet, this is usually labeled as "Table 4B: Supplies made to unregistered persons (B2C) - including reverse charge supplies."
5. **Enter RCM Details:** - In the relevant table (e.g., Table 4B), you will find columns for various details such as GSTIN of the recipient (if registered), invoice number, invoice date, taxable value, integrated tax, central tax, state/UT tax, and cess. - For supplies attracting reverse charge, ensure you fill in these details accurately: - **Invoice Number and Date:** Enter the invoice number and date of the invoice. - **Taxable Value:** Enter the taxable value of the supply on which reverse charge is applicable. - **Tax Amounts:** Enter the integrated tax (IGST), central tax (CGST), state/UT tax (SGST/UTGST), and cess amounts applicable under reverse charge.
6. **Save and Validate:** - Once you have entered all the required details in the GSTR Excel workbook, save the file. - Use the offline tool's validation feature to ensure all mandatory fields are filled correctly and there are no errors or warnings.
7. **Generate JSON File:** - After validating the data, generate the JSON file using the offline tool. This JSON file is what you will upload to the GST portal for filing your GSTR-1 return.
8. **Upload to GST Portal:** - Finally, log in to the GST portal, navigate to the GSTR-1 section, and upload the JSON file generated by the offline tool.
By following these steps, you can accurately fill in the RCM details in the GSTR Excel workbook template using the offline tool provided by the GST portal. Always ensure to refer to the latest guidelines and instructions from GSTN for any updates or changes in the filing process.