The short answer

Keep one books currency and translate every foreign document into it at a dated exchange rate, from one agreed source and by one rule for which day applies. Refuse any foreign document that has no rate rather than booking it at one to one. Set a default currency on each foreign customer and vendor, and review the realised exchange differences every month.

Key takeaways

  • Write the rate source and the day rule on one page, so every clerk applies the same policy.
  • Enter rates daily for currencies you trade every day and weekly for the rest, each with its date.
  • When the bank fixes a rate for one deal, type that rate on the deal’s own documents.
  • Keep local customers in the books currency, so their statements carry no rate at all.
  • At month end, list open foreign balances for your accountant, who decides whether they need restating at the closing rate.

One business, one books currency

A company can invoice in dollars, buy in euros and pay rent in riyals, but its ledger keeps one currency. That is the books currency, also called the functional currency. Every statement, tax figure and balance reads in it, so every document in another currency needs a second amount: its total translated at an exchange rate.

The document keeps both. The customer sees what they owe in their own currency, and the ledger records what that amount was worth on the day. Reports add up the books amounts, never the mixed originals, which is why a wrong rate on one document quietly distorts every total it touches.

Decide where rates come from

Before the first foreign document, agree one source for rates and one rule for which day’s rate applies. Without a rule, one clerk uses the bank’s rate, another a website, and a third copies last month’s. The books then carry three rates for the same day, and nobody can say which is right.

  1. Pick one source, such as your main bank’s published rate or the central bank’s.
  2. Decide which day applies; the document date is the usual choice.
  3. Name who enters rates, and how often: daily for currencies you trade every day, weekly for the rest.
  4. Enter each rate with its date, so a document can find the latest rate on or before its own date.
  5. When the bank fixes a different rate for one deal, type that rate on the document itself.

TipKeep the rate source and the day rule on one written page, so a new clerk applies the same policy as the one before.

Never book a missing rate at one to one

The most expensive mistake in foreign trade is not a bad rate but no rate. Some systems, finding nothing on file, book the document at one to one. A dollar invoice for 8,000 then enters the ledger as 8,000 riyals, the receivable is understated by most of its value, and the error surfaces only when the money arrives.

The safe rule is the opposite: a foreign document with no rate is refused until someone supplies one. That is a small delay at the desk, set against a hole in the accounts that can take weeks to trace.

Agree the currency with each customer and vendor

Whoever invoices in their own currency passes the exchange risk to the other side. When you buy in dollars and sell in riyals, you carry the risk between the bill and the payment. Decide, party by party, which currency each relationship uses, and record it on the customer or vendor so their documents start in the right one.

  • Set a default currency on each foreign customer and vendor.
  • Keep local customers in the books currency, so their statements carry no rate at all.
  • Quote a foreign customer in the currency you will invoice in, never one and then the other.
  • Where a supplier lets you choose, compare the price in both currencies before you order.

When the money arrives at a different rate

Rates move between the invoice and the payment. If you invoice 10,000 dollars at 3.7500 and the customer pays when the rate is 3.7400, you receive 37,400 riyals against a receivable booked at 37,500. The 100 riyal gap is a realised exchange difference: a real gain or loss, made on the day the money moved.

Your accountant decides where these differences post. What matters for the owner is to see them, because on thin distribution margins a run of small losses on a weakening currency can take a visible bite out of profit.

TipWhere the margin on a foreign deal is thin, ask the bank for a fixed rate before you sign, and type that rate on the deal’s documents.

Open foreign balances at month end

At month end some foreign invoices and bills are still open, each booked at the rate of its own date. Accounting standards often expect these balances to be restated at the month-end rate, an adjustment called revaluation, which shows the gain or loss you would make if they were settled that day.

Axon Suite does not revalue foreign balances yet: each document keeps the rate it was booked at. If your accountant needs the adjustment, list the open foreign balances at month end, work out the difference at the closing rate, and post it as a manual journal.

Checklist: Multi-currency checklist

  • Write down one rate source and the day it applies
  • Name who enters rates and how often
  • Enter every rate with its date
  • Set a default currency on each foreign customer and vendor
  • Refuse any foreign document that has no rate
  • Type the bank’s rate on deals with a fixed rate
  • Review realised exchange differences every month
  • List open foreign balances at month end for your accountant

In Axon Suite

How Axon Suite handles it

In Axon Suite each document carries its own currency and exchange rate. A rate typed on the document wins; otherwise the latest rate on or before its date is used, the subsidiary’s own first and then the one shared by all, and with no rate at all the document is refused rather than booked at one to one. Foreign balances are not revalued at month end yet: each document keeps the rate it was booked at.

Feature

Documents in any currency

Each document carries its own currency and exchange rate. With no rate on file and none typed, the document is refused, never booked at one to one.

Open: Documents in any currency
Feature

Several companies, one account

Add every subsidiary with its own currency, country, fiscal year, time zone and document numbers. A user works in one subsidiary, or across the whole account with a switcher in the top bar.

Open: Several companies, one account
Feature

Bill what arrived, at the agreed price

Draw the bill from the goods receipt and each line is billed at the purchase order’s agreed price and discount, under the vendor’s own invoice number. You can’t bill more than was received, and the same vendor invoice can’t be entered twice.

Open: Bill what arrived, at the agreed price
Feature

Trial balance, P&L and balance sheet

The trial balance, income statement and balance sheet read straight from the posted ledger. Each parent account totals the accounts beneath it, and the balance sheet tells you whether it balances.

Open: Trial balance, P&L and balance sheet

Before you go

Questions owners ask

What if we forget to enter today’s rate?

Axon Suite uses the latest earlier rate. Only when no rate exists on or before the document date is the document refused, naming the currency and the date.

Can each of our companies use its own rates?

Yes. In Axon Suite a subsidiary’s own rate comes first, and rates entered for all subsidiaries fill the gaps.

Should we invoice foreign customers in our currency or theirs?

In yours if they accept it, because the exchange risk then sits with them. If they insist on theirs, price the risk into the deal or agree a fixed rate with your bank.

Glossary

Terms in this guide

Open the glossary

See your own van sale reach the ledger in 30 minutes.

Chat on WhatsApp