Re: [GNC] How to "Get Quotes" for a specific day?
I've used Google sheets to retrieve prices which can be imported into GnuCash. In the referenced message, it should be simple to set whatever date you want. https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html David T. On Dec 30, 2022, 7:48 AM, at 7:48 AM, Geoff wrote: >No. > >As far as I know the Finance::Quote module that GnuCash uses has no >provision to fetch historical prices. > >If you are into scripting and web scraping, checkout Selenium which has > >a nice Python interface. > >Good luck! > >Geoff >= >P.S. Always include gnucash-user@gnucash.org on all correspondence. > >On 30/12/2022 3:23 pm, gnucash_2...@michaelaltfield.net wrote: >>> 2. Import from a CSV file:- >>>(File / Import / Import prices from a CSV file) >> >> OK, Is there a way that I can generate this CSV file using >`gnc-fq-dump` or `gnucash-cli` or similar so that I can script >something to fetch/generate a CSV file and then import that CSV file >for all my stocks for a specific date? >> >> On Fri, Dec 30, 2022 at 03:25:02PM +1100, Geoff wrote: >>> Hi Michael >>> >>> You can't do this. >>> >>> Alternatives:- >>> 1. Key the prices directly into the Price Database:- >>> (Tools / Price Data Database / Add) >>> 2. Import from a CSV file:- >>> (File / Import / Import prices from a CSV file) >>> >>> Historical prices are available from, inter alia, >https://finance.yahoo.com/ >>> >>> >>> Regards >>> >>> Geoff >>> = >>> >>> On 30/12/2022 3:06 pm, gnucash_2...@michaelaltfield.net wrote: How can I tell GNU Cash to update its "Price Database" for all >known currencies, stocks, bonds, mutual funds, etc for a *specific* >day? I'm trying trying to prepare a report for a date in the past. I've >set the `Options` for the report to `nearest in time` so that it will >grab the prices for the commodities from the Price Database that are >closest to the date of the report as possible. * >https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports Well, I checked the Price Database, and I have gaps in the prices >for some of my stocks. For many stocks, I don't have any prices defined >for the day of the report. Therefore, my report may be inaccurate. I know that I can go to `Tools` -> `Price Database` and click the >`Get Quotes` button. This will fetch the current quote (price) and add >it to the Price Database for all defined currencies, stocks, bonds, >mutual funds, etc. But that will fetch and add the prices for *today's >date* only. How can I do the equivalent of `Get Quotes` but for a specific day >in the *past*? (see also >https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 >- >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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
I'm sure he read what you wrote and assumed you were running Gnucash 4.12 on MacOS Ventura :-) If not please advise OS and Gnucash version. If that is indeed the case check out https://lists.gnucash.org/pipermail/gnucash-user/2022-November/103465.html and https://gitlab.gnome.org/GNOME/gtk/-/issues/5305#note_1592320 for all the gory details. Basically popups passed the mouse clicks etc through to the underlying register. Fixed in 4.13 thanks goodness. Regards David H. On Fri, 30 Dec 2022 at 13:47, Thomas Forrester wrote: > I guess you didn't read what I wrote. So, let me say it again (via the > magic of copy/paste): > > "I was right-clicking on a transaction in the right (credit) column. It > was already highlighted, and there was no other transaction highlighted. > The right-click context menu appeared alongside the mouse pointer which was > positioned on the highlighted credit transaction. From that menu I > selected and confirmed the delete of the highlighted credit transaction. A > debit transaction was deleted instead." > > Reverting to a backup after doing as much work as I had leading up to that > reconciliation in that session would have been a multitude of times more > painful. Bad stuff always happens after lots of other stuff has happened - > Murphy's Law. The backup is for truly catastrophic stuff, or maybe if > you're just lucky and haven't done anything else yet. > > This is hardly and interface error. And checking the 4.13 change log > reveals nothing addressing this or any related reconciliation bug. The > known issues list doesn't even identify it. I don't think it's on anyone's > radar. > > On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > That sounds like a GTK bug. You were raising a context menu on what was > > selected, not where the mouse pointer was located. If you had a line in > > the left pane selected, that is what got deleted. > > > > Maybe reverting to a backup file and making it your main file would be > > in order for restoring your books to a sane state then starting the > > reconciliation over. > > > > As for the bug, I suppose you can file it, but I wouldn't be surprised > > if it is a GTK rather than GnuCash problem. > > > > But before you do, try GnuCash 4.13 first. I think the GTK version was > > just bumped on that release. > > > > Regards, > > Adrien > > > > On 12/29/22 3:36 PM, Thomas Forrester wrote: > > > I was reconciling several credit card statements for the same card and > > had > > > noticed that a subscription payment I had set up as an automatic entry > > was > > > showing up even though I had canceled the subscription. Clearly, I > > hadn't > > > discontinued the automatic transaction entry in GnuCash. I ignored > > several > > > of the subscription transactions while reconciling, but then I thought > I > > > might as well just delete them in the Reconcile screen since you can > > > right-click and delete transactions right there. With the first ot 3 > of > > > the transactions highlighted, I right-clicked on it and selected > > delete. I > > > clicked OK to the confirmation message affirming I was sure I wanted to > > > delete the transaction. I rather mindlessly repeated that action a > couple > > > of times, then realized the transactions weren't deleting. Much to my > > > horror, I realized transactions on the left (debit) column for the > > > reconciliation was getting shorter, not the right (credit) column where > > the > > > highlighted item I was trying to delete was. > > > > > > Again, I'm going to stress this: I was right-clicking on a transaction > in > > > the right (credit) column. It was already highlighted, and there was > no > > > other transaction highlighted. The right-click context menu appeared > > > alongside the mouse pointer which was positioned on the highlighted > > credit > > > transaction. From that menu I selected and confirmed the delete of the > > > highlighted credit transaction. A debit transaction was deleted > instead. > > > > > > Obviously, this is not correct behavior. > > > > > > This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB > backend. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > - > 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
Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
I just performed a trivial test in release 4.8 (Build ID: 4.8a+(2021-09-28) in Lubuntu 22.04 by adding a bogus transaction to a register then saving the file, opening the reconciliation window, right clicking the desired split in the right panel of the reconciliation window, and clicking delete. The correct entire transaction was deleted. So, from my perspective, if the current release does not work the same way, there has been a regression since 4.8. On Thu, Dec 29, 2022 at 11:08 PM David Carlson wrote: > I haven't needed to do a reconciliation yet since this thread started, but > perhaps in the next few days. > > In the meantime, I didn't even realize that you could right click split > lines in that screen and do things. If that works successfully, wonderful. > > I have always used the menu to navigate to the transaction in the register > view and perform my edits there. > > Finally, I subscribe to the theory to save a backup just before starting > any significant activity such as a reconciliation or import. That is one > reason I am not using a database file format and I won't until the > application has a way to undo several recent actions. My cat does > occasionally walk across the keyboard. > > On Thu, Dec 29, 2022, 9:47 PM Thomas Forrester > wrote: > >> I guess you didn't read what I wrote. So, let me say it again (via the >> magic of copy/paste): >> >> "I was right-clicking on a transaction in the right (credit) column. It >> was already highlighted, and there was no other transaction highlighted. >> The right-click context menu appeared alongside the mouse pointer which >> was >> positioned on the highlighted credit transaction. From that menu I >> selected and confirmed the delete of the highlighted credit transaction. >> A >> debit transaction was deleted instead." >> >> Reverting to a backup after doing as much work as I had leading up to that >> reconciliation in that session would have been a multitude of times more >> painful. Bad stuff always happens after lots of other stuff has happened >> - >> Murphy's Law. The backup is for truly catastrophic stuff, or maybe if >> you're just lucky and haven't done anything else yet. >> >> This is hardly and interface error. And checking the 4.13 change log >> reveals nothing addressing this or any related reconciliation bug. The >> known issues list doesn't even identify it. I don't think it's on >> anyone's >> radar. >> >> On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone < >> adrien.montele...@lusfiber.net> wrote: >> >> > That sounds like a GTK bug. You were raising a context menu on what was >> > selected, not where the mouse pointer was located. If you had a line in >> > the left pane selected, that is what got deleted. >> > >> > Maybe reverting to a backup file and making it your main file would be >> > in order for restoring your books to a sane state then starting the >> > reconciliation over. >> > >> > As for the bug, I suppose you can file it, but I wouldn't be surprised >> > if it is a GTK rather than GnuCash problem. >> > >> > But before you do, try GnuCash 4.13 first. I think the GTK version was >> > just bumped on that release. >> > >> > Regards, >> > Adrien >> > >> > On 12/29/22 3:36 PM, Thomas Forrester wrote: >> > > I was reconciling several credit card statements for the same card and >> > had >> > > noticed that a subscription payment I had set up as an automatic entry >> > was >> > > showing up even though I had canceled the subscription. Clearly, I >> > hadn't >> > > discontinued the automatic transaction entry in GnuCash. I ignored >> > several >> > > of the subscription transactions while reconciling, but then I >> thought I >> > > might as well just delete them in the Reconcile screen since you can >> > > right-click and delete transactions right there. With the first ot 3 >> of >> > > the transactions highlighted, I right-clicked on it and selected >> > delete. I >> > > clicked OK to the confirmation message affirming I was sure I wanted >> to >> > > delete the transaction. I rather mindlessly repeated that action a >> couple >> > > of times, then realized the transactions weren't deleting. Much to my >> > > horror, I realized transactions on the left (debit) column for the >> > > reconciliation was getting shorter, not the right (credit) column >> where >> > the >> > > highlighted item I was trying to delete was. >> > > >> > > Again, I'm going to stress this: I was right-clicking on a >> transaction in >> > > the right (credit) column. It was already highlighted, and there was >> no >> > > other transaction highlighted. The right-click context menu appeared >> > > alongside the mouse pointer which was positioned on the highlighted >> > credit >> > > transaction. From that menu I selected and confirmed the delete of >> the >> > > highlighted credit transaction. A debit transaction was deleted >> instead. >> > > >> > > Obviously, this is not correct behavior. >> > > >> > > This is GnuCash 4.11 Build
Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
I haven't needed to do a reconciliation yet since this thread started, but perhaps in the next few days. In the meantime, I didn't even realize that you could right click split lines in that screen and do things. If that works successfully, wonderful. I have always used the menu to navigate to the transaction in the register view and perform my edits there. Finally, I subscribe to the theory to save a backup just before starting any significant activity such as a reconciliation or import. That is one reason I am not using a database file format and I won't until the application has a way to undo several recent actions. My cat does occasionally walk across the keyboard. On Thu, Dec 29, 2022, 9:47 PM Thomas Forrester wrote: > I guess you didn't read what I wrote. So, let me say it again (via the > magic of copy/paste): > > "I was right-clicking on a transaction in the right (credit) column. It > was already highlighted, and there was no other transaction highlighted. > The right-click context menu appeared alongside the mouse pointer which was > positioned on the highlighted credit transaction. From that menu I > selected and confirmed the delete of the highlighted credit transaction. A > debit transaction was deleted instead." > > Reverting to a backup after doing as much work as I had leading up to that > reconciliation in that session would have been a multitude of times more > painful. Bad stuff always happens after lots of other stuff has happened - > Murphy's Law. The backup is for truly catastrophic stuff, or maybe if > you're just lucky and haven't done anything else yet. > > This is hardly and interface error. And checking the 4.13 change log > reveals nothing addressing this or any related reconciliation bug. The > known issues list doesn't even identify it. I don't think it's on anyone's > radar. > > On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > That sounds like a GTK bug. You were raising a context menu on what was > > selected, not where the mouse pointer was located. If you had a line in > > the left pane selected, that is what got deleted. > > > > Maybe reverting to a backup file and making it your main file would be > > in order for restoring your books to a sane state then starting the > > reconciliation over. > > > > As for the bug, I suppose you can file it, but I wouldn't be surprised > > if it is a GTK rather than GnuCash problem. > > > > But before you do, try GnuCash 4.13 first. I think the GTK version was > > just bumped on that release. > > > > Regards, > > Adrien > > > > On 12/29/22 3:36 PM, Thomas Forrester wrote: > > > I was reconciling several credit card statements for the same card and > > had > > > noticed that a subscription payment I had set up as an automatic entry > > was > > > showing up even though I had canceled the subscription. Clearly, I > > hadn't > > > discontinued the automatic transaction entry in GnuCash. I ignored > > several > > > of the subscription transactions while reconciling, but then I thought > I > > > might as well just delete them in the Reconcile screen since you can > > > right-click and delete transactions right there. With the first ot 3 > of > > > the transactions highlighted, I right-clicked on it and selected > > delete. I > > > clicked OK to the confirmation message affirming I was sure I wanted to > > > delete the transaction. I rather mindlessly repeated that action a > couple > > > of times, then realized the transactions weren't deleting. Much to my > > > horror, I realized transactions on the left (debit) column for the > > > reconciliation was getting shorter, not the right (credit) column where > > the > > > highlighted item I was trying to delete was. > > > > > > Again, I'm going to stress this: I was right-clicking on a transaction > in > > > the right (credit) column. It was already highlighted, and there was > no > > > other transaction highlighted. The right-click context menu appeared > > > alongside the mouse pointer which was positioned on the highlighted > > credit > > > transaction. From that menu I selected and confirmed the delete of the > > > highlighted credit transaction. A debit transaction was deleted > instead. > > > > > > Obviously, this is not correct behavior. > > > > > > This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB > backend. > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > -
Re: [GNC] How to "Get Quotes" for a specific day?
No. As far as I know the Finance::Quote module that GnuCash uses has no provision to fetch historical prices. If you are into scripting and web scraping, checkout Selenium which has a nice Python interface. Good luck! Geoff = P.S. Always include gnucash-user@gnucash.org on all correspondence. On 30/12/2022 3:23 pm, gnucash_2...@michaelaltfield.net wrote: 2. Import from a CSV file:- (File / Import / Import prices from a CSV file) OK, Is there a way that I can generate this CSV file using `gnc-fq-dump` or `gnucash-cli` or similar so that I can script something to fetch/generate a CSV file and then import that CSV file for all my stocks for a specific date? On Fri, Dec 30, 2022 at 03:25:02PM +1100, Geoff wrote: Hi Michael You can't do this. Alternatives:- 1. Key the prices directly into the Price Database:- (Tools / Price Data Database / Add) 2. Import from a CSV file:- (File / Import / Import prices from a CSV file) Historical prices are available from, inter alia, https://finance.yahoo.com/ Regards Geoff = On 30/12/2022 3:06 pm, gnucash_2...@michaelaltfield.net wrote: How can I tell GNU Cash to update its "Price Database" for all known currencies, stocks, bonds, mutual funds, etc for a *specific* day? I'm trying trying to prepare a report for a date in the past. I've set the `Options` for the report to `nearest in time` so that it will grab the prices for the commodities from the Price Database that are closest to the date of the report as possible. * https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports Well, I checked the Price Database, and I have gaps in the prices for some of my stocks. For many stocks, I don't have any prices defined for the day of the report. Therefore, my report may be inaccurate. I know that I can go to `Tools` -> `Price Database` and click the `Get Quotes` button. This will fetch the current quote (price) and add it to the Price Database for all defined currencies, stocks, bonds, mutual funds, etc. But that will fetch and add the prices for *today's date* only. How can I do the equivalent of `Get Quotes` but for a specific day in the *past*? (see also https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] How to "Get Quotes" for a specific day?
Hi Michael You can't do this. Alternatives:- 1. Key the prices directly into the Price Database:- (Tools / Price Data Database / Add) 2. Import from a CSV file:- (File / Import / Import prices from a CSV file) Historical prices are available from, inter alia, https://finance.yahoo.com/ Regards Geoff = On 30/12/2022 3:06 pm, gnucash_2...@michaelaltfield.net wrote: How can I tell GNU Cash to update its "Price Database" for all known currencies, stocks, bonds, mutual funds, etc for a *specific* day? I'm trying trying to prepare a report for a date in the past. I've set the `Options` for the report to `nearest in time` so that it will grab the prices for the commodities from the Price Database that are closest to the date of the report as possible. * https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports Well, I checked the Price Database, and I have gaps in the prices for some of my stocks. For many stocks, I don't have any prices defined for the day of the report. Therefore, my report may be inaccurate. I know that I can go to `Tools` -> `Price Database` and click the `Get Quotes` button. This will fetch the current quote (price) and add it to the Price Database for all defined currencies, stocks, bonds, mutual funds, etc. But that will fetch and add the prices for *today's date* only. How can I do the equivalent of `Get Quotes` but for a specific day in the *past*? (see also https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] How to "Get Quotes" for a specific day?
How can I tell GNU Cash to update its "Price Database" for all known currencies, stocks, bonds, mutual funds, etc for a *specific* day? I'm trying trying to prepare a report for a date in the past. I've set the `Options` for the report to `nearest in time` so that it will grab the prices for the commodities from the Price Database that are closest to the date of the report as possible. * https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports Well, I checked the Price Database, and I have gaps in the prices for some of my stocks. For many stocks, I don't have any prices defined for the day of the report. Therefore, my report may be inaccurate. I know that I can go to `Tools` -> `Price Database` and click the `Get Quotes` button. This will fetch the current quote (price) and add it to the Price Database for all defined currencies, stocks, bonds, mutual funds, etc. But that will fetch and add the prices for *today's date* only. How can I do the equivalent of `Get Quotes` but for a specific day in the *past*? (see also https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash) ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
I guess you didn't read what I wrote. So, let me say it again (via the magic of copy/paste): "I was right-clicking on a transaction in the right (credit) column. It was already highlighted, and there was no other transaction highlighted. The right-click context menu appeared alongside the mouse pointer which was positioned on the highlighted credit transaction. From that menu I selected and confirmed the delete of the highlighted credit transaction. A debit transaction was deleted instead." Reverting to a backup after doing as much work as I had leading up to that reconciliation in that session would have been a multitude of times more painful. Bad stuff always happens after lots of other stuff has happened - Murphy's Law. The backup is for truly catastrophic stuff, or maybe if you're just lucky and haven't done anything else yet. This is hardly and interface error. And checking the 4.13 change log reveals nothing addressing this or any related reconciliation bug. The known issues list doesn't even identify it. I don't think it's on anyone's radar. On Thu, Dec 29, 2022 at 4:28 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > That sounds like a GTK bug. You were raising a context menu on what was > selected, not where the mouse pointer was located. If you had a line in > the left pane selected, that is what got deleted. > > Maybe reverting to a backup file and making it your main file would be > in order for restoring your books to a sane state then starting the > reconciliation over. > > As for the bug, I suppose you can file it, but I wouldn't be surprised > if it is a GTK rather than GnuCash problem. > > But before you do, try GnuCash 4.13 first. I think the GTK version was > just bumped on that release. > > Regards, > Adrien > > On 12/29/22 3:36 PM, Thomas Forrester wrote: > > I was reconciling several credit card statements for the same card and > had > > noticed that a subscription payment I had set up as an automatic entry > was > > showing up even though I had canceled the subscription. Clearly, I > hadn't > > discontinued the automatic transaction entry in GnuCash. I ignored > several > > of the subscription transactions while reconciling, but then I thought I > > might as well just delete them in the Reconcile screen since you can > > right-click and delete transactions right there. With the first ot 3 of > > the transactions highlighted, I right-clicked on it and selected > delete. I > > clicked OK to the confirmation message affirming I was sure I wanted to > > delete the transaction. I rather mindlessly repeated that action a couple > > of times, then realized the transactions weren't deleting. Much to my > > horror, I realized transactions on the left (debit) column for the > > reconciliation was getting shorter, not the right (credit) column where > the > > highlighted item I was trying to delete was. > > > > Again, I'm going to stress this: I was right-clicking on a transaction in > > the right (credit) column. It was already highlighted, and there was no > > other transaction highlighted. The right-click context menu appeared > > alongside the mouse pointer which was positioned on the highlighted > credit > > transaction. From that menu I selected and confirmed the delete of the > > highlighted credit transaction. A debit transaction was deleted instead. > > > > Obviously, this is not correct behavior. > > > > This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scrubbing workflow
Correct. You need to scrub each Account separately. Geoff = On 30/12/2022 1:57 pm, m...@tgr66.me wrote: Assuming one creates a separate account to track each stock (for example, “Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub for each symbol? Or am I misunderstanding and it *should* work at the “Joint Brokerage” level? On Dec 29, 2022, at 20:04, Geoff wrote: Hi Tim Lot scrubbing has nothing to do with internationali[sz]ation. It is just one possible method** to match your buys and sells for a particular stock account and thus calculate your gains and losses. Each sale transaction is applied consecutively to each buy transaction, and the capital gain (or loss) on each such match is calculated and stored as a separate transaction in the stock account. Note that scrubbing works on a "FIFO" basis (first in , first out) which may or may not be what you want to do. If you have three stock accounts, you will have to scrub each of them separately. There is no "easier way". Note that the process is completely reversible - you can manually delete the capital gain/loss transactions and start over. You don't have to remember which sales have been scrubbed, the scrubbing process will just pick up any unapplied sales next time you run it. **The other method is to manually match your sales to your buys one lot at a time. Hope this helps. Regards Geoff = On 30/12/2022 11:00 am, m...@tgr66.me wrote: I searched the mailing list and didn’t really get any hits from the past six years, so I’m starting a new thread. I understand the concept of lots, and I *think* I understand _why_ GnuCash uses the scrubbing concept (i.e., internationalization?). In any case, I’m a little worried about the work flow as I implement GnuCash. Let’s say I perform a number of trades of stocks in any given month, but I don’t remember when sells I’ve scrubbed, and which I haven’t. How do I tell which ones need to be done? Go through each symbol (could easily be 30 or more total over three accounts)? Just curious if I”m missing an easier way? Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scrubbing workflow
Assuming one creates a separate account to track each stock (for example, “Joint Brokerage:AAPL” and “Joint Brokerage:AMZN” doesn’t a user have to scrub for each symbol? Or am I misunderstanding and it *should* work at the “Joint Brokerage” level? > On Dec 29, 2022, at 20:04, Geoff wrote: > > Hi Tim > > Lot scrubbing has nothing to do with internationali[sz]ation. It is just one > possible method** to match your buys and sells for a particular stock account > and thus calculate your gains and losses. > > Each sale transaction is applied consecutively to each buy transaction, and > the capital gain (or loss) on each such match is calculated and stored as a > separate transaction in the stock account. > > Note that scrubbing works on a "FIFO" basis (first in , first out) which may > or may not be what you want to do. > > If you have three stock accounts, you will have to scrub each of them > separately. There is no "easier way". > > Note that the process is completely reversible - you can manually delete the > capital gain/loss transactions and start over. > > You don't have to remember which sales have been scrubbed, the scrubbing > process will just pick up any unapplied sales next time you run it. > > > **The other method is to manually match your sales to your buys one lot at a > time. > > > Hope this helps. > > Regards > > Geoff > = > > > On 30/12/2022 11:00 am, m...@tgr66.me wrote: >> I searched the mailing list and didn’t really get any hits from the past six >> years, so I’m starting a new thread. >> I understand the concept of lots, and I *think* I understand _why_ GnuCash >> uses the scrubbing concept (i.e., internationalization?). >> In any case, I’m a little worried about the work flow as I implement GnuCash. >> Let’s say I perform a number of trades of stocks in any given month, but I >> don’t remember when sells I’ve scrubbed, and which I haven’t. How do I tell >> which ones need to be done? Go through each symbol (could easily be 30 or >> more total over three accounts)? >> Just curious if I”m missing an easier way? >> Tim >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scrubbing workflow
Hi Tim Lot scrubbing has nothing to do with internationali[sz]ation. It is just one possible method** to match your buys and sells for a particular stock account and thus calculate your gains and losses. Each sale transaction is applied consecutively to each buy transaction, and the capital gain (or loss) on each such match is calculated and stored as a separate transaction in the stock account. Note that scrubbing works on a "FIFO" basis (first in , first out) which may or may not be what you want to do. If you have three stock accounts, you will have to scrub each of them separately. There is no "easier way". Note that the process is completely reversible - you can manually delete the capital gain/loss transactions and start over. You don't have to remember which sales have been scrubbed, the scrubbing process will just pick up any unapplied sales next time you run it. **The other method is to manually match your sales to your buys one lot at a time. Hope this helps. Regards Geoff = On 30/12/2022 11:00 am, m...@tgr66.me wrote: I searched the mailing list and didn’t really get any hits from the past six years, so I’m starting a new thread. I understand the concept of lots, and I *think* I understand _why_ GnuCash uses the scrubbing concept (i.e., internationalization?). In any case, I’m a little worried about the work flow as I implement GnuCash. Let’s say I perform a number of trades of stocks in any given month, but I don’t remember when sells I’ve scrubbed, and which I haven’t. How do I tell which ones need to be done? Go through each symbol (could easily be 30 or more total over three accounts)? Just curious if I”m missing an easier way? Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 237, Issue 113
It’s no biggie changing the date and many programs default on the.current date or the last entered. It’s fine with me if you just leave it alone. Besides, unless I’m mistaken, when I pull in a QFX, the system uses the date it cleared the bank, not the date entered or written. > On Dec 29, 2022, at 6:48 PM, Fross, Michael wrote: > > Hi Chris, > > I, too, enter the receipts immediately. If I buy something online, it's > actually exactly the same time as the purchase. If it's a real store, it > gets entered once I'm home. Having it default to "today" is the right > answer for me. > > Michael > >> On Thu, Dec 29, 2022 at 5:23 PM Chris Skudder >> wrote: >> >> FWIW, I'm another who enters most txn's on the same day I make them. >> IMHO, one of the great and beautiful advantages of GnuCash over >> Quickbooks Online (which I must use to do our church's accounts) - is >> that GC opens basically instantaneously. There's no network latency, no >> login, no "let's make sure it's really you" and "let's verify your cell >> number," no clicking thru "Don't you want to sign up for our payroll >> service, and our credit card processing service" and Lord knows what >> else, before I can do what "I" want to do, versus what Intuit wants me >> to do. >> For me, I can open the computer from standby, open GnuCash, enter the >> txn, and stash the receipt "off the deck" somewhere, quite a bit faster >> than try to find receipts later, find time, remember what they're for, >> + etc. >> Realizing everybody's different ... but my own 1 vote is to keep the >> date default "today", or at least to give a user the OPTION to default >> txn dates to today. >> So hooray for open source software, and for the talented and dedicated >> peep's who do the coding that I don't know how to do. >> Thank you to you all. >> Chris >> __ >> >> From: [1]gnucash-user-requ...@gnucash.org >> Sent: Thursday, December 29, 2022, 12:00 PM >> To: [2]gnucash-user@gnucash.org >> Subject: gnucash-user Digest, Vol 237, Issue 113 >> >> On 12/28/2022 11:11 AM, R Losey wrote: >> >> That would be an interesting poll (about when one enters data) >> >> References >> >> 1. mailto:gnucash-user-requ...@gnucash.org >> 2. mailto:gnucash-user@gnucash.org >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 237, Issue 113
Hi Chris, I, too, enter the receipts immediately. If I buy something online, it's actually exactly the same time as the purchase. If it's a real store, it gets entered once I'm home. Having it default to "today" is the right answer for me. Michael On Thu, Dec 29, 2022 at 5:23 PM Chris Skudder wrote: >FWIW, I'm another who enters most txn's on the same day I make them. >IMHO, one of the great and beautiful advantages of GnuCash over >Quickbooks Online (which I must use to do our church's accounts) - is >that GC opens basically instantaneously. There's no network latency, no >login, no "let's make sure it's really you" and "let's verify your cell >number," no clicking thru "Don't you want to sign up for our payroll >service, and our credit card processing service" and Lord knows what >else, before I can do what "I" want to do, versus what Intuit wants me >to do. >For me, I can open the computer from standby, open GnuCash, enter the >txn, and stash the receipt "off the deck" somewhere, quite a bit faster >than try to find receipts later, find time, remember what they're for, >+ etc. >Realizing everybody's different ... but my own 1 vote is to keep the >date default "today", or at least to give a user the OPTION to default >txn dates to today. >So hooray for open source software, and for the talented and dedicated >peep's who do the coding that I don't know how to do. >Thank you to you all. >Chris > __ > >From: [1]gnucash-user-requ...@gnucash.org >Sent: Thursday, December 29, 2022, 12:00 PM >To: [2]gnucash-user@gnucash.org >Subject: gnucash-user Digest, Vol 237, Issue 113 > > On 12/28/2022 11:11 AM, R Losey wrote: > > That would be an interesting poll (about when one enters data) > > References > >1. mailto:gnucash-user-requ...@gnucash.org >2. mailto:gnucash-user@gnucash.org > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Scrubbing workflow
I searched the mailing list and didn’t really get any hits from the past six years, so I’m starting a new thread. I understand the concept of lots, and I *think* I understand _why_ GnuCash uses the scrubbing concept (i.e., internationalization?). In any case, I’m a little worried about the work flow as I implement GnuCash. Let’s say I perform a number of trades of stocks in any given month, but I don’t remember when sells I’ve scrubbed, and which I haven’t. How do I tell which ones need to be done? Go through each symbol (could easily be 30 or more total over three accounts)? Just curious if I”m missing an easier way? Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] gnucash-user Digest, Vol 237, Issue 113
FWIW, I'm another who enters most txn's on the same day I make them. IMHO, one of the great and beautiful advantages of GnuCash over Quickbooks Online (which I must use to do our church's accounts) - is that GC opens basically instantaneously. There's no network latency, no login, no "let's make sure it's really you" and "let's verify your cell number," no clicking thru "Don't you want to sign up for our payroll service, and our credit card processing service" and Lord knows what else, before I can do what "I" want to do, versus what Intuit wants me to do. For me, I can open the computer from standby, open GnuCash, enter the txn, and stash the receipt "off the deck" somewhere, quite a bit faster than try to find receipts later, find time, remember what they're for, + etc. Realizing everybody's different ... but my own 1 vote is to keep the date default "today", or at least to give a user the OPTION to default txn dates to today. So hooray for open source software, and for the talented and dedicated peep's who do the coding that I don't know how to do. Thank you to you all. Chris __ From: [1]gnucash-user-requ...@gnucash.org Sent: Thursday, December 29, 2022, 12:00 PM To: [2]gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 237, Issue 113 On 12/28/2022 11:11 AM, R Losey wrote: That would be an interesting poll (about when one enters data) References 1. mailto:gnucash-user-requ...@gnucash.org 2. mailto:gnucash-user@gnucash.org ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
That sounds like a GTK bug. You were raising a context menu on what was selected, not where the mouse pointer was located. If you had a line in the left pane selected, that is what got deleted. Maybe reverting to a backup file and making it your main file would be in order for restoring your books to a sane state then starting the reconciliation over. As for the bug, I suppose you can file it, but I wouldn't be surprised if it is a GTK rather than GnuCash problem. But before you do, try GnuCash 4.13 first. I think the GTK version was just bumped on that release. Regards, Adrien On 12/29/22 3:36 PM, Thomas Forrester wrote: I was reconciling several credit card statements for the same card and had noticed that a subscription payment I had set up as an automatic entry was showing up even though I had canceled the subscription. Clearly, I hadn't discontinued the automatic transaction entry in GnuCash. I ignored several of the subscription transactions while reconciling, but then I thought I might as well just delete them in the Reconcile screen since you can right-click and delete transactions right there. With the first ot 3 of the transactions highlighted, I right-clicked on it and selected delete. I clicked OK to the confirmation message affirming I was sure I wanted to delete the transaction. I rather mindlessly repeated that action a couple of times, then realized the transactions weren't deleting. Much to my horror, I realized transactions on the left (debit) column for the reconciliation was getting shorter, not the right (credit) column where the highlighted item I was trying to delete was. Again, I'm going to stress this: I was right-clicking on a transaction in the right (credit) column. It was already highlighted, and there was no other transaction highlighted. The right-click context menu appeared alongside the mouse pointer which was positioned on the highlighted credit transaction. From that menu I selected and confirmed the delete of the highlighted credit transaction. A debit transaction was deleted instead. Obviously, this is not correct behavior. This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Deleting Transaction from Reconcile Deletes Wrong Transaction
I was reconciling several credit card statements for the same card and had noticed that a subscription payment I had set up as an automatic entry was showing up even though I had canceled the subscription. Clearly, I hadn't discontinued the automatic transaction entry in GnuCash. I ignored several of the subscription transactions while reconciling, but then I thought I might as well just delete them in the Reconcile screen since you can right-click and delete transactions right there. With the first ot 3 of the transactions highlighted, I right-clicked on it and selected delete. I clicked OK to the confirmation message affirming I was sure I wanted to delete the transaction. I rather mindlessly repeated that action a couple of times, then realized the transactions weren't deleting. Much to my horror, I realized transactions on the left (debit) column for the reconciliation was getting shorter, not the right (credit) column where the highlighted item I was trying to delete was. Again, I'm going to stress this: I was right-clicking on a transaction in the right (credit) column. It was already highlighted, and there was no other transaction highlighted. The right-click context menu appeared alongside the mouse pointer which was positioned on the highlighted credit transaction. From that menu I selected and confirmed the delete of the highlighted credit transaction. A debit transaction was deleted instead. Obviously, this is not correct behavior. This is GnuCash 4.11 Build ID: 4.11+(2022-06-25) using a MariaDB backend. Thank you, Tom Thomas L. Forrester Middleton, WI USA ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Feature request - prevent a transaction with todays date
Two items: I understand what you wrote about legally tendering something, but I was thinking of mailing bills... I may write them on Monday, and drop them into the mail, but until the mail is received by the creditor, it isn't paid. But yes, I have looked at US IRS regulations, and (for example), a charitable contribution is considered made on the date you give it, not when the organization caches it. When I enter past transactions, the initial date is 'today', but every subsequent entry defaults to the date I last used (until I restart GnuCash) On Wed, Dec 28, 2022 at 3:16 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > On 12/28/22 10:07 AM, R Losey wrote: > > While that is technically true, I enter credit card charges on the day I > > use the card, not when it clears... ditto for writing checks, and I > suspect > > most people do it that way. > Those generally *are* the days payment is legally made. When you hand > over a check, that is an act of 'tendering'. The fact that the banking > system doesn't clear it immediately or even that the recipient doesn't > present it for payment immediately does not matter to your books. (save > to later reconcile cleared items) And to be pedantic, the date on the > check is the actual tendering date, if later than the current calendar > date. (hence the term 'post dated check') > > With respect the Cards, the situation is similar but with usually > shorter lag times. Merchants usually submit pending charges in batches > at close of day or at a set time. The money appears in their account > next day or maybe 72hours later. Your account with the Card issuer is > affected immediately. > > But Michael is referring to the possible situation where you don't enter > transactions on those same days, instead, you may enter them a week or > even months later. The day you make the entry is not relevant. The day > the transaction occurred, is. > > The OP's issue is with GnuCash reverting to 'today' as a default when > entering batches of historical transactions as being cumbersome. > > As I and others have noted, we don't observe that behavior, so it is > possibly a work-flow issue. > > Regards, > Adrien > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Date format for QIF file
The supported formats are, IIRC: y-m-d y-d-m d-m-y m-d-y Every time you start an import it will begin with the full list and use the dates in the file to rule out from the list; if there remains more than one once all the file is loaded, then it asks you. If the set is empty once the file is loaded, then it raises an error. -derek On Thu, December 29, 2022 3:30 pm, Peter West wrote: > I did. My question remains. What are the formats? For example, is > /MM/DD supported? What, exactly, does NN/NN/(NN)NN mean? In my corner > of the world, NN/NN/(NN)NN is taken to mean DD/MM/(YY)YY. In the US, it > means MM/DD/(YY)YY, apparently. It is surprising to me that an unambiguous > QIF date spec like dd monthname year is not supported. > — > Peter West > p...@pbw.id.au > And the angel said to them, “Fear not, for behold, I bring you good news > of great joy that will be for all the people. For unto you is born this > day in the city of David a Saviour, who is Christ the Lord. And this will > be a sign for you: you will find a baby wrapped in swaddling cloths and > lying in a manger.” > >> On 30 Dec 2022, at 6:18 am, Dan Black wrote: >> >> If you read Derek's reply again, he stated that you must use numbers >> only; month names are not acceptable. >> >> Dan >> >> On December 29, 2022 3:14:02 PM Peter West wrote: >> >>> What date formats ARE supported by the GNC QIF import process? 29 >>> December 2022 is unambiguous, but apparently unsupported by GNC. >>> >>> Happy 6th day of Christmas! >>> >>> — >>> Peter West >>> p...@pbw.id.au >>> And the angel said to them, “Fear not, for behold, I bring you good >>> news of great joy that will be for all the people. For unto you is born >>> this day in the city of David a Saviour, who is Christ the Lord. And >>> this will be a sign for you: you will find a baby wrapped in swaddling >>> cloths and lying in a manger.” >>> On 30 Dec 2022, at 4:55 am, Derek Atkins wrote: Not particularly. The issue is that 11/12 is ambiguous. Is it November 12 or December 11? Using a 2-digit year doesn't help. The best way is to ensure you have a day > 12 in the mix (and a year > 31). So using 12/29/2022 should give you a unique format. You cannot use month names, only numbers. -derek Sent using my mobile device. Please excuse any typos. On December 29, 2022 14:35:09 m...@tgr66.me wrote: > I’m developing QIF files to import my old investments. I get asked > every time to confirm the date format (the entire import process is a > bit long imo). The QIF specification says I ought to be able to enter > a date using `dd month year`; for example: 29 December 2022. However, > this results in an error in GnuCash. > > Is there a format I can use in the files that GnuCash will accurately > autodetect the correct format? > > Thanks. > > Tim > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 - 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 >>> - >>> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Date format for QIF file
If you read Derek's reply again, he stated that you must use numbers only; month names are not acceptable. Dan On December 29, 2022 3:14:02 PM Peter West wrote: What date formats ARE supported by the GNC QIF import process? 29 December 2022 is unambiguous, but apparently unsupported by GNC. Happy 6th day of Christmas! — Peter West p...@pbw.id.au And the angel said to them, “Fear not, for behold, I bring you good news of great joy that will be for all the people. For unto you is born this day in the city of David a Saviour, who is Christ the Lord. And this will be a sign for you: you will find a baby wrapped in swaddling cloths and lying in a manger.” On 30 Dec 2022, at 4:55 am, Derek Atkins wrote: Not particularly. The issue is that 11/12 is ambiguous. Is it November 12 or December 11? Using a 2-digit year doesn't help. The best way is to ensure you have a day > 12 in the mix (and a year > 31). So using 12/29/2022 should give you a unique format. You cannot use month names, only numbers. -derek Sent using my mobile device. Please excuse any typos. On December 29, 2022 14:35:09 m...@tgr66.me wrote: I’m developing QIF files to import my old investments. I get asked every time to confirm the date format (the entire import process is a bit long imo). The QIF specification says I ought to be able to enter a date using `dd month year`; for example: 29 December 2022. However, this results in an error in GnuCash. Is there a format I can use in the files that GnuCash will accurately autodetect the correct format? Thanks. Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - 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 - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Date format for QIF file
What date formats ARE supported by the GNC QIF import process? 29 December 2022 is unambiguous, but apparently unsupported by GNC. Happy 6th day of Christmas! — Peter West p...@pbw.id.au And the angel said to them, “Fear not, for behold, I bring you good news of great joy that will be for all the people. For unto you is born this day in the city of David a Saviour, who is Christ the Lord. And this will be a sign for you: you will find a baby wrapped in swaddling cloths and lying in a manger.” > On 30 Dec 2022, at 4:55 am, Derek Atkins wrote: > > Not particularly. > The issue is that 11/12 is ambiguous. Is it November 12 or December 11? > Using a 2-digit year doesn't help. > The best way is to ensure you have a day > 12 in the mix (and a year > 31). > So using 12/29/2022 should give you a unique format. > You cannot use month names, only numbers. > -derek > Sent using my mobile device. Please excuse any typos. > On December 29, 2022 14:35:09 m...@tgr66.me wrote: > >> I’m developing QIF files to import my old investments. I get asked every >> time to confirm the date format (the entire import process is a bit long >> imo). The QIF specification says I ought to be able to enter a date using >> `dd month year`; for example: 29 December 2022. However, this results in an >> error in GnuCash. >> >> Is there a format I can use in the files that GnuCash will accurately >> autodetect the correct format? >> >> Thanks. >> >> Tim >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Date format for QIF file
Thank you Derek, I understood *why* it was happening, and I do realize that in reality, as the file size grows, the chance of having all days <= 12 is pretty darn slim :-) I appreciate the quick response. Tim > On Dec 29, 2022, at 12:55, Derek Atkins wrote: > > Not particularly. > The issue is that 11/12 is ambiguous. Is it November 12 or December 11? > Using a 2-digit year doesn't help. > The best way is to ensure you have a day > 12 in the mix (and a year > 31). > So using 12/29/2022 should give you a unique format. > You cannot use month names, only numbers. > -derek > Sent using my mobile device. Please excuse any typos. > > On December 29, 2022 14:35:09 m...@tgr66.me wrote: > >> I’m developing QIF files to import my old investments. I get asked every >> time to confirm the date format (the entire import process is a bit long >> imo). The QIF specification says I ought to be able to enter a date using >> `dd month year`; for example: 29 December 2022. However, this results in an >> error in GnuCash. >> >> Is there a format I can use in the files that GnuCash will accurately >> autodetect the correct format? >> >> Thanks. >> >> Tim >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> - >> 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Date format for QIF file
Not particularly. The issue is that 11/12 is ambiguous. Is it November 12 or December 11? Using a 2-digit year doesn't help. The best way is to ensure you have a day > 12 in the mix (and a year > 31). So using 12/29/2022 should give you a unique format. You cannot use month names, only numbers. -derek Sent using my mobile device. Please excuse any typos. On December 29, 2022 14:35:09 m...@tgr66.me wrote: I’m developing QIF files to import my old investments. I get asked every time to confirm the date format (the entire import process is a bit long imo). The QIF specification says I ought to be able to enter a date using `dd month year`; for example: 29 December 2022. However, this results in an error in GnuCash. Is there a format I can use in the files that GnuCash will accurately autodetect the correct format? Thanks. Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Central Bank Digital Currencies (CBDC)
On 2022-12-29 09:03, Adrien Monteleone wrote: > Such restrictions would have no bearing as to if they should be separate > or not. It has nothing to do with GnuCash or even accounting. > > If the respective governments simply treat them as equivalent to paper, > coins, or other current digital blips, then they likely will not get > separate currency codes. > > Since separate currency codes would be quite messy for the ISO group > responsible, and thus for implementing CBDCs at all, I highly doubt they > will be treated separately by authorities. > > However, none of that is of concern to GnuCash. Your question depends on > what various governments end up doing in the future. Until they > implement, there is little point in speculating, and zero point in > altering code, or even thinking about it as there is no 'target'. Amen! My first reaction was "what does this have to do with GnuCash"? I see I'm not alone in that! Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Date format for QIF file
I’m developing QIF files to import my old investments. I get asked every time to confirm the date format (the entire import process is a bit long imo). The QIF specification says I ought to be able to enter a date using `dd month year`; for example: 29 December 2022. However, this results in an error in GnuCash. Is there a format I can use in the files that GnuCash will accurately autodetect the correct format? Thanks. Tim ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Central Bank Digital Currencies (CBDC)
hi David With the roll out of ISO 20022 from March 2023 we hope to see more digital assets complying with the protocol ( if i remember there were around 10 of them already compliant). Morover CBDC will take advantage of this to enable cross border transfers. Swift had already announced that they have completed pilot program where they are able to support CBDC-CBDC and Fiat-CBDC transfers by existing participants. GNUCash already allows you to create your own securities and account for it. You may use the same till you want an ISO code for digital assets. Saludos Cordiales Murugan From: gnucash-user on behalf of Dr. David Kirkby Sent: Thursday, December 29, 2022 1:15 PM To: LI Daobing Cc: GNU Cash User Subject: Re: [GNC] Central Bank Digital Currencies (CBDC) On Thu, 29 Dec 2022 at 07:15, LI Daobing wrote: > CBDCs also can constrain the usage of money. like some money can only be > used to pay rent, and some other money can only be used to buy food. > All the more reason that I don’t like them. However, that gives a greater need to be able to consider them as separate assets, so I feel GnuCash should allow people to add other currencies, and not restrict currencies to those defined in an ISO standard. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Central Bank Digital Currencies (CBDC)
Such restrictions would have no bearing as to if they should be separate or not. It has nothing to do with GnuCash or even accounting. If the respective governments simply treat them as equivalent to paper, coins, or other current digital blips, then they likely will not get separate currency codes. Since separate currency codes would be quite messy for the ISO group responsible, and thus for implementing CBDCs at all, I highly doubt they will be treated separately by authorities. However, none of that is of concern to GnuCash. Your question depends on what various governments end up doing in the future. Until they implement, there is little point in speculating, and zero point in altering code, or even thinking about it as there is no 'target'. Regards, Adrien On 12/29/22 10:15 AM, Dr. David Kirkby wrote: On Thu, 29 Dec 2022 at 07:15, LI Daobing wrote: CBDCs also can constrain the usage of money. like some money can only be used to pay rent, and some other money can only be used to buy food. All the more reason that I don’t like them. However, that gives a greater need to be able to consider them as separate assets, so I feel GnuCash should allow people to add other currencies, and not restrict currencies to those defined in an ISO standard. Dave ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Central Bank Digital Currencies (CBDC)
On Thu, 29 Dec 2022 at 07:15, LI Daobing wrote: > CBDCs also can constrain the usage of money. like some money can only be > used to pay rent, and some other money can only be used to buy food. > All the more reason that I don’t like them. However, that gives a greater need to be able to consider them as separate assets, so I feel GnuCash should allow people to add other currencies, and not restrict currencies to those defined in an ISO standard. Dave -- Dr. David Kirkby, Kirkby Microwave Ltd, drkir...@kirkbymicrowave.co.uk https://www.kirkbymicrowave.co.uk/ Telephone 01621-680100./ +44 1621 680100 Registered in England & Wales, company number 08914892. Registered office: Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote v1.54 Released
Murugan - I am suspecting it is likely a bug between GNC and the Perl module interface. I have not used currency exchanges so far thus I am not familiar with that part of the function or help in troubleshooting. -- Original Message -- Received: Thu, 29 Dec 2022 09:54:23 AM EST From: Murugan Muruganandam To: "Frank H. Ellenberger" , Bruce Schuck , "gnucash-user@gnucash.org" , Kalpesh Patel Subject: Re: [GNC] Finance::Quote v1.54 Released > thanks Kalpesh, Frank > I read the help page but as Kalpesh pointed out, it was not clear that it updates without any intervention. > i took the install online route and it perfectly installed 1.54 > > I have a issue though, Couple of currency rates are not getting updated in GNUcash when i run through the front end, the same i am able to see the latest prices when i query from the command line ( i am using windows). Is there any specifics i am missing. currency pairs are USD/CLP and CLF/CLP > Please note it used to work without any issues earlier. > > > > > Saludos Cordiales > > > Murugan > > > From: Frank H. Ellenberger > Sent: Wednesday, December 28, 2022 5:05 PM > To: Murugan Muruganandam ; Bruce Schuck ; gnucash-user@gnucash.org > Subject: Re: [GNC] Finance::Quote v1.54 Released > > Hi all, > > recently C. Wehling has added the chapter > https://www.gnucash.org/docs/v4/C/gnucash-help/finance-quote.html > to thhe manual. It should explain it for all OSes. > > HTH > Frank > > Am 28.12.22 um 19:52 schrieb Murugan Muruganandam: > > hi bruce > > > > thanks, how can i update 1.54 in windows > > > > > > > > > > Saludos Cordiales > > > > > > Murugan > > > > > > From: gnucash-user on behalf of Bruce Schuck > > Sent: Tuesday, December 27, 2022 12:28 AM > > To: gnucash-user@gnucash.org ; gnucash-de...@gnucash.org > > Subject: [GNC] Finance::Quote v1.54 Released > > > > Finance::Quote v1.54 has been released and uploaded to CPAN. > > > > https://metacpan.org/release/BPSCHUCK/Finance-Quote-1.54 > > > > https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54.tar.gz > > > > https://github.com/finance-quote/finance-quote > > > > Thank you. > > > > - Bruce S. > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > - > > 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 > > - > > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Finance::Quote v1.54 Released
thanks Kalpesh, Frank I read the help page but as Kalpesh pointed out, it was not clear that it updates without any intervention. i took the install online route and it perfectly installed 1.54 I have a issue though, Couple of currency rates are not getting updated in GNUcash when i run through the front end, the same i am able to see the latest prices when i query from the command line ( i am using windows). Is there any specifics i am missing. currency pairs are USD/CLP and CLF/CLP Please note it used to work without any issues earlier. Saludos Cordiales Murugan From: Frank H. Ellenberger Sent: Wednesday, December 28, 2022 5:05 PM To: Murugan Muruganandam ; Bruce Schuck ; gnucash-user@gnucash.org Subject: Re: [GNC] Finance::Quote v1.54 Released Hi all, recently C. Wehling has added the chapter https://www.gnucash.org/docs/v4/C/gnucash-help/finance-quote.html to thhe manual. It should explain it for all OSes. HTH Frank Am 28.12.22 um 19:52 schrieb Murugan Muruganandam: > hi bruce > > thanks, how can i update 1.54 in windows > > > > > Saludos Cordiales > > > Murugan > > > From: gnucash-user > on behalf of > Bruce Schuck > Sent: Tuesday, December 27, 2022 12:28 AM > To: gnucash-user@gnucash.org ; > gnucash-de...@gnucash.org > Subject: [GNC] Finance::Quote v1.54 Released > > Finance::Quote v1.54 has been released and uploaded to CPAN. > > https://metacpan.org/release/BPSCHUCK/Finance-Quote-1.54 > > https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.54.tar.gz > > https://github.com/finance-quote/finance-quote > > Thank you. > > - Bruce S. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > 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 > - > 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 - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Feature request - prevent a transaction with todays date
You *can* create a proforma invoice or quote and turn that into an invoice. Just create an invoice, but instead of giving it a number, use the word PROFORMA or QUOTE, and don't post it. Then use the invoice printing facility to print it (to find the proforma or quote, you can search, e.g. by customer name). Then when the proforma needs to become a real invoice, you can find the invoice (Business -> Customer -> Find Invoice, and search by customer name) and then select Edit Invoice to change the invoice ID from PROFORMA to whatever invoice ID you want. If you want to know what the next number should be, you can open up Accounts Receivable and use View -> Sort to sort by Number (and reverse order, if you wish) to make sure that the previous invoice with the highest number is at the bottom (or top, if reversed). David On Wed, 28 Dec 2022 at 22:08, Dr. David Kirkby < drkir...@kirkbymicrowave.co.uk> wrote: > On Wed, 28 Dec 2022 at 21:26, Adrien Monteleone < > adrien.montele...@lusfiber.net> wrote: > > > Consider as well, another software package entirely to handle quotes, > > proformas, invoices, AR even. > > > > Then export the resulting accounting data to GnuCash to complete your > > books. > > > > (the same goes for investment tracking) > > > > I use a word processor - LibraOffice. But it would be nice to generate a > quote or proforma invoice and turn that into an invoice. Like you can with > > Quckbooks > > https://quickbooks.intuit.com/learn-support/en-za/help-article/job-estimates/create-send-estimates-quotes-quickbooks-online/L0kOXRjoP_ZA_en_ZA > > Sage > > https://help.accounting.sage.com/en-us/accounting/invoicing/extra-sales-quotes.html > > Kashflow > https://www.kashflow.com/support/kb/settings-quote-settings/ > > etc. > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Whiting ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
