2Monthly Processing
Option 8Print All Reports
Use this function to print the Sales Tax Report, Sales Report, Cash Receipts Report, Adjustments Report, Subsidiary GL Distributions Report, and Transaction Control Report. The following processing steps accomplish this job.
- Step 1This is the standard disposition used for all reports not printed on special forms.
- Step 2This function supplies a default value for the “time period” (month, quarter, or year) in the Sales Tax Report.
- Step 3In preparation for performing a sort/selection process on The Sales Tax Districts information, this step provides you with a default sequencing of data records by Tax Code and Tax District, with the option to change modifiable parameters at run time. Selection of data records is provided by Tax Code and Tax District, with the option to enter user-specified comparisons at run time.
- Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 5In order to print the Sales Tax report, this step formats the Sales Tax Districts information. The following data items are shown: Tax District, Description, Rate, GL Account, Total Sales, Taxable Sales and Total Sales Tax. As appropriate, group headings appear whenever a change occurs in Tax Code. If requested, totals appear whenever a change occurs in Tax Code. When totals are specified, the following items are accumulated: Total Sales by Tax Code, Taxable Sales by Tax Code, and Sales Tax by Tax Code.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:35 LGG Page: 1
Sales Tax
Month to Date
Dist District Name Tax Rate GL Account Sales Taxable Sales Sales Tax
=================================================================================================================================
Tax Code 001 No Sales Tax
1 No tax .000 2897.34 2880.50 .00
—————— —————— ——————
— Tax Code Totals —> 2897.34 2880.50 .00
============ ============ ============
Tax Code 002 State Tax
001 Washington State Tax-Urban .081 2020001001 10326.72 10202.60 653.47
002 Washington State Tax - Rural .079 2020001001 .00 .00 .00
003 Nevada State Tax .062 2020001001 5930.75 5930.75 415.65
—————— —————— ——————
— Tax Code Totals —> 16257.47 16133.35 1069.12
============ ============ ============
—————— —————— ——————
— Grand Totals —> 19154.81 19013.85 1069.12
============= ============= =============- Step 6In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account Number, Operator ID, and Transaction No, giving additional sort order choice by account component, with the option to change modifiable parameters at run time.
- Step 7According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 8In order to print the report requested, this step formats the Month To Date Postings information. The following data items are shown: Operator ID, Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Apply Type, Debit Amount, And Credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account Number, or account component. If requested, totals appear whenever a change occurs in Account Number, account component, or Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:36 LGG Page: 1
Sales Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 06 89
Account 1030001001WH Accts Receiv, Sales/Wholesale
0000 0000 00000010 Alexander's, Inc. 401 SVC 06/30/89 Svc Charge Write Off .00 20.26-
0000 0000 00000020 Master Sellers Company 333 SVC 06/30/89 Svc Charge Write Off .00 2.00-
0000 0000 00000040 Burlington Enterprises 404 SVC 06/10/89 Svc Charge Write Off .00 22.22-
0000 0000 00000040 Burlington Enterprises 604 SVC 06/10/89 Svc Charge Write Off .00 101.90-
—————— —————— ——————
— Current Month Totals —> .00 146.38- 146.38-
— Beginning GL Balance —> 141659.39
——————
— Account Total —> 141513.01
============ ============ ============
Account 3060000000 Miscellaneous Income
0000 0000 00000010 Alexander's, Inc. 401 SVC 06/30/89 Svc Charge Write Off 20.26 .00
0000 0000 00000020 Master Sellers Company 333 SVC 06/30/89 Svc Charge Write Off 2.00 .00
0000 0000 00000040 Burlington Enterprises 404 SVC 06/10/89 Svc Charge Write Off 22.22 .00
0000 0000 00000040 Burlington Enterprises 604 SVC 06/10/89 Svc Charge Write Off 101.90 .00
—————— —————— ——————
— Current Month Totals —> 146.38 .00 146.38
— Beginning GL Balance —> .00
——————
— Account Total —> 146.38
============ ============ ============
—————— —————— ——————
— Post Month/Year 06 89 Totals —> 146.38 146.38- .00
============ ============ ============- Step 9In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post Month. If requested, totals appear whenever a change occurs in Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:36 LGG Page: 1
Sales Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 06 89
1030001001WH Accts Receiv, Sales/Wholesale .00 146.38- 146.38-
3060000000 Miscellaneous Income 146.38 .00 146.38
—————— —————— ——————
— Post Month/Year 06 89 Totals —> 146.38 146.38- .00
============ ============ ============
Post Month/Year 07 89
1030001001WH Accts Receiv, Sales/Wholesale .00 22.58- 22.58-
3060000000 Miscellaneous Income 22.58 .00 22.58
—————— —————— ——————
— Post Month/Year 07 89 Totals —> 22.58 22.58- .00
============ ============ ============
Post Month/Year 08 89
1030001001WH Accts Receiv, Sales/Wholesale 18721.44 .00 18721.44
1050001000 Service Charges Receivable .00 140.96- 140.96-
2020001001 Sales Tax Payable, Sales .00 1069.12- 1069.12-
2051000000 Sales Deposits 2050.00 .00 2050.00
3010001001MA Sales, Manufacturing .00 10134.75- 10134.75-
3010001001WH Sales, Wholesale .00 8879.10- 8879.10-
4190000001WH Freight Out, Sales/Wholesale .00 547.51- 547.51-
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 20771.44 20771.44- .00
============ ============ ============- Step 10In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account Number, Operator ID, and Transaction No, giving additional sort order choice by account component, with the option to change modifiable parameters at run time. Selection of data records is provided by Post Year, Post Month, Account Number, and account component, with the option to enter user-specified comparisons at run time.
- Step 11According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 12In order to print the report requested, this step formats the Month To Date Postings information. The following data items are shown: Operator ID, Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Apply Type, Debit Amount, and Credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account Number, or account component. If requested, totals appear whenever a change occurs in Account Number, account component, or post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:36 LGG Page: 1
Cash Receipts Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
Account 1010001000 Cash, Corporate
MRC 0010 0001 00000080 Dominion Business Machin 9988765 PAY 08/09/94 Cash 14675.00 .00
—————— —————— ——————
— Current Month Totals —> 14675.00 .00 14675.00
— Beginning GL Balance —> 776673.21
——————
— Account Total —> 791348.21
============ ============ ============
Account 1010001001 Cash, Sales Outlets
SRR 0008 0001 00000010 Alexander's, Inc. 6130 PAY 08/11/89 payment 2170.28 .00
SRR 0008 0002 00000040 Burlington Enterprises 11603 PAY 08/11/89 payment 3111.95 .00
SRR 0008 0003 00000060 Hale’s Interiors 817 PAY 08/11/89 payment 2600.00 .00
SRR 0008 0004 00000020 Master Sellers Company 1278 PAY 08/11/89 payment 600.40 .00
SRR 0008 0005 00000050 Miscellaneous Customer 3121 PAY 08/11/89 payment 2789.56 .00
SRR 0008 0006 00000030 Pool and Associates 4421 PAY 08/11/89 payment 3000.00 .00
SRR 0008 0007 00000020 Master Sellers Company 1279 PAY 08/11/89 deposit 1500.00 .00
SRR 0008 0008 00000050 Miscellaneous Customer 3144 PAY 08/11/89 deposit 2000.00 .00
—————— —————— ——————
— Current Month Totals —> 17772.19 .00 17772.19
— Beginning GL Balance —> 2148193.22
——————
— Account Total —> 2165965.41
============ ============ ============
Account 1030001000MA Accts Receiv, Corp./Mfg.
MRC 0010 0001 00000080 Dominion Business Machin 9988765 PAY 08/09/94 payment .00 14675.00-
—————— —————— ——————
— Current Month Totals —> .00 14675.00- 14675.00-
— Beginning GL Balance —> 256200.79
——————
— Account Total —> 241525.79
============ ============ ============- Step 13In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post Month. If requested, totals appear whenever a change occurs in Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:37 LGG Page: 1
Cash Receipts Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
1010001000 Cash, Corporate 14675.00 .00 14675.00
1010001001 Cash, Sales Outlets 17772.19 .00 17772.19
1030001000MA Accts Receiv, Corp./Mfg. .00 14675.00- 14675.00-
1030001001WH Accts Receiv, Sales/Wholesale .00 14272.19- 14272.19-
2051000000 Sales Deposits .00 3500.00- 3500.00-
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 32447.19 32447.19- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 32447.19 32447.19- .00
============ ============ ============- Step 14In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Post Year, Post Month, Account Number, Operator ID, and Transaction No, giving additional sort order choice by account component, with the option to change modifiable parameters at run time. Selection of data records is provided by Post Year, Post Month, Account Number, and account component, with the option to enter user-specified comparisons at run time.
- Step 15According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 16In order to print the report requested, this step formats the Month To Date Postings information. The following data items are shown: Operator Id, Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Apply Type, Debit Amount, and credit Amount. As appropriate, group headings appear whenever a change occurs in Post Month, Account Number or account component. If requested, totals appear whenever a change occurs in Account Number, account component, or Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:37 LGG Page: 1
Adjustments Detail GL Distributions
ID Ctrl Trx Customer Inv/Ck Trx Date Description Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
Account 1030001001WH Accts Receiv, Sales/Wholesale
SRR 0000 0001 00000040 Burlington Enterprises 111 ADJ 08/12/89 order cancelled-apply 900.00 .00
SRR 0000 0002 00000040 Burlington Enterprises 1023 ADJ 08/12/89 order cancelled-apply .00 900.00-
SRR 0000 0003 00000060 Hale’s Interiors 1018 ADJ 08/12/89 wrong customer invoic .00 275.98-
SRR 0000 0004 00000010 Alexander's, Inc. 1018 ADJ 08/12/89 correction 275.98 .00
SRR 0000 0005 00000020 Master Sellers Company 333 ADJ 08/12/89 write off service cha .00 4.02-
—————— —————— ——————
— Current Month Totals —> 1175.98 1180.00- 4.02-
— Beginning GL Balance —> 131936.81
——————
— Account Total —> 131932.79
============ ============ ============
Account 3010001001WH Sales, Wholesale
SRR 0000 0001 00000040 Burlington Enterprises 111 ADJ 08/12/89 order cancelled-apply .00 900.00-
SRR 0000 0002 00000040 Burlington Enterprises 1023 ADJ 08/12/89 order cancelled-apply 900.00 .00
SRR 0000 0003 00000060 Hale’s Interiors 1018 ADJ 08/12/89 wrong customer invoic 275.98 .00
SRR 0000 0004 00000010 Alexander's, Inc. 1018 ADJ 08/12/89 correction .00 275.98-
—————— —————— ——————
— Current Month Totals —> 1175.98 1175.98- .00
— Beginning GL Balance —> 560855.13-
——————
— Account Total —> 560855.13-
============ ============ ============
Account 3060000000 Miscellaneous Income
SRR 0000 0005 00000020 Master Sellers Company 333 ADJ 08/12/89 write off service cha 4.02 .00
—————— —————— ——————
— Current Month Totals —> 4.02 .00 4.02
— Beginning GL Balance —> 168.96
——————
— Account Total —> 172.98
============ ============ ============
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 2355.98 2355.98- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 2355.98 2355.98- .00
============ ============ ============- Step 17In order to print the report requested, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Post month. If requested, totals appear whenever a change occurs in Post Month. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, And Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:37 LGG Page: 1
Adjustments Summary GL Distributions
Account Account Name Debits Credits Net Change
=================================================================================================================================
Post Month/Year 08 89
1030001001WH Accts Receiv, Sales/Wholesale 1175.98 1180.00- 4.02-
3010001001WH Sales, Wholesale 1175.98 1175.98- .00
3060000000 Miscellaneous Income 4.02 .00 4.02
—————— —————— ——————
— Post Month/Year 08 89 Totals —> 2355.98 2355.98- .00
============ ============ ============
—————— —————— ——————
— Grand Totals —> 2355.98 2355.98- .00
============ ============ ============- Step 18In preparation for performing a sort/selection process on the Month To Date Postings information, this step provides you with a default sequencing of data records by Subsidiary Type, Subsidiary Code, and Account Number, with the option to change modifiable parameters at run time.
- Step 19According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 20In order to print the Subsidiary Code Detail GL Distributions, this step formats the Month To Date Postings information. The following data items are shown: Transaction No, Customer, Name, Invoice/Check Number, Transaction Type, Transaction Date, Description, and Amount.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:38 LGG Page: 1
Subsidiary Code Detail GL Distributions
Trx Customer Invc/Chk Trx Date Description Amount
=================================================================================================================================
Subsidiary Type GL
Subsidiary Code JONES 2 Salesperson Sam Jones JONES
0001 00000010 Alexander's, Inc. 3001 INV 08/11/89 special order desk 900.00-
0001 00000010 Alexander's, Inc. 3001 INV 08/11/89 special order chairs 600.00-
—————
— Subsidiary Code Subtotals —> 1500.00-
===========
Subsidiary Code PETERS 2 Salesperson George Peters PETERS
0005 00000020 Master Sellers Company 3005 INV 08/11/89 special order table 2704.00-
—————
— Subsidiary Code Subtotals —> 2704.00-
===========
Subsidiary Code WILLIAMS 2 Salesperson Kris Williams WILLIAMS
0006 00000050 Deno’s Inc. 3006 INV 08/11/89 shelving unit 5401.60-
0006 00000050 Deno’s Inc. 3006 INV 08/11/89 shelving unit 529.15-
—————
— Subsidiary Code Subtotals —> 5930.75-
===========
—————
— Subsidiary Type Subtotals —> 10134.75-
===========
—————
— Grand Totals —> 10134.75-
===========- Step 21In order to print the Subsidiary Code Summary GL Distributions, this step formats the Month To Date Postings information. As appropriate, group headings appear whenever a change occurs in Subsidiary Type or Subsidiary Code. If requested, totals appear whenever a change occurs in Subsidiary Code or Subsidiary Type. When totals are specified, the following items are accumulated: Debit Amount Total, Credit Amount Total, and Net Change Amount Total. Grand totals print at the end, showing Debit Amount Total, Credit Amount Total, and Net Change Amount Total.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:38 LGG Page: 1
Subsidiary Code Summary GL Distributions
Subsidiary Code Debits Credits Net Change
=================================================================================================================================
Sub Type GL
JONES .00 1500.00- 1500.00-
PETERS .00 2704.00- 2704.00-
WILLIAMS .00 5930.75- 5930.75-
—————— —————— ——————
— Sub Type GL Totals —> .00 10134.75- 10134.75-
============ ============ ============
—————— —————— ——————
— Grand Totals —> .00 10134.75- 10134.75-
============ ============ ============- Step 22In preparation for performing a sort/selection process on the Transaction Control information, this step provides you with a default sequencing of data records by Application, File Posted, Operator ID, and Control No, with the option to change modifiable parameters at run time. Selection of data records is provided by Application, File Posted, Operator ID, Control No, and Journal Code, with the option to enter user-specified comparisons at run time.
- Step 23According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 24In order to print the Transaction Control report, this step formats the Transaction Control information. The following data items are shown: Application, File Posted, Operator ID, Control No, Amount Posted, Last Transaction Posted, Date/Time, Journal Code, Description, Operator Exclusive?, Control Total, Hash Total, Number of Transaction, Number of errors, and Number of Warnings.
A sample output is shown below.
Expert Computing, Inc.
11/08/94 15:38 LGG Page: 1
Accounts Receivable Transaction Control
Appl/File Control Group Amt Posted Last Tx
Date/Time Jrnl Description Op Exc? Ctrl Total Hash Total Trx Errors Warnings
=================================================================================================================================
TAR ADJUSTMENTS SRR / 0000 4.02- 5
03/16/90 14:25 ARAJ August - group 1 N .00 0 5 0 0
TAR CASH RECEIPTS MRC / 0010 14675.00 1
08/09/94 15:40 ARCR Cash Receipts N 14675.00 0 1 0 0
TAR CASH RECEIPTS SRR / 0001 10587.00 3
03/14/90 11:55 ARCR June - group 1 N 10587.00 70 3 0 0
TAR CASH RECEIPTS SRR / 0002 11446.03 3
03/14/90 11:55 ARCR June - second group N 11446.03 140 3 0 0
TAR CASH RECEIPTS SRR / 0003 4272.58 2
03/14/90 11:55 ARCR June - group 3 N 4272.58 70 2 0 0
TAR CASH RECEIPTS SRR / 0004 13827.61 4
03/14/90 11:55 ARCR June - EOM group N .00 0 4 0 0
TAR CASH RECEIPTS SRR / 0006 14705.85 7
03/16/90 09:15 ARCR through 7/15/89 N 14705.85 280 7 0 0
TAR CASH RECEIPTS SRR / 0007 27427.64 10
03/16/90 09:15 ARCR July receipts through EOM N 27427.64 340 10 0 0
TAR CASH RECEIPTS SRR / 0008 17772.19 8
03/16/90 14:23 ARCR Through 8/10/89 N 17772.19 280 8 0 0
TAR INVOICES KAJ / 0015 954.50 2
05/16/90 10:06 ARIV N .00 0 2 0 0
TAR INVOICES MRC / 0017 16460.55 4
08/09/94 15:28 ARIV FROM ORDER ENTRY N .00 0 4 0 0
TAR INVOICES MRC / 0018 152569.88 1
09/20/94 12:15 ARIV FROM ORDER ENTRY N .00 0 1 0 0
TAR INVOICES MRC / 0019 32640.80 1
09/20/94 14:34 ARIV FROM ORDER ENTRY N .00 0 1 0 0
TAR INVOICES SRR / 0001 19107.60 10
03/13/90 14:17 ARIV Orders through 6/10/89 N .00 350 10 0 0
TAR INVOICES SRR / 0002 27479.72 8
03/13/90 15:45 ARIV Orders 6/11-6/20/89 N .00 310 8 0 0
TAR INVOICES SRR / 0003 5567.38 4
03/13/90 15:45 ARIV June order 6/21/89-EOM N 5567.38 190 4 0 0
TAR INVOICES SRR / 0004 140.96 3
03/27/90 09:26 ARIV Service charges-opening entry N .00 0 3 0 0