Thanks Jim,
It seems there was some work done recently to bring some of this about,
but it is shelved for now pending other improvements.
In the meantime, the Reconciliation Report does show the reconcile-date
for each split, so I suppose I could take an Account Report and meld the
two together in a spreadsheet. I don't see that the ending balance
reconciled against is recorded, but some working backwards might produce
a good guess.
I'm now in the process of altering my Notes accordingly as best I can
figure the original data.
Note, I'm not sure if this topic is covered in the docs (I haven't
looked yet) but apparently, if you re-reconcile after making an edit,
you should do so with the original ending statement date and amount. For
Cash accounts, unless one records this info, it is lost to the ether.
(the ending balance is lost; the date can be gleaned as you say
directly, or running the Reconciliation Report *before* editing the
transaction)
Thankfully, changes were made to not be so trigger happy on flipping the
reconcile flag so this should be less important after I trudge through
the current mess I have. (many old transactions with more recent
reconcile-date!)
Regards,
Adrien
On 1/7/21 4:38 PM, Jim DeLaHunt wrote:
Adrien:
Interesting question!
On 2021-01-07 13:59, Adrien Monteleone wrote:
I have a couple of cash accounts that I reconcile on a non-regular
basis.…
I noticed some of my more recent balancing entries contain a Note of
what the cash-on-hand 'ending' balance was at the time. Further
examination of the relevant accounts, shows the balance no longer at
that amount as of that balancing transaction. (meaning I've entered
missing transactions somewhere or made other correcting entries
earlier in the register)
I'd like to clean those up, but I don't have such notes for older
balancing entries.…
*I'm not scared to delve into the data file if the info is there, but
just not exposed in the UI. Just kindly point me in the right
direction. (I'm using SQLite backend)
I do a similar irregular reconciliation of cash-on-hand and
accounts-receivable accounts. I am not aware of a report which gives you
the reconciliation dates you seek. If you find it, I would like to know.
I do believe that the reconciliation dates are in the GnuCash book, if
you are willing to write code to get them. I was just looking inside the
XML form of the GnuCash book, because I was writing a program to fix up
linked file locations.
Inside the file, in a <gnc:transaction> element, there is <trn:splits>,
which contains two or more <trn:split> element. A reconciled (or
cleared) <trn:split> element contains a <split:reconciled-state> element
with a value "y" (or "c"), and a <split:reconcile-date> with a date. An
unreconciled <trn:split> element contains a <split:reconciled-state>
element with a value "n", and no <split:reconciled-state> element.
Also, in the <gnc:account> element, there is a "slots" mapping
structure. One slot has the key "reconcile-info". Its value is a mapping
structure with "last date", "last-interval", and "include-children".
Note this is per-account info, not per transaction.
Thus, I suspect that you might be able to write a report which uses
these structures to get close to what you want.
I looked inside the SQLite form of a GnuCash book a long time ago, but I
don't recall how it is structured. I suspect it might be fairly
straightforward to rephrase the above in SQLite terms. But sorry, I
can't easily do that for you myself at the moment.
_______________________________________________
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.