GST REFUND ISSUE+

Save Share

This query is : Resolved

Quick Summary

This discussion addresses a common issue when preparing GST refund claims, specifically for Annexure B. The challenge lies in converting purchase and expense data from Tally ERP 9 into an Excel format suitable for Annexure B, which requires all taxable values to be consolidated into a single column. The suggested solution involves using a Pivot Table to organise the extracted Tally data, focusing only on transactions where Input Tax Credit (ITC) has been claimed.

TARIQUE RIZVI

TARIQUE RIZVI (Querist)
Follow

13 July 2021 Respected Sir,

ANNEXURE B FOR GST REFUND
===========================
CONVERSION FROM ERP 9 TO EXCEL
==============================
When the ERP 9 data is converted into excel, all types of purchases and expenses reflect as exact as per Tally ERP 9 data but in ANNEXURE B all the Taxable Values are required in one column irrespective of nature of transaction. What to do now?