Revalue Customer Account

Are you ready to revalue your customer accounts?
  • If you're using default nominal accounts with cost centres and departments for any of your foreign currency customer accounts, you'll need to make sure that you have Exchange Differences nominal accounts with the same CC / Dept combinations.

  • Make sure your exchange rates are up to date.

Cost centres

Departments

Manage currencies and exchange rates

Find this screen

Open: Period End Routines > Foreign Customer Account Revaluation

How to

Revalue a single currency

This revalues all outstanding transactions on the customer accounts that use the selected currency. You can change the exchange rate here if you need to.

  1. Select Revalue single currency.
  2. Enter a Revaluation date. This is the date the revaluation transactions are posted. If a currency uses a period exchange rate, the exchange rate set for this date is used.
  3. Choose the currency.
  4. Click to change the exchange rate.

    If the currency uses a Period exchange rate only, the exchange rate is displayed but can't be changed.

  5. Choose whether to report or post the revaluation transactions:
    1. Produce Report Only: Produces a report showing the revalued transactions.
    2. Produce accounting adjustments: Posts revaluation transactions.
  6. Click OK.

Revalue all currencies

This revalues the outstanding transactions on all foreign currency customer accounts, using the exchange rates set in the Currencies and Exchange rate settings. You can't change the exchange rate here.

  1. Select Revalue all currencies.
  2. Enter a Revaluation date. This is the date the revaluation transactions are posted. If a currency uses a period exchange rate, the exchange rate set for this date is used.
  3. Choose whether to report or post the revaluation transactions:
    1. Produce Report Only: Produces a report showing the revalued transactions.
    2. Produce accounting adjustments: Posts revaluation transactions.

Report on the differences

Choose Produce Report Only and click OK.

A list of the potential revaluation transactions is displayed, but not revaluation takes place.

This is useful if you want to find out what the current exchange gain or loss is but don't want to post an adjustment.


Useful Info

When to use this

Use this to manage exchange rate differences for your foreign currency transactions.

It's likely that there'll be changes in the exchange rate between the time an invoice is entered and when it's paid. These fluctuations are dealt with automatically by Sage 200cloud when a payment is allocated to an invoice.

However, you may also want to make sure that the value of outstanding foreign currency transactions reflects the latest exchange rate. If so, you can revalue these outstanding transactions here.

When you revalue your customer accounts, Sage 200cloud works out the difference between the exchange rate entered when the invoice was saved and the current exchange rate. Where there is a difference, this amount is posted to the Debtors Control Account and Exchange Differences account.

Produce a report or produce accounting adjustments?

When you revalue your foreign customer accounts you can either produce a report or perform a full revaluation.

  • When you produce a report, it displays the value of outstanding transactions your customer have with you based on the currency exchange rate applicable on the day the report is generated. Sage 200cloud doesn't make any amendments to the values of transactions that are held on the system. Think of it as a what-if snapshot.
  • When you produce accounting adjustments, Sage 200cloud updates the customer's balances on Sage 200cloud based on the currency exchange rate applicable on the day you perform the revaluation.

Single or multiple currencies?

If you are revaluing a single foreign currency, you can specify the exchange to use.

If you are revaluing more than one currency, Sage 200cloud uses the exchange rates specified on the Currencies & Exchange Rates screen.

Revaluation rules

When your transactions are revalued the following rules are applied:

  • For currencies using a Single exchange rate:

    The exchange rate specified in the Currencies and Exchange rate settings is used.

    If you revalue a single currency, you can change the exchange rate here.

  • For currencies using a Period exchange rate:

    The exchange rate set for the period the Revaluation date falls into is used.

  • For currencies using both single and period exchange rates:

    The single or period exchange rate is used depending on which on is selected on the customer account.

  • Transactions with a Query flag against them are not revalued.
  • The revaluation only posts the difference in the exchange rate, and not the full base value of the transaction.
  • Only outstanding or part outstanding transactions up to the specified Revaluation date, are revalued.
  • If the Revaluation date is in a future period, the revaluation values are posted to the deferred postings file.

What happens when

An account is revalued?

A revaluation transaction for each revalued account is posted to the Debtors nominal account and Exchange Differences nominal account. The transactions are posted using the Revaluation date.

Nominal Account Debit Credit
Debtors Control Gain Loss
Exchange Differences Loss Gain
Tip:

Don't forget, if you're using cost centre and departments with your nominal accounts, make sure you have an Exchange Differences Nominal account with the correct cost centre and department combinations. Otherwise the transaction will be posted to the suspense account.

For example. you have a customer account with a default sales account of 4000 with a cost centre MAN. When you save the revaluation, it posts to the following Exchange Differences account 8006 MAN.