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.
I hope this helps!
—Jim DeLaHunt, Vancouver, Canada
_______________________________________________
gnucash-user mailing list
[email protected]
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.
