Matching transactions in the 'Imbalance' account

David T. sunfish62 at yahoo.com
Mon Jan 28 21:59:28 EST 2013


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.


More information about the gnucash-user mailing list