While the convenience of importing transactions is nice, I've
been doing manual reconciliation and entry -- it's fast enough,
providing that I haven't missed a transaction.
On Thu, Oct 6, 2022 at 8:11 AM David Carlson
<david.carlson....@gmail.com> wrote:
OK. I just checked and now they only offer PDF,
Spreadsheet(whatever that
means) and CSV download formats for my account. I guess they
don't need
our business.
On Thu, Oct 6, 2022 at 7:51 AM Carl S. <s...@shch262.com> wrote:
> Whooops.....you're right QFX and not QDF
> ------------------------------
> *From:* David Carlson [mailto:david.carlson....@gmail.com
> <david.carlson....@gmail.com>]
> *Subject:* [GNC] Import CSV transactions into GC
> *Date:* Thursday, October 6, 2022 at 12:17 AM
> *To:* Carl S.
> *Cc:* gnucash-user@gnucash.org
>
> What is QDF format? That would not be the same as QFX.
>
> On Wed, Oct 5, 2022 at 10:57 PM Carl S. <s...@shch262.com>
wrote:
>
>> David,
>>
>> Thanks for the recommendations. I've been working on this
way too long
>> but think that I figured out some of the difficulties.
'Just reconciled
>> a credit card statement and got all of the old mess behind
so that I can
>> begin anew by downloading csv transactions every few days
or so.
>>
>> I think I figured out why and how I got duplicates- in
the Match
>> Transactions window there were several transactions that
had the A box
>> checked and in the Additional Comments column area there
were the words,
>> New, transfer $25.75 to (auto) "E:Food" My guess is that
GC was
>> telling me, "you already have this transaction in the
register and
>> here's the amount and the account name". So the solution
was to tell GC
>> to NOT import the transaction by unchecking the A box
which would turn
>> the line color red. You're correct also that if the C box
is checked
>> that particular transaction wont be imported.
>>
>> Thank you for the help...
>>
>> Carl Smith
>>
>> On 10/5/22 22:17, David Cousens wrote:
>> > Carl
>> >
>> > If you had previously imported the September
transactions, then the
>> Import
>> > Matcher should recognize all of them as duplicates and
not import them.
>> In this
>> > case the A checkbox and U+C checkbox should both be
unchecked and the
>> 'C'
>> > checkbox set to indicate that the transactions match
existing
>> transactions and
>> > won't be imported, but the existing transactions will be
marked as
>> cleared (not
>> > reconciled).
>> >
>> > If the CSV file contained some data which differed from
that which was
>> in the
>> > in the QFX files, the U+C checkbox may be checked
instead of the C
>> checkbox
>> > which indicates that the transaction matches an existing
transaction
>> and won't
>> > be imported again but the data which is different will
be updated form
>> the CSV
>> > import file. The A checkbox should not be checked if
the transactions
>> already
>> > exist in your data file, only if they are new
transactions.
>> >
>> > It is deliberately designed so as to not allow importing
duplicate
>> transactions
>> > as transactions can only be deleted individually from
the account
>> register.
>> >
>> > If you are experimenting with the import, a good idea is
to create a
>> dummy test
>> > set of books and experiment with importing into that
firstrather than
>> your main
>> > set of books. The dummy doesn't have to have your full
account tree,
>> just the
>> > accounts you will use during the import process. Once
you have the
>> import
>> > working as you want then import to your main set of
books. It also
>> helps to
>> > create a dummy CSV file which only has a few typical
transactions in it
>> to get
>> > the setup right. Avoids having to delete large numbers
of transaction
>> while you
>> > are experimenting if you don't get it right first time
round.
>> >
>> > David Cousens
>> >
>> > On Wed, 2022-10-05 at 21:01 -0400, Carl S. wrote:
>> >> Discover Card (a credit card) as of last week stopped
providing the
>> >> download of Discover card transactions in QDF....much
to my
>> displeasure.
>> >>
>> >> They do provide a download of transactions in CSV format.
>> >>
>> >> I'm trying to figure out how to do a reliable
importation of my credit
>> >> card transactions into GC in my Discover Card acct in
GC. This all
>> >> assumes I'll have to work with the downloaded CSV files
now.
>> >>
>> >> For experimentation reasons I'm working on importing in
csv format the
>> >> transactions for the entire month of September just to
see how the
>> >> actual process is done. Previously, I had already
imported the
>> Discover
>> >> card transactions in QDF for September (before Discover
Card ended the
>> >> QDF download). Next I'm importing the CSV transactions
to see how they
>> >> are recognized and matched by GC.
>> >>
>> >> I've been somewhat successful in using the
>> >> File----Import-----Transactions from CSV and getting to
the Match
>> >> Transactions screen which presents the transactions to
be imported. I
>> >> understand what the Reconcile (auto match) transactions
are but many of
>> >> the transactions when imported to the account end up as
duplicates
>> since
>> >> previously they had been added in QDF.
>> >>
>> >> So, I'm confused and want to make the importation
process as easy as
>> >> possible. The A U+C C options make matters
worse....for me.
>> >>
>> >> Also, I've tried, or rather, have attempted to get
working, various
>> >> csv2ODF converters. For me too many error messages was
enough to stay
>> >> away from them.
>> >>
>> >> Any help is much appreciated...
>> >>
>> >> Car Smith
>> >> _______________________________________________
>> >> gnucash-user mailing list
>> >> gnucash-user@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@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@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.
>>
>
>
> --
> David Carlson
>
>
>
-- David Carlson
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
-- _________________________________
Richard Losey
rlo...@gmail.com
Micah 6:8
