[GNC] importing

[Gyle McCollam]

David T.,
Yes, it was a QFX file and the transactions had already been entered and I was importing the file to match and reconcile my credit card statement.  The transactions on the statement were all dated 01/22/2023, while the transactions in my Gnu Cash file had transaction date from 09/2022 thru 01/2023.  I imported the file and made the corrections in the reconciliation window.


Thank You,

Gyle McCollam

Gyle McCollam

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________
From: David T. <sunfish62 at yahoo.com>
Sent: Friday, February 17, 2023 12:57 AM
To: Gyle McCollam <gmccollam at live.com>
Cc: David Reiser via gnucash-user <gnucash-user at gnucash.org>; edodd at billiau.net <edodd at billiau.net>
Subject: Re: [GNC] importing

With regard to the import process, were the source files OFX/QFX, by chance?

That file format includes unique transaction IDs to prevent reimport of previously imported transactions. Under the circumstances, I'd opt to manually enter the transactions in question and reconcile after.

David T.
On Feb 17, 2023, at 5:55 AM, Gyle McCollam <gmccollam at live.com<mailto:gmccollam at live.com>> wrote:

Liz,
Yes, I record all my transactions and then match with bank, credit card, etc.  In this case, I think it was the gas stations fault as it happened with multiple Mastercard's.  It was nice not having to pay for gas for 6 months, but this month the charges showed up on both cards.


Thank You,

Gyle McCollam

Gyle McCollam

gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email

________________________________

From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com<http://gmail.com>@gnucash.org> on behalf of edodd at billiau.net <edodd at billiau.net>
Sent: Thursday, February 16, 2023 8:57 PM
To: gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Subject: Re: [GNC] importing

On Thu, 16 Feb 2023 23:53:35 +0000
Gyle McCollam <gmccollam at live.com> wrote:

 I ran into a unique problem with a credit card import.  I was buying
 gas at a station using a mastercard.  The transaction was on my
 credit card as pending, but would disappear and not be on my bill.
 This went on for 6 months, but they finally corrected the problem and
 billed me for the 6 months of gas this month.  However, when I
 imported the file it said there were no matching transactions.  I
 used preferences to change the import parameters, but I could not
 change the dates to allow for transactions that old.  I could set the
 proper expense account, but that would double up on the transaction.
 Is there a way to click or double click on the import matcher and
 manually select the matching transaction?


 Thank You,

 Gyle McCollam

This is an interesting case. Are you recording the credit card
transactions in your books regardless of the errors of the credit card
company?
It is an example of the advantages of maintaining your record from your
receipts and entering the transactions, because then you would know
that money was owing, and how much.

If something takes more than about 18 months to show up I remove it
from active lists but preserve the data in case it turns up eventually.
I won't specify a method, because it has failings.

Liz
________________________________

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
-----
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
To update your subscription preferences or to unsubscribe:
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.