A Sale in a Currency the Books Do Not Keep
You can invoice a customer in another currency, record the rate that applied, and take a payment in that currency. The ledger turns each of those into your base currency at the rate on the document, and books the difference when the payment lands at another rate. What it does not keep is a second set of books.
There are two quite different questions hiding behind the phrase multi-currency, and every evaluation conflates them. Can I transact in another currency? And can I account in one?
Our answers
Yes to the first, and comprehensively — customers, invoices and payments all carry a currency, and every document freezes the rate and the conditions that applied when it was raised. To the second: one set of books, in one base currency fixed at setup. Every foreign document posts into it at its own recorded rate, and a payment that settles at a different rate books the realised gain or loss. What stays with your accountant is the period-end revaluation of balances still open.
What the transaction side does
A customer carries a currency. An invoice carries its own, together with a snapshot of the conditions it was raised under — the country, the tax treatment, the rate that applied and the moment it was captured. A payment carries a currency too.
So a document raised in another currency reads correctly forever, at the rate that applied on the day, regardless of what has happened since. That mechanism is one of the better things in the product and it is described in full in Eight Fields That Freeze a Moment.
The customer statement inherits it: each row carries the currency of the document it came from, so a customer invoiced in two currencies gets a statement that says so rather than one that silently adds them together.
Every document knows its own currency and its own rate. The books know one currency, and convert into it once, at the rate on the document.
What the accounting side does
The organisation has one base currency, chosen at setup, and it does not change. Everything in the ledger is in it.
A foreign-currency invoice, credit note, customer payment, POS sale or online collection posts in that base currency at the rate recorded on the document — never at today's rate, and never at an invented one. Each journal line keeps the document's currency, its rate and its own figure beside the converted amount, so any line can be traced back.
An invoice raised at one rate and settled at another produces a difference, and that difference is now posted. The receivable clears at the invoice's rate, the money arrives at the payment's, and what separates them goes to an exchange gains and losses account as a realised gain or loss.
A foreign document with no rate recorded is not posted at all. It shows that it is waiting for a rate, the audit log records the refusal, and recording the rate posts it — so a missing rate is a visible gap rather than a figure booked a whole exchange rate wrong.
What does not happen is revaluation. An invoice still open at a period end stays at the rate it was raised at until it is paid; there is no unrealised gain or loss and no restatement at a closing rate.
Other currencies can be displayed, and a display figure is indicative — a convenience for reading, not a second set of records.
That is a defensible design and we would defend it. A display conversion presented as a second set of books would be worse than not having one, because it would look like accounting and would not be.
Where the two halves meet
At settlement, in the ledger — and, for whatever is still open, on the desk of whoever closes the month.
One invoice, two moments
The settled invoice is closed out exactly: receivable at the invoice rate, cash at the payment rate, the gap named. An invoice still unpaid at the period end is carried at the rate it was raised at, and restating it at a closing rate is the part your accountant does.
Why a Burundian seller should decide this deliberately
Because for many businesses here the transaction currency and the reporting currency are genuinely different things, and the gap between them is not stable.
A seller who prices regionally, collects in more than one unit and reports locally has to choose a base currency at setup, and that choice is permanent for the organisation. Choose the one your statutory reporting is in, not the one most of your revenue arrives in. The documents will carry the transaction currency regardless; the books can only be one thing, and the one thing they need to be is the one your accountant files.
The second decision is who records the rates. The ledger books a realised difference only from rates that were entered — on the invoice when it is raised, on the payment when it lands — and a foreign invoice with no rate waits off the ledger until someone supplies one. That is a named person's job, and so is the period-end revaluation of whatever is still open.
The rate is already recorded, and the realised side already posts.
The reason period-end revaluation is a tractable build here rather than an open-ended one is that the inputs already exist and are already correct: every document carries the rate it was raised at, and every settlement already books its realised difference to its own account.
Revaluation of open items
Outstanding foreign-currency invoices restated at a period-end rate, with the unrealised gain or loss posted and reversed on the first day of the next period.
A daily rate captured for you
A rate fetched and stored each day, offered on the document instead of typed — the rate on the document still being the one that posts.
A second reporting currency
The largest by a wide margin, and the one we would push back on hardest. Multi-book accounting is a different product and pretending otherwise would not serve anybody.
We put scope on a public page and dates in a written quote. If exchange differences are material to your reporting rather than a rounding line, describe the volume and we will scope it in writing.
Scope currency reportingWhat AWRA OpsHub does today
- A currency on customers, invoices and payments, and a currency per row on the customer statement.
- A financial snapshot on every sales document holding the country, currency, tax context, exchange rate and capture time.
- Documents that read at the rate that applied when they were raised, permanently, regardless of later changes.
- Foreign-currency invoices, credit notes, customer payments, POS sales and online collections posted to the ledger in base currency at the rate recorded on each document, with the currency, rate and original figure kept on every line.
- Realised exchange gain or loss booked to an exchange gains and losses account when a payment settles at a different rate from its invoice.
- A foreign document with no rate held off the ledger, shown as waiting for a rate, and audited — then posted when the rate is recorded.
- Indicative display currencies for reading figures in a familiar unit.
- Tax context frozen per document, so a rate change does not restate history.
More we can add to your workspace
- A second base currency. One organisation keeps one set of books, fixed at setup. Commission it
- Revaluation of open items at a period end, with the unrealised exchange gain or loss. Commission it
- A daily exchange rate captured automatically and offered on each document. Commission it
- Settlement of an invoice in a third currency, which is held and flagged today rather than posted. Commission it
- Consolidation across organisations, which is the shape you would use to report in two currencies. Commission it
Where we point you to a specialist
- Refusing to present a display conversion as a second set of books is a position rather than an omission, and we would argue for it.
- The base currency is a permanent decision at setup. Choose the currency your statutory reporting is in.
- This is market-neutral. It is the difference between transacting and accounting in more than one currency; this is a market where those two are routinely different.
Four questions that separate transacting from accounting
Can I produce a trial balance in two currencies?
A good answer sounds like
Yes, or an honest no.
What it actually means
This is the question. Ours is no. Everything else about multi-currency is downstream of it.
What happens to an open foreign-currency invoice at period end?
A good answer sounds like
A revaluation, or nothing.
What it actually means
Ours is nothing: it stays at its own rate until it is paid, and the realised difference posts then. Either is workable; not knowing means the difference appears as an unexplained gap.
Where is the rate on this document, and when was it captured?
A good answer sounds like
A stored value with a timestamp.
What it actually means
A document that resolves its rate at read time changes value daily. Ours does not.
Is the second currency a set of books or a display?
A good answer sounds like
A straight answer.
What it actually means
A display conversion described as multi-currency accounting is the most common overstatement in this category.
Choose your base currency once, correctly
It is permanent for the organisation and it should be the currency you file in, not the one you invoice in most. Ten minutes before setup, and never again.
Talk it throughFrequently asked questions
Can I change the base currency later?
Treat it as permanent. It is set per organisation and everything in the books is kept in it, so changing it once there is history is a data problem rather than a setting. Decide it at setup with your accountant in the room.
How do I handle the exchange difference at month end?
The realised part is already in the ledger: each payment that settled at a different rate from its invoice posted its gain or loss to the exchange gains and losses account. What remains is revaluing invoices still open at the period end, which is done outside the system with a named owner — every open document carries the rate it was raised at, so it is a spreadsheet rather than an investigation.
What happens to a foreign invoice with no exchange rate?
It is not posted. The invoice shows that it is waiting for a rate, the refusal is in the audit log, and once the rate is recorded the invoice posts at that rate. Nothing is booked at a guessed rate or at the raw foreign figure.
Does the statement add up two currencies?
Each row carries the currency of the document it came from, so a mixed-currency customer gets a statement that shows both rather than one that silently sums them. Read the running balance with that in mind — it is a sequence of rows rather than a single converted total.