Yes The One agrees SOFTCAAT is a marvelous audit software that can automate lot of processes like sampling, stratification, identification of duplicates, gaps, fraud detection, compliance testing, trend analysis, combining files and more!!
However all companies do not use Tally and therefore one needs to be profecient in using the DATA ANALYSIS add-in provided in MS-Excel itself which can do most if not all these tasks.
Sumit my friend I wish there were such a facility but alas its not freeware here's a link click this <a target='_blank' rel='nofollow' href="https://www.tallyshop.com/softcaat.htm">SoftCAAT</a>