Supplier Balance Revaluation Report
Use this report to identify suppliers with credit (negative) balances. In many countries you are required to enter a manual journal entry to adjust the general ledger balance for such suppliers.
This report provides you with two results:
- Independent from the accounting entries for your liabilities account, this report gives you the balance of your supplier and the open items that make up the balance. It takes into account paid prepayments, unpaid prepayments are not included.
- A report listing only suppliers with a negative balance, only suppliers with a positive balance or both kind of suppliers at once. This is needed in some countries, where you need a separate entry on the balance sheet for suppliers with a negative balance.
Use the result 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 revaluated balance. You would then reverse this entry at the beginning of the following period to resynchronize your liabilities with general ledger accounts.
You can run this report for a revaluation period, up to a particular due date, or to include suppliers with a negative balance, suppliers with a positive balance, or suppliers with a positive and negative balance. Make sure the you have entered an End-Of-Period (EOP) rate for each currency used. If any EOP is missing, the report will notify you that the results calculated may be wrong.
Report Submission
You submit this report from the Submit Request window. See: Submitting Standard Reports, Programs, and Listings.
Selected Report Parameters
Revaluation Period. Select the period for which you want to revaluate.
Include Up To Due Date. If you want to differentiate short-term, mid-term and long-term liabilities, you can enter a date.
Supplier Balance.
- Positive. The report lists only suppliers with a positive balance
- Negative. The report lists only suppliers with a negative balance
- Positive and Negative. The reports lists all suppliers.
Selected Report Headings
A warning is printed at the end of the report, if an End Of Period rate was not entered for at least one currency.
Column Headings (Report Name, if needed for different report parameters)
Supplier Name/Number. Supplier name, supplier number, and supplier site that have open items.
Transaction Number. Number for the transaction.
Due Date. Due date of the transaction.
Cur. Currency used to enter the transaction.
Open Orig. Amount. Balance of the transaction in its original currency.
Exchange Rate. Exchange rate for foreign currency transactions. This value is 1 for functional currency transactions.
Open Func. Amount. Balance of the transaction valuated at the exchange rate used when the transactions were approved.
EOP Rate. End-Of-Period rate, which the report uses to revaluate the balance of the transaction.
EOP Amount. Balance of the transaction, revaluated using the EOP rate.
Open Revaluated Amount. Payables uses the higher of the Open Func. Amount and the EOP Open Amount to determine the market value of the open item.
Credit/Debit. Sum of the positive open items (Debit) and the sum of the negative open items (credit). These figures help you determine the amount of the adjustments to your general ledger balances.
