Re: Bank reconciliation history

[William Jackson]

> 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

[Mark Roworth via gnucash-user]

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 <christopher@gmail.com>
 To: Mark Roworth <rowor...@yahoo.co.uk> 
Cc: "gnucash-user@gnucash.org" <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 
<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.

Re: Bank reconciliation history

[Nelson Handcock]

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

[Derek Atkins]

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

[David T. via gnucash-user]

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

[Christopher Lam]

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.

Bank reconciliation history

[Mark Roworth via gnucash-user]

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.