Customer Balance Reconciliation Report for Russia

Overview

This report is required by and complies with the legislation in Russia. Each organization must periodically reconcile settlements with customers based on the Act of Reconciliation of Balance between Customer and Supplier. This report lists all receivables documents, that is invoices and payments, for the period.

The supplier prints the report with the information about the customer's balance based on their book and sends it to the customer. The customer confirms or corrects the figures based on their book and sends it back. These corrections are entered under the third-party column headings. In case of any difference, the clarification process must be performed. The supplier must include only reconciled or confirmed balances into the accounting reporting.

This figure is an example of the report.

Key Insights

To provide additional flexibility, the Customer Balance Reconciliation report uses data from the Subledger Accounting (SLA) supporting references to update the Agreement (description, number, date), Date by Organization, and Number by Organization.

If the SLA supporting reference called FIN_JE_RU_CONTRACT is set, the Agreement (description, number, date) column of the report is updated with the data from supporting reference. Else, the column is left blank.

If FIN_JE_RU_CBRR_DOC_NUM and FIN_JE_RU_CBRR_DOC_DATE supporting references are set, the document number and document date are updated from the supporting reference. Else, the document number and document date are printed from the transaction.

Report Parameters

This table lists selected parameters for the Customer Balance Reconciliation report for Russia:

Parameter	Description
Legal Entity	Specify the legal entity for which the report is launched.
Business Unit	Specify the business unit for which the transactions are being selected.
To and From Period	Specify the time period for the transactions.
Customer Name	Specify the organization with which the reconciliation act must be agreed upon and signed.
Currency	Specify the currency that is used in the report. You can submit a report in functional or foreign currency.
Rate Type	Select the rate type that is used to calculate the Unrealized Exchange Rate Gain/Loss, if the user rate type was used in original transaction.
Group by Contract	Define the sorting order used in the report. Select Yes to sort by Contract, Document Date, and Document Number. Select No to sort by Document Date, and Document Number fields.

Frequently Asked Questions

This table lists frequently asked questions about the Customer Balance Reconciliation report for Russia.

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?	Accountant
When do I use this report?	Use this report monthly or quarterly to reconcile settlements with customers.
What type of reports are these?	Oracle Analytics Publisher