Re: [GNC] Closing books questions

2019-02-20 Thread Adrien Monteleone
If you don’t ‘close books’ there really aren’t any ‘brought forward’ numbers. (there’s nothing to bring forward from, the books are still ‘open') If your books don’t agree with your CPA, you’ll have to make the adjusting entries he recommends. You won’t lose the >2017 transactions, but your

[GNC] Closing books questions

2019-02-20 Thread Terence Wong
I have been using Gnucash for years, each time the accountant audits the books, he commented Gnucash fails to show accurate brought forward figures. My last audit was two years ago. Since then, I have been putting in entries as time goes by. For this year, I want to try get all the numbers

Re: [GNC] Connect MySQL to GnuCash

2019-02-20 Thread David Cousens
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html The SQL commands GnuCash uses to create the database are given here https://wiki.gnucash.org/wiki/SQL David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

Re: [GNC] Connect MySQL to GnuCash

2019-02-20 Thread David Cousens
Steve, You will need to save the file as MySQL using the File->Save A,s if not already done, to create the MySQL database. Once that is done it should be no problem to connect MySQL workbench as per any other database. GnuCash will have to have been built with support for MySQL (which is the

[GNC] Connect MySQL to GnuCash

2019-02-20 Thread Steve Isenberg via gnucash-user
Anyone have any tips or resources on connecting MySQL workbench to a GnuCash file? Thanks ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Changing account numbers?

2019-02-20 Thread David Cousens
Dan In the Account tree view, right click on the account and select Edit Account.. You can then change the account number in the dialog which comes up David Cousens - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

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-20 Thread Liz
On Tue, 19 Feb 2019 05:23:19 -0600 (CST) David Cousens wrote: > Why should the interest have any connection to the CD account? This > would only be applicable if there was a dividend reinvestment for > example as with share/stocks. This is the only time a dividend would > increase your stock

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

2019-02-20 Thread Adrien Monteleone
You shouldn’t need to have separate accounts for each. Since you can specify the source using the description, notes, or memo, you can run reports showing the info you need to determine the source of any funds. It is usually rare to need special accounts for singular purposes, general accounts

[GNC] How-to question: CD Interest payments deposited in a different account

2019-02-20 Thread Art Chimes
Thanks all who replied, and so quickly, too. I think Dale pretty much nailed it, about over-thinking the problem. Or perhaps more accurately, failing to think about it in a new (gnu?) way. Since the interest payments originated with the asset (the CD), I assumed that the payments should first

Re: [GNC] Delete and Backspace keys not working in Flatpak GnuCash

2019-02-20 Thread Adrien Monteleone
There was a similar bug (or bugs) on this issue that was fixed in 3.4. I’ve been using it since its release and I no longer have issues with backspace or delete. Give it a try if you can. Regards, Adrien > On Feb 20, 2019, at 12:13 AM, LeonM wrote: > > Hello, > > I have been a long time

Re: [GNC] Delete and Backspace keys not working in Flatpak GnuCash

2019-02-20 Thread Colin Law
Pretty sure this was a bug in 3.2 Colin On Wed, 20 Feb 2019 at 06:16, LeonM wrote: > > Hello, > > I have been a long time users of GnuCash in Mint and I have just set up a > Mint 18.3 (64bits) in a VMWare VM hosted on Win8.1 to test the Flatpak > version of GnuCash (ver 3.2). > > Missing OFX