Re: [GNC] Net Worth Barchart

2022-12-05 Thread Adrien Monteleone
Liz, I just ran the chart for myself and indeed, it appears your Liabilities are backwards. That is, if you owe money, they should have a Credit balance, but yours show as Debit balance. (The *normal* balance of a Liability account is Credit, not Debit) What is your preference setting for

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Liz
On Tue, 6 Dec 2022 17:30:35 +1100 Geoff wrote: > Hi Liz > > I think the other side of that liability entry should be something > like "Expenses:Company Tax". > > Regards > > Geoff > = > Thanks for that. A bit of rearranging and now the Net Worth barchart looks a bit more logical. Liz

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Geoff
Hi Liz I think the other side of that liability entry should be something like "Expenses:Company Tax". Regards Geoff = On 6/12/2022 5:01 pm, Liz wrote: On Tue, 6 Dec 2022 15:40:06 +1100 Chris Grinton wrote: The charts suggest that you have *negative* liabilities. That is, while the

Re: [GNC] Same security, two namespaces

2022-12-05 Thread Adrien Monteleone
If you are searching for Accounts and not Transactions use Edit > Find Account. Regards, Adrien On 12/5/22 11:05 PM, Fred Tydeman wrote: Another issue I have noticed: If I change what is being searched from Description to Account, and change Selected Accounts to select some, then there is

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Liz
On Tue, 6 Dec 2022 15:40:06 +1100 Chris Grinton wrote: > The charts suggest that you have *negative* liabilities. That is, > while the underlying accounts may have a type of "Liability", the net > balance of these accounts is negative, so are effectively an asset. > > For "normal" positive

Re: [GNC] Net Worth Barchart

2022-12-05 Thread William Prescott
I'm no accountant, but it looks to me like your liabilities are all negative. When you subtract negative liabilities from assets, the net worth is greater. A = 10 L = -1 NW = 10 - (-1) = 11 Will On Dec 5, 2022, at 22:22, Liz wrote: Gnucash Version: 4.12 Build ID: 4.12+(2022-09-24) Here is a

Re: [GNC] Same security, two namespaces

2022-12-05 Thread Fred Tydeman
On Mon, Dec 5, 2022 at 5:10 PM David H wrote: > Fred, > > Are you doing your Ctrl-F in the accounts tab or a register tab? If you do > it in a register tab it only looks at the splits for that register, if you > do it in the Accounts tab it should find both sides of the transaction. Got > caught

Re: [GNC] Net Worth Barchart

2022-12-05 Thread Chris Grinton
The charts suggest that you have *negative* liabilities. That is, while the underlying accounts may have a type of "Liability", the net balance of these accounts is negative, so are effectively an asset. For "normal" positive liabilities, the red bars in the chart would be above the $0 line as

[GNC] Net Worth Barchart

2022-12-05 Thread Liz
Gnucash Version: 4.12 Build ID: 4.12+(2022-09-24) Here is a screenshot of my Net Worth Barchart. I have checked that Assets are type "Assets" and Liabilities are type "Liabilities" Can someone explain to me why or how my Net Worth is greater than my Assets despite the existence of Liabilities? I

Re: [GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread gnu Gord
Thanks. Sorry I missed the fact that it was already in the works. I'll try to do a better search next time. Regards, Gord On Mon, Dec 5, 2022 at 4:51 PM john wrote: > Already in the works for GnuCash 5: > https://github.com/Gnucash/gnucash/pull/1447 > > Regards, > John Ralls > > > On Dec 5,

Re: [GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread Glenn Fowler
Hi Gord, There is a feature request for that already in which you can add your vote: https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1620703-autofill-feature-should-show-a-drop-down-list From: gnucash-user on behalf of gnu Gord Sent:

Re: [GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread john
Already in the works for GnuCash 5: https://github.com/Gnucash/gnucash/pull/1447 Regards, John Ralls > On Dec 5, 2022, at 3:08 PM, gnu Gord wrote: > > I'm wondering if anyone else would find it useful, or if anyone else has > already suggested an enhancement to GnuCash whereby it would

Re: [GNC] Stock transfer

2022-12-05 Thread john
I'd move the whole account, but that depends on your having a pair of placeholders something like Assets:Investment:Vanguard:Stocks Assets:Investment:Fidelity:Stocks to contain the stock accounts. If you already have some IBM in your Fidelity account you might make a placeholder IBM account with

Re: [GNC] Same security, two namespaces

2022-12-05 Thread David H
Fred, Are you doing your Ctrl-F in the accounts tab or a register tab? If you do it in a register tab it only looks at the splits for that register, if you do it in the Accounts tab it should find both sides of the transaction. Got caught by this a little while back. Cheers David H. On Tue, 6

[GNC] Auto Complete "pick from list" enhancement

2022-12-05 Thread gnu Gord
I'm wondering if anyone else would find it useful, or if anyone else has already suggested an enhancement to GnuCash whereby it would display a list of memorized transactions when one was being entered. Currently if I start typing in the description field GC finishes the field and if I hit tab it

[GNC] Same security, two namespaces

2022-12-05 Thread Fred J. Tydeman
Due to a mixture of manual entry of transactions and import of QIF, I have ended up with the same security in two different namespaces. Stock/Intl KOF coca cola Stock/US KOF coca cola Is there a way to merge the two? So that there is just one in the correct namespace? I have done: Edit:

[GNC] Stock transfer

2022-12-05 Thread Fred J. Tydeman
What is the best way to transfer stock from one brokerage to another brokerage? For example, 100 shares IBM from Vanguard to Fidelity. Enter just the number of shares and leave the price and cost fields blank? Enter number of shares along with basis price of those shares? Something else? What

Re: [GNC] Disabling Lots Manager

2022-12-05 Thread David T. via gnucash-user
John, Thanks for the detailed advice. I will look into each of these issues closely before any further action. ⁣David T. ​ On Dec 5, 2022, 10:43 PM, at 10:43 PM, john wrote: >David, > >Obviously make a copy of your SQLite file and work with that. I know >you know that, but it's always good

Re: [GNC] Lot Calculator Off?

2022-12-05 Thread john
Run a transaction report on the register, paste it into a spreadsheet, and calculate the sum of the gains. Run a trial balance report for the day after the transaction and make sure there aren't any unrealized gains from the sale, then run an Income Statement for the day and check that the

Re: [GNC] Automatic Price Updates

2022-12-05 Thread john
Get it working before worrying about the rest. First make sure that the hook is firing by adding a print statement to the lambda, something like (gnc-hook-add-scm-dangler HOOK-UI-POST-STARTUP (lambda () (format #t "Retrieving Quotes~%") (gnc:book-add-quotes #f

Re: [GNC] Disabling Lots Manager

2022-12-05 Thread john
David, Obviously make a copy of your SQLite file and work with that. I know you know that, but it's always good to remind everyone who might find this thread later. You also need to remove any entries in the lots-guid field of splits: update splits set lot_guid = NULL where lot_guid not NULL;

Re: [GNC] Lot Calculator Off?

2022-12-05 Thread David T. via gnucash-user
Further to the issue of the lot manager splitting sales by lots: I attach the screenshot of GnuCash's management of the capital gains for one mutual fund sale. As you can see, there is a more than a full screen of separate gains transactions generated by the Lots Manager for this one sale

Re: [GNC] searching for inventory tags -- bind keys -- best ways

2022-12-05 Thread John Griessen
On 12/4/22 22:27, Adrien Monteleone wrote: Any changes you make otherwise might cause havoc. Changes to memo lines will cause havoc? Why -- no numbers in transactions are changed by memo lines. ___ gnucash-user mailing list

Re: [GNC] Help with online banking setup please: TD Bank and Amex

2022-12-05 Thread Scott Traurig
I've got TD bank authenticating, but not downloading a list of accounts. Manual account entry allows online queries to be made, but the response is a 404 error. I suspect it has something to do with TD Bank needing to see a Quicken connection first, which then must be authorized by logging into

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-05 Thread Robert Heller
At Mon, 5 Dec 2022 09:08:39 -0500 Steve Thompson wrote: > > Thank you, and others who posted. > > So I went looking for the Gnu Cash installation files (that is > what was installed and actually being used) and after looking at > the 2.6 Migrating GnuCash Data for a second time, I now >

Re: [GNC] Why doesn't GnuCash have an Export function?

2022-12-05 Thread Steve Thompson
Thank you, and others who posted. So I went looking for the Gnu Cash installation files (that is what was installed and actually being used) and after looking at the 2.6 Migrating GnuCash Data for a second time, I now understand the *files *I need to copy over (not as bad as the Thunderbird

Re: [GNC] Help with online banking setup please: TD Bank and Amex

2022-12-05 Thread Scott Traurig
I got AMEX running. Still working TD Bank. Looks to be a user authentication problem. Thanks, Scott On Mon, Dec 5, 2022 at 8:05 AM Scott Traurig wrote: > Using information from the following references: > > https://www.gnucash.org/docs/v4/C/gnucash-help/tools-on-line-banking.html >

[GNC] Help with online banking setup please: TD Bank and Amex

2022-12-05 Thread Scott Traurig
Using information from the following references: https://www.gnucash.org/docs/v4/C/gnucash-help/tools-on-line-banking.html https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect https://www.ofxhome.com/index.php/home/directory/T 1. I was able to log into Amex but not retrieve accounts. 2. I

Re: [GNC] Automatic Price Updates

2022-12-05 Thread rsbrux via gnucash-user
A little further study suggests that I should have placed config-user.scm in GNC_CONFIG_HOME (in my case $HOME/.var/app/org.gnucash.GnuCash/config/gnucash/) instead of GNC_DATA_HOME (see https://wiki.gnucash.org/wiki/Configuration_Locations#In_GNC_CONFIG_HOME). However, moving it there still

Re: [GNC] Disabling Lots Manager

2022-12-05 Thread David T. via gnucash-user
Hello, Having worked my way through approximately 25 investment accounts to clear out Lots manually, I realize that I will never finish this using direct user action. There are just too many accounts to check. I am now prepared to use less orthodox methods, but I wanted to see whether