Matching transactions in the 'Imbalance' account

Tue Jan 29 06:04:19 EST 2013

I would take a quick look at the imbalance account, if all of the
transactions there are duplicates, it would be easier to delete them from
their than to pick and chose from the source accounts.  It still isn't
ideal, but for cleanup, it'll save some time.  If this is how it looks, try
to see if you can keep the mouse over the delete button and use the keyboard
to confirm when prompted.  Note you still have to delete the transactions,
deleting an account moves its transactions to the imbalance account, and
deleting the imbalance account does the same thing (so a new imbalance
account will be created in its place).
	Dustin

-----Original Message-----
From: gnucash-user-bounces+the00dustin=gmx.net at gnucash.org
[mailto:gnucash-user-bounces+the00dustin=gmx.net at gnucash.org] On Behalf Of
David T.
Sent: Tuesday, January 29, 2013 02:17
To: Peter Ward
Cc: gnucash-user at gnucash.org
Subject: Re: Matching transactions in the 'Imbalance' account

Actually, Peter, you're describing exactly what I thought.

If, in step 1, you take the time **in the importer window** to match the
transactions in Account A with their appropriate "destination" accounts
(e.g., Account B), then the importer in step 2 (in most cases) will match
the incoming Account B transactions with the existing Account A
transactions. No duplicates.

If you want to keep doing it the way you are doing it, then the fix is to
delete the duplicate transactions in Account B that point to Imbalance. That
is the slow way to do it, though.

David

On Jan 28, 2013, at 11:05 PM, Peter Ward <peter at sandpward.com> wrote:

> 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.
>>> 
>> 
>> 
> _______________________________________________
> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6578 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20130129/96ad3f60/attachment-0001.bin>