Krinirv Tech
Guide · GST

Tally sales and purchase registers with GSTIN, in Excel

To review GST returns or match them against other data, you need the registers in Excel with the party's GSTIN beside each entry. Here are two ways to get them out of TallyPrime.

In TallyPrime, one register at a time

  1. Open the company in TallyPrime and press Alt+F2 to set the period.
  2. Open the register you need: press Alt+G (Go To) and type Sales Register or Purchase Register.
  3. Open the list of vouchers for the period and add the columns you need.
  4. Press Ctrl+E to export the current report. Set the file format to Excel, then press E to export.
  5. Repeat for the credit note, debit note and other registers. Each one becomes its own file.

With TExtract, all the GST registers in one run

  1. Set up once with the setup video, then set the period in TallyPrime with Alt+F2.
  2. Tick the registers: Sales Register, Purchase Register, Credit Note and Debit Note registers, and the Expense Register (GSTIN).
  3. Add the GSTIN. Tick Party GSTIN columns to put the party's GSTIN in the registers.
  4. Add the GST reports if you need them: GST Transactions and the E-Invoice Report. Tick GST Reco Pack to get it as a separate workbook.
  5. Click Extract. Every register lands in one Excel workbook, one sheet each, with an Index sheet on top.

Why one workbook helps

  • Every register covers the same period, so totals tie up across sheets.
  • Filters and pivot tables work straight away, with no merging of files.
  • Add the Day Book and voucher registers, the Trial Balance and the ledgers in the same run.
  • TExtract only reads. Nothing changes in Tally, and your data stays on your computer.

TExtract is in beta. Check important figures against Tally and the GST portal before you file or sign.

More guides: Day Book and vouchers to Excel · Tally edit log (audit trail) to Excel. Questions? Write to support@krinirv.com.