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
- question on possible cleanup of stored ... Jack via KMyMoney-devel
-
