Tuesday, 19 November 2019

GSTR2A Reconciliation Fastest Utility | Get Mismatch With in Seconds

Complete Solution GSTR2A Reconciliation
In this article me and my friend created a utility in ms access in which you can insert your portal and books GST2A. This utility will produce GSTR2A reconciliation within seconds. This Utility different to other because of no user actions required to generate data format mean user efforts are negligible. 



You can not also watch mismatch but also print and export to excel your all mismatch type report  and invoice mismatch type report. This is a very beautiful utility because of very user friendly and free of cost.

Requirements to use this utility:-
1. Ms Access must be install on your system
2. Portal GSTR2A and books GSTR2A
3. download this utility from below given link

Advantages:-
1. Free of Cost
2. Effortless reconciliation
3. Easy to print result on A4 Size sheet no need to settle.
4. Separate reports for only invoice mismatch etc.



This is first version of this utility. so may be some limitation. so track problems and send to me on my mail address :- contact.aasansolution@gmail.com for further corrections.

for more information about this utility watch given below video

Version 7 Release Dated 31-12-2019

1.Reconcile Monthly/ Annually etc.
2.Reconcile B2B as well as CDNR
3.Multi Rate Invoices will show only in single row
4.Match Invoices if invoice number string incorrect
5.All Reports into Excel Export facility

Download Now







Old version was
Version 5.1 Release Dated 17-12-2019

Version 4.0 Release Dated 12-12-2019

Version 3.0 Release Dated 04-12-2019

Version 2.0 Release Dated 21-11-2019

Version 1.0 Release Dated 19-11-2019

38 comments:

  1. WE ARE FACING PROBLEM REGARDING ERROR

    ReplyDelete
    Replies
    1. what problems send me screen shot and check tally file as per video or not

      Delete
  2. I HAVE DOWNLOADED BUT NOT WORKING WHILE PRESSING PRESS TO CONTINUE

    ReplyDelete
    Replies
    1. what problems send me screen shot and check tally file as per video or not

      Delete
  3. Great Utility.
    It is easy to use and Reconciliation of data.
    thanks bro.

    ReplyDelete
  4. डिअर आपने अपना नंबर नही दिया और आपके कहने के अनुसार मैंने आपसे एक रिक्वेस्ट किया था कि इसमें GSTN का नाम ऐड करने के लिये

    ReplyDelete
  5. Great Utility
    But Please add multiple month reconciliation option

    ReplyDelete
  6. utility file not open after download

    ReplyDelete
  7. Please Also Sort By GSTIN Cause When I Matched Data Then Some Bills Having Same Bill Number of Different Party Shown In Front Of Different Party in Reco.

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. This comment has been removed by a blog administrator.

    ReplyDelete
  10. Sir there are an error that what is parameter value.

    ReplyDelete
  11. I cannot loading the tally data. It shows enter parameter

    ReplyDelete
  12. shows as enter parameter value
    Books_GSTR2A.Invoice1

    ReplyDelete
  13. sir mismatch report showing in sometimes gstr2a legal name and in our books trade name or different. example (Padmawati Cotton Mills is company name but portal showing proprietor name asUGAM KANWAR KANTED its showing mismatch report please rectify this error.

    ReplyDelete
  14. Sir
    Is it possible that report shows party-wise
    and
    For Full Year ?
    Please reply.
    Thanks

    ReplyDelete
  15. UTALITY FILE NOT OPEN
    WHAT I DO???

    ReplyDelete
  16. ---------------------------
    Warning
    ---------------------------
    No archives found
    ---------------------------
    OK
    ---------------------------
    NOT WORKING PROPERLY. WHAT'S VERSION OF EXCEL. PLEASE SEND ME ON MY EMAIL.

    RAJENDRAMEHTAJI1964@GMAIL.COM.

    WAITING POSITIVE REPLY.

    ReplyDelete
  17. HI SIR YOUR TOOL IS WORKING VERY WELL. THANK YOU AND PLEASE UPDATE WITH INVOICE NO MISMATCH PROBLEM.
    SOME PEOPLE ARE UPLOADED INV.NO.GST/19-20/389 BUT WE ARE TAKING THE INVOICE NO.389 IN OUR BOOKS THEN RECONCILATION GETTING REPORT BOTH INVOICES ARE WRONG. PLEASE SOLVE THIS ISSUE

    AND ARRANGE THE MISMATCH REPORT PORTAL DATA WITH RCM AND WITHOUT RCM WHEN WE PRINT THE MISMATCH REPORT.


    OTHERWISE YOUR TOOL IS VERY GOOD. THANKS AGAIN FOR YOUR SUPPORT TO CONSULTANTS

    ReplyDelete
  18. This is my Suggestion:
    Matching Karne Ke Liye Invoice No. is important.
    Purchase date should not be used for matching. Some people enter purchase date as per their receipt of goods not as per invoice date. So I am getting problem at the time of matching.
    Invoice No and Invoice Amount should be used for matching data so result will be perfect.

    ReplyDelete
  19. Dear sir thanks for you tool , suggestion ,if there is any option for party wise reconciliation ,total itc available for selected month against book for perticular party ,it helps faster reconciliation ,

    ReplyDelete
  20. Respected sir ,
    i have downloaded version 7 , but when uploading portal data it is showing execution of this application has stop due to a run time error
    plz suggest how to solve this
    thanks.

    ReplyDelete
  21. SIR PROVIDE ME LINK TO DOWNLOAD JUST BEFORE 7 VERSION AS IT WAS BEST FOR ME TO RECONSLIED
    7 VERSION IS GIVING SO MANY MISMATCHED .

    ReplyDelete