[GNC] Reconciliation Report -- Can't find transactions

[Adrien Monteleone]

I just discovered the same thing myself yesterday. (I never use the report) I can’t imagine what utility that has. I also think it is a bug since the primary sort order was ‘date’ and there was an option to choose ‘reconciled date’ instead, but the general tab date range only operates on reconciled date.

This is quite strange. I certainly didn’t expect that behavior.

If one edits a transaction that is reasonably far back in history (say for some minor spelling error, or a refactoring of expense accounts) which then gets the reconcile flag unset and you have to re-reconcile to reset it, now that old transaction is going to show up on your current reconciliation report.

I had to re-reconcile some periods from 2016 not long ago for this very reason. When I ran the report yesterday to see reconciled transactions from 2018, I had old transactions mixed in. It seems it is impossible to get a report (without resorting to a spreadsheet workflow) that shows me what I wanted to see. (yes, I can run a filter on the register and then run a register report - I’m talking about using *this* report)

Is that intended?

With no way out?

Regards,
Adrien


> On Jan 12, 2019, at 10:32 AM, Stephen M. Butler <kg7je at arrl.net> wrote:
> 
> On 1/12/19 12:20 AM, Liz wrote:
>> On Sun, 6 Jan 2019 14:44:56 -0600 (CST)
>> David Cousens <davidcousens at bigpond.com> wrote:
>> 
>>> Steve,
>>> 
>>> I just ran it on an account in my recordsin 3.4  and it worked fine.
>>> I had to explicitly select the account/accounts and period it was to
>>> be prepared for in the Accounts tab in the Report Options dialog
>>> (Edit Menu) once I had opened the report (initially blank) and then
>>> the entries all came up.
>>> 
>>> David
>>> 
>> I was just experimenting here (Debian Buster/Sid; Gnucash 3.4+ 30/12/18)
>> 
>> I opened the reconciliation report
>> Select options
>> Select an asset account, apply
>> All I had was the unreconciled amounts
>> 
>> Try a second and a third account, with the dates set to beginning of
>> last quarter to end of last quarter.
>> I got the reconciled and the unreconciled amounts (which I was
>> expecting)
>> 
>> Tried first account again, wouldn't change to the altered dates,
>> wouldn't show the reconciled amounts. Reload made no difference.
>> 
>> I closed Gnucash, restarted and tried again with identical results.
>> Output.pdf is the first account, not showing a large number of
>> reconciled transactions (77 missing transactions)
>> Output1.pdf is the second account.
>> 
>> Liz
> 
> 
> I found that my reconciliation date was in 2019 while I was running the
> report thru the end of 2018.  Once I opened up the dates to include up
> through "Today", the reports worked.
> 
> Reminder (to self), dates on the reconciliation report are not the
> transaction dates.  Instead, they are the reconciliation date! 
> Important difference.
> 
> -- 
> Stephen M Butler, PMP, PSM
> Stephen.M.Butler51 at gmail.com
> kg7je at arrl.net
> 253-350-0166
> -------------------------------------------
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>