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.
