Re: [GNC] Adaptive learning reset of imports

2021-12-08 Thread Chris Green
On Wed, Dec 08, 2021 at 12:25:58AM -0600, Jeff wrote: > My data files are all saved on an external drive so I can take the drive > anywhere I need to with my laptop instead of staying with my dedicated > server. > I run syncthing on my laptop and desktop machines. It synchronises (among other thi

Re: [GNC] Bitcoin is legal currency in El Salvador - why not

2021-12-08 Thread Michael or Penny Novack
Things change quite quickly in the crypto currency scene. 1) The Royal National Lifeboat Institute (RNLI) was the first major charity in the UK to accept donations by bitcoin https://rnli.org/support-us/give-money/bitcoin-donations 2) Newegg, which is a pretty large company, accepts bitcoin

[GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread Thomas
Dear User-List, I successfully populated the advanced portfolio template with most of the data by selecting of all the accounts of my securities. What I did not manage to get filled is the "money in" column, to also include received dividends in the calculations. I tried to add the accounts with t

Re: [GNC] Bitcoin is legal currency in El Salvador - why not

2021-12-08 Thread Dustin Henning
On 12/7/21 11:51 PM, Dr. David Kirkby wrote: Things change quite quickly in the crypto currency scene. 1) The Royal National Lifeboat Institute (RNLI) was the first major charity in the UK to accept donations by bitcoin https://rnli.org/support-us/give-money/bitcoin-donations 2) Newegg, which

Re: [GNC] Bitcoin is legal currency in El Salvador - why not

2021-12-08 Thread Dustin Henning
I'm noi sure how this is relevant.  Cash and gift cards are often used in these ways, too.  Are you suggesting GnuCcash should remove support for cash acounts? On 12/7/21 10:42 PM, Tim Hume via gnucash-user wrote: It is true that Bitcoin is loved by speculators and scammers. But it does have

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread Tom Teixeira
On 12/8/21 10:09 AM, Thomas wrote: Dear User-List, I successfully populated the advanced portfolio template with most of the data by selecting of all the accounts of my securities. What I did not manage to get filled is the "money in" column, to also include received dividends in the calculation

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread David Carlson
IIRC Tom's suggestion is the key to getting dividends correctly assigned in the Advanced Portfolio Report. I cannot find the documentation either, but there is a lot of information in the Tutorial chapter on investments < https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide> On Wed, Dec 8, 20

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread Thomas
Thanks Tom and David for your quick replies! I actually found that info some time ago as well, but it seems not to do the trick (for me). In the security's account I have the buy transactions (which are taken into account by the advanced portfolio template) and also the dividend payments in a "neu

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread Richard Ullger
I recall the discussions that took place on the mailing list years ago when fixing up the Advanced Portfolio Report. The 'Money In' column reflects only the actual cash You have used to purchase the security. Dividend and interest income is included in the 'Income' column only and not in the '

Re: [GNC] Advanced Portfolio Template: Population of data with dividends

2021-12-08 Thread David Carlson
If dividends are reinvested, they do add to the cost basis. Wouldn't that be considered "Money In" by the Advanced Portfolio Report? Or is it only "New" money? I think that the dividend income and security purchase or zero share security reference split lines need to be in the same transaction

[GNC] Directors loan - do I need an expense account?

2021-12-08 Thread Dr. David Kirkby
A "directors loan" is quite a common thing in the UK for companies. The concept is fairly simple, so anyone in the world should be able to understand my description. Generally the director loans the company money to get it up and running, so the company has a liability to the director. https://ww

[GNC] Trouble with gnc-fq-dump

2021-12-08 Thread Daniel Torstenson
Hi, I'm trying to get online quotes to work with Alphavantage, but I'm having trouble. I'd appreciate any pointers for debugging this, as I don't see anyone else with this problem after searching the web a little bit. I'm running Linux. I have an Alphavantage API key. A call to https://www.alph

[GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread Dr. David Kirkby
A friend of mine bought some Excel spreadsheets for his company accounts. He has used them for many years and finds them good. He has suggested I use them, but I'm not keen on that idea. At any point in time he can see exactly what the depreciation of an item is, and so exactly when the value has f

Re: [GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread Liz
On Thu, 9 Dec 2021 00:34:04 + "Dr. David Kirkby" wrote: > So each time an asset is purchased, one needs to start depreciating > it from then. It's not true to say this is just done once per year. My scheme is to do all the calculations shortly after purchase, until I get to zero. I'm not sur

Re: [GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread David Carlson
That would be nice, but, as you opened the discussion with the note that you use spreadsheets to perform the calculations, you realize that different political jurisdictions have different accounting standards, and to build code in GnuCash to accommodate all the possibilities and keep it up to date

Re: [GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread Gyle McCollam
What I do is set up a placeholder account for the asset. I set up sub accounts for the actual asset purchase and another for the depreciation of the asset. You could then set up a scheduled transaction to record the depreciation each month, quarter, semiannually, or annually depending on how y

Re: [GNC] Directors loan - do I need an expense account?

2021-12-08 Thread Gyle McCollam
I would set the loan up in a loan account (liability), not under accounts payable. When you want to make a payment, you would debit the loan account and credit accounts payable director. When you actually pay the "invoice" you would debit accounts payable and credit the checking account. Tha

Re: [GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread Dr. David Kirkby
On Thu, 9 Dec 2021 at 00:47, David Carlson wrote: > That would be nice, but, as you opened the discussion with the note that > you use spreadsheets to perform the calculations, > No I did not. I said a friend uses a spreadsheet for depreciation, after purchasing some accounting add-on for Excel.

Re: [GNC] An automated depreciation calculator would be really helpful.

2021-12-08 Thread davidcousens49
Dave, Depreciation rules are generally set by your taxation system and your accountant will likely be reflecting those rules that apply in your jurisdiction. If you are going to do the depreciation calculations then you will need to become acquainted with the rules in your jurisdiction. Rules may

Re: [GNC] Trouble with gnc-fq-dump

2021-12-08 Thread Frank H. Ellenberger
Hi Daniel, I get: > gnc-fq-dump -v alphavantage IBM Finance::Quote fields Gnucash uses: symbol: IBM <=== required date: 12/08/2021 <=== recommended currency: USD <=== required last: 123.0200 <=\ nav:

Re: [GNC] Trouble with gnc-fq-dump

2021-12-08 Thread Daniel Torstenson
Ah, your question of which distri led me to the solution. I'm on Arch. I installed Finance::Quote using gnc-fq-update, without fully realizing it was about to install a billion perl modules. I think there was probably some dependency problem. I manually uninstalled those modules (I think! There wer