New transaction report (Was: Migration from Quicken 98)

[George Riner]

I can no longer put it off.  I entered a particular string amongst about 
30-40 transactions so that I could do a 'classes-style' report that 
would search for my string to find the transactions I want to report.  
Reviewing the capabilities of the 'standard reports', I see that I 
cannot accomplish this.  But there are messages about a 'new transaction 
report' from a Doug Doughty that would accomplish what I'm trying for.


So, how do I get a hold of this report? Is it something that can be 
attached to an email? Is it something that can be downloaded from some 
repository of custom reports? Do I have to ask Doug to send it to me?


Once I obtain it, I'll try to figure out how to install it so I can try 
to use it.


:George
Gnucash 2.6.17
Windows 10



On 3/26/2017 1:00 PM, david.carlson@gmail.com wrote:






 There is another thread on the gnucash user maillist about a new 
transaction report from Doug or Cindy Doughty with about 30 messages.  I do not 
know how to put a link to it while using my tablet to write this message.
Go through that thread in reverse to find the last revision.
David C
Sent from my LG G Pad 7.0 LTE, an AT 4G LTE tablet



-- Original message--From: Roger MillsDate: Sun, Mar 26, 2017 1:22 
PMTo: 'Christopher Lam';Cc: gnucash-user@gnucash.org;Subject:RE: Migration from 
Quicken 98
That sound like a possibility – thanks. How do I go about finding Doug 
Doughty’s new transaction report? [I am new to GnuCash and to this mailing list 
– and am still at the stage of needing to satisfy myself that GnuCash will do 
everything I need before I start using it in anger]. Cheers,Roger  From: 
Christopher Lam [mailto:christopher@gmail.com] Sent: 26 March 2017 15:51To: 
Roger MillsCc: gnucash-user@gnucash.orgSubject: Re: Migration from Quicken 98 I 
would approximate categories by tagging transactions in any of the available 
free-text fields - description/memo/notes. eg. tag Annual Insurance payment 
with @holidayhomeThanks to Doug Doughty's new Transaction-Report you will be 
able to arbitrarily report by searching these fields.But the Standard Reports 
are not currently able to search similarly.  On 26 March 2017 at 02:11, Roger 
Mills  wrote:I'm trying to migrate several sets of accounts from Quicken 98 to 
GnuCash,and would like some advice.I am aware that I need to create an 
'account' for each 'category' inQuicken, and that's not a problem.But I also 
make extensive use of 'Classes' in Quicken, and can't readily seehow to 
replicate this in GnuCash. As an example, I use classes todistinguish between 
expenditure associated with my main home and my holidayhome. The expenditure 
comes out of the same set of physical bank/credit cardaccounts, and involves 
essentially the same types (Categories) ofexpenditure - insurance, utility 
bills, maintenance, etc.One possible approach may be to create an hierarchy 
with an account for eachclass and with sub-accounts, sub-sub-accounts, etc. 
beneath that to replaceQuicken's categories and sub-categories. But that 
doesn't really cut itbecause, in Quicken, categories and classes and 
independent of each otherrather than being hierarchical, and can appear in any 
combination. If, forexample, I had 8 classes and 10 categories, it appears that 
I would have tocreate upwards of 80 'accounts' to cover all the combinations. 
Even then, itmay not achieve the desired result.At various times I may wish to 
see all expenditure associated with aparticular class regardless of category 
and, at other times, all expenditureof a certain type (category) regardless of 
class. Depending on which wayround the hierarchy is arranged, only one of these 
appears to be possible.Hopefully, I'm missing something, and I would be 
grateful for any pointersas to what it may be. I would also be grateful for any 
available casestudies showing how other people have migrated Quicken accounts - 
which useboth categories and classes - into GnuCash.Many thanks,Roger 
MillsWarwick - UK___gnucash-user 
mailing 
listgnucash-user@gnucash.orghttps://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. No virus found in this message.Checked by AVG - 
www.avg.com  Version: 2016.0.8007 / Virus Database: 4767/14182 - Release Date: 
03/25/17___gnucash-user mailing 
listgnucash-user@gnucash.orghttps://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.



___
gnucash-user 

Re: For UK users: Will gnucash get ready for Making Tax, Digital ?

[John Ralls]

> On Jul 26, 2017, at 5:52 PM, Buddha Buck  wrote:
> 
> GnuCash does not currently (to my knowledge) support any
> jurisdiction-specify tax policy or reporting requirements. To do so for one
> would imply that it should do so for all, and that is a maintenance
> nightmare. As such, I think it more likely that someone would write a
> program that can take reports or data that GnuCash can already generate
> (CSV exports? OFX exports?) and uploads the necessary info to HMRC.

GnuCash can generate TXF files that certain US and German tax prep software can 
support. Alex Aycinena maintains the former and Christian Stimming the latter, 
but Christian has had real life intervene and doesn’t at present have time to 
contribute code to GnuCash so I suspect that the German version is out of date.

If anyone else would like to contribute a similar report for their country 
we’ll be happy to add it to the distribution, but one should bear in mind that 
doing so is a commitment to maintain it with typically annual updates.

That applies to MTD as well: Of our current regular contributors only Mike 
Evans is British; if he’s not motivated to develop the support someone else 
from the UK will have to step up or it won’t happen.

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: Tracking a TIAA mixed fund account

[AC]

On 2017-07-26 12:17, Eric Siegerman wrote:
> (Lost the attribution; sorry):
>> Assets:TIAA (cash)
>> Assets:TIAA:Lifecycle 1 (commodity)
>> Assets:TIAA:Lifecycle 2 (commodity)
>> Assets:TIAA:TIAA Mutual Fund (commodity)
> 
> I've never heard of TIAA before, but from what's been said, I
> infer that an account there behaves enough like a normal
> investment account for what follows to make sense, i.e. that it
> can hold numerous securities, but can also directly hold cash.
> 
> If that's so, I'd make one small change to the suggested layout:
> track the cash holdings in a fourth subaccount, rather than
> dumping them into the parent account, like so:
> 
> Assets:TIAA (placeholder -- see below)
> Assets:TIAA:Cash (cash)
> Assets:TIAA:Lifecycle 1 (commodity)
> etc.
> 
> That way you can see at a glance how much uninvested cash the
> TIAA account holds, while the parent Assets:TIAA GNC account
> shows its total value.
> 
> In this scheme, you'd never enter transactions directly into
> Assets:TIAA, but only into its subaccounts.  Turning the former
> into a "placeholder account" would help prevent mistakes in that
> regard, but is entirely optional.


The account does not have the ability to hold cash, whatever is sent
over to them from my paycheck is directly invested in one of the three
commodities.  The only thing the account has is a current cash value
based on the current market values of the commodities.  I'm going to try
the structure in a new file and see how it behaves.  If everything looks
ok then I'll recreate the structure in my main file and start entering
the data.
___
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: For UK users: Will gnucash get ready for Making Tax, Digital ?

[Buddha Buck]

On Wed, Jul 26, 2017 at 6:53 PM  wrote:

>
>The need for a secret code to identify approved software was mentioned.
>Secret or not, why is it against OpenSource ideals when HMRC wants to
>assure that only software with the right capabilities can be used?
>

One of the ideals of FOSS is that anyone should have the ability to examine
and modify FOSS software to meet their own needs.

This means that it is impossible within the FOSS ideals to prevent a user
from making changes to software they receive, and it is difficult, if not
impossible, to embed a "secret" into the software.

If the AuthID/API key is used to identify the company/user using the MTD
API, then there isn't a problem; it's basically an installation-specific
password and will be different for each taxpayer.

The problem comes when HMRC wants to use a secret key to identify the
software using their API, and expects software vendors to apply for the API
key, distribute that API key to all their endusers, and expect the keys to
be secret. When anyone can download GnuCash from GitHub and build it from
source themselves, keeping that key secret just isn't possible in practice.

Software is constantly being updated and modified -- both FOSS and
commercial -- so realistically the best that HMRC can do is to certify
specific versions and distributions of any software program. It may be the
case that someone is willing to get a particular version of GnuCash
certified, but they won't be able to do it in a way that would allow a
secret key to remain secret. What they can do is say "The version of
GnuCash distributed on this site, with MD5 hash x is certified by
HMRC", and that certification won't hold for any other version.

Personally, I think relying on certification and secret keys to discourage
malfeasors is a bad idea. If the protocol allows people to do bad things,
then the bad guys will reverse-engineer the protocol, wiretap the
connections between their "legit" copies of Quicken or whatever to capture
the secret key, and Bob's your uncle.

Rather, as with anything, the onus is on the registered taxpayer to send
good information. The HMRC servers and protocols should be robust to
attack, and software which implements the protocol shouldn't be required to
identify itself except in an advisory capacity.

In which case, GnuCash, if it should choose to support it, could implement
the protocol, but explicitly make no warrantees about being "certified" or
suitable for purpose. Since already GnuCash does not warrant itself as
being correct for tax purposes in any jurisdiction (after all, anyone can
use it incorrectly), it wouldn't be a change of policy.

GnuCash does not currently (to my knowledge) support any
jurisdiction-specify tax policy or reporting requirements. To do so for one
would imply that it should do so for all, and that is a maintenance
nightmare. As such, I think it more likely that someone would write a
program that can take reports or data that GnuCash can already generate
(CSV exports? OFX exports?) and uploads the necessary info to HMRC.
___
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.

For UK users: Will gnucash get ready for Making Tax, Digital ?

[Mike . Minh]

   [If you don't mind me saying this: I haven't seen mailman lists for
   quite some years and I was a little surprised to see they still exist.
   I could not find any way how to add another comment to a given thread,
   despite having started the thread myself.  This contribution may well
   appear as a new thread]


   I'm glad to see that I sucessfully triggered a discussion about MTD.

   Whilst it may take  longer than anticipated to see MTD in full swing,
   one thing is clear, it will come.
   It's a Government project, UK GOV is not exactly famous for meeting
   deadlines (or budgets).

   HMRC's plans were already delayed twice very substantially, the Finance
   Bill this year was amended so heavily in the last minute, hardly any of
   the MTD aims were left. All this down to the dreadful Brexit
   referendum, followed closely by a General Election.

   May I add to some of the points mentioned:

   The VAT treshold (£85K turnover pa) is not a realiable indicator for
   who might be affected or not. You can for instance voluntarily register
   for VAT (my company did, and the reason has little to do with money,
   but with getting access to clients who would not deal with a
   non-registered biz)

   This is also not just about submitting VAT returns electronically.
   There will eventially be a need to keep electronic records on
   transaction basis, for the smaller businesses maybe not initially, but
   it will become a requirement eventually.

   Exceptions named by HMRC were notably religious communities whose
   beliefs don't allow to use electronic communication. No joke. They have
   thought of everything, right?

   Any yes, nobody has any specs yet. No reason to put the head into the
   sand. Sage, Quickbooks or XERO, nobody knows. At any rate, the earlier
   the gnucash dev community starts preparing for MTD, the better.

   The need for a secret code to identify approved software was mentioned.
   Secret or not, why is it against OpenSource ideals when HMRC wants to
   assure that only software with the right capabilities can be used?

   Some more links:

   [1]http://webarchive.nationalarchives.gov.uk/20161207201022/https://www
   .gov.uk/government/publications/making-tax-digital

   [2]https://www.gov.uk/government/news/next-steps-on-the-finance-bill-an
   d-making-tax-digital (only published on 13 July 2017)

References

   1. 
http://webarchive.nationalarchives.gov.uk/20161207201022/https://www.gov.uk/government/publications/making-tax-digital
   2. 
https://www.gov.uk/government/news/next-steps-on-the-finance-bill-and-making-tax-digital
___
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: Name Does Not Show in Posts

[Robert Heller]

It is a setting in your E-Mail client (or Juno's webmail program).  You need 
to tell your client (or Juno's webmail program) to include your *name* as the 
E-Mail "comment", instead of your *email* address (which is what it is now).


At Wed, 26 Jul 2017 19:42:23 GMT "pfwoolver...@juno.com" 
 wrote:

> 
> 
> 
> My name does not show in my posts to the mailing list.  My email shows in the 
> name field.
> 
> I have my name in the optional name field in my Gnucash-user account.  What 
> do I need to do to get my name to show?
> 
> ___
> 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.
> 
> 

-- 
Robert Heller -- 978-544-6933
Deepwoods Software-- Custom Software Services
http://www.deepsoft.com/  -- Linux Administration Services
hel...@deepsoft.com   -- Webhosting Services
   
___
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.

Name Does Not Show in Posts

[pfwoolver...@juno.com]

My name does not show in my posts to the mailing list.  My email shows in the 
name field.

I have my name in the optional name field in my Gnucash-user account.  What do 
I need to do to get my name to show?

___
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: Tracking a TIAA mixed fund account

[Eric Siegerman]

(Lost the attribution; sorry):
> Assets:TIAA (cash)
> Assets:TIAA:Lifecycle 1 (commodity)
> Assets:TIAA:Lifecycle 2 (commodity)
> Assets:TIAA:TIAA Mutual Fund (commodity)

I've never heard of TIAA before, but from what's been said, I
infer that an account there behaves enough like a normal
investment account for what follows to make sense, i.e. that it
can hold numerous securities, but can also directly hold cash.

If that's so, I'd make one small change to the suggested layout:
track the cash holdings in a fourth subaccount, rather than
dumping them into the parent account, like so:

Assets:TIAA (placeholder -- see below)
Assets:TIAA:Cash (cash)
Assets:TIAA:Lifecycle 1 (commodity)
etc.

That way you can see at a glance how much uninvested cash the
TIAA account holds, while the parent Assets:TIAA GNC account
shows its total value.

In this scheme, you'd never enter transactions directly into
Assets:TIAA, but only into its subaccounts.  Turning the former
into a "placeholder account" would help prevent mistakes in that
regard, but is entirely optional.

  - Eric
___
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: 2.6.17 for MacOS X

[Alan Magnus]

Thanks guys. I copied the file to the new location and 2.6.17 started up up 
properly and now works.
 

> On 26 Jul 2017, at 00:18, John Ralls  > wrote:
> 
> OK, I did the upgrade and tested. Copying the file from /usr/lib/ does indeed 
> fix the problem in 2.6.17.
> 
> Curiously 2.6.16 started right up without complaint and without needing to be 
> changed.
> 
> Regards,
> John Ralls
> 
>> On Jul 25, 2017, at 8:43 PM, John Ralls > > wrote:
>> 
>> The fundamental problem is documented sort-of in this bug: 
>> https://github.com/Dead2/zlib-ng/issues/80 
>> >  >
>> 
>> The simplest solution until the next release is to copy 
>> /usr/lib/libz.1.dylib into Gnucash.app/Contents/Resources/lib. You might 
>> want to move the existing one aside first just to be safe.
>> 
>> Regards,
>> John Ralls
>> 
>>> On Jul 25, 2017, at 3:56 PM, davel...@mac.com  
>>> wrote:
>>> 
>>> 
 On Jul 25, 2017, at 5:53 PM, Alan Magnus > wrote:
 
 GNUCASH 2.6.17 does not open using the latest Beta release for Mac. Mac OS 
 X 13 Beta 4
>>> 
>>> 
>>> I can confirm the issue. Here is the problem:
>>> 
>>> Termination Reason:DYLD, [0x4] Symbol missing
>>> 
>>> Application Specific Information:
>>> dyld: launch, loading dependent libraries
>>> DYLD_FRAMEWORK_PATH=/Applications/Gnucash.app/Contents/Frameworks
>>> DYLD_LIBRARY_PATH=/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash::/System/Library/Frameworks/ApplicationServices.framework/Versions/A/Frameworks/ImageIO.framework/Versions/A/Resources/:/Applications/Gnucash.app/Contents/Resources/lib:/Applications/Gnucash.app/Contents/Resources/lib/gnucash
>>> 
>>> Dyld Error Message:
>>> Symbol not found: _inflateValidate
>>> Referenced from: 
>>> /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
>>> Expected in: /Applications/Gnucash.app/Contents/Resources/lib/libz.1.dylib
>>> in 
>>> /System/Library/Frameworks/ImageIO.framework/Versions/A/Resources/libPng.dylib
>>> 
>>> Dave
>>> 
>>> 
>>> ___
>>> 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.
> 
> ___
> 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: For UK users: Will gnucash get ready for Making Tax Digital ?

[Dr. David Kirkby (Kirkby Microwave Ltd)]

On 25 July 2017 at 17:54, David Goodenough <
david.goodeno...@linkchoose.co.uk> wrote:

>
> There is a problem.  They want to assign a secret ID to each piece of
> software
> and so if you say it is open source they then refuse to allocate an ID as
> it
> will not be secret.  I have raised this with the cabinet office digital
> dept,
> and they acknowledge that this effectively bans open source which is
> against
> official government policy.  They are trying to get this changed.
>
> David
>

I must admit I can't quite think how, but I'm sure some cryptology expert
could find a solution. Although I don't do it now, I was a regular
developer of the sagemath open-source maths program, started by Prof.
William Stein at the University of Washington.

http://www.sagemath.org/

Prof Stein is an expert in number theory, and many of the users of that
package are too. I will drop a few of them an email, and see if any of them
can come up with a solution.

Dave
___
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: Budget bar chart with sub-accounts

[Jon Schewe]

I did some debugging with the report and created a modified version that
shows all accounts. I filed a bug with GnuCash with the fix at
https://bugzilla.gnome.org/show_bug.cgi?id=785437.

On Sun, Jul 23, 2017 at 5:58 PM, Jon Schewe  wrote:

> Has anyone found a way to create a budget bar chart that sums the child
> accounts?
>
> I have a budget for Medical and I have a Medical account and sub accounts
> for Doctor and Prescription. I would like the bar chart to display the sum
> of Medical, Medical:Doctor, and Medical:Prescription vs. the Medical
> budget.
>
> I see that the text budget report does this.
>
> Right now I don't get any chart if the accounts have sub-accounts.
>
> Thanks
> - Jon
>
> --
> http://mtu.net/~jpschewe
>
>


-- 
http://mtu.net/~jpschewe
___
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.