GSTR 2B/2A MATCHING EXCEL UTILITY V.1 (AI VERSION) Live Demo
Here We Introduce “GSTR 2B Matching Utility (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.
Thank You.,
Would You like to get the tool (or) Any Queries Please send a mail to [email protected]
Смотрите видео GSTR 2B/2A MATCHING EXCEL UTILITY V.1 (AI VERSION) Live Demo онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Perfect Excel Solutions 27 Февраль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,973 раз и оно понравилось 44 людям.