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
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.
Password of zip file
Download Version 7-8-4
check below video to know features of version 7-8
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.
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
4.Match Invoices if invoice number string incorrect
5.All Reports into Excel Export facility
6.computax Problems solved
6.computax Problems solved
Password of zip file
Download Version 7-8-4
check below video to know features of version 7-8
Great job, thanks.
ReplyDeleteWE ARE FACING PROBLEM REGARDING ERROR
ReplyDeletewhat problems send me screen shot and check tally file as per video or not
Deletenot run in my pc
DeleteSir i m download utilities but after open i click on press to continue button but no any responce... so guide me
DeleteI HAVE DOWNLOADED BUT NOT WORKING WHILE PRESSING PRESS TO CONTINUE
ReplyDeletewhat problems send me screen shot and check tally file as per video or not
Deleteabsolutely right bro
Deletegive me the gstr2a download
ReplyDeleteGreat Utility.
ReplyDeleteIt is easy to use and Reconciliation of data.
thanks bro.
डिअर आपने अपना नंबर नही दिया और आपके कहने के अनुसार मैंने आपसे एक रिक्वेस्ट किया था कि इसमें GSTN का नाम ऐड करने के लिये
ReplyDeletewhat is parameter value??
ReplyDeleteEven I'm facing the same error
DeleteGreat Utility
ReplyDeleteBut Please add multiple month reconciliation option
utility file not open after download
ReplyDeletePlease 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.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteSir how we reconsile yearly?
ReplyDeleteSir there are an error that what is parameter value.
ReplyDeleteI cannot loading the tally data. It shows enter parameter
ReplyDeleteshows as enter parameter value
ReplyDeleteBooks_GSTR2A.Invoice1
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.
ReplyDeleteEven..I Am Facing The Same Error
DeleteSir
ReplyDeleteIs it possible that report shows party-wise
and
For Full Year ?
Please reply.
Thanks
check version 5.0
DeleteDownload Link Not Working
Deletenow link corrected
Deleteno link found
ReplyDeleteno link found time pass
ReplyDeleteParty wise ?
ReplyDeleteA
ReplyDeleteParameter Error
ReplyDeleteUTALITY FILE NOT OPEN
ReplyDeleteWHAT I DO???
---------------------------
ReplyDeleteWarning
---------------------------
No archives found
---------------------------
OK
---------------------------
NOT WORKING PROPERLY. WHAT'S VERSION OF EXCEL. PLEASE SEND ME ON MY EMAIL.
RAJENDRAMEHTAJI1964@GMAIL.COM.
WAITING POSITIVE REPLY.
problem solved
DeleteHI SIR YOUR TOOL IS WORKING VERY WELL. THANK YOU AND PLEASE UPDATE WITH INVOICE NO MISMATCH PROBLEM.
ReplyDeleteSOME 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
This is my Suggestion:
ReplyDeleteMatching 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.
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 ,
ReplyDeleteRespected sir ,
ReplyDeletei 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.
SIR PROVIDE ME LINK TO DOWNLOAD JUST BEFORE 7 VERSION AS IT WAS BEST FOR ME TO RECONSLIED
ReplyDelete7 VERSION IS GIVING SO MANY MISMATCHED .
hello
ReplyDeletesir i downloaded gstra 2a utility but its not proceeding after pressing the continue button.
ReplyDeletewhat to do.
massage show file corrupted, redownload from site
ReplyDeleteIt says "File corrupted, redownload from site"
ReplyDeleteIssue is not seen if date is set to 30th Jan
DeleteI HAVE DOWNLOADED BUT NOT WORKING WHILE PRESSING PRESS TO CONTINUE
ReplyDeletemere pc main run button work nahi kar raha hai
ReplyDeleteplease sovlved
Try this, https://youtu.be/61xPVGxk0aw, its free and simplest solution. it works even if there is invoice mismatch.
Deletehttp://gst-recon.com/
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
ReplyDeleteSir, Computax Ki Annual Generated File Bhi Utility Me Add Nahi Ho Rahi
ReplyDeleteSIR I AM A TALLY DEVELOPER AND PROVIDING GST RECONCILIATION SOURCE CODE WITH ITC CAPING
ReplyDeleteIF YOU ARE INTRESTED THEN CALL ME MY MOBILE NO IS 8306335434
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 "
ReplyDeleteNOT IMPORT 2A FILE............PLEASE GIVE YOUR MOBIE NO. YOU Can charge which utility i want
ReplyDeleteGood Morning Sir,
ReplyDeleteFirst 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
try version 7.8
DeleteDear Sir,
ReplyDeleteKindly add 1 more option for this Utility,
Multiple file to upload for Tally file.
Sir i m download utilities but after open i click on press to continue button but no any responce... so guide me
ReplyDeleteLink is not worked properly after enabled the file too
ReplyDeleteUnable to down load utility pl help
ReplyDeleteडिअर
ReplyDeleteइस Reconcilation में सबसे बड़ी एक परेशानी मै महसूस कर रहा हूँ वह यह है कि Utlity खुलने के बाद Minimize नही हो पा रही है जिस कारण टैली याअन्य जगह रखा डाटा से मिलन नही हो पा रहा है के सन्दर्भ में मेंरा आपसे निवेदन है कि सबसे पहले Cut Minimize और Maximize का option बताये आपकी बहुत मेहरवानी होगी | मेरा मोबाइल नंबर 7007027372 है और Whatsapp 9453094094 है Email bajpaicp@Rediffmail.com है |
डिअर
ReplyDeleteमुझे लगता है कि आप इस उत्लिटी में अभी भी कम कर रहे है इश्को और अच्चा बनाने के लिए |
कुछ सुझाब आपको दूंगा यदि सही और अच्छे लगे तो सुधार करे |
मेरे पास से आपका नंबर फोन Reset होने के कारण चला गया है मतलब खो गया है क्या दोबारा आप अपना नंबर देंगे ?? यह नंबर आपने 2017 HSN Code TDL के बाद दिया था |
धन्यबाद
डिअर प्लीज जबाब दे धन्यबाद
ReplyDeleteall mismatch report me only tally file data show and portal data 0 show karta hai
ReplyDeleteplease solve it
Hello Sir,
ReplyDeleteI 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...
sir
ReplyDeletetool is no working properly hanging too much and taking too much time
it is picking Voucher number from Tally sheet in place of Purchase invoice number. Causing mismatches.
ReplyDeleteTool is picking voucher number instead of Purchase Invoice number from Tally Excel sheet.
ReplyDeletemy whatsapp no. 9437019735
ReplyDeleteSir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
ReplyDeletemy contact no.9447391605.
Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
ReplyDeletemy contact no.9911448547
Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
ReplyDeletemy contact no.9911448547
mail-id :- ksm.manocha@gmail.com
Sir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
ReplyDeletemy contact no.9911448547
MAIL ID :- ksm.manocha@gmail.com
GSTR 2A data not Shown in ALL ENTRIES COMPARISION TAB for F.Y 2019-20
ReplyDeleteRespected 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
GSTR 2A data not Shown in ALL ENTRIES COMPARISION TAB for F.Y 2019-20
ReplyDeleteRespected 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
जब 1sep2020 के बाद से पोर्टल से 2A एक्सेल डाउन लोड करते है तो काउंटर पार्टी
ReplyDeleteस्टेटस के बाद गोवेन्ट पोर्टल ने 5 कॉलम और जोड़ दिये है जिसके कारण आपकी 2A
reconcilation यूटिलिटी सभी को मिस मैच दिखा रही है ।
जो डेटा पोर्टल से हमने 22 Aug 2020 को डाउन लोड किये थे उन पर अभी भी 2A
reconcilation यूटिलिटी ठीक से काम कर रही है ।
केवल वाउचर नंबर कॉलम में सप्लायर इनवॉइस नंबर को कॉपी करना पड़ता है ।
कृपया इसमें सुधार हेतु आवस्यक कार्यवाही करे
अगर किसी क्लेरिफिकेशन की जरूरत हो तो मुझे आप 9301704200 पर विजय गोयल रायपुर
कॉल कर सकते है ।मेल id vkgryp@gmail.com
साथ ही निवेदन है कि जब भी आप सॉफ्ट वेयर अपडेट करते है तो वहां पर लास्ट
अपडेटेड डेट जरूर करे ताकि हमे जानकारी मिलती रहे कि कुछ अपडेट हुवा है ।
आपकी 2A reconcilation यूटिलिटी सबसे आसान है ।
अगर लीगल name के साथ बुसिनेस name अपडेट करने की सुविधा भी दे तो काफी आसानी
होगी बहुत सारे सॉफ्टवेयर यह सुविधा दे रहे है
साथ हो मिस मैच में ₹5 तक का डिफरेंस हो तो उसे भी मैच मानने का ऑप्शन देकर
मिसमैच लिस्ट को छोटा किया जा सकता है।
SPMPL/July/004 dt 01/07/2020 & other invoice is SPMPL/June/004 dt 01/06/2020
ReplyDeletethan this shows in mismatch ( screen shot Attached)
please do needfull to resolve the issue
i am checking
Deleteeven 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
ReplyDeleteplease solve this problem sir
sir please solve the problem
ReplyDeletewe have downloaded 7-8-2 2A reconcilation utility but still not working all invoices show miss match . and pramiter F13 for CDRA ask
ReplyDeleteplease do need ful if you want any desk conectivity for data please feel free to call 9301704200 vijay Goyal
i am working on it very soon i will provide next version
DeleteRaipur 15-09-2020 10:40PM
ReplyDeleteversion 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
credit/Debit note reconcilation also not working
ReplyDeleteUp to which date problem s will be resolved.
ReplyDeleteVijay Goyal 9301704200
Vkgryp@gmail.com
If any clarification needed pl feel free to cal
waiting for correction in 2a reco reports
ReplyDeleteSir, My GSTR2A Excel utility using time expired.Is there any option to buy this utility.please help me...
ReplyDeletemy contact no 7567686907
Raipur 15-09-2020 10:40PM
ReplyDeleteversion 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
Also credit note /debit note issue istheir
Reply
just now downloaded and installed. it says expired download new version, kindly provide me solution
ReplyDeletewith reards
.
ReplyDeleteUtility Expired
ReplyDeletePLEASE UPDATE WHY UTILITY EXPIRED 25NOV2020 TO TILL DATE
ReplyDeleteIt's Not Working Properly and correctly
ReplyDeleteSir, the utility is unable to load GST 2A file for portal...it is showing only "file are loading wait....." please help
ReplyDeletemail your files
Deleteparameter error on CDNR
ReplyDeleteDear sir please provide DDL of Multi printing invoice of particular party wise for tally prime
ReplyDeletePLEASE PROVIDE ME GSTR 2A RECONCILATION UTILITY
ReplyDeleteutility not working utility expired
ReplyDeleteutility not working utility expired
ReplyDeleteGOOD SOFTWARE IN DESIGN... I TRIED AND ITS HELPS ME VERY MUCH. I WANT MORE FILTER IN MISMATCH REPORT. LIKE MISMATCH REPORT SHOULD BE PARTY / GSTIN WISE. SO THAT RECONCILATION MAY BE DONE EVEN IF INV NO HAVE LITTLE BIT TYPING ERROR. THANKS BROTHER. I HAVE NO WORD TO APPRICIATE YOUR EFFORT.
ReplyDeleteI have uploaded GSTR-2A file but it's taking too much time.
ReplyDeleteDoes it actually working or not ?
How to work 2a reconciliation
ReplyDeletesir while opening the software "file expired it's free re download from site after expiry or buy for without expiry" please give solution sir
ReplyDeletesir while opening the utility "file expired it's free re download from site after expiry or buy for without expiry" please give solution sir
ReplyDeletesir, 2A utility is not working. After click on press to continue, one dialouge box is open and the message given in that dialouge box is" File expired. its free downloaded fron site after expiry or buy for without wxpiry".
ReplyDelete