GSTR 3B File Report: Detailed Overview and guide

In this tutorial, you'll learn how to access and use the GST 3B Filed Report from ClearTax. By following this guide, you'll generate and review the report for specific financial periods, ensuring accurate compliance and better financial insights.

1

Launch the GST software from the Clear Compliance Cloud Launchpad. This is your starting point for accessing all GST-related reports and tools.

2

Click on See All next to the report section. This will display a comprehensive list of all available reports, making it easier to locate the one you need.

3

From the list of reports, select GST 3B Filed Report. This report provides a detailed summary of your GST filings for the selected period.

4

Select your business from the dropdown menu. If you manage multiple businesses, ensure you choose the correct one to avoid any discrepancies.

5

Search and select your GSTN. Then, choose the time period for the report. You can either select a financial year or specify a particular return period for more precise data.

6

Click Generate Report to initiate the process. The system will begin compiling the data for the selected period.

7

Ensure your OTP is activated by updating your GSTN credentials. If your OTP is active, the system will automatically download your GSTN file data from the government portal and prepare the report.

8

Review the generated GSTN report. The report provides a comprehensive overview, including total turnover, total liability, and the Input Tax Credit (ITC) available. It also breaks down how much was paid using ITC versus cash, with both total and monthly amounts displayed.

9

Expand the rows if needed to view a detailed bifurcation of the amounts. This helps you understand how each value was calculated.

10

Click Expand All Rows to view a detailed bifurcation of the entries in Table 3.1.1. This action reveals a comprehensive breakdown of the taxable values and tax amounts, including individual components like IGST, CGST, and SGST. By expanding all rows, you're able to analyze the data at a granular level, ensuring accuracy in reporting and compliance.

11

Proceed to Table 3.2, which provides an in-depth view of supplies made to unregistered persons, composition taxable persons, and UIN holders. This table builds upon the details declared in Table 3.1A, offering a more segmented analysis of outward supplies. It highlights the taxable value and tax amounts, with a particular focus on IGST.

This section of the GSTN reporting emphasizes the outward supplies and their detailed bifurcation. It ensures that the total taxable value and the total tax, especially the IGST amount, are accurately captured and reported.

12

Review the eligible ITC details in Table Four. This table outlines the ITC available, whether fully or partially, for various components. These include the import of goods, import of services, inward supplies liable to reverse charge, and inward supplies from ISD. Each component is listed with its corresponding values, making it easier to track and verify.

By following these steps, you've successfully accessed and reviewed the GST 3B Filed Report. This ensures your compliance is accurate and provides valuable insights into your financial data.

13

Examine the total of all ITC components. This total represents the sum of all ITC available from the different components listed in Table Four. It's crucial to ensure that these totals align with your records for accurate reporting.

14

Navigate to Section B to view the ITC reversed details. This section provides a breakdown of ITC that has been reversed under specific rules or sections.

15

Check the components under ITC Reversed. This section includes details of ITC reversed under Rule 42, Rule 43, or other applicable rules like Rule 38, 42, 43, or Section 75. Each reversal is categorized for clarity, helping you understand the adjustments made.

16

Look for any ITC reversed that's not part of the sections like 38, 42, 43, or Sections 17 and 5 in the ITC Reversed Others subsection. This subsection captures any additional reversals that don't fall under the predefined categories.

17

Confirm the need for ITC availability and review additional related information. This step ensures that all ITC details are accounted for and any discrepancies are addressed.

18

Explore information under Section 17(5). This section includes details about ITC that was reclaimed or reversed under Table 4B2 in any previous or earlier tax period. It's essential to cross-check these details to ensure compliance with GST regulations.

19

Identify any ineligible ITC details under Section 16(4) and ITC restricted due to POS provisions in the same table. These details highlight ITC that cannot be claimed, helping you avoid errors in your filings.

20

Check for values of exempted, nil-rated, and non-GST supplies. These values are also available in the same section and provide a complete picture of your tax liabilities and exemptions.

21

Examine any interest and late fee details, which are also provided in this section. These details help you track any additional charges incurred due to delays or errors in filing.

22

Note that the rows have been expanded for detailed viewing. This expanded view allows you to analyze each entry thoroughly.

23

Collapse the rows if necessary. If you need to expand them again for a better view, proceed to do so. This flexibility ensures that you can toggle between a summarized and detailed view as needed.

24

Review any tax payments declared. This step ensures that all payments are accurately recorded and match your financial records.

25

View the total tax declared in this section. This total includes all tax components and provides a summary of your tax liabilities.

26

Access the ITC Offset Report to view detailed month-wise information on tax payments under various components like supplies, interest, and late fees. This report also provides a breakdown of Input Tax Credit (ITC) availability, specifying whether it's available in full or part. Additionally, it highlights details about reversed or ineligible ITC, helping you identify discrepancies or areas requiring attention.

27

Navigate to the Insight section to obtain a consolidated overview of the report. This section presents the overall turnover for each month in a clear graphical format. The graph uses distinct colors to differentiate between various data types, such as taxable turnover, exempt turnover, and zero-rated turnover, making it easier to interpret and analyze the information.

By following these steps, you're equipped to thoroughly review and manage your ITC details, ensuring compliance and accuracy in your tax filings.

28

In the same Insight section, review detailed turnover information month by month. This breakdown lets you track your business's performance over time, identify trends, and pinpoint months with significant fluctuations in turnover.

29

Check out the total liability details in the Insight section. This feature provides a comprehensive view of your total financial obligations, including tax liabilities under different heads. It's a crucial step for understanding your overall tax position and planning your finances effectively.

30

Examine how tax payments have been made through ITC. This section offers a dual representation: a graphical view for quick insights and a tabular bifurcation for detailed analysis. It breaks down tax amounts paid under different components using ITC, such as CGST, SGST, and IGST, helping you understand how ITC has been utilized.

31

Utilize the available filters to refine the data displayed. For instance, if you're interested in viewing tax paid through ITC details for a specific month, apply the filters accordingly. This feature is particularly useful for analyzing specific reporting periods or focusing on particular aspects of your financial data, such as ITC utilization trends or tax payment patterns.

32

Conduct a detailed comparative analysis of the ITC claim and RCM liability. The report visually distinguishes these two metrics: RCM liability is represented in light pink, while the ITC claim is displayed in sky blue. This color-coded representation simplifies the comparison process.

33

View the overall graphical representation of RCM liability versus ITC claim. This section also includes a return period-wise comparison and a tabular format report, providing a comprehensive study of the two metrics. It's an essential step for identifying mismatches or areas where ITC claims might not fully offset RCM liabilities.

34

Check the data availability status to find comprehensive information such as the GSTN number, return type, GSTN connection status, download status, and the last download date. If the data isn't up-to-date, reconnect with the GSTN and download the latest information to ensure accuracy.

35

Download the report into Excel in multiple formats. Click on the drop down menu to select the desired format. For example, to download the overall GSTR 3B file report, which mirrors the government-provided form, select the corresponding option. This step ensures you have offline access to the data for further analysis or record-keeping.

To view the ITC Offset Report, which details how much amount you've paid through ITC or other components, follow these steps:

1

Click on ITC Offset Report to access this crucial report provided by Clear. This report gives you a detailed breakdown of your transactions, including tax payments and ITC utilization.

2

Return to the report section by clicking on the appropriate area in the user interface. This ensures you're back to the main dashboard for further navigation or analysis.


By following these steps, you're equipped to analyze your financial data effectively, make informed decisions, and ensure compliance with tax regulations.

To download the GSTR Inside Report, which offers a comprehensive summary and bifurcation of your consolidated reports, proceed with the following steps:

3

Click on the report to initiate the download. This Inside Report provides an overview, which you can review directly on our user interface. It includes key metrics and data points for a quick understanding of your tax position.

4

Observe the RCM versus ITC claim in the provided table or sheet. This step allows you to analyze the data in detail, ensuring all claims and liabilities are accurately recorded and reconciled.

To access and understand the GST 3B file PDF, an acknowledgment PDF provided by the government, follow these detailed instructions. This guide will help you download, analyze, and utilize the GST 3B file PDF and related reports for better insights into your GST filings.

5

Click on GST 3B file PDF to download the zip file containing monthly PDFs. These PDFs serve as official acknowledgments of your filed GST 3B. Ensure you save the zip file in a secure location for future reference.

For a more detailed or combined view similar to the government-provided GSTN 2B filed report, use the GSTN Combined Report. This report consolidates your filings into a single, easy-to-read format.

6

Click on GSTN Combined Report to get a detailed and combined overview of your filings. This report is particularly useful for cross-verifying data and ensuring accuracy in your GST submissions.

To gain a comprehensive understanding of your GST filings, follow these steps to download and analyze the GSTL to be filed report. This report provides a detailed breakdown of all essential information.

7

Download the GSTL to be filed report for a detailed and comprehensive view. This report combines all critical data, offering an overall insight into your GST filings.

8

Focus on section 3.2 of the report to understand specific details about the GSTR-3B filed report. This section highlights key data points, making it easier to identify discrepancies or areas requiring attention.

9

Explore the various components of the GSTR-3B filed report. This report provides a detailed bifurcation of the GST-3B details you've previously filed, which are also available on the government portal. Use this breakdown to cross-check your records and ensure compliance.

10

Expand the rows in different tables to see how the values have been calculated. Each table provides a granular view of the data, helping you understand the methodology behind the calculations. We've covered a few tables in detail, and you can similarly investigate each table included in the report.

11

Download the necessary Excel sheets for future reference. These sheets are invaluable for analyzing the report in the future and maintaining a clear record of your GST filings

By following these steps, you'll have a clear and comprehensive understanding of your GST filings, ensuring accuracy and compliance. Keep these reports handy for future reference and audits.

Last updated