Turning it on
Multi-currency is off until Project Five switches it on for your business: contact Project Five to activate it. Settings → Currencies shows whether it is on. While it is off nothing changes: every document is in your books' currency, and there are no rate fields.
Switching it on adds two accounts under Other income, Realised FX Gain/Loss and Unrealised FX Gain/Loss. They are kept apart because the two are treated differently: realised is what settling a document at a different rate earned or cost, unrealised is the period-end restatement of what is still open.
Your books stay in one currency, New Zealand dollars. Foreign currencies are converted into it. Currencies with three decimal places (such as the Kuwaiti dinar) can be used for a bank account, whose statements, receipts, payments and transfers keep all three places; documents stay in currencies with two decimal places or none. Currencies with four are not offered.
Currencies
On Settings → Currencies, add the currencies you deal in from the list. A currency that has exchange rates can't be removed, but you can deactivate it so it is no longer offered on new documents. Documents already raised keep their currency.
Exchange rates
Rates are entered on Settings → Exchange rates, which opens once you have added a currency. A rate says how many of your dollars one unit of the foreign currency buys. "1 USD = 1.6234 NZD" is entered as 1.6234.
There is one rate per currency per day. Entering a rate for a day that already has one replaces it. A rate can't be dated in the future.
Editing or deleting a rate never changes a document that was already raised: each document keeps the rate it was booked at.
Fetch today's rates fills in the European Central Bank's reference rate for every currency switched on, dated the day the bank published it (a Monday fetch gets Friday's). Easy also does this each morning at 05:20. A rate you typed for the same day always wins; a fetched rate shows *European Central Bank reference rate* in its note. A currency the bank does not publish (Fijian dollars, Pacific francs) still needs typing.
Old rates
When a rate is picked for a document, the latest rate on or before the document's date is used. A rate dated after the document is never used.
If that rate is older than the number of days set under Old rates on Settings → Currencies, it is flagged so you can confirm it instead of booking a weeks-old rate without noticing. With no rate on or before the date, you enter one.
Documents in another currency
With multi-currency on, an invoice, quote, credit note, bill, supplier credit note or purchase order has a Currency box beside its date. Choose the currency and the rate for the document's date is filled in; change the date of a new document and it follows. Type your own rate and it is never replaced.
- A rate a few days old is filled in but has to be confirmed before you can save.
- With no rate on or before the date, type one. You can save it to Exchange rates from the same screen if you can manage settings.
- A saved draft keeps its rate when you change its date. It offers the latest one instead.
- A customer or supplier can have a billing currency. It is only the starting point for a new document: change it whenever you like.
Under the totals you see what the document comes to in your books' currency. Each line is converted and rounded once, so the figure can differ by a cent from the total times the rate. It is the figure that goes to your accounts and the VAT return.
What your customer sees
An invoice, quote or credit note in a foreign currency names its currency in the header and shows every total with the currency code ("USD 1,782.50"). Line amounts are plain numbers.
A foreign invoice with VAT always carries a small NZD equivalent box under the totals: the rate used and the subtotal, VAT and total in NZD. The VAT is owed to RMD in NZD, so the box can't be turned off. It appears only on invoices, only when VAT is charged, and only for VAT-registered businesses.
Your bank details stay on a foreign invoice with a line saying which currency to pay in. A foreign invoice prints no "pay online" link at all: the card gateway and your own payment page both take NZD, so the customer pays by bank transfer.
A customer approving a foreign quote on the portal gets the invoice at today's rate. If you have no current rate for that currency they are asked to contact you, and the quote shows up under Mail → My actions until you have dealt with it.
Statements, reports and paying
A customer statement is in one currency. A customer who owes in two currencies gets two statements, and Send statements emails them once with a PDF for each. Aged reports have a row per customer per currency and a total in NZD that agrees with your Trade Debtors account.
Registers, the VAT return and the dashboard add up the NZD figures. Filtering and sorting invoices and bills by an amount compares NZD.
Getting paid, and paying, in another currency
Your bank account is in NZD, so a USD invoice is settled with NZD. On Record receipt (or Record payment on a bill) enter how much of the invoice the payment settles, in its own currency, and the NZD the bank actually received or paid. The screen shows the rate that works out to and the exchange gain or loss.
The invoice is still owed in USD until it is cleared: paying USD 400 of USD 1,000 leaves USD 600 owing, whatever the NZD came to. The last payment clears the invoice completely, so a rounding difference never lingers in Trade Debtors. The gain or loss goes to the Realised FX gain/loss account in the same entry, and Reports → Realised exchange gains and losses lists them by currency and month.
A receipt for a foreign invoice shows how much of the invoice it settled in its own currency, and the total received in NZD. The gain or loss is never printed for your customer.
A credit note in a foreign currency can only be applied to an invoice in the same currency. If the two were raised at different rates, applying one to the other books the difference as a realised gain or loss. Foreign bills are paid one at a time from the cash book; a payment run only takes NZD bills.
Revaluing at a period end
Between being raised and being paid, a USD invoice is carried at the rate it was booked at. At a period end, Accounting → Period close → Revalue restates everything still open in a foreign currency at the closing rate: invoices, bills, credit notes and the balance of a bank account held in another currency. The difference goes to Unrealised FX Gain/Loss in one entry.
- The closing rate for each currency is the latest one on or before the date. Change it on the screen if you use another. An old rate is flagged; the revaluation uses it as shown.
- A revaluation stays. The next one books only the change since the last, and a later payment's realised gain or loss is measured from the restated value. Invoiced at 1.60, revalued at 1.70 and paid at 1.68, a USD 1,000 invoice shows an unrealised gain of $100 and a realised loss of $20.
- Revalue before you lock the period. You can't date one before a revaluation that stands.
- Something paid or cancelled after the date is left out: its difference was realised when it was paid.
- Only the latest revaluation can be reversed, and only while its period is open and nothing it restated has been paid off since. Undoing a revalued invoice or bill takes its restatement back out on the date it is undone.
- A bank account's own balance (the figure on your statement) never changes; only what it is worth in NZD does.
Period close reminds you when foreign items are open and no revaluation has been made for the month. It does not stop you signing off.
Bills read from a photo or email
When a bill's document is in a foreign currency you have switched on, the bill is raised in that currency with the amounts as printed, and you confirm the rate. If the currency isn't switched on you are asked to enter the amounts in NZD.