Transaction Reconciliation

David Carlson carlson.dl at sbcglobal.net
Tue Oct 30 23:11:20 EDT 2012


Hi Scumbuster,

You are describing the import transaction step of the process.  The transactions that are red will not import at all unless you edit them in some way to make them yellow or green. 

I am embarrassed to admit that I cannot remember where the instructions are for that process.  Perhaps someone else knows.  I think that our manuals need improvement because that did not jump out at me when I looked for it.  

Yellow transactions will import but they may not get assigned to the account that you want them to be assigned.  If you can correct them before completing the import, the next time similar transactions appear, it is more likely that they will import to your liking.  Green ones will import but they may still need to be fine tuned in one way or another.
After you have done it a few times you will get a feel for what to expect when GnuCash imports the specific files that your bank produces.

David C

--- On Tue, 10/30/12, Scumbuster <scumbuster at comcast.net> wrote:

From: Scumbuster <scumbuster at comcast.net>
Subject: RE: Transaction Reconciliation
To: "'David Carlson'" <carlson.dl at sbcglobal.net>
Cc: gnucash-user at gnucash.org
Date: Tuesday, October 30, 2012, 1:24 PM

I am a very new user , but I am working similarly to how I did in
Quicken............

I get receipts when I buy stuff/use my debit card (for everything) so I
accumulate the receipts.

I then download the bank transactions, then go through the "imbalanced"
transactions using each receipt, then mark the transactions as "cleared" as
I assign them to "accounts" (categories in quicken).......

I assume that at some point I can then use the bank statements to go back
and reconcile.....so I basically do everything twice I guess....

As I mentioned in another post, I have noticed that many of the imported
transactions are wanting to come in as red (like the transactions are not
really transactions) or as green (matching, cleared transactions) when they
are not.  Trying to work around that now.

But frankly, just glad to be moving away from Quicken!


-----Original Message-----
From: gnucash-user-bounces+scumbuster=comcast.net at gnucash.org
[mailto:gnucash-user-bounces+scumbuster=comcast.net at gnucash.org] On Behalf
Of David Carlson
Sent: Tuesday, October 30, 2012 11:08 AM
To: Liz; Derek Atkins
Cc: gnucash-user at gnucash.org
Subject: Re: Transaction Reconciliation

Derek,

I think that Liz and probably others (as I used to be) are confused when
they receive their paper statements and the screen shows some transactions
already checked.  They are then not sur you need to e which ones they have personally
checked unless they start over.

That is always a little more difficult because they are never in the same
order on the screen as on the paper statement.  If they do not want to print
an extra copy of something so they can use a pencil, they need some tool to
track which they themselves have checked.  

It is definitely not satisfactory to assume that downloads are accurately
matching transactions so that they can be assumed to be 'cleared'.

David C

--- On Tue, 10/30/12, Derek Atkins <warlord at MIT.EDU> wrote:

From: Derek Atkins <warlord at MIT.EDU>
Subject: Re: Transaction Reconciliation
To: "Liz" <edodd at billiau.net>
Cc: gnucash-user at gnucash.org
Date: Tuesday, October 30, 2012, 9:20 AM

Liz <edodd at billiau.net> writes:

> On Thu, 25 Oct 2012 11:37:02 -0700 (PDT) "David T." 
> <sunfish62 at yahoo.com> wrote:
>
>> 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.
>
> If I import data there is a 'helpful' change from 'n' to 'c'.
> When I try to reconcile, the 'c' marked transactions don't appear in 
> the window, and I used to waste considerable time reconciling from the 
> paper statement when I had only part-downloaded the account data.
> Now I change all the 'c' back to 'n' and reconcile speedily.

Anything marked 'c' should just already be checked off in the reconcile
windows.  You shouldn't need to change them back to 'n', unless you wind up
clearing transactions after the statement is generated but before you
receive it -- in which case yes, you will need to uncheck those items in the
reconcile window.

> 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
       warlord at MIT.EDU                        PGP key available
_______________________________________________
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.
_______________________________________________
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.



More information about the gnucash-user mailing list