How to Extract Tally Data for GST Refund Claims – Complete Guide

Learn how to extract sales, purchase, GSTR-1, GSTR-3B and ITC data from TallyPrime for GST refund claims with Excel export and reconciliation tips.

How to Extract Tally Data for GST Refund Claims – Complete Guide

   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

  1. Open your company in TallyPrime.

  2. Press Alt + G (Go To).

  3. Search for GSTR-1.

  4. 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:

  1. Press Alt + E (Export).

  2. Select the relevant GST export option available in your release.

  3. Choose the required period and GST registration.

  4. Select the transactions or summaries you need.

  5. Choose Excel (Spreadsheet), CSV or JSON, depending on your purpose.

  6. Specify the destination folder.

  7. 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. 

TallyHelp+2

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

  1. Open your TallyPrime company.

  2. Press Alt + G.

  3. Search for Purchase Register.

  4. Open the report.

  5. 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:

  1. Open the required report.

  2. Press Alt + E (Export).

  3. Choose Excel (Spreadsheet).

  4. Select the required export configuration.

  5. Enter the destination folder.

  6. 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:

  1. Open TallyPrime.

  2. Press Alt + G (Go To).

  3. Search for GSTR-3B.

  4. Open the report.

  5. Press F2 (Period).

  6. Select the required tax period.

  7. Review the available sections.

  8. Check ITC details and tax liability.

  9. Press Alt + E (Export).

  10. 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. 

TallyHelp+1

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:

  1. Open the required report.

  2. Press Alt + E (Export).

  3. Select the Current or relevant export option.

  4. Choose Excel (Spreadsheet) as the file format.

  5. Configure the export settings.

  6. Enter a suitable file name.

  7. Select the destination folder.

  8. 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. 

CBIC GST+2

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

0/12 completed
Reset checklist

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

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content