Re: [GNC] Plot Size on Piechart reports

2019-08-14 Thread David T. via gnucash-user
ow this, but did you report also display a legend ? I believe the legend and chart together are fitted into the dimensions you set. If the text in the legend varies from report to report, that my explain why the charts themselves vary as well. Geert Op dinsdag 13 augustus 2019 10:47:43 CEST schreef Dav

Re: [GNC] Unrealized gain/loss on Forex

2019-08-14 Thread David T. via gnucash-user
I believe that the "Unrealized Losses" entry on the Trial Balance report is calculated. You will need to create an account for it, as well as the transaction to account for the loss.  HTH, David  On Wed, Aug 14, 2019 at 11:40, Jayakumar Chakravarthy wrote: Hi, When I make an Invoice

Re: [GNC] Get online quote for Canada Fund

2019-08-13 Thread David T. via gnucash-user
Note that adding the price source column to the security list will allow you to see at a glance which source all your stocks are using.  On Wed, Aug 14, 2019 at 8:17, David Reiser via gnucash-user wrote: First, make sure that _none_ of your stocks are requesting quotes through yahoo.

Re: [GNC] Plot Size on Piechart reports

2019-08-13 Thread David T. via gnucash-user
I'm pretty sure that this code isn't making sizing decisions based on readability-- at least not in my experience.  It is perfectly happy to cram huge amounts of data into tiny on screen areas... Percentages default to 100%, but remember previously stored values.  On Tue, Aug 13, 2019 at

Re: [GNC] Problems moving vertical lines between columns on

2019-08-13 Thread David T. via gnucash-user
As covered in the note at https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-running-gnucash.html#basics-register2 On Tue, Aug 13, 2019 at 5:40, David Carlson wrote: James, Keep in mind that in the register view the description column is a special case that essentially defaults to

Re: [GNC] Plot Size on Piechart reports

2019-08-12 Thread David T. via gnucash-user
Dang. New mail client ate my screen shot! Next try... On 8/12/2019 9:07 PM, David T. via gnucash-user wrote: Hello, The attached screen shot shows three iterations of a standard Piechart. Each has its own set of accounts and slices, but each is set to plot its chart to the same 485 by 240

[GNC] Plot Size on Piechart reports

2019-08-12 Thread David T. via gnucash-user
Hello, The attached screen shot shows three iterations of a standard Piechart. Each has its own set of accounts and slices, but each is set to plot its chart to the same 485 by 240 dimensions--and yet, each one is clearly a different size! While the first is an Expense piechart, I believe

Re: [GNC] journal entries

2019-08-12 Thread David T. via gnucash-user
I'm not sure how this is a challenge, especially since both John and David C. pointed you in the right direction in the docs. Perhaps you are associating the term "Journal entry" with something special? To begin, set your View preference to "Basic" and on the Preferences:Accounts tab, uncheck

Re: [GNC] Transaction Report Sign Reverses

2019-08-12 Thread David T. via gnucash-user
cular case. On Mon., 12 Aug. 2019, 13:02 David T. via gnucash-user, mailto:gnucash-user@gnucash.org>> wrote: Hello, I am trying to create a YTD Capital Gains report, and am encountering a problem with how the Transaction Report implements the Sign Reverses setting. I

[GNC] Transaction Report Sign Reverses

2019-08-11 Thread David T. via gnucash-user
Hello, I am trying to create a YTD Capital Gains report, and am encountering a problem with how the Transaction Report implements the Sign Reverses setting. I recall some time back a discussion about the fact that the Sign Reverses setting reverses signs in these reports in a confusing way.

[GNC] Windows Report Options Dialog Setting

2019-08-11 Thread David T. via gnucash-user
Hello, GnuCash 3.5 on Windows 10. I have discovered a UI problem that I believe to be a bug. It appears that if a user maximizes the Options dialog for a report, and then saves the options by clicking OK, the maximized window size becomes the default options window size from that point

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-07 Thread David T. via gnucash-user
Building on Christopher's comment, my experience was that if a transaction to be imported has the flag set, Gnucash imports that value. I'm not sure the exact mechanics or heuristics (and it was a long time ago that I migrated to Gnucash), but I know I didn't have to reconcile my imported

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

2019-08-06 Thread David T. via gnucash-user
Indeed. I ask myself, "which character do I see after invoking this option?" It isn't "R"--it is "C." Furthermore, the imported transaction isn't "Reconciled," it is "Cleared." You still have to reconcile it. As for changing the Reconcile value to "R," well, that goes a little further down

Re: [GNC] QIF Import Problem

2019-08-05 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

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,

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

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

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

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

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,

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

[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] 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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

[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

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

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

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

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:

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

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

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

Re: [GNC] Gnucash Price updating

2019-04-11 Thread David T. via gnucash-user
You don’t tell us; are you using Yahoo! as your price source? Yahoo! dismembered its quote source website a while back, and GnuCash users have had to seek out other sources. One source is AlphaVantage, while another is “Yahoo! as JSON”. If you set up your accounts to use one of these

Re: [GNC] two lines for every entry

2019-04-10 Thread David T. via gnucash-user
Todd, I strongly suggest you read the Guide-- especially the chapters that cover double entry accounting and other basics.  David On Thu, Apr 11, 2019 at 10:45, ToddAndMargo via gnucash-user wrote: Hi All, On a credit card account, when ever I enter a charge and press enter, I get a

Re: [GNC] US Bans Free tax Software

2019-04-10 Thread David T. via gnucash-user
While it may be lamentable that the US government is headed down this path, if is not necessarily the same disaster... Since Gnucash is not tax software, and I am not a professional tax expert, I use Gnucash for tracking my finances (including using tax options extensively), and Turbotax to

Re: [GNC] report: group account activity by accounting period instead of by month

2019-04-07 Thread David T. via gnucash-user
Indeed.  I read that backwards, and advised how to get monthly subtotals. If you are in the US, you might explore the Tax Options settings, which, when combined with the TXF report, can make tax reporting very easy.  David On Mon, Apr 8, 2019 at 8:25, John Ralls wrote: > On Apr 7,

Re: [GNC] Fwd: report: group account activity by accounting period instead of by month

2019-04-07 Thread David T. via gnucash-user
I'm pretty sure you should be able (even with your vintage Gnucash version) to create a transaction report with these settings.   Select the accounts you want, set the dates to "Start of previous year" and "End of previous year", leave primary sort alone, but change secondary sort to "Date"

Re: [GNC] Downgrading to 2.6.21

2019-04-07 Thread David T. via gnucash-user
I’m not sure how it works on Windows, but on my Mac, when I attempt to open certain files in my Dropbox folder (I am using the DropBox add-in that maps my DropBox to a folder in my system), I see a huge character string in the title bar, with a long repeating sequence of “../“ This doesn’t

Re: [GNC] is there a way to undo last months reconciliation

2019-04-07 Thread David T. via gnucash-user
OK. Thanks for pointing that out. > On Apr 7, 2019, at 9:50 PM, Michael Hendry wrote: > >> On 7 Apr 2019, at 16:33, David T. via gnucash-user >> wrote: >> >> Adrien, >> >> I have seen how easy it is to have this happen; I had an import that had >

Re: [GNC] is there a way to undo last months reconciliation

2019-04-07 Thread David T. via gnucash-user
Adrien, I have seen how easy it is to have this happen; I had an import that had extraneous spaces in the Description field, and when I corrected that, the transactions de-reconciled. There were no warnings. I don’t believe I’ve ever set this option anywhere; how would a user locate the

Re: [GNC] Bills in Gnucash

2019-03-31 Thread David T. via gnucash-user
Oh.  Let me go to nabble to figure out that you're replying to my post... now, having closed all the spammy windows for super resume... Having the new account assistant create a specific set of accounts IN NO WAY is "enabling business features." It's just a bunch of accounts. The features are

Re: [GNC] Confused by report "Price Source" when recording bills in a foreign currency

2019-03-30 Thread David T. via gnucash-user
ISTR such a discussion as well; I also believe someone explained to me then why these reports are using the PriceDB at all. Now, I can’t recall what the explanation was, and I *still* don’t see why the Price DB is accessed to create a report for transactions in which the price has been already

Re: [GNC] Confused by report "Price Source" when recording bills in a foreign currency

2019-03-30 Thread David T. via gnucash-user
Christian, While it may be, strictly speaking, unnecessary to create currency-specific expense accounts, it may yet be useful to do so. For example, if you maintain a bank account in one currency, and a second bank account in a different currency, you may wish to track ongoing expenses

Re: [GNC] Scheduled transactions

2019-03-30 Thread David T. via gnucash-user
Not mentioned previously is the fact that you can tell gnucash to move a scheduled transaction from a weekend day to the day prior or following, without manual intervention. That might help... David On Sat, Mar 30, 2019 at 9:26, Roger Oliver wrote: Good to know. At least I can stop

Re: [GNC] Bills in Gnucash

2019-03-30 Thread David T. via gnucash-user
I'm not sure what you're talking about. I just recently created a set of books for a business (my first attempt), and I had no need to "enable business features."  David On Sat, Mar 30, 2019 at 5:18, R. Victor Klassen wrote: Before you can do any of the below, you need to “enable

Re: [GNC] Bills in Gnucash

2019-03-29 Thread David T. via gnucash-user
Gustav, Welcome to gnucash. Although I am not an expert in using the business features, I believe that you can add your customers and suppliers to your existing account structure without disruption. The chapter on using business features in the Guide should help you out.  Best,David On

Re: [GNC] Investment account import

2019-03-27 Thread David T. via gnucash-user
Joseph, Each stock will have its own account. That's just how it works. Setup can be tedious, but it's not difficult once it's set up. I have many more commodity accounts than you (many of them closed out), and I do not find it troublesome.  David On Wed, Mar 27, 2019 at 20:10, Joseph

Re: [GNC] The Meaning of Split (previously Example of multi-split feature of CSV importer?)

2019-03-21 Thread David T. via gnucash-user
I like the terminology “simple” versus “compound”, but I do not understand what is meant by a “ two-line simple transaction as a special case of a compound transaction.” David > On Mar 21, 2019, at 4:40 PM, Geert Janssens > wrote: > > Op woensdag 20 maart 2019 12:35:40 CET schreef Michael

Re: [GNC] End of year rollover

2019-03-20 Thread David T. via gnucash-user
 Of course you can. Google "close books site:gnucash.org" and read up on the myriad opinions and issues that you might encounter.  On Thu, Mar 21, 2019 at 1:00, Philip Burg wrote: I would like to close my books at the end of my financial year but have access to the previous years

Re: [GNC] Still can't update price quotes

2019-03-20 Thread David T. via gnucash-user
Glad you got it sorted. Out of curiosity, when you say one entry was "odd," what did you mean? Just a note: there is no ticker symbol APPL; the symbol for Apple is AAPL. So, if you tried actually with APPL, you naturally won't get results.  David On Wed, Mar 20, 2019 at 8:53, Elias K

Re: [GNC] Example of multi-split feature of CSV importer?

2019-03-18 Thread David T. via gnucash-user
GunCash’s use of the term “split” is quite specific, and defined in the Glossary of the Guide, as well as Chapter 4.1 Basics. Basic Concepts. David > On Mar 18, 2019, at 10:49 PM, Michael Hendry wrote: > >> On 18 Mar 2019, at 16:36, Patrick wrote: >> >> That makes sense. Thank you for the

Re: [GNC] GNUCash Documentation

2019-03-15 Thread David T. via gnucash-user
Justin, As one who has worked on the docs before, I say welcome! My only change would be to wait longer—say a week—since many are busy with other life responsibilities. Is there a particular area that particularly irks you? David > On Mar 14, 2019, at 7:33 AM, Justin Haynes > wrote: > >

Re: [GNC] Archive part of my data

2019-03-15 Thread David T. via gnucash-user
A quick search online yielded:https://github.com/fefe982/gnucash-XML-split I can't vouch for the reliability of the program.  David On Fri, Mar 15, 2019 at 2:54, Michael or Penny Novack wrote: On 3/14/2019 2:46 PM, Jonathan Heard wrote: > Good Morning, > > I have been using GnuCash for a

Re: [GNC] IRC access

2019-03-05 Thread David T. via gnucash-user
I agree. It would be appropriate to have brief information related to gnucash on IRC, with pointers to official resources.  90% of the content in the current page should go. The introductory paragraph followed by the server, channel, and link to IRC download and help pages should be it.  David

Re: [GNC] MySQL

2019-03-05 Thread David T. via gnucash-user
Thanks for clarifying. I'm probably also mixing some of this in with the whole Python on Macs issue. David On Wed, Mar 6, 2019 at 10:11, John Ralls wrote: David, For 2.6 yes. For 3.x everything is in the bundle for all three database backends just like Windows. Regards, John Ralls

Re: [GNC] Delete multiple transactions (was: gnucash-user Digest, Vol 192, Issue 7)

2019-03-05 Thread David T. via gnucash-user
Of course, should the user wish to delete all records after a given date (or before) they could use the same filtering technique to create a view of the offending records and one by one delete them until the view is empty. This can happen pretty quickly, once the user tells gnucash to delete

Re: [GNC] MySQL

2019-03-05 Thread David T. via gnucash-user
John, for MySQL, don't Mac users have to build Gnucash with the appropriate libdbd-mysql dependency added in? ISTR at some point that we needed to build gnucash ourselves to add this functionality.  Or am I misremembering? David T. On Wed, Mar 6, 2019 at 3:50, John Ralls wrote: > On

Re: [GNC] Music Teacher: tracking balances owed from students

2019-03-04 Thread David T. via gnucash-user
Adrien, Any chance you might add these tips to the Using Gnucash wiki page? "Simple business advice for managing invoices" or some such... Adding it at the business features spot might make most sense.  Cheers,David On Tue, Mar 5, 2019 at 2:36, Adrien Monteleone wrote: The short

[GNC] Business Feature Question

2019-02-27 Thread David T. via gnucash-user
Hello, Long time user with a question regarding the business features and grants. Specifically, I am setting up a business file for a business that receives grant monies from different organizations in exchange for various services. I’ve set up the granting agencies as customers in the books,

Re: [GNC] Cashflow-like report to show realized and unrealiz

2019-02-27 Thread David T. via gnucash-user
IANAA, but as I understand it, gnucash doesn't track unrealized gains well mostly because traditional accounting isn't focused on unrealized gains. I'm told that accountants want to be certain that the *amount* of what you have is accurate. The value of that is less interesting. Honestly, the

Re: [GNC] Accounting for gold coins

2019-02-27 Thread David T. via gnucash-user
Gnucash by policy uses the ISO currency definitions, which precludes any additions or extensions. And yes, this had been discussed before. Workarounds have focused either on treating metals like any other commodity, as you have done here, or by loading your alternative (e.g., bitcoin) on an

Re: [GNC] How-to question: CD Interest payments deposited in

2019-02-20 Thread David T. via gnucash-user
This is correct.  I have, however, found it useful to create an income account for each entity that will send me a tax document (in the US, a 1099 of one or another ilk). Then, having set the accounts as tax-related, the Tax report shows me figures that match those separate 1099s. This makes

Re: [GNC] How-to question: CD Interest payments deposited in

2019-02-19 Thread David T. via gnucash-user
David, The income derived from that CD, so that's why I imagine he'd want the connection.  Moreover, I don't think it's unreasonable for someone with stock holdings to want to see the dividends associated with a given stock. Using income subaccounts for each security breaks down when you either

Re: [GNC] How-to question: CD Interest payments deposited in

2019-02-18 Thread David T. via gnucash-user
Adrien (and Dale and David), Each of you correctly suggests a transaction from an income account to the checking account.   However, I suspect that underlying Art's question is the idea that this transaction will not have any connection to the original CD account. When he calls up the CD

Re: [GNC] Saved reports have all dissapeared since upgrade to V3

2019-02-13 Thread David T. via gnucash-user
https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_DATA_HOME > On Feb 13, 2019, at 2:34 AM, Peter Gardner wrote: > > Hi all > > > > As subject line all of my save reports have gone since I upgraded from V2 to > V3. > > > > Any help? > > > > Peter > > > > --- > This email

Re: [GNC] Which report for date limited account transactions?

2019-02-12 Thread David T. via gnucash-user
Rich, You have numerous options. If you’re going the Account Report method, first filter your account for the date range you want and then trigger the report. Otherwise, use the transaction report and select your account and date range there. Of course, you could use the Tax Options to set

Re: [GNC] Backup recovery

2019-02-10 Thread David T. via gnucash-user
I don’t know. What is backblaze? Based on the info in the FAQ to which I referred, it appears that on Feb 8, 2019, you opened a backup copy of “GNU 5 Feb 2018”, which itself was made on March 5, 2018, made some changes, and saved from that backup. I don’t know your workflow or immediate

Re: [GNC] postpone reconciliation broken: ignores my changes

2019-02-08 Thread David T. via gnucash-user
I know that on my Mac, it takes some time for gnucash to actually finish the save process.  Mine is a somewhat older macbook pro with an SSD. Is it possible that you failed to wait for it to finish saving? David T. On Fri, Feb 8, 2019 at 14:23, Michael Hendry wrote: > On 8 Feb 2019, at

Re: [GNC] Number Rounding

2019-02-04 Thread David T. via gnucash-user
So, you're saying that your transaction reads $5.26 in all its splits, but the reconcile window is showing it as $5.30?  Are you sure you're looking at the same transaction, and not two similar transactions with different amounts? Is there something else about this transaction that is odd? 

Re: [GNC] Question about display of reports

2019-02-04 Thread David T. via gnucash-user
Mark,  Your problem stems from the fact that your accounts are in (Canadian?) dollars, while your locale may be in pounds.  I am not versed in multi-currency situations. Maybe someone else can advise you on how to clear that up.  David On Mon, Feb 4, 2019 at 13:54, Mark Stockwell wrote:

Re: [GNC] Question about display of reports

2019-02-02 Thread David T. via gnucash-user
And which report. > On Feb 3, 2019, at 9:42 AM, David Carlson wrote: > > Mark, you left out which version you are using. > > On Sat, Feb 2, 2019 at 10:08 PM Mark Stockwell via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Hi >> >> Whenever I run a report from my version of Gnucash,

Re: [GNC] Accounts and HSAs question

2019-01-31 Thread David T. via gnucash-user
Mark, Did you see and read through the thread at  https://lists.gnucash.org/pipermail/gnucash-user/2018-May/077029.html That's the most recent (and succinct, IMHO) discussions on the topic.  There are others further back, I know.  David T. On Fri, Feb 1, 2019 at 12:11, Mark wrote: Hello,

Re: [GNC] Gnucash leadership team

2019-01-31 Thread David T. via gnucash-user
Honestly, the decision is yours. I’ve been using GnuCash now for over 13 years. Back then, Derek Atkins was one of the primary developers, having taken over for another crew that had carried GnuCash from its early years as xaccountant. He stepped back, and several others stepped in. So, it’s

Re: [GNC] Reconciliation is not adding up correctly - what t

2019-01-29 Thread David T. via gnucash-user
Finbar, On Tue, Jan 29, 2019 at 16:54, Finbar Mahon wrote: 2. For this particular a/c the figure €3986.22 is the balance in the a/c, taken from the bank statement on 28.12.2017, after the last transaction on that date. That clarifies this issue.  You created a transaction in the amount of

Re: [GNC] Reconciliation is not adding up correctly - what to do??

2019-01-28 Thread David T. via gnucash-user
> On Jan 28, 2019, at 7:28 PM, Adrien Monteleone > wrote: > > David, > > I understand perfectly what you are saying. My point was I read the post to > be a confusion in terms. I understood the OP to mean ‘opening balance’ to > mean the opening balance transaction in the account, *not* the

Re: [GNC] Upgrade Path from version 2.6.16 on MacOS High Sierra (10.13.6) and beyond

2019-01-28 Thread David T. via gnucash-user
> On Jan 28, 2019, at 6:54 PM, Adrien Monteleone > wrote: > > >> >> It’s not clear whether “data files” is meant to refer to *your* data files, >> or *the application’s.* Adrien is right that you can easily load multiple >> versions of the application simply by naming one “Gnucash

<    1   2   3   4   5   6   7   >