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.