Bills Payable Maturity Date Report

Use this report to review the amounts and maturity dates of bills payable that have not yet matured. This can help you estimate your cash needs by showing you the amounts of bills payable due to mature on a specific date. Note that this report uses only the payment's maturity date, and does not use information from Oracle Cash Management to identify whether the payment has actually cleared your bank.

Data is grouped by maturity date for bills payable within a bank account, with subtotals for all payments in that bank account that have the same maturity date. Totals are for all payments for all accounts with the same currency and maturity date.

If an exchange rate is not defined between the payment currency and the bank account currency, the subtotal for that maturity date does not include those amounts, and the report notifies you of this.

Report Submission

You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.

Selected Program Parameters

Bank Account Name. Disbursing Bank account. Leave this field blank if you do not want to restrict the report to a particular bank account.

Maturity Date. The report includes all future dated payments with a status of Issued and a maturity date up to and including the date you enter. This report does not include any future dated payments that have a status of Negotiable. Leave this field blank to review all future dated payments with a status of Issued.

Supplier. Enter a supplier if you want to limit this program to payments for a particular supplier. Leave blank if you want to submit the report regardless of the supplier.

Supplier Site: Enter to limit report by a particular supplier's site.

Selected Report Headings

Document Number. The payment number. For example, the check number.

Payment Date. Date the payment was created.

Maturity Date. Date recorded on the payment as the date funds are to be disbursed by the bank. This is the date that the payment becomes negotiable.

Curr. Currency of the bank account.

Payment Amount. The payment amount in the bank account currency. If the payment amount currency is different from the bank account currency and an exchange rate has not been defined for the payment rate date of the payment, Payables prints asterisks instead of an amount. In addition, the payment amount is not included in the subtotal for the maturity date.

Transaction Curr. The currency of the payment. This is the currency in which the payment is disbursed.

Transaction Amount. The payment amount in the transaction currency.