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.
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. |
The Debit and Credit totals help you determine the amount of the adjustments to your general ledger balances.