This document provides you the information on the data analysis report which is a tool for both auditors and companies that want to provide detailed analytical data based on the ledger whereby you can compare the financial facts of one year to the previous years.
Go to Accountancy ➔ Check ➔ Analysis, define the search criteria, and then click Start.
This section displays the total debit and credit entries of all the general ledger accounts.
This section displays the percentage of the debit and credit entries of the general ledger accounts that have been checked and reviewed.
The financial year defined at Financial year in Accountancy ➔ Check ➔ Analysis under the Range section is displayed. This cannot be edited.
Select the type of amount that you want to display in the report. You can select any of the following:
The reference year defined at Reference year in Accountancy ➔ Check ➔ Analysis under the Range section is displayed. If the reference year is not selected at Accountancy ➔ Check ➔ Analysis, the previous year will be displayed. For example, if the Financial year is “2005”, the Reference year will be “2004”. This cannot be edited.
Select the variance to view the abnormalities of the balances. For example, the expected sales growth for the year is 5%. A revenue growth of 10% is an abnormal deviation. To detect these abnormalities, you can filter these exceptions by selecting =, >=, <=, or <>, and typing the percentage. You can also leave this box blank if you do not want to view the variance.
Select this check box to view the cumulative balances (the debit and credit balances of each succeeding month are added together) of the general ledger accounts.
Click this to display the report based on the new search criteria.
Click this to view the general journal entries of the selected general ledger account for the selected month and year. For more information, see Viewing analysis Check report details.
Click this to exit.