Analytical Procedures (International)

 

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

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.

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:

The second section displays the Base parameter (e.g. Sales Accounts Group) with the following details:

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.

Button options in Analytical procedures screen

F1: Detailed

Click F1: Detailed or press Alt+F1 to view the detailed report along with the ledger level information.

F4: Compare

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.

Ctrl+F9: Master Config

Click Ctrl+F9: Master Config or press Ctrl+F9 keys to identify Related Party and apply Sampling methods for analysis.

F6: Adv. Compare

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.

W: Working Note

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

Ctrl+W: Wkg Paper

F9: Inv Reports

Click F9: Inv Reports or press F9 key to navigate to the default Inventory Reports like Godown Summary, Movement Analysis, Stock Summary etc.

F10: Acc Reports

Click F10: Acc Reports or press F10 key to navigate to the default Accounting Reports like Balance Sheet, Cash Flow, Trial Balance etc.

F10: Analysis Reports

Click F10: Analysis Reports or press Alt+F10 keys to navigate to the other Analysis Reports.

F12: Configure

Click F12: Configure or press F12 to change/alter the default display for the Analytical Procedures report.

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.