Analytical Procedures will help in comparing Groups, Ledgers or Cost Centres across the Years (Analysis Year & Previous Year) to find the exceptional trends, which will help the Auditor to carry out further investigations. The user can also do cross comparisons among Groups, Ledgers and Cost Centres to find out exceptions.
To access Analytical Procedures report,
Go to Gateway of Tally > Analysis & Verification > Data Analysis > Analytical Procedures
In the Analytical Procedures sub screen,
Select the required comparison criteria from the Comparison list
Select the required Group in the Base Group field
Select the required Group that needs to be compared with the Base Group in the Compare with Group field
In the Current Period From specify the required period from the Analysis Year
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.
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 Analysis Period 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 (e.g. 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 (e.g. Indirect Expenses) with the Base parameter (e.g. Sales Group) along with the percentage change and variance.
Particulars: Displays the parameter (e.g. Indirect Expenses) with which the Base parameter is compared.
X: Displays the Closing Balance for each item under Particulars for the Analysis 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 keys to identify Related Party and apply Sampling methods for analysis.
Click F6: Adv Compare 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 keys 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 Working Paper along with the details of User Name, Working Note Date & Time, Status, Note etc.
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, the cursor will move to Working Note field to enter the details.
Group: 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 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 analysis period. That is, the Working Note details will be displayed in the Working Paper of Current as well as Next Analysis Period.
To view the Working Paper during analysis, click on Ctrl+W: Wkg Paper or press Ctrl+W keys. The details displayed in Working Paper will be relevant to report from where it is triggered. For more details on Working Paper refer the topic Working Note.
Click F9: Inv Reports or press F9 key to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc.
Click F10: Acc Reports or press F10 key to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.
Click F10: Analysis Reports or press Alt+F10 keys to navigate to the other Analysis Reports.
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 user 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 user 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.