> Am going to look at writing some SQL to pull this out of the GNU cash database
You will be looking for the "reconcile_date" column on the "splits"
table. I use PostgreSQL and I'm curious to hear about any fancy SQL
you come up with!
Wiliam
___
gnucash
nt: Monday, 30 October 2017, 13:27
Subject: Re: Bank reconciliation history
Don't think this information is stored in the database.
I think the closest approach is use Transaction Report, enable
Display/Reconciled Date, set Sorting/Primary Key to Reconciled date,
Sorting/Secondary Key
If you open the GNucash account that you use to record your bank
transactions, there is a "Reconciled" indicator. By default it is set to
'N'. If you click this it will change to "C", and when you complete the
reconciliation this indicator is changed to "Y".
When I reconcile my GN account, I click
Hi,
Mark Roworth via gnucash-user writes:
> Hi all,
> Is there anyway I can see a list of bank statements and which
> transactions were reconciled to which statements? For the life of me I
> can't find it?
> Thanks for any help received,
Even though the reconcile date is stored, there is curren
Mark,
The simple answer is “No.” There isn’t any way from the GnuCash application to
see which transactions were reconciled on which statements.
I believe that the GnuCash data file does store reconcile information in the
data file, but that information is not exposed in the GUI. You might be a
Don't think this information is stored in the database.
I think the closest approach is use Transaction Report, enable
Display/Reconciled Date, set Sorting/Primary Key to Reconciled date,
Sorting/Secondary Key to None.
But I don't think the 'reconciled balance at reconciliation date' is ever
store
Hi all,
Is there anyway I can see a list of bank statements and which transactions were
reconciled to which statements? For the life of me I can't find it?
Thanks for any help received,
Mark
Mark roworthrowor...@yahoo.co.uk
___
gnucash-user mailing list
