[GNC] How to Manually Match transactions

[Griff]

Thanks Adrien and Stephen.

Both your solutions are good work arounds, sounds like the short answer is
it can't be done the nice way preserving data. The result will be to
manually delete one of the import transactions and the new duplicate
created won't have the date that matches one of the 2 banks for correctness
purposes.

To your suggestion of importing it all at once, that is not possible as one
QFX file is from the credit card company download and the other QFX is from
the different bank company's download. They will be two files.

This is unfortunate as the matcher is only run on QIF import and not
OFX/QFX import.
Should I be getting the data from the banks in QIF instead, does that work
better then OFX/QFX for GnuCash import?

On Thu, Nov 19, 2020 at 11:48 AM Adrien Monteleone <
adrien.monteleone at lusfiber.net> wrote:

> 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.
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>