Re: Bank reconciliation history
> 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-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
Thanks everyone with you help with this. Am going to look at writing some SQL to pull this out of the GNU cash database (I happen to be a SQL developer). Mark roworthrowor...@yahoo.co.uk07870 575707 From: Christopher Lam To: Mark Roworth Cc: "gnucash-user@gnucash.org" Sent: 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 to None. But I don't think the 'reconciled balance at reconciliation date' is ever stored. Interestingly from the account register, there's View/Sort By... "Statement Date" which doesn't seem to do what the tooltip says. On 30 October 2017 at 18:00, Mark Roworth via gnucash-user wrote: 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 gnucash-user@gnucash.org https://lists.gnucash.org/ mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
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 on this indicator as I check items off on my bank statement, and when I get to the end of the period I click "Reconcile" and confirm everything in the display is checked. Any discrepancy is easily seen and can be investigated further. Not sure if you might be able to include this column in a transaction report though. Hope this helps! Thanks & Regards, Nelson Handcock 0409 149919 http://www.linkedin.com/in/nelsonhandcockaustralia On Tue, Oct 31, 2017 at 2:08 AM, Derek Atkins wrote: > 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 currently no report > that will show/access that data. > > > Mark > > Mark roworthrowor...@yahoo.co.uk > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > -- >Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory >Member, MIT Student Information Processing Board (SIPB) >URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH >warl...@mit.eduPGP key available > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
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 currently no report that will show/access that data. > Mark > Mark roworthrowor...@yahoo.co.uk > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH warl...@mit.eduPGP key available ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: Bank reconciliation history
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 able to save your data in SQL format and then open your data in an SQL tool that would allow you to create an SQL query to extract this information. But that is not for the faint of heart. HTH, David > On Oct 30, 2017, at 3:00 PM, Mark Roworth via gnucash-user > wrote: > > 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 > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
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 to None. But I don't think the 'reconciled balance at reconciliation date' is ever stored. Interestingly from the account register, there's View/Sort By... "Statement Date" which doesn't seem to do what the tooltip says. On 30 October 2017 at 18:00, Mark Roworth via gnucash-user < gnucash-user@gnucash.org> wrote: > 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 > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.