Re: [GNC] How to copy a GnuCash 'installation'?

[Chris Green]

On Sat, May 07, 2022 at 07:02:22AM +1000, Liz Dodd wrote:
> On Fri, 6 May 2022 18:58:13 +0100
> Chris Green  wrote:
> 
> > However there are other files one needs to copy if you want reports
> > and screen layout and things like that to be the same.  Is this
> > documented anywhere?
> 
> Of course. It's in the wiki, and you will find it in the FAQ under
> "Backups".
> 
Ah, yes, good point - a backup is similar to what I'm looking for.
Thank you.

-- 
Chris Green
___
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] Fwd: Double entry directly to Equity

[Bogdan]

Well, actually my question is not an accounting question but rather a
technical one on how to set up and use equity accounts in Gnucash, if at
all possible (I'm a qualified accountant by the way). I took a revaluation
reserve just as an example.

In many accounting frameworks you can find items that affect equity
directly rather than through Profit and Loss / Retained Earnings.

For example, if you account for Property at fair value through P&L (so
called "investment property") you would reflect an unrealized gain in
market value as :

Dr Asset Cr Income (you equity increases because your net income / retained
earnings increase)

However, if you use a revaluation model for the Property and mark it to
market you would do:

Dr Asset Cr Reserve account

A Reserve account is an equity account (as much as Retained Earnings is an
equity account). This gain doesn't go through P&L  and doesn't affect your
income and expenses but it does increase your equity / capital directly
through the reserve account (where it's reflected on the asset side - the
property account or counter-account is beyond the point).

So I guess I am just wondering how to create an equity account in Gnucash.
I used to set up these accounts as sub-accounts in the Trading account but
now when I'm trying to make an entry directly to such a sub-account in
Trading (e.g. Dr Asset Cr Trading) the Trading account changes to Imbalance
automatically. Is there a workaround or is there a way to fix it?

Thanks!

On Sun, May 8, 2022 at 2:39 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
> > This Investopedia page (
> >
> https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
> > .) might provide some insights into how to setup revaluation reserves. My
> > reading of this is that the Reserve account is a contra account to the
> asset
> > value and it is recorded against a specific Expense account to account
> for short
> > term variations in the asset value.  Find the section on recording
> revaluation
> > reserves a bit down the page.  Most jurisdictions don't tax unrealized
> gains or
> > give you exemptions for unrealized losses, so you would likely want to
> record it
> > under an Expense account category for non-deductible expenses.
> >
> > You should seek specific accounting advice from a qualified accountant
> for your
> > jurisdiction and specific situation and not rely on this
> >
> > David Cousens
>
> Listen to David.
>
> This is a house. Ordinary expenses fore most repairs are non-deductible.
> But certain "improvements", while also non-deductible at the time, are
> allowed to be added to the basis, and so can reduce capital gains
> when/if the house is sold << and you might not be required to report
> these gains if buying another house for more within a certain amount of
> time >> BUT (and this is why I am not being more specific, though I know
> some of the details) I am NOT "qualified" to give such advice. Seek a
> qualified professional.
>
> 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] Fwd: Double entry directly to Equity

[davidcousens49]

Bogdan

That's easy. In the Accounts Tab, right click on the top level Equity account to
select it and then right click anywhere in the pane and select New Account from
the popup menu  or use Actions->New Account from the mainmenu. This should start
the dialogue with Equity as the parent account, enter the name "Revaluation
Reserve", select the account currency and add any other detail (opening balance
if non zero etc.) . At the bottom the Parent account should show as Equity. (You
can select any other Equity account as parent depending upon your heirarchy in
Equity). Click OK and you have an equity account which you can the use as the
other split in transactions recording the changes in asset value.

David


On Sun, 2022-05-08 at 10:37 +0200, Bogdan wrote:
> Well, actually my question is not an accounting question but rather a
> technical one on how to set up and use equity accounts in Gnucash, if at
> all possible (I'm a qualified accountant by the way). I took a revaluation
> reserve just as an example.
> 
> In many accounting frameworks you can find items that affect equity
> directly rather than through Profit and Loss / Retained Earnings.
> 
> For example, if you account for Property at fair value through P&L (so
> called "investment property") you would reflect an unrealized gain in
> market value as :
> 
> Dr Asset Cr Income (you equity increases because your net income / retained
> earnings increase)
> 
> However, if you use a revaluation model for the Property and mark it to
> market you would do:
> 
> Dr Asset Cr Reserve account
> 
> A Reserve account is an equity account (as much as Retained Earnings is an
> equity account). This gain doesn't go through P&L  and doesn't affect your
> income and expenses but it does increase your equity / capital directly
> through the reserve account (where it's reflected on the asset side - the
> property account or counter-account is beyond the point).
> 
> So I guess I am just wondering how to create an equity account in Gnucash.
> I used to set up these accounts as sub-accounts in the Trading account but
> now when I'm trying to make an entry directly to such a sub-account in
> Trading (e.g. Dr Asset Cr Trading) the Trading account changes to Imbalance
> automatically. Is there a workaround or is there a way to fix it?
> 
> Thanks!
> 
> On Sun, May 8, 2022 at 2:39 AM Michael or Penny Novack <
> stepbystepf...@comcast.net> wrote:
> 
> > > This Investopedia page (
> > > 
> > https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
> > > .) might provide some insights into how to setup revaluation reserves. My
> > > reading of this is that the Reserve account is a contra account to the
> > asset
> > > value and it is recorded against a specific Expense account to account
> > for short
> > > term variations in the asset value.  Find the section on recording
> > revaluation
> > > reserves a bit down the page.  Most jurisdictions don't tax unrealized
> > gains or
> > > give you exemptions for unrealized losses, so you would likely want to
> > record it
> > > under an Expense account category for non-deductible expenses.
> > > 
> > > You should seek specific accounting advice from a qualified accountant
> > for your
> > > jurisdiction and specific situation and not rely on this
> > > 
> > > David Cousens
> > 
> > Listen to David.
> > 
> > This is a house. Ordinary expenses fore most repairs are non-deductible.
> > But certain "improvements", while also non-deductible at the time, are
> > allowed to be added to the basis, and so can reduce capital gains
> > when/if the house is sold << and you might not be required to report
> > these gains if buying another house for more within a certain amount of
> > time >> BUT (and this is why I am not being more specific, though I know
> > some of the details) I am NOT "qualified" to give such advice. Seek a
> > qualified professional.
> > 
> > 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] Fwd: Double entry directly to Equity

[Bogdan]

Thanks, that answers my question!

On Sun, May 8, 2022 at 12:03 PM  wrote:

> Bogdan
>
> That's easy. In the Accounts Tab, right click on the top level Equity
> account to
> select it and then right click anywhere in the pane and select New Account
> from
> the popup menu  or use Actions->New Account from the mainmenu. This should
> start
> the dialogue with Equity as the parent account, enter the name "Revaluation
> Reserve", select the account currency and add any other detail (opening
> balance
> if non zero etc.) . At the bottom the Parent account should show as
> Equity. (You
> can select any other Equity account as parent depending upon your
> heirarchy in
> Equity). Click OK and you have an equity account which you can the use as
> the
> other split in transactions recording the changes in asset value.
>
> David
>
>
> On Sun, 2022-05-08 at 10:37 +0200, Bogdan wrote:
> > Well, actually my question is not an accounting question but rather a
> > technical one on how to set up and use equity accounts in Gnucash, if at
> > all possible (I'm a qualified accountant by the way). I took a
> revaluation
> > reserve just as an example.
> >
> > In many accounting frameworks you can find items that affect equity
> > directly rather than through Profit and Loss / Retained Earnings.
> >
> > For example, if you account for Property at fair value through P&L (so
> > called "investment property") you would reflect an unrealized gain in
> > market value as :
> >
> > Dr Asset Cr Income (you equity increases because your net income /
> retained
> > earnings increase)
> >
> > However, if you use a revaluation model for the Property and mark it to
> > market you would do:
> >
> > Dr Asset Cr Reserve account
> >
> > A Reserve account is an equity account (as much as Retained Earnings is
> an
> > equity account). This gain doesn't go through P&L  and doesn't affect
> your
> > income and expenses but it does increase your equity / capital directly
> > through the reserve account (where it's reflected on the asset side - the
> > property account or counter-account is beyond the point).
> >
> > So I guess I am just wondering how to create an equity account in
> Gnucash.
> > I used to set up these accounts as sub-accounts in the Trading account
> but
> > now when I'm trying to make an entry directly to such a sub-account in
> > Trading (e.g. Dr Asset Cr Trading) the Trading account changes to
> Imbalance
> > automatically. Is there a workaround or is there a way to fix it?
> >
> > Thanks!
> >
> > On Sun, May 8, 2022 at 2:39 AM Michael or Penny Novack <
> > stepbystepf...@comcast.net> wrote:
> >
> > > > This Investopedia page (
> > > >
> > >
> https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revaluation%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
> > > > .) might provide some insights into how to setup revaluation
> reserves. My
> > > > reading of this is that the Reserve account is a contra account to
> the
> > > asset
> > > > value and it is recorded against a specific Expense account to
> account
> > > for short
> > > > term variations in the asset value.  Find the section on recording
> > > revaluation
> > > > reserves a bit down the page.  Most jurisdictions don't tax
> unrealized
> > > gains or
> > > > give you exemptions for unrealized losses, so you would likely want
> to
> > > record it
> > > > under an Expense account category for non-deductible expenses.
> > > >
> > > > You should seek specific accounting advice from a qualified
> accountant
> > > for your
> > > > jurisdiction and specific situation and not rely on this
> > > >
> > > > David Cousens
> > >
> > > Listen to David.
> > >
> > > This is a house. Ordinary expenses fore most repairs are
> non-deductible.
> > > But certain "improvements", while also non-deductible at the time, are
> > > allowed to be added to the basis, and so can reduce capital gains
> > > when/if the house is sold << and you might not be required to report
> > > these gains if buying another house for more within a certain amount of
> > > time >> BUT (and this is why I am not being more specific, though I
> know
> > > some of the details) I am NOT "qualified" to give such advice. Seek a
> > > qualified professional.
> > >
> > > 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.gnucas

[GNC] Large GnuCash file very slow to write to

[Tim Hume via gnucash-user]

Hi,

My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every 
month or two I import a lot more transactions in CSV format. I use piecash in a 
Python script I wrote, because the importing of CSV data built into GnuCash 
crashes when I import too many transactions.

I might be importing perhaps 4000 or 5000 transactions. Saving them into my 
GnuCash file takes many many minutes. I know my file is getting too large, but 
it surely shouldn't take 10+ minutes to do this operation? Whilst I do it, I 
can see Python is taking 100% of a CPU core.

Come the end of the financial year (30 June) I'm going to start a new file. But 
this will quickly grow in size, and no doubt I'll run into this problem again. 
Is there anything I can do to speed this up, or do I just have to live with it?

Cheers,

Tim.

Sent with [ProtonMail](https://protonmail.com/) secure email.
___
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] Large GnuCash file very slow to write to

[Kenneth Schneider]

I don’t believe the file is getting too large. If you haven’t looked into using 
an SSD drive at least for the database I highly recommend it. Not only will you 
amazed at how fast data will be written to the file but also how fast you will 
be able to generate reports.

Ken Schneider 

> On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user 
>  wrote:
> 
> Hi,
> 
> My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every 
> month or two I import a lot more transactions in CSV format. I use piecash in 
> a Python script I wrote, because the importing of CSV data built into GnuCash 
> crashes when I import too many transactions.
> 
> I might be importing perhaps 4000 or 5000 transactions. Saving them into my 
> GnuCash file takes many many minutes. I know my file is getting too large, 
> but it surely shouldn't take 10+ minutes to do this operation? Whilst I do 
> it, I can see Python is taking 100% of a CPU core.
> 
> Come the end of the financial year (30 June) I'm going to start a new file. 
> But this will quickly grow in size, and no doubt I'll run into this problem 
> again. Is there anything I can do to speed this up, or do I just have to live 
> with it?
> 
> Cheers,
> 
> Tim.
> 
> Sent with [ProtonMail](https://protonmail.com/) secure email.
> ___
> 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] Large GnuCash file very slow to write to

[Tim Hume via gnucash-user]

It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 chip).

The slow part seems to be saving the database - inserting the transactions is 
fast enough, the save operation is what takes so long. It may be 20 minutes - I 
haven't timed it. Even closing GnuCash is slow - perhaps 30 seconds to a minute.

Sent with ProtonMail secure email.
--- Original Message ---
On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider  
wrote:


> I don’t believe the file is getting too large. If you haven’t looked into 
> using an SSD drive at least for the database I highly recommend it. Not only 
> will you amazed at how fast data will be written to the file but also how 
> fast you will be able to generate reports.
>
> Ken Schneider
>
> > On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user 
> > gnucash-user@gnucash.org wrote:
> >
> > Hi,
> >
> > My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every 
> > month or two I import a lot more transactions in CSV format. I use piecash 
> > in a Python script I wrote, because the importing of CSV data built into 
> > GnuCash crashes when I import too many transactions.
> >
> > I might be importing perhaps 4000 or 5000 transactions. Saving them into my 
> > GnuCash file takes many many minutes. I know my file is getting too large, 
> > but it surely shouldn't take 10+ minutes to do this operation? Whilst I do 
> > it, I can see Python is taking 100% of a CPU core.
> >
> > Come the end of the financial year (30 June) I'm going to start a new file. 
> > But this will quickly grow in size, and no doubt I'll run into this problem 
> > again. Is there anything I can do to speed this up, or do I just have to 
> > live with it?
> >
> > Cheers,
> >
> > Tim.
> >
> > Sent with ProtonMail secure email.
> > ___
> > 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] GnuCash 4.10

[Richard Clarkson via gnucash-user]

Have just updated from previous version to GnuCash 4.10 on Windows 11.

 

GnuCash now refuses to open (have tried from PowerShell too). I have tried
reinstalling but no change.

 

Any idea how I can rectify this issue?

Many thanks

 

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] GnuCash 4.10

[Gyle McCollam]

Richard,
When you tried to update, did it tell you, you had to remove the old 
installation of GnuCash?  I know it does that before installing the new 
version.  Maybe there was an issue with the uninstall.  I woould make sure you 
have a backup, then try uninstalling the old version manually.  After that try 
installing again.  This time there should be no uninstall attempted by GnuCash 
and maybe it will install correctly.  There is no logical reason why it 
shouldn't work on Windows 11, as I said I have been using it since 4.10 came 
out.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: Richard Clarkson 
Sent: Sunday, May 8, 2022 10:18 AM
To: 'Gyle McCollam' 
Subject: RE: [GNC] GnuCash 4.10


Thanks Gyle!



The exe file won’t open.



Will maybe have to start from scratch or wait for the next update.



Richard



From: Gyle McCollam 
Sent: 08 May 2022 15:04
To: Richard Clarkson 
Subject: Re: [GNC] GnuCash 4.10



Richard,

Sorry to hear you are having problems.  I have been using 4.10 on Windows 11 
with no issues.  Is it not able to find your GnuCash file or is it not working 
at all.  If it is the former, use file open and explore to find your GnuCash 
file.  If it is the latter, I can't help you.



Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email



From: gnucash-user 
mailto:gnucash-user-bounces+gylemc=gmail@gnucash.org>>
 on behalf of Richard Clarkson via gnucash-user 
mailto:gnucash-user@gnucash.org>>
Sent: Sunday, May 8, 2022 9:40 AM
To: gnucash-user@gnucash.org 
mailto:gnucash-user@gnucash.org>>
Subject: [GNC] GnuCash 4.10



Have just updated from previous version to GnuCash 4.10 on Windows 11.



GnuCash now refuses to open (have tried from PowerShell too). I have tried
reinstalling but no change.



Any idea how I can rectify this issue?

Many thanks



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] GnuCash 4.10

[Glenn Fowler]

Hi Richard,

Do you get an error message?
Did you install using the installer?

On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user <
gnucash-user@gnucash.org> wrote:

> Have just updated from previous version to GnuCash 4.10 on Windows 11.
>
>
>
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
>
>
>
> Any idea how I can rectify this issue?
>
> Many thanks
>
>
>
> 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.

[GNC] Double entry directly to Equity

[David Long]

Hi, I just tested David's method of creating a new equity account and
crediting the revaluation to that account and debiting the asset account. I
did not attach  the new Revaluation Reserve  account to an existing equity
account (parent)  but I specified it as a new top level account. Either way
works fine, and the revaluation reserve appears where it should on the
balance sheet report.


Cheers
David

-Original Message-
From: gnucash-user
 On Behalf Of
gnucash-user-requ...@gnucash.org
Sent: May 8, 2022 10:39 PM
To: gnucash-user@gnucash.org
Subject: gnucash-user Digest, Vol 230, Issue 21

Send gnucash-user mailing list submissions to
gnucash-user@gnucash.org

To subscribe or unsubscribe via the World Wide Web, visit
https://lists.gnucash.org/mailman/listinfo/gnucash-user
or, via email, send a message with subject or body 'help' to
gnucash-user-requ...@gnucash.org

You can reach the person managing the list at
gnucash-user-ow...@gnucash.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of gnucash-user digest..."


Today's Topics:

   1. Re:  How to copy a GnuCash 'installation'? (Chris Green)
   2. Re:  Fwd: Double entry directly to Equity (Bogdan)
   3. Re:  Fwd: Double entry directly to Equity
  (davidcousen...@gmail.com)
   4. Re:  Fwd: Double entry directly to Equity (Bogdan)
   5.  Large GnuCash file very slow to write to (Tim Hume)
   6. Re:  Large GnuCash file very slow to write to (Kenneth Schneider)
   7. Re:  Large GnuCash file very slow to write to (Tim Hume)
   8.  GnuCash 4.10 (Richard Clarkson)
   9. Re:  GnuCash 4.10 (Gyle McCollam)
  10. Re:  GnuCash 4.10 (Glenn Fowler)


--

Message: 1
Date: Sun, 8 May 2022 08:56:47 +0100
From: Chris Green 
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to copy a GnuCash 'installation'?
Message-ID: 
Content-Type: text/plain; charset=us-ascii

On Sat, May 07, 2022 at 07:02:22AM +1000, Liz Dodd wrote:
> On Fri, 6 May 2022 18:58:13 +0100
> Chris Green  wrote:
> 
> > However there are other files one needs to copy if you want reports 
> > and screen layout and things like that to be the same.  Is this 
> > documented anywhere?
> 
> Of course. It's in the wiki, and you will find it in the FAQ under 
> "Backups".
> 
Ah, yes, good point - a backup is similar to what I'm looking for.
Thank you.

--
Chris Green


--

Message: 2
Date: Sun, 8 May 2022 10:37:51 +0200
From: Bogdan 
To: stepbystepf...@comcast.net, gnucash-user@gnucash.org
Subject: Re: [GNC] Fwd: Double entry directly to Equity
Message-ID:

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

Well, actually my question is not an accounting question but rather a
technical one on how to set up and use equity accounts in Gnucash, if at
all possible (I'm a qualified accountant by the way). I took a revaluation
reserve just as an example.

In many accounting frameworks you can find items that affect equity
directly rather than through Profit and Loss / Retained Earnings.

For example, if you account for Property at fair value through P&L (so
called "investment property") you would reflect an unrealized gain in
market value as :

Dr Asset Cr Income (you equity increases because your net income / retained
earnings increase)

However, if you use a revaluation model for the Property and mark it to
market you would do:

Dr Asset Cr Reserve account

A Reserve account is an equity account (as much as Retained Earnings is an
equity account). This gain doesn't go through P&L  and doesn't affect your
income and expenses but it does increase your equity / capital directly
through the reserve account (where it's reflected on the asset side - the
property account or counter-account is beyond the point).

So I guess I am just wondering how to create an equity account in Gnucash.
I used to set up these accounts as sub-accounts in the Trading account but
now when I'm trying to make an entry directly to such a sub-account in
Trading (e.g. Dr Asset Cr Trading) the Trading account changes to Imbalance
automatically. Is there a workaround or is there a way to fix it?

Thanks!

On Sun, May 8, 2022 at 2:39 AM Michael or Penny Novack <
stepbystepf...@comcast.net> wrote:

>
> > This Investopedia page (
> >
>
https://www.investopedia.com/terms/r/revaluationreserves.asp#:~:text=Revalua
tion%20reserve%20is%20an%20accounting,of%20the%20asset%20has%20changed
> > .) might provide some insights into how to setup revaluation reserves.
My
> > reading of this is that the Reserve account is a contra account to the
> asset
> > value and it is recorded against a specific Expense account to account
> for short
> > term variations in the asset value.  Find the section on recording
> revaluation
> > reserves a bit down the page.  Most jurisdictions don't tax unrealized
> gains or
> > give you exemptions for unrealized losses, so you would likely want to
> record it
> 

Re: [GNC] Large GnuCash file very slow to write to

[john]

Is this about your python program being slow or about GnuCash being slow? Note 
that Piecash isn't GnuCash and we don't provide any support for it, nor 
obviously can we provide any support for your program.

If it's a GnuCash problem, please provide more details about exactly what 
you're doing and what step is taking 20 minutes.

Regards,
John Ralls


> On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user 
>  wrote:
> 
> It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 
> chip).
> 
> The slow part seems to be saving the database - inserting the transactions is 
> fast enough, the save operation is what takes so long. It may be 20 minutes - 
> I haven't timed it. Even closing GnuCash is slow - perhaps 30 seconds to a 
> minute.
> 
> Sent with ProtonMail secure email.
> --- Original Message ---
> On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider 
> mailto:kschnei...@bout-tyme.net>> wrote:
> 
> 
>> I don’t believe the file is getting too large. If you haven’t looked into 
>> using an SSD drive at least for the database I highly recommend it. Not only 
>> will you amazed at how fast data will be written to the file but also how 
>> fast you will be able to generate reports.
>> 
>> Ken Schneider
>> 
>>> On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user 
>>> gnucash-user@gnucash.org wrote:
>>> 
>>> Hi,
>>> 
>>> My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every 
>>> month or two I import a lot more transactions in CSV format. I use piecash 
>>> in a Python script I wrote, because the importing of CSV data built into 
>>> GnuCash crashes when I import too many transactions.
>>> 
>>> I might be importing perhaps 4000 or 5000 transactions. Saving them into my 
>>> GnuCash file takes many many minutes. I know my file is getting too large, 
>>> but it surely shouldn't take 10+ minutes to do this operation? Whilst I do 
>>> it, I can see Python is taking 100% of a CPU core.
>>> 
>>> Come the end of the financial year (30 June) I'm going to start a new file. 
>>> But this will quickly grow in size, and no doubt I'll run into this problem 
>>> again. Is there anything I can do to speed this up, or do I just have to 
>>> live with it?
>>> 
>>> Cheers,
>>> 
>>> Tim.
>>> 
>>> Sent with ProtonMail secure email.
>>> ___
>>> 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] GnuCash 4.10

[Glenn Fowler]

Ok try double clicking directly on your book file and see if it works.

On Sun, May 8, 2022 at 11:16 AM Richard Clarkson 
wrote:

> Glenn
>
>
>
> When installing using the installer there was a message that GnuCash was
> open, so I closed GnuCash and clicked retry.
>
>
>
> Gnucash.exe didn’t work. I also tried via PowerShell and the GnuCash
> wasn’t found. I’ve tried in Admin mode too.
>
>
>
> I have uninstalled GnuCash and reinstalled and still have the same issue.
>
>
>
> Thanks for your help.
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 15:31
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Hi Richard,
>
>
>
> Do you get an error message?
>
> Did you install using the installer?
>
>
>
> On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> Have just updated from previous version to GnuCash 4.10 on Windows 11.
>
>
>
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
>
>
>
> Any idea how I can rectify this issue?
>
> Many thanks
>
>
>
> 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] Large GnuCash file very slow to write to

[David Carlson]

Tim,
Also please mention what version of GnuCash you are presently using and a
little more about your OS environment such as size of your RAM and whether
it is nearly all used when you see your problem.

On Sun, May 8, 2022 at 10:31 AM john  wrote:

> Is this about your python program being slow or about GnuCash being slow?
> Note that Piecash isn't GnuCash and we don't provide any support for it,
> nor obviously can we provide any support for your program.
>
> If it's a GnuCash problem, please provide more details about exactly what
> you're doing and what step is taking 20 minutes.
>
> Regards,
> John Ralls
>
>
> > On May 8, 2022, at 4:50 AM, Tim Hume via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > It is an SSD drive (I'm using a Mac Mini about one year old - with the
> M1 chip).
> >
> > The slow part seems to be saving the database - inserting the
> transactions is fast enough, the save operation is what takes so long. It
> may be 20 minutes - I haven't timed it. Even closing GnuCash is slow -
> perhaps 30 seconds to a minute.
> >
> > Sent with ProtonMail secure email.
> > --- Original Message ---
> > On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider <
> kschnei...@bout-tyme.net > wrote:
> >
> >
> >> I don’t believe the file is getting too large. If you haven’t looked
> into using an SSD drive at least for the database I highly recommend it.
> Not only will you amazed at how fast data will be written to the file but
> also how fast you will be able to generate reports.
> >>
> >> Ken Schneider
> >>
> >>> On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user
> gnucash-user@gnucash.org wrote:
> >>>
> >>> Hi,
> >>>
> >>> My GnuCash file (SQLite format) has become rather large - 110 MBytes.
> Every month or two I import a lot more transactions in CSV format. I use
> piecash in a Python script I wrote, because the importing of CSV data built
> into GnuCash crashes when I import too many transactions.
> >>>
> >>> I might be importing perhaps 4000 or 5000 transactions. Saving them
> into my GnuCash file takes many many minutes. I know my file is getting too
> large, but it surely shouldn't take 10+ minutes to do this operation?
> Whilst I do it, I can see Python is taking 100% of a CPU core.
> >>>
> >>> Come the end of the financial year (30 June) I'm going to start a new
> file. But this will quickly grow in size, and no doubt I'll run into this
> problem again. Is there anything I can do to speed this up, or do I just
> have to live with it?
> >>>
> >>> Cheers,
> >>>
> >>> Tim.
> >>>
> >>> Sent with ProtonMail secure email.
> >>> ___
> >>> 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 <
> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists <
> 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.
>


-- 
David Carlson
___
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/wi

Re: [GNC] Double entry directly to Equity

[Michael or Penny Novack]

On 5/8/2022 11:26 AM, David Long wrote:

Hi, I just tested David's method of creating a new equity account and
crediting the revaluation to that account and debiting the asset account. I
did not attach  the new Revaluation Reserve  account to an existing equity
account (parent)  but I specified it as a new top level account. Either way
works fine, and the revaluation reserve appears where it should on the
balance sheet report.


Cheers
David


This question took longer to get resolved for you because of 
misunderstanding.


You really had a gnucash question (and not a question about what could 
or could not be put under equity). Gnucash is an AUTOMATION of standard 
double entry bookkeeping and with one (for some us major/annoying) 
exception* you can do anything you could working the old fashioned way 
pen and ink on paper. So yes of course you can create accounts of type 
equity. It';d be kind of hard to use for accounting for partnerships 
(for example) if you couldn't set up :drawing" accounts for each partner.


IF you were opting to have all transactions entered "journal style" 
(like you have to do for splits) it would be exactly like the old days 
except "posting" would be automatic and error free and anything entered 
out of balance immediately obvious.


My suggestion for anybody experienced doing bookkeeping the old 
fashioned way is that IF they are confused by/have trouble with any of 
the "shortcuts" gnucash offers, simply don't use those at first. Thus I 
set up books for entities without using the "opening balance" feature 
(create accounts zero and instead open the books with a transaction just 
like in the old days.


Michael D Novack

* The "business features" -- you can't ask for invoices to be produced 
unless "accrual basis" with the invoiced amount a "receivable". That 
annoys me because doing books for non-profits where often invoices are 
wanted (like member dues) but these amounts are NOT receivable (there is 
no obligation to renew). This is one of the reasons that many orgs push 
"pledge of a monthly donation" and that set up to be automated. A 
"pledge" IS legally/technically "receivable".



___
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] Investment accounts - maintain ongoing balance only

[Scott Soderling]

I use GnuCash for all my personal finances. I have a number of "retirement"
investment accounts. I receive monthly multi-page statements for each
account from the bank, showing every transaction (buys/sells, interest,
dividends, capital gains, etc). Now that I'm a senior, I have to withdraw
monthly amounts from these accounts, which are transferred to a checking
account.

I really have no interest in tracking all that data in GnuCash. I can see
it all in the statements and/or through my online banking. What I am
interested in doing.  create GnuCash accounts for each investment
account, so that I can enter transfer transactions each month to my
checking account. All I need to do in addition to that is update the
current value of the investment accounts, say as of the last day of each
month.

Opening the investment accounts and giving them opening balances is easy.
I'm now looking for suggestions going forward regarding updating the
current value of each account monthly. That is, I don't want to set up sub
accounts for every stock, mutual fund, etc and then have to track
share/unit prices, just to come up with an account balance. I just want to
enter one "adjustment" type transaction for each investment account, once a
month, to make it balance to my monthly bank statements.

Appreciate all ideas... thanks!
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Investment accounts - maintain ongoing balance only

[Derek Atkins]

If you just want to keep the value balance, then you can just use a
regular asset account and every month (or quarter, or however often) enter
a "balance update" transaction for whatever gains/losses you achieved that
month/quarter/etc.  Note that this will combine realized and unrealized
gains, so you won't necessarily be able to use that change in value for
tax purposes.  but it'll get you what you want.

-derek

On Sun, May 8, 2022 1:17 pm, Scott Soderling wrote:
> I use GnuCash for all my personal finances. I have a number of
> "retirement"
> investment accounts. I receive monthly multi-page statements for each
> account from the bank, showing every transaction (buys/sells, interest,
> dividends, capital gains, etc). Now that I'm a senior, I have to withdraw
> monthly amounts from these accounts, which are transferred to a checking
> account.
>
> I really have no interest in tracking all that data in GnuCash. I can see
> it all in the statements and/or through my online banking. What I am
> interested in doing.  create GnuCash accounts for each investment
> account, so that I can enter transfer transactions each month to my
> checking account. All I need to do in addition to that is update the
> current value of the investment accounts, say as of the last day of each
> month.
>
> Opening the investment accounts and giving them opening balances is easy.
> I'm now looking for suggestions going forward regarding updating the
> current value of each account monthly. That is, I don't want to set up sub
> accounts for every stock, mutual fund, etc and then have to track
> share/unit prices, just to come up with an account balance. I just want to
> enter one "adjustment" type transaction for each investment account, once
> a
> month, to make it balance to my monthly bank statements.
>
> Appreciate all ideas... thanks!
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.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] Investment accounts - maintain ongoing balance only

[Stan Brown]

On 2022-05-08 10:17, Scott Soderling wrote:
> Opening the investment accounts and giving them opening balances is easy.
> I'm now looking for suggestions going forward regarding updating the
> current value of each account monthly. That is, I don't want to set up sub
> accounts for every stock, mutual fund, etc and then have to track
> share/unit prices, just to come up with an account balance. I just want to
> enter one "adjustment" type transaction for each investment account, once a
> month, to make it balance to my monthly bank statements.


Debit  to Assets:Investment Account
Credit to Income:Investment Gains and Losses

(Some people, me among them, would put Investment Gains and Losses under
Equity rather than Income. I do this because investment gains and losses
can exceed the total of all ordinary income and expenses in a given
month; also, I budget my income and expenses but not investment gains
and losses, which are unpredictable. Since these adjusting transactions
are for your benefit and not your accountant's, you can do whatever
feels natural to you.)


-- 

Stan Brown

Tehachapi, CA, USA

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

Re: [GNC] GnuCash 4.10

[Glenn Fowler]

Your data file for your book which will be in the folder that you
specified.

Ex
myfinances.gnucash
vacationhome.gnucash

On Sun, May 8, 2022, 1:00 PM Richard Clarkson 
wrote:

> Glenn
>
>
>
> Can’t see anything called book file. Are you referring to GNUData.gnucash
> ? If so nothing opens.
>
>
>
> Thanks
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 16:34
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Ok try double clicking directly on your book file and see if it works.
>
>
>
> On Sun, May 8, 2022 at 11:16 AM Richard Clarkson <
> rtclark...@btinternet.com> wrote:
>
> Glenn
>
>
>
> When installing using the installer there was a message that GnuCash was
> open, so I closed GnuCash and clicked retry.
>
>
>
> Gnucash.exe didn’t work. I also tried via PowerShell and the GnuCash
> wasn’t found. I’ve tried in Admin mode too.
>
>
>
> I have uninstalled GnuCash and reinstalled and still have the same issue.
>
>
>
> Thanks for your help.
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 15:31
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Hi Richard,
>
>
>
> Do you get an error message?
>
> Did you install using the installer?
>
>
>
> On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> Have just updated from previous version to GnuCash 4.10 on Windows 11.
>
>
>
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
>
>
>
> Any idea how I can rectify this issue?
>
> Many thanks
>
>
>
> 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] Investment accounts - maintain ongoing balance only

[Michael or Penny Novack]

On 5/8/2022 3:47 PM, Stan Brown wrote:

On 2022-05-08 10:17, Scott Soderling wrote:
Debit  to Assets:Investment Account
Credit to Income:Investment Gains and Losses

(Some people, me among them, would put Investment Gains and Losses under
Equity rather than Income. I do this because investment gains and losses
can exceed the total of all ordinary income and expenses in a given
month; also, I budget my income and expenses but not investment gains
and losses, which are unpredictable. Since these adjusting transactions
are for your benefit and not your accountant's, you can do whatever
feels natural to you.)


This is not quite an account vs non-accountant thing.

Two things to keep in mind. Accounts of "type" income or "type" expense 
are actually accounts of fundamental type equity << the only REAL types 
are asset, liability, and equity. In the earliest days of double entry 
bookkeeping (we are talking about hundreds of years ago) there were no 
":temporary" account of type income or expense. Then  somebody realized 
that by (temporarily) doing the transactions against income and expense 
additional useful information was to be had. Moved to equity by the 
:close the books" process. Because software like gnucash can produce the 
reports without "closing the books" we tend not to ever :close the 
books" and so don;t  "see" the types income and expense as temporary.


So of course you can use equity as the other side. You also should 
realize that this might be a very good way to go for "investments" where 
the increase over time (the unrealized gains) will NEVER be realized << 
instead, the asset will be "converted" into something else or never 
cashed in. In other words, you want the increase in value to bypass 
income and go straight to equity. I'll give examples of both:


converted --- A "deferred annuity" (aka "retirement income" policy). The 
little policies received each year from the employer (as retirement 
benefit*) will be swapped for a single annuity by the carrier when you 
retire. They are cash value policies, so you COULD track their increase 
in value each year. The point here is that once converted no longer has 
a cash value as such << yes it has value, could be marketed --- AND for 
fair comparisons of equivalent net worth you MIGHT want to compute the 
"present value of an annuity" but you could not market it for anything 
like that fair worth. But leave that to somebody like me who knows how 
to use actuarial tables (including which to use for this) >>


never cashed in --- a small business, especially a family farm, might 
carry a "2nd death" policy on the owners. Again, not cashed in because 
the whole point of this is to have the policy face value (plus 
additions) available to buy out the shares of those heirs who will not 
be involved with continuing the business. Mutual partner insurance is 
similar (so the surviving partners can buy out the heirs of the deceased 
partner). The whole point of THIS kind of insurance is to allow the 
business to continue instead of having to be sold to satisfy the claims 
of heirs.


Michael D Novack

* In other words, a "defined contribution" plan which is probably more 
common these days than a "defined benefits pension" plan.



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

[Glenn Fowler]

No problem at all.

Maybe try downgrading to 4.9 to see if the issue persists or not to help
find where the problem is.

You can get previous versions here:
https://github.com/Gnucash/gnucash/releases


On Sun, May 8, 2022 at 6:01 PM Richard Clarkson 
wrote:

> Thanks Glenn
>
>
>
> That’s what I tried and it doesn’t open.
>
>
>
> Thanks for putting your thinking cap on.
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 21:01
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Your data file for your book which will be in the folder that you
> specified.
>
>
>
> Ex
>
> myfinances.gnucash
>
> vacationhome.gnucash
>
>
>
> On Sun, May 8, 2022, 1:00 PM Richard Clarkson 
> wrote:
>
> Glenn
>
>
>
> Can’t see anything called book file. Are you referring to GNUData.gnucash
> ? If so nothing opens.
>
>
>
> Thanks
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 16:34
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Ok try double clicking directly on your book file and see if it works.
>
>
>
> On Sun, May 8, 2022 at 11:16 AM Richard Clarkson <
> rtclark...@btinternet.com> wrote:
>
> Glenn
>
>
>
> When installing using the installer there was a message that GnuCash was
> open, so I closed GnuCash and clicked retry.
>
>
>
> Gnucash.exe didn’t work. I also tried via PowerShell and the GnuCash
> wasn’t found. I’ve tried in Admin mode too.
>
>
>
> I have uninstalled GnuCash and reinstalled and still have the same issue.
>
>
>
> Thanks for your help.
>
>
>
> Richard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* 08 May 2022 15:31
> *To:* Richard Clarkson 
> *Cc:* GnuCash users group 
> *Subject:* Re: [GNC] GnuCash 4.10
>
>
>
> Hi Richard,
>
>
>
> Do you get an error message?
>
> Did you install using the installer?
>
>
>
> On Sun, May 8, 2022, 9:40 AM Richard Clarkson via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> Have just updated from previous version to GnuCash 4.10 on Windows 11.
>
>
>
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
>
>
>
> Any idea how I can rectify this issue?
>
> Many thanks
>
>
>
> 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] Importing Accounts with non-English Characters

[viking2ev]

I downloaded v4.10, but the bug remains. It is still not possible to import 
*accounts* using a CSV file (encoded in UTF-8) with non-English characters.
Is there any workaround? I read in the bug report that importing a CSV file 
encoded in windows 1252 may work. However, I have no idea how to save my CSV 
file using Excel and windows 1252 encoding. 

-Original Message-
From: gnucash-user 
[mailto:gnucash-user-bounces+viking2ev=san.rr@gnucash.org] On Behalf Of 
viking
Sent: 16 March, 2021 01:32
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Importing Accounts with non-English Characters

Frank H. Ellenberger-3 wrote
> right, it is on the list:
> https://bugs.gnucash.org/show_bug.cgi?id=785860 - "Export Account Tree 
> to CSV" and "Import Accounts from CSV" should use the same dialogs as 
> "...Transactions..."
> 
> Am 16.03.21 um 09:09 schrieb viking:
>> However, there is no such option when importing *Accounts*.  

Quite an old bug from 2017. Is there a workaround to be able to import accounts 
with non-English characters?

I am also not able to /manually/ create a new account including non-English 
characters. For example, the letter "å" can be typed here by pressing 
"Alt-0229". However, it doesn't work when trying to type this letter in the 
Account name for a New Account. 
Is this another bug?




--
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] GnuCash 4.10

[davidcousens49]

Richard,

Just installed GnuCash 4.10 on my wife's Windows 11 laptop with no problems at
all using the msi installer from Sourceforge following the download link from
the GnuCash website. Starts, creates a new datafile and opens a copy of my
datafile from my Linux system without any problem.

It has to be something specific to your setup or a problem with the download.
Did you perhaps download the flatpak version and not have the flatpak setup. 
It will help if you can provide us details of which version you downloaded and
from whay site.

David Cousens

On Sun, 2022-05-08 at 14:40 +0100, Richard Clarkson via gnucash-user wrote:
> Have just updated from previous version to GnuCash 4.10 on Windows 11.
> 
>  
> 
> GnuCash now refuses to open (have tried from PowerShell too). I have tried
> reinstalling but no change.
> 
>  
> 
> Any idea how I can rectify this issue?
> 
> Many thanks
> 
>  
> 
> 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.

[GNC] Get Quotes hangs

[Fred Tydeman]

Linux: Fedora 35 64-bit
GnuCash 4.10
Finance::Quote 1.51
Online Quote: Alpha Vantage API key: has a value

gnc-fq-check: installed
gnc-fq-dump: installed
gnc-fq-helper: installed
gnc-fq-update: missing

gnucash
 Tools
  Price database
Get Quotes
gets me a spinning circle.

System Monitor shows
 CPU: 5%
 Memory: 7% used
 Swap: 0 bytes uses
 Network:  minimal

Clicking on the "X" in the top right corner of the Price database
window is ignored.  After a few seconds, get a popup about not
responding and do I want to Cancel or End process.

If I End process, both the Price database window and GnuCash window
exit.

If I restart GnuCash, I get a message about the lock cannot be
obtained.  I can force that with Open Anyway.
___
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 4.10

[David H]

What was your previously installed version - I know you said "from previous
version" but that is a little vague :-). If I remember correctly upgrading
from one of the versions took a little while to actually open a Gnucash
window first time in as it involved migrating preferences etc?

Cheers David H.

On Mon, 9 May 2022 at 12:06,  wrote:

> Richard,
>
> Just installed GnuCash 4.10 on my wife's Windows 11 laptop with no
> problems at
> all using the msi installer from Sourceforge following the download link
> from
> the GnuCash website. Starts, creates a new datafile and opens a copy of my
> datafile from my Linux system without any problem.
>
> It has to be something specific to your setup or a problem with the
> download.
> Did you perhaps download the flatpak version and not have the flatpak
> setup.
> It will help if you can provide us details of which version you downloaded
> and
> from whay site.
>
> David Cousens
>
> On Sun, 2022-05-08 at 14:40 +0100, Richard Clarkson via gnucash-user wrote:
> > Have just updated from previous version to GnuCash 4.10 on Windows 11.
> >
> >
> >
> > GnuCash now refuses to open (have tried from PowerShell too). I have
> tried
> > reinstalling but no change.
> >
> >
> >
> > Any idea how I can rectify this issue?
> >
> > Many thanks
> >
> >
> >
> > 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.
>
___
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 v 2.6.19 or newer on 32bit linux

[Jonathan Francoeur]

Hi David.  Thank you for asking.  I am using Linux Lite, Ubuntu 16.04 
and GNU Cash 2.6.12 on the older machine.  As far as I know, I can not 
install any newer version of Ubuntu on this 32bit machine.


Hi Adrien.  I'm kinda scared of attempting to build a newer version of 
GNU Cash without knowing that someone else has done so successfully.  
I'm not that good with computers and the list of dependencies looks 
daunting to me.  Thank you for your suggestions none the less.


On 3/25/22 4:25 AM, David T. via gnucash-user wrote:

I think it would be helpful to know a bit more about the versions of Gnucash on 
the two machines. The message he got was that he needed *at least* 2.6.19, not 
that he needed to use it.

Jonathan, does this imply that your older machine is running Ubuntu 16.04? The 
Gnucash wiki says that 16.04 had 2.6.12, while 18.04 had 2.6.19. The vintage of 
Ubuntu might affect your options here.

And if your older system has a version greater than 2.6.19 on it, something 
else has gone wrong, and more info would be needed.


On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone 
 wrote:

Caveat:

You can have some dependency issues on that old machine that might
prevent building the current version or using Flatpak.

I'd think you *should* be able to build 2.6.19 or 2.6.21 though. (2.6.21
was the last 2.6 version)

Please do report back what you are able to accomplish.

If nothing works, consider possibly using RDP or VNC to your 64bit
machine rather than a local install.

Regards,
Adrien

On 3/24/22 8:00 PM, Adrien Monteleone wrote:

Jonathan,

You should be able to build a current version of Gnucash on your 32bit
machine.

See the instructions here:

https://wiki.gnucash.org/wiki/Building

And you can update to current on your 64bit machine to match.

You might also be able to use the Flatpak if you don't want to build.
(I'd try that first)

Regards,
Adrien

On 3/23/22 2:52 AM, Jonathan Francoeur wrote:

I have my accounts in dropbox and I was using a newer version of GNU
cash on my 64bit computer.  Now I"m trying to use the files on my
older 32bit computer and I get the error:


This Dataset contains features not supported by this version of
GnuCash. You must use a newer version of GnuCash in order to support
the following features:
* Use account GUID as key for bayesian data and store KVP flat
(requires at least Gnucash 2.6.19)


I have not been able to install the Gnucash 2.6.19 from the tar.gz
files.  I'm used to using .deb files on following instructions by copy
pasting in to the terminal.  I haven't found anything like that for
installing a newer version on GNU cash on a 32bit linux machine.  Any
ideas?

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