Skip to content
Select language: English

Currency and rates

Copy for AI
Use AI with help

Lim & Co keeps its books in one base currency, but a quotation or invoice can be in another currency — the one the customer is charged in. The exchange rate on the invoice turns its amounts into your base currency. This page explains where that rate comes from and when it stops changing; to set one, see Invoice exchange rate.

How the quote-to-cash records connect: an account has contacts and opportunities; an opportunity holds quotations; a quotation is billed on one or more invoices; a receipt pays invoices; a credit note reduces one invoice; a refund pays back unapplied money or remaining credit.Contacta person thereAccountthe customerOpportunityoptional · the dealQuotationoptional · the offerReceiptmoney receivedInvoicewhat the customerowesCredit notea correctionRefundmoney paid backhas peoplehas dealsholds one or morebilled on one or morepays withpays one ormorereduces oneunapplied moneyremaining credit

Every money record in the chain has a currency, and they follow the invoice:

  • A quotation and an invoice each have their own Currency. An invoice raised from a quotation keeps the quotation’s currency.
  • A credit note is always in its invoice’s currency and converts at the invoice’s rate.
  • A receipt is in the currency of the invoices it pays. One receipt takes one currency.
  • A refund is in the currency of the receipt or credit note it pays back.

Your base currency is set when your company’s account is created and cannot be changed. It is shown under System settings → Currency & FX, where Exchange rates lists the current rates.

  1. Draft. When you choose a foreign currency, the invoice takes the automatic rate for that day, shown under the fields with its source and date. You can select Change rate to use your own; if it is more than 5% away from the automatic rate, easySales warns you but lets you apply it.
  2. Issue. The rate is fixed with the invoice’s other figures. It no longer changes when rates move, and the PDF, receivables and statements all use it.
  3. Payment. Record the amount received in the invoice’s currency, and what reached your bank in your base currency. The second figure is required: easySales fills it in at today’s automatic rate, and you change it to the bank’s figure.
  4. In your base currency. On the account’s receivables and the customer’s statement, the invoice and every payment and credit note against it convert at the invoice’s fixed rate. An invoice paid in full therefore nets to zero, whatever the bank credited.
  5. Exchange gain or loss. The gap between the invoice’s rate and what the bank credited is a realised exchange gain or loss. easySales shows it on the receipt and in a register, for your own records only; see Exchange differences.
  • An invoice raised from a quotation takes the automatic rate of the day it is raised, not an earlier rate. Change it on the draft if you agreed a rate with the customer.
  • A foreign invoice with no recorded rate is left out of the account’s totals in your base currency and listed separately.
  • An invoice in your base currency has no rate to set.
  • A refund in a foreign currency also asks what left your bank in your base currency. See Refund a customer.
  • Base currency — the currency your company measures its records in.
  • Document currency — the currency shown and charged on one quotation, invoice or credit note.
  • Exchange rate — how many units of your base currency one unit of the document currency is worth.
  • Automatic rate — the published rate easySales offers for the day.
  • Refreshing the exchange rates does not change an issued invoice’s rate.
  • A foreign payment does not create a balance on the invoice because the bank converted at a different rate. The invoice is settled in its own currency.
  • The document currency does not replace your base currency.

The rate line and Change rate are on the invoice form; see Invoice exchange rate. Base currency and Exchange rates are under System settings → Currency & FX; see System settings.

Your figures need one measure. Outstanding, the ageing and the statement add up invoices in many currencies, and they can only be added in one. The base currency is that measure, and it never changes, so last year’s figures keep their meaning.

The customer owes the invoice’s currency. A customer who was invoiced USD 2,000.00 and paid USD 2,000.00 has paid in full, whatever the bank credited you. Settling each invoice in its own currency keeps a rate movement from leaving a balance the customer does not owe.

Everything against an invoice uses its rate. Payments and credit notes convert at the invoice’s fixed rate, so the account and the statement show a paid invoice at zero, exactly as the customer sees it. What the bank really credited is measured apart, as an exchange gain or loss for your own books.

One receipt is one sum of money. A receipt matches one amount that reached your bank, and that amount is in one currency. Payments in two currencies are two receipts, each matched to its own bank line.

  • Leave the automatic rate on most invoices. It is filled in for you and fixed at issue; change it only when a contract fixes a rate. See Invoice exchange rate.
  • Set an agreed rate as you raise the invoice. An invoice raised from a quotation starts at that day’s rate, so change it on the draft before you issue it. See Raise an invoice.
  • Type the bank’s figure as you record the payment. Amount in SGD, or your own base currency, takes what your bank credited, and 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.
  • Check the rate table before a batch of foreign invoices. System settings → Currency & FX → Exchange rates shows each rate’s source and when it was last refreshed. See System settings.

Lim & Co’s base currency is SGD. On 5 October Mei Tan invoices Pacific Resorts Ltd USD 2,000.00 for design work, at the automatic rate of 1 USD = 1.350000 SGD.

  1. She issues the invoice. Its rate is now fixed, and the account’s receivables count it as SGD 2,700.00 (2,000.00 × 1.35).
  2. On 3 November the customer pays USD 2,000.00. The bank credits SGD 2,690.00 after converting at its own rate.
  3. Mei selects Record payment, keeps Amount received at USD 2,000.00 and changes Amount in SGD to 2,690.00.

The invoice reads Paid. On the account’s receivables the payment converts at the invoice’s rate, SGD 2,700.00, so the balance is zero. The receipt keeps SGD 2,690.00 as what actually arrived and shows a realised exchange loss of SGD (10.00): 2,690.00 − 2,700.00.

Mei issues a second invoice to Pacific Resorts Ltd for USD 2,000.00 at the same fixed rate of 1.350000, so SGD 2,700.00. One item is returned, and she issues a credit note for USD 200.00. It is in USD and converts at the invoice’s rate: SGD 270.00 (200.00 × 1.35). The receivables now count SGD 2,430.00 (2,700.00 − 270.00).

The customer pays the USD 1,800.00 left, and the bank credits SGD 2,412.00. Daniel Lim types 2,412.00 in Amount in SGD. The payment counts as SGD 2,430.00 (1,800.00 × 1.35), the invoice reads Paid, and the receipt shows a realised loss of SGD (18.00): 2,412.00 − 2,430.00.

Bayview Hotel Group owes Lim & Co SGD 1,090.00 on one invoice and USD 500.00 on another, and pays both on the same day. Daniel records two receipts: one in SGD for SGD 1,090.00, and one in USD for USD 500.00 with the SGD the bank credited. Each matches its own line on the bank statement.

  • What is a base currency? The one currency your company measures its records in: outstanding balances, the ageing and statements are all shown in it. Lim & Co’s is SGD.
  • Can I change my company’s base currency? No. It is set when your company’s account is created and cannot be changed. See System settings.
  • Does an invoice raised from a quotation keep the quotation’s currency? Yes. It takes the automatic rate of the day it is raised; change the rate on the draft if you agreed another.
  • Can one receipt pay invoices in two currencies? No. A receipt takes one currency. Record one receipt per currency. See Record a payment.
  • Can a credit note be in a different currency from its invoice? No. A credit note is always in its invoice’s currency and converts at the invoice’s rate. See Create a credit note.
  • Why is a foreign invoice missing from the account’s SGD totals? It has no recorded exchange rate, so it cannot be converted. The account lists it separately under its totals.
  • Which currency is a refund recorded in? The currency of the receipt or credit note it pays back, with what left your bank in your base currency beside it. See Refund a customer.