[GNC] Hidden accounts and balances

[Bridgit Griffin]

I recently imported 20 years of financial data. The issue I'm facing is 
that marking an account as hidden doesn't remove the balance from the 
total of the higher level accounts. Such that only active (unhidden) 
accounts are reflected in totals. Being accustom to Quicken that did 
have this feature either through a close option or hiding the account 
removed any of the balances in those accounts from totals. I can't be 
the first person who has encountered this, but searching didn't produce 
any relevant results. Any suggestions are welcome. Thank you.


___
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] Hidden accounts and balances

[Colin Law]

I would have expected a closed account to have a zero balance.

Colin

On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin 
wrote:

> I recently imported 20 years of financial data. The issue I'm facing is
> that marking an account as hidden doesn't remove the balance from the
> total of the higher level accounts. Such that only active (unhidden)
> accounts are reflected in totals. Being accustom to Quicken that did
> have this feature either through a close option or hiding the account
> removed any of the balances in those accounts from totals. I can't be
> the first person who has encountered this, but searching didn't produce
> any relevant results. Any suggestions are welcome. Thank you.
>
> ___
> 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] Hidden accounts and balances

[Bridgit Griffin]

No not all have zero balances. However, Quicken allows the account to be
treated as if that is the case. It seems the hidden function in GNUcash
doesn't function the same way.

On Fri, Aug 10, 2018, 4:30 AM Colin Law  wrote:

> I would have expected a closed account to have a zero balance.
>
> Colin
>
> On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin 
> wrote:
>
>> I recently imported 20 years of financial data. The issue I'm facing is
>> that marking an account as hidden doesn't remove the balance from the
>> total of the higher level accounts. Such that only active (unhidden)
>> accounts are reflected in totals. Being accustom to Quicken that did
>> have this feature either through a close option or hiding the account
>> removed any of the balances in those accounts from totals. I can't be
>> the first person who has encountered this, but searching didn't produce
>> any relevant results. Any suggestions are welcome. Thank you.
>>
>> ___
>> 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] Hidden accounts and balances

[Maf. King]

Sounds like a bug or mis-feature in quicken to me.  I think I'd prefer that my 
accounts package didn't hide money from me.

Seriously, though thinking about it for a second, what financial institution 
would allow you to close an account you held with them and leave a running 
balance for the rest of eternity?  (apologies to those planning a meal at the 
Restaurant at the End of the Universe as featured in Hitchhikers Guide to the 
Galaxy)  

If you're hiding an Income / Expense account then surely you don't want to 
regard that money as no longer earned / spent? It would throw everything out 
of whack, IMHO.

0.02
Maf.



On Friday, 10 August 2018 14:11:15 BST Bridgit Griffin wrote:
> No not all have zero balances. However, Quicken allows the account to be
> treated as if that is the case. It seems the hidden function in GNUcash
> doesn't function the same way.
> 
> On Fri, Aug 10, 2018, 4:30 AM Colin Law  wrote:
> > I would have expected a closed account to have a zero balance.
> > 
> > Colin
> > 
> > On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin 
> > 
> > wrote:
> >> I recently imported 20 years of financial data. The issue I'm facing is
> >> that marking an account as hidden doesn't remove the balance from the
> >> total of the higher level accounts. Such that only active (unhidden)
> >> accounts are reflected in totals. Being accustom to Quicken that did
> >> have this feature either through a close option or hiding the account
> >> removed any of the balances in those accounts from totals. I can't be
> >> the first person who has encountered this, but searching didn't produce
> >> any relevant results. Any suggestions are welcome. Thank you.
> >> 
> >> ___
> >> 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.


-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542





___
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] Hidden accounts and balances

[Bridgit Griffin]

It's a nice way to handle joint accounts that are no longer joint yet open.
Also, for handling very old accounts not reconciled that are closed. Plus
during the import process from Quicken lots of transactions were removed
from accounts. For example, anything that says cash or salary. As you all
know Quicken allows for categories that GNUcash makes into accounts.
They're not really accounts so what is getting closed? It was a category in
Quicken.

Why offer hidden when it's not?

On Fri, Aug 10, 2018, 8:19 AM Maf. King  wrote:

> Sounds like a bug or mis-feature in quicken to me.  I think I'd prefer
> that my
> accounts package didn't hide money from me.
>
> Seriously, though thinking about it for a second, what financial
> institution
> would allow you to close an account you held with them and leave a running
> balance for the rest of eternity?  (apologies to those planning a meal at
> the
> Restaurant at the End of the Universe as featured in Hitchhikers Guide to
> the
> Galaxy)
>
> If you're hiding an Income / Expense account then surely you don't want to
> regard that money as no longer earned / spent? It would throw everything
> out
> of whack, IMHO.
>
> 0.02
> Maf.
>
>
>
> On Friday, 10 August 2018 14:11:15 BST Bridgit Griffin wrote:
> > No not all have zero balances. However, Quicken allows the account to be
> > treated as if that is the case. It seems the hidden function in GNUcash
> > doesn't function the same way.
> >
> > On Fri, Aug 10, 2018, 4:30 AM Colin Law  wrote:
> > > I would have expected a closed account to have a zero balance.
> > >
> > > Colin
> > >
> > > On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin <
> bridgitgrif...@gmail.com>
> > >
> > > wrote:
> > >> I recently imported 20 years of financial data. The issue I'm facing
> is
> > >> that marking an account as hidden doesn't remove the balance from the
> > >> total of the higher level accounts. Such that only active (unhidden)
> > >> accounts are reflected in totals. Being accustom to Quicken that did
> > >> have this feature either through a close option or hiding the account
> > >> removed any of the balances in those accounts from totals. I can't be
> > >> the first person who has encountered this, but searching didn't
> produce
> > >> any relevant results. Any suggestions are welcome. Thank you.
> > >>
> > >> ___
> > >> 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.
>
>
> --
> Maf. King
> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>
>
>
>
>
>
___
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] Hidden accounts and balances

[Colin Law]

If they are accounts that no longer have any value (monetarily I mean) but
when you look at the account it says it has a value then your accounts are
in error.  Add a transaction to bring the value to zero.

Colin

On Fri, 10 Aug 2018 at 14:43, Bridgit Griffin 
wrote:

> It's a nice way to handle joint accounts that are no longer joint yet
> open. Also, for handling very old accounts not reconciled that are closed.
> Plus during the import process from Quicken lots of transactions were
> removed from accounts. For example, anything that says cash or salary. As
> you all know Quicken allows for categories that GNUcash makes into
> accounts. They're not really accounts so what is getting closed? It was a
> category in Quicken.
>
> Why offer hidden when it's not?
>
> On Fri, Aug 10, 2018, 8:19 AM Maf. King  wrote:
>
>> Sounds like a bug or mis-feature in quicken to me.  I think I'd prefer
>> that my
>> accounts package didn't hide money from me.
>>
>> Seriously, though thinking about it for a second, what financial
>> institution
>> would allow you to close an account you held with them and leave a
>> running
>> balance for the rest of eternity?  (apologies to those planning a meal at
>> the
>> Restaurant at the End of the Universe as featured in Hitchhikers Guide to
>> the
>> Galaxy)
>>
>> If you're hiding an Income / Expense account then surely you don't want
>> to
>> regard that money as no longer earned / spent? It would throw everything
>> out
>> of whack, IMHO.
>>
>> 0.02
>> Maf.
>>
>>
>>
>> On Friday, 10 August 2018 14:11:15 BST Bridgit Griffin wrote:
>> > No not all have zero balances. However, Quicken allows the account to be
>> > treated as if that is the case. It seems the hidden function in GNUcash
>> > doesn't function the same way.
>> >
>> > On Fri, Aug 10, 2018, 4:30 AM Colin Law  wrote:
>> > > I would have expected a closed account to have a zero balance.
>> > >
>> > > Colin
>> > >
>> > > On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin <
>> bridgitgrif...@gmail.com>
>> > >
>> > > wrote:
>> > >> I recently imported 20 years of financial data. The issue I'm facing
>> is
>> > >> that marking an account as hidden doesn't remove the balance from the
>> > >> total of the higher level accounts. Such that only active (unhidden)
>> > >> accounts are reflected in totals. Being accustom to Quicken that did
>> > >> have this feature either through a close option or hiding the account
>> > >> removed any of the balances in those accounts from totals. I can't be
>> > >> the first person who has encountered this, but searching didn't
>> produce
>> > >> any relevant results. Any suggestions are welcome. Thank you.
>> > >>
>> > >> ___
>> > >> 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.
>>
>>
>> --
>> Maf. King
>> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>>
>>
>>
>>
>>
>>
___
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] Reconciliation Report

[Mike stagl]

When running a stock reconciliation report, I cannot get the Start Date and End 
Date to work correctly.  If I choose Start of Previous Month and End of 
Previous Month, or even use actual dates, I get transactions from the start 
date all the way to the current date.


This month I am seeing un-reconciled transactions from August, when I am 
running a report with the dates 7/1/2018 to 7/31/2018.


For what it's worth, other reports appear to correctly implement the date.


Thanks for any help,


Mike
___
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-user Digest, Vol 185, Issue 45

[Derek Atkins]

Stan,

Stan Brown  writes:

> I'm not sure my main point was understood. Quite apart from all links
> pointing to the old database, where each bug report ends with a link
> to the report in the new database, the two links I mentioned are
> wrong. The both point to a bug number that is different from the
> visible text. The visible text bug number is right, but if you click
> on the link it takes you to a different numbered bug.
>
> I'm pretty sure it was bad copy/pasting by somebody, because they two
> both take you to the _same_ wrong bug number.

I think I missed the OP.

Can you please (re-)send the URL where the visible text and the HREF are
different?

Thanks,

-derek
-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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] Hidden accounts and balances

[Derek Atkins]

Bridgit Griffin  writes:

> It's a nice way to handle joint accounts that are no longer joint yet open.
> Also, for handling very old accounts not reconciled that are closed. Plus
> during the import process from Quicken lots of transactions were removed
> from accounts. For example, anything that says cash or salary. As you all
> know Quicken allows for categories that GNUcash makes into accounts.
> They're not really accounts so what is getting closed? It was a category in
> Quicken.
>
> Why offer hidden when it's not?

It is hidden -- you wont see the account listed in the Chart of Accounts.
Youre hiding the ACCOUNT, you're not hiding the transactions stored therein.

In the case of a joint account that's no longer joint -- what happened
to the remaining funds in the account?  If you no longer have access to
them then you should remove them from your books in some appropriate way
(taking the account down to zero).

The fact that the account remains open is irrelevant if the funds are
not yours.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
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-user Digest, Vol 185, Issue 45

[Derek Atkins]

Actually, it looks like Geert fixed this already in GIT.

-derek

On Fri, August 10, 2018 9:58 am, Derek Atkins wrote:
> Stan,
>
> Stan Brown  writes:
>
>> I'm not sure my main point was understood. Quite apart from all links
>> pointing to the old database, where each bug report ends with a link
>> to the report in the new database, the two links I mentioned are
>> wrong. The both point to a bug number that is different from the
>> visible text. The visible text bug number is right, but if you click
>> on the link it takes you to a different numbered bug.
>>
>> I'm pretty sure it was bad copy/pasting by somebody, because they two
>> both take you to the _same_ wrong bug number.
>
> I think I missed the OP.
>
> Can you please (re-)send the URL where the visible text and the HREF are
> different?
>
> Thanks,
>
> -derek
> --
>Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>Member, MIT Student Information Processing Board  (SIPB)
>URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
>warl...@mit.eduPGP key available
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

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

Re: [GNC] GNUcash 3.2 flatpak file open issue

[Geert Janssens]

I have been playing with the gnucash flatpak package in the last few days.

And I can add some information regarding the file open issues (though not 
everything is clear yet).

For starters I can confirm that by default USB sticks and network shares are 
not accessible. I have fouind this is due to flatpak's security policy which 
states: by default allow as little access as possible. This clearly excludes 
mounted media and network shares.

This limitation can be relaxed though with the "flatpak override" command. In 
particular by running
  flatpak override org.gnucash.GnuCash --filesystem=

 can be any filesystem path you wish to access from within 
gnucash. For example on Fedora usb sticks are mounted under /run/media so I 
have run

  flatpak override org.gnucash.GnuCash --filesystem=/run/media

And now USB sticks appear in the gnucash File->Open dialog.

It appears on Ubuntu and derivatives however usb sticks are mounted under 
/media so on those platforms the command would become

  flatpak override org.gnucash.GnuCash --filesystem=/media

The same can be done for any network shares that are not mounted under your 
home directory. For example if you have a mounted network share under /mynet
you can allow access by running 

  flatpak override org.gnucash.GnuCash --filesystem=/mynet

One caveat:
I had some permission issues on my system, which I don't know were due to how 
my system is set up or a bug in flatpak. As my flatpaks are installed system 
wide, the flatpak information is stored in /var/lib/flatpak and only the root 
user has write access there.

So I had to prefix each command with 'sudo'. With this the commands ran fine, 
but I still had issues because the file permissions of the generated override 
file and its parent directory, "overrides", didn't grant access to ordinary 
users.

I fixed this by running following two commands:
sudo chmod o=rx /var/lib/flatpak/overrides
sudo chmod o+r /var/lib/flatpak/overrides/org.gnucash.GnuCash

You may or may not need to do something similar on your system. YMMV.

Hopefully this will make flatpak a viable alternative for more users that want 
to try out gnucash 3 while it's not yet available on their preferred platform.

Regards,

Geert

Op vrijdag 27 juli 2018 01:06:49 CEST schreef DaveC49:
> Adrien, David,
> 
> The same issue occurs in Linux Mint 19(Tara) which is Ubuntu 18.04 based.
> Nemo (file explorer)  can see the mounted USB stick and access it directly
> or via the /media// mount point for the device but the Gnucash file
> open dialog neither sees the USB stick or /media// mount point when
> you click on other locations. It only lists a restricted set of the
> directories under / by comparison with what can be accessed from Nemo. Not
> being able to access the /media mount points would qualify as a bug.
> 
>  On LM19 /media has 755 permissions, the user directory under it has 750 and
> the mounted USB stick has 755 permissions.
> 
> The file->Open dialog in LibreOffice which looks to be a similar GTK3 dialog
> does display the USB stick in the sidebar and it sees all the directories
> under / as well as any networked locations which don't show up in GnuCash
> either.
> 
> if no-one has already filked a bug i will put one in later today.
> 
> 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] Hidden accounts and balances

[Adrien Monteleone]

> On Aug 10, 2018, at 8:43 AM, Bridgit Griffin  wrote:
> 
> It’s a nice way to handle joint accounts that are no longer joint yet open.

If you control those funds, certainly you wouldn’t want to hide them.

If you don’t control the funds, as noted, you should zero and then hide the 
account as those aren’t your assets any longer.


> Also, for handling very old accounts not reconciled that are closed.

Reconcile the account, balance it out. Hide it. I created several Miscellaneous 
expense accounts, one of which is “Balancing” for just such a purpose where 
nothing else makes sense. (and yes, sometimes I credit Miscellaneous:Balancing, 
and sometimes I debit it depending on what needed to be done to bring the other 
account into balance)


> Plus
> during the import process from Quicken lots of transactions were removed
> from accounts.

If transactions were removed from accounts, the import is not yet complete or 
needs to be redone.

Without those transactions, the affected accounts are in error and won’t 
balance.


> For example, anything that says cash or salary. As you all
> know Quicken allows for categories that GNUcash makes into accounts.
> They're not really accounts so what is getting closed? It was a category in
> Quicken.

If non-accounts were created out of categories yet the transactions do properly 
exist where they belong, then delete the extra entries if not those entire 
accounts. They were never real and shouldn’t exist. Your books (especially your 
balance sheet and likely income statement) would be forever off otherwise 
because you’d effectively have duplicated transactions.

Regards,
Adrien
> 
> Why offer hidden when it's not?
> 
> On Fri, Aug 10, 2018, 8:19 AM Maf. King  wrote:
> 
>> Sounds like a bug or mis-feature in quicken to me.  I think I'd prefer
>> that my
>> accounts package didn't hide money from me.
>> 
>> Seriously, though thinking about it for a second, what financial
>> institution
>> would allow you to close an account you held with them and leave a running
>> balance for the rest of eternity?  (apologies to those planning a meal at
>> the
>> Restaurant at the End of the Universe as featured in Hitchhikers Guide to
>> the
>> Galaxy)
>> 
>> If you're hiding an Income / Expense account then surely you don't want to
>> regard that money as no longer earned / spent? It would throw everything
>> out
>> of whack, IMHO.
>> 
>> 0.02
>> Maf.
>> 
>> 
>> 
>> On Friday, 10 August 2018 14:11:15 BST Bridgit Griffin wrote:
>>> No not all have zero balances. However, Quicken allows the account to be
>>> treated as if that is the case. It seems the hidden function in GNUcash
>>> doesn't function the same way.
>>> 
>>> On Fri, Aug 10, 2018, 4:30 AM Colin Law  wrote:
 I would have expected a closed account to have a zero balance.
 
 Colin
 
 On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin <
>> bridgitgrif...@gmail.com>
 
 wrote:
> I recently imported 20 years of financial data. The issue I'm facing
>> is
> that marking an account as hidden doesn't remove the balance from the
> total of the higher level accounts. Such that only active (unhidden)
> accounts are reflected in totals. Being accustom to Quicken that did
> have this feature either through a close option or hiding the account
> removed any of the balances in those accounts from totals. I can't be
> the first person who has encountered this, but searching didn't
>> produce
> any relevant results. Any suggestions are welcome. Thank you.
> 
> ___
> 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.
>> 
>> 
>> --
>> Maf. King
>> PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542
>> 
>> 
>> 
>> 
>> 
>> 
> ___
> 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.
> -
> P

Re: [GNC] Hidden accounts and balances

[Bridgit Griffin]

For sanity's sake I imported the Quicken file into another financial 
program and the results were similar to what is in Quicken. There were 
many many more accounts that are closed (aka zeroed balances) that 
GNUcash was reporting differently. And if the account had a balance when 
I selected closed in the new software that account was removed from the 
balances. I think it is in the importing process that causes many issues 
as categories and certain transactions were broken out into their own 
accounts. Looking like I'll forgo GNUCash for now. Thank you for all the 
input.



On 8/10/18 4:30 AM, Colin Law wrote:

I would have expected a closed account to have a zero balance.

Colin

On Fri, 10 Aug 2018 at 09:51, Bridgit Griffin 
mailto:bridgitgrif...@gmail.com>> wrote:


I recently imported 20 years of financial data. The issue I'm
facing is
that marking an account as hidden doesn't remove the balance from the
total of the higher level accounts. Such that only active (unhidden)
accounts are reflected in totals. Being accustom to Quicken that did
have this feature either through a close option or hiding the account
removed any of the balances in those accounts from totals. I can't be
the first person who has encountered this, but searching didn't
produce
any relevant results. Any suggestions are welcome. Thank you.

___
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] Reconciliation Report

[Christopher Lam]

Which version? There was a change in date strategy for reconciliation 
report in the past couple releases.


Would you mind attaching a screenshot?

If you need to hide sensitive data, any paint program such as MSPaint 
can hide data.


Please switch option "General / Add options summary" to "always".


On 10/08/18 21:59, Mike stagl wrote:

When running a stock reconciliation report, I cannot get the Start Date and End 
Date to work correctly.  If I choose Start of Previous Month and End of 
Previous Month, or even use actual dates, I get transactions from the start 
date all the way to the current date.


This month I am seeing un-reconciled transactions from August, when I am 
running a report with the dates 7/1/2018 to 7/31/2018.


For what it's worth, other reports appear to correctly implement the date.


Thanks for any help,


Mike
___
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] Reconciliation Report

[David Carlson]

Which version of GnuCash are you using and which OS?

On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl  wrote:

> When running a stock reconciliation report, I cannot get the Start Date
> and End Date to work correctly.  If I choose Start of Previous Month and
> End of Previous Month, or even use actual dates, I get transactions from
> the start date all the way to the current date.
>
>
> This month I am seeing un-reconciled transactions from August, when I am
> running a report with the dates 7/1/2018 to 7/31/2018.
>
>
> For what it's worth, other reports appear to correctly implement the date.
>
>
> Thanks for any help,
>
>
> Mike
> ___
> 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] Reconciliation Report

[Christopher Lam]

The reconcile report 'date' selection applies to the 'reconcile date', 
so any reconciled transaction whose reconcile-date falls between 
start-date and end-date is included. I think this behaviour applies from 
3.2 onwards.


Any unreconciled transactions are also included. The reasoning was that 
any unreconciled transactions were deemed likely to be useful in a 
reconciliation report. This also roughly matches the behaviour of the 
formal reconcile tool -- it lists any cleared or unreconciled 
transactions (income on left, expense on right), ready for ticking prior 
to clicking 'Finalise'.



On 11/08/18 01:04, Mike stagl wrote:

Sorry, I forgot the basics.  GnuCash 3.2 on Windows 7.


I've attached a screenshot as well.

Thanks in advance!


Mike


From: David Carlson 
Sent: Friday, August 10, 2018 11:23 AM
To: Mike stagl
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciliation Report

Which version of GnuCash are you using and which OS?

On Fri, Aug 10, 2018 at 8:59 AM, Mike stagl 
mailto:m_st...@hotmail.com>> wrote:
When running a stock reconciliation report, I cannot get the Start Date and End 
Date to work correctly.  If I choose Start of Previous Month and End of 
Previous Month, or even use actual dates, I get transactions from the start 
date all the way to the current date.


This month I am seeing un-reconciled transactions from August, when I am 
running a report with the dates 7/1/2018 to 7/31/2018.


For what it's worth, other reports appear to correctly implement the date.


Thanks for any help,


Mike
___
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] Production of UK VAT reports

[Edacc]

Hi,

There is documentation on employing a Gnuash account hierarchy to produce
special purpose gl codes for VAT, and that is extremely helpful. I can see
that a report could be then run against them to produce the numbers to go
into the various boxes of the return and first time round the return can be
filtered by 'before the cut off date' so transactions belonging to a future
quarter are not included.

Next time the VAT report is required for the following period the 'before
date' filter stops me including post date transactions again, but how do I
not include transactions dated within the prior period, but not included in
the prior return?

This is a common situation, especially with input transactions which can get
'temporarily lost' and are posted to the books after preparation of a
period's VAT return although they are dated within that period. The proper
thing to do is then to include them in the next VAT return, and because they
are inputs there is no cashflow loss to HMRC so no hassle.

Other computerised and paper systems I have seen have a mechanism to also
mark all transactions included in a VAT report and form with either a simple
'VAT done' flag, or an identifier for the specific VAT period return the
transaction has been reported on. I am struggling to find anything
equivalent to this in GnuCash (and there is so much other real good stuff).

Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
other statutory schemes both in relation to the taxes due/deductible and
total inputs and outputs. In regards the VAT I am thinking about the
standard arrangement, not cash accounting or fixed payment on account VAT
arrangements.

If VAT returns are being done with GNUCash I am presuming there is a simple
answer.

Many thanks



--
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] Error in Finance:Quote

[Shokster]

Hi all, sorry if this is not the right place (if so, please advise) for this
post. 
 
I'm having a hard time trying to get GnuCash to 'Get Quotes'. It throws an
error saying 'Unable to retrieve quotes for these items: Currency:INR
Continue using only the good quotes? Yes/No'. 
 
I've got just the 1 security for now. It's a mutual fund code 101143 at
https://www.amfiindia.com/spages/NAVAll.txt
 
Seems like it's setup ok on Security editor. 
 
 
So, I've had a crash course into running perl modules, and ran (from a
run.bat file): 
 
perl "C:\Program Files (x86)\gnucash\bin\gnc-fq-dump" indiamutual 125112
pause 
 
This works as: 
 
 
But I can't figure out why the 'Get Quote' via GnuCash won't work! :( 
 
>From reading around, there seems to be a major shift (to Alpha Vantage) that
shouldn't be relevant to this case? 
 
Currently, I work with Excel, and will port my accounts to GnuCash if the
price editor can import mutual fund NAV'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] Production of UK VAT reports

[Christopher Lam]

The simple answer is there is no 'VAT-done' flag. You'd either book the 
VAT-able transaction using posted-date, or not... If a transaction is 
booked in error and already processed/reported to authorities, then do 
another reversing transaction (IMHO; if the accountant agrees) at a 
later date.



On 10/08/18 19:27, Edacc wrote:

Hi,

There is documentation on employing a Gnuash account hierarchy to produce
special purpose gl codes for VAT, and that is extremely helpful. I can see
that a report could be then run against them to produce the numbers to go
into the various boxes of the return and first time round the return can be
filtered by 'before the cut off date' so transactions belonging to a future
quarter are not included.

Next time the VAT report is required for the following period the 'before
date' filter stops me including post date transactions again, but how do I
not include transactions dated within the prior period, but not included in
the prior return?

This is a common situation, especially with input transactions which can get
'temporarily lost' and are posted to the books after preparation of a
period's VAT return although they are dated within that period. The proper
thing to do is then to include them in the next VAT return, and because they
are inputs there is no cashflow loss to HMRC so no hassle.

Other computerised and paper systems I have seen have a mechanism to also
mark all transactions included in a VAT report and form with either a simple
'VAT done' flag, or an identifier for the specific VAT period return the
transaction has been reported on. I am struggling to find anything
equivalent to this in GnuCash (and there is so much other real good stuff).

Similar considerations would apply to UK HMRC NRLT, CIS, IPT, MGD and many
other statutory schemes both in relation to the taxes due/deductible and
total inputs and outputs. In regards the VAT I am thinking about the
standard arrangement, not cash accounting or fixed payment on account VAT
arrangements.

If VAT returns are being done with GNUCash I am presuming there is a simple
answer.

Many thanks



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

Re: [GNC] Hidden accounts and balances

[David Cousens]

Bridgit,

The hidden feature in GnuCash simply means that the account will not be
visible in the Account Tree (and any popup selection menus ? - see below),
not that the account is inactive, and not in use at all and is effectively
removed from the account tree.

A hidden account can still have transactions which target the account, its
balance still sums into any parent accounts. It is primarily a convenience
to simplify the account tree presentation and selection popups. This is an
exerpt from the help manual on creating accounts
https://www.gnucash.org/docs/v3/C/gnucash-help/acct-create.html

"The Placeholder check-box sets an account to read-only status and prevents
the addition of transaction data to the account.

Note
Setting an account to Placeholder will also hide that account in the pop-up
account list in a register. Sub-accounts to the placeholder account will
still display in the pop-up, however.

The Hidden check box hides an account (and any sub-accounts) in the account
tree. To reset this option, you will first need to open the View → Filter
By... dialog for the account tree and check the Show hidden accounts option.
Doing so will allow you to select the account and reopen this dialog.

Note
Hidden accounts still appear in the pop-up account list in a register. To
remove an account from this pop-up account list as well, check the
Placeholder check box."

It is also worth noting here that an account which has transactions into it
can be set as a placeholder, i.e. readonly and the existing transactions can
remain, it still has a balance associated with those transactions and
itsbalance should also include the sum of any child accounts as well as any
transactions to the placeholder itself.

If you want to remove an account from the account tree completely the Delete
Account option in the popup menu which appears when you right click on an
account in the account tree presents you with a dialog which will transfer
the transactions in the account to another specified account before deleting
the account.

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.