APPX Software Library

2Monthly Processing

Option 3Cash Receipts GL Distributions

Use this function to print information about cash receipts postings to General Ledger. The following processing steps accomplish this job.

  1. Step 1You can use this function to select the “summary only” option for the Cash Receipts GL Distributions report.

On the following pages, the screen displayed by this function is shown.

The screen shown below allows you to choose to print only the summary Cash Receipts report.

The Accounts Receivable Cash Receipts GL Distributions
Figure 30. The Accounts Receivable Cash Receipts GL Distributions

Data items for the preceding screen are described below:

Print Summary Report Only?

Y or N Default N

You can choose to print just the summary report by entering ‘Y’. If you enter ‘N’, both the detail and the summary report will be printed.

Press ENTER to save the information on this screen.

  1. Step 2In 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.
  2. Step 3This is the standard disposition used for all reports not printed on special forms.
  3. Step 4According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
  4. Step 5In 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:28                                                                                                       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
                                                                                         ============  ============  ============
  1. Step 6In 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:28                                                                                                       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
                                                                     ============            ============            ============