Key Indicators Current Activity Report
Use the Key Indicators Report to review your accounts payable department's productivity. The Key Indicators Report provides current activity indicators that compare current period activity with prior period activity in three major areas: suppliers, invoices, and payments. Payables further breaks down each category into basic items, exception items, and updates. The report provides the number of transactions for each indicator (such as number of automatic payments printed during a period) and amount values where applicable to the Key Indicator (such as total value of automatic payments written during a period).
Attention: This report does not sort by currency, nor does it convert foreign currency invoices to your functional currency.
Prerequisite
Run the report for the previous period to generate comparison data. You can look at the Report Run check box in the Special Calendar window to confirm that you have run the report. See: Special Calendar.
Report Submission
Payables automatically prints the Key Indicators Current Activity Report when you submit the Key Indicators Report. You submit the Key Indicators Report from the Submit Request window. See: Key Indicators Report.
Selected Report Headings
Prior. Payables prints the name of the prior period for which it is reporting Key Indicators, and the dates covered by the period.
Current Period Number. Payables prints the number of each indicator type which occurred during the reporting period. For example, current period number of sites is the number of new sites you entered during the current reporting period.
Prior Period Number. Number of transactions occurring in the prior period. For example, prior period number of sites is the total number of sites you entered during the last Key Indicators period before the current reporting period. Prior period data will appear only if you have submitted a Key Indicators Report for that prior period.
Percent Change Number. Percent change of the current period number compared with the prior period number. For example, if you entered 5 suppliers into Payables during the current period, and 10 suppliers into Payables during the prior period, the percent change would be -50.00.
If you did not submit this report for the prior period, Payables displays N/A (Not Applicable) in this column.
All Periods Number. Payables prints the number of transactions that you entered in Payables during all periods.
Current Period Amount. Amount of the transactions you entered Payables during the current period. For example, the current period amount for invoices is the total value of invoices you entered during the current reporting period. If an amount is not applicable, such as with suppliers, Payables leaves this column blank.
Prior Period Amount. Amount of the transactions you entered Payables during the period before the reporting period. For example, the prior period amount for invoices is the total value of invoices you entered during the last reporting period. If an amount is not applicable, Payables leaves this column blank.
Percent Change Amount. Percent change of the current period amount over the prior period amount. For example, if you entered $500,000 of invoices into Payables during the current period, and $1,000,000 of invoices into Payables during the prior period, the percent change is -50.00. Payables does not convert foreign currency invoices to your functional amount, so this value may not provide accurate information if you use multiple currencies.
All Periods Amount. Payables prints the total dollar amount of items in Payables. If an amount is not applicable, Payables leaves this column blank. If you enter invoices in foreign currencies, Payables displays this amount as the entered value. This report does not convert your foreign currency invoices to your functional currency amount.
Row Headings
Suppliers:
- Suppliers. Number of new suppliers you enter.
- Sites. Number of new sites you enter for your new suppliers.
- Additional sites. Number of new sites you enter for existing suppliers.
Supplier Exceptions:
- One time suppliers. Number of new suppliers you designate as one-time suppliers.
- 1099 suppliers. Number of new suppliers which are 1099-type suppliers. A 1099 supplier is one which you defined as Federal Reportable in the Suppliers window.
- Supplier sites on hold. Number of new supplier sites you have placed on hold. You can hold all payments or hold future invoices for a supplier site in the Suppliers window.
- Inactive suppliers. Number of new suppliers for which you enter an inactive date.
Supplier Updates.
- Suppliers updated. Number of existing suppliers for which you have added or changed supplier information.
- Sites updated. Number of existing supplier sites for which you have added or changed site information.
Invoices.
- Invoices. Number and amount of invoices.
- Matched to PO's. Number and amount of invoices matched to purchase orders.
- Distribution lines. Number of invoice distributions.
- Scheduled payments. Number of scheduled payments based on payment terms and manual adjustments in the Scheduled Payments window of the Invoice Workbench.
- Batches. Number of invoice batches.
Invoice Exceptions:
- Invoice variances. Number and amount of invoices where, at the end of the reporting period, the invoice amount does not match the invoice distribution amount.
- Invoice holds. Number and amount of invoices that are on invoice hold (not including matching holds) at the end of the reporting period.
- Invoice matching holds. Number and amount of invoices that are on matching hold at the end of the reporting period.
- Total invoice exceptions. Payables prints the sum of invoice exceptions and invoice exception amounts.
Checks:
- Manual checks. Number and amount of manual payments.
- Automatic checks. Number and amount of payment batch payments and Quick payments that Payables prints during the reporting period.
- Total checks. Payables prints the sum of number and amount of automatic and manual payments.
Payments:
- Invoices paid. Number of invoices paid.
- Discounts taken. Number of discounts taken on paid invoices.
Payment Exceptions:
- Payments voided. Number of payments voided.
- Payments stopped. Number of stop payments initiated.
- Spoiled payments. Number of payments you recorded as spoiled during a payment batch.
Bank reconciliation:
- Payments cleared. Number and amount of payments cleared.
- Payments outstanding. Number and amount of payments which have not been reconciled to your bank account.
See Also
Entering Suppliers
Payment Terms
Approval
Entering Basic Invoices
Creating Single Payments
Paying Invoices in Payment Batches
Reconciling Payments with Oracle Cash Management
Key Indicators State-of-the-System Report
Entering Purchase Order Matched Invoices
Common Report Parameters
Common Report Headings