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.
