Re: For UK users: Will gnucash get ready for Making Tax, Digital ?

2017-09-06 Thread Wm via gnucash-user
On 23/08/2017 18:11, mike.m...@gmx.net wrote: A little more reading. [1]https://www.cchdaily.co.uk/lords-probe-software-companies-lack-readiness-m aking-tax-digital Please note that this link is mostly outdated, espcially the deadlines mentioned are not any more applicable. The

Re: GnuCash: Docs: Where to document?

2017-12-13 Thread Wm via gnucash-user
On 13/12/2017 00:57, brad wrote: I would like to see something on this in the wiki. Just because Mac & windows don't have python and sql by default doesn't mean that the knowledge base should be dumbed down. It is not a case of dumbing down. Building gnucash with python on windows is

Re: export general ledger

2017-12-17 Thread Wm via gnucash-user
On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, assets, or liabilities.  But I'd like to have all transactions in the csv file. I think I see how to do this

Re: export general ledger

2017-12-18 Thread Wm via gnucash-user
On 18/12/2017 13:16, Sébastien de Menten wrote: To export a gnucash book to a ledger-cli output, you may be interested by the piecash python module and the related script https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py I already said that, you just have to wait

Re: export general ledger

2017-12-18 Thread Wm via gnucash-user
On 18/12/2017 10:32, Jeff Abrahamson wrote: On 18/12/17 03:26, Wm via gnucash-user wrote: On 17/12/2017 19:31, Jeff Abrahamson wrote: I'd like to export the general ledger to a csv file.  When I use File -> Export, however, I'm offered a choice of exporting income, expenses, ass

Re: export general ledger

2017-12-18 Thread Wm via gnucash-user
On 18/12/2017 18:13, Adrien Monteleone wrote: Jeff, If I recall correctly from other discussion, the General Ledger is not it’s own entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This is probably why there is no export option for it. You recall incorrectly. The

Re: Finance-Quote Price Issue

2017-12-09 Thread Wm via gnucash-user
On 20/11/2017 00:37, Richard Ullger wrote: There is an issue with prices for UK funds and investment trusts downloaded on a Saturday and Sunday which are appearing 100 times too small. When these prices are retrieved Monday to Friday they are correct. Prices for stocks and bonds are not

Re: How to Manually Track a Collection of Stocks & Stuff Combined into a Single Share

2018-02-09 Thread Wm via gnucash-user
On 08/02/2018 14:28, David Carlson wrote: If you want to create a fictional stock and manually enter prices from time to time that is easy. Just use the security editor and invent a name and symbol, possibly under the group called Fund. Do not set an online quote source. Then manually use the

Re: Trading Accounts

2018-02-14 Thread Wm via gnucash-user
On 12/02/2018 17:12, Les wrote: I use, in addition to USD. AUD, HKD, CAD, CNY and SGD.  I buy in tranches for average cost.  So, not sure that means I have complicated trades but I make sure I never have any orphan accounts. I checked my test file for capital and it did not list any. Although,

Re: A predictive bar graph needed

2018-02-14 Thread Wm via gnucash-user
On 12/02/2018 19:11, Cliff McDiarmid wrote: Thanks Adrien I thought as much. That's a shame everything else is what I need. I don't know what a predictive bar graph is so, unsurprisingly, I'm not missing one. Hint: using terms you are familiar with and other people aren't usually

Re: p2x modelling in gnc, help me think, please

2018-02-09 Thread Wm via gnucash-user
On 07/02/2018 18:17, Adrien Monteleone wrote: Go to Preferences > General > Numbers. You can increase your decimal precision. Did that solve the small fraction issue? That isn't a good way to go if your base currency is a 2 decimal one. Creating a commodity with the appropriate number of

p2x modelling in gnc, help me think, please

2018-02-07 Thread Wm via gnucash-user
Background: I am a p2x investor, I like it, it is fun and may do some good to far away people and get me a better return on my money than more conventional investments ... or I could lose it all. Ho hum. the gnc point is how best to model a p2x investment. my p2x investments involve hundreds

Re: Reports balance sheet - with explicit dual currency for "$"

2018-02-25 Thread Wm via gnucash-user
On 24/02/2018 18:05, Vin Ordinaire wrote: Dollars are great - pick one of many flavours USD,CAN,AUD,HKG,Bermuda,Singapore and about 10 others. The problem is reporting a balance sheet multiple currency assets. I located in the Windows version Options>Commodities>Show Foreign Currencies that

Re: Account Report/Register Report

2018-03-08 Thread Wm via gnucash-user
On 06/03/2018 01:25, Robin Chattopadhyay wrote: Hi- Using Linux Mint 18.3, Gnucash 2.6.19... There's a report I like to use called Account Report. You can get to it after opening a register. I use this report to see what gnc has as the cost basis for an investment. I'm not sure that was how

Re: Integrating Profit and Loss Report into a set of books and the trial balance

2018-03-08 Thread Wm via gnucash-user
On 06/03/2018 15:13, jcnw wrote: I am setting up a set of books for a small church and need to run a month profit and loss report. How do I enter the Net Income for the Period into the books so it shows up in the balance sheet? I have set up the books with Income, Expense, Asset and Liability

Re: Integrating Profit and Loss Report into a set of books and the trial balance

2018-03-12 Thread Wm via gnucash-user
On 07/03/2018 23:14, Stan Brown wrote: On Wed, Mar 7, 2018, at 10:56 AM, John Wilson wrote: Stan, Thank you for your prompt help. Attached is my first P statement which shows an income of $1,458.23 but when I run a trial balance it does not appear in Earnings, which Equity:Earnings account that

Re: General Ledger

2018-03-03 Thread Wm via gnucash-user
On 03/03/2018 13:47, Stan Brown wrote: On 2018-03-02 13:47, Wm via gnucash-user wrote: On 23/02/2018 12:52, Adrien Monteleone wrote: And unfortunately, this filter change is not sticky. You’ll have to reset it each time you load the GL. This is already a filed bug. AdrienM, it is not a bug

Re: General Ledger

2018-03-03 Thread Wm via gnucash-user
On 02/03/2018 16:22, Leo Bolta wrote: Not to keep the thread alive but these are photos of select pages of the 1882 High School bookkeeping text book, I referred to earlier and promised to distribute. Several of the previous commenter's may have been quite accurate in regards to the historical

Re: How to get summary journal entries

2018-03-03 Thread Wm via gnucash-user
On 28/02/2018 23:24, Stefan Riha wrote: I'm a beginner and I'd like to examine how sales and expenses change assets and liabilities (a.k.a ."summary journal entry", see e.g. Accounting workbook for dummies by J. Tracey, link to google books below). cash sale or sale on account ? expense on

Re: General Ledger

2018-03-03 Thread Wm via gnucash-user
On 26/02/2018 18:16, Greg Feneis wrote: I keep seeing this email subject line and imagine you guys are discussing a lesser known war hero Thank you, Mr Feneis, I'm not sure what this thread is really about either but commend your humour. It doesn't really matter what the damn thing is

Re: Big thanks, Windows version, multi-currency symbol bug ?

2018-03-03 Thread Wm via gnucash-user
On 01/03/2018 18:02, Y B wrote: Having problems posting: someone included paypc.com on the spam assassin list. we are innocent ! Hello ! Following the suggestion of Fred Perrin to set Tools>Security Editor>Show National Currencies, I'm posting here. Thanks also to Mike Alexander for his

Re: General Ledger

2018-03-03 Thread Wm via gnucash-user
On 23/02/2018 12:52, Adrien Monteleone wrote: And unfortunately, this filter change is not sticky. You’ll have to reset it each time you load the GL. This is already a filed bug. AdrienM, it is not a bug if you have many years of tx, promise. I like the narrow time window. -- Wm

Re: General Ledger

2018-03-03 Thread Wm via gnucash-user
On 23/02/2018 21:52, Buddha Buck wrote: I suspect that GnuCash terminology regarding journals and ledgers is somewhat confused and non-standard. yeah, they are convenience terms My basic understanding of classical accounting is that transactions were first entered into journals, and then

Re: Liabilities / Accounts

2018-03-01 Thread Wm via gnucash-user
On 27/02/2018 17:53, Adrien Monteleone wrote: James, Everyone has their own methods, but the Tutorial & Concepts Guide has a suggestion that I’ve followed and it’s served me well. I always enter transactions working in the account register the money is coming FROM. I never use the General

Re: Transaction report ?? currency symbol

2018-03-05 Thread Wm via gnucash-user
On 05/03/2018 15:23, Adrien Monteleone wrote: I see then my first guess was wrong. I’ve never played with Docker so I wasn’t aware you had to specify locales when creating the image. Glad to see you got it worked out and thanks for posting the solution for posterity! Getting the locale

Re: Printing no longer works on Windows 10 Pro

2018-03-05 Thread Wm via gnucash-user
On 22/02/2018 07:53, David Carlson wrote: I seem to recall that GnuCash uses a different printing system dialog than most other windows programs. Perhaps a developer knows where to look for this problem. I'd prefer a developer to spend 0 time on a problem that can be solved by copy and paste

Re: Reporting based on search criteria and exprting transactions to excel. It's simple!

2018-03-05 Thread Wm via gnucash-user
On 03/03/2018 03:27, Mike Stillingfleet wrote: I have used GNUCash for a couple of years now. in recent days I have come across a couple of features or tricks which have completely transformed the value of GNUCash to me. Yet neither of these features are in the help pages. Or if the are in

Re: [GNC] Can't assign payment to multiple invoices

2018-11-01 Thread Wm via gnucash-user
On 27/10/2018 19:24, wail wrote: Hello, I have a list of invoices and a list of payments and I'm trying to assign payments to invoices (I'm using Gnucash 3.3 on Ubuntu 18.10). The problem is that my client pays sums that are not related to invoices, e.g. invoices would be $4 $5 $3 $6 while

Re: [GNC] How to run GNUcash in portable fashion?

2018-11-01 Thread Wm via gnucash-user
On 27/10/2018 13:46, Kim Wood wrote: Here is another suggestion that works for me. I use the most recent PortableApps build, and simply delete the \PortableApps\GnuCashPortable\App\gnucash directory, and replace it with my more recent c:\Program Files (x86)\gnucash directory. Works fine for

Re: [GNC] How to run GNUcash in portable fashion?

2018-11-01 Thread Wm via gnucash-user
On 26/10/2018 21:36, Paul Kinzelman wrote: Not ideal of course, but if you install GC on all the computers you want to run on, you could just put the data on the flash drive and plug it in to whatever computer you want and have already installed GC and then start GC. Wrong! the clever people

Re: [GNC] How to run GNUcash in portable fashion?

2018-11-01 Thread Wm via gnucash-user
On 27/10/2018 09:34, Geert Janssens wrote: Agreed. And on several occasions I have been thinking about adjusting the gnucash code and its Windows installer to make this universally possible. It never really happened so far due to lack of time and other priorities. the .gnucash folder model

Re: [GNC] Question about sub accounts

2018-11-01 Thread Wm via gnucash-user
On 29/10/2018 14:55, Eric Gwin wrote: Hi, I'm pretty new to to application, and have basically 0 accounting background. I've setup my books and all is working pretty well, but I am running into an issue with subaccounts I hope I'm doing something wrong, but if not I'd also like to know so I can

Re: [GNC] Question about sub accounts

2018-11-01 Thread Wm via gnucash-user
On 29/10/2018 16:49, Adrien Monteleone wrote: We’ve discussed envelope budgeting quite a bit here on the list. Do a list restricted search to find the threads. I’ve tried it myself in the past, and currently have the account tree set up to use, but honestly, it is probably better to use an

Re: [GNC] How to run GNUcash in portable fashion?

2018-11-01 Thread Wm via gnucash-user
On 26/10/2018 21:27, aeneas wrote: Very nice reply! It looks like knowing about GNC_DATA_HOME goes a long way toward solving my problem. From what I can see I'm not using AQBANKING. Also, I'd speculate that my scheme may not be be completely fool-proof. I did search the registry for

Re: [GNC] Backup

2018-11-01 Thread Wm via gnucash-user
On 31/10/2018 01:24, D via gnucash-user wrote: Check out https://wiki.gnucash.org/wiki/Backup You should not point people to incorrect and misleading links -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

Re: [GNC] Feature request: Stock currency setting

2018-11-01 Thread Wm via gnucash-user
On 27/10/2018 13:30, rsbrux via gnucash-user wrote: You can just move the account, but the transaction currency is immutable so you will have to delete and re-create the transaction. As for adding a trading currency to the security editor, it’s possible but the code for creating transaction

Re: [GNC] Backup

2018-11-01 Thread Wm via gnucash-user
On 31/10/2018 00:52, Bob Hammons wrote: I have been using Gnucash since the first of the year. The data files are in a directory named gnucash and it save a lot of backups. I am using Windows 10. I open filer and control c the days files, sometimes as high as 20, and paste them to a thumb

Re: [GNC] Backup

2018-11-02 Thread Wm via gnucash-user
On 01/11/2018 09:27, Geert Janssens wrote: Op woensdag 31 oktober 2018 17:09:27 CET schreef Wm via gnucash-user: On 31/10/2018 01:24, D via gnucash-user wrote: Check out https://wiki.gnucash.org/wiki/Backup You should not point people to incorrect and misleading links What's misleading

Re: [GNC] Capital losses in Advanced Portfolio Report

2018-11-02 Thread Wm via gnucash-user
On 21/10/2018 11:18, José A. Fernández Troncoso wrote: Yes, when I create a sale transaction on the stock, a capital loss is calculated automatically by the report and shown as a negative amount in the Realized Gain column. That's fine by me. It presumes a tax regime, unfortunately. The

Re: [GNC] Can't assign payment to multiple invoices

2018-11-02 Thread Wm via gnucash-user
On 01/11/2018 10:39, Wail Yahyaoui wrote: Wm: If the payments really are unrelated to the invoices use the old fashioned payment on account method, i.e. reduce the balance on the Liability and tidy it up occasionally. > > I wanted to clean the unpaid invoice list. # > What do you mean by

Re: [GNC] Unable to retrieve quotes for these items:, CURRENCY:EUR

2018-11-02 Thread Wm via gnucash-user
On 21/10/2018 10:32, rsbrux via gnucash-user wrote: Dear John, Thanks for the tip!  After a bit of experimentation, it seems that the problem has to do with the number of currency exchange rates requested. If I reduce the number to five or fewer, the price update works.  I guess this has to

Re: [GNC] Backup

2018-11-02 Thread Wm via gnucash-user
On 01/11/2018 16:40, Ronal B Morse wrote: I don't see any reason to change the Wiki. People who already have a backup plan in place know what they need to do. So long as no-one is ever allowed to say "I followed your instructions and lost my data" I agree. I am waving and saying, "I have

Re: [GNC] Stock Quotes

2019-01-14 Thread Wm via gnucash-user
On 03/01/2019 19:03, nvsoar wrote: On 01/02/19 08:51, Dave Cooper via gnucash-user wrote: Hi gnucash I have returned to gnu-cash having not used it for several years so please bear with me. I have reloaded the system and set it up to get some UK stock prices (LSE) using Alphavantage

Re: [GNC] Are there any add-on modules for Gnucash

2019-02-23 Thread Wm via gnucash-user
On 22/02/2019 15:34, John Ralls wrote: Our position has always been and will likely always be that we support writing to a GnuCash file or database only through the GnuCash API. That's not the same thing as from inside of GnuCash. Nods, in theory. GnuCash's libraries expose their API

Re: [GNC] Are there any add-on modules for Gnucash

2019-02-23 Thread Wm via gnucash-user
On 21/02/2019 21:03, Adrien Monteleone wrote: Otherwise, if you have a case of say, high volume day trading, you are probably limited to tracking most of the activity outside of GnuCash, generating daily net transactions and just entering/importing those. Good advice, Adrien. The gnc data

Re: [GNC] How to handle bounced check

2019-02-02 Thread Wm via gnucash-user
On 02/02/2019 04:24, Mike Alexander wrote: A few weeks ago I received a check in payment for an invoice I had sent to a customer. I recorded the payment and deposited the check. A couple of weeks later I got notice from my bank that the check had bounced. My question is how to record this.

Re: [GNC] Bookkeeping for a club's charity account - use business features?

2019-08-24 Thread Wm via gnucash-user
On 23/08/2019 09:24, Michael Hendry wrote: First, Adrien makes some very valid points which I think you should consider. As previously mentioned on the list, I’ve just become Treasurer of our local Rotary Club, which has two sets of books, one relating to the business of running the club

[GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-08-24 Thread Wm via gnucash-user
heads up, folks morningtstar.co.uk (and possibly other European versions) have changed some stuff that mean some F::Q requests have stopped working. This isn't gnc's fault. If you use a quote source such as mstaruk expect it to fail until the F::Q folks catch up. Would people with

Re: [GNC] Gnucash bug

2019-07-30 Thread Wm via gnucash-user
On 09/07/2019 03:45, John Ralls wrote: On 8 juil. 2019, at 08:55, R. Victor Klassen wrote: Perhaps this has been fixed. I’m using 2.6.21 for production. Using SQLite I am expecting every transaction to hit disk immediately. Saturday we had a power failure and lost about five days’ worth

Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-11-23 Thread Wm via gnucash-user
On 25/08/2019 00:06, Richard Ullger wrote: On 23/08/2019 14:26, Wm via gnucash-user wrote: heads up, folks morningtstar.co.uk (and possibly other European versions) have changed some stuff that mean some F::Q requests have stopped working. This isn't gnc's fault. If you use a quote source

Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-12-03 Thread Wm via gnucash-user
On 01/12/2019 15:36, John Ralls wrote: On Nov 30, 2019, at 12:58 PM, Wm via gnucash-user wrote: On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc

Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-12-02 Thread Wm via gnucash-user
On 01/12/2019 15:36, John Ralls wrote: On Nov 30, 2019, at 12:58 PM, Wm via gnucash-user wrote: On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc

Re: [GNC] Restricted funds and other charitable / not-for-profit specifics

2019-12-07 Thread Wm via gnucash-user
On 25/11/2019 18:33, Michael or Penny Novack wrote: On 11/24/2019 6:17 AM, Wm via gnucash-user wrote: Is anyone interested in resurrecting the possibility of gnc dealing with restricted funds and other charitable / not-for-profit / whatever they are called where you live accounting better

Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-11-24 Thread Wm via gnucash-user
On 23/11/2019 20:12, Richard Ullger wrote: I get (on Saturday evening)... gnc-fq-dump -v mstaruk GB00B4PQW151 Finance::Quote fields Gnucash uses: symbol: GB00B4PQW151 <=== required date: 11/22/2019 <=== recommended currency: GBP <=== required

Re: [GNC] Non-cash charity contributions

2019-11-24 Thread Wm via gnucash-user
On 24/11/2019 18:26, Kevin Reid wrote: On Sun, Nov 24, 2019 at 10:14 AM Art Chimes wrote: I have an expense account called "charity:non-cash contributions" where I record these (potentally tax-deductible) donations, but I don't know how best to record the other side of the transaction. …

[GNC] Restricted funds and other charitable / not-for-profit specifics

2019-11-24 Thread Wm via gnucash-user
Is anyone interested in resurrecting the possibility of gnc dealing with restricted funds and other charitable / not-for-profit / whatever they are called where you live accounting better? -- Wm ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

2019-11-30 Thread Wm via gnucash-user
On 24/11/2019 23:07, Richard Ullger wrote: On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote: Which OS and perl version are you on? At the moment it is looking like gnc might need a more recent version of strawberry perl on Win but I can't quite work out why. If you

Re: [GNC] Vanguard investments module for Gnucash / Finance ::Quote

2019-11-23 Thread Wm via gnucash-user
On 19/11/2019 16:27, Derek Robinson via gnucash-user wrote: Vanguard investors using GnuCash may be frustrated that many Vanguard products (like their 529 portfolios, any 401(k) / 403(b) products with the word "Trust" in the title) do not have prices that are easily obtainable from one of the