Tuesday, 19 November 2019

GST Mismatch Report :- GSTR2A Reconciliation Fastest Utility | Get Mismatch With in Seconds

This article related to following query if you searching
gstr 3b and gstr 1 mismatch
gst mismatch
mismatch in the nature of transaction and place of supply
gstr 9 itc mismatch
gstr 2a mismatch


gstr 3b and gstr 2a mismatch
itc mismatch in gstr 9
mismatch in gst return
itc mismatch
mismatch in gstr 2a
mismatch in gst

Quickly GST Mismatch Report
Question:-  जब हम Press to continue बटन पर क्लिक करते हैं तो यूटिलिटी काम नहीं कर रही है
( when I click on press to continue button utility not working) 
Solution:-  please check given video I answered in this video



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-8-3 Release Dated 14-09-2020

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
6.computax Problems solved



Download Version 7-8-3
check below video to know features of version 7-8


























85 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. Sir i m download utilities but after open i click on press to continue button but no any responce... so guide me

      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
  22. sir i downloaded gstra 2a utility but its not proceeding after pressing the continue button.
    what to do.

    ReplyDelete
  23. massage show file corrupted, redownload from site

    ReplyDelete
  24. It says "File corrupted, redownload from site"

    ReplyDelete
  25. I HAVE DOWNLOADED BUT NOT WORKING WHILE PRESSING PRESS TO CONTINUE





    ReplyDelete
  26. mere pc main run button work nahi kar raha hai
    please sovlved

    ReplyDelete
    Replies
    1. Try this, https://youtu.be/61xPVGxk0aw, its free and simplest solution. it works even if there is invoice mismatch.
      http://gst-recon.com/

      Delete
  27. Sir, Aasan Solution ko Iss Utility K Liye Bohot Bohot Dhanyawaad, Par GSTR 2A Portal Se Download "Legal Name Of Business" K Naam Se Ho Raha Hai "Firm Name" Se Nahi. or Tally Me Sundry Creditors Firm K Naam Se Hai. Error Yeh Hai Ki Missmatch Report Me Firm Name or Legal Name Of Business Dono se Bata Raha Hai, Jab Ki Missmatch Gstr Number Se Batana Chahiye.. Plz Confirm... Thank You

    ReplyDelete
  28. Sir, Computax Ki Annual Generated File Bhi Utility Me Add Nahi Ho Rahi

    ReplyDelete
  29. SIR I AM A TALLY DEVELOPER AND PROVIDING GST RECONCILIATION SOURCE CODE WITH ITC CAPING
    IF YOU ARE INTRESTED THEN CALL ME MY MOBILE NO IS 8306335434

    ReplyDelete
  30. I HAVE DOWNLOADED LATEST VERSION 7.0 BUT WHEN I AM TRYING TO RUN THIS FILE AFTER RUNNING REGISTRY FILE THEN A ERROR APPEAR ON THE SCREEN " FILE IS CORRUPTED , RE DOWNLOAD IT FROM SITE "

    ReplyDelete
  31. NOT IMPORT 2A FILE............PLEASE GIVE YOUR MOBIE NO. YOU Can charge which utility i want

    ReplyDelete
  32. Good Morning Sir,

    First of all thank you very much for making a good utility for GSTR2A reconciliation it is very helpful & user-friendly

    I have been using your old utilities like V5 and V6 last couple of months its very useful for us for making GSTR2A reconciliation

    but now I am sorry to inform you that your latest utility V7-7 is not working properly so I request to you please help me out

    I shall be very grateful if you consider my problem, I am waiting for your valuable reply if possible

    ReplyDelete
  33. Dear Sir,

    Kindly add 1 more option for this Utility,
    Multiple file to upload for Tally file.

    ReplyDelete
  34. Sir i m download utilities but after open i click on press to continue button but no any responce... so guide me

    ReplyDelete
  35. Link is not worked properly after enabled the file too

    ReplyDelete
  36. Unable to down load utility pl help

    ReplyDelete
  37. डिअर
    इस Reconcilation में सबसे बड़ी एक परेशानी मै महसूस कर रहा हूँ वह यह है कि Utlity खुलने के बाद Minimize नही हो पा रही है जिस कारण टैली याअन्य जगह रखा डाटा से मिलन नही हो पा रहा है के सन्दर्भ में मेंरा आपसे निवेदन है कि सबसे पहले Cut Minimize और Maximize का option बताये आपकी बहुत मेहरवानी होगी | मेरा मोबाइल नंबर 7007027372 है और Whatsapp 9453094094 है Email bajpaicp@Rediffmail.com है |

    ReplyDelete
  38. डिअर
    मुझे लगता है कि आप इस उत्लिटी में अभी भी कम कर रहे है इश्को और अच्चा बनाने के लिए |
    कुछ सुझाब आपको दूंगा यदि सही और अच्छे लगे तो सुधार करे |
    मेरे पास से आपका नंबर फोन Reset होने के कारण चला गया है मतलब खो गया है क्या दोबारा आप अपना नंबर देंगे ?? यह नंबर आपने 2017 HSN Code TDL के बाद दिया था |
    धन्यबाद

    ReplyDelete
  39. डिअर प्लीज जबाब दे धन्यबाद

    ReplyDelete
  40. all mismatch report me only tally file data show and portal data 0 show karta hai
    please solve it

    ReplyDelete
  41. Hello Sir,

    I like the tool. But already some data in there and i can not upload new data.
    How do i reset the data already in there?
    Help me please...

    ReplyDelete
  42. sir
    tool is no working properly hanging too much and taking too much time

    ReplyDelete
  43. it is picking Voucher number from Tally sheet in place of Purchase invoice number. Causing mismatches.

    ReplyDelete
  44. Tool is picking voucher number instead of Purchase Invoice number from Tally Excel sheet.

    ReplyDelete
  45. Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
    my contact no.9447391605.

    ReplyDelete
  46. Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
    my contact no.9911448547

    ReplyDelete
  47. Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
    my contact no.9911448547

    mail-id :- ksm.manocha@gmail.com

    ReplyDelete
  48. Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
    my contact no.9911448547

    MAIL ID :- ksm.manocha@gmail.com

    ReplyDelete
  49. GSTR 2A data not Shown in ALL ENTRIES COMPARISION TAB for F.Y 2019-20

    Respected Sir
    I have downloaded your GSTR 2A reconcile Utility dated 8.9.20 but when I upload my GSTR 2A excel file from the portal download for 12 months along with my purchase register file i.e all ITC of 3b for the financial year 2019-20 both. But unfortunately, the GSTR 2A portal data not shown in "All entries
    comparison" tab.
    Please sort out the problem with a quick solution. I am waiting for your reply

    ReplyDelete
  50. GSTR 2A data not Shown in ALL ENTRIES COMPARISION TAB for F.Y 2019-20

    Respected Sir
    I have downloaded your GSTR 2A reconcile Utility 7.8 version dated 8.9.20 but when I upload my GSTR 2A excel file from the portal download for 12 months along with my purchase register file i.e all ITC of 3b for the financial year 2019-20 both. But unfortunately, the GSTR 2A portal data not shown in "All entries
    comparison" tab.
    Please sort out the problem with a quick solution. I am waiting for your reply

    ReplyDelete
  51. जब 1sep2020 के बाद से पोर्टल से 2A एक्सेल डाउन लोड करते है तो काउंटर पार्टी
    स्टेटस के बाद गोवेन्ट पोर्टल ने 5 कॉलम और जोड़ दिये है जिसके कारण आपकी 2A
    reconcilation यूटिलिटी सभी को मिस मैच दिखा रही है ।

    जो डेटा पोर्टल से हमने 22 Aug 2020 को डाउन लोड किये थे उन पर अभी भी 2A
    reconcilation यूटिलिटी ठीक से काम कर रही है ।
    केवल वाउचर नंबर कॉलम में सप्लायर इनवॉइस नंबर को कॉपी करना पड़ता है ।

    कृपया इसमें सुधार हेतु आवस्यक कार्यवाही करे

    अगर किसी क्लेरिफिकेशन की जरूरत हो तो मुझे आप 9301704200 पर विजय गोयल रायपुर
    कॉल कर सकते है ।मेल id vkgryp@gmail.com

    साथ ही निवेदन है कि जब भी आप सॉफ्ट वेयर अपडेट करते है तो वहां पर लास्ट
    अपडेटेड डेट जरूर करे ताकि हमे जानकारी मिलती रहे कि कुछ अपडेट हुवा है ।

    आपकी 2A reconcilation यूटिलिटी सबसे आसान है ।
    अगर लीगल name के साथ बुसिनेस name अपडेट करने की सुविधा भी दे तो काफी आसानी
    होगी बहुत सारे सॉफ्टवेयर यह सुविधा दे रहे है

    साथ हो मिस मैच में ₹5 तक का डिफरेंस हो तो उसे भी मैच मानने का ऑप्शन देकर
    मिसमैच लिस्ट को छोटा किया जा सकता है।

    ReplyDelete
  52. SPMPL/July/004 dt 01/07/2020 & other invoice is SPMPL/June/004 dt 01/06/2020
    than this shows in mismatch ( screen shot Attached)

    please do needfull to resolve the issue

    ReplyDelete
  53. even in this version 7.8.2 ,GSTA 2A potal data which i download in the month of september 2020 not come after uploading in this utility

    please solve this problem sir

    ReplyDelete
  54. we have downloaded 7-8-2 2A reconcilation utility but still not working all invoices show miss match . and pramiter F13 for CDRA ask

    please do need ful if you want any desk conectivity for data please feel free to call 9301704200 vijay Goyal

    ReplyDelete
    Replies
    1. i am working on it very soon i will provide next version

      Delete
  55. Raipur 15-09-2020 10:40PM
    version 7-8-3 still not working only .only export to excel missmatch vocher is woking upto some extent other reports are not working.
    (1) if supplier invoice no SPMPL/20-21/JUN/005 dt 05/06/2020 & next month SPMPL/20-21/JULY/005 dt 06/07/2020 and date matching is malfunctioning please do needful.
    (2)if date is in portl & not in books then mismatch issue is their
    (3) please update legal name with Trade name also this will help because only trade name is available in tally data.
    (4) GSTR 2 (3B Elecgible ITC)data imported from Tally Voch No. & date should be replace by Supplier Invoice number. and date for reconcilation pupouse
    (5) as return upload date is available in portal montly downloaded data please increase one coloum also in thos regard.
    please do needful

    ReplyDelete
  56. credit/Debit note reconcilation also not working

    ReplyDelete
  57. Up to which date problem s will be resolved.
    Vijay Goyal 9301704200
    Vkgryp@gmail.com
    If any clarification needed pl feel free to cal

    ReplyDelete