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 <write2...@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 <write2...@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....@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 <gmccol...@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 >>>> >>>> gmccol...@live.com <gmccol...@gyleshomes.com> email >>>> ------------------------------ >>>> *From:* gnucash-user <gnucash-user-bounces+gylemc=gmail....@gnucash.org> >>>> on behalf of David Carlson <david.carlson....@gmail.com> >>>> *Sent:* Tuesday, November 16, 2021 10:00 AM >>>> *To:* Ove Grunnér <write2...@gmail.com> >>>> *Cc:* gnucash-user <gnucash-user@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 <write2...@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@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@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@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.
