Skip ahead to the main page
Partner Huddle
Pages

Month-end currency revaluation: 3 figures to check

Partner Huddle Editorial Team · Published · 11 min read

For a month-end currency revaluation, check the foreign-currency balance, the closing rate against the recorded rate, and the unrealized gain or loss.

Key takeaways

  • Match each currency balance to the account records.
  • Record the rate sources and any manual changes.
  • Recalculate the gain or loss before approving the adjustment.

For partners and operations leads at small accounting firms, that meeting deserves a careful look. A client that holds euros, pounds, or another currency may show a balance whose home-currency value has moved since the entry was first recorded. A revaluation updates that value. It does not, on its own, show that the number is right, and it does not tell you whether the client's books are in order.

The examples in this post come from the documentation of three software products: ERPNext, Microsoft Dynamics 365 Business Central, and Zoho Books. They show how each product presents these figures. They are not general rules, and the rules that apply to a particular client depend on the accounting framework and the jurisdiction involved.

Set up the review before you open the file

Setting up the review first means deciding what it covers and collecting its sources before you check any figure. Ask the client or bookkeeper for the account detail for each foreign-currency account, the bank statements as at the last day of the month, the list of rates used, and the prior month's revaluation for comparison. Put these in one folder before you open the revaluation. That makes the review easier to follow and easier to repeat next month. Use the client intake checklist to organise the handoff.

Write down the period end date and the accounts in scope. If a foreign-currency account is left out of the revaluation, the review should say so, so that nobody later assumes it was checked. Note who prepared the revaluation, who is reviewing it, and the date of the review. A short header like this turns a loose set of checks into a record someone else can follow.

Leave time for questions. A review that starts on the last day of the close leaves little room to chase a missing bank statement or a rate with no source. If the review is planned for a set day each month, the bookkeeper knows when the materials are due, and the questions that come up can be answered before the close is locked.

Check the foreign-currency balance at month end

Start here, because the revaluation should leave this amount alone. The ERPNext documentation uses a simple case: "At month end, Nova still holds EUR 1,000 in its Euro Bank account." ( Frappe, Exchange Rate Revaluation)

The same page explains what the revaluation changes. Exchange Rate Revaluation "updates that Company-currency carrying value without changing the EUR 1,000 balance." The page's example also says the revaluation "retains EUR 1,000 but changes its USD value by USD 50." ( Frappe, Exchange Rate Revaluation) In plain terms, the currency amount stays the same, and the company-currency value is what moves.

When you review this figure, work through it in three steps:

  • Compare the foreign-currency amount in the revaluation with the bank statement for that account, as at the last day of the month.
  • Compare it with the account's own balance for the same currency. If the two differ, find the entries that explain the gap before going further.
  • Check the currency code. Two currencies can have similar codes or names, and a balance tagged with the wrong currency can produce a wrong home-currency value even when the amount looks right.

A balance that looks right at the total level can still hide a problem. If the client holds more than one bank account in the same currency, check each account separately rather than only the combined figure. Combined totals can match even when the accounts that make them up do not. For that comparison, use the client bank reconciliation checks.

Trace the balance back to the entries that built it, too. A month-end foreign-currency figure reflects incoming payments and outgoing payments, while revaluation changes its company-currency value. A reviewer does not need to re-post every entry, but it helps to know which entries moved the balance, so that an unexpected figure can be explained rather than accepted.

Some clients hold a balance in a currency that is not the one they report in, and others hold several foreign currencies at once. In either case, keep each currency on its own line in your notes. Mixing currencies in one total makes it hard to see which balance a rate change affects, and it makes the check in the next section harder to carry out.

Compare the closing rate with the recorded rate

The second figure is the change between the rate at which the balance was recorded and the closing rate for the month. These two rates are the inputs to the revaluation. A wrong rate in either place changes the result, even if the balance itself is correct.

The ERPNext example gives both rates and the result: "If the balance was recorded at 1 EUR = 1.10 USD and the closing rate is 1.15, its USD value has risen from 1,100 to 1,150." ( Frappe, Exchange Rate Revaluation) Here the closing rate is higher than the recorded rate, and the USD value rises. The euro balance is the same EUR 1,000 before and after. Only its USD value changes.

Microsoft's Business Central documentation works through a different example with its own rates. It describes a month-end adjustment: "At the end of the month, a currency adjustment is performed where the adjustment currency rate has been set to 1.125, which triggers an unrealized gain of 2." ( Microsoft, Update currency exchange rates)

The same example also shows a rate registered on a payment: "At the time of payment, the actual currency rate registered on the bank transaction shows a currency rate of 1.120." ( Microsoft, Update currency exchange rates) The adjustment rate of 1.125 and the bank transaction rate of 1.120 are two separate figures. A reviewer should be able to tell which rate each entry used, and why the two differ, instead of assuming they are the same.

Zoho Books' help page describes rate handling in one sentence: "Additionally, Zoho Books will automatically handle currency exchange rates, which you can adjust if needed." ( Zoho, Currencies) That sentence describes Zoho Books only. Where a product handles rates automatically, the review question stays the same: which rate was used, and was it adjusted by hand?

When you review this figure, ask the bookkeeper for four things:

  • The recorded rate for each foreign-currency balance, with a note of where it came from.
  • The closing rate for the month and its source, such as a rate table or a bank feed.
  • A list of any rate changed by hand, with the reason written down.
  • Confirmation that the revaluation used the closing rate on that list, and not an older or different rate.

If the client holds balances in more than one foreign currency, each currency has its own recorded rate and its own closing rate. Check each pair separately, and make sure the list of rates has one entry for each currency in use.

Compare the rates with the prior month's revaluation as well. A sudden change in a rate that looked steady in earlier months is a prompt to check the source. It is not a finding on its own. Your job is to confirm where the number came from.

Check the unrealized gain or loss before posting

The third figure is the gain or loss that results from the first two. Its main job in the review is to be checked before any adjustment is posted to the books.

The ERPNext example says the revaluation "identifies the USD 50 unrealized gain so finance can review and post an accurate period-end adjustment." ( Frappe, Exchange Rate Revaluation) The same example moves the USD value from 1,100 to 1,150, which matches the USD 50 change the page describes. Checking that the gain ties back to the balance and the rates is the core of this step.

A useful way to review the gain or loss is to write the calculation out in your own words. For each balance, state the foreign-currency amount, the recorded rate, the closing rate, and the change in the home-currency value. If you can write that out, you have a yardstick to check the software's output against.

Record the gain or loss in the review note in the same form you used for your own calculation. Show the currency, the amount, and the direction, along with the balance and the rates that produced it. A reader who did not run the review can then follow the number from start to finish without asking where it came from.

Confirm the sign. A gain and a loss can look alike on a long list, and a reversed sign changes the story the adjustment tells.

Zero balances need their own look. The ERPNext documentation says: "From ERPNext v14 onward, zero-balance cases are handled by a separate Exchange Gain/Loss Journal Entry in Draft." ( Frappe, Exchange Rate Revaluation) If you review ERPNext from v14 onward, look for that separate draft entry as part of the close. A zero balance can drop out of a review that looks only at the balances that remain.

Putting the three figures together

Check the three figures in order, because each depends on the one before it. The balance sets the amount, the rates set how far the value moves, and the gain or loss follows from both.

The ERPNext example brings all three figures together. The numbers line up as follows:

FigureValue in the ERPNext example
Foreign-currency balanceEUR 1,000
Recorded rate1 EUR = 1.10 USD
Closing rate1.15
USD value, before and after1,100 to 1,150
Unrealized gainUSD 50

Illustrative example: calculate the value change

Suppose a foreign-currency balance of 1000 has a home-currency value of 1100 before revaluation and 1150 afterward. Subtract 1100 from 1150: the increase is 50. Compare that result with the reported unrealized gain, then check the rates behind the values.

If the same chain does not hold for a client's numbers, find out which figure is off before you approve the adjustment. A mismatch between the balance and the gain or loss can come from several places, such as a rate entered by hand or a balance taken from the wrong account.

Write a short review note once the three figures tie together. A note helps the next reviewer and makes the client's records easier to explain. It can say which balances were revalued, which rates were used and where they came from, the gain or loss by currency, and any rate changed by hand, with the reason.

Today, choose one foreign-currency account and gather its statement, rate sources, and revaluation. Record your answers to the questions below.

Questions to ask before you sign off

Four questions cover all three figures, and each one can be answered from the revaluation and the client's records.

Does the foreign-currency balance match the bank statement and the account records for that currency at month end?

It should match both records; explain any difference before approving the adjustment.

Which recorded rate and which closing rate did the revaluation use, and where did each come from?

Identify both rates and record a source for each.

Was any rate changed by hand, and is there a written reason?

Record whether a rate was changed manually and the reason for any change.

Does the gain or loss match the value change, and how should ERPNext zero balances be checked?

Confirm the amount and sign; for ERPNext v14 onward, check the separate draft entry for zero-balance cases.

If the answer to any question is no, or not yet, ask for the missing detail before you approve. A clear "not yet" is more useful than a quick yes that cannot be checked later.

Ask for the answers in writing, even if the bookkeeper gives them in a call. A short email that states the balance, the rates, and the gain or loss gives you something to compare against when the next month's revaluation arrives.

Explaining the review to the client

A revaluation can be hard to explain to a client who does not work with accounts every day. Use the three figures to structure the conversation. Start with the balance, because it is the simplest of the three to follow. Move next to the rate change, and finish with the gain or loss, which is the result of the first two.

Plain words help. You can say that the amount held in euros did not change, but its value in the company's reporting currency did. Keep technical labels for the written review note, where the next reviewer will need them, and use everyday language in the conversation itself.

If the client disagrees with a figure, go back to the three checks rather than debating the total. Ask which balance, which rate, or which entry the client believes is wrong, and look at that piece together. A conversation about one balance and one rate is easier to settle than a debate about the final number alone.

Keep product examples separate from accounting rules

These examples cover three products and do not set rules for your clients. The ERPNext documentation describes how ERPNext presents these figures, the Business Central page describes Business Central, and the Zoho Books page describes Zoho Books. Any rule in those pages holds only in the product it describes.

Confirm which accounting framework or tax treatment applies to a given client, and how the relevant jurisdiction handles unrealized gains and losses. Those questions belong with the client's accountant or a qualified advisor in the relevant jurisdiction.

Use the three figures as a checklist for the review itself, and treat the rules for how entries should be recorded as a separate question. Keeping the two apart makes both easier to answer.

Sources