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

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

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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: recover GNUcash data after windows crash

2017-11-27 Thread David T. via gnucash-user
Ian, Gcm files are not your data files. They are metadata files. Similarly, the “.gnucash” folder is the system folder that holds this metadata. Your data files (AccontsBusiness.gnucash and Personal.gnucash) are somewhere else on your backup. Put those on your new machine (not in the “.gnucash

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-25 Thread David T. via gnucash-user
John, I know you and the other developers are doing huge service to the rest of us with your work. I truly wish I had the skills that allowed me to help with this; years of attempts have shown me that this is beyond me, however. Thank you all. David > On Nov 25, 2017, at 9:32 PM, John Ralls

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-23 Thread David T. via gnucash-user
John, GnuCash on the Mac ALWAYS opens the last file it had open—even when you double-click on another GnuCash file. This is a long-known issue with how the Mac handles the GnuCash startup. File->Open will get you to your second set of accounts. David > On Nov 24, 2017, at 8:00 AM, John

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-23 Thread David T. via gnucash-user
This has long been an issue with GnuCash on the Mac, such that most of us have simply gotten used to it. I will add something to the wiki FAQ shortly. It has been entered as a bug (https://bugzilla.gnome.org/show_bug.cgi?id=761024 ), so it has

Re: Accounts Capicity

2017-12-01 Thread David T. via gnucash-user
Bevan, I haven’t heard of anyone “exceeding capacity,” so I doubt that is your problem. What operating system, what version of GnuCash? Has anything else changed on your system? At what point do you discover you can’t enter data? David > On Dec 1, 2017, at 9:39 AM, Bevan Twidale

Re: Report error An error occurred while running the report.

2017-12-13 Thread David T. via gnucash-user
Are you sure that there are any transactions for the period you selected? I'm not certain, but I believe that an empty return set gives this. This is an unfortunate communication.  David On Wed, Dec 13, 2017 at 13:18, Dane Dormio wrote: I am running the latest

Re: A BASH script to help get tax-related data from gnucash

2017-12-16 Thread David T. via gnucash-user
I’m sorry. Your original characterization was vague, and I didn’t understand what your issue with that report was. I see what you are noting, although it’s not something that bothers me. FWIW, I would probably dump the report into a spreadsheet and munge the data there if the redundancies were

Re: Gnucash & macOS High Sierra.

2017-12-13 Thread David T. via gnucash-user
So, that sounds like a problem with a change in locale settings, and not a problem with Sierra.  I doubt the original poster is encountering the same problem as you.  David On Wed, Dec 13, 2017 at 16:39, Pam Dooner wrote: yes, definitely 2.6.18. Just tried again and

Re: A BASH script to help get tax-related data from gnucash

2017-12-15 Thread David T. via gnucash-user
If you have set the accounts as tax-related, why wouldn't you use the Tax Schedule Report?   This works rather well, especially if you assign specific tax lines to your accounts. See chapter 10 of the help for detailed instructions.  David On Fri, Dec 15, 2017 at 13:17,

RE: finance-quote error

2017-12-15 Thread David T. via gnucash-user
Are you sure your alphavantage key is properly set in your environment?  David On Fri, Dec 15, 2017 at 13:12, batwell wrote: I am still having problems after updating to 1.47.  I have not found any source that returns a usable response. Any Idea what I am doing

Re: Alphavantage quotes working through F::Q, not through Gnucash

2017-11-12 Thread David T. via gnucash-user
I’ll assume that you mean /Applications/Gnucash.app/Contents/Resources/environment (note the lower case ‘e’; case matters in MacOS). If not, then that will be the problem. To run gnc-fq-dump, you need to be in /Applications/Gnucash.app/Contents/Resources/bin David > On Nov 12, 2017, at 7:10

Re: API Key

2017-11-10 Thread David T. via gnucash-user
Les, Dave, Thanks for airing this out a little more. I had not succeeded in getting this to work, mostly because I didn’t understand the FAQ, which tells us to add the environment key to "/etc/gnucash/environment where prefix is:” in one spot, and then says

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: Finance-Quote 1.44 released!

2017-11-09 Thread David T. via gnucash-user
Does the TIAA-CREF module not work? David > On Nov 9, 2017, at 7:31 PM, davel...@mac.com wrote: > > >> On Nov 9, 2017, at 4:46 AM, Erik Colson wrote: >> >> >> davel...@mac.com writes: >> >>> Thanks for all your work on this. A symbol I cannot get to work is QREARX >>> (a

RE: Can gnucash add Virtual currency?

2017-11-08 Thread David T. via gnucash-user
Technically, adding bitcoin as a security isn't the same as adding it as a currency,  which the OP requested.  Gnucash bases its currencies list on the ISO standard, which does not include bitcoin. That said, treating it like any other commodity should work, except that the ongoing valuation

Re: F::Q 1.40 uploaded

2017-11-08 Thread David T. via gnucash-user
If I were going to try to change all my quote sources quickly, I would do it with SQL. ! NOTE THAT THIS SUGGESTION IS NOT/NOT PROMOTED BY THE DEVELOPMENT TEAM BECAUSE IT CHANGES YOUR DATA FROM OUTSIDE THE GNUCASH API!! !!! USE AT YOUR OWN RISK 1) Make a

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
John, You don’t say what you did when you downloaded “the latest version” (presumably 2.6.18, yes?). Once you downloaded it, did you open the dmg file and drag Gnucash.app into your applications folder? I ask this because you say there are two Gnucash apps in Applications. As the different

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
John, Glad to hear. Just as a final note: the files in your home folder aren’t “backups.” They are your actual data files. If you want backups, you’ll have to make them yourself. David T. > On Dec 2, 2017, at 11:53 PM, John Donnee wrote: > > I dragged the application to

Re: gnucash file could not be found

2017-12-07 Thread David T. via gnucash-user
Mike, GnuCash automatically attempts to open the last file you used, even if that file is no longer where GnuCash thinks it is. Moreover, on Macs, GnuCash tries to open that last file *even if you double click on another GnuCash file from Finder.* The workaround is that you use File-> Open to

Re: Cannot edit opening balance

2017-12-11 Thread David T. via gnucash-user
I would suggest reading section 4.4 of the tutorial, where the issue regarding handling starting balance problems is addressed directly.  David On Mon, Dec 11, 2017 at 11:48, John R. Sowden wrote: My suggestion is to never use the opening balance in an

Re: GnuCash: Docs: Where to document?

2017-12-11 Thread David T. via gnucash-user
Chaz, Seems like that sort of write up might go on the wiki. I'll note that neither python nor the sql aspects of gnucash are consistently available to the average user, so your write up may have limited utility. Python is only available to Mac users if they compile gnucash themselves, for

Re: Here Is What I Did

2017-12-02 Thread David T. via gnucash-user
You should have a file named “mydata.gnucash” (where “mydata” is whatever you called it. That’s your data file. The other is a log of changes since your last save. You can go to the wiki page I referenced and learn all about Gnucash’s various files. David T. > On Dec 3, 2017, at 12:31 AM,

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: [GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

2018-05-06 Thread David T. via gnucash-user
Sorry I’ve been delayed in responding. I’ll try to reply to the various suggestions. Adrien: The COA is perfectly fine, except that it’s not possible to embed the one figure in a multi-column report, so that doesn’t work for me. As for what I had in 2.6.19, I included verbatim what I have had

[GNC] Problem with Saved Reports

2018-05-07 Thread David T. via gnucash-user
Hello, I have encountered now a couple of times the unpleasant experience of calling up my saved reports configurations, only to find all but 5 or 7 completely gone. When I examine the saved-reports-2.4 file stored on my hard drive, it has been reduced in size to about 30k. This has happened

Re: [GNC] Handling VISA Debit Accounts

2018-05-07 Thread David T. via gnucash-user
In my experience (admittedly limited), a debit card is a means to extract funds from an account—not an account on its own. Considered this way, it is simply a variant of a check, or of writing a withdrawal slip and handing it over to a teller (for those who remember those days). There is no

[GNC] Keybindings Mac OSX GC 2.6.19

2018-05-12 Thread David T. via gnucash-user
Hello, I don’t know if I am going crazy, but I thought that GnuCash used typical Mac key bindings (CMD-S, CMD-P, etc.). In the last few weeks, though, most of these key bindings use the CTRL key. Although I haven’t changed 2.6 in a while, I have downloaded and run 3.1 (without saving

Re: [GNC] pros/cons of storage formats

2018-05-17 Thread David T. via gnucash-user
And, as I noted in January, the sql format does not get compressed, so the files are much larger.  On Thu, May 17, 2018 at 10:37, Adrien Monteleone wrote: Keith, The SQL backends are having a few issues at the moment. It would be a good idea to search

Re: [GNC] pros/cons of storage formats

2018-05-16 Thread David T. via gnucash-user
Keith,  I'm not sure how you looked,  but this topic had been discussed for many years on the list. A recent one was  https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074315.html. Another was  https://lists.gnucash.org/pipermail/gnucash-user/2013-September/050410.html. David

Re: [GNC] Ubuntu 18.04

2018-06-12 Thread David T. via gnucash-user
David, The main wiki page has limited edit access, but https://wiki.gnucash.org/wiki/Installation would be a good place to hook build instructions into. David T. > On Jun 12, 2018, at 3:19 AM, DaveC49 wrote: > > Hi Geert, > > I think one of

Re: [GNC] Dock Icon on Mac

2018-06-13 Thread David T. via gnucash-user
My dock works, and has worked for a decade. Perhaps you are using GnuCash from two places: Applications, and the dmg? I say this because the “?” could happen after restart if the dock item were linked to a dmg file, and the dmg weren’t reloaded on restart. Similarly, a second dock item would

Re: [GNC] Profit and Loss Spreadsheet

2018-06-03 Thread David T. via gnucash-user
Indeed. And once your data are in a spreadsheet, you can run all sorts of sophisticated functions on it. ;) David > On Jun 3, 2018, at 10:07 AM, Adrien Monteleone > wrote: > > John, > > I’ll have to interpret a bit, but my guess is you want a report that shows > multiple months worth of P

[GNC] GC 3.1 Mac OS X 10.13.4 High Sierra Report issue

2018-05-02 Thread David T. via gnucash-user
Hello, Before I submit a bug report, I’d like to see whether there has been some change to the reports system that causes the degradation I am seeing, and if there is a different way to achieve my same goal. I have a custom report that is set to display a single figure for YTD totals for a

Re: How to deal with RRSP's (Canada)

2018-01-05 Thread David T. via gnucash-user
that is earned in 2017, but which is counted as taxable income only in 2035? Cheers, David > On Jan 5, 2018, at 7:42 PM, Mike or Penny Novack > <stepbystepf...@dialup4less.com> wrote: > > On 1/5/2018 1:05 AM, David T. via gnucash-user wrote: >> David— >> >

Re: How to deal with RRSP's (Canada)

2018-01-04 Thread David T. via gnucash-user
David— I see where you are coming from on this. For reference, I accept your 5 assumptions; I believe they are accurate for many US retirement accounts as well. The Income/Equity splits in Cam’s example are a mechanism that allow distributions to appear as income on reports, without

Re: Reports Not Responding Windows 10

2017-12-22 Thread David T. via gnucash-user
I had to check on my own machine (Mac OS X 10.11.6 GC 2.6.14), but there are no delays here. I had to check because, for me, the first report is always run at startup, when I am not really paying attention. If the problem really is a delay on the first-run report only, perhaps a workaround

Re: Year end issues

2018-01-15 Thread David T. via gnucash-user
No, there isn’t. The Close book feature simply creates a transaction that zeroes out your income and expense accounts as of a given date. In a double entry accounting system, if you delete the expense side of the transaction, what do you suggest doing for the Checking account side? If you are

Re: Filtered account report

2018-01-16 Thread David T. via gnucash-user
Sure. I understand. My experience with my own accounts was different (even with multiple loans over multiple years). Personally, I find the burden of changing transactions--evens hundreds of them--to be minor.  And the results have been consistent and reliable ever since. But you do what you

Re: Gnucash freezes while loading data

2018-01-21 Thread David T. via gnucash-user
Those don’t sound like large files, so it sounds like there might be something wrong. Do they ALL hang, or only some of them? I will admit that I am not one to advise on importing, as I don’t do it much. That being said, I would take a close look at the source files—especially the date

Re: Money Market Accounts

2018-01-22 Thread David T. via gnucash-user
Hello,  I think you have two options, depending on your preference.  1) Use the parent brokerage account to hold these funds. This works best when the funds are basically just held by the brokerage until they can be transferred to another asset. 2) Create a separate subaccount for them.  This

Re: Please remove me from the mailing list

2018-01-30 Thread David T. via gnucash-user
We have spent a heck of a lot of bandwidth on this topic, and we seem to do so every time someone sends one of these unsubscribe requests. I personally agree with Derek that it is a hopeless and thankless task to account for all the possibilities, and I would rather find a different solution

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-30 Thread David T. via gnucash-user
Matt, I see one huge problem: where are you balancing the funds for the allocated accounts? They need balancing, and once you add something to balance them, you might as well male them Subaccounts of checking anyway.  Cheers,David  On Wed, Jan 31, 2018 at 4:06, Matt

RE: Subaccounts [WAS Re: Future allocated money vs Budgets]

2018-01-31 Thread David T. via gnucash-user
Matt,  I have to admit that I misread the tally; I did not see that the first $500 (AllocatedCash) was balancing the others. My apologies.  I'll let you and Adrien work this out, since I don't have a lot of background in this.  David On Wed, Jan 31, 2018 at 8:58, Matt

Re: Please remove me from the mailing list

2018-02-03 Thread David T. via gnucash-user
Liz, Looks good. Just a brief question on terminology: I had never heard the term “reflector” used for these sites. It’s always been called a “mirror.” Which is considered the proper term for these? David > On Feb 3, 2018, at 11:18 AM, Liz wrote: > > On Wed, 31 Jan 2018

Re: Need help with opening my Gnucash software

2018-02-02 Thread David T. via gnucash-user
Rick, It is far easier for the OP simply to click the “Close” button (which continues starting GnuCash, but without loading the missing file) and then using the GnuCash File->Open command to locate their file. David > On Feb 3, 2018, at 11:10 AM, Rick Copple

Re: File Format : XML v MySQL / postgres / sqllite

2018-01-27 Thread David T. via gnucash-user
Sebastien, The problem isn’t with Python (I am told that Macs already have Python on them). The problem as I understand it (John will no doubt correct me when my statements prove ill-informed or flat out wrong) has to do with the fact that GnuCash requires a specific version of Python, which

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
at startup before the F::Q note... > On Feb 8, 2018, at 9:33 PM, John Ralls <jra...@ceridwen.us> wrote: > > > >> On Feb 8, 2018, at 6:52 AM, David T. via gnucash-user >> <gnucash-user@gnucash.org> wrote: >> >> In thread >> https://lists.gnuca

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Reiser <dbrei...@icloud.com> wrote: > > >> On Feb 8, 2018, at 9:52 AM, David T. via gnucash-user >> <gnucash-user@gnucash.org> wrote: >> >> In thread >> https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html >> <

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
Unfortunately, adding these lines to my config.user did not result in any further information. I am stumped, and disappointed. It seems that an upgrade of GnuCash not only tanks one’s customized environment file in the application bundle (understandable), but also any additional files that a

Re: Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
shudders*)? David > On Feb 9, 2018, at 9:40 AM, David T. via gnucash-user > <gnucash-user@gnucash.org> wrote: > > Unfortunately, adding these lines to my config.user did not result in any > further information. I am stumped, and disappointed. > > > It se

Re: Installation

2018-02-12 Thread David T. via gnucash-user
Adrien,  Log files have to be visible to the user, so that when they have to recover from an error state in their files, they can use them to restore.  David On Tue, Feb 13, 2018 at 9:05, Adrien Monteleone wrote: It would seem to me the ‘cleaner’ option to

Re: Capital Gains posting in newly imported data from quicken

2018-02-14 Thread David T. via gnucash-user
snrm, It has been a long time since I migrated from Quicken, but I know that my biggest headaches came from how Quicken did (or didn't) handle gains.  That said, gnucash includes a lot management tool that you can use to generate gains transactions. It is far from perfect, however. For example,

Re: Cash Flow View

2018-02-08 Thread David T. via gnucash-user
Matt, The wiki can always use help, so thank you! I think your approach makes sense. I will note that there already is a set of installation pages, and it may be most useful simply to move the relevant questions and answers to them. I suspect that there are similar overlaps in other areas of

Re: GNUCASH Free Accounting Software

2018-02-08 Thread David T. via gnucash-user
Or run a transaction report and set the dates accordingly. > On Feb 9, 2018, at 5:20 AM, David Carlson wrote: > > If you want to do a register report for a certain time range open the > register window and choose View > Filter by.. > Date to select your time >

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-08 Thread David T. via gnucash-user
Roger,  You stay by stating that you are able to generate a report that tells you "the current value of everything."  Then, you ask how you can add another layer of complexity to accomplish the same thing? I don't understand: what's wrong with the report?  David On Thu, Feb 8, 2018 at

Re: Online quotes fetching the wrong price

2018-02-08 Thread David T. via gnucash-user
Justin, I see the same command line result. I will note that the date listed there is for 2017 (mine is the same), which suggests something is out of whack. Looking online, I see that NAB was at 33.14 on 03/13/2017, so that doesn’t work. I’ve tried various versions of the exchange (ASX, ASE,

Price Retrieval Failure, Part 2

2018-02-08 Thread David T. via gnucash-user
In thread https://lists.gnucash.org/pipermail/gnucash-user/2018-January/074224.html , I noted that after upgrading my installation from 2.6.16 to 2.6.19 on my Mac (OS X 10.13.3), Price retrieval was failing with the

Re: QFX Import and Reconciled Transactions

2018-02-16 Thread David T. via gnucash-user
RW, The QFX specification includes an ID field against which gnucash matches. If subsequent imports keep trying to match existing transactions, it may be that your bank is reusing the IDs. This has been seen before.  David On Fri, Feb 16, 2018 at 14:59, R

Re: General Ledger

2018-02-23 Thread David T. via gnucash-user
Try https://www.gnucash.org/docs/v2.6/C/gnucash-help/general-journal.html "The General Journal defaults to showing only the previous month of transactions. This is changeable by using the "Filter By..." on the View menu."

Re: Re: finance-quote error

2017-12-27 Thread David T. via gnucash-user
Ismael, You will generally get better results sending requests to the list, for a number of reasons.  First, you will get advice from the combined group knowledge. This is especially helpful in this case because I don't know a heck of a lot about F::Q. Second, normal list etiquette is not to

Re: [GNC] Getting My Account To Trial Balance

2018-07-25 Thread David T. via gnucash-user
David, I imagine that the number of GnuCash users who only have accounts in a single currency (i.e., without any investments in stocks, mutual funds, or other commodities) is probably pretty small. For those who *do* have such holdings, a balanced transaction will still fail the trial balance

  1   2   3   4   5   6   7   >