MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > Accounts Receivable > Reports > Expected Payments Report

Expected Payments Report

AR180A

 

DATE     3/08/93                                                                                                        PAGE     1

TIME    18:17:31                                    EXPECTED PAYMENTS REPORT                         REQUESTOR  ACCOUNT MANAGEMENT

REPORT  AR180A

REPORT SELECTION CRITERIA:  CO/LOC 001 BRU   CUSTOMER FROM             TO             CUTOFF DATE  3/31/93 DETAIL D

                                                                        INS PY                                              DISCT.

CO  LOC EXP.DATE CUSTOMER    CUSTOMER NAME                  TY  DOC NO  NO  TY  DUE DATE  DISC.DAT   EXPECTED AMOUNT   CUR  PERCT.

--- --- -------- ----------- ------------------------------ -- -------- --- --  --------  --------  -----------------  ---  ------

001 BRU 12/18/92 C06         COMPACT GMBH                   IN CHANTEST 001 CK  12/18/92   0/00/00          12,500.00  DEM     .00

001 BRU 12/18/92 CUSTOMER C06         TOTALS                                                                12,500.00  DEM

001 BRU 12/18/92        EXPECTED DATE TOTALS                                                                12,500.00  DEM

001 BRU 12/31/92 C06         COMPACT GMBH                   IN 00000002 000 CK  12/31/92  12/16/92          15,500.11  DEM     .00

001 BRU 12/31/92 CUSTOMER C06         TOTALS                                                                15,500.11  DEM

001 BRU 12/31/92        EXPECTED DATE TOTALS                                                                15,500.11  DEM

001 BRU  1/07/93 C06         COMPACT GMBH                   IN CHANTEST 002 CK   1/07/93   0/00/00          12,500.00  DEM     .00

001 BRU  1/07/93 CUSTOMER C06         TOTALS                                                                12,500.00  DEM

001 BRU  1/07/93        EXPECTED DATE TOTALS                                                                12,500.00  DEM

001 BRU  1/31/93 C06         COMPACT GMBH                   FC F1000001 000      1/31/93   0/00/00              50.65  DEM     .00

001 BRU  1/31/93 CUSTOMER C06         TOTALS                                                                    50.65  DEM

001 BRU  1/31/93        EXPECTED DATE TOTALS                                                                    50.65  DEM

001 BRU  2/21/93 C06         COMPACT GMBH                   IN CHANTEST 003 CK   2/21/93   0/00/00           5,000.00  DEM     .00

001 BRU  2/21/93 CUSTOMER C06         TOTALS                                                                 5,000.00  DEM

001 BRU  2/21/93        EXPECTED DATE TOTALS                                                                 5,000.00  DEM

001 BRU  2/28/93 C06         COMPACT GMBH                   IN 00000006 001 CK   2/28/93   0/00/00           2,291.67  DEM     .00

001 BRU  2/28/93 C06         COMPACT GMBH                   FC F1000002 000      2/28/93   0/00/00              56.86  DEM     .00

001 BRU  2/28/93 CUSTOMER C06         TOTALS                                                                 2,348.53  DEM

001 BRU  2/28/93        EXPECTED DATE TOTALS                                                                 2,348.53  DEM

001 BRU  3/02/93 C06         COMPACT GMBH                   IN 00000004 000 CK   3/02/93   2/04/93           1,452.13  DEM     .00

001 BRU  3/02/93 CUSTOMER C06         TOTALS                                                                 1,452.13  DEM

001 BRU  3/02/93        EXPECTED DATE TOTALS                                                                 1,452.13  DEM

001 BRU  3/23/93 CUSTOMER C01         TOTALS                                                                69,526.00- BEF

001 BRU  3/23/93 CUSTOMER C01         TOTALS                                                                   665.00- USD

001 BRU  3/23/93 C03         SPRINT SC                      IN PJG00033 000 CK   1/30/93  12/25/92          12,800.00  DEM     .00

                    CO/LOC 001 / BRU  TOTALS                                                                68,424.02  DEM

                    CO/LOC 001 / BRU  TOTALS                                                               944,729.00  BEF

                    CO/LOC 001 / BRU  TOTALS                                                                76,540.91  USD

                         COMPANY 001  TOTALS                                                                68,424.02  DEM

                         COMPANY 001  TOTALS                                                               944,729.00  BEF

                         COMPANY 001  TOTALS                                                                76,540.91  USD

                                GRAND TOTALS                                                                68,424.02  DEM

                                GRAND TOTALS                                                               944,729.00  BEF

                                GRAND TOTALS                                                                76,540.91  USD

                                                      **  END OF REPORT  **

Purpose

This report will show open items which are expected to be paid in a specified time range.  It is to be used for short time cash management similar to the Accounts Payable cash requirements report.  Average days to pay and average days late is calculated for each customer based on payment history.

Report Sequence

Company/Location, Expiration Date, Customer Number, Document Type, Document Number