Where the CSV importer--along with most of the rest of GnuCash--works poorly is when there are 3 or more commodities/currencies involved. The most common example is when one trades in stock denominated in a different currency from your own, for example a Canadian whose books are in CAD buying US stock denominated in USD.
Regards, John Ralls > On Nov 16, 2021, at 9:59 AM, David Carlson <david.carlson....@gmail.com> > wrote: > > Kalpesh, > > When the CSV importer was upgraded early in the release 3.x series, it was > intended to work with investment transactions. It is designed to import > the majority of variations available in split transactions with more than > two splits. > > I am starting to test it with my investment accounts in release 3.8 in > Ubuntu, and finding that I need to do some fine tuning, but I need to do > more testing for my case. However, I think that the reconciliation flag > code may be working in that release, but I simply accepted the standard > treatment. > > On Tue, Nov 16, 2021 at 11:31 AM Kalpesh Patel <kalpesh.pa...@usa.net> > wrote: > >> Hi Ove - >> >> >> >> I was curious what types of Stock Transactions you are importing properly >> via CSV format into GNC. >> >> >> >> I was under the belief that purchase/sale of securities/commodities was not >> supported via CSV import process in GNC (or I was mistaken) so if it is >> possible then I wouldn't mind learning how to accomplish that. >> >> >> >> I have always fallen back with QIF import for importing stocks/securities >> transactions if OFX/QFX isn't supported by the broker as QIF format >> provided >> much better control of transactions being imported. I can also export from >> Quicken, manipulate, and then import to keep GNC up-to-date if need be. >> >> >> >> ------------------------------ >> >> >> >> Message: 7 >> >> Date: Tue, 16 Nov 2021 09:00:35 -0600 >> >> From: David Carlson <david.carlson....@gmail.com >> <mailto:david.carlson....@gmail.com> > >> >> To: Ove Grunn?r <write2...@gmail.com <mailto:write2...@gmail.com> > >> >> Cc: gnucash-user <gnucash-user@gnucash.org <mailto: >> gnucash-user@gnucash.org> >>> >> >> Subject: Re: [GNC] CSV Import Reconciled field >> >> Message-ID: >> >> >> <cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com >> <mailto:cadygsbk2db66tmfy_nuec+ytnfdjjvrvpiqxjpisyaobtx0...@mail.gmail.com >>> >>> >> >> Content-Type: text/plain; charset="UTF-8" >> >> >> >> Hello Ove, >> >> >> >> Your procedure is very creative and I hope we can solve your problem. I >> believe that the CSV importer should respect the desired state of the >> reconciliation flag, so the fact that it does not is a problem in my >> opinion. >> >> >> >> First, your problem may be the result of a recent bug in the CSV import >> that >> may or may not be resolved in the current GnuCash release 4.8. >> >> However, to help track it down, please tell us what release you are using, >> your operating system, and the installation type(e.g. Distro, Flatpak, >> >> compiled) . >> >> >> >> Second, technically, credit cards are always considered to be liabilities >> in >> accounting applications. I realize that you are not following technically >> correct accounting procedures, and your procedure works for you (at least >> it >> did earlier), but you may run into problems if you try to balance bank >> account payments against credit card bills later. Thus, I suggest trying >> to >> modify your procedure to follow accounting conventions. >> >> >> >> We look forward to hearing from you. >> >> >> >> >> >> >> >> On Tue, Nov 16, 2021 at 6:19 AM Ove Grunn?r <write2...@gmail.com >> <mailto:write2...@gmail.com> > wrote: >> >> >> >>> Hello, all >> >>> >> >>> I am in the process of changing from QIF import to CSV import of data >> >>> and have encountered a difference in the functionality that I am >> >>> trying to understand better in order to make it compatible with my own >> >>> process, or change my own process to suit the functionality. >> >>> >> >>> >> >>> My Account Structure is in principle: >> >>> >> >>> Asset:Credit Card >> >>> Asset:Card Receipts >> >>> Expenses:Various Expense accounts >> >>> >> >>> >> >>> My process to date have been to Scan all receipts and based on the >> >>> file names of each receipt, [ e.g. 20211231_VISA >> >>> CARD_000009.99_EUR_Place of Sale_Category or Transfer Account_Note ] I >> >>> then generate a QIF file and import all receipts this way to [Asset:Card >> Receipts] in gnucash. >> >>> >> >>> For bank and credit card statements I have then converted the >> >>> statements I download from Online to QIF format, and then I import >> >>> these QIF files to GnuCash, where the Account is always [Asset:Credit >> >>> Card], and the transfer account is always [Asset:Card Receipts] >> >>> >> >>> As such, "Card Receipts" should always be Zero in the long run, if it >> >>> is positive I am missing a receipt, and if it is negative the purchase >> >>> has not yet showed up on my Credit Card. >> >>> >> >>> I then have a report that shows all Non-Reconciled transactions in >> >>> [Asset:Card Receipts] When Card statement and Receipts match, I >> >>> manually click the R column to set state to Reconciled. >> >>> I find this very easy to work with, as I decide the Expense category >> >>> when I name the receipt, and I can very easily reconcile it to make >> >>> sure All Card Expenses are tracked this way. >> >>> >> >>> Recently in order to get Stock Transactions to import properly I had >> >>> to use CSV format to import transactions, and in order not to have to >> >>> import both QIF and CSV files, I decided to change receipts and Card >> >>> Statements to CSV also. >> >>> >> >>> The problem I have now is that when I import any transaction using CSV >> >>> it always is set to "Reconciled" on import. >> >>> I tried to set the "Reconciled" field in the CSV Importer dialog, but >> >>> it seems it is ignoring the reconsoiled information on import. >> >>> Quote from GnuCash documentation: "Note that "reconciled" in this >> >>> context does not mean the same as "reconciled" in the process of >> >>> reconciling an account to an external statement. The reconciliation >> >>> status of an imported transaction is set to cleared (c) on import of a >> new >> transaction " >> >>> >> >>> So the question is, without completely changing my process, is there a >> >>> way to force csv imports to show up as Not-Reconciled after import? >> >>> Some other way of achieving the definition of each receipts expense >> >>> category separate to the import process and an easy way of ensuring >> >>> all transactions on the statement has a receipt or similar >> >>> confirmation of correctness. >> >>> >> >>> Many thanks in advance for any suggestions or advice. >> >>> >> >>> Kind regards Ove. >> >>> _______________________________________________ >> >>> gnucash-user mailing list >> >>> gnucash-user@gnucash.org <mailto:gnucash-user@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. >> >>> >> >> >> >> >> >> -- >> >> 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 >> 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. >> > > > -- > 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 > 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. _______________________________________________ gnucash-user mailing list gnucash-user@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.
