↑↓ selectEnter openEsc close

    1. Elbuz

    How to set up exchange rates and recalculate prices

    21 min readUpdated

    Elbuz updates exchange rates itself — from the national bank of your main currency or your own source — and recalculates foreign-currency supplier price lists with them.

    When you need this:

    • The supplier prices in dollars, you sell in hryvnias — one button recalculates prices at the latest rate.
    • The source rate jumped over 30% — Elbuz won't apply it until you confirm.
    • You buy currency above the bank rate — the “CB + %” markup adds the difference to the price.
    • You need the rate used a month ago — the history keeps each currency's rate by day.

    Where to start: check the rate source and schedule updates.

    What the currency list can do

    • Main currency — the reference point: catalog prices, document totals and profit are calculated in it.
    • Automatic updates — rates arrive on schedule or with the ⟳ button; a jump of more than 30% isn't applied automatically.
    • Built-in sources — national banks, the European Central Bank, PrivatBank and an aggregated market rate.
    • Your own source — rates from your accounting system or your bank via a link.
    • Your own rate for a price list — one supplier is calculated at its own rate, regardless of the currency list.
    • Price recalculation — price lists and the catalog at the new rate with one button.
    • Rate history — charts and daily snapshots, two years by default.

    How to choose the main currency

    One currency in the list is marked as the main one. Its rate is always one, and Elbuz calculates everything in it: catalog prices, document totals, profit. The rates of the other currencies answer the question “how much of the main currency does one unit of this currency cost”.

    You don't have to look for it in the grid: the summary bar above the list states how many currencies there are, how many are active, which one is the base currency, when rates were last updated and which provider is selected.

    The grid also has a separate “Main site currency” column. Only one currency can be marked in it: as soon as you check another one, the previous one is unchecked. This mark isn't passed to your site — what exactly gets exported is covered a little further down.

    The main currency is set once, at the start. Changing it in a working catalog changes the meaning of every price: the numbers stay the same but now mean something else. If you do have to change the main currency, first read what happens to catalog prices and open documents — it's right below.

    Each currency in the list has a few more fields: code (USD, EUR, UAH), symbols to the left and right of the amount, the number of decimal places for prices, and the activity, export to website and show on site checkboxes. Inactive currencies aren't updated and take no part in calculations.

    What the “Export to website” and “Show on site” columns mean

    • “Export to website” applies to export through the tunnel. The tunnel sends to the site only currencies that have both “Activity” and this checkbox on: code, name, rate and the accounting main currency mark. A currency without the checkbox isn't sent.
    • “Show on site” and “Main site currency” aren't sent by the tunnel at all. They don't affect which currencies your site shows or which currency it opens in — that's set up in the site's own admin panel.

    An Elbuz CMS store gets currencies not through the tunnel but together with the store settings during export. It receives every currency with “Activity” on and a rate.

    “Show on site” decides whether shoppers see the currency. The Elbuz main currency becomes the store's main currency and is always shown. “Export to website” has no effect on an Elbuz CMS store.

    What happens to documents if you change the main currency

    You can't simply uncheck “Main currency”: if you uncheck the only main currency, Elbuz silently restores it. Instead, make another currency the main one — then the mark is removed from the previous one automatically.

    At that moment Elbuz does three things: removes the mark from the previous main currency, sets the new one's rate to 1 and resets its “CB + %” to zero. Not a single line in documents, warehouses or reservations changes.

    That's why open documents stay calculated the old way:

    • the document total and the prices in its lines are the same numbers, in the document's own currency;
    • the rate recorded in the document when it was created or posted also stays — and all summary amounts are multiplied by it: settlements with the contact, tiles, reports;
    • so summaries are calculated at a rate taken against the old main currency. Until you fix the rate in the document, the totals will show the wrong figures.

    The former main currency keeps a rate of 1 until the first rate update: until then Elbuz treats it as equal to the new main currency one to one. Changed the main currency — click ⟳ right away.

    A document's rate is edited in its card, in the “Currency rate” field. If you change a document's currency, Elbuz fills in the rate as of the document date: the latest history record up to that date, or the list's current rate if there's no history for that period. A rate you entered manually stays untouched.

    Catalog and price list prices also stay the same numbers after the main currency changes. But the next recalculation will compute price list prices from the new main currency: its rate is 1, and the numbers in the price lists will now mean the new currency.

    How rates update automatically

    You don't enter rates manually every day — Elbuz fetches them. The source is chosen in the “Currency Source” dialog, which opens when you click the “Rates provider” tile above the currency table, and it's one per account.

    From this window an update runs in two ways: manually with the ⟳ button or automatically on schedule — menu ≡ → “Schedule setup”. While rates are loading, Elbuz shows “Updating currency rates, please wait...”, and when it's done — “Currency rates updated”.

    The default is “Automatic — by the base currency”: Elbuz uses the national bank of your main currency — bank.gov.ua for UAH, nationalbank.kz for KZT, nbp.pl for PLN, the European Central Bank for EUR, bnr.ro for RON, cnb.cz for CZK, bnm.md for MDL, tcmb.gov.tr for TRY, nbrb.by for BYN.

    For any other main currency it's open.er-api.com. The option shows the currently selected source in brackets. Alpha Vantage has been removed from the list: if you had it selected, rates are now fetched the same way as with “Automatic”.

    Currency Source dialog with the list of rate providers

    Rates come from the server cache rather than straight from the bank every time: on schedule and before a price list import, the source response is no older than 60 minutes; with the ⟳ button, no older than 5 minutes. So after changing the source, just click ⟳ to get fresh data.

    If the source doesn't respond, Elbuz takes the last good rate from the same source if it's no older than 24 hours and shows “Rate as of …, the source did not respond (…).” above the table.

    If there's none, rates stay as they were, nothing is written to the history, and above the table and in the “Operation log” you see “The exchange-rate source “…” returned no data — rates were not updated and nothing was written to the history. Choose another source…”. A zero or empty rate is never written.

    The rate changed by more than 30%

    A sharp rate jump more often means a source error than a real change, and prices depend on the rate.

    So on schedule, before an import and in flows, such a rate isn't applied: the currency keeps its old rate, and above the table and in the log you see “Rate not applied automatically — change exceeds 30%: USD 30 → 44.8871 (+49.6%). Check it and click ‘Get currency rates’ to apply it manually.” The other currencies update as usual.

    You can apply such a rate only manually: the ⟳ button asks “The rate changed by more than 30%: … Apply the new rate? Product prices depend on it.” with the “Apply” and “Cancel” buttons. If you've changed the main currency, the protection is skipped once: all rates are legitimately recalculated from the new main currency.

    Which rate source to choose

    The rule is simple: choose the national bank of the country whose currency is your main one. That's the official rate — the one your accountant uses — and your main currency is certain to be in it. If that bank isn't in the list, use open.er-api.com: it knows over 160 currencies and works with any main currency.

    Option in the listMain currency it works withGood to know
    Automatic — by the base currencyanythe default: the national bank of the main currency's country, otherwise open.er-api.com
    nationalbank.kz — National Bank of Kazakhstan (KZT)KZT, as well as UAH, USD, EUR, PLN, BYN, MDL, RON, CZK, TRYofficial rate of the National Bank of Kazakhstan
    bank.gov.ua — National Bank of Ukraine (UAH)UAH, as well as KZT, USD, EUR, PLN, MDL, RON, CZK, TRYofficial NBU rate; no Belarusian ruble
    nbp.pl — National Bank of Poland (PLN)PLN, as well as UAH, USD, EUR, RON, CZK, TRYno tenge
    ecb.europa.eu — European Central Bank (EUR)EUR, as well as USD, PLN, RON, CZK, TRYno hryvnia or tenge
    bnr.ro — National Bank of Romania (RON)RON, as well as UAH, USD, EUR, PLN, MDL, CZK, TRYno tenge
    cnb.cz — Czech National Bank (CZK)CZK, as well as USD, EUR, PLN, RON, TRYno hryvnia or tenge
    bnm.md — National Bank of Moldova (MDL)MDL, as well as UAH, KZT, USD, EUR, PLN, BYN, RON, CZK, TRYofficial rate of the National Bank of Moldova
    tcmb.gov.tr — Central Bank of Turkey (TRY)TRY, as well as KZT, USD, EUR, RONuses the selling rate; no hryvnia, zloty or Czech koruna
    open.er-api.com — ExchangeRate-API, 160+ currencies, any base currencyanynot a specific bank's rate but an aggregated market rate; updated once a day. Suits you when your country's national bank isn't in the list
    liqpay.ua — PrivatBank, selling rate (UAH)UAH, USD or EURPrivatBank's selling rate, only for the dollar, euro and hryvnia. No other currencies
    nbrb.by — National Bank of Belarus (BYN)BYN, as well as UAH, KZT, USD, EUR, PLN, MDL, CZK, TRYofficial rate of the National Bank of Belarus; no Romanian leu
    Your own source — by linkany, if it's in the source responserates from your accounting system or your bank (your own source)

    You can also pick another country's national bank — Elbuz converts the rates through your main currency. For example, your main currency is the hryvnia and the source is the National Bank of Poland: it publishes both the dollar and the hryvnia in zlotys, so Elbuz gets the dollar rate in hryvnias by dividing one by the other.

    The condition is the same as for your own source: your main currency must be in the bank's table. If it isn't (like the hryvnia at the European Central Bank), nothing is updated and the window shows the red message “The exchange-rate source returned no data — rates were not updated and nothing was written to the history.”

    Built-in sources have 15 seconds to respond. If one doesn't make it, the server cache from the last 24 hours is used; if there's none, rates stay as they were, and you can retry the update later.

    Only active currencies are updated, and only those that aren't the main one: the main currency's rate is one by definition. A currency the source doesn't have keeps its old rate — Elbuz doesn't warn you about it, so after changing the source, check the “Update date” column.

    If the source returned no data, the run stops right away: rates don't change, nothing is written to the history, and a red line appears in the log. A history snapshot and a regular line listing the rates appear only when data arrived.
    noyesyesno⟳ Get currency rates or scheduleDid the source return data thatincludes your main currency?Rates don't change, no history, redline in the Operation logEach active currency except themain oneDid the source give a rate thatdiffers from the current one?New rate, Change, Update dateThe currency keeps its old rateMain currency gets rate 1History snapshot and old recordcleanupUpdating currency rates line with thelist of rates in the Operation log
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    After a rate update, product prices aren't recalculated automatically. Recalculation is started separately — with the magic wand button in the same window. This is deliberate: otherwise every rate movement would rewrite the whole catalog.

    How to set your own rate and what overwrites it

    You edit a rate right in the grid: double-click the “Rate” cell, enter the new value, and the row is saved. Elbuz records it, shows the difference from the old rate in the “Change” column, puts the current time in “Update date”, and adds a history record with the source “Manual” — if there's no record for that day yet.

    This value lives only until the next rate update: it's overwritten silently, without asking and without any “edited manually here” mark.

    It's not only the ⟳ button that can overwrite it — rates are also fetched by the schedule, the “Refresh currency rates” action in Elbuz Flows, asking the AI consultant to update rates, and a price list import if “Refresh rates before import” is on in the settings (“System settings” → “Price lists” → “Import and parsing”, off by default).

    There are two ways to pin your own rate, and neither is in the currency list:

    • A rate for one price list. The price list column settings have “Exchange rate” and “+%” fields. If “Exchange rate” holds a value other than zero and one, the currency list isn't consulted for this price list at all — products are recalculated at your rate, whatever the list shows. More: what you set for an individual column.
    • Turn off “Activity” for the currency. The source doesn't update inactive currencies — but they also drop out of price recalculation: their rate isn't applied to products, and the price stays in the supplier file's currency.
    Column settings panel with the Currency group: currency, exchange rate and +%
    1Exchange rate field
    2+% field
    1. Exchange rate — the rate used to convert the column price (44.8 for USD).
    2. +% — a markup on this rate.

    Editing a rate manually affects price lists. Price lists with “Process the price list only if the file has changed” whose price or RRP is in this currency are imported next time even if the supplier file hasn't changed: Elbuz resets the stored file checksum on purpose so prices are recalculated at the new rate.

    And two actions Elbuz silently refuses. A standard-set currency's name and code can't be changed: the rest of the row is saved, these two stay as they were. Nor can such a currency be deleted — “Entry deleted” appears and the row leaves the grid, but returns after the next update. Turn off a currency you don't need with “Activity”.

    How to connect your own rate source

    Built-in sources don't suit everyone: some get rates from their own accounting system, others from a bank they have a contract with. For these cases there's the your own link option: you enter the address Elbuz fetches rates from, and everything else works the same.

    The requirements for what's behind the link are simple but strict. The address must return JSON with two fields:

    • base — the code of the currency the rates are quoted against;
    • rates — a list of “currency code → rate”.

    It looks roughly like this:

    {"base": "USD", "rates": {"UAH": 41.5, "EUR": 0.92, "PLN": 3.95}}

    The list must include your main currency's code. Without it Elbuz can't calculate cross rates and updates nothing; the window shows the red message “The exchange-rate source returned no data — rates were not updated and nothing was written to the history.” This is the most common cause of “I connected my own source, but the rates are old”.

    Elbuz then calculates cross rates itself: it takes your main currency's rate in the source and divides it by the rate of each other currency. So it doesn't matter which currency the source uses as its base — as long as your main currency is there.

    Two more details. If the source uses a different code for a currency, its additional code works — Elbuz searches by the main code, then by the additional one. This applies to all currencies except the main one: its code in the source must match the list. The response gets 30 seconds, so the source must be fast.

    How to recalculate prices at the new rate

    A fresh rate in the currency list changes nothing by itself: prices in price lists and in the catalog stay as they were calculated last time. Recalculation is started by a separate magic wand button in the same window — its tooltip reads “Apply markup to products from price lists”.

    Toolbar of the Currencies and rates window with the tooltip on the magic-wand button
    1Get currency rates
    2Apply markup (magic wand)
    3Additional operations menu
    1. Get currency rates — fetches the rates from the selected provider.
    2. Magic wand — applies the markup to products from price lists; the tooltip is shown.
    3. Additional operations menu — holds the schedule settings.

    There's no choice of what to recalculate: the button takes all active price lists of active suppliers. A disabled price list or supplier is skipped silently.

    For each price list Elbuz does four things in a row:

    1. resets the price and RRP to the original values from the supplier file — those before any markups;
    2. applies the rate: from the currency list first — together with the “CB + %” markup, just as during a price list import — or, if the price list has its own rate in the column settings, that one. A currency with “Activity” turned off gives no rate: prices in it stay in the file's currency;
    3. runs all of this price list's markup rules again;
    4. recalculates field formulas — first the price list's own rules, then those shared by all price lists.

    After the price lists, base catalog prices are recalculated as a separate step — but by the base catalog markup rules from the purchase price, not from the price list. This run doesn't carry the new price list price over to catalog cards.

    Two forks decide whether the rate reaches the price: whose rate is used — the price list's or the currency list's, and whether the price list has the “Price + exchange rate” markup type. Without this type the rate isn't applied at all.
    yesnoyesnoMagic wand button — all activeprice lists of active suppliersPrice list price and RRP reset to theoriginals from the fileDoes the price column have its ownExchange rate?Rate from the price list columnsettingsRate from the currency list plus CB+ %, a disabled currency gives norateDoes the markup list include thePrice + exchange rate type?Price is multiplied by the rate, thenthe other markup rulesMarkup rules without multiplying bythe rateField formulas — price list's, thensharedBase catalog prices by base catalogmarkup rules, except Fixed Priceand Do not updateLog: Markup/discount applied
    • Start or end
    • Action or result
    • Decision: the path depends on the answer

    The rate step runs only for price lists whose markup list includes the “Price + exchange rate. Settings source: currency list + price list.” type. Without it the price list is recalculated without the rate, and its prices stay as before. This is the most common cause of “I clicked it, but some price lists didn't change”.

    Markup types window with the chain of markup types for the price list
    1Price + exchange rate
    1. The first line, “Price + exchange rate”, takes its settings from the currency list and the price list.

    Base catalog products flagged “Fixed Price” and “Do not update” aren't touched by the base catalog markup rules — their price stays the one you set.

    Elbuz reports progress in the “Operation log”: each price list gets the line “Apply markup/discount (without loading the price list)”, and at the end — “Markup/discount applied”. If the last line is missing, the run didn't finish; some price lists were recalculated and some weren't, and running it again fixes that.

    There's no queue here: recalculation runs within the same request while the window waits for the response. Meanwhile the button is locked and the screen shows “Processing data, please wait”; when it's all done, “Operation completed successfully” appears. If you close the window, you'll see neither the confirmation nor an error, and you'll have to check the log.

    There's no cap on the number of products: Elbuz recalculates each price list as a whole, with a set of database queries rather than row by row.

    The “CB + %” rate markup

    The grid has a “CB + %” column — a markup on the rate in percent. You need it when you don't want to sell exactly at the source rate: the bank rate and the rate at which you actually buy currency usually differ, and that difference should be in the price rather than eat into your margin.

    The markup applies to the rate, not to the product price: all recalculations after it use the increased rate.

    How to view rate history

    The separate “Rate history” window shows what happened to each currency: a trend chart, a chart of percentage change over the period and a table of daily snapshots. The period is chosen at the top — from 30 days to all history.

    A snapshot is written once a day for each currency, and not only on updates from the source: editing a rate manually and applying a rate to a document also leave a record.

    The retention depth is set with the broom button; by default history is kept for 730 days, i.e. two years. Older records are deleted automatically on every rate update, and the same place has a button to remove them right away.

    Clearing the history doesn't affect documents. The rate a document was calculated at is stored in the document itself — so even if you cut the history down to a month, last year's invoice stays correctly calculated.

    Scenarios

    The supplier gives a price list in dollars, but you need prices in hryvnias

    What to turn on. In the price list card, “Columns” → “Column wizard”, open the “Price” row's column settings and pick USD in the “Currency” group; leave “Exchange rate” at 0. Make sure the price list's own chain of markup types has “Price + exchange rate. Settings source: currency list + price list.” — new price lists get it. General pricing rules don't replace it: only this type applies the rate. Then import the price list.

    What you get. During repricing the price from the file is multiplied by the USD rate from the currency list, plus the “CB + %” markup if it's filled in. The next types — markup, rounding — are calculated from the hryvnia price. When the rate changes, the next import or the magic wand button recalculates the prices.

    What won't happen. No rate formula is needed. With the column currency set, adding {Price list: Price} * {CURRENCY_RATE_USD} applies the rate twice: the formula multiplies a price repricing already converted to hryvnias (or vice versa). Without the “Price + exchange rate” type in the price list, the column currency does nothing: the price stays in dollars.

    The supplier sends a price list in dollars, you sell in hryvnias and want a fresh rate every day

    What to turn on. Choose the source in the “Currency Source” dialog (click the “Rates provider” tile) and schedule updates: menu ≡ → “Schedule setup”. The supplier's price list must have “Price + exchange rate. Settings source: currency list + price list.” among its markup types. After rates update, click the magic wand “Apply markup to products from price lists”.

    What you get. The schedule updates rates in the currency list, and the magic wand recalculates all active price lists of active suppliers at those rates.

    What won't happen. The scheduled task only fetches rates — it doesn't recalculate price list or catalog prices; only the magic wand or the next price list import does that. Documents already created keep their own rate.

    The supplier uses its own rate, not the source rate

    What to turn on. In the price list card, “Columns” → “Column wizard”, open the price row's column settings; in the “Currency” group set the column currency and an “Exchange rate” other than 0 and 1 (0 takes the rate from the currency list, as above). For a markup on this rate, fill in “+%” — but the magic wand ignores it: for products in the column currency it uses the plain “Exchange rate”.

    What you get. This price list is recalculated at your rate, and the other price lists as before, from the currency list.

    What won't happen. Currency list updates don't affect this price list, and the currency list itself doesn't change either: the rate in the column settings lives only in this price list.

    Rates must come from your accounting system or your bank

    What to turn on. In the “Currency Source” dialog, select “Your own source — JSON by link” and enter the address in the field of the same name below the list. The response must contain base and rates, and rates must include your main currency's code.

    If the source names some other currency differently from the currency list, give it an additional code. The additional code doesn't work for the main currency: in rates it must be under the same code as in the list.

    What you get. Elbuz calculates cross rates itself: it divides the main currency's rate in the source by the rate of each other currency. The response gets 30 seconds.

    What won't happen. If rates lacks the main currency's code or the source doesn't respond, nothing is updated: the window shows the red message “The exchange-rate source returned no data — rates were not updated and nothing was written to the history.”, the “Operation log” gets a red line with the same text, and nothing goes to rate history.

    A price list must be imported at a rate that's fresh at import time

    What to turn on. “System settings” → “Price lists” → “Import and parsing”, the “Refresh rates before import” switch (off by default).

    What you get. Before a price list import, the import log gets a separate step, “Loading currency rates”. The source is queried only if nobody did in the last hour (via ⟳, the schedule or a previous import; failed attempts count too, so a dead source won't slow every price list). Otherwise the list's current rates are used.

    What won't happen. A rate you fixed manually in the currency list won't survive: the first price list import that queries the source overwrites it with the source value if it differs. If you need a fixed rate for one supplier, use the previous scenario.

    What to do when rates or prices are wrong

    A rate update broke off

    Elbuz first gets the full response, then writes rates one currency at a time in a quick pass. So a break during the request — lost connection, closed window — changes no rates. A mix of new and old rates is possible only if the break hits the writing. The “Update date” column shows which: updated currencies have today's date.

    The history snapshot, old record cleanup and the log line are done at the very end, after all currencies. A broken run leaves no “Updating currency rates” line in the “Operation log” (Account → Operation log) — that's the sign it didn't finish.

    A completed run puts the list of resulting rates there; if the source returned nothing, the line is red, with the text “The exchange-rate source returned no data — rates were not updated and nothing was written to the history.”

    It's safe to retry. A rate is overwritten only if it differs from the current one, and the history holds one record per currency per day — a second run on the same day doesn't duplicate anything.

    The history keeps the first value of the day, not the last. If rates came from the source in the morning and you corrected a rate manually in the afternoon, the chart for that day keeps the morning number marked “Provider”. The currency list itself will have your value.

    There's one difference with the schedule. If a scheduled run breaks off, the task stays marked as running, and the scheduler skips it next time. A watchdog releases such a lock once an hour has passed since the start — after that the schedule works as before. You can update rates manually with ⟳ before then.

    Prices were recalculated at a wrong rate

    It happens: the source returned an odd number or someone typed a rate with a mistake, and the recalculation has already run. There's no separate “cancel” button — and you don't need one here.

    Recalculation always starts from the original price in the supplier file, so a wrong rate isn't layered on top of the previous one. Here's what to do: fix the rate in the currency list — manually or by updating from the source — and click the recalculation button again. Prices will be as if the wrong run never happened.

    One exception: if a price list's original price is zero and the current value wasn't written by markup steps, it isn't reset to the original — such a price stays as it was.

    To see exactly which rate a specific product was calculated at, use its context menu: “Product markup history”. It shows the original price and every step in turn, including the “Rate:” line with the applied value. And the “Rate history” window shows which rate the currency list had that day.

    Recalculation doesn't touch documents. The rate an invoice or order was calculated at is stored in the document itself, and the button in the currency list doesn't change it. If a wrong rate got into a document, fix the “Currency rate” field in that document.

    What you seeWhyWhat to do
    Clicked “Get currency rates” — nothing changedthe source returned no data (then the red “The exchange-rate source returned no data — rates were not updated and nothing was written to the history.” appears), or it has none of your active currencieswith the red message, try later or choose another source; without it, check the “Update date” column and the currency codes
    Above the table: “Rate not applied automatically — change exceeds 30%…”the source gave a rate that differs from the current one by more than 30%; such a rate isn't applied automaticallycheck the rate with your bank and click ⟳ → “Apply” (rate jump)
    Above the table: “Rate as of …, the source did not respond”the source is unavailable right now; the last rate from the server cache (up to 24 hours) was usednothing; click ⟳ later or choose another source
    Your own source is connected, but rates are oldthe response lacks your main currency's code — cross rates can't be calculated without itadd the main currency to the rates list of your source
    Only some currencies updatedthe rest aren't in the source under the code you havegive the currency an additional code — the one the source uses
    Rates updated, but catalog prices are oldprice recalculation is separate and doesn't start by itselfclick the price recalculation button in the same window
    Fixed a rate manually — the next day it's different againthe rate was overwritten by the next update: the schedule, a flow, or a price list import with “Refresh rates before import” onpin your rate in the price list column settings or turn off “Activity” for the currency (manual rate)
    Recalculated prices at a wrong rateno harm done: recalculation always starts from the original price in the supplier filefix the rate and click the recalculation button again (wrong rate)
    Clicked recalculation — some price lists didn't changetheir markup list lacks the “Price + exchange rate” typeadd this markup type to the price list (price recalculation)
    Deleted a currency, but it came backcurrencies from the standard set are system ones and can't be deleted, even though the message says otherwiseturn off “Activity” for it — it will no longer take part in calculations
    The history is emptythere are no snapshots for the selected period — either the period is short or rates haven't been updated for a long timewiden the period or update the rates
    The rate in a document doesn't match the current onethat's expected: a document stores the rate as of its creationnothing; that's exactly why you can clear the history without affecting documents

    FAQ

    Which rate source should I choose?

    Leave “Automatic”: Elbuz takes the national bank of your main currency's country, or open.er-api.com if that bank isn't in the list. Have a contract with a bank or your own accounting system — connect your own link (all sources).

    Why wasn't the new rate applied, with a 30% warning above the table?

    The rate changed by more than 30% — this is how Elbuz protects prices from a source error. Check the rate and click ⟳: you'll be asked “Apply the new rate?”, and after “Apply” the rate is saved.

    What format should my source return?

    JSON with the base and rates fields, where rates is a list of “currency code → rate”. A must: the list has to include your main currency's code, otherwise Elbuz can't calculate cross rates.

    Why did prices stay old after a rate update?

    Price recalculation is a separate action, the magic wand button in the same window. This is deliberate: otherwise every rate change would rewrite the whole catalog without your knowledge.

    What's the “CB + %” column for?

    It's a markup on the rate. If you buy currency above the bank rate, enter the difference in percent, and all recalculations will use your rate.

    How long is rate history kept?

    730 days by default. You change the period with the broom button in the history window; old records are deleted automatically on every rate update.

    Can I roll back prices recalculated at a wrong rate?

    You don't need to: recalculation always starts from the original price in the supplier file. Fix the rate and click the recalculation button again (wrong rate).

    What happens to open documents if I change the main currency?

    Nothing is recalculated: the totals and the rate recorded in the document stay the same, and summary totals will be calculated against the old main currency. Fix the “Currency rate” field in the document itself (changing the main currency).

    Where to find it and who has access

    Menu
    Directories → Currencies and rates
    Update rates now
    the ⟳ button in the currency list window
    Rate history
    from the same window, the “Rate history” button
    Access right
    the “Currencies and rates” and “Rate history” windows
    The Currencies and rates window: currency grid with the rates provider panel on the right
    1Rate
    2Main currency mark
    3CB + %
    4Rates provider
    1. Rate — how much of the main currency one unit of this currency costs.
    2. Main currency mark — its rate is always 1 and everything is calculated in it.
    3. CB + % — a markup on the rate when you buy the currency above the bank rate.
    4. Rates provider — where the program takes the rates from.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free