Cash non-LCY account "Account Current Exchange Rate"
Hello all,
want to ask about improvement related non-local Currency Cash account? I see here big potential to improve behavior related "Exchange Rare".
Side story: I have records from Year 2016 (currently it is 08.12.2022) and from that time I was multi-time abroad using different Currencies at different time. Usually I pay everything by card and price is usually automatically recalculated to LCY, but if there is no option I transfer amount from bank to Currency of the country (Bank -> Cash) and here comes improvement. If you export multi-times at different dates from one Currency Account to Another it happens that it comes with different Exchange Rates. Then you have to with each transaction fixed Exchange Rate is taken from Currency (or updated online) --> this is not good.
Point here is to use for Income and Expense transaction concept of "Account Current Exchange Rate to LCY" --> which would be recalculated with each Inbound to Account "Income" and Transfer. All Transfer to Account helps to recalculate "Account Current Exchange Rate to LCY". Example in printscreen attached.
Result: this would result into correct situation that when you spend all money from non-LCY account it would result to 0 recalculation to LCY in all statistic ...
Example:
Step1: Create Account
Name: EUR
Currency: EUR
Initial Amount: 0
Initial Amount-LCY: 0
Step2: Transfer amount from different Account
Transfer From Account: Peněženka
Transfer From Amount: 100
Transfer From Currency: CZK
Transfer To Account: EUR
Transfer To Amount: 5
Transfer To Currency: EUR
Transaction Exchange Rate: 0.05
EUR-Account result:
Accunt Amount: 5
Account Amount LCY: 100
Account Current Exchange: 0.05
Step 3: do some spendings from Acount
Type: Expense
Account: EUR
Currency: EUR
Amount: 1.2
Transaction Amount LCY: 24
Transaction Exchange Rate: 0.05
EUR-Account result:
Accunt Amount: 3.8
Account Amount LCY: 76
Account Current Exchange: 0.05
Step 3: do another spendings from Acount
Type: Expense
Account: EUR
Currency: EUR
Amount: 2
Transaction Amount LCY: 40
Transaction Exchange Rate: 0.05
EUR-Account result:
Accunt Amount: 1.8
Account Amount LCY: 36
Account Current Exchange: 0.05
Step 4: Transfer amount from different Account
Transfer From Account: Peněženka
Transfer From Amount: 200
Transfer From Currency: CZK
Transfer To Account: EUR
Transfer To Amount: 7
Transfer To Currency: EUR
Transaction Exchange Rate: 0.035
EUR-Account result:
Account Amount: 8.8
Account Amount LCY: 236
Account Current Exchange: 0.037288136
Step 5: do another spendings from Account
Type: Expense
Account: EUR
Currency: EUR
Amount: 4.32
Transaction Amount LCY: 115.85
Transaction Exchange Rate: 0.037288136
EUR-Account result:
Account Amount: 4.48
Account Amount LCY: 120.14
Account Current Exchange: 0.037288136
Step 6: do another spendings from Account
Type: Income
Account: EUR
Currency: EUR
Amount: 4
Transaction Amount LCY: 107.27
Transaction Exchange Rate: 0.037288136
EUR-Account result:
Account Amount: 8.48
Account Amount LCY: 227.42
Account Current Exchange: 0.037288136
Step 7: Transfer amount from different Account
Transfer From Account: Peněženka
Transfer From Amount: 300
Transfer From Currency: CZK
Transfer To Account: EUR
Transfer To Amount: 17
Transfer To Currency: EUR
Transaction Exchange Rate: 0.056666667
EUR-Account result:
Account Amount: 25.48
Account Amount LCY: 527.42
Account Current Exchange: 0.048310811
Step 8: do another spendings from Account
Type: Expense
Account: EUR
Currency: EUR
Amount: 20
Transaction Amount LCY: 413.99
Transaction Exchange Rate: 0.048310811
EUR-Account result:
Account Amount: 5.48
Account Amount LCY: 113.43
Account Current Exchange: 0.048310811
Step 8: do another spendings from Account
Type: Expense
Account: EUR
Currency: EUR
Amount: 5.48
Transaction Amount LCY: 113.43
Transaction Exchange Rate: 0.048310811
EUR-Account result:
Account Amount: 0
Account Amount LCY: 0
Account Current Exchange: 0.048310811
