Matching transactions in the 'Imbalance' account

[Peter Ward]

David,

Yes you are correct, I'm importing all of my statements first (and not just
2) BEFORE I specify the destination accounts.
I understand now this is not the way to do it. I need to import 1 at a time
and then sort the destinations before importing the next account.

I didn't even know I could specify the destination accounts while still in
the importer, that's a great tip thank you!
Obviously whether I sort the destination during import or later doesn't
matter as long as it's BEFORE I import the next account.
However your tip about sorting the destination DURING import to teach the
Bayesion transaction matching is also a good one.
I'll let you know how I go.

Thanks for you time

Pward


On 29 January 2013 13:59, David T. <sunfish62 at yahoo.com> wrote:

> Peter--
>
> It sounds like you are importing all of your statements, and then editing
> the result. This will produce the situation you describe.
>
> Instead, what you should do is import the banking information one account
> at a time, and select the destination accounts ***while still in the
> importer.***
>
> This will have a couple of benefits:
>
> 1) as you tell GnuCash which account a given transaction is supposed to go
> to, you will teach GnuCash how to handle the same kinds of transactions the
> next time you import (assuming you have turned on the Bayesian transaction
> matching option).
> 2) when you import the file for Account B, it should find the transactions
> that you pointed to in the first pass, and match the new transaction to the
> existing one.
>
> HTH,
> David
>
>   ------------------------------
> *From:* Peter Ward <peter at sandpward.com>
> *To:* gnucash-user at gnucash.org
> *Sent:* Monday, January 28, 2013 5:28 PM
> *Subject:* Matching transactions in the 'Imbalance' account
>
> Hi All,
>
> I've recently downloaded gnucash and believe I am progressing well enough
> with its use. I find it extremely logical for which I'm thankful.
> I have however encountered one issue with which I'm sure experienced users
> will be able to help.
>
> I've downloaded and imported multiple bank account statements into gnucash.
> Of course each transaction is also initially entered into the Imbalance
> account to maintain double entries.
>
> When however I go through transactions in account (A) to correct the
> destination account (B) for each transaction, a second entry is created in
> the destination account (B), even though dates and amounts match the
> original entries in account (B)
> So I end up with 2 transactions for each 'real' transaction in account (B),
> one pointing at the correct account (A) and the original entry in account
> (B) pointing at the Imbalance account.
>
> - Is there any way to 'match' the transactions in the Imbalance account
> with each other?
> - Is there any way to point a transaction in account (A) at a specific
> transaction in account (B)?
> - Any other suggestions as to how I may sort this out procedurally...e.g.
> import account (A), specify the destinations for all account (A)
> transactions, then import account (B) and hope the filter will recognise
> the existing transactions?
>
> my thanks in advance
>
> Pward
> _______________________________________________
> 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.
>
>
>