filling RCM details in offline tool
This query is : Resolved
30 August 2017
Where should I fill RCM details in GSTR Excel workbook templet
Guest
Guest
(Expert)
30 August 2017
please see my video.It will help you to file return.
https://youtu.be/9Myx8rN2tt4
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.
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.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- CLOSING STOCK QUERY
- Gst on travel by air for business purposes
- GST ISD Query on various AMCs
- Missed TDS
- Rent claimed on building given on permissive possession basis
- F&O reporting in ITR
- ITR 44AD SECTION
- Query regarding Item 61/62/63 vs Item 64 in ITR-3
- Taxation on Old jewellery sold
- Query regarding reporting of exempt foreign remuneration in ITR
- Gst reverse charge mechanism to be claimed in the month of payment
- Itr processing refund
- U/S 194 T
- TDS refund Indemnity Bond
- ITC BENEFIT ON BROKRAGE PAID
- PF wage ceiling
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
