[GNC] csv export via terminal in Ubuntu
Hello everybody, I'm looking for a way to start the csv export via terminal command. Are there solutions to work around the GUI? Or is it possible to convert all accounts and bookings directly from a .gnucash file to a .csv file per terminal? Thanks in advance -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
[GNC] Saved reports have all dissapeared since upgrade to V3
Hi all As subject line all of my save reports have gone since I upgraded from V2 to V3. Any help? Peter --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ___ 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.
Re: [GNC] V2.6.19 XML Only File Format
See https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html for details of setting up database backends. Basically it is just File ->Save As and then select the option you require provided you have the database systems installed and have the necessary permissions to create a database. This does require GnuCash to have been built with database support. This is the default and should be present, but it is really in the hands of the distribution packagers. If they have compiled GnuCash with the default settings you should be OK. David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Struggling with Quicken import
I have given up trying to create an account structure and then populating it. Instead I exported one account with transactions of a limited date range and imported it into GnuCash. I got further this time. The import created the accounts from the Quicken account/categories, showed the matches for editing and things were looking pretty good, but the actual import failed and told me there was a problem with the import. No indication of what the problem was. I looked at the only log I could find but it was not helpful, at least there were no error indicators. I don't know how to troubleshoot this. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Struggling with Quicken import
That is a fair interpretation, since that's what the wiki says. However, it would appear that the wiki is in need of some correction. I'm not sure, but that wiki language may have resulted from a writer's misunderstanding of the different import vectors, with one writer assuming that account structures would be manually entered, while another assumed that it could happen via an import. It may also be that the importer logic changed, but that is less likely. David T. On February 13, 2019, at 2:25 AM, dmacklewis wrote: No, Quicken does not have the CSV option. It has the options to export transactions, account list, category list, memorized payees and security list. I assumed GnuCash would build an account tree from an account list based on the following from the Quicken Migration wiki statement "Although it is not necessary, you may find it easier to migrate your data if you first create an account tree by exporting your Quicken categories list only, and importing it in GnuCash before any migration of transactions." I interpreted that to mean I could do the same thing with an account list. I shall try the category list route next. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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. ___ 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.
[GNC] V2.6.19 XML Only File Format
I am using a System76 Pop!_OS 18.04 LTS GnuCash 2.6.19 is available During initial setup only the XML file format is available. I have PostgreSQL on my system. Would rather use that or SQLite. How can I setup using one of those DBs? Thanks ___ 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.
Re: [GNC] Struggling with Quicken import
But this is based off transactions and I don’t think the OP wanted transactional data, just accounts. Regards, Adrien > On Feb 12, 2019, at 3:01 PM, Bucky Carr wrote: > > > Quicken2016 has a .PRN export option that looks like this: > > "Date","Num","Payee","Category","Memo","Amount","C","Balance" > "6/24/1992",,"VG - 500 Index","[Retire - VG - Rollover IRA]",,-2.50,"R",-2.50, > "9/24/1992",,"VG - 500 Index","[Retire - VG - Rollover IRA]",,-2.50,"R",-5.00, > > > Is that close enough to cvs? > > > On 2/12/2019 1:54 PM, dmacklewis wrote: >> No, Quicken does not have the CSV option. ___ 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.
Re: [GNC] Struggling with Quicken import
If you are in a mood to experiment you could try exporting as qif a limited date range of a month or so from the bank account in Quicken that should match the account you have already set up in Gnucash both with and without the account tree. Then try importing both. That might at least get all the accounts and categories that exist in those transactions. David Carlson On Tue, Feb 12, 2019, 3:04 PM Bucky Carr > Quicken2016 has a .PRN export option that looks like this: > > "Date","Num","Payee","Category","Memo","Amount","C","Balance" > "6/24/1992",,"VG - 500 Index","[Retire - VG - Rollover > IRA]",,-2.50,"R",-2.50, > "9/24/1992",,"VG - 500 Index","[Retire - VG - Rollover > IRA]",,-2.50,"R",-5.00, > > > Is that close enough to cvs? > > > On 2/12/2019 1:54 PM, dmacklewis wrote: > > No, Quicken does not have the CSV option. > > ___ > 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. > ___ 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.
Re: [GNC] Problem with Splits
Hello, I just want to apologize, somehow the subject of this thread escaped my mind maybe because the OP’s post I bit not understandable. I obviously know what split transactions are and yes, if one account remains unsplit I would go from there. Kind regards Christian Kluge Am 12.02.2019 um 21:40 schrieb Michael or Penny Novack: > On 2/12/2019 2:49 PM, Christian Kluge wrote: > > Sorry, I made the assumption that since talking about "splits" you > already knew about entering "split transactions. Your example below, > showing it as multiple transactions, indicates otherwise. So taking your > example (a $100 expense paid for by $50 cash and a $50 loan .. > > As I said, start with the UNSPLIT side. So I would enter from the > expense account, date, description, amount, and then instead of entering > the account of the other side (can't, more than one, that's what "split" > means) I would click on "split" above. > > That brings up a different view for THAT transaction. There would be a > line for the debit (the expense account) with $100 and below that a line > also with $100 but "Imbalance" since account not yet specified. I would > change the amount on that line to $50 and enter cash for the account and > hit enter. That brings up a new line below with the new balance still > unspecified, still $50 and Imbalance. I specify the account "loan" and > hit enter, now no balance remaining, and enter again restores the view > << you no longer see the split details in that view >> > > Advice --- do not shortcut and hit that last enter twice quickly. You > want to see/confirm that there was no balance for Imbalance remaining. > > THAT describes a "one sided split" transaction. Do not attempt a > transaction split on both sides until/unless you are very experienced > entering splits << entering two sided often can mean first "lying" about > an amount and correcting that only after the other side of the > transaction has been done >> > > Michael D Novack > > >> Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack: >>> On 2/11/2019 2:40 PM, Christian Kluge wrote: Hi, my general rule of thumb is to always entering from an asset or liability account. >>> The proper "general rule" for a (one side) split transaction is to >>> enter it from the side (debit or credit) that is NOT being split. That >>> this is most often either and asset or a liability account just the >>> consequence of that most often the side of the transaction not being >>> split. >>> >>> Starting with an account on the side of the transaction being split will >>> make entry almost as difficult as entering a transaction that is split >>> on both sides. >>> >>> You need an example? Say you are paying for your share of an expense X >>> and the person you are sharing with allows you to pay part in cash and >>> owe the rest. You would begin this split from the expense account (the >>> credit side being split between cash (asset) and loan (liability) >>> >> This I would enter as either three transactions: >> >> By expense to liabilities $100 >> By liabities to cash $50 >> By liabilities to loan $50 >> >> or if I assume that the loan exists even before I pay in cash: >> >> By expense to loan $100 >> By loan to cash $50 >> >> Also who wants to change accounts all the time. >> >> If I recording cash transactions I don’t go into revenue or expense >> accounts but stick with cash. >> >> I my examples above several expense/liability transactions would occur >> before I even would post the cash transaction. >> >> Kind regards >> >> Christian Kluge >> >> ___ >> 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. > > ___ 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.
Re: [GNC] Struggling with Quicken import
Quicken2016 has a .PRN export option that looks like this: "Date","Num","Payee","Category","Memo","Amount","C","Balance" "6/24/1992",,"VG - 500 Index","[Retire - VG - Rollover IRA]",,-2.50,"R",-2.50, "9/24/1992",,"VG - 500 Index","[Retire - VG - Rollover IRA]",,-2.50,"R",-5.00, Is that close enough to cvs? On 2/12/2019 1:54 PM, dmacklewis wrote: No, Quicken does not have the CSV option. ___ 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.
Re: [GNC] Struggling with Quicken import
Nope, the category import also produces nothing. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Struggling with Quicken import
No, Quicken does not have the CSV option. It has the options to export transactions, account list, category list, memorized payees and security list. I assumed GnuCash would build an account tree from an account list based on the following from the Quicken Migration wiki statement "Although it is not necessary, you may find it easier to migrate your data if you first create an account tree by exporting your Quicken categories list only, and importing it in GnuCash before any migration of transactions." I interpreted that to mean I could do the same thing with an account list. I shall try the category list route next. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] Problem with Splits
On 2/12/2019 2:49 PM, Christian Kluge wrote: Sorry, I made the assumption that since talking about "splits" you already knew about entering "split transactions. Your example below, showing it as multiple transactions, indicates otherwise. So taking your example (a $100 expense paid for by $50 cash and a $50 loan .. As I said, start with the UNSPLIT side. So I would enter from the expense account, date, description, amount, and then instead of entering the account of the other side (can't, more than one, that's what "split" means) I would click on "split" above. That brings up a different view for THAT transaction. There would be a line for the debit (the expense account) with $100 and below that a line also with $100 but "Imbalance" since account not yet specified. I would change the amount on that line to $50 and enter cash for the account and hit enter. That brings up a new line below with the new balance still unspecified, still $50 and Imbalance. I specify the account "loan" and hit enter, now no balance remaining, and enter again restores the view << you no longer see the split details in that view >> Advice --- do not shortcut and hit that last enter twice quickly. You want to see/confirm that there was no balance for Imbalance remaining. THAT describes a "one sided split" transaction. Do not attempt a transaction split on both sides until/unless you are very experienced entering splits << entering two sided often can mean first "lying" about an amount and correcting that only after the other side of the transaction has been done >> Michael D Novack Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack: On 2/11/2019 2:40 PM, Christian Kluge wrote: Hi, my general rule of thumb is to always entering from an asset or liability account. The proper "general rule" for a (one side) split transaction is to enter it from the side (debit or credit) that is NOT being split. That this is most often either and asset or a liability account just the consequence of that most often the side of the transaction not being split. Starting with an account on the side of the transaction being split will make entry almost as difficult as entering a transaction that is split on both sides. You need an example? Say you are paying for your share of an expense X and the person you are sharing with allows you to pay part in cash and owe the rest. You would begin this split from the expense account (the credit side being split between cash (asset) and loan (liability) This I would enter as either three transactions: By expense to liabilities $100 By liabities to cash $50 By liabilities to loan $50 or if I assume that the loan exists even before I pay in cash: By expense to loan $100 By loan to cash $50 Also who wants to change accounts all the time. If I recording cash transactions I don’t go into revenue or expense accounts but stick with cash. I my examples above several expense/liability transactions would occur before I even would post the cash transaction. Kind regards Christian Kluge ___ 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. -- There is no possibility of social justice on a dead planet except the equality of the grave. ___ 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.
Re: [GNC] Struggling with Quicken import
Does Quicken offer the option to export just the account tree as a CSV? You can import an account tree into GnuCash if it is in the proper CSV format. This is a fixed format, you can’t map the columns so you’ll need to likley modify the Quicken export to conform before importing. Regards, Adrien > On Feb 12, 2019, at 12:20 PM, dmacklewis wrote: > > I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file > with one account. I then exported a Quicken Deluxe 2019 QIF file containing > just the accounts. The import seems to run but when the page to 'Match QIF > accounts with GnuCash accounts' is displayed, it it empty. None of the QIF > or GnuCash accounts are listed. The import finishes with no accounts loaded. > I tried the same import with GnuCash 2.6.21-3 and got the same results. What > am I doing wrong? > ___ 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.
Re: [GNC] Problem with Splits
Am 11.02.2019 um 22:15 schrieb Michael or Penny Novack: > On 2/11/2019 2:40 PM, Christian Kluge wrote: >> Hi, >> >> my general rule of thumb is to always entering from an asset or >> liability account. >> > The proper "general rule" for a (one side) split transaction is to > enter it from the side (debit or credit) that is NOT being split. That > this is most often either and asset or a liability account just the > consequence of that most often the side of the transaction not being split. > > Starting with an account on the side of the transaction being split will > make entry almost as difficult as entering a transaction that is split > on both sides. > > You need an example? Say you are paying for your share of an expense X > and the person you are sharing with allows you to pay part in cash and > owe the rest. You would begin this split from the expense account (the > credit side being split between cash (asset) and loan (liability) > This I would enter as either three transactions: By expense to liabilities $100 By liabities to cash $50 By liabilities to loan $50 or if I assume that the loan exists even before I pay in cash: By expense to loan $100 By loan to cash $50 Also who wants to change accounts all the time. If I recording cash transactions I don’t go into revenue or expense accounts but stick with cash. I my examples above several expense/liability transactions would occur before I even would post the cash transaction. Kind regards Christian Kluge ___ 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.
Re: [GNC] Struggling with Quicken import
You can't. Qif only imports transactions. If you have no transactions then the importer will do nothing. -derek Sent using my mobile device. Please excuse any typos. On February 12, 2019 1:37:28 PM David Carlson wrote: I am not by my Gnucash right now but if I recall, there is a slightly different work path to import accounts without transactions. David Carlson On Tue, Feb 12, 2019, 12:22 PM dmacklewis I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file with one account. I then exported a Quicken Deluxe 2019 QIF file containing just the accounts. The import seems to run but when the page to 'Match QIF accounts with GnuCash accounts' is displayed, it it empty. None of the QIF or GnuCash accounts are listed. The import finishes with no accounts loaded. I tried the same import with GnuCash 2.6.21-3 and got the same results. What am I doing wrong? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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. ___ 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. ___ 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.
Re: [GNC] Struggling with Quicken import
I am not by my Gnucash right now but if I recall, there is a slightly different work path to import accounts without transactions. David Carlson On Tue, Feb 12, 2019, 12:22 PM dmacklewis I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file > with one account. I then exported a Quicken Deluxe 2019 QIF file containing > just the accounts. The import seems to run but when the page to 'Match QIF > accounts with GnuCash accounts' is displayed, it it empty. None of the QIF > or GnuCash accounts are listed. The import finishes with no accounts > loaded. > I tried the same import with GnuCash 2.6.21-3 and got the same results. > What > am I doing wrong? > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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. > ___ 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.
[GNC] Struggling with Quicken import
I installed Gnucash 3.4.1 on MacOS High Sierra 10.13.6 and created a file with one account. I then exported a Quicken Deluxe 2019 QIF file containing just the accounts. The import seems to run but when the page to 'Match QIF accounts with GnuCash accounts' is displayed, it it empty. None of the QIF or GnuCash accounts are listed. The import finishes with no accounts loaded. I tried the same import with GnuCash 2.6.21-3 and got the same results. What am I doing wrong? -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ 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.
Re: [GNC] accrual of property tax payments
> On Feb 12, 2019, at 11:47 AM, Keith Bellairs wrote: > > Thanks, Derek. The issue has been around for years, I guess. > > Looking at invoices, for a cash basis user the invoice should get posted to > payables when received and the payable is reversed to expense on the date > the payment is actually made. The question here is posted to ‘payables’ and ‘what else?’ Every transaction must have (at least) two splits. In the paper world, a cash-basis entity would not even enter any transaction for a received bill until it is paid.(their ‘payables’ would be kept separate from the actual books) What would need to happen in GnuCash is the option to mark a bill as ‘cash basis’ when entering it. This would set the posting date as the date it is paid, but still allow the ‘due reminder’ to fire, and GC would have to maintain a separate list of ‘due bills’ from A/P since it technically can’t be entered there. (unless some one finagles some sort of virtual account for the purpose) > > For an accrual basis user the expense could be posted immediately to the > (past, present, or future) "due date". If it's in the future it won't show > up in current P, which is correct. Accrued means it is already incurred, so it wouldn’t necessarily (if ever) be posted to the due date. It should be posted likely on receipt or an even earlier date if applicable, that is, in the period the expense was incurred. > I found that I could not edit the > dates on the expense transactions that were created by the business logic, > so all 4 quarters show up as expenses on the day I posted the invoice. That > doesn't seem right in anyone's world. > You can’t edit the expense transactions if you posted the bill to expense in the line items. They are part of the bill and that is the only place you can edit it. This is for safety. You could make a mess if you were able to edit portions of a bill, outside of the bill itself. If you really need to edit a bill that is posted, you have to first un-post it. But beware that even though you can put dates on line items, those do not affect posting or transaction dates. The entire bill gets a single posting date of your choosing. Those line item dates are merely reference for you or your customer. (if speaking of invoices) Again, having all four quarters show up in one year being ‘right’ depends on your situation. If this is merely a ‘payment plan’ then it is correct. The entire bill is owed now, and thus is an expense in its entirety, now, but they allow you to pay it over 4 quarters. If you were to sell the property mid-way, who does the town legally think owes the taxes? But by all means, speak to a local CPA to get a definitive answer on how to book this. ___ 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.
Re: [GNC] Can't delete security
Thanks for the tip(s)! I had forgotten that GC automatically creates a "Trading" account. After deleting that and the inital price ntry created by the first transaction, I could delete the security. On 12.02.19 18:30, Maf. King wrote: On Tuesday, 12 February 2019 17:27:20 GMT rsbrux via gnucash-user wrote: @anyone, How can I find out which account GnuCash thinks is using this security? It occurred to me that I might be able to find out by doing a text search of the GnuCash file, as I have understood that it is XML. However, I cannot open it in mousepad, as it complains that the encoding is not UTF-8. Any hints as to how to proceed would be most welcome. the data file is probably zip-compressed. Either untick the GC pref to save as compressed, or run it through gunzip (you probably need to change the extension first) HTH, Maf ___ 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.
Re: [GNC] Which report for date limited account transactions?
On Tue, 12 Feb 2019, Adrien Monteleone wrote: That doesn’t apply if using the Transaction Report. If you were following the advice to run an Account Report *after* first filtering that particular register, then I was advising to add to the workflow a step to remove the filter on that register. Adrien, I thought this to be the case and why I asked for clarification. Best regards, Rich ___ 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.
Re: [GNC] Which report for date limited account transactions?
That doesn’t apply if using the Transaction Report. If you were following the advice to run an Account Report *after* first filtering that particular register, then I was advising to add to the workflow a step to remove the filter on that register. Regards, Adrien > On Feb 12, 2019, at 11:36 AM, Rich Shepard wrote: > > On Tue, 12 Feb 2019, Adrien Monteleone wrote: > >> Don’t forget to clear the filter after running the report or down the road >> you might be wondering why you aren’t seeing a bunch of transactions. >> (there is an indicator, but it is easily missed) > > Adrien, > > I'm not following you; perhaps we're looking at two different work flows. > What I've done is this: > > Select Reports -> Transaction Report > Set report title, display type, and date range in General tab > Find the appropriate account in the Account tab > Click the Make PDF button > Specify `print to file`, modify the default file name and directory > Print the report > > Which filter should I clear? > > Regards, > > Rich ___ 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.
Re: [GNC] accrual of property tax payments
Thanks, Derek. The issue has been around for years, I guess. Looking at invoices, for a cash basis user the invoice should get posted to payables when received and the payable is reversed to expense on the date the payment is actually made. For an accrual basis user the expense could be posted immediately to the (past, present, or future) "due date". If it's in the future it won't show up in current P, which is correct. I found that I could not edit the dates on the expense transactions that were created by the business logic, so all 4 quarters show up as expenses on the day I posted the invoice. That doesn't seem right in anyone's world. But the invoice logic is overkill for me. I'll go back to scheduled transactions. For my purposes scheduling 4 transactions is fine. Keith On Mon, Feb 11, 2019 at 5:23 PM Derek Atkins wrote: > Keith Bellairs writes: > > > My property tax is payable in 4 installments -- August, November, > February, > > and May. I have tried to set this up with my town as the vendor and 4 > > payments. > > > > When I ran my income statement for last year, I see that the future > > liabilities have been posted with the date that the bill was posted, not > > the date that the bill is due. So all of my 2019 payments show as tax > > expense in 2018. > > > > Is there a way to have the vendor bills show up dated with the due date > > instead of the date posted? > > See: https://bugs.gnucash.org/show_bug.cgi?id=95700 > > This is talking about customer invoices, but vendor bills use the same > logic. Note the date of the bug report. > > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > -derek > > -- >Derek Atkins 617-623-3745 >de...@ihtfp.com www.ihtfp.com >Computer and Internet Security Consultant > ___ 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.
Re: [GNC] Which report for date limited account transactions?
On Tue, 12 Feb 2019, Adrien Monteleone wrote: Don’t forget to clear the filter after running the report or down the road you might be wondering why you aren’t seeing a bunch of transactions. (there is an indicator, but it is easily missed) Adrien, I'm not following you; perhaps we're looking at two different work flows. What I've done is this: Select Reports -> Transaction Report Set report title, display type, and date range in General tab Find the appropriate account in the Account tab Click the Make PDF button Specify `print to file`, modify the default file name and directory Print the report Which filter should I clear? Regards, Rich ___ 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.
Re: [GNC] Can't delete security
Hi, Did you uncompress the XML file before trying to open it? -derek On Tue, February 12, 2019 12:27 pm, rsbrux wrote: > @Derek, > Many thanks for your advice. Believe me, I've tried. Unfortunately, it > is a mystery to me why any account should still be using this security. > As mentioned below, I have deleted both the initial transaction and the > investment account I created for the security. I don't know why any > other account should reference it. > > @anyone, > How can I find out which account GnuCash thinks is using this security? > It occurred to me that I might be able to find out by doing a text > search of the GnuCash file, as I have understood that it is XML. > However, I cannot open it in mousepad, as it complains that the encoding > is not UTF-8. > Any hints as to how to proceed would be most welcome. > > -Original Message- > From: Derek Atkins > Sent: Tuesday, February 12, 2019 4:46 PM > To: rsbrux via gnucash-user > Cc: rsbrux > Subject: Re: [GNC] Can't delete security > > Hi, > > rsbrux via gnucash-user writes: > >> Because of the well-known difficulties associated with assigning the >> correct currency to a security, I need to delete and recreate a >> security. I have deleted the initial transaction I created for this >> security, as well as the investment account I created for the >> transaction. Nonetheless, when I try to "Remove" the security from >> the "Security Editor", I get the message: >> >> "That commodity is currently used by at least one of your accounts. >> You may not delete it." >> >> I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 >> >> How can I correct this? > > Do what it's telling you. Delete the account that is using the commodity. > > GnuCash wont let you delete something that is referenced by another > object. > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
Re: [GNC] Can't delete security
You might have set the preference to compress the file. Either uncompress it from your file manager before opening, or unset the preference and perform another save from within GnuCash. Regards, Adrien > On Feb 12, 2019, at 11:27 AM, rsbrux via gnucash-user > wrote: > > @Derek, > Many thanks for your advice. Believe me, I've tried. Unfortunately, it is a > mystery to me why any account should still be using this security. As > mentioned below, I have deleted both the initial transaction and the > investment account I created for the security. I don't know why any other > account should reference it. > > @anyone, > How can I find out which account GnuCash thinks is using this security? It > occurred to me that I might be able to find out by doing a text search of the > GnuCash file, as I have understood that it is XML. However, I cannot open it > in mousepad, as it complains that the encoding is not UTF-8. > Any hints as to how to proceed would be most welcome. > > -Original Message- > From: Derek Atkins > Sent: Tuesday, February 12, 2019 4:46 PM > To: rsbrux via gnucash-user > Cc: rsbrux > Subject: Re: [GNC] Can't delete security > > Hi, > > rsbrux via gnucash-user writes: > >> Because of the well-known difficulties associated with assigning the >> correct currency to a security, I need to delete and recreate a >> security. I have deleted the initial transaction I created for this >> security, as well as the investment account I created for the >> transaction. Nonetheless, when I try to "Remove" the security from >> the "Security Editor", I get the message: >> >> "That commodity is currently used by at least one of your accounts. >> You may not delete it." >> >> I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 >> >> How can I correct this? > > Do what it's telling you. Delete the account that is using the commodity. > > GnuCash wont let you delete something that is referenced by another object. > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > ___ > 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. > ___ 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.
Re: [GNC] Which report for date limited account transactions?
Don’t forget to clear the filter after running the report or down the road you might be wondering why you aren’t seeing a bunch of transactions. (there is an indicator, but it is easily missed) Regards, Adrien > On Feb 12, 2019, at 10:39 AM, Rich Shepard wrote: > > On Tue, 12 Feb 2019, David T. wrote: > >> You have numerous options. If you’re going the Account Report method, >> first filter your account for the date range you want and then trigger the >> report. > > David, > > This is what Geert recommended. Hadn't thought of doing this. > >> Otherwise, use the transaction report and select your account and date >> range there. > > I like this. > > Thanks, both of you, > > Rich ___ 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.
Re: [GNC] Can't delete security
@Derek, Many thanks for your advice. Believe me, I've tried. Unfortunately, it is a mystery to me why any account should still be using this security. As mentioned below, I have deleted both the initial transaction and the investment account I created for the security. I don't know why any other account should reference it. @anyone, How can I find out which account GnuCash thinks is using this security? It occurred to me that I might be able to find out by doing a text search of the GnuCash file, as I have understood that it is XML. However, I cannot open it in mousepad, as it complains that the encoding is not UTF-8. Any hints as to how to proceed would be most welcome. -Original Message- From: Derek Atkins Sent: Tuesday, February 12, 2019 4:46 PM To: rsbrux via gnucash-user Cc: rsbrux Subject: Re: [GNC] Can't delete security Hi, rsbrux via gnucash-user writes: Because of the well-known difficulties associated with assigning the correct currency to a security, I need to delete and recreate a security. I have deleted the initial transaction I created for this security, as well as the investment account I created for the transaction. Nonetheless, when I try to "Remove" the security from the "Security Editor", I get the message: "That commodity is currently used by at least one of your accounts. You may not delete it." I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 How can I correct this? Do what it's telling you. Delete the account that is using the commodity. GnuCash wont let you delete something that is referenced by another object. Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
Re: [GNC] Which report for date limited account transactions?
On Tue, 12 Feb 2019, Rich Shepard wrote: Otherwise, use the transaction report and select your account and date range there. I like this. As a follow up suggestion, it would be nice if GnuCash remembers the directory in which to print the PDF file based on the previous one used. Now, each time the default is shown (here it's ~/workspace/gnucash/). Regards, Rich ___ 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.
[GNC] Setting counter formats
Hello all, I am unable to set the invoice counter format in GnuCash 3.4 on OSX 10.14 (Mojave) while using the XML backend (I have not tried with SQL). When I reopen File > Preferences after entering a format and clicking OK, my edits are gone, and new invoices inherit the default nn format. Is there a workaround for getting this set, such as a manual addition to the .gnucash xml file? I had been able to set counters in earlier versions of Gnucash. Thanks, Ron ___ 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.
Re: [GNC] Which report for date limited account transactions?
On Tue, 12 Feb 2019, David T. wrote: You have numerous options. If you’re going the Account Report method, first filter your account for the date range you want and then trigger the report. David, This is what Geert recommended. Hadn't thought of doing this. Otherwise, use the transaction report and select your account and date range there. I like this. Thanks, both of you, Rich ___ 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.
Re: [GNC] Which report for date limited account transactions?
Rich, You have numerous options. If you’re going the Account Report method, first filter your account for the date range you want and then trigger the report. Otherwise, use the transaction report and select your account and date range there. Of course, you could use the Tax Options to set your various accounts and then use the TXF report… HTH, David > On Feb 12, 2019, at 9:35 PM, Rich Shepard wrote: > > Running Build ID: 3.4+ (2018-12-30) on Slackware-14.2. > > Preparing to send my account 2018 tax information and I've encountered a > problem: when I print an Account Report as a PDF the options do not allow me > to specify a date range, only the appearance of the report and which columns > to include. > > To limit the report of, for example, mortgage interest payments in 2018 > which report format should I apply? > > TIA, > > Rich > ___ > 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. ___ 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.
Re: [GNC] Which report for date limited account transactions?
Op dinsdag 12 februari 2019 17:05:41 CET schreef Rich Shepard: > Running Build ID: 3.4+ (2018-12-30) on Slackware-14.2. > > Preparing to send my account 2018 tax information and I've encountered a > problem: when I print an Account Report as a PDF the options do not allow me > to specify a date range, only the appearance of the report and which > columns to include. > > To limit the report of, for example, mortgage interest payments in 2018 > which report format should I apply? I think the easiest is to start from the account register in which the transactions appear. Then apply a filter to this register and finally choose Reports->Account Report. The report should honor the filter you have applied to the register. Regards, Geert ___ 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.
Re: [GNC] Importing Quicekn Files
Sorry, yeah QXF != QFX. QFX/OFX is readable. QXF is not. -derek On Tue, February 12, 2019 11:04 am, Dan Black wrote: > QFX is a download format, designed for import of transactions from your > bank into a single Quicken account. ... QXF is an encrypted file transfer > format designed to move entire Quicken databases with multiple accounts > from Windows to Mac or visa versa. > > On February 12, 2019 10:46:36 AM Derek Atkins wrote: > >> David Carlson writes: >> >>> I just peeked at Quicken 2019 and they also have a QXF file format >>> which >>> does not work for GnuCash either. I did not have time to figure out >>> what >>> they do use that format for. For us it is another tree in the forest. >> >> Are you sure? QXF should be readable by the OFX importer. >> >>> David Carlson >> >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> -derek >> >> -- >> Derek Atkins 617-623-3745 >> de...@ihtfp.com www.ihtfp.com >> Computer and Internet Security Consultant >> ___ >> 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. > > > > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
[GNC] Which report for date limited account transactions?
Running Build ID: 3.4+ (2018-12-30) on Slackware-14.2. Preparing to send my account 2018 tax information and I've encountered a problem: when I print an Account Report as a PDF the options do not allow me to specify a date range, only the appearance of the report and which columns to include. To limit the report of, for example, mortgage interest payments in 2018 which report format should I apply? TIA, Rich ___ 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.
Re: [GNC] Importing Quicekn Files
QFX is a download format, designed for import of transactions from your bank into a single Quicken account. ... QXF is an encrypted file transfer format designed to move entire Quicken databases with multiple accounts from Windows to Mac or visa versa. On February 12, 2019 10:46:36 AM Derek Atkins wrote: > David Carlson writes: > >> I just peeked at Quicken 2019 and they also have a QXF file format which >> does not work for GnuCash either. I did not have time to figure out what >> they do use that format for. For us it is another tree in the forest. > > Are you sure? QXF should be readable by the OFX importer. > >> David Carlson > >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > ___ > 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. ___ 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.
Re: [GNC] Can't delete security
Hi, rsbrux via gnucash-user writes: > Because of the well-known difficulties associated with assigning the > correct currency to a security, I need to delete and recreate a > security. I have deleted the initial transaction I created for this > security, as well as the investment account I created for the > transaction. Nonetheless, when I try to "Remove" the security from > the "Security Editor", I get the message: > > "That commodity is currently used by at least one of your > accounts. You may not delete it." > > I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 > > How can I correct this? Do what it's telling you. Delete the account that is using the commodity. GnuCash wont let you delete something that is referenced by another object. > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
Re: [GNC] Importing Quicekn Files
David Carlson writes: > I just peeked at Quicken 2019 and they also have a QXF file format which > does not work for GnuCash either. I did not have time to figure out what > they do use that format for. For us it is another tree in the forest. Are you sure? QXF should be readable by the OFX importer. > David Carlson > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ 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.
Re: [GNC] Importing Quicekn Files
There is a difference between QXF and QFX formats. Ken Schneider > On Feb 12, 2019, at 8:45 AM, David Carlson > wrote: > > I just peeked at Quicken 2019 and they also have a QXF file format which > does not work for GnuCash either. I did not have time to figure out what > they do use that format for. For us it is another tree in the forest. > > David Carlson > >> On Mon, Feb 11, 2019 at 11:23 PM John Ralls wrote: >> >> >> >>> On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user < >> gnucash-user@gnucash.org> wrote: >>> >>> I am a new user and just tried to import my Quicken files following the >> instructions. However, My files are saved as .QDF files, not .QIF and I >> get a wrong format error message when I try to import them. >>> >>> >>> I would appreciate any suggestions for fixing this. >> >> You must export them as QIF or QFX files. GnuCash doesn't know how to read >> QDF. >> >> Regards, >> John Ralls >> >> ___ >> 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. >> > ___ > 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. > ___ 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.
Re: [GNC] Importing Quicekn Files
I just peeked at Quicken 2019 and they also have a QXF file format which does not work for GnuCash either. I did not have time to figure out what they do use that format for. For us it is another tree in the forest. David Carlson On Mon, Feb 11, 2019 at 11:23 PM John Ralls wrote: > > > > On Feb 11, 2019, at 12:28 PM, David Seltzer via gnucash-user < > gnucash-user@gnucash.org> wrote: > > > > I am a new user and just tried to import my Quicken files following the > instructions. However, My files are saved as .QDF files, not .QIF and I > get a wrong format error message when I try to import them. > > > > > > I would appreciate any suggestions for fixing this. > > You must export them as QIF or QFX files. GnuCash doesn't know how to read > QDF. > > Regards, > John Ralls > > ___ > 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. > ___ 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.
Re: [GNC] transaction imported do not show up
Do not overlook the possibility that you may be looking in the wrong file for the fresh data. Usually it is easiest to employ a file manager to look for data files that have the correct name and recent date stamps. David Carlson On Mon, Feb 11, 2019 at 11:20 PM David Cousens wrote: > Anatoly > > What version of GNuCash are you using and on what platform > (Linux/Windows/MacOS)? > > How were you trying to import your data from the bank? Directly using an > on-line connection or by downloading a datafile and then importing that > file > into GnuCash? > > If the latter what was the format of the data file? > > While there is online support for direct download from a bank from within > GnuCash, this is not necessarily available from all banks or in many > countries. > > Other options usually available are to download OFX/QFX files, QIF files, > CSV files. Of these the first are generally easiest to import provided the > bank has got the OFX format right. Not all do. > > David Cousens > > > > - > David Cousens > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > ___ > 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. > ___ 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.
Re: [GNC] SMTP TLS -- Re: Liabilities and Net Worth in Android app
It reachd the list. > On Feb 11, 2019, at 4:58 PM, Derek Atkins wrote: > > humming.b...@posteo.net writes: > >> Dear Derek, >> >> if this email reaches the list, then TLS is working. > > Considering you sent it to me *and* the list, I have no way to confirm. > My tests seem to imply it is working. ;) > >> Cheers >> Chris > > -derek > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > ___ > 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. ___ 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.
Re: [GNC] Backup recovery
On Tuesday, 12 February 2019 12:09:22 GMT Finbar Mahon wrote: > Well, I hope I understood all that. > > I did a save as in a new folder called GNU FEB 12 2019, >Saved all the > open accounts, >closed them, >quit and then reopened GNUcash. > > Voila, afaics, a file opened called GNU FEB12 2019.gnucash and it > contains the last transactions, so far so good. > > Just have to remember to save and quit ?? > Yay! Glad it is back to sane behaviour. Saving your work before quitting is always worth considering :-) Maf. ___ 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.
Re: [GNC] Backup recovery
Well, I hope I understood all that. I did a save as in a new folder called GNU FEB 12 2019, >Saved all the open accounts, >closed them, >quit and then reopened GNUcash. Voila, afaics, a file opened called GNU FEB12 2019.gnucash and it contains the last transactions, so far so good. Just have to remember to save and quit ?? Thanks again, Finbar On 11/02/2019 15:10, Maf. King wrote: Good luck, Maf. ___ 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.
[GNC] Can't delete security
Because of the well-known difficulties associated with assigning the correct currency to a security, I need to delete and recreate a security. I have deleted the initial transaction I created for this security, as well as the investment account I created for the transaction. Nonetheless, when I try to "Remove" the security from the "Security Editor", I get the message: "That commodity is currently used by at least one of your accounts. You may not delete it." I am using GnuCash 2.6.19 running under Ubuntu Studio 18.04 How can I correct this? ___ 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.
Re: [GNC] Version 3.4 Mac OS - intermittent fault with transaction editing popup
> On 11 Feb 2019, at 18:59, Adrien Monteleone > wrote: > > All context menus for me on a Mac have a ‘lag’ or delay on some or all items > in the menu. At most this lasts about 2 seconds. In most cases it is only one > menu entry (consistently a ‘delete’ variant) that doesn’t seem to want to be > highlighted while the others are all responsive right away. I haven’t had to > move the mouse off the menu, I just move up and down and it eventually ‘wakes > up.’ > > Not sure if that is related. > > Regards, > Adrien > >> >> That’s the one! >> >> I’m having great trouble reproducing it this afternoon, and hadn’t >> discovered the move-the-pointer trick on the inert popup. >> >> But I have discovered that moving the cursor just outside the top of an >> active popup (i.e. one which does highlight the options) may make it inert >> when the cursor is brought back in. >> >> Michael I’m not suffering from the delay mentioned by Adrien, but I’ve noticed another couple of oddities in the user interface. It’s not possible to use Cmd-back-apostrophe to switch between two windows opened by the same instance of GC - this was present in 2.6.. versions too - so it’s necessary to click on the other window to give it focus. In 2.6… any part of the window could be clicked, so it was possible to enter new transactions during a reconciliation (for example). I’ve found that in 3.4 it’s necessary to click the Title Bar. Clicking the content of a window brings it to the front, but leaves it largely unresponsive. Switching to the account being reconciled in this way makes it impossible to edit the date of a new transaction, but possible to enter the rest. Switching back to the Reconciliation Window by clicking on the content leaves the window unresponsive, with the tick marks for already-reconciled transactions greyed out. In the short term, there is a simple work-around - always click on the Title Bar. It’s not clear whether this change from 2.6… arises from a change in the GC code itself, or in the window management code it uses. Michael ___ 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.
Re: [GNC] Problem after upgrade from 2.6.14 to 3.x, bookings of an account are cut off
Hello, does anyone have suggestions how to trace the fault further? even if I launch gnucash with "gnucash --log "=debug" --log "gnc.backend.dbi=debug" --log "qof=debug" --log "gnc=debug", I do not get anything on STDOUT or STDERR.. Logs are by default written to https://wiki.gnucash.org/wiki/Tracefile. Use --logto=foo to change that; stdout and stderr are special values of foo that do what you'd expect, otherwise foo is expected to be a file path. I just figured that out.. but first of all the problem: in the account/bookings view gnucash shows me only entries until a specific date. all newer and newly created bookings are not being shown. But there are bookings in the MySQL (respecitvely MariaDB) databases. I see there all corresponding transactions and splits. the corresponding bookings in the other accounts are shown. I migrated to 3.x by exporting the book into xml, but in this file(s) the contents are already missing. I have a backup of the database (which worked fine until gnucash 2.6.14. But if I open that database using gnucash 3.3 or 3.4 those data are not shown. currently: Version: 3.4 Build ID: 3.4+ (2018-12-30) Finance::Quote: 1.47 using the command-line option --debug doesn't show any database related information or exceptions. As a first guess you have a filter set. Select View>Filter By... and make sure that "Show All" is selected on the date tab. In fact that was he cause... I already invested 2 days in the last month, loooking for errors, trying to restore database backups... Thank you very much... I didn't note that word "Filtered" on top right. Regards, Paul ___ 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.