Analytical Procedures will help in comparing Groups, Ledgers or Cost Centres across the Years (Audit Year & Previous Year) to find the exceptional trends, which will help the Auditor to carry out further investigations. The Auditor can also do cross comparisons among Groups, Ledgers and Cost Centres to find out exceptions.
To access Analytical Procedures report
1. Go to Gateway of Tally > Audit & Compliance > Audit & Analysis > Analytical Procedures.
2. In the Analytical Procedures sub screen:
o Select the required comparison criteria from the Comparison list.
o Select the required Group in the Base Group field.
o Select the required Group that needs to be compared with the Base Group in the Compare with Group field.
o In the Current Period From specify the required period from the Audit Year.
o In the Previous Period From specify the required period form the Previous Year.
Note: The Comparison is also possible between Cost Centre - Cost Centre, Cost Centre - Group, Cost Centre - Ledger, Group - Cost Centre, Group - Ledger, Ledger - Cost Centre, Ledger - Group, Ledger - Ledger.
3. Press Enter.
The Analytical Procedures screen displays the parameters that are compared across the years with the details of percentage changes and Variance. The details of various fields in the above report are given below:
● Comparison: Displays the parameters that are selected for comparison.
The second section displays the Base parameter (e.g. Sales Accounts Group) with the following details:
● Current Period: Name of the Company and selected Audit Period is displayed along with the Closing Balance for the selected parameter (e.g. Sales Accounts Group) is displayed. The percentage change from Previous Period to Current Period is also displayed.
● Previous Period: Name of the Company with which the comparison is done, the selected Previous Period along with the Closing Balance for the selected parameter (for example, Sales Accounts Group) is displayed. The Base parameter value for Previous Period is treated as 100% by default as displayed.
● The last line displays the Variance details which includes the Amount and percentage Increase or Decrease.
The third section displays the details of the compared parameter (for example, Indirect Expenses) with the Base parameter (for example, Sales Group) along with the Percentage change and Variance.
● Particulars: Displays the parameter (for example, Indirect Expenses) with which the Base parameter is compared.
● X: Displays the Closing Balance for each item under Particulars for the Audit Period.
● % of A: Displays the value of X as percentage of A.
● Y: Displays the Closing Balance for each item under Particulars for the Previous Period.
● % of B: Displays the value of Y as percentage of B.
● Variance Amount (X-Y): Displays difference amount as Variance of X and Y.
● Variance % (X-Y)/Y: Displays the percentage of the Variance difference.
Click F1: Detailed or press Alt+F1 to view the detailed report along with the Ledger level information.
Click F4: Compare or press F4 to change the parameters selected for comparison or to change the period from the Analytical Procedures sub screen as shown earlier.
Click Ctrl+F9: Master Config or press Ctrl+F9 to identify the parties as MSME, identify Related Parties and apply Sampling methods for Auditing.
Click F6: Compare List or press F6 to select and add additional parameters for comparison such as Purchase Accounts Group. The additional parameters will be displayed at the end after the initial parameters which were selected for Comparison.
Click W: Working Note or press Alt+W to specify the working note details at Company or Group or Ledger or Voucher level. The details provided in working note will be captured in Audit Working Paper along with the details of User Name, Working Note Date and Time, Status, Note and so on.
In Working Note Details screen:
● Details for: In this field select the level for which Working Note to be entered.
● Company: On selection of Company as the Level cursor will move to Audit Note field to enter the details.
● Group: On selection of group based on the ledger selected, displays the list of Parent Groups for defining the Working Note.
● Working Note: In this field enter the working note details.
● For CARO Reporting?:Choose the clause applicable to the Working Note from the list of CARO Clauses displayed. Working Notes tagged with CARO Clauses will appear in the CARO Working Paper.
● For Future Reference?: By default this option will be set to No. Set the option to Yes, to carry the Working Note forward to the next audit period. That is, the Working Note details will be displayed in Audit Working Paper of Current as well as Next Audit Period.
To view the Audit Working Paper during Auditing, click Ctrl+W: Audit Wkg Paper or press Ctrl+W keys. The details displayed in Audit Working Paper will be relevant to report from where it is triggered. For more details on Working Paper refer the topic Audit Working Paper.
Click F9: Inv Reports or press F9 to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary and so on.
Click F10: Acc Reports or press F10 to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance and so on.
Click F10: Audit Reports or press Alt+F10 to navigate to the other Audit Reports within Statutory Audit.
Click F12: Configure or press F12 to change/alter the default display for the Analytical Procedures report.
● Expand all levels in Detailed Format: Set this option to Yes to expand till last level.
● Show ledgers with Variance: User can choose to view only those Ledgers that fulfill.
● Variance Type: The user can choose to view the variance based on amounts, or percentages.
● Range:The user can choose to view Ledgers with variance equal to, greater than, or lesser than a specific value:
● The value has to be specified in the next field:
If there are multiple Items in the Particulars column, then the Auditor can press Enter on any of the items to establish the comparison between the Base parameter and the new parameter selected.
From the above report, the Auditor can drill down to the Ledger Monthly Summary and further drill down to view the Ledger Vouchers report for the selected period which is similar to Verification of Vouchers - Ledger Vouchers.