Re: [GNC] Advance portfolio report between two dates
On 9/4/2023 1:04 PM, Paras Desai wrote: Hello Michael Thanks for your feed back. I fully agree that Dynamic COA can create havoc while comparing two period (dates) financial report. That is the precise reason, I have very precisely structured primary account and secondary sub account so far my work accounts are concern. No one can change without authorisation. No created account to be deleted even if have zero balance and so on. There is a detailed SOP implemented as how to handle COA. I was NOT talking about "unauthorized changes". Nor was I talking about accounts no longer being used. I was talking about things like this: At time A there is an account with name X. The transactions in there almost all fit X with a couple odd ones more fitting a not yet existent Y (but still close enough to put in X). Over the course of the year, a lot more of these Y's, and less close to X. So decided it makes sense to create and account Y, move the few from X that really better fit Y to Y, and from now on use Y for the ones that best belong there. But since X and Y are related, a new parent Z for them to be children of. Or... one of your bank accounts is with bank and so naturally the name of the account reflects that. At some point in the year the bank changes its name to . Do you leave the account name alone? Do you change it to match the new bank name? Mind, you might not see this as much of an issue as I do since I have been mainly keeping books for organizations (I'd not be wanting to present reports to the BoD with the old name, would be sure to be questioned on "why not fixed") I other words, I expect the CoA to be somewhat dynamic. 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.
[GNC] Advance portfolio report between two dates
Hello Michael Thanks for your feed back. I fully agree that Dynamic COA can create havoc while comparing two period (dates) financial report. That is the precise reason, I have very precisely structured primary account and secondary sub account so far my work accounts are concern. No one can change without authorisation. No created account to be deleted even if have zero balance and so on. There is a detailed SOP implemented as how to handle COA. Having said that, i would believe that certain reports does not have much value if they are not compared. For example, balance sheet - it reflects balances. It will be one of the most important comparison for example, as how much account payable has increased between two period and stuff. Even if I have to make indirect cashflow statement, i need balance sheets between two dates to calculate increase / decrease in working capital and its effect on operating cash flow. Unfortunately, out of habit, i try to mimic such things from my personal finance too, which I know is over kill. And i must understand the limitations. But as they say old habit die hard. I have been trying to adopt GNU Cash fully, though I started using it since last few months only. My idea was to look no further, if I can get most of the things from GC. Thanks again for your time in addressing my question. With best regards Paras ___ 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] Advance portfolio report between two dates
If you look at any of the reports with the word Chart in their name you will find that they chart values over time, which is what you want. You get a pretty chart as a bonus. Depending on your account structure it may be easy or not to include the accounts that you want. On Sun, Sep 3, 2023 at 2:34 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > On 9/3/2023 2:43 PM, Paras Desai wrote: > > Hi Ken > > > > Thanks for your kind reply and efforts in explaining a way. > > > > Apparently, it appears that there is no alternative but to run reports > on two dates and compare or do some analysis. > > > > Any reports comparing two period is a desirable thing in finance and > accounting, may it be personal accounting. > > > > Thanks > > > > Paras > > You are quite correct, comparing two periods is desirable. > > What perhaps is confusing you is "a report" vs "comparing two runs of > that report". Yes of course, there COULD be a report Y that compared two > X reports. But there are some good reasons where that might best be done > "outside". There might quite possibly be the need for some human > decision making. I'll give a different report as an example (but one > where "as of date A" is commonly compared to "as of date B") > > Consider the Balance Sheet report. We are suggesting that to produce a > report comparing "as of date A" with "as of date B" you rut the two > reports, export, bring into a spreadsheet or something else you can > edit, and there produce the final report. Why? Why not an automatically > generated report? Well IF there is a one to one correspondence of > accounts "as of date A" vs "as of date B" this would be simple << you > can imagine a new report in gnucash called "Compare Balance Sheets" to > which you would supply two dates >> But what if the CoA "as of date A" > does NOT correspond 1:1 to the CoA "as of date B"? Accounts could have > been added, accounts could have been deleted, accounts could have > changed names, etc. You expect a computer (even with a pretty good AI > application) to be able to figure out what has happened and to line > things up properly? > > Situation 1:Account A present at date 1, absent at date 2, while > account B present at date 2 not present at date 2. > > Situation 2: No actual change except account A was renamed account B > > As a human bookkeeper, you know which happened (hopefully you remember) > > 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] Advance portfolio report between two dates
On 9/3/2023 2:43 PM, Paras Desai wrote: Hi Ken Thanks for your kind reply and efforts in explaining a way. Apparently, it appears that there is no alternative but to run reports on two dates and compare or do some analysis. Any reports comparing two period is a desirable thing in finance and accounting, may it be personal accounting. Thanks Paras You are quite correct, comparing two periods is desirable. What perhaps is confusing you is "a report" vs "comparing two runs of that report". Yes of course, there COULD be a report Y that compared two X reports. But there are some good reasons where that might best be done "outside". There might quite possibly be the need for some human decision making. I'll give a different report as an example (but one where "as of date A" is commonly compared to "as of date B") Consider the Balance Sheet report. We are suggesting that to produce a report comparing "as of date A" with "as of date B" you rut the two reports, export, bring into a spreadsheet or something else you can edit, and there produce the final report. Why? Why not an automatically generated report? Well IF there is a one to one correspondence of accounts "as of date A" vs "as of date B" this would be simple << you can imagine a new report in gnucash called "Compare Balance Sheets" to which you would supply two dates >> But what if the CoA "as of date A" does NOT correspond 1:1 to the CoA "as of date B"? Accounts could have been added, accounts could have been deleted, accounts could have changed names, etc. You expect a computer (even with a pretty good AI application) to be able to figure out what has happened and to line things up properly? Situation 1: Account A present at date 1, absent at date 2, while account B present at date 2 not present at date 2. Situation 2: No actual change except account A was renamed account B As a human bookkeeper, you know which happened (hopefully you remember) 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.
[GNC] Advance portfolio report between two dates
Hi Ken Thanks for your kind reply and efforts in explaining a way. Apparently, it appears that there is no alternative but to run reports on two dates and compare or do some analysis. Any reports comparing two period is a desirable thing in finance and accounting, may it be personal accounting. Thanks Paras ___ 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] Advance portfolio report between two dates
That doesn't seem to be something the Advanced Portfolio report is made to do. It is meant to provide a snapshot of things at a particular point in time, based upon the cost/earnings/increase in value of investments. I think, if I wanted to do this, I'd approach it thus, unless someone else has an easier way: (1) Set the ending date of the report to the start date of the timespan of interest. (2) Export the report for the start date. (3) Set the ending date of the report to the ending date of the timespan. (4) Export the report for the ending date. (5) Use a text editor or any other means you might have of editing an HTML file, to "convert" the HTML code to a format that is acceptable for a spreadsheet program. Probably CSV or something like that. Do this for both files. (6) Read the two files into a spreadsheet program, then do whatever you like with the data. It's not an elegant one-button approach, but it will get you the info you need. Again that's my "first guess" as to a method. Maybe someone more conversant in such activities will provide a more efficient method. ___ 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] Advance portfolio report between two dates
Hello friends Greetings. I wish to understand, if I can run advance portfolio report between two dates. The needs arises from the fact that I wish to monitor, as how my investment is doing between two dates (for example between August 1, 2023 and August 31, 2023) I tried to select dates in General options, but it shows report till date or till period, but does not show from date. Thanking you Paras ___ 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.
