[GNC] CSV Import Reconciled field

Tue Nov 16 14:11:44 EST 2021

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.417 at 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.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> >
>> 
>> To: Ove Grunn?r <write2ove at gmail.com <mailto:write2ove at gmail.com> >
>> 
>> Cc: gnucash-user <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+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
>> <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>
>> 
>>> 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
>> 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
> 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.