Re: [GNC] What accounts should I reconcile?

2022-12-19 Thread David T. via gnucash-user
This was what I was going to mention; it can also be used to track reimbursed expense accounts. ⁣David T. ​ On Dec 20, 2022, 6:54 AM, at 6:54 AM, Paul Kroitor wrote: >I use the reconcile feature in at least two other ways: > >1. I keep current accounts with a lot of other parties -- four adult

Re: [GNC] Roth IRA conversion

2022-12-19 Thread David T. via gnucash-user
Yes. I saw that right after I sent my reply. I'm sorry. It was a case of my seeing what was in my own head at the moment. ⁣David T. ​ On Dec 20, 2022, 1:53 AM, at 1:53 AM, Michael or Penny Novack wrote: >On 12/19/2022 2:49 PM, David T. wrote: >> Michael, >> >> While I fully respect your

Re: [GNC] Roth IRA conversion

2022-12-19 Thread David T. via gnucash-user
Michael, While I fully respect your answer, with over 45 million IRA accounts in the US (according to one source I found online), this is a pretty common circumstance. It should be possible for basic guidance to be given by *someone*, without all 45 million consulting an accountant. I

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-15 Thread David T. via gnucash-user
People aren't reading the GnuCash documents. What makes you think they'll read a text on accounting? ⁣David T. ​ On Dec 15, 2022, 6:49 PM, at 6:49 PM, Michael or Penny Novack wrote: > >> I'm not sure what you mean when you say "documentation," but I don't >think the Guide or the Help would

Re: [GNC] GNUcash is using 538MB

2022-12-15 Thread David T. via gnucash-user
538MB for what? The application takes up somewhere around 500MB on the HDD. When running, the application may use large amounts of RAM; currently, my machine has a load of about 150MB for GnuCash. When stored, GnuCash files can vary wildly in size, depending on the storage method. My XML

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-15 Thread David T. via gnucash-user
5 Dec 2022 at 05:35, David T. via gnucash-user wrote: David, I'm not sure what you mean when you say "documentation," but I don't think the Guide or the Help would be appropriate places to make such references. Section 2.1 of the Guide gives a few basic explan

Re: [GNC] Reconciling PayPal

2022-12-15 Thread David T. via gnucash-user
The pdf statements I get from that page include balances. The direct question was where to find statements on PayPal. ⁣David T. ​ On Dec 15, 2022, 10:37 AM, at 10:37 AM, Liz wrote: >On Thu, 15 Dec 2022 09:45:15 +0300 >"David T. via gnucash-user" wrote: > >> At paypa

Re: [GNC] Reconciling PayPal

2022-12-14 Thread David T. via gnucash-user
At paypal.com, click the Activity tab, then click the download icon at the top right. This takes you to a hidden area that includes a tab for Taxes and Statements. At least, that's what I see on my machine. ⁣David T. ​ On Dec 15, 2022, 9:29 AM, at 9:29 AM, "Dr. David Kirkby" wrote: >On Wed,

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
David, I'm not sure what you mean when you say "documentation," but I don't think the Guide or the Help would be appropriate places to make such references. Section 2.1 of the Guide gives a few basic explanations on underlying accounting concepts. This section, in fact, states that "you do

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
Michael, I'll note that my suggestion was specifically and purposefully to add the text to the wiki, and not to the Guide or Help. ⁣David T. ​ On Dec 14, 2022, 5:25 PM, at 5:25 PM, Michael or Penny Novack wrote: > >>> Given the length of this thread and the apparent confusion >documenting

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-14 Thread David T. via gnucash-user
I think you're thinking of so-called "suspense" accounts? It would seem to me that tracking what PayPal won't release isn't necessary in my books-- any more than I need to track when the bank freezes a large check I deposit. I just carry that balance until it can be used. David T. ​ On Dec

Re: [GNC] Reconciling PayPal

2022-12-14 Thread David T. via gnucash-user
I get pdf PayPal statements that can be downloaded, just like from my bank. ⁣David T. ​ On Dec 14, 2022, 2:00 PM, at 2:00 PM, "Dr. David Kirkby" wrote: >On Wed, 14 Dec 2022 at 03:45, R Losey wrote: > >> I assume you can reconcile an asset account like any other bank >> account you can

Re: [GNC] Buying with PayPal - how do I split the transaction?

2022-12-13 Thread David T. via gnucash-user
Given the length of this thread and the apparent confusion documenting PayPal in GnuCash, it might be helpful for someone to add a section to the wiki page at "Using GnuCash" on the different methods people have outlined. IMHO, the Guide and Help cover the overall concepts well enough. ⁣David

Re: [GNC] Mutual fund price computation incorrect

2022-12-13 Thread David T. via gnucash-user
There's a setting to force decimal display that somehow is changed on the new installation. ⁣ David T.​ On Dec 13, 2022, 22:31, at 22:31, Dean Jagels wrote: >I recently moved from a native installation of GnuCash 4.2 to a >Flatpack >installation of 4.12. > >Now, when I look at my mutual fund

Re: [GNC] Disabling Lots Manager

2022-12-05 Thread David T. via gnucash-user
e Sheet again and compare them with the saved ones. If >everything matches your book should be OK. For extra insurance you >could run Check & Repair before and after as well. > >Regards, >John Ralls > > > > >> On Dec 5, 2022, at 2:25 AM, David T. via gnucas

Re: [GNC] Lot Calculator Off?

2022-12-05 Thread David T. via gnucash-user
it would be nice if there were a way to mimic this in GnuCash. David T. On 12/2/2022 9:31 PM, john wrote: On Dec 2, 2022, at 1:06 AM, David T. via gnucash-user wrote: Hello, GnuCash 4.11 on Windows 10 As the end of the year approa

Re: [GNC] Disabling Lots Manager

2022-12-05 Thread David T. via gnucash-user
u mention are pretty bad, especially the one about auto re-calculating gains just by viewing them. That's a nightmare. I'd call it a 'blocking bug' or at least very high severity. (along with the bug that silently deletes linked sale transactions) Regards, Adrien On 12/4/22 9:16 AM, David T. via gn

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
gt;off. > >The bugs you mention are pretty bad, especially the one about auto >re-calculating gains just by viewing them. That's a nightmare. I'd call > >it a 'blocking bug' or at least very high severity. (along with the bug > >that silently deletes linked sale transactions) > &g

Re: [GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
ffects can be purged from a database.   In a perfect world there would be a simple setting or procedure to accomplish that. Can a developer or other user help with this? On Sun, Dec 4, 2022, 5:04 AM David T. via gnucash-user wrote: Hello, Gnucash 4.11 Windows 10 Having struggled

[GNC] Disabling Lots Manager

2022-12-04 Thread David T. via gnucash-user
Hello, Gnucash 4.11 Windows 10 Having struggled once again with the extremely unreliable aspects of the Lots Manager, I am resigned to the fact that, while an admirable endeavor in concept, the Lots Manager is more trouble than it is worth, and leads to books that cannot be considered

Re: [GNC] Stock spinoff

2022-12-03 Thread David T. via gnucash-user
Well said,  Geoff. I'd add that creating the new share is a simple process of making a transaction that adds the new share to its account. It's the determination of cost basis (for both the original shares and the new share you received) that complicates things. These affect future gains

Re: [GNC] Lot Calculator Off?

2022-12-03 Thread David T. via gnucash-user
tual funds with regularly-reinvested dividend >entries), it is significantly more difficult to manage. Since most >institutions simply report the aggregate sale and gain, it would be >nice if there were a way to mimic this in GnuCash. >>>> >>>> David T. >&g

Re: [GNC] Long Account names truncated on right

2022-12-03 Thread David T. via gnucash-user
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html#txns-register-oview ⁣David T. ​ On Dec 3, 2022, 11:32 PM, at 11:32 PM, Peter Punzi wrote: >Hello all, > >I am enjoying using GNU Cash for my noprofit. I set up the account >structure and naming to match form 990 which we must

Re: [GNC] Lot Calculator Off?

2022-12-03 Thread David T. via gnucash-user
nageable; when a single sale gets split into 6 or more such entries >(as can happen with mutual funds with regularly-reinvested dividend >entries), it is significantly more difficult to manage. Since most >institutions simply report the aggregate sale and gain, it would be >nice if there were

Re: [GNC] Lot Calculator Off?

2022-12-03 Thread David T. via gnucash-user
reinvested dividend entries), it is significantly more difficult to manage. Since most institutions simply report the aggregate sale and gain, it would be nice if there were a way to mimic this in GnuCash. David T. On 12/2/2022 9:31 PM, john wrote: On Dec 2, 2022, at 1:06 AM, David T. via gn

[GNC] Lot Calculator Off?

2022-12-02 Thread David T. via gnucash-user
Hello, GnuCash 4.11 on Windows 10 As the end of the year approaches, I am working to get all my accounts up to date, and I've stumbled across an apparent error in capital gains calculations in the Lot manager. I am attaching a screenshot of the problem I am seeing. If you add up the sales

Re: [GNC] Crash While Editing Transactions

2022-12-02 Thread David T. via gnucash-user
Since I've replicated the problem, I have submitted this as a bug: https://bugs.gnucash.org/show_bug.cgi?id=798675 On 12/2/2022 11:18 AM, David T. via gnucash-user wrote: Now having had this happen again, I can confirm that the crash occurs when deleting a Lot-generated gains transaction

Re: [GNC] Crash While Editing Transactions

2022-12-02 Thread David T. via gnucash-user
Now having had this happen again, I can confirm that the crash occurs when deleting a Lot-generated gains transaction. On 12/2/2022 10:30 AM, David T. via gnucash-user wrote: Hello, Summary: Using GnuCash 4.11 under Windows 10, I was deleting erroneous Gains transactions in a Mutual Fund

[GNC] Crash While Editing Transactions

2022-12-01 Thread David T. via gnucash-user
Hello, Summary: Using GnuCash 4.11 under Windows 10, I was deleting erroneous Gains transactions in a Mutual Fund account when GnuCash crashed out. Details: I was entering sales of mutual fund shares and using the Lots feature to calculate gains for the sales. This generally works well for

Re: [GNC] getting price quotes

2022-11-30 Thread David T. via gnucash-user
I believe that AlphaVantage is the "default" simply because it is alphabetically first in the list. And it is included because it is still possible for users to use it, albeit with significant restrictions (that have been imposed after the original implementation). It is not wise to read

Re: [GNC] Fwd: Accounts for UK Vat need updating since the UK left the European Union

2022-11-22 Thread David T. via gnucash-user
Presumably,  Dr. Kirby will still have transactions in those accounts, in which case hiding the accounts and making them placeholders would be the proper approach. As for the template, Frank's advice is appropriate. I believe his warning about being sure is sarcastic; regardless, the template

Re: [GNC] Price as decimal in Price database

2022-11-20 Thread David T. via gnucash-user
Try Preferences->Numbers, Date, Time->Force Prices to display as decimals ⁣David T. ​ On Nov 20, 2022, 7:19 PM, at 7:19 PM, Fred Tydeman wrote: >Is there a way to force the Price database to display prices as decimal >values (instead of fractions)?

Re: [GNC] Account structure for tracking trip expenses

2022-11-18 Thread David T. via gnucash-user
This question has a long history (the earliest I've seen is from 2001, https://lists.gnucash.org/pipermail/gnucash-user/2001-October/002612.html). If you Google "cost center site:lists.gnucash.org/pipermail", you can find a number of these. Interestingly, that early thread neatly (if tersely)

Re: [GNC] Lost checking account

2022-10-27 Thread David T. via gnucash-user
James, While Geoff has been doing a stellar job working with you on your GnuCash use, I'll say that your account list shown doesn't appear to have any checking account in it. It does show an imbalance account with a very large amount in it, though, so I wonder if somehow your checking

Re: [GNC] Automatic payments and interest during reconciliation?

2022-10-27 Thread David T. via gnucash-user
Odd. I tried googling numerous variations of that previous email without success. Terms I tried included: kinzelman site:lists.gnucash.org/pipermail kinzelman reconciliation site:lists.gnucash.org/pipermail kinzelman reconciling site:lists.gnucash.org/pipermail paul reconciling

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-26 Thread David T. via gnucash-user
This was my point; the numerous large log files suggest something else might be amiss. I've been using GnuCash since 2006 or so,  which was version 2.2.x. My file is quite large, and yet my log files (cf. https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-backup1.html) continue to be a

Re: [GNC] Help please. Upgraded from 2.3.4 to 4.12. Worked fine. But database does not load. Win 11.

2022-10-20 Thread David T. via gnucash-user
I don't profess to have any great ideas, but I see from the one screenshot that your file opens, but appears to be empty, and I see from the other that you have numerous large log files (9mb or so) on every day of the display. Many of them appear to be only a few days old. Personally, my log

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-16 Thread David T. via gnucash-user
That works for me! Thanks, John. ⁣David T. ​ On Oct 16, 2022, 10:34 PM, at 10:34 PM, john wrote: >I've renamed that page to GnuCash SQL Examples. > >Regards, >John Ralls > > >> On Oct 15, 2022, at 11:54 PM, David T. via gnucash-user > wrote: >> >> Look

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-16 Thread David T. via gnucash-user
Looks good. And this is definitely a better placement. Now, one wonders whether the name of the page ("PostgreSQL- Requests For Direct Database Access") would be better as "SQL For Direct Access to GnuCash Data"... Alas,  the power to rename pages reside with only an anointed few... ⁣David T.

Re: [GNC] Price database

2022-10-16 Thread David T. via gnucash-user
Geoff, Good advice/help! I do think it would be necessary to add the currency to the result, to inform the resulting prices. ⁣David T. ​ On Oct 16, 2022, 4:38 AM, at 4:38 AM, Geoff wrote: >Hi Elmar > >To elaborate on John's reply, this SQL statement should do the trick: > > >select

Re: [GNC] transaction images and failed hard drives

2022-10-14 Thread David T. via gnucash-user
Geoff, Jeff is asking a more specific question related to the image linking feature. It's not his book data that he's looking for guidance on; it's whether he can link his images using a different mechanism than to a file directly. Jeff, I don't profess to fully understand your solution, but

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-12 Thread David T. via gnucash-user
Frank, I've just rewritten the page extensively, and in the course of doing so, I added back your category and headers. ⁣David T. ​ On Oct 12, 2022, 2:31 AM, at 2:31 AM, "Frank H. Ellenberger" wrote: > > >Am 12.10.22 um 01:17 schrieb Geoff: >> I have reverted all of my changes. > >… and my

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
k" as Account type     [Image of New account window with circles)]     Click on the "Select" button for the "Security/Currency" field     Choose "NASDAQ" as type and "(AMZN) Amazon" as security     Set Parent Account to an account in t

Re: [GNC] How to include images in the Wiki?

2022-10-11 Thread David T. via gnucash-user
John, sunfish62 (that's me) is also asking for such access. On 10/11/2022 6:38 AM, john wrote: On Oct 10, 2022, at 9:01 PM, Geoff wrote: So, how do I go about obtaining "uploadaccess", or finding a friendly and patient Administrator to upload images on my behalf? Just ask! What's your

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
Click on the "Select" button for the "Security/Currency" field >> >> Choose "NASDAQ" as type and "(AMZN) Amazon" as security >> >> Set Parent Account to an account in the Assets branch of your chart >> >> Click &

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
I'm opening the page on Android devices in Chrome. I still feel that each of the windows should be placed in a separate image, in the actual instructional sequence. ⁣David T. ​ On Oct 11, 2022, 11:05 AM, at 11:05 AM, Geoff wrote: >Hi David > >Thanks for the review. > >I tested this (on

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
quot;Security/Currency" field Choose "NASDAQ" as type and "(AMZN) Amazon" as security Set Parent Account to an account in the Assets branch of your chart Click "Ok" ⁣David T. ​ On Oct 11, 2022, 10:37 AM, at 10:37 AM, "David T. via gnucash-user" wrot

Re: [GNC] Using GnuCash Wiki: Add Stock Page: Screenshots Added

2022-10-11 Thread David T. via gnucash-user
Geoff, As it's a wiki, you just go for it. I was going to do just that, because your image width causes the browser page to shrink everything else on screen, making it incredibly hard for old eyes to read the (now miniscule) text. But, you've aggregated all the steps into one wide image. If

Re: [GNC] Mac Installation 4.12 issue

2022-10-08 Thread David T. via gnucash-user
Hylton, The main GnuCash page includes a link for installation, and on that installation page, the section for macos states: "Once you have downloaded the disk image, double click to open it, and then drag the app icon into your Applications folder (or anywhere else on your system that you

Re: [GNC] Problem with missing balance in a parent account

2022-10-08 Thread David T. via gnucash-user
That account register doesn't have any transactions in it, so it won't have any value either. Is it possible that in the past, you used a report to see the parent account balances, or even the Chart of Accounts? And if the account in the screen shot is a placeholder account, then you a)

Re: [GNC] Reconciling subaccounts

2022-10-08 Thread David T. via gnucash-user
John, I don't know about "typically." There are any of a number of ways that someone might use placeholder accounts. In my own books, I have placeholder accounts for brokerage holdings, where the placeholder represents an institution's account and the leaf accounts represent individual

Re: [GNC] Price update not working

2022-10-08 Thread David T. via gnucash-user
While it's always best to try to use the latest versions, Richard's error message doesn't sound like one that has to do with currency rate retrieval (which I believe is the major bug that F::Q1.53 is meant to fix). I would personally check to see what quote sources are selected for each

Re: [GNC] Move transactions from one account to another

2022-10-08 Thread David T. via gnucash-user
Or simply delete account A, and you'll be asked the same question. ⁣David T. ​ On Oct 8, 2022, 4:02 AM, at 4:02 AM, "Carl S." wrote: > > >*From:* David Carlson [mailto:david.carlson@gmail.com] >*Subject:* [GNC] Move

Re: [GNC] Mutual Fund Dividend After Sale

2022-09-06 Thread David T. via gnucash-user
Jack: DRIP="Dividend Re-Investment Plan" It seems to me that you've decided, in your frustration, to lash out at the people who are trying to understand your problem and offer you help. That's not a good look. You've testily confirmed that you haven't received shares from this dividend, and

Re: [GNC] A new start - somewhat strange

2022-09-05 Thread David T. via gnucash-user
Norbert, You are remembering a thread where the suggestion was to create accounts in the second currency for the major areas you anticipate tracking find in Riel. To wit: Expenses - Groceries - - USD - - RIEL Best, David T. On Sep 5, 2022, 06:45, at 06:45, Norbert Klein wrote: >Thanks –

Re: [GNC] A new start - somewhat strange

2022-09-04 Thread David T. via gnucash-user
Save to a folder in your personal workspace. Just like you'd do with your personal word processing files. David T. On Sep 4, 2022, 14:24, at 14:24, Norbert Klein wrote: >Thanks - that helped me to do the next step: > >Just create a new file: > >File -> New File > >I followed the

Re: [GNC] Change Linked Document Path

2022-09-02 Thread David T. via gnucash-user
Norbert, John is discussing a technical aspect of a migration of an existing data file, whereas you are asking about a brand new installation not presenting you with apparent next steps. In other words, not the same at all. Your question received two answers: one terse but highly accurate;

Re: [GNC] Can someone tell me how A-L=Eq+(I-Ex) is correct?

2022-08-31 Thread David T. via gnucash-user
I'm surprised no one has mentioned https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-accounting1.html#basics-accountingequation2 That's the Tutorial & Guide page that explains the concept. David T. On August 31, 2022 10:15:04 AM GMT+03:00, Gyle McCollam wrote: >Neal, >Your welcome. I

[GNC] Fwd: Re: Saved Report Configurations Missing After Upgrade to v3

2022-08-28 Thread David T. via gnucash-user
ied either. They are less important though. And certainly not now any more that you have been using gnucash 3.x already. No doubt you have already reopened registers and reports to you likings. Regards, Geert Op dinsdag 23 augustus 2022 13:02:51 CEST schreef David T. via gnucash-user:

Re: [GNC] GC 3.11 crashes during "Check & Repair"

2022-08-28 Thread David T. via gnucash-user
I'm not an expert, but I'm pretty sure the price db doesn't have splits; it's just a list of commodities, prices, and dates (asking with some other housekeeping info). I believe that "113 of 304" is in reference to the splits within a given account, so you'd need to know which account might

Re: [GNC] Saved Report Configurations Missing After Upgrade to v3

2022-08-23 Thread David T. via gnucash-user
Neville, You've responded to a thread from four years ago, referencing a problem with upgrading from version 2.4 to version 3.0 (on Windows, I believe). Gnucash is now up to version 4.11, so whatever problem you've been having is far in most users' rear view mirrors. Geert probably remembers

Re: [GNC] Example of importing Stock transactions from CSV

2022-08-21 Thread David T. via gnucash-user
The thread at https://lists.gnucash.org/pipermail/gnucash-user/2019-March/083442.html goes into quite a discussion about how to import multi line csv files. On August 21, 2022 6:26:24 PM GMT+03:00, Jon Schewe wrote: >David, > >I'm using GnuCash 4.11 from FlatPak. I have all of my

Re: [GNC] Copy/Paste Transaction Issue

2022-08-19 Thread David T. via gnucash-user
ing to go back to Quicken but I'm thinking that >it was never an issue to Copy/Paste To/From any type of account. > >On Fri, Aug 19, 2022 at 1:46 AM David T. via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> Liz, >> >> I think the issue really boi

Re: [GNC] Copy/Paste Transaction Issue

2022-08-19 Thread David T. via gnucash-user
Liz, I think the issue really boils down to "what exactly is getting copied and pasted?" I don't know the specifics, but as far as I understand it, a transaction in GnuCash looks unitary to the end user, but actually consists of a strange hybrid: a Transaction entry with (at least) two

Re: [GNC] Saving a New Book doesn't allow format selection

2022-08-17 Thread David T. via gnucash-user
>created the play file I just saved my GnuCash file with a new name so I >could test scenarios. >>> >>>>> On Aug 16, 2022, at 3:16 PM, John Ralls >wrote: >>>> >>>>  >>>> >>>>> On Aug 16, 2022, at 11:56 AM

[GNC] Saving a New Book doesn't allow format selection

2022-08-16 Thread David T. via gnucash-user
Hello, I was just testing something out with a new book, and when I went to save this new book, I was unable to select the storage format for the new book. I would have imagined that I would be able to tell GnuCash to use a specific format (like SQLite3) when I save a new book, but this

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
are to create them manually, or take the risk of editing the data file directly. Regards, Adrien On 8/16/22 2:52 AM, David T. via gnucash-user wrote: flywire, You're crossing up threads here. Jim specifically needs to create Security entries in his GnuCash file (and has stated this on several

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Actually, it was clear to me. Jim's point was that if you do these steps 130 times in a row, your brain will explode. Certainly it would be nice to be able to import them. On Aug 16, 2022, 14:05, at 14:05, flywire wrote: >Obviously it wasn't clear that the post copied below identifies the

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Jim, As you continue down this project, consider how you want to handle various aspects of accounting for stocks and mutual funds--particularly, how you want to manage tax-related transactions, such as dividend income, capital gains income, etc. With that many commodities, you will want to

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
flywire, You're crossing up threads here. Jim specifically needs to create Security entries in his GnuCash file (and has stated this on several occasions) so that he can add transactions for those securities later. Your advice regarding adding commodity transactions using csv import tools is

Re: [GNC] How to bulk import about 130 Securities entries?

2022-08-16 Thread David T. via gnucash-user
Geoff's suggestion (to use an external automation tool) would best be placed on the Using Gnucash page (https://wiki.gnucash.org/wiki/Using_GnuCash) that Adrien suggested. Flywire suggested Piecash, which is already listed on the Published tools page. On 8/16/2022 12:05 AM, Frank H.

Re: [GNC] Why does the sample "investments" account tree have intermediate "Bond", "Mutual Fund", and "Stock" accounts?

2022-08-14 Thread David T. via gnucash-user
Jim, I'll address a little of this from my non-technical, non-accountant perspective. I don't know the rationale behind those intermediate accounts, and I don't use them. That said, each investment type behaves a little differently, and perhaps separating them makes some operations easier

Re: [GNC] What is the difference between Account types "Stock" and "Mutual fund"?

2022-08-14 Thread David T. via gnucash-user
And I designate ETFs as Mutual Funds... On August 14, 2022 5:44:55 AM GMT+03:00, Derek Atkins wrote: >Pretty much the only distinction is the UI labels. >-derek >Sent using my mobile device. Please excuse any typos. >On August 13, 2022 21:53:17 Jim DeLaHunt wrote: > >> Hello, folks: >> >> I am

Re: [GNC] Order of accounts, auto numbering transactions.

2022-08-09 Thread David T. via gnucash-user
To use a different sort order, assign account codes to your accounts, add the Account Codes column to the Chart of Accounts screen, and click that column header to sort on it. For further references, each of these is covered in various places in the documentation and the lists. On Aug 9,

Re: [GNC] Third party OFX/CVS providers

2022-08-07 Thread David T. via gnucash-user
I can't imagine having so many transactions that the time it took to program the process would in the end save me time in doing the accounting. My method for processing pdf statements is to open the pdf statement in one window and enter my transactions in GnuCash in another-- the old fashioned

Re: [GNC] Stumped on Mortgage Asst - Screenshots

2022-08-02 Thread David T. via gnucash-user
Steve, I expect others will give you ideas on how or what is mistaken on the mortgage assistant. I, however, am going to suggest a different approach, which is to forego using the scheduled transactions/mortgage assistant altogether, and simply enter the monthly payments manually. The

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread David T. via gnucash-user
ostfrom them but I find it helpful when following and replying a >discussion in a thread to have them open in my browser. I don't know if they >are >mentioned in the Wiki or not. > >David Cousens > > > >On Tue, 2022-08-02 at 08:14 +0300, David T. via gnucash-user wro

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread David T. via gnucash-user
>Regards, >Adrien > >On 8/2/22 1:19 AM, David T. via gnucash-user wrote: >> "If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information." >> >> On August 2, 2022 8:26:38 AM GMT+03:00, Adrien

Re: [GNC] Gnu.cash user

2022-08-02 Thread David T. via gnucash-user
can* >technically select Liability accounts on an Asset Chart, and likely vice >versa, but they simply will be ignored) > >This is also a use case for a specific option to suppress the chart outright >rather than hack it by sizing constraints. > > >Regards, >Adrien &g

Re: [GNC] Random List Maintenance Question: Regarding Nabble

2022-08-02 Thread David T. via gnucash-user
t;What filters are you referring to? > >Regards, >Adrien > >On 8/2/22 12:14 AM, David T. via gnucash-user wrote: >> Hello, >> >> Since the Nabble mirror of Gnucash lists went down (last year?) and doesn't >> seem to be getting up again, is it time to remove

Re: [GNC] Confusing and inconsistent headers in transaction entry and report forms

2022-08-01 Thread David T. via gnucash-user
For the record, there's a Reload button on the toolbar that will... reload the current report. On August 2, 2022 6:56:17 AM GMT+03:00, davidcousen...@gmail.com wrote: > perhaps then rerun the Transaction Report. The >latter doesn't rerun automatically . You have to edit the report options and

Re: [GNC] Gnu.cash user

2022-08-01 Thread David T. via gnucash-user
Adrien, Good call. Of special interest perhaps are the Asset Chart and Liabilities Chart reports, in which the user can (a) select specific accounts to include (under Assets & Liabilities, respectively), and (b) select Show Table to list the account values below. One can even (I believe)

[GNC] Random List Maintenance Question: Regarding Nabble

2022-08-01 Thread David T. via gnucash-user
Hello, Since the Nabble mirror of Gnucash lists went down (last year?) and doesn't seem to be getting up again, is it time to remove references to it on the wiki and in every message filter? TIA, David T. ___ gnucash-user mailing list

Re: [GNC] Stock Split - am I doing this right?

2022-07-31 Thread David T. via gnucash-user
Depending on your situation, the built in mechanisms for calculating your basis and subsequently your gain may or may not generate accurate results. The lot feature is great when it works, which for me has been about 80%of the time. But if it doesn't get the right numbers (for whatever reason)

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
Geoff, Changing values of reconciled transactions without notice renders a book completely unreliable for any accounting purpose. If that's not evil, what is? David T. On July 27, 2022 2:46:34 PM GMT+03:00, Geoff wrote: >Lots. > >(And they aren't really evil, just wilful). > >;--)) > >Geoff

Re: [GNC] Trading accounts

2022-07-27 Thread David T. via gnucash-user
The thread I started, with the title "Evil Lots Behavior" was about the Gnucash *Lots* feature, which is designed to "assist" users in the management of individual lots of stock and mutual fund shares. (For the record, the lots feature will change reconciled gains transactions without

Re: [GNC] Trading accounts

2022-07-26 Thread David T. via gnucash-user
David C. Trading accounts are not the same as lots. Different concept, different code. Just a for instance: trading accounts are turned on by book; lots can be enabled by account. David T. On July 27, 2022 3:33:37 AM GMT+03:00, David Carlson wrote: >I believe that you are witnessing first

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
GnuCash lots feature as I prefer to track lots >manual ly, so I don't know how that would fit in. > >On Mon, Jul 25, 2022, 8:00 AM David T. via gnucash-user < >gnucash-user@gnucash.org> wrote: > >> Hello, >> >> I'm seeking advice from the group about the best w

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Thanks John. I appreciate it. On July 25, 2022 6:58:12 PM GMT+03:00, john wrote: > > >> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user >> wrote: >> >> Hello, >> >> I'm seeking advice from the group about the best way to handle

[GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Hello, I'm seeking advice from the group about the best way to handle a ticker/name change for a held stock. For example, Facebook renamed itself Meta a while back, and in June they changed their ticker from FB to META. Naturally, I wish the Gnucash books to reflect these changes; I also

Re: [GNC] Another crash

2022-07-24 Thread David T. via gnucash-user
A couple of additions to Adrien's information: 1) Searching using "site:lists.gnucash.org" will also include all the documentation and other gnucash resources. This may be useful, of course! But if you want *just* the list archives, use "site:lists.gnucash.org/pipermail" 2) Unfortunately,

Re: [GNC] Another crash

2022-07-24 Thread David T. via gnucash-user
Phyllis, Although I haven't used the importer in recent years, I know that in the past it has been known to take a LONG time to process. Perhaps it was still working on the import when you went to Task Manager and killed the process. Also, I know that when I've been creating new accounts on

Re: [GNC] Lost 4 hours of data input

2022-07-22 Thread David T. via gnucash-user
It's too bad that the responses to "Gnucash has crashed and I lost X hours of work" are: 1. Save more often. 2. Don't use a cloud service except as an offline backup. 3. Use the db backend (which is basically a technological alternative to #1). On July 22, 2022 8:51:01 PM GMT+03:00,

Re: [GNC] What is the intended effect of hiding an account ?

2022-07-21 Thread David T. via gnucash-user
You would be advised to read https://wiki.gnucash.org/wiki/Documentation_Improvement On July 22, 2022 12:18:37 AM GMT+03:00, Tom Browder wrote: >On Thu, Jul 21, 2022 at 15:53 David Carlson >wrote: > >> Perhaps another user misunderstood your question. John R is a major >> developer and he

Re: [GNC] Evil Lots Behavior

2022-07-20 Thread David T. via gnucash-user
ully reversible - just delete all the Capital >Gains/Losses transactions it created and start matching Buys and Sells again. >Rinse and repeat. > > >Hope this helps. > >Regards > >Geoff >= > > >On 21/07/2022 12:40 am, David Carlson wrote: >> It could

Re: [GNC] Hidden accounts still visible

2022-07-20 Thread David T. via gnucash-user
BTW, this is covered in 5.4 of the Guide. On July 20, 2022 4:57:15 PM GMT+03:00, "David T. via gnucash-user" wrote: >You have set your view preferences to display hidden accounts. View->Filter by >{Other tab} Show hidden accounts > >To hide an account in the drop d

Re: [GNC] Hidden accounts still visible

2022-07-20 Thread David T. via gnucash-user
You have set your view preferences to display hidden accounts. View->Filter by {Other tab} Show hidden accounts To hide an account in the drop down list, set the account to Placeholder. On July 20, 2022 4:03:40 PM GMT+03:00, Stan Brown wrote: >On 2022-07-19 23:40, David T. via gnucas

[GNC] Evil Lots Behavior

2022-07-20 Thread David T. via gnucash-user
Hello, In the course of catching up with my accounting, I've been working extensively with mutual fund holdings, and their buys and sells. I have found a disturbing bug in the way that the lots feature handles existing gains. Specifically, the software recalculates ALL gains in a lot the

[GNC] Memory demands and system performance of Gnucash (Was Re: GC4.10 on Win10 Crashing)

2022-07-20 Thread David T. via gnucash-user
grinding down to a crawl. Even on my >> highest performance machines it takes several seconds to save but I usually >> do it before starting any activity that will take more than a few minutes. >> >> On Tue, Jul 19, 2022 at 1:43 PM David T. via gnucash-user < >>

Re: [GNC] Revising an old Gnucash file

2022-07-20 Thread David T. via gnucash-user
If you set an account to Hidden, it will be... hidden in the chart of accounts. Assuming that your messed up account is a catch-all account from which you hope to move transactions, I'd actually keep that account visible, and change the messed up transactions to reflect my current intention--

<    1   2   3   4   5   6   7   >