12Oracle Fusion Receivables Reports

This chapter contains the following:

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.

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.

Accounting Reports

Overview of the Bad Debt Provision Report

This topic contains summary information about the Bad Debt Provision Report.

Overview

The Bad Debt Provision Report provides information about your bad debt exposure.

This image shows output from the Bad Debt Provision
Report.

Key Insights

The report uses the percent collectible value that you specify in the Collectible field of the Credit and Collections section of the customer account profile to calculate the bad debt provision.

Frequently Asked Questions

The following table lists frequently asked questions about the Bad Debt Provision Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Accounting

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

When you need customer overdue transaction collectibility information to create the provision for bad debt accounting journals.

What can I do with this report?

Schedule periodically.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Invoices Posted to Suspense Report

This topic contains summary information about the Invoices Posted to Suspense Report.

Overview

The Invoices Posted to Suspense Report provides a listing of all transactions that have revenue amounts posted to suspense accounts.

This image shows output from the Invoices Posted
to Suspense Report.

Key Insights

The report groups and prints revenue amounts by the company or balancing segment of the accounting flexfield, postable status, and currency.

Frequently Asked Questions

The following table lists frequently asked questions about the Invoices Posted to Suspense Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Accounting

Who uses this report?

Financial Manager after a run of the Import AutoInvoice process, whenever you use a suspense general ledger account.

When do I use this report?

To review a list of transactions, where revenue amounts are posted to suspense accounts when the imported transaction line amounts do not agree with the Price * Quantity calculated amount.

What can I do with this report?

Schedule to run following a run of the Import AutoInvoice process.

What type of report is this?

Oracle Business Intelligence Publisher

Potential Reconciling Items Report

During the internal reconciliation process, you use the Receivables to General Ledger Reconciliation Report to confirm that transactional data and accounting data match. However, even if the data matches, the journals could still post to incorrect general ledger accounts, due to issues with your Receivables setup.

Use the Potential Reconciling Items Report to help you identify and correct these setup issues.

You typically run the Potential Reconciling Items Report:

  • For new software installations, prior to running final accounting, in order to confirm the correct derivation of accounting.

  • Whenever the accounting setup has been modified--such as the creation of new transaction types, receipt methods or receivables activities--prior to running final accounting.

The report suggests journal items that potentially posted to general ledger accounts with unexpected account types, thus creating reconciliation issues in general ledger. An unexpected account type refers to general ledger account types that are not normally associated with an item general ledger category. General ledger account types used by Receivables include assets, liabilities, income, and expense.

For example, a receivable item might be expected to post to an asset account. If the item posts to a non-asset account, then it will appear on the Potential Reconciling Items Report.

Typical items that the Potential Reconciling Items Report includes are:

  • Adjustment journals with offset accounts that are asset accounts, rather than income or expense.

  • Revenue journals for invoices and credit memos that post to account types other than income.

  • Unearned revenue journals that post to an account type other than liability.

  • Unbilled journals created for deferred billing that post to an account type other than asset.

  • Late charge journals that post to an account type other than income.

  • Cash, confirmation, or remittance journals that post to account types other than asset.

  • Short term debt journals created by factoring receipts that post to account types other than liability.

  • Nonrecoverable tax that posts to an account type other than expense.

Possible causes for discrepancy include:

  • Incorrect accounting setup.

  • Incorrect manual updating of general ledger account distributions.

  • Setup created for activities that is inconsistent with the intended use of Receivables.

When a potential reconciling item is an error, correct both the individual transaction and the incorrect setup to prevent future occurrences of the same error.

Billing Reports

AutoInvoice Execution Report

Use the AutoInvoice Execution Report to review a run of the Import AutoInvoice process.

The AutoInvoice Execution Report lists the total number of transactions imported for each AutoInvoice run, with detailed information for all transaction lines that failed import. The report includes summary information for the invoices, debit memos, and credit memos that were processed in each currency. The report also shows the total amount for each transaction class for all transactions processed.

You can also review and correct AutoInvoice errors by downloading the AutoInvoice Lines spreadsheet from the Billing work area.

Overview of the Transaction Details Report

This topic contains summary information about the Transaction Details Report.

Overview

The Transaction Details Report lists all of the information that was entered for each of your transactions.

This image shows output from the Transaction Details
Report.

Key Insights

The report provides, for each transaction, complete header and line information, tax information, freight information, sales credits, revenue accounting, account sets, and transaction flexfield.

Frequently Asked Questions

The following table lists frequently asked questions about the Transaction Details Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Billing

Who uses this report?

Financial Specialist during transaction reviews.

When do I use this report?

When you need to see all the details related to specific transactions.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the AutoAdjustment Preview Report

This topic contains summary information about the AutoAdjustment Preview Report.

Overview

The AutoAdjustment Preview Report provides information about potential automatic transaction adjustments, generated after a run of the Create Automatic Billing Adjustments program.

This image shows output from the AutoAdjustment
Preview Report.

Key Insights

The report includes information about the customer, transaction, adjustment amount, and adjustment status, and displays the total amount and count for both approved and pending adjustments.

Frequently Asked Questions

The following table lists frequently asked questions about the AutoAdjustment Preview Report.

How do I find this report?

Scheduled Processes - Create Automatic Billing Adjustments

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

To preview potential transaction adjustments when writing off transaction balances using the Create Automatic Billing Adjustments program.

What can I do with this report?

Set the AutoAdjustments Option parameter of the Create Automatic Billing Adjustments program to Generate Report Only.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Adjustment Register

This topic contains summary information about the Adjustment Register.

Overview

The Adjustment Register provides information about approved adjustments that affect transaction balances.

This image shows output from the Adjustment Register.

Key Insights

Review both manual and automatic adjustments by customer, adjustment status, adjustment type, or adjustment reason.

Frequently Asked Questions

The following table lists frequently asked questions about the Adjustment Register.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Period Close

Who uses this report?

  • Financial Specialist to review activity for the period.

  • Financial Manager during period close processing.

When do I use this report?

When you need a listing of adjustments against customer transactions or to assist the receivables reconciliation process.

What can I do with this report?

Schedule to run as needed.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Receivables - Adjustments Real Time subject area.

Overview of the Transaction Register

This topic contains summary information about the Transaction Register.

Overview

The Transaction Register lets you review customer transactions by business unit and accounting period.

This image shows output from the Transaction Register.

Key Insights

The report includes all transactions that increase or decrease the customer outstanding balance for the specified period.

Frequently Asked Questions

The following table lists frequently asked questions about the Transaction Register.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Period Close

Who uses this report?

  • Financial Specialist reviewing activity for the period.

  • Financial Manager during period close processing.

When do I use this report?

  • When you need a listing of customer transactions.

  • During the receivables reconciliation process.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Receivables - Transactions Real Time subject area.

Receivables Balances Reports

Overview of the Customer Account Status Report

This topic contains summary information about the Customer Account Status Report.

Overview

The Customer Account Status Report displays detailed information about each of your customer accounts.

This image shows output from the Customer Account
Status Report.

Key Insights

The report displays for each customer all open debit items, credit items, and total balance due in the ledger currency.

Frequently Asked Questions

The following table lists frequently asked questions about the Customer Account Status Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Specialist or Financial Manager when analyzing customer accounts.

When do I use this report?

When you want to analyze the detail that makes up the customer account balances by specific account statuses or collectors.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Customer Balance Revaluation Report

This topic contains summary information about the Customer Balance Revaluation Report.

Overview

The Customer Balance Revaluation Report identifies customers with credit (negative) balances.

This image shows output from the Customer Balance
Revaluation Report.

Key Insights

The report provides the balance of a customer and the open items that make up the balance, and lists customers by positive and negative balance.

Frequently Asked Questions

The following table lists frequently asked questions about the Customer Balance Revaluation Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

When you need to create accounting journals for revaluated customer accounts and identify customers with negative balances.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Projected Gains and Losses Report

This topic contains summary information about the Projected Gains and Losses Report.

Overview

The Projected Gains and Losses Report lets you review open foreign (non-ledger) currency invoices, debit memos, and chargebacks revalued according to the revaluation rate that you specify.

This image shows output from the Projected Gains
and Losses Report.

Key Insights

The report compares the revalued amount of each debit item with the entered amount and prints the unrealized gain or loss.

Frequently Asked Questions

The following table lists frequently asked questions about the Projected Gains and Losses Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

To review projected gain or loss for open foreign currency transactions revalued according to the revaluation rate that you specify.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Applied Receipts Register

This topic contains summary information about the Applied Receipts Register.

Overview

The Applied Receipts Register provides information about all receipt applications that affect your customer balances.

This image shows output from the Applied Receipts
Register.

Key Insights

Review receipt applications by customer and receipt batch. The report displays all receipt applications within the specified date range regardless of check date.

Frequently Asked Questions

The following table lists frequently asked questions about the Applied Receipts Register.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Period Close

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

When you need a listing of your customer applied receipts or to assist the receivables reconciliation process.

What can I do with this report?

Schedule to run as needed.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Receivables - Standard Receipt Application Details Real Time subject area.

Overview of the Unapplied Receipts Register

This topic contains summary information about the Unapplied Receipts Register.

Overview

The Unapplied Receipts Register lets you review detailed information about customer unidentified, on-account and unapplied payments. This information more accurately indicates how much a customer actually owes you.

This image shows output from the Unapplied Receipts
Register.

Key Insights

The report groups receipts by receipt batch and customer, and provides separate totals by business unit for on-account, unapplied, and unidentified receipts in the ledger currency, and a grand total for the report.

Frequently Asked Questions

The following table lists frequently asked questions about the Unapplied Receipts Register.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Period Close

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

  • When you need a listing of your customer unapplied receipts.

  • To assist the receivables reconciliation process.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Receivables - Standard Receipt Application Details Real Time subject area.

Overview of the Receipts Days Late Analysis Report

This topic contains summary information about the Receipts Days Late Analysis Report.

Overview

The Receipts Days Late Analysis Report helps you review the timeliness of your customer payments.

This image shows output from the Receipts Days
Late Analysis Report.

Key Insights

The report provides details of receipt applications against customer transactions for the period you specify.

Frequently Asked Questions

The following table lists frequently asked questions about the Receipts Days Late Analysis Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager when analyzing late payments.

When do I use this report?

To review the timeliness of your customer payments, including weighted days late calculation, which indicates the cost to you of overdue payments.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Receipts Awaiting Bank Clearance Report

This topic contains summary information about the Receipts Awaiting Bank Clearance Report.

Overview

The Receipts Awaiting Bank Clearance Report lets you review receipts waiting to be cleared by your remittance bank.

This image shows output from the Receipts Awaiting
Bank Clearance Report.

Key Insights

The report provides a separate section for each currency included in the output, and sorts information within each currency section by remittance bank account and remittance batch date.

Frequently Asked Questions

The following table lists frequently asked questions about the Receipts Awaiting Bank Clearance Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager to analyze risk.

When do I use this report?

To review all receipts waiting to be cleared by your remittance bank.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Receipts Awaiting Remittance Report

This topic contains summary information about the Receipts Awaiting Remittance Report.

Overview

The Receipts Awaiting Remittance Report lets you review receipts awaiting remittance to your bank.

This image shows output from the Receipts Awaiting
Remittance Report.

Key Insights

The report runs on both automatic and manual receipts. Once a receipt is approved for remittance it will no longer appear on the report.

Frequently Asked Questions

The following table lists frequently asked questions about the Receipts Awaiting Remittance Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager to analyze the overall remittance status.

When do I use this report?

To review all receipts requiring remittance to your bank.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Reversal Status Report

This topic contains summary information about the Reversal Status Report.

Overview

The Reversal Status Report lets you view the status of automatic receipt reversals processed for a settlement batch by a run of the Automatic Receipts Reversal process.

Reversal Status Report

Key Insights

This report is generated automatically after a run of the Automatic Receipts Reversal process. You can also run the report manually. The report groups receipts by settlement batch and includes receipt date, receipt number, receipt amount, reversal reason code, and a description of automatic receipt reversals that were unsuccessful.

Report Parameters

The following table lists selected report parameters:

Parameter Description

Settlement Batch Reference

Specify the identifier of the settlement batch for which you want to run the report.

From Settlement Batch Creation Date and To Settlement Batch Creation Date

Indicate the settlement batch creation date range for reporting data.

Receipt Status

Indicate the receipt status for reporting data.

Frequently Asked Questions

The following table lists frequently asked questions about the Reversal Status Report.

FAQ Answer

How do I find this report?

Scheduled Processes - Reversal Status Report

Who uses this report?

Financial Manager or Financial Specialist when analyzing automatic receipt activity.

When do I use this report?

To analyze the automatic receipt reversals and failed receipt reversals in a settlement batch.

What can I do with this report?

Schedule as needed.

What type of reports are these?

Oracle Business Intelligence Publisher

Overview of the Reversed Receipts Report

This topic contains summary information about the Reversed Receipts Report.

Overview

The Reversed Receipts Report lets you review receipt reversals by reversal date and remittance bank.

This image shows output from the Reversed Receipts
Report.

Key Insights

The report displays results and total receipts by bank, customer or reversal reason. You can optionally review specific receipts according to the parameters that you specify.

Frequently Asked Questions

The following table lists frequently asked questions about the Reversed Receipts Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager when analyzing causes of reversals.

When do I use this report?

To review receipt reversals by reversal date and remittance bank, and categorize by stop payments, insufficient funds, and receipts entered in error.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses these subject areas:

  • Receivables - Standard Receipt Application Details Real Time

  • Receivables - Miscellaneous Receipts Real Time

Overview of the Receivables Open Items Revaluation Report

This topic contains summary information about the Receivables Open Items Revaluation Report.

Overview

The Receivables Open Items Revaluation Report is used to revalue your open items, including invoices, credit memos, and debit memos.

This image shows output from the Receivables Open
Items Revaluation Report.

Key Insights

Revalue open items based on the revaluation rate that you specify, which is either an end-of-period rate or a daily rate. The report is divided into sections for each unique combination of balancing segment and receivables account.

Frequently Asked Questions

The following table lists frequently asked questions about the Receivables Open Items Revaluation Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

When you need to revalue your customer open transactions for determining the amount needed to manually adjust your general ledger balance to reflect the difference between the original and revalued balance.

What can I do with this report?

Schedule as needed.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Receivables Aging by General Ledger Account Report

This topic contains summary information about the Receivables Aging by General Ledger Account Report.

Overview

The Receivables Aging by General Ledger Account Report helps you review information about outstanding receivables balances.

This image shows output from the Receivables Aging
by General Ledger Account Report.

Key Insights

You can use this report either during reconciliation or to age or summarize open receivables.

Frequently Asked Questions

The following table lists frequently asked questions about the Receivables Aging by General Ledger Account Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

Review information about your customer outstanding receivables balances by general ledger account as of a specific accounting date.

What can I do with this report?

Schedule periodically.

What type of report is this?

Oracle Business Intelligence Publisher

Bills Receivable Reports

Overview of the Bills Receivable Remittance Batch Management Report

This topic contains summary information about the Bills Receivable Remittance Batch Management Report.

Overview

The Bills Receivable Remittance Batch Management Report provides detailed information about a bills receivable remittance batch.

This image shows output from the Bills Receivable
Remittance Batch Management Report.

Key Insights

Review both remittance batch information and information about each bill receivable in the batch.

Frequently Asked Questions

The following table lists frequently asked questions about the Bills Receivable Remittance Batch Management Report.

FAQ Answer

How do I find this report?

Scheduled Processes - Create Bills Receivable Remittance Batch

Who uses this report?

Financial Specialist responsible for bills receivable.

When do I use this report?

To review a run of the Create Bills Receivable Remittance Batch process.

What can I do with this report?

According to your bills receivable remittance schedule.

What type of report is this?

Oracle Business Intelligence Publisher

Overview of the Automatic Bills Receivable Transactions Batch Report

This topic contains summary information about the Automatic Bills Receivable Transactions Batch Report.

Overview

The Automatic Bills Receivable Transactions Batch Report lists the contents of a bills receivable batch.

This image shows output from the Automatic Bills
Receivable Transactions Batch Report.

Key Insights

The report lists the bills receivable created in a batch, or the bills receivable that will be created in a batch submitted in Draft.

Frequently Asked Questions

The following table lists frequently asked questions about the Automatic Bills Receivable Transactions Batch Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables Balances

Who uses this report?

Financial Specialist responsible for bills receivable.

When do I use this report?

When you need to review a list of the bills receivable created in a batch, or the bills receivable that will be created in a batch if the Create Bills Receivable Batch process is submitted in Draft.

What can I do with this report?

Set the Batch Mode parameter of the Create Bills Receivable Batch process to Draft.

What type of report is this?

Oracle Business Intelligence Publisher

Reconciliation Reports

Overview of the Receivables to General Ledger Reconciliation Report

This topic contains summary information about the Receivables to General Ledger Reconciliation Report.

Overview

The Receivables to General Ledger Reconciliation Report is the primary tool for the reconciliation of receivables data to the general ledger.

This image shows output from the Receivables to
General Ledger Reconciliation Report.

Key Insights

The report provides both summarized and detailed reconciling data for review and analysis.

Frequently Asked Questions

The following table lists frequently asked questions about the Receivables to General Ledger Reconciliation Report.

FAQ Answer

How do I find this report?

Reports and Analytics pane - Shared Folders - Financials - Receivables - Receivables to Ledger Reconciliation

Who uses this report?

Financial Manager during period close processing.

When do I use this report?

When you are reconciling your receivables to your general ledger balances.

What can I do with this report?

Review report after running the Prepare Receivables to General Ledger Reconciliation scheduled process.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses these subject areas:

  • Receivables - Adjustments Real Time

  • Receivables - Bill Receivable Real Time

  • Receivables - Credit Memo Applications Real Time

  • Receivables - Receipt Details Real Time

  • Receivables - Standard Receipt Application Details Real Time

  • Receivables - Transactions Real Time

  • Subledger Accounting - Journals Real Time

  • Subledger Accounting - Receivables Summary Reconciliation Real Time

  • General Ledger - Journals Real Time

  • General Ledger - Transactional Balances Real Time

Guidelines for Using the Receivables to General Ledger Reconciliation Report

Use the Receivables to General Ledger Reconciliation report to facilitate the reconciliation of receivables data to the general ledger.

The interactive reporting capability of the Receivables to General Ledger Reconciliation report provides both summarized and detailed reconciling data for review. The Summary report lets you see receivables and accounting beginning and ending balances, as well as summarized activity for the period and how this activity was accounted.

Drill down on any amount in the Summary report Difference column to display the Differences Detail report for that item. The Differences Detail reports display the details that make up balances from the Summary report, and indicate potential causes for differences between actual and reconciling amounts.

Note: For a more efficient reconciliation, don't allow general ledger sources other than Receivables to post to Receivables accounts.

If you restrict the number of general ledger accounts that you include in a run of the Prepare Receivables to General Ledger Reconciliation program, this can affect the display of data in the detail reports and may be the cause of a difference between the accounted amount of a transaction and the reconciling amount.

For example, if Receivables transactions are recorded against balancing segment values 1, 2, 3 or natural accounts A, B, C, and the account range you used excluded some of these values, then these transactions would show up as differences on the report.

If you are downloading a large amount of data from the report to a spreadsheet and you plan to perform a number of data manipulations, use the CSV format. If you are downloading data for reference purposes only, use the Excel or PDF format.

Review these additional guidelines for using the Receivables to General Ledger Reconciliation report:

  • Differences between Transactional and Accounted Amounts

  • Differences between Summary and Detail Amounts

  • Differences between the Reconciliation Report and the Aging Report

  • Recommendations for Reconciling by Business Unit and by Intercompany Activity

  • Recommendations for Reconciling Unapplied and Unidentified Receipts and On-Account Items

  • Recommendations for Reconciling Bills Receivable

Differences between Transactional and Accounted Amounts

Ideally the Summary report should display no differences between receivables transactional amounts and accounted amounts. In addition, the beginning and ending receivables balances should agree with the Receivables Aging by Account report.

Note: It may happen that the Summary report will contain variance amounts. If the Summary report contains variance amounts, contact your system administrator.

Any differences that you find require further investigation and possible correction. Common reasons for differences between transactional amounts and accounted amounts include:

  • Transactions that are not accounted.

  • Transactions with subledger accounts that fall outside the account range of the report.

  • Transaction amounts don't agree with the subledger journal line amounts.

  • Journals are posted to the subledger or general ledger that didn't come from Receivables.

  • Subledger journals were not transferred or posted to general ledger.

After finding and correcting discrepancies, you must re-run the Prepare Receivables to General Ledger Reconciliation program and review the Summary report.

Note: Some differences may be valid. For example, if you included unapplied and unidentified receipts in your extract, but you don't post these receipts to a receivables account or an account with the financial category of Accounts Receivable assigned, then these receipts appear as a difference that is outside the account range of the report. In this case, you can re-run the extract and exclude these items.

Differences between Summary and Detail Amounts

The Non-Receivables Begin Balance amount is any portion of a general ledger account beginning balance that didn't originate from Receivables transactions. You can drill down on this amount to see a list of general ledger journal lines that have an accounting date that falls within the current fiscal year but prior to the period of the reconciliation report; and that have an account combination that falls within the account range of the report.

The drill-down page doesn't include non-Receivables journal lines dated in previous fiscal years, which means that these journal lines won't match the Non-Receivables Begin Balance amount. The drill-down page is only intended to provide current fiscal year journals that might have posted erroneously to the receivables account.

The journal source of these journals is typically not Receivables. However, you may see manual subledger journal entries that were entered for the Receivables source directly into the subledger but not necessarily linked to a specific Receivables transaction. Most of these entries represent adjustment journal entries.

Manual subledger journals created during the current reconciling period display in the Summary report in the Other Accounting section, and become part of the Non-Receivables Begin Balance amount in subsequent periods. Manual general ledger journals that may affect receivables accounts are created directly in the general ledger and don't display in the Other Accounting section on the Summary report, but display instead in the Non-Receivables Activity amount.

Summary amounts may not reflect totals on detail pages because:

  • Data was modified after the data extract was run for a given accounting period. If transactions or accounting were created or modified between the time the extract was executed and the moment you drill down from a summary amount to its detail amounts, the summary amount won't reflect the detail page totals.

    To limit discrepancies between the summary and detail reports, set the Receivables accounting period status to Close Pending or Closed.

  • Security rules in your setup may restrict you from seeing data from certain business units or segment values.

    Ensure that appropriate security is given to users for all business units and accounting flexfield segment values that each user is responsible for reconciling.

Differences between the Reconciliation Report and the Aging Report

You may find differences between the data displayed in the Receivables to General Ledger Reconciliation report and the Receivables Aging by Account report. This list provides the principle reasons why this occurs and recommendations for working with these differences:

  • Intercompany Transactions: You can't limit the display of intercompany transactions on the Receivables Aging by Account report. If the reconciliation extract either excludes intercompany transactions or displays intercompany transactions only, then the Receivables to General Ledger Reconciliation report and the Receivables Aging by Account report won't display compatible data.

  • Unaccounted Amounts: The Receivables Aging by Account report doesn't display unaccounted activity. Unaccounted amounts display as differences in the Summary Reconciliation report. In this case, compare the Accounting End Balance with the Receivables Aging by Account report. You will need to subtract out any amount in Other Accounting, as this is not included in the Receivables Aging by Account report.

  • Receipts at Risk: The Receivables Aging by Account Report has the option to display or ignore Receipts at Risk. The Receivables to General Ledger Reconciliation report doesn't use this option, and always excludes receipts at risk. For reconciliation purposes, be sure to exclude receipts at risk when running the Receivables Aging by Account report.

  • Open Credits: The Receivables Aging by Account report has the option to Age, Summarize, or Exclude open credits. For reconciliation purposes, it is recommended that you Age or Summarize open credits.

Caution: Do not use Advanced Collections Aging reports for reconciliation because they don't include general ledger account information. This applies to these three reports:
  • Aging by Common Currency Report

  • Collections Aging 4-Bucket Report

  • Collections Aging by Collector 7-Bucket Report

Recommendations for Reconciling by Business Unit and by Intercompany Activity

To reconcile by business unit, you need to have an implicit mapping of the business unit to one or more primary balancing segment values. When you run the Prepare Receivables to General Ledger Reconciliation program, you must specify both the business unit to reconcile and the balancing segment value or range of values assigned to that business unit. The Business Unit parameter selects the receivables activity and the balancing segment value selects the accounting data.

You have three options for reconciling Intercompany activity:

  • Include Intercompany activity with other Receivables activity.

  • Exclude Intercompany activity from reconciliation.

  • Include only Intercompany activity.

If you want to include Intercompany activity with other Receivables activity, set the Include Intercompany parameter to Yes and include the Intercompany account in the range of account values to extract. By default, if no account range is selected, all accounts with the financial category of Accounts Receivable are included in the extract.

If you want to exclude Intercompany activity from reconciliation, set the Include Intercompany parameter to No, and also exclude the Intercompany range of accounts from the extract.

If you are reconciling only the Intercompany activity, set the Include Intercompany parameter to Intercompany Only, and select the account range for your Intercompany Receivables accounts.

Recommendations for Reconciling Unapplied and Unidentified Receipts and On-Account Items

If you want to exclude unapplied and unidentified receipts, and on-account items, from reconciliation, set the Include Unapplied and Unidentified Receipts parameter and the Include On-Account Items parameter to No, and exclude the respective ranges of accounts from the extract. To avoid reconciling differences, unapplied and unidentified receipts, and on-account items, should not post to the same general ledger accounts as that used for transactions. If they do, then the accounting for transactions would also be excluded.

If you never include unapplied and unidentified receipts, or on-account items, in your reconciliation, then don't assign the financial category of Accounts Receivable to these accounts in your chart of accounts setup.

Recommendations for Reconciling Bills Receivable

Two rows on the Summary report display bills receivable activity for the accounting period:

  • Bills Receivable: Bills receivable created (unsigned or drawee-issued), accepted (signed), and canceled during the accounting period.

  • Bills Receivable Applications: All customer transactions applied to bills receivable created, accepted, and canceled during the accounting period.

The totals for Bills Receivable and Bills Receivable Application net to zero, because both sides of the creation of bills receivable and the application of transactions, or unapplication in the case of canceled bills, are recorded here. Creation and Acceptance require the assignment of transactions to the bill receivable, so each of these bills display the associated transaction applications. Cancellation reverses the bill receivable and its applications, so canceled bills display both sides of the activity, application and unapplication.

Status changes to Remitted, Unpaid, and Factored bills receivable have an accounting impact only because, as the bill goes through its lifecycle, only the account it posts to changes. These events display in the Summary report in the Other Accounting section. Like all other events related to reconciliation, the accounts used for these activities need to have the financial category of Accounts Receivable assigned to the natural account segment in the chart of accounts.

Other activities against bills receivable are included in existing sections of the Summary report and the related drill-down reports. On-account credit memos against a bill receivable display in the Invoices section, along with all other transaction activity. Receipts applied to bills receivable display with other receipts in the Applied Receipts section.

Guidelines for Receivables to General Ledger Reconciliation

Periodically you need to reconcile the transactions in your accounts receivable system, both before and after you post to the general ledger. The Receivables to General Ledger Reconciliation extract and report help to simplify this process and reduce the amount of manual reconciling activity required.

The automated activities in the reconciliation process function according to the way you set up your Financials environment. A review of some of these setups can help improve the overall reconciliation process.

Review these activities related to setting up your Financials environment for Receivables to General Ledger reconciliation:

  • Business Unit vs. Ledger Reconciliation

  • Accounts Receivable Financial Category

  • Profile Option Settings

  • User Security

Business Unit vs. Ledger Reconciliation

If you implicitly map primary balancing segment values to your business unit, you can reconcile based on business unit. This allows employees from different business units to balance their respective organization activity.

If you don't implicitly map primary balancing segment values to business unit, you must reconcile based on ledger. In this case, you will need access to all business units associated with the ledger to perform a thorough reconciliation.

Note: Implicit mapping means that no specific setup is used to assign the business unit to a primary balancing segment. This is a business decision, and your setup in Receivables should be such that the default accounting assigned to activities for that business unit should be the primary balancing segment value that was decided.

Accounts Receivable Financial Category

You must assign the financial category of Accounts Receivable to all of your receivables natural account values. This is a required setup step for Receivables to General Ledger reconciliation. You perform this task under the Manage Chart of Accounts Value Sets activity.

If the financial category of Accounts Receivable is not included in the chart of accounts setup, the Receivables to General Ledger Reconciliation report won't select any data. When you run the extract program, if you try to select general ledger natural account values that don't have this category assigned, the extract program displays an error indicating that the financial category was not assigned.

Once you assign the Accounts Receivable financial category, you can leave the Account parameter blank when you run the extract, in order to include all accounts that have the Accounts Receivable financial category in the ledger. You can alternatively enter specific natural account values to limit the report to reconciling only a subset of the receivables accounts in the ledger, but these values must have the Accounts Receivable financial category assigned.

If you set up accounts for unidentified, unapplied, and on-account receipts, and on-account credit memos, you must also assign the Accounts Receivable financial category to these accounts in order to include them in reconciliation. If you want to exclude these accounts during reconciliation, then you must exclude them from the Account parameter, and both the Include On-Account Items parameter and the Include Unapplied and Unidentified Receipts parameter.

Caution: You must assign unique general ledger accounts to unidentified, unapplied, and on-account receipts, and on-account credit memos, to exclude them from reconciliation. Don't assign them the same receivables accounts as that used for transactions, because the accounting for transactions would also be excluded, causing reconciling differences.

Profile Option Settings

Review the setting of these profile options:

  • Reconciliation Data Purge Frequency

  • Zero Amount Journal Lines Displayed

Use the Reconciliation Data Purge Frequency profile option to indicate the number of days to keep reconciliation extract data in the tables. Enter a value for the number of days needed to not lose prior extracts that you may need for comparison purposes.

Every time you run the extract program, it refers to the value of the Reconciliation Data Purge Frequency profile option. If there are any reconciliation data extract requests in the table older than the number of days specified in the profile option, these requests are purged.

For example, if a reconciliation data extract is run on January 1, and the value of this profile option is set to 30 days, then the data from January 1 is not purged if you run another extract on January 29. However, the data is purged if you run another extract on February 1.

The Zero Amount Journal Lines Displayed profile option affects whether journal lines with zero amounts display in the Not Transferred to GL Detail report. If this profile option is set to Yes, the Summary report may equal zero and the detail report will list these zero amount journal lines. This doesn't prevent Period Close and doesn't cause reconciling issues as the net effect on the report is zero.

User Security

This section includes considerations for segment security and data access set.

Segment security applies to Detail reports only. If you don't have segment security access, then summary and detail report totals may not match.

Typically General Ledger users are secured by a data access set, and Receivables users by business unit security. This means that for the Receivables to General Ledger Reconciliation report:

  • General Ledger users can see general ledger data for the balancing segment values in their data access set, as well as the Receivables and Subledger Accounting data for all business units linked to the ledger.

  • Receivables users can see the Receivables and Subledger Accounting data for business units in their security definition, as well as general ledger data for all balancing segment values in the ledger.

However, if security is configured such that the data role for the General Ledger or Receivables job roles also have FND grants to specific business units for General Ledger users or specific data access sets for Receivables users, then the reconciliation report will only include:

  • For General Ledger users, the Receivables and Subledger Accounting data for those business units in the ledger to which the user has access.

  • For Receivables users, general ledger data for those balancing segment values included in the data access set to which the user has access.

This doesn't present a problem for the Receivables to General Ledger Reconciliation report if there is an implicit mapping between business units and balancing segment values. Users can simply filter the report for the balancing segment values that are mapped to the business units to which they have access, and the report should work properly.

However, if there is not an intentional and implicit mapping between balancing segment values and business units, then this can cause the Receivables to General Ledger Reconciliation report to display undesirable results:

  • For General Ledger users, the report will include general ledger data for all balancing segment values in the data access set, while Receivables and Subledger Accounting data are limited to the business units to which a user is granted access.

  • For Receivables users, the report either won't include any general ledger data, or it will include general ledger data that is not properly mapped to the Receivables and Subledger Accounting data for the business unit.

You can resolve this issue by removing the FND grants from specific business units for the General Ledger job roles, and from specific data access sets for the Receivables job roles.

Extract Reconciliation Data from Receivables to General Ledger

Run the Prepare Receivables to General Ledger Reconciliation program to select data for the Summary section of the Receivables to General Ledger Reconciliation Report. The extract must run successfully in order to see the most current Summary report, and before you can run the Receivables to General Ledger Reconciliation Report.

Use the following parameters of the Prepare Receivables to General Ledger Reconciliation program to control the Receivables transaction activity that you intend to include in the extract:

  • Business Unit

  • Include Intercompany Transactions

  • Include On-Account Items

  • Include Unapplied and Unidentified Receipts

Tip: To avoid unintended reconciling differences, you must ensure that you include or exclude the related accounting activity associated with the Receivables transaction activity included in a given extract.

For example, if you intend to reconcile by a specific business unit but don't select the associated primary balancing segment values in the Account parameter, accounting data from other business units belonging to the same ledger will display as differences.

Prepare Receivables to General Ledger Reconciliation Parameters

Request Name

Enter a name that is descriptive of this extract. Consider using a name that indicates the accounting period, date, and time, especially if you are planning to create multiple extracts.

Note: Enter a unique request name each time you run the extract. If you reuse a request name, then the extract may contain no data.
Ledger

The ledgers available for selection are based on your security assignment. The default is the first ledger in alphabetic order.

Business Unit

Use this parameter if you need to reconcile by a specific organization.

Note: The business unit must be mapped to a balancing segment. If not, you must reconcile by ledger. If you have implicitly mapped your business unit to one or more primary balancing segment values, you will also need to select these values when you run the extract.
Accounting Period

You can select either an Open or Closed accounting period. The default is the latest period in the Closed Pending status, if it exists, for the selected ledger.

You can run the extract on an Open period to see point-in-time summary balances, in order to review possible reconciling activities you may encounter during period close processing. If you select an Open period for reconciliation, users can still enter activity against the period after the extract runs, creating potential discrepancies between the summary and detail information on the report. Best practice is to close the accounting period to be reconciled before you run the extract, and then select this Closed period in the Accounting Period parameter.

Include Intercompany Transactions

You can include or exclude Intercompany transactions, or you can reconcile by Intercompany activity only.

Include On-Account Items

You can include or exclude on-account items. On-account items include on-account receipts and on-account credit memos.

Note: You may want to exclude on-account items if they typically post to non-receivable accounts. If you plan to exclude on-account items, you also need to exclude the related general ledger account in the Account parameter. Therefore, don't post this activity to the same Receivables account as your invoices to avoid reconciling differences.
Include Unapplied and Unidentified Receipts

You can include or exclude unapplied receipts and unidentified receipts. Unapplied receipts are receipts that haven't yet applied; unidentified receipts are receipts without customer information.

Note: You may want to exclude unapplied and unidentified receipts if they typically post to non-receivable accounts. If you plan to exclude unapplied and unidentified receipts, you also need to exclude the related general ledger account in the Account parameter. Therefore, don't post this activity to the same Receivables account as your transactions to avoid reconciling differences.
Account

You can select values from any of the segments of the accounting flexfield. The natural account segment values must have the financial category of Accounts Receivable assigned in your general ledger setup in order for the extract and report to work properly.

If you are excluding on-account items, or unapplied and unidentified receipts, from your reconciliation, you must also exclude their associated general ledger accounts, if those accounts have the financial category of Accounts Receivable assigned. If they don't have the financial category assigned, by default these accounts are not included in your reconciliation.

If you are reconciling by business unit, select the range of balancing segment values implicitly mapped to your business unit.

If you are reconciling Intercompany activity, select the range of Intercompany accounts. These accounts must have the financial category of Accounts Receivable assigned.

If you are reconciling everything, you don't need to select any values. The report automatically selects data for Receivables accounts that have the financial category of Accounts Receivable assigned.

Receivables Report FAQs

What's a variance amount?

A variance amount is a line in the Receivables to General Ledger Reconciliation report that displays the total amount of variance between transactional and accounted amounts.

Variance amounts are due to some type of data corruption. There are two types of variance amounts: receivables variance and accounting variance. A receivables variance is the result of data corruption in the Receivables tables. An accounting variance is the result of data corruption either in subledger accounting or the general ledger. Variance amounts don't display in any other section of the summary or detail reports.

The Receivables to General Ledger Reconciliation Accounting variance report captures information related to these two causes of data corruption:

  • Accounting entries in general ledger sourced from subledger accounting that are present in the general ledger tables, but not available in the subledger accounting tables.

  • Accounting entries transferred from the subledger to general ledger that are present in the subledger accounting tables, but are not available in the general ledger tables.

How are accounts reconciled to general ledger?

The Receivables to General Ledger Reconciliation report only reconciles accounts receivable for accrual basis accounting, and only reconciles accounting in the primary ledgers.

The Receivables to General Ledger Reconciliation report reconciles the transaction types that impact the accounts receivable in general ledger. These include:

  • Invoice

  • Debit memo

  • Credit memo

  • On-account credit memo

  • Chargeback

  • Adjustment

  • Applied receipt

  • On-account receipt

  • Unapplied receipt

  • Unidentified receipt

  • Bills receivable

  • Bills receivable application

Note: On-account credit memo refund amounts and on-account credit memo gain or loss amounts are included in the Invoices section of the Reconciliation report, because they affect the open balance of the receivable amount of the credit memo. In all cases the intent is to close the credit memo, so both the original credit memo and the activity against it are displayed.

The report also reconciles manual journal entries created in the Receivables subledger.

If your business unit is implicitly mapped to the primary balancing segment value in the chart of accounts, you can run the report to reconcile by either business unit or ledger. If there is no implicit mapping, then you must reconcile by ledger.

Note: This mapping is not defined anywhere in Receivables or General Ledger.

Netting Reports

Netting Settlement Letter

This topic contains summary information about the Netting Settlement Letter.

Overview

Select the Generate Netting Letter option for an agreement to receive a netting settlement letter for yourself and your third party every time a settlement takes place. The netting letter generation process automatically runs when the netting manager submits a settlement, or creates a settlement without review. You can access the report from the Financial Reporting Center.

The netting settlement letter lists the following invoices and transactions:

  • The Payables invoices that were netted, which includes the following parameters:

    • Invoice Number

    • Invoice Type

    • Invoice Date

    • Invoice Amount

    • Netted Amount

    • Invoice Currency

    • Invoice Total

    • Netted Total

  • The Receivables transactions that were netted, which includes the following parameters:

    • Transaction Number

    • Transaction Type

    • Transaction Date

    • Transaction Amount

    • Netted Amount

    • Transaction Currency

    • Transaction Total

    • Netted Total

The following figure of a netting settlement letter sample lists only the Payables transactions that were netted:

This graphic illustrates a sample netting settlement
letter for Payables transactions.

The following figure of a netting settlement letter sample lists only the Receivables transactions that were netted:

This graphic illustrates a sample netting settlement
letter for Receivables transactions.

Key Insights

The settlement process runs the report automatically, and sends the letter to your third party. You can view the letter from the Financial Reporting Center.

Frequently Asked Questions

The following table lists frequently asked questions about the netting settlement letter.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu. You can also select the Generate Netting Letter for your Netting Agreement, and download the letter from the Financial Reporting Center when a settlement is settled.

Who uses this report?

Netting Manager.

When do I use this report?

Use this report when a netting settlement is settled.

What can I do with this report?

Run the report for a settlement for your legal entity. The report can be emailed to your trading partner automatically. If the Send Letters by Email option is selected on the Agreement, an email of the settlement letter is sent to the third party.

What type of reports are these?

Oracle Business Intelligence Publisher.

Netting Reversal Letter

This topic contains summary information about the Netting Reversal Letter.

Overview

The Netting Reversal Letter runs automatically when the netting manager reverses a netting settlement after selecting the Generate Netting Letter option for the agreement. You can access the report from the Financial Reporting Center. The netting reversal letter is similar to the netting settlement letter but it indicates that the payments have been voided, and the receipts have been reversed.

The following figure describes a sample netting reversal letter for Payables:

The image describes a sample Netting Reversal Letter.

Key Insights

The reversal process runs the report automatically, and sends the letter to your third party. You can view the letter from the Financial Reporting Center.

Frequently Asked Questions

The following table lists frequently asked questions about the netting reversal letter.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu. You can also select the Generate Netting Letter option for your Netting Agreement, and download the letter from the Financial Reporting Center when a settlement is reversed.

Who uses this report?

Netting Manager.

When do I use this report?

Use this report when a netting settlement is reversed.

What can I do with this report?

Run the report for a settlement for your legal entity. The report can be automatically mailed to your trading partner. If the Send Letters by Email option is selected for the Agreement, an email of the settlement letter is sent to the third party.

What type of reports are these?

Oracle Business Intelligence Publisher.

This topic describes about the Netting Settlement report.

Overview

The Netting Settlement report is an internal report for the netting manager to review. The report automatically runs when the netting manager submits a settlement, or creates a settlement without review. You can access this report from the Financial Reporting Center.

The netting settlement report lists these netting information:

  • Netting Agreement and Netting Settlement options that were valid at the point of settlement.

  • Payables invoices that were netted.

  • Receivables transactions that were netted.

This figure lists the parameters of a netting settlement report:

The image describes a section of a sample netting
settlement report.

Here's a sample netting settlement report for Payables transactions.

The image describes Payables transactions for a
sample Netting Settlement Report.

Here's a sample netting settlement report for Receivables transactions.

The image describes Receivables transactions for
a sample Netting Settlement Report.

Key Insights

The settlement process runs the report automatically. You can view the report from the Financial Reporting Center.

Frequently Asked Questions

Here are few frequently asked questions about the Netting Settlement Report.

FAQ Answer

How do I find this report?

The Netting Settlement report runs automatically when a settlement is settled. You can also schedule and run this report from the Scheduled Processes work area.

Who uses this report?

Netting Manager.

When do I use this report?

Use this report when a netting settlement is settled.

What can I do with this report?

Run the report for a settlement for your legal entity. You can then review the invoices and transactions that were netted in the settlement.

What type of report is this?

Oracle Business Intelligence Publisher.

Netting Settlement Listing

This topic contains summary information about the Netting Settlement Listing.

Overview

The netting settlement listing is an internal report in the spreadsheet format, that netting managers can review. The listing automatically runs when the netting manager submits a settlement or creates a settlement without review. You can access the report from the Financial Reporting Center.

The netting settlement listing consists of the following four sections:

  • Title tab: Provides the title of the listing. The following image displays the title tab of a Netting Settlement Listing:

    The image describes the header tab of a sample
Netting Settlement Listing Title.
  • Header tab: Lists Netting Agreement and Netting Settlement options that were valid at the point of settlement, as displayed in the following image:

    The image describes the header tab of a sample
Netting Settlement Report.
  • Payables Transactions tab: Lists the following parameters:

    • Supplier Name

    • Supplier Number

    • Taxpayer ID

    • Tax Registration Number

    • Supplier Site

    • Invoice Number

    • Invoice Date

    • Invoice Type

    • Terms Date

    • Amount

    • Invoice Currency

    • Open Amount: Indicates the open invoice amount before netting.

    • Final Netting Amount: Indicates the amount of the invoice that was netted.

    • Open Amount after Netting: Indicates the final open invoice amount after netting.

      Note: You can identify a partially netted as the invoice with a positive Open Amount after Netting that is less than the Open Amount.
    • Settlement Currency

    The following figure illustrates a sample netting settlement listing for Payables:

    The image describes a sample Netting Settlement
Listing for Payables.
  • Receivables Transactions Tab: Lists the following parameters:

    • Customer Name

    • Customer Number

    • Taxpayer ID

    • Tax Registration Number

    • Customer Site

    • Transaction Number

    • Transaction Date

    • Transaction Type

    • Terms Date

    • Amount

    • Transaction Currency

    • Open Amount: Indicates the open invoice before netting.

    • Final Netting Amount: Indicates the amount of the invoice that was netted.

    • Open Amount after Netting

    • Settlement Currency

    The following figure illustrates a sample netting settlement listing for Receivables:

    The following figure illustrates a sample netting
settlement listing for Receivables.

Key Insights

The settlement process runs the report automatically, and you can download the listing from the Financial Reporting Center.

Frequently Asked Questions

The following table lists frequently asked questions about the netting settlement listing.

FAQ Answer

How do I find this report?

The Netting Settlement Listing runs automatically when a settlement is settled. You can also schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Netting Manager.

When do I use this report?

Use this report when a netting settlement is settled.

What can I do with this report?

Run the report for a settlement for your legal entity. You can review the invoices and transactions that were netted in the settlement, and then perform analysis on the date in the spreadsheet.

What type of report is this?

Oracle Business Intelligence Publisher.