APPX Software Library

5Graphs and Spreadsheets

Option 3Account Balances by Quarter

This function will build a print file of net quarterly account balances for an account/fiscal year that can be read by graphic utility software. The following processing steps accomplish this job.

  1. Step 1You can use this function to enter an account number and fiscal yeas as parameters for the Account balances by Quarter graph.

The screen shown below allows you to enter parameters needed for the Account Balances by Quarter graph.

Account Balances by Quarter screen

The Account Balances by Quarter Screen
Figure 45

Data items for the preceding screen are described below:

Account

Upper case, up to 12 characters Required Scan available

Identify the single account, summary account balance, or account number of the budget amount to be graphed. The account must be on file in the Chart of Accounts.

Start Fiscal Year

Positive number, up to 2 digits

Supply the first fiscal year of the range of fiscal years to graph to fiscal quarters. The range of years cannot exceed three fiscal years.

End Fiscal Year

Positive number, up to 2 digits

Supply the last fiscal year of the range of fiscal years to graph by fiscal quarters. The range of years cannot exceed three fiscal years.

The entered data is validated. During validation, including access to other files, conditions may be found which cause messages to be displayed. Errors (E), Warnings (W), and Messages (M) that may result are shown below:

  • EAccount / Fiscal Year Not on File
  • EEnd Year must be Greater or Equal the Start Year
  • ERange of Years Cannot Exceed 3 Years

Press ENTER to display system-supplied information and then press ENTER again to save the information on this screen.

  1. Step 2This disposition type is used for all graphics output.
  2. Step 3In order to print the Account Balances by Quarter graph, this step formats the Account Balances information. The following data items are shown: Account, Description, Fiscal Quarter Description, and Amount.

A sample output is shown below.

Account 1010001000
Cash, Corporate

                       Net:

1Q89            -499464.01
2Q89             363607.29
3Q89             -38672.21
4Q89            -125199.97
1Q90             131051.11
2Q90                  0.00