Re: Virtual accounts or line items

2017-08-06 Thread David Carlson 
My bank does permit the customer to assign a 'category' to a transaction,
somewhat like some credit cards do.  I have no idea if that info would be
included in a OFX export.

David C



On Sun, Aug 6, 2017 at 7:43 PM, Jon Schewe  wrote:

> Ideally what I would like would be for some "real" transactions to
> reference the parent account and some to reference the virtual account.
> Then when importing the QFX the import process would look in the parent
> account and the sub-accounts.
>
>
> On Sun, Aug 6, 2017 at 6:15 PM, David Carlson  > wrote:
>
>> What I do is keep two register views open on the 'parent' account, one
>> 'with sub-accounts' which shows the totals as seen by the bank and one
>> normal register view which shows the amount not dedicated to the 'virtual'
>> sub-account(s).
>>
>> As suggested in the thread that you cited, I do not tell the bank
>> anything about the 'virtual' sub-account(s) transactions, so they will
>> never appear in an imported transaction list and thus they are never
>> 'cleared' via the import.  While it is not required to have a register view
>> open during an import, I always do, because I have a lot of cases where the
>> import process makes matching mistakes or incorrect transfer account
>> assignments if I do not monitor it.
>>
>> In any case, my reconciliation is intended to verify transactions with
>> the bank, and it still works correctly in the 'with sub-accounts' register
>> view.  The 'Include Sub-Accounts option is not required.  I then look in
>> the 'virtual' sub-account(s) register(s) and I can reconcile them
>> separately.  For those accounts the reconciliation only tells me that I am
>> satisfied with those transactions.
>>
>> As for budgeting, I do not use that feature, so I cannot comment.
>>
>> David C
>>
>> On Sun, Aug 6, 2017 at 2:19 PM, Jon Schewe  wrote:
>>
>>> I've got a question about using virtual accounts along with QFX imports.
>>>
>>> I found this thread about using virtual accounts to do budgeting:
>>> http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html
>>>
>>> I rather like how it works from the perspective that I know how much
>>> money
>>> is available in my checking account for things that I haven't budgeted.
>>> This also works well when reconciling against my statement as I can check
>>> the box to include sub-accounts and everything balances.
>>>
>>> However when I import a QFX file, the importer will only look at the top
>>> level account for transactions. This means that I need to manually clear
>>> the transactions in the sub-accounts.
>>>
>>> My wife uses Quickbooks at work and says there is a view that works for
>>> her
>>> for this. She can create these virtual sub-accounts and see their
>>> individual transactions, however when she looks at the top-level account
>>> she sees all transactions for the top account and the sub-accounts.
>>>
>>> Is there a way to do this in GnuCash?
>>>
>>> Thanks,
>>>
>>> - Jon
>>>
>>> --
>>> 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.
>>>
>>
>>
>
>
> --
> 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.

Re: Suggestion

2017-08-06 Thread David Carlson 
For me the time to move, decrypt, and decompress the data file and generate
the register views and report views is so much longer than loading the
program that I do not even try to measure that part.

David C

On Sun, Aug 6, 2017 at 5:50 PM, Greg Feneis  wrote:

> Also FWIW, I just started GnuCash V...16 (not quite the latest) on my 6
> year old Win 7 laptop and it only took 25 Seconds to get to where it begins
> loading the data file.  While a lot of my programs take between 2 and 5
> seconds to load, I do have a few that take quite a bit longer to load than
> GnuCash does (programing, simulation, cad environments, etc.).
> ​
> Are other folks having a significantly longer wait than 25 Seconds for
> GnuCash to go from start to begin loading of data file?
>
> Kind regards,
>
> Greg Feneis
>
>
>
> On Sun, Aug 6, 2017 at 2:50 PM, aegross  wrote:
>
> > >>
> > On zondag 6 augustus 2017 16:46:24 CEST Sam McCoy wrote:
> > >Gentlemen:
> > >
> > >I have noticed the time it takes to load all the modules when
> starting
> > >up Gnu Cash.
> >
> > FWIW, I have anecdotally noticed that by far the longest module required
> to
> > load is Finance::Quote, which strictly speaking, is not GnuCash code.
> >
> > Regards,
> > AEG
> >
> >
> >
> >
> >
> > --
> > View this message in context: http://gnucash.1415818.n4.
> > nabble.com/Suggestion-tp4693076p4693081.html
> > Sent from the GnuCash - User mailing list archive at Nabble.com.
> > ___
> > 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: Virtual accounts or line items

2017-08-06 Thread David Carlson 
What I do is keep two register views open on the 'parent' account, one
'with sub-accounts' which shows the totals as seen by the bank and one
normal register view which shows the amount not dedicated to the 'virtual'
sub-account(s).

As suggested in the thread that you cited, I do not tell the bank anything
about the 'virtual' sub-account(s) transactions, so they will never appear
in an imported transaction list and thus they are never 'cleared' via the
import.  While it is not required to have a register view open during an
import, I always do, because I have a lot of cases where the import process
makes matching mistakes or incorrect transfer account assignments if I do
not monitor it.

In any case, my reconciliation is intended to verify transactions with the
bank, and it still works correctly in the 'with sub-accounts' register
view.  The 'Include Sub-Accounts option is not required.  I then look in
the 'virtual' sub-account(s) register(s) and I can reconcile them
separately.  For those accounts the reconciliation only tells me that I am
satisfied with those transactions.

As for budgeting, I do not use that feature, so I cannot comment.

David C

On Sun, Aug 6, 2017 at 2:19 PM, Jon Schewe  wrote:

> I've got a question about using virtual accounts along with QFX imports.
>
> I found this thread about using virtual accounts to do budgeting:
> http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html
>
> I rather like how it works from the perspective that I know how much money
> is available in my checking account for things that I haven't budgeted.
> This also works well when reconciling against my statement as I can check
> the box to include sub-accounts and everything balances.
>
> However when I import a QFX file, the importer will only look at the top
> level account for transactions. This means that I need to manually clear
> the transactions in the sub-accounts.
>
> My wife uses Quickbooks at work and says there is a view that works for her
> for this. She can create these virtual sub-accounts and see their
> individual transactions, however when she looks at the top-level account
> she sees all transactions for the top account and the sub-accounts.
>
> Is there a way to do this in GnuCash?
>
> Thanks,
>
> - Jon
>
> --
> 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.
>
___
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: Trouble installing Finance::Quote on Mac OSX Yosemite

2017-08-06 Thread aegross 
You didn't mention whether you installed XCODE...which is required for OS X.

Regards,
AEG 





--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Trouble-installing-Finance-Quote-on-Mac-OSX-Yosemite-tp4693082p4693083.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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.

Trouble installing Finance::Quote on Mac OSX Yosemite

2017-08-06 Thread Daniel Dickinson 
I installed GnuCash 2.6.17 and it runs fine.  However, I am having trouble with 
Finance::Quote.  Initially FinanceQuote Update wouldn't run, but I got around 
that by allowing apps from unidentified developers.  When I launch it, it opens 
a terminal window and asks for my password.  It tries to install 
Finance::Quote, but gets stuck at the following:


Running make test

PERL_DL_NONLAZY=1 "/usr/bin/perl" "-Iblib/arch" "-Iblib/lib" 
"-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef 
*Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

t/00compile.t . ok

t/01perl_bugs.t ... ok

t/02-xsdynamic.t ..


It never completes the 02-xsdynamic.t test, just sits there.  But the process 
at the top of the terminal window changes back and forth periodically between 
"lipo" and "xcrun."  I'd guess it's stuck in some kind of a loop.  I checked 
the console but didn't see any error messages that appeared to be related to 
this.


I also tried installing manually using

perl -MCPAN -e shell
 install Finance::Quote

This completed successfully, but GnuCash doesn't seem to know that 
Finance::Quote is there - when I try to download quotes, it says "There was a 
system error while retrieving the price quotes."  Again there is nothing in the 
console that would give any insight about what's going on.


Thanks for any suggestions.


___
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: Suggestion

2017-08-06 Thread aegross 
>>
On zondag 6 augustus 2017 16:46:24 CEST Sam McCoy wrote:
>Gentlemen:
> 
>I have noticed the time it takes to load all the modules when starting
>up Gnu Cash.  

FWIW, I have anecdotally noticed that by far the longest module required to
load is Finance::Quote, which strictly speaking, is not GnuCash code.

Regards,
AEG





--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Suggestion-tp4693076p4693081.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
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

2017-08-06 Thread Colin Law 
On 6 August 2017 at 18:06, Frank H. Ellenberger
 wrote:
> Hi Jerry,
>
> Am 06.08.2017 um 04:15 schrieb Jerry Lanese:
>> Frank,
>> I am a small business owner trying to use GNUCASH and having some problems.  
>> Is there anyone I can call.
>
> We have a moderated user list which I cc. You might consider to
> subscribe at https://lists.gnucash.org/mailman/listinfo/gnucash-user
>
>> I am having trouble with split transactions and now the system is
>> telling me that it will not save what I have.  I know I have lost
>> about 3 hours of work.

*Always* tell us what the error message is when you ask for help about
such a problem.
Possibly you cannot save to the directory you have specified, for some
reason or another. If you use File > Save As you should be able to
browse to a directory that you *can* save to and save it there, so you
will not lose your work.

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

Virtual accounts or line items

2017-08-06 Thread Jon Schewe 
I've got a question about using virtual accounts along with QFX imports.

I found this thread about using virtual accounts to do budgeting:
http://gnucash.1415818.n4.nabble.com/Virtual-accounts-td1421283.html

I rather like how it works from the perspective that I know how much money
is available in my checking account for things that I haven't budgeted.
This also works well when reconciling against my statement as I can check
the box to include sub-accounts and everything balances.

However when I import a QFX file, the importer will only look at the top
level account for transactions. This means that I need to manually clear
the transactions in the sub-accounts.

My wife uses Quickbooks at work and says there is a view that works for her
for this. She can create these virtual sub-accounts and see their
individual transactions, however when she looks at the top-level account
she sees all transactions for the top account and the sub-accounts.

Is there a way to do this in GnuCash?

Thanks,

- Jon

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

Re: GnuCash

2017-08-06 Thread Frank H. Ellenberger 
Hi Jerry,

Am 06.08.2017 um 04:15 schrieb Jerry Lanese:
> Frank,
> I am a small business owner trying to use GNUCASH and having some problems.  
> Is there anyone I can call.

We have a moderated user list which I cc. You might consider to
subscribe at https://lists.gnucash.org/mailman/listinfo/gnucash-user

> I am having trouble with split transactions and now the system is
> telling me that it will not save what I have.  I know I have lost
> about 3 hours of work.
Did you read the Tutorial and Concepts Guide? If not already installed
on your systen (try F1 or the help menu) you can read it at
http://www.gnucash.org/docs.phtml .

> 
> Jerry Lanese

Regards
Frank
___
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: Suggestion

2017-08-06 Thread Geert Janssens 
On zondag 6 augustus 2017 16:46:24 CEST Sam McCoy wrote:
>Gentlemen:
> 
>I have noticed the time it takes to load all the modules when starting
>up Gnu Cash. Many of these modules have names that suggests they
>support business activities. I believe there are many users (loke me)
>that use gnu cash strictly for personal finances. I would therefore
>like to suggest to the developers that a smaller version of Gnu Cash be
>considered that would be sans business support, i.e invoicing, customer
>db, etc. The resulting module would be smaller and load more quickly.
>Thanks for providing me with the best damn program on planet earth.
> 
>Al Trudeau

Hi Sam,

I'm happy you enjoy using gnucash.

As to your suggestion I am about to integrate some code changes that drop the 
separate business modules and integrate all of that code into the core of 
gnucash. Rather the opposite of what you are asking. The reason for this is 
that most of the business functionality is already part of the gnucash core. 
The only things still in the loadable modules you see at startup were some gui 
related bits and pieces.

Instead I would like to ask: have you actually timed the loading of the 
business modules in the whole of the startup time ? I have my doubts whether 
removing them will have a noticeable improvement on the load performance.

Having said all that however, I do agree it would be very nice to improve the 
load performance. John Ralls has looked at this in the past and from that work 
I remember most time is lost because gnucash makes plenty of jumps between c 
code and guile code, not due to the loading of one random module in itself. 
Work is on the way to improve this, but we're not there yet. There are several 
aspects that are planned in this respect:
1. the use of guile will be reduced in the core
2. module loading will probably be revisited at some point
3. the long term goal is to make gnucash a database driven application, to 
eliminate the slow load time of the data file itself

Regards,

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

Suggestion

2017-08-06 Thread Sam McCoy 
   Gentlemen:

   I have noticed the time it takes to load all the modules when starting
   up Gnu Cash. Many of these modules have names that suggests they
   support business activities. I believe there are many users (loke me)
   that use gnu cash strictly for personal finances. I would therefore
   like to suggest to the developers that a smaller version of Gnu Cash be
   considered that would be sans business support, i.e invoicing, customer
   db, etc. The resulting module would be smaller and load more quickly.
   Thanks for providing me with the best damn program on planet earth.

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