[GNC] CSV Import Reconciled field

Wed Nov 17 04:30:31 EST 2021

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