Analysis check report

Introduction 

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.

Menu path 

Go to Accountancy ➔ Check ➔ Analysis, define the search criteria, and then click Start.

Fields

Totals section

This section displays the total debit and credit entries of all the general ledger accounts.

Status section

This section displays the percentage of the debit and credit entries of the general ledger accounts that have been checked and reviewed.

Financial year section

Year

The financial year defined at Financial year in Accountancy ➔ Check ➔ Analysis under the Range section is displayed. This cannot be edited.

Amount

Select the type of amount that you want to display in the report. You can select any of the following:

• Debit/Credit/Balance — Select this to view the debit, credit, and balance amounts of the financial year. By default, this is selected.
• Debit/Credit — Select this to view only the debit and credit amounts of the financial year. 
• Balance — Select this to view only the balance amount of the financial year.
• Debit — Select this to view only the debit amount of the financial year.
• Credit — Select this to view only the credit amount of the financial year.
• N/A — Select this if you do not want to view the amount of the financial year.

Reference year section

Year

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.

Amount

Select the type of amount that you want to display in the report. You can select any of the following:

• Debit/Credit/Balance — Select this to view the debit, credit, and balance amounts of the reference year. 
• Debit/Credit — Select this to view only the debit and credit amounts of the reference year.
• Balance — Select this to view only the balance amount of the reference year.
• Debit — Select this to view only the debit amount of the reference year.
• Credit — Select this to view only the credit amount of the reference year.
• N/A — Select this if you do not want to view the amount of the reference year.

Options section

Variance

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.

Cumulative

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.

Buttons

Refresh

Click this to display the report based on the new search criteria.

Details

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.

Close

Click this to exit.

Related documents

• Generating analysis check report
• Viewing analysis check report details