RE: Outgoing personal loan clarification

2017-11-02 Thread Tony Vanson
I set up a “money owing” asset Transferred the loan amount to it from ‘bank account’ Transferred 1st repayment amount from “money owing” to “cash in wallet” asset Works for me Cheers Sent from Mail for Windows 10 From: Frankie Raney Sent: Friday, 3 November 2017 1:22 AM To: Tony Vanson Cc:

Re: finance-quote error

2017-11-02 Thread Keith Myers
Confused why the Price Quote worked up till Nov. 1 when all my Google searches indicate the API was pulled back in July. Why was it still working till yesterday? What are the Gnucash developers going to do to remedy the problem? I see that there is a free API from Alpha Vantage. Why can't the

Re: finance-quote error

2017-11-02 Thread David Carlson
I found another program that may still be able to get prices, including historical prices. It just worked a moment ago to get the price of a NYSE stock. It would not be trivial to export tables from that program to import into GnuCash, but maybe someone wants to try... Google "TakeStock2" On

Re: Broken Search Link

2017-11-02 Thread Tommy Trussell
On Wed, Nov 1, 2017 at 9:39 PM, D via gnucash-user wrote: > This is a known issue. You can use Google and specify the site to get > reasonable results. > > Which page was this on? > > David > > On November 2, 2017, at 3:16 AM, Alan Whiteman >

Re: finance-quote error

2017-11-02 Thread MGC
Nobody knows what terms of service were violated. The yahoo finance help community is exploding over this. Check that out for a fun read. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

Re: finance-quote error

2017-11-02 Thread David Carlson
OK, I think I found the problem, they discovered that there is no practical way to take possession of our first-born children and they cannot tell if we are stealing the information that they provide for free on their finance website and selling it to the Russians. David C On Thu, Nov 2, 2017 at

Re: finance-quote error

2017-11-02 Thread David Carlson
I wonder exactly what "Term of Service" we violated? David C On Thu, Nov 2, 2017 at 6:10 PM, MGC wrote: > The error message I'm getting now says: > > It has come to our attention that this service is being used in violation > of > the Yahoo Terms of Service. As such, the

Re: finance-quote error

2017-11-02 Thread MGC
The error message I'm getting now says: It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com. I think we're

Re: Copying fields in a filtered account sheet

2017-11-02 Thread John Ralls
> On Nov 2, 2017, at 11:38 AM, Cliff Williams wrote: > > You Guru's as GnuCash > > Firstly thank you very much for this great piece of software but as always we > want more ... :-) > > Is it possible to allow the user to copy part or complete accounts sheets >

Copying fields in a filtered account sheet

2017-11-02 Thread Cliff Williams
You Guru's as GnuCash Firstly thank you very much for this great piece of software but as always we want more ... :-) Is it possible to allow the user to copy part or complete accounts sheets using the crtl c, ctrl v option? This would come in very useful when segmenting data based on

RE: Outgoing personal loan clarification

2017-11-02 Thread Frankie Raney
So..which way? On Nov 2, 2017 9:59 AM, "Tony Vanson" wrote: > Thanks to everyone. My problem is solved. > Cheers > > Sent from Mail for Windows 10 > > From: Adrien Monteleone > Sent: Thursday, 2 November 2017 10:59 PM > To: gnucash-user@gnucash.org > Subject: Re:

Re: Showing paid ahead customer balances

2017-11-02 Thread Adrien Monteleone
Roger, I use an account called Liabilities:Customer Deposits. When I receive the funds I debit cash/checking and credit the Customer Deposit liability account. When I apply their deposit to an invoice, I ‘pay’ the invoice with that liability account. You probably will want to make

RE: Outgoing personal loan clarification

2017-11-02 Thread Tony Vanson
Thanks to everyone. My problem is solved. Cheers Sent from Mail for Windows 10 From: Adrien Monteleone Sent: Thursday, 2 November 2017 10:59 PM To: gnucash-user@gnucash.org Subject: Re: Outgoing personal loan clarification I think the usual structure there would be: Assets:Current Assets:Other

Re: simple find transactions report

2017-11-02 Thread Elmar
Thanks - I missed the transaction report option. Oops. On 11/2/2017 11:28 AM, Christopher Lam wrote: Hi Elmar From the default Transaction Report, choose: Accounts/Accounts: select the Expenses:Discretionary:Travel, click 'Select children' which will select

Re: finance-quote error

2017-11-02 Thread Keith Myers
I too hope that Yahoo hasn't withdrawn the API.  Who would be available to take their place?  I edited some of my securities to scrape from the First Trust Portfolios but whatever has happened with Yahoo has broken all the other stock price listings too it seems. From: John Ralls

Re: Price Editor broke today for unknown reasons

2017-11-02 Thread Keith Myers
Yes, that is what I meant.  The "Get Quotes" function within the Price Editor which uses the Perl Finance:Quote module.  I even when into the Security Editor and tried a couple of the other stock scrapers for some of the securities.  Whatever has happened to Yahoo has borked everything.

Showing paid ahead customer balances

2017-11-02 Thread rmomxtx
Is there a way to show paid ahead customer balances on the balance sheet? They show by customers overview as negative balances per customer but not on the balance sheet that I can find. I would like to see the total balances on the balance sheet as a liability against a cash reserve for a

Re: simple find transactions report

2017-11-02 Thread Christopher Lam
Hi Elmar >From the default Transaction Report, choose: Accounts/Accounts: select the Expenses:Discretionary:Travel, click 'Select children' which will select Expenses:Discretionary:Travel:Lodging etc Sorting/Primary Key: Date Sorting/Primary Subtotal: none Sorting/Secondary Key: Description or

Re: simple find transactions report

2017-11-02 Thread Elmar
Getting a report by payee/description for a set of dates across a set of accounts, is still opaque to me, though. I have a "travel" account under expenses-discretionary, that is itself split into lodging, travel, fees, etc. I am trying to retrieve all transactions from all these subaccounts

Re: Outgoing personal loan clarification

2017-11-02 Thread Adrien Monteleone
I think the usual structure there would be: Assets:Current Assets:Other Current Assets:Short Term Loans You could then have separate accounts under Short Term Loans for each person you’ve loaned to. And as noted by others, income accounts do not enter the picture. This is not new money. An

Re: Price Editor broke today for unknown reasons

2017-11-02 Thread Derek Atkins
Keith Myers writes: > I can't get Price Editor to work today. Worked fine up till > yesterday.  Now all it does is hang GnuCash with a spinner and > timeout.  I completely removed Perl and reinstalled including the > Finance-Quote module.  When I run gnc-fq-check,

RE: Outgoing personal loan clarification

2017-11-02 Thread Christopher Lam
I’d think: 11th: Regular 2-split Assets:Cash -$300 Expenses:Payroll $300 25th: Multisplit Assets:Cash -$50 Assets:Loan:Employee -$250 Expenses:Payroll $300 The loan repayment is simply a transfer between ‘Money owed’ asset account to your bank account. Some concerns will be whether you wish

Re: Outgoing personal loan clarification

2017-11-02 Thread Frankie Raney
It m not be correct accounting, but I would have set up a checking account using the borrowers name. Transfer the 2000 from your account to the new one, then as they make payments, transfer from their account back to yours. When it reaches 0, you can delete it or just leave it. On Nov 2, 2017

Re: Outgoing personal loan clarification

2017-11-02 Thread Colin Law
On 2 November 2017 at 08:19, Tony Vanson wrote: > Hi all, > First time here, so please excuse my accounting ignorance. > Whilst I understand some of the GnuCash basics, I have a problem which I’m > hoping I can get some help on. > I’m currently residing overseas and we

Price Editor broke today for unknown reasons

2017-11-02 Thread Keith Myers
I can't get Price Editor to work today. Worked fine up till yesterday.  Now all it does is hang GnuCash with a spinner and timeout.  I completely removed Perl and reinstalled including the Finance-Quote module.  When I run gnc-fq-check, gnc-fq-dump, and gnc-fq-update, they all come back with