RE: Outgoing personal loan clarification

[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: Adrien Monteleone; David T. via gnucash-user
Subject: RE: Outgoing personal loan clarification

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: Outgoing personal loan clarification

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 asset is being returned to you. It’s just an asset transfer from 
the loan back to cash. (or checking account, etc.)

Regards,
Adrien

> On Nov 2, 2017, at 3:19 AM, 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 employ a staff member.
> This person has asked for a personal loan, which I have given, paid by cash 
> from my bank account
> I shall use generic amounts for the details.
>
> This person is paid a total 600.00 per month, split 300.00 paid on the 11th 
> and 25th of each month.
> The loan is for 2000.00 with 250.00 repayable on the 25th of each month for 8 
> months. I do not charge interest.
> So on the 11th of the month she receives 300.00 and on the 25th 50.00 cash 
> with 250.00 being for the loan repayment.
> My question is: how do I enter this in GnuCash?
> I already have a bank account and have set up a ‘money owed’ account as an 
> asset which shows the 2000.00 owing.
> I have also set up a ‘loan repayment’ account as income.
> Hopefully someone can advise me the particular steps I need to follow for 
> what entries go where, particularly in regards to the 25th of the month items.
> Cheers
>
>
> Sent from Mail for Windows 10
>
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 Gnucash
developers incorporate that API as a substitute for the discontinued Yahoo
Finance API?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 Thu, Nov 2, 2017 at 8:02 PM, MGC  wrote:

> 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
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Broken Search Link

[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 
> wrote:
>
> Hi,
>
> The " search the gnucash-user Archives." link in the gnucash-user page
> is broken.
>
> The URL https://lists.gnucash.org/search/?idxinfo=gnucash-user leads to
> a 404.
>
>

To see the "broken" search link, go to

https://lists.gnucash.org/mailman/listinfo

The broken link exists on the announce, gnucash-devel, and gnucash-user
list description pages.

It doesn't seem to exist on any of the others.



> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 7:03 PM, David Carlson 
wrote:

> 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 service is being discontinued.
>> For all future markets and equities data research, please refer to
>> finance.yahoo.com.
>>
>> I think we're hosed.
>>
>>
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.
>> html
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 service is being discontinued.
> For all future markets and equities data research, please refer to
> finance.yahoo.com.
>
> I think we're hosed.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 hosed.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Copying fields in a filtered account sheet

[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 
> using the crtl c,  ctrl v option?   This would  come in very useful when 
> segmenting data based on a filter.   My old app called AceMoney did it and it 
> was so so useful.
> 
> Looking forward to your earliest reply.
> 

GnuCash doesn't have anything called an "account sheet". Please explain in 
detail what you're trying to do.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Copying fields in a filtered account sheet

[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 a filter.   My old app called AceMoney did it and it was so so 
useful.

Looking forward to your earliest reply.

--
Cliff
Mobile: 07769214945
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Outgoing personal loan clarification

[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: Outgoing personal loan clarification
>
> 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 asset is being returned to you. It’s just an asset
> transfer from the loan back to cash. (or checking account, etc.)
>
> Regards,
> Adrien
>
> > On Nov 2, 2017, at 3:19 AM, 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 employ a staff member.
> > This person has asked for a personal loan, which I have given, paid by
> cash from my bank account
> > I shall use generic amounts for the details.
> >
> > This person is paid a total 600.00 per month, split 300.00 paid on the
> 11th and 25th of each month.
> > The loan is for 2000.00 with 250.00 repayable on the 25th of each month
> for 8 months. I do not charge interest.
> > So on the 11th of the month she receives 300.00 and on the 25th 50.00
> cash with 250.00 being for the loan repayment.
> > My question is: how do I enter this in GnuCash?
> > I already have a bank account and have set up a ‘money owed’ account as
> an asset which shows the 2000.00 owing.
> > I have also set up a ‘loan repayment’ account as income.
> > Hopefully someone can advise me the particular steps I need to follow
> for what entries go where, particularly in regards to the 25th of the month
> items.
> > Cheers
> >
> >
> > Sent from Mail for Windows 10
> >
> >
> >
> > ---
> > This email has been checked for viruses by Avast antivirus software.
> > https://www.avast.com/antivirus
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Showing paid ahead customer balances

[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 sub-accounts for each customer under that 
Customer Deposits account.

Unfortunately, this does not combine with a customer report as those funds 
never enter the A/R account. I’m not sure if there is a way around that as 
technically, these ARE liabilities, not assets. I suppose it would be nice if 
the business features included a special Customer Deposit account and the 
customer report considered it when executing. You might want to file an 
enhancement request.

Regards,
Adrien

> On Nov 2, 2017, at 10:54 AM, rmom...@gmail.com wrote:
> 
> 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 specific item that some families pay ahead for
> the entire year. Otherwise it is a quarterly charge. The product is student
> materials, the programmed texts they use to study. The idea is to have
> visibility of these paid ahead balances to keep them in a physically
> separate fund.
> 
> 
> 
> Thanks,
> 
> Roger
> 
> 
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Outgoing personal loan clarification

[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 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 asset is being returned to you. It’s just an asset transfer from 
the loan back to cash. (or checking account, etc.)

Regards,
Adrien

> On Nov 2, 2017, at 3:19 AM, 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 employ a staff member.
> This person has asked for a personal loan, which I have given, paid by cash 
> from my bank account
> I shall use generic amounts for the details.
> 
> This person is paid a total 600.00 per month, split 300.00 paid on the 11th 
> and 25th of each month.
> The loan is for 2000.00 with 250.00 repayable on the 25th of each month for 8 
> months. I do not charge interest.
> So on the 11th of the month she receives 300.00 and on the 25th 50.00 cash 
> with 250.00 being for the loan repayment.
> My question is: how do I enter this in GnuCash?
> I already have a bank account and have set up a ‘money owed’ account as an 
> asset which shows the 2000.00 owing.
> I have also set up a ‘loan repayment’ account as income.
> Hopefully someone can advise me the particular steps I need to follow for 
> what entries go where, particularly in regards to the 25th of the month items.
> Cheers
> 
> 
> Sent from Mail for Windows 10
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[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 
Expenses:Discretionary:Travel:Lodging etc


Sorting/Primary Key: Date
Sorting/Primary Subtotal: none
Sorting/Secondary Key: Description

or

Sorting/Primary Key: Description
Sorting/Secondary Key: Date
Sorting/Secondary Subtotal: none

Good luck!

Next release 2.7 onwards will have arbitrary string searching.

On 2 November 2017 at 22:59, Elmar > wrote:


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 sorted by payee and date to
dump into a spreadsheet.  Doing a "find" on the placeholder account
"travel" gives me nothing at all. Do I have to go and learn SQL to
get what I need?

- Elmar

On 10/10/2017 11:17 AM, Geert Janssens wrote:

Heh, sorry. I'm not near a computer to verify my directions and
won't be until next week...

Glad you managed to decode my terse answer.

Geert

Elmar > schreef op
9 oktober 2017 21:37:57 GMT+01:00:
  >Perfect!  Thanks, although I had to translate this to the
menu entry
  >"edit/find" (not "search")


___
gnucash-user mailing list
gnucash-user@gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.




___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: finance-quote error

[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 
 To: Keith Myers  
Cc: gnucash-user@gnucash.org
 Sent: Thursday, November 2, 2017 8:32 AM
 Subject: Re: finance-quote error
   


> On Nov 1, 2017, at 9:49 PM, Keith Myers  wrote:
> 
> I've been beating my head against the desk for the past 5 hours trying to
> figure out why Price Editor isn't working today when it worked fine
> yesterday. Uninstalled. Reinstalled.  Multiple times.  Finally found this
> list and my answers.  Yahoo effed up today. Hope they get it straightened
> out soonest.

We all hope that they messed something up rather than that they’ve withdrawn 
the API.

Regards,
John Ralls


   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Editor broke today for unknown reasons

[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.

  From: Derek Atkins 
 To: Keith Myers  
Cc: gnucash-user@gnucash.org
 Sent: Thursday, November 2, 2017 7:32 AM
 Subject: Re: Price Editor broke today for unknown reasons
   
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, gnc-fq-dump, and
> gnc-fq-update, they all come back with the expected correct
> responses. Perl sees the module fine.  Why is GnuCash broken today. 
> All the rest of GnuCash is working correctly, just the Price Editor
> can't get any updates.  I have repaired GnuCash, rebooted the computer
> umpteen times and nothing has got the Price Editor to not hang
> GnuCash.

I presume you mean "Price Grabber" and not "Price Editor".  The *Price
Editor" itself does not use Perl or anything else -- it's a dialog that
lets you manually enter prices.  If you then click on "Get Quotes", that
launches the "Price Grabber", which does use Perl.

Apparently Yahoo is b0rked right now.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
      Member, MIT Student Information Processing Board  (SIPB)
      URL: http://web.mit.edu/warlord/   PP-ASEL-IA    N1NWH
      warl...@mit.edu                        PGP key available

   
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Showing paid ahead customer balances

[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 specific item that some families pay ahead for
the entire year. Otherwise it is a quarterly charge. The product is student
materials, the programmed texts they use to study. The idea is to have
visibility of these paid ahead balances to keep them in a physically
separate fund.

 

Thanks,

Roger

 

 

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[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

Sorting/Primary Key: Description
Sorting/Secondary Key: Date
Sorting/Secondary Subtotal: none

Good luck!

Next release 2.7 onwards will have arbitrary string searching.

On 2 November 2017 at 22:59, Elmar  wrote:

> 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
> sorted by payee and date to dump into a spreadsheet.  Doing a "find" on the
> placeholder account "travel" gives me nothing at all. Do I have to go and
> learn SQL to get what I need?
>
> - Elmar
>
> On 10/10/2017 11:17 AM, Geert Janssens wrote:
>
>> Heh, sorry. I'm not near a computer to verify my directions and won't be
>> until next week...
>>
>> Glad you managed to decode my terse answer.
>>
>> Geert
>>
>> Elmar  schreef op 9 oktober 2017 21:37:57 GMT+01:00:
>>  >Perfect!  Thanks, although I had to translate this to the menu entry
>>  >"edit/find" (not "search")
>>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: simple find transactions report

[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 sorted by payee and date to dump into a spreadsheet.  Doing 
a "find" on the placeholder account "travel" gives me nothing at all. 
Do I have to go and learn SQL to get what I need?


- Elmar

On 10/10/2017 11:17 AM, Geert Janssens wrote:
Heh, sorry. I'm not near a computer to verify my directions and won't be 
until next week...


Glad you managed to decode my terse answer.

Geert

Elmar  schreef op 9 oktober 2017 21:37:57 GMT+01:00:
 >Perfect!  Thanks, although I had to translate this to the menu entry
 >"edit/find" (not "search")


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Outgoing personal loan clarification

[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 asset is being returned to you. It’s just an asset transfer from 
the loan back to cash. (or checking account, etc.)

Regards,
Adrien

> On Nov 2, 2017, at 3:19 AM, 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 employ a staff member.
> This person has asked for a personal loan, which I have given, paid by cash 
> from my bank account
> I shall use generic amounts for the details.
> 
> This person is paid a total 600.00 per month, split 300.00 paid on the 11th 
> and 25th of each month.
> The loan is for 2000.00 with 250.00 repayable on the 25th of each month for 8 
> months. I do not charge interest.
> So on the 11th of the month she receives 300.00 and on the 25th 50.00 cash 
> with 250.00 being for the loan repayment.
> My question is: how do I enter this in GnuCash?
> I already have a bank account and have set up a ‘money owed’ account as an 
> asset which shows the 2000.00 owing.
> I have also set up a ‘loan repayment’ account as income.
> Hopefully someone can advise me the particular steps I need to follow for 
> what entries go where, particularly in regards to the 25th of the month items.
> Cheers
> 
> 
> Sent from Mail for Windows 10
> 
> 
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Price Editor broke today for unknown reasons

[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, gnc-fq-dump, and
> gnc-fq-update, they all come back with the expected correct
> responses. Perl sees the module fine.  Why is GnuCash broken today. 
> All the rest of GnuCash is working correctly, just the Price Editor
> can't get any updates.  I have repaired GnuCash, rebooted the computer
> umpteen times and nothing has got the Price Editor to not hang
> GnuCash.

I presume you mean "Price Grabber" and not "Price Editor".  The *Price
Editor" itself does not use Perl or anything else -- it's a dialog that
lets you manually enter prices.  If you then click on "Get Quotes", that
launches the "Price Grabber", which does use Perl.

Apparently Yahoo is b0rked right now.

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
   Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
   Member, MIT Student Information Processing Board  (SIPB)
   URL: http://web.mit.edu/warlord/PP-ASEL-IA N1NWH
   warl...@mit.eduPGP key available
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

RE: Outgoing personal loan clarification

[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 to maintain the constant bimonthly 
payroll amounts of $300 so that the original employee pay of $600/month is 
still reflected in your books, and whether the $2000 is considered a business 
loan or a personal loan. 

These questions cannot be answered in any accounting package; your software 
(ideally gnucash but also any inferior package) will simply always reflect your 
understanding of your financial situation.

Good luck!

From: Tony Vanson
Sent: Thursday, 2 November 2017 4:24 PM
To: gnucash-user@gnucash.org
Subject: Outgoing personal loan clarification

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 employ a staff member.
This person has asked for a personal loan, which I have given, paid by cash 
from my bank account
I shall use generic amounts for the details.

This person is paid a total 600.00 per month, split 300.00 paid on the 11th and 
25th of each month.
The loan is for 2000.00 with 250.00 repayable on the 25th of each month for 8 
months. I do not charge interest.
So on the 11th of the month she receives 300.00 and on the 25th 50.00 cash with 
250.00 being for the loan repayment.
My question is: how do I enter this in GnuCash?
I already have a bank account and have set up a ‘money owed’ account as an 
asset which shows the 2000.00 owing.
I have also set up a ‘loan repayment’ account as income.
Hopefully someone can advise me the particular steps I need to follow for what 
entries go where, particularly in regards to the 25th of the month items.
Cheers


Sent from Mail for Windows 10



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Outgoing personal loan clarification

[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 1:36 AM, "Colin Law"  wrote:

> 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 employ a staff member.
> > This person has asked for a personal loan, which I have given, paid by
> cash from my bank account
> > I shall use generic amounts for the details.
> >
> > This person is paid a total 600.00 per month, split 300.00 paid on the
> 11th and 25th of each month.
> > The loan is for 2000.00 with 250.00 repayable on the 25th of each month
> for 8 months. I do not charge interest.
> > So on the 11th of the month she receives 300.00 and on the 25th 50.00
> cash with 250.00 being for the loan repayment.
> > My question is: how do I enter this in GnuCash?
> > I already have a bank account and have set up a ‘money owed’ account as
> an asset which shows the 2000.00 owing.
> > I have also set up a ‘loan repayment’ account as income.
>
> The loan repayment should not be an account. When you receive money it
> should be recorded as a transfer from the money owed asset account to
> your cash account (or checking acct or wherever it ends up). This then
> reduces the amount in the loan account and increases the amount of
> cash you have, as it should.
>
> Colin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Outgoing personal loan clarification

[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 employ a staff member.
> This person has asked for a personal loan, which I have given, paid by cash 
> from my bank account
> I shall use generic amounts for the details.
>
> This person is paid a total 600.00 per month, split 300.00 paid on the 11th 
> and 25th of each month.
> The loan is for 2000.00 with 250.00 repayable on the 25th of each month for 8 
> months. I do not charge interest.
> So on the 11th of the month she receives 300.00 and on the 25th 50.00 cash 
> with 250.00 being for the loan repayment.
> My question is: how do I enter this in GnuCash?
> I already have a bank account and have set up a ‘money owed’ account as an 
> asset which shows the 2000.00 owing.
> I have also set up a ‘loan repayment’ account as income.

The loan repayment should not be an account. When you receive money it
should be recorded as a transfer from the money owed asset account to
your cash account (or checking acct or wherever it ends up). This then
reduces the amount in the loan account and increases the amount of
cash you have, as it should.

Colin
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Price Editor broke today for unknown reasons

[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 the expected correct responses. Perl sees the module 
fine.  Why is GnuCash broken today.  All the rest of GnuCash is working 
correctly, just the Price Editor can't get any updates.  I have repaired 
GnuCash, rebooted the computer umpteen times and nothing has got the 
Price Editor to not hang GnuCash.


___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.