2Monthly Processing
Option 4Print All Required Reports
This function will queue all required end of month reports together. The following processing steps accomplish this job.
- Step 1This disposition type is used for all standard General Subsidiary reports.
- Step 2In preparation for performing a sort/selection process on the Subsidiary Code Postings 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 and Subsidiary Code, with the option to enter user-specified comparisons at run time.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Transactions by Account Report, this step formats the Subsidiary Code Postings information. The following data items are shown: Journal Code, Operator ID, Control No, Source Trx No, Reference, Fiscal Month, Fiscal Year, Transaction Date, Description, and Amount. As appropriate, group headings and totals appear whenever a change occurs in Account or Subsidiary Code.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:26 LGG Page: 1
Transactions by Account Report
Jrnl Oper/Cntrl Trx Ref Mo/Yr Trx Date Description Amount
=================================================================================================================================
Account 4190000001MA Freight Out, Sales/Mfg.
Subsidiary Code JONES Salesperson Sam Jones
SRR / 0000 0000 EOM 02 90 07/13/89 Balance Forward 3,157
GL1 SRR / 0157 0004 JE 03 90 08/31/89 August Expenses 1,485
———
— Subsidiary Code Subtotals —> 4,642
======
Subsidiary Code PETERS Salesperson George Peters
SRR / 0000 0000 EOM 02 90 07/13/89 Balance Forward 2,277
GL1 SRR / 0157 0004 JE 03 90 08/31/89 August Expenses 1,239
———
— Subsidiary Code Subtotals —> 3,516
======
Subsidiary Code WILLIAMS Salesperson Kris Williams
SRR / 0000 0000 EOM 02 90 07/13/89 Balance Forward 2,984
GL1 SRR / 0157 0004 JE 03 90 08/31/89 August Expenses 1,371
———
— Subsidiary Code Subtotals —> 4,355
======
———
— Account Subtotals —> 12,513
======
———
— Grand Totals —> 12,513
======- Step 5In 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 6According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 7In order to print the Budget Comparison by Account Report, this step formats the Subsidiary Codes by Account information. The following data items are shown: Subsidiary Code, Description, Annual Budget, Year-to-Date Balance, Difference, Lifetime Budget, Life-to-Date Balance, and Difference. 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:26 LGG Page: 1
Budget Comparison by Account Report
Annual YTD Lifetime LTD
Sub Code Description Budget Balance Difference Budget Balance Difference
=================================================================================================================================
Account 1150001000MA Equipment
COMPUTER New Computer Syst. Development 58400.00 .00 58400.00 236000.00 121630.00 114370.00
GENERAL Non Project-Specific Costs 24000.00 .00 24000.00 .00 476670.00 476670.00-
_________ ________ ________ ________ ________ _________
— Account Totals —> 82400.00 .00 82400.00 236000.00 598300.00 362300.00-
============ =========== ============ ============ ============ ===========
Account 1170001000 Accumulated Depreciation
COMPUTER New Computer Syst. Development .00 1904.00- 1904.00 .00 30844.00-
30844.00
GENERAL Non Project-Specific Costs .00 55917.00- 55917.00 .00 711143.74-
711143.74
_________ ________ ________ ________ ________ _________
— Account Totals —> .00 57821.00- 57821.00 .00 741987.74- 741987.74
============ ============ ============ ============ ============ ============
Account 3010001001MA Sales, Manufacturing
JONES Salesperson Sam Jones 1831317.00- 411194.51- 1420122.49- .00 411194.51-
411194.51
PETERS Salesperson George Peters 1465085.00- 382984.83- 1082100.17- .00 382984.83-
382984.83
WILLIAMS Salesperson Kris Williams 1281890.00- 360119.34- 921770.66- .00 360119.34-
360119.34
_________ ________ ________ ________ ________ _________
— Account Totals —> 4578292.00- 1154298.68- 3423993.32- .00 1154298.68- 1154298.68
============ ============ ============ ============ ============ ============
Account 4010000001MA Cost of Goods Sold, Sales/Mfg.
JONES Salesperson Sam Jones 107127.00 15004.70 92122.30 .00 15004.70 15004.70-
PETERS Salesperson George Peters 85701.00 14640.76 71060.24 .00 14640.76 14640.76-
WILLIAMS Salesperson Kris Williams 74989.00 13071.01 61917.99 .00 13071.01 13071.01-
_________ ________ ________ ________ ________ _________
— Account Totals —> 267817.00 42716.47 225100.53 .00 42716.47 42716.47-
============ ============ ============ ============ ============ ==========- Step 8In 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 9According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 10In order to print the Summary by Account Report, this step formats the Subsidiary Codes by Account information. Totals appear whenever a change occurs in Account; the following items are accumulated: Beginning Balance, Debits, Credits, Month-to-Date Balance, Year-to-Date Balance, and Life-to- Date Balance. Grand totals print at the end.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 16:27 LGG Page: 1
Summary by Account Report
Account Description Begin Balance Debits Credits MTD Balance YTD Balance LTD
Balance
=================================================================================================================================
1150001000MA Equipment 598300.00 .00 .00 .00 .00 598300.00
1170001000 Accumulated Depreciation 684166.74- .00 57821.00- 57821.00- 57821.00- 741987.74-
3010001001MA Sales, Manufacturing .00 .00 1154298.68- 410961.42- 1154298.68- 1154298.68-
4010000001MA Cost of Goods Sold, Sales/Mfg. .00 42716.47 .00 15715.54 42716.47 42716.47
4020000001MA Sales Commissions, Mfg. .00 74333.73 .00 .00 74333.73 74333.73
4040001000 Depreciation Expense .00 57821.00 .00 57821.00 57821.00 86761.00
4080000000 Salaries Expense .00 84310.52 .00 84310.52 84310.52 162162.61
4090000000MA Repairs and Maintenance, Mfg. .00 60573.25 .00 60573.25 60573.25 94283.76
4100000001MA Promotion/Advertising, Mfg. .00 32250.00 .00 10800.00 32250.00 32250.00
4110000000 Travel and Entertainment .00 34737.16 .00 34737.16 34737.16 90378.41
4110000001MA Travel & Entertainment, Sales .00 43993.56 .00 19463.15 43993.56 43993.56
4160000000 Direct Labor .00 158132.95 .00 158132.95 158132.95 262699.26
4180000000 Indirect Labor .00 24731.95 .00 24731.95 24731.95 109946.64
4190000001MA Freight Out, Sales/Mfg. .00 12512.87 .00 4095.53 12512.87 12512.87
__________ _________ __________ _________ _________ __________
— Grand Totals —> 85866.74- 626113.46 1212119.68- 1598.63 586006.22- 285948.11-
============ ============ ============ ============ ============ ============