[GNC] CSV Import Reconciled field - Sideline question

Tue Nov 16 12:43:03 EST 2021

Hello Patel,

[I changed the title of the email so hopefully it will create a separate 
trail and not mix up with my initial query ]

I can do most things with both QIF and Multi line CVS in regards to 
Stock/securities (that  I need to do)

e.g.

  * Stock Purchase with commission
  * Stock Sell with commission
  * Dividend with tax and with fee and zero buy stock to align the
    dividend with the stock
  * Stock Split or more precisely Add Stock at zero cost

the one thing I was not able to do with QIF was to align the Dividend 
with the Stock, so that the "Advanced Portfolio" report would correctly 
recognise the Dividend to the Stock.

Since I have trading accounts active, I also add a line for each trading 
account transaction when required. I am not sure if I have to do this, 
but it is easy to do when I create the export CSV file programmatically.

I find the CSV multi-line format very easy to work with because you can 
add any combination of lines to a transaction.

What in particular are you having a problem with importing using CSV?

kind regards Ove.

On 16/11/2021 17:28, Kalpesh Patel 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.417 at gmail.com>
>
> To: Ove Grunn?r <write2ove at gmail.com>
>
> Cc: gnucash-user <gnucash-user at gnucash.org>
>
> Subject: Re: [GNC] CSV Import Reconciled field
>
> Message-ID:
>
>                 
> <CADYgSbk2DB66tMfy_nueC+ytNfDjjVrvpiQXJpiSyAobtx0e6Q at 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 <write2ove at 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 at 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
>