General Ledger > Other GL Reports > Analysis Reports

The Account Balance Report shows the amount balance of each GL Account IDs at the end of every period specified or the amount total of all transactions affecting a certain GL Account ID within a specific period. It further shows you the period-to-date balances of the periods you specify in the report.

This report has the following uses:

•To aid in preparing periodic forecasts by analyzing the pattern of changes for each GL Account ID balance over a range of periods.

•To aid in verifying the reasonableness of the GL account balance that contributed a major amount to the total financial statement account category.

To print the Account Balance Report, follow these steps:

1.Access the Account Balance Report from the Reports Main group under the Reports tab.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Click the List box button next to the Sort By field and select one of the following sorting options:

•Account Code

•Specific segment type such as Account #, Division or Department

4.Click the List box button next to the Layout field and choose the Layout option you want to use:

oAccount Balance Report - PTD

Select this option if you want the report to display the net increase or decrease in GL Account ID balances during the selected periods.

oAccount Balance Report - YTD

Select this option if you want the report to display the cumulative balance of an account at the end of every selected period.

5.In the Report Configuration section, mark the Individual Account ID checkbox if you want to generate the report for a specific GL account; otherwise, define the desired range of segments to be included in the report.

Note: The available fields in this section will vary when you select different sorting options. This section will show the Account ID range if you chose the Account ID sorting option. If you chose to sort by any specific segment, the Report Configuration section will show all the GL segments set up for the company.

6.In the Period field, define the fiscal year and range of periods that you want to include n the report.

Note: You can choose different fiscal years in the From Period and To Period fields. You can also specify periods that span beyond 12 months especially for companies with fiscal year that covers more than 12 periods. The period values depend on the period names set up in the Fiscal Period Table function from the Utilities menu.

7.If applicable, mark the option below:

oInclude Zero Balance Accounts

Mark this checkbox if you want the report to display the GL Account IDs with zero balances.

8.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Account Balance Report function also provides you with flexibility to perform the following:

Account Balance Report

Account Balance Report

See Also