A supplier invoice arrives in US dollars. Your bank statement shows a slightly different euro amount. The invoice includes VAT, the payment lands days later, and month-end is already close. Currency conversion bookkeeping is where small differences become confusing records, incorrect VAT figures and unnecessary accountant queries.
For a Malta business buying, selling or paying subscriptions in foreign currencies, the aim is simple: keep the original transaction clear, convert it consistently into euros, and retain an audit trail that explains every figure. The process does not need a complex spreadsheet. It does need a clear rule for dates, rates and exchange differences.
Why foreign-currency invoices create bookkeeping problems
A foreign-currency transaction has at least two values: the amount shown on the invoice and its value in euros. The original amount matters because it is the supplier’s legal document. The euro amount matters because your accounts, VAT records and management reporting need a consistent base currency.
The complication is that exchange rates move. An invoice dated 3 May may convert to one euro value, while the payment made on 28 May converts to another. Neither figure is automatically wrong. They represent different points in the transaction.
The problems start when a business records only the bank amount, overwrites the invoice currency, or applies different rate sources from one month to the next. This makes supplier balances hard to reconcile and turns a routine review into detective work.
For VAT-registered businesses, timing also matters. The exchange rate should support the euro value used in the relevant VAT period. A payment date is not always the right date for recognising the purchase or sale. The correct treatment depends on the transaction, the applicable VAT rules and the tax point. When a transaction is unusual, obtain advice from your accountant rather than forcing it into a standard rule.
A practical currency conversion bookkeeping workflow
Good currency conversion bookkeeping follows the document first, not the bank feed. Start with the invoice, capture its details, then reconcile payment and exchange differences afterwards.
1. Keep the original invoice amount intact
Record the supplier or customer, invoice number, invoice date, currency, net amount, VAT amount and gross total exactly as they appear on the document. A €1,200 equivalent is not a substitute for an invoice issued for $1,300. You need both.
This protects the audit trail and makes it easier to spot duplicated invoices, partial payments and credit notes. It also gives your accountant the evidence needed to validate the VAT treatment.
2. Convert using a defined, consistent rate
Choose an approved exchange-rate source and apply it consistently. Your accounting policy might use a rate at the transaction date, an approved periodic rate where permitted, or another method agreed with your accountant. Consistency is more valuable than chasing tiny gains from whichever rate happens to look best that day.
Document the policy. State the rate source, the date used and how the rate is applied. That turns a conversion from a manual judgement call into a repeatable process.
For example, a French software supplier issues a €500 invoice. If your books are in euros, no currency conversion is needed, even if the card provider charges a separate fee. If a UK supplier issues a £500 invoice, record £500 on the document and convert it to euros using your chosen rate for the relevant recognition date. Store the euro value alongside the original amount.
3. Categorise VAT before posting the transaction
Currency and VAT are separate questions. Converting a supplier invoice into euros does not tell you whether the VAT is recoverable, whether reverse charge applies, or which VAT return box is affected.
Check the supplier location, VAT number where relevant, the nature of the goods or services, and the place-of-supply rules. EU transactions can require different treatment from local purchases or non-EU services. The right coding must be applied to the euro value that enters the VAT records.
This is why generic invoice capture tools often create more work than they remove. They may read the currency correctly but still leave the business to decide the local VAT outcome. Malta-specific categorisation reduces that gap.
4. Reconcile the payment separately
When the payment appears in the bank, match it to the invoice. The euro amount paid may differ from the euro amount originally recognised because the exchange rate changed between invoice and settlement. Bank charges can create a further difference.
Do not edit the original invoice value to make it match the bank line. Post the difference correctly as an exchange gain or loss, and record any bank fee separately. This keeps the supplier ledger accurate: the invoice is settled in its original currency, while the accounts show the financial effect of the rate movement.
A small difference is normal. A large difference may indicate a duplicate charge, a partial payment, an incorrect rate, or an invoice that belongs to another period. Exception handling is where human attention adds value.
The dates that matter most
There is no single “currency date” that works for every purpose. Three dates commonly appear in the same transaction: the invoice date, the tax point or supply date, and the payment date.
The invoice date usually supports when the cost or income is recognised. The tax point can determine when VAT becomes due or recoverable. The payment date determines the actual cash conversion shown by your bank. In many straightforward cases these dates are close together. In others – deposits, advance payments, credit notes, recurring subscriptions and delayed settlements – they are not.
Use the correct date for the purpose at hand. Do not assume the bank date should drive the entire entry simply because it is easiest to find. If you report in euros but receive a foreign-currency invoice in one VAT period and pay it in the next, the original conversion and settlement difference need to remain distinguishable.
What to retain for an audit-ready record
The best bookkeeping records answer a reviewer’s questions without a long email trail. For each foreign-currency transaction, retain the source invoice, the original currency amounts, the conversion rate or source used, the conversion date, the resulting euro values, the VAT category and the payment evidence.
Where a foreign exchange difference arises, retain the link between the invoice and payment. This is especially useful for businesses with regular subscriptions in dollars or sterling, overseas contractors, online advertising spend and EU suppliers.
Avoid rounding each line differently across the workflow. Decide whether your system rounds at line level or invoice total level and apply the same approach. Minor rounding differences happen, but they should be explainable rather than random.
Where automation earns its place
Manual conversion feels manageable when there are five invoices a month. It stops being manageable when invoices arrive through email, WhatsApp, staff purchases and supplier portals, each using a different currency and VAT treatment.
The useful automation is not just a currency calculator. It captures the invoice, reads the original currency and values, assigns the right VAT category, converts the amounts into euros using your chosen workflow, and preserves the document for review. It should also flag exceptions rather than asking you to inspect every routine invoice.
MyAccountant is built around this sequence for Malta businesses: submit an invoice by email, WhatsApp or dashboard, then receive structured data, euro conversion and VAT-ready categorisation without rekeying figures into a spreadsheet. The value is not fewer clicks alone. It is a cleaner route from supplier document to monthly reporting.
Automation still needs controls. Review new suppliers, unusual currencies, high-value invoices and transactions where the VAT treatment is unclear. Once a supplier’s pattern is established, supplier learning can reduce repeat decisions without removing oversight.
Common mistakes worth stopping now
The most expensive errors are usually process errors, not arithmetic errors. Recording only euro equivalents loses the original contractual amount. Using the payment date for every invoice can misstate period reporting. Coding exchange differences as supplier costs hides what actually happened. And applying VAT after the transaction has already been posted invites corrections at month-end.
Another common mistake is treating card-provider conversion rates as the only record needed. They explain what left the bank, but they do not replace the invoice value or prove the VAT categorisation. Keep both sides of the transaction.
If your business uses an accountant, agree the policy once. Confirm the preferred rate source, treatment of exchange gains and losses, approval process for exceptions, and month-end cut-off. That creates a workflow your team can follow and your accountant can trust.
A foreign-currency invoice should not become a spreadsheet problem. Capture the document, preserve the original amount, convert consistently, code VAT correctly and let exceptions rise to the surface. That is how month-end stays quick, clear and ready for review.