Re: [GNC] How should I enter values on a budget in gnucash ?
Daniel, The Budget module needs lots of testing. Some changes were made (not sure at what release) to sort out issues with negative signs and the book preference for 'reverse balanced accounts.' I used to use this module quite a bit, but about that time, I fell behind and haven't gotten back to it. When that happens, I'll report back in this thread if I find similar issues as you, and/or if I find answers/solutions. Regards, Adrien On 5/15/24 6:37 PM, Daniel Sheffield wrote: Hi all, I am using Gnucash 4.8. I'm facing the issues discussed here. I see a bunch of issues here: https://bugs.gnucash.org/buglist.cgi?component=Budgets=GnuCash=--- Specifically I am hitting these: * https://bugs.gnucash.org/show_bug.cgi?id=797870 * https://bugs.gnucash.org/show_bug.cgi?id=689754 I've seen a bunch of comments in this e-mail thread about user error or user preferences. Fact is the budget feature is just plain wrong as there is currently no form of user entry that gives consistent results in the following areas: * Budget Chart - plots actual vs budget bar chart * Budget Editor Income/Expense/Transfers/Total - this seems to be where the math error is * Budget Balance sheet - I don't use this one, but can confirm that it behaves as described in the issues above. What I desire: * Budget Editor Income/Expense/Transfers/Total is correct so that I can tell at a glance if I've made a mistake in my budget. * Budget Chart - I need the credits and debits to be plotted in the same direction. I don't care whether the Reverse value for Credit Accounts is set or not or which direction debits/credits are plotted so long as they are consistent. What I have been doing as a work around: * In the Budget Editor I put debiting a liability [thus decreasing my liability] as a +ve value and crediting a liability [thus increasing my liability] as a -ve value. If I make corresponding transactions in my accounts, then the Budget Chart of actuals vs budget agree. * In the Budget Editor I put crediting my Income as a +ve value and debiting an Expense as a +ve value. If I make corresponding transactions in my accounts, then the Budget Chart of actuals vs budget agree for Expenses but are opposite (diverging graph) for Income. But that's OK because I don't include income in my Budget Chart. * In the Budget Editor, the totals are calculated like: Remaining to Budget = Net Income Credits - Net Expense Debits + Net Transfer Debits (where debits are positive values on the budget sheet and credits are negative values on the budget sheet). Note that again, the "Reverse value for Credit Accounts" setting has no effect on the charts or the budget editor as far as I can tell. * Thus, the +ve values on my liabilities increase the total remaining to budget! * I can rectify the total remaining to budget by using -ve values for debiting a liability, but if I do that my Budget Chart is off (I include Expense and Liabilities in my chart). * So instead, I do a crazy hack: For every +ve value in a Liability, I put a corresponding -ve value in Equity and a +ve value in Assets. The result is: * The total remaining to budget is correct * The Budget Chart shows actuals that go in the same direction as budget values for Expense and Liabilities. * The Budget Report is incorrect for liabilities - but I don't use this feature - I use the Budget Chart instead. * I have to remember to put the hack values in my Assets and Equities on the Budget Editor (making room for error). This whole thing makes me afraid to use the budget feature. As my wife is used to an Envelopes (Single Entry) system rather than Double Entry accounting, it's critical that I can have a reliable budgeting feature (essentially what single entry is looking at). At this point, I'm seriously considering changing my method to the following: * Put all values in budget editor as +ve for a debit and -ve for a credit. * The estimate feature will be applying sign reversal inconsistently with this approach - but this is less error prone to reverse (multiply each value by minus -1 as necessary). * The total remaining to budget will be completely wrong, but I can calculate this myself by looking at the rolled up top level accounts (assuming I haven't hard-coded values in any of these accounts). That is, summing the totals on the top-level accounts should add to zero. * Assuming corresponding transactions entered in the accounts, ie, sticking to budget, then all the accounts on the Budget Chart will show actuals agreeing with budget, including Income accounts (and Equity accounts too?). * Differences on Budget Chart will be shown correctly (in terms of magnitude), though wrapping my head around the sign reversal will be a pain - but this is the "normal" confusion I face with meaning of credit and debit in terms of accounting vs colloquial usage. * Budget Report is still wrong (sign reversal applied to Liabilities in Actual but not in Budget values). But I don't use this feature. *
Re: [GNC] Budget-like Balance Sheet Report
Hi Julian Try the Balance Sheet Multicolumn report. It has options for Monthly or Yearly balances. Regards Geoff = On 23/05/2024 1:47 am, Who The Hell Knows wrote: I'm looking for a balance sheet report similar in format to the budget report but instead of the net debit/credit per account per month it shows the account balances at the end of each month in multiple columns, one month per column. Does such a report exist? Thanks, Julian ___ 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. ___ 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] Problem building Gnucash from source using wiki page "macOS/Quartz"
As suggested, I patched project.py in ~/.new_local/lib/python3.11/site-packages/pipenv/ as per "gitHub.com/pypa/pipenv/issues/6106”. Reran gtk-osx-setup.sh and got the following question: - pyenv: /Users/gtkosx/.new_local/share/pyenv/versions/3.11.7 already exists - continue with installation? (y/N) Answered “y”, and it seemed to run to completion, but with some warnings about tkinter and lzma not being installed. Continued with instructions in wiki.gnucash.org/wiki/MacOS/Quartz: - Set path to include ~/.new_local/bin - Moved copy of bash to .new_local/bin - Downloaded jhbuildrc_custom - Put jhbuild_custom in .config - Added 'branches["gnucash-git”]=(None,”master”)’ - Changed “=_modules_stable” to “=_modules_git” Finally, ran “jhbuild bootstrap-gtk-osx” and got: - Loading .env environment variables... - I: Modulesets were edited locally but JHBuild is configured to get them from the network, perhaps you need to add use_local_modulesets = True to your /Users/gtkosx/.config/jhbuildrc. - jhbuild bootstrap-gtk-osx: no such command (did you mean "jhbuild run bootstrap-gtk-osx"?) Tried running “jhbuild -f .config/jhbuildrc-custom bootstrap-gtk-osx” and got: - Loading .env environment variables... - Traceback (most recent call last): - File "/Users/gtkosx/Source/jhbuild/jhbuild/config.py", line 194, in load - execfile(filename, config) - File "/Users/gtkosx/Source/jhbuild/jhbuild/utils/compat.py", line 67, in execfile - exec(code, globals, locals) - File ".config/jhbuildrc-custom", line 3, in - setup_sdk() - ^ - NameError: name 'setup_sdk' is not defined - jhbuild: could not load config file Looks like jhbuild is trying to execute "setup_sdk()” from line 3 of jhbuildrc_custom but can’t find this function. There was no reference to it in the output of gtk-osx-setup.sh. Thanks for any advice on how to proceed. > On May 10, 2024, at 10:43 AM, John Ralls wrote: > > > >> On May 9, 2024, at 10:08, Paul Ingram wrote: >> >> >> Trying to build gnucash-5.6 from source on a mac mini running macOS 14.4.1 >> in accordance with the instructions on >> https://wiki.gnucash.org/wiki/MacOS/Quartz. >> >> Created administrator account “gtkosx” >> Switched to the new account: "su gtkosx" >> Ran “sh gtk-osx-setup.sh” in a bash shell >> Got the following messages: >> >> Installed openssl-3.2.0 … >> Installed readline-8.2 … >> Installed python-3.11.7 (with warnings “missing the Tk toolkit?” and >> “missing the lzma lib?” >> Installed pip-24.0 … >> Installing collected packages: distlib, setup tools, … >> Installed certifi-2024.2.2, distlib-0.3.8, … >> Created virtualenv … >> Locking dependencies ... >> Building requirements … >> Resolving dependencies … >> >> Error: >> File >> "/Users/gtkosx/.new_local/lib/python3.11/site-packages/pipenv/project.py", >> line *239*, in get_requests_session_for_source >> >> if *self.sessions.get**(*source*[*"name"*])*: >> >> ~~ >> >> KeyError: 'name' >> >> ✘ Locking Failed! >> >> >> >> Patch for project.py appears here: https://github.com/pypa/pipenv/issues/6106 >> >> >> >> Do I patch project.py manually and rerun gtk-osx-setup.sh? >> > > Yes. Pipenv has merged my PR but hasn’t done a new release. > > Regards, > John Ralls signature.asc Description: Message signed with OpenPGP ___ 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-like Balance Sheet Report
I'm looking for a balance sheet report similar in format to the budget report but instead of the net debit/credit per account per month it shows the account balances at the end of each month in multiple columns, one month per column. Does such a report exist? Thanks, Julian ___ 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.