Exchange rate
Copy for AI
When you bill in a currency other than your base currency, easySales converts the invoice at an exchange rate. This page shows how to check that rate and change it while the invoice is a draft.
Before you start
Section titled “Before you start”You need Invoice Add or Edit. The invoice must be new or a draft: once it is issued, its rate is fixed. An invoice in your base currency has no rate to set.
- On a new invoice, or a draft you are editing, choose the Currency.
- Read the line under it, for example Exchange rate 1 USD = 1.351200 SGD · MAS with the date of that rate. This is the automatic rate.
- To use a different rate, select Change rate. The Exchange rate panel shows the Current rate and the Automatic rate.
- Type the New rate, up to twelve decimal places. Under it, the panel shows how far your rate is from the automatic one, such as -5.3% vs MAS. A very small rate, such as the MAS rate for VND of 0.00004884, can be typed exactly.
- Select Apply.
- To go back to the automatic rate later, open the panel again and select Use automatic rate.
- Save the invoice.
What happens next
Section titled “What happens next”The invoice converts at the rate you chose, and the line now reads set by hand and says what the automatic rate would be. When you issue the invoice, its rate is fixed: the PDF, the customer’s receivables and the statement all use it, and it does not change when rates move later.
Rules to know
Section titled “Rules to know”- A rate more than 5% away from the automatic rate shows an amber warning, such as More than 5% from the MAS rate — double-check before you continue. You can still apply it.
- A rate must be above zero, with at most twelve decimal places. The rate line shows at least six decimal places, and more when the rate needs them.
- If there is no automatic rate for the currency, the line says so; enter a rate by hand.
- On an issued invoice Change rate is greyed out: The rate is fixed once the invoice is issued. To bill at a different rate, cancel the invoice and issue a new one.
- A credit note raised on the invoice, including the one that cancels it, converts at the invoice’s own rate.
- A Singapore GST-registered company whose base currency is not SGD needs an SGD rate for the invoice’s currency to issue a foreign-currency invoice that charges GST; the PDF prints the SGD amounts at that rate. The draft shows this rate on a second line, SGD rate for tax. If there is no rate, issuing is refused; for a USD invoice the message reads “This invoice is in USD and must show its SGD equivalent, but there is no exchange rate from USD to SGD. Add a rate for USD, or type the SGD rate on the draft, then issue again. Nothing was issued.”
- You cannot add rows to the rate table yourself; set the rate on the draft. Open the saved draft, select Change rate on its SGD rate for tax line, and the SGD rate for tax panel shows the Current rate and Automatic rate. Type the New rate and select Apply, or select Use automatic rate. Save the invoice, then select Issue. This needs Invoice Edit.
- The SGD rate for tax line follows the same rules as the exchange rate: the same 5% warning, set by hand once you change it, and fixed when the invoice is issued.
- Refresh rates, under System settings → Currency & FX → Exchange rates, needs System Edit. It only asks for the rates to be fetched again; it does not add a currency the rate table is missing.
- When the customer pays, you must also enter what arrived in your base currency, such as Amount in SGD. easySales compares it with the invoice’s rate to measure the exchange gain or loss; see Record a payment.
Why it works this way
Section titled “Why it works this way”The rate is fixed when the invoice is. An issued invoice records a sale in your books at a value in your base currency. If that value moved with every new rate, your sales figure for a closed month would change after you had reported it. Fixing the rate at issue keeps the invoice, its credit notes and the customer’s statement on one value.
What the bank pays is measured separately. The customer owes the invoice’s own currency, and the money that reaches your bank in your base currency rarely matches the invoice’s value exactly. The difference is a realised exchange gain or loss in your records, not a balance left on the invoice for the customer to settle.
A rate set by hand is allowed, and checked. A contract may fix a rate, so you can type it. A slip such as 13.512 for 1.3512 would put a wrong sale in your books, so a rate more than 5% from the automatic one is flagged before you apply it.
Singapore wants GST in SGD. A Singapore tax invoice in a foreign currency must also show its amounts in SGD, so a company with another base currency needs an SGD rate before it can issue one.
Work faster
Section titled “Work faster”- Leave the automatic rate on most invoices. It fills itself in from the rate table and is fixed at issue, so there is nothing to type. See Currency and rates.
- Read the percentage before you apply. The figure under New rate tells you at once whether a typed rate is close to the automatic one or off by a slip of the decimal point.
- Set the agreed rate again on a copy. Copy prices a new invoice at today’s tax and exchange rates, so a contract rate typed on the original does not carry over. See Copy an invoice.
- Enter the bank’s figure when the money arrives. Type what your bank credited in Amount in SGD while you record the payment; the gain or loss is worked out for you. See Record a payment.
- Review every gain and loss in one list. On the Invoices list, open the ··· menu and select Exchange differences under Registers. See Exchange differences.
Examples
Section titled “Examples”Lim & Co bills Bayview Hotel Group USD 5,000.00 for a lobby styling project. The rate line reads Exchange rate 1 USD = 1.351200 SGD · MAS, so the invoice is worth SGD 6,756.00.
The hotel agreed a rate of 1.280000 in its contract, so Mei Tan selects Change rate and types it. It is 5.3% below the automatic rate and the panel shows the warning; Mei checks the contract and selects Apply. The invoice is now worth 5,000.00 × 1.280000 = SGD 6,400.00, and the line reads set by hand · automatic would be 1.351200.
She saves the draft, then issues it, which fixes the rate for good.
The payment arrives. Three weeks later the hotel pays USD 5,000.00 and Lim & Co’s bank credits SGD 6,380.00. Daniel Lim records the payment and types 6,380.00 in Amount in SGD. The invoice reads Paid, because the customer paid the full USD 5,000.00. The receipt’s Exchange gain/(loss) section reads “At the invoice rate SGD 6,400.00 · received SGD 6,380.00”, a loss of SGD (20.00): 6,380.00 − 6,400.00 = −20.00.
A slip caught by the warning. Mei types 13.512 for another USD invoice. The panel shows the amber warning and +900.0% vs MAS, since (13.512 − 1.3512) ÷ 1.3512 = 9, or 900%. She corrects it to 1.3512 before selecting Apply.
Common questions
Section titled “Common questions”- Where does easySales get its exchange rates? From the rate table under System settings → Currency & FX → Exchange rates. The line under Currency names the source and the date, such as MAS.
- Can I change the exchange rate after issuing an invoice? No. The rate is fixed at issue. To bill at another rate, cancel the invoice and issue a new one. See Cancel an invoice.
- Why does the panel warn me about my rate? The rate you typed is more than 5% away from the automatic rate. Check it; if it is right, select Apply anyway.
- How many decimal places can an exchange rate have? Up to twelve, so even a very small rate such as 0.00004884 is stored exactly.
- Why did the customer’s payment come to less in SGD than the invoice? The bank converted at its own rate on the day it was paid. The difference is recorded as an exchange loss; the invoice is still paid in full. See Exchange differences.
- Does a copied invoice keep the original’s exchange rate? No. A copy is priced at today’s tax and exchange rates. Set the agreed rate again with Change rate before you issue it.