[GNC] Budgeting > transfers to liabilities and securities purchase

[Mark Walters]

Hi Everyone,
Issue 1
I updated to Debian Bullseye and Gnucash Version: 3.10, Build ID:
3.10+(2020-04-11).
Entering a positive number for a transfer to the liability in the budget
makes the budget balance sheet show the correct change to the liability
(i.e. a transfer to my mortgage account decreases the balance of that
mortgage)
Now the "budget report" has a sign error. Actuals reported negative, while
the budget is reported positive.

Issue 2
For securities purchase, my work around is to enter a zero in the summary
row for securities to stop gnucash counting units as dollars. Entering the
value (zero or purchase price) here stops the budget balance sheet from
including previously held securities. This is still a bit buggy as the
transfer to securities needs a budget unit price to be able to resolve the
budget to zero.
Would be great to be able to enter a budget unit price and have GnuCash
work of the total price or number of units.

Thanks,
Mark



On Tue, Jul 7, 2020 at 6:07 PM Christopher Lam <christopher.lck at gmail.com>
wrote:

> 1. Please use the very latest gnucash 3.11 or 4.0; if there are still
> issues please file bug in Bugzilla.
>
> 2. Budget for securities is error prone; currency and share exchanges are
> complex and not proven to be reliable in budgeting module.
>
> On Tue, 7 Jul 2020, 3:43 pm Mark Walters, <mark.walters.0 at gmail.com>
> wrote:
>
>> Hi everyone,
>> I am trying to use Gnucash budgeting and have 2 issues. I have searched
>> the
>> mailing list and google'd but had no luck.
>>
>> 1.Sign convention issues between budget, transactions and budget reports
>> I am budgeting for transfers to a liability (mortgage repayment). To make
>> the budget balance sheet reduce my liability, a positive number is entered
>> in the budget under mortgage liability. But when I use the estimate
>> function, the repayments are entered as negative numbers.
>> i.e. a test repayment of $50k comes through to -$50k with the estimate
>> function. But the budget balance sheet records an increase in the
>> liability
>> from $350k to $400k, this should be $350k to $300k. I though perhaps my
>> liability should have a negative balance, but the transaction entry
>> (actuals) currently decrease the liability as entered and as expected.
>>
>> 2. Budgeting for securities purchase
>> I'd like to budget a certain dollar value transaction to buy shares (Say
>> $1k). When I enter this in the budget. the totals in the budget sheet work
>> as expected. But the budget balance sheet adds 1000 units to my holding,
>> instead of the number of units. Understand that the future price is
>> unknown
>> but the calculation seems inconsistent (dollars in budget, but carried
>> forward as units). If I enter units in the budget, the budget balance
>> sheet
>> works.. but then the budget doesn't sum to zero (because no price is
>> applied to units)
>> How do others enter this in a budget? Should I have another 'dollar'
>> account to capture the value of the shares?
>>
>>
>> Kind Regards,
>> Mark Walters
>> Email: mark.walters.0 at gmail.com
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
>>
>