[GNC] CSV Import Reconciled field

[Ove Grunnér]

Thanks David,


First the SW Details:
Gnucash version: 4.4
Build ID: 4.4+(2020-12-28)
Finance::Quote: 1.51
Type: Distro

Installed by "sudo apt install gnucash"
$ uname -a
Linux Conf-VirtualBox 5.13.0-21-generic #21-Ubuntu SMP Tue Oct 19 08:59:28
UTC 2021 x86_64 x86_64 x86_64 GNU/Linux
$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 21.10
Release: 21.10
Codename: impish

Running on VirtualBox on CentOS on Ryzen AMD.

Then, the Account structure, thanks for the info on Credit Card being
liability, it makes sense.
Asset:Credit Card [the "Account Type" is actually set to "Credit Card" but
the parent directory is set to "Asset", and the Name of the toplevel
account is "Asset" which is why I had shown Asset:xxxx]
Asset:Card Receipts [ this "Account Type" is set to "Asset"]

I hope having a Credit Card as a child to an Asset Account is OK???

Happy to raise a bug if it helps.

kind regards Ove.





On Tue, 16 Nov 2021 at 15:00, David Carlson <david.carlson.417 at gmail.com>
wrote:

> 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
>