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

Picture : balance-sheet-unrealized.png -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

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

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

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

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

Re: [GNC] GNUCash beginner setup

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

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

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,

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

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

Re: [GNC] Starting Balance in Reconciliation Window wrong

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

Re: [GNC] Price of gold

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

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

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

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

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

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

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

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

> 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

Re: [GNC] GNUCash beginner setup

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

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

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,

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

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%

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

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

Re: [GNC] Price of gold

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

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

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 >

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

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

Re: [GNC] GNUCash beginner setup

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

Re: [GNC] GNUCash beginner setup

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

Re: [GNC] Price of gold

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)

Re: [GNC] GNUCash beginner setup

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

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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.

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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:

Re: [GNC] Price of gold

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,

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

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

Re: [GNC] Price of gold

> 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

Re: [GNC] GNUCash beginner setup

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

Re: [GNC] GNUCash beginner setup

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:

[GNC] Price of gold

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

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

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 $

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

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

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

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,

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

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

Re: [GNC] Gnucash 3.9 Flathub stucks

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

Re: [GNC] Debit & Credit headings

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

[GNC] Debit & Credit headings

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

Re: [GNC] Gnucash 3.9 Flathub stucks

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 <

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

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

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

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

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

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

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

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, >

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

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

Re: [GNC] Improve imported transaction category matching

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

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

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

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

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

Re: [GNC] Gnucash 3.9 Flathub stucks

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 **:

Re: [GNC] Gnucash 3.9 Flathub stucks

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

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

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