To calculate yearly foreign interest income for tax return, the exchange rate matching the date of the interest payment has to be used. Currently the way I do this is to export all original interest transactions with Amount Entered in different currencies (EUR, GBP, USD) and download the table of daily exchange rates for the whole year and then use a vlookup function in LibreOffice Calc to find the correct rate. I already load the exchange rates into Skrooge too, so it would be nice to pick it up directly from there.

In the Operations view there is no column that uses or shows the original exchange rate (the Amount column uses the current/latest exchange rate) and I can imagine adding such a column would slow down the view considerably. Or should I submit this as a wishlist bug?

Alternatively, there a way to create a "Monthly" report that picks up the original fx rate matching the operation date? Figuring out how to define a monthly report is not trivial so I want to make sure it is even possible before spending a lot more time on it. If this could work, then it would useful to be able to select Custom date ranges for the Monthly Report, since the UK tax year runs from April 6-April 5...

Hi,

I don't know exactly what kind of report your need.
If you give me more details (some examples of operations and the expected result), I will be able to tell you if this is already possible (may be with monthly report) or we can imagine to develop a new plugin to compute this kind of reports.
Regards.

PS: In "Monthly" report, you can do all queries you need, so you should be able to do this kind of report but this is clearly not easy if you don't know the skrooge data model. That's why it's may be better to describe me what you need.

Hi,

Sorry, I'm having trouble getting a table in the forum without the formatting getting messed up, but hopefully this is readable.

I'd like to generate one report that picks up all operations from all accounts (between two dates) that have category dividend or interest. For those I want to see the amount in the original currency (amount entered) and the amount at the date of the operation in my base currency. In my example this is €.

The normal translation of "Amount entered" -> "Amount" always uses the current/latest exchange rate. But I need the exchange rate at the time of the payment to be used. If for each operation I see either the correct rate ("Exchange rate" column in my example) or the correctly translated amount ("Amount at time") then I'm happy, because I won't need to perform a lookup using the currency code into a historical table of exchange rates in LibreOffice anymore.

Code: Select all

British Pound Unit Values                     
2017-Jan-1   1.5                  
2017-Aug-1   1.4                  
2018-Jan-1   1.3                  
                     
Account      Category   Date      Amount   Amount entered   Exchange Rate   Amount at time
UK stock   dividend      2017-Jan-1   € 130   £100         1.5            € 150
EU Bank      interest      2017-Apr-1   € 100   € 100         1            € 100
UK Bank      interest      2017-Aug-1   € 130   £100         1.4            € 140