Re: [GNC] Restoring backups

2019-04-12 Thread David T. via gnucash-user
cicko, Thanks for adding this to the wiki. However, the circumstances you describe are not a function of backing up gnucash, but are rather a general issue associated with using gnucash on macs.  Because of this, I will recommend that your notes be moved into the FAQ page on using gnucash for ma

Re: [GNC] Start up after shut down

2019-04-14 Thread David T. via gnucash-user
Since what Stephen says is the default behavior for Gnucash, you will need to figure out what you are doing that is giving you this exceptional behavior.  What specific steps are you taking in the save process? What messages does Gnucash report, if any? What specifically happens on startup? Do y

Re: [GNC] File operations open non-existant drive

2019-04-14 Thread David T. via gnucash-user
I believe this error was mentioned in a thread last August (https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079468.html).  Unfortunately, there doesn't seem to have been a resolution other than to remove the hardware.  Sorry.  David On Mon, Apr 15, 2019 at 6:58, wendiallen

Re: [GNC] Cannot retrieve quotes for some securities

2019-04-15 Thread David T. via gnucash-user
Alphavantage implemented limits on the number of quotes that can be retrieved at a time. This was discussed some months back, with suggestions on different remedies.  Changing the source to "Yahoo as json" is one of those solutions. Editing the perl in Finance::Quote to add a time delay was ano

Re: [GNC] Column Width

2019-04-17 Thread David T. via gnucash-user
Readers might like to consult: https://cvs.gnucash.org/docs/C/gnucash-guide/txns-shortcuts1.html Additionally, the behavior of the register columns (and in particular the Description and Balance columns) is described at: https:/

Re: [GNC] Need help with a Savings account

2019-04-17 Thread David T. via gnucash-user
Adrien, The Guide covers in some detail both the concept of double entry and debits and credits. In fact, some have suggested that the guide goes into too much detail about these concepts.  It was the reason I suggested that the recent user consult the documentation, since it explained everyth

Re: [GNC] Need help with a Savings account

2019-04-17 Thread David T. via gnucash-user
Adrien, Your willingness to help others in such situations far outstrips my own, and I commend you for it.  I've said it before, but it bears repeating: I think it is better to refer users to the documentation first, and address their questions at a later stage, for a number of reasons.  Fir

Re: [GNC] Changing account tree on large database

2019-04-26 Thread David T. via gnucash-user
David, I think a couple of additional points of reference from you would be helpful. What operating system are you experiencing this slow performance? I believe it’s WIndows, but I could be mistaken. The relative performance benchmarks seem to be OS-dependent. I am using MacOS, and while some

Re: [GNC] QIF File import

2019-04-26 Thread David T. via gnucash-user
Tommy, Thanks for pointing to the wiki! Note that your first link (to the FAQ) simply refers the reader to the page at the second link… I think the page at this second link covers most of the issues that users have raised over the years. David T. > On Apr 27, 2019, at 4:17 AM, Tommy Trussell

Re: [GNC] Need help reconciling

2019-04-27 Thread David T. via gnucash-user
All of this is covered in the Guide at https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1 , especially 2.9.4.1, which includes a section regarding the starting balance, as well as

Re: [GNC] Dimensions in Accounts

2019-04-29 Thread David T. via gnucash-user
Sachin, That sounds a lot like "Classes", which is a long standing feature request that has yet to be implemented.  David t.  On Mon, Apr 29, 2019 at 9:32, Sachin Danave wrote: Dear All, This may sound like a feature request, but just wanted to know if anything like this already exists

Re: [GNC] Dimensions in Accounts

2019-04-29 Thread David T. via gnucash-user
Colin-- Having top level accounts for entities only will work if all the subsidiary accounts are the proper type (that is, you can't mix asset accounts and liability accounts). On Mon, Apr 29, 2019 at 13:08, Colin Law wrote: Is it a big complication to have top level asset accounts Me an

[GNC] De-Reconciliation Settings

2019-04-29 Thread David T. via gnucash-user
It was pointed out to me in another thread that one can reset specific warnings flags using Action->Reset Warnings.  I’d like to raise a couple of points with this dialog, now that I have been introduced to it… First off, the dialog is quite opaque, insofar as it is (apparently) only showing w

Re: [GNC] De-Reconciliation Settings

2019-04-29 Thread David T. via gnucash-user
PM, John Ralls wrote: > > > >> On Apr 29, 2019, at 12:54 AM, David T. via gnucash-user >> wrote: >> >> It was pointed out to me in another thread that one can reset specific >> warnings flags using Action->Reset Warnings. >> >> I’d like

Re: [GNC] Quicken import and duplicate records

2019-04-30 Thread David T. via gnucash-user
Priit, When I migrated over, I did it the same way as you describe here-- that is, I imported the entire file in one pass. I went back to quicken numerous times to clean up the exported data, but eventually got an import that was clean enough.  I offer that simply as a counter story to that of t

Re: [GNC] column widths - balance

2019-05-02 Thread David T. via gnucash-user
Note that Section 2.3.3 of the Guide includes the following: Note In the register windows, you can resize the various columns that GnuCash displays, but keep in mind that the Description and Balance columns behave differently from other columns. The Description column is designed to expand auto

Re: [GNC] column widths - balance

2019-05-05 Thread David T. via gnucash-user
Well, look at that! It does work now. I’m pretty sure that’s a change. I will note that it is still quite picky, getting the correct cursor without hitting the scroll bar. And, as you note, moving to the right from the far right can be counterintuitive or even impossible. I think I’ll stick with

Re: [GNC] Questions

2019-05-06 Thread David T. via gnucash-user
1 - it's alphabetical. You could rename the accounts with numeric prefixes or use account codes and story on them.  2 - the income statement isn't set up to accommodate those breakdowns. You might try creating a multi column report with income statements for different time periods. 3 - don't eve

Re: [GNC] Questions

2019-05-06 Thread David T. via gnucash-user
1 - As I mentioned, account codes will work for this. Assign each account a numeric code, add the code column to the COA, and sort on it. Done. 2 - Multicolumn reports. 3 - Are you talking about the “General Ledger” report, or the “General Journal” report? My version of the former report (GC 3.4

Re: [GNC] Questions

2019-05-06 Thread David T. via gnucash-user
2 - Multicolumn reports are already part of GnuCash. 3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint accounts, and received sane results. Is it possible that when you attempted to select multiple accounts, you actually selected only the last account you clicked? Many

Re: [GNC] Questions

2019-05-06 Thread David T. via gnucash-user
3 - I spoke too soon. There is something weird going on there. I can select multiple accounts, and some will display, while others do not. Not sure what is going on there. > On May 6, 2019, at 6:38 PM, David T. via gnucash-user > wrote: > > 2 - Multicolumn reports are already par

Re: [GNC] Questions

2019-05-06 Thread David T. via gnucash-user
hing weird going on there. I can >> select multiple accounts, and some will display, while others do not. >> Not sure what is going on there. >> >>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user >>> wrote: >>> >>> 2 - Multi

Re: [GNC] Custom Report

2019-05-09 Thread David T. via gnucash-user
I'm not at a computer right now, but I seem to recall that the Profit & Loss report does not have monthly breakdowns. You could copy the monthly data to a column in a spreadsheet in order to make comparisons.  Each report has different options which are only availableafter first invoking the rep

Re: [GNC] ancient gnucash files not opening

2019-05-13 Thread David T. via gnucash-user
As I understand, you'd have to load earlier versions and work your way up to the current version. I'm not sure how many intermediate versions you'd need to go through.  However, your newest files in that range predate version 2.0.0 by more than a year. Which means you'd have to download, compil

Re: [GNC] QFX vs OXR/QXF

2019-05-16 Thread David T. via gnucash-user
Jeffrey, Thanks for filling me in on the vagaries and nuances of bank processes.  I stand by my assertion that if you are downloading your transactions from the bank, then you are by default choosing to accept *their* accounting of your money.  If this level of difference bothers you, then you

Re: [GNC] QFX vs OXR/QXF

2019-05-16 Thread David T. via gnucash-user
The most common issue that crops up with importing QIF data seems to be date formatting, such as a date that is in dd-mm- format (when the rest of the file is mm-dd- format).  Unfortunately, there really isn't any easy way to locate such errors, short of scanning through the source file

Re: [GNC] Fix assets

2019-05-17 Thread David T. via gnucash-user
Section 15.5 of the Guide enumerates fixed asset types, and chapter 16 Depreciation goes into a bit of detail about this complex subject. The broad concepts are covered there, but consulting with a local expert is recommended in this area. David > On May 18, 2019, at 9:02 AM, Adrien Monteleone

Re: [GNC] Upcoming report deprecation

2019-05-21 Thread David T. via gnucash-user
I am not a fan of keeping reports that *no one uses* included in the application, on the offhand chance that some new user might decide to learn scheme and the gnucash api to write a new report. As noted in the bug, this has not been a particularly common occurrence.  Geert's solution is a goo

Re: [GNC] Removing myself from this mailing list

2019-05-26 Thread David T. via gnucash-user
I’d wager tht Ray is subscribed through “Nabble”. Ray, you should unsubscribe frmo the Nabble. > On May 26, 2019, at 6:55 PM, Derek Atkins wrote: > > indeed. > The email address "ray.bergm...@yandex.com" is not subscribed to any > gnucash email address. > -derek > > On Sun, May 26, 2019 9:07 a

Re: [GNC] How do I display the accumulated total Assets on t

2019-05-26 Thread David T. via gnucash-user
That result suggests that you do not have an entry for C$ in your price db, as was mentioned earlier. Put one in and see whether that fixes the problem.  On Mon, May 27, 2019 at 1:18, Ron Eggler wrote: On Sat, May 25, 2019 at 4:01 PM Christopher Lam wrote: > You'll have to explore the

Re: [GNC] Importing investment info from Financial Planner's website

2019-05-27 Thread David T. via gnucash-user
Jo, Importing such information is typically a one- time process, and the time it would take to programmatically process all possible situations makes it expensive, from a programming perspective. The development team has focused on other areas. I doubt any developer would take up your request. 

Re: [GNC] Unsplitting a transaction

2019-06-05 Thread David T. via gnucash-user
David, If you delete the split for the current register, there is nothing binding the transaction to the current register, so of course it will "disappear" from this register.  David On Wed, Jun 5, 2019 at 14:49, David Carlson wrote: It has always been my custom to start from the left

Re: [GNC] Switch to Account that a Transfer is from by Keybo

2019-06-18 Thread David T. via gnucash-user
Adrien, Because this is specifically a situation that resulted from GTK, I would be reluctant to add language to the Gnucash documentation.  David T.  On Tue, Jun 18, 2019 at 8:29, Adrien Monteleone wrote: Yes, the Gtk+ version which changed this was implemented for 3.0. Regards, Adrie

Re: [GNC] I just don't understand reconciliation

2019-06-18 Thread David T. via gnucash-user
Michael, I believe that ToddAndMargo clicked the "Reconcile" button in the reconcile window, which is designed to create a balancing entry when your reconciling doesn't work.  ToddAndMargo, Michael's suggestion to click the "Finish" button might be more successful for you.  David T. On Tu

[GNC] Assistance on transition from one OS to another

2019-06-18 Thread David T. via gnucash-user
Hello, I am a long time user of gnucash on a Mac, and am now transitioning to either windows or linux; I'm still sorting out which.  This message is decidedly NOT a request for anyone's input on that choice, however.  What I am trying to figure out is how to get the many customized preferences I

Re: [GNC] print check register

2019-07-02 Thread David T. via gnucash-user
While in the register, try Reports->Account Report.  HTH,David On Wed, Jul 3, 2019 at 6:40, Chris Tsuji wrote: HI How do you print the check register? thanks Chris Tsuji ___ gnucash-user mailing list gnucash-user@gnucash.org To update your sub

Re: [GNC] Editing List of Income/Expenses

2019-07-03 Thread David T. via gnucash-user
Each entry in your list of expenses is a separate account in your chart of accounts.  You edit the list by removing accounts.  Bear in mind that if your account has transactions in it, you will be asked the account to which you want these transactions to be moved.  David On Wed, Jul 3, 20

Re: [GNC] Change a batch of transactions from income to Expense

2019-07-05 Thread David T. via gnucash-user
David,  I am not sure why you say that the documentation lacks a description of debits and credits; I am sure you are aware of section 2.1 of the Guide, which goes into some detail about this precise issue.  David T.  On Fri, Jul 5, 2019 at 3:32, David Cousens wrote: Alan, The guide h

Re: [GNC] Change a batch of transactions from income to Expe

2019-07-05 Thread David T. via gnucash-user
That information has been in the documentation since 2.4. Not sure what edits you are referring to... On Fri, Jul 5, 2019 at 13:11, David Cousens wrote: David, Sorry I hadn't realized the section i put in on that had made it into the current version of the docs. Thanks for pointing that

Re: [GNC] Change a batch of transactions from income to Expe

2019-07-05 Thread David T. via gnucash-user
I guess I don't know what part of it you're referring to. In 2.4 I see notes about the meaning of debit and credit, as well as general discussion about double entry accounting. It seemed to me that would have addressed OP's needs, but I defer to your perspective.  On Fri, Jul 5, 2019 at 16

Re: [GNC] Adding custom reports

2019-07-12 Thread David T. via gnucash-user
rgdobie, Your method modifies the gnucash package directly.  While it works to do this, your changes will be overwritten every time you upgrade.  There is a method which avoids this (although I admit it has never worked for me). David P.S. when you use nabble, none of the regular list users see

Re: [GNC] Use of "dash" as a Separator Character

2019-07-24 Thread David T. via gnucash-user
I figure they are bound to crop up, so leave them where I can watch them. I keep them empty. A quick check shows me areas needing work! David On 7/24/2019 8:19 PM, Derek Atkins wrote: D writes: Derek, I don't know about renaming, but you certainly can move them! I've had my Imbalance accou

Re: [GNC] Migration

2019-07-31 Thread David T. via gnucash-user
I won't comment on whether the migration process has become simpler over the years, as I haven't done it in about as long.  There has been a huge amount of discussion over the years on the question of migration from Quicken (usually tied either to the beginning of a new calendar year, or the im

Re: [GNC] gnucash-user Digest, Vol 196, Issue 61

2019-08-01 Thread David T. via gnucash-user
Migrating investment transactions is particularly challenging because of the issue of capital gains and cost basis. I gave up trying, and instead rely on the broker-derived assessment of gain because of it. With individual stocks, GnuCash's lot features work pretty well, though.  On Fri, A

Re: [GNC] QIF Import Problem

2019-08-04 Thread David T. via gnucash-user
... And I have none of these problems with 13 years of history. No lags, loading, while slow, has neither decreased nor increased over the years with a growing file size. YMMV, but I've used both Mac versions, and now the Windows version (currently 3.5). I've said it before, but it bears repea

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

2017-09-30 Thread David T. via gnucash-user
> On Sep 30, 2017, at 3:31 PM, Geert Janssens > 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, >>> >>> I’m no expert, but the Guid

Re: What's the best way to model an electronic funds transfer pull with hold

2017-10-01 Thread David T. via gnucash-user
Nelson, When *I* have entered this in GnuCash, I have simply entered a transaction from one account to the other, effective when I initiated the transaction. The various delays and holds are, to my way of looking at this, background noise, and I just ignore them. They go away in a few days’ tim

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 th

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 10. All programs and apps

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 2015 model > running OS X 10.1

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 PM

Re: Does Gnucash supports barcode scanner.

2017-10-10 Thread David T. via gnucash-user
Gnucash is not a pos package. So, you will have difficulty using it for that.  Just a note: a barcode scanner is just another input device; if your operating system supports the device, then gnucash will receive that input.  HTH, David  On Tue, Oct 10, 2017 at 8:12, Suresh Saragadam wrote:

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 t

Re: command line QIF import

2017-10-18 Thread David T. via gnucash-user
> On Oct 18, 2017, at 9:14 PM, John R. Sowden > wrote: > > 1. The program opens in the Cash-Checking Account journal register. I > entered the check number. For "Description", instead of a description, I put > the name of the payee, in this case "Landlord", I entered the account name > "Re

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

2017-10-23 Thread David T. via gnucash-user
Corinna, >From the image, I surmise that you probably want to get the columns *other* >than the description a little wider?  You will need to ignore for a moment the description column (because it's special)*, and adjust your other columns. You can try double clicking the column headers, which m

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 a

Re: Online Quote Problem - Mac

2017-11-05 Thread David T. via gnucash-user
It’s a known issue. Yahoo has blocked quotes. Everyone hopes for a fix… > On Nov 5, 2017, at 11:43 PM, Joshua Morris wrote: > > I’m a very big fan of GnuCash - I use it religiously. Recently, > out-of-the-blue, I have been having trouble retrieving online quotes. I’ve > updated to the latest

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 exa

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 wil

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 backu

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 TIAA-CREF mutual f

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 "/Applications/Gnucash.app/Contents

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

2017-11-12 Thread David T. via gnucash-user
My question to both Les and Robert is *which* environment file have you updated? ~/.bash_profile, or /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment? F::Q will not work in the Mac bundle with Alphavantage if you modify ..bash_profile (but will work at the command line), an

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 P

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

2017-11-12 Thread David T. via gnucash-user
When you say "specifying it in the environment file," do you mean ~/.bash_profile,  or the environment file located deep in the gnucash.app bundle?  If the former, the bash environment variables won't affect the gnucash.app instance. If the latter, I would double check the first-listed entry to

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 Night

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 b

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

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 vers

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 my desktop. Frankly

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, Joh

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 a

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 accounting system.  Instead, I cre

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 examp

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 version of GNUcash (2.6.1

Re: Accounts as hyperlinks ignores the report options date range bug

2017-12-13 Thread David T. via gnucash-user
I suspect that this is how the links are programmed, so, technically not a bug--but certainly not what you are hoping for.  You should file an enhancement request on Bugzilla, but you might not see action on it for some time; the reports don't get a lot of developer attention.  David On We

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 this time managed to

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 wrong or what to change?  T

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, azalea4va wrote:

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 a

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 wou

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 cont

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 affecting

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

2018-01-05 Thread David T. via gnucash-user
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 > wrote: > > On 1/5/2018 1:05 AM, David T. via gnucash-user wrote: >> David— >> >> I see where you are coming from on this. >>

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 d

Re: Filtered account report

2018-01-15 Thread David T. via gnucash-user
AC, I went a different way.  I created Subaccounts for each grouping I wanted to track. So, if I want to track interest on a particular loan (for example, if I expected a 1099 for it), I created a subaccount under Expenses:Interest. That made it simple to track individual loans. I also can assig

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 hav

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 fields,

Re: info about action field in double-line view

2018-01-22 Thread David T. via gnucash-user
Geert, What is the current status on the File Association feature set? I know that there was a wave of activity a few years back when the feature was first added, but I haven’t seen anything about it since. My recollection of the traffic at the time was that it had potential to be very useful,

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 wor

Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user
Hello, I recently upgraded from 2.6.16 to 2.6.19 on my Mac (OSX 10.13.2). In the prior setup, I had upgraded Finance::Quote to 1.47, added a shell variable for the Alphavantage key, added the same key to /Applications/Gnucash.app/Contents/Resources/etc/gnucash/environment, changed all my stock

Re: Price Retrieval Failure

2018-01-23 Thread David T. via gnucash-user
ecked > and AlphaVantage  listed as source for each entry. > > > > From: David T. via gnucash-user > To: Gnucash Users > Sent: Tuesday, January 23, 2018 10:07 AM > Subject: Price Retrieval Failure > > > Hello, > > > I recently upgraded from 2.6.16 to 2.6.19

Re: Reports very slow to open

2018-01-23 Thread David T. via gnucash-user
David,  Christopher is referring to a thread in which windows users reported that gnucash was imposing a substantial delay on the first run report. This is different from the general problem of slow report loading, I believe.  As for the delay,  I have not seen anyone say that they have a fix.  D

Re: Reports very slow to open

2018-01-23 Thread David T. via gnucash-user
Yes.  https://bugzilla.gnome.org/show_bug.cgi?id=790789 On Wed, Jan 24, 2018 at 11:37, David Carlson wrote: OK, I missed the reference.  Has a bug been submitted? David C On Wed, Jan 24, 2018 at 12:32 AM, David T. wrote: David,  Christopher is referring to a thread in which windows us

Re: Future allocated money vs Budgets

2018-01-26 Thread David T. via gnucash-user
Adrien, A small point: there is an option on the reconcile window to include subaccounts, so that should not pose a problem. David > On Jan 26, 2018, at 12:38 PM, Adrien Monteleone > wrote: > > The biggest problem with any of this is if the money is actually sitting in a > bank account. Rec

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 ca

<    1   2   3   4   5   6   7   >