Re: [GNC] Balance Sheet and Win Loose Statement
I believe one can set the date for the balance sheet using options, and that would be how I handled that. I'd assume that getting these numbers for past years (say, for 2010) would be a one time process, assuming that your 2010 books wouldn't change any more, once they are complete. Once derived, they could be written down, printed, or otherwise captured in final form for future reference, so I don't see why you're looking to introduce a new level of complexity to the process. As for your ideas about python functions, I don't work with gnucash at that level, so I'll let someone else try and answer whether such functions exist (but I doubt they do). David T. Original Message From: Silvio Siefke Sent: Sun Jul 25 11:54:47 EDT 2021 To: gnucash-user@gnucash.org Subject: Re: [GNC] Balance Sheet and Win Loose Statement Hi, > Perhaps you might explain further what precisely you're trying to do, and > why. If I wanted to see the data in a Balance Sheet or a Profit & Loss > Statement, I'd just run those reports from the menu. Further, if I needed to > manipulate the information more, I'd probably copy and paste the contents > into a spreadsheet and work on that. Why use python at all? Now I go to Reports > Balance Sheet and see the Balance after give the year. But I want make some statistics and its hard ever change the year. Assets + Liabilities are the same sum so this sum is what I need. * https://en.wikipedia.org/wiki/Balance_sheet Same for Income statement only need NET INCOME thats all. * https://en.wikipedia.org/wiki/Income_statement I have read gnucash work with python maybe there is libary where can do like: ./python_gnucash 2010 "Balance Sheet Sum" ./python_gnucash 2010 "Income statement NET INCOME" So is my idea would make easier, when can handle the complete Income Statement / Balance Sheet is great but at end only need the sum! Regards & Thank you Silvio ___ 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] Balance Sheet and Win Loose Statement
Hi, On Sun, July 25, 2021 11:54 am, Silvio Siefke wrote: > Hi, > >> Perhaps you might explain further what precisely you're trying to do, >> and why. If I wanted to see the data in a Balance Sheet or a Profit & >> Loss Statement, I'd just run those reports from the menu. Further, if I >> needed to manipulate the information more, I'd probably copy and paste >> the contents into a spreadsheet and work on that. Why use python at all? > > Now I go to Reports > Balance Sheet and see the Balance after give the > year. But I want make some statistics and its hard ever change the year. Why do you say that? Open the report options, go to the General tab, and select the report date. Then click Apply (to rerun the report and keep the options window open), or Ok (to close the options window and rerun the report). > Assets + Liabilities are the same sum so this sum is what I need. > * https://en.wikipedia.org/wiki/Balance_sheet > > Same for Income statement only need NET INCOME thats all. > * https://en.wikipedia.org/wiki/Income_statement So run the report and copy out the balance. Why make this more difficult than it has to be; the tools currently exist, use them. > I have read gnucash work with python maybe there is libary where > can do like: > > ./python_gnucash 2010 "Balance Sheet Sum" > ./python_gnucash 2010 "Income statement NET INCOME" Nope, this does not exist. > So is my idea would make easier, when can handle the complete > Income Statement / Balance Sheet is great but at end only need the sum! I don't understand why you only need the sum. But you can run the report and copy it out, which IMHO is much easier than trying to rebuild the report in another language just to get the sum. > Regards & Thank you > Silvio > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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] Balance Sheet and Win Loose Statement
Hi, > Perhaps you might explain further what precisely you're trying to do, and > why. If I wanted to see the data in a Balance Sheet or a Profit & Loss > Statement, I'd just run those reports from the menu. Further, if I needed to > manipulate the information more, I'd probably copy and paste the contents > into a spreadsheet and work on that. Why use python at all? Now I go to Reports > Balance Sheet and see the Balance after give the year. But I want make some statistics and its hard ever change the year. Assets + Liabilities are the same sum so this sum is what I need. * https://en.wikipedia.org/wiki/Balance_sheet Same for Income statement only need NET INCOME thats all. * https://en.wikipedia.org/wiki/Income_statement I have read gnucash work with python maybe there is libary where can do like: ./python_gnucash 2010 "Balance Sheet Sum" ./python_gnucash 2010 "Income statement NET INCOME" So is my idea would make easier, when can handle the complete Income Statement / Balance Sheet is great but at end only need the sum! Regards & Thank you Silvio pgpL7ZYzHohq_.pgp Description: PGP signature ___ 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] Balance Sheet and Win Loose Statement
Silvio, Perhaps you might explain further what precisely you're trying to do, and why. If I wanted to see the data in a Balance Sheet or a Profit & Loss Statement, I'd just run those reports from the menu. Further, if I needed to manipulate the information more, I'd probably copy and paste the contents into a spreadsheet and work on that. Why use python at all? Best, David T. Original Message From: Silvio Siefke Sent: Sun Jul 25 07:29:08 EDT 2021 To: gnucash-user@gnucash.org Subject: [GNC] Balance Sheet and Win Loose Statement Hello, is there a way with python to ask Gnucash (MySql) for the values of Balance Sheet and Win Loose Statement? I had take a look on github but be not sure what is right, most of the scripts use xml file of GnuCash. Thanks for help. Silvio ___ 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] Balance Sheet and Win Loose Statement
Hello, is there a way with python to ask Gnucash (MySql) for the values of Balance Sheet and Win Loose Statement? I had take a look on github but be not sure what is right, most of the scripts use xml file of GnuCash. Thanks for help. Silvio pgp8hK9HSwPDX.pgp Description: PGP signature ___ 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.