[GNC] CSV Import Reconciled field

Fri Dec 3 14:48:23 EST 2021

I joined up later in the 3.X releases so likely missed the earlier notes and didn’t go in the past version to catch-up on it. 

I also was looking for much easier way to import, similar to importing bank debit/credit transactions, as my format looks like this:

Date

Investment

Transaction Type

Amount

Shares/Unit

4/28/2020

JPM EQUITY INCOME R6

DIVIDEND

3.23

0.2

4/2/2020

JPM EQUITY INCOME R6

REALIZED G/L

-0.36

0

4/2/2020

JPM EQUITY INCOME R6

ADVISOR / CONSULTANT FEE

-1.66

-0.116

3/13/2020

JPM EQUITY INCOME R6

CONTRIBUTION

53.96

           3.448

But I assume that I am not going to succeed without some preprocessing to get aligned what csv importer is expecting.

From: David Carlson <david.carlson.417 at gmail.com> 
Sent: Tuesday, November 16, 2021 1:00 PM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: Ove Grunnér <write2ove at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] CSV Import Reconciled field

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.patel at usa.net <mailto:kalpesh.patel at 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.417 at gmail.com <mailto:david.carlson.417 at gmail.com> 
<mailto:david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com> > >

To: Ove Grunn?r <write2ove at gmail.com <mailto:write2ove at gmail.com>  <mailto:write2ove at gmail.com <mailto:write2ove at gmail.com> > >

Cc: gnucash-user <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
>

Subject: Re: [GNC] CSV Import Reconciled field

Message-ID:

<CADYgSbk2DB66tMfy_nueC+ytNfDjjVrvpiQXJpiSyAobtx0e6Q at mail.gmail.com <mailto:CADYgSbk2DB66tMfy_nueC%2BytNfDjjVrvpiQXJpiSyAobtx0e6Q at mail.gmail.com> 
<mailto:CADYgSbk2DB66tMfy_nueC+ytNfDjjVrvpiQXJpiSyAobtx0e6Q at mail.gmail.com <mailto:CADYgSbk2DB66tMfy_nueC%2BytNfDjjVrvpiQXJpiSyAobtx0e6Q 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 <mailto:write2ove at gmail.com> 
<mailto:write2ove at gmail.com <mailto: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 <mailto:gnucash-user at gnucash.org>  <mailto:gnucash-user at gnucash.org <mailto: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

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto: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