forums.lyricapps.com

hey there, I have an issue with balances.
Let's say I create a monthly balance (left column) to keep track of my expenses goal. So good, so fine.

One of the biggest chunks of my balance is my mortgage, that is linked to the Euribor index and armonized every three months.

What that means? that every 3 months I have to edit the balance and update the new mortgage value (can be higher or lower)
Fact is, this is going to update all my past balance reports (those listed on the bottom window). They can become now positive or negative, it all depends if the new balance is higher or lower.

Past balance reports should be frozen in time. They should be tied somehow to the balance structure that has generated them or they will provide incorrect storical data. It would be nice to be able to see what category values generated them, as a reference.

Any way I can attain this?
In case, could it be a good idea for V5?

Thanks,
Ivan

I'm sorry but I don't understand everything, can you explain again with a concrete example with numbers so that I can understand ? Thanks

Angeman wrote:I'm sorry but I don't understand everything, can you explain again with a concrete example with numbers so that I can understand ? Thanks

I knew it was messy let me try to rephrase is!

--------------
Example, let's create a budegt (left "column", + sign:

Monthly goal: keep within 1000 euro

Budget consist of 2 actegories, house mortgage and other expenses. Keep in mind that every 3 months my mortgage gets a new value from the bank

Foo data:
May: Mortgage 550 euro - Other 500 euro - total 1050 - Overbudget of 50 euro
June: Mortgage 550 euro - Other 500 euro - total 1050 - Overbudget of 50 euro
July: Mortgage 550 euro - Other 450 euro - total 1000 - On budget

August: Mortgage 450 euro - Other 500 euro - total 950 - under budget of 50 euro
--------------

Now... if I had a look on the balance recap I should see:

May red light
June red light
July green light
August green light

Fact is, it's now August and I have to edit my balance parameters (because it still has a value of 550 for mortgage since 3 months before, but we know in August is now 450 because my bank tell me so)

When I do this (edit budget value for mortgage), all the recaps get recalculated, included past ones.

They then all get the green light because it's like I've spent 100 euro less even in May, June and July. But it's not the case. Icompta gets the present value for mortgage and recalculates also past budget recaps.

it shouldn't be the case because it's not reflecting the real word. I spent 550 euro in those months for mortgage, not 450.

I hope it's more clear now

Thanks,
Ivan

You have to create a new budget each time the mortgage value changes. You can just copy/paste your current budget to duplicate it and then adjust the new value and starting date.

Angeman wrote:You have to create a new budget each time the mortgage value changes. You can just copy/paste your current budget to duplicate it and then adjust the new value and starting date.

Thanks for your answer, that's exact what I am doing but the issue remains.
Each time you create a new budget, the past reports change accordingly to which budget you have selected. Try it yourself with some bogus data, won't take you more than 3 minutes.

Past balances are of no value in this way. I'm not sure if you got this point since you totally skipped this part in your answer.

Past balances *must not* change once they are done. What I spent 2 months ago (for example) must be frozen in time. It's spent, gone. If (now) my current budget is lower or higher than 2 months ago, it's not like magically I also spent more (or less) 2 months ago too. Isn't it?

I'm just worried this thing will get carried on on V5.

Ciao,
Ivan

When you duplicate your budget, you need to change the dates of the old budget and the new one.
Let me explain with an example :

Current budget : Mortgage 500 €
Start date : 01/06/12
End date : none

Now you need to adjust your budget so you duplicate it then you have to change the dates like this :

Old budget (previous one) : Mortgage 500 €
Start date : 01/06/12
End date : 01/09/12

New current budget (duplicated one) : Mortgage 600 €
Start date : 01/09/12
End date : none

The past balances are only shown in the old budget and won't change !

Angeman wrote:When you duplicate your budget, you need to change the dates of the old budget and the new one.

yes! Kinda tricky but hey it works!
Thanks for this final explanation!

p.s. where are we? 19%?

Ivan