Re: [GNC] Return of Capital

[cicko]

John Ralls-2 wrote
> That's an interesting way of handling an RoC. The only downside for those
> of us with different tax rates depending on how long we hold an investment
> is that it resets the purchase date, and if we're not paying attention
> might make one think at tax time that the $500 RoC was really a capital
> gain.

True. However, to shed some light here... The suggestion for the Return of
Capital transaction is related to ledger-cli. It tracks lot dates/tags
separately, which helps in calculation of the capital gains.
What I'm trying to do here is massage my GnuCash data to minimise the
adjustments necessary when I export the data.
The background is that I'm trying out ledger reporting (this is what it's
good at) on top of my GnuCash book. The start has not been smooth due to the
few cases with Return of Capital and Capital Gains, where $ amounts are
flowing from a commodity account. Once I resolve that, I would finally be
able to run some normal queries on top of the real data and hopefully
automate those with scripts.
So, if someone else is interested, piecash can export GC3 book in ledger
format fairly smoothly. But the differences in accounting methods must be
taken into consideration, as this case illustrates. I will try to make
scripts that make the necessary adjustments as a part of the export process.
I know this all may sound tedious but one look at the Scheme code makes it
all worthwhile. ;)

And now onto those capital gains records. :S



--
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] GnuCash V3.5 Not Used By My GnuCash Database

[Colin Law]

Just pointing out that the instructions say
"cd to your download folder (or where you have the above 3 files)"
which you didn't do the first time round.

Colin

On Fri, 19 Apr 2019 at 20:02, Lawrence Joy  wrote:
>
> A synopsis of what I did to get V3.5 loaded and working on my Ubuntu 18.04.1 
> LTS OS. The files:
> MyNamed.gnucash
> MyNamed.gnucash.20190304113239.log
> MyNamed.gnucash.20190304124553.log
> MyNamed.gnuchas.20190304124553.gnucash
> are in /home/larry and gnucash-3.5 is in /home/larry/Downloads.
>
> I downloaded the three files by Stephen Butler off of Google Drive.--Thanks 
> for that information as I had not seen it any other place before. Those three 
> files were put in /home/larry/Downloads. Per instructions I did 'sudo apt 
> install ./*_3.5_*.deb' in my /home/larry directory as that was where my 
> gnucash files were. It came back with:
> "Reading package lists... Done"
> "E: Unsupported file ./*_3.5_*.deb given on commandline"
>
> I then went to /home/larry/Downloads directory and entered the same thing. It 
> came back with
> "Reading package lists... Done"
> "Building dependency tree"
> "Reading state information... Done"
> "Note, selecting 'gnucash' instead of './gnucash_3.5_amd64.deb"
> "Note, selecting 'gnucash-common' instead of './gnucash-common_3.5_all.deb"
> "Note, selecting 'python3-gnucash' instead of 
> './python3-gnucash_3.5_amd64.deb"
> "Do you want to continue? [Y/n]" The three notes bothered me but I went ahead 
> and answered Y.
> It took about an hour and a half to do the download/programming.
>
> Now when I push the Super Key and then push G the gnucash icon shows up, 
> which I click on, and when I check Help>About it says its GnuCash V3.5. 
> Hurray!
>
> On the terminal I run 'which gnucash' and get back "usr/bin/gnucash".
> On the terminal I also run 'sudo dpkg -l | grep gnucash' and get back
> ii  gnucash1:3.5  
>amd64personal and small-business 
> financial-accounting software
> ii  gnucash-common 1:3.5  
>all  common files for the financial-accounting 
> software Gnucash
> ii  gnucash-docs   3.4-0+bionic~ppa1  
>all  Documentation for gnucash, a personal finance 
> tracking program
> ii  python3-gnucash1:3.5  
>amd64Gnucash interface for Python
>
> Everything seems to be okay now. Thanks for all your help.
> --Larry
>
> >I don?t know if you even had 3.4 installed unless you knew for a fact you 
> >were once running it. (If that is the case, you might have earlier removed 
> >2.6.19)
> **Yes, the Help>About said it was V3.4.
>
> >It looks like you downloaded the 3.5 source. (you mentioned it contained 
> >directories and files)
>
> >You can build from that source download using the wiki instructions, or use 
> >the pre-built deb packages as Colin suggests. If you choose not to build 
> >from source, you can safely delete that gnucash-3.5 directory.
> **I'm not a programmer so I stick to official released stuff.
>
> >Do not delete the files ending in .gnucash. The first one `MyNamed.gnucash` 
> >is your main data file. The last one 
> >`MyNamed.gnucash.20190304124553.gnucash` is a backup file. The other two are 
> >log files as their file extension suggests.
>
> >Keeping the logs and the backup is optional. Just don?t delete the main data 
> >file.
>
> >I would still run the dpkg -l command to make sure there are no other 
> >versions on your system before installing 3.5:
>
> >sudo dpkg -l | grep gnucash
>
> >(no response and a return to the command prompt means nothing else 
> >concerning gnucash is installed)
>
> >You can also perform a:
>
> >which gnucash
>
> >to see if the system thinks an executable with that name is located 
> >anywhere, but I don?t expect it will find anything.
>
> >Regards,
> >Adrien
>
___
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] I can't see above the current widow

[Geert Janssens]

Op woensdag 17 april 2019 11:24:51 CEST schreef Jonathan Silvey:
> For some reason, I cannot go above the top line of a window. I have been
> through the Preferences and Help pages without success.
> 
> Two possible clues are that the Accounts totals are correct, so the
> information is there somewhere. But when I add a Description which I have
> used many times before (but not in the current window), the Description is
> treated as though I’ve never used it before, ie I have to type the whole
> entry.
> 
> I use Gnucash 2.6.3 on Windows 10.

Please upgrade to at least gnucash 2.6.21 first. There have been a ton bug 
fixes since 2.6.3 which may fix your issue.

If that doesn't fix it we can try to dig deeper.

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] Cannot run v3 on Windows 7 since a year

[Geert Janssens]

Do you have other applications on your system that use guile (like Lilypond 
for example) ?

Regards,

Geert

Op donderdag 18 april 2019 13:26:08 CEST schreef Oliver Heidelbach via 
gnucash-user:
> I reinstalled the current version again to see the log.
> 
> It does not write any log file since the Visual C++ runtime pops with
> that error.
> 
> I don't know if this helps, but I tried to run guile.exe from the
> command line and this happened:
> 
> ###
> C:\Program Files (x86)\gnucash\bin>guile
> 
> Throw without catch before boot:
> Throw to key misc-error with args ("primitive-load-path" "Unable to find
> file ~S in load path" ("ice-9/boot-9") #f)Aborting.
> 
> This application has requested the Runtime to terminate it in an unusua
> Please contact the application's support team for more information.
> 
> 
> 
> If I run gnucash.exe from the command line, I get the same popup error
> message I have gotten before, containing the last part of the above
> error message.
> 
> Oliver
> 
> Am 09.04.2019 um 11:27 schrieb Colin Law:
> > Have a look in the gnucash trace file after you try to start it.
> > https://wiki.gnucash.org/wiki/Tracefile
> > 
> > Colin
> > 
> > On Tue, 9 Apr 2019 at 10:25, ohei2 via gnucash-user
> > 
> >  wrote:
> >> Hi,
> >> 
> >> I just tried to install v3.5 on my Win7 64bit. It installed and on the
> >> the
> >> first attempt to start it I get
> >> 
> >> /This application has requested the Runtime to terminate it in an unusual
> >> way. Please contact the application's support team for more information/
> >> 
> >> I also tried an uninstall and deleting the leftover directory like
> >> suggested in a similar thread. Same error message.
> >> 
> >> I did switch back to 2.6.21 which runs without any problems.
> >> 
> >> About one year ago I tried to install 3.0 which also would not run back
> >> then and switched back to the older version.
> >> 
> >> I am a bit clueless on how to proceed. Sitting it out does not seem to
> >> work
> >> obviously.
> >> 
> >> Regards, ohei2
> >> 
> >> 
> >> 
> >> 
> >> --
> >> 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.




___
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] retained earnings between two different financial periods

[mc]

Config:
gnucash 3.5 clean install.
(X)ubuntu Linux 18.04
gnucash files saved as sqlite.

Hi

I am new to gnucash and testing it.
Most things I have tried work as expected (and extremely well ;-)  )

One question: on the page:
www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html 


it states:
"GnuCash’s built-in reports automatically handle concepts
like retained earnings between two different financial periods"

However when I tested it
gnucash does NOT appear to separate retained earnings
between two different financial periods.

When I print a balance sheet report,
without closing the books,
I just get 1 net retained earnings number:
    Retained Earnings / Retained Losses
that includes the amounts from previous years.

The P&L for different years works as expected.

(after closing the books, the BS report also works as expected)

What have I missed?

thanks

mc

___
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] retained earnings between two different financial periods

[David Cousens]

mc,

The balance of Retained Earnings is a balance , i.e. the value of the sum of
all the credits minus the sum of all the debits to it up to a specific date
from whenever recording to the account started. When you close the income
and expense accounts to retained earnings you credit (add) the difference
between their sums (the value of retained earnings for the accounting
period) to the previous Retained Earnings account balance to get a new
total.

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] Entering paycheck details of Employer sponsored deductions

[Umakanth V S]

Hi All,

I have recently started using GnuCash to keep track of my personal
expenses. I find it to be a great software and am still learning its
features.  This is my first post and it pertains to entering details of
employer sponsored deductions from paycheck in GnuCash. I have read other
posts related to the subject of paycheck, but could not find any that
clarifies my doubts.

We have a scheme called PF (Provident Fund), in which some amount is
(mandatorily) deducted from the paycheck and credited to the PF. I can also
make an additional (voluntary) contribution. The employer contributes an
amount which also goes into this Fund. These contributions generate a
compounded interest. Details as follows:

Employee contrib (mandatory) = P
Employee contrib (voluntary) = Q
P+Q generates compound interest A
P+Q+A = balance of employee contribution

Employer contrib = R
R generates compound interest B
R+B = balance of employer contrib

All taken together (P+Q+A+R+B) gives the total balance outstanding in the
PF account.
I have created the account structure as follows:


Assets:PF
Assets:PF:Employee_contrib:Employee_contrib-mandatory
Assets:PF:Employee_contrib:Employee_contrib-voluntary
Assets:PF:Employer_contrib:Employer_contrib

I have created all above accounts as 'Bank' Account Type, because, if
required, I can take a loan from this PF account.

I have two issues:

1.  I want to create seperate accounts for Interest earned for my
contribution and employer contrib. I tried to do that as
Income:Interest-Employee_contrib and tried to place it under the
Assets:PF:Employee_contrib: location in the account tree. I am not able to
assign it as an Income type. The available types are Bank,Cash,Asset etc .
How do I do this or what category do I assign it?
I would like both the Interest accounts to be under Assets:PF (and not
under Income: )so that I can get a consolidated view of the complete PF
account.

2. How do I set up auto calculation of the compound interest A & B for both
the employee and employer contribution accounts?

Thanks in advance,
Umakanth
___
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] Cannot run v3 on Windows 7 since a year

[Jimmy R via gnucash-user]

I'm using Win 7 with no problem
If I recall correctly...and Im guessing here I had the same problem..its
been a while.
I had a one Visual C++ missing between releases. They *must *be installed in
sequential order.
If you have one missing in between I had to uninstall  the latter versions ,
install the missing one, then install the newer ones.

Attached image of my control panel installed V C++

 


Jimmy




--
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] Entering paycheck details of Employer sponsored deductions

[D via gnucash-user]

I track various such items on my own books. 

I probably wouldn't have separate accounts for the mandatory and the voluntary 
contributions; they are calculated as one. I would enter each contribution type 
as a separate split, though. That's how I've done it myself.

For what it's worth, I enter employer contributions as separate income 
transactions; that way, I end up with a clear sense of the overall activity. I 
have an income account for employer contributions to keep them isolated.

In my accounts, I have all of this in one asset account. As I see it, the 
interest on your P+Q, when added to the interest on your R, is the same as the 
interest on P+Q+R, unless the rates are different.

Interest is income; you might as well get used to it. Interest accrued will be 
entered as income, going into the asset account. 

David

On April 20, 2019, at 3:37 PM, Umakanth V S  wrote:

Hi All,

I have recently started using GnuCash to keep track of my personal
expenses. I find it to be a great software and am still learning its
features.  This is my first post and it pertains to entering details of
employer sponsored deductions from paycheck in GnuCash. I have read other
posts related to the subject of paycheck, but could not find any that
clarifies my doubts.

We have a scheme called PF (Provident Fund), in which some amount is
(mandatorily) deducted from the paycheck and credited to the PF. I can also
make an additional (voluntary) contribution. The employer contributes an
amount which also goes into this Fund. These contributions generate a
compounded interest. Details as follows:

Employee contrib (mandatory) = P
Employee contrib (voluntary) = Q
P+Q generates compound interest A
P+Q+A = balance of employee contribution

Employer contrib = R
R generates compound interest B
R+B = balance of employer contrib

All taken together (P+Q+A+R+B) gives the total balance outstanding in the
PF account.
I have created the account structure as follows:


Assets:PF
Assets:PF:Employee_contrib:Employee_contrib-mandatory
Assets:PF:Employee_contrib:Employee_contrib-voluntary
Assets:PF:Employer_contrib:Employer_contrib

I have created all above accounts as 'Bank' Account Type, because, if
required, I can take a loan from this PF account.

I have two issues:

1.  I want to create seperate accounts for Interest earned for my
contribution and employer contrib. I tried to do that as
Income:Interest-Employee_contrib and tried to place it under the
Assets:PF:Employee_contrib: location in the account tree. I am not able to
assign it as an Income type. The available types are Bank,Cash,Asset etc .
How do I do this or what category do I assign it?
I would like both the Interest accounts to be under Assets:PF (and not
under Income: )so that I can get a consolidated view of the complete PF
account.

2. How do I set up auto calculation of the compound interest A & B for both
the employee and employer contribution accounts?

Thanks in advance,
Umakanth
___
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] Unexpected behaviour of locking mechanis

[mc]

Config:
gnucash 3.5 clean install.
(X)ubuntu Linux 18.04
gnucash files saved as sqlite.

Am new to gnucash and testing it.

I keep several versions of a gnucash file,
saved with names like --.gnucash

After cleanly exiting gnucash by a normal Quit,,
I may try to open an earlier saved version.
I frequently get the message:

GnuCash could not obtain a lock for .../.gnucash
the database may be in use by another user, in which case you should not 
open the database.

What would you like to do?
open read only / create new file / open anyway / quit

I have checked that gnucash is not running,
and there is no lock file to be found.
I open it anyway, and it is without problems,
other than my tabs have disappeared and there is only the default 
"Accounts" tab.


In fact there is no .LCK file even when gnucash has a file opened.

So:
a.  has gnucash changed the locking mechanism in v3
or do sqlite files not use a locking mechanism?

b.  is there a possible issue with this locking mechanism?

thanks
mc
___
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] Entering paycheck details of Employer sponsored deductions

[D via gnucash-user]

Sorry. I didn't really answer your second question.

First question, why do you need to calculate the two interest figures 
separately? Does the fund manager do this?

As for calculating interest, you will find it fraught with difficulty. The 
likelihood that your calculations will match the institution's every time is 
extremely low. I gave up on that long ago, and instead enter such information 
from the statement.

David

On April 20, 2019, at 6:27 PM, D via gnucash-user  
wrote:

I track various such items on my own books. 

I probably wouldn't have separate accounts for the mandatory and the voluntary 
contributions; they are calculated as one. I would enter each contribution type 
as a separate split, though. That's how I've done it myself.

For what it's worth, I enter employer contributions as separate income 
transactions; that way, I end up with a clear sense of the overall activity. I 
have an income account for employer contributions to keep them isolated.

In my accounts, I have all of this in one asset account. As I see it, the 
interest on your P+Q, when added to the interest on your R, is the same as the 
interest on P+Q+R, unless the rates are different.

Interest is income; you might as well get used to it. Interest accrued will be 
entered as income, going into the asset account. 

David

On April 20, 2019, at 3:37 PM, Umakanth V S  wrote:

Hi All,

I have recently started using GnuCash to keep track of my personal
expenses. I find it to be a great software and am still learning its
features.  This is my first post and it pertains to entering details of
employer sponsored deductions from paycheck in GnuCash. I have read other
posts related to the subject of paycheck, but could not find any that
clarifies my doubts.

We have a scheme called PF (Provident Fund), in which some amount is
(mandatorily) deducted from the paycheck and credited to the PF. I can also
make an additional (voluntary) contribution. The employer contributes an
amount which also goes into this Fund. These contributions generate a
compounded interest. Details as follows:

Employee contrib (mandatory) = P
Employee contrib (voluntary) = Q
P+Q generates compound interest A
P+Q+A = balance of employee contribution

Employer contrib = R
R generates compound interest B
R+B = balance of employer contrib

All taken together (P+Q+A+R+B) gives the total balance outstanding in the
PF account.
I have created the account structure as follows:


Assets:PF
Assets:PF:Employee_contrib:Employee_contrib-mandatory
Assets:PF:Employee_contrib:Employee_contrib-voluntary
Assets:PF:Employer_contrib:Employer_contrib

I have created all above accounts as 'Bank' Account Type, because, if
required, I can take a loan from this PF account.

I have two issues:

1.  I want to create seperate accounts for Interest earned for my
contribution and employer contrib. I tried to do that as
Income:Interest-Employee_contrib and tried to place it under the
Assets:PF:Employee_contrib: location in the account tree. I am not able to
assign it as an Income type. The available types are Bank,Cash,Asset etc .
How do I do this or what category do I assign it?
I would like both the Interest accounts to be under Assets:PF (and not
under Income: )so that I can get a consolidated view of the complete PF
account.

2. How do I set up auto calculation of the compound interest A & B for both
the employee and employer contribution accounts?

Thanks in advance,
Umakanth
___
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] retained earnings between two different financial periods

[mc]

Thanks David

yes, I do understand that.
I had misunderstood the meaning of
"built-in reports automatically handle concepts like retained earnings 
between two different financial periods"
to mean on the BS it would separately show prior years' retained 
earnings and current year-to-date profit"

But as I think about your answer, I realise that would be unusual.
The current year's profit is only shown separately on the P&L,
and that is what the sentence from the documentation means.

mc

(I hope this method of replying works
 - I didn't get an email with your reply in it to reply to)

--

mc,

The balance of Retained Earnings is a balance , i.e. the value of the sum of
all the credits minus the sum of all the debits to it up to a specific date
from whenever recording to the account started. When you close the income
and expense accounts to retained earnings you credit (add) the difference
between their sums (the value of retained earnings for the accounting
period) to the previous Retained Earnings account balance to get a new
total.

David Cousens
___
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] Entering paycheck details of Employer sponsored deductions

[David Carlson]

Umakanth,

Income (and Expense) accounts always need to be under the Income or
Expense  top account.  The only way to associate them to assets or
liabilities is to have similar names.  I normally name them with the base
name first, then some significant detail then end with Interest or whatever
is best description. I also avoid spaces or punctuation in account names.
I am sure David T uses his own method to do the same thing.

David Carlson

On Sat, Apr 20, 2019 at 8:11 AM D via gnucash-user 
wrote:

> Sorry. I didn't really answer your second question.
>
> First question, why do you need to calculate the two interest figures
> separately? Does the fund manager do this?
>
> As for calculating interest, you will find it fraught with difficulty. The
> likelihood that your calculations will match the institution's every time
> is extremely low. I gave up on that long ago, and instead enter such
> information from the statement.
>
> David
>
> On April 20, 2019, at 6:27 PM, D via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> I track various such items on my own books.
>
> I probably wouldn't have separate accounts for the mandatory and the
> voluntary contributions; they are calculated as one. I would enter each
> contribution type as a separate split, though. That's how I've done it
> myself.
>
> For what it's worth, I enter employer contributions as separate income
> transactions; that way, I end up with a clear sense of the overall
> activity. I have an income account for employer contributions to keep them
> isolated.
>
> In my accounts, I have all of this in one asset account. As I see it, the
> interest on your P+Q, when added to the interest on your R, is the same as
> the interest on P+Q+R, unless the rates are different.
>
> Interest is income; you might as well get used to it. Interest accrued
> will be entered as income, going into the asset account.
>
> David
>
> On April 20, 2019, at 3:37 PM, Umakanth V S  wrote:
>
> Hi All,
>
> I have recently started using GnuCash to keep track of my personal
> expenses. I find it to be a great software and am still learning its
> features.  This is my first post and it pertains to entering details of
> employer sponsored deductions from paycheck in GnuCash. I have read other
> posts related to the subject of paycheck, but could not find any that
> clarifies my doubts.
>
> We have a scheme called PF (Provident Fund), in which some amount is
> (mandatorily) deducted from the paycheck and credited to the PF. I can also
> make an additional (voluntary) contribution. The employer contributes an
> amount which also goes into this Fund. These contributions generate a
> compounded interest. Details as follows:
>
> Employee contrib (mandatory) = P
> Employee contrib (voluntary) = Q
> P+Q generates compound interest A
> P+Q+A = balance of employee contribution
>
> Employer contrib = R
> R generates compound interest B
> R+B = balance of employer contrib
>
> All taken together (P+Q+A+R+B) gives the total balance outstanding in the
> PF account.
> I have created the account structure as follows:
>
>
> Assets:PF
> Assets:PF:Employee_contrib:Employee_contrib-mandatory
> Assets:PF:Employee_contrib:Employee_contrib-voluntary
> Assets:PF:Employer_contrib:Employer_contrib
>
> I have created all above accounts as 'Bank' Account Type, because, if
> required, I can take a loan from this PF account.
>
> I have two issues:
>
> 1.  I want to create seperate accounts for Interest earned for my
> contribution and employer contrib. I tried to do that as
> Income:Interest-Employee_contrib and tried to place it under the
> Assets:PF:Employee_contrib: location in the account tree. I am not able to
> assign it as an Income type. The available types are Bank,Cash,Asset etc .
> How do I do this or what category do I assign it?
> I would like both the Interest accounts to be under Assets:PF (and not
> under Income: )so that I can get a consolidated view of the complete PF
> account.
>
> 2. How do I set up auto calculation of the compound interest A & B for both
> the employee and employer contribution accounts?
>
> Thanks in advance,
> Umakanth
> ___
> 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.

Re: [GNC] retained earnings between two different financial periods

[John Ralls]

> On Apr 20, 2019, at 2:33 AM, mc  wrote:
> 
> Config:
> gnucash 3.5 clean install.
> (X)ubuntu Linux 18.04
> gnucash files saved as sqlite.
> 
> Hi
> 
> I am new to gnucash and testing it.
> Most things I have tried work as expected (and extremely well ;-)  )
> 
> One question: on the page:
> www.gnucash.org/docs/v3/C/gnucash-help/tool-close-book.html 
> 
> it states:
> "GnuCash’s built-in reports automatically handle concepts
> like retained earnings between two different financial periods"
> 
> However when I tested it
> gnucash does NOT appear to separate retained earnings
> between two different financial periods.
> 
> When I print a balance sheet report,
> without closing the books,
> I just get 1 net retained earnings number:
> Retained Earnings / Retained Losses
> that includes the amounts from previous years.
> 
> The P&L for different years works as expected.
> 
> (after closing the books, the BS report also works as expected)
> 
> What have I missed?

The Balance Sheet report calculates a "Retained Earnings" line as a "virtual" 
top-level account if it finds balances in the accounts of type Income or 
Expense, the balance being the net value of those accounts, i.e. total income - 
total expenses.

If you've previously closed your books to an account named Retained Earnings 
(which you'd normally put under an Equity top-level placeholder account) then 
it will show that balance too. So if you close your books at the end of each 
period and then run the balance sheet some time later you'll have two Retained 
Earnings lines: One for when you last closed and one for the transactions since 
then.

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] Unexpected behaviour of locking mechanis

[Adrien Monteleone]

Good question,

I use SQLite3 also, and there are no .LCK files in my data directory. (they 
might be placed elsewhere as I’m on MacOS)

But I’ve never had an issue opening other files than my current one.

The only thing I noticed was that you mentioned you cleanly exited before 
opening one of the older files. Did you cleanly exit when that older file was 
originally current? If not, then that would be why the lock is still active for 
it. (however the lock is implemented)

Regards,
Adrien

> On Apr 20, 2019, at 7:58 AM, mc  wrote:
> 
> Config:
> gnucash 3.5 clean install.
> (X)ubuntu Linux 18.04
> gnucash files saved as sqlite.
> 
> Am new to gnucash and testing it.
> 
> I keep several versions of a gnucash file,
> saved with names like --.gnucash
> 
> After cleanly exiting gnucash by a normal Quit,,
> I may try to open an earlier saved version.
> I frequently get the message:
> 
> GnuCash could not obtain a lock for .../.gnucash
> the database may be in use by another user, in which case you should not open 
> the database.
> What would you like to do?
> open read only / create new file / open anyway / quit
> 
> I have checked that gnucash is not running,
> and there is no lock file to be found.
> I open it anyway, and it is without problems,
> other than my tabs have disappeared and there is only the default "Accounts" 
> tab.
> 
> In fact there is no .LCK file even when gnucash has a file opened.
> 
> So:
> a.  has gnucash changed the locking mechanism in v3
> or do sqlite files not use a locking mechanism?
> 
> b.  is there a possible issue with this locking mechanism?
> 
> thanks
> mc

___
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] Unexpected behaviour of locking mechanis

[John Ralls]

> On Apr 20, 2019, at 5:58 AM, mc  wrote:
> 
> Config:
> gnucash 3.5 clean install.
> (X)ubuntu Linux 18.04
> gnucash files saved as sqlite.
> 
> Am new to gnucash and testing it.
> 
> I keep several versions of a gnucash file,
> saved with names like --.gnucash
> 
> After cleanly exiting gnucash by a normal Quit,,
> I may try to open an earlier saved version.
> I frequently get the message:
> 
> GnuCash could not obtain a lock for .../.gnucash
> the database may be in use by another user, in which case you should not open 
> the database.
> What would you like to do?
> open read only / create new file / open anyway / quit
> 
> I have checked that gnucash is not running,
> and there is no lock file to be found.
> I open it anyway, and it is without problems,
> other than my tabs have disappeared and there is only the default "Accounts" 
> tab.
> 
> In fact there is no .LCK file even when gnucash has a file opened.
> 
> So:
> a.  has gnucash changed the locking mechanism in v3
> or do sqlite files not use a locking mechanism?
> 
> b.  is there a possible issue with this locking mechanism?

The SQL locks are in a table inside the database, not in a separate file. The 
file will be locked if you didn't properly quit GnuCash the last time you had 
*that file* open.

The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
complete rewrite into C++ for GnuCash 3.x.

It's a computer program. Of course it's possible that there's a problem, and 
since you're doing something a bit different from what everyone else does you 
might be the first to have found it. How are you creating these "earlier saved 
versions"?

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] Unexpected behaviour of locking mechanis

[Adrien Monteleone]

I figured the lock was in the db, but wasn’t certain.

I just tested with my current data file:

Clean exit via GnuCash > Quit GnuCash
Copy & Rename file to `test-1234.gnucash`
Re-open GnuCash
File > Open > `test-1234.gnucash`

The file opened fine, save none of the open tabs from when I exited were 
re-opened. (doesn’t bother me any, and might even be intended behavior, but it 
confirms what mc found in that respect)

However, being on a Mac as you know I can't test double-clicking the renamed 
file to open it, if that is what mc is doing. Not sure if that is where the 
problem lies or if it was an un-clean shutdown after saving that other file as 
surmised.

Regards,
Adrien

> On Apr 20, 2019, at 9:53 AM, John Ralls  wrote:
> 
> 
> 
>> On Apr 20, 2019, at 5:58 AM, mc  wrote:
>> 
>> Config:
>> gnucash 3.5 clean install.
>> (X)ubuntu Linux 18.04
>> gnucash files saved as sqlite.
>> 
>> Am new to gnucash and testing it.
>> 
>> I keep several versions of a gnucash file,
>> saved with names like --.gnucash
>> 
>> After cleanly exiting gnucash by a normal Quit,,
>> I may try to open an earlier saved version.
>> I frequently get the message:
>> 
>> GnuCash could not obtain a lock for .../.gnucash
>> the database may be in use by another user, in which case you should not 
>> open the database.
>> What would you like to do?
>> open read only / create new file / open anyway / quit
>> 
>> I have checked that gnucash is not running,
>> and there is no lock file to be found.
>> I open it anyway, and it is without problems,
>> other than my tabs have disappeared and there is only the default "Accounts" 
>> tab.
>> 
>> In fact there is no .LCK file even when gnucash has a file opened.
>> 
>> So:
>> a.  has gnucash changed the locking mechanism in v3
>> or do sqlite files not use a locking mechanism?
>> 
>> b.  is there a possible issue with this locking mechanism?
> 
> The SQL locks are in a table inside the database, not in a separate file. The 
> file will be locked if you didn't properly quit GnuCash the last time you had 
> *that file* open.
> 
> The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
> complete rewrite into C++ for GnuCash 3.x.
> 
> It's a computer program. Of course it's possible that there's a problem, and 
> since you're doing something a bit different from what everyone else does you 
> might be the first to have found it. How are you creating these "earlier 
> saved versions"?
> 
> 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] Unexpected behaviour of locking mechanis

[Geert Janssens]

Op zaterdag 20 april 2019 17:08:02 CEST schreef Adrien Monteleone:
> I figured the lock was in the db, but wasn’t certain.
> 
> I just tested with my current data file:
> 
> Clean exit via GnuCash > Quit GnuCash
> Copy & Rename file to `test-1234.gnucash`
> Re-open GnuCash
> File > Open > `test-1234.gnucash`
> 
> The file opened fine, save none of the open tabs from when I exited were
> re-opened. (doesn’t bother me any, and might even be intended behavior, but
> it confirms what mc found in that respect)
> 
That is indeed normal. The state of the open tabs and such is saved in an 
independent state file, linked to the data file by its filename. If you change 
this filename outside of gnucash, gnucash won't be able to link it back to 
that state file.

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] Unexpected behaviour of locking mechanis

[mc]

Thanks John

The SQL locks are in a table inside the database, not in a separate file"
That would mean there is one for each gnucash file.  Good to know.

"How are you creating these "earlier saved versions""
Just with "save as".
Then I do some more changes, then do another "save as" with a higher 
version number.
So in one long session, I may have several earlier versions with diff 
version numbers.


eg:
Lets call the files I have created in the session v0, v1, v2, v3.
I initially open v0, then (say) 1 hour later do save as v1,
another hour later save as v2, later save as v3, etc.

So the likely answer is:
as the lock is inside the database,
doing a new "Save As" to create v1
doesn't release the lock on the older, now superseded v0.
Then save as v2, doesnt release the lock on v1, etc.
So at the end of the session, I quit while v3 is open,
and only the lock on v3 is released.

But, v0, v1, v2 all still have locks inside their database.

So "save as" doesnt release locks on earlier versions used in the session,
Also, "Quit" also only releases the lock on the current file,
not the earlier versions used in this session.

So to release the locks
(if that were useful)
would have to go back and open, then Quit from each earlier version.

Thanks for your guidance.

mc


On 20/04/2019 22.53, John Ralls wrote:



On Apr 20, 2019, at 5:58 AM, mc  wrote:

Config:
gnucash 3.5 clean install.
(X)ubuntu Linux 18.04
gnucash files saved as sqlite.

Am new to gnucash and testing it.

I keep several versions of a gnucash file,
saved with names like --.gnucash

After cleanly exiting gnucash by a normal Quit,,
I may try to open an earlier saved version.
I frequently get the message:

GnuCash could not obtain a lock for .../.gnucash
the database may be in use by another user, in which case you should not open 
the database.
What would you like to do?
open read only / create new file / open anyway / quit

I have checked that gnucash is not running,
and there is no lock file to be found.
I open it anyway, and it is without problems,
other than my tabs have disappeared and there is only the default "Accounts" 
tab.

In fact there is no .LCK file even when gnucash has a file opened.

So:
a.  has gnucash changed the locking mechanism in v3
or do sqlite files not use a locking mechanism?

b.  is there a possible issue with this locking mechanism?

The SQL locks are in a table inside the database, not in a separate file. The 
file will be locked if you didn't properly quit GnuCash the last time you had 
*that file* open.

The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
complete rewrite into C++ for GnuCash 3.x.

It's a computer program. Of course it's possible that there's a problem, and since you're 
doing something a bit different from what everyone else does you might be the first to 
have found it. How are you creating these "earlier saved versions"?

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] Unexpected behaviour of locking mechanis

[mc]

Geert

I assume the state files are the .gcm files in
~/.local/share/gnucash/

But,
I never change the names of the underlying files,
yet still, frequently when I open a previous version,
I will lose the tabs, nd just get the default "Accounts" tab.

Was just trying to test it to see if I could establish a pattern as to 
when it happened,

but haven't succeeded yet.

mc


On 20/04/2019 23.12, Geert Janssens wrote:

Op zaterdag 20 april 2019 17:08:02 CEST schreef Adrien Monteleone:

I figured the lock was in the db, but wasn’t certain.

I just tested with my current data file:

Clean exit via GnuCash > Quit GnuCash
Copy & Rename file to `test-1234.gnucash`
Re-open GnuCash
File > Open > `test-1234.gnucash`

The file opened fine, save none of the open tabs from when I exited were
re-opened. (doesn’t bother me any, and might even be intended behavior, but
it confirms what mc found in that respect)


That is indeed normal. The state of the open tabs and such is saved in an
independent state file, linked to the data file by its filename. If you change
this filename outside of gnucash, gnucash won't be able to link it back to
that state file.

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.


___
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] Unexpected behaviour of locking mechanis

[Colin Law]

I thought I would try this with 3.5 on Ubuntu 18.10.  Using Save As
repeatedly to sqlite3 does not result in locked files. I can go back
and open the previous versions without issue.

However, when saving to sqlite, which I don't normally, I do see in
the trace file
* 16:43:29 ERROR  [error_handler()] DBI error: 19:
UNIQUE constraint failed: books.guid
* 16:43:29 ERROR 
[GncDbiSqlConnection::execute_nonselect_statement()] Error executing
SQL INSERT INTO books(guid,root_account_guid,root_template_guid)
VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
* 16:43:29 ERROR 
[GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
books(guid,root_account_guid,root_template_guid)
VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
* 16:43:29 ERROR  [commit_err()] Failed to commit: 17

Whether that is a serious issue I don't know.

Colin

On Sat, 20 Apr 2019 at 16:20, mc  wrote:
>
> Thanks John
>
> The SQL locks are in a table inside the database, not in a separate file"
> That would mean there is one for each gnucash file.  Good to know.
>
> "How are you creating these "earlier saved versions""
> Just with "save as".
> Then I do some more changes, then do another "save as" with a higher
> version number.
> So in one long session, I may have several earlier versions with diff
> version numbers.
>
> eg:
> Lets call the files I have created in the session v0, v1, v2, v3.
> I initially open v0, then (say) 1 hour later do save as v1,
> another hour later save as v2, later save as v3, etc.
>
> So the likely answer is:
> as the lock is inside the database,
> doing a new "Save As" to create v1
> doesn't release the lock on the older, now superseded v0.
> Then save as v2, doesnt release the lock on v1, etc.
> So at the end of the session, I quit while v3 is open,
> and only the lock on v3 is released.
>
> But, v0, v1, v2 all still have locks inside their database.
>
> So "save as" doesnt release locks on earlier versions used in the session,
> Also, "Quit" also only releases the lock on the current file,
> not the earlier versions used in this session.
>
> So to release the locks
> (if that were useful)
> would have to go back and open, then Quit from each earlier version.
>
> Thanks for your guidance.
>
> mc
>
>
> On 20/04/2019 22.53, John Ralls wrote:
> >
> >> On Apr 20, 2019, at 5:58 AM, mc  wrote:
> >>
> >> Config:
> >> gnucash 3.5 clean install.
> >> (X)ubuntu Linux 18.04
> >> gnucash files saved as sqlite.
> >>
> >> Am new to gnucash and testing it.
> >>
> >> I keep several versions of a gnucash file,
> >> saved with names like --.gnucash
> >>
> >> After cleanly exiting gnucash by a normal Quit,,
> >> I may try to open an earlier saved version.
> >> I frequently get the message:
> >>
> >> GnuCash could not obtain a lock for .../.gnucash
> >> the database may be in use by another user, in which case you should not 
> >> open the database.
> >> What would you like to do?
> >> open read only / create new file / open anyway / quit
> >>
> >> I have checked that gnucash is not running,
> >> and there is no lock file to be found.
> >> I open it anyway, and it is without problems,
> >> other than my tabs have disappeared and there is only the default 
> >> "Accounts" tab.
> >>
> >> In fact there is no .LCK file even when gnucash has a file opened.
> >>
> >> So:
> >> a.  has gnucash changed the locking mechanism in v3
> >> or do sqlite files not use a locking mechanism?
> >>
> >> b.  is there a possible issue with this locking mechanism?
> > The SQL locks are in a table inside the database, not in a separate file. 
> > The file will be locked if you didn't properly quit GnuCash the last time 
> > you had *that file* open.
> >
> > The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
> > complete rewrite into C++ for GnuCash 3.x.
> >
> > It's a computer program. Of course it's possible that there's a problem, 
> > and since you're doing something a bit different from what everyone else 
> > does you might be the first to have found it. How are you creating these 
> > "earlier saved versions"?
> >
> > 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.
___
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

Re: [GNC] Assets don't display in CasgFlow report

[Ron Eggler]

Hi Adrien,

Thanks for your response!

>
> Edit your report options to include the accounts you want. There is an
> ‘Accounts’ tab where you make the selection.
>

I have selected them and they do show up in the "Selected Accounts" list
only there's no number amount to the right of the name.

>
> Be mindful of the account depth setting as well.
>

 Yes, I've set that to 3 (to include the accounts I need)

>
> Note, of course, the accounts in question have to have transactions during
> the same period as the report in order to show up.
>

If I do click onto the link in the "Selected Accounts" list, it will take
me to the account and display transactions as recorded within the selected
period but still, I see no number displayed to the right - mind this is
just for Assets, Money In & Money Out looks correct.

Ron


>
> > On Apr 19, 2019, at 4:52 PM, Ron Eggler  wrote:
> >
> > Hi,
> > GnuCash newbie here, sorry if the answer to my question is obvious.
> > When I create a Cash Flow report, Money In & Money Out seems to display
> > properly but the Assets don't. In accounts, I have some "Bank"-Type
> > accounts under "Asset".
> > My assets kind of look like (the account Type is in []):
> > Assets [Asset]
> >   Deposits in Can banks/instit - Can currency [Asset[
> >account1 [Bank]
> >account2 [Bank]
> >Deposit in Can banks/instit - Foreign currency
> >account1 (USD) [Bank]
> >account2 (USD) [Bank]
> >
> > why would this not work as expected and show up in the report
> accordingly?
> > And more importantly, how can I make my assets show up?
> >
> > Thanks a lot!
> > Ron
>
> ___
> 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] Assets don't display in CasgFlow report

[Adrien Monteleone]

Ron,

I think I might understand now what you are describing.

There are three sections to the report:

1. Selected Accounts
2. Money into selected accounts comes from
3. Money out of selected accounts goes to

#1 is just a list - no figures

The actual ‘report’ is sections #2 & #3. Some of those *might* be asset 
accounts and the should show amounts when they appear in those two sections. If 
they are not, then you have other problems. (they shouldn’t even show up at all 
if no activity occurred with them)

If you want to see the value of your assets, run a Balance Sheet.

Hope that helps.

Regards,
Adrien


> On Apr 20, 2019, at 1:20 PM, Ron Eggler  wrote:
> 
> Hi Adrien,
> 
> Thanks for your response!
> 
> Edit your report options to include the accounts you want. There is an 
> ‘Accounts’ tab where you make the selection.
> 
> I have selected them and they do show up in the "Selected Accounts" list only 
> there's no number amount to the right of the name.
> 
> Be mindful of the account depth setting as well.
> 
>  Yes, I've set that to 3 (to include the accounts I need)
> 
> Note, of course, the accounts in question have to have transactions during 
> the same period as the report in order to show up.
> 
> If I do click onto the link in the "Selected Accounts" list, it will take me 
> to the account and display transactions as recorded within the selected 
> period but still, I see no number displayed to the right - mind this is just 
> for Assets, Money In & Money Out looks correct.
> 
> Ron
> 
> 
> 
> > On Apr 19, 2019, at 4:52 PM, Ron Eggler  wrote:
> > 
> > Hi,
> > GnuCash newbie here, sorry if the answer to my question is obvious.
> > When I create a Cash Flow report, Money In & Money Out seems to display
> > properly but the Assets don't. In accounts, I have some "Bank"-Type
> > accounts under "Asset".
> > My assets kind of look like (the account Type is in []):
> > Assets [Asset]
> >   Deposits in Can banks/instit - Can currency [Asset[
> >account1 [Bank]
> >account2 [Bank]
> >Deposit in Can banks/instit - Foreign currency
> >account1 (USD) [Bank]
> >account2 (USD) [Bank]
> > 
> > why would this not work as expected and show up in the report accordingly?
> > And more importantly, how can I make my assets show up?
> > 
> > Thanks a lot!
> > Ron

___
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] Assets don't display in CasgFlow report

[Ron Eggler]

On Sat, Apr 20, 2019 at 12:58 PM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Ron,
>
> I think I might understand now what you are describing.
>
> There are three sections to the report:
>
> 1. Selected Accounts
> 2. Money into selected accounts comes from
> 3. Money out of selected accounts goes to
>
> #1 is just a list - no figures
>
> The actual ‘report’ is sections #2 & #3. Some of those *might* be asset
> accounts and the should show amounts when they appear in those two
> sections. If they are not, then you have other problems. (they shouldn’t
> even show up at all if no activity occurred with them)
>
> If you want to see the value of your assets, run a Balance Sheet.
>

h okay, Got it!  Great (y) - makes sense - as I said, I'm a newbie ;)


> Hope that helps.
>

It did, Thanks a lot! :)

Ron

> On Apr 20, 2019, at 1:20 PM, Ron Eggler  wrote:
> >
> > Hi Adrien,
> >
> > Thanks for your response!
> >
> > Edit your report options to include the accounts you want. There is an
> ‘Accounts’ tab where you make the selection.
> >
> > I have selected them and they do show up in the "Selected Accounts" list
> only there's no number amount to the right of the name.
> >
> > Be mindful of the account depth setting as well.
> >
> >  Yes, I've set that to 3 (to include the accounts I need)
> >
> > Note, of course, the accounts in question have to have transactions
> during the same period as the report in order to show up.
> >
> > If I do click onto the link in the "Selected Accounts" list, it will
> take me to the account and display transactions as recorded within the
> selected period but still, I see no number displayed to the right - mind
> this is just for Assets, Money In & Money Out looks correct.
> >
> > Ron
> >
> >
> >
> > > On Apr 19, 2019, at 4:52 PM, Ron Eggler  wrote:
> > >
> > > Hi,
> > > GnuCash newbie here, sorry if the answer to my question is obvious.
> > > When I create a Cash Flow report, Money In & Money Out seems to display
> > > properly but the Assets don't. In accounts, I have some "Bank"-Type
> > > accounts under "Asset".
> > > My assets kind of look like (the account Type is in []):
> > > Assets [Asset]
> > >   Deposits in Can banks/instit - Can currency [Asset[
> > >account1 [Bank]
> > >account2 [Bank]
> > >Deposit in Can banks/instit - Foreign currency
> > >account1 (USD) [Bank]
> > >account2 (USD) [Bank]
> > >
> > > why would this not work as expected and show up in the report
> accordingly?
> > > And more importantly, how can I make my assets show up?
> > >
> > > Thanks a lot!
> > > Ron
>
> ___
> 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] Register / Accounts page Footer CSS

[Jimmy R via gnucash-user]

I guess you can call it the footer, looking for the css to alter size, font,
& colors
I have been through all the wiki, and I have adjusted the gtk css for the
register but cannot find the footer styling. there is only one adjustment in
preferences > general for negative red value checkbox


Accounts: S,Grand Total, Net Assets, Profits, & negative value color

Transactions register: Present, Future, Cleared, Reconciled, Projected
Minimum,  & negative value color

Jimmy



--
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] Unexpected behaviour of locking mechanis

[John Ralls]

Colin,

Maybe a problem with your book. I just did the same exercise (stepping in the 
debugger to make sure that everything was getting called in the right places, 
it is) and didn't get any such errors.

Regards,
John Ralls


> On Apr 20, 2019, at 8:49 AM, Colin Law  wrote:
> 
> I thought I would try this with 3.5 on Ubuntu 18.10.  Using Save As
> repeatedly to sqlite3 does not result in locked files. I can go back
> and open the previous versions without issue.
> 
> However, when saving to sqlite, which I don't normally, I do see in
> the trace file
> * 16:43:29 ERROR  [error_handler()] DBI error: 19:
> UNIQUE constraint failed: books.guid
> * 16:43:29 ERROR 
> [GncDbiSqlConnection::execute_nonselect_statement()] Error executing
> SQL INSERT INTO books(guid,root_account_guid,root_template_guid)
> VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
> * 16:43:29 ERROR 
> [GncSqlBackend::execute_nonselect_statement()] SQL error: INSERT INTO
> books(guid,root_account_guid,root_template_guid)
> VALUES('2e45bf75396f1f5d2c459c4bb687b8da','f70697860ee4e46e92997a700eb37f1c','b4415e84471d47e166dd9d00f5293faf')
> * 16:43:29 ERROR  [commit_err()] Failed to commit: 17
> 
> Whether that is a serious issue I don't know.
> 
> Colin
> 
> On Sat, 20 Apr 2019 at 16:20, mc  wrote:
>> 
>> Thanks John
>> 
>> The SQL locks are in a table inside the database, not in a separate file"
>> That would mean there is one for each gnucash file.  Good to know.
>> 
>> "How are you creating these "earlier saved versions""
>> Just with "save as".
>> Then I do some more changes, then do another "save as" with a higher
>> version number.
>> So in one long session, I may have several earlier versions with diff
>> version numbers.
>> 
>> eg:
>> Lets call the files I have created in the session v0, v1, v2, v3.
>> I initially open v0, then (say) 1 hour later do save as v1,
>> another hour later save as v2, later save as v3, etc.
>> 
>> So the likely answer is:
>> as the lock is inside the database,
>> doing a new "Save As" to create v1
>> doesn't release the lock on the older, now superseded v0.
>> Then save as v2, doesnt release the lock on v1, etc.
>> So at the end of the session, I quit while v3 is open,
>> and only the lock on v3 is released.
>> 
>> But, v0, v1, v2 all still have locks inside their database.
>> 
>> So "save as" doesnt release locks on earlier versions used in the session,
>> Also, "Quit" also only releases the lock on the current file,
>> not the earlier versions used in this session.
>> 
>> So to release the locks
>> (if that were useful)
>> would have to go back and open, then Quit from each earlier version.
>> 
>> Thanks for your guidance.
>> 
>> mc
>> 
>> 
>> On 20/04/2019 22.53, John Ralls wrote:
>>> 
 On Apr 20, 2019, at 5:58 AM, mc  wrote:
 
 Config:
 gnucash 3.5 clean install.
 (X)ubuntu Linux 18.04
 gnucash files saved as sqlite.
 
 Am new to gnucash and testing it.
 
 I keep several versions of a gnucash file,
 saved with names like --.gnucash
 
 After cleanly exiting gnucash by a normal Quit,,
 I may try to open an earlier saved version.
 I frequently get the message:
 
 GnuCash could not obtain a lock for .../.gnucash
 the database may be in use by another user, in which case you should not 
 open the database.
 What would you like to do?
 open read only / create new file / open anyway / quit
 
 I have checked that gnucash is not running,
 and there is no lock file to be found.
 I open it anyway, and it is without problems,
 other than my tabs have disappeared and there is only the default 
 "Accounts" tab.
 
 In fact there is no .LCK file even when gnucash has a file opened.
 
 So:
 a.  has gnucash changed the locking mechanism in v3
 or do sqlite files not use a locking mechanism?
 
 b.  is there a possible issue with this locking mechanism?
>>> The SQL locks are in a table inside the database, not in a separate file. 
>>> The file will be locked if you didn't properly quit GnuCash the last time 
>>> you had *that file* open.
>>> 
>>> The locking mechanism itself hasn't changed, but the SQL/DBI backend got a 
>>> complete rewrite into C++ for GnuCash 3.x.
>>> 
>>> It's a computer program. Of course it's possible that there's a problem, 
>>> and since you're doing something a bit different from what everyone else 
>>> does you might be the first to have found it. How are you creating these 
>>> "earlier saved versions"?
>>> 
>>> 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.
>> -
>>