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
19 August 2026
Chartered Accountant - Financial Consolidation & Reporting

Synergy Keystone

Mumbai

CA

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 24 August 2026
Chartered Accountant Articles

Rohit KC Jain & Co

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
CA Article Trainee

SR BAGAI & Co.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details
Company
21 August 2026
Accountant

A G International

Kolkata

B.Com

View Details
Company
28 August 2026
Assistant Manager

NRS AND ASSOCIATES

Kozhikode

CA Inter

View Details