GST Reports

GST Reports

GST Reports provide comprehensive GST (Goods and Services Tax) compliance information, including GSTR filings, tax calculations, input tax credit, and GST-related analytics in EquiBillBook. This guide will help you generate and use GST reports effectively.

Understanding GST Reports

GST Reports help you:

• Prepare GSTR filings (GSTR-1, GSTR-2, GSTR-3B, etc.)
• Track GST collected and GST paid
• Monitor input tax credit (ITC) availability and utilization
• Analyze GST by tax type (CGST, SGST, IGST)
• Ensure GST compliance and accuracy
• Generate reports for GST returns filing

Accessing GST Reports

To generate GST reports:

1. Navigate to the Reports module from the main menu
2. Click on Tax Reports → GST Reports
3. Select the specific GST report type
4. Select date range and filters
5. Click "Generate Report"

Types of GST Reports

1. GSTR-1 Report (Outward Supplies)

GSTR-1 report includes:

• B2B (Business to Business) invoices
• B2C (Business to Consumer) invoices
• Credit notes and debit notes
• Exports and SEZ supplies
• Taxable, exempt, and nil-rated supplies
• HSN/SAC code-wise summary

2. GSTR-2 Report (Inward Supplies)

GSTR-2 report includes:

• Purchase invoices from suppliers
• Input tax credit details
• Reverse charge transactions
• Import of services
• Credit and debit notes received

3. GSTR-3B Report (Summary Return)

GSTR-3B report includes:

• Outward taxable supplies
• Inward supplies liable to reverse charge
• Input tax credit available
• Tax payable and tax paid
• Interest and late fees

4. GST Summary Report

GST summary includes:

• Total GST collected (CGST, SGST, IGST)
• Total GST paid
• Net GST liability
• ITC available and utilized
• GST by tax rate

Report Information Displayed

GST Collection Details

The report shows:

• CGST Collected: Central GST collected on sales
• SGST Collected: State GST collected on sales
• IGST Collected: Integrated GST collected on sales
• CESS Collected: CESS amount collected
• Total GST Collected: Sum of all GST types

GST Payment Details

Payment information includes:

• CGST Paid: Central GST paid on purchases
• SGST Paid: State GST paid on purchases
• IGST Paid: Integrated GST paid on purchases
• CESS Paid: CESS amount paid
• Total GST Paid: Sum of all GST payments

Input Tax Credit (ITC)

ITC details include:

• ITC Available: Total ITC available for utilization
• ITC Utilized: ITC used against tax liability
• ITC Balance: Remaining ITC balance
• ITC by Type: CGST, SGST, IGST ITC breakdown

GST Liability

Liability information includes:

• Gross GST Liability: Total GST collected
• ITC Utilized: ITC set off against liability
• Net GST Payable: Final GST amount to be paid
• Interest and Penalties: Late fees and interest

Report Parameters and Filters

Date Range Selection

Select the period for the report:

• Monthly: Select specific month
• Quarterly: Select specific quarter
• Financial Year: Select financial year
• Custom Range: Select specific from and to dates

Tax Type Filter

Filter by GST type:

• CGST: Central GST only
• SGST: State GST only
• IGST: Integrated GST only
• All: Include all GST types

Transaction Type Filter

Filter by transaction type:

• Sales: Outward supplies
• Purchase: Inward supplies
• Returns: Credit/debit notes
• All: Include all transactions

Location/Branch Filter

Filter by location or branch:

• All Locations: Include all locations/branches
• Specific Location: Select one or more locations
• GST Registration: Filter by GST registration number

HSN/SAC Code Summary

GST reports include HSN/SAC code-wise summary:

• HSN Code: For goods
• SAC Code: For services
• Taxable Value: Value before tax
• GST Amount: Tax amount by code
• Quantity: Total quantity (for goods)

Place of Supply Analysis

Reports show GST by place of supply:

• Intra-state Supplies: CGST + SGST
• Inter-state Supplies: IGST
• Export Supplies: Zero-rated supplies
• SEZ Supplies: Special Economic Zone supplies

Generating and Viewing Reports

Generate Report

1. Select GST report type
2. Select date range (month/quarter)
3. Apply filters as needed
4. Click "Generate Report" or "View Report"
5. Review the generated report

Report Preview

The report preview shows:

• Complete GST summary in preview format
• GST collection and payment details
• ITC summary
• Detailed transaction breakdown
• HSN/SAC code summary
• Options to export or print

Exporting Reports

Export Formats

Export reports in various formats:

• Excel (XLS/XLSX): For GSTR filing preparation
• PDF: For printing and sharing
• CSV: For data import to GST portal
• JSON: For direct GST portal upload (if supported)

Export Process

1. Generate and preview the report
2. Click "Export" or "Download"
3. Select export format
4. Choose export options (columns, grouping, etc.)
5. Download the exported file

GST Compliance

Pre-filing Checklist

Before filing GST returns, verify:

• All invoices are recorded correctly
• GST rates are applied correctly
• HSN/SAC codes are accurate
• Place of supply is correct
• ITC is calculated correctly
• Credit/debit notes are properly recorded

Reconciliation

Reconcile GST data:

• Match sales invoices with GSTR-1
• Match purchase invoices with GSTR-2
• Verify ITC claims
• Check for discrepancies
• Resolve mismatches before filing

Best Practices

• Generate GST reports monthly before filing returns
• Review reports for accuracy and completeness
• Reconcile GST data regularly
• Export reports for GST portal filing
• Keep exported reports for audit purposes
• Verify HSN/SAC codes are correct
• Check place of supply for accurate tax calculation
• Monitor ITC utilization regularly

Troubleshooting

Report shows incorrect GST amounts:

• Verify tax rates are configured correctly
• Check place of supply settings
• Review tax group assignments
• Verify invoice tax calculations

ITC not showing correctly:

• Check purchase invoices are recorded
• Verify supplier GST details
• Check ITC eligibility rules
• Review reverse charge transactions

HSN/SAC codes missing:

• Ensure items have HSN/SAC codes assigned
• Check item master data
• Update missing codes
• Verify code format is correct

GST Reports in EquiBillBook help you maintain GST compliance, prepare accurate returns, and ensure proper tax management for your business.