GSTR2A Reconciliation Excel Tool Free.

13,802 Views

GSTR-2A is a system generated ‘draft’ Statement of purchase related tax return for a Receiver Taxpayer. When a seller files his GSTR-1, the information is captured in GSTR-2A. It takes information on goods and/or services which have been purchased in a given month from the seller’s GSTR-1.

GST reconciliation primarily involves matching the data uploaded by the suppliers with those of the recipient’s purchase data. This basically includes comparing the GSTR2A auto-populated from suppliers data and the purchase data recorded by the receiver of the supplies.

Free Excel Tool


Popular Topics


Latest Post

Interest liability for filing Form GSTR-3B

68 ViewsFiling Dates extended for providing relief to taxpayers in view of COVID-19 pandemic- Part 3 a. Taxpayers having aggregate turnover > Rs. 5 Cr. in preceding FY Tax period(a) Interest not payable,if filed by(b) Date from which interest is payable@ 9% till date of filing,if filed by 24th June, 2020(c) Date from which interest […]

Filing Dates extended for providing relief to taxpayers in view of COVID-19 pandemic- Part 1

95 ViewsDue to COVID-19 pandemic and challenges faced by taxpayers, Government has extended dates for GST filings. These are notified in Notifications 30/2020 to 36/2020 dated 03.04.2020. Circular No. 136/06/2020-GST dated 3rd April, 2020 has been issued. 1. Normal Taxpayers filing Form GSTR-3B a.Taxpayers having aggregate turnover > Rs. 5 Cr. in preceding FY Tax period Late fees waived […]

CCI approves acquisition of GMR Kamalanga Energy Limited by JSW Energy Limited

149 ViewsMinistry of Corporate Affairs The Competition Commission of India (CCI) approves the acquisition by JSW Energy Limited (“Acquirer”) of GMR Kamalanga Energy Limited (“Target”), under Section 31(1) of the Competition Act, 2002, in its meeting held today through video conferencing The proposed combination envisages the acquisition of the entire (i.e., 100%) shareholding of the […]

CCI approves Hitachi’s proposed acquisition of 80.1% in power grid business of ABB Limited

90 ViewsMinistry of Corporate Affairs The Competition Commission of India (CCI) approves proposed acquisition of 80.1% stake by Hitachi in the power grid business of ABB Limited, in its meeting held today through video conferencing The proposed combination envisages acquisition of 80.1% share capital of ABB Management Holding AG (ABB Management) by Hitachi Limited (Hitachi) […]

Advisory on Opting-in for Composition Scheme for 2020-21 – Extension of Dates in view of COVID-19 pandemic

102 Views A.Due to COVID-19 pandemic and challenges faced by taxpayers, Government has extended dates for opting for composition scheme by normal taxpayers, for the financial year 2020-21. These are notified in Notifications 30/2020 Central Tax, dated 03.04.2020. Circular No. 136/06/2020-GST dated 3rd April, 2020 has also been issued. B.Existing Normal taxpayers who want to opt for Composition Scheme […]

MSME Technology Centres Contributing in A Big Way in Fight Against COVID19

162 ViewsMinistry of Micro,Small & Medium Enterprises The country right now is fighting with novel corona virus at many levels. Eighteen operational Technology centres, autonomous bodies under Ministry of Micro, Small and Medium Enterprises (MSME), are also playing their role and contributing in the fight with COVID19. Central Footwear Training Institute (CFTI) Chennai procured and […]

Officers & staff of Ministry of Finance , Financial Institutions and Public Sector Banks/Enterprises Contributes Rs 430 crore towards PM CARES Fund to combat COVID-19 outbreak

334 ViewsMinistry of Finance The Officers & staff of Ministry of Financeincluding the officials of financial institutions and Public Sector Banks/Enterprises under the Ministry have come forward to donate a day’s salary including under Corporate Social Responsibility (CSR) with anamount ofRs 430.13 crore to PM-CARES Fund  for providing assistance to those impacted by the COVID-19 […]

CBDT issues orders u/s 119 of IT Act,1961 to mitigate hardships to taxpayers arising out of compliance of TDS/TCS provisions

128 ViewsMinistry of Finance Due to outbreak of the Covid-19 pandemic, there is severe disruption in the normal working of almost all sectors. To mitigate the hardships of taxpayers, the CBDT has issued the following directions/clarifications by exercise of its power u/s 119 of the Income-tax Act, 1961 (the Act): All the assessees who have […]

Report Income Tax e filing Account Misuse

107 Views If you think your e-Filing account may have been compromised or accessed in an unauthorized manner, then you may be a victim of cybercrime. Please report the incident to the concerned police or cyber-cell authorities as a first step. You may file an online criminal complaint/FIR by visiting https://cybercrime.gov.in/, an initiative of Government of India […]

Extend Due date for furnishing FORM GSTR-3B for supply made in the month of May, 2020.

152 ViewsSeeks to extend due date for furnishing FORM GSTR-3B for supply made in the month of May, 2020. [To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 36/2020 – Central Tax New Delhi, the […]

Extend due date of compliance which falls during the period from “20.03.2020 to 29.06.2020” till 30.06.2020 and to extend validity of e-way bills.

113 Views[To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 35/2020 – Central Tax New Delhi, the 3rd April, 2020 G.S.R…..(E).– In exercise of the powers conferred by section 168A of the Central Goods and […]

Clarification in respect of various measures announced by the Government for providing relief to the taxpayers in view of spread of Novel Corona Virus (COVID-19)

291 ViewsCircular No. 136/06/2020-GST CBEC-20/06/04-2020 -GSTGovernment of IndiaMinistry of FinanceDepartment of RevenueCentral Board of Indirect Taxes and CustomsGST Policy Wing New Delhi, dated the 3rd April, 2020 ToThe Principal Chief Commissioners / Chief Commissioners / Principal Commissioners /Commissioners of Central Tax (All)The Principal Director Generals / Director Generals (All) Madam/Sir, Subject: Clarification in respect of […]

AarogyaSetu App for Covid-19 Tracker

143 ViewsMinistry of Electronics & IT The Government of India today launched a mobile app developed in public-private partnership to bring the people of India together in a resolute fight against COVID-19.The App, called ‘AarogyaSetu’ joins Digital India for the health and well-being of every Indian. It will enable people to assess themselves the risk for their […]

All about of GSTR-8 | What is GSTR-8

867 Views1. What is Form GSTR-8? Form GSTR-8 is a Statement of TCS (Tax Collected at Source) to be filed by E Commerce Operators. Form GSTR-8 contains the details of taxable supplies and the amount of consideration collected by such operator pertaining to the supplies made by other suppliers through such e commerce operator and […]

Repayment of 7.80% GS2020

105 ViewsMinistry of Finance The repayment of following securitiesis due as per details given below:  Table: Details of GoI Security maturing on May 03, 2020 Sl. No. Name of Security Scheduled Date of Repayment Effective date of Repayment No Interest Accrual from scheduled date of Repayment (1) (2) (3) (4) (5) 1. Repayment of 7.80% […]

Extend due date of furnishing FORM GST CMP-08 and FORM GSTR-4

155 ViewsSeeks to extend due date of furnishing FORM GST CMP-08 for the quarter ending March, 2020 till 07.07.2020 and filing FORM GSTR-4 for FY 2020-21 till 15.07.2020. [To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and […]

Waiver of late fee for FORM GSTR-1 for tax periods of February, 2020 to April, 2020.

139 Views[To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 33/2020 – Central Tax New Delhi, the 3rd April, 2020 G.S.R…..(E).— In exercise of the powers conferred by section 128 of the Central Goods and […]

Waiver of late fee for delay filing of Return in FORM GSTR-3B for tax periods of February, 2020 to April, 2020

166 Views[To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 32/2020 – Central Tax New Delhi, the 3rd April, 2020 G.S.R…..(E).— In exercise of the powers conferred by section 128 of the Central Goods and […]

Provide relief by conditional lowering of GST Interest rate for tax periods of February, 2020 to April, 2020.

232 Views[To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 31/2020 – Central Tax New Delhi, the 3rd April, 2020 G.S.R…..(E).—In exercise of the powers conferred by sub-section (1) of section 50 of the Central […]

Allow opting Composition Scheme for FY 2020-21 till 30.06.2020

165 Views[To be published in the Gazette of India, Extraordinary, Part II, Section 3, Sub-section (i)] Government of IndiaMinistry of Finance(Department of Revenue)Central Board of Indirect Taxes and CustomsNotification No. 30/2020 – Central Tax New Delhi, the 3rd April, 2020 G.S.R…(E). – In exercise of the powers conferred by section 164 of the Central Goods […]

How To File GSTR-8

385 ViewsHow can I create and file details in Form GSTR-8? To create and file details in Form GSTR-8, perform following steps: A. Login and Navigate to Form GSTR-8 page B. Enter details in various tiles C. Preview Form GSTR-8 D: Payment of Tax E. File Form GSTR-8 with DSC/ EVC F. View Debit entries in […]

Authorisation of Union Bank of India as Primary Dealer | RBI | Bank Merger

123 Viewshe Reserve Bank has authorised Union Bank of India to undertake Primary Dealership business departmentally with effect from April 01, 2020, pursuant to the amalgamation of Corporation Bank into Union Bank of India in terms of the Amalgamation of Andhra Bank and Corporation Bank into Union Bank of India Scheme, 2020 notified by the […]

Loading…

Something went wrong. Please refresh the page and/or try again.


SUBSCRIBE | NEWSLETTER

Subscribe to our newsletter and stay latest updated on GST, Income Tax and new post.

Join 1,497 other subscribers

6 Responses

    1. Mukesh Gupta

      no need to do it in excel. below is the simple and best online tool for GSTR2A reconciliation. http://gst-recon.com. i use this one. you can easily find matched mismatched and can search by field and also group by column. you just need to upload 2 files. gstr2a downloaded as it is from gst.gov.in and purchase register exported from your accouting software..thats too free of cost

  1. Mukesh Gupta

    no need to do it in excel. below is the simple and best online tool for GSTR2A reconciliation. http://gst-recon.com. i use this one. you can easily find matched mismatched and can search by field and also group by column. you just need to upload 2 files. gstr2a downloaded as it is from gst.gov.in and purchase register exported from your accouting software..thats too free of cost

Comments