Re: Transaction Report - Subtotaling on Description? (Based on Previous Threads)

[aegross]

dadinva wrote
> The new version of the transaction report I posted has a check box named
> "composite".   

Thanks Dougwhere do we find the new report?

AEG



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash on ArchLinux

[B. Dielhenn]

As the error message indicates, the file integrity could not be verfied
using PGP. Possible reasons are missing PGP keys or file corruption. To
verify that pacman knows the key you can run 'pacman-key --list-keys'
and check if pacman has the keys of e.g."Jan de Groot " (and the other packagers). If there is a problem with the file
downloaded from the repo, you could try to select another mirror in
/etc/pacman.d/mirrorlist and run pacman -Syy. Do not forget to remove
the downloaded packages (e.g. libart-lgpl) from /var/cache/pacman/pkg
to enforce a fresh download. The 15 failing packages are from the
official repository and not from AUR. This are only runtime and build
dependencies for gnucash (or its transitive dependencies). I hope this
information helps you to build gnucash.

On Sun, 2017-09-10 at 17:58 +0200, ala...@tuta.io wrote:
> Bernhard, it's not a fresh installation. Perhaps 1 year old or so. 
> 
> I ran those commands now and after that "yaourt -S gnucash". Exactly
> the same result.. What could be wrong with my computer in your
> opinion?
> I have installed any other program i need with no problems.
> 
> Andres
> 
> -- 
> Securely sent with Tutanota. Claim your encrypted mailbox today! 
> https://tutanota.com
> 
> 10. Sep 2017 10:18 by b.dielh...@mailbox.org:
> 
> > Hello Andres,
> > 
> > is this a fresh installation of archlinux? Did you run
> > 
> > pacman-key --populate archlinux
> > pacman-key --refresh-keys
> > 
> > as root?
> > 
> > Regards,
> > Bernhard
> > 
> > 
> > On Sun, 2017-09-10 at 11:56 +0200, ala...@tuta.io wrote:
> > > Hello and thanks for your answers.
> > > 
> > > It says there are invalid or corrupted packages and it won't
> > > finish installation no matter what i do.
> > > 
> > > It goes like this:
> > > 
> > > ==> Edit PKGBUILD ? [Y/n] ("A" to abort)
> > > ==> 
> > > ==> n
> > > 
> > > ==> gnucash dependencies:
> > >  - guile (already installed)
> > >  - desktop-file-utils (already installed)
> > >  - webkitgtk2 (already installed)
> > >  - libgnome-keyring (already installed)
> > >  - dconf (already installed)
> > >  - intltool (already installed) [makedepend]
> > >  - slib (package found)
> > >  - goffice0.8 (building from AUR)
> > >  - libdbi-drivers (package found)
> > >  - libmariadbclient (package found)
> > >  - postgresql-libs (package found)
> > >  - aqbanking (package found)
> > >  - libgnomecanvas (package found)
> > > 
> > > 
> > > ==> Continue building gnucash ? [Y/n]
> > > ==> -
> > > ==> y
> > > 
> > > ==> Building and installing package
> > > ==> Install or build missing dependencies for gnucash:
> > > [sudo] password for xander: 
> > > resolving dependencies...
> > > looking for conflicting packages...
> > > 
> > > Packages (15) guile1.8-1.8.8-5  gwenhywfar-4.17.0-2  ktoblzcheck-
> > > 1.49-1
> > >   libart-lgpl-2.3.21-4  libdbi-0.9.0-2  libofx-
> > > 0.9.11-1
> > >   libxml++2.6-2.40.1-2  opensp-1.5.2-7  sgml-common-
> > > 0.6.3-5
> > >   aqbanking-5.6.12-2  libdbi-drivers-0.9.0-6
> > >   libgnomecanvas-2.30.3-3  libmariadbclient-10.1.26-1
> > >   postgresql-libs-9.6.4-3  slib-3b5-2
> > > 
> > > Total Installed Size:  61.71 MiB
> > > 
> > > :: Proceed with installation? [Y/n] y
> > > (15/15) checking keys in keyring  
> > > [##] 100%
> > > (15/15) checking package integrity
> > > [##] 100%
> > > error: libart-lgpl: signature from "Jan de Groot
> > > " is invalid
> > > :: File /var/cache/pacman/pkg/libart-lgpl-2.3.21-4-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: libgnomecanvas: signature from "Felix Yan
> > > " is invalid
> > > :: File /var/cache/pacman/pkg/libgnomecanvas-2.30.3-3-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: libmariadbclient: signature from "Christian Hesse (Arch
> > > Linux Package Signing) " is invalid
> > > :: File /var/cache/pacman/pkg/libmariadbclient-10.1.26-1-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: postgresql-libs: signature from "Evangelos Foutras
> > > " is invalid
> > > :: File /var/cache/pacman/pkg/postgresql-libs-9.6.4-3-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: guile1.8: signature from "Evangelos Foutras
> > > " is invalid
> > > :: File /var/cache/pacman/pkg/guile1.8-1.8.8-5-x86_64.pkg.tar.xz
> > > is corrupted (invalid or corrupted package (PGP signature)).
> > > Do you want to delete it? [Y/n] 

Re: Question on multiple layered searches and exporting

[Cindy Doughty]

try using the new version of the transaction report I posted.  It allows
you to search based on two criteria.

Doug Doughty

On Tue, Aug 8, 2017 at 1:32 PM, Jeff  wrote:

> I have not used internet chat feeds in 30 years so bear with me as I
> relearn how.  I found partial answers to my questions all over the web but;
> nothing that worked for me using the exported reports in other programs.
>
> Anyway questions at hand.  I am using GNUCash 2.16.7 for Windoze 10.  I
> need to to generate some specialized reports that are not supported.
>
> So my questions are:
>
> 1)  Is there anyway I can make each search I do output it's results to a
> new tab so I do not have to start all over after getting 5 layers deep in a
> search if I screw up?
>
> 2) Is there an easier way to get an editable exported document from any of
> the reports, including searches?  The only way to print them properly seems
> to be convert to HTML then print.  I on occasion need to add them to Open
> Office Documents and I have yet to find a way to do this on short notice.
> Export to open office file type would be wonderful great option in my case.
>
> Jeffrey Black M.B.A.
>
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Transaction Report - Subtotaling on Description? (Based on Previous Threads)

[Cindy Doughty]

The new version of the transaction report I posted has a check box named
"composite".  If you check the box and select the entire year for the time
period it will give you the total for each description.

Doug

On Mon, Sep 4, 2017 at 5:17 PM, aegross  wrote:

> This post is more-or-less for the elders of the forumthose who have a
> lot
> of experience with GC and double-entry accounting
>
> Was reporting on charitable giving for the current year, using the
> Transaction Report.  Tried to determine how to subtotal on Description;
> couldn't determine how and scanned through past threads and found these:
>
> http://gnucash.1415818.n4.nabble.com/Basic-reporting-
> Subtotal-by-Description-field-td1421478.html
>
> http://gnucash.1415818.n4.nabble.com/report-of-charitable-contributions-
> td4461126.html#a4461254
>
> http://gnucash.1415818.n4.nabble.com/Which-report-am-I-
> looking-for-td4688925.html#a4689235
>
>
> If I understand the primary points of these threads, it isn't possible to
> subtotal on Description (without changing the code) and if one really
> wanted
> to subtotal on description, they really should not have setup their account
> like Expense:Charity but rather Expense:Charity:CharityName1,
> Expense:Charity:CharityName2, etc.
>
> The previous authors and myself maybe have thinking too much as to how a
> Quicken-type program uses reports and not properly how to think this
> through
> with proper double-entry accounting.   Before reading these threads, it
> wouldn't have occurred to me to have Expense sub-accounts dedicated to a
> particular entity, esp if I may use an entity once or twice but never
> again.
>
> It's not that there is a problem with the Transaction Report or even that
> it
> "needs work" but rather, my understanding of double-entry accounting was
> insufficient.  Correct?
>
> Regards,
> Andrew Gross
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> 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
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash on ArchLinux

[Michael via gnucash-user]

I am not on Arch but rather Manjaro a close relative of Arch.  Gnucash
installed from AUR without problems.  I agree with Bernhard that it
sounds like a local issue, not AUR.  Mike

On Sun, 10 Sep 2017 12:38:44
+0200 "B. Dielhenn"  wrote:

> Sorry for the bad formatting, my mail client swallowed the newlines.
> So, did you run these commands?
> pacman-key --populate archlinuxpacman-key --refresh-keys
> This seems to be a local issue on your machine and not an AUR related
> one.
> Regards,Bernhard
> On Sun, 2017-09-10 at 12:18 +0200, B. Dielhenn wrote:
> > Hello Andres,
> > is this a fresh installation of archlinux? Did you run 
> > pacman-key --populate archlinuxpacman-key --refresh-keys
> > as root?
> > Regards,Bernhard
> > 
> > On Sun, 2017-09-10 at 11:56 +0200, ala...@tuta.io wrote:  
> > > Hello and thanks for your answers.
> > > 
> > > It says there are invalid or corrupted packages and it won't
> > > finish installation no matter what i do.
> > > 
> > > It goes like this:
> > >   
> > > ==> Edit PKGBUILD ? [Y/n] ("A" to abort)
> > > ==> 
> > > ==> n  
> > >   
> > > ==> gnucash dependencies:  
> > >  - guile (already installed)
> > >  - desktop-file-utils (already installed)
> > >  - webkitgtk2 (already installed)
> > >  - libgnome-keyring (already installed)
> > >  - dconf (already installed)
> > >  - intltool (already installed) [makedepend]
> > >  - slib (package found)
> > >  - goffice0.8 (building from AUR)
> > >  - libdbi-drivers (package found)
> > >  - libmariadbclient (package found)
> > >  - postgresql-libs (package found)
> > >  - aqbanking (package found)
> > >  - libgnomecanvas (package found)
> > > 
> > >   
> > > ==> Continue building gnucash ? [Y/n]
> > > ==> -
> > > ==> y  
> > >   
> > > ==> Building and installing package
> > > ==> Install or build missing dependencies for gnucash:  
> > > [sudo] password for xander: 
> > > resolving dependencies...
> > > looking for conflicting packages...
> > > 
> > > Packages (15) guile1.8-1.8.8-5  gwenhywfar-4.17.0-2  ktoblzcheck-
> > > 1.49-1
> > >   libart-lgpl-2.3.21-4  libdbi-0.9.0-2
> > > libofx-0.9.11-1 libxml++2.6-2.40.1-2  opensp-1.5.2-7  sgml-common-
> > > 0.6.3-5
> > >   aqbanking-5.6.12-2  libdbi-drivers-0.9.0-6
> > >   libgnomecanvas-2.30.3-3  libmariadbclient-10.1.26-1
> > >   postgresql-libs-9.6.4-3  slib-3b5-2
> > > 
> > > Total Installed Size:  61.71 MiB
> > > 
> > > :: Proceed with installation? [Y/n] y
> > > (15/15) checking keys in keyring  
> > > [##] 100%
> > > (15/15) checking package integrity
> > > [##] 100%
> > > error: libart-lgpl: signature from "Jan de Groot
> > >  > > nl>" is invalid  
> > > :: File /var/cache/pacman/pkg/libart-lgpl-2.3.21-4-
> > > x86_64.pkg.tar.xz
> > > is corrupted (invalid or corrupted package (PGP signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: libgnomecanvas: signature from "Felix Yan
> > >  > > om>" is invalid  
> > > :: File /var/cache/pacman/pkg/libgnomecanvas-2.30.3-3-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: libmariadbclient: signature from "Christian Hesse (Arch
> > > Linux
> > > Package Signing) " is invalid
> > > :: File /var/cache/pacman/pkg/libmariadbclient-10.1.26-1-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: postgresql-libs: signature from "Evangelos Foutras
> > >  > > foutrelis.com>" is invalid  
> > > :: File /var/cache/pacman/pkg/postgresql-libs-9.6.4-3-
> > > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > > signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: guile1.8: signature from "Evangelos Foutras
> > >  > > is.com>" is invalid  
> > > :: File /var/cache/pacman/pkg/guile1.8-1.8.8-5-x86_64.pkg.tar.xz
> > > is corrupted (invalid or corrupted package (PGP signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: slib: signature from "Antonio Rojas "
> > > is
> > > invalid
> > > :: File /var/cache/pacman/pkg/slib-3b5-2-any.pkg.tar.xz is
> > > corrupted
> > > (invalid or corrupted package (PGP signature)).
> > > Do you want to delete it? [Y/n] n
> > > error: gwenhywfar: signature from "Evangelos Foutras
> > >  > > elis.com>" is invalid  
> > > ::
> > > File /var/cache/pacman/pkg/gwenhywfar-4.17.0-2-x86_64.pkg.tar.xz
> > > is corrupted (invalid or corrupted package (PGP signature)). Do
> > > you want to delete it? [Y/n] n error: ktoblzcheck: signature from
> > > "Sergej Pupykin  > > > " is invalid  
> > > 
> > > :: File 

Re: Unit Trusts assistance development

[John Ralls]

> On Sep 10, 2017, at 1:26 AM, Hylton Conacher (ZR1HPC)  
> wrote:
> 
> Hi,
> 
> I am a new user of Gnucash 2.6.17 on a Mac and after many years using the 
> earlier versions (95/98) of Quicken on Windows Have started a fresh set of 
> accounts on Gnucash, for personal use, since the 1st Sept.
> 
> I have managed to operate my way through how different the app works, and am 
> actually enjoying the learning experience.
> 
> In the years previous to this I have invested funds in several unit trusts, 
> or what I believe some call, Mutual Funds.
> 
> I would like to add the current balances of the unit trusts as opening 
> balances in Gnucash however despite reading the on-line manual and doing some 
> Google searching as well as Bugzilla searching, have been unable to 
> successfully create the following unit trust type of account hierarchy, as 
> the account type is not specified.
> 
> Further delving into the app trying to use either 'Stock' or 'Mutual fund' 
> did not assist as then I needed to select the 'Security/Currency'. When I 
> clicked on Select it only showed non-currency related items, and none of them 
> in south Africa. As my country currency is not listed, despite being listed 
> if I choose to add an 'Asset' account.
> 
> The composition of the units purchased is decided by the parent company from 
> which you are buying the unit trusts. The money given to the company for the 
> purchase of your units is invested in a variety of assets that should provide 
> a return i.e. gold bullion, stocks purchased in a particular range of 
> companies, bonds etc.
> As the value of those investments increases i.e. those companies invested in 
> are now worth more, so the value of a unit trust unit increases.
> The parent company has absolute discretion on where and when it wants to 
> invest your money and so manages the risk and ensures a positive return on 
> investment, allowing them to take a fee of the profit earned.
> 
> A unit trust will normally be traded in the home country currency but may be 
> traded in a completely different currency i.e. whilst the home currency is 
> ZAR, I may have a unit trust that is traded in GBP. A unit trust consists of 
> units purchased, usually to 2 or 3 decimal points i.e. 0.01 or 0.001 but some 
> might be more, a price per full unit and then the currency value of the total 
> units held in that particular named unit trust.
> 
> I believe this unit trust account type needs further development work and 
> wonder if there is a work around?
> 
> I have raised a feature request
> 
> to request this further enhancements to Gnucash.

You believe wrong.

One accounts for units in a unit trust as units. Please STUDY the Tutorial and 
Concepts Guide, paying particular attention to the chapters on Investments and 
Capital Gains, where you’ll learn how to use GnuCash to account for 
non-currency assets.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: GnuCash on ArchLinux

[B. Dielhenn]

Sorry for the bad formatting, my mail client swallowed the newlines.
So, did you run these commands?
pacman-key --populate archlinuxpacman-key --refresh-keys
This seems to be a local issue on your machine and not an AUR related
one.
Regards,Bernhard
On Sun, 2017-09-10 at 12:18 +0200, B. Dielhenn wrote:
> Hello Andres,
> is this a fresh installation of archlinux? Did you run 
> pacman-key --populate archlinuxpacman-key --refresh-keys
> as root?
> Regards,Bernhard
> 
> On Sun, 2017-09-10 at 11:56 +0200, ala...@tuta.io wrote:
> > Hello and thanks for your answers.
> > 
> > It says there are invalid or corrupted packages and it won't finish
> > installation no matter what i do.
> > 
> > It goes like this:
> > 
> > ==> Edit PKGBUILD ? [Y/n] ("A" to abort)
> > ==> 
> > ==> n
> > 
> > ==> gnucash dependencies:
> >  - guile (already installed)
> >  - desktop-file-utils (already installed)
> >  - webkitgtk2 (already installed)
> >  - libgnome-keyring (already installed)
> >  - dconf (already installed)
> >  - intltool (already installed) [makedepend]
> >  - slib (package found)
> >  - goffice0.8 (building from AUR)
> >  - libdbi-drivers (package found)
> >  - libmariadbclient (package found)
> >  - postgresql-libs (package found)
> >  - aqbanking (package found)
> >  - libgnomecanvas (package found)
> > 
> > 
> > ==> Continue building gnucash ? [Y/n]
> > ==> -
> > ==> y
> > 
> > ==> Building and installing package
> > ==> Install or build missing dependencies for gnucash:
> > [sudo] password for xander: 
> > resolving dependencies...
> > looking for conflicting packages...
> > 
> > Packages (15) guile1.8-1.8.8-5  gwenhywfar-4.17.0-2  ktoblzcheck-
> > 1.49-1
> >   libart-lgpl-2.3.21-4  libdbi-0.9.0-2  libofx-0.9.11-1
> >   libxml++2.6-2.40.1-2  opensp-1.5.2-7  sgml-common-
> > 0.6.3-5
> >   aqbanking-5.6.12-2  libdbi-drivers-0.9.0-6
> >   libgnomecanvas-2.30.3-3  libmariadbclient-10.1.26-1
> >   postgresql-libs-9.6.4-3  slib-3b5-2
> > 
> > Total Installed Size:  61.71 MiB
> > 
> > :: Proceed with installation? [Y/n] y
> > (15/15) checking keys in keyring  
> > [##] 100%
> > (15/15) checking package integrity
> > [##] 100%
> > error: libart-lgpl: signature from "Jan de Groot  > t.
> > nl>" is invalid
> > :: File /var/cache/pacman/pkg/libart-lgpl-2.3.21-4-
> > x86_64.pkg.tar.xz
> > is corrupted (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: libgnomecanvas: signature from "Felix Yan  > .c
> > om>" is invalid
> > :: File /var/cache/pacman/pkg/libgnomecanvas-2.30.3-3-
> > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > signature)).
> > Do you want to delete it? [Y/n] n
> > error: libmariadbclient: signature from "Christian Hesse (Arch
> > Linux
> > Package Signing) " is invalid
> > :: File /var/cache/pacman/pkg/libmariadbclient-10.1.26-1-
> > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > signature)).
> > Do you want to delete it? [Y/n] n
> > error: postgresql-libs: signature from "Evangelos Foutras
> >  > foutrelis.com>" is invalid
> > :: File /var/cache/pacman/pkg/postgresql-libs-9.6.4-3-
> > x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> > signature)).
> > Do you want to delete it? [Y/n] n
> > error: guile1.8: signature from "Evangelos Foutras  > el
> > is.com>" is invalid
> > :: File /var/cache/pacman/pkg/guile1.8-1.8.8-5-x86_64.pkg.tar.xz is
> > corrupted (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: slib: signature from "Antonio Rojas "
> > is
> > invalid
> > :: File /var/cache/pacman/pkg/slib-3b5-2-any.pkg.tar.xz is
> > corrupted
> > (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: gwenhywfar: signature from "Evangelos Foutras  > tr
> > elis.com>" is invalid
> > :: File /var/cache/pacman/pkg/gwenhywfar-4.17.0-2-x86_64.pkg.tar.xz
> > is corrupted (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: ktoblzcheck: signature from "Sergej Pupykin  > ru
> > > " is invalid
> > 
> > :: File /var/cache/pacman/pkg/ktoblzcheck-1.49-1-x86_64.pkg.tar.xz
> > is
> > corrupted (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: sgml-common: signature from "Andreas Radke  > x.
> > org>" is invalid
> > :: File /var/cache/pacman/pkg/sgml-common-0.6.3-5-any.pkg.tar.xz is
> > corrupted (invalid or corrupted package (PGP signature)).
> > Do you want to delete it? [Y/n] n
> > error: opensp: signature from "Andreas Radke  > >"
> > is invalid
> > :: File 

Re: GnuCash on ArchLinux

[B. Dielhenn]

Hello Andres,
is this a fresh installation of archlinux? Did you run 
pacman-key --populate archlinuxpacman-key --refresh-keys
as root?
Regards,Bernhard

On Sun, 2017-09-10 at 11:56 +0200, ala...@tuta.io wrote:
> Hello and thanks for your answers.
> 
> It says there are invalid or corrupted packages and it won't finish
> installation no matter what i do.
> 
> It goes like this:
> 
> ==> Edit PKGBUILD ? [Y/n] ("A" to abort)
> ==> 
> ==> n
> 
> ==> gnucash dependencies:
>  - guile (already installed)
>  - desktop-file-utils (already installed)
>  - webkitgtk2 (already installed)
>  - libgnome-keyring (already installed)
>  - dconf (already installed)
>  - intltool (already installed) [makedepend]
>  - slib (package found)
>  - goffice0.8 (building from AUR)
>  - libdbi-drivers (package found)
>  - libmariadbclient (package found)
>  - postgresql-libs (package found)
>  - aqbanking (package found)
>  - libgnomecanvas (package found)
> 
> 
> ==> Continue building gnucash ? [Y/n]
> ==> -
> ==> y
> 
> ==> Building and installing package
> ==> Install or build missing dependencies for gnucash:
> [sudo] password for xander: 
> resolving dependencies...
> looking for conflicting packages...
> 
> Packages (15) guile1.8-1.8.8-5  gwenhywfar-4.17.0-2  ktoblzcheck-
> 1.49-1
>   libart-lgpl-2.3.21-4  libdbi-0.9.0-2  libofx-0.9.11-1
>   libxml++2.6-2.40.1-2  opensp-1.5.2-7  sgml-common-
> 0.6.3-5
>   aqbanking-5.6.12-2  libdbi-drivers-0.9.0-6
>   libgnomecanvas-2.30.3-3  libmariadbclient-10.1.26-1
>   postgresql-libs-9.6.4-3  slib-3b5-2
> 
> Total Installed Size:  61.71 MiB
> 
> :: Proceed with installation? [Y/n] y
> (15/15) checking keys in keyring  
> [##] 100%
> (15/15) checking package integrity
> [##] 100%
> error: libart-lgpl: signature from "Jan de Groot  nl>" is invalid
> :: File /var/cache/pacman/pkg/libart-lgpl-2.3.21-4-x86_64.pkg.tar.xz
> is corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: libgnomecanvas: signature from "Felix Yan  om>" is invalid
> :: File /var/cache/pacman/pkg/libgnomecanvas-2.30.3-3-
> x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> signature)).
> Do you want to delete it? [Y/n] n
> error: libmariadbclient: signature from "Christian Hesse (Arch Linux
> Package Signing) " is invalid
> :: File /var/cache/pacman/pkg/libmariadbclient-10.1.26-1-
> x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> signature)).
> Do you want to delete it? [Y/n] n
> error: postgresql-libs: signature from "Evangelos Foutras  foutrelis.com>" is invalid
> :: File /var/cache/pacman/pkg/postgresql-libs-9.6.4-3-
> x86_64.pkg.tar.xz is corrupted (invalid or corrupted package (PGP
> signature)).
> Do you want to delete it? [Y/n] n
> error: guile1.8: signature from "Evangelos Foutras  is.com>" is invalid
> :: File /var/cache/pacman/pkg/guile1.8-1.8.8-5-x86_64.pkg.tar.xz is
> corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: slib: signature from "Antonio Rojas " is
> invalid
> :: File /var/cache/pacman/pkg/slib-3b5-2-any.pkg.tar.xz is corrupted
> (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: gwenhywfar: signature from "Evangelos Foutras  elis.com>" is invalid
> :: File /var/cache/pacman/pkg/gwenhywfar-4.17.0-2-x86_64.pkg.tar.xz
> is corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: ktoblzcheck: signature from "Sergej Pupykin  >" is invalid
> :: File /var/cache/pacman/pkg/ktoblzcheck-1.49-1-x86_64.pkg.tar.xz is
> corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: sgml-common: signature from "Andreas Radke  org>" is invalid
> :: File /var/cache/pacman/pkg/sgml-common-0.6.3-5-any.pkg.tar.xz is
> corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: opensp: signature from "Andreas Radke "
> is invalid
> :: File /var/cache/pacman/pkg/opensp-1.5.2-7-x86_64.pkg.tar.xz is
> corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: libxml++2.6: signature from "Jan de Groot  nl>" is invalid
> :: File /var/cache/pacman/pkg/libxml++2.6-2.40.1-2-x86_64.pkg.tar.xz
> is corrupted (invalid or corrupted package (PGP signature)).
> Do you want to delete it? [Y/n] n
> error: libofx: signature from "Jaroslav Lichtblau  nux.org>" is invalid
> :: File /var/cache/pacman/pkg/libofx-0.9.11-1-x86_64.pkg.tar.xz is
> corrupted (invalid 

envelope budgeting (was Re: New report - Compare current spending versus historic average)

[Gour]

On Fri, 5 May 2017 11:04:41 -0400
Cindy Doughty  wrote:

Hello Doug,

Thank you very much for sharing your reports!

> This report allows you to pick a time period and then compare it with
> the average
> This report has all of the functionality of  the multiple periods
> side by side report, it just adds some additional options.

Let me admit that few times I tried to migrate from Gnucash to some of the
#plaintextaccounting packages - {beancount,(h)ledger}, but after some time
returned back to GC. :-)

Data entry, reconcilation, general UI are great in GC as well as available
reports. The only practical thing which bugs me is to make better use of budget
feature - unfortunately, not used, afaik, by any core GC dev. 

However, your work (aka reports) make me hopefuly that it would be possible to
do everything here and stay with Gnucash.

I read some past articles about doing 'envelope budgeting' with GC by creating
parallel 'budget' accounts and include them in every transaction, but it all
looks a bit complicated when my needs are probably not so extensive.

Your report can help to arrive at e.g. average amount for each Expense account
I'm interested in and it would be great if one could use those to, somehow,
automagically enter those amounts in the estimated entry fields for each month
within budget's period since Estimate function in Budget feature does calculate
values based on the past amounts for *each* month separately, which makes
amount skewed - e.g. I pay car insurance and associated costs once per weak and
would like that the cost is distibuted evenly throughout the year. Same with
the cost for heating (gas) which greatly differs between summer/winter season?


Do you believe it's possible without going too deep in the GC's core?

I'd like to be able to (easily) create yearly budget based on my previous
expenses and to always have insight how I'm doing, iow. how are actual expenses
are in comparison with the yearly budget's plan so we can plan further expenses
accordingly depending if we are spending over/under the budget.

Do you have any suggestion how to take advantage of current Gnucash's
technology to achieve that and what parts/reports do you see missing which
could be done by the end-user's report(s)?

I'm also interested if you can throw some advice in regard to learning
Guile/Scheme for the purpose of GC reporting although I'm afraid that at the
time when I learn enough of it, Gnucash will abandon it. :-)

In the past I wanted to learn/use Racket, but never had enough time and/or
purpose to really do it.


Sincerely,
Gour

-- 
Many, many births both you and I have passed. I can remember
all of them, but you cannot, O subduer of the enemy!


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Unit Trusts assistance development

[Hylton Conacher (ZR1HPC)]

Hi,

I am a new user of Gnucash 2.6.17 on a Mac and after many years using 
the earlier versions (95/98) of Quicken on Windows Have started a fresh 
set of accounts on Gnucash, for personal use, since the 1st Sept.


I have managed to operate my way through how different the app works, 
and am actually enjoying the learning experience.


In the years previous to this I have invested funds in several unit 
trusts, or what I believe some call, Mutual Funds.


I would like to add the current balances of the unit trusts as opening 
balances in Gnucash however despite reading the on-line manual and doing 
some Google searching as well as Bugzilla searching, have been unable to 
successfully create the following unit trust type of account hierarchy, 
as the account type is not specified.


Further delving into the app trying to use either 'Stock' or 'Mutual 
fund' did not assist as then I needed to select the 'Security/Currency'. 
When I clicked on Select it only showed non-currency related items, and 
none of them in south Africa. As my country currency is not listed, 
despite being listed if I choose to add an 'Asset' account.


The composition of the units purchased is decided by the parent company 
from which you are buying the unit trusts. The money given to the 
company for the purchase of your units is invested in a variety of 
assets that should provide a return i.e. gold bullion, stocks purchased 
in a particular range of companies, bonds etc.
As the value of those investments increases i.e. those companies 
invested in are now worth more, so the value of a unit trust unit increases.
The parent company has absolute discretion on where and when it wants to 
invest your money and so manages the risk and ensures a positive return 
on investment, allowing them to take a fee of the profit earned.


A unit trust will normally be traded in the home country currency but 
may be traded in a completely different currency i.e. whilst the home 
currency is ZAR, I may have a unit trust that is traded in GBP. A unit 
trust consists of units purchased, usually to 2 or 3 decimal points i.e. 
0.01 or 0.001 but some might be more, a price per full unit and then the 
currency value of the total units held in that particular named unit trust.


I believe this unit trust account type needs further development work 
and wonder if there is a work around?


I have raised a feature request

to request this further enhancements to Gnucash.

Hylton
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.