How to Generate Party Wise GST Report in TallyPrime

A party wise GST report in TallyPrime segregates GST data by vendor or customer, showing taxable value, tax amount, and GST rate. Access it via Gateway of Tally > Display More Reports > GST Reports or Alt+G. Filter by date, party, and GST type for compliance and audit readiness.

Understanding Party Wise GST Reports in TallyPrime

A party wise GST report is one of the most powerful analytical tools in TallyPrime for GST compliance and vendor management. Unlike statutory returns like GSTR-1 or GSTR-3B, a party wise GST report breaks down all GST transactions by individual party (vendor, customer, or supplier). This means you see exactly how much GST each party has contributed to your inbound or outbound supply chain, making it ideal for internal audits, vendor reconciliation, and tax planning.

Since TallyPrime 6.x introduced connected GST features, generating accurate party wise reports has become seamless. The system automatically calculates GST liability and input tax credit at the party level, eliminating manual errors and saving hours of reconciliation work.

Why Party Wise GST Reports Matter for Your Business

Every business dealing with multiple vendors or customers faces the challenge of tracking GST across numerous transactions. A party wise GST report solves this by providing a single-point view of GST exposure per party. For example, if you have 50 suppliers, the party wise report shows you GST paid to each one, helping identify which vendors consume the most input credit and which may have compliance issues.

This is critical for GST audit preparation. Tax authorities often ask for party-level GST breakup to verify GSTR-2B reconciliation. A well-maintained party wise report in TallyPrime demonstrates transparency and reduces audit risk significantly.

Enabling GST in TallyPrime: First Steps

Before generating any GST report, you must enable GST in your TallyPrime company. Press F11 to open Company Configuration. Navigate to Statutory and Taxation > GST Details. Set your GSTIN (Goods and Services Tax Identification Number), state code, and GST registration type (Regular, Composition, or Unregistered). Save and restart TallyPrime for changes to take effect.

Once GST is enabled, all new vouchers will have GST fields. Existing vouchers may need amendment to add GST details. TallyPrime will not generate accurate GST reports if this foundational step is skipped.

Accessing Party Wise GST Report: Menu Path

The quickest way to access the party wise GST report is using the Alt+G shortcut. This opens the GST Reports menu directly. Alternatively, navigate via Gateway of Tally > Display More Reports > GST Reports > Party Wise GST. Both paths lead to the same report interface.

Once the report opens, you will see a summary of GST transactions grouped by party name. The report displays party code, party name, total taxable value, SGST, CGST, IGST (or UGST for union territories), and total GST amount. Each row represents one party.

Filtering Party Wise GST Report by Date Range

By default, the party wise GST report shows data for the current financial year. To filter by a specific date range, press F2 after opening the report. A date filter dialog will appear. Enter the From Date and To Date, then press Enter. The report will recalculate to show only transactions within that range.

This is useful when you need to analyze GST for a specific quarter, month, or project period. For instance, if you want to see GST paid to suppliers in Q2 FY2025-26, set the date range from 01-Jul-2025 to 30-Sep-2025 and the report will refresh instantly.

Filtering by Party Name and GST Type

Party wise GST reports can also be filtered by individual party name. Press F3 to open the Filter dialog. Select Party Name and enter the vendor or customer name. This narrows the report to show GST details for only that party, useful for vendor reconciliation or dispute resolution.

You can also filter by GST Type: Inbound (purchases) or Outbound (sales). This separation helps you track input tax credit separately from output tax liability, a key requirement for GST reconciliation and GSTR-2B matching.

Understanding Party Wise GST Report Columns

Each column in the party wise GST report serves a specific purpose. Party Name and Code identify the vendor or customer. Taxable Value shows the net amount before GST. SGST (State GST) and CGST (Central GST) are applicable for intra-state transactions, typically at 5%, 9%, or 18% each. IGST (Integrated GST) applies to inter-state transactions at double the combined rate.

The Total GST column sums SGST, CGST, and IGST for each party. Some reports also show HSN/SAC codes, invoice count, and average tax rate. Understanding these columns helps you spot anomalies, such as a party with unusually high GST rate, which may indicate incorrect master data or voucher entry.

Worked Example: Generating a Party Wise GST Report

Let us walk through a real scenario. Suppose you operate a manufacturing business in Bangalore (Karnataka) and want to analyze GST paid to suppliers in November 2025. You have three main suppliers: Supplier A (intra-state), Supplier B (inter-state), and Supplier C (intra-state).

Step 1: Press Alt+G to open GST Reports. Step 2: Select Party Wise GST. Step 3: Press F2 and set From Date to 01-Nov-2025 and To Date to 30-Nov-2025. Step 4: Press Enter to refresh. The report now shows:

Party Name	Taxable Value (Rs)	SGST (Rs)	CGST (Rs)	IGST (Rs)	Total GST (Rs)
Supplier A	100,000	9,000	9,000	0	18,000
Supplier B	150,000	0	0	27,000	27,000
Supplier C	80,000	7,200	7,200	0	14,400

From this report, you can see that Supplier B (inter-state) accounts for the highest GST at Rs 27,000 due to IGST. Suppliers A and C combined contribute Rs 32,400 in intra-state GST. This data helps you plan cash flow for GST payment, identify high-value suppliers, and prepare for GSTR-2B reconciliation.

Party Wise GST Report vs GSTR-2B Reconciliation

GSTR-2B is the statutory inbound supply return filed by tax authorities, showing what suppliers have claimed in their GSTR-1. Your party wise GST report should match GSTR-2B data. If there are discrepancies, it indicates either data entry errors in TallyPrime or supplier filing issues.

To reconcile, export your party wise GST report (Ctrl+E) and compare party-wise totals with GSTR-2B. If a supplier's GST amount in your books differs from GSTR-2B, investigate the vouchers for that party, check invoice numbers, and verify HSN/SAC codes. TallyPrime 6.x has built-in reconciliation tools under Gateway of Tally > Display More Reports > GST Reports > GSTR-2B Reconciliation.

Exporting Party Wise GST Report to Excel

To share party wise GST reports with auditors, accountants, or management, export to Excel. While viewing the report, press Ctrl+E. A dialog appears asking for export format. Select Excel (.xlsx). TallyPrime will generate a spreadsheet with all report data, maintaining formatting and calculations.

Alternatively, press Ctrl+P to print, then select Print to PDF. This creates a read-only version suitable for email distribution or archival. Both methods preserve the report structure and make further analysis or comparison easy.

Handling GST on Reverse Charge Transactions

Reverse charge applies when you purchase from unregistered suppliers or specific services like transportation. In a party wise GST report, reverse charge transactions appear separately. The GST amount is shown as payable output tax, not input credit. This is critical for GSTR-3B filing, as reverse charge GST cannot be claimed as input tax credit.

In TallyPrime, mark reverse charge transactions by enabling the Reverse Charge checkbox in the voucher. The party wise report will automatically segregate these, helping you calculate net GST liability correctly.

Party Wise GST Report for Sales (Outbound Supply)

The party wise GST report is equally useful for analyzing outbound GST (sales tax). It shows GST collected from customers, helping you prepare GSTR-1 and track output tax liability. Filter the report to show only sales vouchers by party, then compare with GSTR-1 to ensure all invoices are correctly reported.

This is especially important if you have exempt supplies, zero-rated supplies, or supplies to SEZ units. The party wise report helps identify which customers fall under which category, ensuring correct GST treatment and GSTR-1 filing.

Using Party Wise GST Report for Vendor Audits

When auditing a specific vendor, the party wise GST report is your first stop. Filter by that party name to see all transactions, GST amounts, and invoice details. Compare this with the vendor's invoices and delivery notes to verify accuracy. If GST amounts in TallyPrime do not match vendor invoices, correct the vouchers immediately.

This process prevents GST input credit disputes and ensures your books are audit-ready. Many businesses use this report monthly to catch errors early, reducing last-minute corrections during GST audit season.

Party Wise GST Report and Input Tax Credit Optimization

Input tax credit (ITC) is the GST paid on inbound supplies that you can claim against output tax. The party wise GST report shows exactly which parties contribute to your ITC pool. By analyzing this report, you can identify high-ITC suppliers and ensure all their invoices are correctly entered in TallyPrime with proper HSN/SAC and GST rates.

For example, if a supplier typically provides 18% GST items but one invoice shows 5%, the party wise report will flag this anomaly. Correcting such errors before GSTR-2B filing prevents ITC reversal notices from tax authorities.

Customizing Party Wise GST Reports

TallyPrime allows customization of party wise GST reports through MIS report customization. You can add or remove columns, change sorting order, apply conditional formatting, and save custom layouts. Access customization via Gateway of Tally > Display More Reports > GST Reports > Party Wise GST, then press Alt+C or navigate to Report Settings.

Custom reports might include additional fields like party contact, payment terms, or invoice count. These enhancements make the report more actionable for business analysis beyond compliance.

Party Wise GST Report and e-Invoicing Integration

If you have enabled e-invoicing in TallyPrime (requires active TSS and IRN generation), the party wise GST report automatically includes e-invoice data. IRN (Invoice Reference Number) and QR codes are embedded, and GST amounts are verified against IRP (Invoice Registration Portal) records. This ensures your party wise report is always compliant with e-invoicing standards.

When you generate party wise GST reports with e-invoicing enabled, TallyPrime cross-checks GST amounts with IRN records, flagging any discrepancies. This is a powerful audit tool that reduces manual verification effort.

Party Wise GST Report for Multi-State Operations

If your business operates across multiple states, the party wise GST report becomes even more critical. It segregates SGST, CGST, and IGST by party, showing which states contribute to your GST liability. This helps with state-level GST planning and ensures correct IGST treatment for inter-state supplies.

For instance, if you have suppliers in Delhi, Mumbai, and Chennai, the party wise report shows GST paid to each state separately. This data is essential for GSTR-2B reconciliation, as tax authorities verify state-wise GST matching.

Troubleshooting Party Wise GST Report Issues

If your party wise GST report shows incorrect totals or missing parties, the issue usually lies in voucher entry or master data. First, verify that GST is enabled (F11 > Statutory and Taxation > GST Details). Second, check if all parties have GST registration status set correctly in their master (Gateway of Tally > Accounts Info > Ledgers > select party > GST Details).

If vouchers are missing, use Tally customization to rebuild the report or run a data repair (Alt+Y > Data > Repair). Back up your data before repair. If issues persist, contact your Tally support partner for deeper troubleshooting.

Party Wise GST Report and Compliance Calendar

Use the party wise GST report as part of your monthly GST compliance routine. Generate it on the 15th of each month to review inbound and outbound GST, reconcile with GSTR-2B, and identify discrepancies early. This proactive approach reduces last-minute errors when filing GSTR-3B (due by the 20th of the next month for regular taxpayers).

Document your party wise GST reports monthly in a compliance folder. This creates an audit trail and demonstrates due diligence to tax authorities if questioned.

Integrating Party Wise GST with TallyPrime Approval Workflow

For larger organizations, Tally approval workflow can be configured to require approval of high-value GST transactions before posting. The party wise GST report then reflects only approved transactions, ensuring data integrity. This is particularly useful for organizations with strict internal controls.

Configure approval workflows in F11 > Statutory and Taxation > Approval Settings. Once enabled, all GST-related vouchers above a threshold amount require manager approval before the party wise report includes them.

Party Wise GST Report for Financial Planning

Beyond compliance, the party wise GST report is a financial planning tool. Analyze GST trends by party over quarters to forecast GST liability, plan cash flow, and negotiate payment terms with suppliers. For example, if a supplier consistently provides high-ITC items, prioritize timely payment to ensure uninterrupted supply and smooth ITC claims.

Export historical party wise GST reports (3-6 months) to Excel and create trend charts. Share these insights with your finance team for better budgeting and vendor relationship management.

Party Wise GST Report and TSS Renewal Benefits

Keeping your TallyPrime TSS (Technical Support Services) active ensures you receive the latest GST updates, including changes to tax rates, new compliance rules, and bug fixes. Party wise GST reports depend on accurate GST rules embedded in TallyPrime. When TSS is active (Silver: Rs 4,500/year, Gold: Rs 13,500/year, plus 18% GST), you get timely updates that keep your reports compliant.

If your TSS expires, TallyPrime continues to work, but you will not receive GST rule updates, potentially causing compliance issues. Early TSS renewal adds approximately one free month, and two-year renewal offers about 10% discount.

Connecting with Expert Support for Party Wise GST Reports

Generating accurate party wise GST reports requires proper TallyPrime setup, correct master data, and disciplined voucher entry. If you are struggling with report accuracy or need help optimizing your GST processes, Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar since 2010, is here to help. We provide hands-on training, data cleanup, custom report design, and ongoing support to ensure your party wise GST reports are always compliant and actionable. Contact us today at +91 75469 00951 to schedule a consultation and transform your GST compliance workflow.