APPX Software Library

5Graphs and Spreadsheets

Option 2Account Balances by Month - Net

This function will build a print file of net monthly 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 - Net graph.

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

Graphs and Spreadsheets menu

The General Ledger Graphs and Spreadsheets Menu
Figure 44

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

A sample output is shown below.

Account 1010001000
Cash, Corporate
Fiscal Year 89

             Net:

Jun   -183337.12
Jul   -136520.50
Aug   -179606.39
Sep    424684.51
Oct    247488.97
Nov   -308566.19
Dec    136512.28
Jan    244097.99
Feb   -419282.48
Mar     98376.46
Apr    107528.01
May   -331104.44

EOY         0.00