Re: [GNC] Files

2018-08-27 Thread Liz
On Mon, 27 Aug 2018 09:53:05 -0400
JIM <9031jbk...@att.net> wrote:

> In my home folder in Linux I am getting lots of files generated by 
> Gucash. Examples:
> 
> Jim's checking
> gnucash.1432
> XX.log
> 
> And another file beside it:
> gnucash.1432
> XX.log
> Why are all these files being formed and can I remove them?
> Thanks  Jimk

Your answer is right here

https://wiki.gnucash.org/wiki/Backup#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F

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
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] Unable to open new version

2018-08-27 Thread Ian Lancaster
For years (2011?) I have used GnuCash to keep my personal accounts.  A 
few years ago I could not open the program and had to download the new version.
A few days ago again I could not open the program to update some 
information, and again it would not load.  So I thought a similar thing had 
occurred and downloaded the latest version.  Like a fool I deleted the old app.
When I tried to open the app, Apple would not open the program because 
“the program was not purchased from the Apple App Store”.  I fixed that problem 
but now when I open the program I get a new blank page not my usual accounts.  
Everything has been corrected with the Apple techs and they say to 
contact you to see if there is someway to resurrect the accounts.
Ian Lancaster.
___
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] Files

2018-08-27 Thread JIM
In my home folder in Linux I am getting lots of files generated by 
Gucash. Examples:


Jim's checking
gnucash.1432
XX.log

And another file beside it:
gnucash.1432
XX.log
Why are all these files being formed and can I remove them?
Thanks  Jimk

___
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] Help breaking up a file

2018-08-27 Thread Eric Jensen
I apparently looked at the file size wrong. It is actually only 1.38 MB.
That is compressed. It does take about 23 seconds to open the file though
from a local drive. I am also using gnucash 2.6.19
I agree that it is nice to have all the historical data available. But I
don't like waiting so long for it to open every time. And I don't find
myself looking up things older than 3 year very often

On Mon, Aug 27, 2018, 5:00 AM Colin Law  wrote:

> Wow, that is a lot of personal data, mine goes back to 2001 and is
> only 2MB.  Is that the default file type (XML) and have you specified
> Compress files in Preferences > General?
>
> In my opinion it is best to keep all the data in one file, then you
> have immediate access to all the history.  So far for me the PC power
> has kept pace with the file size so I have not noticed much difference
> over the years.  On Ubuntu mine takes 7 seconds to load the program
> and another 13 to load the user data.  That is fetching the data over
> my local network from a Pi file server so would likely be much quicker
> if the file was on the PC.  I am using 2.6.19
>
> What operating system are you using and what do you mean by 'noticeably
> slow'?
>
> Colin
> On Mon, 27 Aug 2018 at 09:39, Eric Jensen  wrote:
> >
> > I have been using gnucash to track my personal finances since 2011. I
> have just
> > continued using the same file over the years. At this point it is over
> 45MB and
> > it is noticeably slow when opening it. I realize now that I should
> probably use
> > a new file for each year. Is there any way for me to break up my current
> file
> > into yearly chunks? I tried exporting all transactions for a year in CSV
> format
> > and then importing them into a new file that I had created exporting the
> > accounts, but that seemed to have a lot of errors. Does anyone have a
> simple way
> > to accomplish this?
> > 
> > Thanks,
> > Eric
> > ___
> > 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.
>
-- 
Thanks,
Eric
___
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] Associate file with transaction path

2018-08-27 Thread Adrien Monteleone
Anthony,

Did you find a solution?

What OS and is this a local path, external drive, network location?

Also, if Linux is your OS, did you by chance install using the flatpak?

Regards,
Adrien

> On Aug 11, 2018, at 5:24 AM, Anthony Marrian  
> wrote:
> 
> So sorry: version 3.2
> 
> From: Anthony Marrian
> Sent: 11 August 2018 11:23
> To: 'gnucash-user@gnucash.org' 
> Subject: Associate file with transaction path
> 
> The preference I've set under Edit / Preferences / General / Path Head for 
> Transaction Associated Files is ignored. Any tips, please?
> 
> With best wishes - Anthony
> 
> 
> ___
> 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] macOS gnc 3.2

2018-08-27 Thread John Ralls
It’s because Gtk2 and Gtk3 use different paths to the accelerators. Gtk3 can 
read the Gtk2 paths but not vice-versa. Because Gtk2 had the ability to change 
accelerators from the menus (I think that was removed from Gtk3 but I’m not 
sure, and so I haven’t changed the logic) GnuCash writes out a new accelerator 
map when you quit.

The accelerator map file is ~/Library/Application 
Support/Gnucash/accelerator-map. It occurs to me that another workaround 
besides deleting it before launching GnuCash 2.6.x would be to make it 
read-only *after* running GnuCash 2.6 and before running GnuCash 3:

chmod a-w ~/Library/Application Support/Gnucash/accelerator-map

Regards,
John Ralls


> On Aug 27, 2018, at 7:27 PM, David T. via gnucash-user 
>  wrote:
> 
> Adrien,
> 
> It’s been going on a while, and it’s still there. I am using 2.6.19 and 
> 3.1.2. It has something to do with how GTK3 handles accelerator keys (or 
> something like that). It’s mostly an inconvenience, since there is a 
> workaround that involves deleting a file that GTK3 creates (or something like 
> that). Since I never remember where that file is, I have just decided to get 
> used to the New Keyboard Regime.
> 
> David
> 
>> On Aug 27, 2018, at 7:57 PM, Adrien Monteleone 
>>  wrote:
>> 
>> Interesting, is this recent? I was switching between 3.0/2.6.19 and then 
>> 3.1/2.6.21 and I never noticed them change. Since moving to 3.2 I haven’t 
>> tried a 2.6.x version again.
>> 
>> Regards,
>> Adrien
>> 
>>> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user 
>>>  wrote:
>>> 
>>> Just note that if you use 3.x and go back to 2.6.x, the program and your 
>>> data will still work together, but your key bindings will get changed 
>>> (Command-S will be Ctrl-S, etc.). It’s a little disconcerting at first.
>>> 
 On Aug 27, 2018, at 4:00 PM, John Ralls  wrote:
 
 It's a personal decision but there are only a few weeks till 3.3 so you 
 might wait. On the other hand since you have a Mac you have the luxury of 
 being able to have as many GnuCash versions as you like, just make sure 
 that they either have different names or are in different folders. As long 
 as you don't use any of the new 3.2 features that affect the data file you 
 can switch back and forth at will.
 
 Regards,
 John Ralls
 
 
> On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
> 
> After 20 years on a linux desktop, I find myself in an iMac. I have gnc
> 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
> package as a download. But it seems like I saw a lot of folks with issues
> with 3.2. Should I upgrade?
> 
> Keith
> ___
> 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.
> 

Re: [GNC] macOS gnc 3.2

2018-08-27 Thread David T. via gnucash-user
Adrien,

It’s been going on a while, and it’s still there. I am using 2.6.19 and 3.1.2. 
It has something to do with how GTK3 handles accelerator keys (or something 
like that). It’s mostly an inconvenience, since there is a workaround that 
involves deleting a file that GTK3 creates (or something like that). Since I 
never remember where that file is, I have just decided to get used to the New 
Keyboard Regime.

David

> On Aug 27, 2018, at 7:57 PM, Adrien Monteleone 
>  wrote:
> 
> Interesting, is this recent? I was switching between 3.0/2.6.19 and then 
> 3.1/2.6.21 and I never noticed them change. Since moving to 3.2 I haven’t 
> tried a 2.6.x version again.
> 
> Regards,
> Adrien
> 
>> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user 
>>  wrote:
>> 
>> Just note that if you use 3.x and go back to 2.6.x, the program and your 
>> data will still work together, but your key bindings will get changed 
>> (Command-S will be Ctrl-S, etc.). It’s a little disconcerting at first.
>> 
>>> On Aug 27, 2018, at 4:00 PM, John Ralls  wrote:
>>> 
>>> It's a personal decision but there are only a few weeks till 3.3 so you 
>>> might wait. On the other hand since you have a Mac you have the luxury of 
>>> being able to have as many GnuCash versions as you like, just make sure 
>>> that they either have different names or are in different folders. As long 
>>> as you don't use any of the new 3.2 features that affect the data file you 
>>> can switch back and forth at will.
>>> 
>>> Regards,
>>> John Ralls
>>> 
>>> 
 On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
 
 After 20 years on a linux desktop, I find myself in an iMac. I have gnc
 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
 package as a download. But it seems like I saw a lot of folks with issues
 with 3.2. Should I upgrade?
 
 Keith
 ___
 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.

[GNC] Using CSV Importer and Google for Commodity Prices

2018-08-27 Thread David T. via gnucash-user
Hello,

I, like many others, have encountered numerous headaches over the last year due 
to the turmoil around retrieving commodity price quotes. I appreciated being 
able to retrieve prices on an occasional basis and see, broadly speaking, how 
my holdings were performing. I bemoaned the loss of Yahoo! as a F::Q price 
source, and followed the flock to AlphaVantage, and have seen that method fail 
as well.

I had resigned myself to logging on to my various online accounts occasionally 
in order to see in general how the portfolio was doing, but I missed the golden 
era of stock quotes and reporting in GnuCash (2017?). 

I was intrigued by the release of GC3, and its new CSV importer, but wasn’t 
sure I was all that interested in digging into it as a means of obtaining 
prices. But then I saw the recent thread of another user getting their prices 
into GC this way, so I decided to give it a try. What I was shooting for is a 
system that allows me to reasonably quickly generate a list of prices and put 
them into the PriceDB.

I thought I’d share with the list the results. 

First off, I am using Google’s financial functions (which retrieves prices 
based on a ticker symbol) in an online Sheets file. I created a worksheet that 
pulls ticker symbols from a second worksheet, has a column that uses this 
symbol to pull a price, and a third column set to calculate today’s date. 

Next, I opened GnuCash, ran the Advanced Portfolio report, copied the entire 
contents and pasted it directly into my SRC worksheet. Now the PriceDB 
worksheet is fully populated with all the commodites in my GnuCash file, and 
will retrieve current prices for all of them. 

Then I copy this data and paste it into a text file and save it with a csv 
extension. The GnuCash importer then can import these prices; on the 
configuration page, I had to ensure that it used tabs as the delimiter, 
followed the correct date formatting, and had all the other settings correct, 
but once that was done, the importer was able to pull all the prices in quite 
quickly. Conveniently, the importer skips duplicate entries, which is helpful 
since the Advanced Portfolio doesn’t aggregate commodities across accounts. 
Once I had gotten things to work, I was able to save the importer settings to 
smooth future imports. I expect that this will allow me to update my pricedb on 
the sporadic basis that I need, without being unduly burdensome. 

This is the point where I send my gratitude to the GnuCash development team—and 
Geert in particular—for working to rewrite the csv importer. Thank you, Geert!

David

For those who are interested, the Sheets formulas I use are listed below:

For the Ticker Symbol cell, a simple reference to the cell with the ticker 
symbol from the Advanced Portfolio (SRC is the sheet name of the Advanced 
Portfolio source data):

=SRC!B3

For the date cell, returning blank if the referenced cell is empty*:

=if(ISBLANK(A3),"",text(TODAY(),"mm-dd-"))


For the Price cell, returning blank if the referenced cell is empty*:

=if(ISBLANK($A3), "", GOOGLEFINANCE($A3,"Price"))

* By testing if the cell is empty, I can put the same formula into literally 
hundred of rows. Then, if the number of commodities in my holdings goes up (or 
down), the sheet will only show information for commodities that are present.


___
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] macOS gnc 3.2

2018-08-27 Thread Adrien Monteleone
Interesting, is this recent? I was switching between 3.0/2.6.19 and then 
3.1/2.6.21 and I never noticed them change. Since moving to 3.2 I haven’t tried 
a 2.6.x version again.

Regards,
Adrien

> On Aug 27, 2018, at 3:18 PM, David T. via gnucash-user 
>  wrote:
> 
> Just note that if you use 3.x and go back to 2.6.x, the program and your data 
> will still work together, but your key bindings will get changed (Command-S 
> will be Ctrl-S, etc.). It’s a little disconcerting at first.
> 
>> On Aug 27, 2018, at 4:00 PM, John Ralls  wrote:
>> 
>> It's a personal decision but there are only a few weeks till 3.3 so you 
>> might wait. On the other hand since you have a Mac you have the luxury of 
>> being able to have as many GnuCash versions as you like, just make sure that 
>> they either have different names or are in different folders. As long as you 
>> don't use any of the new 3.2 features that affect the data file you can 
>> switch back and forth at will.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>>> On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
>>> 
>>> After 20 years on a linux desktop, I find myself in an iMac. I have gnc
>>> 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
>>> package as a download. But it seems like I saw a lot of folks with issues
>>> with 3.2. Should I upgrade?
>>> 
>>> Keith
>>> ___
>>> 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] Balsheet-eg.scm problem

2018-08-27 Thread Stephen M. Butler
On 08/27/2018 10:43 AM, Geert Janssens wrote:
>
> "Stephen M. Butler"  schreef op 26 augustus 2018 06:15:27 
> CEST:
>> On 08/25/2018 02:15 AM, Geert Janssens wrote:
>> 
>>> Having said all that my original question was what problems you had
>> when
>>> setting up the report as decribed in
>>> https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report
>>> With that I meant what problems did you encounter when storing *all
>> three 
>>> files* in $HOME/.local/share/gnucash and creating a load file in 
>> I hadn't picked up that the files had to be in that folder.  So had
>> left
>> them in the report folder.
>>> $HOME/.config/gnucash called config-user.scm with this content:
>>> (load (gnc-build-userdata-path "balsheet-fmtd.scm"))
>> I had given the path to the report folder.
>>> This works equally well on my system and is recommended.
>>>
>>> So what issues do you get when setting up the reports in your home
>> directory ?
>>
>> It appears to be ignored. 
>>
>> I moved the three files to $HOME/.local/share/gnucash (bold in the
>> below
>> list):
>>
>> $ pwd
>> /home/steve/.local/share/gnucash
>> $ ls -l
>> total 164
>> -rw-r--r-- 1 steve steve 19148 Aug 25 21:03 accelerator-map
>> *-rw-r--r-- 1 steve steve 11472 Aug 25 20:58 balsheet-fmtd.eguile.scm**
>> **-rw-r--r-- 1 steve steve 33386 Aug 25 20:58 balsheet-fmtd.scm**
>> **d*rwxrwxr-x 2 steve steve  4096 Jul  1 19:03 books-rw-r--r-- 1 steve
>> steve  1240 Aug 25 20:58 stylesheet-reports.css
>> -drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 checks
>> -rw-rw-r-- 1 steve steve 0 Aug 25 21:03 expressions-2.0
>> -rw-rw-r-- 1 steve steve  7877 Aug 13 11:00 saved-reports-2.8
>> -rw-rw-r-- 1 steve steve  3121 Aug 13 11:00 saved-reports-2.8-backup
>> *-rw-r--r-- 1 steve steve  1240 Aug 25 20:58 stylesheet-reports.css**
>> **-*rw-rw-r-- 1 steve steve  1614 Aug 25 21:03 stylesheets-2.0
>> drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 translog
>>
>> Created the gnucash folder and config.user file in .config:
>>
>> $ pwd
>> /home/steve/.config/gnucash
>> $ ls -l
>> total 12
>> -rw-r--r-- 1 steve steve 53 Aug 25 20:56 config.user
>> $ cat config.user
>> (load (gnc-build-userdata-path "balsheet-fmtd.scm"))
>>
> In gnucash 3 this file shoulb be named config-user.scm
>
> It looks like you missed the extension.
>
> Regards,
>
> Geert
> Sent from my smartphone. Please excuse my brevity.
>
Yes I did!!  And that works!  I've cleaned up
/usr/local/share/gnucash/scm/gnucash/report to revert it back to the
state when 3.2 was last compiled.  I think I'll remember that this is
there now and will have a place to look it up if I forget the details.

Thank you for hanging in there with me.

--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Process Payment and convenience fees

2018-08-27 Thread David Cousens
Justin,

One other comment. You do not say whether this fee is being paid to the
utility company or a third party, e.g. bank is imposing it for handling the
transaction. In the latter case, it would make more sense to track it
separately from the charges by the utility company. If it is imposed by the
utility company itself, then it is only necessary to track it separately as
an expense if you feel knowing  that information is of benefit to you, i.e
you wish to minimize the fees you pay. 

I would challenge the utility company if the fee goes to them. If it is a
handling charge for using a credit card for payment for example, and you
have other options for payment which don't incur the fee, then  it should be
a separate line item in your bill with separate totals for the different
payment options. There may also be legislative reasons that the fee has to
be separate from the bill, but that should only affect disclosure of the
fee, not inclusion in the total owing but legislators sometimes ,make life
diffcult for businesses.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] help with software

2018-08-27 Thread Allison Cawdrey
Thanks Chris.  I did get it up and running.

Allison

On Mon, Aug 27, 2018, 3:23 PM Chris Good  wrote:

> Hi Allison,
>
> In case you have trouble following the mail thread below,
>
> Sounds like a bug that is already fixed in latest version.
> Problem occurs in MS Windows when GnuCash is closed while it is minimized,
> say by right clicking on Gnucash icon in task bar, and selecting 'Close'.
> Either upgrade to latest version or edit .gcm file to replace both -32000
> values with 0.
> I think you can find this bug in http://bugs.gcucash.org by searching for
> 'minimized' - I think I entered this bug with American spelling even though
> I'm Australian, as I guess there are many more American users than English.
>
> Regards, Chris Good
>
> > Message: 6
> > Date: Sun, 26 Aug 2018 18:47:13 -0400
> > From: D 
> > To: David Carlson , Rich Shepard
> >  
> > Cc: Gnucash Users 
> > Subject: Re: [GNC] help with software
> > Message-ID: <7420bna204062en10q8ujgje.1535323633...@email.android.com>
> > Content-Type: text/plain; charset=utf-8
> >
> > Allison,
> >
> > You mention that you click on "the icon on the bar," so I wonder if you
> are encountering an odd window position, as discussed at
> https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077584.html
> >
> > David
> >
> > On August 26, 2018, at 6:16 PM, David Carlson <
> david.carlson@gmail.com> wrote:
> >
> > Allison,
> >
> > Windows 10 just released an update that did not install well on some
> > computers.
> >
> > Assuming that is not your problem, the next question is when you say
> > clicking on the file does nothing, are you referring to your data file
> > (which you hopefully put in some subfolder under your documents).
> >
> > David C
> >
> >
> >>> On Sun, Aug 26, 2018, 3:46 PM Rich Shepard 
> wrote:
> >>>
> >>> On Sun, 26 Aug 2018, Allison Cawdrey wrote:
> >>>
> >>> I am windows user. Not sure what version. I downloaded it about a month
> >>> ago, so would have used most recent. I don't see anything. I click on
> >> icon
> >>> in my start bar and nothing happens. When I try to open it directly
> from
> >>> file, I get the same response. Nothing happens.
> >>
> >> Allison,
> >>
> >> Okay. I know nothing about Windows; haven't used it since 3.1. This
> >> information is helpful and someone on the mail list will now have a
> better
> >> basis for helping you.
> >>
> >> You have a start menu, I presume. Have you looked at all the menus there
> >> to see where GC might be installed? There is probably a utility that can
> >> tell you where an executable program is installed, but I know only the
> >> linux
> >> tools for doing this.
> >>
> >> Please keep all messages on the mail list so others can both contribute
> >> and learn from your experiences.
> >>
> >> Regards,
> >>
> >> Rich
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] help with software

2018-08-27 Thread Chris Good
Hi Allison,

In case you have trouble following the mail thread below,

Sounds like a bug that is already fixed in latest version.
Problem occurs in MS Windows when GnuCash is closed while it is minimized, say 
by right clicking on Gnucash icon in task bar, and selecting 'Close'.
Either upgrade to latest version or edit .gcm file to replace both -32000 
values with 0.
I think you can find this bug in http://bugs.gcucash.org by searching for 
'minimized' - I think I entered this bug with American spelling even though I'm 
Australian, as I guess there are many more American users than English.

Regards, Chris Good

> Message: 6
> Date: Sun, 26 Aug 2018 18:47:13 -0400
> From: D 
> To: David Carlson , Rich Shepard
>  
> Cc: Gnucash Users 
> Subject: Re: [GNC] help with software
> Message-ID: <7420bna204062en10q8ujgje.1535323633...@email.android.com>
> Content-Type: text/plain; charset=utf-8
> 
> Allison,
> 
> You mention that you click on "the icon on the bar," so I wonder if you are 
> encountering an odd window position, as discussed at 
> https://lists.gnucash.org/pipermail/gnucash-user/2018-June/077584.html
> 
> David
> 
> On August 26, 2018, at 6:16 PM, David Carlson  
> wrote:
> 
> Allison,
> 
> Windows 10 just released an update that did not install well on some
> computers.
> 
> Assuming that is not your problem, the next question is when you say
> clicking on the file does nothing, are you referring to your data file
> (which you hopefully put in some subfolder under your documents).
> 
> David C
> 
> 
>>> On Sun, Aug 26, 2018, 3:46 PM Rich Shepard  wrote:
>>> 
>>> On Sun, 26 Aug 2018, Allison Cawdrey wrote:
>>> 
>>> I am windows user. Not sure what version. I downloaded it about a month
>>> ago, so would have used most recent. I don't see anything. I click on
>> icon
>>> in my start bar and nothing happens. When I try to open it directly from
>>> file, I get the same response. Nothing happens.
>> 
>> Allison,
>> 
>> Okay. I know nothing about Windows; haven't used it since 3.1. This
>> information is helpful and someone on the mail list will now have a better
>> basis for helping you.
>> 
>> You have a start menu, I presume. Have you looked at all the menus there
>> to see where GC might be installed? There is probably a utility that can
>> tell you where an executable program is installed, but I know only the
>> linux
>> tools for doing this.
>> 
>> Please keep all messages on the mail list so others can both contribute
>> and learn from your experiences.
>> 
>> Regards,
>> 
>> Rich
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] macOS gnc 3.2

2018-08-27 Thread David T. via gnucash-user
Just note that if you use 3.x and go back to 2.6.x, the program and your data 
will still work together, but your key bindings will get changed (Command-S 
will be Ctrl-S, etc.). It’s a little disconcerting at first.

> On Aug 27, 2018, at 4:00 PM, John Ralls  wrote:
> 
> It's a personal decision but there are only a few weeks till 3.3 so you might 
> wait. On the other hand since you have a Mac you have the luxury of being 
> able to have as many GnuCash versions as you like, just make sure that they 
> either have different names or are in different folders. As long as you don't 
> use any of the new 3.2 features that affect the data file you can switch back 
> and forth at will.
> 
> Regards,
> John Ralls
> 
> 
>> On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
>> 
>> After 20 years on a linux desktop, I find myself in an iMac. I have gnc
>> 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
>> package as a download. But it seems like I saw a lot of folks with issues
>> with 3.2. Should I upgrade?
>> 
>> Keith
>> ___
>> 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] macOS gnc 3.2

2018-08-27 Thread John Ralls
It's a personal decision but there are only a few weeks till 3.3 so you might 
wait. On the other hand since you have a Mac you have the luxury of being able 
to have as many GnuCash versions as you like, just make sure that they either 
have different names or are in different folders. As long as you don't use any 
of the new 3.2 features that affect the data file you can switch back and forth 
at will.

Regards,
John Ralls


> On Aug 27, 2018, at 12:49 PM, Keith Bellairs  wrote:
> 
> After 20 years on a linux desktop, I find myself in an iMac. I have gnc
> 2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
> package as a download. But it seems like I saw a lot of folks with issues
> with 3.2. Should I upgrade?
> 
> Keith
> ___
> 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] macOS gnc 3.2

2018-08-27 Thread Keith Bellairs
After 20 years on a linux desktop, I find myself in an iMac. I have gnc
2.6.21 running in macOS 10.13.6. I see that I was offered the "stable" 3.2
package as a download. But it seems like I saw a lot of folks with issues
with 3.2. Should I upgrade?

Keith
___
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] Balsheet-eg.scm problem

2018-08-27 Thread Geert Janssens


"Stephen M. Butler"  schreef op 26 augustus 2018 06:15:27 CEST:
>On 08/25/2018 02:15 AM, Geert Janssens wrote:
>
>> Having said all that my original question was what problems you had
>when
>> setting up the report as decribed in
>> https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report
>> With that I meant what problems did you encounter when storing *all
>three 
>> files* in $HOME/.local/share/gnucash and creating a load file in 
>
>I hadn't picked up that the files had to be in that folder.  So had
>left
>them in the report folder.
>> $HOME/.config/gnucash called config-user.scm with this content:
>> (load (gnc-build-userdata-path "balsheet-fmtd.scm"))
>
>I had given the path to the report folder.
>>
>> This works equally well on my system and is recommended.
>>
>> So what issues do you get when setting up the reports in your home
>directory ?
>
>It appears to be ignored. 
>
>I moved the three files to $HOME/.local/share/gnucash (bold in the
>below
>list):
>
>$ pwd
>/home/steve/.local/share/gnucash
>$ ls -l
>total 164
>-rw-r--r-- 1 steve steve 19148 Aug 25 21:03 accelerator-map
>*-rw-r--r-- 1 steve steve 11472 Aug 25 20:58 balsheet-fmtd.eguile.scm**
>**-rw-r--r-- 1 steve steve 33386 Aug 25 20:58 balsheet-fmtd.scm**
>**d*rwxrwxr-x 2 steve steve  4096 Jul  1 19:03 books-rw-r--r-- 1 steve
>steve  1240 Aug 25 20:58 stylesheet-reports.css
>-drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 checks
>-rw-rw-r-- 1 steve steve 0 Aug 25 21:03 expressions-2.0
>-rw-rw-r-- 1 steve steve  7877 Aug 13 11:00 saved-reports-2.8
>-rw-rw-r-- 1 steve steve  3121 Aug 13 11:00 saved-reports-2.8-backup
>*-rw-r--r-- 1 steve steve  1240 Aug 25 20:58 stylesheet-reports.css**
>**-*rw-rw-r-- 1 steve steve  1614 Aug 25 21:03 stylesheets-2.0
>drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 translog
>
>Created the gnucash folder and config.user file in .config:
>
>$ pwd
>/home/steve/.config/gnucash
>$ ls -l
>total 12
>-rw-r--r-- 1 steve steve 53 Aug 25 20:56 config.user
>$ cat config.user
>(load (gnc-build-userdata-path "balsheet-fmtd.scm"))
>

In gnucash 3 this file shoulb be named config-user.scm

It looks like you missed the extension.

Regards,

Geert
Sent from my smartphone. Please excuse my brevity.
___
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] Veihicle mileage cost such in HomeBank?

2018-08-27 Thread Christopher Lam
My solution is to have an Expenses:Mileage account, with an 
unused/obsolete currency, and change its symbol to "km".


I only record business mileage, i.e. description: "travel to client in 
next town", dated 01/05/2018


 * Expenses:Business:Mileage +40km
 * Equity:Mileage -40km

Thus my annual Transaction Report to accountant Expenses:Business:* will 
include aggregate amounts.


For added convenience, the currency can be converted to own currency via 
options, using currency exchange rate = official govt mileage rate, thus 
the $claimable is generated. But I'd keep in original "km" currency for 
clarity.


The disadvantage is it'll mess up net worth.

Thus there's no need to keep a separate spreadsheet.


On 26/08/18 02:32, Riccardo Delpopolo Carciopolo wrote:

Hello Rich,

thank you for the extended explanation!
I think I would end to use a simple spreadsheet as you suggest.

Regards

Il giorno sab 25 ago 2018 alle ore 20:28 Rich Shepard <
rshep...@appl-ecosys.com> ha scritto:


On Sat, 25 Aug 2018, Riccardo Delpopolo Carciopolo wrote:


Thank you for answering, but I could not understand the difference

between

an accounting program and a personal finance management program. I've
successfully used gnucash to track my expenses for some month, but I
really miss a way to track the mileage of my car. Would be nice such
functionality.

Riccardo,

Tracking vehicle milage has nothing to do with finance, bookkeeping, or
accounting. I recommend you use a spreadsheet to track the milage.


Anyway, probably I have to switch to a software that meets my needs.

Your choice. For monetary data GnuCash is outstanding. For other data,
such as vehicle milage, a spreadsheet, database, or plain text file is more
apprpropriate.

Would you consider vehicle milage an asset, expense, liability, or
equity?
If none of the above then it does not belong in financial software any more
than would records of your clothing sizes.

Regards,

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


___
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] Help breaking up a file

2018-08-27 Thread Stephen M. Butler
On 08/27/2018 06:36 AM, David Cousens wrote:
> Eric,
>
> What version of Gnucash are you currently using and on what operating
> system?  
>
> If it is 3.2, you can export the transactions using the default export
> format to a csv file and import them using the same default format. The
> format is selectable in the setup assistants for both export (here just use
> the default settings in the first pane of the assistant and don't change
> them) and on import select the GnuCash Export Setting in the Load and Save 
> Settings combo box at the top.
>
> I did this this afternoon with a couple of month's data while testing out
> some changes I was making to the importer and it worked flawlessly apart
> from one quirk. You have to make sure the default date format when you
> import the exported data matches the date format for your locale or whatever
> date format you have set in the GnuCash preferences for dates for your
> books. 
>
> My understanding is that before v3 GnuCash was unable to easily reimport its
> own export data but from V3.0 on this should work OK so if you are using a
> v2.6 variant this may be the problem and causing the errors on import. I
> would try it with a small block of data initially until you are sure you
> have the settings right.
>
> David Cousens.
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

I have thought that a useful feature would be a balance-forward option
on the year-end close tool.  That option would replace all of the
transactions in an account with a single entry that is the balance at
the end of the year (or specified date if someone has a fiscal year
non-calendar).  Since the year-end close just ran, all the income and
expense accounts would net to zero.  I would have it saved to a new file
rather than replacing the old (or ask for a name for the "old" file and
write the pre-action file to there).

I suppose this could be a stand-alone feature but it seems most useful
in conjunction with the "close" option.

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Process Payment and convenience fees

2018-08-27 Thread Stephen M. Butler
On 08/27/2018 05:39 AM, Justin H Haynes wrote:
> It worked just fine.  From the Accounts Payable register, I edited the 
> payment transaction and added two splits - 1 from the Liabilities:Credit Card 
> account to pay the fee, and 1 to the Expenses:Fees.  In the reference field, 
> I left all the “Payment” splits generated by GNUCash alone, and for the 2 I 
> added, I put “Fee” in that field.  
>
> So the payment amount in billing is correct, but I still have the fee 
> recorded in the transaction.
>
> It is probably a good idea not to change the payment split I would guess.
> $

My wife is an accountant so I popped the question to her.  You have a
couple of options according to her:
1.  Include the fee as part of the utility expense.
2.  Create a separate expense account.

Do the latter if you want to keep track of the total expenses through
the fee.  The former if you don't care.  Note that with the first you
won't balance at the end of the year with any YTD totals the utility
company might produce (for reconciling purposes).

As for the implementation of the payment, I'd just add another split for
the fee amount with the expense side going to whichever expense account
you decide making the total out of CC the $603.49.


>> On Aug 26, 2018, at 12:16 PM, Justin H Haynes  
>> wrote:
>>
>> I have two invoices to pay to a utility company.  Let’s say the amounts of 
>> the invoices are $200 and $300 for a total of $500.  I have paid $600, so 
>> the payment correctly is applied to those two invoices, and $100 to the 
>> Accounts Payable account.  I can see the three transactions in Account 
>> payable.  Actually 3 splits - 1 for each of the amounts of the 2 invoices, 
>> and 1 for the remainder, then on the other side of the transaction the $600 
>> from Liabilities:Credit Card.
>>
>> However, there was a convenience fee charged by the payment processor for 
>> the city utilities.  So, the amount charged to my credit card was $603.49. 
>>
>> Will the best way to deal with this be to edit the split from the 
>> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?
>>
>>
>> Thanks!,
>>
>> Justin
>>
>>

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Process Payment and convenience fees

2018-08-27 Thread Derek Atkins
Justin H Haynes  writes:

> In this case, I suppose I could create a separate bill with only the
> convenience of $3.49 and include that as one of the bills I pay with
> he 603.49 payment, since that fee appears on no written statement I
> have received.

Your other option is to just modify the payment transaction and add the
split for $3.49 to Expenses:Bank Fees (or wherever you want to record
it).

Did you get charged $600 or $603.49?  If the latter, then you can just
manually increase the Asset:Bank split and add the expense split.  If
the former, then you might have more work to do.

Personally, I wouldn't use the business features for a utility bill.

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

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] Veihicle mileage cost such in HomeBank?

2018-08-27 Thread Mike or Penny Novack

On 8/27/2018 10:17 AM, Adrien Monteleone wrote:

I would think it possible to do this in your regular books, with a bit of care.

I would favor using equity accounts only, but I suppose using Income/Expense 
(as you noted are really Equity anyway) is probably easier for many to wrap 
their head around.

The care would come in that you’d need to create new parent accounts of your 
fundamental type choice, and be sure not to include that part of your tree in 
’normal’ reports.

Regards,
Adrien
 Yes, possible, but why? Some relationship? I admit that SOME possible 
mileage categories would have relationship to taxes,  but not others.


I realize that lots of folks here are keeping multiple currencies in a 
single book.


Just strikes me as error prone and a last resort thing to do.

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

Re: [GNC] AlphaVantage Deal

2018-08-27 Thread Richard Ullger
On 27/08/2018 15:23, Ott Kekishev wrote:
> Hello Richard, 
> 
> What version of GC are you using? I have been trying to get yahooJSON
> working in GC, but had no luck so far. I am using version 3.2. F::Q
> works for yahooJSON, but inside GC it does not fetch. Do you know what
> files are connected in GC to this yahooJSON fetching?
> 
> Best regards,
> Ott
> 

Hi Ott,

I'm using v3.2 Build ID: git 3.2-48-gc444729db+ (2018-07-16) built from
git running on Linux. F::Q is v1.47.

The perl scripts for each download source are stored in
/usr/share/perl5/vendor_perl/Finance/Quote/ on my Linux system, which is
where I found YahooJSON.pm.

Other than that, I'm not a gc developer and don't know, nor have taken
the time to find out, how the quotes are actually loaded into gnucash.

Regards,

Richard
___
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] Process Payment and convenience fees

2018-08-27 Thread Adrien Monteleone
Where to record the expense is likely a personal preference. Talk to your CPA 
if you have concerns, especially if you’re itemizing deductions and calculating 
percentages for a home business.

While you can edit the transaction in the A/P (and A/R) register, just to be 
safe, I always use the other register. So in this case, the credit card 
register. (you can always use the ‘jump’ feature to save some time getting 
there if needed)

It is safe to edit the main split, in this case, the credit card amount to 
reflect its actual total. I do this frequently with no issues.

If you edit the individual payments that are posted against A/P then you’ll 
have to edit the payment (right-click menu) and re-apply them.

Regards,
Adrien

> On Aug 27, 2018, at 9:22 AM, Justin H Haynes  wrote:
> 
> 
> 
>> On Aug 27, 2018, at 3:54 AM, elvis  wrote:
>> 
>> On 27/08/18 03:16, Justin H Haynes wrote:
>>> I have two invoices to pay to a utility company.  Let’s say the amounts of 
>>> the invoices are $200 and $300 for a total of $500.  I have paid $600, so 
>>> the payment correctly is applied to those two invoices, and $100 to the 
>>> Accounts Payable account.  I can see the three transactions in Account 
>>> payable.  Actually 3 splits - 1 for each of the amounts of the 2 invoices, 
>>> and 1 for the remainder, then on the other side of the transaction the $600 
>>> from Liabilities:Credit Card.
>>> 
>>> However, there was a convenience fee charged by the payment processor for 
>>> the city utilities.  So, the amount charged to my credit card was $603.49.
>>> 
>>> Will the best way to deal with this be to edit the split from the 
>>> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?
>> 
>> If it a fee that is incurred solely for paying the bill then it is part of 
>> your utility bill.
> 
> In this case, I suppose I could create a separate bill with only the 
> convenience of $3.49 and include that as one of the bills I pay with he 
> 603.49 payment, since that fee appears on no written statement I have 
> received.
> 
> 
> ___
> 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] AlphaVantage Deal

2018-08-27 Thread Ott Kekishev
Hello Richard,

What version of GC are you using? I have been trying to get yahooJSON
working in GC, but had no luck so far. I am using version 3.2. F::Q works
for yahooJSON, but inside GC it does not fetch. Do you know what files are
connected in GC to this yahooJSON fetching?

Best regards,
Ott

On Mon, 27 Aug 2018 at 14:10, Richard Ullger  wrote:

> On 27/08/2018 04:34, Ethan Swint wrote:
> > Hmm... not a lot of response from the user on this topic. I'll bubble it
> to
> > the top this time and let it go from there.
> >
> > The main theme was that the AlphaVantage team is open to a lower-priced
> > premium option that would give 120 quotes/minute for up to 128
> quotes/day,
> > then revert back down to the 5 quotes/minute. It works perfectly for me,
> as
> > I have many securities that I'm tracking, but only use GNC to sync once a
> > day. If you are interested in something along similar lines, feel free to
> > email me separately and let me know how much you think this service is
> > worth to you.
> >
> > I'll have to pull Bruce's implementation and kick the tires on it - that
> > could be the solution that works for me.
> >
> > Regards,
> > Ethan
> >
>
> Personally, I gave up with AlphaVantage some time ago as I found them
> too unreliable.
>
> Apart from the issue of missing stock quotes due to the volume issues
> that have been discussed, I also had the following issues.
>
> - I usually download prices at least 60 minutes after market close each
> day. If I didn't get to download prices on a Friday evening and ended up
> downloading them on a Saturday or Sunday, the prices would download 100
> times too small. I would notice this because my total assets would take
> a dive.
>
> - Frequently, downloaded prices would be way off the actual closing
> price for many stocks.
>
> - Currency rates would fail to load 100% of the time.
>
> I moved to yahoo_json which is working well for me. I had an initial
> issue where prices for securities quoted on the LSE were downloaded 100
> times too big in pence rather than £'s but that was easily fixed by
> amending the YahooJSON.pm perl script to divide the prices by 100.
>
> Also since moving stock price download away from AlphaVantage, currency
> rates are now updating due to the reduced volume.
>
> Regards,
>
> Richard
> ___
> 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] Process Payment and convenience fees

2018-08-27 Thread Justin H Haynes


> On Aug 27, 2018, at 3:54 AM, elvis  wrote:
> 
> On 27/08/18 03:16, Justin H Haynes wrote:
>> I have two invoices to pay to a utility company.  Let’s say the amounts of 
>> the invoices are $200 and $300 for a total of $500.  I have paid $600, so 
>> the payment correctly is applied to those two invoices, and $100 to the 
>> Accounts Payable account.  I can see the three transactions in Account 
>> payable.  Actually 3 splits - 1 for each of the amounts of the 2 invoices, 
>> and 1 for the remainder, then on the other side of the transaction the $600 
>> from Liabilities:Credit Card.
>> 
>> However, there was a convenience fee charged by the payment processor for 
>> the city utilities.  So, the amount charged to my credit card was $603.49.
>> 
>> Will the best way to deal with this be to edit the split from the 
>> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?
> 
> If it a fee that is incurred solely for paying the bill then it is part of 
> your utility bill.

In this case, I suppose I could create a separate bill with only the 
convenience of $3.49 and include that as one of the bills I pay with he 603.49 
payment, since that fee appears on no written statement I have received.


___
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] Veihicle mileage cost such in HomeBank?

2018-08-27 Thread Adrien Monteleone
I would think it possible to do this in your regular books, with a bit of care.

I would favor using equity accounts only, but I suppose using Income/Expense 
(as you noted are really Equity anyway) is probably easier for many to wrap 
their head around.

The care would come in that you’d need to create new parent accounts of your 
fundamental type choice, and be sure not to include that part of your tree in 
’normal’ reports.

Regards,
Adrien

> On Aug 25, 2018, at 5:16 PM, Mike or Penny Novack 
>  wrote:
> 
> On 8/25/2018 2:32 PM, Riccardo Delpopolo Carciopolo wrote:
>> Hello Rich,
>> 
>> thank you for the extended explanation!
>> I think I would end to use a simple spreadsheet as you suggest.
>> 
>> Regards
>> 
> HOWEVER (since this might be useful for others)
> 
> I use a spreadsheet for mileage since we want to be able to have totals by 
> category. Medical and non-profit for taxes and we track civic and political 
> too just to see how much driving we do for those. That few number of columns 
> easy to do/print from a spread sheet.
> 
> In spite of the fact that gnucash is an accounting package, this could 
> provide a simple example of using  "virtual books". Imagine for just a moment 
> that there was a country whose currency was "miles". You could set up a very 
> funny partial set of books. Instead of fundamental types asset, liability, 
> equity, income, and expense suppose you did away with all but income and 
> expense (technically those are of fundamental type equity). Under Income 
> would be just a single account called "total miles". Under Expense would be 
> an account for each mileage category you wanted to track plus one 
> miscellaneous for other trips. The only report you would run would be the 
> income statement. Your transactions are just total miles (income) allocated 
> to the category (expense) << a single trip MIGHT need a split if for more 
> than one purpose >>
> 
> If you only have a few categories, I'd use a spread sheet. But those can be 
> annoying when MANY columns wide. Let's suppose that you did contracting jobs, 
> perhaps a dozen or two every year, or even more. And suppose each of these 
> had mileage associated with it. And suppose you wanted to track all of this 
> << see how much mileage for each job" >>  Now using gnucash in the "funny" 
> way might seem attractive.
> 
> Michael
> 
> 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
> 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] Process Payment and convenience fees

2018-08-27 Thread elvis

On 27/08/18 03:16, Justin H Haynes wrote:

I have two invoices to pay to a utility company.  Let’s say the amounts of the 
invoices are $200 and $300 for a total of $500.  I have paid $600, so the 
payment correctly is applied to those two invoices, and $100 to the Accounts 
Payable account.  I can see the three transactions in Account payable.  
Actually 3 splits - 1 for each of the amounts of the 2 invoices, and 1 for the 
remainder, then on the other side of the transaction the $600 from 
Liabilities:Credit Card.

However, there was a convenience fee charged by the payment processor for the 
city utilities.  So, the amount charged to my credit card was $603.49.

Will the best way to deal with this be to edit the split from the 
Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?


If it a fee that is incurred solely for paying the bill then it is part 
of your utility bill.








Thanks!,

Justin


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


--
Tomorrow is the most important thing in life. Comes into us at midnight very 
clean. It's perfect when it arrives and it puts itself in our hands. It hopes 
we've learned something from yesterday

___
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] Help breaking up a file

2018-08-27 Thread David Cousens
Eric,

What version of Gnucash are you currently using and on what operating
system?  

If it is 3.2, you can export the transactions using the default export
format to a csv file and import them using the same default format. The
format is selectable in the setup assistants for both export (here just use
the default settings in the first pane of the assistant and don't change
them) and on import select the GnuCash Export Setting in the Load and Save 
Settings combo box at the top.

I did this this afternoon with a couple of month's data while testing out
some changes I was making to the importer and it worked flawlessly apart
from one quirk. You have to make sure the default date format when you
import the exported data matches the date format for your locale or whatever
date format you have set in the GnuCash preferences for dates for your
books. 

My understanding is that before v3 GnuCash was unable to easily reimport its
own export data but from V3.0 on this should work OK so if you are using a
v2.6 variant this may be the problem and causing the errors on import. I
would try it with a small block of data initially until you are sure you
have the settings right.

David Cousens.



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: [GNC] Help breaking up a file

2018-08-27 Thread Mike or Penny Novack

On 8/27/2018 4:59 AM, Colin Law wrote:

Wow, that is a lot of personal data, mine goes back to 2001 and is
only 2MB.  Is that the default file type (XML) and have you specified
Compress files in Preferences > General?

In my opinion it is best to keep all the data in one file, then you
have immediate access to all the history.  So far for me the PC power
has kept pace with the file size so I have not noticed much difference
over the years.

  However, maybe good to discuss the original question.

TWO parts to this, splitting OLD data into separate years vs in the 
future having separate years. Or perhaps something in between, every 
several years when the file grows too large, starting over.


Yes, it is important to be able to access historical data. But important 
to consider how often one needs to do that. It doesn't hurt very much if 
rare operations are slow as long as frequent operations are fast.


Thus you could consider (for that third choice) at the end of the 
current year opening a new set off books for the next year. You would do 
this from the end of the year Balance Sheet << export the CoA and then 
plug in the standing account balances from the Balance Sheet >> You then 
open gnucash with this new set of books for continuing on BUT can always 
open the old file if and when you need to look at historical data. 
Personally (for added safety) I would have burned that file (the old 
books) on ROM medium and when wanting to look at historical data, slip 
that disk in and then tell gnucash to open* THAT file (rather than the 
current books). Safe from you accidentally changing something.


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
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] Process Payment and convenience fees

2018-08-27 Thread Justin H Haynes
It worked just fine.  From the Accounts Payable register, I edited the payment 
transaction and added two splits - 1 from the Liabilities:Credit Card account 
to pay the fee, and 1 to the Expenses:Fees.  In the reference field, I left all 
the “Payment” splits generated by GNUCash alone, and for the 2 I added, I put 
“Fee” in that field.  

So the payment amount in billing is correct, but I still have the fee recorded 
in the transaction.

It is probably a good idea not to change the payment split I would guess.

> On Aug 26, 2018, at 12:16 PM, Justin H Haynes  wrote:
> 
> I have two invoices to pay to a utility company.  Let’s say the amounts of 
> the invoices are $200 and $300 for a total of $500.  I have paid $600, so the 
> payment correctly is applied to those two invoices, and $100 to the Accounts 
> Payable account.  I can see the three transactions in Account payable.  
> Actually 3 splits - 1 for each of the amounts of the 2 invoices, and 1 for 
> the remainder, then on the other side of the transaction the $600 from 
> Liabilities:Credit Card.
> 
> However, there was a convenience fee charged by the payment processor for the 
> city utilities.  So, the amount charged to my credit card was $603.49. 
> 
> Will the best way to deal with this be to edit the split from the 
> Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?
> 
> 
> Thanks!,
> 
> Justin
> 
> 
> ___
> 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] AlphaVantage Deal

2018-08-27 Thread Richard Ullger
On 27/08/2018 04:34, Ethan Swint wrote:
> Hmm... not a lot of response from the user on this topic. I'll bubble it to
> the top this time and let it go from there.
> 
> The main theme was that the AlphaVantage team is open to a lower-priced
> premium option that would give 120 quotes/minute for up to 128 quotes/day,
> then revert back down to the 5 quotes/minute. It works perfectly for me, as
> I have many securities that I'm tracking, but only use GNC to sync once a
> day. If you are interested in something along similar lines, feel free to
> email me separately and let me know how much you think this service is
> worth to you.
> 
> I'll have to pull Bruce's implementation and kick the tires on it - that
> could be the solution that works for me.
> 
> Regards,
> Ethan
> 

Personally, I gave up with AlphaVantage some time ago as I found them
too unreliable.

Apart from the issue of missing stock quotes due to the volume issues
that have been discussed, I also had the following issues.

- I usually download prices at least 60 minutes after market close each
day. If I didn't get to download prices on a Friday evening and ended up
downloading them on a Saturday or Sunday, the prices would download 100
times too small. I would notice this because my total assets would take
a dive.

- Frequently, downloaded prices would be way off the actual closing
price for many stocks.

- Currency rates would fail to load 100% of the time.

I moved to yahoo_json which is working well for me. I had an initial
issue where prices for securities quoted on the LSE were downloaded 100
times too big in pence rather than £'s but that was easily fixed by
amending the YahooJSON.pm perl script to divide the prices by 100.

Also since moving stock price download away from AlphaVantage, currency
rates are now updating due to the reduced volume.

Regards,

Richard
___
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] Help breaking up a file

2018-08-27 Thread Colin Law
Wow, that is a lot of personal data, mine goes back to 2001 and is
only 2MB.  Is that the default file type (XML) and have you specified
Compress files in Preferences > General?

In my opinion it is best to keep all the data in one file, then you
have immediate access to all the history.  So far for me the PC power
has kept pace with the file size so I have not noticed much difference
over the years.  On Ubuntu mine takes 7 seconds to load the program
and another 13 to load the user data.  That is fetching the data over
my local network from a Pi file server so would likely be much quicker
if the file was on the PC.  I am using 2.6.19

What operating system are you using and what do you mean by 'noticeably slow'?

Colin
On Mon, 27 Aug 2018 at 09:39, Eric Jensen  wrote:
>
> I have been using gnucash to track my personal finances since 2011. I have 
> just
> continued using the same file over the years. At this point it is over 45MB 
> and
> it is noticeably slow when opening it. I realize now that I should probably 
> use
> a new file for each year. Is there any way for me to break up my current file
> into yearly chunks? I tried exporting all transactions for a year in CSV 
> format
> and then importing them into a new file that I had created exporting the
> accounts, but that seemed to have a lot of errors. Does anyone have a simple 
> way
> to accomplish this?
> 
> Thanks,
> Eric
> ___
> 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] Process Payment and convenience fees

2018-08-27 Thread Justin H Haynes
I have two invoices to pay to a utility company.  Let’s say the amounts of the 
invoices are $200 and $300 for a total of $500.  I have paid $600, so the 
payment correctly is applied to those two invoices, and $100 to the Accounts 
Payable account.  I can see the three transactions in Account payable.  
Actually 3 splits - 1 for each of the amounts of the 2 invoices, and 1 for the 
remainder, then on the other side of the transaction the $600 from 
Liabilities:Credit Card.

However, there was a convenience fee charged by the payment processor for the 
city utilities.  So, the amount charged to my credit card was $603.49. 

Will the best way to deal with this be to edit the split from the 
Liabilities:Credit Card register to add a split for 3.49 to Expenses:Fees?


Thanks!,

Justin


___
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] Help breaking up a file

2018-08-27 Thread Eric Jensen

I have been using gnucash to track my personal finances since 2011. I have just
continued using the same file over the years. At this point it is over 45MB and
it is noticeably slow when opening it. I realize now that I should probably use
a new file for each year. Is there any way for me to break up my current file
into yearly chunks? I tried exporting all transactions for a year in CSV format
and then importing them into a new file that I had created exporting the
accounts, but that seemed to have a lot of errors. Does anyone have a simple way
to accomplish this?

Thanks,
Eric
___
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] Balsheet-eg.scm problem

2018-08-27 Thread Alex Kempshall via gnucash-user

I have a customised balance sheet report based on

/usr/share/gnucash/scm/gnucash/report/balsheet-eg.scm

which has a report-guid  of "2e3751edeb7544e8a20fd19e9d08bb65"

If I look in the file .local/share/gnucash/saved-reports-2.8

I find this


;;;
;; Options for saved report "Pleckbond Balance Sheet (eguile) 
2018071", based on template "2e3751edeb7544e8a20fd19e9d08bb65"

(let ()
  (define (options-gen)
    (let
 (
   (options (gnc:report-template-new-options/report-guid 
"2e3751edeb7544e8a20fd19e9d08bb65" "Balance Sheet (eguile)"))
   (new-embedded-report-ids '()) ;; only used with Multicolumn 
View Reports

 )
; Section: General

other stuff

  (gnc:define-report
    'version 1
    'name "Pleckbond Balance Sheet (eguile) 2018071"
    'report-guid "6e1d6178b2eb431f8e650772779f9319"
    'parent-type "2e3751edeb7544e8a20fd19e9d08bb65"
    'options-generator options-gen
    'menu-path (list gnc:menuname-custom)
    'renderer (gnc:report-template-renderer/report-guid 
"2e3751edeb7544e8a20fd19e9d08bb65" "Balance Sheet (eguile)")

  )





On 26/08/18 05:15, Stephen M. Butler wrote:

On 08/25/2018 02:15 AM, Geert Janssens wrote:


Having said all that my original question was what problems you had when
setting up the report as decribed in
https://wiki.gnucash.org/wiki/Custom_Reports#Loading_Your_Report
With that I meant what problems did you encounter when storing *all three
files* in $HOME/.local/share/gnucash and creating a load file in

I hadn't picked up that the files had to be in that folder.  So had left
them in the report folder.

$HOME/.config/gnucash called config-user.scm with this content:
(load (gnc-build-userdata-path "balsheet-fmtd.scm"))

I had given the path to the report folder.

This works equally well on my system and is recommended.

So what issues do you get when setting up the reports in your home directory ?

It appears to be ignored.

I moved the three files to $HOME/.local/share/gnucash (bold in the below
list):

$ pwd
/home/steve/.local/share/gnucash
$ ls -l
total 164
-rw-r--r-- 1 steve steve 19148 Aug 25 21:03 accelerator-map
*-rw-r--r-- 1 steve steve 11472 Aug 25 20:58 balsheet-fmtd.eguile.scm**
**-rw-r--r-- 1 steve steve 33386 Aug 25 20:58 balsheet-fmtd.scm**
**d*rwxrwxr-x 2 steve steve  4096 Jul  1 19:03 books-rw-r--r-- 1 steve
steve  1240 Aug 25 20:58 stylesheet-reports.css
-drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 checks
-rw-rw-r-- 1 steve steve 0 Aug 25 21:03 expressions-2.0
-rw-rw-r-- 1 steve steve  7877 Aug 13 11:00 saved-reports-2.8
-rw-rw-r-- 1 steve steve  3121 Aug 13 11:00 saved-reports-2.8-backup
*-rw-r--r-- 1 steve steve  1240 Aug 25 20:58 stylesheet-reports.css**
**-*rw-rw-r-- 1 steve steve  1614 Aug 25 21:03 stylesheets-2.0
drwxrwxr-x 2 steve steve  4096 Jun 22 12:38 translog

Created the gnucash folder and config.user file in .config:

$ pwd
/home/steve/.config/gnucash
$ ls -l
total 12
-rw-r--r-- 1 steve steve 53 Aug 25 20:56 config.user
$ cat config.user
(load (gnc-build-userdata-path "balsheet-fmtd.scm"))


The report isn't loaded and there is no error message.
gnucash --logto stdout

(gnucash:5078): Gtk-WARNING **: 21:00:39.924: Theme parsing error:
gtk.css:1278:13: The 'icon-shadow' property has been renamed to
'-gtk-icon-shadow'

(gnucash:5078): Gtk-WARNING **: 21:00:39.924: Theme parsing error:
gtk.css:1281:15: The 'icon-shadow' property has been renamed to
'-gtk-icon-shadow'
;;; note: source file
/usr/local/share/gnucash/scm/gnucash/report/business-reports.scm
;;;   newer than compiled
/usr/local/lib/gnucash/scm/ccache/2.0/gnucash/report/business-reports.go
;;; found fresh local cache at
/home/steve/.cache/guile/ccache/2.0-LE-8-2.0/usr/local/share/gnucash/scm/gnucash/report/business-reports.scm.go



Sorry to be so dense but I'm obviously missing something.
--Steve



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