Il 19/05/22 00:50, davidcousen...@gmail.com ha scritto:
You need a sub account of your asset account and a corresponding account in
Equity which you could call a revaluation reserve or something similar. This
account can be either in Equity itself or could be an Income or Expense account
Il 18/05/22 16:46, David T. ha scritto:
First, the analogy of a painting's unrealized gains to those of any
other asset is perfectly valid. The only difference is that there is
only one "share" of the painting, while there are many shares of a
stock or mutual fund. Their change in value is
Il 18/05/22 23:47, Michael or Penny Novack ha scritto:
Because we lack "qualifications", seek professional guidance on WHAT
to do. We can then help with the "how to do that using gnucash".
Especially in this specific case of "art held as an investment"
because you might actually be doing this
Il 18/05/22 16:03, David Carlson ha scritto:
Perhaps your question is not clear if it wasn't answered by several
replies hinting that accountants treat various types of assets
differently.
Actually, yours was the first reply I got :)
I am not an accountant, so I cannot know how well
Any ideas? Was my question perhaps not sufficiently clear?
Il giorno dom 15 mag 2022 alle ore 17:15 Andrea Borgia
ha scritto:
> Hello.
>
>
> Trying to improve my book-keeping, I would like to tackle this issue now
> so I went to the documentation, precisely "11.4
Hello.
Trying to improve my book-keeping, I would like to tackle this issue now
so I went to the documentation, precisely "11.4.1. Unrealized Gains".
Problem is, the example applies to a painting, that is an object whose
value changes, not shares whose number remains constant but whose
Answering myself to add some information:
* when reopening the books for 2021, I see that all EUR funds had a
split belonging to Trading:Currency:EUR, whereas this year I did not use it
* this gave me the idea to try entering the transaction from the
"capital" account, instead of the mutual
Hello.
I prefer to keep my books divided by year, so in spring I typically
close the old book and start a new one with mostly the same accounts,
been doing that for a while and I keep notes reminding myself of all the
steps to take.
I have a number of mutual funds, including one which is
Il 17/04/21 19:47, John Ralls ha scritto:
But if you sold only 50 shares Trading:XYZ would have a balance of -50 and
Trading:EUR has a balance of €400. To find the capital gain you have to compute
the basis of the remaining 50 shares and subtract it from the Trading:EUR
balance.
Yes,
Il 11/04/21 18:41, John Ralls ha scritto:
You may be confusing "recognized gains" and "realized gains". A realized gain (or loss)
is the change in value between a buy and a sell transaction. In contrast an unrealized gain is the change in
the value of an asset that you still own. If you
Il 10/04/21 20:33, John Ralls ha scritto:
1) No, but that's separate from trading accounts. That's the point of the bug
report.
2) No, the trading accounts just make it obvious that you haven't booked the
gain/loss.
3) That's back to the discussion in the bug. When you trade securities in
Il 09/04/21 18:59, John Ralls ha scritto:
On Apr 9, 2021, at 9:37 AM, Andrea Borgia wrote:
Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam <
christopher@gmail.com> ha scritto:
There is some discussion in an unusually detailed bug report
https://bugs.gnucash.org/show_bug.
Il giorno dom 28 mar 2021 alle ore 03:04 Christopher Lam <
christopher@gmail.com> ha scritto:
>
> There is some discussion in an unusually detailed bug report
> https://bugs.gnucash.org/show_bug.cgi?id=797796 -- this originates in
> GnuCash's transaction currency being permitted to be any
Il 27/03/21 23:23, David Cousens ha scritto:
As the (Income - Expense) is already recorded against Assets when you create
the transactions, you are including them twice in the total you are
calculating.
Please keep in mind that I am neither an accountant nor a native English
speaker,
Il 27/03/21 22:54, David Cousens ha scritto:
On the mutual fund purchase. It is most likely that the fund will > have paid US taxes on its earnings so you are unlikely to be liable
> for any tax in the US so there is likely little value in maintaining
> US expense or income accounts. I base
Il 27/03/21 19:04, Michael or Penny Novack ha scritto:
Now we come to the end of the year, at which point let's say the
exchange rate is $1.25/1 EUR. Those $1300 are no longer worth 1000
Eur. They are worth 1040 EUR. Your equity has gone up by 40 EUR.
I will stop here because the issue of
Il 27/03/21 18:20, John Ralls ha scritto:
Andrea,
The most likely reason is that you failed to book a capital gain/loss from a
stock sale or a currency exchange.
Regards,
John Ralls
Hi, John.
That could be interesting for 2021 since I bought quite a few USD to
invest in a mutual fund but
Hi.
As previously mentioned, each year I close the current gnucash book and
open a new one.
For 2020: "Initial capital of 2020" = "Asset of 2019" - "Expenses of
2019" + "Income of 2019" (there are no liabilities)
For 2021 things are not right, apparently:
* "assets of 2020" -
Hello, David.
Finally had time to go over your explanation with the books open, I'm
adding my observations inline.
If I read it correctly you will have paid originally in totally €320.44 for
the laptop (€313.21 cost of the laptop + US$7.23 shipping/commission fees,
which would have been a
Il 24/03/21 22:46, David Cousens ha scritto:
Hi Andrea,
OK it is only Euro and USD which makes it simpler. my apologies for the
delay in replying. I was away from home yesterday,
No worries, this is my personal accounting: it can wait when we all have
time. Now it's late here, I'll go
Il 22/03/21 21:25, David Cousens ha scritto:
In that case just credit paypal:usd for US$5.56 and debit the paypal:eur
account for the relevant amount in euros at the date Paypal made the
transfer (Paypal will usually have the exchange rate somewhere in the
massive CSV file if you download
Hi.
Each year I open a new book and carry over asset / liabilities, also
factoring in the year end results.
So, all Income / Expenses accounts get closed by posting an entry with
the total amount to a "Results" account or rather to "Results:EUR",
"Results:USD" and so on.
These new
Il 18/03/21 14:41, D. via gnucash-user ha scritto:
Well, considering that the NAV in the example is "USD 2150.31" and the 5366.43
in the example actually represents the fund size, I'd imagine you should get the former
as the NAV.
Yes, and at the moment it is working again.
In the attached
esults.
>
> See attached screenshot - I think the problem lies with the long regular
> expression on line 160. It contains a couple of "greedy" matches that
> are probably causing a match on the last decimal number (Share Class
> Size) instead of the first (NAV).
>
> G
Il 17/03/21 20:32, Derek Atkins ha scritto:
The screenshot didn't make it through the email, most likely because you
sent it as an embedded image in HTML instead of as a text with attachment.
Yes and I never had any issues before. Weird.
My apologies.
gnc-fq-dump morningstarch
Il 17/03/21 20:12, Derek Atkins ha scritto:
What quote source are you using? This doesn't work for me with Yahoo-JSON:
It was in the first screenshot, here is the text version:
gnc-fq-dump morningstarch LU0067412154
gnc-fq-dump mstaruk LU0067412154
Hi.
Something odd is going on but I can't decide if it is F::Q at fault or GC:
Thing is, the UK website lists a totally reasonable price, so it's
either gnc-fq-dump or F::Q who is playing fast and loose with numbers :)
The price editor is affected as well, actually that's how I found out.
Il 05/02/21 02:16, Geoff ha scritto:
If you are familiar with the perl programming language, you could try
and fix the FTfunds.pm module yourself. It should be using this web
page:
https://markets.ft.com/data/funds/tearsheet/summary?s=IE00BMWWJZ56:EUR
Otherwise, you might be able to find
Il 05/02/21 08:56, Geert Janssens ha scritto:
Op vrijdag 5 februari 2021 02:16:53 CET schreef Geoff:
I don't really understand what the GnuCash Namespace is intended for,
but it doesn't seem to make any difference in this case. It is a useful
way of organizing your securities in the Security
Il 05/02/21 02:16, Geoff ha scritto:
If you are familiar with the perl programming language, you could try
and fix the FTfunds.pm module yourself. It should be using this web
page:
https://markets.ft.com/data/funds/tearsheet/summary?s=IE00BMWWJZ56:EUR
Otherwise, you might be able to find
Il 04/02/21 01:13, Geoff ha scritto:
Re (1).
Next, in GnuCash, I set up the security to retrieve prices as
"Unknown" / "morningstarch" and was able to retrieve a price
successfully. See attached screenshot. I am running GnuCash 4.4 on
Windows 10.
Hi, Geoff.
First of all, thanks for
Hi.
Couple of weird issues getting F::Q to work on Debian "testing" with
libfinance-quote-perl 1.49-1
gnucash 1:4.4-1
1) I have one fund whose quote is provided by Morningstar, LU0341736642:
gnc-fq-dump works for "morningstarch"
Il 01/03/20 16:39, km22 ha scritto:
I recently moved from Windows 7 (due to end of life) to Debian 10. I
have gnucash 3.4 installed from the standard repo. However I think this
version contains a bug as I cannot see any of the historical FX prices I
stored in the Price Database. I think I
Il 17/03/19 08:54, David Cousens ha scritto:
There are no examples yet unfortunately. I am doing a lot of testing of the
new CSV importer with a view to updating the importer documentationbut it
is still very much in progress. At the same time I am identifying any bugs
that come up for fixing
Il 10/03/19 10:16, Adrien Monteleone ha scritto:
The fact that this is also the same amount as this particular
transaction you entered for 13/01/17 is purely coincidental. (and
should be, since it is entered in 2017 and you are running a balance
sheet as of 31/12/16, unless you *aren’t*
reply to self to add: also leading marks are affected.
basically, all marks that appear at the very beginning or end of a
description.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
Hi.
Splitting multi-year book by exporting transactions to CSV and importing
them in a new file, I noticed that trailing quotation marks (") in split
descriptions have been replaced by a backslash.
Am I doing something wrong during the export? I see there is a "quote"
checkbox but there is
Il 10/03/19 10:55, Liz ha scritto:
If you have a negative balance do you pay a "negative" tax?
Liz
I have never tried but I assume you simply would pay nothing.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription
Il 10/03/19 01:19, Adrien Monteleone ha scritto:
Retained Earnings is posted when you perform a close book operation.
(or manually zero your income/expense accounts to Equity)
If you didn’t do this for 2015, there would be no entry.
If you performed the 2016 close book operation in Jan 2017,
Hi.
While splitting a multi-year book, I saw that the (end of) 2016 balance
sheet has an entry called "retained earnings" with a value of 54.10.
A find-by-value gives me an entry in jan.2017 from an account which has
a tax-related flag set (and can't be changed, too): am I correct in
Hello, David.
Thanks for the explanation. Rest of the comments are inline.
To export the account tree use File->Export->Export Accounts to export the
account structure into a new book file directly. It works fine with GnuCash
V3.4. What version of GnuCash are you using and on what operating
Il 03/03/19 20:29, Christian Kluge ha scritto:
I’d suggest making balance sheets for each year to exported.
Afterwards I would use File\Export\Transactions to CSV.
There I would select the appropriate time range.
I also would export the account structure to CSV.
In the one-year-only file I
Hi.
For the past decade, I've had only a few gnucash files, not one per year:
basically, I'd create a new one when the file would be large enough at the
end of the year to notice that startup time.
If I wanted to retroactively split them by single year as I started doing
now, how could I do
Hello, Michael.
Ah, my line of country, insurance.
Good thing this is your field of expertise, mine is programming :)
a) Do they not give you an annual statement? One that indicates
increase in "cash value".
I have the receipts for the payments made and I can check the current
value on
Hello.
I have an insurance policy which works like this:
- after the initial payment, I could make additional payments, up to a
month ago, and I did.
- the company has to have 100% backing for the money received by
customers for this product, meaning all of them could theoretically ask
45 matches
Mail list logo