[GNC] Is there a record of reconciliations performed along with closing balances and dates?

[Jim DeLaHunt]

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