Oracle Receivables Predefined Reports

Receivables provides predefined reports to help you analyze and manage your accounts receivable information.

The Receivables predefined reports cover the following areas:

• Bill Presentment Templates

• Accounting Reports

• Billing Reports

• Receivables Balances Reports

• Bills Receivable Reports

• Netting Settlement Reports

• Reconciliation Process and Report

You schedule and run all Receivables reports from the Scheduled Processes work area. You can also access and open all reports in the Reports and Analytics work area.

To run a report from Scheduled Processes:

1. Click the Schedule New Process button.

2. Search for the process name that you want.

3. Enter values for the parameters that you need.

4. Enter the desired process options and schedule.

5. Click Submit.

The following tables group the Receivables reports by type and provide a description of each report.

Bill Presentment Templates

The predefined print templates are used to print Receivables transactions. You can also create your own versions of these print templates.

Display Name	Description
Print Invoices Template	Layout for printing invoices. Includes information about the customer, due date, line amount, tax amount, and outstanding balance.
Print Credit Memos Template	Layout for printing credit memos. Includes information about the customer, application date, line amount, and total amount applied.
Print Debit Memos Template	Layout for printing debit memos. Includes information about the customer, due date, line amount, and outstanding balance.
Print Chargebacks Template	Layout for printing chargebacks. Includes information about the customer, due date, line amount, and outstanding balance.
Print Summary Balance Forward Bills Template	Layout for printing balance forward bills in summary mode. Includes information on the beginning balance, summary information of current customer billing activity, and ending balance for the billing cycle.
Print Detailed Balance Forward Bills Template	Layout for printing balance forward bills in detail mode. Includes information on the beginning balance, details of current customer billing activity, and ending balance for the billing cycle.
Print Bills Receivable Template	Layout for printing bills receivable. Includes information about the customer drawee, drawee contact, creation date, transactions assigned to the bill, and total bill amount.

Accounting Reports

Use these reports to review and analyze Receivables accounting information.

Display Name	Description
Bad Debt Provision Report	Provides information for reviewing bad debt exposure and provisioning based on percent collectible assigned to the customer. Includes transaction number, balance due amount, and bad debt provision amount in the ledger currency.
Invoices Posted to Suspense Report	Provides a list of all transactions that have revenue amounts posted to suspense accounts as a result of running the Import AutoInvoice process. Includes information on transaction class, customer, transaction date, and transaction amount by business unit.
Potential Reconciling Items Report	Provides a list of journal items that may potentially post to incorrect general ledger accounts. Includes customer account number, payment number, transaction number, and credit and debit amounts by reporting level, reporting context, accounting date, and balancing segment.

Billing Reports

Use these reports to review and analyze Receivables billing and related transaction information.

Display Name	Description
Billing History Report	Provides a summarized history of transactions and activities against them by customer site for a specified date range. Includes information on original transaction amount, current balance due, sum of all payments applied to the transaction, total credit memo amounts against the transaction, and total adjustment amounts to the transaction.
Import AutoInvoice Execution Report	Report for the process that imports transactions from other source systems into Receivables. Includes information about both successful and rejected transactions by transaction type, customer, transaction number, and transaction date.
Print Adjustments Report	Prints information about adjustments associated with specified transactions and customers by business unit, adjustment number, and transaction number.
Transaction Details Report	Lists invoices, credit memos, debit memos, and chargebacks for review. Includes information about transaction header, transaction lines, sales credits, revenue accounts, account sets, and transaction flexfields by business unit, transaction number, and transaction type.

Receivables Balances Reports

Use these reports to review and analyze payment information and customer balances.

Display Name	Description
Automatic Receipt Creation and Remittance Execution Report	Report for the process that creates automatic receipts and receipt remittances in a batch. Includes information about automatically generated receipts, remitted receipts, and data validation errors by batch.
Bank Risk Report	Provides information about receipts that are currently at risk with the remittance bank. Includes information about the remittance batch, receipt, and receipt amount by business unit, remittance bank branch, and remittance bank account.
Clear Receipts Automatically Execution Report	Report for the process that clears receipts automatically. Includes information about the clearing of customer receipts by remittance bank account, receipt number, and customer.
Create Automatic Receipt Write-offs Execution Report	Report for the process that writes off unapplied amounts on selected receipts. Includes information about the receipt write-offs by currency, customer, receipt number, amount, and date.
Create Customer Statements Execution Report	Report for the process that generates customer statements. Prints customer billing information in a format presentable to the customer. Includes information on invoices, debit memos, chargebacks, payments, on-account credits, credit memos, adjustments, and past due information.
Customer Account Status Report	Provides a list of customer open items and the total balance due based on customer account status for the specified ledger currency.
Customer Balances Revaluation Report	Displays information related to the difference between the original customer balance and the revaluated balance for manually adjusting the general ledger. Includes the customer balance and the open items that make up that balance by business unit, revaluation period, and customer.
Document Number Audit Report	Provides a list of document numbers assigned to transactions, adjustments, and receipts to help identify missing document numbers for a business unit, document sequence name, and document number range. Includes information about the status, customer, currency, and amount of the transactions, adjustments, and receipts.
Format Automatic Receipts Report	Prints automatic receipts in a specified receipt batch so that they can be sent to customers for confirmation. Includes receipt number, receipt date, currency, and the transactions applied to each receipt.
Generate Late Charges Report	Prints information on late charges for transactions that are overdue or have late payments by batch name. Includes transaction number, due date, and overdue amount of transactions.
Process Receipts Through Lockbox Execution Report	Report for the process that creates receipts for payments made through lockbox. Includes information on lockbox receipts and data validation errors for each transmission from the bank.
Receipts Days Late Analysis Report	Provides the cost of late customer payments by calculating weighted average days late for each customer. Includes information about the transaction number, transaction type, due date, receipt number, receipt days late, and receipt weighted days late by business unit, customer, transaction number, and collector.
Receipts Awaiting Bank Clearance Report	Provides a list of receipts waiting to be cleared by the remittance bank. Includes information about the remittance bank account name, remittance batch date, maturity date, receipt number and receipt amount by business unit, maturity date, and currency.
Receipts Awaiting Remittance Report	Provides a list of receipts waiting to be remitted to the bank. Includes information about the remittance bank account name, maturity date, receipt number, and receipt amount by business unit, remittance bank account, maturity date, and currency.
Receivables Aging by General Ledger Account Report	Provides information about outstanding receivables balances by general ledger account as of a specific date. Includes information about customer, transaction number, due date, and outstanding amount by balancing segment, transaction as-of date, aging buckets, currency, and customer. The related Receivables Aging by General Ledger Account and Multifund Accounting report generates aging details for ledgers and business units enabled for Multifund Accounting.
Receivables Open Items Revaluation Report	Displays the amount needed to manually adjust general ledger account balances to reflect the difference between the original and revalued customer open items. Includes information about transaction number, due date, currency, open original amount, conversion rate, open ledger currency amount, revaluation rate, and revaluation open amount by business unit, revaluation period, conversion rate type and balancing segment.
Receivables Projected Gains and Losses Report	Compares the revalued amount of foreign currency transactions with the entered amount and prints the projected unrealized gain or loss. Includes information about the currency, entered amount, ledger currency amount, revaluation rate, and the revaluation gain and loss by business unit, ledger currency, customer, and transaction number.
Recognize Revenue Execution Report	Report for the process that recognizes revenue and creates revenue distributions for transactions that use invoicing and revenue scheduling rules. Includes information about revenue accounting distributions and unprocessed or partially processed transactions for customer billing.
Reversal Status Report	Provides information about the status of automatic receipt reversals processed for a settlement batch. Includes the receipt date, receipt number, receipt amount, reversal reason code, and a description of automatic receipt reversals that were unsuccessful.

Bills Receivable Reports

Use these reports to review and analyze bills receivable activity.

Display Name	Description
Automatic Bills Receivable Remittance Execution Report	Report for the process that creates a bills receivable remittance from bills receivable. Provides the details of bills receivable remitted to the bank to initiate collection from customers.
Automatic Bills Receivable Transactions Batch Report	Report for the process that creates bills receivable from transactions. Lists the transactions assigned to each bill receivable.
Close Matured Bills Receivable Execution Report	Report for the process that creates and applies receipts for standard remitted bills receivable, and applies receipts and eliminates risk on bills receivable factored with recourse. Lists the changes to each bill receivable and shows all receipts that were cleared by the process run.
Print Bills Receivable Report	Prints bills receivable either individually, belonging to a bills receivable batch, or belonging to a bills receivable remittance batch.

Netting Settlement Reports

Use these reports to review and analyze Payables and Receivables netting settlements.

Display Name	Description
Netting Settlement Letter	Prints a letter that provides details of Payables and Receivables transactions in a netting settlement.
Netting Reversal Letter	Prints a letter that provides details of Payables and Receivables reversed transactions in a netting settlement.
Netting Settlement Report	Lists the Payables and Receivables transactions belonging to a specific netting settlement in PDF format.
Netting Settlement Listing	Lists the Payables and Receivables transactions belonging to a specific netting settlement in spreadsheet format.

Reconciliation Process and Report

Use this process and report to help you reconcile receivables data to the general ledger.

Display Name	Description
Prepare Receivables to General Ledger Reconciliation	Extracts and prepares transaction and accounting information for reconciling Receivables to the General Ledger. You must run this process before you can use the Receivables to General Ledger Reconciliation Report.
Receivables to General Ledger Reconciliation Report	Provides both summary and detailed reconciliation of receivables data to the general ledger. The summary report displays receivables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted. The detail reports display the real-time details that make up balances from the summary report, and indicate potential causes for differences between actual and reconciling amounts.