GSTR 2B Matching Excel Utility V.2 (Free)
GST Council Instructed All GST Taxpayers Can Take Input Tax Credit Based on GSTR 2B. GSTR 2B is a Auto Drafted Statement Generated (For Instance) for the month of Aug 2021, a Suppliers filed their GSTR1 on 12th Aug 2021 up to 11th Sep 2021. The statement for Aug 2021 will be generated on 12th Sept 2021.
GST Tax payers get struggling to Match Their Book ITC With Portal Generated GSTR 2B Data. We Introduced “GSTR 2B Matching Utility” is Enable to Match Your ITC With Quick & Perfect.
Now We Introduced Utility Can Match & Reconcile Your B2B Invoices, Debit Notes, Credit Notes, Imports & Amendments. (Our Utility Not Required Invoice No is Similar as per Supplier mentioned in Invoice. For Instance, Supplier Mentioned Invoice no. CBE-32-2020-21 , But You mentioned in your books Invoice No. 32)
From our Utility Matching & Reconciliation Results Based on Your Books ITC Vs As per GSTR 2B are as follows (Invoice Wise),
1. ITC Not Filed (Input Not Available in Portal)
2. ITC Not Taken (Input Available in GSTR 2B But Not taken in Books)
3. Matching ITC (ITC is Available in Both Books & GSTR 2B)
4. Difference ITC (If ITC is Available in Books & Portal With some Difference)
5. Duplication in Book (If ITC is Taken Twice for single Invoice – This Happens due to clerical mistake)
6. Summary Results (Summarised the Above mentioned Results)
7. One Screen Reconciliation Summary (All GSTN Numbers summarised with All ITC between Books vs Portal)
Newly Added Features:
1. GSTN Mismatch Identify (Our Tool Identifies if any clerical mistake made in GSTN Numbers. Like – If any spaces, Pan Numeral or Alpha Character Errors,Etc.,)
2. Now Your As Per Portal Data Your Suppliers Name Automatically Gathered from Book Data. I.e. Proprietor Name to Trade Name. This Will Help Identify Your Suppliers Easily.
3. Customize Report (ITC Not filed & ITC Not Taken): Now Summarised Results Can Generate ITC Not Filed & ITC Not Taken.
If Any Feedback (or) Suggestions Please Let us Know.
Author Bio
Kindly send us latest reconciliation tool on ronakp64@yahoo.in
Dear sir, Please share latest Recon tools at tukaram@hospetsteels.com or can you provide a demo on ITC reconciliation with 2A/2B
please send latest reconcillation tools on sonuk8797@gmail.com
Dear sir
please send me the katest reconciliation tool on kanti007@rocketmail.com
Hello requesting to kindly send me latest reconsiliation gstr2b vs books tool on vinay.skpk@gmail.com
Please kindly sent the latest reconciliation tool on akhilagr9@gmail.com
will you send me laterst GSTR2A-2B Matching Utility?
Please share the Matching tool of ITC to GSTR2B and books
Request you to kindly send me gstr 2 b utility in excel format
please send the latest Reconciliation tools – Cma@kananinternational.in
Hello
requesting to kindly send me latest reconciliation tool on
cas@govencas.com
Sir,
Please share GSTR2B MATCHING PURCHASE REGISTER TEMPLET IN EXCEL at this email id.
Thanks and regard…
Kindly share the latest version of recon excel sheet to this e mail id prasannakumar.h100@gmail.com
Hello
requesting to kindly send me latest reconsiliation tool on jaigraphics2003@gmail.com
Sir,
GSTR2A matching utilities are not working. Please send the working tools
1. Can I upload 1 full year 2A/2B for reconciliation?
2. What happens when bill number does not match exactly?
3. My Company issues Debit notes first to square the ledger for vendor payment. Credit note number is not entered in our books. Can this utility reconcile credit note amounts also? Option not available in the upload CN register from books
1. Yes Sir. We can Reconcile Monthly (or) Yearly Data in this Utility.
2. Our Utility Using Partial Match Option in Invoice No. Hence if any problems in Prefix & Suffix means, No Problem. It will be a match.
3. Yes sir. Our Utility can reconcile Credit/Debit Note also. Options available in this Latest Version.
We sent the latest version Utility to your mail ID. Please check.
Hello
requesting to kindly send me latest reconciliation tool on kaushalmishra29@gmail.com
Dear Sir,
Please send me the latest reconciliation tool to vipin_vj@ymail.com.
Requesting you to kindly send latest A reconciliation tools on sharadkborade85@gmail.com