[GNC] Import CSV transactions into GC
Carl S.
SE at SHCH262.com
Fri Oct 7 10:51:35 EDT 2022
Well, reconciliation is easy and quick enough but manual entry of
transactions is a huge waste of time- I have over 400 per month just for
my credit card.
At this point I've adapted to importing CSV format and it works quite
well.....now that I understand it. I've also successfully imported PDF
converted to CSV format once certain data or columns (in Libreoffice
Calc) were modified or deleted.
So with an element of happiness I ask....."QFX....QFX.....what's that?"
Carl Smith
------------------------------------------------------------------------
*From:* R Losey [mailto:rlosey at gmail.com]
*Subject:* [GNC] Import CSV transactions into GC
*Date:* Thursday, October 6, 2022 at 12:43 PM
*To:* David Carlson
*Cc:* Carl S.; gnucash-user at gnucash.org
> 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.417 at 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. <SE at shch262.com> wrote:
>
> > Whooops.....you're right QFX and not QDF
> > ------------------------------
> > *From:* David Carlson [mailto:david.carlson.417 at gmail.com
> > <david.carlson.417 at gmail.com>]
> > *Subject:* [GNC] Import CSV transactions into GC
> > *Date:* Thursday, October 6, 2022 at 12:17 AM
> > *To:* Carl S.
> > *Cc:* gnucash-user at 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. <SE at 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 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.
> >>
> >>
> >> _______________________________________________
> >> 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.
> >>
> >
> >
> > --
> > David Carlson
> >
> >
> >
>
> --
> David Carlson
> _______________________________________________
> 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.
>
>
>
> --
> _________________________________
> Richard Losey
> rlosey at gmail.com
> Micah 6:8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0x19B6B68457884FFB.asc
Type: application/pgp-keys
Size: 2436 bytes
Desc: OpenPGP public key
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20221007/7f1fb75f/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 665 bytes
Desc: OpenPGP digital signature
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20221007/7f1fb75f/attachment.sig>
More information about the gnucash-user
mailing list