GSTR 2B Matching Excel Utility Live Demo (தமிழில்) V.2 (AI VERSION) Within Few Minutes
Here We Introduce “GSTR 2B Matching Utility V.2 (AI Version)” For To Match Your ITC Data With GSTR 2B 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.
Data Required For Matching (Or) Reconciliation:
1.GSTR 2B EXCEL DATA
2.AS PER YOUR BOOK DATA (Invoice Wise)
This GSTR 2B Matching Utility Results As Follows:
1.GST Not Filed: This Results 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.
New Feature of Our Utility:
1. GST Number Error Identify:
(After Click GST Check Button - 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 be Help Identify your suppliers Easily.
3. Now You Can Reconcile Your GSTR 2B's B2b, Debit Note, Credit Note, Amended & Import. Now Given Invoice type in As per Book Sheet. Based on this We can reconcile every data generated in GSTR 2B.
4. Partial Matches Highlight:
Now we provide the Partial Matches Highlight option. This Will Highlight Invoices which is matched between ITC Not Filed & ITC Not Taken (This Error Happened due to Wrong GSTN Provided at the time of Reconciliation)
5. One Screen Reconciliation Summary:
GSTN Wise Summary Option Provided. Based on As per Book & As per Portal GSTN Based All difference ITC Summarized.
6. Customize Report (ITC Not filed & ITC Not Taken):
Now Summarized Results Can Generate ITC Not Filed & ITC Not Taken.
Thank You.,
Would You like to get the tool (or) Any Queries Please send a mail to [email protected]
Смотрите видео GSTR 2B Matching Excel Utility Live Demo (தமிழில்) V.2 (AI VERSION) Within Few Minutes онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Perfect Excel Solutions 26 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,856 раз и оно понравилось 41 людям.