[GNC] How to Manually Match transactions

Adrien Monteleone adrien.monteleone at lusfiber.net
Thu Nov 19 13:47:29 EST 2020


The most likely correct short answer: the import created two 
transactions rather than one. Your correction of the Imbalance 
assignment is not creating a new transaction, but correcting only one of 
the existing two separate transactions. Commit this fix, and then delete 
the extraneous transaction.

The longer answer:

Step 1:

I *highly* recommend turning on View > Transaction Journal View, at 
least temporarily. This will show all splits of a transaction for easy 
viewing. (I use this view permanently)

Step 2:

 From account 1 (either credit card or bank, your choice) observe the 
two splits shown. One should be a debit (Dr.—left column figure) and one 
should be a credit (Cr.—right column figure).

If you are looking at the Credit Card, you should see

Dr. Credit Card
Cr. Checking Account

and the opposite if you are viewing the Checking Account. I use 
Debit(Dr.) and Credit(Cr.) because the informal labels change based on 
the type of account viewed and might even be confusing.

Debits increase asset and expense accounts, debits increase equity, 
liability, and income accounts.

If *instead* you see:

Dr. Credit Card
Cr. Imbalance

and,

Dr. Imbalance
Cr. Checking Account

then the import created two separate transactions instead of only one. 
(as I guessed above in the short answer)

Simply fix *one* of them—e.g.,

Dr. Credit Card
Cr. Checking Account (re-assigned from Imbalance)

and *delete* the other transaction in the opposite account.

----

It would be good to review the Help & Guide documents concerning 
imports, specifically with respect to how to assign the 'transfer' 
account properly so that you end up with one transaction instead of two. 
The QFX file might list each side of the transaction separately and the 
importer is treating it as two separate rather then two sides of, the 
same transaction. That's a user fix either before or during the import.



Regards,
Adrien

On 11/19/20 12:29 PM, Griff wrote:
> Here is a very simple question but I can't figure out how to do this.
> I have searched the documentation and this mailing list.
> 
> How do I manually match 2 transactions:
> 
> I have 2 account that have had data imported via qfx.
> 
> Account 1 (credit card) has a transaction on 2020-01-19 that is a payment
> for $amount which is the credit card payment from checking account
> 
> Account 2 (bank account) has a transaction on 2020-01-21 that is a
> withdrawal for $amount which is the checking account payment to the credit
> card.
> 
> The Transfer for the transactions in each account are currently  set to
> Imbalance-USD. When I change the Account 1 transaction Transfer field to
> Account 2 - a new transaction is created in Account 2 instead of matching
> to the existing one.



More information about the gnucash-user mailing list