Hope the title made sense. Basically I have a report that lists a series of transactions in Zambian Kwacha rather than my base currency of UK pounds. In the 'Report Configuration' I have NOT selected the option 'Convert values to Base Currency' and was therefore expecting the report to give the exact same values as those entered into the ledger. While the values are very close they aren't exact e.g. a value entered into the ledger as 20,500 ZMK is reported as 20,292.09 ZMK.

I presume that it has something to do with currency conversion, perhaps the ledger value is converted to the base currency using a historical conversion rate, which is then converted back to the foreign currency using a current conversion rate? Either way is there any way to stop this happening?

Thanks in advance
DJ

What report is it? There's no double conversion, but in some cases it might use the prices you entered, particularly if there are base currency categories involved.

Hei ku, thanks for your rapid response. The report is a customised categories report to show expenses for the last month. All of the expenses are expressed in ZMK (not the base currency), but they are slightly different from the absolute figures entered into the ledger.

Do you get the exactly value entered into the ledger on such a report?

Could I be doing something wrong?

Let me try to explain, because there's probably a conversion there.

The accounts have a currency, either the base one or another.
Categories have a currency too. By default, they have the base currency. Could you go to the categories view and check that?

Ah hah!

The categories that are being reported on have a base currency of £ sterling, while the entries to the category are in ZMK. So looks like they are being converted back and forth via slightly different exchange rates.

Am guessing short of changing the category base currency this is unavoidable?

If so then will just have to accept it as I have to regularly deal with 5 or more currencies so don't want to have multiple identical categories that use a different base currency.

Increase the price precision. That should minimize the rounding errors.

That helps a bit, but unfortunately I need the exact amounts.

No worries though...

Appreciate all your help!

There is a difference of 10% . That is not a rounding error. The only solution for this problem that I have found so far, is to duplicate categories. You need "Groceries GBP" and "Groceries ZMK", etc. You can also create different .kmy files, but then you cannot have unique reports.

check the conversion rates you have, because 10% is too much. Many of us have multi-currency expenses and don't have that problem.

I definitely don't get a 10% difference - more like 1% which I think is probably a rounding error / different conversion rates......

My error. Copied your amounts incorrectly when computing percentages. Apologies.