A €1,200 supplier invoice is not a €1,200 cost simply because that is what it becomes on the day you pay it. Between receipt, VAT treatment and settlement, the exchange rate can move. If your records do not show that movement clearly, month-end becomes a hunt through bank statements and spreadsheets.
This foreign currency bookkeeping guide explains the practical controls Maltese businesses need when buying, selling or paying in currencies other than euro. The aim is simple: capture the source document once, convert it consistently and make exchange differences visible instead of letting them distort your costs, VAT figures or cash position.
Start with the transaction date, not the payment date
Foreign currency bookkeeping begins when the transaction takes place. For a supplier bill, that is usually the invoice date. For a sales invoice, it is the date you issue it or the date the supply is recognised under your accounting policy. Record the original currency and original amount alongside the euro value from that date.
For example, a UK software supplier invoices your business £1,000 on 10 June. Your bookkeeping record should retain the £1,000 invoice total, then convert it to euros using the exchange rate your business applies on 10 June. That euro amount becomes the initial expense and creditor balance.
When you pay the invoice later, you do not overwrite the original euro value. You record the euro amount that actually left your bank, then post the difference as an exchange gain or loss. This keeps your expense accurate and explains why the bank payment does not match the original creditor balance exactly.
It sounds minor. Across regular subscriptions, imports, travel costs and overseas clients, it quickly becomes material.
Choose one exchange-rate policy and apply it consistently
The right rate depends on your accounting policy, the transaction type and the tax treatment. Many businesses use a reliable published daily rate for invoice-date conversion. Others may use a monthly rate for high-volume, low-value transactions where that is appropriate and accepted for their reporting needs.
The key is consistency. Do not use the card provider’s rate for one invoice, a search-engine result for another and a bank rate for the next. Those rates can differ because of timing, spreads and fees. Inconsistent choices create reconciliation problems and make it harder for an accountant to review the ledger.
Your policy should state which source you use, whether rates are daily or monthly, and how you treat bank charges. Keep the source available with your records. If an auditor, accountant or tax reviewer asks how an amount was converted, the answer should take seconds, not a reconstruction exercise.
Separate exchange rates from bank fees
A payment provider may deduct a conversion fee or use a less favourable rate than the reference rate you used for the invoice. These are related, but they are not the same thing.
The difference between the booked euro liability and the euro payment is normally an exchange difference. A separately identified transfer, card or conversion fee is a bank charge. Posting both to one vague expense account hides useful information. Keeping them separate shows the real cost of paying overseas suppliers and helps you compare providers.
Record realised and unrealised exchange differences
A realised exchange difference happens when you settle an invoice. You know precisely what you owed in euros when the invoice was recorded and what it cost in euros when you paid it.
Suppose the £1,000 supplier invoice was booked at €1,170. Two weeks later, €1,185 leaves your bank account to settle it. The additional €15 is a realised foreign exchange loss. If the payment had been €1,155, you would record a €15 gain.
An unrealised difference is different. It arises when an unpaid foreign-currency invoice remains open at month-end or year-end. The invoice needs revaluing using the closing rate required by your accounting policy. The difference is posted as an unrealised gain or loss, because no cash has moved yet.
This revaluation matters most for businesses with sizeable overseas receivables or long supplier payment terms. Without it, the balance sheet can show a euro amount that no longer reflects what you are likely to receive or pay. When the invoice is eventually settled, reverse or clear the revaluation correctly so the same movement is not counted twice.
Foreign currency bookkeeping and Malta VAT
VAT is where a workable process becomes essential. Your bookkeeping must preserve the supplier invoice, identify the correct VAT treatment and calculate the values needed in euros for your Malta VAT records and return.
A foreign currency does not decide the VAT treatment. The nature of the purchase or sale does. A local purchase, an intra-Community acquisition, imported goods, reverse-charge service or export can each have different treatment. The conversion then needs to support the euro VAT figures you report.
Take a eurozone business buying online advertising from a non-Maltese supplier. The supplier may invoice in US dollars and charge no local VAT. That does not mean the transaction is outside your VAT process. Depending on the place-of-supply rules and your business status, reverse charge may apply. The invoice must be classified correctly before any return figures are prepared.
Do not force the bank’s final euro debit into the VAT calculation just because it is easy to find. The VAT basis should follow the applicable rules and your documented conversion method. Payment-date movements belong in foreign exchange gains or losses, not in a rewritten VAT value.
For businesses with mixed VAT treatment, this is also a strong reason to capture the full invoice rather than only typing an amount into a spreadsheet. The supplier name, VAT number, supply type, invoice date, currency and tax wording may all affect the outcome.
Build a process that survives month-end
Manual bookkeeping fails in predictable places: receipts arrive late, invoices sit in email threads, a director pays with a personal card, and the person reconciling the bank cannot tell which rate was used. The fix is not a bigger spreadsheet. It is a defined intake-to-review workflow.
First, collect each invoice in one place as soon as it arrives. Keep the original document and capture the supplier, date, currency, net amount, VAT treatment and total. Next, apply your approved exchange-rate policy automatically or through a controlled calculation. Finally, match the payment when it appears in the bank feed and post any exchange difference separately.
At month-end, review unpaid foreign-currency balances, process the required revaluations and reconcile every foreign-currency bank or payment account. Check unusual rate differences, missing supplier documents and VAT exceptions before figures are carried into the return or management report.
This is exactly where automation earns its place. MyAccountant can capture multilingual invoices from email, WhatsApp or dashboard upload, extract the key data, convert amounts into euros and prepare Malta-ready VAT figures while surfacing exceptions for review. The judgement remains with the business or accountant. The repetitive transcription does not.
Common errors that create avoidable clean-up work
The most expensive mistake is treating a foreign currency payment as a new expense instead of settling an existing invoice. That duplicates costs and leaves creditors open. Another is deleting the original currency value after conversion. You need both figures to audit the transaction and understand future differences.
Businesses also often post every rate movement to bank charges, ignore open invoices at period end, or use an exchange rate that cannot be traced back to a stated policy. These errors may seem small in a single month, but they accumulate into unreliable margins and difficult year-end adjustments.
There is one useful exception to the rule of keeping detail: genuinely trivial, occasional foreign-currency spend may not justify a complex process. Even then, retain the receipt, document the rate source and make sure the VAT treatment is right. Simplicity is useful only when it remains controlled.
Give exceptions to a person, not every invoice
A good foreign currency process should be quiet. Most standard invoices should flow through the same rules each month. Human attention is best reserved for an unfamiliar supplier, a missing VAT number, an unusual currency, a large rate variance or a transaction whose VAT treatment is unclear.
That approach gives owners cleaner euro reporting and gives accountants records they can trust without rekeying them. Set the policy once, retain the evidence and review the exceptions. Your month-end should show what changed in the business, not how much time was spent converting currencies.