Carl, I’m with you on manual entry. GNC does a good job of remembering what you did last time so after a handful of months I give everything that is matched a glance to be sure it’s correct and deal with the unmatched ones.
One caveat. I duplicate regular monthly transactions with multiple splits (pensions checks) before the import. > On Oct 7, 2022, at 10:52 AM, Carl S. <s...@shch262.com> wrote: > > 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:rlo...@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@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....@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 > >
OpenPGP_0x19B6B68457884FFB.asc
Description: Binary data
> _______________________________________________ > 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.
OpenPGP_signature
Description: Binary data
_______________________________________________ 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.
