Table 9 of GSTR 9C requires the auditor to bifurcate the entire turnover based on the rate of tax applicable. This article shares an straight forward way to get the same from Tally software.
The required data can be extracted from the Tally by utilising GST Return features of the software. Access GSTR 1 in Tally at the following menu – Gateway of Tally –> Display Menu –> Statutory Reports –> GST Reports –> GSTR 1.
The default view might be similar to that of actual GSTR 1, which shows B2B sales, B2C sales etc.. In order to get the required data, change the view type to Summary mode by pressing Alt+V. In summary mode, press Alt+F1 for detailed view and the work is done.
Under the Taxable heading, the sales will be displayed under various tax rates as shown in the below image. By further drilling down on the taxable sales, you can also see HSN/SAC breakup of the turnover.