Tetra M Labs.

ERP

Multi-currency accounting: how small businesses handle invoices in more than one currency

Multi-currency accounting starts with a simple problem: you send an invoice in dollars, euros, or dirhams, but your bank account and your books are in another currency. The amount on the invoice and the amount that lands in your account are rarely the same, and the difference has to go somewhere. If you ignore it, your profit looks wrong, your customer balances look wrong, and your accountant spends the year-end untangling it.

The good news is that the rules are straightforward once you know the three moments that matter: the day you record the transaction, the day you get paid, and the day you close your books.

Multi-currency accounting: the exchange rate problem

Every business has one currency it reports in — accountants call this the functional currency. For a business in Lahore selling to a client in Dubai, that might be rupees even though the invoice is in dirhams. For a freelancer in the Gulf billing a client in Europe, it might be dirhams while the invoice is in euros.

When you issue an invoice in a foreign currency, you record it in your books at the exchange rate on that day — the spot rate. So a $1,000 invoice recorded when the rate is 280 rupees to the dollar goes into your sales ledger as 280,000 rupees, even though the invoice itself still says $1,000. Your customer owes you $1,000; your books track both the foreign-currency amount and its value in your own currency.

The same applies in reverse when you buy. A supplier bill for €500 is recorded at the rate on the bill date, and you owe €500 until you pay it, whatever happens to the rate in between.

That is why a good accounting system keeps the foreign-currency amount alongside the converted amount. Without the original figure, you cannot tell whether a later difference is a real gain, a real loss, or just a rounding error.

Multi-currency accounting: exchange gains and losses

The difference between the rate on the invoice date and the rate on the payment date is an exchange gain or loss, and it belongs in your profit and loss account — not buried in the sale or the purchase.

Take the $1,000 invoice recorded at 280,000 rupees. If the customer pays a month later, when the rate has moved to 285, the payment is worth 285,000 rupees. You have gained 5,000 rupees from the movement, and that gain is recorded separately from the sale. If the rate had fallen to 275 instead, you would have lost 5,000 rupees on the same sale, through no fault of your pricing.

The same logic applies to unpaid balances at the end of a reporting period. If that $1,000 invoice is still unpaid at your year-end, you revalue it at the closing rate. The resulting difference is an unrealised gain or loss: real in accounting terms, but not yet cash. It reverses or firms up when the customer actually pays. Mixing realised and unrealised gains together is one of the most common mistakes in multi-currency accounting, because only the realised ones have touched your bank account.

Bank charges are separate: a fee for receiving a foreign payment is a bank charge, not an exchange loss. Lumping fees into the exchange difference makes both figures wrong.

Three habits that keep multi-currency books clean

First, invoice in the currency you agreed, and record the rate on the day. Never re-type an old rate from a previous invoice, and never use the rate on the day you happen to do the bookkeeping. The transaction date decides the rate, and your system should store it with the invoice.

Second, revalue open foreign-currency balances at each month-end, not just at year-end. A monthly revaluation takes minutes with proper software, means the year-end holds no surprises, and lets your monthly profit reflect currency movements as they happen.

Third, keep one ledger account per currency for each customer or supplier where volumes justify it, or at least make sure your reports can split balances by currency. A single account mixing dollars, euros, and rupees with no currency split cannot be reconciled to anything — you cannot check it against a bank statement or a customer statement, because neither of those mixes currencies either.

What to watch out for

The most expensive mistake is pricing in a foreign currency without thinking about the movement. A quote that is profitable at today's rate can be loss-making by the time you are paid if the currency moves against you and your costs are in your home currency. Businesses that invoice regularly in another currency either price in a margin for movement, agree shorter payment terms, or invoice in their own currency where the customer accepts it.

Another trap is using the wrong rate source. The rate your bank actually applies when converting a payment is not always the published market rate — banks add a spread. For recording the invoice, the market spot rate is the standard starting point; for the payment, the rate your bank applied is what hit your account. Your accountant can confirm which rate your reporting framework expects.

Finally, remember that multi-currency accounting is about measurement, not magic. It does not remove currency risk; it records it honestly so you can see it, price for it, and explain it. A business that knows exactly how much of its profit came from selling and how much came from currency movement is in a far stronger position than one that only finds out at year-end.

You do not need to do these conversions by hand — that is what accounting software is for. But understanding the three moments — invoice date, payment date, and period-end — means you can spot a currency problem while there is still time to act on it.

If you want your invoicing, expenses, and reporting in one place, join the waitlist for Point at tetramlabs.com.