Re: [GNC] e-invoicing ?
There’s creation of e-Invoice files that GnuCash might be able to do if someone can find the specification somewhere. I spent an hour looking and found lots of pages touting the benefits and outlining the e-Invoicing process but nothing about what the file/datastream is supposed to contain. There’s also no loose developer time to work on this. Geert Janssens, the Belgian that Liz alluded to, hasn’t had time to contribute more than the occasional bug-fix for a few years. His business outgrew GnuCash quite a while ago. Peppol is at this time not possible. I found a project, “Peppol for the masses” (https://nlnet.nl/project/Peppol-Decentralised/) that might someday enable FLOSS projects to access it. Regards, John Ralls > On Mar 5, 2025, at 01:03, Pascal Standaert wrote: > > dunno about Australia, but Belgium mandates it for all B2B invoicing from > 01/01/2026 ... > that is sure ... > > https://ec.europa.eu/digital-building-blocks/sites/pages/viewpage.action?pageId=881983566 > > "On 1 February 2024, the Belgian parliament approved the law implementing > mandatory domestic B2B eInvoicing in Belgium as from 1 January 2026" > > I hope we hear from your developer in Belgium very soon ... > > > > > On 5/03/2025 09:54, Liz wrote: >> On Wed, 5 Mar 2025 09:34:28 +0100 >> Pascal Standaert wrote: >> >>> I'm looking into switching to Gnucash for my accounting, but I have >>> some worries about the mandatory e-invoicing which is being rolled >>> out over Europe ... >>> >>> https://www.storecove.com/blog/en/peppol-countries/ >>> >>> https://ec.europa.eu/digital-building-blocks/sites/display/DIGITAL/Obtaining+a+copy+of+the+European+standard+on+eInvoicing >>> >>> ... wil Gnucash be able to do this UBL format xml for e-invoicing ? >>> >>> if not, it would be shear useless to try set it up ... because here >>> in Belgium this e-invoicing (peppol) wil be mandatory from january >>> 1st 2026 ... >> Storecove says PEPPOL is in use in Australia. I've never heard of it, >> and am certainly not using it to invoice anyone. >> >> The ATO tells me that Australia has adopted it as a framework. The >> storecove link tells me its mandatory, and I know that it isn't. >> https://www.ato.gov.au/businesses-and-organisations/einvoicing/what-is-einvoicing >> >> Point? Storecove is not correct there, so are they correct elsewhere? >> >> For your concern, one of our developers is resident in Belgium and will >> be aware of these hurdles to use of Gnucash. >> >> Liz >> ___ >> 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] e-invoicing ?
dunno about Australia, but Belgium mandates it for all B2B invoicing from 01/01/2026 ... that is sure ... https://ec.europa.eu/digital-building-blocks/sites/pages/viewpage.action?pageId=881983566 "On 1 February 2024, the Belgian parliament approved the law implementing mandatory domestic B2B eInvoicing in Belgium as from 1 January 2026" I hope we hear from your developer in Belgium very soon ... On 5/03/2025 09:54, Liz wrote: On Wed, 5 Mar 2025 09:34:28 +0100 Pascal Standaert wrote: I'm looking into switching to Gnucash for my accounting, but I have some worries about the mandatory e-invoicing which is being rolled out over Europe ... https://www.storecove.com/blog/en/peppol-countries/ https://ec.europa.eu/digital-building-blocks/sites/display/DIGITAL/Obtaining+a+copy+of+the+European+standard+on+eInvoicing ... wil Gnucash be able to do this UBL format xml for e-invoicing ? if not, it would be shear useless to try set it up ... because here in Belgium this e-invoicing (peppol) wil be mandatory from january 1st 2026 ... Storecove says PEPPOL is in use in Australia. I've never heard of it, and am certainly not using it to invoice anyone. The ATO tells me that Australia has adopted it as a framework. The storecove link tells me its mandatory, and I know that it isn't. https://www.ato.gov.au/businesses-and-organisations/einvoicing/what-is-einvoicing Point? Storecove is not correct there, so are they correct elsewhere? For your concern, one of our developers is resident in Belgium and will be aware of these hurdles to use of Gnucash. Liz ___ 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] e-invoicing ?
On Wed, 5 Mar 2025 09:34:28 +0100 Pascal Standaert wrote: > I'm looking into switching to Gnucash for my accounting, but I have > some worries about the mandatory e-invoicing which is being rolled > out over Europe ... > > https://www.storecove.com/blog/en/peppol-countries/ > > https://ec.europa.eu/digital-building-blocks/sites/display/DIGITAL/Obtaining+a+copy+of+the+European+standard+on+eInvoicing > > ... wil Gnucash be able to do this UBL format xml for e-invoicing ? > > if not, it would be shear useless to try set it up ... because here > in Belgium this e-invoicing (peppol) wil be mandatory from january > 1st 2026 ... Storecove says PEPPOL is in use in Australia. I've never heard of it, and am certainly not using it to invoice anyone. The ATO tells me that Australia has adopted it as a framework. The storecove link tells me its mandatory, and I know that it isn't. https://www.ato.gov.au/businesses-and-organisations/einvoicing/what-is-einvoicing Point? Storecove is not correct there, so are they correct elsewhere? For your concern, one of our developers is resident in Belgium and will be aware of these hurdles to use of Gnucash. Liz ___ 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] Problems getting prices from Yahoo as JSON
Thanks for that. All my questions answered. On the point of downloading the latest version of F::Q was that someone had suggested that I should use the Gnucash provided installation app to get the latest version and that only downloads the latest release - not the latest dev version. Thanks again for all your help Adrian From: Bruce Schuck Sent: 04 March 2025 16:28 To: 'GnuCash User' Cc: Adrian Holbrook ; Kalpesh Patel Subject: Re: [GNC] Problems getting prices from Yahoo as JSON On 3/4/25 12:01 AM, Adrian Holbrook wrote: > I think that the issue with the Perl module to download > Finance::Quote is that it downloads the latest released version > while I was trying to download the development issue. Exactly what command were you using. "cpan BPSCHUCK/Finance-Quote-1.64_03.tar.gz" would have installed the interim version. > In the end I just copied the relevant YahooJson.pm module and > replaced the previous module. Unfortunately my programming > experience was limited to Fortran, Basic and Logo (!) and I am a bit > rusty! I was a Fortran IV/77 developer a lifetime ago. Learned Basic as part of an advanced Math curriculum in 8th grade (1974-1975). > On the issue of the GBp to GBP conversion Things are now working > but there is still a minor issue. When I checked this morning NXR > was returning the correct price (I do not understand what has > changed) but with NWG I realised that I was retrieving the price > from Alphavantage not Yahoo and that was showing 480.5. When I > changed the source to Yahoo as JSON it worked correctly and shows > 4.803. It's a known issue with AlphaVantage, noted in the Caveat section of the Finance::Quote::AlphaVantage(3) man page. The AV API does not return the currency, so all ".L" symbols are assumed to be GBP. If the user knows a security is traded in GPp/GBX, and using AlphaVantage, add a ".X" to the symbol. So NWG.L would be NWG.L.X. 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.
[GNC] Finance::Quote update of Strawberry Perl
Hi All, I managed to break my FQ functionality to the extent that the Get Quotes button was greyed out. I have just fixed it again and thought I should relay my experience in case it helps others. I am running Windows 10 and GnuCash 5.10+(2024-12-14). Something I did broke GnuCash FQ. I think I know what it was. I use UniGetUI, which is WinGet under the covers, to keep my software up to date. Some time back it offered an update to Strawberry Perl which I accepted. I think it was after that when my Get Quotes button became greyed out. I tried uninstalling and reinstalling Perl but that did not help. I noticed recently in answer to thread "Problems getting prices from Yahoo as JSON" they suggested uninstalling Strawberry Perl, deleting its installation folder and then reinstalling it by running the GnuCash/Install Online Price Retrieval for GnuCash menu option. I had tried something to this before, except I did not delete the folder, so I tried again doing that. It took quite a while to get everything set up again but, after it finished, the Get Quotes button was functional again! It installed Strawberry Perl V5.38.2.2. UniGetUI is still telling me the latest version is currently V5.40.0.1 but that is what I had before and Get Quotes did not work, so I am resisting updating it. Why does FQ need an old version of Perl? Best Regards, John Bonnett ___ 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] Finance::Quote Interim Release 1.64_04 - Possible Usage Counter
Hello, After taking care of a couple remaining pull requests, this interim release may be the final version to be released as F::Q v1.65. BPSCHUCK/Finance-Quote-1.64_04.tar.gz (https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_04.tar.gz) A few releases back, I had enabled a simple way to count method usage. I am thinking of restoring that function, with the addition of including a way to opt out by setting the environment variable "NOFQCOUNT" to anything. Based on web log scraping, the items logged would be source IP, User Agent, F::Q version, and method. 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.
Re: [GNC] Finance::Quote Interim Release 1.64_04 - Possible Usage Counter
Thank you Bruce for all of the work keeping F::Q working in an environment where many companies conspire against you. It's appreciated. Michael On Wed, Mar 5, 2025 at 12:55 PM Bruce Schuck wrote: > Hello, > > After taking care of a couple remaining pull requests, this interim > release may be the final version to be released as F::Q v1.65. > > BPSCHUCK/Finance-Quote-1.64_04.tar.gz > ( > https://www.cpan.org/authors/id/B/BP/BPSCHUCK/Finance-Quote-1.64_04.tar.gz > ) > > A few releases back, I had enabled a simple way to count method usage. I > am thinking of restoring that function, with the addition of including a > way to opt out by setting the environment variable "NOFQCOUNT" to > anything. Based on web log scraping, the items logged would be source > IP, User Agent, F::Q version, and method. > > 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.
[GNC] Reconcile Info: Starting Balance
Hi, I got a bunch of credit card statements correctly reconciled, then something got messed up. Maybe changes I made to transactions in the checking account (such as payments made to pay down credit card balance) messed up the credit card account. But now when I go to re-reconcile the credit card, the "Reconcile Information" / "Starting Balance" is wrong. Where does that number come from? After I reconcile a credit card statement, on the last day of that statement period, I put a final transaction, for example on 10/14/24 "This statement covered 9/15/24 - 10/14/24, the correct balance at this point is $4,567.89." I do this to help me find the problem when balances get messed up. But this doesn't help me with the "Starting Balance" problem. And if GnuCash has the Starting Balance wrong, I can confirm the transactions that paid down the balance and transactions where I purchased items, but GnuCash (correctly?) won't let me mark the statement period as reconciled. I guess the Starting Balance is wrong because, while I may be going back to reconcile a Feb-Mar statement, there are Mar-Apr, and May-Jun transactions that are reconciled (which therefore don't even show up in the reconcile window). Would I have to go to my ledger and manually un-check all the Mar-Apr, May-Jun, and Jun-Jul transactions which are marked "Y" reconciled, just to get a correct Starting Balance for Feb-Mar. And then later manually re-check them all? Tom ___ 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] Reconcile Info: Starting Balance
Tom, The starting balance is calculated from the sum of all the recorded transaction split lines that are marked as reconciled for the account in question. This includes transactions dated after the selected reconciliation date. The other transaction split lines for those transactions are not considered unless and until those respective accounts are reconciled. Usually, the reconciliation of a particular account does not affect the reconciliation of other accounts unless a previously reconciled transaction split line is either accidentally or intentionally unreconciled or deleted from one of the other split accounts for that transaction. If there are missing transactions you will not be able to complete the reconciliation. Thus, the key is to not edit previously reconciled split lines for accounts other than the account that is being used to view that transaction. You should see a warning if you try to do that unless you have disabled that warning, If your starting balance does not match the previous statement's ending balance, chances are you probably did something in another account that unreconciled some previously reconciled split line for the account that you are currently reconciling. If you are fanatic about having the reconciliation date recorded correctly for past transactions, then you do need to unreconcile all transactions that the bank statement(s) show as cleared after the date in question. Otherwise, just reconcile the stray transaction(s) in the current reconciliation period and don't worry about the starting balance. On Wed, Mar 5, 2025 at 10:15 AM Tom Balazs wrote: > Hi, > > I got a bunch of credit card statements correctly reconciled, then > something got messed up. Maybe changes I made to transactions in the > checking account (such as payments made to pay down credit card balance) > messed up the credit card account. > > But now when I go to re-reconcile the credit card, the "Reconcile > Information" / "Starting Balance" is wrong. Where does that number come > from? > > After I reconcile a credit card statement, on the last day of that > statement period, I put a final transaction, for example on 10/14/24 "This > statement covered 9/15/24 - 10/14/24, the correct balance at this point is > $4,567.89." I do this to help me find the problem when balances get messed > up. But this doesn't help me with the "Starting Balance" problem. > > And if GnuCash has the Starting Balance wrong, I can confirm the > transactions that paid down the balance and transactions where I purchased > items, but GnuCash (correctly?) won't let me mark the statement period as > reconciled. > > I guess the Starting Balance is wrong because, while I may be going back to > reconcile a Feb-Mar statement, there are Mar-Apr, and May-Jun transactions > that are reconciled (which therefore don't even show up in the reconcile > window). > > Would I have to go to my ledger and manually un-check all the Mar-Apr, > May-Jun, and Jun-Jul transactions which are marked "Y" reconciled, just to > get a correct Starting Balance for Feb-Mar. And then later manually > re-check them all? > > Tom > ___ > 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 Carlson ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - 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 update of Strawberry Perl
On Wed, 5 Mar 2025 20:13:13 +1030, John Bonnett wrote: Why does FQ need an old version of Perl? It doesn't. The updated version of Perl typically will not contain any of the additional modules installed on the original/older version. "Typically", because for advanced Perl users there are ways to install modules in directories not affected by Perl upgrades. On my Macbook (still running Catalina 10.15), I have 3 different versions of Perl available. Each has modules installed that are not installed for the other releases. I also have 2 different directory trees of modules that can be used by any of the versions when I set an environment variable. This ability is useful for developers, but can throw novice users for a loop if somehow modules were installed where not expected. 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.
Re: [GNC] Reconcile Info: Starting Balance
1. I don't worry about the starting balance. As long as the ending balance is correct and the reconcile screen shows zero differences then all is good. 2. Must reconcile the account in date order. You cannot do January after you have done February. 3. As David explained, the starting balance is all reconciled lines in that account regardless of date. 4. Sometimes I enter the default month/day but GnC supplies an earlier year. Recently I've been getting a lot of 2024 entries when I'm doing 2025!!! I've learned to check the dates on the reconcile screen to catch those before I finish the reconciliation. Yes, in most cases I have to postpone and then correct the dates on the transactions before restarting the reconciliation. Stephen M Butler stephen.m.butle...@gmail.com kg...@arrl.net 253-350-0166 --- GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 On 3/5/25 08:14, Tom Balazs wrote: Hi, I got a bunch of credit card statements correctly reconciled, then something got messed up. Maybe changes I made to transactions in the checking account (such as payments made to pay down credit card balance) messed up the credit card account. But now when I go to re-reconcile the credit card, the "Reconcile Information" / "Starting Balance" is wrong. Where does that number come from? After I reconcile a credit card statement, on the last day of that statement period, I put a final transaction, for example on 10/14/24 "This statement covered 9/15/24 - 10/14/24, the correct balance at this point is $4,567.89." I do this to help me find the problem when balances get messed up. But this doesn't help me with the "Starting Balance" problem. And if GnuCash has the Starting Balance wrong, I can confirm the transactions that paid down the balance and transactions where I purchased items, but GnuCash (correctly?) won't let me mark the statement period as reconciled. I guess the Starting Balance is wrong because, while I may be going back to reconcile a Feb-Mar statement, there are Mar-Apr, and May-Jun transactions that are reconciled (which therefore don't even show up in the reconcile window). Would I have to go to my ledger and manually un-check all the Mar-Apr, May-Jun, and Jun-Jul transactions which are marked "Y" reconciled, just to get a correct Starting Balance for Feb-Mar. And then later manually re-check them all? Tom ___ 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] e-invoicing ?
I'm looking into switching to Gnucash for my accounting, but I have some worries about the mandatory e-invoicing which is being rolled out over Europe ... https://www.storecove.com/blog/en/peppol-countries/ https://ec.europa.eu/digital-building-blocks/sites/display/DIGITAL/Obtaining+a+copy+of+the+European+standard+on+eInvoicing ... wil Gnucash be able to do this UBL format xml for e-invoicing ? if not, it would be shear useless to try set it up ... because here in Belgium this e-invoicing (peppol) wil be mandatory from january 1st 2026 ... ___ 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.
