question on possible cleanup of stored (redundant) reconciation data

[Jack]

I'm currently working on my monthly reconciliation of most of my  
investment accounts, and have found a potential for inconsistent (and  
very confusing) data.

Reconciliation data is stored in three separate places within an  
<ACCOUNT ......> entity.

First, within the <ACCOUNT .....> tag itself, there is a  
"lastreconciled='yyyy-mm-dd'" attribute.
Second, the <RECONCILIATIONS ...> entity within the account contains a  
<RECONCILIATION ...> tag with date and value for each reconcilation.
Finally, in the <KEYVAULUEPAIRS ....> for the account, there is a <PAIR  
key="reconciliationHistory" ...> tag where the value is a semicolon  
separated list of all the reconciliation date:value pairs for the  
account.

It seems to me the second and third types are completely redundant, and  
wonder if one of them should be removed.

The third one can easily be found by using the last entry in either of  
the other two lists, so I wonder if it should also be removed as  
redundant.

---

Irrelevant FYI as to why I went digging into this: when I reconcile an  
Investment Account (after reconciling its associated Brokerage account,  
I start by confirming the number of shares held of all securites in  
that account.  For some reason, when I do this, that account closes in  
the ledger, and I am left in the Brokerage account ledger.  On rare  
occasion, I don't notice, and rush through the reconciiation wizard -  
which then runs on the Brokerage account for today.  Normally, I do  
notice this, so can either cancel that reconciliation, or undo the last  
action, if I complete the reconciliation.  Today, I did not notice, and  
was halfway through reconciling the next account before I noticed.  I  
therefore went to remove the extraneous reconciliation by manually  
editing the xml file.  That led me to all the above.

At some future time (probably not until we get to the revision of the  
whole investment handling by KMM) I will include a way to remove old  
reconciliation entries from the list.  I know it's not really  
necessary, as the amount of "extra" data is small, but I would prefer  
to be able to clean up those lists, for example removing all except the  
end of year reconciliation for more than two or three years ago.

Jack