[GNC] Advance portfolio report between two dates

Michael or Penny Novack stepbystepfarm at comcast.net
Sun Sep 3 15:33:52 EDT 2023


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



More information about the gnucash-user mailing list