Transaction Reconciliation

[David T.]

OK. I guess I am grateful that I don't have to understand the intricacies of your situation. My head hurts to think about it...


David




________________________________
 From: David Carlson <carlson.dl at sbcglobal.net>
To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>; David T. <sunfish62 at yahoo.com> 
Sent: Thursday, October 25, 2012 8:46 PM
Subject: Re: Transaction Reconciliation
 

David T

Sorry, I was not clear in my description of my first use case.  I generally have a work cycle somewhat similar to that of the OP.  During the month I usually import transactions two or three times.  This changes most of the "n" s to "c" where I had pre-entered the transaction, either manually or by scheduled transaction assistant, or creates new transactions with a status of "c".  When I need to re-enter or enter from scratch, the status, of course, starts out  as "n".  Then after the import I want to check any remaining "n" transactions to see if they are legitimately un-cleared or the result of a glitch somewhere, such as the import matching to the wrong transaction.  That would happen two or three times a month in my case because I often eat the same sandwich at Panera for the same price, Then the newly
 imported transaction would get matched to the previously imported transaction for a different date.  I catch most of these when I review the import, but sometimes I miss one.
In addition, like the OP, I wish to review splits as in my second use case to correct initial estimates when the details become available.
When the bank statement arrives I finally open the Reconcile window and reconcile to change the status of that statement's transactions to 'R".  This is analogous to paper reconciliation as we did it in the dark ages.   I would not un-reconcile a transaction except in an extraordinary case. Then It would get reconciled again in the following month.

I do not currently reconcile expense or income accounts, but I might if I think of a good reason to do it.  The reason that I check them is to get more accurate income and expense reports. 

I will have to try your suggestion to use the space bar in the reconcile
 window.

David C.

--- On Thu, 10/25/12, David T. <sunfish62 at yahoo.com> wrote:


>From: David T. <sunfish62 at yahoo.com>
>Subject: Re: Transaction Reconciliation
>To: "David Carlson" <carlson.dl at sbcglobal.net>, "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
>Date: Thursday, October 25, 2012, 1:37 PM
>
>
>David--
>
>I'll note that Colin made an important point regarding the OP's query: that there is a Reconcile process that is a more normal method of reconciling against a statement. With regard to *that* issue, I imagine that the Reconcile process would help them out. I will add to Colin's advice to note that when a user has the Reconcile window
 open, it is possible to check off a transaction in the list simply by using the space bar. Cursor keys allow you to navigate from one transaction to the next, and TAB will take you from the deposits list to the charges list.
>
>As for your first use case, I don't really see why you'd need to change the R status on a manually-entered transaction; in my experience, the primary difference this makes is to pre-check a transaction in the (above-mentioned) reconciliation window. However,
 it is a simple matter in that window to mark such a transaction as reconciled--despite it's not having a "C" status.
>
>
>
>Your second use case (double-checking expense accounts), is more interesting. I see where your approach has utility. I wonder if it might be also viable for you to a) verify expense transactions for a given time period (say a week or a month) and then b) reconcile the account. This would then mark the transactions with a "y" in the R field.
>
>
>
>David
>
>
>
>________________________________
> From: David Carlson <carlson.dl at sbcglobal.net>
>To: gnucash-user at gnucash.org 
>Sent: Thursday, October 25, 2012 9:35 AM
>Subject: Re: Transaction Reconciliation
> 
>On 10/25/2012 10:56 AM, Colin Law wrote:
>> On 25 October 2012 16:28, C. Andrews Lavarre <alavarre at gmail.com> wrote:
>>> I've googled and read 5.8 of the documentation as well as
>>>
>>> *    **http://wiki.gnucash.org/wiki/Keyboard_Shortcuts **
>>> *
>>> and examined
>>> *
>>> **    ~/.gnucash/accelerator-map*
>>>
>>> but have not found:
>>>
>>> *How to change a transaction reconciliation status from n to c with key
>>> combination without mouse*.
>>>
>>> When you tab through a transaction the cursor skips the Reconciliation
>>> column.*
>>>
>>> *So how can this be done?
>>>
>>> I do asmuch I can with keyboard, especially when reconciling statements.
>>> It would be very useful to either have a hotkey to change a transaction
>>> reconciliation from *n* to *c*  or else be able to tab to the column and
>>> press space or something to change it.
>> Just in case you are not aware of it the normal method of
>>
 reconciliation is via Actions >
 Reconcile.  I don't think I have ever
>> changed that field manually.  Or is there a use case that I am not
>> aware of?
>>
>> Colin
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
>>
>
>Colin,
>Absolutely yes there are use cases.  I get very imperfect results when I
>import transactions from my banks.  Sometimes I miss that an incorrect
>match was made and I need to either manually enter or re-enter
 a
>transaction or undo and re-do an import.  The
 former is usually easier. 
>As far as improving the accuracy of imports, that is not likely with the
>particular way they structure their exports, unless GnuCash get better
>in this area.
>
>Secondly, in other accounts (especially income and expense accounts, I
>use the "C" in the reconcile box to tell me that I have double-checked
>that transaction line.  I often make guesses in splits and go back later
>when I find out how much interest the bank really charged.
>
>I would vote for adding a keystroke or key combination to move the focus
>to the reconcile field.
>
>David C
>
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at 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.
>
>