Bank reconciliation history
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.
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
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: Close Book regression
Please file a bug report. -derek Amish writes: > Yes i had noticed the same too. What i did is moved 1 or 2 transactions > which fall on closing date to one day earlier. > > Amish > > On 28-Oct-2017 4:19 PM, "Yves-Eric Martin" < > yem_lists.gnucash@filter.yve.net> wrote: > > Hi all, > > > Version: GnuCash 2.6.18 (built from rev 3a9fbb8+ on 2017-09-22) > > > I think I found a regression in the Close Book tool: until last year (not > sure which version unfortunately), the transactions on the closure date > were included in the calculations, resetting all income and expense > balances to zero. But now, it seems these closure date transactions are not > included anymore, leaving accounts with non-zero balances. > > Steps to reproduce (on a new file with the default common accounts, no > transactions): > > 1) create a transaction in Expenses:Supplies on 2017-09-29 for the purchase > of goods for 1,000 (credit to Cash in Wallet) > 2) create a transaction in Expenses:Supplies on 2017-09-30 for the purchase > of goods for 200 (credit to Cash in Wallet) > 3) use the Close Book tool with: > - Closing date: 2017-09-30 > - Income total: Equity:Opening Balances > - Expenses total: Equity:Opening Balances > - Description: Closing Entries > > Current behavior: The Expenses:Supplies account shows a balance of 200 > > Expected behavior: The Expenses:Supplies account shows a balance of 0 > > Workaround: a temporary workaround is to run the Close Book tool using > "date + 1", then manually edit the two closing transactions and move them > back 1 day. > > > > Thank you, > Yves-Eric > ___ > 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. > > -- 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
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
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.
