APPX Software Library

5Graphs and Spreadsheets

Option 1Account Balances by Month

This function will build a print file of monthly cumulative 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 year as parameters for the Account Balances by Month graph.

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

Account Balances by Month screen

The Account Balances by Month Screen
Figure 43

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.

Fiscal Year

Positive number, up to 2 digits

Supply the fiscal year of the account balance or budget amount to be graphed. The combination of account number and fiscal year must be in the Account Balances file, or the combination of Budget Type, account number, and fiscal year must be in the Budget Amounts file.

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

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 Month graph, this step formats the Account Balances information. The following data items are shown: Account, Description, Fiscal Year, SOY, Month Descriptor, Monthly Balances, and EOY.

A sample output is shown below.

Account 1010001001
Cash, Sales Outlets
Fiscal Year 89

             Cum:

SOY    459041.00
Jun    481381.97
Jul    541353.89
Aug    735242.96
Sep    563056.52
Oct    718387.09
Nov    843577.86
Dec    997220.07
Jan   1132870.07
Feb   1304174.65
Mar   1477709.05
Apr   1606307.02
May   1789730.94

EOY   1789730.94