[GNC] CSV Import Reconciled field

Wed Nov 17 09:23:15 EST 2021

Hi David, I did some more testing on Flatpack
Version: 4.8
Build ID: Flathub 4.8-1
Finance Quote: 1.49
"Edit > Preferences > Online Banking > QIF import > default transaction
status" is set to "Not cleared".

It has the same behaviour as on distro version 4.4
"Edit > Preferences > Online Banking > QIF import > default transaction
status" is set to "Not cleared".

I also noted that it is only the sub-transaction that correspond to the
first line in the multi line csv file that is set to "c", all other
sub-transactions get set to "n" as expected.
I may therefore be able to work around my specific issue by never having
the Asset:Card Receipts account as the first line in the csv import file.

Thanks also to Geert for his suggestions,

I included an example of an import file below, I hope the html table
survives any email conversions...
When I go through the import pages, there is a page called "Match
Transactions" I think you refer to this page.
here I can override any matching, by selecting one of the 3 options

   1. A (New, Already Balanced)
   2. U+C (Match Missing)
   3. C (Match Missing)

Assuming there is not already a matching transaction.
In either case, I always need to select "A" as I need to create a new
transaction.

Date Transaction_ID Number Description Notes Commodity_Currency Void_Reason
GnuCash_Action Memo Account_Name

Amount Reconciled Reconcile_Date Rate_Price
2021-11-12 A211116155857301
text more text CURRENCY::SEK
Link Memo Text Stock Alpha Account

0 n
1

Payment Memo Text Investment Account

-780 n
1

Dividend Memo Text Dividend for Alpha Stock

780 n
1

kind regards Ove.

On Wed, 17 Nov 2021 at 12:51, Ove Grunnér <write2ove at gmail.com> wrote:

> Hi David,
>
> "Edit > Preferences > Online Banking > QIF import > default transaction
> status" is set to "Not cleared".
>
> Ove.
>
>
> On Wed, 17 Nov 2021 at 09:30, David Carlson <david.carlson.417 at gmail.com>
> wrote:
>
>> Ove,
>>
>> I think one thing to check regarding the reconciliation status for newly
>> imported transactions with the CSV importer would be the Edit > Preferences
>> > Online Banking > QIF import > default transaction status to see if it is
>> still set to Cleared.  I know that should (I think) be ignored for CSV
>> imports, but there is no equivalent setting for CSV imports, at least as of
>> the 3.8 GnuCash release.  I am surprised no one has confirmed whether or
>> not it is broken in release 4.6 or 4.8.
>>
>> On Tue, Nov 16, 2021 at 9:58 AM Gyle McCollam <gmccollam at live.com> wrote:
>>
>>>
>>> I just wanted to confirm what David told you, credit cards are always a
>>> liability because it is money you owe to someone.  Being an accountant, I
>>> can tell you that is always the correct way to record the transaction.  You
>>> should debit the expanse account (Groceries, Gas (Fuel), etc.) and credit
>>> the credit card account.  Then when you get the credit card statement, you
>>> can reconcile that to the liability account (credit card) and record any
>>> receipts you may have missed during the month.
>>>
>>> Thank You,
>>> *Gyle McCollam*
>>>
>>> Gyle McCollam
>>>
>>> 609.680.2326                     Mobile
>>>
>>> gmccollam at live.com <gmccollam at gyleshomes.com>           email
>>> ------------------------------
>>> *From:* gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org>
>>> on behalf of David Carlson <david.carlson.417 at gmail.com>
>>> *Sent:* Tuesday, November 16, 2021 10:00 AM
>>> *To:* Ove Grunnér <write2ove at gmail.com>
>>> *Cc:* gnucash-user <gnucash-user at gnucash.org>
>>> *Subject:* Re: [GNC] CSV Import Reconciled field
>>>
>>> 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
>>> _______________________________________________
>>> 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
>>
>