Learn how to extract GST refund data from TallyPrime step by step. Discover how to export sales, purchase, GSTR-1, GSTR-3B and Input Tax Credit (ITC) reports into Excel, reconcile accounting records with the GST portal and prepare accurate supporting documents for GST refund claims.
How to Extract Tally Data for GST Refund Claims – Complete Step-by-Step Guide
Claiming a GST refund in India involves more than simply submitting an application on the GST portal. Before applying, businesses need to organise their sales, purchase, tax payment and Input Tax Credit (ITC) records to ensure that the refund amount is accurate and supported by proper documentation.
If you maintain your accounts in TallyPrime, you can extract most of the information required for a GST refund directly from your accounting data. This saves time, reduces manual calculations and makes it easier to identify differences between your books and GST returns.
In this guide, you will learn how to extract GST-related data from TallyPrime, which reports to prepare, how to export them into Excel and what to check before submitting a GST refund application.
Understanding GST Refund Data Requirements
A GST refund may arise for different reasons, such as:
Excess balance in the Electronic Cash Ledger.
Export of goods or services under a Letter of Undertaking (LUT) without payment of IGST.
Export of goods or services with payment of IGST, where applicable.
Accumulated Input Tax Credit due to an inverted duty structure.
Excess tax paid due to an error or incorrect calculation.
Other eligible situations recognised under GST law.
The documents and calculations required depend on the reason for claiming the refund.
For example, a manufacturer exporting goods under LUT may need export invoices, relevant sales records, eligible ITC details and supporting statements. A business claiming a refund of excess cash balance will need to reconcile its cash ledger with the refund amount.
Important: TallyPrime helps you prepare accounting information and supporting reports. It does not automatically establish your eligibility for a GST refund. The applicable GST provisions, refund category and GST portal requirements must also be checked.
TallyPrime Reports Required for GST Refund Claims
Before extracting data, identify the reports that support your refund application.
TallyPrime Report | Why It Is Required |
|---|---|
Sales Register | To verify taxable sales and export invoices |
Purchase Register | To review purchases and input tax details |
GSTR-1 Report | To reconcile outward supply information |
GSTR-3B Report | To review tax liability and ITC figures |
GST Tax Analysis | To examine CGST, SGST and IGST amounts |
Input Tax Credit Report | To identify eligible and available ITC |
Ledger Vouchers | To verify individual transactions |
Stock Summary | To support quantity and stock-related reconciliation where relevant |
Day Book | To review accounting entries for the selected period |
The availability and exact names of these reports may vary depending on your TallyPrime release and GST configuration.
How to Prepare Your TallyPrime Company Data Before Exporting
Before extracting GST information, make sure your accounting records are complete. Incorrect ledger configurations or missing GST details can affect the accuracy of your reports.
Follow these checks before starting:
Confirm that GST is enabled in your TallyPrime company.
Verify your company's GSTIN and state details.
Check that sales and purchase ledgers have the correct GST classifications.
Confirm that stock items have the appropriate HSN codes and tax rates.
Record all purchase and sales invoices for the relevant period.
Check credit notes, debit notes and cancelled vouchers.
Verify that purchase entries contain the correct supplier GSTIN wherever applicable.
Take a backup of your TallyPrime company data.
For example, if you are preparing a refund claim for April to September, 2026, select the exact six-month period in your reports. Avoid mixing transactions from different financial years or refund periods.
Step-by-Step: How to Extract GST Sales Data from TallyPrime
Sales information is particularly important for refund applications involving exports, SEZ supplies and other eligible outward supplies.
You can use the GSTR-1 report to review and export your sales information.
Step 1: Open the GSTR-1 Report
Open your company in TallyPrime.
Press Alt + G (Go To).
Search for GSTR-1.
Select the GSTR-1 report and press Enter.
Step 2: Select the Required Period
Press F2 (Period) and enter the refund period.
For example:
From: 1 April 2026
To: 30 September 2026
Make sure the period matches the refund application and applicable GST requirements.
Step 3: Review Sales Transactions
Check the following information:
B2B sales invoices.
B2C sales invoices.
Export sales.
SEZ supplies.
Credit notes and debit notes.
Taxable sales value.
IGST, CGST and SGST amounts.
HSN/SAC summary.
Pay particular attention to export invoices. Verify invoice numbers, dates, recipient details, taxable values and the applicable export transaction classification.
Step 4: Export the Sales Data
Once the report has been checked:
Press Alt + E (Export).
Select the relevant GST export option available in your release.
Choose the required period and GST registration.
Select the transactions or summaries you need.
Choose Excel (Spreadsheet), CSV or JSON, depending on your purpose.
Specify the destination folder.
Confirm the export.
Menu options can differ between TallyPrime releases. The GST Returns export workflow is available in supported releases.
The exported Excel file can help you review sales invoices and prepare supporting information for the refund application.
Step-by-Step: How to Extract Purchase and Input Tax Credit Data
Purchase information is essential when you are claiming a refund of accumulated ITC, particularly under the inverted duty structure or other eligible refund categories.
Follow these steps to prepare your purchase data.
Step 1: Open the Purchase Register
Open your TallyPrime company.
Press Alt + G.
Search for Purchase Register.
Open the report.
Press F2 and select the required period.
Step 2: Review Purchase Invoices
Check the following details in your purchase records:
Supplier name and GSTIN.
Purchase invoice number.
Invoice date.
Taxable purchase value.
CGST amount.
SGST amount.
IGST amount.
Purchase classification.
Eligible and ineligible ITC.
Step 3: Check Input Tax Credit Details
Open the GST reports and review the available Input Tax Credit information.
Pay attention to:
Eligible ITC.
Ineligible ITC.
ITC reversed.
ITC available for utilisation.
Input tax on goods.
Input tax on services.
Capital goods ITC, where relevant.
Remember that the ITC shown in your accounting records is not automatically refundable. Eligibility must be determined under the applicable GST provisions.
Step 4: Export Purchase Data
After reviewing the purchase register:
Open the required report.
Press Alt + E (Export).
Choose Excel (Spreadsheet).
Select the required export configuration.
Enter the destination folder.
Confirm the export.
Save the exported file separately from your sales data so that you can easily reconcile both reports.
How to Extract GSTR-3B Data from TallyPrime
GSTR-3B contains important information about your outward tax liability, eligible ITC, reversals and tax payments.
It is useful when comparing the refund-related calculations with the figures reported in your GST returns.
Follow these steps:
Open TallyPrime.
Press Alt + G (Go To).
Search for GSTR-3B.
Open the report.
Press F2 (Period).
Select the required tax period.
Review the available sections.
Check ITC details and tax liability.
Press Alt + E (Export).
Select the required export format and save the file.
Depending on your TallyPrime version, you may also find separate Return View and Nature View options.
Compare the figures in TallyPrime with the GSTR-3B returns actually filed on the GST portal. Do not rely only on the figures generated from your books.
How to Export TallyPrime GST Reports into Excel
Excel is useful for organising refund-related information, checking invoice details and preparing reconciliation statements.
TallyPrime supports several export formats, including Excel, CSV, PDF, XML and JSON.
To export an individual accounting report:
Open the required report.
Press Alt + E (Export).
Select the Current or relevant export option.
Choose Excel (Spreadsheet) as the file format.
Configure the export settings.
Enter a suitable file name.
Select the destination folder.
Confirm the export.
For better organisation, create a separate folder for each refund period.
For example:
GST Refund – April to September 2026
Sales Register.xlsx
Purchase Register.xlsx
GSTR-1.xlsx
GSTR-3B.xlsx
ITC Details.xlsx
Refund Reconciliation.xlsx
Use clear file names and retain the original exported reports. If you make adjustments in Excel, save those in separate working copies rather than changing the original accounting exports.
For more information, refer to TallyPrime's official data export guide.
How to Reconcile Tally Data with GST Portal Records
Exporting data is only one part of the refund preparation process. You should also reconcile your accounting records with the information available on the GST portal.
This step helps identify differences before submitting a refund application.
Compare the following information:
Particulars | TallyPrime | GST Portal |
|---|---|---|
Sales invoices | Sales Register | GSTR-1 |
Taxable turnover | GST Sales Report | GSTR-1 / GSTR-3B |
Output tax | GST Tax Analysis | GSTR-3B |
Purchase invoices | Purchase Register | GSTR-2B |
Eligible ITC | ITC Reports | GSTR-2B and GSTR-3B |
ITC reversals | Accounting Entries | GSTR-3B |
Tax payments | Accounting Records | Electronic Cash/Credit Ledgers |
Practical example:
Suppose your TallyPrime purchase records show eligible-looking ITC of ₹2,50,000, but the corresponding GSTR-2B records show only ₹2,30,000.
There is a difference of ₹20,000.
Instead of including the entire amount in your refund calculation, investigate the difference. Check missing invoices, supplier reporting, duplicate entries, amendments and applicable ITC restrictions.
This reconciliation can help prevent incorrect refund calculations and unnecessary notices.
Documents and Reports Required for Different GST Refund Categories
The information extracted from TallyPrime depends on the reason for your refund claim.
Here is a practical reference table:
Refund Category | Important Supporting Information |
|---|---|
Export without payment of tax | Export invoices, LUT details and eligible ITC |
Export with payment of IGST | Export invoices, shipping bill and relevant tax payment details |
Inverted duty structure | Purchase details, sales details and eligible Net ITC |
Excess cash balance | Electronic Cash Ledger details |
Excess tax payment | Original tax payment and return records |
SEZ supplies | SEZ invoices, endorsements and relevant ITC or tax details |
Deemed exports | Deemed export invoices and applicable supporting documents |
The GST refund application is generally submitted in FORM GST RFD-01, subject to the applicable category-specific rules and exceptions. The GST portal also requires relevant declarations, statements and supporting documents.
You can refer to the CBIC GST Refund Rules for the applicable legal requirements.
How to Calculate and Verify Refund-Related ITC
If you are claiming a refund of accumulated ITC, you must calculate the eligible amount according to the relevant refund category.
For example, in an inverted duty structure claim, the calculation involves factors such as:
Turnover of inverted rated supply of goods or services.
Adjusted total turnover.
Net ITC.
Relevant tax rates and output tax liability.
The applicable formula is prescribed under Rule 89(5) of the CGST Rules, subject to amendments and conditions.
Example:
Suppose a business purchases raw materials at an 18% GST rate but sells finished products at a 5% GST rate.
The business may accumulate ITC because the input tax rate is higher than the output tax rate.
However, the difference between input and output tax is not automatically the refundable amount. The refund must be calculated using the prescribed formula and applicable restrictions.
Do not calculate or claim a refund simply by subtracting output GST from total purchase GST.
Common Mistakes to Avoid When Extracting Tally Data
Even a small accounting error can create problems during GST refund processing.
Avoid these common mistakes:
Incorrect GSTIN: Verify supplier and customer GSTINs before exporting invoice details.
Wrong tax classification: Make sure local, interstate, export and SEZ transactions are classified correctly.
Missing purchase invoices: Review all purchase vouchers before calculating ITC.
Duplicate entries: Check whether the same invoice has been entered more than once.
Incorrect refund period: Use the correct tax period and financial year.
Unreconciled ITC: Compare purchase records with GSTR-2B and filed GSTR-3B returns.
Incorrect export classification: Check whether export transactions are recorded with or without payment of IGST, as applicable.
Missing supporting documents: Keep invoices, shipping documents, LUT details and other category-specific evidence ready.
GST Refund Data Extraction Checklist
Before sending your data to your accountant or GST consultant, use this checklist.
Refund preparation progress
Frequently Asked Questions (FAQs)
Q1. Can I extract GST refund data directly from TallyPrime?
Yes. You can export sales, purchase, GSTR-1, GSTR-3B and other relevant accounting reports for refund preparation.
Q2. Which TallyPrime report is useful for GST refund claims?
GSTR-1, GSTR-3B, Purchase Register, Sales Register and ITC-related reports are particularly useful.
Q3. Can I export GST data from TallyPrime into Excel?
Yes. TallyPrime supports Excel, CSV and other export formats for supported reports.
Q4. Is GSTR-2B data available automatically in TallyPrime?
TallyPrime supports GST portal data connectivity and reconciliation features in supported releases. You may need to download or refresh the relevant portal data.
Q5. Can I file a GST refund application using TallyPrime?
TallyPrime helps prepare and export supporting accounting information. The refund application is generally submitted through the GST portal using the applicable refund process.
Conclusion
Extracting accurate GST data from TallyPrime makes the refund preparation process more organised and manageable. By exporting your sales, purchase, GSTR-1, GSTR-3B and ITC reports, you can prepare the accounting information needed for reconciliation and refund calculations.
However, exporting reports alone is not enough. Always compare your TallyPrime records with the GST portal, verify ITC eligibility and prepare supporting documents according to the refund category.
A properly organised set of accounting records can help reduce calculation errors, avoid unnecessary clarification requests and make the overall GST refund process smoother.
Important Disclaimer
This article is intended for educational and informational purposes only. GST refund eligibility, calculations, documentation and filing requirements depend on the applicable provisions of the CGST Act, CGST Rules and relevant notifications or circulars. GST provisions may change over time. Consult a qualified Chartered Accountant or GST professional before submitting a refund application.

COMMENTS