Verification of Opening Balances report will help the user to check and fix the Opening Balance differences between different Groups/Subgroups/Ledgers when the Analysis Year and Previous Year company data are available as separate companies on Tally.ERP 9.
By default this report will show Opening Balance differences between different Groups/Subgroups/Ledgers of Non Revenue type. The user can include Revenue type of Groups/Subgroups/ Ledgers for verification by F12 : Configuration .
If the company data is of multiple years, then the report will by default be Verification of Balances. In the case of, split company data to view the Verification of opening Balances report, the previous year company data have to loaded.
To view the Verification of Opening Balances report
1. Go to Gateway of Tally > Analysis & Verification > Verification of Balances .
o If previous year company is not loaded, click on Ctrl+F3 : Compare Cmp or press Ctrl+F3 to load the company that contains the data for the year prior to the analysis period
o Click Ctrl+V : Verf of Op. Bal or press Ctrl+V .
The Verification of Opening Balances report appears:
o Select any of the groups displayed, and press Enter to view the Verification of Opening Balances report for that Group:
Note: Where the previous year company is loaded, Verification of Opening Balances report appears by default.
The user can further drill down to subgroups and ledgers by pressing Enter on the required Groups from the above screen. The information can also be viewed in detail by clicking F1 : Detailed or pressing Alt+ F1 from the above report.
To fix the differences in the Opening Balances, the user can press Ctrl+Enter on the respective ledger and change the Opening Balance details.
Click Ctrl+F3 : Compare Cmp or press Ctrl+F3 to load the company that contains the data for the year prior to analysis period.
Click F4 : Group or press F4 to view the Verification of Opening Balances report for a particular Group.
To view the Ledger wise report for Verification of Opening Balances click F5 : Led-wise or press F5 .
Click F9 : Verify or press F9 to mark any ledger as Verified or On hold.
Note: The facility to mark a Ledgers as Verified is provided only for those ledgers which are present in the Analysis Year.
Click Ctrl+F9 : Master Config or press Ctrl+F9 to identify the parties Related Party , Periodic Payments and Receipts and apply Sampling methods for analysis.
Click X : Exceptions or press Alt+X to view the exceptional items only.
Click V : Balance Variance or press Alt+V to view the Ledger Balance Variance report.
To view the groups which have balances of the opposite nature, that is, if a group that should normally have, say, a Debit balance has a Credit balance, click Ctrl+O: Opp Behaviour or press Ctrl+O .
The Verification of Balances (Opposite Behaviour) appears:
Click W : Working Note or press Alt+W to specify the working note details at Company or Group or Ledger level. The details provided in working note will be captured in 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 Working Note field to enter the details.
● Group : On selection of group based on the ledger selected, displays the list of Groups for defining the working note.
● Ledger : Selection of level - Ledger, application will default the ledger for which the working note is entered.
● 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 Working Paper of Current as well as Next Analysis Period.
To view the Working Paper during analysis, click Ctrl+W : Wkg Paper or press Ctrl+W . 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 .
Other button options in this report are similar to Verification of Balances report.
Click F12 : Configure or press F12 to change the default display.
● Appearance of Names : Select the appropriate appearance Name for the Groups.
● Sorting Method : Select the required sorting method for the transactions from the list of Sorting Methods.
● Expand all levels in Detailed Format : Set this option to Yes to expand all level - Groups, Sub-groups and Ledgers in detailed format.
● Show Exception First : Set this option to Yes to show all the exceptions in the top of the Group/Ledger Listing.
● Show Ledgers of Following Type: In this field select the appropriate ledger Type - Non Revenue or Revenue or All Items to configure the report respectively.
● Show Verification Note : Set this option to Yes to display the verification note entered by the user.
