Matching transactions in the 'Imbalance' account

[Peter Ward]

David,

Many thanks for your prompt reply but I don't think that will solve the
problem.
I probably didn't explain myself clearly.
What I did was:

1. Import transactions to account A. These now point to the Imbalance
account.
2. Import transactions to account B. These now point to the Imbalance
account.
3. Update transactions in account A to point them to account B

The result is:

1 Account A is fine.
2 Account B has duplicated transactions. One set (original) still pointing
at the Imbalance account. The second (duplicated) set pointing correctly at
account A.

I was hoping it was possible for gnucash to recognise the duplicate
transactions in B and match my A transactions to them when I pointed them
to B.
It seems however I must take care of this procedurally by:

1. Importing transactions to account A. These point to the Imbalance
account.
2. Updating transactions in account A to point them to account B.
3. Import transactions to account B and hope the duplicates are recognised
and not imported.

Hope I've made myself clearer this time!

Thanks again for your time. I will be sure to post my solution when I've
nutted this out.

Pward





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


On 29 January 2013 13:54, David J. Bakeman <dbakeman at comcast.net> wrote:

> On 01/28/2013 05:28 PM, Peter Ward wrote:
> > 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?
> If I understand you correctly I think you are entering a new transaction
> because you are entering
> it in (A) which does NOT yet have the transaction.  So you need to go to
> (B) and edit the transaction.
> Replace Imbalance with the desired account (A).
>
> So find the transaction in (B) hit the split button then go to the entry
> that's set to imbalance and
> change it to (A) and hit return.
> >
> > 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.
> >
>
>