4Reports and Inquiry
Option 4Balances by Account Report
This function prints a summary of the Subsidiary Codes by Account file by subsidiary code within account number. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the subsidiary Codes by Account information, this step provides sequencing of data records by Account and Subsidiary Code, with no option to change the sequence at run time. Selection of data records is provided by Account Component, Subsidiary Code, Subsidiary Code Type, and Alpha Sort, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all standard General Subsidiary reports.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Balances by Account Report, this step formats the Subsidiary Codes by Account information. The following data items are shown: Subsidiary Code, Description, Added On, Subsidiary Code Type, Alpha Sort, Month-to-Date Balance, Year-to-Date Balance, and Life-to-Date Balance. As appropriate, group headings and totals appear whenever a change occurs in Account.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:17 LGG Page: 1
Balances by Account Report
Sub Code Description Date Added Type Sort MTD Balance YTD Balance LTD Balance
=================================================================================================================================
Account 1150001000MA Equipment
COMPUTER New Computer Syst. Development 07/10/89 1 COMPUTER .00 .00 121630.00
GENERAL Non Project-Specific Costs 07/10/89 2 GENERAL .00 .00 476670.00
—————— —————— ——————
— Account Subtotals —> .00 .00 598300.00
============= ============= =============
Account 1170001000 Accumulated Depreciation
COMPUTER New Computer Syst. Development 07/10/89 1 COMPUTER 1904.00- 1904.00- 30844.00-
GENERAL Non Project-Specific Costs 07/10/89 2 GENERAL 55917.00- 55917.00- 711143.74-
—————— —————— ——————
— Account Subtotals —> 57821.00- 57821.00- 741987.74-
============ ============= =============
Account 3010001001MA Sales, Manufacturing
JONES Salesperson Sam Jones 07/10/89 2 JONES 139742.17- 411194.51- 411194.51-
PETERS Salesperson George Peters 07/10/89 2 PETERS 130429.41- 382984.83- 382984.83-
WILLIAMS Salesperson Kris Williams 07/10/89 2 WILLIAMS 140789.84- 360119.34- 360119.34-
—————— —————— ——————
— Account Subtotals —> 410961.42- 1154298.68- 1154298.68-
============= ============= =============
Account 4010000001MA Cost of Goods Sold, Sales/Mfg.
JONES Salesperson Sam Jones 07/10/89 2 JONES 5625.78 15004.70 15004.70
PETERS Salesperson George Peters 07/10/89 2 PETERS 5311.16 14640.76 14640.76
WILLIAMS Salesperson Kris Williams 07/10/89 2 WILLIAMS 4778.60 13071.01 13071.01
—————— —————— ——————
— Account Subtotals —> 15715.54 42716.47 42716.47
============= ============= ============
Account 4020000001MA Sales Commissions, Mfg.
JONES Salesperson Sam Jones 07/10/89 2 JONES .00 27145.24 27145.24
PETERS Salesperson George Peters 07/10/89 2 PETERS .00 25255.54 25255.54
WILLIAMS Salesperson Kris Williams 07/10/89 2 WILLIAMS .00 21932.95 21932.95
—————— —————— ——————
— Account Subtotals —> .00 74333.73 74333.73
============= ============= =============