Module 9 · Advanced · 7 min read
Foreign currency in daily work: a checklist
You will be able to: Follow a safe routine for foreign-currency documents; Spot the screens that do not convert currencies; Avoid the common rate mistakes.
- Read not done yet
- Self-check: not taken not done yet
- Lesson complete not done yet
Multi-currency errors are rarely deep accounting mistakes. They are small slips repeated: no rate, the wrong direction, a stale rate. Use the same routine every time.
- Before the day: check that the currency is Active in Settings ▸ Currencies and that today's rate is in Settings ▸ Exchange Rates.
- On the sales or purchase document, choose the Currency and read the Rate box. It should be the rate you expect, not 1.
- On a receipt or payment voucher in a foreign currency, check the Rate again. Submit stays grey ('Rate needed') until the rate is valid.
- After posting, check the Accounting impact or Posting Trail: amounts in base currency should equal foreign amount x rate.
- At period end, list the open foreign-currency invoices and bills and give them to your accountant.
Where amounts are not converted
- Approval rules compare the Document total in the document's own currency. Zeyto does not convert currencies in that test.
- The Approvals screen adds 'Value held' as the documents show it, without converting.
- Some reports add document amounts as they are on each document. Where a report says a foreign document is not converted, read its figures with care.
An approval rule that missesA rule says: Sales Invoice, Document total is more than 50,000. A USD 20,000 invoice is worth about AED 73,450, but the rule sees 20,000 and does not trigger. Add a condition on Currency (written in double quotes, for example "USD") with a USD limit, or make a second rule.
Wrong directionThe rate for USD should be 3.6725. A clerk types 0.2723, the inverse, on a USD 2,100 invoice. The receivable becomes AED 571.83 instead of AED 7,712.25. The rate is always base units per one foreign unit.
Smaller points
- A journal in a foreign currency does not post without a real rate.
- Rate 1.000000 on a non-base document is allowed but suspicious.
- Receipts for post-dated cheques cannot be in a foreign currency.
- Card sales in a foreign currency settle only if the Merchant fees setting for that is ticked; the exchange difference goes to the exchange gain or loss account.
Watch outNever delete a posted document to fix a wrong rate. Amend it (module 10 explains how) so the history stays.
TipKeep a one-page rate sheet by currency for the month. Staff who enter documents check against it.
Try it in the demo
- Open Sales ▸ Sales Invoice ▸ + New and choose a foreign currency. Read the Rate and the totals. Leave without submitting.
- Open Settings ▸ Approval Rules and read the list of test fields (Document total, Currency and so on). Do not save a rule on the shared demo.
- Open Reports ▸ Posting Trail and look at how an existing foreign-currency document shows its base amounts.
Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.
Key takeaways
- Check currency, rate and direction every time.
- Approval rules and some report totals do not convert currencies.
- Fix mistakes by amending, never by deleting.
- Give your accountant a list of open foreign-currency items at period end.
Check yourself
2 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.