The Exchange Rates Used report shows the exchange rate that Kolleno used on each day to convert your balances into your company currency. Use it to compare the Net Balance on your dashboard with your accounting system.
Generate the report
Go to Reports → Aging Analytics → Exchange Rates Used. Select a From date and a To date, then generate the report. A range can have a maximum of 92 days. The report downloads as an Excel file.
To download or schedule a report, see Using Reports in Kolleno.
Where the rates come from
Kolleno gets its rates once a day from the European Central Bank (ECB). For a currency that the ECB does not publish, Kolleno uses a third-party rate provider. Each day uses the rates of the previous working day.
On weekends, on holidays and when the ECB is not available, Kolleno keeps the last rate for a maximum of 5 days. When neither currency is EUR, Kolleno calculates the rate from the two EUR rates. For example, CAD to USD = EUR to USD ÷ EUR to CAD.
For more, see How Foreign Exchange (FX) Rates Work in Kolleno.
What is in the file
Exchange Rates has one row for each currency and each day of the range:
Day: the day that Kolleno used the rate.
From and To: the currency of your records and your company currency.
Rate: the amount in your company currency for 1 unit of the From currency. To convert an amount, multiply it by the rate.
Rate date: the date of the rate, usually the previous working day.
Method: Published rate, Inverse of the EUR rate, Cross rate through EUR, or No rate.
Record Exchange Rates lists the records that use their own rate from your accounting system, for example NetSuite, instead of the Kolleno rate. Each row shows the record rate next to the Kolleno rate of the same day. See Use NetSuite Exchange Rates.
Common questions
Why does a row show No rate?
Kolleno found no rate in the 5 days before that day, so it cannot convert balances in that currency. If this continues for more than a few days, contact support@kolleno.com.
Why is one of my currencies missing?
The report shows only the currencies of the invoices, credit notes and journal entries that are dated in the range or open today.
Why does my accounting system show a different rate?
Your accounting system can use a different rate provider. If you use NetSuite, Kolleno can use the NetSuite rate of each record.