[GNC] CSV Import Reconciled field

Wed Nov 17 07:51:06 EST 2021

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
>