Re: [GNC] My deposits are disappearing

[Brad Morrison]

Hi Ron/GnuCash users, 

What operating system are you using? 

You mentioned that you are using GnuCash 5.6, the current version is 5.8
- https://gnucash.org/download.phtml 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-09-17 09:39, David Carlson wrote:

> Sorry, my phone sent my reply before i was done writing it.
> So you may want to edit the transaction note or memo when matching the
> second import of the transaction.  You may or may not find that easier than
> entering by hand or using a scheduled transaction to create an existing
> transaction to match an import to.
> 
> On Tue, Sep 17, 2024, 11:31 AM David Carlson 
> wrote:
> 
> If you import both sides of a payment from a bank account to a credit card
> account, GnuCash may or may not detect the match of the second import to
> the first.  You need to develop a routine to ensure that those matches are
> entered to your satisfaction during the second import.  That may include
> editing notes
> 
> On Tue, Sep 17, 2024, 11:13 AM Ronald Solomon 
> wrote:
> 
> I am using gnucash 5.6 I entered my credit cards by hand, I could not get
> the import to work consistently, I entered them a month at a time then
> balanced them with the statement and reconciled each month.
> I then entered my checking account. in the same fashion, each month is
> balanced and reconciled. I got this month's credit card statement and went
> to enter when I saw the credit card account ending total was wrong, I
> pulled up the old statement and I pulled up the statements back to the 1st
> of the year and it was wrong back to January. That was the problem I
> was having with importing I would have a balanced and reconciled account,
> and the import would go back and change figures taking forever to fix. At
> first glance it appears some if not all of my deposits are missing.
> Is this a bug? or am I doing the entering in the wrong order credit cards
> then checking information.
> 
> --
> Ron Solomon
> ___
> 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 modifications

[Brad Morrison]

Hi David/Derek/GnuCash, 

1 & 3. GnuCash is not a multi user program, but more than 1 person can
modify a GnuCash file, just not at the same time. Are these questions
more about user access to the bookkeeping software or more about
tracking the accounting changes and tracking who is making what changes
and when for the purposes of noticing and correcting errors/mistakes? 

2. As Derek & David/Sunfish have pointed out previously, GnuCash is open
source and there may be a developer willing to make significant
modifications to the program for you if you pay them. I do not know how
large your firm is, what your current bookkeeping software is, how many
users there are for your current bookkeeping software, how much you pay
for that software annually, what modifications you would need to make
GnuCash palatable to your data entry employees and so on. Your firm
would have to do an analysis of those factors and others to determine
what path makes the most sense. 

GnuCash is not a fiscally sponsored nonprofit project of the Software
Freedom Conservancy (https://sfconservancy.org/), Software in the Public
Interest (https://www.spi-inc.org/), the Free Software Foundation
(https://www.fsf.org/working-together/fiscal-sponsorship), Open
Collective (https://opencollective.com/), so donations to GnuCash
(https://gnucash.org/donate.phtml) are not tax deductible for US
taxpayers, but if your firm pays a developer to add features to GnuCash,
then those expenses could be written off as business expenses. 

There are also GnuCash developer mailing lists that you could use to ask
if a developer is interested in adding the features you need and how
much they would charge for such work -
https://wiki.gnucash.org/wiki/Mailing_Lists#Mailing_Lists_for_Development_Topics
 

Odoo (https://www.odoo.com/) is another option for accounting firms
(https://www.odoo.com/accounting-firms) interested in open source
software solutions. 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-09-03 04:54, Derek Atkins wrote:

> Hi David,
> 
> I will attempt to answer your questions in-line below...
> 
> On Mon, September 2, 2024 7:56 am, David Gay wrote: 
> 
>> Good afternoon,
>> 
>> Our firm is using GnuCash as an accounting software and I want to ask some
>> questions:
>> 1. Can multiple users be added to using gnucash? so I, as an accountant,
>> could check what type of data other people working insert into software.
> 
> GnuCash is not a multi-user application -- only one person can be using it
> at a time.  Moreover, there is no centralized auditing feature, so no,
> there is no way you can easily see what others are entering.
> 
> Having said that, there /is/ the transaction log..  But it's not meant as
> an auditing tool.  It's not user-friendly.  And it's stored locally on the
> user's machine, not "shared" with the data file.
> 
> One option is that you could open the General Journal, view all
> transactions, and then sort transactions by date-entered.
> 
>> 2. Could there be any modifications made to GnuCash initial soft version?
>> For example if our firm wants to customize the software and make it more
>> convenient for our specific tasks, could all this be done by modifying
>> GnuCash initial code? If it can be done, could you provide such a service
>> to us? I mean the coders who would do specific modifications for us for
>> the
>> payment.
> 
> GnuCash is open source, so yes, you could certainly make changes to the
> software.  Whether you could find a developer to pay to work on it is a
> different question.
> 
>> 3. Can I add more users to the software? So multiple users could
>> input transactions to it
> 
> At this time, no, GnuCash is not multi-user nor does it allow parallel
> entry.  The best you could do is store the GnuCash file on a shared
> storage server and then the individual users could open the file when they
> need to make entries and then close it when they are done.  But you will
> need an out-of-band mechanism to ensure that only one person has the file
> opened at a time.  If multiple people have it opened, then the "second"
> will overwrite the changes of the "first".
> 
>> 4. How can I add typical journal entries to the software? So that a user
>> who does not understand the double-entry system can enter the transaction
>> type in the description, or somewhere else, and the journal entry is
>> created automatically according to the recorded transaction type.
> 
> GnuCash is double entry.  There is no "shortcut" around that.
> 
> The closest you have is basic entry mode -- but when entering transactions
> you always have to specify the "other

Re: [GNC] How do I invoice a customer which he pays with billable services by him?

[Brad Morrison]

Hi Michael/GnuCash, 

https://www.irs.gov/taxtopics/tc420 - "Topic no. 420, Bartering income" 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-08-30 05:32, Michael or Penny Novack via gnucash-user wrote:

> On 8/29/2024 6:17 PM, Mark at Lorimark wrote: 
> 
>> (not an accountant)
>> 
>> That sounds like 'barter' which should probably not be on the books?
> 
> Not an accountant or tax advisor
> 
> Neither am I but see topic "402 Bartering Income" on the IRS site.
> 
> This one of the situations best NOT writing about an instance about because 
> commonly "cheated on" if those engaged in barter are sure no auditing trail 
> left behind. But here part of the exchange was in money.
> 
> LOL, decades ago we were visiting in an "end of the road" community that by 
> government reckoning was extremely poor. Our hosts told us that poor, but not 
> nearly as poor as in the gov't statistics because most of the local economic 
> exchange was done by barter and  off the books. While there, the flutter 
> valve in my Saab's fuel pump snapped. A local mechanic towed us a good 
> distance to his shop, where in exchange for a shop manual for the car* (not 
> expensive for me replace) and a small amount of cash** he took apart the fuel 
> pump and hand cut a replacement flutter valve from a bit of aluminum sheet 
> stock (after noting that the flip lib of a soda can was the same thickness as 
> the snapped flutter valve) which worked well enough to get us hundreds of 
> miles home. The total cost to me was a small fraction of what the tow, 
> diagnosis, and repair would have cost me in the city. Our hosts felt we had 
> been cheated!
> 
> Michael D Novack
> 
> * Not like comes with the car or a "Chiltens" but a full shop manual which I 
> carried as at the time Saabs uncommon in many areas. This mechanic had 
> shelves where he had shop manuals for as many as he could get a hold of, and 
> hadn't yet one for Saab. Like I said, a real out of the way end of the road 
> place.
> 
> ** In defense, the people of this community could scarcely comply with the 
> IRS since the latter's evaluation of "fair market value" would not be taking 
> into account the LOCAL "fair value". In other words, when goods/services were 
> exchanged for money, that was a far smaller amount than "outside". Remember 
> our host's feeling we had been cheated.
> 
> ___
> 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] IRA value

[Brad Morrison]

Hi Fred/GnuCash, 

The current version of GnuCash is 5.8 -
https://gnucash.org/download.phtml  

The current version of Fedora is 40 - https://fedoraproject.org/ 

It is always a good idea to run the current version of software (that
will work on your hardware) so that one benefits from the security
improvements and feature enhancements. 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-08-29 15:56, Fred Tydeman wrote:

> I have updated stock prices.
> I have run the Advanced portfolio on an IRA to get Total value.
> If I look at the Accounts tab for that IRA, the Present(USD) value
> is 9% lower than the report  value.  Why?
> 
> Gnucash 4.14 on Fedora Linux 37
> ___
> 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] Assets with two different currencies and buy/sale in different currencies?

[Brad Morrison]

Hi Boniforti/GnuCash, 

What version of GnuCash are you using? What operating system are you
using? https://gnucash.org/download.phtml 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-08-26 11:13, Boniforti Flavio wrote:

> Hi all.
> I'm starting to set up my accounts on GnuCash and I'm actually stuck
> understanding how (or even if) I should add the following.
> I do own a music studio with a collection of vintage instruments. As the
> whole gear is worth quite some k, I thought I'd add it as an asset. So
> first questions here: is it correct? Does it make sense?
> Let's assume I will add it as an asset, the next question is around the
> corner. I buy my gear in two different currencies, thus I would've thought
> to set up two different asset accounts: one in currency A and one in
> currency B. So far so good. Now the (for me) difficult part comes: I also
> sell items of my collection sometimes and when I do, the transaction can be
> in either one of the two currencies I bought them. Assuming I bought an
> item in USD and I sell it in CAD, how would I have to enter this
> transaction in GnuCash?
> 
> As an additional info (maybe irrelevant, but anyways): as of today I
> maintain a spreadsheet with the price I paid for a specific piece of gear,
> including the currency I used. At the same time, I do a currency conversion
> and fill the adjacent column with the converted value (e.g. bought for 1200
> USD I put the equivalent 1630 CAD in the other column).
> 
> Thanks for any help!
> F.
> 
> https://www.instagram.com/boniforti_music
> https://soundcloud.com/boniforti_music
> https://bonny-j.bandcamp.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.
___
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] Invoice numbers within Customer Report

[Brad Morrison]

Hi Liz/GnuCash users, 

https://bugs.gnucash.org/show_bug.cgi?id=799386 - here is your bug
report. 

The bug report does not specify if you are using the Flatpak or
distribution/system package of GnuCash - ? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-07-22 16:09, Liz wrote:

> I find the invoice numbers do not appear consistently within the
> Customer Report.
> I can't say when it started, because only in the last few years have I
> been using the Customer Reports consistently.
> It does not matter if the invoice number is external to Gnucash or is
> generated by Gnucash.
> 
> I've filed a bug
> Bug 799386 - Invoice numbers do not always appear on customer report 
> 
> and welcome anyone else using Customer Reports to add any information
> if they see the same behaviour.
> 
> 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] Check & Repair

[Brad Morrison]

Hi Art/GnuCash community, 

Just so we are all on the same page here, what operating system and
version of GnuCash are you having the 'check & repair' issues on? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-07-21 23:58, G R Hewitt wrote:

> There is some visual feedback when using 'Check and repair' on the status
> bar bottom right, but blink and you will likely miss it.
> It would nice to have a pop-up that says something like 'C and R completed,
> no errors' or a list of corrected errors, if any.
> Feedback is important.
> 
> On Mon, 22 Jul 2024 at 06:35, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
> 
> If I'm not mistaken, when you upgrade, GnuCash will automatically make
> necessary adjustments to your file when things change internally from
> version to version. (for example, one version long ago, changed how time
> stamps were internally recorded, but nothing changed visibly to the
> user) Sometimes, this doesn't happen automatically or complete itself
> for various reasons. This feature exists in the menu, to 'force' the
> adjustments. This is why intentionally running it is included in the
> recommended upgrade procedures in the Wiki.
> 
> Outside of that scenario, I'm not sure what, if any, benefit exists in
> using that feature.
> 
> Regardless, feedback would still be nice.
> 
> Regards,
> Adrien
> 
> On 7/21/24 10:40 PM, sunfish62--- via gnucash-user wrote: ISTR that the 
> feature runs silently, and that in recent versions it runs rather quickly, 
> such that the user doesn't even see any action. I agree it
> would be nice to have some concluding pop-up for informational purposes.
> 
> ___
> 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] Same currency pair, two places, same date

[Brad Morrison]

Hi Fred/GnuCash, 

https://fedoraproject.org/ - the current version of Fedora is 40 

https://gnucash.org/ - the current version of GnuCash is 5.8 

It is best to update to the current versions first so as to reduce the
amount of variables in troubleshooting issues for a project with limited
resources. 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-07-12 01:30, Fred Tydeman wrote:

> In looking at my Price Database for Currencies,
> I see that the conversion rate for a pair appears twice
> for the same date.
> Under COP there is a USD entry for June 30 of 0.000239
> Under USD there is a COP entry for June 30 of 4148
> So, which one is used for reports?
> Is this going to cause issues?
> 
> In looking at other values, I see that most of them in both
> COP and USD came from Finance::Quote, but at different dates.
> 
> There are a few user:price-editor entries.
> 
> I am running Fedora Linux 37 and Gnucash 4.14
> ___
> 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] Zeros in Balance sheet

[Brad Morrison]

Fred & GnuCash users, 

Although this might not be specific to your issue: 

The current version of Fedora Linux is 40 -
https://fedoramagazine.org/announcing-fedora-linux-40/ &
https://fedoraproject.org/ &
https://distrowatch.com/table.php?distribution=fedora  

The current version of GnuCash is 5.6 -
https://gnucash.org/download.phtml#distribution &
https://repology.org/project/gnucash/versions &
https://flathub.org/apps/org.gnucash.GnuCash  

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2024-06-20 07:03, Fred Tydeman wrote:

> Fedora Linux 37
> GnuCash 4.14
> 
> Doing  Reports: Assets&Liabilities: Balance Sheet
> In the Options: Display:
> I uncheck Include accounts with zero total balances
> I check Omit zero balance figures
> 
> If I take the default of 3 Levels of subaccounts
> the report has lots of lines with zero amounts.
> 
> If I change the Levels of subaccounts to All,
> then the zero entries go away.
> 
> Seems wrong.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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] GC Best Practices for Investment Management

[brad]

Yes, I think it's very useful to have all of my financial data in GC, 
even tho it doesn't do everything that I want.  I haven't found the 
brokerage firms analysis tools useful.   They seem to be oriented toward 
the active investor & do their best to encourage trading.
I'm an index fund, buy and hold, investor.   I use a balance sheet 
report in GC which I export then use some script and Octave tools to 
generate an asset allocation report where I keep running log in a 
spreadsheet.   It's messy but I don't know anything about Scheme, so 
this was easier for me.


I still rely on the brokerage data for cap gains and taxable stuff, but 
I try to make sure my GC data is consistent.



On 11/8/23 11:16, Jediator wrote:
After dumping QB and using GC for couple of months, I started really 
enjoying its features and simplicity.  I noticed that a major feature 
in GC is the stock and investment management function, which I was 
hesitating to get into.  I'd like to hear from fellow GC users on the 
usefulness and best practices for using GC for investment management.  
Especially:


1. GC was developed in the 90's before many brokerage firms offer
   portfolio management and analysis tools.  Is it really useful to
   replicate your investment data in GC from your brokerage account?
   What are the advantages does GC bring in doing this other than
   calculating capital gain taxes/loss?
2. What types of direct reporting functions in GC for investment
   management (Info in tool guide and online Wiki seems to be outdated)?
3. How do you compare GC with other open source products (e.g.,
   Ghostpolio)?

Thanks a lot in advance! -- JC


___
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 5.4 Repackaged

[Brad Morrison]

Hi GNC folks,

I have not contributed much to this mailing list lately and have been 
dealing with other things, so I did not realize how much has changed.


I tried to look at the bug report cited below 
(https://bugs.gnucash.org/show_bug.cgi?id=799092), but GnuCash seems to 
use BugZilla to manage the bug reports. I have a BugZilla account for 
contributions I have tried to add to Mozilla products (Firefox & 
Thunderbird), but that BugZilla account does not work in the GnuCash 
version of BugZilla and I was unable to log in 
(https://bugs.gnucash.org/show_bug.cgi?id=799092&GoAheadAndLogIn=1). The 
Bugzilla websites/URLs are also setup differently for GnuCash & Mozilla.


I then tried to use my GnuCash mailing list account 
(https://wiki.gnucash.org/wiki/Mailing_Lists & 
https://lists.gnucash.org/mailman/listinfo) and was also not able to log 
in to GnuCash's version of BugZilla 
(https://wiki.gnucash.org/wiki/Bugzilla & 
https://bugs.gnucash.org/enter_bug.cgi?product=%E2%88%82Bugzilla).


GnuCash still uses Mailman 2.1.29 
(https://www.gnu.org/software/mailman/index.html), which looks like it 
was released in July 2018 (http://ftp.gnu.org/gnu/mailman/).


I then tried to log in to Mozilla's version of BugZilla 
(https://bugzilla.mozilla.org/home) and was able to successfully 
(https://bugzilla.mozilla.org/user_profile?user_id=713226), but that log 
in did not carry over to GnuCash's version of BugZilla.


I am still not logged in and I would like to have no more than 1 account 
per software application that I use.


So, it would be nice if GnuCash could integrate the various online 
account systems that it uses (Mailman, BugZilla, whatever else) so that 
users would only have to have 1 log in for all of GnuCash. That is still 
way more decentralized that having a single Apple, Google, or Microsoft 
login that applies to dozens (hundreds?) of different websites.


I use Linux Mint 21.2 (https://linuxmint.com/edition.php?id=305). LM 
21.2 (https://linuxmint.com/rel_victoria_cinnamon.php) is based on 
Ubuntu 22.04 "Jammy Jellyfish" 
(https://discourse.ubuntu.com/t/jammy-jellyfish-release-notes/24668). In 
the LM Software Manager, there are 2 options for GnuCash, the "System 
Package" option lists version "1:4.8-1build2" & the "Flatpak (Flathub)" 
option lists version "5.4+ (Flathub 5.4.1)." That basically matches with 
what is listed on Repology for GnuCash 
(https://repology.org/project/gnucash/versions - GNU version 4.8 for 
Ubuntu 22.04).


LM 21.2 is the most current version of Linux Mint 
(https://linuxmint.com/download_all.php), but Repology lists the 
repository for Ubuntu 22.04 as having 17,168 out of 35,549 packages 
outdated (https://repology.org/repository/ubuntu_22_04).


The GnuCash download page (https://www.gnucash.org/download.phtml) lists 
plenty of stable releases for Windows, Mac, & various Linux distros. 
There seem to be 9,557 versions of GnuCash listed on the SourceForge 
download page (https://sourceforge.net/projects/gnucash/files/).


Stan's GnuCash email name lists him as using GnuCash 4.14, so I'm not 
sure if he is actually using 5.4 or 5.4.1 - ?


Christopher Lam is linking to the index of 32 bit builds for Windows 
(https://code.gnucash.org/builds/win32/stable/), I am surprised that 
GnuCash still releases & supports/maintains 32 bit versions for Windows - !


At the bottom of the GnuCash homepage 
(https://www.gnucash.org/index.phtml), it still lists that GnuCash 4.0 
has been released (https://www.gnucash.org/new_features-4.0.phtml).


OK, so I say all of that because my main point is that that is too much 
to keep track of. I don't know how GnuCash can be reasonably expected to 
accurately manage and/or maintain that many different options for that 
many different operating systems. There seems to be so much effort put 
on adding to GnuCash and not reducing the number of options with the 
goal of reducing the amount of maintenance and work required to use 
GnuCash. While I am sure that there are plenty of reasons for GnuCash 
doing things this way, it seems to be a real drag on the project's success.


Hope this helps!

Brad


On 9/29/23 12:11, Stan Brown (using GC 4.14) wrote:

On 2023-09-29 09:22, john wrote:

On Sep 29, 2023, at 04:07, Ian Keiller via gnucash-user 
 wrote:

Odd thing happens when trying to update from 5.4 to 5.4.1 on Windows. Setup 
shows an error:
The following applications are using files that need to be updated by Setup. It 
is recommended that you allow Setup to automatically close these applications. 
After the installation has completed, Setup will attempt to restart the 
applications.

GnuCash Program File.

On cancelling, I noticed in Task Manager there is an instance of GnuCash still 
running even though I had exited the the application.
I have never seen this behaviour before, so could it be a bug introduced in 5.4?

http

Re: [GNC] Importing stock prices from a CSV file

[brad]

Here's a couple of examples:
https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file
https://wiki.gnucash.org/wiki/Stocks/get_prices


On 9/29/23 16:33, flywire wrote:

I'll work with the Price Import Assistant druid. Is it actually documented?
I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices

___
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] Reply convention

[Brad Morrison]

I know that GnuCash (https://lists.gnucash.org/mailman/listinfo) does 
not use the current version of the Mailman mailing list software (now 3, 
not 2 - https://www.gnu.org/software/mailman/), but does anyone know if 
the various email formatting conventions 
(https://wiki.openstack.org/wiki/MailingListEtiquette) can be adjusted 
by the mailing list user at the email client level?


Thanks,

Brad


On 7/19/23 14:10, R Losey wrote:

On Wed, Jul 19, 2023 at 5:05 AM Chris Green  wrote:


On Tue, Jul 18, 2023 at 03:28:34PM -0500, R Losey wrote:

On Mon, Jul 17, 2023 at 3:37 AM Paul Feakins  wrote:


On 15/07/2023 01:56, R Losey wrote:

Is there really a convention for replies?

Indeed there is:
https://wiki.openstack.org/wiki/MailingListEtiquette#Replies



Thanks for the link; it isn't specific to GnuCash, but that's okay.

However, it does seem outdated - limiting a line to 72 characters when

most

browsers and email clients are capable of doing line wrap?


Yes, but eyes aren't!  Something around 80 characters (i.e. 72 plus a
bit) is the best line length for our eyes to read.



And plain text only?


What else are you going to do?  Anything more is likely to be
differently interpreted by different users' software so the result you
intend is likely to be lost on many users.  There are standard ways of
indicating emphasis and such using just plain text.



This doesn't appear to be plain text... perhaps I'm associating plain text
with fixed-width fonts.
But if this works, that's fine.

Regarding line length, I thought you could set your browser or email client
to wrap at whatever length one wishes.


_
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.


___
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] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

[Brad Morrison]

Hi Michael/all,

It does not appear that Square lists a GnuCash app as an option - 
https://squareup.com/us/en/app-marketplace Square also doesn't have Odoo 
(https://www.odoo.com/) listed as an app option.


I do not know what those kinds of technical integrations would involve, 
but I assume that it would be a lot of work!


My point in reminding people of the limits of GnuCash's capabilities is 
to say that if we want to increase those capabilities, they need to be 
paid for. It is unfair to expect people to donate as much to this or any 
open source project as the core folks of such projects typically do.


"If anyone is interested in expanding GnuCash's capabilities, feel free 
to donate to the project here (https://www.gnucash.org/donate.phtml), 
just be aware that for US based taxpayers, GnuCash is not a 501c3 
registered nonprofit and does not have a fiscal sponsor like some other 
open source projects (https://sfconservancy.org/projects/current/ or 
https://www.spi-inc.org/projects/), so those donations may not be tax 
deductible if the taxpayer itemizes their deductions 
(https://www.irs.gov/taxtopics/tc506)."


I wouldn't mind donating my time to try to help GnuCash apply to SFC 
&/or SPI to become a fiscally sponsored nonprofit, but I would need help 
and permission.


Thanks,

Brad


On 8/12/23 06:39, Michael or Penny Novack wrote:

On 8/12/2023 9:02 AM, Brad Morrison wrote:

Hi Gregory/Susan/Richard/all,

I think that it is important to remember that GnuCash is an all 
volunteer project and not an accounting system suitable for almost 
any type of organization, other than a very simple one:


https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278 
- "But GnuCash isn't suitable for large, or even small, enterprises 
and never will be. GnuCash is for tiny and simple enterprises; we 
often say individuals and sole proprietorships. Even having employees 
makes using GnuCash a dubious proposition (no payroll module), as 
does carrying more than a very few line items of inventory (no 
inventory module) or performing any sort of manufacturing (no bill of 
materials or cost accounting modules). 



I disagree in the sense that in the days of pen and ink on paper all 
of those things were done before we had computers. Using gnucash you 
can do anything you could pen and ink on paper.


What is being said is that gnucash is not an "integrated business 
system" with multiple components sending feeds to each other. 
Components like POS, inventory, payroll, etc. are not PART of 
":general ledger" (gnucash as normally used). Those other components 
would be storing data that isn't financial as well as what is and is 
sent to by "feeds".


For example, besides things like unit cost of batch an inventory 
system is dealing with things like shelving location, restock level, 
primary and secondary sources, etc. A POS system is tracking things 
like the ID of the sales person currently at the register. The payroll 
system things like emergency contact, length of service, etc.


MY druthers? I am opposed to "monolithic" systems, much preferring 
"modular" systems << and remember, I used to work on/design LARGE 
systems >> If nothing else, makes changing and testing MUCH easier 
since well defined boundaries and data exchange between components. So 
while I do not think the developers of gnucash should tackle these 
other components PERHAPS it would make sense to make gnucash (the 
general ledger component) a module that could receive "feeds". Then 
others could decide to tackle one or more of these other parts of "a 
business system". Hopefully also keeping them modular (as they might 
be feeding each other as well as feeding general ledger. For example, 
POS would feed both "general ledger" (the money part of the sale)  AND 
inventory  (the physical part of the sale).


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.


___
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] Need advice I use Quickbooks and only for personal use. All I do is bank accounts entries & credit cards, just use P&L & Balance Sheet reports

[Brad Morrison]

Hi Gregory/Susan/Richard/all,

I think that it is important to remember that GnuCash is an all 
volunteer project and not an accounting system suitable for almost any 
type of organization, other than a very simple one:


https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278 - 
"But GnuCash isn't suitable for large, or even small, enterprises and 
never will be. GnuCash is for tiny and simple enterprises; we often say 
individuals and sole proprietorships. Even having employees makes using 
GnuCash a dubious proposition (no payroll module), as does carrying more 
than a very few line items of inventory (no inventory module) or 
performing any sort of manufacturing (no bill of materials or cost 
accounting modules).


Adding those modules is a non-starter: Consider that it's been 10 years 
since we began working on separating libgnucash from the application, 
converting from GObject to C++, and changing from a program that can 
load its data from a SQL database and put it back to one that is built 
around SQL queries. We haven't gotten very far.


Those seeking a F/LOSS accounting solution for larger enterprises should 
look to Odoo." (https://www.odoo.com/ & 
https://www.odoo.com/accounting-firms)


I include that last part just to make any expectations you might have 
more grounded in the reality of GnuCash's current capabilities.


If anyone is interested in expanding GnuCash's capabilities, feel free 
to donate to the project here (https://www.gnucash.org/donate.phtml), 
just be aware that for US based taxpayers, GnuCash is not a 501c3 
registered nonprofit and does not have a fiscal sponsor like some other 
open source projects (https://sfconservancy.org/projects/current/ or 
https://www.spi-inc.org/projects/), so those donations may not be tax 
deductible if the taxpayer itemizes their deductions 
(https://www.irs.gov/taxtopics/tc506).


Good luck!

Brad


On 8/8/23 12:10, R Losey wrote:

On Tue, Aug 8, 2023 at 6:40 AM Gregory Robertson
wrote:


I'm use to QuickBooks Pro but as I mentioned I only use a few of the
features. Is this a good software for me to do just the basics. Also, I
just want to do on desktop, no online. I am not use to your format. Could
you please send me an answer tomswr...@gmail.com<mailto:mswr...@gmail.com>.
Thank you, Susan
___


I used Quicken for about 20 years and then changed to GnuCash... I also
only used it for checking, credit cards, and some investments.

I did not import anything; I just started afresh some years ago with
GnuCash (I figured that if I had to go back to Quicken, I could, but as the
years pass, this is less and less likely to be needed).

I have enjoyed GnuCash very much. I especially enjoy the fact that I can
run it on iMac, Windows, or Linux.

The one warning I'd give is that the reports in GnuCash are nowhere near as
ready-to-go as they were in Quicken. I struggled to get the reports to
report how and what I wanted.

But, on the other hand, people in this list are very helpful.

_
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.


___
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] Addition to basis

[Brad Morrison]

Hi Fred/Derek/flywire/all,

Maybe I am just not understanding the situation as you are describing 
it, but I have not ever seen a 1099DIV (the USA's IRS form for 
accounting for dividend payments - 
https://www.irs.gov/forms-pubs/about-form-1099-div) that also listed 
basis adjustments on it...? But I have only seen a few foreign/non-US 
dividend statements...


I understood basis adjustments to be accounted for when the asset is 
sold and the most common adjustments for US stocks are wash sales, but I 
can't ever remember seeing those noted on a 1099DIV, they are usually 
recorded on a 1099B (https://www.irs.gov/forms-pubs/about-form-1099-b).


If the asset is not being sold/disposed of 
(https://www.irs.gov/forms-pubs/about-schedule-d-form-1040 & 
https://www.irs.gov/taxtopics/tc703), would just making a note that 
could carry forward to the next year be the easiest thing to do?


Maybe I am just not understanding, are there more details that you could 
share with us?


Thanks,

Brad

P.S. Although I like to include all the related emails in my response, 
Thunderbird (the email client I use - 
https://www.thunderbird.net/en-US/) is separating flywire's email, even 
though it has the same subject line, from Fred & Derek's emails...?



On 8/8/23 13:32, Derek Atkins wrote:

Hi,

On Tue, August 8, 2023 4:12 pm, Fred Tydeman wrote:

How does one record an Addition to basis for a stock?

The splits involved are:
   Income: qualified div
   Income:  non-qualified div
   Expense: foreign tax
   Asset: cash
   Imbalance -- should be addition to basis

I have tried changing the Imbalance to
   Asset: stock
with a price of 0.00, but gnucash adds shares with a price of 1.00

ISTR there are "issues" with this...  Keep in mind, when entering data in
the stock account, you need to enter TWO of the three values (#shares,
price, and value), and GnuCash will compute the third.  Note that it's the
#shares and total value that is stored, the price is always computed.  In
THIS particular case, you can TRY to enter 0 shares and the change in
value, but I'm not 100% sure GnuCash will like that.  It's been a while
since I played in the stock accounts.


Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek


___
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] Wells Fargo OFX

[Brad Morrison]

Hi Chris/all,

Did you already review the information & links from my last email 
responding to your OFX/online banking issues?


https://lists.gnucash.org/pipermail/gnucash-user/2023-July/107875.html

If so, did you have more specific questions?

Thanks,

Brad


On 7/22/23 19:13, Chris Miller wrote:

Hi Folks,
I bank with Wells Fargo and have done so for 30 years. I've used
QuickBooks and Quicken for most of that time and they have worked out
well. Regardless, I am not a fan of Intuit.
I'm investigating GnuCash, and the thing I find most important is being
able to synchronize my accounts with Wells Fargo. However I'm not
finding much advice on how to set up OFX.
Does anybody have experience with this? Does anybody have advice for me
on how to do it, or if I should do it.
Thanks for the help,
Chris.
Laboriously sent to you from my ... do you really care?
___
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] user groups that meet in person?

[Brad Morrison]

Hi Steve/all,

I have not seen anything posted to this Mailman 2 mailing list about in 
person user groups specific to GnuCash in the last 6 months...


You may have some luck/interest in GnuCash from the few Linux User 
Groups (https://en.wikipedia.org/wiki/Linux_user_group) that are still 
active, including NYLUG (http://nylug.org/), LILUG 
(http://www.lilug.org/), NJLUG (https://www.meetup.com/NJLinux/), and 
several others in the areas you listed.


I am on the "board" of the North Bay Linux Users Group 
(https://nblug.org/) and we have been meeting monthly for about the last 
1.5 years since the common pandemic hiatus. I also find it very helpful 
and enjoyable to meet others in person and discuss 
interests/questions/issues/etc.


One of my projects has been to scout out interest in forming a 
national/international umbrella organization of LUGs because so many of 
the local groups are scattered and not organized into a registered 501c3 
nonprofit organization. While that structure totally makes sense for 
smaller, all volunteer orgs, if all those independent LUGs had some 
organizational, financial, technical, marketing/PR, & legal structure & 
support, it would be a tremendous help and likely minimize the 
disruptions caused when a key member moves away or loses interest and 
the LUG falls apart. Even for the existing and ongoing LUGs like NBLUG, 
when we migrated our Mailman server from 2 to 3, no one in our group had 
done it before and it was a struggle. Having optional, central support 
for very occasional tasks like that makes updates/changes much easier 
and provides redundancy/backup for when something fails (like when the 
Texas storms took out the GnuCash website server and there was trouble 
with the host's ISP for weeks afterwards & the security/https 
certificates expiring/not redirecting correctly & some scrambling around 
trying to create and use workarounds for almost 2 months in early 2023 - 
https://lists.gnucash.org/pipermail/gnucash-user/2023-March/thread.html). 
The Linux Foundation (https://www.linuxfoundation.org/) offered some 
support & resources 
(https://lists.linuxfoundation.org/mailman/listinfo), but they are not a 
501c3. The Software Freedom Conservancy 
(https://sfconservancy.org/projects/services/) & Software in the Public 
Interest (https://www.spi-inc.org/membership/) are both 501c3 nonprofits 
and both fiscally sponsor nonprofit, open source projects, but SFC  has 
not been responsive (they seem overwhelmed with their current work) and 
I should check in with SPI...


GnuCash is also not a sponsored project of any 501c3 nonprofit org that 
I know of, so donations from US taxpayers are not deductible, but still 
greatly appreciated - https://gnucash.org/donate.phtml


Apologies for 'hijacking' your post, but you likely figured out that 
with no responses in 4 days, the basic answer was no.


Good luck!

Brad


On 7/13/23 14:38, Steve Freeman wrote:

Are there any user groups that meet in person? I'd really like to
occasionally work with others. Live in Connecticut, but travel to New York
(especially Westchester), New Jersey  and Philadelphia.

  


Steve Freeman

___
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] Migration and On-lind banking Manuals

[Brad Morrison]

Hi Chris/David/all,

While David covered some of the aspects of migrating your QuickBooks 
files into GnuCash, as far as online banking, I would suggest checking 
out https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect & 
https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings and 
seeing whether what you are hoping to do is possible with GnuCash and 
with the financial institution(s) that you use.


https://www.ofxhome.com/ - might also be helpful for determining the 
connection settings for the financial institutions listed there


https://financialdataexchange.org/ofx - I have heard from others on this 
GnuCash mailing list that OFX is not well maintained and further 
development is iffy. "Death by a thousand cuts" is how one person 
described OFX (https://en.wikipedia.org/wiki/Open_Financial_Exchange).


You also mentioned 'company files' in QuickBooks and while I am not 
exactly sure what you mean by that, if you have anything other than a 
very simple business, GnuCash may not work well for you:


https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278 - 
"But GnuCash isn't suitable for large—or even small;mdash;enterprises 
and never will be. GnuCash is for tiny and simple enterprises; we often 
say individuals and sole proprietorships. Even having employees makes 
using GnuCash a dubious proposition (no payroll module), as does 
carrying more than a very few line items of inventory (no inventory 
module) or performing any sort of manufacturing (no bill of materials or 
cost accounting modules).


Adding those modules is a non-starter: Consider that it's been 10 years 
since we began working on separating libgnucash from the application, 
converting from GObject to C++, and changing from a program that can 
load its data from a SQL database and put it back to one that is built 
around SQL queries. We haven't gotten very far.


Those seeking a F/LOSS accounting solution for larger enterprises should 
look to Odoo <https://www.odoo.com>." (https://www.odoo.com/ & 
https://www.odoo.com/accounting-firms)


I include that last part just to make any expectations you might have 
more grounded in the reality of GnuCash's current capabilities.


Good luck!

Brad


On 7/16/23 19:22, David Cousens wrote:

Chris,

If you will have ongoing access to Quickbooks then it is reasonable just to
start by transferring the balances. If for some reason (unable to run the
program in future due to platform change etc etc) you will not have access but
still have a need to access the previous records, then data migration.

When I first moved to GnuCash I had previous data from a business in MYOB.
Initially I just transferred the balances but eventually I transferred the data
for previous years using CSV export and import into GnuCash. I worked back wards
a year at a time resetting the opening balances. I produced balance sheets for
each year and Profit/Loss reports in MYOB before starting and ensured the
corresponding reports in GnuCash matched after completing the import of data for
a given year.  If the reconciliation was valid to some date (eg start of a
current period) before beginning the import and it still works on the major
accounts to the same date after import, you can be reasonably sure that you
haven't introduced too many major errors. If it doesn't agree use the usual
procedures to locate errors in the records until the reconciliation is in
agreement again. Gnucash will show any unreconciled transactions from past
periods in the reconciliation dialogue for a reconciliation to a dtae in the
current period and you can keep a reconciliation dialogue open while importing
the data.
  
Quickbboks IIF files seem to be tab separated CSV files so GNucash's importer

should be able to handle them.

With the importer it is usually good practice to initially import relatively
small batches until you work out the correct associations between columns in the
expoprted data and the corresponding headings within GnuCash. It is possibly a
good idea to initially do this on a dummy set of books to sort out the problems
and only import into your working books once you have it sorted and routine. I
imported data a month at a time going backwards when I initially did this (circa
2010) and gradually moved to 6 months and then a year at a time when I had a
reliable methodology worked out.

Make frequent backups of the data file as you work backwards.

Another approach that I didn't try was to enter the historical data into a
separate data file from the file for the current data going forward.

Good luck

David Cousens

On Sun, 2023-07-16 at 18:13 -0700, Chris Miller wrote:

Hi Folks,

I have a few Intuit QuickBooks "Company Files" that I will migrate to GnuCash.
I'm looking for migration advice.

It is not clear how much history I want to take with me. I may simply start
with exiting account balances, and li

Re: [GNC] Finance::Quote - AlphaVantage Trade Currencies

[Brad Morrison]

Hi Bruce/all,

Thank you for all your hard work with F::Q!

Does it also make sense to post this situation & question to the other 6 
GnuCash Mailman 2 mailing lists that are not in English? 
https://wiki.gnucash.org/wiki/Mailing_Lists & 
https://lists.gnucash.org/mailman/listinfo


I have never used F::Q in GnuCash (or at all), so maybe my point is 
useless or maybe you already are signed up for those other language 
lists. I was just thinking that there may be many more users of AV for 
non-US traded securities on the other language lists than English - ?


In my work for a tax & wealth management firm (on the tax side), I most 
frequently interact with non-US traded stocks when an IRS form 1099DIV 
(https://www.irs.gov/forms-pubs/about-form-1099-div) or 1099B 
(https://www.irs.gov/forms-pubs/about-form-1099-b) indicates that 
foreign taxes were paid and my role is account for those foreign taxes 
paid & to determine whether an IRS form 1116 
(https://www.irs.gov/forms-pubs/about-form-1116) is needed.


While I am mentioning the GnuCash mailing lists, does anyone know if 
there are plans to upgrade from Mailman 2 to Mailman 3? 
https://www.gnu.org/software/mailman/ & 
https://en.wikipedia.org/wiki/GNU_Mailman


2.5 securities per minute seems really slow!

Brad


On 7/16/23 15:52, Bruce Schuck wrote:

Hello again,

At some point I am going to take a break from F::Q, I thought this 
weekend I was going to escape.


### For the question, skip to the next ###

Anyway, some time ago the issue was raised about prices from 
AlphaVantage for LSE traded stocks (see 
https://github.com/finance-quote/finance-quote/issues/281). While 
there is an issue, the user's perceived solution was not the answer. 
Apparently my attempt to explain that the root cause was that the data 
returned from the AV "GLOBAL_QUOTE" API did *NOT* contain the currency 
used for the pricing returned.


What the AV module does is assign a currency based on the suffix of 
the lookup symbol. So stocks like GBP.L and GBPG.L get mapped to GBP. 
The problem is that GBP.L (Global Petroleum Limited) is traded in GBX 
(aka GBp) and GBPG.L (Goldman Sachs Access UK Gilts 1-10) is traded in 
GBP. But the AV module as written cannot differentiate since the 
currency used is not part of the data. Stocks from South Africa have a 
similar issue.


Needless to say, since I was not ready to dig into the root cause and 
not wanting to remove the fix that was meant to convert GBp pricing to 
GBP pricing based solely on the symbol's suffix, the user decided to 
go on a rant and throw a tantrum in the comments and had to be blocked 
from the Finance::Quote repository.


### Question here ###

The currency for the trades can be gotten from AV, but an additional 
call using the "SYMBOL_SEARCH" API is necessary. Obviously this would 
impact the throttling limitation of AlphaVantage. For non-US stocks, 
this means that including an additional currency lookup an average of 
2.5 securities can be fetched per minute. I am curious how many of you 
all use AV for non-US traded securities? Has the pricing discrepancy 
affect you, and would you want it corrected even though that means 
increasing retrieval time due to the extra API usage?


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.

Re: [GNC] installing Gnucash

[Brad Morrison]

Hi Warren,

Have you already followed the instructions on the Wiki for the operating 
system on the device that you are using?


https://wiki.gnucash.org/wiki/Installation

Brad


On 7/14/23 20:25, Warren Dinte wrote:

Could you please give me a step by step guide fore installing GnuCash.I 
have downloaded from both advised sources, and the program has been saved to my 
computer.

But where do I go from here?I have tried various means to get the program 
up and running but after two days of repeated attempts I have given up trying.

Could you please give me a step-by -step guide to get going.

Warren Dinte

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986>  for Window

___
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] automatically account for gst on random purchases

[Brad Morrison]

Thanks flywire!

That GitHub Pull Request link takes me to a comment from John Ralls that 
very succinctly summarizes the difficulties of using GnuCash for larger 
or more complex enterprises.


The rest of that comment is: "Adding those modules is a non-starter: 
Consider that it's been 10 years since we began working on separating 
libgnucash from the application, converting from GObject to C++, and 
changing from a program that can load its data from a SQL database and 
put it back to one that is built around SQL queries. We haven't gotten 
very far.


Those seeking a F/LOSS accounting solution for larger enterprises should 
look to Odoo <https://www.odoo.com>."


I had never heard of Odoo before I read that comment 
(https://www.odoo.com/). From Odoo's website, I also found a small list 
of accounting firms that use Odoo (19 are listed for the USA at 
https://www.odoo.com/accounting-firms). Although that listing is 
organized strangely to me, the firms are listed by "city, USA" NOT 
"city, state, USA" or even "state, USA" and the US is a large country 
with 50 states and 330+ million people, so there are many cities with 
the same name... Regardless, some of the firms on that list may also be 
interested in using GnuCash for "tiny & simple" enterprises, thus the 
occasional requests for bookkeeping/accounting help for businesses that 
use GnuCash may have some more leads available!


flywire: you mentioned that you use QuickBooks for business, have you 
tried using Odoo?


For anyone else following this thread, but unsure as to exactly what GST 
is, I'm assuming that we are talking about the tax concept (and not 
likely the American version of GST) - https://en.wikipedia.org/wiki/GST


I'm sure that the GnuCash developers would appreciate any financial 
support from anyone regularly using this software and/or asking for new 
features/updates to be implemented/investigated 
(https://gnucash.org/donate.phtml). For American taxpayers that itemize 
their deductions, just keep in mind that GnuCash is not a 501c3 
nonprofit, nor a fiscally sponsored project of an existing, registered 
501c3 nonprofit 
(https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106798.html), 
so those donations may not be tax deductible 
(https://www.irs.gov/help/ita/can-i-deduct-my-charitable-contributions).


Brad


On 6/18/23 04:37, flywire wrote:

https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278
"GnuCash is for tiny and simple enterprises; we often say individuals and
sole proprietorships. Even having employees makes using GnuCash a dubious
proposition (no payroll module), as does carrying more than a very few line
items of inventory (no inventory module) or performing any sort of
manufacturing (no bill of materials or cost accounting modules)."

GnuCash supports GST for Accrual Accounting but not Cash Accounting, go
figure.

-

I proposed a process for Cash Accounting with Automated GST:
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
TLDR; Automate GST for cash accounting by preprocessing transactions to
enrich with GST and import as a multisplit file

1. This isn't going to work on random transactions, you need to know which
accounts have GST
2. I already preprocess bank transactions in a spreadsheet before importing
but I haven't got around to splitting for GST (because I still use
QuickBooks for business)
3. I'd probably do the splits in python and integrate it into LibreOffice
Calc

If anyone is interested I'll work on it.


https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107405.html  R

Losey wrote:

You MIGHT be able to get fancy by getting the data into a spreadsheet,
having macros to assign the GST and travel categories, and then import the
spreadsheet into GnuCash.


https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107404.html

Karl May wrote:

For my business setup I am wondering whether there is a way to
automatically
account for gst on small random purchases (e.g. hotel, restaurant etc.).

My current setup is roughly

Assets:financial_assets:bank_account
Assets:financial_assets:gst
Expense:travel

So far I haven't setup Accounts/payable and Accounts/receivable.

The current process is:

A) import bank account transactions via OFX into "bank_account" and
"imbalanced"
B) manually go through all transaction, use "split transaction",

manually

calculate the gst and assign amounts to Expense:travel and
Assets:financial_assets:gst.


Any suggestions how this can be automated such that the default is a
transaction split and application of a default GST rate?

Regards
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https:

Re: [GNC] OFX transactional data downloads from FDIC insured banks

[Brad Morrison]

Aha, thanks Kalpesh! I did not understand the technical differences 
between OFX (https://financialdataexchange.org/ofx & 
https://en.wikipedia.org/wiki/Open_Financial_Exchange) & QFX 
(https://en.wikipedia.org/wiki/QFX_(file_format)).


So based on what you are highlighting here, GnuCash does NOT typically 
have issues importing downloaded QFX files (nor downloaded OFX files) 
and the main differences in GnuCash between OFX & QFX are the ability to 
directly connect to your financial institution using OFX Direct Connect 
- correct?


https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings & 
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect


If so, searching for a bank that specifically allows OFX transactional 
data downloads may just be pursuing open source only for the sake of 
being open source and may not be relevant to many GnuCash users. I have 
been surprised at how many people on this mailing list still use Windows 
and Mac OSs, but what do I know...


https://financialdataexchange.org/ofx - this OFX Work group page does 
not appear to have been updated since my May 18 email (below), so I will 
cc the FDX email addresses I found once again. Silicon Valley Bank is 
still listed as a "Active OFX solution providers participant" although 
SVB does still seem to exist as a division of First Citizens Bank 
(https://www.svb.com/). And 2020 is still listed as the copyright year 
for FDX at the bottom...


I will look more into Plaid later - 
https://en.wikipedia.org/wiki/Plaid_Inc.


Thanks,

Brad

On 5/22/23 11:21, Kalpesh Patel wrote:

I can confirm thathttps://www.chase.com/  provides download of accounts (credit 
card, checking or saving) in QFX format from their web site. At one Chase even 
provided direct connect OFX download via an API call which they shuttered in 
2022. If you have Plaid then you can go to Plaid+ subscription to download 
somewhat delayed transaction in OFX format for number of financial institutions 
that do not provided direct connect OFX mechanism.

QFX format is proprietary of Intuit which contains colon separated key-value 
paired header information at the beginning of the file (like below) and then 
the standard XML OFX data payload:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

OFX importer in GNC simply ignores this header information hence it is quite 
often refers to as one and same in the GNC context.

  


-Original Message-
From: Brad Morrison  
Sent: Sunday, May 21, 2023 11:03 AM

To:gnucash-user@gnucash.org
Subject: [GNC] OFX transactional data downloads from FDIC insured banks

Hi Stephen/Bob/Gyle/all,

Gyle: I emailed Bask Bank (customersupp...@baskbank.com), Presidential Bank 
(em...@presidential.com), & CIT Bank (serv...@cit.com) on Thursday, May 18 at 
about 7 PM PST and have not heard back from any of them yet (CIT did send an 
automated response immediately). We will see what they say.

Bob: I made a comment on Huntington Bank's Facebook page
(https://www.facebook.com/HuntingtonBank/) about 15 minutes ago because they do 
not seem to have email customer service options on the Contact Us page on their 
website (https://www.huntington.com/customer-service/contact-us). We will see 
what they say.

Stephen: you said "JP Morgan Chase Bank provides OFX/QFX format downloads of 
Checking and Savings Accounts" do you meanhttps://www.jpmorganchase.com/  
orhttps://www.jpmorgan.com/global  orhttps://www.chase.com/  or something else? JPM is an 
enormous financial institution (https://www.google.com/finance/quote/JPM:NYSE) and I 
don't know where to direct my inquiries.

In addition, my understanding is that there is a difference between OFX
(https://en.wikipedia.org/wiki/Open_Financial_Exchange) and QFX 
(https://en.wikipedia.org/wiki/QFX_(file_format)), but it seems like many 
people are lumping them together - ?

My standard ask goes something like this:

"Hi,

I use GnuCash (https://gnucash.org/), an open source accounting software. Does  
Bank allow transactional data to be downloaded in the OFX file format 
(https://en.wikipedia.org/wiki/Open_Financial_Exchange  &
https://financialdataexchange.org/ofx) or does Bank only allow 
proprietary/patented/corporate file formats (like QFX, owned by Intuit) for 
transactional data downloads?

Thank you,

Brad"

I changed the email subject title from the "Tax report options (flywire)" one 
as the conversation only went in this direction and Alex Aycinena,nor anyone else, added 
to what I was saying about the tax data format options (see emails below).

Thank you for your help in this project!

Brad


On 5/19/23 12:41, Gyle McCollam wrote:

Bob,
You replied to me only.  I was replying to Brad.  You should use reply all so 
that your reply goes to the list.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmcco

[GNC] OFX transactional data downloads from FDIC insured banks

[Brad Morrison]

Hi Stephen/Bob/Gyle/all,

Gyle: I emailed Bask Bank (customersupp...@baskbank.com), Presidential 
Bank (em...@presidential.com), & CIT Bank (serv...@cit.com) on Thursday, 
May 18 at about 7 PM PST and have not heard back from any of them yet 
(CIT did send an automated response immediately). We will see what they 
say.


Bob: I made a comment on Huntington Bank's Facebook page 
(https://www.facebook.com/HuntingtonBank/) about 15 minutes ago because 
they do not seem to have email customer service options on the Contact 
Us page on their website 
(https://www.huntington.com/customer-service/contact-us). We will see 
what they say.


Stephen: you said "JP Morgan Chase Bank provides OFX/QFX format 
downloads of Checking and Savings Accounts" do you mean 
https://www.jpmorganchase.com/ or https://www.jpmorgan.com/global or 
https://www.chase.com/ or something else? JPM is an enormous financial 
institution (https://www.google.com/finance/quote/JPM:NYSE) and I don't 
know where to direct my inquiries.


In addition, my understanding is that there is a difference between OFX 
(https://en.wikipedia.org/wiki/Open_Financial_Exchange) and QFX 
(https://en.wikipedia.org/wiki/QFX_(file_format)), but it seems like 
many people are lumping them together - ?


My standard ask goes something like this:

"Hi,

I use GnuCash (https://gnucash.org/), an open source accounting 
software. Does  Bank allow transactional data to be downloaded in 
the OFX file format 
(https://en.wikipedia.org/wiki/Open_Financial_Exchange & 
https://financialdataexchange.org/ofx) or does Bank only allow 
proprietary/patented/corporate file formats (like QFX, owned by Intuit) 
for transactional data downloads?


Thank you,

Brad"

I changed the email subject title from the "Tax report options 
(flywire)" one as the conversation only went in this direction and Alex 
Aycinena,nor anyone else, added to what I was saying about the tax data 
format options (see emails below).


Thank you for your help in this project!

Brad


On 5/19/23 12:41, Gyle McCollam wrote:

Bob,
You replied to me only.  I was replying to Brad.  You should use reply all so 
that your reply goes to the list.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>email


From: Bob Crochelt
Sent: Friday, May 19, 2023 2:02 PM
To: Gyle McCollam
Subject: Re: [GNC] Tax report options (flywire)

Hi:
Huntington Bank offers OFX/QFX for checking and savings, but not AFAIK CD's.
HTH
Bob Crochelt

On Thu, May 18, 2023 at 03:48:18PM +, Gyle McCollam wrote:

Brad,
As fr as banks with FDIC Insurance and OFX/QFX downloads, I can think of 3 off 
the top of my head.  Presidential Bank in MD, good rate, but only on the 1st 
$25,000 in checking with conditions.  2nd, Bask Bank/Texas Capital, limited to 
2 savings accounts and CDs.  Last. but not least CIT Bank (not CITI).  I'm sure 
there are many others and even if they only offer CSV downloads, that is almost 
as easy once you've done it once.


Thank You,

Gyle McCollam

Gyle McCollam

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>    email


From: gnucash-user  on behalf of 
Brad Morrison
Sent: Thursday, May 18, 2023 5:56 AM
To:gnucash-user@gnucash.org  
Cc:fdxmemberservi...@financialdataexchange.org  
;fdxsupp...@financialdataexchange.org  

Subject: Re: [GNC] Tax report options (flywire)

Hi Alex/all,

Thank you for the overarching explanations about how GnuCash Tax Report
Options work and some of the issues behind that.

As I covered in my April 25 post
(https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106671.html),
I have been trying to find US based FDIC insured banks that allow for
transactional data to be downloaded in the OFX file format
(https://en.wikipedia.org/wiki/Open_Financial_Exchange). I have still
not been able to find any that do, so I dug a bit deeper (the ICBA and
several other banking associations did not respond to my inquiries) and
noticed that the Financial Data Exchange group that hosts the "OFX Work
Group" (https://financialdataexchange.org/ofx) seems to be quite out of
date (copyright date at the bottom lists 2020 as the year, 2019 is the
last date on the timeline, etc.). The Financial Data Exchange homepage
(https://financialdataexchange.org/) looks better maintained and seems
to have several news items from the last month, but also has that 2020
copyright date at the bottom. FDX also has this Tax Data Exchange
section
(https://financialdataexchange.org/FDX/FDX/US-Tax/US-Tax-Forms.aspx?hkey=00bae613-7ec8-4c93-8e37-4712f09ae255)
under the "Resources" tab, but it also looks a bit stale. You may be
able to parse the technical information there better than I can, but it
might be worth a look as that Tax Data Exchange page also seems to
acknowledge what you are saying about T

Re: [GNC] Tax report options (flywire)

[Brad Morrison]

Hi Alex/all,

Thank you for the overarching explanations about how GnuCash Tax Report 
Options work and some of the issues behind that.


As I covered in my April 25 post 
(https://lists.gnucash.org/pipermail/gnucash-user/2023-April/106671.html), 
I have been trying to find US based FDIC insured banks that allow for 
transactional data to be downloaded in the OFX file format 
(https://en.wikipedia.org/wiki/Open_Financial_Exchange). I have still 
not been able to find any that do, so I dug a bit deeper (the ICBA and 
several other banking associations did not respond to my inquiries) and 
noticed that the Financial Data Exchange group that hosts the "OFX Work 
Group" (https://financialdataexchange.org/ofx) seems to be quite out of 
date (copyright date at the bottom lists 2020 as the year, 2019 is the 
last date on the timeline, etc.). The Financial Data Exchange homepage 
(https://financialdataexchange.org/) looks better maintained and seems 
to have several news items from the last month, but also has that 2020 
copyright date at the bottom. FDX also has this Tax Data Exchange 
section 
(https://financialdataexchange.org/FDX/FDX/US-Tax/US-Tax-Forms.aspx?hkey=00bae613-7ec8-4c93-8e37-4712f09ae255) 
under the "Resources" tab, but it also looks a bit stale. You may be 
able to parse the technical information there better than I can, but it 
might be worth a look as that Tax Data Exchange page also seems to 
acknowledge what you are saying about TXF code being abandoned 
("Standards-based JSON files are superior to both CSV and TXF files CSV 
files require proprietary programs to process. Documentation and support 
of the TXF standard has dwindled and has now been fully-replaced by new 
standards.")


I do not know if GnuCash is already a member of FDX, but that maybe 
something to consider...?


Brad

On 5/17/23 12:08, Alex Aycinena wrote:

On Wed, May 17, 2023 at 9:00 AM  wrote:


-- Forwarded message --
From: flywire
To: Gnucash Users
Cc:
Bcc:
Date: Wed, 17 May 2023 17:17:45 +1000
Subject: Re: [GNC] Tax report options
https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107018.html
flywire wrote:


It is a spreadsheet process to add share/franking credits to etf/franking
credits (Distribution:13Q) and similar for capital gains
(Distribution:18H:18A) since the components are the same tax item. Any
thoughts of how I could sum them in reports from different account trees?


lol In the heat of the moment preparing tax I'd never thought of just
transferring the total to the main account for that item.

https://lists.gnucash.org/pipermail/gnucash-user/2023-May/107020.html
flywire wrote:


...there are 13 annual returns


To be clear, the items on the return map to different tax codes, eg
franking credits is 13Q on a personal return and 8D on a trust return. I'd
expect a table would need to be maintained for each return type. Australian
codes hardly change over time which likely means there would be no active
maintenance.

Is it as simple as just using a unique tax code as account code and then
reporting by account code? (Assume one return type.)

___



Some questions have been asked about  Tax Report Options in the past couple
of weeks. I have been away and not able to respond or make comments. Let me
make these points, which may not necessarily apply to this thread, but to
others (sorry):

- The Tax Report Options and associated US Income Tax Report are only
intended to be used for US Income Taxes.

- Some time ago, someone in Germany used the US version and made
adjustments for use in Germany; I'm not familiar with that and don't know
if it works and is being maintained.

- Initially it was intended primarily to generate a file that could be
uploaded to Income Tax Preparation software (and a report was sort of
secondary) and so a key element of the design was the use of TXF codes that
the Tax software could understand; the specification for those codes was
abandoned some time ago so the ability to expand the system is not there
unless we invented our own new TXF code (ugh!).

- That is why there is nothing for Form 1116.

- If someone wanted to do what was done for Germany for another
jurisdiction, they would have to deal with this TXF issue; I certainly
don't recommend trying it.

- The US version could/should be re-written to not depend on TXF codes but
this would not be trivial.

- One can use the 'No Tax code' tag to include accounts on the US Income
Tax Report, just not sorted by Form/Schedule; you could use the account
name and/or description for that purpose for those accounts to give you
totals (example: for Form 1116).

- The system assumes that each 'book' (i.e., gnucash file) is for one
reporting entity (individual, partnership, corporation, etc.) and that one
file is not used to track the accounts of more than one tax
reporting entity.

- You can certainly us

Re: [GNC] Tax report options

[Brad Morrison]

While I have nothing useful to say about tracking foreign taxes paid in 
GnuCash, I will add that IRS Form 1116 
(https://www.irs.gov/forms-pubs/about-form-1116) is unpleasant to deal 
with and the firm that I work for usually elects not to file it, if the 
client meets the election requirements 
(https://www.irs.gov/instructions/i1116#en_US_2022_publink11441fd0e81), 
which in most cases is limited by bullet point #3 on that first list: 
"Your total creditable foreign taxes aren't more than $300 ($600 if 
married filing a joint return)." Well, as long as we are talking about 
individual returns and not fiduciary (estates, trusts) returns...


It does not look like Open Tax Solver supports form 1116 - 
https://opentaxsolver.sourceforge.net/forms.html


Brad

On 5/14/23 07:43, Fred Tydeman wrote:

When I get the 1099 DIV forms for mutual funds and stock brokerage accounts,
I add two transactions dated year end (if this is the only mention of
foreign taxes):
   Foreign tax:  +xxx  (expense)
   Dividend:   +xxx  (income)
for each net foreign tax paid for each security.
I am looking for the total of all the foreign tax entries.

Other investments, tell me about each gross dividend / interest payment and
how
much foreign tax was withheld.  Those I can enter as each is done.



On Sun, May 14, 2023 at 4:24 PM Ken Farley  wrote:


Form 1116 has cost me at least a couple of iterations of filing my taxes
in the past. It would be nice if something told me I needed it...but
unless I was paying taxes to a foreign nation directly, meaning a
transaction occurs in one of my accounts, I don't see how I would have
it included in this report. Dividends I get, interest received, capital
gains, etc. These are all entries into my ledgers that the report can be
told to use. The taxes paid that are useful for the Form 1116 tax credit
are only known to me when I get my 1099 Forms from my investment
brokerage. I have absolutely no idea what they will be until I see that
entry in the form. So, I don't understand how the tax report in Gnucash
would be able to supply you with this information?
___
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.

[GNC] W3C Web Developer Tools

[Brad Morrison]

Hi GnuCash,

For those web developers (or web users) on this list, I stumbled across 
what seems to be a very helpful toolset from W3C: 
https://w3c.github.io/developers/tools/


That page includes a link checker, a HTML validator, a CSS validator and 
more! It seems like a pretty useful thing to do occasionally, like 
spring cleaning... Or you can annoy all your friends and coworkers by 
having an easy way to point out the various technical issues with their 
websites!


Speaking of which, I ran https://gnucash.org/ through the W3C link 
checker tool https://validator.w3.org/checklink and it took about 67 
seconds on my connection to return plenty of helpful results because if 
there is one thing we all know, it's that the GnuCash developers clearly 
do not have enough work to keep themselves busy!


And not to be overly competitive, but I also plugged in 
https://opentaxsolver.sourceforge.net/index.html and that website only 
took about 51 seconds to complete the link checker process...


In solidarity,

Brad
___
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] Status of SourceForge tip jar

[Brad Morrison]

Thank you for making a donation Wally! And thank you Derek for managing 
the SourceForge Tip Jar!


https://gnucash.org/donate.phtml - the GnuCash donation page lists 2 
ways to donate: the SF Tip Jar & the Argenta Bank account in Belguim run 
by Geert Janssens.


In the USA, cash contributions/donations to what are called 501c3 
nonprofit organizations (after the Internal Revenue Code section - 
https://www.irs.gov/charities-non-profits/charitable-organizations/exemption-requirements-501c3-organizations) 
are tax deductible (within limitations) for those US taxpayers that 
itemize their tax deductions 
(https://www.irs.gov/help/ita/can-i-deduct-my-charitable-contributions) 
instead of taking the standard deduction 
(https://www.irs.gov/help/ita/how-much-is-my-standard-deduction & 
https://www.irs.gov/newsroom/deductions-for-individuals-what-they-mean-and-the-difference-between-standard-and-itemized-deductions). 



I have found few projects in the open source world take advantage of 
this legal mechanism to both increase donations from Americans and 
financially benefit their supporters. FreeCAD 
(https://wiki.freecad.org/donate), Open Tax Solver 
(https://please-fund-me.com/cgi-bin/render_fund_page.cgi?fund=67), even 
bigger open source projects like the Linux Mint OS 
(https://linuxmint.com/donors.php) and Libre Office 
(https://www.libreoffice.org/donate/) do not seem to take advantage of 
this tax saving tool for charitable organizations with American 
donors/funders/supporters.


There is also a tool called fiscal sponsorship 
(https://www.councilofnonprofits.org/running-nonprofit/administration-and-financial-management/fiscal-sponsorship-nonprofits) 
that allows one organization to accept and distribute tax deductible 
donations to its member organizations/projects. The Software Freedom 
Conservancy (https://sfconservancy.org/) provides this service 
(https://sfconservancy.org/projects/services/) to many open source 
projects (https://sfconservancy.org/projects/current/), but in my 
attempted interactions with SFC and in speaking with others in the North 
Bay Linux Users Group (NBLUG - https://nblug.org/), I have gotten my 
impression reinforced that SFC is not very responsive to its member 
projects. SFC also refers to another nonprofit fiscal sponsor on its 
website (https://sfconservancy.org/projects/apply/), Software in the 
Public Interest (SPI - https://www.spi-inc.org/), but there may be 
others. Oddly, as I am writing this out and learning more, I see that 
Libre Office is listed as one of the SPI's fiscally sponsored projects 
(https://www.spi-inc.org/projects/ > 
https://www.spi-inc.org/projects/libreoffice/), but Libre Office's 
donation page only specifies the tax deductibility of donations for 
Germans under the "Click here for information about tax deductions" 
section. Oh my, OK, there is a line about donations to Libre Office 
through SPI being tax deductible to Americans under a different section, 
"Click here for bank transfers (eg SEPA), and additional information for 
US residents" - that is not a helpful section/topic design!


I better stop typing and thinking about this subject before I start 
pulling out any more of what limited hair I have left on my head. 
Hopefully, my points about fiscal sponsorship have been made and if 
anyone else is interested, we can discuss the nuances further...


Brad


On 5/3/23 14:29, Wally Hackenslacker via gnucash-user wrote:

Done! Paypal transaction ID: 3U743030XD777840W
I know it's not much but I hope it's useful to the project.

Thank you Derek.

--- Original Message ---
El miércoles, 3 de mayo de 2023 a las 3:17 PM, Derek 
Atkins  escribió:



It is still working; I am the manager of the target paypal account, and I
report periodically to the core devs and act on their (our?) consensus on
disbursement.

Thank you in advance for your donation/contribution.

-derek

On Wed, May 3, 2023 2:57 pm, Wally Hackenslacker via gnucash-user wrote:


Hello all.

I wanted to ask what is the status of the SourceForge tip jar for GnuCash.
I'm looking to make a donation and the method that works for me is making
a Paypal donation through the tip jar but I wanted to make sure that it's
still working, if it is trustworthy and that the money will reach the devs
of the project.

Thanks.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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.

Re: [GNC] Turn of drop list when entering data in memo/description line

[Brad Morrison]

Hi Trevor,

What Linux distro & version # are you using? While I am assuming that 
you are updating/upgrading Gnucash via your Linux distro's package 
manager, are you using the flatpak/flathub version of Gnucash or the 
direct package?


I am using Linux Mint 20.3 (https://linuxmint.com/ with the most current 
version being 21.1) and the versions of Gnucash in the LM 20.3 software 
manager are "Version: 3.8, Build ID: 3.8b+(2019-12-29), Finance::Quote: 
1.49" for the direct package and "4.10+" for the Flathub/Flatpak version.


Brad


On 4/29/23 03:14, Trevor Dempsey via gnucash-user wrote:

Greetings,

I just upgraded to version 5.0 and I would like to know how to turn 
OFF the drop list when entering a description in the memo line.


I can only enter 3 letters before it seizes up and I must cancel my 
entry to continue. To enter new data into this memo line, I must first 
write it in a text file and then copy/paste it onto the line.


I would roll back this upgrade if I could but the version of linux I 
am using does not allow that.


Any help would be appreciated because at the moment Gnucash is unusable.

___
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] Atualização GnuCash versão 5.0

[Brad Morrison]

Hi Eduardo,

It looks like your message is in Portugese (Brazilian) according to the 
DuckDuckGo online translator that I copied & pasted your text into. Here 
is the list of the various GnuCash user mailing lists 
(https://lists.gnucash.org/mailman/listinfo) and the second one from the 
top, Gnucash-br (https://lists.gnucash.org/mailman/listinfo/gnucash-br), 
seems to be specifically for "brasileiros."


Good luck!

Brad


What Eduardo wrote in English (according to DuckDuckGo's translator): 
"Good morning. It normally used GnuCash until version 4.13, performing 
transaction imports." CSV", multisplit, linking the columns normally 
(DATE, DESCRIPTION, NUMBER, ACTION, DEBIT, ACCOUNT, COMMENT and NOTES). 
In this update, 5.0, I noticed several changes in the import format, 
with the replacement of the previously available CREDIT and DEBIT 
fields, intended for value information, by the fields AMOUNT, AMOUNT, 
AMOUNT(NEGAITVO), VALUE, VALUE(NEGATIVE), PRICE I've tried to change the 
". CSV" in various ways, including one column for positive values and 
another for negative values (this one with values "+" and "-"), but it 
always results in the msg "select a column of VALUE(NEGATIVE), and does 
not progress on import. Could someone provide a relationship table of 
the fields for correct formatting of ". CSV" in this new version? Thank 
you very much for the help Best regards Eduardo Key Matsudo"



What I wrote above in Portugese (according to DuckDuckGo's translator): 
"Oi Eduardo, Parece que sua mensagem está em português (brasileiro) de 
acordo com o tradutor online DuckDuckGo que eu copiei e colei seu texto. 
Aqui está a lista das várias listas de discussão de usuários do GnuCash 
(https://lists.gnucash.org/mailman/listinfo) e a segunda do topo, 
Gnucash-br (https://lists.gnucash.org/mailman/listinfo/gnucash-br), 
parece ser especificamente para "brasileiros". Boa sorte! Brad"



On 4/29/23 04:34, eduardo key matsudo wrote:

Bom dia.

Utilizava normalmente o GnuCash até a versão 4.13, realizando importações de transações 
".CSV", multisplit, vinculando as colunas normalmente (DATA, DESCRIÇÃO, NÚMERO, 
AÇÃO, DÉBITO, CONTA, COMENTÁRIO e NOTAS).
Nesta atualização, 5.0, notei várias alterações no formato da importação, com a 
substituição dos campos CRÉDITO e DÉBITO anteriormente disponíveis, destinados 
à informação do valor, pelos campos QUANTIA, MONTANTE, MONTANTE(NEGAITVO), 
VALOR, VALOR(NEGATIVO), PREÇO
Já tentei alterar o ".CSV" de várias formas, incluindo uma coluna para valores positivos e outra para 
negativos (esta com valores "+" e "-"), mas sempre resulta na msg "selecione uma coluna 
de VALOR(NEGATIVO), e não progride na importação.
Alguém poderia fornecer uma tabela de relacionamento dos campos para correta formatação 
do ".CSV" nesta nova versão?

Agradeço muito pela ajuda

Atenciosamente,

Eduardo Key Matsudo
(11) 967023407

___
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] Can't reenter password for OFX DirectConnect

[Brad Morrison]

Hi Alex S/all,

Hopefully someone else will address the GnuCash aspect of your specific 
issue with the OFXDirectConnect. I would like to comment on the 
situation with banks allowing transactional data downloads in the OFX 
file format (https://en.wikipedia.org/wiki/Open_Financial_Exchange).


I am still trying to find a professional bookkeeper in the USA that uses 
GnuCash, but based on not seeing anyone respond on this mailing list to 
Bob Treumann's March 1 ask or my March 7 reply, I'm assuming that there 
are no US-based professional bookkeepers on this mailing list that use 
GnuCash AND are taking on new clients.


All 3 of the local (Sonoma County, CA, USA - 
https://en.wikipedia.org/wiki/Sonoma_County,_California) bookkeeping 
firms that I have asked about using GnuCash were unfamiliar with the 
software, 2 of the 3 only used Quickbooks (1 also used Xero), and only 1 
expressed any interest in using GnuCash, but did not email back when I 
followed up a week later. I found these bookkeeping firms through Sonoma 
County Go Local's directory 
(https://sonomacounty.golocal.coop/businesses/services-professional/accounting-tax-bookkeeping-and-payrol/). 
It does not appear that the 2 national bookkeeping organizations 
(https://aipb.org/ & https://nacpb.org/) that I found online have local 
chapters, although I have not asked them directly yet.


As part of this project of mine, I have been trying to find a bank that 
allows transactional data downloads in the OFX file format and using 
that inquiry as an opportunity to ask about whether the bank has a 
policy of sourcing/using open source software. I started with SRI 
(https://en.wikipedia.org/wiki/Socially_responsible_investing) banks 
that I knew of because I thought that they would be the most open to & 
interested in open source software and the concepts/philosophies of 
transparency and sharing behind its development and use. Every bank that 
I have asked so far has said that they do not allow transactional data 
downloads in the OFX file format and none have said that they have a 
policy regarding open source software. I have received responses from 
these banks so far:


 * https://en.wikipedia.org/wiki/Beneficial_State_Bank
 * https://en.wikipedia.org/wiki/Amalgamated_Bank
 * https://en.wikipedia.org/wiki/Pacific_Premier_Bancorp
 * https://en.wikipedia.org/wiki/National_Cooperative_Bank

I have sent inquires to more banks, but those are the only ones that 
have responded so far. I have not asked Regions Bank 
(https://en.wikipedia.org/wiki/Regions_Financial_Corporation), but after 
seeing your post, I was going to. However, it does not appear from their 
website messages section (https://www.regions.com/help > 
https://www.regions.com/digital-banking/digital-services/reggie-digital-assistant) 
that they accept incoming electronic messages from non-customers. I have 
also been surprised that Regions Bank does not seem to have a "Contact 
Us" tab anywhere on their header or footer list of standard options, so 
I used the "Help & support" section. Maybe they are not seeking new 
customers, but that would be unusual...? As a customer, you may want to 
reach out to ask Regions Bank if they still support OFX Direct Connect.


Finally, I have been able to find 2 regional credit unions that allow 
transactional data downloads in the OFX file format 
(https://www.redwoodcu.org/ & 
https://en.wikipedia.org/wiki/Patelco_Credit_Union). I have only asked 
these 2 credit unions so far and since both said yes (and RCU even 
directed me to their page about financial data downloads - 
https://www.redwoodcu.org/ask-rcu/2199/) and none of the banks that have 
even responded to me have said yes, I wondered if some back end 
technology provider that FDIC insured 
(https://en.wikipedia.org/wiki/Federal_Deposit_Insurance_Corporation) 
banks use, but NCUA insured 
(https://en.wikipedia.org/wiki/National_Credit_Union_Administration) 
credit unions do not use might be responsible for this lack of support 
for OFX...?


After having such little luck fishing for banks that support OFX, it 
just occurred to me over the weekend that it might be a good idea to ask 
banking associations 
(https://en.wikipedia.org/wiki/Independent_Community_Bankers_of_America 
& https://www.icba.org/) and advocacy organizations that work with banks 
(https://www.greenamerica.org/finance & https://mightydeposits.com/) 
about interest from community banks in OFX, GnuCash, & open source 
software.


When I write local organizations, I usually reference the North Bay 
Linux Users Group (NBLUG - https://nblug.org/) because I am on the 
board, but I leave that part out of my template when inquiring with 
larger or non-local financial institutions & organizations. I'm open to 
any suggestions/ideas/help if anyone else is interested in this project...


Onward and upward,

Brad


On 4/24/23 13:59, Thepwnd via gnucash-user wro

Re: [GNC] Company plan for stocks and stock options

[Brad Morrison]

Hi Wolfgang/all,

While I definitely echo what John has mentioned about having a tax 
professional that has experience preparing tax returns with stock 
options review the situation and your accounting setup, I will also note 
how helpful it is when a tax client is actually interested enough in how 
the relevant accounting rules works to assemble the necessary 
information correctly. The difference between working on a tax return 
for a "shoebox client" and a client that is organized is the frequently 
the difference between a good workday and a bad one...


Wolfgang: did your company provide you with a form 3922 or form 3921 for 
your stock options? https://www.irs.gov/forms-pubs/about-form-3922 & 
https://www.irs.gov/forms-pubs/about-form-3921


Another thing to think about is whether those stock options that are 
vested & distributed annually show up as compensation on your W2 - 
https://www.irs.gov/forms-pubs/about-form-w-2


Brad

On 4/4/23 12:26, john wrote:

The whole bucket of deferred compensation is really complicated and how you 
account for it is tied up in tax law. If the value of the options, stock plan, 
retirement plan subsidies, and whatever else is large enough to matter to your 
tax returns you really, really need the help of a licensed accountant with 
direct experience with the types of deferred compensation you get. Ask your 
colleagues for recommendations.

Regards,
John Ralls



On Apr 4, 2023, at 11:14 AM, Murugan Muruganandam  
wrote:

Employee stock options are normally not taxed until the vesting is done.  
Restricted Stock Units (RSU) has a different mechanism though

What is your objective of this accounting? if you can detail then there are 
couple of ways to account for the same




Saludos Cordiales


Murugan


From: gnucash-user  on 
behalf of Stan Brown
Sent: Tuesday, April 4, 2023 2:06 PM
To:gnucash-user@gnucash.org  
Subject: Re: [GNC] Company plan for stocks and stock options


On 2023-04-04 10:40, Wolfgang Paul Rauchholz wrote:

Fairly new to gnucash and not a finance export, I want to run all my
personal finances with this great tool.

I installed 5.0 by compiling it under fedora core 37.

I started adding normal daily expenses and all look fine.

One of the doubts I have is how do I correctly add a company plan for stock
options and stock plan that get vested/distributed every year. As I don't
buy them there is no cash leaving my bank account.

The options and stocks are part of your compensation as an employee,
right? As such, the accounting would be similar to your accounting for
your paycheck.

Your paycheck (ignoring tax withholding) is
Debit: Cash or Bank account
Credit: Employee income

The stocks would be
Debit: Stock in Company X
Credit: Employee income
and similarly for the options. With stocks and options you'll want to
know number of shares and share prices so that you can compute gains and
losses when you sell them. If they aren't fully vested you will want to
note the vesting date as well.

You'll probably want to have separate accounts for stocks in the company
and stock options. To simplify computing your income tax, you may want
to have separate income accounts for income in money and income in
securities; they could both be subaccounts under an Employee Income account.

The usual disclaimer: I don't know your tax situation or any legal
requirements for how you may need to account for all of this.

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.
___
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] easy way to total number of transactions and USD ammounts

[Brad Morrison]

Hi Jeff/all,

I encountered this issue a few weeks ago for a tax client with a short 
term rental property. Apparently, 2022 is a "transition" year for the 
new requirements for producing a form 1099K - 
https://www.irs.gov/businesses/understanding-your-form-1099-k


This VRBO page might be easier to read for some - 
https://help.vrbo.com/articles/About-1099-K-tax-form-reports


I do not know what your state requirements are (I don't even know what 
state you are in), but the form 1099K is a federal form, and the company 
that you are dealing with may be right that they are not required to 
produce a form 1099K for you for 2022, just FYI. It reminds me of that 
old Greg Palast (https://en.wikipedia.org/wiki/Greg_Palast) phrase, "The 
best democracy money can buy."


In other IRS/US tax news - 
https://www.propublica.org/article/how-to-file-taxes-for-free-without-turbotax


Brad

On 3/29/23 23:43, Jeff wrote:
The IRS threw me a curve ball this year (imagine that).  One of their 
tax forms went from $600 minimum to you, to $20,000 "AND" more than 
200 transactions in 2022.  Is there someone out there that can hold my 
hand and show me how to export those transactions to a spreadsheet to 
see if we fall into that level at the federal level, since there are 
no reporting features in GNC that total $ and number of transactions, 
at least that I am aware of?  I have not used spreadsheets for much of 
anything since my college days, shall we say decades ago, so rusty is 
an understatement.


The real kicker is my state sets the minimum at $1,200, period.

The company involved, has so far refused to provide me with a copy of 
the 1099 involved.  It may or may not meet the federal level but I 
know for a fact that it passes my states $ level of $1,200.


Don't you just love our tax system in the U.S.A.? NOT!


___
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] Temporary Website URL

[Brad Morrison]

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

Re: [GNC] QuickBooks to GnuCash Migration Script improvements

[Brad Morrison]

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] Temporary Website URL

[Brad Morrison]

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 me 
that this is why he doesn't trust open source projects with his business 
or his clients' business. It was pretty embarrassing for me and I have 
hesitated to refer any possibly interested professionals that I meet to 
GnuCash since.


I can confirm the certificate error for website #1. It looks like 
gnucash.org uses Let's Encrypt (https://letsencrypt.org/) as the 
certificate authority and the certificate was valid from December 12, 
2022 until March 11, 2023. My understanding was that Let's Encrypt was 
free, so that might mean that it just has to be renewed/reauthorized...?


I can confirm that website #2 still lists the "Apache2 Ubuntu Default 
Page" error for the non-https/secure gnucash website. I believe that 
John mentioned that Linas upgraded his server in January and that broke 
this feature and it has not been fixed since.


I also see Gnucash website #3 as working well. I can see that that 
website also uses Let's Encrypt as the certificate authority and that 
certificate is valid from March 5, 2023 until June 3, 2023.


I also noticed that website #1 & #2 has 2 "Subject Alt Names" 
(gnucash.org & www.gnucash.org) on that certificate, while website #3 
has just 1 (code.gnucash.org).


After briefly reading a few of the mailing list messages on US 
banks/credit unions that are not allowing their transaction to be 
downloaded/available in an open format, I have also wanted to start 
emailing various financial institutions about whether they intend to 
make such a format available. I would still need to further review the 
formatting situation described in the email chains before I start asking 
around and then opening an account at such a financial institution, but 
if the main GnuCash website still doesn't work, it is hard to write such 
emails at all.


Brad


On 3/17/23 11:00, Ken Pyzik wrote:

So checking websites statuses today:

https://www.gnucash.org  - privacy/certificate error
http://www.gnucash.org  - Default appache2 page
https://code.gnucash.org/website  - working perfectly.

As noted - this has been an issue since 11 February.  The https:// was working 
at one point a couple of weeks ago -- but now it is not.

FYI -- Ken

-Original Message-
From: gnucash-user  On 
Behalf Of John Ralls
Sent: Sunday, February 19, 2023 3:40 PM
To:gnucash-annou...@lists.gnucash.org
Cc: gnucash-devel; Gnucash 
Users
Subject: [GNC] Temporary Website URL

As most everyone already knowswww.gnucash.org  has been offline since 11 
February because Linas Vepstas lost internet access and his ISP, Grande 
Networks in Austin, TX, has not fixed it.

To provide replacement service until Linas gets back online we've set up an 
alternate site,https://code.gnucash.org/website/.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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] Looking for setup and/or bookkeeping help

[Brad Morrison]

Hi Bob/all,

That is an interesting question and I'm disappointed that no one has yet 
offered a professional bookkeeper that uses GnuCash, even if just for 
certain, interested clients. While I don't know what state you and your 
business are located in, I work in the North Bay Area office of a tax & 
wealth management firm (on the tax side) and while I use Lacerte 
(Intuit's tax professional software - 
https://proconnect.intuit.com/lacerte/) every workday, I do not use 
Quickbooks (Intuit's bookkeeping program - 
https://quickbooks.intuit.com/), although many other people in our firm 
do. I am pretty new to the accounting field, so the vast majority of my 
work is on relatively simple individual/1040 US tax returns and a few 
relatively simple fiduciary/1041 tax returns. While I do work on the 
occasional out of state or multi state tax returns, the vast majority of 
my work are California tax returns. I rarely touch partnership (1065) 
tax returns and have yet to work on C/S corp tax returns (1120, 1120S), 
although I have worked on 1040 tax returns that had K1s from 
1065/partnerships & 1041/fiduciary tax returns. I say all of that 
because I am not the right person to help you out.


I did find this section on the GnuCash Wiki, but it seems very old, it 
only lists 2 professionals, and I'm not sure if they still offer those 
GnuCash bookkeeping services - 
https://wiki.gnucash.org/wiki/FAQ#Q:_Is_there_a_CPA_.28Certified_Public_Accountant.29_who_uses_GnuCash_in_my_area.3F


As much as I dislike Intuit (https://en.wikipedia.org/wiki/Intuit) for a 
seemingly never ending supply of reasons, since we are having this 
conversation on an open source software mailing list, I will point out 
that Intuit is the largest software company 
(https://www.google.com/finance/quote/INTU:NASDAQ?window=1Y) that I know 
of that does not contribute at all to open source projects, Intuit is 
not even listed among the 275 top contributors here - 
https://opensourceindex.io/


At the same time, there are no open source software options for tax 
professionals in the USA to prepare & file federal tax returns. While 
Open Tax Solver (https://opentaxsolver.sourceforge.net/) exists for 
individuals, due to how the IRS authorizes electronic filing providers 
(https://www.irs.gov/e-file-providers/efile-for-tax-professionals) OTS 
does not allow for e-filing. One must print out the tax forms after 
using the OTS program and mail them in.


From 
https://www.irs.gov/e-file-providers/e-help-desk-for-tax-professionals - 
"e-file Requirement for Tax Return Preparers: The law requires tax 
return preparers and firms who reasonably expect to file 11 or more 
covered returns in calendar year 2013 and thereafter, to e-file the 
returns they prepare and file. For 2013, covered returns are Forms 1040, 
1040-A, 1040-EZ, and 1041. If this requirement will cause an undue 
hardship, apply for a waiver by completing Form 8944, Preparer e-file 
Hardship Waiver Request. For more information, go to IRS.gov, keyword 
‘e-file requirement’."


That's enough details to highlight my point of the 'competitive moat' 
that exists for commercial financial/accounting software firms and how 
there are significant barriers to competition from open source 
alternatives in the US. And while bookkeeping software is far less 
complicated and far more commonly used than the professional tax 
software specific to US federal and state tax rules, it is very 
difficult to find any professional bookkeepers that are even familiar 
with tools like GnuCash, much less use them exclusively. If there are 
any other accounting professionals that are interested in changing this, 
by all means consider me an ally. But for now, I work for the firm that 
I do because I have bills to pay.


If even just 1 bookkeeping firm in the entire USA could handle remote 
clients like Bob using GnuCash exclusively, that to me would be a game 
changer for this software and the open source accounting community. That 
firm would likely have to hire an IT contractor, that IT contractor 
would then be called on to solve issues for both the firm and the 
software that the firm uses, and that is when major improvements start 
to happen. When skilled people are able to get paid to spend significant 
amounts of time on open source software that has both 
personal/individual and professional/business applications/uses is when 
improvements snowball and adoption grows.


Apologies for the preaching - good luck Bob,

Brad

On 3/1/23 10:28, Bob Treumann wrote:

Are there any accountants or bookkeepers who specialize in gnucash?
Or other power users who would help me out?I would expect to pay.

I have my small business ( S-Corp ) gnucash account set up in a cloud
database so the person could work remotely, either to get me started or to
do the bookkeeping and taxes including payroll taxes.

Bob Treumann

<https://www.avast.com/sig-email?ut

Re: [GNC] Gnucash,org url is now working

[Brad Morrison]

Thanks to John, Fred, Derek, Geert, & Ken for clarifying the situation 
with the website & mailing lists.


Are there any plans to upgrade the GnuCash mailing lists 
(https://lists.gnucash.org/mailman/listinfo) from Mailman2 to Mailman3 
(https://www.gnu.org/software/mailman/index.html)? I mentioned before 
that I am on the board of the North Bay Linux Users Group (NBLUG - 
https://nblug.org/) and we recently upgraded from Mailman2 to Mailman3 
(https://nblug.org/mailman3/postorius/lists/), with plenty of hiccups 
along the way...


I am not sure what version the majority of GnuCash users have on their 
various machines, but the version I have on my Dell E7440 laptop is 
"Version: 3.8, Build ID: 3.8b+(2019-12-29), Finance::Quote: 1.49" as 
that is the most current version available in the Linux Mint software 
manager. Linux Mint also has a FlatHub version that appears to be listed 
as "4.10+" available in the Software Manager. I am running Linux Mint 
20.3, but the current version is 21.1 (https://linuxmint.com/), so maybe 
that is the reason I have an older version available via the Software 
Manager...?


Does GnuCash recommend using the FlatHub version when it is newer than 
the version offered in the various Linux distro repositories?


https://code.gnucash.org/website/download.phtml lists the stable release 
version as 4.13 and the unstable release version as the 4.901 one that 
John mentioned below.


Has Grande Communication Networks (https://www.astound.com/texas/ & 
https://en.wikipedia.org/wiki/Grande_Communications) been able to get 
Linas & the host machine back online yet since the February 11 storms in 
Austin, TX?


Brad

On 3/3/23 09:03, john wrote:

That's been broken since Linas upgraded the host machine in January along with 
updates so it's still missing the 4.901 release from last month and I expect 
the 4.902 coming on Sunday won't work either. Keep 
usinghttps://code.gnucash.org/website.

Regards,
John Ralls



On Mar 3, 2023, at 8:53 AM, Fred Bone  wrote:

On 03 March 2023 at 7:31, Derek Atkins said:


Hi.
Indeed, it does appear thatwww.gnucash.org  lost its brain and, although
responding, is not the gnucash website.  I will notify Linas to ask what's
up.

What appears to be up is the loss of an automatic redirect from
http://www.gnucash.org
to
https://www.gnucash.org
which, as this is clearly an Apache webserver, is a matter of one line in
a .htaccess file.

The corresponding redirect for gnucash.org (without the www. prefix) is
working.

___

On 3/3/23 05:08, Geert Janssens wrote:


It looks like an http vs https thing.


https://www.gnucash.org works fine, plain http doesn't. Probably the 
redirect is not working as it should.



Regards,


Geert


Op vrijdag 3 maart 2023 13:31:14 CET schreef Derek Atkins:

> Hi.

> Indeed, it does appear that www.gnucash.org lost its brain and, 
although


> responding, is not the gnucash website.  I will notify Linas to ask 
what's


> up.

> As for # subscribers, we have a dozen lists with some overlapping

> subscriptions, but there are over 2000 subscribers to gnucash-user.

>

> -derek

>

> On Fri, March 3, 2023 7:13 am, Brad Morrison wrote:

> > Hi Ken, John, & all,

> >

> > I just tried the link that Ken provided and it took me to some 
"Apache2


> > Ubuntu Default Page," but not the GnuCash homepage...?

> >

> > I also tried the link that John provided and that seems to work 
fine for


> > the GnuCash homepage for me.

> >

> > Is anyone else having similar results?

> >

> > I would attach screenshots, but I don't know if the Mailman2 mailing

> > list software allows for that - ? I am on the board of the North Bay

> > Linux Users Group (NBLUG - https://nblug.org/) and we have gone 
through


> > some transition difficulties in our recent upgrade from MailMan2 to

> > MailMan3 (https://www.gnu.org/software/mailman/index.html), so when I

> > saw that these GnuCash mailing lists are still using MailMan2

> > (https://lists.gnucash.org/mailman/listinfo) I made a mental note of

> > that. Although with the amount of email traffic /volume that I 
have seen


> > on this list, I am willing to bet that this list has far more

> > subscribers than all of our NBLUG lists combined (we have about 
250 on


> > the 'talk' list and about 450 on the 'announce' list).

> >

> > Thanks,

> >

> > Brad

> >

> > On 2/21/23 21:00, Ken Pyzik wrote:

> >> Tested it this evening - 9:00PM PST in the

> >> US.www.gnucash.org<http://www.gnucash.org>  now appears to be 
working.


> >> FYI.

> >>

> >> Ken

> >>

> >>

> >> 

Re: [GNC] Gnucash,org url is now working

[Brad Morrison]

Hi Ken, John, & all,

I just tried the link that Ken provided and it took me to some "Apache2 
Ubuntu Default Page," but not the GnuCash homepage...?


I also tried the link that John provided and that seems to work fine for 
the GnuCash homepage for me.


Is anyone else having similar results?

I would attach screenshots, but I don't know if the Mailman2 mailing 
list software allows for that - ? I am on the board of the North Bay 
Linux Users Group (NBLUG - https://nblug.org/) and we have gone through 
some transition difficulties in our recent upgrade from MailMan2 to 
MailMan3 (https://www.gnu.org/software/mailman/index.html), so when I 
saw that these GnuCash mailing lists are still using MailMan2 
(https://lists.gnucash.org/mailman/listinfo) I made a mental note of 
that. Although with the amount of email traffic /volume that I have seen 
on this list, I am willing to bet that this list has far more 
subscribers than all of our NBLUG lists combined (we have about 250 on 
the 'talk' list and about 450 on the 'announce' list).


Thanks,

Brad

On 2/21/23 21:00, Ken Pyzik wrote:

Tested it this evening - 9:00PM PST in the 
US.www.gnucash.org<http://www.gnucash.org>  now appears to be working.  FYI.

Ken


___
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.




On 2/19/23 15:40, John Ralls wrote:

As most everyone already knowswww.gnucash.org  has been offline since 11 
February because Linas Vepstas lost internet access and his ISP, Grande 
Networks in Austin, TX, has not fixed it.

To provide replacement service until Linas gets back online we've set up an 
alternate site,https://code.gnucash.org/website/.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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] Is anyone else having difficulty accessing the https://gnucash.org/ homepage?

[Brad Morrison]

Hello,

Is anyone else having difficulty accessing the https://gnucash.org/ 
homepage?


I am still able to access the Wiki 
(https://wiki.gnucash.org/wiki/GnuCash) and the Mailman lists 
(https://lists.gnucash.org/mailman/listinfo), but not the GnuCash homepage.


It was somewhat embarrassing when I texted the GnuCash homepage web 
address yesterday morning to a bookkeeper that currently uses QuickBooks 
as a possible alternative for him to use. He writes me back that he 
can't load the website from the link I sent him, nor from the URL he 
found when he did a Google search on his own - not exactly an impressive 
introduction...


Thanks,

Brad
___
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] monthly balance report

[brad]

I'd like to have a report which monthly shows monthly balances and 
totals for a few accounts.  They are all cash asset accounts.


I couldn't find quite what I wanted , but here's my work around, plz let 
me know if there is a report which will give me what I'm looking for.


The one called Asset Chart in the menu, which has a name of 'Assets Over 
Time' is what I landed on, but I had a few frustrating stumbling blocks.


Even tho I'm picking just 4 accounts, and don't need children of those 
accounts, if I don't pick 'All' under 'Levels of Subaccounts' I get an 
error, No Data ...


Once I select All Levels, the error goes away but it looks like a blank 
page.   I realized that the graphic data was blank but the table was 
down the page out of view.  I found if I  changed the Plot Height to a 
small number I see the table that I'm looking for.


This seems like such a common report that I must be missing something 
simple.


gnucash 4.8
ubuntu 20.04.5

___
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] More UI downgrades

[brad]

I don't see your grey box issue.  I can click on any field, deposit, 
withdrawal, shares, etc and edit the number.  GC 4.8, xubuntu 20.04


On 9/10/22 08:43, Russell Gadd wrote:

It seems every time I upgrade there is some deterioration in user interface
design. I upgrade to Gnucash when I upgrade my Linux system. I've just
upgraded to Mint 21 which came with Guncash 4.8.

In this edition the edit of any amount now opens a grey box where the
number in it is unresponsive to the mouse so if you try to swipe across the
field to clear it it doesn't do anything. This is contrary to how all other
software since time immemorial behaved. You have to use the keyboard to
delete characters. How could the developers think this is an improvement?

While griping I will also mention the previous gripe I had. When
reconciling I used to use the space bar (I think, it was a long time ago)
to fill in the box and automatically move down to the next item. It made
reconciling pretty slick. Then it was "upgraded" so it no longer moves
down. You either have to use the mouse to fill in the boxes or hit the
space bar followed by the down arrow. I complained at the time but the
response was a justification which was impossible to understand, which I
took to be obfuscation of the fact that it could not be justified. Now
after such a long time how about reinstating the previous behaviour?

Otherwise great software. Many thanks for the dedication of the developers.
___
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 manage multiple accounts (as in separate gnucash databases)?

[brad]

On 4/27/22 02:13, Chris Green wrote:

On Tue, Apr 26, 2022 at 07:49:02PM -0600, brad wrote:

On 4/26/22 09:25, Chris Green wrote:

I have several gnucash accounts files (sqlite databases in my case)
spread around my system.  When I go to a specific directory and run
GnuCash I just want it to see only the database[s] in that directory.

Is there a way I can tell gnucash to forget about all previous files
it has opened?  As it is I get presented with a 'memory' of other
accounts which can be very confusing unless I'm very careful with file
naming.

The --nofile option tells gnucash not to open the last accounts
database, it helps a little, but I really want it to forget more!


I'm not clear on what the problem is (unless you're on a Mac).
On my system (linux), In the file manager, navigate to the folder, find the
file you want to open, and double click it.  It only opens that database.
What's confusing?


I don't use GUI file manager (well, very rarely), I tend to 'cd' in a
terminal window to the directory where the files I want to use are and
then run the various programs I need to do things to those files.  The
GnuCash file is just one of those files.


Then just run 'gnucash filename' , filename is the one you want to open?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to manage multiple accounts (as in separate gnucash databases)?

[brad]

I'm not clear on what the problem is (unless you're on a Mac).
On my system (linux), In the file manager, navigate to the folder, find 
the file you want to open, and double click it.  It only opens that 
database.  What's confusing?



On 4/26/22 09:25, Chris Green wrote:

I have several gnucash accounts files (sqlite databases in my case)
spread around my system.  When I go to a specific directory and run
GnuCash I just want it to see only the database[s] in that directory.

Is there a way I can tell gnucash to forget about all previous files
it has opened?  As it is I get presented with a 'memory' of other
accounts which can be very confusing unless I'm very careful with file
naming.

The --nofile option tells gnucash not to open the last accounts
database, it helps a little, but I really want it to forget more!



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

It looks like using sub-accounts to track amounts designated for a
specific purpose going into and out of accounts will work great.
Thanks everyone.
Brad

On Sat, Apr 23, 2022 at 11:14 AM Brad  wrote:
>
> I like the idea of using sub-accounts.  I will test it out and report back.
> Thanks.
>
> On Fri, Apr 22, 2022 at 7:37 PM David H  wrote:
> >
> > Brad,
> >
> > If I were to do this I think I'd look at creating sub-accounts under the 
> > Transfer To account - i.e.
> >
> > Assets >> Current Assets >> Transfer To Account  >> Groceries
> > Assets >> Current Assets >> Transfer To Account  >> Utilities
> > Assets >> Current Assets >> Transfer To Account  >> etc
> >
> > This tells you how much you transferred to each and also includes the 
> > balance of the sub accounts in the Transfer To account.
> >
> > cheers David H.
> >
> >
> >
> > On Sat, 23 Apr 2022 at 07:39, Brad  wrote:
> >>
> >> Hello,
> >> I am new to GnuCash and to this list.  I am a long, long time Quicken
> >> user who has finally gotten fed up with Quicken and I am in the midst
> >> of converting to GnuCash.
> >>
> >> My question is regarding transfer of funds from one account to
> >> another.  I want to transfer funds from one account to another, but I
> >> also want to track the transfer amount against an expense account so I
> >> can keep track separately of how much I have transferred for different
> >> reasons.
> >>
> >> Anyone have any ideas?  I'm guessing it involves a split transaction
> >> of some sort, but I can't figure out what the pieces of the split look
> >> like.
> >> Thanks in advance for your help.
> >> Brad
> >> ___
> >> gnucash-user mailing list
> >> gnucash-user@gnucash.org
> >> To update your subscription preferences or to unsubscribe:
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> If you are using Nabble or Gmane, please see 
> >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> >> -
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

I like the idea of using sub-accounts.  I will test it out and report back.
Thanks.

On Fri, Apr 22, 2022 at 7:37 PM David H  wrote:
>
> Brad,
>
> If I were to do this I think I'd look at creating sub-accounts under the 
> Transfer To account - i.e.
>
> Assets >> Current Assets >> Transfer To Account  >> Groceries
> Assets >> Current Assets >> Transfer To Account  >> Utilities
> Assets >> Current Assets >> Transfer To Account  >> etc
>
> This tells you how much you transferred to each and also includes the balance 
> of the sub accounts in the Transfer To account.
>
> cheers David H.
>
>
>
> On Sat, 23 Apr 2022 at 07:39, Brad  wrote:
>>
>> Hello,
>> I am new to GnuCash and to this list.  I am a long, long time Quicken
>> user who has finally gotten fed up with Quicken and I am in the midst
>> of converting to GnuCash.
>>
>> My question is regarding transfer of funds from one account to
>> another.  I want to transfer funds from one account to another, but I
>> also want to track the transfer amount against an expense account so I
>> can keep track separately of how much I have transferred for different
>> reasons.
>>
>> Anyone have any ideas?  I'm guessing it involves a split transaction
>> of some sort, but I can't figure out what the pieces of the split look
>> like.
>> Thanks in advance for your help.
>> Brad
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] New to GnuCash SQLite on Windows: I have questions

[brad]

On ubuntu linux the X shuts it down cleanly.

On 4/21/22 06:36, Derek Atkins wrote:

On Thu, April 21, 2022 8:11 am, Chris Green wrote:

On Thu, Apr 21, 2022 at 08:07:03AM -0400, Derek Atkins wrote:

GnuCash deletes the LNK files when it shuts down cleanly.  If they still
exist, that means either GnuCash is running with those files open, or
GnuCash was NOT shut down cleanly when they had those files open.  In
the
latter case, either you used the [x] to close it, or shut down the

You mean I'm not supposed to use th X (top right in window) when I
close down GnuCash!  Every other program I have ever used shuts down
cleanly when one does this!

That very much depends on the OS and Window Manager.  Sometimes it does,
but sometimes it forcibly quits the application and doesn't allow it to
shut down cleanly.  Is it really that hard to File -> Quit (or Cntl-Q)
instead of using the [x]?

Have you never noticed the "File is already in use" messages?


Chris Green
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

-derek



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Question about transfers

[Brad]

Thank you for the quick response.  I do have some background in
accounting and I have actually reviewed both the Tutorial and the full
Help manual.  So far I am liking QnuCash alot.  It's just a matter of
getting it to do some of the things I was doing in Quicken.

So, you are pretty close to understanding what I am trying to do.
Yes, I am accumulating funds in a separate bank account for a large
purchase (let's say property taxes paid once a year).  Then when it is
time to pay the property tax I need to transfer the funds to my
checking account so that I can write the check to the county.  At the
same time I want to keep track of how much I have transferred for that
purpose.  For example, maybe I transfer the funds in two transactions
and I want a quick way to see if I have transferred enough.

In Quicken, my property tax budget was set to zero.  When I write the
check for the property taxes, say for $1,000, that expense category
goes to -$1,000.  Then when I transfer the funds, I can add them to
that budget line, bringing the property tax expense category back to
zero.  This way I have basically 3 entries, but I need an even number
of entries to follow double-entry accounting rules.  Two entries to
transfer the funds from one account to another, and then one to show
the funds going to the property tax expense.  Oh, and I guess two more
when I write the check to the county.
Thanks.
Brad


On Fri, Apr 22, 2022 at 3:54 PM Stan Brown  wrote:
>
>
> On 2022-04-22 14:37, Brad wrote:
> > My question is regarding transfer of funds from one account to
> > another.  I want to transfer funds from one account to another, but I
> > also want to track the transfer amount against an expense account so I
> > can keep track separately of how much I have transferred for different
> > reasons.
>
> Welcome to GnuCash, Brad! There's a bit of a learning curve coming from
> Quicken or most other software, because in GnuCash you're doing
> double-entry bookkeeping, and most of the details are visible to you.
> Have you looked at the Tutorial and Concepts Guide (in the Help menu)
> yet, to help you with that learning curve?
>
>
> By "transfer funds from one account to another", do you mean transfer
> from one bank account (or cash, money market, etc) to another? Is this a
> matter of segregating funds that you expect to spend for a large future
> expense, such as a vacation or a new furnace? I'm going to assume both
> of those are yes, but if I've guessed wrong please follow up with more
> details and perhaps an example of what you're trying to do.
>
>
>
> By the way, this isn't really a GnuCash problem, but an accounting
> problem. Your chart of accounts should be structured to let you
> aggregate information in the ways that you want. It would be no
> different if you were keeping our books in a big ledger with pen and ink.
>
>
>
> If you have some sort of bank account in which you're accumulating funds
> against a large future expense, you'd probably want to name that account
> in GnuCash as "Assets:Banks:Savings for Vacation" or similar. when you
> transfer money from your regular everyday bank account, your transaction
> would look like this:
>
> Debit: Assets:Banks:Savings for Vacation
>
> Credit:Assets:Banks:Regular Checking
>
>
>
> As for tracking against expenses, no expense is created by this account
> transfer. Why? Because even though you may presently intend to use these
> funds for a particular future expense, you haven't actually spent them
> yet, and you could change your mind before you do.
>
> When you start spending out of the vacation account, _that's_ when you
> have an expense, and your transactions would look like this:
>
> Debit: Expenses:Vacations
>
> Credit:Assets:Banks:Savings for Vacation
>
>
>
> --
>
> 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
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Question about transfers

[Brad]

Hello,
I am new to GnuCash and to this list.  I am a long, long time Quicken
user who has finally gotten fed up with Quicken and I am in the midst
of converting to GnuCash.

My question is regarding transfer of funds from one account to
another.  I want to transfer funds from one account to another, but I
also want to track the transfer amount against an expense account so I
can keep track separately of how much I have transferred for different
reasons.

Anyone have any ideas?  I'm guessing it involves a split transaction
of some sort, but I can't figure out what the pieces of the split look
like.
Thanks in advance for your help.
Brad
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.8 Questions

[brad]

For sharing access I think a shared Dropbox folder would be safe and 
sufficient.  Other possibilities which I'm not as familiar with would be 
Google Drive and One Drive.


On 3/7/22 00:56, Lokesh Yagnik wrote:

Dear all,

I am not an accountant but with the help of the various threads I have
managed to maintain the accounts for myself, my wife and a small business -
three separately.

My Accountant is quite used to using Xero and prefers I change to it. Xero
makes his work flow easier. I understand that.

I have advised that Gnucash is quite capable of handling most things I
require and generating various reports. Accountant is willing to give this
a go after I generated some reports for him and sent screenshots.

Questions
- Can this version (or any version) of Gnucash allow remote access? Or
(from what I think is the case) will just have to allow him to remote log
in to my computer and then look at Gnucash

- Since I was learning, I have resisted the temptation to update to a newer
version of Gnucash. To upgrade, my understanding is that I need to
upgrade each version to the most uptodate stable version.
  As for backing up the current stuff, I will need to back up the various
XYXYXY.gnucash files or does the entire string -
Folder1/folder2/folder3/XYXYXY.gnucash has to be replicated?

thanks in advance

LY
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mac fails to open gnucash file

[brad]

Hmm is right.  I just tried to duplicate the issue and couldn't.  It 
must be something a little more subtle, or GC got into some bad state.


On 3/5/22 12:53, john wrote:

Hmm.

I have for many years kept my books in an encrypted disk image (dmg) that I 
back up on Google Drive. After a restart I have to remount the dmg, something I 
occasionally forget to do before starting GnuCash and when I do GnuCash pops up 
that dialog. I've always told it no. I usually quit GnuCash, mount the dmg, and 
restart GnuCash, and GnuCash though I sometimes just mount the dmg and then use 
the saved entry at the bottom of the File menu to open the book. Both have 
always worked without a problem.

ISTR this has come up before. Are you not answering the dialog box at all, 
leaving it displayed, when you try to open the book after mounting the share?

Regards,
John Ralls



On Mar 5, 2022, at 9:50 AM, brad  wrote:

I think I have this sorted out.   I did try File->Open, but it didn't work.   I 
did know about the 'Known Mac Thing', so annoying.

Something not obvious, probably a bug.   When GC fails to open the last file, 
because it isn't there or the Sambashare hasn't been mounted yet, a GUI pops up 
saying it could not be found, it's in the history list, do you want to remove it?  
  You must say yes.   You must say yes even if you're going to open another file 
with File->Open.

The steps to recreate:   Start GC by clicking the app, before mounting the sambashare. 
  It fails.  Don't click yes on the history list removal (because why would you, 
you're going to mount the sambashare and use it).  Mount the sambashare & attempt 
to file->open the file.   Fail.
Subsequent attempts to mount the sambashare before starting GC, or copying the 
GC file to local hard drive will fail also, until saying 'Yes' remove the file 
from the history list.

This probably doesn't have anything to do with the MAC OS update, that was a 
distraction.

Thanks

On 3/4/22 20:25, D. wrote:

I'm not using a Mac anymore, but you should know that double clicking a file in 
Finder will not open that file in GnuCash but will open the last opened file 
instead. It is a Known Mac Thing.

You might want to try using File -> Open to see whether your File really won't 
open...

On 3/4/22 22:03, Adrien Monteleone wrote:

If you are getting a crash, you should file it on bugs.gnucash.org and attach 
your crash report there.

Also, check the wiki about obtaining a TraceFile. That might be helpful as well.

But first...

I'm guessing you can start GnuCash since it crashes on exit.

Can you navigate to File > Open and look for your file that way to reset the 
last-known location?

Regards,
Adrien

On 3/4/22 8:07 PM, brad wrote:

Upgraded to 4.9.  It still fails to open.   Also when closing GC it crashes.  I 
don't know if the list will allow it, but I'll attach the crash report.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mac fails to open gnucash file

[brad]

I think I have this sorted out.   I did try File->Open, but it didn't 
work.   I did know about the 'Known Mac Thing', so annoying.


Something not obvious, probably a bug.   When GC fails to open the last 
file, because it isn't there or the Sambashare hasn't been mounted yet, 
a GUI pops up saying it could not be found, it's in the history list, do 
you want to remove it?    You must say yes.   You must say yes even if 
you're going to open another file with File->Open.


The steps to recreate:   Start GC by clicking the app, before mounting 
the sambashare.   It fails.  Don't click yes on the history list removal 
(because why would you, you're going to mount the sambashare and use 
it).  Mount the sambashare & attempt to file->open the file.   Fail.
Subsequent attempts to mount the sambashare before starting GC, or 
copying the GC file to local hard drive will fail also, until saying 
'Yes' remove the file from the history list.


This probably doesn't have anything to do with the MAC OS update, that 
was a distraction.


Thanks

On 3/4/22 20:25, D. wrote:
I'm not using a Mac anymore, but you should know that double clicking 
a file in Finder will not open that file in GnuCash but will open the 
last opened file instead. It is a Known Mac Thing.


You might want to try using File -> Open to see whether your File 
really won't open...

On 3/4/22 22:03, Adrien Monteleone wrote:
If you are getting a crash, you should file it on bugs.gnucash.org and 
attach your crash report there.


Also, check the wiki about obtaining a TraceFile. That might be 
helpful as well.


But first...

I'm guessing you can start GnuCash since it crashes on exit.

Can you navigate to File > Open and look for your file that way to 
reset the last-known location?


Regards,
Adrien

On 3/4/22 8:07 PM, brad wrote:
Upgraded to 4.9.  It still fails to open.   Also when closing GC it 
crashes.  I don't know if the list will allow it, but I'll attach the 
crash report.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] mac fails to open gnucash file

[brad]

Upgraded to 4.9.  It still fails to open.   Also when closing GC it 
crashes.  I don't know if the list will allow it, but I'll attach the 
crash report.


On 3/4/22 17:48, William Prescott wrote:

There was a problem with 4.8 on Monterey. I don't remember the symptoms, but 
upgrading to 4.8-2 or 4.9 fixed it. Either should be compatible with 4.8 on 
Linux.

Will

On 2022 Mar 4, at 03-04 18:39:04, brad  wrote:

I suddenly can't open a gnucash file (it worked recently) on Mac. Gnucash 4.8.   
The Mac recently updated to 12.2.1, Monterey & that may have broken gnucash.
It will have an error msg like: 'Can't parse the URL/Volumes/.../brad.gnucash'
We usually run it on a Samba share, but I copied it over to the Mac and it 
can't open it on the hard drive either.   I've tried opening from finder, or 
from GC

If the answer is to update GC to 4.9 on the mac, can I keep running 4.8 on 
linux and be compatible?

Thx
Brad
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Translated Report (Full Report Below)
-

Process:   Gnucash [530]
Path:  /Applications/Gnucash.app/Contents/MacOS/Gnucash
Identifier:org.gnucash.Gnucash
Version:   4.9-1 (4.9-1)
Code Type: X86-64 (Native)
Parent Process:launchd [1]
User ID:   501

Date/Time: 2022-03-04 18:59:39.6358 -0700
OS Version:macOS 12.2.1 (21D62)
Report Version:12
Anonymous UUID:6A40DE88-4B5D-A277-2D35-CBD7C1706176


Time Awake Since Boot: 150 seconds

System Integrity Protection: enabled

Crashed Thread:0  Dispatch queue: com.apple.main-thread

Exception Type:EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:   KERN_INVALID_ADDRESS at 0x07c8
Exception Codes:   0x0001, 0x07c8
Exception Note:EXC_CORPSE_NOTIFY

Termination Reason:Namespace SIGNAL, Code 11 Segmentation fault: 11
Terminating Process:   exc handler [530]

VM Region Info: 0x7c8 is not in any region.  Bytes before following region: 
4391704632
  REGION TYPESTART - END [ VSIZE] PRT/MAX 
SHRMOD  REGION DETAIL
  UNUSED SPACE AT START
--->  
  __TEXT  105c42000-105c6a000[  160K] r-x/r-x 
SM=COW  ...MacOS/Gnucash

Application Specific Information:
Performing @selector(terminate:) from sender NSMenuItem 0x63532140


Thread 0 Crashed::  Dispatch queue: com.apple.main-thread
0   libobjc.A.dylib 0x7ff80858f49b 
realizeClassWithoutSwift(objc_class*, objc_class*) + 42
1   libobjc.A.dylib 0x7ff80858f5b1 
realizeClassWithoutSwift(objc_class*, objc_class*) + 320
2   libobjc.A.dylib 0x7ff8085945b3 
realizeClassMaybeSwiftMaybeRelock(objc_class*, mutex_tt&, bool) + 370
3   libobjc.A.dylib 0x7ff8085924bd lookUpImpOrForward + 
815
4   libobjc.A.dylib 0x7ff808591bdb 
_objc_msgSend_uncached + 75
5   libgdk-3.0.dylib   0x106852c1c 
_gdk_quartz_window_did_become_main + 348
6   CoreFoundation  0x7ff8087b9f23 
__CFNOTIFICATIONCENTER_IS_CALLING_OUT_TO_AN_OBSERVER__ + 12
7   CoreFoundation  0x7ff8088573f9 
___CFXRegistrationPost_block_invoke + 49
8   CoreFoundation  0x7ff808857376 _CFXRegistrationPost 
+ 496
9   CoreFoundation  0x7ff80878b836 _CFXNotificationPost 
+ 733
10  Foundation  0x7ff8095d31be 
-[NSNotificationCenter postNotificationName:object:userInfo:] + 82
11  AppKit  0x7ff80b32823b -[NSWindow 
_changeKeyAndMainLimitedOK:] + 1075
12  AppKit  0x7ff80b327ca9 -[NSWindow 
_makeKeyRegardlessOfVisibility] + 76
13  AppKit  0x7ff80b31db54 -[NSWindow 
makeKeyAndOrderFront:] + 40
14  libgdk-3.0.dylib   0x106852e6c 
_gdk_quartz_window_did_resign_main + 268
15

[GNC] mac fails to open gnucash file

[brad]

I suddenly can't open a gnucash file (it worked recently) on Mac. 
Gnucash 4.8.   The Mac recently updated to 12.2.1, Monterey & that may 
have broken gnucash.
It will have an error msg like: 'Can't parse the 
URL/Volumes/.../brad.gnucash'
We usually run it on a Samba share, but I copied it over to the Mac and 
it can't open it on the hard drive either.   I've tried opening from 
finder, or from GC


If the answer is to update GC to 4.9 on the mac, can I keep running 4.8 
on linux and be compatible?


Thx
Brad
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Setting up Government Bond

[brad]

I think the problem may be that you do need to treat it as a security 
(like a stock).    When you enter the transaction you need to enter the 
number of shares and the total cost and let the price per share be 
automatically filled.


On 2/23/22 08:43, Suseno Dermawan wrote:

Hi all,
I'm recently new to gnucash. i play around with this for a couple weeks.
I've figured out of recording crypto currency as fund and able to set up an
opening balance for it.
however it is a different matter with bond. specifically government bond.

what i have, the bond isn't like stock, where there is a price per share
but it's lump sum of i.e. 1000 usd.
how should i record this ?

I enter one in the price editor (screenshot attached)
[image: image.png]

below is the security editor entry

[image: image.png]

but when i made the transaction it always
goes as follow:
[image: image.png]
i can't make the  total share as 30.000.000

i want to be able to see 30.000.000 ORI19 in the dashboard.
[image: image.png]
instead i get  300.000 ORI19
can some help to explain how should i go about this?

Thank you,


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash Backup

[brad]

There's a tool called rsnapshot on linux that is pretty easy to use.   
(rsnapshot.org)


On 2/22/22 18:01, Chris Good wrote:

Message: 1
Date: Tue, 22 Feb 2022 10:49:42 -0700
From: Mario Nigrovic 
To: gnucash-user@gnucash.org
Subject: [GNC] (no subject)
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Many years ago, I had used gnucash, and was pretty happy with it. I was very
careful to make regular backups of my data, and so, when my disk inevitably
crashed, I was not too worried. However, I was mortified to discover that,
although all my transaction data had been saved, all my custom reports were
lost, as they had been stored separately in a secret undisclosed location, I
later discovered to be elsewhere in my home directory.

Recently, I have decided to try again to use gnucash, but I would like very
much to ensure ALL my data is backed up. So I hit upon the idea of running
the tool under a custom value of $HOME, but I was then shocked to discover
that even with this method, gnucash was able to remember previous locations
of my database file, which suggests that the tool is also using some kind of
other mechanism to save historical data, and that makes me very nervous
about actually being able to do proper backups of everything related to the
tool.
Doing some sleuthing using strace, I was able to find the previous database
location delivered through some socket connection, and that really scares
me, since it is now possible critical data is stored via some other Linux
service and I will have no way to trace out where this may be to avoid
future nasty surprises.
I have not seen any documentation about backup strategies other than the
aromatic saving of previous data files, yet I do see that there was data
being stored at least in ~/.local, so I'm hoping someone on this list may be
able to point me to some more thorough discussion of ALL the places user
data from gnucash may be stored.
Thanks for your help!

-- Mario

Hi Mario,

Backups are discussed in https://wiki.gnucash.org/wiki/Backup

You may also like the tool I wrote for backing up (just about) all the
possible files that hold GnuCash configuration:

Linux:
https://github.com/goodvibes2/BackupGnuCashLinux
Windows:
https://github.com/goodvibes2/BackupGnuCashWin

I know this is not the simplest to understand but that's how it is.
If you cannot figure out what to do, just follow the instructions for
Version 2.x in java 11 and using the Precompiled Binaries.

Regards,
Chris Good

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Question on Parent Accounts

[Brad Weibel]

Need to have a new parent account (Cost of Goods Sold) … not able to determine 
how to go about setting  up a new parent account

Sent from Mail for Windows

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash & Macros

[brad]

There used to be a wiki page with some examples for using the python 
bindings.   I don't see it anymore, but I did notice examples on git

https://github.com/Gnucash/gnucash/tree/maint/bindings/python/example_scripts

I'm using a python script to do exactly what the OP is looking for & it 
looks like there is a script in the example_scripts link to do that also.


Note: this question was posted 7 months ago

On 12/31/21 07:49, Jon Schewe wrote:

On Fri, 2021-12-31 at 16:22 +0800, Kevin Buckley wrote:

On Wed, 26 May 2021 at 23:11, Jack Frillman via gnucash-user
<
gnucash-user@gnucash.org

wrote:
I have repetitive task I do every day and I would like to reducey
the
number of steps to do that task.

More specifically I import stock/mutual fund and precious metal
prices
from a CSV file. Currently I go through the multi-step process the
GUI
walks you through. This is easy enough but I can be ultra lazy at
times
and would like to execute that import process using a macro if
possible.


Whilst I can't suggest a "macro" within Gnucash, I can suggest
another
way to achieve the same thing, assumimg you are happy doing a bit
of shell scripting, plain text editing, and store your GnuCash files
in
uncompressed XML format.

If you are comfortable running a script and learning a little python,
this may help you with some options
https://github.com/jpschewe/gnucash-stock-portfolio
It uses the gnucash API to write stock information.

I second the lots of backups suggestion.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] A repository for user-contributed files

[brad]

Is that page linked to on another wiki page?  Perhaps it doesn't get 
attention because no one knows it is there


On 12/31/21 08:19, David Carlson wrote:

There is a page in the GnuCash WIKI for user "Tool" submissions.  It does
not get as much attention as it deserves.  It is located here: <
https://wiki.gnucash.org/wiki/Published_tools>

On Fri, Dec 31, 2021 at 5:16 AM Dr. David Kirkby <
drkir...@kirkbymicrowave.co.uk> wrote:


On Thu, 30 Dec 2021 at 05:59, Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:


Thanks for the link, and I'll take a look, but I am curious...

Why not just post that info on the Wiki in that place?

What happens if your company site goes down/dark?

Do the various tips not still apply to GnuCash which has no relation to
your company?

Are you opposed to sharing your tips and tricks with the broader GnuCash
community?

Do you mind if they are posted on the GnuCash wiki directly?

Regards,
Adrien


I think if you take a look, you will realise that the intension was to
share them, requesting others to take backups, in case I die and the
website goes down. So I was obviously not expecting them to be specific to
my company, the fact I was requesting others to take backups.

Sending an email to this list, adding an entry to the Wiki were all
mentioned.

When I asked about a repository, I was told one didn’t exist. Someone
suggested GIT, someone else mentioned the ownership of git.

I was just offering some storage area if it was wanted.

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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.





___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Backports in Ubuntu? was: Ubuntu binary fairly dated

[brad]

Later versions of Ubuntu are not too far out of date
21.10: 4.4
21.04: 4.4

A month or so ago I was asking a similar question & someone posted a 
script to build it.  See attached (hopefully). It worked for me except 
the location of the binary was a bit confusing.


On 12/3/21 5:24 PM, Mike Brady wrote:

Thanks. I might look at the Debian repos. But afaik, and as discussed by
others in the thread, it appears that for Ubuntu the app versions are
frozen to the main kernel versions. So unless some other method is used,
we're stuck at 3.8 for Gnucash (for instance) until Mint upgrades or we
can otherwise force a more current kernel version. With Mint, upgrades
seem to happen every 2-3 years, so it's a long time to wait for app updates.

The other apps I mentioned (LibreOffice, Firefox, and Thunderbird) seem
to have a way other than Flatpack to bypass the Ubuntu limitation. I
don't really know how. Otherwise, we have to build from source to get a
newer version; not the most user-friendly method, especially after using
Windows for many years.

-MIke

On 12/3/2021 3:13 PM, Frank H. Ellenberger wrote:

Hi Mike,

Am 03.12.21 um 22:19 schrieb Mike Brady:

Have been following this thread because I use Linux Mint, which is based
on the LTS version of Ubuntu. Yes, the GnuCash version in the Ubuntu LTS
repository is way out of date (3.8).

:

AFAIK the Ubuntu family is a branch of the Debian family. And Debian has
usually recent GnuCash versions in their Backports repos.
Q1: Offers Ubuntu no backports repos?
If the answer is No, Why?
Perhhaps worth to discuss with the Ubuntu user base?

Regards
Frank

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




build-gnucash.sh
Description: application/shellscript
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Newest version for Ubuntu 20.04 LTS

[brad]

Don't you need to be in $SOURCEDIR for the git commands?


On 11/19/21 12:10 AM, david whiting wrote:

Hi Brad,

Once you have the sources you can use git to checkout any previous
version you want. To see the tagged versions, in a terminal type:

git tag

The last 10 lines show:

4.2-post-string-freeze
4.3
4.3-string-freeze
4.4
4.5
4.6
4.7
4.8
4.8a
gnucash-1-9-0

So, if you want version 4.8a, you can do:

git checkout -b 4.8a 4.8a

This will checkout the version tagged 4.8a, and create a new branch
called 4.8a. Once you have that, you can just change to the build
directory and run the cmake and make commands. I have selected 4.8a,
if you want version 4.8 instead, just use 4.8 instead of 4.8a in the
git checkout. Note, once you have the source code, you don't need to
run the whole script again to get a new version. When there is a new
release, e.g. 4.9 or 5.0, or 5.1, or whatever, you can just:

git checkout maint
git pull

to get the latest commits, then:

git checkout -b 5.0 5.0

(for example) to get that version.

Here is the script again, with the git checkout command added (near the end):

 build-gnucash.sh  

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

sudo apt update
sudo apt upgrade

sudo apt-get install build-essential
## This is one long line
sudo apt install git make cmake libglib2.0-dev libxml2-dev
libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
gwenhywfar-tools libgwengui-gtk3-dev

# Only use the next 2 lines if you have not installed [[Google_Test |
Google Test]] already.
sudo apt install libgtest-dev# >=1.7.0
sudo apt install google-mock # 1.8.0 installs
googlemock in a subdirectory of gtest

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
[ ! -d $SOURCEDIR/gnucash ] && git clone
https://github.com/Gnucash/gnucash.git $SOURCEDIR

## Checkout version 4.8a
git checkout -b 4.8a 4.8a

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR

make

 end of script ====


David

On Thu, 18 Nov 2021 at 22:07, brad  wrote:

David,  Will your script build the latest stable release?  If not what
do I change to do that?

On 10/2/21 11:48 AM, david whiting wrote:

Hi Jeff,

On Wed, 29 Sept 2021 at 07:11, Jeff  wrote:
[...]

I would settle for a copy of "Building the Newest Version of GNC for
Dummies Course" book.

Others have shown you that you can use flatpak to get the latest
version, but if you do want to build from source I have found that the
following works on Ubuntu 20.04. I have also attached it as a script.
This clones the source from git and by default builds the maintenance
version. The versions are tagged, so you can use git to checkout a
different version and build that if you want, e.g. you could build 4.8
rather than maint.

 build-gnucash.sh  

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

sudo apt update
sudo apt upgrade

sudo apt-get install build-essential
## This is one long line
sudo apt install git make cmake libglib2.0-dev libxml2-dev
libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
gwenhywfar-tools libgwengui-gtk3-dev

# Only use the next 2 lines if you have not installed [[Google_Test |
Google Test]] already.
sudo apt install libgtest-dev# >=1.7.0
sudo apt install google-mock # 1.8.0 installs
googlemock in a subdirectory of gtest

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
[ ! -d $SOURCEDIR/gnucash ] && git clone
https://github.com/Gnucash/gnucash.git $SOURCEDIR

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR

make

 end of script 

David

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more informat

Re: [GNC] Newest version for Ubuntu 20.04 LTS

[brad]

David,  Will your script build the latest stable release?  If not what 
do I change to do that?


On 10/2/21 11:48 AM, david whiting wrote:

Hi Jeff,

On Wed, 29 Sept 2021 at 07:11, Jeff  wrote:
[...]

I would settle for a copy of "Building the Newest Version of GNC for
Dummies Course" book.

Others have shown you that you can use flatpak to get the latest
version, but if you do want to build from source I have found that the
following works on Ubuntu 20.04. I have also attached it as a script.
This clones the source from git and by default builds the maintenance
version. The versions are tagged, so you can use git to checkout a
different version and build that if you want, e.g. you could build 4.8
rather than maint.

 build-gnucash.sh  

## Change this if you want to build it somewhere else.
SOURCEDIR="$HOME/Documents/gnucash/source"
BUILDDIR="$HOME/Documents/gnucash/build"

sudo apt update
sudo apt upgrade

sudo apt-get install build-essential
## This is one long line
sudo apt install git make cmake libglib2.0-dev libxml2-dev
libxslt1-dev libwebkit2gtk-4.0-dev gettext swig guile-3.0-dev
libofx-dev xsltproc libboost-all-dev libdbi1 libdbi-dev libdbd-sqlite3
libsecret-1-0 libsecret-1-dev aqbanking-tools libaqbanking-dev
gwenhywfar-tools libgwengui-gtk3-dev

# Only use the next 2 lines if you have not installed [[Google_Test |
Google Test]] already.
sudo apt install libgtest-dev# >=1.7.0
sudo apt install google-mock # 1.8.0 installs
googlemock in a subdirectory of gtest

mkdir -p $SOURCEDIR
mkdir -p $BUILDDIR

## Clone gnucash source from git, if it is not already there
[ ! -d $SOURCEDIR/gnucash ] && git clone
https://github.com/Gnucash/gnucash.git $SOURCEDIR

cd $BUILDDIR
cmake -DCMAKE_INSTALL_PREFIX=$HOME/opt/gnucash $SOURCEDIR

make

 end of script 

David

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Best way to upgrade from an old version (2.6.14) to current

[brad]

I'm a bit confused as to the best update method.   These seem to be 
differing methods, incrementally updating GC (3 steps), or jump to 4.4 
(1 step) and let it do the data update in one step.    Is the JR one 
step method reliable for a big file with many accounts?


On 1/8/21 10:15 AM, John Ralls wrote:


The old GnuCash file still has a bunch of imports and starting with it will 
save you some time importing and perhaps training the import-matcher. Make a 
separate backup of it for an extra layer of safety.

Since you didn't actually use GnuCash much it's probably safe to just install 
4.4. The installer will take care of uninstalling your old 2.6.14. There's a 
bunch of upgrading that GnuCash will do on its first run and a bunch more on 
the first import, so be patient! If your existing file is large and your old 
laptop is slow or doesn't have a lot of memory it may take more than an 
hour--someone reported several hours for a very large file--to run all of the 
startup scrubs and then more hours to update the import maps, so plug in the 
laptop, turn off energy savers (it's OK to blank the screen but you don't want 
it to go to sleep), and plan to leave it running for a while.

As you bring the GnuCash file up to date do small imports--a month or two worth 
of transactions--to begin. If most of the imported transactions are matched 
correctly then you can go to larger import batches, but if they're not then 
you'll want to do a half dozen or so small batches to train the matcher. Note 
that there's a recently added feature that allows you to select several 
transactions in the matcher window and assign all of them to the same transfer 
account; just right-click after selecting and pick Assign Account from the 
context menu (it's the only option).

Remember to save frequently so that you can easily go back if something goes 
wrong.

Regards,
John Ralls

On 1/8/21 10:28 AM, D. via gnucash-user wrote:

Welcome back!

Let me start with the last point first: in my experience, Gnucash's developer 
team is deeply committed to compatibility, and works to ensure that upgrades 
preserve ALL previous data. Furthermore, the default data storage is XML, which 
is text that is human readable, and fully transparent to the end user (I'll add 
the caveat here that for efficiency's sake, the file is usually stored in a 
compressed format, which cannot be directly read by humans, but which can be 
expanded and then read).

Under the circumstances, you can follow either path, but I'd probably choose to 
upgrade and update in place, depending on details. Arguing in favor of a fully 
new start in 4.4 is the simplicity of downloading that version and starting 
anew. Rather strongly against this, however, is the fact that you have already 
imported most of your history into the older version--a process that is usually 
somewhat painful.

Under the alternative, you'd update the software, confirm your existing data, 
and then import new transactions from Quicken. This would allow you to build 
off the existing data set, perhaps quickly.

If you follow the upgrade path, the recommended method is to:
1) Make a backup of your data file.
2) Upgrade to 2.16.21, open your file and perform a check & repair on the 
entire file.
3) Upgrade to 3.11, open your file and perform a check & repair on the entire 
file.
4) Upgrade to 4.4, open your file and perform a check & repair on the entire 
file.
5) Export new transactions from Quicken.
6) Import these transactions into Gnucash.
7) Perform any reconciliations in date order.
8) Relax, don't worry, have a home brew.  (This last directive might not apply 
to the current set of activities)

HTH,
David T.




___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] OFX import, wrong base account

[brad]

Thanks.  That did it.  The account numbers looked right there, so I just 
deleted it all.


On 8/18/20 11:43 AM, Jean Laroche wrote:

Have you tried using Tools/Import Map Editor (in the tools menu)?
Select "Online" on the far right to change or remove OFX import 
account associations. Find the wrong one and remove it.

Jean

On 8/18/20 10:36 AM, brad wrote:
I'm still looking for ideas on this.   I'm comfortable unzipping the 
gc file and tweaking with a text editor if that's what needs to be done.



On 8/10/20 1:52 PM, brad wrote:
I tried to import an OFX from a different institution, a credit card 
this time, it was a bank last time.   It used the same account as 
the Source Account.
I tried a trick I found on the list from a decade ago, delete the 
account, and move all transaction to a new account.  No go.   Now it 
seemed to randomly pick another account as the Source Account.


On 8/10/20 12:57 PM, brad wrote:
I'm running my 1st OFX import since updating to 3.8 and the ofx 
import is going to the wrong base (source) account.    How do I 
change that??

I see this in the help
*|"GnuCash|* then opens an Account Selection dialog to select an 
account in your CoA to match to an account name in the import file. 
Select the appropriate account from the account tree and press the 
*OK* button. On subsequent import of files from the same source 
account, the mapped *|GnuCash|* account is remembered and the 
account selection dialog is not displayed."

But that doesn't help me reset it.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] OFX import, wrong base account

[brad]

I'm still looking for ideas on this.   I'm comfortable unzipping the gc 
file and tweaking with a text editor if that's what needs to be done.



On 8/10/20 1:52 PM, brad wrote:
I tried to import an OFX from a different institution, a credit card 
this time, it was a bank last time.   It used the same account as the 
Source Account.
I tried a trick I found on the list from a decade ago, delete the 
account, and move all transaction to a new account.  No go.   Now it 
seemed to randomly pick another account as the Source Account.


On 8/10/20 12:57 PM, brad wrote:
I'm running my 1st OFX import since updating to 3.8 and the ofx 
import is going to the wrong base (source) account.    How do I 
change that??

I see this in the help
*|"GnuCash|* then opens an Account Selection dialog to select an 
account in your CoA to match to an account name in the import file. 
Select the appropriate account from the account tree and press the 
*OK* button. On subsequent import of files from the same source 
account, the mapped *|GnuCash|* account is remembered and the account 
selection dialog is not displayed."

But that doesn't help me reset it.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] OFX import, wrong base account

[brad]

I tried to import an OFX from a different institution, a credit card 
this time, it was a bank last time.   It used the same account as the 
Source Account.
I tried a trick I found on the list from a decade ago, delete the 
account, and move all transaction to a new account.  No go.   Now it 
seemed to randomly pick another account as the Source Account.


On 8/10/20 12:57 PM, brad wrote:
I'm running my 1st OFX import since updating to 3.8 and the ofx import 
is going to the wrong base (source) account.    How do I change that??

I see this in the help
*|"GnuCash|* then opens an Account Selection dialog to select an 
account in your CoA to match to an account name in the import file. 
Select the appropriate account from the account tree and press the 
*OK* button. On subsequent import of files from the same source 
account, the mapped *|GnuCash|* account is remembered and the account 
selection dialog is not displayed."

But that doesn't help me reset it.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] OFX import, wrong base account

[brad]

I'm running my 1st OFX import since updating to 3.8 and the ofx import 
is going to the wrong base (source) account.    How do I change that??

I see this in the help
*|"GnuCash|* then opens an Account Selection dialog to select an account 
in your CoA to match to an account name in the import file. Select the 
appropriate account from the account tree and press the *OK* button. On 
subsequent import of files from the same source account, the mapped 
*|GnuCash|* account is remembered and the account selection dialog is 
not displayed."

But that doesn't help me reset it.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to transfer investment

[brad]

Open the account you're transferring from.
On a new transaction line, in the transfer column, select the account 
the shares are going to.
Enter the shares as a negative number, and a current share price (you 
have to put something there).

click on the 'show all splits in the current transaction' button
Now it will show both accounts,  enter the same number of shares (+ this 
time) and the same price in the other account.


On 12/14/19 8:50 AM, Heide Wang wrote:

Hi Brad,

Thank you for your reply.  Can you be more specific?

Heide

On 12/12/19 2:12 PM, brad wrote:
I don't think you'd have to show it as a sell to cash, just open the 
split dialog and enter the shares,  sell on one line, buy on the other.


On 12/10/19 7:11 PM, Heide Wang wrote:
I have stocks in two different account. if I need to transfer the 
investments (stocks) from one account to another account, Should I 
sell the investment on one account and buy it in another account or 
there is better and easier way to do it? I am using old version 
2.6.18. Thanks.


Heide
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to transfer investment

[brad]

I don't think you'd have to show it as a sell to cash, just open the 
split dialog and enter the shares,  sell on one line, buy on the other.


On 12/10/19 7:11 PM, Heide Wang wrote:

I have stocks in two different account. if I need to transfer the investments 
(stocks) from one account to another account, Should I sell the investment on 
one account and buy it in another account or there is better and easier way to 
do it? I am using old version 2.6.18. Thanks.

Heide
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] alpha advantage

[brad]

I switched to the quote source 'Yahoo as JSON'  & it works great.

On 10/28/18 11:50 PM, Steven Anter wrote:

version of gnucash = 3.0
OS = windows 10

Changes = none, other than adding a couple new securities

A couple securities =  NYSE:AA
FUND:VTSAX
NASDAQ:VNQI

On Sun, Oct 28, 2018 at 10:39 PM David Carlson 
wrote:


You are very lucky if you were getting 50 prices from AlphaVantage as
recently as a week ago.  Since there have been several different causes of
impaired performance you really need to provide all the details I mentioned
in my first reply to you and even a couple of example securities and
exchange on which they are traded in order for others on this user list to
suggest solutions to your problem.

David C

On Mon, Oct 29, 2018 at 12:22 AM Steven Anter  wrote:


David,

I have about 50+ securities. Alpha has been working ok, albeit with a few
incorrect prices, until this weekend. What list are you talking about that
I should "search?"

On Sun, Oct 28, 2018 at 9:57 PM David Carlson <
david.carlson@gmail.com> wrote:


Steven,

AlphaVantage stopped working for those of us with more than a few
securities several months ago when they started throttling services.  Some
of us have also had issues after downloading release 3.3 or so of GnuCash.
Search this list for info that seems to match your particular problem or
provide more details about when it last worked for you, what version of
GnuCash you are using, your computer OS,  and what you have changed since
it last worked for suggestions about how to restore price retrieval.

David C

On Sun, Oct 28, 2018 at 3:44 PM Steven Anter  wrote:


I've been using alpha advantage to download quotes for some time now.
However, it fails with message:  "unable to retrieve quotes for these
items."  The list includes all my securities.  Is there a new
development
with alpha advantage that I should know about?
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Next release of F::Q

[brad]

My version of  AlphaVantage.pm in 
/usr/local/share/perl/5.26.1/Finance/Quote/AlphaVantage.pm has no 
maxQueries variable.   I just ran gnc-fq-update.   Do we need to get the 
latest from github?


On 08/16/2018 03:20 AM, Erik Colson wrote:

Hello all,

I'm on some extended vacation and will be back home next week.  My
intent is to release F::Q from master at the end of this month.

The alphavantage module has undergone some modifications which should
make it more reliable since we can now tell the module at which speed it
can question the alphavantage API.

Before releasing F::Q, I would like as many feedback as possible on the
best working arguments.  You can therefor play with the following
variables in the Alphavantage.pm file:

my $maxQueries = { quantity =>20 , seconds => 65}; # no more than x queries per 
y seconds

Probably we should now set quantity to 5 and seconds to 61, but maybe
there are some better values?  The values above seem to work pretty well
on my automated home system.  Sometimes queries get rejected, but the
module is now smart enough to insert a delay if alphavantage API refuses
to answer queries.

The purpose of next release is to fix the problems with Alphavantage
speed control, so I won't add any other commits to other modules for
this release.  I've seen some messages on github concerning
Alphavantage.pm and will read those while enhancing the module.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance::Quote still not working with alphavantage

[brad]

I just updated to xubuntu 18.04 and the packaged gnucash 2.6.19, and I 
still have to update Quote.pm with this.


https://raw.githubusercontent.com/mtalexander/finance-quote/6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm


From the list:
On Sat, Mar 31, 2018 at 9:49 PM, Chris Good  wrote:


Hi Steven,



Please see my mail below but get the Quote.pm + AlphaVantage.pm from Mike
Alexander’s git hub instead of mine as he has also put the 1 second delay
between each request for a currency and you will need that.



Get from Quote.pm from

https://raw.githubusercontent.com/mtalexander/finance-quote/
6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote.pm



Get AlphaVantage.pm from

https://github.com/mtalexander/finance-quote/blob/
6ee43ea08b504617142139fda41ae45be865fa38/lib/Finance/Quote/AlphaVantage.pm



Regards,



Chris Good



On 07/05/2018 02:45 PM, David Carlson wrote:

Greg,

Just so you don't feel like you are alone, I have GnuCash running on for
different machines one Windows and three are assorted versions of Uubuntu
and Debian.  Only one of them (one of the Ubuntu machines) will retrieve
quotes successfully through AlphaVantage, and that is about 1/3 to 1/2 of
the U.S. stocks and mutual funds in my list on a given try.  In two or
three tries I think that I get most of them. All of my machines are running
some GnuCash release between 2.6.12 and 2.6.17 and I think that I have gone
through all the steps that have been mentioned in this thread on most of
the machines but GnuCash still does not even tell me that it did not get
any of those stocks or mutual funds.

I suspect that GnuCash may not even be able to find the environment setting
or something.


David C

On Thu, Jul 5, 2018 at 1:05 PM, Greg Etling  wrote:


Reviving this thread - I decided to follow others' recommendation of
installing perlbrew, and F::Q is working from the CLI. However, I'm not
seeing any change in the Gnucash behavior (v2.6.21, key in the preferences
pane, retrieval failing), so I think I'm missing a step on having Gnucash
actually use the perlbrew version of perl. Can anyone let me know what I'm
likely forgetting?

Thanks

Greg
917-664-0083
http://gregetling.com
--
"The credit belongs to the man who is actually in the arena, whose face is
marred by dust and sweat and blood; who strives valiantly; who errs, who
comes short again and again, because there is no effort without error and
shortcoming" -Theodore Roosevelt

On Sun, Nov 19, 2017 at 4:59 PM, Frank Saporito <
frank.saporito...@gmail.com

wrote:
Hi Greg

Is this what you are looking for?

$ ONLINE_TEST=1 prove -lvof t/alphavantage.t
Cannot determine source for t/alphavantage.t at
/usr/share/perl5/App/Prove.pm line 496

thanks



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-

f1415819.html

___
gnucash-user mailing list
gnucash-user@gnucash.org
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
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] where to share GnuCash python scripts?

[brad]

It might be helpful also to add a link your github files here:

https://wiki.gnucash.org/wiki/Using_GnuCash


On 03/24/2018 01:33 AM, Amish wrote:

For open source codes - GitHub would be a good place.

https://github.com/

On Friday 23 March 2018 11:15 PM, darrylctx wrote:
Where would be the best place to upload the .py files if I wanted to 
share
them?  Right now, they are pretty raw, but I could clean them up and 
make
them a little easier to use.  At the least, they are an example of 
how easy

it is to get data into GC with a few simple python scripts.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Fw: Re: Getting Active Perl

[Brad Lane via gnucash-user]

Thanks for telling me. I am new to using mailing list an unfamiliar with the 
guidelines/rules.Can you guide me to information about how to do so?
Regards,
 
Brad 

 

   - Forwarded Message - From: Geert Janssens 
To: Brad Lane Sent: Thursday, 
March 29, 2018, 3:58:33 AM EDTSubject: Re: Getting Active Perl
 Please make sure to keep the conversations on the mailing list. It is 
considered rude to send mail directly to other users/developers unless 
explicitly told to do so. Additionally, that one person you reply to may not 
have all the answers. You have more chances for a complete answer by keeping 
the conversation on the list.

You can do so by using the "Reply to all" or "Reply to list" features of your 
mail program.

Op woensdag 28 maart 2018 21:35:03 CEST schreef Brad Lane:
> Sorry. Default or not, I'm not seeing it. Even reinstalled GNU Cash.I do not
> see it under Windows 7 32 bit Start.Suggestions? Regards,
> 
> Brad 
> 
What version of gnucash ?

On Windows 7 it should be in the Gnucash group.

Regards,

Geert

> 
> 
>    On Wednesday, March 28, 2018, 2:15:04 PM EDT, Geert Janssens
>  wrote:
>  Op woensdag 28 maart 2018 20:03:54 CEST schreef Brad Lane:
> > Thank you. I have installed Strawberry Perl.Where can I find a copy of the
> > Install F::Q batch  file?
> > Regards,
> > 
> > Brad
> 
> It is shipped with gnucash by default on Windows. You can start it from the
> Windows start menu. It's menu item is called
> "Install Online Price Retrieval for GnuCash"
> 
> Regards,
> 
> Geert




  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Getting Active Perl

[Brad Lane via gnucash-user]

Gentlemen or Ladies
I am installing GNU Cash on my Windows 7 32 bit computer and want to get 
Finance::Quote for the program. I went to ActiveState.com looking for 
ActivePerl and only found a 64 bit version. Do you know how I can get a version 
of ActivePerl that will run on my computer so I can get Finance::Quote?
Regards,
 
Brad 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash: Docs: Where to document?

[brad]

I would like to see something on this in the wiki.

Just because Mac & windows don't have python and sql by default doesn't 
mean that the knowledge base should be dumbed down.



On 12/11/2017 09:29 PM, John Ralls wrote:



On Dec 11, 2017, at 4:41 PM, Charles Sliger  wrote:


On Mon, 2017-12-11 at 16:01 -0800, John Ralls wrote:

On Dec 11, 2017, at 2:27 PM, Charles Sliger  wrote:

I'm starting to migrate from QuickBooks to GnuCash.
I'm working my way through the integration issues with
Gnucash - Python - Postgresql
How would the GnuCash team prefer that I document this for the benefit
of others?

I've got about 30 years of unix/database/network systems engineering
under my belt and without that to draw on I don't think I would be able
to work my way through this as the documentation seems rather sparse and
fractured.

I'll have to document it for my own purposes anyway so let me know if
there's interest.


Chaz,

Can you outline what you propose to document? Integration with QuickBooks 
doesn’t really make sense to me and SQL servers have plenty of documentation 
themselves as well as hundreds of books and websites teaching how to administer 
them. Repeating any of that in our documentation would be pointless.

Regards,
John Ralls



John,
What I will be documenting is the actual nuts and bolts process for
using GnuCash, Python, and Postgresql together.  Integration is probably
too strong a word right now but I see these three as being very
complementary.  While it might be true that all of the information is
out there somewhere, I have had to make a number of educated guesses in
the process of just getting GnuCash and Postgresql working together.
This was after purchasing and reading all three books on GnuCash and
spending a good deal of time with on-line research.  Most people are not
going to have the time to become dba's in order to reap the benefits of
an RDBMS such as Postgresql.  I find they can benefit from having the
documentation for something like this pulled together in a single
narrative.  Given that the average PC today can easily handle running a
combination like this, it seems natural to leverage the capabilities of
a database like Postgresql.
S...  I just thought I'd ask if there was a place put this kind of
information and a process for getting it there.

It seems to me that your personal blog might be a good place to document the 
“process”. I think that anything involving coding is not of major interest to 
99 and 44/100% of our user base. That’s not to say that you can’t write useful 
articles about it for the wiki, but the wiki’s general style is more 
descriptive than narrative.

As for most people not having the time to learn to be DBAs, I agree. What I 
disagree about is that they should set up a DB server anyway. With your 30 
years of experience you might think that maintaining a DB server and ensuring 
that it’s secure and that the data is properly backed up is trivial, but for 
nearly all users that’s far from being the case. If it’s possible to write “How 
to be a competent DBA in 30 minutes” then there are a dozen books and 100+ 
websites out there already. I haven’t found them and I don’t think it’s 
possible, but if I’m wrong then far better to put some pointers in the wiki 
than to create the 137th version.

It is possible, even simple, to enjoy the benefits of SQL without messing 
around with being a server DBA. SQLite3 creates a very usable SQL database in a 
single file that can be easily copied for backup, no administration 
required--in fact, nothing much to administer.

One more point: You perhaps misunderstand how GnuCash uses the database 
backends. It is not (yet, nor will it be in 2.8) a database application. It 
uses the database as a data store, reading the whole thing into memory at the 
beginning of the session. After that the only queries are updates and inserts.

To answer your final question, the place in the GnuCash infrastructure to put it would be 
the wiki, https://wiki.gnucash.org/wiki . Thanks to 
spammers we have had to insert human approval into the account creation process. Just say 
something about what you want to write so that we know that you’re not a spam-bot or 
someone who thinks they need a wiki account to use the program and your request will be 
quickly approved. After that there’s a one-week waiting period for your account to be 
blessed for editing. There might be an issue about creating pages after that; if you have a 
problem best to bring it up on IRC (https://wiki.gnucash.org/wiki/IRC 
).

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
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@

batch edit security editor

[brad]

Since it sounds like alphavantage is going to be slower than yahoo and I 
have quite a few securities that I don't need to get quotes for anymore 
I turned off 'get online quotes' for everything with a script edit of 
the xml file.   Then I can update the relatively few securities I need 
with quote source 'alphavantage'.


!!!  Warning unapproved and possibly dangerous (but it worked for me). !!!

The heart of this is the sed command.  This was my workflow from a 
unix/linux shell:


close gnucash

If your gnucash file is called file.gnucash

cd to the directory where file.gnucash exists

cp file.gnucash file.gnucash.bak  # back it up in case things go wrong

mkdir Temp

cd Temp

cp ../file.gnucash file.gnucash.gz   # the gnucash file is compressed

gunzip file.gnucash.gz  # because gunzip likes the suffix to be there

sed 's;;;' file.gnucash > temp

mv temp file.gnucash

gzip file.gnucash

mv file.gnucash.gz ../file.gnucash




___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Finance-Quote 1.44 released!

[brad]

On my xubuntu, gnc-fq-update isn't there.  I ran

sudo perl -MCPAN -e shell

Then in the perl shell:

reload index

upgrade Finance::Quote

If I didn't 'reload index' it wasn't getting the latest.


On 11/07/2017 03:39 PM, John Ralls wrote:

The simplest way is to run `sudo gnc-fq-update`.

Regards,
John Ralls


On Nov 7, 2017, at 2:12 PM, Les  wrote:

Can someone refresh my memory on how to update F::Q.  I don't even know what 
version I currently have installed.  I am on Linux Mint 18.2 and installed GC 
from GetDebs (current version of GC 2.6.17.)


Thanks,
Les


On 11/07/2017 02:58 PM, Erik Colson wrote:

New version 1.44 of Finance-Quote is available with the following changes:

 * Added currencies for .SA (Brazil) and .TO (Canada/Toronto) markets
 * Setup a pause of .7s between queries in AlphaVantage.pm to limit 
queries

Authors:
   - Dj Padzensky , PadzNet, Inc.
   - Linas Vepstas 
   - Yannick LE NY 
   - Paul Fenwick 
   - Brent Neal 
   - Volker Stuerzl 
   - Keith Refson 
   - Rob Sessink 
   - Leigh Wedding 
   - Tobias Vancura 
   - James Treacy 
   - Bradley Dean 
   - Erik Colson 
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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
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
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: Finance-Quote 1.42 released!

[brad]

I got the system error in gnucash yesterday too, with FQ 1.40. I'm not 
getting that error right now, but not getting the quotes either.   I've 
updated to 1.43


Running the identical gnc-fq-dump cmd, sometimes gives an error & 
sometimes works


gnc-fq-dump -v alphavantage IWD
--- snip non useful bits ...

All fields returned by Finance::Quote for stock IWD

stock   field  value
-   -  -
IWD  errormsg: Invalid API call. Please retry or visit the 
documentation (https://www.alphavantage.co/documentation/) for 
TIME_SERIES_DAILY.

...

just a few seconds later it works

gnc-fq-dump -v alphavantage IWD
Finance::Quote fields Gnucash uses:
    symbol: IWD  <=== required
  date: 11/06/2017   <=== required
  currency: USD  <=== required
  last: 120.0700 <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

All fields returned by Finance::Quote for stock IWD

stock   field  value
-   -  -
IWD close: 120.0700
IWD  currency: USD
IWD  date: 11/06/2017
IWD  high: 120.1400
IWD   isodate: 2017-11-06
IWD  last: 120.0700
IWD   low: 119.7800
IWD    method: alphavantage
IWD  open: 119.9200
IWD   success: 1
IWD    symbol: IWD
IWD    volume: 1235771

On 11/07/2017 09:19 AM, Russell Mercer wrote:

I would like to echo the same result that jctchen is having. I installed the 
new version of finance quote after adding the API key, then set the source to 
Unknown/alphavantage, which is how it shows on Windows.

I receive the same error when I hit the Get Quotes button. It took probably 20 
seconds before it returned this error.

Not sure if there is a place to find a log for it, but if anyone has pointers 
in that regard, I would be happy to post it.

Thanks for your efforts so far, they are much appreciated.

Russell

On Nov 7, 2017, 05:00 -0800, ? ?? , wrote:

Thank you, Erik.

I've updated F-Q to 1.43 successfully.
And,
Got an API Key from AlphaVantage, set it in Windows Environment Variable.
Changed the GnuCash online quote source to Other/alphavantage in Security 
Editor.

But I still got error message (something like "System error when getting 
quote") when I updated the security prices.
All share prices remained unchanged.

BTW, I use multiple currencies. New F-Q will work well with update of currency 
exchange rate?

Thank you, jctchen

-Original Message-
From: Erik Colson [mailto:e...@ecocode.net]
Sent: Tuesday, November 7, 2017 2:46 PM
To: ? ??  writes:


Error reading 'C:\strawberry\cpan\FTPstats.yml': Alert: While trying
to 'parse' YAML file 'C:\strawberry\cpan\FTPstats.yml'
..
Stashing away as 'C:\strawberry\cpan\FTPstats.yml.1510022664' to prevent 
further interruptions. You may want to remove that file later.
Could not rename: Permission denied

I'm by no means a Windows expert, but I would try manually removeing 
FTPstats.yml and restart the installation.

best
--
erik colson
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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
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: F::Q 1.40 uploaded

[brad]

alphavantage works with the few funds that I tried.

Anybody have a quick way to change all quote sources from yahoo to 
alphavantage?



On 11/05/2017 12:44 PM, Erik Colson wrote:

...
Please note that while AlphaVantage does appear to offer quite a bunch
of quotes, it doesn't seem to support funds nor currencies.

best
--
erik colson
___



___
gnucash-user mailing list
gnucash-user@gnucash.org
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: F::Q not working... any ideas for workaround ?

[brad]

It might be possible to use this

https://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html

and then use the python backdoor to import the prices.

There might be something useful here:

https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file

I'm going to wait a few days to see if someone smarter gets this sorted 
out :)



On 11/04/2017 09:18 AM, GB wrote:

Hello

As other people have noticed, the Finance::Quote function is no longer
working for folks (or rather it is something related to Yahoo!Finance API
modifications causing issues )

Is there a workaround for this?  I simply am not able to manually update
each security in the Price Editor separately to get a full picture of my
finances.  Is there another way to workaround this until F::Q function come
back?

Like, for instance, is there a way I can use Excel or Google spreadsheets to
pull the quotes needed ( perhaps not from Yahoo ) and then import that that
as a CSV into GC, or perhaps convert that to a db script to update my
gnucash db?

Sorry in advance, i know this is obtuse question.  I am not familiar with
gc's SW design... I am just an un-informed user who is heavily reliant on
gnucash !

GB



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: finance-quote error

[brad]

Running gnc-fq-check on the cmd line lists the sources that fq can use.  
I've tried a bunch of those sources, but none work.   If anyone finds 
one that works for US funds or stocks plz let us know.


I looked at the fq developers email list & they're aware of the problem, 
one guy said that he'd look at it this weekend.  I wonder if google 
finance might be an option?


On the yahoo forum someone found this, which doesn't directly solve our 
problem:

https://www.vertex42.com/ExcelTemplates/excel-stock-quotes.html



___
gnucash-user mailing list
gnucash-user@gnucash.org
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.

finance-quote error

[brad]

get quotes just quit working.

Gnucash 'Get Quotes' results in:

Unable to retrieve quotes for these items:

followed by what looks to be all of my securities


If I run on the cmd line

gnc-fq-dump -v yahoo VT

No results found for stock VT, but results were returned for
the stock(s) HTTP/1.1 999 Request denied, Yahoo! - 
999 Unable to process request at this time -- error 
999Sorry, Via: http/1.1 
media-router-api24.prod.media.gq1.yahoo.com (ApacheTrafficServer [c s f 
]), Content-Type: text/html, Expires: -1, Cache-Control: max-age=0, 
Server: ATS, Date: Thu, Content-Length: 177, Age: 0, , Connection: 
close.  Printing data for the first stock returned.


Finance::Quote fields Gnucash uses:
    symbol:  (deduced)   <=== required
  date: 11/01/2017   <=== required
  currency: USD  <=== required
  last:  <=\
   nav:  <=== one of these
 price:  <=/
  timezone:  <=== optional

** This stock quote cannot be used by gnucash!!

...

and a bunch more.

I can try any server or stock and get a similar error.

___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Suggestion

[brad]

It only takes a few seconds on my low end linux box which is also about 
6 yrs old.  It takes 25 sec to be completely up and most of that time is 
loading the data file.



On 08/06/2017 04:50 PM, Greg Feneis wrote:

Also FWIW, I just started GnuCash V...16 (not quite the latest) on my 6
year old Win 7 laptop and it only took 25 Seconds to get to where it begins
loading the data file.  While a lot of my programs take between 2 and 5
seconds to load, I do have a few that take quite a bit longer to load than
GnuCash does (programing, simulation, cad environments, etc.).
​
Are other folks having a significantly longer wait than 25 Seconds for
GnuCash to go from start to begin loading of data file?

Kind regards,

Greg Feneis



On Sun, Aug 6, 2017 at 2:50 PM, aegross  wrote:


On zondag 6 augustus 2017 16:46:24 CEST Sam McCoy wrote:

Gentlemen:

I have noticed the time it takes to load all the modules when starting
up Gnu Cash.

FWIW, I have anecdotally noticed that by far the longest module required to
load is Finance::Quote, which strictly speaking, is not GnuCash code.

Regards,
AEG





--
View this message in context: http://gnucash.1415818.n4.
nabble.com/Suggestion-tp4693076p4693081.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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
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.