[GNC] CSV Import Reconciled field

Ove Grunnér write2ove at gmail.com
Wed Nov 17 09:43:33 EST 2021


I was considering raising a bug but I found that as David suspected it
already existed. bug 796890
<https://bugs.gnucash.org/show_bug.cgi?id=796890>

Kind regards Ove.


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

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


More information about the gnucash-user mailing list