Re: [GNC] Budget-like Balance Sheet Report
Thanks Geoff. A couple tweaks to the defaults and I got exactly what I needed. Regards, Julian On Fri., May 24, 2024, 8:46 a.m. Geoff, wrote: > 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] 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 do
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.
[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.
[GNC] How should I enter values on a budget in gnucash ?
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. * Budget Balance sheet is still wrong for the same reason. But I don't use this feature either. This would achieve my goals of a) reduce possibility of introducing error while creating my budget, b) ensure the Budget Chart is readable and differences are shown at correct magnitude. But it still bugs me that the Total Remaining to budget is wrong (let alone other budget reports than budget chart being wrong). It's not a good look trying to explain away this discrepancy t
Re: [GNC] Budget car payment
You can indeed save as CSV after opening in LibreOffice or Excel. Once it is opened, the spreadsheet app now controls what you do with it. Regards, Adrien On 1/13/24 5:27 PM, David Carlson wrote: I just tried opening a GnuCash report saved in Html format with Libre Office writer and found that it would offer to save in ODT format as soon as I tried to save anything. I am sure that it would also save in csv or other common formats. ___ 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 car payment
I just tried opening a GnuCash report saved in Html format with Libre Office writer and found that it would offer to save in ODT format as soon as I tried to save anything. I am sure that it would also save in csv or other common formats. On Sat, Jan 13, 2024 at 3:14 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 1/13/2024 1:34 PM, Dennis Powless wrote: > > Are there other options to export besides HTML? Say to excel in csv or > txt? > > > If you open an HTML document, do you know how to get the content saved > as .xlsx or .cvs or .txt? The point here is that asking the developers > to add the option of adding export to format X just kicks the can down > the road to "how about format Y:. > > > Michael D Novack > > > ___ > 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. > -- David Carlson ___ 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 car payment
On 1/13/2024 1:34 PM, Dennis Powless wrote: Are there other options to export besides HTML? Say to excel in csv or txt? If you open an HTML document, do you know how to get the content saved as .xlsx or .cvs or .txt? The point here is that asking the developers to add the option of adding export to format X just kicks the can down the road to "how about format Y:. Michael D Novack ___ 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 car payment
On 2024-01-13 10:34, Dennis Powless wrote: > Are there other options to export besides HTML? Say to excel in csv or txt? Directly, no. But you can open the exported HTML file in Excel and then File » Save As a variety of formats including CSV and text. I've never done this myself, but it has been posted many times on this mailing list. Stan Brown Tehachapi, CA, USA https://BrownMath.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 - 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 car payment
I realize that Gnucash is not a budgeting tool and I don't expect it to provide the functionality that one can get from excel or open office. So, I think I will just export the data to excel and do the budget/dashboard from there. I can get what I need from the reports quite easily in gnucash. D On Sat, Jan 13, 2024 at 1:34 PM Dennis Powless wrote: > Are there other options to export besides HTML? Say to excel in csv or > txt? > > D > > On Wed, Jan 10, 2024 at 2:50 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > >> Signs in Budgets need more testing. (I had plans to do so long ago, >> perhaps I might get to it now as I'm way behind in my own budgeting!) >> >> You might have to play around a bit to see if it is possible to come up >> with a sane entry method that produces a sane bottom line result. Or you >> may have discovered a bug that needs fixing. >> >> I'll endeavor to work on my budget this week and see if I can duplicate >> your issue. >> >> >> >> And no, I don't think the Budget Module docs have been updated in many >> moons and suns. >> >> Regards, >> Adrien >> >> On 1/10/24 12:12 PM, Dennis Powless wrote: >> > I'm trying to create a budget and am having some issues with setting it >> up. >> > I have a liability for car loan and expense for interest for that loan. >> > >> > I pay out of the checking account, say 500. >> > I split to the Liability loan 200 and expense interest 300. >> > >> > In a spreadsheet I would budget out 500 for the car payment. However, >> > Gnucash is not set up this way (or I have it wrong). >> > >> > The liability payment is a negative entry in the budget and the expense >> is >> > a positive value. >> > The same in the "budget report" created. >> > >> > The help docs are not very helpful, nor are internet searches. Most in >> the >> > end, state to use a separate spreadsheet for budgeting. >> > Which I have been doing for many years, but figured I'd give it another >> try >> > as it's been about 9 years. >> >> ___ >> 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] Budget car payment
Are there other options to export besides HTML? Say to excel in csv or txt? D On Wed, Jan 10, 2024 at 2:50 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Signs in Budgets need more testing. (I had plans to do so long ago, > perhaps I might get to it now as I'm way behind in my own budgeting!) > > You might have to play around a bit to see if it is possible to come up > with a sane entry method that produces a sane bottom line result. Or you > may have discovered a bug that needs fixing. > > I'll endeavor to work on my budget this week and see if I can duplicate > your issue. > > > > And no, I don't think the Budget Module docs have been updated in many > moons and suns. > > Regards, > Adrien > > On 1/10/24 12:12 PM, Dennis Powless wrote: > > I'm trying to create a budget and am having some issues with setting it > up. > > I have a liability for car loan and expense for interest for that loan. > > > > I pay out of the checking account, say 500. > > I split to the Liability loan 200 and expense interest 300. > > > > In a spreadsheet I would budget out 500 for the car payment. However, > > Gnucash is not set up this way (or I have it wrong). > > > > The liability payment is a negative entry in the budget and the expense > is > > a positive value. > > The same in the "budget report" created. > > > > The help docs are not very helpful, nor are internet searches. Most in > the > > end, state to use a separate spreadsheet for budgeting. > > Which I have been doing for many years, but figured I'd give it another > try > > as it's been about 9 years. > > ___ > 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] Budget car payment
Signs in Budgets need more testing. (I had plans to do so long ago, perhaps I might get to it now as I'm way behind in my own budgeting!) You might have to play around a bit to see if it is possible to come up with a sane entry method that produces a sane bottom line result. Or you may have discovered a bug that needs fixing. I'll endeavor to work on my budget this week and see if I can duplicate your issue. And no, I don't think the Budget Module docs have been updated in many moons and suns. Regards, Adrien On 1/10/24 12:12 PM, Dennis Powless wrote: I'm trying to create a budget and am having some issues with setting it up. I have a liability for car loan and expense for interest for that loan. I pay out of the checking account, say 500. I split to the Liability loan 200 and expense interest 300. In a spreadsheet I would budget out 500 for the car payment. However, Gnucash is not set up this way (or I have it wrong). The liability payment is a negative entry in the budget and the expense is a positive value. The same in the "budget report" created. The help docs are not very helpful, nor are internet searches. Most in the end, state to use a separate spreadsheet for budgeting. Which I have been doing for many years, but figured I'd give it another try as it's been about 9 years. ___ 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 car payment
I'm trying to create a budget and am having some issues with setting it up. I have a liability for car loan and expense for interest for that loan. I pay out of the checking account, say 500. I split to the Liability loan 200 and expense interest 300. In a spreadsheet I would budget out 500 for the car payment. However, Gnucash is not set up this way (or I have it wrong). The liability payment is a negative entry in the budget and the expense is a positive value. The same in the "budget report" created. The help docs are not very helpful, nor are internet searches. Most in the end, state to use a separate spreadsheet for budgeting. Which I have been doing for many years, but figured I'd give it another try as it's been about 9 years. Dennis ___ 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 reports 'YTD' vs 'use accumulated amounts'
Thanks. That is what I was looking for. I thought it was a report, not an option on a report. Larry On Fri, Nov 17, 2023, 8:17 p.m. Mark Penner wrote: > On Friday, November 17, 2023 1:53:38 PM CST larry johnston wrote: > > I got as far as upgrading to GC 4.14 and was planning to use the Use > > Accumulated Amounts report but I could not find it. Do I have to upgrade > to > > ver 5 or am I not looking in the correct place? > > I don't know where you've looked, but in the Budget Report options, on the > General tab, there is a checkbox labelled 'Use accumulated amounts'. Is > that > what you're looking for? When checked the accumulated amount budgeted over > all > periods up to the that period is shown. When unchecked only the amount > budgeted for that period is shown. > > > ___ 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 reports 'YTD' vs 'use accumulated amounts'
On Friday, November 17, 2023 1:53:38 PM CST larry johnston wrote: > I got as far as upgrading to GC 4.14 and was planning to use the Use > Accumulated Amounts report but I could not find it. Do I have to upgrade to > ver 5 or am I not looking in the correct place? I don't know where you've looked, but in the Budget Report options, on the General tab, there is a checkbox labelled 'Use accumulated amounts'. Is that what you're looking for? When checked the accumulated amount budgeted over all periods up to the that period is shown. When unchecked only the amount budgeted for that period is shown. ___ 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 reports 'YTD' vs 'use accumulated amounts'
I'm not familiar with such a report name. I'm on 5.4 and it does not exist. Regards, Adrien On 11/17/23 1:53 PM, larry johnston wrote: Hi, I got as far as upgrading to GC 4.14 and was planning to use the Use Accumulated Amounts report but I could not find it. Do I have to upgrade to ver 5 or am I not looking in the correct place? ___ 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 reports 'YTD' vs 'use accumulated amounts'
Hi, I got as far as upgrading to GC 4.14 and was planning to use the Use Accumulated Amounts report but I could not find it. Do I have to upgrade to ver 5 or am I not looking in the correct place? TIA, Larry On Wed, Jul 19, 2023 at 1:31 PM larry johnston wrote: > Hi, > > Yes, I was thinking of starting over with 5.3. If I could import the Chart > of Accounts from 2.6.15 that would be great. > > Larry > > On Wed, Jul 19, 2023, 11:17 a.m. Stan Brown (using GC 2.6.19) < > stan+gnuc...@fastmail.fm> wrote: > >> On 2023-07-19 09:25, Adrien Monteleone wrote: >> > On 7/18/23 1:07 PM, larry johnston wrote: >> >> Will 2.6.15 run on Windows 11? Can it still be downloaded? >> > >> > First a direct answer: >> > >> > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with >> > Win11 can try installing it to see and report back. (best I have is >> > access to Win10) >> >> I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't >> imagine 2.6.15 would be any different. >> >> (I've been very short of time for months, and haven't had time to follow >> through on my intention to move to 5.x.) >> >> Stan Brown >> Tehachapi, CA, USA >> https://BrownMath.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 >> - >> 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] budget reports 'YTD' vs 'use accumulated amounts'
Hi, Yes, I was thinking of starting over with 5.3. If I could import the Chart of Accounts from 2.6.15 that would be great. Larry On Wed, Jul 19, 2023, 11:17 a.m. Stan Brown (using GC 2.6.19) < stan+gnuc...@fastmail.fm> wrote: > On 2023-07-19 09:25, Adrien Monteleone wrote: > > On 7/18/23 1:07 PM, larry johnston wrote: > >> Will 2.6.15 run on Windows 11? Can it still be downloaded? > > > > First a direct answer: > > > > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with > > Win11 can try installing it to see and report back. (best I have is > > access to Win10) > > I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't > imagine 2.6.15 would be any different. > > (I've been very short of time for months, and haven't had time to follow > through on my intention to move to 5.x.) > > Stan Brown > Tehachapi, CA, USA > https://BrownMath.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 > - > 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] budget reports 'YTD' vs 'use accumulated amounts'
On 2023-07-19 09:25, Adrien Monteleone wrote: > On 7/18/23 1:07 PM, larry johnston wrote: >> Will 2.6.15 run on Windows 11? Can it still be downloaded? > > First a direct answer: > > I don't know, but I'm sure It doesn't hurt to try. Maybe someone with > Win11 can try installing it to see and report back. (best I have is > access to Win10) I have 2.6.19, and it runs just fine on Windows 10 and 11. I can't imagine 2.6.15 would be any different. (I've been very short of time for months, and haven't had time to follow through on my intention to move to 5.x.) Stan Brown Tehachapi, CA, USA https://BrownMath.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 - 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 reports 'YTD' vs 'use accumulated amounts'
I forgot about that option. For completeness, what you are describing is to start with the new version on a new computer with a fresh file, then just use your ending figures from the 2.6.15 file as 'opening balances' in the new file, correct? Note, you can start entirely fresh, or if you like, you can export just the Chart of Accounts from 2.6.15, import it to 5.3, and then manipulate it from there. The upgrade path isn't as terrible as it sounds, and it would allow you to preserve in-app access to historical data. But by all means, chart your own course. You have lots of options. Regards, Adrien On 7/19/23 12:57 PM, larry johnston wrote: I think I will install the latest version and try the 'use accumulated totals' report with a test file. If it works then make the jump. I have an old laptop that is running 2.6.15 if I have to access the old files. Rebuilding the Chart of Accounts seems easier than the upgrade process. ___ 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 reports 'YTD' vs 'use accumulated amounts'
, data and all, to a Virtual Machine. I have set
> up Virtual Machines (VMs) for several non-techy family members and they
> use it with no problems.
>
> If you end up needing that sort of solution, there are several of us
> here who can help, even though that isn't specific to GnuCash. (and
> there is plenty of help on the web for that too)
>
> Lastly, don't rule that old rustbucket out. It may be possible to
> 'refresh' it simply by reinstalling Windows, possibly upgrading some
> internal hardware, or switching to an appropriate version of Linux.
> You'd be amazed how either of those approaches can revitalize aging
> hardware to like-new performance. (or better in some cases!)
>
> > Does a later version have a report with the same functionality as Phil's
> > YTD report?
>
> I think Chris answered this, but specifically we'd need Phil's report
> (or at least a sample of its output) to know for sure.
>
> To your more detailed question:
>
> > Does the current Budget Report give YTD figures?
>
> Yes, using the 'accumulated amounts' option.
>
> > Does it show 'Current month vs. Budget'
>
> That is ambiguous, but I'm guessing you want 'current month actual' vs.
> 'current month budget'. The answer is Yes, *without* 'accumulated
> amounts' selected. (how the report normally works - each period is shown
> actual, budget, and variance (if selected to) *for that period*.
>
> If you want to see YTD of your Actual vs. YTD of your Budget *as of a
> period* that is what the 'accumulated amounts' option is for.
>
> > Does it show 'YTD vs. Budget
> Yes, as noted above. (not sure how you see this differently)
>
> > Does it show 'Current Income & Expense vs. Annual Budget'
>
> Yes. Of course, you need to include those accounts in the report to see
> the data just as before.
>
> The old Budget Report could do this with Options > Display > 'Show
> column with totals'.
>
> This column is superfluous when using the 'accumulated amounts' if
> you're at the end of the budgeting window as the figures should match
> the last period, but otherwise, it is very useful to see 'how much room
> do I have left' if you are not yet done with that budget. ('year' for
> most folks) Here too the 'variance' column is useful.
>
> > If we want to access our current files what stages of upgrading do we
> need
> > to take?
>
> See above about Upgrade Path
>
> > Is it possible for someone who is not that computer savvy to run two
> > versions of GNUCash on Windows 11?
>
> Yes, see above about Virtual Machines, but be sure to read the FAQ about
> Up/Downgrading. There are limits once you go past some versions.
>
>
> Regards,
> Adrien
>
> ___
> 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] Year to Date Budget Report
Adrien, The original thread was three years ago. Has there been any changes to 'use accumulated amounts' report? Larry On Wed, Jul 19, 2023 at 9:32 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > Larry, it was there. I answered in that existing thread. (and I see you > replied there too) > > Regards, > Adrien > > On 7/18/23 4:55 PM, larry johnston wrote: > > Hi, > > > > I thought I posted this question to the list earlier today but I did not > > see it come through on the feed. So forgive me if it is already out > there. > > ___ > 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] Year to Date Budget Report
Larry, it was there. I answered in that existing thread. (and I see you replied there too) Regards, Adrien On 7/18/23 4:55 PM, larry johnston wrote: Hi, I thought I posted this question to the list earlier today but I did not see it come through on the feed. So forgive me if it is already out there. ___ 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 reports 'YTD' vs 'use accumulated amounts'
On 7/18/23 1:07 PM, larry johnston wrote:
Hi,
I did not try to upgrade when I asked this question three years ago.
However my computer is on its last legs so I am trying to decide what to do
when I get the new computer.
We have been using GNUCash 2.6.15 and it has met our needs for our personal
finances. A key feature for us is Phil's YTD report. Per the discussion in
this string his report will not work in more recent versions. As a result I
have a few questions.
Will 2.6.15 run on Windows 11? Can it still be downloaded?
First a direct answer:
I don't know, but I'm sure It doesn't hurt to try. Maybe someone with
Win11 can try installing it to see and report back. (best I have is
access to Win10)
*note, the advice below sounds like a lot of work and reading. It is.
That's the tradeoff when you wait to upgrade. You don't put off the
work, you just scrunch it into 'one shot' later.
-
Second, about finding the older versions:
You can find it along with all other versions on SourceForge. (the
official location of all GnuCash Downloads)
https://sourceforge.net/projects/gnucash/files/
Click the '(stable)' folder, then the folder for the version you want,
then click the installer you need. ('.exe' in your case)
If you ever need to get back there again - simply go to GnuCash.org and
click the 'More downloads' link in the Download section at the top of
the page. That will take you to: https://gnucash.org/download.phtml
(there is also a Downloads section in the site menu, you can download
'program' or 'documentation' from there)
On that page, scroll to the bottom and choose the link for 'View all
GnuCash downloads' which takes you to the above SourceForge page.
Use this to find any old version. (necessary for your upgrade path
should you take it)
Despite the cutoff of old versions for old operating systems, there is
no hard rule that a *newer* version of GnuCash won't run on say, XP or
Win7, just that the devs don't support it and you are on your own
trying. I've never heard of any issue with old versions of *GnuCash*
running on *newer* operating system versions. (your case)
-
Third, upgrade path:
Read this over first:
https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade
With all that out of the way, and understanding it (ask back here on the
list if you have questions) you can proceed.
MAKE BACKUPS! (or at least some sort of copy of your data file in
between *each* upgrade) That way if you have any problems or notice any
sort of data corruption, you can step back and try again.
See this FAQ on Backups:
https://wiki.gnucash.org/wiki/FAQ#Questions_about_Backups
You may want to backup your 'environment' as well as your data - so
don't skip that section!
(yes, you will need to get familiar with the various file locations to
seamlessly pull this off)
now, to really proceed with the upgrade...
In your case, you would first want to upgrade to the last release of the
2.6.x series, 2.6.21
Then you would step to the last of the 3.x series, then last of 4.x,
then finally the current 5.x release which is 5.3.
Those releases in order would be:
2.6.15 -> 2.6.21 -> 3.11 -> 4.14 -> 5.3
Be sure (as noted in the above FAQ answer) to run Actions > Check &
Repair > Check & Repair All after first opening your file when you do
*each* upgrade. This is important. It should take only a few seconds,
but some data files might take longer. Report back here if you have any
issues.
-
Fourth, other options:
In a worst case, if you need to upgrade the computer to a new physical
machine running Win11, and 2.6.15 doesn't install or run, you could try
running 2.6.15 in a Virtual Machine. (either running your previous
version of Windows, or Linux) That is a tad bit technical, but not
terribly so these days. It is essentially running the old OS inside an
'app'. There are even ways to migrate your current computer
installation, software, data and all, to a Virtual Machine. I have set
up Virtual Machines (VMs) for several non-techy family members and they
use it with no problems.
If you end up needing that sort of solution, there are several of us
here who can help, even though that isn't specific to GnuCash. (and
there is plenty of help on the web for that too)
Lastly, don't rule that old rustbucket out. It may be possible to
'refresh' it simply by reinstalling Windows, possibly upgrading some
internal hardware, or switching to an appropriate version of Linux.
You'd be amazed how either of those approaches can revitalize aging
hardware to like-new performance. (or better in some cases!)
Does a later version have a report with the same functionality as Phil's
YTD report?
I think Chris answered this, but specifically we'd need Phil's report
(or at least a sample of its output) to know for sure.
To your more detailed question:
Does the current Budget Report give YTD figures?
Y
[GNC] Year to Date Budget Report
Hi, I thought I posted this question to the list earlier today but I did not see it come through on the feed. So forgive me if it is already out there. My computer is on its last legs and I am expecting a newer one running Windows 11. Will I still be able to run GNUCash 2.6.15 or should I upgrade to a newer version? 2.6.15 meets our needs for home finances. We currently use GNUCash 2.6.15 with Windows 10and rely on Phil's custom YTD report to compare income and expenses against my budget. If I upgrade to the current version which I understand has a similar report called 'use accumulated amounts'. I am wondering if anyone has used both and can let me know if 'use accumulated totals' works as well as YTD. YTD gives me a report that includes: current month vs budget, year to date vs budget and current income and expenses vs annual budget. I don't want to lose that functionality if I upgrade. TIA, Larry ___ 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 reports 'YTD' vs 'use accumulated amounts'
Hi, I did not try to upgrade when I asked this question three years ago. However my computer is on its last legs so I am trying to decide what to do when I get the new computer. We have been using GNUCash 2.6.15 and it has met our needs for our personal finances. A key feature for us is Phil's YTD report. Per the discussion in this string his report will not work in more recent versions. As a result I have a few questions. Will 2.6.15 run on Windows 11? Can it still be downloaded? Does a later version have a report with the same functionality as Phil's YTD report? If we want to access our current files what stages of upgrading do we need to take? Is it possible for someone who is not that computer savvy to run two versions of GNUCash on Windows 11? TIA, Larry On Wed, Jan 15, 2020 at 3:59 PM Christopher Lam wrote: > The updated budget report in 3.8 aims to display the YTD budget amounts. > If it does not perform well then you'll need to file a bug. > > On Wed, 15 Jan 2020 at 23:48, larry johnston > wrote: > > > Peter, > > > > I am still running 2.6.15. I am running Windows 10. Phil's report still > > runs well in Wndows 10. > > > > I have not upgraded because I do not want to lose the functionality of > > Phil's report. I do not download financial information from institution > as > > I do manual entry so have not seen any reason to upgrade. I am however > > worried that if I wait too long I won't be able to access my data in a > > later upgrade. > > > > Have you used the 'use accumulated totals' function in the newer > versions? > > I gather from what you state that you don't think it will > > provide similar results to Phil's YTD refort. > > > > Larry > > > > On Sun, Jan 12, 2020 at 2:54 AM pj42uk wrote: > > > > > Larry, so far as I can tell the Standard report does not provide the > YTD > > > information. > > > Phil's report does nor run properly on v 3.8 Windows 10. > > > Is your experience any different? > > > Peter > > > > > > > > > > > > -- > > > Sent from: > > http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > > > ___ > > > 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. > > > ___ > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Budget reporting issue
I've just run my budget report for the first time since the 5.0 upgrade (specifically, I'm on version 5.0, build ID Flathub 5.0-1, on Ubuntu 22.04 LTS ), and my saved report configuration comes up completely blank. In troubleshooting, I find that if I use the "Make PDF" button and export the report as PDF, it is fine. Reporting here to see if anyone else is having a similar issue. ___ 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] [Bug 798864] Budget Revalues for the Income are positive numbers.porting on select reports are wrong
On 4/17/2023 4:01 AM, Richard Lindgren wrote: Sounds like you understand my problem. However, since I'm not a programmer, I hesitate to tackle this patch. Maybe it is easier than it looks and is probably the best fix? I'm just nervous here. Let me ask this basic question. When I am creating my Budget, I have assumed this: 1. All Income values are positive numbers. 2. All Expense values are negative numbers. With that being said and used, my reports work for; a) Profit and Loss Report and b) my Budget Report. Now the question is, where do I go from here? For me to be able to help you, you would need to stop thinking of positive and negative that way. Double entry bookkeeping is older than the use of negative numbers in European mathematics. To ME, in the context of bookkeeping, positive means a balance in the sense expected for an account of that type and negative if in the sense opposite to what is expected for that sort of account. With the two senses being "debit" and "credit". (as opposed to positive and negative). Which is normal depends on the type of the account (or as we would say in the old days, on which side of the ledger -- picture an open book; there is a left hand page and a right hand page). So . I would consider a income amount negative were it a debit and an expense amount negative were it a credit (say a rebate). That's because normal for account type income is credit and normal for account type expense is debit. Notice it is different say for the bank account involved as the other side of these transactions, but that is because its type is "asset". When reporting a bug, I would suggest FIRST seeing if this bug manifests while using just the formal accounting senses debit and credit. If not, but you perceive the problem when using positive and negative, give serious consideration that the problem is not with the program but misunderstanding how positive and negative apply in this situation. Michael D Novack ___ 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] [Bug 798864] Budget Revalues for the Income are positive numbers.porting on select reports are wrong
Richard, Just a note that if you reply to Christopher's bug messages by email, the discussion at the bug website is incomplete. You and the community would be better served by your replying in the bug itself. David T. On Apr 17, 2023, 11:02, at 11:02, Richard Lindgren wrote: >Sounds like you understand my problem. However, since I'm not a >programmer, I hesitate to tackle this patch. Maybe it is easier than it >looks and is probably the best fix? I'm just nervous here. > >Let me ask this basic question. When I am creating my Budget, I have >assumed this: >1. All Income values are positive numbers. >2. All Expense values are negative numbers. > >With that being said and used, my reports work for; a) Profit and Loss >Report and b) my Budget Report. > >Now the question is, where do I go from here? > >Richard > >-Original Message- >From: bugs-ad...@bugs.gnucash.org >Sent: Monday, April 17, 2023 12:19 AM >To: rlindgr...@outlook.com >Subject: [Bug 798864] Budget Reporting on select reports are wrong > >https://bugs.gnucash.org/show_bug.cgi?id=798864 > >--- Comment #7 from Christopher Lam --- >Created attachment 374682 > --> https://bugs.gnucash.org/attachment.cgi?id=374682=edit >candidate patch > >Here's a candidate replacement for budget-income-statement.scm, or the >patch pasted below. You can overwrite the budget-income-statement.scm >somewhere into the Program Files\gnucash\etc...\ (you'll need admin >access). > >It changes the definition of net-income from simple summation to a >recalculation of balances of both income and expense budget amounts. I >think this is the correct fix. > >modified gnucash/report/reports/standard/budget-income-statement.scm >@@ -428,7 +428,11 @@ > (gnc:get-assoc-account-balances-total expense-account-balances)) > > (net-income >- (gnc:collector- revenue-total expense-total)) >+ (gnc:collector- >+ (gnc:get-assoc-account-balances-total >+(get-assoc-account-balances-budget >+ budget (append revenue-accounts expense-accounts) >+ period-start period-end >gnc:budget-account-get-net > > (table-env > (list > >-- >You are receiving this mail because: >You are on the CC list for the bug. >You reported the bug. >___ >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] [Bug 798864] Budget Reporting on select reports are wrong
I have followed the GnuCash account structure format in setting up my accounts. Both my Income and Expense Accounts are Top Level Accounts. Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:43 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #8 from Christopher Lam --- P.S. even if this is the right fix, the budget report is very likely to show wildly incorrect amounts if the user has an unusual account structure, e.g. an Expense account whose parent-account is Income. -- You are receiving this mail because: You reported the bug. You are on the CC list for the bug. ___ 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] [Bug 798864] Budget Revalues for the Income are positive numbers.porting on select reports are wrong
Sounds like you understand my problem. However, since I'm not a programmer, I hesitate to tackle this patch. Maybe it is easier than it looks and is probably the best fix? I'm just nervous here. Let me ask this basic question. When I am creating my Budget, I have assumed this: 1. All Income values are positive numbers. 2. All Expense values are negative numbers. With that being said and used, my reports work for; a) Profit and Loss Report and b) my Budget Report. Now the question is, where do I go from here? Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:19 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #7 from Christopher Lam --- Created attachment 374682 --> https://bugs.gnucash.org/attachment.cgi?id=374682=edit candidate patch Here's a candidate replacement for budget-income-statement.scm, or the patch pasted below. You can overwrite the budget-income-statement.scm somewhere into the Program Files\gnucash\etc...\ (you'll need admin access). It changes the definition of net-income from simple summation to a recalculation of balances of both income and expense budget amounts. I think this is the correct fix. modified gnucash/report/reports/standard/budget-income-statement.scm @@ -428,7 +428,11 @@ (gnc:get-assoc-account-balances-total expense-account-balances)) (net-income - (gnc:collector- revenue-total expense-total)) + (gnc:collector- + (gnc:get-assoc-account-balances-total +(get-assoc-account-balances-budget + budget (append revenue-accounts expense-accounts) + period-start period-end gnc:budget-account-get-net (table-env (list -- You are receiving this mail because: You are on the CC list for the bug. You reported the bug. ___ 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] [Bug 798864] Budget Reporting on select reports are wrong
I expect GnuCash to show the actual Total amount of Income minus the Actual Expenses which would leave the difference, to show the actual net Loss or Gain. Richard -Original Message- From: bugs-ad...@bugs.gnucash.org Sent: Monday, April 17, 2023 12:08 AM To: rlindgr...@outlook.com Subject: [Bug 798864] Budget Reporting on select reports are wrong https://bugs.gnucash.org/show_bug.cgi?id=798864 --- Comment #6 from Christopher Lam --- In other words what do you think should be the "Total revenue", "Total expenses" and "Net loss/gain for Budget Unnamed Budget"? -- You are receiving this mail because: You reported the bug. You are on the CC list for the bug. ___ 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] GnuCash 5.0 Budget Reporting on select reports are wrong
https://bugs.gnucash.org/ On Sat, 15 Apr 2023, 5:49 pm Richard Lindgren, wrote: > How do I file a Bugzilla report? > > > > Richard > > > > *From:* Christopher Lam > *Sent:* Saturday, April 15, 2023 5:37 AM > *To:* Richard Lindgren > *Cc:* GnuCash users group > *Subject:* Re: [GNC] GnuCash 5.0 Budget Reporting on select reports are > wrong > > > > It's true that only the "Budget report" has been scrutinized for bugs. > Please file in Bugzilla. > > > > On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, > wrote: > > I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: > 5.0+(2023-03-25)) after realizing that the budget expense calculations were > not correct. Not all the budget reports are wrong, but of the reports that > I choose to use that are wrong are: > > 1. Budget Income Statement > 2. Budget Profit & Loss Statement. > > It appears that both the income and expense values(Data) for the above > listed reports show the values in black (signifying that they are positive > numbers for each income and expenses?). The other reports that I use (not > listed) have their values for the income and expenses in black(income) and > red(expenses). Those calculations appear to be working fine. The reports > listed above show the calculations incorrect. In my preferences, I have > checked the box to have all negative amounts to be in "Red". > > In addition to accessing the reports menu for my saved reports, the > program often crashes. I then am required to reopen the program and are > given five (5) options before being allowed to continue. They are: > > 1. Open Read Only > 2. Create a new file > 3. Open anyway > 4. Open Folder > 5. Quit > > I choose option # 3 "Open anyway". After doing that, I save the file and > then I continue with my reports. > > If I am doing something wrong, please forgive me and show me the error of > my ways. > > Thank you in advance for your help. I look forward to hearing from you. > > Richard Lindgren > rlindgr...@outlook.com<mailto:rlindgr...@outlook.com> > 269-876-9100 > ___ > 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] GnuCash 5.0 Budget Reporting on select reports are wrong
It's true that only the "Budget report" has been scrutinized for bugs. Please file in Bugzilla. On Sat, 15 Apr 2023, 4:38 pm Richard Lindgren, wrote: > I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: > 5.0+(2023-03-25)) after realizing that the budget expense calculations were > not correct. Not all the budget reports are wrong, but of the reports that > I choose to use that are wrong are: > > 1. Budget Income Statement > 2. Budget Profit & Loss Statement. > > It appears that both the income and expense values(Data) for the above > listed reports show the values in black (signifying that they are positive > numbers for each income and expenses?). The other reports that I use (not > listed) have their values for the income and expenses in black(income) and > red(expenses). Those calculations appear to be working fine. The reports > listed above show the calculations incorrect. In my preferences, I have > checked the box to have all negative amounts to be in "Red". > > In addition to accessing the reports menu for my saved reports, the > program often crashes. I then am required to reopen the program and are > given five (5) options before being allowed to continue. They are: > > 1. Open Read Only > 2. Create a new file > 3. Open anyway > 4. Open Folder > 5. Quit > > I choose option # 3 "Open anyway". After doing that, I save the file and > then I continue with my reports. > > If I am doing something wrong, please forgive me and show me the error of > my ways. > > Thank you in advance for your help. I look forward to hearing from you. > > Richard Lindgren > rlindgr...@outlook.com<mailto:rlindgr...@outlook.com> > 269-876-9100 > ___ > 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.
[GNC] GnuCash 5.0 Budget Reporting on select reports are wrong
I have upgraded my GnuCash program 4.13 to 5.0 (Build ID: 5.0+(2023-03-25)) after realizing that the budget expense calculations were not correct. Not all the budget reports are wrong, but of the reports that I choose to use that are wrong are: 1. Budget Income Statement 2. Budget Profit & Loss Statement. It appears that both the income and expense values(Data) for the above listed reports show the values in black (signifying that they are positive numbers for each income and expenses?). The other reports that I use (not listed) have their values for the income and expenses in black(income) and red(expenses). Those calculations appear to be working fine. The reports listed above show the calculations incorrect. In my preferences, I have checked the box to have all negative amounts to be in "Red". In addition to accessing the reports menu for my saved reports, the program often crashes. I then am required to reopen the program and are given five (5) options before being allowed to continue. They are: 1. Open Read Only 2. Create a new file 3. Open anyway 4. Open Folder 5. Quit I choose option # 3 "Open anyway". After doing that, I save the file and then I continue with my reports. If I am doing something wrong, please forgive me and show me the error of my ways. Thank you in advance for your help. I look forward to hearing from you. Richard Lindgren rlindgr...@outlook.com<mailto:rlindgr...@outlook.com> 269-876-9100 ___ 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 problem
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
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
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
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
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
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
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, >> > &g
Re: [GNC] Budget report fails in multiple currencies
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 > > tha
Re: [GNC] Budget report fails in multiple currencies
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 you
Re: [GNC] Budget report fails in multiple currencies
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
Re: [GNC] Budget report fails in multiple currencies
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
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] How to generate Budget V Actual Report for Profit and Loss
On 12/28/22 5:38 AM, David Long wrote: Thanks Adrien for your reply. I have also been trying to produce a report showing this year's P compared with previous. I tried the multi column reports, but the descriptions repeat and the rows do not line up. Reporting Actual V Budget and prior years is pretty standard in an accounting system, and whilst I love GnuCash, it's an area not covered well. The report you are looking for is in Reports > Experimental > Income Statement (multicolumn) In Options > General, set: *Period duration > One Year *Start Date > first day of first year in report, e.g.—1/1/21 *Last Date > last day of last year in report, e.g.—12/31/22 You can control the order of the columns with: *"Period order is most recent first" You can also get a combined overall column and a bar chart. (the chart doesn't yet show up on the report, but as a link to the chart near the top) Sadly, there is no variance column option here. You still need to export to a spreadsheet to make one manually. Should I be asking for an enhancement? It can't hurt, but don't expect action on any timetable. At the least, requesting a variance column for this particular report I think would be useful to see over/under vs. previous period(s). Regards, Adrien ___ 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] How to generate Budget V Actual Report for Profit and Loss
On 12/28/2022 6:38 AM, David Long wrote: Thanks Adrien for your reply. I have also been trying to produce a report showing this year's P compared with previous. I tried the multi column reports, but the descriptions repeat and the rows do not line up. Reporting Actual V Budget and prior years is pretty standard in an accounting system, and whilst I love GnuCash, it's an area not covered well. Should I be asking for an enhancement? Best done outside of gnucash (*) Wearing my old senior business analyst hat (that a s well as senior systems analyst) I will ask you a question (the client will know the answer and understand the issue IF asked the right question. When you say "compare two years' P side by side" do you mean "compare this year's with last years AS LAST YEAR'S WAS DONE (the "published"data" or do you mean "compare this year's with a rerun last year's so changes in the CoA won't exist and things will line up properly."(but this new "last year's" will NOT necessarily match the original "last year's" when that last year's was the then "this year's") OK, assume that every year you run a YE P report and export it. OR you could just have saved in gnucash). You want a "something" that could be told to take two of these and from them produce that side by side comparison report. Isn't that easier to do with two exported reports and your favorite editor rather than asking for an editing program to be written. And no big deal to add to it "and allow me to annotate an unusual amount" or "add fixed text and company logo to top", etc. etc. etc. If a program doing the editing you need to request an enhancement each time. And how to deal with the fact that in b=general will NOT "line up" perfectly because the CoA and have changed a bit since the previous year and a human decision how to handle needed for each mismatch. Michael D Novack (*) How I was told to do it by an experienced accountant on the board in spite of the fact that I was a retired professional fluent in many computer languages including LISP (SCHEME is a LISP dialect) ___ 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] How to generate Budget V Actual Report for Profit and Loss
Thanks Adrien for your reply. I have also been trying to produce a report showing this year's P compared with previous. I tried the multi column reports, but the descriptions repeat and the rows do not line up. Reporting Actual V Budget and prior years is pretty standard in an accounting system, and whilst I love GnuCash, it's an area not covered well. Should I be asking for an enhancement? regards David Message: 8 Date: Tue, 27 Dec 2022 20:34:12 -0600 From: Adrien Monteleone To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] How to generate Budget V Actual Report for Profit and Loss Message-ID: Content-Type: text/plain; charset=UTF-8; format=flowed You are correct. The current work-around is to finish off in a spreadhseet to add the missing Net Income calculation. Adding the Actual (and Variance) to the Budget Income/P version would be nice. (percentages would be awesome too!) I'm not sure that it is necessary for the basic Budget Report as that can also show other types of accounts and in such context, a Net Income might not be useful or meaningful. Regards, Adrien On 12/23/22 1:51 PM, davidvernonl...@gmail.com wrote: > I am trying to report an income statement showing actual against budget. > > If I select an Income Statement report or a Profit and Loss statement > report I see the actuals for the period , but not the budget. > > If I select Budget Income Statement Report or Budget Profit and Loss > statement report I see the budget but no actuals. > > If I select " budget Report" and then under "options" I select only > the Income and expense reports, then I see both budges and actuals, > the Total Expenses and the Total Income, but I cannot find a way of > see the net income/loss Total on that report ( being total income less expenses). > > At the moment my workaround is to copy paste to Excel ___ 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] How to generate Budget V Actual Report for Profit and Loss
You are correct. The current work-around is to finish off in a spreadhseet to add the missing Net Income calculation. Adding the Actual (and Variance) to the Budget Income/P version would be nice. (percentages would be awesome too!) I'm not sure that it is necessary for the basic Budget Report as that can also show other types of accounts and in such context, a Net Income might not be useful or meaningful. Regards, Adrien On 12/23/22 1:51 PM, davidvernonl...@gmail.com wrote: I am trying to report an income statement showing actual against budget. If I select an Income Statement report or a Profit and Loss statement report I see the actuals for the period , but not the budget. If I select Budget Income Statement Report or Budget Profit and Loss statement report I see the budget but no actuals. If I select " budget Report" and then under "options" I select only the Income and expense reports, then I see both budges and actuals, the Total Expenses and the Total Income, but I cannot find a way of see the net income/loss Total on that report ( being total income less expenses). At the moment my workaround is to copy paste to Excel ___ 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] How to generate Budget V Actual Report for Profit and Loss
I am trying to report an income statement showing actual against budget. If I select an Income Statement report or a Profit and Loss statement report I see the actuals for the period , but not the budget. If I select Budget Income Statement Report or Budget Profit and Loss statement report I see the budget but no actuals. If I select " budget Report" and then under "options" I select only the Income and expense reports, then I see both budges and actuals, the Total Expenses and the Total Income, but I cannot find a way of see the net income/loss Total on that report ( being total income less expenses). At the moment my workaround is to copy paste to Excel How to do? Thanks David Long ___ 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] Creating/Modifying a Budget Report
Abe, please remember to reply-all or reply-list that way others can benefit from the conversation, and may be able to help where I can't. - You should be able to edit everything in a spreadsheet app with ease. Every report is just an HTML table, so it has cells with labels and data which map *mostly* nicely to columns and rows in a spreadsheet. If you're having import issues, try just saving the report and opening it with your spreadsheet app of choice. (Libreoffice and relatives are known to work well, and some people say Excel works fine too.) Of course, a Select-All/Copy/Paste works fine too. Some methods carry over formatting, and others let you easily copy over plain text. The Title Extension is just the name of your budget. You can just select that cell and edit as needed. (or rename your budget to something you'd prefer as a title extension) I'm sure a crafty spreadsheet text formula can find the ":" separator in the title and then replace the text after it. If you haven't yet played around with spreadsheet formulas affecting text, logic, or 'information' about the sheet/cell, I encourage you to do so. There is lots of power there which might meet your needs, or at least some of them. And those skills are useful for many things other than GnuCash of course. - The Totals column is entirely independent of the Report Title parts, so not sure what issue you are having. - As for scripting/macros, macros are usually something used in a spreadsheet app to automate stuff, like formatting, or adding in formulas, etc. You'd have to investigate your preferred app as to how they work, and where they might be useful to you. Scripting is usually done to process a file outside of an 'app'. For example, if using Linux or Mac, you can use 'shell' scripting using 'sed' or 'awk' (among others) to edit the resulting HTML file that you export/save from GnuCash. This could do things like search and replace titles, column headings, etc. Other options are Python & Perl. Windows can also use some of these, but I'm not sure which. Then you can either open the resulting edited file manually or as part of the script in a spreadsheet for further processing. (applying 'styles' for instance) Or you can open the file in your browser of choice, and either view, print, or 'save to PDF'. Part of your scripting can handle CSS changes to the Report file beyond perhaps what works withing the CSS Stylesheet in GnuCash. (Technically, GnuCash uses Webkit rendering engine, same as used in Safari, to display reports, but not all useful parts of a report are easily stylable via CSS there.) Your script could insert CSS ID's, Classes, or otherwise add styling or even entire HTML elements to be styled as part of your 'text processing'. (HTML files are 'plain text' in a Markup language) Getting the CSS right will allow you a 'pretty' version of the report for viewing/printing in a browser. On that note, see my other reply about CSS basics. If you're going to get to this level of customization, you should be aware of these things and how to manipulate them. For starters, open the exported/saved report in a text editor. Start learning HTML. (the basics, plus tables) Any scripting will need to be able to edit HTML properly. - There are also automation tools in the wild that can assist with all or part of anything you find yourself manually having to change or do often. Some can even record mouse movements and 'replay' them! (the link to such an app has been posted on this list before, but I seem to have misplaced it. You might find it in a well crafted search.) *note, I'd advise to play with the report Options and Stylesheets from *within* GnuCash to get as close as you can to your desired end goal. That will save you lots of work outside of GnuCash to get it looking like you want. - You'll still have to learn new things to accomplish this task, but it doesn't have to be Scheme! (no hate on Scheme, it just isn't the easiest thing to tackle) Regards, Adrien On Oct 10, 2022 w42d283, at 4:17 PM, Abe Sternberg wrote: Love your response. I had tried exporting to a spreadsheet, but didn't get anything I knew how to play with. I had experimented with the title, but couldn't get rid of your title extension if I wanted the "accumulated" totals. Could you go into a little more detail for option #3 Scripting and Macros? The scripting and/or macro is done in the spreadsheet and not in GnuCash, correct? ___ 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] Creating/Modifying a Budget Report
I forgot to add, if you go the CSS route (or use CSS customizations before going to a spreadsheet) you'll want to focus on learning the basics of headings, fonts, colors, and tables. That should be sufficient for working with GnuCash reports. (there might be a few others, but this will get you well on your way) Regards, Adrien ___ 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] Creating/Modifying a Budget Report
While you *could* learn Scheme or Guile and craft our own version, these are presentational details, and can more easily be handled by other means. #1 - Options > General Report name - This allows you to change the report name. Note for this report, the entire displayed name is 'Report Name:Budget Name', so while you can't customize the entire name, you can influence how it reads, somewhat, by editing this field and getting crafty with the name of your budget. (not ideal, I know) Stylesheet - use the CSS (experimental) setting here, this will allow you to adjust things like padding between cells/columns, fonts, colors, table borders, etc. You'll need to learn and play with CSS, but this is much, much simpler for mere mortals than Scheme. There are people on this list (myself included) who 'speak' CSS and can assist if you get stuck. #2 - Export to Spreadsheet The Report is just an HTML table, and you can save it or export it and then open in a spreadsheet app. (or even copy/paste) From there, in addition to presentational effects, you can add in other calculations. (e.g., percentages) #3 - Scripting/Automating/Macros If you want to get fancy, and tire of repeatedly customizing, you can learn some simple scripting or macros (if using a spreadsheet) to handle the remaining adjustments. This can be done on the exported/saved report and then displayed in a browser or spreadsheet for printing if desired. (all reports in GnuCash are HTML based by the way) - As for YTD, the report can do that and it seems you've got the Totals columns turned on already. Play with that and the Budget Range on the General tab to fine tune this to your liking. Also note, the Budget setup is what defines the periods, not the report options. So if you're not seeing what you expect, check your setup. - Finally, if something is missing, or seems like it should be an option for the report within GnuCash, then file a Request For Enhancement (RFE) at bugs.gnucash.org Options from other reports that are missing from the Budget report would be good candidates for, possibly easy, inclusion as they won't require as much work as something brand new. Regards, Adrien On 10/10/22 12:26 PM, Abe Sternberg wrote: I would like to put some space between the columns, change some of the column names, change the report title, and just pretty it up a bit. I have attached a screenshot of my GnuCash's current report. I need both monthly activity and YTD figures. ___ 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] Creating/Modifying a Budget Report
Can you describe the modification? What you want to change might make a difference in the offered possible solutions and ideas. Regards, Adrien On 10/10/22 11:07 AM, Abe Sternberg wrote: I have been using GnuCash for about a year and am not a very sophisticated user. I am the treasurer for a very small non-profit, and the "standard family bank account" approach has worked just fine. Now, I find that I would like to add keeping our budget performance on GnuCash. I have set up the budget, which is working fine, the challenge is that the included budget reports are inadequate, and I would like to change them or create my own. I spent all of yesterday wondering around GnuCash on the I-net and only found references to programming my reports in either Scheme, eguile, or guile. All the preceding are Linux based languages and not Windows. I am not a programmer, and all the descriptions I read just boggled my mind. Can anyone out there shed some light on this, all I want to do is a report modification which should be a built-in for 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.
[GNC] Creating/Modifying a Budget Report
I have been using GnuCash for about a year and am not a very sophisticated user. I am the treasurer for a very small non-profit, and the "standard family bank account" approach has worked just fine. Now, I find that I would like to add keeping our budget performance on GnuCash. I have set up the budget, which is working fine, the challenge is that the included budget reports are inadequate, and I would like to change them or create my own. I spent all of yesterday wondering around GnuCash on the I-net and only found references to programming my reports in either Scheme, eguile, or guile. All the preceding are Linux based languages and not Windows. I am not a programmer, and all the descriptions I read just boggled my mind. Can anyone out there shed some light on this, all I want to do is a report modification which should be a built-in for GnuCash? Thanks, Abe ___ 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 Reporting
On 5/7/22 8:39 AM, iwaddo via gnucash-user wrote: I’m new to gnucash so please let me know if this is not the correct way to get support. This is *one* of the right places. IRC is another option. I have successfully entered all my transactions back to Oct 21, everything balances as I expect. I created a budget to cover the period Oct 21 through to Sept 22. I am however struggling to get a report to show me my likely closing balance based on the differences between my forecast and actual income and outgoings. Hopefully this question make sense. Almost. What exactly do you mean by 'likely closing balance'? Closing Balance of 'what', the entire book? or just say, your Checking Account? There is no overall 'closing balance' save perhaps a Net Worth calculation. (the result of the full Accounting Equation) Budget reports can show you the budgeted amount, actual amount, difference, and do this by period with a yearly or even year-to-date 'grand total' if you like. (or even running totals rather then individual periods) But this report is 'by-account', and does not show an 'overall closing balance'. (whatever that means) Regards, Adrien ___ 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 Reporting
I’m new to gnucash so please let me know if this is not the correct way to get support. I have successfully entered all my transactions back to Oct 21, everything balances as I expect. I created a budget to cover the period Oct 21 through to Sept 22. I am however struggling to get a report to show me my likely closing balance based on the differences between my forecast and actual income and outgoings. Hopefully this question make sense. Thank you for your help. Regards ___ 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 calculation possible bug
Please file a bug report on Bugzilla? On Mon, 17 Jan 2022, 5:42 pm Peter Jackson, wrote: > I am using the Budget routine with Expenses and Income selected, set to > range, manual periods, with 1 selected in both cases. > In the January ie first column only for Income, the Total does not equal > the sum of the components in both the Budget, and Budget report. In fact, > if I enter zero in each income component, the total stays the same. > Regards > Peter > ___ > 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 calculation possible bug
I am using the Budget routine with Expenses and Income selected, set to range, manual periods, with 1 selected in both cases. In the January ie first column only for Income, the Total does not equal the sum of the components in both the Budget, and Budget report. In fact, if I enter zero in each income component, the total stays the same. Regards Peter ___ 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 calculation possible bug
I am using the Budget routine with Expenses and Income selected, set to range, manual periods, with 1 selected in both cases. In the January ie first column only for Income, the Total does not equal the sum of the components in both the Budget, and Budget report. In fact, if I enter zero in each income component, the total stays the same. Regards Peter ___ 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] Editing a Budget - "from this period onwards"
I get that, but that's the best we have at the moment. Your hands don't have to leave the keyboard though, so it isn't terribly slow. Unfortunately, I don't think the Budget screen is implemented as a 'spreadsheet' though it has rows and columns of cells. That is probably why the functionality is not built-in. Regards, Adrien On 12/31/21 8:40 AM, Jim Passmore wrote: Thanks, Adrien, but those functions are only of limited help. All periods (and estimate) can be useful *at the beginning* of a year. I usually copy a budget when starting a new year, then use the "all periods" function to fill December numbers into Jan-Dec of the new year where they have changed from the previous January. However, let's say you get a raise in April. Your budget then changes (e.g., in the US) for your income, federal taxes, state taxes, social security, Medicare. You don't want to overwrite the first 3 months history, which would mess up year-end reporting, so 5 times you have to type the new budget number, then copy to clipboard, followed by 8 reps of mouse click and ctrl-v into May-Dec. That's a total of 5 copy and 40 paste operations. (I also have other withholdings that change with income, such as retirement--that makes the number even larger!) Either a "fill to right" or "copy column" would cut down on the copy/paste. Wish I could offer to help implement this, but I have zero experience with C/C++. ___ 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] Editing a Budget - "from this period onwards"
Thanks, Adrien, but those functions are only of limited help. All periods (and estimate) can be useful *at the beginning* of a year. I usually copy a budget when starting a new year, then use the "all periods" function to fill December numbers into Jan-Dec of the new year where they have changed from the previous January. However, let's say you get a raise in April. Your budget then changes (e.g., in the US) for your income, federal taxes, state taxes, social security, Medicare. You don't want to overwrite the first 3 months history, which would mess up year-end reporting, so 5 times you have to type the new budget number, then copy to clipboard, followed by 8 reps of mouse click and ctrl-v into May-Dec. That's a total of 5 copy and 40 paste operations. (I also have other withholdings that change with income, such as retirement--that makes the number even larger!) Either a "fill to right" or "copy column" would cut down on the copy/paste. Wish I could offer to help implement this, but I have zero experience with C/C++. -- *Jim Passmore* On Mon, Dec 27, 2021 at 6:42 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > There is the function to edit 'all periods' for a particular account at > a time. (on the toolbar, and in the Edit menu) > > Of course this isn't just 'to the right' but for all periods in the budget. > > There is not an easy way I can see to copy an entire period to others. > > And of course there is the 'estimate' feature based on your historical > data, which you can take as-is, or average over the range of periods. > > Regards, > Adrien > > On 12/26/21 9:31 PM, Jim Passmore wrote: > > I would echo the feature request for "fill from selected to the right". > > Another good addition to the budget editor would be the ability to copy > an > > entire period column for all accounts. > > Thanks! > > > > ___ > 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 and scrolling
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] How to copy open budget to spreadsheet
Not sure if you solved this but I see no one has replied. Run a Budget Report. (best to exclude the Actuals and Diff columns) Then copy/paste or save/open the resulting report in your favorite spreadsheet app. Regards, Adrien On 4/17/21 9:32 AM, Morris Beavers wrote: Hello GNUCash, My version is 4.4. My budget is open. No export seems to be available for the budget. After highlighting several rows ctrl-c doesn't seem to copy the highlighted data to the clipboard. I'm trying to get the sum of expense sub-accounts to enter into the "Total Monthly Expense" parent account. I wouldn't expect everyone adds this manually, I must be missing something. I found a 2010 hit that recommended ctrl-c and the clipboard, didn't work for 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 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] Editing a Budget - "from this period onwards"
There is the function to edit 'all periods' for a particular account at a time. (on the toolbar, and in the Edit menu) Of course this isn't just 'to the right' but for all periods in the budget. There is not an easy way I can see to copy an entire period to others. And of course there is the 'estimate' feature based on your historical data, which you can take as-is, or average over the range of periods. Regards, Adrien On 12/26/21 9:31 PM, Jim Passmore wrote: I would echo the feature request for "fill from selected to the right". Another good addition to the budget editor would be the ability to copy an entire period column for all accounts. Thanks! ___ 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] Editing a Budget - "from this period onwards"
I would echo the feature request for "fill from selected to the right". Another good addition to the budget editor would be the ability to copy an entire period column for all accounts. Thanks! -- *Jim Passmore* On Sun, Dec 26, 2021 at 10:45 AM Graham Ward wrote: > You can edit a budget by changing the individual values by period, but is > there a way to edit all future periods from say period 3 - 12 rather than > having to edit each one individually? So ideally I would like to change a > line from "this period forward". > > Thanks. > ___ > 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] Editing a Budget - "from this period onwards"
You can simply tab over and do copy/paste, but otherwise, not that I'm aware of. Regards, Adrien On 12/26/21 9:43 AM, Graham Ward wrote: You can edit a budget by changing the individual values by period, but is there a way to edit all future periods from say period 3 - 12 rather than having to edit each one individually? So ideally I would like to change a line from "this period forward". ___ 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] Editing a Budget - "from this period onwards"
You can edit a budget by changing the individual values by period, but is there a way to edit all future periods from say period 3 - 12 rather than having to edit each one individually? So ideally I would like to change a line from "this period forward". Thanks. ___ 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"
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 <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, 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"
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.
[GNC] Budget Report Liability "Act" VS Liability Report "Delta"
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 ___ 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
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
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
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
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] Tax and Budget Reporting
Hi there I may not have fully understood but you just run a transaction report on your bank accounts (select you bank accounts in Options)? That will give you deposits & withdrawals including tax. If you want to know the totals for specific accounts (eg donations) you can just filter that report by using the account filter in the options box. I hope that helps. Cheers Hop On 6/10/21 23:14, GnuCash Charity User wrote: Sorry if I wasn't clear, don't need to budget for taxes themselves, but taxes included in line X. So if I budget $150, that's including tax paid, hence want ability to report combined. On Wed, 6 Oct 2021 at 01:32, flywire [1] wrote: Your reports show Expense:X and Asset:Tax Collected (but not reimbursed). Why do you want to budget for tax if it is reimbursed with a net cost of zero? ___ gnucash-user mailing list [2]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [4]https://wiki.gnucash.org/wiki/Ma iling_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. References 1. mailto:flywi...@gmail.com 2. mailto:gnucash-user@gnucash.org 3. https://lists.gnucash.org/mailman/listinfo/gnucash-user 4. https://wiki.gnucash.org/wiki/Mailing_Lists ___ 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] Tax and Budget Reporting
Sorry if I wasn't clear, don't need to budget for taxes themselves, but taxes included in line X. So if I budget $150, that's including tax paid, hence want ability to report combined. On Wed, 6 Oct 2021 at 01:32, flywire wrote: > Your reports show Expense:X and Asset:Tax Collected (but not reimbursed). > Why do you want to budget for tax if it is reimbursed with a net cost of > zero? > ___ 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] Tax and Budget Reporting
Your reports show Expense:X and Asset:Tax Collected (but not reimbursed). Why do you want to budget for tax if it is reimbursed with a net cost of zero? ___ 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] Tax and Budget Reporting
Hi, My apologies if this has been asked in the past, haven't been able to find in the archives. We have had a great experience breaking out our tax spending from regular spending, given as a charity we receive rebates on our tax costs. However, a challenge is in our budgeting and reporting. Previously, we included taxes and the actual spend in budgeting and reporting in the same line item. Now it it is in separate lines. For example, previously we would budget/report we spent $113 on line X - $100 for the item itself, $13 in taxes (I'm in Canada). It's helpful showing the $13 spent in taxes, but on the majority of reports, I want to show $113 was spent on line X, particularly on budget reports. Anyone know how to make this happen? Thanks! ___ 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
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
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
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
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.
[GNC] How to copy open budget to spreadsheet
Hello GNUCash, My version is 4.4. My budget is open. No export seems to be available for the budget. After highlighting several rows ctrl-c doesn't seem to copy the highlighted data to the clipboard. I'm trying to get the sum of expense sub-accounts to enter into the "Total Monthly Expense" parent account. I wouldn't expect everyone adds this manually, I must be missing something. I found a 2010 hit that recommended ctrl-c and the clipboard, didn't work for me. Thanks, Morris ___ 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 screen Grand Total
Many thanks Chris. Sent from my iPhone > On 15 Nov 2020, at 13:28, Christopher Lam wrote: > > > You'll need to upgrade to 4.2 -- see the flatpak releases. > >> On Sun, 15 Nov 2020, 9:54 am Andrew, wrote: >> Hi All >> >> I have just rolled from Ubuntu 18.04 to 20.04 and note a difference in >> the GNUCash app versions making it more difficult to for me to manage my >> expenses. >> >> Current Ubuntu 20 GNU Cash Version >> >> Version: 3.8 >> Build ID: 3.8b+(2019-12-29) >> Finance::Quote: 1.49 >> >> Version under Ubuntu 18 >> >> Version 2.6.19 >> >> In previous version there was a total line at the very bottom of the >> budget screen that allowed me to see which months were over/under spent >> allowing me to forecast future issues in my cash flow. Is there a way to >> turn this back on in settings or can it be reintroduced. I am a 60 year >> old creature of habit and I have had to reinstall Ubuntu 18 alongside >> 20 just to use older version of GNU Cash which served my purpose. >> >> The Income/Expenses/Liabilities used to be grand totaled at the very >> bottom and updated on live updates of the budget above . Now it does not. >> >> Many thanks in anticipation of a reply. >> >> >> Cheers >> >> Andrew >> >> ___ >> 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 screen Grand Total
You'll need to upgrade to 4.2 -- see the flatpak releases. On Sun, 15 Nov 2020, 9:54 am Andrew, wrote: > Hi All > > I have just rolled from Ubuntu 18.04 to 20.04 and note a difference in > the GNUCash app versions making it more difficult to for me to manage my > expenses. > > Current Ubuntu 20 GNU Cash Version > > Version: 3.8 > Build ID: 3.8b+(2019-12-29) > Finance::Quote: 1.49 > > Version under Ubuntu 18 > > Version 2.6.19 > > In previous version there was a total line at the very bottom of the > budget screen that allowed me to see which months were over/under spent > allowing me to forecast future issues in my cash flow. Is there a way to > turn this back on in settings or can it be reintroduced. I am a 60 year > old creature of habit and I have had to reinstall Ubuntu 18 alongside > 20 just to use older version of GNU Cash which served my purpose. > > The Income/Expenses/Liabilities used to be grand totaled at the very > bottom and updated on live updates of the budget above . Now it does not. > > Many thanks in anticipation of a reply. > > > Cheers > > Andrew > > ___ > 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 screen Grand Total
Hi All I have just rolled from Ubuntu 18.04 to 20.04 and note a difference in the GNUCash app versions making it more difficult to for me to manage my expenses. Current Ubuntu 20 GNU Cash Version Version: 3.8 Build ID: 3.8b+(2019-12-29) Finance::Quote: 1.49 Version under Ubuntu 18 Version 2.6.19 In previous version there was a total line at the very bottom of the budget screen that allowed me to see which months were over/under spent allowing me to forecast future issues in my cash flow. Is there a way to turn this back on in settings or can it be reintroduced. I am a 60 year old creature of habit and I have had to reinstall Ubuntu 18 alongside 20 just to use older version of GNU Cash which served my purpose. The Income/Expenses/Liabilities used to be grand totaled at the very bottom and updated on live updates of the budget above . Now it does not. Many thanks in anticipation of a reply. Cheers Andrew ___ 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 Calculations
Yes. To reset the ability to roll-up the child amounts, select the parent amount and delete it. Leave nothing in that cell. (it will probably show a gray '0.00' or if there are child amounts already assigned, their total instead) Regards, Adrien On 7/20/20 4:31 PM, Jon Griffith wrote: Got it. I will test it out and see if I can't figure it out. If you were to modify the parent account manually, would you permanently break its ability to calculate the child accounts? Seems parent accounts should be locked so you can't manipulate them. ___ 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 Calculations
Got it. I will test it out and see if I can't figure it out. If you were to modify the parent account manually, would you permanently break its ability to calculate the child accounts? Seems parent accounts should be locked so you can't manipulate them. On Mon, Jul 20, 2020 at 1:51 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I'm not 100% clear on what you are trying to change, but here's how the > Budget Module works: > > You can set child amounts. Those will automatically roll up to the parent. > > If you set anything at all for the parent, even 0.00, then that is what > you will get. It then ignores the child accounts as least as far as the > parent is concerned. > > This allows you to budget a different amount for the parent than the sum > of its children. > > But in both cases, any amount entered should be reflected in the totals > in the summary section. If not, (and I'm understanding you correctly) > you've found a bug, please report it on Bugzilla. > > Regards, > Adrien > > On 7/20/20 2:01 PM, Jon Griffith wrote: > > Trying to wrap my head around something. > > > > The totals calculated on top level accounts are a cumulative sum of it's > > sub accounts *and* any transactions *in* the top level account, assuming > it > > can have transactions. > > > > There are instances where if I manually change a budget amount, it does > not > > affect any of the balances of it's parent account nor the totals at the > > bottom. Is this a bug, or intended behavior? > > > > ___ > 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. > -- [image: photo] *Jon Griffith* REALTOR®, HomeSmart 480-463-4062 | j...@jongriffith.com http://realtor.jongriffith.com 10601 N. Hayden Road, Suite I-100 | @RealScottsdale <http://facebook.com/realscottsdaleliving> <http://twitter.com/realscottsdale> <http://www.youtube.com/realscottsdaleliving> <http://www.linkedin.com/in/jonathangriffith> Get your own email signature <https://www.wisestamp.com/signature-in-email?utm_source=promotion_medium=signature_campaign=get_your_own=4578964714553344> ___ 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 Calculations
I'm not 100% clear on what you are trying to change, but here's how the Budget Module works: You can set child amounts. Those will automatically roll up to the parent. If you set anything at all for the parent, even 0.00, then that is what you will get. It then ignores the child accounts as least as far as the parent is concerned. This allows you to budget a different amount for the parent than the sum of its children. But in both cases, any amount entered should be reflected in the totals in the summary section. If not, (and I'm understanding you correctly) you've found a bug, please report it on Bugzilla. Regards, Adrien On 7/20/20 2:01 PM, Jon Griffith wrote: Trying to wrap my head around something. The totals calculated on top level accounts are a cumulative sum of it's sub accounts *and* any transactions *in* the top level account, assuming it can have transactions. There are instances where if I manually change a budget amount, it does not affect any of the balances of it's parent account nor the totals at the bottom. Is this a bug, or intended behavior? ___ 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 Calculations
Trying to wrap my head around something. The totals calculated on top level accounts are a cumulative sum of it's sub accounts *and* any transactions *in* the top level account, assuming it can have transactions. There are instances where if I manually change a budget amount, it does not affect any of the balances of it's parent account nor the totals at the bottom. Is this a bug, or intended behavior? -- [image: photo] *Jon Griffith* REALTOR®, HomeSmart 480-463-4062 | j...@jongriffith.com http://realtor.jongriffith.com 10601 N. Hayden Road, Suite I-100 | @RealScottsdale <http://facebook.com/realscottsdaleliving> <http://twitter.com/realscottsdale> <http://www.youtube.com/realscottsdaleliving> <http://www.linkedin.com/in/jonathangriffith> Get your own email signature <https://www.wisestamp.com/signature-in-email?utm_source=promotion_medium=signature_campaign=get_your_own=4578964714553344> ___ 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] Top-Level Account:Expenses not totaling in Budget
You are welcome. If that example of ‘Medical’ is showing zero (without an explicit ‘0.00’ entered by you) and any of the child accounts of ‘visits, meds, and tests’have amounts, then you have found a bug. (though why for some accounts and not others is to be determined.) It *should* roll up those child accounts to give you a total Medical budget. (again, as long as you haven’t entered ‘0.00’ into the Medical parent budget. To be sure, you can select it and hit `delete`) When you have some time, report back here and we can work on it. Regards, Adrien > On Jul 6, 2020 w28d188, at 8:34 PM, Lorrie Laskey wrote: > > Adrian, > > Thank you very much. Without your help, I would have never found the > auto-fill feature. And now the Expenses are showing a cumulative total. > Both were big issues. I was ready to find another program. > > Some child-level accounts are still showing zero values because their > sub-accounts have no values. For example, Medical has no entries for > doctor's visits, meds, and tests, but I can live with seeing zero. > > Now I can move on to finishing my budget. You are a life saver. Thanks. > > Lorrie ___ 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] Top-Level Account:Expenses not totaling in Budget
Adrian, Thank you very much. Without your help, I would have never found the auto-fill feature. And now the Expenses are showing a cumulative total. Both were big issues. I was ready to find another program. Some child-level accounts are still showing zero values because their sub-accounts have no values. For example, Medical has no entries for doctor's visits, meds, and tests, but I can live with seeing zero. Now I can move on to finishing my budget. You are a life saver. Thanks. Lorrie On Mon, Jul 6, 2020 at 3:13 PM wrote: > Send gnucash-user mailing list submissions to > gnucash-user@gnucash.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.gnucash.org/mailman/listinfo/gnucash-user > or, via email, send a message with subject or body 'help' to > gnucash-user-requ...@gnucash.org > > You can reach the person managing the list at > gnucash-user-ow...@gnucash.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of gnucash-user digest..." > Today's Topics: > >1. Re: OFX setup (John Ralls) >2. Re: OFX setup (Fleur Dragan) >3. Re: Gnucash-User (Stan Brown) >4. Re: Top-Level Account:Expenses not totaling in Budget > (Adrien Monteleone) >5. Re: Top-Level Account:Expenses not totaling in Budget > (Adrien Monteleone) >6. Re: Help required (Adrien Monteleone) >7. Re: Gnucash-User (Don Ireland) >8. Re: Gnucash-User (David T.) >9. Re: Gnucash-User (Adrien Monteleone) > 10. Re: Gnucash-User (David Cousens) > > > > -- Forwarded message -- > From: John Ralls > To: Fleur Dragan > Cc: gnucash-user@gnucash.org > Bcc: > Date: Mon, 6 Jul 2020 09:09:42 -0700 > Subject: Re: [GNC] OFX setup > Unfortunately the stderr/stdout capture didn't make it through the list. > You may send them directly to me if you like, but please first go through > them and remove any identifying information, especially the bank routing > id, account numbers, and any PINs or passwords. > > All that you need for an OFX account setup is the Routing ID and Account > number. The former goes in the Bank Code field, the latter in the Account > Number field. Both should have been in the log window output; you can edit > the user and retrieve accounts again if you need to. The Bank and Account > names are used to identify the account in the UI so you can enter whatever > you like. The other fields are for HBCI/FinTS and can safely be left blank. > > Regards, > John Ralls > > > > On Jul 6, 2020, at 4:33 AM, Fleur Dragan wrote: > > > > > > First I set: > > > > export GWEN_LOGLEVEL=debug > > export AQBANKING_LOGLEVEL=debug > > export AQOFX_LOG_COMM=1 > > export AQOFXCONNECT_LOGLEVEL=debug > > > > > > Then I ran, just to be safe: > > > > rm -rf ~/.aqbanking/ > > > > > > Then I ran: > > > > /Applications/Gnucash.app/Contents/MacOS/Gnucash --debug 2>&1 | tee > gnc.out > > > > > > Once GnuCash started up, I tried to set up a user, which was > successful. Then I tried to retrieve accounts, which was also successful, > but no accounts were created in the aqbanking window. I tried to create an > account, but it's not clear what information each field wants, especially > since it's designed to be country agnostic. Is BIC SWIFT the routing > number for my US account? Is country "US" or "United States" or something > else? Bank Name? The one in www.ofxhome.com? The one on their > website? Can't get much more ambiguous than bank name. The look up bank > code doesn't appear to do anything, so I have no idea if the bank code is > the OFX FI, the routing number, or something else. There are enough > ambiguous fields, trying various combinations is prohibitive. If there is > documentation, in English (google translate will not understand subtleties > of BIC/IBAN/SWIFT/routing number), for setting up OFX accounts, I will > happily try again. > > > > There were no errors in /tmp/ofx.log. > > > > There don't seem to be any errors in the output, and nothing was in the > trace file, so I guess I read how to turn that on wrong. I've attached the > stdout/stderr output. Will the trace be helpful? If so, I'll go back and > to that. What else have I missed? > > > > > > > > thanks, > > fleur > > -- > > Fleur Dragan / fl...@obscure.org > > > > > > > > > >> On Jul 5, 2020, at 1:14 AM, Frank H. Ellenberger < > frank.h.ellenber...@gmail.com> wrote: > >> > >> Hi, > >> >
Re: [GNC] Top-Level Account:Expenses not totaling in Budget
> On Jul 6, 2020 w28d188, at 8:36 AM, Lorrie Laskey wrote: > > > I tried estimating the expenses and that ignored the rent, entirely, the > largest of my expenses. Please do file a bug report on this. Extensive work has been done on the budget recently and the developer working on it is in need of testing and feedback. Regards, Adrien ___ 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] Top-Level Account:Expenses not totaling in Budget
> On Jul 6, 2020 w28d188, at 8:36 AM, Lorrie Laskey wrote: > > > 1. How do I get a total monthly expense value for all expenses? That should be in the summary at the bottom as well as in the parent account ‘Expenses’ line in the budget itself. *note — do not enter a value into a parent account cell that you want to be a ‘roll-up’ sum of its children. Leave it blank and the budget sheet will auto-tally the children and display that as the amount of the parent budget. Otherwise, you get a fixed amount for the parent that you entered. You can’t even have a ‘zero’ there. It must be empty of your own entry. (it may show a gray ‘0.00’ in that case) > 2. Is there not a feature to autofill or drag the monthly values, say > $60 for phone, into all months? Otherwise copy and paste are so error-prone > and time-consuming. Yes, use the ‘All Periods’ button on the toolbar. You can replace an amount, add to an existing figure, or multiply an existing figure by your entry and even choose to round to a significant figure. > 3. How are 1-time payments for a time period handled? Examples are > insurance paid once per six months. That is up to you. Some people budget the one time payment. Some spread it out evenly. For example, I budget the payment of insurance to a pre-paid asset account, then expense it over time. > 4. Can the Column of the budget not be adjusted by inputting a width > value like a column in a spreadsheet? Grabbing and pulling the column is > not exact and the width changes with the browser window width requiring > constant fiddling. Sadly, no. I don’t think any part of GnuCash works that way at this time. The only column I can adjust at all in the Budget is the Account Name. Not sure how you are managing to adjust the others. I thought they would auto-fit the number of digits. > 5. How do I remove specific expenses from the list of expenses under the > Expenses top-level account? I don't want to see expenses listed where I > will have a zero value. View > Filter By... > Other > uncheck `Show zero total accounts` Note, the option to not show ‘unused accounts’ will hide any accounts for which you do not have transactions. There is no way to toggle individual accounts otherwise, but when running the Budget Report, you get another opportunity to exclude them in Options > Accounts as a per-account setting. ---- Finally, be sure to use the latest GnuCash (4.0), the budget module has received several updates over the last year and older versions might not work the same or even have some features missing. (like the 'All Periods’ button, not sure when that was implemented) Regards, Adrien ___ 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] Top-Level Account:Expenses not totaling in Budget
I am creating an income vs expenses budget, inputting my monthly values for July to December 2020. The total cumulative running value for Expenses is not changing as expenses are added to the month of July for all expenses. For example... - $60 - gas - $60 - phone - $1500 - rent - and so on The total monthly expenses should be about $2400 however it is not increasing over the value of say, the rent, ignoring the other monthly expenses. I tried estimating the expenses and that ignored the rent, entirely, the largest of my expenses. Here are my questions but #1 is the most pressing. 1. How do I get a total monthly expense value for all expenses? 2. Is there not a feature to autofill or drag the monthly values, say $60 for phone, into all months? Otherwise copy and paste are so error-prone and time-consuming. 3. How are 1-time payments for a time period handled? Examples are insurance paid once per six months. 4. Can the Column of the budget not be adjusted by inputting a width value like a column in a spreadsheet? Grabbing and pulling the column is not exact and the width changes with the browser window width requiring constant fiddling. 5. How do I remove specific expenses from the list of expenses under the Expenses top-level account? I don't want to see expenses listed where I will have a zero value. Thank you, Lorrie ___ 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
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-userdata=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577sdata=mezyiDl%2F9pRqDQIg1HTO8csplKroFwRZ6eaMNuIMfMc%3Dreserved=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_Listsdata=02%7C01%7C%7Ce942f9688bc8466223cf08d7e219ffbf%7C84df9e7fe9f640afb435%7C1%7C0%7C637226473603933577sdata=vnTKjrgP7%2FSNT8kAYaZ0BZpcjXXmuB7fUazqpRQaDlQ%3Dreserved=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.
