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

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 written by Doug Doughty I've become inspired t

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

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 the link is broken. A

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 conceptu

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 mostl

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

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 screaming at me on any of the ofx/qfx

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 different computer, I was 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 2.6.17 on Windows, I did

Re: Manually Post Scheduled Transactions

2017-07-24 Thread David T. via gnucash-user
Taking into account the fact that I don't really use scheduled transactions much these days, nevertheless I think you have a different model going from what gnucash does.  Specifically, in gnucash, a scheduled transaction is only a template; it is not a transaction itself. As a template, it lack

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 agentash...@gmail.com from the mailing lists >>

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 bel

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, pfwoolver...@juno.c

Re: Tracking a TIAA mixed fund account

2017-07-23 Thread David T. via gnucash-user
The proposed structure is set up precisely as you want, down to the naming, and it will show total portfolio. At least it does for me. Personally, I don’t know the precise share holdings for any of the mutual funds I own, so the Lifecycle funds are, for me, exactly the same. David P.S. Dale’s

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 fun

Re: Flash Drive

2017-07-18 Thread David T. via gnucash-user
As I understand those links, portableapps.com works on these other operating systems by using Wine, a virtual windows emulator.  So, you'd install a windows emulator on your linux machine (125mb) in order to run gnucash as a portable app on a stick so as to save installing Gnucash (175mb) on you

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 to:  https://portableapps.com/de/apps

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 wrote: GnuCash - User

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

Re: Flash Drive

2017-07-14 Thread David T. via gnucash-user
John,  I seem to have misunderstood. I thought you said you were only trying to store the data file on the flash drive; this sounds like you are trying to store the entire application there.  Storing the data file is trivial, but trying to load the entire application is another story. Since I 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 <=\ n

Re: Where do I find gnucash data?

2017-07-10 Thread David T. via gnucash-user
John, The files are presumably on the D: drive where you saved them. You can copy your files to another PC by using Windows Explorer to copy them to another location. Try looking also at Chapter 2.6 and 2.7 in the Tutorial and Concepts Guide. They cover the various questions about backups and c

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 t

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 report

Re: Automating home mortgage splits?

2017-06-27 Thread David T. via gnucash-user
Dan, Many will point you to the scheduled transactions and the Mortgage assistant. I always found that there was an inevitable difference between the amount that got calculated by GnuCash, and what the lender calculated for the specific amounts. Given that variation, I always felt it was easier

Re: Tracking Primary Residences

2017-06-25 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 th

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 fe

Re: quickbooks to gnucash

2017-06-21 Thread David T. via gnucash-user
Chris, This thread from 2012 summarizes the state of that situation, which has not changed materially in the intervening time: https://lists.gnucash.org/pipermail/gnucash-user/2012-March/043685.html Basically, as a one-t

Re: Please STOP sending emails

2017-06-19 Thread David T. via gnucash-user
Don’t blame the list; YOU signed up—YOU unsubscribe. The link is below. > On Jun 19, 2017, at 10:03 PM, Bradford N Hull wrote: > > > > Sent from my iPhone > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailma

Re: Library for reports in .xlsx

2017-06-16 Thread David T. via gnucash-user
Andrey, If you are willing, I think you should put this info in the wiki at https://wiki.gnucash.org/wiki/Using_GnuCash#Using_third_party_software_for_data_exploration_and_visualization

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 invoice line and open the >> invoice, maybe I am missing

Asset Barchart Report

2017-06-10 Thread David T. via gnucash-user
Hello, I have found that the standard Asset Barchart report that comes with GnuCash is incredibly slow to render. When I attempt to use this report, it takes easily two to four minutes to render, and uses the entire CPU capacity on my computer while it works on this report. Given that nearly ev

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

Re: Schwab Brokerage account/Roth OFX

2017-06-04 Thread David T. via gnucash-user
> On Jun 4, 2017, at 9:00 PM, vipdm wrote: > > Thanks. What do you mean, "CURRENT stock buy/sell & dividend transactions", > all completed transactions would be in the past? Do you mean since the last > time you checked? I am mainly looking to pull the current balance. When you > have a chance,

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

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 hier

Re: Hiding accounts

2017-05-24 Thread David T. via gnucash-user
This is actually documented in the Help file at 5.4.1. David > On May 24, 2017, at 9:35 PM, Dianna Broughton > wrote: > > Thank you - checking the placeholder box (in addition to the hidden box) > worked! > > I should've asked long before now! > > Warmly, > Dianna > > > __

Re: How to close a financial year

2017-05-24 Thread David T. via gnucash-user
Don, As I mentioned originally, there is an annual discussion about the capabilities of GnuCash in regards to closing the books—and the philosophies behind each of the options that users might choose in that regard. Reading some of those past discussions will help you understand GnuCash’s appro

Re: Current terminology

2017-05-22 Thread David T. via gnucash-user
those technologies myself. > > On Mon, May 22, 2017 at 12:23 AM David T. via gnucash-user > mailto:gnucash-user@gnucash.org>> wrote: > Eneko, > I noticed that recently, when I created the glossary in the guide. I am bit a > user of any of those technologies myself, so I

Re: Current terminology

2017-05-21 Thread David T. via gnucash-user
Eneko, I noticed that recently, when I created the glossary in the guide. I am bit a user of any of those technologies myself, so I cannot honestly weigh in. However, I note that it still seems that those who do user them still refer to this as HBCI,  and not FinTS. I'm not certain, therefore, w

Re: gnucash-user Digest, Vol 170, Issue 39

2017-05-18 Thread David T. via gnucash-user
So, Derek’s advice to downgrade to 2.6.15, make your changes, and then reload 2.6.16 is your best option. > On May 19, 2017, at 7:59 AM, Greg Grotsky wrote: > > That is not a possibility, I tried it but when you select the delete > function and it allows you to pick a new account it will only d

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 > ___ > gnucash-user m

Re: lots

2017-05-18 Thread David T. via gnucash-user
> On May 18, 2017, at 4:40 PM, Adrien Monteleone > wrote: > > >> On May 17, 2017, at 9:45 PM, David T. via gnucash-user >> wrote: > >> >> >> P.S. -> To the Wiki gurus: I have suggested in the past that having these >> “Draft Guide” p

Re: Trial Balance does not include amount of Return of Capital Investment splits

2017-05-18 Thread David T. via gnucash-user
I was going to say that the description sounds more like a spinoff than a split or return of capital. Spinoffs are a bitch because you have to figure out how much basis goes into the new stock, how much stays with the original stock. Add in the fact that each stock has its own value, and that th

Re: lots

2017-05-17 Thread David T. via gnucash-user
Robert, I will note two points about the page to which you refer: 1) this page is a section of the wiki that contains an old, *non-current* draft of the User Guide which was created in 2007, and, 2) the section that you quote is, I believe, intended as as proposal to improve the lots features (

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 a

Re: How to close a financial year

2017-05-16 Thread David T. via gnucash-user
Anita,  This is discussed pretty much every year on the list. Try googling "close books gnucash site:lists.gnucash.org". You should find plenty of reading. David On Tue, May 16, 2017 at 14:41, Anita Graves wrote: Dear Friends,  How does one close the file for one financial year and open

Re: Fixing opening balance for an incorrectly reconciled account

2017-05-15 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 n

Re: Question regarding documenting Reversing Transactions

2017-05-10 Thread David T. via gnucash-user
Geert, It took a little bit, but I have added Bug 782455 as an enhancement request. It’s not a uservoice page, but I have never liked that tool anyway. David > On Apr 28, 2017, at 3:26 PM, Geert Janssens > wrote: > > On woensdag 26 april 2017 00:39:08 CEST Mike or Penny Novack wrote: >> On 4

<    2   3   4   5   6   7