Re: [GNC] Fwd: The two modules

[Stephen M. Butler]

Christopher

Going to the latest version is stymied until I hear back from one of the
developers on what went wrong with make.

I'm new to using GnuCash so have not delved into the Foreign currency or
stocks.

So, let's build a COA together and see what happens (on paper):

100 - Asset
110 -   " : Bank1
112 -   " :    "  :Checking
114 -   " :    "  : Savings
116 -   " :    "  : Bonds
120 -   " : Bank2
130 -   " : ForeignBank   (GBP currency)
140 -   " : Broker
142 -   " :    "  : Cash
144 -   " :    "  : Stock
150 -   " : House

200 - Liability
220 -   " : Bank2
222 -   " :   "  : Loan
224 -   " :   "  : Creditcard

300 - Equity

400 - Income

500 - Expense

We may fill in the above further as we work along.  So, our initial
transaction will be to setup our initial balances:
[Normally we would setup somewhat prior to the above purchases and buy
things out of the checking account -- but, we just installed the
software and are starting in the middle.]

Transaction 001
    114 Debit $100
    116 Debit $2000
    120 Debit $500
    130 Debit GBP 500  (equivalent to $625 at time of purchase)
    142 Debit $2000
    144 Debit $4000 (20 units @ $200)
    222 Credit $9000
    224 Credit $500
    300 Debit $275   [Note, we are below water here.  Equity should be a
credit account and we are in the hole.]

At this point I went to the house accountant and asked about unrealized
gain and how to book it.  She said you don't.  Not until there is an
event in which it is sold or traded.  For tomorrow GBP might drop back
to parity, the stock might crash, and the housing market could implode.

So, we may need input from others who might have a different viewpoint.

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

On 06/18/2018 03:32 PM, Christopher Lam wrote:
> Hi Stephen
>
> One of the most unique features of gnucash is the multilevel account
> hierarchy, meaning both parent accounts and child accounts can carry
> balances.
>
> Would you mind liaising with the house accountant to ask about the
> following COA and the resulting balance sheet
>
> Asset (bal=$0.00)
> Asset:Bank1 (bal=$0.00)
> Asset:Bank1:Savings (bal=$100)
> Asset:Bank1:Bonds (bal=$2000)
> Asset:Bank2:Current (bal=$500)
> Asset:House (bal=$100,000, cost price)
> Asset:ForeignBank:Savings (bal=GBP 500, bought last year at a rate of
> 1 GBP = 1.25 USD
> Asset:Broker (bal=$2000) i.e.cash with broker
> Asset:Broker:Funds [stock] (bal=20units bought @ $200 each)
> Liability (bal=$0)
> Liability:Bank2 (bal=$0)
> Liability:Bank2:Loan (bal=-$9,000)
> Liability:Bank2:Creditcard (bal=-$500)
>
> Let's assume the current valuation of the unit funds is $250 i.e.
> unrealized gains of $1000; the house is currently valued at $110,000,
> and today 1 GBP = 1.30 USD :)
>
> How should the full expanded balance sheet look like? (XLS is fine)
> (if there are missing lines e.g. retained earnings etc please make up
> numbers and offer exact source)
>
> Thanks!
>
>
> On 19/06/18 00:16, Stephen M. Butler wrote:
>> Yes, it is the alignment of numbers that is the problem.
>>
>> 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
>>
>> On 06/18/2018 06:35 AM, Christopher Lam wrote:
>>> Hi Stephen
>>> Thank you this is very helpful.
>>>  From my understanding the non-eguile version does produce satisfactory
>>> headings and contents.
>>> However its alignment of numbers is odd?
>>> Is the alignment of subtotals and totals perfect in your amended
>>> eguile report? How should it look if there are deeper levels of
>>> subaccounts?
>>> For html export, open the report tab, then File>Export>Export Report.
>>> I believe the standard balsheet can be refined but this will take some
>>> time.
>>> C
>>>
>>> On 18 June 2018 at 00:32, Stephen M. Butler >> > wrote:
>>>
>>>  Interesting on the age.  I thought I'd downloaded the most recent
>>>  Linux
>>>  install.  But, my version is 2.6.19 built from rev c1b5e6c8d+ on
>>>  2018-04-09.  May be best to wait for the next release due out
>>>  early next
>>>  week and see how those reports look.
>>>
>>>  In the interim, attached are:
>>>  1.  GVE.gnucash -- my current set of books for an apartment
>>>  building I'm
>>>  selling
>>>  2.  Balance Sheet - standard.pdf -- Standard Balance Sheet report
>>>  (unformatted)
>>>  3.  Balance Sheet - formatted.pdf -- Eguile balance sheet after my
>>>  changes were applied
>>>          (Wife still has problems but willing to work with this.
>>>  Specifically, the "Profit/Loss" line should be part of Equities
>>> and be
>>>  added just after Retained earnings.  She thinks I should have
>>> just one
>>>  line of 

[GNC] Cant open new download for GNUCASH 3.1-3

[tricia]

Have downloaded latest upgrade to my MacBook Pro.
All appears to have downloaded successfully but it just quits when you select 
‘continue’ following verifying.
I have checked  it is in applications folder and tried to open from here.
I have deleted and downloaded again. I have rebooted etc
Still no success.
With past downloads I have had no problems.
Help
Kind regards, Trish





DI & TA Walter
20 Nightingale Court
OAKBANK  SA  5243

Ph:  0458 013 166
or: 0400 891 161
E: dtkal1...@hotmail.com



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

Re: [GNC] Problem with online banking setup in Ubuntu

[David Carlson]

WaltD

Please be sure to include gnucash-user@gnucash.org in all communications by
using reply All or whatever works best in your mail client.

I personally installed release 2.6.17 from GetDeb into Ubuntu 16.04 Gnome
on an older laptop and it has worked as well as I could expect with only 2
Gig of Ram.  However, I have a very large data file and I only use
AlphaVantage to update stock prices on a different machine so I am not sure
about AqBanking.  Perhaps others can share their experience with GnuCash on
Ubuntu.

While GnuCash 3.2 will be released very soon for Windows and OS X, it will
take a while to get to Ubuntu, unless you are willing to compile it
yourself.  Personally, I am not in a hurry.

David C

On Thu, Jun 21, 2018 at 5:56 PM, Walter Dowis  wrote:

> Hi David,
>   Thank you so much for your response. I truly appreciate your help.
>   I originally installed Gnucash from the Ubuntu repository. I
> installed the Gnucash-js package but I have since uninstalled it.
>   I can reinstall Gnucash, but first let ask, where do you suggest I
> install it from: GetDeb or the Ubuntu respository.
>   So before we begin, let my install the best version that you
> suggest.
>
>   Regards,
>   Walter
>
> On Jun 21, 2018 11:54 AM, "David Carlson" 
> wrote:
>
> WaltD
>
> You did not say whether you are using the release of GnuCash that is found
> in the software offered by Ubuntu or a newer release from Get Deb or yet
> another package.  Please name the release that you are using and whether
> you also installed all the supplemental packages required for Aqbanking.
> See the FAQ on the website for more information.
>
> You will almost always see that error messeage when reopening a file after
> a crash.  Usually you choose open anyway unless you think that the file is
> open on a different computer.
>
> As for the cause of the crash, it is necessary to know which version that
> you have before someone here can suggest what to try next.
>
> Good luck.
>
> David C
>
>
>
> On Thu, Jun 21, 2018, 5:46 AM WaltD  wrote:
>
>>  I am new to GnuCash. My OS is Ubuntu Unity 16.04 LTS.  I just
>> created a
>> new file with new accounts. I am trying to setup online banking to my
>> checking account. In the online setup wizard I reach a point where I'm to
>> "Start AqBanking Wizard". When I click on the AqBanking button nothing
>> happens and the GnuCash program closes.
>>  When I restart GnuCash, I get this strange message: GnuCash could not
>> obtain the lock for
>> file:///home/walter/GnuCash/Book01.gnucash. (Book01 is the new file I
>> created). How can I complete the online setup?
>>
>>
>>
>> --
>> 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.
>>
>
>
___
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] Problem with online banking setup in Ubuntu

[David Carlson]

WaltD

You did not say whether you are using the release of GnuCash that is found
in the software offered by Ubuntu or a newer release from Get Deb or yet
another package.  Please name the release that you are using and whether
you also installed all the supplemental packages required for Aqbanking.
See the FAQ on the website for more information.

You will almost always see that error messeage when reopening a file after
a crash.  Usually you choose open anyway unless you think that the file is
open on a different computer.

As for the cause of the crash, it is necessary to know which version that
you have before someone here can suggest what to try next.

Good luck.

David C



On Thu, Jun 21, 2018, 5:46 AM WaltD  wrote:

>  I am new to GnuCash. My OS is Ubuntu Unity 16.04 LTS.  I just created
> a
> new file with new accounts. I am trying to setup online banking to my
> checking account. In the online setup wizard I reach a point where I'm to
> "Start AqBanking Wizard". When I click on the AqBanking button nothing
> happens and the GnuCash program closes.
>  When I restart GnuCash, I get this strange message: GnuCash could not
> obtain the lock for
> file:///home/walter/GnuCash/Book01.gnucash. (Book01 is the new file I
> created). How can I complete the online setup?
>
>
>
> --
> 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.
>
___
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] Can't save a file to redirected folder.

[John Ralls]

> On Jun 20, 2018, at 10:13 PM, RedFishGnuFish  
> wrote:
> 
> Admittedly, I'm brand new to GnuCash but I think this is a real issue.
> 
> I'm using GnuCash 3.1 on Win 7.  My windows Desktop directory is redirected
> to a 2008 Server on my home network.
> 
> I create a new project and try to save it.
> 1) I first create a folder (Accounting) on my Desktop which succeeds.
> 
> 2) I enter that folder Accounting
> 
> 3) I try to save fool.gnucash
> 
>Note, the network path looks something like: 
>\\servername\Share\Users\\Accounting\foo.gnucash
> 
> I get the error:
> 
> You attempted to save in
> 
> or a subdirectory theerof.  This is not allowed as GnuCash reservers that
> directory for internal use.
> 
> Please try again in a different directory.
> 
> I'ts ironic that the only reason I'm upgrading from Quicken 2003 is it
> doesn't seem to handle network path names.
> 

Are all of the characters in  regular English characters (i.e. a-z, 
A-Z, and 0-9)?
Are you absolutely sure that the  is in fact random? How many 
trials did you run? Are all of *those* characters in the regular English 
character set?
Is the server path mapped to a drive with net use? Have you tried that?

Regards,
John Ralls

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

Re: [GNC] Gnucash won't open?

[Geert Janssens]

Op donderdag 21 juni 2018 15:49:29 CEST schreef keithwjones:
> John Ralls-2 wrote
> 
> > The other is that you closed GnuCash with the main window minimized and
> > GnuCash has set the window position to -32000;-32000. That misfeature has
> > been fixed for 3.2, but in the meantime you can open
> > AppData/Roaming/GnuCash/books/your-datafile-name.gcm in an editor (notepad
> > will do), find the window position line, and change the coordinates to
> > small positive numbers, perhaps 100;100.
> > 
> > The parameter you want to change is
> > ...
> > [Window 1]
> > ...
> > WindowPosition=-32000;-32000;
> > ...
> 
> Just happened to me, changed to 100;100
> 
> Keith
> 
I discovered today why this is a problem on Gnucash 3.x and not on 2.6.x. 
While Bob already committed a fix to prevent this from happening again, he did 
not add a cure for existing bad WindowPosition values. I have just committed 
that part so it should no longer happen from gnucash 3.2 onwards.

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] Strange Problem

[John Ralls]

> On Jun 21, 2018, at 2:51 AM, Les  wrote:
> 
> Yesterday, I created a new stock account, like all of the other stock 
> accounts that I have.  The strange thing is while the stock is listed in my 
> Security Editor, it is NOT listed in Price Editor.  How is this possible?
> 
> How can I fix this problem?
> 

Get or create a price for the new security.

Regards,
John Ralls


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

Re: [GNC] Gnucash won't open?

[keithwjones]

John Ralls-2 wrote
> The other is that you closed GnuCash with the main window minimized and
> GnuCash has set the window position to -32000;-32000. That misfeature has
> been fixed for 3.2, but in the meantime you can open
> AppData/Roaming/GnuCash/books/your-datafile-name.gcm in an editor (notepad
> will do), find the window position line, and change the coordinates to
> small positive numbers, perhaps 100;100.
> 
> The parameter you want to change is
> ...
> [Window 1]
> ...
> WindowPosition=-32000;-32000;
> ...

Just happened to me, changed to 100;100

Keith




-
GnuCash 3.1 - Windows 10
--
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] Can't save a file to redirected folder.

[RedFishGnuFish]

Admittedly, I'm brand new to GnuCash but I think this is a real issue.

I'm using GnuCash 3.1 on Win 7.  My windows Desktop directory is redirected
to a 2008 Server on my home network.

I create a new project and try to save it.
1) I first create a folder (Accounting) on my Desktop which succeeds.

2) I enter that folder Accounting

3) I try to save fool.gnucash

Note, the network path looks something like: 
\\servername\Share\Users\\Accounting\foo.gnucash

I get the error:

You attempted to save in

or a subdirectory theerof.  This is not allowed as GnuCash reservers that
directory for internal use.

Please try again in a different directory.

I'ts ironic that the only reason I'm upgrading from Quicken 2003 is it
doesn't seem to handle network path names.





--
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] Is there a Save As command line option

[DaveC49]

Steve,

One possibility is to use synchronized data bases using master-slave
replication. I know this works with MySQL and it is a bit of a pain to set
up but once it is going it is generally pretty good. Also a bit of a pain to
restart if the replication gets out of sync. I have been meaning to setup
scripts to do that but haven't yet got around to it. I keep several database
on my laptop and desktop in sync automatically. Not sure about PostGRES or
sqlite3 replication capability. 

Also if you have Dropbox or similar access you can store the GnuCash files
in a Dropbox and access it from multiple devices.

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.

[GNC] Strange Problem

[Les]

Yesterday, I created a new stock account, like all of the other stock 
accounts that I have.  The strange thing is while the stock is listed in 
my Security Editor, it is NOT listed in Price Editor.  How is this possible?


How can I fix this problem?

Thanks,

Les

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