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.
