GST REFUND ISSUE+


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.

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?

14 July 2021 Only take transactions on which ITC has been claimed.

26 September 2021 Yes..Just create a Pivot Table from the extracted data.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
20 September 2026
Semi Qualified CA

Navin & Associates

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 01 October 2026
Articled Assistant

KPSN & Associates LLP

Chennai

CA Inter

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
30 September 2026
Senior Accounts Executive

Codeboard Technology

Chennai

MBA

View Details
Company
ARTICLESHIP 30 September 2026
CA Article Assistant

CA Suraj Garg & Associates

New Delhi

CA Final

View Details