Skip to main content

Tax Summary Report

Overview​

The Tax Summary Report provides a consolidated view of all tax liabilities and input credits for a selected period. This report is essential for calculating net GST payable and preparing GSTR-3B returns, giving you a quick snapshot of your tax position.

When to Use This Report​

Use this report when you need to:

  • Calculate net GST payable or refundable for a period
  • Prepare monthly or quarterly GSTR-3B returns
  • Compare output tax liability vs input tax credit
  • Assess tax cash flow requirements
  • Verify tax position before filing deadline
  • Monitor tax health of the business
  • Plan for tax payments to government

How to Run the Report​

Step 1: Navigate to Tax Reports​

Access through main navigation: Reports → Tax Reports

The Tax Reports dashboard shows all available tax report cards.

Step 2: Select Report Type​

Click on the Tax Summary (TS) card or select "Tax Summary" from the Reports dropdown menu.

The report interface opens with filter options.

Step 3: Select Time Period​

Available Period Filters:

Month Filter:

  • Click the Month dropdown
  • Select the month you want to analyze
  • Typically matches your GSTR-3B filing period

Quarters Filter:

  • Click the Quarters dropdown
  • Select Q1, Q2, Q3, or Q4
  • For businesses filing GSTR-3B quarterly

Date Display: Shows the active period: Date: 01-09-2025 - 30-09-2025

Step 4: Run Report​

Click the Run Report button (teal colored, top right).

The system calculates and displays the consolidated tax summary.

Understanding the Report​

Report Structure​

The Tax Summary Report displays a clean, consolidated table with these components:

ColumnDescriptionPurpose
Tax TypeType of GST (IGST, CGST, SGST)Identifies tax component
Tax PercentageApplicable tax rateShows the rate structure
Output TaxTax collected on sales (liability)What you owe to government
Input Tax CreditTax paid on purchases (credit)What you can offset against liability
Net LiabilityOutput Tax - Input Tax CreditActual tax payable (or refundable)
Taxable AmountTotal value of taxable suppliesBase amount for tax calculation

Field Definitions​

Tax Type​

Identifies the GST component being reported:

IGST (Integrated GST):

  • Applies to interstate transactions
  • Single consolidated tax
  • Both output and input shown separately

CGST (Central GST):

  • Applies to intrastate transactions (Central portion)
  • Typically not shown separately in summary reports
  • Combined with SGST for intrastate liability

SGST (State GST):

  • Applies to intrastate transactions (State portion)
  • Typically not shown separately in summary reports
  • Combined with CGST for intrastate liability

In most Tax Summary reports, only IGST is shown as a separate line item, with a consolidated Net Total row combining all tax types.

Tax Percentage​

The applicable GST rate for the transactions:

Common Rates:

  • 18% (most common for goods and services)
  • 28% (luxury goods, sin goods)
  • 12% (standard rated goods)
  • 5% (essential goods)
  • 0% (zero-rated or exempt)

Note: The report typically shows the predominant rate or displays "-" if multiple rates are aggregated.

Output Tax​

Total GST collected on your sales (outward supplies) during the period.

What's Included:

  • GST on all sales invoices
  • Tax on services provided
  • Interstate (IGST) and intrastate (CGST+SGST) sales
  • Reverse charge tax if applicable

What's Excluded:

  • Credit notes issued (reduce output tax)
  • Exempt or nil-rated supplies
  • Cancelled invoices

Significance: This is your tax liability to the government before adjusting input credits.

Example from screenshot: Output Tax = ₹1,34,316.00

Input Tax Credit (ITC)​

Total GST paid on your purchases (inward supplies) that you're eligible to claim as credit.

What's Included:

  • GST on purchase bills from registered suppliers
  • Tax on business expenses
  • Interstate (IGST) and intrastate (CGST+SGST) purchases
  • Import GST (IGST)

What's Excluded:

  • Purchases from unregistered suppliers
  • Ineligible expenses (personal use, blocked credits)
  • GST on purchases where payment not made within 180 days

Significance: This credit offsets your output tax liability, reducing the actual amount payable.

Example from screenshot: Input Tax Credit = ₹8,79,181.99

Net Liability​

The actual amount payable to (or refundable from) the government.

Formula: Net Liability = Output Tax - Input Tax Credit

Understanding the Result:

Negative Value (shown with minus sign):

  • Input Tax Credit exceeds Output Tax
  • You have a refund or credit to carry forward
  • Example: -₹7,44,865.99 means ₹7,44,865.99 refundable/credit

Positive Value:

  • Output Tax exceeds Input Tax Credit
  • You need to pay this amount to government
  • Example: +₹50,000 means ₹50,000 payable

Zero:

  • Output tax and input credit are equal
  • No payment required, no refund due

Taxable Amount​

Total value of all taxable supplies (sales) before adding GST.

Calculation:

  • Sum of basic amounts from all invoices
  • Excludes GST amount
  • Includes only taxable supplies (not exempt/nil rated)

Purpose:

  • Shows business turnover for tax purposes
  • Used to determine filing frequency requirements
  • Helps track business growth

Example from screenshot: Taxable Amount = ₹56,30,544.40

This means total taxable sales (before GST) were ₹56,30,544.40

Reading the Report Data​

Sample Interpretation​

Looking at the data from the screenshot:

Tax Summary for September 2025:

IGST Row:

  • Tax Percentage: 18%
  • Output Tax: ₹1,34,316.00
  • Input Tax Credit: ₹8,79,181.99
  • Net Liability: -₹7,44,865.99
  • Taxable Amount: ₹56,30,544.40

What this means:

  1. Sales: You made taxable sales worth ₹56,30,544.40 (before tax)

  2. Output Tax: You collected ₹1,34,316.00 as GST from customers (liability)

  3. Input Credit: You paid ₹8,79,181.99 as GST on purchases (credit available)

  4. Net Position: Your input credit (₹8,79,181.99) is MORE than your output tax (₹1,34,316.00)

  5. Result: You have a credit balance of ₹7,44,865.99 which can be:

    • Carried forward to next month
    • Used to offset future liabilities
    • Claimed as refund (subject to conditions)

Net Total Row:

  • Shows the same values aggregated across all tax types
  • In this case, only IGST shown, so Net Total = IGST row
  • Confirms overall tax position for the period

Common Scenarios​

Scenario 1: Net Tax Payable​

Data:

  • Output Tax: ₹5,00,000
  • Input Tax Credit: ₹3,50,000
  • Net Liability: ₹1,50,000

Action Required:

  • Pay ₹1,50,000 to government in GSTR-3B
  • Ensure payment before filing deadline
  • Generate challan and make e-payment

Scenario 2: Net Credit (Refund)​

Data:

  • Output Tax: ₹2,00,000
  • Input Tax Credit: ₹4,50,000
  • Net Liability: -₹2,50,000

Action Required:

  • No payment needed this month
  • Carry forward ₹2,50,000 credit to next month
  • Use credit against future liabilities
  • Consider refund claim if persistent credit

Scenario 3: Zero Liability​

Data:

  • Output Tax: ₹3,00,000
  • Input Tax Credit: ₹3,00,000
  • Net Liability: ₹0

Action Required:

  • File nil return in GSTR-3B
  • No payment required
  • Credits and liabilities perfectly balanced

Using for GSTR-3B Filing​

The Tax Summary Report directly maps to GSTR-3B return sections:

GSTR-3B Mapping:

Table 3.1 - Tax on outward and reverse charge supply

  • Use Output Tax values from this report

Table 4 - Eligible ITC

  • Use Input Tax Credit values from this report

Table 6.1 - Payment of tax

  • Use Net Liability to determine payment amount
  • Positive = Pay from cash ledger
  • Negative = Adjust from credit ledger or carry forward

Best Practices​

Before Filing GSTR-3B

  • Run Tax Summary report for the filing period
  • Cross-verify output tax with Summary of Outward Supplies
  • Cross-verify input credit with Summary of Inward Supplies
  • Ensure all invoices and bills are approved
  • Check GSTR-2B for any missing ITC
  • Match net liability with cash flow availability

Monthly Best Practices

  • Review tax summary mid-month to anticipate liability
  • Monitor ITC accumulation trends
  • Plan cash flow for tax payments
  • Track credit carry-forward balances
  • Reconcile with accounting records
  • Address any discrepancies before month-end

Troubleshooting​

Mismatch with Other Reports​

Issue: Tax Summary doesn't match Inward/Outward Supply reports

Solutions:

  • Ensure same date range selected in all reports
  • Verify all transactions are approved
  • Check for cancelled or credit note adjusted entries
  • Rerun all reports after any corrections
  • Contact support if mismatch persists

Unexpected Credit Balance​

Issue: Large input credit accumulated

Possible Reasons:

  • High-value purchases in the period
  • Capital expenditure with significant GST
  • Export sales (zero-rated with full ITC)
  • Business slowdown with ongoing purchase commitments

Actions:

  • Verify all ITC claims are legitimate
  • Consider refund application if persistent
  • Check ITC eligibility conditions
  • Plan to utilize credit in upcoming periods

Missing Transactions​

Issue: Expected transactions not reflected

Solutions:

  • Check transaction dates are within period
  • Verify document approval status
  • Ensure proper tax configuration
  • Review cancelled or draft documents
  • Validate data entry completion

Compliance Reminders​

GSTR-3B Filing Deadlines:

  • Monthly Filers: 20th of next month
  • Quarterly Filers (QRMP): 22nd or 24th of month following quarter
  • Late filing: ₹50/day penalty (₹20/day for nil returns)
  • Late payment: 18% interest per annum on tax due

ITC Claiming Rules:

  • Claim ITC only if invoice in GSTR-2B
  • Time limit: Earlier of September return next FY or annual return date
  • Payment to supplier within 180 days required
  • Match invoices with supplier GSTR-1 data

Need help? Contact support at support@bizconnekt.com