[GNC] Budget report problem

[Ismael Smajli]

 

Hello

 

I use BUDGET   &   BUDGET REPORT in GNUCASH ver. 4.13.

 

For my BUDGET REPORT I   have   SHOW BUDGET, SHOW ACTUAL  &  SHOW DIFFERENCE in 
the display settings enabled.

 

Problem:

In the   row   of one of my expense account (Service Charges) the report shows  
 in the columns 'Act'   figures. A   small amount of   expenses   for which I 
cannot   find any corresponding record/split in the respective month.

 

When I run a TRANSACTION REPORT for the respective month and filter for the 
account   'Service Charges'   (I choose SELECT CHILDREN and choose SHOW HIDDEN 
ACCOUNTS) to ensure that I have selected all accounts under Service Charges.

However this   TRANSACTION REPORT   is empty. "No transactions were found that 
match the time interval and account selection specified in the Options panel."

Is this a BUG in the BUDGET REPORT ?

  Regards
  Ismael

 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Here is a pull request that demonstrates a "better" handling of the
exchange. Basically, conversion to the report currency should happen
*after* the balance change has been computed, not before. If it happens
before, it makes the historical, cumulative total's exchange-rate
fluctuation during the budget period part of the result.

In the language of my last e-mail, this pull request computes "ES_12*X_1"
(but perhaps it should be "ES_12*X_2"... to be discussed).

https://github.com/Gnucash/gnucash/pull/1497

On Sun, Jan 8, 2023 at 9:34 AM ml enquirer  wrote:

> Yes, it's cumulative, which is a problem I think.
>
> Let:
> 0 indicate the opening of the book
> 1 indicate the start of the budget period in question
> 2 indicate the end of that period
> S_i indicates the sum of transactions since 0 at marker i, in the currency
> of the sub-account
> P_i indicates the sum of transactions since 0 at marker i, in the currency
> of the parent account
> ES_ij indicates the sum of transactions during a period bounded by i and
> j, in sub-account currency
> X_i gives the exchange rate between sub-account and parent-account
>
> The trouble is that the report prints out:
>
> P_2 - P_1
> = S_2*X_2 - S_1*X_1
> = (S_1+ES_12) * X_2 - S_1 * X_1
> = ES_12 * X_2 +  S_1( X_2 - X_1)
>
> My problem is that I only really care about the first term, that contains
> ES_12. But as the years go by, S_1 >> ES_12, so the second term
> increasingly dominates. This becomes particularly visible when X_2-X_1 is
> significant, which has certainly been the case looking at GBP and EUR in
> recent years ;)
>
> By the way, I agree that "ES_12*X_2" is a bit trivial, and it would be
> nice to account for the variation of exchange rates during the year, but
> that's a second-order effect compared to this bug.
>
>
>
>
> To show this in the code:
>
> The "Actual" column in the budget report is populated by
> "gnc:get-account-periodlist-actual-value"
>
> https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L404
>
> which just calls "gnc-budget-get-account-period-actual-value budget acct
> period"
>
> https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L313
>
> which calls "gnc_budget_get_account_period_actual_value"
>
> https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/gnc-budget.cpp#L671gnc_budget_get_account_period_actual_value
>
> which calls "recurrenceGetAccountPeriodValue"
>
> https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Recurrence.c#L421
> where the documentation says "@return the amount that an Account's value
> changed between the beginning  and end of the nth instance of the
> Recurrence."
>
> The problem is that this does:
>
> https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Account.cpp#L3992
> gnc_numeric b1, b2;
> b1 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t1, NULL,
> recurse);
> b2 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t2, NULL,
> recurse);
> return gnc_numeric_sub(b2, b1, GNC_DENOM_AUTO, GNC_HOW_DENOM_FIXED);
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Yes, it's cumulative, which is a problem I think.

Let:
0 indicate the opening of the book
1 indicate the start of the budget period in question
2 indicate the end of that period
S_i indicates the sum of transactions since 0 at marker i, in the currency
of the sub-account
P_i indicates the sum of transactions since 0 at marker i, in the currency
of the parent account
ES_ij indicates the sum of transactions during a period bounded by i and j,
in sub-account currency
X_i gives the exchange rate between sub-account and parent-account

The trouble is that the report prints out:

P_2 - P_1
= S_2*X_2 - S_1*X_1
= (S_1+ES_12) * X_2 - S_1 * X_1
= ES_12 * X_2 +  S_1( X_2 - X_1)

My problem is that I only really care about the first term, that contains
ES_12. But as the years go by, S_1 >> ES_12, so the second term
increasingly dominates. This becomes particularly visible when X_2-X_1 is
significant, which has certainly been the case looking at GBP and EUR in
recent years ;)

By the way, I agree that "ES_12*X_2" is a bit trivial, and it would be nice
to account for the variation of exchange rates during the year, but that's
a second-order effect compared to this bug.




To show this in the code:

The "Actual" column in the budget report is populated by
"gnc:get-account-periodlist-actual-value"
https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L404

which just calls "gnc-budget-get-account-period-actual-value budget acct
period"
https://github.com/Gnucash/gnucash/blob/master/gnucash/report/reports/standard/budget.scm#L313

which calls "gnc_budget_get_account_period_actual_value"
https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/gnc-budget.cpp#L671gnc_budget_get_account_period_actual_value

which calls "recurrenceGetAccountPeriodValue"
https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Recurrence.c#L421
where the documentation says "@return the amount that an Account's value
changed between the beginning  and end of the nth instance of the
Recurrence."

The problem is that this does:
https://github.com/Gnucash/gnucash/blob/master/libgnucash/engine/Account.cpp#L3992
gnc_numeric b1, b2;
b1 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t1, NULL,
recurse);
b2 = xaccAccountGetNoclosingBalanceAsOfDateInCurrency(acc, t2, NULL,
recurse);
return gnc_numeric_sub(b2, b1, GNC_DENOM_AUTO, GNC_HOW_DENOM_FIXED);
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[Adrien Monteleone]

As long as the change in value isn't cumulative, I would want to know.

If I wanted to budget the same 'purchasing power' as last period/year, I 
would not want to budget the exact same nominal amount. (on that note, a 
feature to factor inflation for budgets would be swell!)


But I do understand that previous rates are no guarantee of future 
rates. (exchange or inflation) They provide a starting point though.


All of that would only affect my *next* budget, via Actual, not the 
current one. (it might also explain Variance) So I still think there's a 
potential bug.


Regards,
Adrien

On 1/7/23 11:35 AM, ml enquirer wrote:

Hi Fred,

Thanks for the thought! I agree the change in value is 10,000. My point is,
basically, that I don't care about currency fluctuations in money already
spent when planning *next* year's budget.

But the 'problem' (which might just be that I need someone to explain what
a 'budget' is!) is (at least) two fold:
1) When I think 'budget' I think "planning how much I can spend in this
budget period". So I want the report to tell me that. If there are no
transactions in any child account, I don't expect a non-zero total in the
parent account. I certainly don't want a non-zero total that depends how
long I've been using gnucash. In the first year of using Gnucash, this
shows the total expense. In the 100th (hopefully!) year of using Gnucash,
this mainly shows the currency fluctuation of the history of my grocery
spending in years 0-99! These are totally different things, at least for
the typical use of an expense account like 'groceries'.
2) The budget report and the budget view seem to show the totals
aggregating in different ways. I would expect correspondence.

When you think "budgetting this year's groceries", why would you care about
having to plan for the currency fluctuation in what has already been spent,
and which is no longer available to spend, and which has no impact on what
can be spent this year? Is there another report that you'd recommend that I
use?

Let me be gently provocative: I think my described use-case is more widely
relevant, at least for expense accounts if not for asset accounts ;) But as
I keep on saying, I'm very ignorant of even basic accountancy techniques,
so feel free to (gently) teach me!


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Hi Fred,

Thanks for the thought! I agree the change in value is 10,000. My point is,
basically, that I don't care about currency fluctuations in money already
spent when planning *next* year's budget.

But the 'problem' (which might just be that I need someone to explain what
a 'budget' is!) is (at least) two fold:
1) When I think 'budget' I think "planning how much I can spend in this
budget period". So I want the report to tell me that. If there are no
transactions in any child account, I don't expect a non-zero total in the
parent account. I certainly don't want a non-zero total that depends how
long I've been using gnucash. In the first year of using Gnucash, this
shows the total expense. In the 100th (hopefully!) year of using Gnucash,
this mainly shows the currency fluctuation of the history of my grocery
spending in years 0-99! These are totally different things, at least for
the typical use of an expense account like 'groceries'.
2) The budget report and the budget view seem to show the totals
aggregating in different ways. I would expect correspondence.

When you think "budgetting this year's groceries", why would you care about
having to plan for the currency fluctuation in what has already been spent,
and which is no longer available to spend, and which has no impact on what
can be spent this year? Is there another report that you'd recommend that I
use?

Let me be gently provocative: I think my described use-case is more widely
relevant, at least for expense accounts if not for asset accounts ;) But as
I keep on saying, I'm very ignorant of even basic accountancy techniques,
so feel free to (gently) teach me!

D

On Sat, Jan 7, 2023 at 6:08 PM Fred Bone  wrote:

> On 07 January 2023 at 10:21, ml enquirer said:
>
> > Just to add that I was wrong that this could be solved by making budgets
> > with a single period. I *think* this problem arises for any
> multi-currency
> > sub-accounts and becomes visible when you have a book which has been
> > running for many years. In that circumstance, the 'actual' column is only
> > incrementally affected by spends during the actual reporting period
> (which
> > are small compared to the cumulative spending over the years).
> >
> > Imagine a case where there is *no* spend on any sub-account in a
> reporting
> > period, but the years prior total 1,000,000 EUR and 1,000,000 GBP.
> Imagine
> > the exchange rate is 1 EUR to GBP at the start of this new 'empty' period
> > and 1 EUR to 1.01 GBP at the end. 1) The computed total at the start will
> > be 1,000,000 EUR + 1,000,000 GBP = 2,000,000 GBP. 2) The computed total
> at
> > the end will be 1,000,000 EUR + 1,000,000 GBP = 2,010,000 GBP and the
> > reported "Actual" spend will be 10,000 GBP despite nothing having been
> > spent.
>
> The change in value is indeed 10,000. What's the problem?
>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[Fred Bone]

On 07 January 2023 at 10:21, ml enquirer said:

> Just to add that I was wrong that this could be solved by making budgets
> with a single period. I *think* this problem arises for any multi-currency
> sub-accounts and becomes visible when you have a book which has been
> running for many years. In that circumstance, the 'actual' column is only
> incrementally affected by spends during the actual reporting period (which
> are small compared to the cumulative spending over the years).
> 
> Imagine a case where there is *no* spend on any sub-account in a reporting
> period, but the years prior total 1,000,000 EUR and 1,000,000 GBP. Imagine
> the exchange rate is 1 EUR to GBP at the start of this new 'empty' period
> and 1 EUR to 1.01 GBP at the end. 1) The computed total at the start will
> be 1,000,000 EUR + 1,000,000 GBP = 2,000,000 GBP. 2) The computed total at
> the end will be 1,000,000 EUR + 1,000,000 GBP = 2,010,000 GBP and the
> reported "Actual" spend will be 10,000 GBP despite nothing having been
> spent.

The change in value is indeed 10,000. What's the problem?


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Just to add that I was wrong that this could be solved by making budgets
with a single period. I *think* this problem arises for any multi-currency
sub-accounts and becomes visible when you have a book which has been
running for many years. In that circumstance, the 'actual' column is only
incrementally affected by spends during the actual reporting period (which
are small compared to the cumulative spending over the years).

Imagine a case where there is *no* spend on any sub-account in a reporting
period, but the years prior total 1,000,000 EUR and 1,000,000 GBP. Imagine
the exchange rate is 1 EUR to GBP at the start of this new 'empty' period
and 1 EUR to 1.01 GBP at the end.
1) The computed total at the start will be 1,000,000 EUR + 1,000,000 GBP =
2,000,000 GBP.
2) The computed total at the end will be 1,000,000 EUR + 1,000,000 GBP =
2,010,000 GBP
and the reported "Actual" spend will be 10,000 GBP despite nothing having
been spent.

This reporting bug gets worse the longer gnucash is used.

Thanks,
D

On Sat, Jan 7, 2023 at 9:52 AM ml enquirer  wrote:

> Hi Adrien,
>
> Thanks for the mental bandwidth on this. I don't like replying inline, but
> I'm going to grit my teeth and do it here - forgive me!
>
> Cheers,
> D
>
> On Sat, Jan 7, 2023 at 12:47 AM Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Christopher Lamm had been working on various aspects of the Budget
>> Report not long ago. He may be able to squeeze in a look at this. He'll
>> likely be the one to see your bug report and maybe shed light on the
>> math logic.
>>
> Great: https://bugs.gnucash.org/show_bug.cgi?id=798716
>
>
>> If I can find some time this weekend I'll test as well. I normally don't
>> budget with multiple currencies, but I do use the Budget feature and
>> report. (looking at your screenshot, I've never done a multi-year
>> budget, so that will be interesting. I'll test too with a single year.)
>>
> The pragmatic way around this is to only use budget reports with a single
> budget period when multiple currencies are used in sub-accounts. Things
> then work because the starting "actual" value is always zero.
>
>
>> Concerning the 'roll-up', if you leave the parent blank, it should work.
>> (at least it does with a single currency) *But*, you can also put in a
>> different value manually for the parent. I'm not sure if that is in play
>> here or not. The parent has to be entirely blank, not just a "0" or "0.00"
>>
>> *note, this is for the Budget itself, your screenshot showed the report
>> result, but does the parent roll-up not work on the budget tab either?
>>
> Interesting. Here the budget and the budget report behave differently. The
> roll-up *does* acknowledge the change in FX rate, but behaves as I'd expect
> (see screenshot attached)
>
>>
>> With respect to the 'past-period memory', it could be buggy, but I'd be
>> inclined to first look really carefully at my report options, *and* the
>> budget period setup. (Edit > Budget Options, or Options toolbar button
>> once a budget is already open - different from Options button on the
>> report tab) I once made an odd mess here myself that produced strange
>> numbers that didn't make sense.
>>
>> Specifically with the Report Options, the General tab can make things
>> messy with respect to custom ranges, and Accounts > Account Depth can
>> produce odd results if not sufficiently deep, or if flattened.
>>
> Depth was enough to capture all sub-accounts and ranges were sensible (and
> covered all transactions). I admit it is possible to screw this up as you
> warn - and perhaps I still have - but I think I've picked it simply
>
>>
>> Additionally, did you simply manually enter all budget values, or did
>> you perhaps use the Estimate feature?
>>
> Manually entered.
>
>>
>> Finally, does this book have Trading Accounts enabled by chance? I think
>> I understood from your first post that you aren't using them yet. (mine
>> does, so I'll test with and without to see if there is difference)
>>
> No trading accounts.
>
>>
>> -
>> I've been in the habit of hazarding guesses lately, so here's one for
>> this topic:
>>
>> Since the Budget Report does not have an option for commodity price
>> source like other reports cognizant of other currencies, I'll
>> hypothesize that budgets simply aren't (yet) capable of properly working
>> with more than one, or any currency other than the book currency.
>>
>> Regards,
>> Adrien
>>
>> On 1/6/23 4:48 PM, ml enquirer wrote:
>> > Dear all,
>> >
>> > I've done some digging, and Gnucash totals seem to be wrongly reported
>> for
>> > budget reports with multi-currency sub-accounts. But I'm not an
>> accountancy
>> > expert at all, so perhaps someone can explain the accounting logic
>> behind
>> > it? Perhaps a report that can imply 1+1=3 should have a warning note?
>> > Should we be ensuring that accounts add up across budget periods, or
>> down
>> > hierarchies within budget periods? Gnucash is doing the former, but it's
>> > c

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Hi Adrien,

Thanks for the mental bandwidth on this. I don't like replying inline, but
I'm going to grit my teeth and do it here - forgive me!

Cheers,
D

On Sat, Jan 7, 2023 at 12:47 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Christopher Lamm had been working on various aspects of the Budget
> Report not long ago. He may be able to squeeze in a look at this. He'll
> likely be the one to see your bug report and maybe shed light on the
> math logic.
>
Great: https://bugs.gnucash.org/show_bug.cgi?id=798716


> If I can find some time this weekend I'll test as well. I normally don't
> budget with multiple currencies, but I do use the Budget feature and
> report. (looking at your screenshot, I've never done a multi-year
> budget, so that will be interesting. I'll test too with a single year.)
>
The pragmatic way around this is to only use budget reports with a single
budget period when multiple currencies are used in sub-accounts. Things
then work because the starting "actual" value is always zero.


> Concerning the 'roll-up', if you leave the parent blank, it should work.
> (at least it does with a single currency) *But*, you can also put in a
> different value manually for the parent. I'm not sure if that is in play
> here or not. The parent has to be entirely blank, not just a "0" or "0.00"
>
> *note, this is for the Budget itself, your screenshot showed the report
> result, but does the parent roll-up not work on the budget tab either?
>
Interesting. Here the budget and the budget report behave differently. The
roll-up *does* acknowledge the change in FX rate, but behaves as I'd expect
(see screenshot attached)

>
> With respect to the 'past-period memory', it could be buggy, but I'd be
> inclined to first look really carefully at my report options, *and* the
> budget period setup. (Edit > Budget Options, or Options toolbar button
> once a budget is already open - different from Options button on the
> report tab) I once made an odd mess here myself that produced strange
> numbers that didn't make sense.
>
> Specifically with the Report Options, the General tab can make things
> messy with respect to custom ranges, and Accounts > Account Depth can
> produce odd results if not sufficiently deep, or if flattened.
>
Depth was enough to capture all sub-accounts and ranges were sensible (and
covered all transactions). I admit it is possible to screw this up as you
warn - and perhaps I still have - but I think I've picked it simply

>
> Additionally, did you simply manually enter all budget values, or did
> you perhaps use the Estimate feature?
>
Manually entered.

>
> Finally, does this book have Trading Accounts enabled by chance? I think
> I understood from your first post that you aren't using them yet. (mine
> does, so I'll test with and without to see if there is difference)
>
No trading accounts.

>
> -
> I've been in the habit of hazarding guesses lately, so here's one for
> this topic:
>
> Since the Budget Report does not have an option for commodity price
> source like other reports cognizant of other currencies, I'll
> hypothesize that budgets simply aren't (yet) capable of properly working
> with more than one, or any currency other than the book currency.
>
> Regards,
> Adrien
>
> On 1/6/23 4:48 PM, ml enquirer wrote:
> > Dear all,
> >
> > I've done some digging, and Gnucash totals seem to be wrongly reported
> for
> > budget reports with multi-currency sub-accounts. But I'm not an
> accountancy
> > expert at all, so perhaps someone can explain the accounting logic behind
> > it? Perhaps a report that can imply 1+1=3 should have a warning note?
> > Should we be ensuring that accounts add up across budget periods, or down
> > hierarchies within budget periods? Gnucash is doing the former, but it's
> > confusing since the display can imply only the latter is in action.
> >
> > I built a local copy of gnucash and tracked the calls through budget.scm
> > back to the totalling and currency-conversion that happens in Account.cpp
> > and I see where the confusion arises. There is memory of previous budget
> > periods built into the reported totals under each asset class (see the
> > detail below and the picture attached).
> >
> > Isn't it a bit counter-intuitive that the budget reports for 'parent'
> > account values in a given budget period, don't need to add up to the sum
> of
> > the 'child' account values when converted by the exchange rate relevant
> for
> > that budget period? I give lots of detail below, where it's clear the
> > report is not "buggy", but it is borderline misleading, particularly
> given
> > that the report can be restricted to a single budget period within which
> it
> > appears to say that 30,000 GBP is the sum of 10,000 GBP and 10,000 EUR,
> > when the exchange rate is 1GBP = 1EUR. 1+1=3?
> >
> > Would love some expert input. Maybe I should report this as a bug and let
> > someone set me right there? :)
> >
> > Cheers,
> > D
> >
> > PS: Here's the detai

Re: [GNC] Budget report fails in multiple currencies

[Adrien Monteleone]

Christopher Lamm had been working on various aspects of the Budget 
Report not long ago. He may be able to squeeze in a look at this. He'll 
likely be the one to see your bug report and maybe shed light on the 
math logic.


If I can find some time this weekend I'll test as well. I normally don't 
budget with multiple currencies, but I do use the Budget feature and 
report. (looking at your screenshot, I've never done a multi-year 
budget, so that will be interesting. I'll test too with a single year.)


Concerning the 'roll-up', if you leave the parent blank, it should work. 
(at least it does with a single currency) *But*, you can also put in a 
different value manually for the parent. I'm not sure if that is in play 
here or not. The parent has to be entirely blank, not just a "0" or "0.00"


*note, this is for the Budget itself, your screenshot showed the report 
result, but does the parent roll-up not work on the budget tab either?


With respect to the 'past-period memory', it could be buggy, but I'd be 
inclined to first look really carefully at my report options, *and* the 
budget period setup. (Edit > Budget Options, or Options toolbar button 
once a budget is already open - different from Options button on the 
report tab) I once made an odd mess here myself that produced strange 
numbers that didn't make sense.


Specifically with the Report Options, the General tab can make things 
messy with respect to custom ranges, and Accounts > Account Depth can 
produce odd results if not sufficiently deep, or if flattened.


Additionally, did you simply manually enter all budget values, or did 
you perhaps use the Estimate feature?


Finally, does this book have Trading Accounts enabled by chance? I think 
I understood from your first post that you aren't using them yet. (mine 
does, so I'll test with and without to see if there is difference)


-
I've been in the habit of hazarding guesses lately, so here's one for 
this topic:


Since the Budget Report does not have an option for commodity price 
source like other reports cognizant of other currencies, I'll 
hypothesize that budgets simply aren't (yet) capable of properly working 
with more than one, or any currency other than the book currency.


Regards,
Adrien

On 1/6/23 4:48 PM, ml enquirer wrote:

Dear all,

I've done some digging, and Gnucash totals seem to be wrongly reported for
budget reports with multi-currency sub-accounts. But I'm not an accountancy
expert at all, so perhaps someone can explain the accounting logic behind
it? Perhaps a report that can imply 1+1=3 should have a warning note?
Should we be ensuring that accounts add up across budget periods, or down
hierarchies within budget periods? Gnucash is doing the former, but it's
confusing since the display can imply only the latter is in action.

I built a local copy of gnucash and tracked the calls through budget.scm
back to the totalling and currency-conversion that happens in Account.cpp
and I see where the confusion arises. There is memory of previous budget
periods built into the reported totals under each asset class (see the
detail below and the picture attached).

Isn't it a bit counter-intuitive that the budget reports for 'parent'
account values in a given budget period, don't need to add up to the sum of
the 'child' account values when converted by the exchange rate relevant for
that budget period? I give lots of detail below, where it's clear the
report is not "buggy", but it is borderline misleading, particularly given
that the report can be restricted to a single budget period within which it
appears to say that 30,000 GBP is the sum of 10,000 GBP and 10,000 EUR,
when the exchange rate is 1GBP = 1EUR. 1+1=3?

Would love some expert input. Maybe I should report this as a bug and let
someone set me right there? :)

Cheers,
D

PS: Here's the detail:
I expected:
- reported actual "Groceries" total would be the sum of the reported "GBP"
and "EUR" account spends in that budget period, according to the relevant
FX rate.

But in reality:
- it's actually this year's change in the balance for that account compared
to the last budget period. That means that while the GBP or EUR rows always
change by 10,000 each year, and thus always show 10,000 in the budget
report, the sum of the two - the "Groceries" row - is not necessarily equal
to 10,000 GBP + 10,000 EUR. In my example, 1EUR = 0.5 GBP for the first two
budget periods, so the balance of "Groceries" by the end of the second
period was (10,000GBP+5,000GBP) + (10,000 GBP + 5,000 GBP) = 30,000 GBP.
But at the end of the third period, the three years' of spending meant that
the balance of "Groceries" was
(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000
GBP. Difference 30,000 GBP.

so 1 + 1 = 3.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-u

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Dear all,

I've done some digging, and Gnucash totals seem to be wrongly reported for
budget reports with multi-currency sub-accounts. But I'm not an accountancy
expert at all, so perhaps someone can explain the accounting logic behind
it? Perhaps a report that can imply 1+1=3 should have a warning note?
Should we be ensuring that accounts add up across budget periods, or down
hierarchies within budget periods? Gnucash is doing the former, but it's
confusing since the display can imply only the latter is in action.

I built a local copy of gnucash and tracked the calls through budget.scm
back to the totalling and currency-conversion that happens in Account.cpp
and I see where the confusion arises. There is memory of previous budget
periods built into the reported totals under each asset class (see the
detail below and the picture attached).

Isn't it a bit counter-intuitive that the budget reports for 'parent'
account values in a given budget period, don't need to add up to the sum of
the 'child' account values when converted by the exchange rate relevant for
that budget period? I give lots of detail below, where it's clear the
report is not "buggy", but it is borderline misleading, particularly given
that the report can be restricted to a single budget period within which it
appears to say that 30,000 GBP is the sum of 10,000 GBP and 10,000 EUR,
when the exchange rate is 1GBP = 1EUR. 1+1=3?

Would love some expert input. Maybe I should report this as a bug and let
someone set me right there? :)

Cheers,
D

PS: Here's the detail:
I expected:
- reported actual "Groceries" total would be the sum of the reported "GBP"
and "EUR" account spends in that budget period, according to the relevant
FX rate.

But in reality:
- it's actually this year's change in the balance for that account compared
to the last budget period. That means that while the GBP or EUR rows always
change by 10,000 each year, and thus always show 10,000 in the budget
report, the sum of the two - the "Groceries" row - is not necessarily equal
to 10,000 GBP + 10,000 EUR. In my example, 1EUR = 0.5 GBP for the first two
budget periods, so the balance of "Groceries" by the end of the second
period was (10,000GBP+5,000GBP) + (10,000 GBP + 5,000 GBP) = 30,000 GBP.
But at the end of the third period, the three years' of spending meant that
the balance of "Groceries" was
(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP)+(10,000GBP+10,000GBP) = 60,000
GBP. Difference 30,000 GBP.

so 1 + 1 = 3.



On Thu, Jan 5, 2023 at 9:37 PM ml enquirer  wrote:

> Hi!
>
> Any clues as to where to start to understand this odd budget report
> behaviour? Browsing the code, I wondered if I should start pulling the code
> apart here:
>
> https://github.com/Gnucash/gnucash/blob/master/gnucash/gnome/gnc-budget-view.c#L1011
>
> to understand why the totals would be combined in such an
> apparently-illogical (but presumably profoundly reasonable to a
> better-informed person!) way...
>
> Hints very much appreciated!
>
> On Mon, Jan 2, 2023 at 4:10 PM ml enquirer 
> wrote:
>
>> Dear all,
>>
>> I spend in two currencies and, historically, I chose to create separate
>> accounts under each expense line for each currency. In future I will do
>> this differently, employing trading accounts, but what I'm about to
>> describe should still work. I budget in my 'home' currency, and the budget
>> report would combine the "sub-spends" in each currency (using the price
>> database).
>>
>> However, the "Actual" budget totals don't behave as I expected. I've set
>> up a simple scenario to explain:
>> 1) I set up an assets and expense ("Groceries") account
>> Under each I set up a "GBP" and a "EUR" account
>> 3) On 1st Jan of 2020, 2021, 2022, 2023 I spend 10,000 EUR and 10,000 GBP
>> on "Groceries"
>> 4) I set up the price database with four entries, on 1st Jan:
>>  - 1/1/2020 1GBP = 1EUR
>>  - 1/1/2021 1GBP = 2EUR
>>  - 1/1/2022 1GBP = 1EUR
>>
>> I've attached a simple reproducer ("bugreport.gnucash", though perhaps
>> this is not a bug so filename might be inappropriate!).
>>
>> When I look at the default budget report, I see that the total per year
>> is always 10,000 of each currency in the sub-accounts, as expected, but the
>> budget's "Act" total under "Groceries" is:
>> 1/1/2020: £15,000 [I expect £20,000 because EUR=GBP on 1/1/20]
>> 1/1/2021: £15,000 [I expect £15,000 because 1EUR=0.5GBP on 1/1/21]
>> 1/1/2022: £30,000 [I expect £20,000 because 1EUR=1GBP on 1/1/22]
>> 1/1/2023: £20,000 [I expect £20,000 because 1EUR=1GBP on 1/1/23]
>>
>> Can someone explain where my naive expectation is wrong? Is GnuCash doing
>> some strange interpolation between exchange rate values?
>>
>> Many thanks in advance.
>>
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this

Re: [GNC] Budget report fails in multiple currencies

[ml enquirer]

Hi!

Any clues as to where to start to understand this odd budget report
behaviour? Browsing the code, I wondered if I should start pulling the code
apart here:
https://github.com/Gnucash/gnucash/blob/master/gnucash/gnome/gnc-budget-view.c#L1011

to understand why the totals would be combined in such an
apparently-illogical (but presumably profoundly reasonable to a
better-informed person!) way...

Hints very much appreciated!

On Mon, Jan 2, 2023 at 4:10 PM ml enquirer  wrote:

> Dear all,
>
> I spend in two currencies and, historically, I chose to create separate
> accounts under each expense line for each currency. In future I will do
> this differently, employing trading accounts, but what I'm about to
> describe should still work. I budget in my 'home' currency, and the budget
> report would combine the "sub-spends" in each currency (using the price
> database).
>
> However, the "Actual" budget totals don't behave as I expected. I've set
> up a simple scenario to explain:
> 1) I set up an assets and expense ("Groceries") account
> Under each I set up a "GBP" and a "EUR" account
> 3) On 1st Jan of 2020, 2021, 2022, 2023 I spend 10,000 EUR and 10,000 GBP
> on "Groceries"
> 4) I set up the price database with four entries, on 1st Jan:
>  - 1/1/2020 1GBP = 1EUR
>  - 1/1/2021 1GBP = 2EUR
>  - 1/1/2022 1GBP = 1EUR
>
> I've attached a simple reproducer ("bugreport.gnucash", though perhaps
> this is not a bug so filename might be inappropriate!).
>
> When I look at the default budget report, I see that the total per year is
> always 10,000 of each currency in the sub-accounts, as expected, but the
> budget's "Act" total under "Groceries" is:
> 1/1/2020: £15,000 [I expect £20,000 because EUR=GBP on 1/1/20]
> 1/1/2021: £15,000 [I expect £15,000 because 1EUR=0.5GBP on 1/1/21]
> 1/1/2022: £30,000 [I expect £20,000 because 1EUR=1GBP on 1/1/22]
> 1/1/2023: £20,000 [I expect £20,000 because 1EUR=1GBP on 1/1/23]
>
> Can someone explain where my naive expectation is wrong? Is GnuCash doing
> some strange interpolation between exchange rate values?
>
> Many thanks in advance.
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget report fails in multiple currencies

[ml enquirer]

Dear all,

I spend in two currencies and, historically, I chose to create separate
accounts under each expense line for each currency. In future I will do
this differently, employing trading accounts, but what I'm about to
describe should still work. I budget in my 'home' currency, and the budget
report would combine the "sub-spends" in each currency (using the price
database).

However, the "Actual" budget totals don't behave as I expected. I've set up
a simple scenario to explain:
1) I set up an assets and expense ("Groceries") account
Under each I set up a "GBP" and a "EUR" account
3) On 1st Jan of 2020, 2021, 2022, 2023 I spend 10,000 EUR and 10,000 GBP
on "Groceries"
4) I set up the price database with four entries, on 1st Jan:
 - 1/1/2020 1GBP = 1EUR
 - 1/1/2021 1GBP = 2EUR
 - 1/1/2022 1GBP = 1EUR

I've attached a simple reproducer ("bugreport.gnucash", though perhaps this
is not a bug so filename might be inappropriate!).

When I look at the default budget report, I see that the total per year is
always 10,000 of each currency in the sub-accounts, as expected, but the
budget's "Act" total under "Groceries" is:
1/1/2020: £15,000 [I expect £20,000 because EUR=GBP on 1/1/20]
1/1/2021: £15,000 [I expect £15,000 because 1EUR=0.5GBP on 1/1/21]
1/1/2022: £30,000 [I expect £20,000 because 1EUR=1GBP on 1/1/22]
1/1/2023: £20,000 [I expect £20,000 because 1EUR=1GBP on 1/1/23]

Can someone explain where my naive expectation is wrong? Is GnuCash doing
some strange interpolation between exchange rate values?

Many thanks in advance.


bugreport.gnucash
Description: application/gnucash
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] budget report and scrolling

[Adrien Monteleone]

Not sure about LibreOffice, but for those on MacOS, Numbers.app lets you 
define 'groups' that you can expand and collapse with a click. You could 
then define each of your periods as a group, then expand/collapse to 
show/hide the Actual/Budget/Diff columns for each.


Regards,
Adrien

On 8/6/21 6:08 PM, Jon Schewe wrote:


I saw the export, but it's HTML and didn't think that the spreadsheet
would take it. Turns out LibreOffice does quite well.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

[Christopher Lam]

If this is the case, then this is very likely a genuine bug and would need
a test data file, sample reports in Bugzilla.

On Mon, 29 Nov 2021, 9:58 pm Charles Crossan,  wrote:

> I believe I found the answer to this.
>
> The Budget report (and the Transaction Report) are showing the "expected"
> values for changes to liability account balances - how much debt I actually
> paid off this month.
>
> The Net Worth Report (and Liabilities Over Time Report) also show "arguably
> correct" values for changes to liability account balances - How much debt I
> added this month; ignoring any payments I made on the first day of the
> month.
>
> The discrepancy arises when transactions occur on the reporting boundary
> days.  For instance, If I apply a $2,000 payment to a credit card on the
> first of the month, and then spend $500 on that card throughout the month,
> the Budget Report (and the Transaction Report) will show that a decrease of
> that credit card account by $2,000; however, the Net Worth (and Liabilities
> Over Time) report will show a Liability increase of $500.
>
> It would seem that the Time-series reports use the balance of the accounts
> at the "end of the day" for the reporting period boundaries(i.e. including
> transactions from the beginning boundary day); whereas the
> transaction-tracking reports use actual ingress and egress values from
> transactions against the account during the reporting periods.
>
> Is there a way to adjust the behavior of Time-Series reports so that they
> choose the balance from before the first transaction of the reporting
> period (and after the last transaction of the end of the reporting period)?
>
> On Sun, Nov 28, 2021 at 8:47 PM Charles Crossan 
> wrote:
>
> > Hello!
> >
> > I've been using GNUCash (gratefully, and happily) for 10 years, and this
> > is my first time reaching out to the mailing list.
> >
> > I recently noticed that the "Budget Report" for the current period shows
> a
> > different "Act" value for "changes in Liabilities" than the
> > manually-calculated liability delta from the "Net Worth Report" or the
> > "Liability report" (using the same set of accounts) for the same
> one-month
> > period.
> >
> > For instance, budget report "act" says "Liabilities Decreased by $1500",
> > but the liabilities report says " Liabilities  increased by $3500"
> >
> > I feel like my comprehension of accounting is betraying me.  How is this
> > possible?  Has anyone else seen something like this before?
> >
> > --
> > Thanks,
> >
> >
> > Charles Crossan
> > @crossan007 
> > 215-804-9851
> > https://www.ccrossan.com
> >
> >
>
> --
> Thanks,
>
>
> Charles Crossan
> @crossan007 
> 215-804-9851
> https://www.ccrossan.com
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

[D. via gnucash-user]

Charles, 

I'm glad you've been able to track down the differences. 

It would seemingly be sensible for the different reports to use the same 
boundary definitions. Whether that can happen is another story. 

The budget reports as far as I know have not received any developer attention 
for some time. I believe Chris Lam has been the main person working on the 
reports; he may have more to say about the issue. 

David


 Original Message 
From: Charles Crossan 
Sent: Mon Nov 29 08:57:58 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

I believe I found the answer to this.

The Budget report (and the Transaction Report) are showing the "expected"
values for changes to liability account balances - how much debt I actually
paid off this month.

The Net Worth Report (and Liabilities Over Time Report) also show "arguably
correct" values for changes to liability account balances - How much debt I
added this month; ignoring any payments I made on the first day of the
month.

The discrepancy arises when transactions occur on the reporting boundary
days.  For instance, If I apply a $2,000 payment to a credit card on the
first of the month, and then spend $500 on that card throughout the month,
the Budget Report (and the Transaction Report) will show that a decrease of
that credit card account by $2,000; however, the Net Worth (and Liabilities
Over Time) report will show a Liability increase of $500.

It would seem that the Time-series reports use the balance of the accounts
at the "end of the day" for the reporting period boundaries(i.e. including
transactions from the beginning boundary day); whereas the
transaction-tracking reports use actual ingress and egress values from
transactions against the account during the reporting periods.

Is there a way to adjust the behavior of Time-Series reports so that they
choose the balance from before the first transaction of the reporting
period (and after the last transaction of the end of the reporting period)?

On Sun, Nov 28, 2021 at 8:47 PM Charles Crossan 
wrote:

> Hello!
>
> I've been using GNUCash (gratefully, and happily) for 10 years, and this
> is my first time reaching out to the mailing list.
>
> I recently noticed that the "Budget Report" for the current period shows a
> different "Act" value for "changes in Liabilities" than the
> manually-calculated liability delta from the "Net Worth Report" or the
> "Liability report" (using the same set of accounts) for the same one-month
> period.
>
> For instance, budget report "act" says "Liabilities Decreased by $1500",
> but the liabilities report says " Liabilities  increased by $3500"
>
> I feel like my comprehension of accounting is betraying me.  How is this
> possible?  Has anyone else seen something like this before?
>
> --
> Thanks,
>
>
> Charles Crossan
> @crossan007 <https://twitter.com/crossan007>
> 215-804-9851
> https://www.ccrossan.com
>
>

-- 
Thanks,


Charles Crossan
@crossan007 <https://twitter.com/crossan007>
215-804-9851
https://www.ccrossan.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

[Charles Crossan]

I believe I found the answer to this.

The Budget report (and the Transaction Report) are showing the "expected"
values for changes to liability account balances - how much debt I actually
paid off this month.

The Net Worth Report (and Liabilities Over Time Report) also show "arguably
correct" values for changes to liability account balances - How much debt I
added this month; ignoring any payments I made on the first day of the
month.

The discrepancy arises when transactions occur on the reporting boundary
days.  For instance, If I apply a $2,000 payment to a credit card on the
first of the month, and then spend $500 on that card throughout the month,
the Budget Report (and the Transaction Report) will show that a decrease of
that credit card account by $2,000; however, the Net Worth (and Liabilities
Over Time) report will show a Liability increase of $500.

It would seem that the Time-series reports use the balance of the accounts
at the "end of the day" for the reporting period boundaries(i.e. including
transactions from the beginning boundary day); whereas the
transaction-tracking reports use actual ingress and egress values from
transactions against the account during the reporting periods.

Is there a way to adjust the behavior of Time-Series reports so that they
choose the balance from before the first transaction of the reporting
period (and after the last transaction of the end of the reporting period)?

On Sun, Nov 28, 2021 at 8:47 PM Charles Crossan 
wrote:

> Hello!
>
> I've been using GNUCash (gratefully, and happily) for 10 years, and this
> is my first time reaching out to the mailing list.
>
> I recently noticed that the "Budget Report" for the current period shows a
> different "Act" value for "changes in Liabilities" than the
> manually-calculated liability delta from the "Net Worth Report" or the
> "Liability report" (using the same set of accounts) for the same one-month
> period.
>
> For instance, budget report "act" says "Liabilities Decreased by $1500",
> but the liabilities report says " Liabilities  increased by $3500"
>
> I feel like my comprehension of accounting is betraying me.  How is this
> possible?  Has anyone else seen something like this before?
>
> --
> Thanks,
>
>
> Charles Crossan
> @crossan007 
> 215-804-9851
> https://www.ccrossan.com
>
>

-- 
Thanks,


Charles Crossan
@crossan007 
215-804-9851
https://www.ccrossan.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Report Liability "Act" VS Liability Report "Delta"

[Charles Crossan]

Hello!

I've been using GNUCash (gratefully, and happily) for 10 years, and this is
my first time reaching out to the mailing list.

I recently noticed that the "Budget Report" for the current period shows a
different "Act" value for "changes in Liabilities" than the
manually-calculated liability delta from the "Net Worth Report" or the
"Liability report" (using the same set of accounts) for the same one-month
period.

For instance, budget report "act" says "Liabilities Decreased by $1500",
but the liabilities report says " Liabilities  increased by $3500"

I feel like my comprehension of accounting is betraying me.  How is this
possible?  Has anyone else seen something like this before?

-- 
Thanks,


Charles Crossan
@crossan007 
215-804-9851
https://www.ccrossan.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Questions

[Steve Welch via gnucash-user]

Thanks Jon (& Christopher)!

Your advice was helpful - I guess I was sorta tired when I was trying to figure 
it out.  
Playing with those options did help me better understand what they do and how 
to approximate what I’m looking for.  
Hopefully I can get to a place where I can get enough of what I want so that it 
is useful.

Steve


> On Oct 10, 2021, at 9:51 PM, Jon Schewe  wrote:
> 
> Steve,
> 
> In the report options I believe you will find the following settings
> useful.
> 
> Under the display tab:
> I have Budget and Actual turned off and Difference turned on. This fits
> with my idea of envelope budgeting. You should experiment with which of
> these 3 columns you find the most useful. 
> 
> Under the general tab:
> Check "Use accumulated amounts"
> Check "Report for range of budget periods"
> Range Start: Current budget period
> Range End: Next budget period
> Check "Include collapsed periods before selected"
> Check "Include collapsed periods after selected"
> 
> Jon
> 
> On Sun, 2021-10-10 at 18:20 -0400, Steve Welch via gnucash-user wrote:
>> I apologize in advance if the answers to these questions are
>> painfully obvious.  I have tried to read the resources provided but
>> no luck so far.
>> I set up my budget with 12 periods (months) - each item is simply
>> 1/12th of the annual total.
>> What I am used to using (Moneydance, Quicken) are two basic reports:
>> 1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
>> 2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
>> When I view the GNC “Budget Report” it looks like I’m seeing #2
>> above.  How can I view a report that shows #1 - YTD budget vs. YTD
>> actuals?
>> Also, is there a way to collapse or hide the monthly columns so that
>> I can see the totals (far right) next to the account names?  With 12
>> months displayed, I have to constantly scroll left - right to see the
>> name and then the totals.  
>> Finally, is “Budget Report” the only one that shows budgeted figures
>> next to actuals?  I haven’t found any others but wanted to be sure.
>> 
>> Again, sorry if I’m missing something simple here.  And thanks!
>> 
>> Steve
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists
>> for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Questions

[Jon Schewe]

Steve,

In the report options I believe you will find the following settings
useful.

Under the display tab:
I have Budget and Actual turned off and Difference turned on. This fits
with my idea of envelope budgeting. You should experiment with which of
these 3 columns you find the most useful. 

Under the general tab:
Check "Use accumulated amounts"
Check "Report for range of budget periods"
Range Start: Current budget period
Range End: Next budget period
Check "Include collapsed periods before selected"
Check "Include collapsed periods after selected"

Jon

On Sun, 2021-10-10 at 18:20 -0400, Steve Welch via gnucash-user wrote:
> I apologize in advance if the answers to these questions are
> painfully obvious.  I have tried to read the resources provided but
> no luck so far.
> I set up my budget with 12 periods (months) - each item is simply
> 1/12th of the annual total.
> What I am used to using (Moneydance, Quicken) are two basic reports:
> 1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
> 2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
> When I view the GNC “Budget Report” it looks like I’m seeing #2
> above.  How can I view a report that shows #1 - YTD budget vs. YTD
> actuals?
> Also, is there a way to collapse or hide the monthly columns so that
> I can see the totals (far right) next to the account names?  With 12
> months displayed, I have to constantly scroll left - right to see the
> name and then the totals.  
> Finally, is “Budget Report” the only one that shows budgeted figures
> next to actuals?  I haven’t found any others but wanted to be sure.
> 
> Again, sorry if I’m missing something simple here.  And thanks!
> 
> Steve
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report Questions

[Christopher Lam]

Hello, does the budget report option "Use accumulated amounts" help? If
not, please file a bug.

On Mon, 11 Oct 2021, 6:21 am Steve Welch via gnucash-user, <
gnucash-user@gnucash.org> wrote:

> I apologize in advance if the answers to these questions are painfully
> obvious.  I have tried to read the resources provided but no luck so far.
> I set up my budget with 12 periods (months) - each item is simply 1/12th
> of the annual total.
> What I am used to using (Moneydance, Quicken) are two basic reports:
> 1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
> 2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
> When I view the GNC “Budget Report” it looks like I’m seeing #2 above.
> How can I view a report that shows #1 - YTD budget vs. YTD actuals?
> Also, is there a way to collapse or hide the monthly columns so that I can
> see the totals (far right) next to the account names?  With 12 months
> displayed, I have to constantly scroll left - right to see the name and
> then the totals.
> Finally, is “Budget Report” the only one that shows budgeted figures next
> to actuals?  I haven’t found any others but wanted to be sure.
>
> Again, sorry if I’m missing something simple here.  And thanks!
>
> Steve
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Report Questions

[Steve Welch via gnucash-user]

I apologize in advance if the answers to these questions are painfully obvious. 
 I have tried to read the resources provided but no luck so far.
I set up my budget with 12 periods (months) - each item is simply 1/12th of the 
annual total.
What I am used to using (Moneydance, Quicken) are two basic reports:
1.  Budget vs. Actual - year to date (YTD budget vs. YTD actuals)
2.  Budget vs. Actual - annual (full year budget vs. YTD actuals)
When I view the GNC “Budget Report” it looks like I’m seeing #2 above.  How can 
I view a report that shows #1 - YTD budget vs. YTD actuals?
Also, is there a way to collapse or hide the monthly columns so that I can see 
the totals (far right) next to the account names?  With 12 months displayed, I 
have to constantly scroll left - right to see the name and then the totals.  
Finally, is “Budget Report” the only one that shows budgeted figures next to 
actuals?  I haven’t found any others but wanted to be sure.

Again, sorry if I’m missing something simple here.  And thanks!

Steve
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] budget report and scrolling

[Jon Schewe]

On Fri, 2021-08-06 at 17:24 -0500, Tommy Trussell wrote:
> On Fri, Aug 6, 2021 at 9:25 AM Jon Schewe  wrote:
> > I am using the budget report and it's working quite well, except
> > for
> > 
> > one thing. When I am viewing a whole year I need to scroll left and
> > 
> > right to see columns later in the year and when I do this I can't
> > see
> > 
> > the labels on the left for the accounts. Does anyone have a good
> > way
> > 
> > around this?
> 
> This is a bit cumbersome, but you can export the report, open it in a
> spreadsheet, and "freeze" the left column with the labels and scroll
> easily. You can export it using the Export Report (on toolbar or File
> menu). 
> 
I saw the export, but it's HTML and didn't think that the spreadsheet
would take it. Turns out LibreOffice does quite well.

>  
> > Just before I sent this I was thinking that I could limit the
> > number of
> > 
> > budget periods visible, while this isn't ideal those options are
> > 
> > disabled in the report options. Is this expected?
> 
> The design is a bit klunky -- the options appear if you tick the
> checkbox "Report for range of budget periods." The other controls
> activate when you choose Manual Period Selection.

That does help.

Jon


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] budget report and scrolling

[Tommy Trussell]

On Fri, Aug 6, 2021 at 9:25 AM Jon Schewe  wrote:

> I am using the budget report and it's working quite well, except for
> one thing. When I am viewing a whole year I need to scroll left and
> right to see columns later in the year and when I do this I can't see
> the labels on the left for the accounts. Does anyone have a good way
> around this?
>

This is a bit cumbersome, but you can export the report, open it in a
spreadsheet, and "freeze" the left column with the labels and scroll
easily. You can export it using the Export Report (on toolbar or File
menu).

(Normally you can also open a report, select all, copy and paste it into a
spreadsheet, but when I did that just now in Libreoffice 7.1.4.2 I had a
bit of a problem with formatting. Opening the exported .html version worked
fine.)


> Just before I sent this I was thinking that I could limit the number of
> budget periods visible, while this isn't ideal those options are
> disabled in the report options. Is this expected?
>

The design is a bit klunky -- the options appear if you tick the checkbox
"Report for range of budget periods." The other controls activate when you
choose Manual Period Selection.


> I'm using GnuCash 4.6 on Linux.
>

 same here.

Hope this helped

Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] budget report and scrolling

[Jon Schewe]

I am using the budget report and it's working quite well, except for
one thing. When I am viewing a whole year I need to scroll left and
right to see columns later in the year and when I do this I can't see
the labels on the left for the accounts. Does anyone have a good way
around this?

Just before I sent this I was thinking that I could limit the number of
budget periods visible, while this isn't ideal those options are
disabled in the report options. Is this expected?

I'm using GnuCash 4.6 on Linux.

Thank you,
Jon


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Report - expressed as a percentage

[Bruce Lang]

Is there any possibility of considering adding to the Budget Report, the 
ability to select an option for the Diff column to display as a 
percentage of the Actual/Budget? It would make reporting somewhat more 
convenient. The feedback I receive from those who read the reports i 
they would prefer to see the difference expressed as a percentage 
achieved of the Budget (to compare against the months of the year - e.g. 
at 9 months, expect to see a 75% achievement).


--

Thanks,

*Bruce*



--
This email has been checked for viruses by AVG.
https://www.avg.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report 3.10

[Jon Schewe]

Tom,

Is the screenshot of the the account Expenses:Car:Car Petrol? So the
actual for that row in the report should be 280.81, correct?

Something else to check is the date range on the report. Make sure that
it is overlapping the time period that the transactions are in.

Jon


On Fri, 2020-04-17 at 08:28 +, Thomas Salt wrote:
> Hi,
>   I have checked the budget options and I only have a single budget that 
> is selected hence I see the Budget Values just not the Actual Values.
> 
> Many Thanks
> Tom S
> 
> 
> -Original Message-
> From: gnucash-user  On 
> Behalf Of Adrien Monteleone
> Sent: 16 April 2020 16:21
> To: Gnucash Users 
> Subject: Re: [GNC] Budget Report 3.10
> 
> I just ran a budget report and I’m seeing actual values, so it is not a 
> general bug.
> 
> Double check that the right budget is selected in Options > General > Budget
> 
> Regards,
> Adrien
> 
> On Apr 16, 2020 w16d107, at 4:16 AM, Thomas Salt  wrote:
> 
> Hi Guys,
>I have just tried to run the standard Budget Report. It shows 
> my Budget Values, but no Actual values. If I click and open one of the 
> categories all the entries are shown. Please can you advise.
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> 
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> Many Thanks
> 
> Tom S
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577&sdata=mezyiDl%2F9pRqDQIg1HTO8csplKroFwRZ6eaMNuIMfMc%3D&reserved=0
> If you are using Nabble or Gmane, please see 
> https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577&sdata=vnTKjrgP7%2FSNT8kAYaZ0BZpcjXXmuB7fUazqpRQaDlQ%3D&reserved=0
>  for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report 3.10

[Thomas Salt]

Hi,
I have checked the budget options and I only have a single budget that 
is selected hence I see the Budget Values just not the Actual Values.

Many Thanks
Tom S


-Original Message-
From: gnucash-user  On 
Behalf Of Adrien Monteleone
Sent: 16 April 2020 16:21
To: Gnucash Users 
Subject: Re: [GNC] Budget Report 3.10

I just ran a budget report and I’m seeing actual values, so it is not a general 
bug.

Double check that the right budget is selected in Options > General > Budget

Regards,
Adrien
> On Apr 16, 2020 w16d107, at 4:16 AM, Thomas Salt  wrote:
> 
> Hi Guys,
>I have just tried to run the standard Budget Report. It shows 
> my Budget Values, but no Actual values. If I click and open one of the 
> categories all the entries are shown. Please can you advise.
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> 
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> Many Thanks
> 
> Tom S

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577&sdata=mezyiDl%2F9pRqDQIg1HTO8csplKroFwRZ6eaMNuIMfMc%3D&reserved=0
If you are using Nabble or Gmane, please see 
https://eur05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577&sdata=vnTKjrgP7%2FSNT8kAYaZ0BZpcjXXmuB7fUazqpRQaDlQ%3D&reserved=0
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report 3.10

[Adrien Monteleone]

I just ran a budget report and I’m seeing actual values, so it is not a general 
bug.

Double check that the right budget is selected in Options > General > Budget

Regards,
Adrien
> On Apr 16, 2020 w16d107, at 4:16 AM, Thomas Salt  wrote:
> 
> Hi Guys,
>I have just tried to run the standard Budget Report. It shows 
> my Budget Values, but no Actual values. If I click and open one of the 
> categories all the entries are shown. Please can you advise.
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> 
> 
> [A screenshot of a cell phone  Description automatically generated]
> 
> 
> Many Thanks
> 
> Tom S

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Report 3.10

[Thomas Salt]

Hi Guys,
I have just tried to run the standard Budget Report. It shows 
my Budget Values, but no Actual values. If I click and open one of the 
categories all the entries are shown. Please can you advise.

[A screenshot of a cell phone  Description automatically generated]




[A screenshot of a cell phone  Description automatically generated]


Many Thanks

Tom S

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Budget Report

[stephen.m.butler51]

Sent from my Verizon, Samsung Galaxy smartphone
 Original message From: DANIEL TREVORS 
 Date: 11/23/18  17:34  (GMT-08:00) To: 
gnucash-user@gnucash.org Subject: [GNC] Budget Report I am a new user. I have 
built my chart of accounts and budget, but I cannot get actual numbers to show 
on the budget report. Help please? Dan Trevors Check your high level 
preferences to see what is the default currency.   Make sure it is the same as 
the currency for each account that you set up.  If you have multiple different 
currency then you will need to enter echange rates and others will need to 
chime in on that.So first, what is the currency set at the account 
level?Second, what is the default currency set in the preferences?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Budget Report

[DANIEL TREVORS]

I am a new user. I have built my chart of accounts and budget, but I cannot get 
actual numbers to show on the budget report. Help please? 

Dan Trevors 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.