CA Loan Bajaj Finserv
CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

GSTR 2B/2A Matching Excel Utility V.1 (AI Version)

madhan 
on 02 March 2021

LinkedIn


GSTR-2B Is a Month-Wise Auto Drafted Statement For Regular Taxpayers Introduced in August 2020 And Can Be Generated From 12th September 2020 Onwards.

This GSTR-2B Generated Report is In A Manner That Allows Taxpayers To Reconcile ITC With Their Own Books Of Accounts And Records. Although Taxpayers Struggling To Reconcile The B2B Generated Data With Their Book Data.

Here We Introduce “GSTR 2B Matching Utility (AI Version)” For To Match Your ITC Data With GSTR 2B/2A Data. This Matching Utility Works By VBA Coding Method Instead Of Excel Formulas Which Is Make Perfect & Quick Reconciliation. Also, We Used Automatic Interaction Method Will Interact The Data Between Books Vs GSTR 2B For Matching With At Least Any Of The Combination Of The Invoices.

GSTR 2B/2A Matching Excel Utility V.1 (AI Version)

Data Required For Matching (Or) Reconciliation:

1. GSTR 2B/2A EXCEL DATA
2. AS PER YOUR BOOK DATA (Invoice Wise)

This GSTR 2B/2A Matching Utility Results As Follows:

1.GST Not Filed: This Result Exposes (Invoice Wise) These Invoices Is Not Available In GSTR 2B Data. Means, Your Supplier Is Not Filed Their GST Returns.
 
2.GST ITC Taken: This Results Exposes (Invoice Wise) These Invoices ITC Is Available For Utilization. Means, These Invoices ITC Is Not Taken By You. We Can Utilize These ITC Except RCM Supplies.

3. Matching ITC: This Results Exposes (Invoice Wise) These Invoices Is Matched With GSTR 2b Data. This Is The Eligible ITC To Claim.

4. Difference ITC: This Results Exposes (Invoice Wise) These Invoices Is Matched With GSTR 2B Data But ITC Is Matched. For Instance A Supplier Issued Invoice With GST Value Of Rs. 10000/-. But As Per GSTR 2B GST ITC Available Rs. 7000/- Only. So The Difference GST Value Is Rs. 3000/- (This Difference ITC Invoices Will Be Amended By Your Supplier).

5. Duplicate In Book: This Results Exposes (Invoice Wise) These Invoices ITC Taken By You More Than One Time. This May Happens If Any Clerical Mistakes. So These Invoices ITC Is Not Eligible.

 

6. Summary: This Sheet Is Exposes Above Mentioned Results Has Been Summarized For Decision Making.

Also, This Tool Have Report Generate Option For Above Mentioned Results For Decision Making Purpose.

 

Click here to download GSTR 2B/2A Matching Excel Utility V.1 (AI Version)


Tags :



Category GST
Other Articles by -
madhan 

Report Abuse

LinkedIn



Comments


update