8Financial Statements
Option 9Print Statements
This function prints financial statements, based upon information in the Account Balances, Budgets, Units Balances, and Foreign Balances files. This job uses formats defined by the Statement Text, Statement Detail, and Statement Printing files. The following processing steps accomplish this job.
- Step 1You can use this function to select which Statement Print numbers to print. You can select ranges of Statement Print numbers both to include and to exclude. You also define the fiscal month and year to be used for accumulating balances for Statement Print Columns defined as ‘NET’ or ‘BAL’.
The screen shown below presents information about Statements To Print.
Select Statements to Print screen
Data items for the preceding screen are described below:
- Current Fiscal Month
Positive number, up to 2 digits
Enter the Fiscal Month desired for the financial statements. This month will be used in determining any column balances defined as “NET” (current month’s net activity) or “BAL” (current month’s cumulative balance).
- Current Fiscal Year
Positive number, up to 2 digits
Enter the Fiscal Year desired for the financial statements. This year will be used in determining any column balances defined as “NET” (current month’s net activity) or “BAL” (current month’s cumulative balance).
- Statement Print Number - From
Positive number, up to 4 digits Scan available
This is the first Statement Print Number for this range of statements. For example, to include (or exclude) statements defined in the range of Statement Print records 150 to 250, enter 150.
- Statement Print Number - To
Positive number, up to 4 digits Scan available
This is the last Statement Print Number for this range of statements. For example, to include (or exclude) statements defined in the range of Statement Print records 150 to 250, enter 250.
- Include?
Y or N Default Y
Enter one of the following values:
‘Y’ = Include this range of Statement Print #’s to be printed. For example, include 100 to 200 would include all statements defined in the range of Statement Print records 100 through 200.
- N
- Exclude this range of Statement Print #’s so they will not be printed. For example, exclude 150 to 150 would exclude the Statement Print record 150.
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:
Press ENTER to display system-supplied information and the press ENTER again to save the information on this screen.
- Step 2This disposition type is used for all standard General Ledger reports.
- Step 3In preparation for performing a sort/selection process on the Statements To Print Detail information, this step provides sequencing of data records by Statement Print #, with no option to change the sequence at run time. Selection of data records is provided by Print Now?, with no option to enter selection criteria at run time.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5This step processes the information for Statements To Print Detail. Under certain conditions, records in the Statement Attributes by column, Statement Percents and Statement Control files will be added. Updates to certain fields in the Statements, Statement Detail and Statement Amounts By Column files will occur. Generalized routines are performed to create the statement columns and amounts in General Ledger, separate the account number in General Ledger and Compute Statement Columns in General Ledger.
- Step 6This function retrieves the next statement to print.
- Step 7In preparation for performing a sort/selection process on the Statements Amounts By Column information, this step provides sequencing of data records by Statement Detail Line No, Type of Statement Output Line, Line Counter and Account, with no option to change the sequence at run time. Selection of data records is provided by Print No, with no option to enter selection criteria at run time.
- Step 8According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 9In order to print the Financial Statements, this step formats the Statement Amounts By Column information. The following data items are shown: Statement Heading and Text. As appropriate, group headings appear whenever a change occurs in Statement Detail Line No. If requested, totals appear whenever a change occurs in Statement Detail Line No.
A sample output is shown below.
Expert Distributing, Inc. Page 1
Balance Sheet
For Year Ended May 31, 1989
ASSETS
CURRENT ASSETS:
CASH $ 2,450,028.04
FOREIGN CURRENCY 2,567,322.20
ACCOUNTS RECEIVABLE
DOMESTIC $ 794,426.45
CANADIAN 387,094.49
1,181,520.94
RETENTION RECEIVABLE 20,512.64
MISC RECEIVABLES 4,533.23
PREPAYMENTS 28,939.74
INVENTORY 2,161,987.30
TOTAL CURRENT ASSETS $ 8,414,844.09
LONG-TERM ASSETS:
PLANT AND EQUIPMENT
LAND 1,164,767.12
BUILDINGS 723,762.82
EQUIPMENT 1,344,942.79
LESS: ACCUM DEPRECIATION 1,183,146.05
2,050,326.68
________________
TOTAL ASSETS $ 10,465,170.77
================- Step 10This step conditionally allows a job to branch forward to backward to any sequence number in the list of functions in the job.