Customer Balance Revaluation Report

Use the Customer Balance Revaluation Report to identify customers with credit (negative) balances. The enterprises in certain countries are required to enter a manual journal entry to adjust the general ledger balance for these customers.

The report provides you with two results:

• Independent from the accounting entries for your receivables account, this report gives you the balance of your customer and the open items that make up the balance. It takes into account on-account receipts.

• The report lists the customers with a negative balance only, customers with a positive balance only, or both positive and negative balances, depending on the setting of the Customer Balance parameter. This information is needed for countries that require a separate entry on the balance sheet for customers with a negative balance.

Use the results of this report to determine the amount you need to manually adjust your general ledger balance to reflect the difference between the original balance and the revaluated balance. You would then reverse this entry at the beginning of the following period to resynchronize your receivables with general ledger accounts.

Note: Make sure you have entered an End-of-Period (EOP) rate for each currency used. If any EOP is missing, the report notifies you that the results calculated may be incorrect.

Run this report in conjunction with both your customer account reviews and reconciliation activities.

Selected Report Parameters

Revaluation Period

The period that you want to revaluate.

Include up to Due Date

If you want to differentiate short-term, mid-term, and long-term receivables activities, enter a date in this parameter. Otherwise, leave the field blank.

Customer Balance

• Show positive Balance: List only customers with a positive balance.

• Show negative Balance: List only customers with a negative balance.

• Show positive and negative Balance: List the balance for all customers. This is the default.

Report Output

This table describes important column headings in the Customer Balance Revaluation Report.

Column Heading	Description
Transaction Number	The number of the transaction.
Transaction Type	The name of the transaction type.
Transaction Date	The date of the transaction.
Due Date	The due date of the transaction.
Currency	The transaction currency.
Open Original Amount	The balance of the transaction in the entered currency.
Conversion Rate	The conversion rate for foreign currency transactions. This value is 1 for ledger currency transactions.
Open Ledger Currency Amount	The balance of the transaction in the ledger currency valuated at the conversion rate used when the transaction was approved.
EOP Rate	The End-of-Period rate, which the report uses to revaluate the balance of the transaction.
EOP Open Ledger Currency Amount	The balance of the transaction in the ledger currency revaluated using the EOP rate.
Open Revaluated Amount	Receivables uses the lower of the Open Ledger Currency Amount and the EOP Open Ledger Currency Amount to determine the market value of the open item.

This table describes important row headings in the Customer Balance Revaluation Report.

Row Heading	Description
Customer Name/Customer Account Number	The customer name, customer account number, and customer site with open items.
Total	The total open ledger currency amount, EOP open ledger currency amount, and open revaluated amount for the customer.
Balance for [Customer Name]	The total open balance for the customer in the ledger currency.
Debit	The sum of the positive open items for the customer.
Credit	The sum of the negative open items for the customer.

Tip: The Debit and Credit totals help you determine the amount of the adjustments to your general ledger balances.