Re: F::Q 1.40 uploaded

2017-11-05 Thread David T. via gnucash-user
Erik, Thank you for working on a fix to the Yahoo! Finance problem. I am sure it has been a challenge. As a general question to the GnuCash-users list: How do various GnuCash users upgrade their F::Q to use this newest version, and how should the environment variable be set? On my Mac, for

Re: Bank reconciliation history

2017-10-30 Thread David T. via gnucash-user
Mark, The simple answer is “No.” There isn’t any way from the GnuCash application to see which transactions were reconciled on which statements. I believe that the GnuCash data file does store reconcile information in the data file, but that information is not exposed in the GUI. You might be

Re: help finding my file

2017-10-20 Thread David T. via gnucash-user
Lorrie, With regard to the files on the desktop, David Carlson's advice is sound. As for keeping the app on your computer, I suspect that you were opening gnucash from the downloaded disk image; you must drag gnucash.app from that image into the Applications folder to complete the installation. 

Re: command line QIF import

2017-10-16 Thread David T. via gnucash-user
What do you mean "failed"? They aren't in the gnucash file at all? Or, they import incorrectly?  If the latter, take a look at some of the transactions that failed; is there something in common?  In my Quicken data, it was transactions that had no categories that caused the most problems. Fill

Re: importing

2017-10-07 Thread David T. via gnucash-user
Frank, The *other* David suggested importing each account separately; I was suggesting importing all at once. In my (admittedly ancient) experience, I worked to get the Quicken data just so, and when I imported everything, I had little to no duplicates. David (T.) > On Oct 7, 2017, at 7:17

Re: Mac OS X and mouseclick

2017-10-06 Thread David T. via gnucash-user
Is there a window hiding off screen somewhere? > On Oct 6, 2017, at 9:23 PM, Rich Harover wrote: > > Hello list from a newb. > > GC is running fine for me on my MacBook Pro (Mac OS X 10.12.6). > > I installed v 2.6.18 and tried to run on my iMac (Retina 5k, late

Re: Can't print checks or reports using gnucash

2017-10-03 Thread David T. via gnucash-user
Walter, I am not an expert, but the error kind of sounds like maybe Perl isn’t properly (re) installed? David > On Oct 3, 2017, at 1:19 AM, Walter Cinsavich wrote: > > I had a major windows 10 64 bit error. It was necessary to do a major > recovery process of windows

Re: Report Question

2017-10-02 Thread David T. via gnucash-user
Mike, I think the question is more about the report and how it aggregates information, rather than how the accounts are structured (although, of course that too can affect things). As Christopher Lam replied to the original poster’s posting of this on Saturday, the likely answer is to change

Re: Default terms

2017-09-30 Thread David T. via gnucash-user
> On Sep 30, 2017, at 3:31 PM, Geert Janssens <geert.gnuc...@kobaltwit.be> > wrote: > > On zaterdag 30 september 2017 12:17:11 CEST Maf. King wrote: >> On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user wrote: >>> Bob, >>> >

Re: Default terms

2017-09-30 Thread David T. via gnucash-user
Bob, I’m no expert, but the Guide at 14.5 says: "You can specify the billing terms on each invoice/bill. Invoice billing terms will default from the customer billing terms. Bill billing terms will default from the vendor billing terms.” It makes no statement about setting up default terms for

Re: Basic Register - Removing Unwanted Columns

2017-09-13 Thread David T. via gnucash-user
With regard to Debit/Credit: common use of these terms is not the same as use in formal accounting. Take a look at the Guide beginning at https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-accounting1.html

Re: custom reports: guile or eguile

2017-09-11 Thread David T. via gnucash-user
The referenced reports can be found in the list archives. On Mon, Sep 11, 2017 at 13:54, Dennis Powless wrote: Where did u find the report? D Sent from my iPhone > On Sep 11, 2017, at 4:37 AM, Gour wrote: > > Hello, > > thanks to reports

Re: Add icon for "Get Transactions..."

2017-09-08 Thread David T. via gnucash-user
Drew, As I understand it, there is no facility to customize the toolbars in GnuCash, since the underlying toolkit, gtk, doesn’t offer it. At least, that is what I was told when I asked a similar question a couple of years back. Sorry. As Derek noted, patches to enable this would be welcomed.

Re: Add icon for "Get Transactions..."

2017-09-08 Thread David T. via gnucash-user
Drew,  I'm not sure what suggestion you are talking about. Could you supply some context?  David P.S. Use Google to search the list archives.  On Fri, Sep 8, 2017 at 16:13, Drew H. wrote: I tried to search the archives to find anything regarding this suggestion but

Re: Reports with Month-end rather that Month-start

2017-09-05 Thread David T. via gnucash-user
Ken, I don’t know where in the code base you want to look—but I will note that “the last day of the month” is more difficult to calculate than “the first day of the month.” The first day is always number 1; the last day varies month to month. I know some software packages make use of a

Re: New user

2017-09-01 Thread David T. via gnucash-user
John,  Peter,  Whatever the reason for Morris to want this (I, for example occasionally want to see all the payments to/from one payee), the fact remains that GnuCash already offers this functionality, although it is buried in View->Sort by (our whatever that menu option is). So, Morris is

Re: Version Migration

2017-08-29 Thread David T. via gnucash-user
The biggest problem with the database back end is users' misconception that its use implies database functionality. They think it will allow them to perform database actions on the data set,  as well as have multiple users simultaneously. As you know, neither of these is true at this time. 

Re: OFX data file question

2017-08-16 Thread David T. via gnucash-user
http://www.ofx.net/ On Wed, Aug 16, 2017 at 17:12, Jeffrey Black wrote: I'm not sure where to look to find this information.  I am looking for a description/list of the fields GnuCash uses or rather needs out of OFX/QFX files. I am tired of GnuCash

Re: Exporting custom made reports

2017-07-27 Thread David T. via gnucash-user
Try looking at: https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-migrate-settings.html > On Jul 27, 2017, at 11:11 PM, Martijn Heuts wrote: > > Hello, I just setup GNU cash to a

Re: Scheduled transactions editor does not include ACTION feature | Use Bugzilla

2017-07-24 Thread David T. via gnucash-user
That peach colored area threw me as well; it is the main difference between the editor and a register. That was what I referred to earlier. Glad you got it figured out.  On Tue, Jul 25, 2017 at 7:45, aegross wrote: Fred Bone wrote >  > This seems strange. Using

Re: Unsubcribe

2017-07-24 Thread David T. via gnucash-user
Then do it. The power is in your hands! > On Jul 24, 2017, at 9:45 PM, Uma Ananth wrote: > > I have a similar request. Please unsubscribe uma...@gmail.com > Thanks > Uma > On Jul 24, 2017 7:51 AM, "Ashwin A" wrote: > >> Request you to unsubscribe

Re: Scheduled transactions editor does not include ACTION feature | Use Bugzilla

2017-07-23 Thread David T. via gnucash-user
Andrew,  I believe that you and I are talking about the same field, and that you are NOT talking about the Actions menu,  which Dave H. was talking about.  I specifically said the action field in a _transaction_; whether that transaction is in a register or the transaction editor should be, I

Re: Manually Post Scheduled Transactions

2017-07-23 Thread David T. via gnucash-user
Have you looked at section 4.5 of the Tutorial and Concepts Guide? https://www.gnucash.org/docs/v2.6/C/gnucash-guide/txns-sxn1.html Let us know what that fails to cover. David > On Jul 23, 2017, at 10:54 PM,

Re: Tracking a TIAA mixed fund account

2017-07-22 Thread David T. via gnucash-user
I may be misunderstanding,  but it seems like the following would work: Assets:TIAA (cash)Assets:TIAA:Lifecycle 1 (commodity)Assets:TIAA:Lifecycle 2 (commodity)Assets:TIAA:TIAA Mutual Fund (commodity) My experience of the so called "Lifecycle" funds is that they are just like any other mutual

Re: Flash Drive

2017-07-17 Thread David T. via gnucash-user
Christoph, Portable apps,  I believe, is Windows only; John was working with Linux. But portable apps could help some others.  David On Mon, Jul 17, 2017 at 11:43, Christoph R wrote: Hi John, even if you gave up on the topic I would like to point you

Re: Copying many transactions

2017-07-15 Thread David T. via gnucash-user
Actually, the dividends DON'T have to go to the fund account. You could register the reinvestment as a dividend transaction (to a cash account), followed by a buy transaction. That is how I handle these.  YMMV. Best, David   On Sat, Jul 15, 2017 at 12:15, azalea4va

Re: Transaction report - what are default accounts?

2017-07-14 Thread David T. via gnucash-user
If you are hoping to have your own account selections as a personal “default”, rename the report (on the General tab) and click "Save Report Configuration As.” Your custom settings will now be available under Reports->Saved Report Configurations. HTH, David > On Jul 15, 2017, at 5:21 AM,

Re:

2017-07-11 Thread David T. via gnucash-user
Kendall, I also see no problem: david$ ./gnc-fq-dump yahoo ITOT Finance::Quote fields Gnucash uses: symbol: ITOT <=== required date: 07/11/2017 <=== recommended currency: USD <=== required last: 55.3989 <=\

Re: When importing transactions, what happens to non-identical data in the description and notes fields?

2017-07-09 Thread David T. via gnucash-user
The importer includes three options: A, R and R+U. These mean: A = add the transaction as new R+U = reconcile the transaction with a matching transaction and update the existing GC transaction with the incoming data (description field etc.) R = Reconcile the incoming transaction with

Re: Reporting Repository ?

2017-07-02 Thread David T. via gnucash-user
John,  I am curious now about the status of the various reports included with gnucash. There have been a number of well-constructed reports put together by Doug that seemingly could be added to the program, and there are some bugs suggesting removal or rearrangement of some of the current

Re: Tracking Primary Residences

2017-06-26 Thread David T. via gnucash-user
Leo, I am sorry you were having trouble getting messages to the list. I am glad you got that straightened out. As to the point of tracking the value of your house, I’ll begin by saying I am not an accountant. However, I *have* been through the precise situation you describe, and I found out

Re: Tracking Primary Residences

2017-06-25 Thread David T. via gnucash-user
Leo, First, I don’t understand why you sent your email verbatim again to the list. Next, it seems to me that if you didn’t track the unrealized gains on your condo (which are not actually real, BTW), then you wouldn’t have a problem with the graphing of the non-existent gains. While it may

Re: Transaction Journal View - blank "Memo" instead of Description

2017-06-10 Thread David T. via gnucash-user
> On Jun 11, 2017, at 3:54 AM, Adrien Monteleone > wrote: > > >> On Jun 10, 2017, at 4:30 PM, Waitman Gobble wrote: >> >> >> Thanks. It appears top posting is preferred here? >> > >> >> It would be nice if I could double-click the

Re: GNUCash value proposition

2017-06-05 Thread David T. via gnucash-user
I won’t tell you how much trouble I had years ago when a bank employee accidentally keyed in the dollar portion of a check twice, and instead of a $621 check, I got tagged for $621,621. Imagine my surprise when I saw that my account was overdrawn by some $600,000… David > On Jun 5, 2017, at

Re: Reconciling an account

2017-06-03 Thread David T. via gnucash-user
John,  That sounds way more complicated than using the reconcile feature in Gnucash and following the guidance in the concept guide at chapter 4.4 & 5.4. When I reconcile using this method, I click reconcile, I select the correct ending date, adjust the closing balance to match the statement.

Re: How to close a financial year

2017-05-24 Thread David T. via gnucash-user
Don,  Your contributions will be welcome. As I do not close my books, and also do not use the business features, I can only offer you editorial guidance and general help in the process.  As for the term "Chart of Accounts", Gnucash uses this term for the page that displays all accounts in a

Re: Bulk Import Into Security Editor?

2017-05-18 Thread David T. via gnucash-user
Correct. How many securities do you have, that you would need a bulk import? David > On May 19, 2017, at 7:52 AM, Andrew Gross wrote: > > The Security Editor does not have a "bulk import" feature, correct? > > > Andrew Gross >

Re: lots

2017-05-17 Thread David T. via gnucash-user
Robert: 1) I believe you are confusing “Lots” and “Trading Accounts”, but I could be wrong. I am not aware of needing to change any settings to use lots. Lots technically aren’t necessary, since a user can manage the gains aspect manually. To use the lots feature, select Actions->View Lots in

Re: Fixing opening balance for an incorrectly reconciled account

2017-05-16 Thread David T. via gnucash-user
Andrew,  Presumably, if you fixed a reconciled transaction, it should be right. If it is now right, then your ending balance should now be right, and you should see below.  If your ending balance is wrong, then you have ANOTHER problem in your account, and you should look for THAT error, rather

Re: Fixing opening balance for an incorrectly reconciled account

2017-05-15 Thread David T. via gnucash-user
Andrew,  I reread your messages. You say you "fixed" a reconciled transaction, and now, you have to enter an extra transaction which you reversed afterward. Do I have that right?  OK, if you"fixed" a reconciled transaction, then presumably now, it is correct. First question: how did you get the

Re: Fixing opening balance for an incorrectly reconciled account

2017-05-14 Thread David T. via gnucash-user
Andrew,  What do you mean, you can't fix the opening balance? If you are talking about your "Opening Balance" transaction, that is just another transaction, and of course you can edit that. (The recent discussion about reversing transactions was about a technicality for business books, and not

<    2   3   4   5   6   7