Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[Long]

Picture :  balance-sheet-unrealized.png

  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[Long]

Hello David Cousens,

Sorry if i misunderstanding, When i created USD Bank, everytime the USD rate
changed, i will edit the price database, which mean i don't need to transfer
money from/to other accounts FROM my USD Bank account to know the value at
the time i want to know.
Which mean, each time the rate is changed, it's changed from 'Price
Database", and My USD Bank Account is auto changing with that rate.
=> Only Work i need to do when i sold it in realy life is record a transfer
value from USD bank to VND Bank in GnuCash.

And after all, Balance Sheet Report still show the "Unrealized" instead of
"Realized" when i transfer all my USD Money into VND Bank. This is what i am
confusing.

So my question are :
1- Is it possible to "Unrealized" to "Realized" in the Balance Sheet Report
?
2- Should I Need to do when it possible to "Realized" ? Or just leave that ?
Just use normal.

Thank you so much.
Regards.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[Long]

Hello Stephen M. Butler,

You said that i'm doing the right way with my example ( i'm thinking like
that too ), when i transferred all my USD to VND Bank. Which mean, in
GnuCash, i don't have any USD, and all of it are now VND (in real life is
the same). But in the Balance Sheet report still show my value are
"Unrealized Gain" not "Realized Gain" . Maybe it's the default behavior of
GnuCash ? I'm confusing about that !

Thank you for helping me.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[Stephen M. Butler]

Bottom line -- Enter them as you are paid.  The CSV import should "see"
the deposits and match them during the import.  If it doesn't, it is a
simple matter to remove that entry and keep the more detailed manually
entered transaction.


On 4/8/20 12:23 PM, jess wrote:
> Thanks for the patience and help, I appreciate it. If I may ask another
> account setup questions, how do you propose to handle income tax and other
> contributions from your salary slips? 
>
> I am a salaried individual with regular monthly income. The salary slips
> reflect the gross income which contains deductions to health insurance,
> social security contributions etc. The net income is finally credited to my
> bank account. In the end of the year, I have a yearly consolidated form
> which mentions my various contributions (social security, pension, health
> insurance, tax etc.) from my salary slips for that FY (Financial Year). For
> example, this tabular form would mention
>
> Income Tax Paid - 100€
> Health Insurance - 40€
> Pension - 30€
> Social Security - 20€
>
> Some other details - 
>
>  (i) My goal is to track yearly contributions, I do not quite need monthly
> details. 
>
>  (ii) I plan to import monthly bank transactions from my bank accounts in a
> CSV format 
>
>  (iii) Tax and other contributions may wary throughout the year due to bonus
> received


Once you have entered one of them, the next time the application should
bring that up as a template for entry.  If nothing changed then just hit
enter and you are done.  If changes, then make those changes by tabbing
to the fields that are different and enter the updated amounts.  Hit
enter when all updates are done.

>
>  (iv) I have a separate account for "Income : Tax Refund" to see income
OK.  Some just offset the Expense account.  Follow the desires of your CPA.
> earned back from taxes
>
>  (v) I want to track fine grained contributions viz. I have a separate
> account for every contribution "Income Tax", "Social Security", "Pension"
> etc.
>
>  (vi) Contributions could be split between me and employer. For example, 10%
> of income for total health insurance where I contribute 5% and employer
> contributes 5%. But, the entire 10% is counted towards the gross income
> statement. Income tax rates are based on gross incomes


If that is shown on the pay slips, then enter it as part of the transaction.

>
>
> I currently have two options which come to my mind.
>
> Option 1 - Monthly Salary Slip entries
>
> In this option, I will merely inflate the gross "Income" to "Net Income" (as
> reflected on my bank account) + Contributions. The gross salary will flow
> into the "Income" account and contributions will flow into the "Expense"
> accounts - one for each 
>
> Pros - I have monthly entries, up to date information at any given point of
> time
I prefer this route.
>
> Cons - Difficult to enter every month due to (iii), bank transaction CSV
> import only reflects net income and additional account entries required
The import should see the manually entered "deposits" and match to
those.  If it doesn't then you could deselect that row during import and
it won't come in.  Which is good because you already have entered that
deposit.
>
> Option 2 - Yearly Entries Based on Wage Tax Form as mentioned above
>
> Here, I will just enter the contributions yearly into a separate individual
> "Expense" accounts once a year. I am unsure on how to handle the "Income"
> accounts year. My immediate idea is to create "Income" accounts for every
> contribution. For example
>
> "Income : Social Security" , "Expense : Social Security"
>
> "Income : Health Insurance", "Expense : Health Insurance" and so on
>
> Pros - Easier to work with, transaction import CSV process does not
> interfere
>
> Cons - Difficult to handle contributions as some contributions are employers
> but part of the gross income (Refer (vi)
>
>
> Given these options, what do you recommend? I am particularly concerned and
> out of wits for point (vi). It seems complicated to handle. 
Once you have that figured out, the automatic "template" should bring
those lines up and you just update the values, if different.  That
"template" is based on the most recent previous transaction of the same
description.  So, if you have two variants (if paid twice a month or
bi-weekly and the amounts vary based on 1st pay of month versus 2nd,
etc) use slightly different descriptions.
>  
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Stephen M Butler, 

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[Stephen M. Butler]

On 4/8/20 12:13 PM, Long wrote:
> Hello,
>
> I have posted a topic about this, but that topic have been spammed. So i
> created new one to resolve my question.
>
> First, i'm not an accounting, and trying to stay away accounting language,
> trying to make anything to easier to understand for me, and who have the
> same question like me. 
I urge you to learn at least the fundamentals about book keeping and
accounting. 
> OK, my question is :
> ---
> I have 2 Bank accounts, one for my default currency, and other is USD in
> GnuCash. In my real life, i usually buy USD by my VND, Then, I will sell USD
> to get VND back. (included gold ... but i just want to talk about USD, it's
> the same thing to do in GnuCash).
> So, i setup the price database (GnuCash 3.9) for USD, i assume the rate is 1
> USD = 2 VND for first time i bought. So my accounts :
> ---
> Assets: 40 VND
> -- VND Bank : 20 VND
> -- USD Bank  : 10 USD -- 20 VND
> Equity : 40 VND
> ---
> Next month, The rate changed : 1USD = 3VND
> Assets : 50 VND
> -- VND Bank : 20 VND
> -- USD Bank : 10 USD -- 30 VND
> Equity : 40 VND
> ---
> Ok, the problem here, My Balance Sheet report now show in the equity tab
> that had "Unrealized Gain" about 10 VND.
> I knew that it's mean the rate of the USD are increasing so my assets are
> increasing too. 
> But, It's also "Unrealized Gain" and not the "Realized Gain" in the report
> when i transferred that USD to VND Bank. (Which mean, when USD rate high, i
> sell it by transfer that money from USD Bank to VND Bank in GnuCash, of
> course in my real life i do the same thing).
> My accounts at that time:
> Assets: 50 VND
> -- VND Bank : 50 VND
> -- USD Bank : 0
> Equity : 40VND
> ---
> 1
>  - So,i really don't need to care about that "Words" in the Balance Sheet
> Report ?
> 2
>  - If i need to care about it, What should i do to change it from
> "Unrealized" to "Realized" (Please give me example for this).

You yourself gave the best example -- when you sell it becomes "realized".

Unless your local taxing authority requires otherwise (and check with
your local accounting professional -- CPA), you can just ignore that it
happens.

> ---
> P/s : I had read documents from GnuCash, and it's look like very hard to
> understand for me. And i don't turned on the "Trading account", look like it
> is the old way for solving this in the older version of GnuCash. i only
> created account with USD currency and setup the price database.
>
> Thank you so much. Please help me.
> Regards.

It may help to setup an empty data file and follow the examples in the
Concepts Guide.  It can be tough to follow in a foreign language.

--Steve


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[David Cousens]

Patrick,

John missed this one. It is usually a good idea to uninstall a previous
version before installation of an upgrade. This does not affect your gnucash
data files or user preference files which are not removed in the uninstall
of the program. In some case after an upgrade user preference may be
relocated (v2.6.xx->3.x  for example) and sometimes customized reports etc
may need to be copied or the file renamed  (see
https://wiki.gnucash.org/wiki/Configuration_Locations for detail). Sometimes
there are occasional changes to the data file format which also means you
cannot revert to a previous version. It is usually possible within the minor
series changes i.e. 2.4->3.5 but sometimes not possible to revert across
major series changes 2.6.19 ->3.8.

David Cousens



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Starting Balance in Reconciliation Window wrong

[David Cousens]

 Problem resolved. Caused by entering 31/12/20 instead of 31/12/2018 when
entering the end date fro a previous reconcilation. Edited datafile and
corrected all reconciliation dates set as 2020-12-31 to 2018-12-31 and the
file now reconciles correctly to 31/12/2019 with the correct starting
balance calculation,

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Ralph]

On Wed, 8 Apr 2020 18:18:32 +0100
Eric Coates via gnucash-user  wrote:

> My gold is in the form of Sovereigns (each of about 7.5gms) and I
> guess that the only reliable way to get a value of it is by offering
> it for sale.

Actually, sovereigns nowadays are so close to being a 'currency' in
themselves, frequently no 'conversions to a currency' are needed.  But
for a current up-to-the-minute valuation in multiple other currencies
you can use the aforementioned kitco's buy price for sovereigns at the
following link (it says 'sell' on the page because YOU are doing the
selling :)

https://online.kitco.com/sell/807/2354-oz-Gold-British-Sovereign-Coin-9167-807

note: the link may wrap due to length so cut n paste into your browser
instead of clicking on the link, if that occurs.

note2: I have no interest in Kitco, except as a customer who sells
sovereigns to them on a frequent basis (received in payment for my
products), so this is not spam and is presented as useful info.

Ralph


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[Christopher Lam]

Your HST seems very similar to UK VAT or GST in use in many other
countries. You may use Tax Tables to set them up. And search the
documentation & wiki on how to report the HST on Sales and Purchases and
their quarterly differences.

On Wed, 8 Apr 2020 at 18:57, Patrick Farrell  wrote:

> Is there a "Canadian Version" of GnuCash as all the documentation in the
> current version of GnuCash 3.4+ (Build 2018-12-30) that I have read
> relates to the USA Tax System?
>
> I immediately need to know how to set up automatically calculating how
> to add Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I
> make up and send out to Clients/Customers, and then how to separately
> account for HST that I pay on any invoices that I receive from our
> vendors and subsequently pay. I then need to offset the HST received
> from Client/Customers versus the HST I have paid out to Vendors and do
> an official Government HST filing at least Quarterly, and pay them the
> difference if any!
>
> Is there an "Update" software function in the program somewhere, as I
> have not been able to see any obvious place to do this? I see there is
> GnuCash 3.9 version offered on the website, but will I lose all existing
> data in my existing GnuCash 3.4+ if I download 3.9 on top of it or have
> to delete 3.4+ before I install version 3.9?
>
> Any suggestions would be helpful.
>
> P@ddy
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[David Cousens]

Long 
Also take a look at Fred Bone's reply in the previous thread. He has some
comments re foreign currency investments which may apply to your case.
David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[David Cousens]

Long,

Unrealized gains or losses are created when the price of an asset you hold ,
i.e. gold, shares etc, varies on the open market. They are unrealized
because unless you sell the asset you haven't made an actual gain or loss.
Investors and businesses generally want to track the value of items they
have invested in so that they can buy and sell their assets when they can
make a profit on them or at a minimum minimize their losses.

They are tracked and reported separately from actual gains and losses
because most tax autorities do not tax you on unrealized gains and losses
only when you actually sell the assets do they become realized gains and
losses and at this point the gain or loss usually becomes taxable. You can
create separate income sub accounts for Taxable and Non Taxable income if
you wish. The Unrealized Gains and Losses account would thern be a
subaccount of Income:Non Taxable while the  would be a sub account of the
Income:Taxable subaccount and when you make the sale after having recorded
the gain or loss at the sale price you would create a transaction to
transfer the balance of the Unrealized Gains and Losses account to the
Realized Gains and Losses which will then be assessable for tax when you
file it. You are not normally required to report Unrealized Gains and Losses
to a tax authority in most countries/jurisdictions (there are some where you
are -so check this with your local accountant)

If you are holding 100gms of gold for example and the price yesterday was
$53.53/gm and today the price is $54.13/g you have had an unrealized gain of
$60.00. When this happens you would record a transaction as follows:

 Debit  
Credit  
Asset:Gold60
Income:Unrealized Gains and Losses:Gold   60

If tomorrow the price drops to $52.93/gm you will have overnight made an
unrealized loss of $120 and you would record this as:

 Debit  
Credit  
Asset:Gold  
120
Income:Unrealized Gains and Losses:Gold   120   

and the Balance of the Income:UnrealizedGains and Losses:Gold will have
decresed by $60 from what it was two days ago.  This balance will tell you
whether you have made or lost money by holding the gold since you bought it.

Not sure why your question got hijacked. Sometimes because in an answer
someone else finds a point and instead of starting a new topic just jumps on
the existing topic.  

Others may be expressing displeasure that you are off subject for the User
forum because the purpose of the forum is not to teach you about accounting
but how to use GnuCash to do the accounting which makes life difficult when
you are learning both at the same time. Wikipedia has a fairly good
treatment of accounting and usually fairly clear explanations of the terms
so try looking up any accounting knowledge/terms there first.

David

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[John Ralls]

> On Apr 8, 2020, at 11:55 AM, Patrick Farrell  wrote:
> 
> Is there a "Canadian Version" of GnuCash as all the documentation in the 
> current version of GnuCash 3.4+ (Build 2018-12-30) that I have read relates 
> to the USA Tax System?
> 
> I immediately need to know how to set up automatically calculating how to add 
> Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I make up and 
> send out to Clients/Customers, and then how to separately account for HST 
> that I pay on any invoices that I receive from our vendors and subsequently 
> pay. I then need to offset the HST received from Client/Customers versus the 
> HST I have paid out to Vendors and do an official Government HST filing at 
> least Quarterly, and pay them the difference if any!
> 
> Is there an "Update" software function in the program somewhere, as I have 
> not been able to see any obvious place to do this? I see there is GnuCash 3.9 
> version offered on the website, but will I lose all existing data in my 
> existing GnuCash 3.4+ if I download 3.9 on top of it or have to delete 3.4+ 
> before I install version 3.9?

There are no national versions, and in any case even US residents would be 
foolish indeed to rely on GnuCash's documentation for tax information. The 
Tutorial and Concept Guide presents a very basic overview of accounting to help 
new users understand how GnuCash is different from programs like KMyMoney or 
Quicken. Beyond that any examples are intended to illustrate how to do tasks in 
GnuCash.

No, GnuCash has no "check for updates" function. MacOS and Microsoft Windows 
users can install new all-in-one packages. Linux users can either install the 
flatpak or rely on their distro's package manager though most of those tend to 
lag behind releases. Installing an upgrade in the same major release shouldn't 
affect your data.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[jess]

Thanks for the patience and help, I appreciate it. If I may ask another
account setup questions, how do you propose to handle income tax and other
contributions from your salary slips? 

I am a salaried individual with regular monthly income. The salary slips
reflect the gross income which contains deductions to health insurance,
social security contributions etc. The net income is finally credited to my
bank account. In the end of the year, I have a yearly consolidated form
which mentions my various contributions (social security, pension, health
insurance, tax etc.) from my salary slips for that FY (Financial Year). For
example, this tabular form would mention

Income Tax Paid - 100€
Health Insurance - 40€
Pension - 30€
Social Security - 20€

Some other details - 

 (i) My goal is to track yearly contributions, I do not quite need monthly
details. 

 (ii) I plan to import monthly bank transactions from my bank accounts in a
CSV format 

 (iii) Tax and other contributions may wary throughout the year due to bonus
received

 (iv) I have a separate account for "Income : Tax Refund" to see income
earned back from taxes

 (v) I want to track fine grained contributions viz. I have a separate
account for every contribution "Income Tax", "Social Security", "Pension"
etc.

 (vi) Contributions could be split between me and employer. For example, 10%
of income for total health insurance where I contribute 5% and employer
contributes 5%. But, the entire 10% is counted towards the gross income
statement. Income tax rates are based on gross incomes


I currently have two options which come to my mind.

Option 1 - Monthly Salary Slip entries

In this option, I will merely inflate the gross "Income" to "Net Income" (as
reflected on my bank account) + Contributions. The gross salary will flow
into the "Income" account and contributions will flow into the "Expense"
accounts - one for each 

Pros - I have monthly entries, up to date information at any given point of
time

Cons - Difficult to enter every month due to (iii), bank transaction CSV
import only reflects net income and additional account entries required

Option 2 - Yearly Entries Based on Wage Tax Form as mentioned above

Here, I will just enter the contributions yearly into a separate individual
"Expense" accounts once a year. I am unsure on how to handle the "Income"
accounts year. My immediate idea is to create "Income" accounts for every
contribution. For example

"Income : Social Security" , "Expense : Social Security"

"Income : Health Insurance", "Expense : Health Insurance" and so on

Pros - Easier to work with, transaction import CSV process does not
interfere

Cons - Difficult to handle contributions as some contributions are employers
but part of the gross income (Refer (vi)


Given these options, what do you recommend? I am particularly concerned and
out of wits for point (vi). It seems complicated to handle.  



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Should i care about Unrealized Losses/Gain in Balance Sheet ?

[Long]

Hello,

I have posted a topic about this, but that topic have been spammed. So i
created new one to resolve my question.

First, i'm not an accounting, and trying to stay away accounting language,
trying to make anything to easier to understand for me, and who have the
same question like me. OK, my question is :
---
I have 2 Bank accounts, one for my default currency, and other is USD in
GnuCash. In my real life, i usually buy USD by my VND, Then, I will sell USD
to get VND back. (included gold ... but i just want to talk about USD, it's
the same thing to do in GnuCash).
So, i setup the price database (GnuCash 3.9) for USD, i assume the rate is 1
USD = 2 VND for first time i bought. So my accounts :
---
Assets: 40 VND
-- VND Bank : 20 VND
-- USD Bank  : 10 USD -- 20 VND
Equity : 40 VND
---
Next month, The rate changed : 1USD = 3VND
Assets : 50 VND
-- VND Bank : 20 VND
-- USD Bank : 10 USD -- 30 VND
Equity : 40 VND
---
Ok, the problem here, My Balance Sheet report now show in the equity tab
that had "Unrealized Gain" about 10 VND.
I knew that it's mean the rate of the USD are increasing so my assets are
increasing too. 
But, It's also "Unrealized Gain" and not the "Realized Gain" in the report
when i transferred that USD to VND Bank. (Which mean, when USD rate high, i
sell it by transfer that money from USD Bank to VND Bank in GnuCash, of
course in my real life i do the same thing).
My accounts at that time:
Assets: 50 VND
-- VND Bank : 50 VND
-- USD Bank : 0
Equity : 40VND
---
1
 - So,i really don't need to care about that "Words" in the Balance Sheet
Report ?
2
 - If i need to care about it, What should i do to change it from
"Unrealized" to "Realized" (Please give me example for this).
---
P/s : I had read documents from GnuCash, and it's look like very hard to
understand for me. And i don't turned on the "Trading account", look like it
is the old way for solving this in the older version of GnuCash. i only
created account with USD currency and setup the price database.

Thank you so much. Please help me.
Regards.




--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

[Patrick Farrell]

Is there a "Canadian Version" of GnuCash as all the documentation in the 
current version of GnuCash 3.4+ (Build 2018-12-30) that I have read 
relates to the USA Tax System?


I immediately need to know how to set up automatically calculating how 
to add Canadian Harmonized Sales Tax ("HST") @ 13% to any Invoices I 
make up and send out to Clients/Customers, and then how to separately 
account for HST that I pay on any invoices that I receive from our 
vendors and subsequently pay. I then need to offset the HST received 
from Client/Customers versus the HST I have paid out to Vendors and do 
an official Government HST filing at least Quarterly, and pay them the 
difference if any!


Is there an "Update" software function in the program somewhere, as I 
have not been able to see any obvious place to do this? I see there is 
GnuCash 3.9 version offered on the website, but will I lose all existing 
data in my existing GnuCash 3.4+ if I download 3.9 on top of it or have 
to delete 3.4+ before I install version 3.9?


Any suggestions would be helpful.

P@ddy

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Suggestion: add "balance" variable for scheduled transactions

[Stephen M. Butler]

On 4/8/20 11:19 AM, David Carlson wrote:
> Have you reviewed
> https://www.gnucash.org/viewdoc.phtml?rev=3=C=guide


Not recently.  I was a couple years into paying my mortgage when started
using GnC.  At that time I setup the scheduled transaction myself and
noted that there was no way to get the current balance nor the number of
days since last payment.  Haven't reviewed the docs since.

>
> On Wed, Apr 8, 2020 at 1:13 PM Stephen M. Butler  > wrote:
>
> I like it. 
>
> Could you also add "days" as in the number of days from the last
> posting
> of this transaction until this posting (assume posting means
> "effective
> date of transaction".  This would then allow the user to craft the
> interest based on number of days and the daily interest rate (fixed
> value known at time creating the scheduled transaction).  Be sure the
> "interest" is rounded to the nearest penny and not left fraction
> of pennies.
>
> On 4/7/20 10:53 PM, jeanl wrote:
> > GC people!
> > The scheduled transaction editor has one special variable "i"
> which you can
> > use in your credit/debit formula, and counts how many times the
> transaction
> > has posted.
> > I'm suggesting to add a variable "balance" that would hold the
> value of the
> > account (see below for which) at the time the transaction posts.
> This
> > balance could then be used to compute interest, and other
> amounts that
> > depend on the current balance, within the scheduled transaction.
> >
> > The idea is to allow *simple* interest computations for basic
> fixed interest
> > mortgage loans that compound monthly (as is typically the case
> in the US,
> > but definitely not in the rest of the world).
> > Here's a typical example: You have a 4% interest rate on a
> mortgage with a
> > monthly payment of say $1000 (these have to be known in advance)
> > Each month the schedule transaction would transfer $1000 from
> your checking
> > account (for example) and split that into balance*0.04/12 toward
> an expense
> > account "mortgage interest" and 1000-balance*0.04/12 toward
> reducing the
> > mortgage account. "balance" would hold the current principal of
> the loan at
> > that date.
> >
> > This would easily handle mortgage extra payments: If you pay an
> extra $500
> > in the middle of the month, that goes toward reducing the principal
> > (assuming that's how your bank handles it, but that's typical in
> the US) and
> > at the end of the month, the interests computed by the scheduled
> > transactions would be computed accurately according to the new
> loan balance.
> >
> > Again, all this works only if your interests are compounded
> monthly and not
> > daily.
> > The account the "balance" refers to would be automatically
> detected based on
> > the nature of the accounts present in the splits (i.e., it would
> ignore all
> > accounts except for the liability account, assuming there's only
> one).
> >
> > I understand this is far from perfect, and only applies to a
> subset of the
> > users, but for these I believe it could be quite useful. It
> happens to be
> > fairly easy to implement, which is why I'm suggesting it.
> >
> > I'm welcoming any feedback on this idea.
> > Jean
> >
> >
> >
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org 
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> -- 
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com 
> kg...@arrl.net 
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Jean-David Beyer via gnucash-user]

On 4/8/20 12:30 PM, Adrien Monteleone wrote:

> To be clear, the spot price is per ozt, but it is based on a
> transaction involving 1000 ozt of Silver or 1kg of Gold. If you are
> buying or selling more or less, your exact price will be different,
> but you can use the spot as a guide.

Here in USA, a standard contract for gold is 100 troy ounces and for
silver, it is 5000 troy ounces.

The spot price may be useful if you are trading gold or silver
contracts, but if you buy a contract because you want to take delivery
of the gold, you are in for a rude shock. For example, there are an
estimated 300 contracts out there for each 100 ounces of gold, so if all
holders wanted to take delivery, 299 would have to do without.

If you actually want to take delivery, you may have to pay a big
premium. These days, some items are either not available at all
(Canadian one-ounce silver Maple Leafs), or command a large premium
($177 premium over spot) to get a one-ounce US Gold Eagle.

So it depends on how you intend to use the prices just what prices you
should use.

-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 14:15:01 up 26 days, 17:44, 2 users, load average: 4.93, 5.19, 5.17
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Suggestion: add "balance" variable for scheduled transactions

[David Carlson]

Have you reviewed
https://www.gnucash.org/viewdoc.phtml?rev=3=C=guide

On Wed, Apr 8, 2020 at 1:13 PM Stephen M. Butler  wrote:

> I like it.
>
> Could you also add "days" as in the number of days from the last posting
> of this transaction until this posting (assume posting means "effective
> date of transaction".  This would then allow the user to craft the
> interest based on number of days and the daily interest rate (fixed
> value known at time creating the scheduled transaction).  Be sure the
> "interest" is rounded to the nearest penny and not left fraction of
> pennies.
>
> On 4/7/20 10:53 PM, jeanl wrote:
> > GC people!
> > The scheduled transaction editor has one special variable "i" which you
> can
> > use in your credit/debit formula, and counts how many times the
> transaction
> > has posted.
> > I'm suggesting to add a variable "balance" that would hold the value of
> the
> > account (see below for which) at the time the transaction posts. This
> > balance could then be used to compute interest, and other amounts that
> > depend on the current balance, within the scheduled transaction.
> >
> > The idea is to allow *simple* interest computations for basic fixed
> interest
> > mortgage loans that compound monthly (as is typically the case in the US,
> > but definitely not in the rest of the world).
> > Here's a typical example: You have a 4% interest rate on a mortgage with
> a
> > monthly payment of say $1000 (these have to be known in advance)
> > Each month the schedule transaction would transfer $1000 from your
> checking
> > account (for example) and split that into balance*0.04/12 toward an
> expense
> > account "mortgage interest" and 1000-balance*0.04/12 toward reducing the
> > mortgage account. "balance" would hold the current principal of the loan
> at
> > that date.
> >
> > This would easily handle mortgage extra payments: If you pay an extra
> $500
> > in the middle of the month, that goes toward reducing the principal
> > (assuming that's how your bank handles it, but that's typical in the US)
> and
> > at the end of the month, the interests computed by the scheduled
> > transactions would be computed accurately according to the new loan
> balance.
> >
> > Again, all this works only if your interests are compounded monthly and
> not
> > daily.
> > The account the "balance" refers to would be automatically detected
> based on
> > the nature of the accounts present in the splits (i.e., it would ignore
> all
> > accounts except for the liability account, assuming there's only one).
> >
> > I understand this is far from perfect, and only applies to a subset of
> the
> > users, but for these I believe it could be quite useful. It happens to be
> > fairly easy to implement, which is why I'm suggesting it.
> >
> > I'm welcoming any feedback on this idea.
> > Jean
> >
> >
> >
> > --
> > Sent from:
> http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
>
> --
> Stephen M Butler, PMP, PSM
> stephen.m.butle...@gmail.com
> kg...@arrl.net
> 253-350-0166
> ---
> GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
>
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Suggestion: add "balance" variable for scheduled transactions

[Stephen M. Butler]

I like it. 

Could you also add "days" as in the number of days from the last posting
of this transaction until this posting (assume posting means "effective
date of transaction".  This would then allow the user to craft the
interest based on number of days and the daily interest rate (fixed
value known at time creating the scheduled transaction).  Be sure the
"interest" is rounded to the nearest penny and not left fraction of pennies.

On 4/7/20 10:53 PM, jeanl wrote:
> GC people!
> The scheduled transaction editor has one special variable "i" which you can
> use in your credit/debit formula, and counts how many times the transaction
> has posted.
> I'm suggesting to add a variable "balance" that would hold the value of the
> account (see below for which) at the time the transaction posts. This
> balance could then be used to compute interest, and other amounts that
> depend on the current balance, within the scheduled transaction.
>
> The idea is to allow *simple* interest computations for basic fixed interest
> mortgage loans that compound monthly (as is typically the case in the US,
> but definitely not in the rest of the world).
> Here's a typical example: You have a 4% interest rate on a mortgage with a
> monthly payment of say $1000 (these have to be known in advance)
> Each month the schedule transaction would transfer $1000 from your checking
> account (for example) and split that into balance*0.04/12 toward an expense
> account "mortgage interest" and 1000-balance*0.04/12 toward reducing the
> mortgage account. "balance" would hold the current principal of the loan at
> that date.
>
> This would easily handle mortgage extra payments: If you pay an extra $500
> in the middle of the month, that goes toward reducing the principal
> (assuming that's how your bank handles it, but that's typical in the US) and
> at the end of the month, the interests computed by the scheduled
> transactions would be computed accurately according to the new loan balance.
>
> Again, all this works only if your interests are compounded monthly and not
> daily.
> The account the "balance" refers to would be automatically detected based on
> the nature of the accounts present in the splits (i.e., it would ignore all
> accounts except for the liability account, assuming there's only one).
>
> I understand this is far from perfect, and only applies to a subset of the
> users, but for these I believe it could be quite useful. It happens to be
> fairly easy to implement, which is why I'm suggesting it.
>
> I'm welcoming any feedback on this idea.
> Jean
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[David Carlson]

Glad you were able to make it work.  You can modify the procedure to your
liking, that is one feature of GnuCash.

On Wed, Apr 8, 2020 at 1:04 PM jess  wrote:

> Thanks David.
>
> Here's the simple procedure which I did. I manually navigated to the
> "Checking Accounts" where the transactions were imbalanced (based on date
> and amount). I assigned an Expense account (in my case all of them were
> withdrawals) and the transaction disappeared from the "Imbalanced EUR"
> account.
>
> Thanks for the explanation of your procedure and keyboard shortcuts. I will
> make note of it and try to do so next time when I face a similar issue.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[jess]

Thanks David.

Here's the simple procedure which I did. I manually navigated to the
"Checking Accounts" where the transactions were imbalanced (based on date
and amount). I assigned an Expense account (in my case all of them were
withdrawals) and the transaction disappeared from the "Imbalanced EUR"
account. 

Thanks for the explanation of your procedure and keyboard shortcuts. I will
make note of it and try to do so next time when I face a similar issue.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Fred Bone]

On 08 April 2020 at 8:40, John Ralls said:

[...]
> The
> gold amount is Troy ounces, about 40 grams. 

That "about" is a bit of a stretch. One troy ounce is 31.1034768 g

(one troy ounce is 20 pennyweights; one pennyweight is 24 grains;
one grain is defined as 0.06479891 grams)



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[David Carlson]

Jess,

The procedure that I follow is to first open the Imbalance-USD account (I
am in the USA) in the Auto-Split-Ledger view.

Then I select the transaction that I want to fix.  It probably already has
a split line for the bank or credit card account where the money was spent.

Then I Tab repeatedly until the curser in in a new line, and tab again into
the account field.

Then I type EX: and click on the dot symbol to open the drop-down account
list, where I select the desired expense account.

Then I move the curser to the amount in the Imbalance-USD line, enter
Crtl-X to remove the value.

Then I move the curser down to the new expense amount box and enter Crtl-V
to post the value there.

Then I press the Enter key to commit the transaction edit.

At this point the transaction is correct but it still has the undesired
Imbalance-USD split line.

Then I could put the curser on the Imbalance-USD line, right click and
select Delete Split.  If I do that, the transaction will disappear from the
Imbalance-USD register, indicating that split line has been removed from
the transaction.  However, I prefer to move the curser to the bank or
credit card account split line, Right Click  and select Jump to that
account register before removing the Imbalance-USD line so I can see the
transaction in it's final form.

Following this lengthy procedure allows me to see what I am doing.

If you follow this procedure and get different results, please let us know.


On Wed, Apr 8, 2020 at 10:07 AM jess  wrote:

> I did check out the "Split View" too. But, I could not settle them in the
> "Imbalanced EUR" account even in the "Split View".
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Adrien Monteleone]

Well, *officially* the U.S. Government still says the price is ≈$1.36 per gram 
:) if only we had such dollars!

(price in law last I checked was $42. per ozt, with ≈31.10348 grams per 
ozt.)

Just my 2¢ (or is that 1 FRN! now?)

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 12:22 PM, Les  wrote:
> 
> I use Kitco.com/markets for my prices of precious metals.  It is as accurate 
> as one can get.  (The real value of an ounce of gold or silver is currently 
> controlled by the paper markets.  And of course it is priced in USD.  It 
> would be more accurate to price USD in grams of gold. But that will probably 
> never happen in my lifetime.
> 
> Les
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Adrien Monteleone]

But there is a premium on top of that.

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 12:36 PM, Les  wrote:
> 
> Eric:
> 
> There are 480 grains per troy oz.
> 
> So you can convert your Sovereigns using the above
> 
> On 4/8/20 12:18 PM, Eric Coates via gnucash-user wrote:
>> 
>> Adrien
>> 
>> OK. Now that I understand where GnuCash's gold price comes from I've come to 
>> the conclusion that what I called the "retail price" of gold is a mirage!
>> 
>> My gold is in the form of Sovereigns (each of about 7.5gms) and I guess that 
>> the only reliable way to get a value of it is by offering it for sale.
>> 
>> But I now know more than I did when I woke up this morning which can't be 
>> bad. Thank you
>> 
>> Eric
>> 
>> A note for Long:
>> It was your question about realised and unrealised losses that got me 
>> thinking (you used "gold" as an asset). I think, unless you actually have 
>> real gold, this thread is best ignored - except as an intellectual exercise. 
>> I do hold gold (in modest quantities) and that's how I'm thinking of this 
>> thread.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Adrien Monteleone]

In the case of a specific coin, as opposed to bars or generic or mint rounds, 
there are several websites selling them that can give you a reasonable price. 
Of course, their premium from spot will itself vary from time to time.

The case will be similar for other country specific coins, even if they are 
‘bullion’ like Maple Leafs, Eagles, Kuggerands, etc.

Ask a local reputable coin dealer (who you might well be selling to) and get 
their opinion on an ‘average’ premium. You can then take spot, add the premium, 
and use that for a manual price entry. (or just pick a website ‘buy’ price for 
the same coin and use that) If you use the purchase price (their selling price) 
then you’ll be overestimating. (you’ll never get that price on the same day)

Numismatics are a different animal entirely. For those you’d have to use some 
coin grading resource and even then, the value is a very subjective estimate 
until it is sold. I have some of this as well and they are booked at purchase 
price. I don’t bother with any adjustments unless I sell, then I’ll realize a 
gain or loss as with bullion.

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 12:18 PM, Eric Coates via gnucash-user 
>  wrote:
> 
> 
> Adrien
> 
> OK. Now that I understand where GnuCash's gold price comes from I've come to 
> the conclusion that what I called the "retail price" of gold is a mirage!
> 
> My gold is in the form of Sovereigns (each of about 7.5gms) and I guess that 
> the only reliable way to get a value of it is by offering it for sale.
> 
> But I now know more than I did when I woke up this morning which can't be 
> bad. Thank you
> 
> Eric
> 
> A note for Long:
> It was your question about realised and unrealised losses that got me 
> thinking (you used "gold" as an asset). I think, unless you actually have 
> real gold, this thread is best ignored - except as an intellectual exercise. 
> I do hold gold (in modest quantities) and that's how I'm thinking of this 
> thread.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Les]

Eric:

There are 480 grains per troy oz.

So you can convert your Sovereigns using the above

On 4/8/20 12:18 PM, Eric Coates via gnucash-user wrote:


Adrien

OK. Now that I understand where GnuCash's gold price comes from I've 
come to the conclusion that what I called the "retail price" of gold 
is a mirage!


My gold is in the form of Sovereigns (each of about 7.5gms) and I 
guess that the only reliable way to get a value of it is by offering 
it for sale.


But I now know more than I did when I woke up this morning which can't 
be bad. Thank you


Eric

A note for Long:
It was your question about realised and unrealised losses that got me 
thinking (you used "gold" as an asset). I think, unless you actually 
have real gold, this thread is best ignored - except as an 
intellectual exercise. I do hold gold (in modest quantities) and 
that's how I'm thinking of this thread.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Les]

I use Kitco.com/markets for my prices of precious metals.  It is as 
accurate as one can get.  (The real value of an ounce of gold or silver 
is currently controlled by the paper markets.  And of course it is 
priced in USD.  It would be more accurate to price USD in grams of gold. 
But that will probably never happen in my lifetime.


Les

On 4/8/20 11:33 AM, Long wrote:

Sorry, I need help here ... Please help me.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Eric Coates via gnucash-user]

Adrien

OK. Now that I understand where GnuCash's gold price comes from I've 
come to the conclusion that what I called the "retail price" of gold is 
a mirage!


My gold is in the form of Sovereigns (each of about 7.5gms) and I guess 
that the only reliable way to get a value of it is by offering it for sale.


But I now know more than I did when I woke up this morning which can't 
be bad. Thank you


Eric

A note for Long:
It was your question about realised and unrealised losses that got me 
thinking (you used "gold" as an asset). I think, unless you actually 
have real gold, this thread is best ignored - except as an intellectual 
exercise. I do hold gold (in modest quantities) and that's how I'm 
thinking of this thread.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Long]

Sorry, I need help here ... Please help me.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Adrien Monteleone]

To be clear, the spot price is per ozt, but it is based on a transaction 
involving 1000 ozt of Silver or 1kg of Gold. If you are buying or selling more 
or less, your exact price will be different, but you can use the spot as a 
guide.

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 11:28 AM, Adrien Monteleone 
>  wrote:
> 
> For the record, a troy ounce (ozt.) is 31.10348 grams.
> 
> Spot pricing is usually based off a set contract amount. Usually 1000 ozt. 
> bars for Silver and 1kg bars (≈32.15 ozt.) for Gold. Transactions in smaller 
> amounts will vary in price accordingly. Also note that there are two quotes, 
> buy/sell or call/ask. The difference is the ’spread’ and where dealers 
> usually make their money. (with maybe a tad more padding here or there)
> 
> I often forget to auto-update so I just enter them manually from the Kitco 
> website as of the 1st of the month. I use NY Spot since I’m in the U.S. but 
> you may prefer London Fix. (which is not really the market price however.)
> 
> Regards,
> Adrien
> 
>> On Apr 8, 2020 w15d99, at 11:18 AM, Eric Coates via gnucash-user 
>>  wrote:
>> 
>> 
>> Hi
>> 
>> A little earlier today, following Frank's contribution, I did an experiment.
>> 
>> I have an account denominated in XAU (but my book currency is GBP) and  I 
>> did a "get quotes" within GnuCash. The gold price that came back was about 
>> 1050 (I assumed this would be GBPs per Troy ounce) but looking at two 
>> different UK sites the "retail price" of gold was about £1330 per Troy ounce.
>> 
>> It was the difference between these numbers that prompted my question and 
>> John's information doesn't help me resolve the difference.(I rather suspect 
>> that the problem arises because of the convolutions of the currency 
>> conversions. But what do I know?)
>> 
>> For completeness: I'm running GnuCash 3.7 with Finance:Quote 1.49 using 
>> Yahoo as JSON as the source of quotes for my shares (I can't see how/where 
>> currency prices are obtained)  on Ubuntu 19.10.
>> 
>> Eric
>> 
>> PS:As I only revalue my portfolio on a monthly basis it's no big deal to 
>> enter a gold price manually so, as I say, it's just out of interest. Thanks 
>> for indulging me.
>> 
>> ==
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Adrien Monteleone]

For the record, a troy ounce (ozt.) is 31.10348 grams.

Spot pricing is usually based off a set contract amount. Usually 1000 ozt. bars 
for Silver and 1kg bars (≈32.15 ozt.) for Gold. Transactions in smaller amounts 
will vary in price accordingly. Also note that there are two quotes, buy/sell 
or call/ask. The difference is the ’spread’ and where dealers usually make 
their money. (with maybe a tad more padding here or there)

I often forget to auto-update so I just enter them manually from the Kitco 
website as of the 1st of the month. I use NY Spot since I’m in the U.S. but you 
may prefer London Fix. (which is not really the market price however.)

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 11:18 AM, Eric Coates via gnucash-user 
>  wrote:
> 
> 
> Hi
> 
> A little earlier today, following Frank's contribution, I did an experiment.
> 
> I have an account denominated in XAU (but my book currency is GBP) and  I did 
> a "get quotes" within GnuCash. The gold price that came back was about 1050 
> (I assumed this would be GBPs per Troy ounce) but looking at two different UK 
> sites the "retail price" of gold was about £1330 per Troy ounce.
> 
> It was the difference between these numbers that prompted my question and 
> John's information doesn't help me resolve the difference.(I rather suspect 
> that the problem arises because of the convolutions of the currency 
> conversions. But what do I know?)
> 
> For completeness: I'm running GnuCash 3.7 with Finance:Quote 1.49 using Yahoo 
> as JSON as the source of quotes for my shares (I can't see how/where currency 
> prices are obtained)  on Ubuntu 19.10.
> 
> Eric
> 
> PS:As I only revalue my portfolio on a monthly basis it's no big deal to 
> enter a gold price manually so, as I say, it's just out of interest. Thanks 
> for indulging me.
> 
> ==


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[Eric Coates via gnucash-user]

Hi

A little earlier today, following Frank's contribution, I did an experiment.

I have an account denominated in XAU (but my book currency is GBP) and  
I did a "get quotes" within GnuCash. The gold price that came back was 
about 1050 (I assumed this would be GBPs per Troy ounce) but looking at 
two different UK sites the "retail price" of gold was about £1330 per 
Troy ounce.


It was the difference between these numbers that prompted my question 
and John's information doesn't help me resolve the difference.(I rather 
suspect that the problem arises because of the convolutions of the 
currency conversions. But what do I know?)


For completeness: I'm running GnuCash 3.7 with Finance:Quote 1.49 using 
Yahoo as JSON as the source of quotes for my shares (I can't see 
how/where currency prices are obtained)  on Ubuntu 19.10.


Eric

PS:As I only revalue my portfolio on a monthly basis it's no big deal to 
enter a gold price manually so, as I say, it's just out of interest. 
Thanks for indulging me.


==

On 08/04/2020 16:40, John Ralls wrote:

On Apr 8, 2020, at 7:31 AM, Eric Coates via gnucash-user 
 wrote:

Good Afternoon

On 08/04/2020 10:08, Frank H. Ellenberger wrote:


The quotes are not from ISO-4217:XAU (troy ounce Gold), but from
NASDAQ:XAU an share index of gold and silver producers.

So, is there a relationship between this NASDAQ:XAU figure and (what might be 
termed) the real price of gold (ie the mid-value retail price of a gram of 
gold, using grams to avoid the confusion between troy ounces and the other 
ounce)?

Just out of interest really


It's https://en.wikipedia.org/wiki/Philadelphia_Gold_and_Silver_Index. It has a 
relationship to the spot price of gold but probably not close enough to be of 
much use.

To get the current USD spot price of Gold in the Zurich Forex markets look for the 
XAU:USD exchange rate; that's what GnuCash will do if you have an account denominated in 
the XAU currency and your book currency is USD. The gold amount is Troy ounces, about 40 
grams. (The "other ounce" is avoirdupois, about 28 grams each.)

Regards,
John Ralls



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Price of gold

[John Ralls]

> On Apr 8, 2020, at 7:31 AM, Eric Coates via gnucash-user 
>  wrote:
> 
> Good Afternoon
> 
> On 08/04/2020 10:08, Frank H. Ellenberger wrote:
> 
>> The quotes are not from ISO-4217:XAU (troy ounce Gold), but from
>> NASDAQ:XAU an share index of gold and silver producers.
> 
> So, is there a relationship between this NASDAQ:XAU figure and (what might be 
> termed) the real price of gold (ie the mid-value retail price of a gram of 
> gold, using grams to avoid the confusion between troy ounces and the other 
> ounce)?
> 
> Just out of interest really
> 

It's https://en.wikipedia.org/wiki/Philadelphia_Gold_and_Silver_Index. It has a 
relationship to the spot price of gold but probably not close enough to be of 
much use.

To get the current USD spot price of Gold in the Zurich Forex markets look for 
the XAU:USD exchange rate; that's what GnuCash will do if you have an account 
denominated in the XAU currency and your book currency is USD. The gold amount 
is Troy ounces, about 40 grams. (The "other ounce" is avoirdupois, about 28 
grams each.)

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[jess]

I did check out the "Split View" too. But, I could not settle them in the
"Imbalanced EUR" account even in the "Split View".



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNUCash beginner setup

[jess]

Thanks Michael, this makes sense!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Price of gold

[Eric Coates via gnucash-user]

Good Afternoon

On 08/04/2020 10:08, Frank H. Ellenberger wrote:


The quotes are not from ISO-4217:XAU (troy ounce Gold), but from
NASDAQ:XAU an share index of gold and silver producers.


So, is there a relationship between this NASDAQ:XAU figure and (what 
might be termed) the real price of gold (ie the mid-value retail price 
of a gram of gold, using grams to avoid the confusion between troy 
ounces and the other ounce)?


Just out of interest really

Take care

Eric


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Long]

Hello Adrien Monteleone-2,

I just want to make it easy. So, everytime i buy $ from bank, i will record
it, and when i sell it (which mean i transfer $ to VND in real life) i just
transfer money from USD Bank to VND Bank in GnuCash.

And the Rate of the money in GnuCash, i will change it when $ rate changed (
i knew that gnucash has auto for this, but i don't use).

So, i don't need to do anything more, just transfer money between my Bank
(like in my real life do). And the Balance Sheet Report will show me
something about unrealized Gain and Lost, i will leave it, Don't need to do
anything, right ? 

Sorry, i'm not an accounting, that why normal words are easier to understand
for me. And sorry for my bad english.

Regards.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Frank H. Ellenberger]

Hi Long,

there is no simple answer. I would suggest to read this:
http://www.mscs.dal.ca/~selinger/accounting/tutorial.html
Yes, it has nice examples.

Frank

Am 08.04.20 um 13:06 schrieb Long:
> Hello Fred Bone, Frank H. Ellenberger-3.
> 
> So, should i do anything or leave it ? or i need to add some transactions to
> balance that, and how ?
> 
> For now, i only transfer money between my bank, which mean my money will
> auto exchange to $ when i transfer to USD bank, and auto exchange to VND
> when i get back my money. With money rate at the time i transfer money. That
> it !!
> 
> I had read a lot documents from GnuCash and it's so extreme hard to me. So
> please give me a example if you can.
> 
> Thank you so much.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

[Adrien Monteleone]

I recall a recent thread about a similar problem with multi-currency import. 
The resulting transaction also had an Imbalance that couldn’t be cleared and 
the only solution was to manually enter the transaction.

If a bug hasn’t been filed, it probably should be.

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 6:30 AM,   
> wrote:
> 
> It was a transaction for a $ purchase, paid with a UK credit card, and now
> correctly looks like this:
> In the US groceries register:
> Met Foodmarkets   US Groceries$37.95
>   Halifax CC  $37.95
> 
> In the Halifax CC register:
> Met Foodmarkets   US groceries£29.19
>   Halifax CC  £29.19
> 
> Somehow this had corrupted to two separate transactions, both £ denominated,
> but on one the CC amount had changed to Imbalance GDP. I couldn't change
> that in either register, so I ended up deleting the two transactions and
> recreating the original one.
> 
> Kind regards,
> Rob


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Adrien Monteleone]

This links to your other thread about recording fluctuations in gold prices.

You don’t need to record the fluctuations, as GnuCash will show you the 
unrealized (because you haven’t sold yet) gain or loss. Just perform a ‘Get 
Quotes’ on a regular basis. (you can also manually enter prices if you forget 
to pull them)

It will do this automatically for any case where you have more than one 
currency with exchange rates other than “1”. (as well as for all books with 
accounts of type ‘fund’ or ’stock’ that have changes in prices)

When you transfer money between banks with different currencies, most likely 
you will receive some sort of receipt that indicates the two amounts. You want 
to enter those as the transaction and then this will add a new price to the 
database. If you just enter one amount (say VND) then GnuCash will use the last 
known price. That will rarely be correct since most currencies float freely and 
the exchange rate changes at least daily if not fluidly near 24/7.

Regards,
Adrien

> On Apr 8, 2020 w15d99, at 6:06 AM, Long  wrote:
> 
> Hello Fred Bone, Frank H. Ellenberger-3.
> 
> So, should i do anything or leave it ? or i need to add some transactions to
> balance that, and how ?
> 
> For now, i only transfer money between my bank, which mean my money will
> auto exchange to $ when i transfer to USD bank, and auto exchange to VND
> when i get back my money. With money rate at the time i transfer money. That
> it !!
> 
> I had read a lot documents from GnuCash and it's so extreme hard to me. So
> please give me a example if you can.
> 
> Thank you so much.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.9 Flathub stucks

[Frank H. Ellenberger]

Hi,

Am 08.04.20 um 13:49 schrieb F:
> Hello Frank,
> 
> []$ flatpak run org.gnucash.GnuCash
> 
>  org.gnucash.GnuCash ~]$  locate /app/lib/guile/2.2/ccache/
>  org.gnucash.GnuCash ~]$

That was not meant as a command.

> I do not understand why I need the first and second commands.
> 
> Manually I cannot find that path.

On my machine i have one at
/home/frank/.local/share/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/guile/2.2/ccache

Because I am not absolutely sure, you should better move the content to
another place.

Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Debit & Credit headings

[Derek Atkins]

Nope.  Most likely they are wrong in your mind because you learned them
from bank and CC statements, which are *backwards* to you.

A Bank account is an Asset to you, but to your bank it's a Liability!  So
Debits and Credits are backwards between your view and the Bank's view.

Please go read the Tutorial and Guide which explains this.

-derek

On Wed, April 8, 2020 8:44 am, Robert Masding wrote:
> They seem to be the wrong way round? Have I done something wrong in the
> setup?
>
>
>
> *Rob*
>
> *Robert Masding*
>
>
>
> *+44 (0)7707 985 379   +44(0)1392 791 428*
>
> *Flat 25, Norwood house, Pennsylvania Road, Exeter, EX4 6TR. UK.*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   Derek Atkins 617-623-3745
   de...@ihtfp.com www.ihtfp.com
   Computer and Internet Security Consultant

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Debit & Credit headings

[Robert Masding]

They seem to be the wrong way round? Have I done something wrong in the
setup?



*Rob*

*Robert Masding*



*+44 (0)7707 985 379   +44(0)1392 791 428*

*Flat 25, Norwood house, Pennsylvania Road, Exeter, EX4 6TR. UK.*
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.9 Flathub stucks

[F]

Hello Frank,

[]$ flatpak run org.gnucash.GnuCash

 org.gnucash.GnuCash ~]$  locate /app/lib/guile/2.2/ccache/
 org.gnucash.GnuCash ~]$

I do not understand why I need the first and second commands.

Manually I cannot find that path.

On Wed, 8 Apr 2020 at 10:46, Frank H. Ellenberger <
frank.h.ellenber...@gmail.com> wrote:

> Hi F,
>
> Am 08.04.20 um 09:17 schrieb F:
> > Thank you Geert!
> >
> > There are a lot of errors, most of them - "source file newer than
> compiled".
> >
> > I have attached the output below.
> >
> >
> > dfg@HP2760p:~$ flatpak run org.gnucash.GnuCash --logto stdout
> >
> > (process:13771): flatpak-WARNING **: 10:00:16.922: Error writing
> > credentials to socket: Error sending message: Broken pipe
> > ;;; note: source file /app/share/guile//2.2/ice-9/psyntax-pp.scm
> > ;;;   newer than compiled
> /app/lib/guile/2.2/ccache/ice-9/psyntax-pp.go
>
>
> flatpak run --command=sh org.gnucash.GnuCash
>
> locate /app/lib/guile/2.2/ccache/
> and remove the whole content
>
> on the next start guile will compile them again.
>
> Geert, I wonder if there is a hook, where we can do it, if the user
> updated the package.
>
> Regards
> Frank
>


-- 
Best Regards
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

[rgwbruce]

It was a transaction for a $ purchase, paid with a UK credit card, and now
correctly looks like this:
In the US groceries register:
Met Foodmarkets US Groceries$37.95
Halifax CC  $37.95

In the Halifax CC register:
Met Foodmarkets US groceries£29.19
Halifax CC  £29.19

Somehow this had corrupted to two separate transactions, both £ denominated,
but on one the CC amount had changed to Imbalance GDP. I couldn't change
that in either register, so I ended up deleting the two transactions and
recreating the original one.

Kind regards,
Rob


-Original Message-
From: John Ralls  
Sent: 07 April 2020 23:46
To: RobBruce 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] CRIT  [gnc_price_unref()] last unref while
price in database

Excellent that you're back in business. What was wrong with the transaction?

Regards,
John Ralls


> On Apr 7, 2020, at 12:15 PM,  
wrote:
> 
> Many thanks for that, John.
> 
> I'd already got the same error when I opened the last backup file, 
> which is why I assumed it was more than just a corrupt data file.
> 
> I had to go back 3 versions before I found the one that loaded, but 
> I've then been able to import all the subsequent log files.
> 
> There was one transaction causing the problem, a foreign currency 
> transaction.
> 
> All now looks good.
> 
> Thanks again for your help.
> 
> Kind regards,
> Rob
> 
> -Original Message-
> From: John Ralls 
> Sent: 07 April 2020 18:34
> To: RobBruce 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] CRIT  [gnc_price_unref()] last unref 
> while price in database
> 
> 
> 
>> On Apr 7, 2020, at 9:56 AM, RobBruce  wrote:
>> 
>> I'm running 3.4 on Windows 10.
>> 
>> Until this afternoon, it's been running very smoothly.
>> 
>> On trying to load GnuCash, I got a message that there was an error 
>> parsing the file E:\Documents\gnucash-rob\rob-gnucash.gnucash
>> 
>> I did look for solutions, and opened the trace log, which contains:
>> 
>> * 12:49:21  WARN  Could not spawn perl: Failed to 
>> execute child process (No such file or directory)
>> * 12:49:21  WARN  Could not read from compressed 
>> file 'E:\Documents\gnucash-rob\rob-gnucash.gnucash'. The error is:
>> 'E:\Documents\gnucash-rob\rob-gnucash.gnucash: invalid block type' 
>> (-3)
>> * 12:49:21  CRIT  parse failed at:
>> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
>> price in database
>> * 12:49:21  CRIT  [gnc_price_unref()] last unref while 
>> price in database 
>> * 12:49:21  WARN  [GncXmlBackend::load()] Syntax error 
>> in Xml File E:\Documents\gnucash-rob\rob-gnucash.gnucash
>> 
>> I'm not aware of having made any change to the file structure - is 
>> this recoverable, please?
> 
> It looks like you have a corrupted file. Try loading the last backup, 
> which should be named something like 
> rob-gnucash.gnucash.20200405154732.gnucash;
> the numbers in the middle are a date stamp, mmddhhmmss, for the 
> subsequent save. Depending on what work you did in the last session 
> you may be able to recover some of it by replaying the corresponding 
> log file with
> File>Import>Replay log file.
> 
> You should also check the drive with `chkdsk` and `wmic diskdrive get 
> status` to make sure that the corruption was something random like a 
> cosmic ray and not the first sign of needing a new one.
> 
> Regards,
> John Ralls
> 
> 


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Long]

Hello Fred Bone, Frank H. Ellenberger-3.

So, should i do anything or leave it ? or i need to add some transactions to
balance that, and how ?

For now, i only transfer money between my bank, which mean my money will
auto exchange to $ when i transfer to USD bank, and auto exchange to VND
when i get back my money. With money rate at the time i transfer money. That
it !!

I had read a lot documents from GnuCash and it's so extreme hard to me. So
please give me a example if you can.

Thank you so much.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Fred Bone]

On 08 April 2020 at 1:05, Long said:

> Hello,
> 
> First, i'm not an accounting, and trying to use GnuCash to manager my
> finances.
> 
> I'm managing multiple currency in GnuCash, and i created Bank account for
> each currency i had.
> 
> And everytime my currency rate changed, i changed it in "Price Database".
> And Balance Sheet report show me Unrealized Losses/Gain on the Equity Tab.
> I don't understand what it's mean and should i remove it ? and how ?

What it means is that there are differences between the value (in your 
home currency) assigned when you created each transaction, and the value 
now (because you have added new exchange rates), and you haven't added 
transactions to record (realise) those changes.

More specifically, the *total* (across all your transactions) of those 
differences has changed (you could think up an unlikely situation where, 
say, the change in value of your transactions in one currency is exactly 
balanced by the change in value of another currency).

To realise those gains/losses you need to enter balancing transactions, 
one per ("foreign currency") account, every time you add a changed 
exchange rate.

If you want to record every daily change in exchange rate then perhaps 
you should learn a little about accounting. There is plenty of material 
on the Web.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Frank H. Ellenberger]

Errandum:

The quotes are not from ISO-4217:XAU (troy ounce Gold), but from
NASDAQ:XAU an share index of gold and silver producers.

Am 08.04.20 um 10:22 schrieb Frank H. Ellenberger:
> Example
> Persons A and B bought each a troy ounce Gold [XAU] this year:
> A @ 100 USD,
> B @ 70 USD,
> Currently it is noted ~90 USD.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Suggestion: add "balance" variable for scheduled transactions

[jeanl]

GC people!
The scheduled transaction editor has one special variable "i" which you can
use in your credit/debit formula, and counts how many times the transaction
has posted.
I'm suggesting to add a variable "balance" that would hold the value of the
account (see below for which) at the time the transaction posts. This
balance could then be used to compute interest, and other amounts that
depend on the current balance, within the scheduled transaction.

The idea is to allow *simple* interest computations for basic fixed interest
mortgage loans that compound monthly (as is typically the case in the US,
but definitely not in the rest of the world).
Here's a typical example: You have a 4% interest rate on a mortgage with a
monthly payment of say $1000 (these have to be known in advance)
Each month the schedule transaction would transfer $1000 from your checking
account (for example) and split that into balance*0.04/12 toward an expense
account "mortgage interest" and 1000-balance*0.04/12 toward reducing the
mortgage account. "balance" would hold the current principal of the loan at
that date.

This would easily handle mortgage extra payments: If you pay an extra $500
in the middle of the month, that goes toward reducing the principal
(assuming that's how your bank handles it, but that's typical in the US) and
at the end of the month, the interests computed by the scheduled
transactions would be computed accurately according to the new loan balance.

Again, all this works only if your interests are compounded monthly and not
daily.
The account the "balance" refers to would be automatically detected based on
the nature of the accounts present in the splits (i.e., it would ignore all
accounts except for the liability account, assuming there's only one).

I understand this is far from perfect, and only applies to a subset of the
users, but for these I believe it could be quite useful. It happens to be
fairly easy to implement, which is why I'm suggesting it.

I'm welcoming any feedback on this idea.
Jean



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Improve imported transaction category matching

[Frank H. Ellenberger]

Hi,

I believe, the OP should at first read
https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html
and then use
https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#ImportMatchEditor
to clean up his file.

Regards
Frank

Am 08.04.20 um 02:22 schrieb Adrien Monteleone:
> I’m not certain, maybe someone else can help, but knowing which file format 
> makes a difference to the devs, thanks.
> 
> Regards,
> Adrien
> 
>> On Apr 7, 2020 w15d98, at 7:20 PM, Giuseppe Quinn  
>> wrote:
>>
>> I’ve been using OFX
>>
>> Is there a pfile or something that might be corrupted that I can set aside 
>> to test and or start over?
>>
>> Thanks for the help!
>>
>>> On Apr 7, 2020, at 1:11 PM, Adrien Monteleone 
>>>  wrote:
>>>
>>> What type of import? QIF, CSV?
>>>
>>> Regards,
>>> Adrien
>>>
>>> p.s. —please be sure to ‘reply-list’ or ‘reply-all’ so others can benefit 
>>> from the discussion and/or offer help.
>>>
 On Apr 7, 2020 w15d98, at 2:01 PM, Giuseppe Quinn  
 wrote:

 Yea, I’ve done them over and over in the import window, to no avail.


>> On Apr 7, 2020, at 12:54 PM, Adrien Monteleone 
>>  wrote:
>
> Make sure you are doing those assignments within the import window. If 
> you import first, then edit transactions to correct Imbalance-xyz to 
> proper accounts, the importer never gets to learn.
>
> Regards,
> Adrien
>
>> On Apr 7, 2020 w15d98, at 1:45 PM, Giuseppe Quinn  
>> wrote:
>>
>> Is there a way to improve category matching of imported transactions? 
>> Every session I have to tell GC which category grocery store 
>> transactions, CC payments, and every other repeating transaction, which 
>> category they go into. 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Frank H. Ellenberger]

I forgot to mention, there is a glossary in the docs:
https://www.gnucash.org/docs/v3/C/gnucash-guide/gnc-gloss.html

More details are in
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_invest.html and
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_dep.html

Am 08.04.20 um 10:22 schrieb Frank H. Ellenberger:
> Hi Long,
> 
> Am 08.04.20 um 08:05 schrieb Long:
>> And everytime my currency rate changed, i changed it in "Price Database".
>> And Balance Sheet report show me Unrealized Losses/Gain on the Equity Tab. I
>> don't understand what it's mean and should i remove it ? and how ?
> 
> Example
> Persons A and B bought each a troy ounce Gold [XAU] this year:
> A @ 100 USD,
> B @ 70 USD,
> Currently it is noted ~90 USD.
> 
> The balance sheet of A will now show 10 USD unrealized losses and
> that of B 20 USD unrealized gains.
> 
> Unrealized means: If you had sold it, when you last queried the quote,
> you would have realized the gain or loss, but you didn't.
> 
> But it helps you to estimate the current market value of your assets.
> 
> To learn, if you have to revalue your assets e.g at the end of the
> financial periode, you should contact your local CPA.
> 
> Regards
> Frank
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Frank H. Ellenberger]

Hi Long,

Am 08.04.20 um 08:05 schrieb Long:
> And everytime my currency rate changed, i changed it in "Price Database".
> And Balance Sheet report show me Unrealized Losses/Gain on the Equity Tab. I
> don't understand what it's mean and should i remove it ? and how ?

Example
Persons A and B bought each a troy ounce Gold [XAU] this year:
A @ 100 USD,
B @ 70 USD,
Currently it is noted ~90 USD.

The balance sheet of A will now show 10 USD unrealized losses and
that of B 20 USD unrealized gains.

Unrealized means: If you had sold it, when you last queried the quote,
you would have realized the gain or loss, but you didn't.

But it helps you to estimate the current market value of your assets.

To learn, if you have to revalue your assets e.g at the end of the
financial periode, you should contact your local CPA.

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.9 Flathub stucks

[Frank H. Ellenberger]

Hi F,

Am 08.04.20 um 09:17 schrieb F:
> Thank you Geert!
> 
> There are a lot of errors, most of them - "source file newer than compiled".
> 
> I have attached the output below.
> 
> 
> dfg@HP2760p:~$ flatpak run org.gnucash.GnuCash --logto stdout
> 
> (process:13771): flatpak-WARNING **: 10:00:16.922: Error writing
> credentials to socket: Error sending message: Broken pipe
> ;;; note: source file /app/share/guile//2.2/ice-9/psyntax-pp.scm
> ;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/psyntax-pp.go


flatpak run --command=sh org.gnucash.GnuCash

locate /app/lib/guile/2.2/ccache/
and remove the whole content

on the next start guile will compile them again.

Geert, I wonder if there is a hook, where we can do it, if the user
updated the package.

Regards
Frank
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gnucash 3.9 Flathub stucks

[F]

Thank you Geert!

There are a lot of errors, most of them - "source file newer than compiled".

I have attached the output below.


dfg@HP2760p:~$ flatpak run org.gnucash.GnuCash --logto stdout

(process:13771): flatpak-WARNING **: 10:00:16.922: Error writing
credentials to socket: Error sending message: Broken pipe
;;; note: source file /app/share/guile//2.2/ice-9/psyntax-pp.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/psyntax-pp.go
;;; note: source file /app/share/guile//2.2/ice-9/psyntax-pp.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/psyntax-pp.go
;;; note: source file /app/share/guile//2.2/ice-9/deprecated.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/deprecated.go
;;; note: source file /app/share/guile//2.2/ice-9/deprecated.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/deprecated.go
;;; note: source file /app/share/guile//2.2/ice-9/threads.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/threads.go
;;; note: source file /app/share/guile//2.2/ice-9/threads.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/threads.go
;;; note: source file /app/share/guile//2.2/ice-9/control.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/control.go
;;; note: source file /app/share/guile//2.2/ice-9/control.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/control.go
;;; note: source file /app/share/guile//2.2/ice-9/futures.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/futures.go
;;; note: source file /app/share/guile//2.2/ice-9/futures.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/futures.go
;;; note: source file /app/share/guile//2.2/srfi/srfi-1.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/srfi/srfi-1.go
;;; note: source file /app/share/guile//2.2/srfi/srfi-1.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/srfi/srfi-1.go
;;; note: source file /app/share/guile//2.2/srfi/srfi-9.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/srfi/srfi-9.go
;;; note: source file /app/share/guile//2.2/srfi/srfi-9.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/srfi/srfi-9.go
;;; note: source file /app/share/guile//2.2/ice-9/ports.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/ports.go
;;; note: source file /app/share/guile//2.2/ice-9/ports.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/ports.go
;;; note: source file /app/share/guile//2.2/system/base/message.scm
;;;   newer than compiled
/app/lib/guile/2.2/ccache/system/base/message.go
;;; note: source file /app/share/guile//2.2/system/base/message.scm
;;;   newer than compiled
/app/lib/guile/2.2/ccache/system/base/message.go
;;; note: auto-compilation is enabled, set GUILE_AUTO_COMPILE=0
;;;   or pass the --no-auto-compile argument to disable.
;;; compiling /app/share/guile//2.2/system/base/message.scm
;;; WARNING: compilation of /app/share/guile//2.2/system/base/message.scm
failed:
;;; In procedure variable-ref: variable is unbound: #>
;;; note: source file /app/share/guile//2.2/system/vm/vm.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/system/vm/vm.go
;;; note: source file /app/share/guile//2.2/system/vm/vm.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/system/vm/vm.go
;;; compiling /app/share/guile//2.2/system/vm/vm.scm
;;; WARNING: compilation of /app/share/guile//2.2/system/vm/vm.scm failed:
;;; In procedure variable-ref: variable is unbound: #>
;;; note: source file /app/share/guile//2.2/ice-9/regex.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/regex.go
;;; note: source file /app/share/guile//2.2/ice-9/regex.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/regex.go
;;; compiling /app/share/guile//2.2/ice-9/regex.scm
;;; WARNING: compilation of /app/share/guile//2.2/ice-9/regex.scm failed:
;;; In procedure variable-ref: variable is unbound: #>
;;; note: source file /app/share/guile//2.2/system/base/pmatch.scm
;;;   newer than compiled
/app/lib/guile/2.2/ccache/system/base/pmatch.go
;;; note: source file /app/share/guile//2.2/system/base/pmatch.scm
;;;   newer than compiled
/app/lib/guile/2.2/ccache/system/base/pmatch.go
;;; compiling /app/share/guile//2.2/system/base/pmatch.scm
;;; WARNING: compilation of /app/share/guile//2.2/system/base/pmatch.scm
failed:
;;; In procedure variable-ref: variable is unbound: #>
;;; note: source file /app/share/guile//2.2/ice-9/receive.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/receive.go
;;; note: source file /app/share/guile//2.2/ice-9/receive.scm
;;;   newer than compiled /app/lib/guile/2.2/ccache/ice-9/receive.go
;;; compiling /app/share/guile//2.2/ice-9/receive.scm
;;; WARNING: compilation of /app/share/guile//2.2/ice-9/receive.scm failed:
;;; In procedure variable-ref: variable is unbound: #>
;;; note: source file /app/share/guile//2.2/system/vm/program.scm
;;;

[GNC] What is Unrealized Losses/Gain in Balance Sheet Report ?

[Long]

Hello,

First, i'm not an accounting, and trying to use GnuCash to manager my
finances.

I'm managing multiple currency in GnuCash, and i created Bank account for
each currency i had.

And everytime my currency rate changed, i changed it in "Price Database".
And Balance Sheet report show me Unrealized Losses/Gain on the Equity Tab. I
don't understand what it's mean and should i remove it ? and how ?

For example : My default currency is VND

Assets: 120 VND
- USD : 10$ -- 20 VND
- VND : 100 VND
Equity : 120VND

Rate is : 1 usd = 2 VND
And when i changed rate : 1 usd = 3 vnd

Assets : 130 VND
- USB : 10$ -- 30vnd
- VND : 100 VND
Equity : 120VND

That it. If i transfer money between that accounts, it auto exchange money
for me. Which mean i transfer 10$ to VND when the rate is 1-3, i have 130VND
in VND bank. 
Then, Balance Sheet Report will show Unrealized Gain about : 10VND.

Please help me. Thank you.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.