Re: [GNC] restoration from backup not working

[David T. via gnucash-user]

From within gnucash, use File->Open. Double clicking doesn't work on MacOS.

 
 
  On Thu, Jan 3, 2019 at 12:31, Eliot Rosenbloom wrote:   Hey - I 
want to get rid of the entries I did today (1/2/19) and revert 
back to my last backup (12/20/18).  When I double click on

gnu-P-4.gnucash.20181220083434.gnucash , however,

what opens (judging from the name at the top of the main window) is

gnu-P-4.gnucash.20161010002912.gnucash ,

which is the OLDEST file in the folder.

I tried this several times.  What am I doing wrong?

I'm using macOS 10.14.2 , and I just upgraded from gnucash 2.6.19 to 
3.4.1   (I forgot to quit the dbus-daemon , if that is still 
recommended.  Just now I looked in ActivityMonitor and do not see it.)

Thanks!!

Eliot
___
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] Tutorial for moving stock between accounts?

[David T. via gnucash-user]

Well, now that you have it mostly right, maybe go in to the second account 
register and see whether you can change the second split price to zero from 
there, using the same tabbing technique. 
 
 
  On Thu, Jan 3, 2019 at 12:23, Jon Leech wrote:   On Wed, 
Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to 
> your destination account and tab to shares and type 13.
>
> Does that work?

    Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

    I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

    Jon
___
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.  
On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to 
> your destination account and tab to shares and type 13.
>
> Does that work?

Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

Jon
___
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] GnuCash won't open

[Ruth L. Mazur]

I have downloaded GnuCash 3.4-Intel to my Mac OS10.11.6  a dozen times but I 
can not get it to open. For Privacy I’m set to sites that I visit.  Once I set 
it to Anyone and that didn’t work either. 

This has been very frustrating.  I’m disillusioned with Quicken and want 
something else, and free is good! What do I need to know to get this app?

Thanks for any help,

Ruth Mazur
Grass Valley, CA 



___
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] Currencies not being converted

[salmichaels]

I have just returned from overseas with laptop and now gnucash does not
convert currencies. I have some accounts in a foreign currency, others in
USD. In making reports or having a Total (USD) column, GC doesn't convert
the accts in foreign currency to USD, but just lists the amounts as if they
are US dollars. If I change the report currency to the foreign currency, it
handles it fine; it converts the USD accounts to the foreign currency, no
issues. 

The program is set to default to local (US) currency, and was even when I
was overseas as far as I know. Now it is also set to local US. My local
settings on my computer are also set for the US. So yeah, I cannot for the
life of me figure this out. 

thanks in advance! 

-sal



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

[GNC] Trying to install GNUcash 3.4.1 on IMac

[Ronnie H]

I’m running GNUcash 3.3.+ (2018-09-29) on the following:

 IMac 2.7 GHz Intel Core i5
8 GB Ram
MacOS Mojave Version 10.14.2

It has started crashing occasionally. Sometimes when I am starting it, and 
sometimes when I am using it.

I have down loaded GNUcash 3.4.1 from sourceforge.net  
3 times but when I click open, it just stops and quits running.

See attached screen shot

___
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] Stock Quotes

[Dave Cooper via gnucash-user]

Hi gnucash

I have returned to gnu-cash having not used it for several years so 
please bear with me.
I have reloaded the system and set it up to get some UK stock prices 
(LSE) using Alphavantage
Unfortunately I get poor results - only 25% - 50% prices are returned - 
I assume this is caused by time outs
As a temporary fix I now use yahoo - json  which gets results every time 
so far, but I have to manually adjust these prices because the return is 
in pence not pounds

Is there a parameter or easy way to fix this?

I note that yahoo are having problems due to their historical data for 
UK is in pounds - not that I am going there.


Cheers
Dave
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Tutorial for moving stock between accounts?

[Jon Leech]

On Wed, Jan 02, 2019 at 05:38:13PM +0530, D wrote:
> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it to 
> your destination account and tab to shares and type 13.
>
> Does that work?

Thanks! This works, for the most part. The share counts in source
and destination accounts are altered correctly, which is enough to let
me do what I need. It does set a Price of 1 for the second line and a
Tot Buy of 13.00, and then creates a new Imbalance line in the split
with a Tot Sell of 13.00.

I cannot change the Price to 0 on the second line, unlike the first.
Trying it results in it immediately being restored to 1, so the
Imbalance seems unavoidable. I can set the Price to a non-zero number
and make gnucash recalculate the Tot Buy / Imbalance fields, but that
seems pointless, since there is no actual Price or cash associated with
this transaction.

Jon
___
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] *.deb package for GnuCash 3.4 Released

[nvsoar]

On 01/02/19 13:44, Colin Law wrote:

I have installed 3.4 onto another Ubuntu 18.10 and can confirm Tim
Kallmer's findings as to the additional packages that need to be
installed.  I have noticed one other slight complication, that Ubuntu
seems to think that the version from the deb (3.4-0-1) is earlier than
the version from the repo (1:3.3-2), possibly due to the 1: on the
front.  The result is that updating the system wants to update gnucash
back to 3.3.  The solution to that is to mark it as held so that it
won't be upgraded.

So to install on Ubuntu 18.10 from the deb first download it from
Stephen's Drive
https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY to,
for example Downloads, then run

sudo apt remove gnucash
sudo apt autoremove
sudo dpkg -i Downloads/gnucash_3.4-0-1_amd64.deb
sudo apt install  libboost-filesystem1.65.1  libboost-date-time1.65.1
   libboost-locale1.65.1  libboost-regex1.65.1
sudo apt-mark hold gnucash

and you should be good to go.  Thanks again to Stephen Butler for
providing this.

Colin


Do you think that 'sudo apt -f install' would work to get the libboost 
packages?

nvsoar


___
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] GNU generated report in HTML to XL

[Maf. King]

On Wednesday, 2 January 2019 15:24:57 GMT Finbar Mahon wrote:
> Hello,
> 
> I exported a GNUCash report to HTMl, but I don't seem to be able to
> import it to LibreOffice Calc, the LibreOffice xl equivalent.
> 
> Does anybody know if I must use 'real' MS XL to receive the HTML file?
> In LibreOffice you can save calc files in MS format. Are there any
> special tricks for importing?
> 
> I am using 3.3 on Windows 10.
> 
> Thanks, Barry

Hi Barry,

I tend to import the html file into a blank spreadsheet - ISTR that the Calc 
menu structure moved this option from something like Insert->File to  
somethilng like Sheet -> Insert Sheet from File last time I prepared reports 
for the accountant.

HTH,
Maf.






___
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] *.deb package for GnuCash 3.4 Released

[Colin Law]

I have installed 3.4 onto another Ubuntu 18.10 and can confirm Tim
Kallmer's findings as to the additional packages that need to be
installed.  I have noticed one other slight complication, that Ubuntu
seems to think that the version from the deb (3.4-0-1) is earlier than
the version from the repo (1:3.3-2), possibly due to the 1: on the
front.  The result is that updating the system wants to update gnucash
back to 3.3.  The solution to that is to mark it as held so that it
won't be upgraded.

So to install on Ubuntu 18.10 from the deb first download it from
Stephen's Drive
https://drive.google.com/open?id=172BMIvLgD7twcGEWkR5GcddoZ_A4QWfY to,
for example Downloads, then run

sudo apt remove gnucash
sudo apt autoremove
sudo dpkg -i Downloads/gnucash_3.4-0-1_amd64.deb
sudo apt install  libboost-filesystem1.65.1  libboost-date-time1.65.1
  libboost-locale1.65.1  libboost-regex1.65.1
sudo apt-mark hold gnucash

and you should be good to go.  Thanks again to Stephen Butler for
providing this.

Colin
___
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] GNU generated report in HTML to XL

[Adrien Monteleone]

Yes, I too have had mixed results *opening* the saved file, but copy and paste 
works every time. I’m pretty sure the wiki reference to this specifies copy and 
paste as the preferred method, but I’ll double check.

Regards,
Adrien

> On Jan 2, 2019, at 10:51 AM, David Carlson  
> wrote:
> 
> Finbar,
> 
> You may need to first open a new blank spreadsheet then cut and paste from
> the html document into the spreadsheet rather than trying to directly open
> HTML with Calc.
> 
> My experience with LibreOffice Calc is that it will import several
> different kinds of files.  I use it regularly to convert transaction detail
> exports from a certain department store website to a form from which I can
> manually extract data to enter into GnuCash, although I have not figured
> out how to restructure it to use the CSV importer for that case.
> 
> David C
> 
> On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon  wrote:
> 
>> Hello,
>> 
>> I exported a GNUCash report to HTMl, but I don't seem to be able to
>> import it to LibreOffice Calc, the LibreOffice xl equivalent.
>> 
>> Does anybody know if I must use 'real' MS XL to receive the HTML file?
>> In LibreOffice you can save calc files in MS format. Are there any
>> special tricks for importing?
>> 
>> I am using 3.3 on Windows 10.
>> 
>> Thanks, Barry
>> 
>> ___
>> 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] Location of GnuCash data files

[Geert Janssens]

On Monday, December 31, 2018 8:40:40 PM CET Adrien Monteleone wrote:
> It should probably be filed in Bugzilla, but I think it might already be
> there.
> 

No for enhancement requests uservoice is fine. We haven't stated this 
explicitly I think, but I find it easier if bugzilla is really for tracking 
bugs.

> I seem to recall asking this question myself some months ago after a thread
> about user confusion over these files. I unfortunately can’t find the
> thread and don’t remember the exact final point, but I do remember one of
> the devs stated a good reason for why the present situation is what it is,
> darned if I can remember it though. Maybe one of them will chime in.
> 

I don't remember exactly either. I believe at the last discussion we were 
debating removing the logging functionality for sql backends and I almost did.

There are several issues with the transaction log and it only provides a false 
sense of security. For example it only logs transaction changes, not account 
changes or any other modification made to the data. So as a recovery tool it's 
only marginally useful. Worse, it will restore bad transactions if business 
features are used. And probably there are several other issues with it.

Given these issues I think I should have proceeded with removing the logging 
for the sql backend after all. As a whole I think this logging is in dire need 
for a redesign. Given the future ideas the dev team has with the xml backend 
(on load convert it internally into an sqlite db as long as it's open), it's 
probably best to hold of on that one though. I think a lower level 
implementation (on the sql transaction level) has a better future.

But that's only tangential to the proposal of moving the backup and log files 
someplace else.

That is also not a new idea. I have also suggested this in the past.

> >> I understand the usefulness of the log files, but why aren't they written
> >> to the temp folder? Or better yet, why aren't they written to a
> >> user-specified location, with the temp folder as default?> 
> > This sounds like an idea that needs to be filed as an enhancement
> > request.  I'd suggest an alternative might be to create two sub-folders
> > in the folder where the data file is stored:
> > 
> > 1. ./GnuCash-Backups
> > 2. ./GnuCash-Logs
> > 

Using subdirectories is one strategy, though I would not suggest the split 
above.
 I'd go for one subdirectory per data file (people sometimes forget you can 
have more than one book). If your book is called MyBook.gnucash, the related 
subdirectory could for example be called MyBook.history. And then we store all 
related files in there. We could also think a bit broader and extend the 
usefulness of this directory to also hold other associated files. In that case 
a name like MyBook.extra could make more sense. In addition as logging also 
happens for the sql a

I also see another approach: gnucash already keeps metadata in GNC_DATA_HOME. 
We could choose to store logfiles and backups in there as well. They are used 
relatively infrequently so there's no need to have them clutter the directory 
of the main data file.

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.

Re: [GNC] Export Company file to Accountant

[Stephen M. Butler]

On 1/2/19 12:28 AM, Charles Peter Avery wrote:
> Hello,
>  
> I am currently using QuickBooks desktop and I want to convert to GnuCash
> however at the end of each financial year I need to provide my accountant
> with a company file that can be imported into Sage HandiSoft.  Is this
> possible with GnuCash?
>  
> Regards
> Charles Avery


A Google search indicates that Sage Handisoft can import from a CSV. 
GnC can export to a CSV.  Just be sure the column order is what Sage
expects.

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



pEpkey.asc
Description: application/pgp-keys
___
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] *.deb package for GnuCash 3.4 Released

[Tim Kallmer]

these needed to be installed:
libboost-filesystem1.65.1
libboost-date-time1.65.1
libboost-locale1.65.1
libboost-regex1.65.1

On Wed, Jan 2, 2019 at 1:27 AM Colin Law  wrote:

>
>
> On Tue, 1 Jan 2019, 22:44 Tim Kallmer 
>> i did that and kept finding 3 or 4 more libboost installations missing. i
>> figured out the patterns, installed them all, and finally it does open for
>> me. thanks!
>>
>
> For others who may be in the same boat please tell us what you had to
> install
>
> Colin
>
>
>> On Tue, Jan 1, 2019 at 4:19 PM Colin Law  wrote:
>>
>>> On Tue, 1 Jan 2019 at 22:00, Tim Kallmer  wrote:
>>> >
>>> > i installed the .deb and ran, sudo apt install libboost-regex1.65.1,
>>> as you mentioned. i get the following:
>>> >
>>> > gnucash:
>>> >   Installed: 3.4-0-1
>>> >   Candidate: 1:3.3-2
>>> >   Version table:
>>> >  1:3.3-2 500
>>> > 500 http://ubuntu.mirrors.tds.net/pub/ubuntu cosmic/universe
>>> amd64 Packages
>>> >  *** 3.4-0-1 100
>>> > 100 /var/lib/dpkg/status
>>> >
>>> > /usr/local/bin/gnucash: error while loading shared libraries:
>>> libboost_locale.so.1.65.1: cannot open shared object file: No such file or
>>> directory
>>>
>>> Looks like it also needs
>>> sudo apt install libboost-locale1.65.1
>>> I imagine I already have that installed but can't check at this moment.
>>>
>>> Colin
>>>
>>> >
>>> > the program never opens, unless i remove and reinstall 3.3.
>>> >
>>> > On Tue, Jan 1, 2019 at 3:36 PM Colin Law  wrote:
>>> >>
>>> >> On Tue, 1 Jan 2019 at 19:06, Tim Kallmer  wrote:
>>> >> >
>>> >> > No luck, still not working for me.
>>> >>
>>> >> What do the following commands show?
>>> >> apt policy gnucash
>>> >> which gnucash
>>> >> and finally what do you see if you run gnucash in a terminal window?
>>> >> In case you don't know you can copy from the terminal window using
>>> Ctrl-Shift-C
>>> >>
>>> >> Colin
>>> >>
>>> >> >
>>> >> > On Tue, Jan 1, 2019 at 4:12 AM Colin Law  wrote:
>>> >> >>
>>> >> >> On Mon, 31 Dec 2018 at 17:58, Tim Kallmer 
>>> wrote:
>>> >> >> >
>>> >> >> > >
>>> >> >> > > the .deb package did not work for me on Ubuntu 18.10
>>> >> >>
>>> >> >> As I posted earlier, for ubuntu 18.10 do
>>> >> >> sudo apt install libboost-regex1.65.1
>>> >> >>
>>> >> >> Colin
>>>
>>
___
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] GNU generated report in HTML to XL

[David Carlson]

Finbar,

You may need to first open a new blank spreadsheet then cut and paste from
the html document into the spreadsheet rather than trying to directly open
HTML with Calc.

My experience with LibreOffice Calc is that it will import several
different kinds of files.  I use it regularly to convert transaction detail
exports from a certain department store website to a form from which I can
manually extract data to enter into GnuCash, although I have not figured
out how to restructure it to use the CSV importer for that case.

David C

On Wed, Jan 2, 2019 at 9:27 AM Finbar Mahon  wrote:

> Hello,
>
> I exported a GNUCash report to HTMl, but I don't seem to be able to
> import it to LibreOffice Calc, the LibreOffice xl equivalent.
>
> Does anybody know if I must use 'real' MS XL to receive the HTML file?
> In LibreOffice you can save calc files in MS format. Are there any
> special tricks for importing?
>
> I am using 3.3 on Windows 10.
>
> Thanks, Barry
>
> ___
> 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] GNU generated report in HTML to XL

[Finbar Mahon]

Hello,

I exported a GNUCash report to HTMl, but I don't seem to be able to 
import it to LibreOffice Calc, the LibreOffice xl equivalent.


Does anybody know if I must use 'real' MS XL to receive the HTML file? 
In LibreOffice you can save calc files in MS format. Are there any 
special tricks for importing?


I am using 3.3 on Windows 10.

Thanks, Barry

___
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] Tutorial for moving stock between accounts?

[David Carlson]

Jon,

I believe that, as discussed earlier by Christopher Lam and David T,
GnuCash may not prevent you from creating a transaction containing only two
lines, one removing shares from one brokerage account and one another
adding shares to a different brokerage account, and it may even be possible
for the shares to be different securities, superficially simulating a
buyout or other unusual non-cash security transaction.  However, if one
does this without correctly accounting for the values of the shares and
security accounts involved, then one is setting himself up for
discrepancies in future reports involving the values of those security
accounts.  This is most easily seen by the example of looking at the
security accounts in the chart of accounts view.  Every security account
that is no longer used because all of the shares have been sold should not
only show 0 shares, but also show 0 current value in your currency.
Chapter 9 in the tutorial goes into great detail on how to correctly
account for the correct capital gains and losses when selling securities
and using the Trial Balance report to verify that the correct cost basis
amount is converted from unrealized into realized gain or loss.  The same
principles should be used to account for values even when no currency is
involved.

There is a little known assistant feature in GnuCash to enter stock splits
which is also documented in the tutorial chapter 9.  That assistant is
under Actions in the menu and it provides a way to assign correct values to
before and after shares when a stock is split.  The result of using that
assistant would create a model for other types of virtual transactions not
involving cash.

If you do not track the value of your securities or your net worth in
GnuCash, then it is much easier to skip all the effort to correctly account
for realized gains and losses and just forward your brokers' tax report to
your accountant.

That is my 2 cents...

David Carlson

On Wed, Jan 2, 2019 at 6:12 AM D via gnucash-user 
wrote:

> Jon,
>
> I can't test this right now, since I'm not at my machine...
>
> Try this:
>
> Open your source account.
>
> Move to the entry point in the register.
>
> Click the 'Split' button. Enter your description.
>
> Tab to the Shares field in the first split and type -13.
>
> Tab to the price field and type 0.
>
> Now, use **tab** to move to the Transfer field on the second line, set it
> to your destination account and tab to shares and type 13.
>
> Does that work?
>
> David T.
>
>
>
> On January 2, 2019, at 2:55 PM, Jon Leech  wrote:
>
> >On Tue, Jan 01, 2019 at 10:35:03AM +, David T. wrote: > What part of
> creating a transaction that moves shares from the old account to the new
> account does not work? It would seem to me that: > Old account decrease 100
> shares > New account add shares > Would work just fine. Could you give a
> bit more detail? The way I know to 'decrease' or 'increase' shares is by
> Selling or Buying them in a split transaction, which also involves a cash
> account from which fees or proceeds are handled. But here the shares are
> moving between accounts, and no cash is involved. Maybe a framework for
> this is to say that I want to adjust the share count in the two security
> accounts in much the same way I adjust the cash value in two cash accounts
> - by moving the underlying commodity (shares or cash, respectively) between
> them. It might be more clear what I'm trying to accomplish, and why I'm
> stymied, if I show a couple of screenshots of a failed attempt. Attached
> src.jpg is of an account containing 33 shares of CEG (let's leave aside
> that the security no longer exists - this is only for demonstration
> purposes). dst.jpg shows another account denominated in the same security,
> and I'd like to transfer 13 of those 33 shares to it. Just to get the share
> counts correct, it seemed obvious to enter a transaction where I Transfer
> from the src to dst account, and enter a negative number of shares. This
> *does* adjust the share count correctly on the src side, but on the dst
> side (dst.gif) instead of showing a number of *shares* transferred, it
> shows a 'Buy' of 13.00 and zero resulting shares. I have also attempted to
> do this with a split, but (a) AFAICT there's no 'Action' in a split that
> relates to transferring shares between accounts - there are 'Sell', 'Buy',
> 'Fee', things related to dividends and capital gains, etc. - and (b) it
> insists on forcing a monetary Price on the transaction which makes the
> split imbalanced, even though no money whatsoever is involved. So this is
> why I'm hoping to find an actual detailed example of how to accomplish this
> transfer in the gnucash framework. I appreciate the responses, but none of
> it quite seems to speak to the thing I'm trying to accomplish - or I don't
> yet understand what people are saying I should do. Jon
>
> ___
> gnucash-user mailing list
> 

Re: [GNC] Tutorial for moving stock between accounts?

[D via gnucash-user]

Jon,

I can't test this right now, since I'm not at my machine...

Try this:

Open your source account. 

Move to the entry point in the register. 

Click the 'Split' button. Enter your description. 

Tab to the Shares field in the first split and type -13.

Tab to the price field and type 0.

Now, use **tab** to move to the Transfer field on the second line, set it to 
your destination account and tab to shares and type 13.

Does that work?

David T.



On January 2, 2019, at 2:55 PM, Jon Leech  wrote:

>On Tue, Jan 01, 2019 at 10:35:03AM +, David T. wrote: > What part of 
>creating a transaction that moves shares from the old account to the new 
>account does not work? It would seem to me that: > Old account decrease 100 
>shares > New account add shares > Would work just fine. Could you give a bit 
>more detail? The way I know to 'decrease' or 'increase' shares is by Selling 
>or Buying them in a split transaction, which also involves a cash account from 
>which fees or proceeds are handled. But here the shares are moving between 
>accounts, and no cash is involved. Maybe a framework for this is to say that I 
>want to adjust the share count in the two security accounts in much the same 
>way I adjust the cash value in two cash accounts - by moving the underlying 
>commodity (shares or cash, respectively) between them. It might be more clear 
>what I'm trying to accomplish, and why I'm stymied, if I show a couple of 
>screenshots of a failed attempt. Attached src.jpg is of an account containing 
>33 shares of CEG (let's leave aside that the security no longer exists - this 
>is only for demonstration purposes). dst.jpg shows another account denominated 
>in the same security, and I'd like to transfer 13 of those 33 shares to it. 
>Just to get the share counts correct, it seemed obvious to enter a transaction 
>where I Transfer from the src to dst account, and enter a negative number of 
>shares. This *does* adjust the share count correctly on the src side, but on 
>the dst side (dst.gif) instead of showing a number of *shares* transferred, it 
>shows a 'Buy' of 13.00 and zero resulting shares. I have also attempted to do 
>this with a split, but (a) AFAICT there's no 'Action' in a split that relates 
>to transferring shares between accounts - there are 'Sell', 'Buy', 'Fee', 
>things related to dividends and capital gains, etc. - and (b) it insists on 
>forcing a monetary Price on the transaction which makes the split imbalanced, 
>even though no money whatsoever is involved. So this is why I'm hoping to find 
>an actual detailed example of how to accomplish this transfer in the gnucash 
>framework. I appreciate the responses, but none of it quite seems to speak to 
>the thing I'm trying to accomplish - or I don't yet understand what people are 
>saying I should do. Jon 

___
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] Tutorial for moving stock between accounts?

[Christopher Lam]

There may not be any internal technical restrictions preventing you from
directly decreasing the share count of a share account, and increasing in
another.

However this is pretty much uncharted territory when it comes to reports
and reporting assumptions.

Typically I'd expect someone who tries to move shares between brokers to be
liquidating their brokerage account, record any capital gains or losses,
and immediately buy shares in the other account.

Any inaccuracies in any reports will be dealt with under caveat emptor
rules :)

On Wed., 2 Jan. 2019, 17:25 Jon Leech  On Tue, Jan 01, 2019 at 10:35:03AM +, David T. wrote:
> > What part of creating a transaction that moves shares from the old
> account to the new account does not work? It would seem to me that:
> > Old account decrease 100 shares
> > New account add shares
> > Would work just fine.
>
> Could you give a bit more detail? The way I know to 'decrease' or
> 'increase' shares is by Selling or Buying them in a split transaction,
> which also involves a cash account from which fees or proceeds are
> handled. But here the shares are moving between accounts, and no cash is
> involved.
>
> Maybe a framework for this is to say that I want to adjust the share
> count in the two security accounts in much the same way I adjust the
> cash value in two cash accounts - by moving the underlying commodity
> (shares or cash, respectively) between them.
>
> It might be more clear what I'm trying to accomplish, and why I'm
> stymied, if I show a couple of screenshots of a failed attempt. Attached
> src.jpg is of an account containing 33 shares of CEG (let's leave aside
> that the security no longer exists - this is only for demonstration
> purposes). dst.jpg shows another account denominated in the same
> security, and I'd like to transfer 13 of those 33 shares to it.
>
> Just to get the share counts correct, it seemed obvious to enter a
> transaction where I Transfer from the src to dst account, and enter a
> negative number of shares. This *does* adjust the share count correctly
> on the src side, but on the dst side (dst.gif) instead of showing a
> number of *shares* transferred, it shows a 'Buy' of 13.00 and zero
> resulting shares.
>
> I have also attempted to do this with a split, but (a) AFAICT
> there's no 'Action' in a split that relates to transferring shares
> between accounts - there are 'Sell', 'Buy', 'Fee', things related to
> dividends and capital gains, etc. - and (b) it insists on forcing a
> monetary Price on the transaction which makes the split imbalanced, even
> though no money whatsoever is involved.
>
> So this is why I'm hoping to find an actual detailed example of how
> to accomplish this transfer in the gnucash framework. I appreciate the
> responses, but none of it quite seems to speak to the thing I'm trying
> to accomplish - or I don't yet understand what people are saying I
> should do.
>
> Jon
> ___
> 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] Tutorial for moving stock between accounts?

[Jon Leech]

On Tue, Jan 01, 2019 at 10:35:03AM +, David T. wrote:
> What part of creating a transaction that moves shares from the old account to 
> the new account does not work? It would seem to me that:
> Old account decrease 100 shares
> New account add shares
> Would work just fine.

Could you give a bit more detail? The way I know to 'decrease' or
'increase' shares is by Selling or Buying them in a split transaction,
which also involves a cash account from which fees or proceeds are
handled. But here the shares are moving between accounts, and no cash is
involved.

Maybe a framework for this is to say that I want to adjust the share
count in the two security accounts in much the same way I adjust the
cash value in two cash accounts - by moving the underlying commodity
(shares or cash, respectively) between them.

It might be more clear what I'm trying to accomplish, and why I'm
stymied, if I show a couple of screenshots of a failed attempt. Attached
src.jpg is of an account containing 33 shares of CEG (let's leave aside
that the security no longer exists - this is only for demonstration
purposes). dst.jpg shows another account denominated in the same
security, and I'd like to transfer 13 of those 33 shares to it.

Just to get the share counts correct, it seemed obvious to enter a
transaction where I Transfer from the src to dst account, and enter a
negative number of shares. This *does* adjust the share count correctly
on the src side, but on the dst side (dst.gif) instead of showing a
number of *shares* transferred, it shows a 'Buy' of 13.00 and zero
resulting shares.

I have also attempted to do this with a split, but (a) AFAICT
there's no 'Action' in a split that relates to transferring shares
between accounts - there are 'Sell', 'Buy', 'Fee', things related to
dividends and capital gains, etc. - and (b) it insists on forcing a
monetary Price on the transaction which makes the split imbalanced, even
though no money whatsoever is involved.

So this is why I'm hoping to find an actual detailed example of how
to accomplish this transfer in the gnucash framework. I appreciate the
responses, but none of it quite seems to speak to the thing I'm trying
to accomplish - or I don't yet understand what people are saying I
should do.

Jon
___
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] Export Company file to Accountant

[Charles Peter Avery]

Hello,
 
I am currently using QuickBooks desktop and I want to convert to GnuCash
however at the end of each financial year I need to provide my accountant
with a company file that can be imported into Sage HandiSoft.  Is this
possible with GnuCash?
 
Regards
Charles Avery
___
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] USD Currency Missing in 3.4

[Chen Thomas]

Hi,

I just downloaded V3.4 and updated it from V3.3 in Windows 10.

Since Finance::Quote can not work with AlphaVantage for a while, I usually 
update currency and stock price manually in Price Database.
But, in V3.4 I can not find USD currency list to update. I can find other 
currency and replace it with USD and get USD currency updated, but it still can 
not be shown in USD currency list.
Something weird, I can not find it but the USD currency I just updated is 
working.

Anyone has the same issue like mine?

Thank you.

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