9Oracle Fusion Payables Reports

This chapter contains the following:

Oracle Fusion Payables Predefined Reports

Oracle Fusion Payables provides predefined reports that cover the following areas:

  • Invoices

  • Payments

  • Payables to Ledger Reconciliation

  • Period Close

  • Prepayments

  • Income Tax and Withholding

  • Netting

You can schedule and run reports from the Scheduled Processes work area. In some cases, you can access and open reports in the Reports and Analytics work area.

The following tables list the predefined reports.

Invoices

Name Description

Import Payables Invoices Report

Report from the process that creates Payables invoices from invoice data in the open interface tables.

Payables Credit Memo Matching Report

Lists credit memos and debit memos for suppliers along with the invoices to which the credit memos and debit memos are matched.

Payables Invoice Aging Report

Lists unpaid invoices according to the specified aging periods.

Supplier Balance Aging Report

List the unpaid supplier invoices according to the specified aging periods.

Payables Invoice Audit by Voucher Number Listing

Lists invoices with assigned sequential voucher numbers.

Payables Invoice Audit Listing

Lists invoices for review and audit based on a specified amount for a given supplier and range of invoice creation dates.

Payables Invoice Register

Provides detailed information about invoices.

Payables Key Indicators Report

Generates reports with transaction activity and the current number of suppliers, invoices, payments, and matching holds.

Payables Matched and Modified Receipts Report

Identifies receipts that were modified after invoice matching.

Payables Matching Detail Report

Provides details of how an invoice, purchase order, or receipt was matched.

Payables Matching Hold Detail Report

Provides detailed payables and purchasing information for invoices with matching holds and matching hold releases.

Payables Negative Supplier Balance Report

Lists suppliers with negative balances along with the invoices and credit or debit memo transactions for the balance.

Payments

Name Description

Payables Cash Requirement Report

Forecasts immediate cash needs for invoice payments.

Payables Payment Requests Import Report

List the payment requests for invoices that are imported or rejected with rejection reasons for payments.

Payables Discounts Taken and Lost Report

Identifies payments where a discount was taken and payments where a discount was available, but not taken.

Payables Payment Register

Provides detailed information about payments.

Payables Selected Installments Report

Lists all invoice installments selected in a payment process request to help determine how well the selection criteria is selecting the correct invoices to pay.

Payment Audit by Voucher Number Report

Lists payments with assigned sequential voucher numbers.

Update Matured Bills Payable Status

Report from the process that updates the status of matured bills payable from issued to negotiable.

Payables to Ledger Reconciliation

Name Description

Payables to Ledger Reconciliation Report

Lists the journals posted to the general ledger for open payables balances to facilitate the reconciliation of accounting and transactional data recorded in Payables and Oracle Fusion Subledger Accounting.

Period Close

Name Description

Payables Open Items Revaluation Report

Lists changes in the value of open items, such as unpaid invoices and credit memos, due to conversion rate fluctuations.

Payables Period Close Exceptions Report

Lists exceptions that prevent the Payables accounting period from closing.

Payables Posted Invoice Register

Lists accounting lines for invoices that have been transferred to the general ledger.

Payables Posted Payment Register

Lists accounting lines for payments that have been transferred to the general ledger.

Payables Trial Balance Report

Lists and subtotals by supplier and liability account, all unpaid and partially paid invoices that Payables transferred to the general ledger.

Payables Unaccounted Transactions and Sweep Report

Lists invoices and payments that weren't accounted for a period or date range.

Prepayments

Name Description

Prepayment Remittance Notice

Lists prepayments that were applied to supplier invoices.

Income Tax and Withholding

Name Description

Payables Withholding Tax by Tax Authority Report

Lists withholding for tax codes assigned to a tax authority.

Payables Withholding Tax Letter

Creates a withholding tax letter to mail to a supplier on a periodic basis. The letter contains a list of withholding made for a supplier summarized either by tax type and tax rate, or by supplier site.

Payables Withholding Tax Report

Lists withholding for a supplier. The invoice view is used to review detailed withholding tax information by invoice. The supplier view is used to review the withholding information for a range of suppliers.

Update and Report Income Tax Details

Report from the process that updates or reports income tax type or income tax region fields on invoice distributions that are used for United States 1099 reporting.

US 1096 Report

Summarizes each United States1099 form type that's transmitted on paper, as required by the United States Internal Revenue Service. Generates the summary on a preformatted Internal Revenue Service form.

US 1099 Electronic Media Report

Generates summarized United States1099 information in electronic format, as required by the United States Internal Revenue Service.

US 1099 Forms - Comma Delimited Format

Reports the total United States 1099 miscellaneous tax type payments for 1099 suppliers in a comma delimited format.

US 1099 Invoice Exceptions Report

Lists paid invoice distributions with inaccurate or missing United States 1099 income tax information.

US 1099 Payments Report

Lists payments made to United States 1099 suppliers.

US 1099 Report

Reports the total United States 1099 miscellaneous payments for a particular 1099 supplier and generates 1099 forms for each tax reporting entity in an organization.

US 1099 Supplier Exceptions Report

Lists suppliers with inaccurate or incomplete United States 1099 income tax information.

Netting

Name Description

Netting Settlement Letter

Prints a letter that detail Receivables and Payables transactions in a netting settlement.

Netting Reversal Letter

Prints a letter that detail Receivables and Payables transactions reversed in a netting settlement.

Netting Settlement Report

Lists the transactions netted for a specific netting settlement in the PDF format.

Netting Settlement Listing

Lists the transactions netted for a specific netting settlement in the spreadsheet format.

Invoices

Import Payables Invoices Report

This topic includes details about the Import Payables Invoices Report.

Overview

The Import Payables Invoices Report provides information from the Import Payables Invoices process, which creates invoices from invoice data in the open interface tables.

The following figure is an example of the report.

The Import Payables Invoices Report is illustrated
in this graphic.

Key Insights

The report provides the results of the import process with the list of invoices that imported successfully along with the reasons that invoices may have failed to import.

Frequently Asked Questions

The following table lists frequently asked questions about the Import Payables Invoices Report.

FAQ Answer

How do I find this report?

The report is automatically generated by the Import Payables Invoices process, but you can also schedule and run it from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Specialist

When do I use this report?

When you run the Import Payables Invoices process and want to review the results of the process.

What can I do with this report?

Review the report for invoices that couldn't be imported.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Credit Memo Matching Report

This topic includes details about the Payables Credit Memo Matching Report.

Overview

The Payables Credit Memo Matching Report lists credit memos and debit memos for suppliers and the invoices to which the credit memos and debit memos are matched.

The following figures provide an example of one page from the report.

The Payables Credit Memo Matching Report Part 1
is illustrated in this graphic.The Payables Credit Memo Matching Report Part 2
is illustrated in this graphic.

Key Insights

The report lists credit memo and debit memo details at the invoice distribution level, and amounts in both the entered and ledger currencies.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Credit Memo Matching Report.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane navigate to Shared Folders > Financials > Payables > Invoices.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to check the credit memos and debit memos that were created for a supplier or group of suppliers.

What can I do with this report?

Review credit memo and debit memo line information.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Payables Invoice Aging Report

This topic includes details about the Payables Invoice Aging Report.

Overview

The Payables Invoice Aging Report lists unpaid invoices according to specified aging periods.

The following figure is an example of the report.

The Payables Invoice Aging Report is illustrated
in this graphic.

Key Insights

The report provides the break down of the accounts payable balance across aging buckets that you can configure. Before running this report, create aging periods on the Create Aging Periods page and run the Apply Missing Conversion Rates process to provide missing conversion rate information.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Invoice Aging Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Run the report to review the outstanding amounts due to a supplier, and for how long the invoice installments have been due.

What can I do with this report?

You can run this report for a business unit, supplier, invoice type, and aging period. You also have various sorting options and can specify whether to include invoice and supplier site details.

What type of report is this?

Oracle Business Intelligence Publisher

Supplier Balance Aging Report: Explained

This topic includes details about the Supplier Balance Aging Report.

Overview

The Supplier Balance Aging Report list the supplier invoices according to specified aging periods. The report provides the breakdown of the accounts payable balance across aging buckets that you configure in the aging periods. If you use multiple currencies, the report converts the invoice amounts to the ledger currency using the conversion rate provided on the invoice.

Note: Before running this report, create the invoice aging periods on the Create Aging Periods page and run the Create Accounting process with the option to transfer the balances to General Ledger.

The following image is an example of the report:

The Supplier Balance Aging Report is illustrated
in this graphic.

Key Insights

This report allows user to generate the Supplier Balance Aging Report for any specific date. The aging report considers only those supplier invoices that are accounted and transferred to the General Ledger and as a result the balances in this report match up with the trial balance report.

  • This report has a column Unallocated Amount. Invoice amounts are displayed in this column based on specific data scenarios listed in the following: The amount isn't within the range of the defined aging buckets for payment due.

  • The outstanding amount for the invoice and the installment don't match. This can happen when one of the amounts is displayed as a positive amount and the other as a negative amount.

  • The payment amount is greater than the invoice amount. This can happen when the invoice distributions have different accounting dates and the invoice or installment has been paid in between the accounting dates.

Note: You should review and take the necessary action to correct.

Frequently Asked Questions

The following table lists frequently asked questions about the Supplier Balance Aging Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Run the report to review the outstanding amounts due to a supplier, and for how long the invoice installments have been due.

What can I do with this report?

You can run this report for a business unit, supplier, invoice type, and aging period. You also have various sorting options and can specify whether to include invoice and supplier site details.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Invoice Audit by Voucher Number Listing

This topic includes details about the Payables Invoice Audit by Voucher Number Listing.

Overview

The Payables Invoice Audit by Voucher Number Listing lists invoices with assigned sequential voucher numbers.

The following figures provide an example of one page from the report.

The Payables Invoice Audit by Voucher Number Listing
Part 1 is illustrated in this graphic.The Payables Invoice Audit by Voucher Number Listing
Part 2 is illustrated in this graphic.

Key Insights

The report lists the invoices created for a document sequence and the missing voucher numbers for a particular sequence.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Invoice Audit by Voucher Number Listing.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use the report to audit the invoices that were entered for a document sequence.

What can I do with this report?

You can run the report for a sequence with a specified range of voucher numbers.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Payables Invoice Audit Listing

This topic includes details about the Payables Invoice Audit Listing.

Overview

The Payables Invoice Audit Listing lists invoices based on a specified amount, for a given supplier and range of invoice creation dates.

The following figures provide an example of one page from the report.

The Payables Invoice Audit Listing Part 1 is illustrated
in this graphic.The Payables Invoice Audit Listing Part 2 is illustrated
in this graphic

Key Insights

The report helps identify invoices that may have been entered in the application more than once.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Invoice Audit Listing.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to check that duplicate invoices weren't entered for the same supplier.

What can I do with this report?

  • Review for duplicate invoices.

  • Submit the report for invoices after a specific date, more than a specific amount, and for specific invoice types.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Payables Invoice Register

This topic includes details about the Payables Invoice Register.

Overview

The Payables Invoice Register provides detailed information about invoices.

The following figures are an example of one page of the report from the Reports and Analytics pane.

The Payables Invoice Register from Reports and
Analytics Pane Part 1 is illustrated in this graphic.The Payables Invoice Register from Reports and
Analytics Pane Part 2 is illustrated in this graphic.

The following figure is an example of the report from the Scheduled Processes work area.

The Payables Invoice Register from Oracle Business
Intelligence Publisher is illustrated in this graphic.

Key Insights

Use this report to cross-check invoices entered in the application with the physical invoices that were used to enter those invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Invoice Register.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Daily to cross check invoice data entry in the application against the invoice on which the entry was made.

What can I do with this report?

Run the report for a specific invoice group, date range, accounting period. You can also specify an invoice status, such as validated or canceled.

What type of report is this?

Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Payables Key Indicators Report

This topic includes details about the Payables Key Indicators Report.

Overview

The Payables Key Indicators Report generates reports with transaction activity, and the current number of suppliers, invoices, payments, and matching holds.

The following figure is an example of the report.

The Payables Key Indicators Report is illustrated
in this graphic.

Key Insights

The report provides summary information for key indicators, such as the number of invoices and payments entered, and the modifications made for those transactions during a period.

Frequently Asked Questions

The following table list frequently asked questions about the Payables Key Indicators Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Periodically to get activity details for a period, such as the number of invoices created and percentage of invoices modified. You can also review exceptions for invoices, payments, and reconciliation.

What can I do with this report?

  • Run the report for a business unit and period.

  • Specify whether to include invoice details.

What type of report is this?

Oracle Business Intelligence Publisher

Approval Groups Report

This topic includes details about the Approval Groups Report.

Overview

You can now use the Approvals Group Report to view the approval groups defined in Oracle Business Process Management (BPM). You can view the report output in both spreadsheet and XML format.

Key Insights

You can obtain the details of the group name, the approvers, and the sequence in which the approvers appear in the approval group.

Report Parameters

There are no parameters that you need to select for this report.

Frequently Asked Questions

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Workflow Rules Administrator

When do I use this report?

Use this report to review approval groups defined in BPM.

What type of a report is this?

Spreadsheet, XML

Workflow Rules Report

This topic includes details about the Workflow Rules Report.

Overview

You can now use the Workflow Rules Report to view the workflow rules configured in Oracle Business Process Management (BPM) for Payables Invoice Approval, General Ledger Journal Approval, and Expense Report Approval workflows. You can view the report output in both spreadsheet and XML format.

Key Insights

You can use this report to obtain details of the stage, participant, rule status, rule conditions, and approval routing for each rule.

Report Parameters

Parameter Description

Workflow

You can select the workflow for which you want to review the workflow rules.

Frequently Asked Questions

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Workflow Rules Administrator

When do I use this report?

Use this report to review existing workflow rules defined in BPM.

What type of a report is this?

Spreadsheet, XML

Payables Matched and Modified Receipts Report

This topic includes details about the Payables Matched and Modified Receipts Report.

Overview

The Payables Matched and Modified Receipts Report identifies the receipts that were modified after invoice matching.

The following figure is an example of the report.

The Payables Matched and Modified Receipts Report
is illustrated in this graphic.

Key Insights

The report lists the receipts that were modified after an invoice was created. Information in this report helps you take further action, such as creating a debit memo if you returned some quantity of the receipt to the supplier.

Frequently Asked Questions

The following table list frequently asked questions about the Payables Matched and Modified Receipts Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically for details of receipt numbers that were modified after an invoice was created.

What can I do with this report?

Run the report for a business unit and receipt date range. You can also run the report for a supplier and supplier site.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Matching Detail Report

This topic includes details about the Payables Matching Detail Report.

Overview

The Payables Matching Detail Report provides details of how an invoice, purchase order, or receipt, was matched.

The following figure is an example of the report.

The Payables Matching Detail Report is illustrated in
this graphic.

Key Insights

The report provides details of transactions that were created against an invoice and its related documents, such as a purchase order or receipt. For example, you can get the list of all the invoices that were matched against a purchase order, or similarly the list of all the purchase orders against which an invoice was matched.

Frequently Asked Questions

The following table list frequently asked questions about the Payables Matching Detail Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

When you want to review details of how an invoice, or its related purchase orders or receipts, was created.

What can I do with this report?

  • Resolve matching errors and holds that may be placed on an invoice.

  • Run this report for a specific transaction, and for all the transactions of a business unit.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Matching Hold Detail Report: Explained

This topic includes details about the Payables Matching Hold Detail Report.

Overview

The Payables Matching Hold Detail Report provides detailed payables and purchasing information for invoices with matching holds and matching hold releases.

The following figure is an example of the report.

The Payables Matching Hold Detail Report is illustrated
in this graphic.

Key Insights

The report lists the matching holds that were placed on an invoice, along with corresponding hold release details. The report helps identify the list of suppliers who often send invoices outside the tolerance percentage, resulting in matching holds. You can streamline your processes by contacting these suppliers and resolving the issues that cause the matching holds.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Matching Hold Detail Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Run the report when you want to review the reasons that matched invoices went on hold.

What can I do with this report?

Use the report to identify suppliers that frequently have invoices on matching hold. You can run this report for a supplier and for a data range.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Negative Supplier Balance Report: Explained

This topic includes details about the Payables Negative Supplier Balance Report.

Overview

The Payables Negative Supplier Balance Report lists suppliers with negative balances, and the invoices and credit or debit memo transactions, for the balance.

The following figure is an example of the summary page from the report.

The Payables Negative Supplier Balance Report Summary
is illustrated in this graphic.

The following figure is an example of the details page from the report.

The Payables Negative Supplier Balance Report Details
is illustrated in this graphic.

Key Insights

The report helps identify the list of suppliers with negative balances.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Negative Supplier Balance Report.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Invoices.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to identify the list of suppliers with a negative closing balance.

What can I do with this report?

  • Run this report for a business unit and liability account.

  • This report provides information to help you take the appropriate action. For example, the standard invoices for some suppliers might not have been entered, or advance payments were made, but the supplier didn't send the invoice for the expenses incurred.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

The summary section of the report uses the Payables Invoices - Trial Balance Real Time subject area. The detailed section of the report uses the Payables Invoices - Transactions Real Time subject area.

Payments

Payables Cash Requirement Report

This topic includes details about the Payables Cash Requirement Report.

Overview

The Payables Cash Requirement Report forecasts immediate cash needs for invoice payments.

The following figure is an example of the report.

The Payables Cash Requirement Report.

Key Insights

The report identifies the cash required for making a payment in a payment batch.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Cash Requirement Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Before every payment process request to determine cash requirements for that request.

What can I do with this report?

  • Use the information to configure multiple payment process request templates.

  • Forecast cash requirements for a specific period, such as 30 days, by defining a payment process request template with the applicable parameters.

What type of report is this?

Oracle Business Intelligence Publisher

Import Payables Payment Requests Report

This topic includes details about the Import Payables Payment Requests Report.

Overview

Use this report to view the payment requests imported or rejected with rejection reasons. When you run the Import Payables Payment Request process this report is generated automatically. The report can be submitted in both summary and detail versions.

The following image is an example of the report:

The Payables Payment Request Import Report is illustrated
in this graphic.

Key Insights

The report is divided into the following sections:

Payables Payment Requests Audit Report

  • List all imported payment request.

Payables Payment Request Rejections Report

  • Party Rejections

  • Address Rejections

  • Bank Rejections

  • Payment Requests Rejections

Frequently Asked Questions

The following table lists frequently asked questions about the Import Payables Payment Requests Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Run the report to review the request for payment.

What can I do with this report?

Review the payment request and rejections for payment.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Discounts Taken and Lost Report

This topic includes details about the Payables Discounts Taken and Lost Report.

Overview

The Payables Discounts Taken and Lost Report identifies payments where a discount was taken and payments where a discount was available, but not taken.

The following figures provide an example of one page of the report from the Reports and Analytics pane.

The Payables Discount Taken and Lost Report Part
1 is illustrated in this graphic.The Payables Discounts Taken and Lost Report Part
2 is illustrated in this graphic.

The following figure is an example of the report from the Scheduled Processes work area.

The Payables Discount Taken and Lost Report from
the Scheduled Processes Work Area is illustrated in this graphic.

Key Insights

View a summary of each payment line for a supplier site.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Invoice Register.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payments.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to check for available discounts and discounts that were lost.

What can I do with this report?

Use the information to identify invoices with lost discounts and decide whether you can benefit from taking these discounts.

What type of report is this?

Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the following subject areas:

  • Payables Invoices - Transactions Real Time

  • Payables Payments - Disbursements Real Time

Payables Payment Register: Explained

This topic includes details about the Payables Payment Register.

Overview

The Payables Payment Register provides detailed information about payments.

The following figure is an example of one page of the report from the Reports and Analytics pane.

The Payables Payment Register from Reports and
Analytics Pane Part 1 is illustrated in this graphic.The Payables Payment Register from Reports and
Analytics Pane Part 2 is illustrated in this graphic.

The following figure is an example of the report from the Scheduled Processes work area.

The Payables Payment Register from the Scheduled
Processes Work Area is illustrated in this graphic.

Key Insights

The report lists all of the payments made for a date range.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Payment Register.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu, or from the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payments.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Daily to cross reference the created payment checks with the report.

What can I do with this report?

Run the report for a specific supplier, date range, bank account, and payment currency.

What type of report is this?

Oracle Business Intelligence Publisher and Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Payments - Disbursements Real Time subject area.

Payables Selected Installments Report: Explained

This topic includes details about the Payables Selected Installments Report.

Overview

The Payables Selected Installments Report lists all the invoice installments that are selected in a payment process request.

The following figure is an example of the report.

The Payables Selected Installments Report displays
the number of invoices and amounts based on currency.

Key Insights

The report provides a total payment amount for each currency.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Selected Installments Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Whenever you submit a payment process request.

What can I do with this report?

Use the report to help determine how well the selection criteria is identifying the correct invoices to pay.

What type of report is this?

Oracle Business Intelligence Publisher

Payment Audit by Voucher Number Report: Explained

The Payment Audit by Voucher Number Report lists payments by sequential voucher numbers.

The following figure is an example of the report.

The Payment Audit by Voucher Number Report is illustrated
in this graphic.

Key Insights

The report helps identify the payments created for a document sequence and any missing voucher numbers for a particular sequence.

Frequently Asked Questions

The following table lists frequently asked questions about the Payment Audit by Voucher Number Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

When you want to audit the payments that were entered for a document sequence.

What can I do with this report?

Run the report for a sequential range of voucher numbers.

What type of report is this?

Oracle Business Intelligence Publisher

Update Matured Bills Payables Status Report: Explained

This topic includes details about the Update Matured Bills Payables Status Report.

Overview

The Update Matured Bills Payables Status Report provides information about the Update Matured Bills Payable process, which updates the status of matured bills payables from issued to negotiable.

The following figure is an example of the report.

The Update Matured Bills Payables Status Report
is illustrated in this graphic.

Key Insights

The report lists the payments that were issued along with the maturity date of each payment.

Frequently Asked Questions

The following table lists frequently asked questions about the Update Matured Bills Payables Status Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically for information on payments that haven't matured yet.

What can I do with this report?

You can run this report for a bank account or supplier to determine the list of payments that were issued and not negotiable.

What type of report is this?

Oracle Business Intelligence Publisher

Payables to Ledger Reconciliation

Payables to Ledger Reconciliation Report: Explained

This topic includes details about the Payables to Ledger Reconciliation Report.

Overview

The Payables to Ledger Reconciliation Report lists the journals posted to the general ledger for open balances. The report facilitates the reconciliation of accounting and transactional data recorded in Payables and Oracle Fusion Subledger Accounting.

The following figure is an example of the report.

The Payables to Ledger Reconciliation Report is
illustrated in this graphic.

Key Insights

The interactive reporting capability of the Payables to Ledger Reconciliation Report provides both summarized and detailed reconciling data for review. The Summary report lets you view payables and accounting beginning and ending balances, summarized activity for the period, and how the activity was accounted.

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Payables to Ledger Reconciliation.

Who uses this report?

Financial Manager

When do I use this report?

During the Payables period close process.

What can I do with this report?

You can reconcile payables data to the general ledger.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Subledger Accounting - Payables Summary Reconciliation Real Time subject area.

Considerations For Payables to General Ledger Reconciliation Report

Use the Payables to General Ledger Reconciliation report to facilitate the reconciliation of payables data to the general ledger. The interactive reporting capability of the Payables to General Ledger Reconciliation report provides both summarized and detailed reconciling data for review.

The summary shows payables and accounting beginning and ending balances, summarized activity for the period, and how the activity was accounted. You can drill down on any amount in the summary Difference column to see the Differences Detail report for that item. The Differences Detail report displays the real-time details that make up the summary balance and indicates potential causes for differences between actual and reconciling amounts.

To view the report, you must select a ledger and request name, which is the name from the Prepare Payables to General Ledger Reconciliation process.

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

Consider these points when using the Payables to General Ledger Reconciliation report.

  • Differences Between Transactional and Accounted Amounts

  • Differences Between Summary and Detail Amounts

  • Differences Between the Reconciliation Report and Other Payables Reports

  • Differences Due to Rounding

  • Variances Due to Transactions not Validated

Differences Between Transactional and Accounted Amounts

Ideally the payables transactional amounts and the accounted amounts on the report summary should be the same. The Payables Begin Balance accounting amount should agree with the Payables Trial Balance report for the last day of the previous period. The Payables End Balance accounting amount should agree with the Payables Trial Balance report for the last day of the period being reconciled.

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

  • Transactions that aren't accounted.

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

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

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

  • Subledger journals that aren't transferred or posted to general ledger.

After finding and correcting discrepancies, you must rerun the Prepare Payables to General Ledger Reconciliation process and review the reconciliation report summary.

Note: The report summary may contain variance amounts if the Payables Begin Balance plus the period activity differ from the Payables End Balance. This applies to both the Payables Amount and the Accounting Amount. If after reviewing the data the variance can't be explained, contact the help desk.

Differences Between Summary and Detail Amounts

The Non-Payables Begin Balance on the report summary is that portion of the general ledger liability account beginning balance that didn't originate from Payables transactions. You can drill down from the beginning balance amount to the general ledger journal lines. The accounting date for the journal lines falls within the current fiscal year, but prior to the period for the reconciliation report.

Note: The drill-down page doesn't include non-Payables journal lines from previous fiscal years, so the journal lines might not match the Non-Payables Begin Balance amount. The drill-down page is intended to provide only current fiscal year journals that might have posted erroneously to the payables account.

The source for these journal lines is typically not Payables. However, you may see manual subledger journal entries with the Payables source entered directly in the subledger, but not necessarily linked to a Payables transaction. Most of these entries represent adjustments.

Manual subledger journals created during the current reconciling period display on the report summary in the Other Accounting amount. These journals become part of the Non-Payables Begin Balance amount in subsequent periods. Manual general ledger journals that may affect payables accounts and are created directly in the general ledger display in the Non-Payables Activity amount.

Summary amounts might not reflect totals on detail pages for one of the following reasons:

  • Data was modified after the Prepare Payables to General Ledger Reconciliation process was run for a given accounting period. For example, transactions or accounting was created between the time the process was run and the moment you drill down from summary to detail.

Note: Discrepancies might still exist if accounting activities occur in the subledger or general ledger after the Prepare Payables to General Ledger Reconciliation process is run. Oracle recommends that you perform these accounting activities prior to closing the Payables period and running the preparation process.
Tip: To limit discrepancies between the summary and detail reports, set the Payables accounting period status to Closed or Permanently Closed.
  • Security rules in your setup may restrict you from viewing data from certain business units or segment values. Oracle recommends that appropriate security be given to users for all business units and accounting flexfield segment values that each user is responsible for reconciling.

  • If you're downloading a large amount of data and plan to perform a number of data manipulations, use the CSV format. If you're downloading data for reference purposes only, use the Excel format.

Differences Between the Reconciliation Report and Other Payables Reports

Data on the Payables to General Ledger Reconciliation report might differ from the following Payables reports:

  • Payables Aging Report, Payables Invoice Register, Payables Payment Register: You can't exclude intercompany transactions from the aging report or the registers. If you run the reconciliation report and exclude intercompany transactions, or show only intercompany transactions, then the reports display incompatible data.

  • Payables Aging Report: The reconciliation report displays payables balances for the first and last date of a period. You can run the aging report for the current date only.

Differences Due to Rounding

Fully paid invoices could have rounding differences. The sum of the entered amounts for the invoice distributions and the sum of the entered amounts for the invoice payment might not match.

The total accounted amounts of the invoice and payment liabilities for a fully paid invoice always match. Rounding differences between the original invoice liability amount and the sum of the payment liabilities are automatically written off. The write-off occurs when the final payment, or prepayment application, is accounted.

However, because the payables amounts are taken from the invoice distributions and invoice payments, rounding differences can appear on the report summary. These differences are included in the Payment Variance amount in the Payables Amount column on the report summary.

Variances Due to Transactions not Validated

On the report summary, the Payables Begin Balance and Payables End Balance amounts include validated transactions only. Unvalidated transactions are included in the Payables Variance amount.

Note: Unvalidated transactions are transactions that are incomplete or that have validation issues, such as invalid accounts or amount variances that must be corrected.

For example, if the current period has 200 USD of unvalidated invoice transactions, the report displays the following:

  • Payables Begin Balance = 10,000 USD

  • Invoices = 1,200 USD

  • Payables Variance = 200 USD

  • Payables End Balance = 11,000 USD

Note: The Invoices Detail report includes unvalidated transactions, so you can review the report to identify the unvalidated and unaccounted transactions.

Considerations For Setting Up for Payables to General Ledger Reconciliation

Periodically you reconcile the transactions in your accounts payable application, both before and after you post to the general ledger. The Payables to General Ledger Reconciliation preparation process and report help simplify reconciliation and reduce the amount of manual reconciling activity required.

The automated activities in the reconciliation process function according to your Oracle Fusion Financials setup. A review of some of these setups can help improve the overall reconciliation process.

Consider these points when setting up the Oracle Fusion Payables to general ledger reconciliation.

  • Reconciling by Business Unit or Ledger

  • Assigning the Financial Category

  • Setting the Reconciliation Data Purge Frequency Profile Option

  • Configuring User Security

Reconciling by Business Unit or Ledger

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

If you don't implicitly map primary balancing segment values to business units, you must reconcile based on ledger. In this case, you must have access to all business units associated with the ledger to perform a thorough reconciliation. You must also reconcile by ledger if you centralize payment processing using the service provider model.

Assigning the Financial Category

You must assign the financial category of Accounts Payable to all of your liability natural account values. You perform this task on the Manage Values page for the value set associated with the natural account segment of your chart of accounts.

Note: To include bills payable, intercompany, and tax authority liability accounts on the reconciliation report, you can also assign them the Accounts Payable category.

After you assign the category, you can leave the Account parameter blank when you run the Prepare Payables to General Ledger Reconciliation process. The process includes all accounts that have a financial category of Accounts Payable in the ledger. You can alternatively enter specific natural account values to limit the report to reconciling only a subset of the payables accounts in the ledger.

Note: You must assign the category to a natural account in your chart of accounts to see information about the Payables to General Ledger Reconciliation report.

Setting the Reconciliation Data Purge Frequency Profile Option

Use the Reconciliation Data Purge Frequencyprofile option to specify the number of days to keep reconciliation data. You may want to keep the data for comparison purposes.

When you run the Prepare Payables to General Ledger Reconciliation process, the process refers to the value of the Reconciliation Data Purge Frequency profile option. Any reconciliation data requests older than the number of days specified in the profile option are purged from the tables.

For example, you set the profile to 30 days and submit the preparation process on January 1. If you submit the process again on January 29, the data isn't purged. However, the data is purged if you submit the process on February 1.

Configuring User Security

Typically General Ledger users are secured by data access sets. Data access sets use primary balancing segment values to secure access to ledgers, ledger sets, and portions of ledgers. Payables users are secured by business units.

For the Payables to General Ledger Reconciliation report:

  • General Ledger users can see general ledger data for the balancing segment values in their data access set. General Ledger users can also see the Payables or Oracle Fusion Subledger Accounting data for all business units linked to the ledger.

  • Payables users can see the Payables and Subledger Accounting data for business units in their security definition. Payables users can also see general ledger data for all balancing segment values in the ledger.

The data roles for the General Ledger or Payables job roles can affect the reconciliation report. If data roles grant access to specific business units for General Ledger users or specific data access sets for Payables users, the report only includes:

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

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

If business units and balancing segment values are implicitly mapped, the report should work properly. Users can filter the report for the balancing segment values that are mapped to the business units to which they have access.

If business units and balancing segment values aren't intentionally or implicitly mapped, the Payables to General Ledger Reconciliation report could display the following unintended results:

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

  • For Payables users, one possible outcome is that the report doesn't include any general ledger data. Another outcome is that the report includes general ledger data that isn't properly mapped to the Payables or Subledger Accounting data for the business unit.

You can resolve this issue. Remove the access granted to specific business units for the General Ledger job roles, and the specific data access sets for the Payables job roles.

FAQs for Payables Reports

How can I report invoices for merged suppliers on the Payables to Ledger Reconciliation report?

Set the Third-Party Merge Accounting option to Replace third party on the Manage Subledger Accounting Options page. Otherwise, an accounting variance could appear on the Payables to Ledger Reconciliation report for journal lines that are attributed to merged suppliers.

Why did the export download only some of the rows on the Payables to Ledger Reconciliation report drill-down page?

The export downloads only the rows that display on the page.

For example, if the Invoices drill-down page has 1,000 rows and the page displays 25 rows at a time, the export to Excel downloads 25 rows.

Oracle Business Intelligence Enterprise Edition has a setting that controls the number of rows that display on a page. For more information on manually configuring settings for data in views, see the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Period Close

Payables Open Items Revaluation Report: Explained

This topic includes details about the Payables Open Items Revaluation Report.

Overview

The Payables Open Items Revaluation Report lists changes in the value of open items, such as unpaid invoices and credit memos, due to conversion rate fluctuations.

The following figure is an example of the report.

The Payables Open Items Revaluation Report is illustrated
in this graphic.

Key Insights

The report identifies the list of open invoices that may have to be adjusted for currency conversion rate differences.

Frequently Asked Questions

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

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Before the period close.

What can I do with this report?

Use the report to revalue open item balances.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Period Close Exceptions Report: Explained

This topic includes details about the Payables Period Close Exceptions Report.

Overview

The Payables Period Close Exceptions Report lists exceptions that prevent the Payables accounting period from closing.

The following figure is an example of the report.

The Payables Period Close Exceptions Report is
illustrated in this graphic.

Key Insights

The report provides details of the transactions that prevent the Payables period from closing.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Period Close Exceptions Report.

FAQ Answer

How do I find this report?

The Payables Period Close process automatically generates this report. You can also run the report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

During the period close process.

What can I do with this report?

You can run this report to determine the list of transactions that prevent the period from closing. You also have the option of sweeping the transactions to the next period.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Posted Invoice Register: Explained

This topic includes details about the Payables Posted Invoice Register.

Overview

The Payables Posted Invoice Register lists accounting lines for invoices that have been transferred to the general ledger.

The following figures are an example of one page from the report.

The Payables Posted Invoices Register Part 1 is
illustrated in this graphic.The Payables Posted Invoices Register Part 2 is
illustrated in this graphic.

Key Insights

The reports lists the invoices that were accounted for a period and is used as a part of period close activities.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Posted Invoice Register.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Period Close.

Who uses this report?

Financial Manager

When do I use this report?

During the period close process.

What can I do with this report?

Use this report, along with the following reports, to reconcile balances between Oracle Fusion Payables and your general ledger:

  • Payables Posted Payment Register

  • Payables Trial Balance Report

  • Payables to Ledger Reconciliation Report

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the following subject areas:

  • Payables Invoices - Transactions Real Time

  • Payables Invoices - Prepayment Applications Real Time

Payables Posted Payment Register: Explained

This topic includes details about the Payables Posted Payment Register.

Overview

The Payables Posted Payments Register lists accounting lines for payments that have been transferred to the general ledger.

The following figures provide an example of one page from the report.

The Payables Posted Payment Register Part 1 illustrated
in this graphic.The Payables Posted Payment Register Part 2 is
illustrated in this graphic.

Key Insights

The reports lists the payments that were accounted for a period and is used as a part of period close activities.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Posted Payment Register.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Period Close.

Who uses this report?

Financial Manager

When do I use this report?

During the period close process.

What can I do with this report?

Use this report, along with the following reports, to reconcile balances between Oracle Fusion Payables and your general ledger:

  • Payables Posted Invoice Register

  • Payables Trial Balance Report

  • Payables to Ledger Reconciliation Report

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Payments - Disbursement Real Time subject area.

Payables Trial Balance Report: Explained

This topic includes details about the Payables Trial Balance Report.

Overview

The Payables Trial Balance Report lists and subtotals, by supplier and liability account, all unpaid and partially paid invoices that Oracle Fusion Payables transferred to the general ledger.

The following figure is an example of the report.

The Payables Trial Balance Report is illustrated
in this graphic.

Key Insights

The report identifies the accounts payable balance at period end and provides the invoice details that comprise that balance.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Trial Balance Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

During the period close process.

What can I do with this report?

Cross check the accounts payable liability balance with the accounts payable liability balance in the general ledger.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Unaccounted Transactions and Sweep Report: Explained

This topic includes details about the Payables Unaccounted Transactions and Sweep Report.

Overview

The Payables Unaccounted Transactions and Sweep Report lists invoices and payments that weren't accounted for a period or date range.

The following figure is an example of the report.

The Payables Unaccounted Transactions and Sweep
Report is illustrated in this graphic.

Key Insights

The report provides the option of sweeping the unaccounted transactions to the next period.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Unaccounted Transactions and Sweep Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

During the period close process.

What can I do with this report?

  • Identify and review all unaccounted invoice and payment transactions.

  • Sweep unaccounted transactions to another period.

What type of report is this?

Oracle Business Intelligence Publisher

Prepayments

Prepayment Remittance Notice

This topic includes details about the Prepayment Remittance Notice.

Overview

The Prepayment Remittance Notice lists prepayments that were applied to supplier invoices.

The following figure is an example of the report.

The Prepayment Remittance Notice is illustrated
in this graphic.

Key Insights

Identify the list of open prepayments per supplier and the amount remaining to be applied.

Frequently Asked Questions

The following table lists frequently asked questions about the Prepayment Remittance Notice.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to get the list of prepayments that are already paid but for which there is no supplier invoice, or the prepayment hasn't been applied to any standard invoice yet.

What can I do with this report?

Send it to the supplier as a reminder to send you any outstanding invoices that may be due against the advance payments.

What type of report is this?

Oracle Business Intelligence Publisher

Income Tax and Withholding

Payables Withholding Tax by Tax Authority Report: Explained

This topic includes details about the Payables Withholding Tax by Tax Authority Report.

Overview

The Payables Withholding Tax by Tax Authority Report lists withholdings for tax codes assigned to a tax authority.

The following figure is an example of the report.

The Payables Withholding Tax by Tax Authority Report
is illustrated in this graphic.The second page is illustrated in this graphic.

Key Insights

The report lists withholding tax information for withholding tax codes that have amounts withheld.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Withholding Tax by Tax Authority Report.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Income Tax and Withholding.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically, to determine withholding amounts for each withholding authority.

What can I do with this report?

  • Review detailed withholding tax information for withholding tax codes assigned to a supplier with a type of Tax Authority.

  • Use the information to satisfy management, supplier, and tax authority reporting requirements.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Payables Withholding Tax Letter: Explained

This topic includes details about the Payables Withholding Tax Letter.

Overview

The Payables Withholding Tax Letter is a letter that you can mail to a supplier periodically. The letter contains a list of withholdings made for the supplier summarized either by tax type and tax rate, or by supplier site

The following figure is an example of the report.

The Payables Withholding Tax Letter is illustrated
in this graphic.

Key Insights

The letter provides details of the withholding amounts for various withholding codes that were deducted for a period.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Withholding Tax Letter.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Periodically to send suppliers details of withholdings that were deducted for a period.

What can I do with this report?

You can run this report for an individual supplier, all suppliers, or for a supplier type. You can also specify a date range for the withholding information.

What type of report is this?

Oracle Business Intelligence Publisher

Payables Withholding Tax Report: Explained

This topic includes details about the Payables Withholding Tax Report.

Overview

The Payables Withholding Tax Report lists the withholdings for a supplier. The report has an invoice view and a supplier view. The invoice view is used to review detailed withholding tax information by invoice. The supplier view is used to review withholding information for a range of suppliers.

The following figures provide an example of one page from the report.

The Payables Withholding Tax Report Part 1 is illustrated
in this graphic.The Payables Withholding Tax Report Part 2 is illustrated
in this graphic.

Key Insights

The report lists the invoices that have withholding deductions.

Frequently Asked Questions

The following table lists frequently asked questions about the Payables Withholding Tax Report.

FAQ Answer

How do I find this report?

From the Reports and Analytics pane, navigate to Shared Folders > Financials > Payables > Income Tax and Withholding.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

Periodically to get details of the withholdings that were deducted an invoice.

What can I do with this report?

  • The default grouping for the report is by invoice, but you can also group the report by supplier.

  • You can run the report for a supplier or supplier type, and a date range.

What type of report is this?

Oracle Transactional Business Intelligence

Related Subject Areas

This report uses the Payables Invoices - Transactions Real Time subject area.

Update and Report Income Tax Details

This topic includes details about the Update and Report Income Tax Details report.

Overview

The report updates or reports on income tax type or income tax region fields on invoice distributions for United States (US) 1099 reporting.

The following figure is an example of the report.

The Update and Report Income Tax Details is illustrated
in this graphic.

Key Insights

The report updates existing invoice distributions with income tax type and income tax region information from the supplier setup.

Frequently Asked Questions

The following table lists frequently asked questions about the Update and Report Income Tax Details report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Periodically to update the income tax details on invoice distributions that are used for US 1099 reporting.

What can I do with this report?

You can run this report to update income tax details using the supplier setup for US 1099 reporting. Income tax details might not be available when an invoice is created so you can use this report to update the data.

What type of report is this?

Oracle Business Intelligence Publisher

US 1096 Report: Explained

This topic includes details about the United States (US) 1096 Report.

Overview

The US 1096 Report summarizes each US 1099 form type that's transmitted on paper, as required by the US Internal Revenue Service, and generates the summary on a preformatted Internal Revenue Service form.

The following figure is an example of the report.

The US 1096 Report is illustrated in this graphic.

Key Insights

Before running this report, you must run the US 1099 Report.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1096 Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Annually for US 1099 reporting.

What can I do with this report?

Send the report to the Internal Revenue Service.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Electronic Media Report: Explained

This topic includes details about the United States (US) 1099 Electronic Media Report.

Overview

The US 1099 Electronic Media Report generates summarized US 1099 information in electronic format, as required by the United States Internal Revenue Service.

The following figure is an example of the report.

The US 1099 Electronic Media Report is illustrated
in this graphic.

Key Insights

Before running the report, account for the invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Electronic Media Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Annually for US 1099 reporting.

What can I do with this report?

Send the output to the Internal Revenue Service.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Forms (Comma Delimited Format): Explained

This topic includes details about the United States (US) 1099 Forms (Comma Delimited Format).

Overview

The US 1099 Forms (Comma Delimited Format) lists the total US 1099 miscellaneous tax type payments for US 1099 suppliers in a comma delimited format.

The following figure is an example of the report.

The US 1099 Comma Delimited Format is illustrated
in this graphic.

Key Insights

Before running the report, account for the invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Forms (Comma Delimited Format).

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Annually for US 1099 reporting.

What can I do with this report?

Report on the total US 1099 miscellaneous payments for US 1099 suppliers.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Invoice Exceptions Report: Explained

This topic includes details about the United States (US) 1099 Invoice Exceptions Report.

Overview

The US 1099 Invoice Exceptions Report lists paid invoice distributions with inaccurate or missing US 1099 income tax information.

The following figure is an example of the report.

The US 1099 Invoice Exceptions Report is illustrated
in this graphic.

Key Insights

Before running this report, account for the invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Invoice Exceptions Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Before submitting the US 1099 Report.

What can I do with this report?

Identify invoice distributions that are exceptions to the US 1099 reports.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Payments Report: Explained

This topic includes details about the United States (US) 1099 Payments Report.

Overview

The US 1099 Payments Report lists payments made to US 1099 reportable suppliers.

The following figure is an example of the report.

The US 1099 Payments Report is illustrated in this
graphic.

Key Insights

Before running the report, account for the invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Payments Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Annually for US 1099 reporting.

What can I do with this report?

Reconcile the report to the US 1099 forms or prepare additional reporting.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Report: Explained

This topic includes details about the United States (US) 1099 Report.

Overview

The US 1099 Report provides the total US 1099 miscellaneous payments for a US 1099 supplier and generates US 1099 forms for each tax reporting entity in an organization.

The following figure is an example of the report.

The US 1099 Report is illustrated in this graphic.

Key Insights

The report includes payments for invoice distributions that have one of the following 1099 MISC types in the Income Tax Type field: MISC types 1 through 14, except for MISC9, MISC11, and MISC12.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Annually for US 1099 reporting.

What can I do with this report?

  • Report on the total US 1099 miscellaneous payments for US 1099 suppliers.

  • Generate US 1099 forms on preformatted forms from the Internal Revenue Service for each tax reporting entity in the organization.

What type of report is this?

Oracle Business Intelligence Publisher

US 1099 Supplier Exceptions Report: Explained

This topic includes details about the United States (US) 1099 Supplier Exceptions Report.

Overview

The US 1099 Supplier Exceptions Report lists suppliers with inaccurate or incomplete US 1099 income tax information.

The following figure is an example of the report.

The US 1099 Supplier Exceptions Report is illustrated
in this graphic.

Key Insights

Before running this report, account for the invoices.

Frequently Asked Questions

The following table lists frequently asked questions about the US 1099 Supplier Exceptions Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

Financial Manager

When do I use this report?

Before submitting the US 1099 Report.

What can I do with this report?

Review suppliers with inaccurate or incomplete US 1099 income tax information and correct them before generating the US 1099 forms.

What type of report is this?

Oracle Business Intelligence Publisher

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.