Re: [GNC] Income earned in gold

[Brad Morrison]

Hi Michael, Fred, & GnuCash users, 

This is an interesting topic! 

The points that Michael brings up about tax implications made me wonder
if your gold investment produces a 1099 and if so, what type of 1099 it
generates...? 

Which is another way of wondering if it is classified as interest income
(1099-INT - https://www.irs.gov/forms-pubs/about-form-1099-int), capital
gains income or dividend income (1099-DIV -
https://www.irs.gov/forms-pubs/about-form-1099-div) or mineral rights
(1099-MISC - https://www.irs.gov/forms-pubs/about-form-1099-misc)...? 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2025-01-02 13:24, Michael or Penny Novack via gnucash-user wrote:

> On 1/2/2025 11:24 AM, Fred Tydeman wrote: 
> 
>> I have an investment in gold (so many ounces).
>> That investment earns "interest" payable in gold (not USD).
>> When I try to setup a new Income account,
>> the only Namespace offered is Currencies.
>> If I try to add a fake currency of Gold,
>> I do not get the Currencies Namespace.
>> 
>> I could guess at the price per ounce of gold at that payable date
>> and record the income as USD.
>> 
>> Any better suggestions?
> Consult tax professionals (and/or the IRS). As far as I can tell not YET a 
> gnucash question and the same true for other commodities like Bitcoin. I 
> would FIRST want to see a ruling about whether this IS income or only later 
> (when sold) income/capital gain. The fact that "gold bugs" want gold treated 
> as if it were currency doesn't make it so. Legally NOT currency in the US for 
> just shy of 100 years.
> 
> NOTE:  Seeing it as income (even though a commodity) because you think a 
> commodity not subject to increase is lack of imagination. Suppose your 
> commodity were 100 cows? << couldn't they have calves? >>
> 
> Michael D Novack
> 
> PS: IF the IRS says is current income at the then valuation date think about 
> a transaction where you BOUGHT that amount of gold, SOLD that amount of gold, 
> received that amount as dollars. Do you have transactions (when taken 
> together) that have debits and credits to your bank account that cancel each 
> other
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Doing Payroll in Gnucash

[R. Victor Klassen via gnucash-user]

I have a rather jurisdiction-specific perl script that I run on a csv file that 
captures the employees time sheet information.

And on top of that I have a piece of C++ code that does the necessary queries 
to get the year-to-date information needed in calculating the deductions, and 
spits out a second .csv file that is read by the above perl script.  The C++ 
code is subject to the possibility of breaking at a major release of GnuCash, 
but hasn’t so far (if the sqlite schema changes, it will break for sure).

So yes it can be done.  I won’t say it’s all that easy.  But without buying 
something or outsourcing it I know of no other way to get payroll right in our 
jurisdiction (Ontario, Canada, specific to rules that apply to farm workers).  


I’m surprised Glenn doesn’t also have to deal with Social Security deductions.  
Here we have EI, CPP, and the two taxes.  I thought I recalled when in the US 
having MC and some other kind of Social Security deduction.

> On Jan 1, 2025, at 12:39 PM, Glenn Fowler  wrote:
> 
> Hi ND,
> 
> What I do is payroll in Quickbooks Payroll Core which is just payroll only 
> and then I just manually add the 3 transactions into GnuCash (payroll check, 
> federal taxes, and state taxes).
> 
> 
> From: gnucash-user  on 
> behalf of Jediator 
> Sent: Wednesday, January 1, 2025 12:31 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Doing Payroll in Gnucash
> 
> Happy New Year everyone!  Anyone using Gnucash for doing Payroll? I'd
> like to know the pros-and-cons of using GNC for payroll processing.  Thanks!
> 
> ND
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Problem getting Finance::Quote working

[Tomas Volf]

Hello,

Today I installed gnucash and am trying to get fetch quotes from the
internet, and I am having troubles getting it to work.  I am not
subscribed, so please CC.

When I try the `gnucash-cli --quotes info', it seems to work:

--8<---cut here---start->8---
$ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli 
--quotes info
* 00:56:27  WARN  [GncFQQuoteSource::set_api_key()] No Alpha 
Vantage API key set, currency quotes and other AlphaVantage based quotes won't 
work.
Found Finance::Quote version 1.64.
Finance::Quote sources:
aex  alphavantage  amfiindiaasegrasx
aufunds  australiabamosz   bats bet  bloomberg
borsa_italianabourso   bse  bseindia bvb
canada   comdirectconsorsbank  cse  deka dutch
dwsfunds europe   fetch_live_currencies financeapi
finanzpartner fondsweb fool france   ftfunds
goldmoneygooglewebgreece   hu   hufund   hungary
hustock  indiaindiamutual  known_currencies  marketwatch
morningstarau morningstarch morningstarjp
morningstaruk mstaruk  nasdaq   nseindia nyse
nzx  onvista  oslobors poland   romania  seb_funds
sinvestorsix  stockdatastooqtesouro_direto
tiaacref tmx  tradegatetradeville   treasurydirect
troweprice   troweprice_direct tsp  tsx  twelvedata
ukfunds  unionfunds   usa  xetrayahoo_json   yahoojson
yahooweb za
--8<---cut here---end--->8---

However when I try to actually get some quotes, I get this "error":

--8<---cut here---start->8---
$ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli 
--quotes dump australia CML
* 00:58:05  WARN  [GncFQQuoteSource::set_api_key()] No Alpha 
Vantage API key set, currency quotes and other AlphaVantage based quotes won't 
work.
CML Finance::Quote returned no data and set no error.
--8<---cut here---end--->8---

Which seems weird.  The helper itself appears to work:

--8<---cut here---start->8---
$ echo '{"defaultcurrency": "USD","australia": {"CML": ""}}' | 
/gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/finance-quote-wrapper
 -f
{"australia":{"CML":{"name":"CONNECTED MINERALS 
LIMITED","success":1,"last":0.2,"method":"asx","price":0.2,"type":"","net":0,"errormsg":"","bid":0.18,"symbol":"CML","p_change":"0","volume":1019,"currency":"AUD","exchange":"Australian
 Securities Exchange","ask":0.2}}}
--8<---cut here---end--->8---

When I strace the `gnucash-cli' binary, it seems it does get the JSON
back:

--8<---cut here---start->8---
$ strace -v -s 8192 -- 
/gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli 
--quotes dump australia CML
[..]
read(15, 
"{\"australia\":{\"CML\":{\"errormsg\":\"\",\"price\":0.2,\"net\":0,\"type\":\"\",\"bid\":0.18,\"success\":1,\"volume\":1019,\"name\":\"CONNECTED
 MINERALS 
LIMITED\",\"method\":\"asx\",\"p_change\":\"0\",\"currency\":\"AUD\",\"ask\":0.2,\"last\":0.2,\"symbol\":\"CML\"}}}\n",
 512) = 224
[..]
write(1, "CML Finance::Quote returned no data and set no error.\n", 54CML 
Finance::Quote returned no data and set no error.
) = 54
[..]
--8<---cut here---end--->8---

I am on 5.9 version:

--8<---cut here---start->8---
$ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli 
--version
GnuCash 5.9
Build ID: 5.9+(2024-09-28)
--8<---cut here---end--->8---

Would anyone have some suggestion what might be wrong and how I can fix
this?

Thank you and have a nice day,
Tomas Volf

-- 
There are only two hard things in Computer Science:
cache invalidation, naming things and off-by-one errors.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Need some help please

[Kathleen Whitcomb]

Have been using Gnucash for years without issueand somehow when I
launched it today it is pulling in data from 2022 ...not my current
accounts

I rely on Guncash daily so I really need to find out how I can find my
current file and get that to be the default file when I launch new cash

Thanks for any help ...I am really stuck

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

Re: [GNC] Income earned in gold

[Michael or Penny Novack via gnucash-user]

On 1/2/2025 11:24 AM, Fred Tydeman wrote:

I have an investment in gold (so many ounces).
That investment earns "interest" payable in gold (not USD).
When I try to setup a new Income account,
the only Namespace offered is Currencies.
If I try to add a fake currency of Gold,
I do not get the Currencies Namespace.

I could guess at the price per ounce of gold at that payable date
and record the income as USD.

Any better suggestions?

Consult tax professionals (and/or the IRS). As far as I can tell not YET 
a gnucash question and the same true for other commodities like Bitcoin. 
I would FIRST want to see a ruling about whether this IS income or only 
later (when sold) income/capital gain. The fact that "gold bugs" want 
gold treated as if it were currency doesn't make it so. Legally NOT 
currency in the US for just shy of 100 years.


NOTE:  Seeing it as income (even though a commodity) because you think a 
commodity not subject to increase is lack of imagination. Suppose your 
commodity were 100 cows? << couldn't they have calves? >>


Michael D Novack

PS: IF the IRS says is current income at the then valuation date think 
about a transaction where you BOUGHT that amount of gold, SOLD that 
amount of gold, received that amount as dollars. Do you have 
transactions (when taken together) that have debits and credits to your 
bank account that cancel each other



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

Re: [GNC] Need some help please

[Deva via gnucash-user]

Kathleen,

You will get better responses if you mention your OS and gnucash version. 

That said, macOS has a peculiarity wherein it will only open the last opened 
file regardless of which data file you clicked on. So if you accidentally 
opened a 2022 copy of the data file, then simply go to File->Ooen and open your 
current data file. That should get you back. 

If you don’t have multiple data files, then perhaps your filter is set. Go to 
View->Filter By and check if there’s a date range restriction set to <= 2022. 

Cheers. 
--

From: Kathleen Whitcomb 
To: GNUCASH-USER@gnucash.org
Subject: [GNC] Need some help please
Message-ID:

Content-Type: text/plain; charset="UTF-8"

Have been using Gnucash for years without issueand somehow when I
launched it today it is pulling in data from 2022 ...not my current
accounts

I rely on Guncash daily so I really need to find out how I can find my
current file and get that to be the default file when I launch new cash

Thanks for any help ...I am really stuck

Kathleen

> --

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

Re: [GNC] Income earned in gold

[sunfish62--- via gnucash-user]

Although bitcoin gets handled as a commodity, and not a currency. At least from 
what I understand at this time. 

⁣David T.​

On Jan 2, 2025, 7:42 PM, at 7:42 PM, Derek Atkins  wrote:
>use currency XAU -- that's what it's for.
>
>-derek
>
>On Thu, January 2, 2025 11:24 am, Fred Tydeman wrote:
>> I have an investment in gold (so many ounces).
>> That investment earns "interest" payable in gold (not USD).
>> When I try to setup a new Income account,
>> the only Namespace offered is Currencies.
>> If I try to add a fake currency of Gold,
>> I do not get the Currencies Namespace.
>>
>> I could guess at the price per ounce of gold at that payable date
>> and record the income as USD.
>>
>> Any better suggestions?
>>
>> The same problem will exist for an investment in Bitcoin
>> that earns interest in Bitcoin.
>>
>> I am running GC 5.9 on Fedora Linux 40.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>-- 
>   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
>-
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Income earned in gold

[Jediator]

Sorry this is off topic, but it was President Nixon who got rid of the 
gold standard in the early 70's (not 1930's).  Now we don't have real 
money anymore...


On 1/2/25 4:40 PM, Michael or Penny Novack via gnucash-user wrote:

On 1/2/2025 3:14 PM, Derek Atkins wrote:

Bitcoin isn't technically a currency.
-derek

Neither, in the US, is gold. Back in the 1930's when we went off "the 
gold standard" it became illegal to contractually require payment in 
gold. Existing contracts had that part declared null and void. LOL, as 
late as 1978 I encountered a rental contract with very old "boiler 
plate". As I crossed "in gold" substituting "in legal currency of the 
US" I pointed out that was ILLEGAL to require payment in gold.


Michael D Novack


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


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

Re: [GNC] Income earned in gold

[Michael or Penny Novack via gnucash-user]

On 1/2/2025 3:14 PM, Derek Atkins wrote:

Bitcoin isn't technically a currency.
-derek

Neither, in the US, is gold. Back in the 1930's when we went off "the 
gold standard" it became illegal to contractually require payment in 
gold. Existing contracts had that part declared null and void. LOL, as 
late as 1978 I encountered a rental contract with very old "boiler 
plate". As I crossed "in gold" substituting "in legal currency of the 
US" I pointed out that was ILLEGAL to require payment in gold.


Michael D Novack


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

Re: [GNC] Need some help please

[David H]

Have you got any filtering active ???  Did you open an old backup file ???

Cheers David H.

On Fri, 3 Jan 2025 at 12:53, Kathleen Whitcomb 
wrote:

> Have been using Gnucash for years without issueand somehow when I
> launched it today it is pulling in data from 2022 ...not my current
> accounts
>
> I rely on Guncash daily so I really need to find out how I can find my
> current file and get that to be the default file when I launch new cash
>
> Thanks for any help ...I am really stuck
>
> Kathleen
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problem getting Finance::Quote working

[David H]

Have you setup your Alpha Vantage API key the output warns you about ?
Preferences >> Online Quotes -
https://wiki.gnucash.org/wiki/Online_Quotes#Alphavantage

 00:58:05  WARN  [GncFQQuoteSource::set_api_key()] No
Alpha Vantage API key set, currency quotes and other AlphaVantage based
quotes won't work

Cheers David H.


On Fri, 3 Jan 2025 at 12:51, Tomas Volf <~@wolfsden.cz> wrote:

> Hello,
>
> Today I installed gnucash and am trying to get fetch quotes from the
> internet, and I am having troubles getting it to work.  I am not
> subscribed, so please CC.
>
> When I try the `gnucash-cli --quotes info', it seems to work:
>
> --8<---cut here---start->8---
> $ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli
> --quotes info
> * 00:56:27  WARN  [GncFQQuoteSource::set_api_key()] No
> Alpha Vantage API key set, currency quotes and other AlphaVantage based
> quotes won't work.
> Found Finance::Quote version 1.64.
> Finance::Quote sources:
> aex  alphavantage  amfiindiaasegrasx
> aufunds  australiabamosz   bats bet  bloomberg
> borsa_italianabourso   bse  bseindia bvb
> canada   comdirectconsorsbank  cse  deka dutch
> dwsfunds europe   fetch_live_currencies financeapi
> finanzpartner fondsweb fool france   ftfunds
> goldmoneygooglewebgreece   hu   hufund   hungary
> hustock  indiaindiamutual  known_currencies
> marketwatch
> morningstarau morningstarch morningstarjp
> morningstaruk mstaruk  nasdaq   nseindia nyse
> nzx  onvista  oslobors poland   romania  seb_funds
> sinvestorsix  stockdatastooqtesouro_direto
> tiaacref tmx  tradegatetradeville   treasurydirect
> troweprice   troweprice_direct tsp  tsx  twelvedata
> ukfunds  unionfunds   usa  xetrayahoo_json   yahoojson
> yahooweb za
> --8<---cut here---end--->8---
>
> However when I try to actually get some quotes, I get this "error":
>
> --8<---cut here---start->8---
> $ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli
> --quotes dump australia CML
> * 00:58:05  WARN  [GncFQQuoteSource::set_api_key()] No
> Alpha Vantage API key set, currency quotes and other AlphaVantage based
> quotes won't work.
> CML Finance::Quote returned no data and set no error.
> --8<---cut here---end--->8---
>
> Which seems weird.  The helper itself appears to work:
>
> --8<---cut here---start->8---
> $ echo '{"defaultcurrency": "USD","australia": {"CML": ""}}' |
> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/finance-quote-wrapper
> -f
> {"australia":{"CML":{"name":"CONNECTED MINERALS
> LIMITED","success":1,"last":0.2,"method":"asx","price":0.2,"type":"","net":0,"errormsg":"","bid":0.18,"symbol":"CML","p_change":"0","volume":1019,"currency":"AUD","exchange":"Australian
> Securities Exchange","ask":0.2}}}
> --8<---cut here---end--->8---
>
> When I strace the `gnucash-cli' binary, it seems it does get the JSON
> back:
>
> --8<---cut here---start->8---
> $ strace -v -s 8192 --
> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli
> --quotes dump australia CML
> [..]
> read(15,
> "{\"australia\":{\"CML\":{\"errormsg\":\"\",\"price\":0.2,\"net\":0,\"type\":\"\",\"bid\":0.18,\"success\":1,\"volume\":1019,\"name\":\"CONNECTED
> MINERALS
> LIMITED\",\"method\":\"asx\",\"p_change\":\"0\",\"currency\":\"AUD\",\"ask\":0.2,\"last\":0.2,\"symbol\":\"CML\"}}}\n",
> 512) = 224
> [..]
> write(1, "CML Finance::Quote returned no data and set no error.\n", 54CML
> Finance::Quote returned no data and set no error.
> ) = 54
> [..]
> --8<---cut here---end--->8---
>
> I am on 5.9 version:
>
> --8<---cut here---start->8---
> $ /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cli
> --version
> GnuCash 5.9
> Build ID: 5.9+(2024-09-28)
> --8<---cut here---end--->8---
>
> Would anyone have some suggestion what might be wrong and how I can fix
> this?
>
> Thank you and have a nice day,
> Tomas Volf
>
> --
> There are only two hard things in Computer Science:
> cache invalidation, naming things and off-by-one errors.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by us

Re: [GNC] Doing Payroll in Gnucash

[Jediator]

Thanks for all your responses.  I guess creating a script seems to be 
the answer to automate payroll in GNC.  Are you using the C/C++ APIs in 
GNC?  Do you have to compile your code for each release? Would it be 
more easier doing that in Python using Python-binding APIs?  Thanks!



On 1/1/25 7:00 PM, R. Victor Klassen wrote:

I have a rather jurisdiction-specific perl script that I run on a csv file that 
captures the employees time sheet information.

And on top of that I have a piece of C++ code that does the necessary queries 
to get the year-to-date information needed in calculating the deductions, and 
spits out a second .csv file that is read by the above perl script.  The C++ 
code is subject to the possibility of breaking at a major release of GnuCash, 
but hasn’t so far (if the sqlite schema changes, it will break for sure).

So yes it can be done.  I won’t say it’s all that easy.  But without buying 
something or outsourcing it I know of no other way to get payroll right in our 
jurisdiction (Ontario, Canada, specific to rules that apply to farm workers).


I’m surprised Glenn doesn’t also have to deal with Social Security deductions.  
Here we have EI, CPP, and the two taxes.  I thought I recalled when in the US 
having MC and some other kind of Social Security deduction.


On Jan 1, 2025, at 12:39 PM, Glenn Fowler  wrote:

Hi ND,

What I do is payroll in Quickbooks Payroll Core which is just payroll only and 
then I just manually add the 3 transactions into GnuCash (payroll check, 
federal taxes, and state taxes).


From: gnucash-user  on behalf 
of Jediator 
Sent: Wednesday, January 1, 2025 12:31 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Doing Payroll in Gnucash

Happy New Year everyone!  Anyone using Gnucash for doing Payroll? I'd
like to know the pros-and-cons of using GNC for payroll processing.  Thanks!

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


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

Re: [GNC] Income earned in gold

[Derek Atkins]

Bitcoin isn't technically a currency.
-derek

On Thu, January 2, 2025 3:10 pm, sunfis...@yahoo.com wrote:
> Although bitcoin gets handled as a commodity, and not a currency. At least
> from what I understand at this time.
>
> ⁣David T.​
>
> On Jan 2, 2025, 7:42 PM, at 7:42 PM, Derek Atkins  wrote:
>>use currency XAU -- that's what it's for.
>>
>>-derek
>>
>>On Thu, January 2, 2025 11:24 am, Fred Tydeman wrote:
>>> I have an investment in gold (so many ounces).
>>> That investment earns "interest" payable in gold (not USD).
>>> When I try to setup a new Income account,
>>> the only Namespace offered is Currencies.
>>> If I try to add a fake currency of Gold,
>>> I do not get the Currencies Namespace.
>>>
>>> I could guess at the price per ounce of gold at that payable date
>>> and record the income as USD.
>>>
>>> Any better suggestions?
>>>
>>> The same problem will exist for an investment in Bitcoin
>>> that earns interest in Bitcoin.
>>>
>>> I am running GC 5.9 on Fedora Linux 40.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>>--
>>   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
>>-
>>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need some help please

[Murugan Mariappan]

Check the folder where you store the files to see the timestamp on the files. 
Pick the last but one backup file and open using file open from the 
application. Check if this is the one you need, if so you can rename it to a 
easily readable one, like attaching the year so you dont get to confuse with 
old archive files





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Kathleen Whitcomb 
Sent: 01 January 2025 22:51
To: GNUCASH-USER@gnucash.org 
Subject: [GNC] Need some help please

Have been using Gnucash for years without issueand somehow when I
launched it today it is pulling in data from 2022 ...not my current
accounts

I rely on Guncash daily so I really need to find out how I can find my
current file and get that to be the default file when I launch new cash

Thanks for any help ...I am really stuck

Kathleen
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7Cf89d21abf1e94af10e1308dd2ba1d011%7C84df9e7fe9f640afb435%7C1%7C0%7C638714696189249580%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=T2hCzz57Z%2BOafOTVu9%2FC%2F9a5RJldTmYDhT%2FQu8C8UQM%3D&reserved=0
-
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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Need some help please

[David Carlson]

Kathleen,

Y ou did not mention which version of GnuCash you are using or your
computer's operating system.  Sometimes that makes a difference.

In any case, a little trick that  recentlyI learned is to click on File,
then hover the curser over the names of the recently used filenames.  The
full path and filename appear in the bottom of the window.  This will tell
you where those files are located so that you can see which ones you have
recently used and where they are located.



On Thu, Jan 2, 2025 at 9:07 PM Murugan Mariappan 
wrote:

> Check the folder where you store the files to see the timestamp on the
> files. Pick the last but one backup file and open using file open from the
> application. Check if this is the one you need, if so you can rename it to
> a easily readable one, like attaching the year so you dont get to confuse
> with old archive files
>
>
>
>
>
> Saludos Cordiales
>
>
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of Kathleen Whitcomb <
> kwhitcom...@gmail.com>
> Sent: 01 January 2025 22:51
> To: GNUCASH-USER@gnucash.org 
> Subject: [GNC] Need some help please
>
> Have been using Gnucash for years without issueand somehow when I
> launched it today it is pulling in data from 2022 ...not my current
> accounts
>
> I rely on Guncash daily so I really need to find out how I can find my
> current file and get that to be the default file when I launch new cash
>
> Thanks for any help ...I am really stuck
>
> Kathleen
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
>
> https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7Cf89d21abf1e94af10e1308dd2ba1d011%7C84df9e7fe9f640afb435%7C1%7C0%7C638714696189249580%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=T2hCzz57Z%2BOafOTVu9%2FC%2F9a5RJldTmYDhT%2FQu8C8UQM%3D&reserved=0
> 
> -
> 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
> -
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] previous issue with gnucash-cli on macOS

[gnucash]

Is solved!!

Note the command I am using does not have the "file:" in it, because it 
fails when that is included.


Thanks to everybody involved.

Ken





On 12/31/24 9:08 PM, gnuc...@kcburns.com wrote:

Jim DeLaHunt, I think you have a BINGO!


Last login: Tue Dec 31 15:47:12 on ttys000
kcburns@Mac001 ~ % /Applications/GnuCash.app/Contents/MacOS/gnucash-cli 
-Q get /Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Found Finance::Quote version 1.64.
kcburns@Mac001 ~ %


That is the result I expected to see!

I think I was had by the copy & paste.

I have already updated my quotes for this evening, so I will verify it 
on Thursday after the market reopens.


Thanks,

Ken


On 12/31/24 4:45 PM, gnucash-user-requ...@gnucash.org wrote:

Hello, KCBurns:

On 2024-12-31 12:52,gnuc...@kcburns.com wrote:

Last login: Tue Dec 31 15:24:15 on console
kcburns@Mac001 ~ %
/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get
/Users/kcburns/GnuCash/KCBurns.gnucash

Application Path /Applications/GnuCash.app/Contents/MacOS/gnucash-cli
Missing data file parameter

gnucash-cli [options] [datafile] - GnuCash, accounting for personal
and small business finance:

... [help text elided] ...


? --output-file arg? Output file for report


zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash
kcburns@Mac001 ~ %


It looks like your command is now spelled correctly, but it is broken
into two lines in the email message.? Is that just an artifact of email
line wrapping, or is there in fact a linefeed character in your command
line?

I see that Gnucash says, "Missing data file parameter", as if all it saw
was "/App?/gnucash-cli -Q get". Then the Terminal shell ("zsh") says,
"zsh: exec format error: /Users/kcburns/GnuCash/KCBurns.gnucash", as if
it was trying to run "/Users/kcburns/GnuCash/KCBurns.gnucash" as a command.

Perhaps try to enter the command again, but being careful of the
spelling and spacing?

e.g. Copy "/Applications/GnuCash.app/Contents/MacOS/gnucash-cli -Q get"
from your previous command, then type a space character, then copy
"/Users/kcburns/GnuCash/KCBurns.gnucash" from your previous command,
then press Return. See if that gets interpreted as a single command.



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

Re: [GNC] Doing Payroll in Gnucash

[Brad Morrison]

Hi Jediatior/ND & GnuCash users, 

https://gnucash.org/docs/v5/C/gnucash-guide/bus_payroll.html - it looks
like GnuCash has a guide that covers this payroll topic. 

---
Thanks, 

Brad - https://www.facebook.com/brad.morrison.12327/ &
https://norcal.social/@BradMorrison 

On 2025-01-02 07:40, Jediator wrote:

> Thanks for all your responses.  I guess creating a script seems to be the 
> answer to automate payroll in GNC.  Are you using the C/C++ APIs in GNC?  Do 
> you have to compile your code for each release? Would it be more easier doing 
> that in Python using Python-binding APIs?  Thanks!
> 
> On 1/1/25 7:00 PM, R. Victor Klassen wrote: I have a rather 
> jurisdiction-specific perl script that I run on a csv file that captures the 
> employees time sheet information.
> 
> And on top of that I have a piece of C++ code that does the necessary queries 
> to get the year-to-date information needed in calculating the deductions, and 
> spits out a second .csv file that is read by the above perl script.  The C++ 
> code is subject to the possibility of breaking at a major release of GnuCash, 
> but hasn't so far (if the sqlite schema changes, it will break for sure).
> 
> So yes it can be done.  I won't say it's all that easy.  But without buying 
> something or outsourcing it I know of no other way to get payroll right in 
> our jurisdiction (Ontario, Canada, specific to rules that apply to farm 
> workers).
> 
> I'm surprised Glenn doesn't also have to deal with Social Security 
> deductions.  Here we have EI, CPP, and the two taxes.  I thought I recalled 
> when in the US having MC and some other kind of Social Security deduction.
> 
> On Jan 1, 2025, at 12:39 PM, Glenn Fowler  wrote:
> 
> Hi ND,
> 
> What I do is payroll in Quickbooks Payroll Core which is just payroll only 
> and then I just manually add the 3 transactions into GnuCash (payroll check, 
> federal taxes, and state taxes).
> 
> 
> From: gnucash-user  on 
> behalf of Jediator 
> Sent: Wednesday, January 1, 2025 12:31 PM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Doing Payroll in Gnucash
> 
> Happy New Year everyone!  Anyone using Gnucash for doing Payroll? I'd
> like to know the pros-and-cons of using GNC for payroll processing.  Thanks!
> 
> ND
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Income earned in gold

[Fred Tydeman]

I have an investment in gold (so many ounces).
That investment earns "interest" payable in gold (not USD).
When I try to setup a new Income account,
the only Namespace offered is Currencies.
If I try to add a fake currency of Gold,
I do not get the Currencies Namespace.

I could guess at the price per ounce of gold at that payable date
and record the income as USD.

Any better suggestions?

The same problem will exist for an investment in Bitcoin
that earns interest in Bitcoin.

I am running GC 5.9 on Fedora Linux 40.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Income earned in gold

[Derek Atkins]

use currency XAU -- that's what it's for.

-derek

On Thu, January 2, 2025 11:24 am, Fred Tydeman wrote:
> I have an investment in gold (so many ounces).
> That investment earns "interest" payable in gold (not USD).
> When I try to setup a new Income account,
> the only Namespace offered is Currencies.
> If I try to add a fake currency of Gold,
> I do not get the Currencies Namespace.
>
> I could guess at the price per ounce of gold at that payable date
> and record the income as USD.
>
> Any better suggestions?
>
> The same problem will exist for an investment in Bitcoin
> that earns interest in Bitcoin.
>
> I am running GC 5.9 on Fedora Linux 40.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
   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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.