Re: [GNC] Temporary Website URL
Brad, You need to encourage your lawyer and accountant friends to go read the end user licenses for the various software packages that they rely on. I think that they will find that holding commercial software vendors financially responsible will be VERY difficult because commercial software vendors disclaim pretty much all liability in the licenses. Plus many commercial software vendors (think Microsoft, Adobe, Intuit, etc.) have deep warchests to spend on lawyers to fight any and all lawsuits that might be brought against them. I'm not saying that the gnucash.org websites shouldn't be working, but we need to be realistic about being able to hold commercial software vendors financially accountable. Jeff On Sun, Mar 26, 2023 at 9:12 PM Brad Morrison wrote: > Ken: I just tried all 3 of your GnuCash links/URLs below and they are > now all working well for me. Many thanks to whoever is responsible for > fixing them! > > Robert: thank you for diving deeper into how certificates work and how > the "Apache2 Ubuntu Default Page" error likely resulted from the > configuration error in January, which then led to the Let's Encrypt > certificate to not renew automatically. > > David & Murugan: I had to look up the meaning of the word "parochial" in > the context that David was using it in - yes, my friend/acquaintance > does have a very narrow and rigid view of risk, which leads to his > narrow view of the risks of open source software. In his defense, I will > say that some people in open source communities may not realize how > common it is for people outside of the open source realm to be very > hesitant about using open source software. I have encountered this > attitude a lot from various lawyers and business people with the primary > reason being financial risk & responsibility. If an open source software > is responsible for an error that results in damages, many decision > makers want to be able to hold someone financially responsible for that > mistake and recoup their losses. That hesitancy can easily shift to > distrust if something confirms the existing bias against trying open > source software, such as a website being down for about 2 months (from > mid-January when the config error was noticed, until mid-March when it > was fixed). > > Please do not misunderstand me - I am not trying to assign blame to > anyone and I write this because I care. As David mentioned, outages > happen to all websites from time to time, including major commercial > platforms. However, I also do not think it is wise to call this a blip > either - I have never heard of any major commercial website going down > for 2 months, much less a major platform like Twitter or Facebook. > Accessibility/attention is where those platforms get so much of their > power from, heads would roll if Facebook or Twitter went down for 2 > months and a workaround had to be created and used. > > My friend/acquaintance and everyone else that uses the internet uses > open source software. But there is a big difference between developers > choosing to use open source software and users choosing to use open > source software. Professional bookkeepers are not software engineers, > the CPAs that I work with are not software engineers, lawyers are not > software engineers - to expect any other professionals to use a tool > that they are not familiar with takes some motivation on the part of the > user. Whether that motivation is philosophical, political, financial, or > practical - any change takes motivation. Hopefully what I just wrote > does not sound too obvious, but the point is that it is hard to ask > someone to use a product that they are not familiar with, are hesitant > about to begin with and then send them a link that doesn't work. > > My primary goal with GnuCash is to increase adoption among professional > bookkeepers in the US. Now that the GnuCash websites are working again, > I can get back to trying to do that. > > Brad > > On 3/19/23 10:36, Murugan Muruganandam wrote: > > Brad > > i agree with David, the website issue was an blip which was solved using > a work around and am sure the team is working to restore the certificate. > > On the statement from your acquaintance that he does not use open source > is quite a stretch, on top of my mind Linux , am very sure his website or > his database is running on Linux. > > I would strongly recommend that your acquaintance take a look into > GNUCash software and share is frank opinion about the merits and de > merits. this software was built solely on comments and requests from > people. > > > > > > > > > > Saludos Cordiales > > > > > > Murugan > > > > > > From: gnucash-user hotmail@gnucash.org> on behalf of David T. via gnucash-user< > gnucash-user@gnucash.org> > > Sent: Sunday, March 19, 2023 3:05 AM > > To: Robert Heller > > Cc: David Reiser via gnucash-user > > Subject: Re: [GNC] Temporary Website URL > > > > Brad, > > > > I just want to note that
Re: [GNC] Temporary Website URL
Ken: I just tried all 3 of your GnuCash links/URLs below and they are now all working well for me. Many thanks to whoever is responsible for fixing them! Robert: thank you for diving deeper into how certificates work and how the "Apache2 Ubuntu Default Page" error likely resulted from the configuration error in January, which then led to the Let's Encrypt certificate to not renew automatically. David & Murugan: I had to look up the meaning of the word "parochial" in the context that David was using it in - yes, my friend/acquaintance does have a very narrow and rigid view of risk, which leads to his narrow view of the risks of open source software. In his defense, I will say that some people in open source communities may not realize how common it is for people outside of the open source realm to be very hesitant about using open source software. I have encountered this attitude a lot from various lawyers and business people with the primary reason being financial risk & responsibility. If an open source software is responsible for an error that results in damages, many decision makers want to be able to hold someone financially responsible for that mistake and recoup their losses. That hesitancy can easily shift to distrust if something confirms the existing bias against trying open source software, such as a website being down for about 2 months (from mid-January when the config error was noticed, until mid-March when it was fixed). Please do not misunderstand me - I am not trying to assign blame to anyone and I write this because I care. As David mentioned, outages happen to all websites from time to time, including major commercial platforms. However, I also do not think it is wise to call this a blip either - I have never heard of any major commercial website going down for 2 months, much less a major platform like Twitter or Facebook. Accessibility/attention is where those platforms get so much of their power from, heads would roll if Facebook or Twitter went down for 2 months and a workaround had to be created and used. My friend/acquaintance and everyone else that uses the internet uses open source software. But there is a big difference between developers choosing to use open source software and users choosing to use open source software. Professional bookkeepers are not software engineers, the CPAs that I work with are not software engineers, lawyers are not software engineers - to expect any other professionals to use a tool that they are not familiar with takes some motivation on the part of the user. Whether that motivation is philosophical, political, financial, or practical - any change takes motivation. Hopefully what I just wrote does not sound too obvious, but the point is that it is hard to ask someone to use a product that they are not familiar with, are hesitant about to begin with and then send them a link that doesn't work. My primary goal with GnuCash is to increase adoption among professional bookkeepers in the US. Now that the GnuCash websites are working again, I can get back to trying to do that. Brad On 3/19/23 10:36, Murugan Muruganandam wrote: Brad i agree with David, the website issue was an blip which was solved using a work around and am sure the team is working to restore the certificate. On the statement from your acquaintance that he does not use open source is quite a stretch, on top of my mind Linux , am very sure his website or his database is running on Linux. I would strongly recommend that your acquaintance take a look into GNUCash software and share is frank opinion about the merits and de merits. this software was built solely on comments and requests from people. Saludos Cordiales Murugan From: gnucash-user on behalf of David T. via gnucash-user Sent: Sunday, March 19, 2023 3:05 AM To: Robert Heller Cc: David Reiser via gnucash-user Subject: Re: [GNC] Temporary Website URL Brad, I just want to note that your acquaintance has a remarkably parochial attitude about software. GnuCash has been available and actively developed for something like 25 years. It seems to me that in this era of "big data," those commercial companies are more interested in the customer as a source of data mining income than as a partner using their software. *And* outages with major commercial platforms (Twitter, Facebook?) underscore that it is not just open source projects that fail sometimes. David T. On Mar 18, 2023, 4:21 PM, at 4:21 PM, Robert Heller wrote: At Sat, 18 Mar 2023 06:04:52 -0700 Brad Morrison wrote: Thanks for point these situations out Ken! The reason I joined the GnuCash-User mailing lists was because I sent a link to an acquaintance that does bookkeeping professionally and he texted back that the website was down, he then did a Google search and tried the GnuCash result on his own and that link didn't work either, and he then goes on to tell
Re: [GNC] Reporting Woes - Newbie incompetence
Brook Milligan wrote: On Mar 24, 2023, at 10:35 AM, R. Victor Klassen wrote: I use a transaction report for what you seek. With the right options I get the account, date, description and amount. Copy paste the result into a spreadsheet Perhaps I am doing something wrong, but how do you copy/paste the result into a spreadsheet. My understanding is that the reports are HTML documents. Perhaps there is some magic I am not aware of? Cheers, Brook ___ 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. Most spreadsheet programs will open HTML files. Apache OpenOffice, LibraOffive, and Excel I know will. Regards Keith N. McKenna ___ 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 5.0 Released
The sha256 hash for Gnucash-Intel-5.0-1.dmg is not equal to the value given at SourceForge. $ sha256 Gnucash-Intel-5.0-1.dmg b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a Gnucash-Intel-5.0-1.dmg FAIL c8ea60b2ccbeab5f6997a927939a0fad715fbbe494644e586c6c386bfec6857a NOT EQUAL TO b43b61244e195f6f8c52f83430c08671e8a02f47a00f09e4295652ce9d57443a — Peter West p...@pbw.id.au“Rejoice and be glad, for your reward is great in heaven, for so they persecuted the prophets who were before you.” > On 27 Mar 2023, at 7:09 am, John Ralls wrote: > > The GnuCash development team announces GnuCash 5.0. > > New Features > >A new Stock Transaction Assistant to guide you through entering most > investment transactions for stocks, bonds, and mutual funds. You can access > it from Actions>Stock Assistant when the focus tab is the Accounts page or a > Stock or Fund account register. >A new Investment Lots report showing a graph of capital gains and losses > in a period by investment lot. Note that if you don't use the View Lots > dialog to manage capital gains and losses this report won't have anything to > show you. Use Reports>Assets & Liabilities>Investment Lots to see the report. >The Online Quotes facility has been completely rewritten and the old > gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with > finance-quote-wrapper. The functions performed by those programs may now be > accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help > for specifics. The perl module requirements have changed with the rewrite: > The new version doesn't need Date::Manip but needs JSON::Parse instead. > gnc-fq-update has been, er, updated to reflect that. >A new tab on the New/Edit Account dialog called More Properties includes > entries to set a high and low limit on an account. That's coupled to a new > column that's available on the Accounts Page, Balance Limit. If you set a > high or low limit and the account balance falls above or below the respective > limit an indicator will be shown in the Balance Limit column. >The description field quickfill in the register now displays a drop-down > list of possible completions instead of just one inline completion. >File import menu items for the MT940, MT942, and DTAUS formats is replaced > with a single Import from AQBanking that supports importing any file format > supported by AQBanking, including the frequently requested CAMT. (Note that > some CAMT profiles are under the XML format.) >The import matcher now permits editing descriptions, notes, and memo > fields in the matcher window before creating the transactions. Right-click > and select from the context menu. >The report generated by the Print Invoice button on the Edit Invoice tab > can now be configured as a book option at the bottom of the Business tab; > this permits selecting a saved configuration of one of the standard invoice > reports. Another option enables a delay, during which a dialog box will > appear enabling the user to select a different report. Note: When saving a > configuration make sure that the invoice number is not set or you'll get that > particular invoice instead of the one that you pressed the button for. > > Significant Code Changes > Deprecations (will be removed in GnuCash 6.0) > >_ (the alias for gettext. Use G_ instead) >gnc:make-account-list-limited-option >gnc:make-account-list-option >gnc:make-account-sel-limited-option >gnc:make-account-sel-option >gnc:make-budget-option >gnc:make-color-option >gnc:make-commodity-option >gnc:make-complex-boolean-option >gnc:make-counter-format-option >gnc:make-counter-option >gnc:make-currency-option >gnc:make-date-format-option >gnc:make-font-option >gnc:make-internal-option >gnc:make-invoice-option >gnc:make-list-option >gnc:make-multichoice-callback-option >gnc:make-multichoice-option >gnc:make-number-plot-size-option >gnc:make-number-range-option >gnc:make-owner-option >gnc:make-pixmap-option >gnc:make-query-option >gnc:make-radiobutton-option >gnc:make-simple-boolean-option >gnc:make-string-option >gnc:make-taxtable-option >gnc:make-text-option >gnc:option-set-default-value >gnc:option-set-value >gnc:option-setter >gnc:option-value >gnc:register-option >The invoice option to gnc:register-report-create-internal > > Report and Book Options > >This major change will affect everyone who has written custom reports in > Guile Scheme. >The report and book options code has been completely rewritten in C++ with > SWIG providing Guile Scheme access for reports. The new design requires > directly registering options with for example > gnc-optiondb-register-string-option instead of calling gnc:make-string-option > to create an option followed by gnc:register-option to insert it in the >
[GNC] GnuCash 5.0 Released
The GnuCash development team announces GnuCash 5.0. New Features A new Stock Transaction Assistant to guide you through entering most investment transactions for stocks, bonds, and mutual funds. You can access it from Actions>Stock Assistant when the focus tab is the Accounts page or a Stock or Fund account register. A new Investment Lots report showing a graph of capital gains and losses in a period by investment lot. Note that if you don't use the View Lots dialog to manage capital gains and losses this report won't have anything to show you. Use Reports>Assets & Liabilities>Investment Lots to see the report. The Online Quotes facility has been completely rewritten and the old gnc-fq-check, gnc-fq-dump, and gnc-fq-helper programs have been replaced with finance-quote-wrapper. The functions performed by those programs may now be accomplished by passing commands to gnucash-cli -Q, see gnucash-cli --help for specifics. The perl module requirements have changed with the rewrite: The new version doesn't need Date::Manip but needs JSON::Parse instead. gnc-fq-update has been, er, updated to reflect that. A new tab on the New/Edit Account dialog called More Properties includes entries to set a high and low limit on an account. That's coupled to a new column that's available on the Accounts Page, Balance Limit. If you set a high or low limit and the account balance falls above or below the respective limit an indicator will be shown in the Balance Limit column. The description field quickfill in the register now displays a drop-down list of possible completions instead of just one inline completion. File import menu items for the MT940, MT942, and DTAUS formats is replaced with a single Import from AQBanking that supports importing any file format supported by AQBanking, including the frequently requested CAMT. (Note that some CAMT profiles are under the XML format.) The import matcher now permits editing descriptions, notes, and memo fields in the matcher window before creating the transactions. Right-click and select from the context menu. The report generated by the Print Invoice button on the Edit Invoice tab can now be configured as a book option at the bottom of the Business tab; this permits selecting a saved configuration of one of the standard invoice reports. Another option enables a delay, during which a dialog box will appear enabling the user to select a different report. Note: When saving a configuration make sure that the invoice number is not set or you'll get that particular invoice instead of the one that you pressed the button for. Significant Code Changes Deprecations (will be removed in GnuCash 6.0) _ (the alias for gettext. Use G_ instead) gnc:make-account-list-limited-option gnc:make-account-list-option gnc:make-account-sel-limited-option gnc:make-account-sel-option gnc:make-budget-option gnc:make-color-option gnc:make-commodity-option gnc:make-complex-boolean-option gnc:make-counter-format-option gnc:make-counter-option gnc:make-currency-option gnc:make-date-format-option gnc:make-font-option gnc:make-internal-option gnc:make-invoice-option gnc:make-list-option gnc:make-multichoice-callback-option gnc:make-multichoice-option gnc:make-number-plot-size-option gnc:make-number-range-option gnc:make-owner-option gnc:make-pixmap-option gnc:make-query-option gnc:make-radiobutton-option gnc:make-simple-boolean-option gnc:make-string-option gnc:make-taxtable-option gnc:make-text-option gnc:option-set-default-value gnc:option-set-value gnc:option-setter gnc:option-value gnc:register-option The invoice option to gnc:register-report-create-internal Report and Book Options This major change will affect everyone who has written custom reports in Guile Scheme. The report and book options code has been completely rewritten in C++ with SWIG providing Guile Scheme access for reports. The new design requires directly registering options with for example gnc-optiondb-register-string-option instead of calling gnc:make-string-option to create an option followed by gnc:register-option to insert it in the report's options. Value access is also changed: Instead of retrieving an option and then querying or setting its value with gnc:option-value one will query the optiondb with gnc-option-value, the arguments to which are the optiondb, the section, and the option name. Supporting the new options backend the options dialog code in gnc-dialog-options, gnc-business-options, and the new gnc-option-gtk-ui have also been rewritten in C++. Online Price Retrieval As noted under New Features the interface to Finance::Quote has been completely rewritten in C++ with much of the behavior previously coded in external perl scripts moved into GnuCash proper. This permits much better access
[GNC] GnuCash 4.14 Released
The GnuCash development team announces GnuCash 4.14, the fifteenth and final release in the stable 4.x series. Between 4.13 and 4.14, the following bugfixes were accomplished: Bug 797477 - Manual foreign transaction from APAR to another doesn't trigger price input Bug 797725 - Untranslatable string "For Period Covering ~a to ~a" Bug 797903 - Transaction window: The 'blue line' is always (erroneously) topmost when t. sorting order is inverted. Bug 798570 - Totals for the income, expenses and remaining to budget incorrect for one specific date. Bug 798625 - "Last up through report date" changed in 4.12 Don't adjust report dates with time64CanonicalDayTime. They're set to 23:59:59 local which is always >= neutral time at which prices and transactions are timestamped. Local noon is before neutral time for all time zones east of UTC+2. Bug 798679 - Unicode normalization should be used for comparison but not stored. Change to NFC normalization for all comparisons because the Unicode meaning of compatible might collide with the user's intent. Bug 798702 - Crash in gnc_plugin_page_focus_idle_destroy() closing a report before it completes. Bug 798705 - ] New: UI string mismatch: OK vs. Next Bug 798712 - Regional Decimal Point not recognized in budgets Bug 798717 - Reports > Business > Fancy Invoice duplicates company details Bug 798732 - : Type of balance carry forward accounts for german skr49 account template fixed Bug 798734 - Aging Reports don't handle mixed currency payments and invoices without Trading Accounts Bug 798734 - Aging Reports don't handle mixed currency payments and invoices without Trading Accounts Bug 798737 - Minor grammatical error - 'for' missing in 'You will be asked a conversion rate for each.' Bug 798740 - Build fails with gcc 13 Bug 798747 - Crash in Investment Portfolio report Bug 798748 - Transaction Notes field's value does not appear in reverse transaction. Bug 798754 - Build fails with gcc 13 and glib > 2.76 Bug 798759 - Register widths for 'with sub-account' not saved Bug 798765 - Increase the limit for Maximum Slices in the Expense Piechart The following fixes and improvements were not associated with bug reports: Budget totals for one period would be wrong when increasing the number of periods. Allow C decls after statements, legal since C99. [kvp] Use static strings and boxed in gvalue_from_kvp_value. Saves allocating and copying complex values, avoiding potential memory leaks. L10N:DE:Updating accounts from 0001 to 8000 DATEV-SKR04 2022-01-01. Payment dialog - always list all possible post accounts. Before only the post account in the currency of the selected vendor or customer was available. Revisit invoice payment in multi-currency context Show proper amount in dialog when applying or editing an existing transaction as payment Be more careful not to waste the existing payment split If the user changed the payment amount while starting from an existing transaction unreconcile the changed payment split Avoid needlessly changing transaction currency (only do so if the user chose a new transfer account and the old currency is neither the new transfer account's currency nor the post account's currency) Edit/assign payment - be more prudent not to lose data We can't handle the case where a transaction has splits in more than one APAR account. Instead of only warning that some of them will be lost refuse to continue and leave it to the user to fix the transaction first. Multi-currency - show split amount rather than transaction value Activate feature GNC_FEATURE_EQUITY_TYPE_OPENING_BALANCE [balsheet-pnl] move out of experimental into regular menu. After 4 years it can finally graduate. [dialog-sx-editor]Allow a daily SX to show all recurrences in the calendar instead of only 6 months. Update Form/Schedule line references for 2022 for the US Income Tax Report New and Updated Translations: Chinese (Simplified), Croatian, Czech, English (Australia), English (New Zealand), English (United Kingdom), French, Hebrew, Hungarian, Italian, Japanese, Macedonian, Polish, Portuguese, Portuguese (Brazil), Russian, Spanish, Swedish, Ukrainian Help translate GnuCash on Weblate: https://hosted.weblate.org/engage/gnucash/ Known Problems: A complete list of all open bugs: https://bugs.gnucash.org/buglist.cgi?bug_severity=blocker_severity=critical_severity=major_severity=normal_severity=minor_severity=trivial_status=NEW_status=ASSIGNED_status=NEEDINFO_status=REOPENED=0_id=8149=priority%2Cbug_severity_format=advanced Documentation Concurrent with the release of GnuCash 4.14 we're pleased to also release a new version of the companion Help and Tutorial and Concepts Guide The following fixes and improvements were not associated with bug reports: Only use localized *; entities Guide:C:
Re: [GNC] Version Information in new Flatpak Release?
Patience. This weekend's release is a double, both 4.13 and 5.0. Since I haven't yet figured out how to do six things at once and anyway have to manipulate several git repositories in the right order, it's taking time and some things like flathub are getting pushed ahead of the announcements. Tommy Trussell reported a similar strange update prompt on Ubuntu 22.04 a couple of weeks ago with a very tardy prompt to update to 4.13, which he already had. I guess that's not a very reliable tool. Regards, John Ralls > On Mar 26, 2023, at 2:13 AM, rsbrux via gnucash-user > wrote: > > For many months now I have been using GC 4.13+ installed as a flatpak under > Ubuntu Studio 22.04 LTS. > Today KDE Discover offered to update GC "to version 4.13+ (Flathub 4.13) > (stable)" > However, looking at the Flathub web page > (https://flathub.org/apps/details/org.gnucash.GnuCash), I see: > Updated: March 25, 2023 > Version: 4.14+ (Flathub 4.14) > > After letting Discover perform the update, running: > flatpak run --command=sh org.gnucash.GnuCash > gnucash --version > as described here: > https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools > yields: > GnuCash 4.14 > Build ID: Flathub 4.14 > > so it looks as though some version information in the Flatpak repository for > GC hasn't been updated properly. > ___ > 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] Modify Balance Sheet report in 4.13?
On 3/26/2023 11:35 AM, Stan Brown wrote: Thanks for this, Adrien. As I look further into it, there are some other changes I'll need to make too, so I think exporting to Excel and then editing the HTML may be easier overall. Keeping books for organizations I was always exporting and editing. Keep in mind that the SAME (logical) report would be wanted in different levels of detail for different purposes. Almost always one format/level of detail/grouping for the Board of Directors and another for tax purposes. For example, the BoD might want to see just the total cost of an event. But the treasurer needs "printing and postage" separated out form other costs because a 990/990EZ line item. The BoD might just want to see the total cost to the organizations of all interns but the treasurer needs to see each separately and those each split between "pay" and "mileage reimbursement" (to fill out possible 1099-MISC) and similarly maybe the total of "orchard mowing costs" for the BoD but how much to any neighboring farmers paid again to see if a 1099 needed. Besides, having it outside of gnucash and under the control of and editor makes it easy to add annotations to explain anything unusual. Michael ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] QuickBooks to GnuCash Migration Script improvements
Thanks for checking out the https://github.com/erikmack/qb-escape script! I'm definitely aware that the script isn't easily accessible to non-technical folks and has some limitations. That said, how can you and I ask what opportunities are there: - Is it technically possible to bundle a migration script as a standalone program? Or possibly within gnucash or as an extension? - What are the challenges beyond just the technical to create and maintain (and market) such a thing? Perhaps a fundraiser could be done? - Assuming you are trying to attract an audience currently using an existing tool (such as QuickBooks), is there guidance they're seeking? My understanding is that CPA firms spend time writing their own documentation for their clients to use specific software tools (such as QuickBooks) so their clients can do certain tasks on their own (e.g. quarterly taxes in USA). I bring this up knowing the challenges of writing migraters (and keeping them up-to-date) is a recurring challenge in various open-source spaces (not just gnucash, for example in plaintextaccounting I'm aware of the earlier attempt of 'ledgerhub' by the beancount community where there were some lessons learned - could link to various threads about this if desired). There's usually a broader challenge between contributors on what the appropriate coding conventions are on writing importers - where carries more of a maintainer perspective seeking more structure, and the other contributor is interested in getting an initial importer done to get their data in and move on. The current state of code in the Quickbooks-to-GnuCash importer falls more in the latter - it's a fairly simple script and makes many assumptions (US-based, reconciled transactions, etc.) While I don't want to get too deep into my personal politics around software, I recently tweeted my hope is to pay/support tools that, even if they're subscription based, at least provide view-only or export options when the subscription has lapsed - especially if the data is locally stored on the user's own computer. To answer your other questions: > I thought that GnuCash was now using Python 3 and not Python 2 as the LWN article states...? There are also points made about piecash and relational databases that I do not know if how that article portrays it from August 2017 is still current/accurate...? I'm thankful for what the original article started, and some of the confusion is what prompted me to spend time improving the documentation at https://github.com/erikmack/qb-escape . I'm still rather new to GnuCash and not sure about the comments in the original article about piecash and relational database formats. On Sun, Mar 26, 2023 at 9:36 AM Brad Morrison wrote: > Hi Vivek/all, > > That LWN 'Escape from QuickBooks (with data in hand)' article > (https://lwn.net/Articles/729087/) was great - thanks for sharing! I > don't know if Jonathan Corbet (or Erik Mack) is on this mailing list, > but Jonathan is a very clear and helpful technical writer. However, it > was still difficult for me to read: > > Partly it is pretty technical and over my head (I would have to look up > what 'Python bindings' actually are in order to understand parts of the > information that was being conveyed, just to give anyone a sense of the > knowledge base that I am coming from). > > Partly it is from August 2017 and I'm not sure how accurate it still is > - I thought that GnuCash was now using Python 3 and not Python 2 as the > LWN article states...? There are also points made about piecash and > relational databases that I do not know if how that article portrays it > from August 2017 is still current/accurate...? > > Partly the whole nature of the article is depressing and disappointing > in conveying how much work is required to migrate data from the > proprietary data format that Quickbooks uses into a format that GnuCash > (or any other free accounting system) can use. I have disliked Intuit > (https://en.wikipedia.org/wiki/Intuit) for a long time, but mostly from > a financial perspective as Intuit is a publicly traded company with a > market capitalization of about $120 billion USD > (https://www.google.com/finance/quote/INTU:NASDAQ?window=MAX), yet > Intuit is not even listed as one of the 287 largest contributors on the > Open Source Contributors Index (https://opensourceindex.io/). Obviously, > there has been a lot of effort put into maintaining Intuit's/Quickbooks' > control of its market share from competitive threats like GnuCash or the > US IRS' efforts to develop its own open source/free tax preparation > software > ( > https://www.propublica.org/article/congress-is-about-to-ban-the-government-from-offering-free-online-tax-filing-thank-turbotax). > > > > With how difficult it seems to be to export data out of Quickbooks, I > can understand why there do not appear to be any professional > bookkeepers in the United States that work with GnuCash, even just as an > option (based on the lack
Re: [GNC] Modify Balance Sheet report in 4.13?
Thanks for this, Adrien. As I look further into it, there are some other changes I'll need to make too, so I think exporting to Excel and then editing the HTML may be easier overall. Stan Brown Tehachapi, CA, USA https://BrownMath.com On 2023-03-24 12:52, Adrien Monteleone wrote: > I don't see that you can as an option, but you can remove the Equity total. > > Fortunately those cells have classes, so you can hide them with CSS > using the CSS stylesheet: > > .total-label-cell, .total-number-cell { > display: none; > } > > > > Regards, > Adrien > > On 3/23/23 6:01 PM, Stan Brown wrote: >> I'm setting up a local nonprofit with GnuCash books. It's a bare-bones >> organization, with no liabilities. >> >> When I run a Balance Sheet report in 4.13, there's a final line, "Total >> for Liability and Equity". Of course that's appropriate in most cases, >> but in this case it's redundant with the "Total for Equity" line. >> >> I've tried the Display options that seem appropriate, but haven't found >> any that suppress that line. Is there any way I can modify the report to >> suppress the "Total for Liability and Equity" line? >> > > ___ > 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] QuickBooks to GnuCash Migration Script improvements
Hi Vivek/all, That LWN 'Escape from QuickBooks (with data in hand)' article (https://lwn.net/Articles/729087/) was great - thanks for sharing! I don't know if Jonathan Corbet (or Erik Mack) is on this mailing list, but Jonathan is a very clear and helpful technical writer. However, it was still difficult for me to read: Partly it is pretty technical and over my head (I would have to look up what 'Python bindings' actually are in order to understand parts of the information that was being conveyed, just to give anyone a sense of the knowledge base that I am coming from). Partly it is from August 2017 and I'm not sure how accurate it still is - I thought that GnuCash was now using Python 3 and not Python 2 as the LWN article states...? There are also points made about piecash and relational databases that I do not know if how that article portrays it from August 2017 is still current/accurate...? Partly the whole nature of the article is depressing and disappointing in conveying how much work is required to migrate data from the proprietary data format that Quickbooks uses into a format that GnuCash (or any other free accounting system) can use. I have disliked Intuit (https://en.wikipedia.org/wiki/Intuit) for a long time, but mostly from a financial perspective as Intuit is a publicly traded company with a market capitalization of about $120 billion USD (https://www.google.com/finance/quote/INTU:NASDAQ?window=MAX), yet Intuit is not even listed as one of the 287 largest contributors on the Open Source Contributors Index (https://opensourceindex.io/). Obviously, there has been a lot of effort put into maintaining Intuit's/Quickbooks' control of its market share from competitive threats like GnuCash or the US IRS' efforts to develop its own open source/free tax preparation software (https://www.propublica.org/article/congress-is-about-to-ban-the-government-from-offering-free-online-tax-filing-thank-turbotax). With how difficult it seems to be to export data out of Quickbooks, I can understand why there do not appear to be any professional bookkeepers in the United States that work with GnuCash, even just as an option (based on the lack of response to Bob Treumann's ask on this list on March 1, 2023). I don't know how many GnuCash users there are that started with QB and were able to successfully migrate their data to GnuCash (?), but after trying to read that LWN article, I'm guessing that most GnuCash users either migrated their data 'manually' or just started fresh with GnuCash...? Ouch! Still it is super helpful to even understand the issues involved more fully - thanks again! Brad On 3/22/23 08:05, Vivek Gani wrote: Hi, I recently made some improvements to the migrations scripts that might help those trying to migrate from Quickbooks to GnuCash: https://github.com/erikmack/qb-escape Even if you're not using GnuCash the instructions for Quickbooks data export might be helpful if you're trying to have a backup of data in a way that's more accessible (i.e. for use in Excel, Libreoffice, etc.) If anyone has time available, I think a possible improvement would be to find a way to make a packaged 'download and run' migration tool so non-technical folks can have an easier path for migrating data to gnucash without trying to install gnucash with python bindings, etc.. This might be possible with pyinstaller though the complicated part will likely be trying to also bundle a gnucash with python bindings setup within there too, and for each different operating system. Linkbacks - these scripts were based on the LWN article 'Escape from Quickbooks (with data in hand)' -https://lwn.net/Articles/729087/ ___ 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] Report Question
Hey Richard and Guillermo, Thanks for your suggestions. I will try exporting the data and using another tool. Sincerely, Matthew On Sun, Mar 26, 2023, 04:20 Guille Lopez wrote: > Hello, > > For this purpose, one could also use a portfolio tracking specific tool > such as https://www.portfolio-performance.info/en/. > > Using export function from GnuCash or the banks, it is not be too > cumbersome to synchronize both software, remaining GnuCash in charge of > the accounting part of the story and Portfolio Performance in charge of > the portfolio analysis. > > Portfolio Performance offers the feature "Taxonomies" , which address > your particular request. > > BR, > > Guillermo > > On 26/03/2023 03:10, R Losey wrote: > > Hi. > > > > I don't consider myself accomplished regarding GnuCash Reports, but for > > what you are wanting, it sounds like a spreadsheet is the perfect way to > > go. Maybe get the data into a spreadsheet, and then you can adjust it / > > report it to your heart's content. If you find a good way to get a report > > on just those accounts, it seems that (based on other emails here) you > can > > cut and paste the report data into a spreadsheet. > > > > > > On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay wrote: > > > >> I have used gnucash for a few years, and have all of my investments > sorted > >> by account. To understand how my investments are distributed, it would > be > >> very convenient for me to have a report that computes the percentage of > >> certain investments in the whole, e.g., the percent that is bonds. Is it > >> possible for me to write a report in which I sort my investments and > then > >> compute quantities like percentages, 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. > >> > > > ___ 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] Report Question
Hello, For this purpose, one could also use a portfolio tracking specific tool such as https://www.portfolio-performance.info/en/. Using export function from GnuCash or the banks, it is not be too cumbersome to synchronize both software, remaining GnuCash in charge of the accounting part of the story and Portfolio Performance in charge of the portfolio analysis. Portfolio Performance offers the feature "Taxonomies" , which address your particular request. BR, Guillermo On 26/03/2023 03:10, R Losey wrote: Hi. I don't consider myself accomplished regarding GnuCash Reports, but for what you are wanting, it sounds like a spreadsheet is the perfect way to go. Maybe get the data into a spreadsheet, and then you can adjust it / report it to your heart's content. If you find a good way to get a report on just those accounts, it seems that (based on other emails here) you can cut and paste the report data into a spreadsheet. On Fri, Mar 24, 2023 at 9:11 PM Matthew Clay wrote: I have used gnucash for a few years, and have all of my investments sorted by account. To understand how my investments are distributed, it would be very convenient for me to have a report that computes the percentage of certain investments in the whole, e.g., the percent that is bonds. Is it possible for me to write a report in which I sort my investments and then compute quantities like percentages, 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. ___ 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] Version Information in new Flatpak Release?
For many months now I have been using GC 4.13+ installed as a flatpak under Ubuntu Studio 22.04 LTS. Today KDE Discover offered to update GC "to version 4.13+ (Flathub 4.13) (stable)" However, looking at the Flathub web page (https://flathub.org/apps/details/org.gnucash.GnuCash), I see: Updated: March 25, 2023 Version: 4.14+ (Flathub 4.14) After letting Discover perform the update, running: flatpak run --command=sh org.gnucash.GnuCash gnucash --version as described here: https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools yields: GnuCash 4.14 Build ID: Flathub 4.14 so it looks as though some version information in the Flatpak repository for GC hasn't been updated properly. ___ 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] Error in "Close Book" help text
Michael, I certainly agree with your concerns. My statement includes my own implication that a good documentarian would explain the broader purpose of the feature as well as its results and means to manage it. My initial statement was terse enough that this aspect was missing. To explicate further, the documents would include: * a brief note regarding the reason for closing the books (i.e., the historical); * an explanation of what exactly the GnuCash CB feature does; * an explanation of how to reverse it; and, * a description of how some reports handle the results. David T. P.S. I would hesitate to address users' misunderstandings of the accounting principles in GnuCash documentation for the reasons you often cite. I am not an accountant and rules vary by jurisdiction. I've always attempted just to explain clearly what the software *does* and let users figure out what they want to do with it based on those capabilities. On Mar 25, 2023, 4:57 PM, at 4:57 PM, Michael or Penny Novack wrote: >On 3/25/2023 4:28 AM, David T. wrote: >> Michael, >> >> As a past documentation contributor, I'd assume any person taking up >> this bug would attempt to document the functionality of the newly >> added feature, regardless of the initial bug request. >> >> David T. > >What I meant is that it is easy for those inexperienced with >bookkeeping, especially those who never did it the old way, to conflate > >"close the books" (as a logical operation) and "close the books" using >this particular gnucash tool. We see lots of this sort of confusion >with >"opening the books" using the opening value wizard vs doing it the old >fashioned way with explicit transaction(s) to enter the initial >values. > >It might seem unnecessary since most newbies hopefully read the >tutorial, etc. but some new to gnucash but experienced with other >similar software (like QuickBooks not Quicken) or very experienced > >with old fashioned bookkeeping might jump right in and do things the >old >way (without the shortcut/tools). This is also just like the >(unexpected?) behavior that to specify options for a report you first >run the report default and THEN use edit=?options to specify the >options. > >Michael D Novack ___ 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.