Re: [GNC] Hamster integration

[David Cousens]

Macho,

The Gnucash CSV importer has a setup section where you can select the separator
character. One of the defaults is tab separation as well as comma and I think
space. You can define any character as the seaparator if you want.

There is a step in which you attach column headers (internal to GnuCash data
designation) and assign them to the columns in the imported data. The help file
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html has detail on
the CSV importing process.  Have no idea what Hamster 's format is but you
should be able to work it out from the above.

David Cousens

On Wed, 2023-10-11 at 21:38 -0400, Macho Philipovich wrote:
> Dear all,
> 
> I want to autogenerate GnuCash invoices from customer-work-hours 
> previously tracked using the Gnome Time Tracker (aka Project Hamster).
> 
> Hamster allows TSV export, GnuCash allows CSV invoice import, so I 
> assume it's just a matter of writing a script to massage Hamster TSV 
> output into appropriate GnuCash CSV input.
> 
> My questions:
> 
>  1. Has anyone else already done this?
>  2. If not, would it be of any use to share my work, or this just too niche?
>  3. If it would be of some use, where and how should it be shared?
> 
> (Please copy me on replies because I'm not subscribed to this list.)
> 
> Thanks,
> 
> Macho
> ___
> 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] Closest to report date bug?

[Marta Neeziak]

Thank you, this is good to know.

Unfortunately, the "Last up through report date" is not what I'm looking
for since it only shows one price across the whole report period (graph
scales up/down by units/shares, not price)...

Is there anyway for me to manually change the report time zone or price
data time zone? I don't think that this was a good change, at all, since
there is now a clear disconnect between what people will expect to see on
their screens vs. what is happening on the back end w/ time zones.

Would appreciate any support in helping me get this resolved on either my
machine (manually) or a fix globally in a new version.

Thanks again.

On Wed, Oct 11, 2023 at 8:35 PM john  wrote:

>
>
> > On Oct 11, 2023, at 09:17, Marta Neeziak  wrote:
> >
> > Not sure what's going on here - but I updated to 5.4 last week and have
> > since had issues with generating graphs that use "Closest to report date"
> > for price data.
> >
> > Basically, when I have the price of an asset and I try to graph it - it
> > graphs the asset using the following day's price data. Example: A stock
> is
> > worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
> > price of $20 on Day1 and $10 on all other days. I spun up a new db to
> test
> > this, and can't seem to figure it out...
> > Results: https://imgur.com/a/fjmwnHc
> >
> > If anyone has any idea as to what's going on and how to fix this, I'd
> > really appreciate it. Thank you.
>
> It's because the report time is midnight local and the quote time is  now
> neutral time (10:59 UTC) so that the price will have the same date in all
> timezones. Unless your time zone is east of UTC+2 (Central European
> Standard Time) 10:59Z the next day is closer to midnight than 10:59Z today.
> Use "Last up through report date" to align the prices the way you want.
>
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Hamster integration

[Macho Philipovich]

Dear all,

I want to autogenerate GnuCash invoices from customer-work-hours 
previously tracked using the Gnome Time Tracker (aka Project Hamster).


Hamster allows TSV export, GnuCash allows CSV invoice import, so I 
assume it's just a matter of writing a script to massage Hamster TSV 
output into appropriate GnuCash CSV input.


My questions:

1. Has anyone else already done this?
2. If not, would it be of any use to share my work, or this just too niche?
3. If it would be of some use, where and how should it be shared?

(Please copy me on replies because I'm not subscribed to this list.)

Thanks,

Macho
___
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] macOS Sonoma "Gnucash is damaged and can’t be opened" error

[Vincent Lucarelli]

I downloaded the image directly from the link on the gnucash.org 
 homepage.

I did try to run the fq updater from the command line before double clicking 
the Gnucash.app - could that have caused the whole app to be marked with 
quarantine?

Vince

> On Oct 10, 2023, at 11:01 PM, john  wrote:
> 
> 
> 
>> On Oct 10, 2023, at 05:05, Vincent Lucarelli  
>> wrote:
>> 
>> Hi,
>> 
>> I upgraded an Intel Mac to macOS Sonoma and downloaded Gnucash 5.4.  When I 
>> tried to run it, I got the error "Gnucash is damaged and can’t be opened.”
>> 
>> In previous OS versions, there was an error about untrusted developer and in 
>> System Settings you could approve running the application. System Settings 
>> has been reorganized and I could not find anywhere to approve Gnucash.
>> 
>> In the terminal, I ran
>> 
>> xattr -rds com.apple.quarantine /Applications/Gnucash.app
>> 
>> and then has to launch Gnucash twice for it to finally run.
> 
> That's interesting: If you're getting GnuCash.app from us you shouldn't be 
> getting untrusted developer warnings: It's signed with an Apple developer 
> certificate and notarized by their automated checking system. Homebrew just 
> "bottles" our dmg, so there shouldn't be any problem if you go that route 
> either.
> 
> 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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Closest to report date bug?

[john]

> On Oct 11, 2023, at 09:17, Marta Neeziak  wrote:
> 
> Not sure what's going on here - but I updated to 5.4 last week and have
> since had issues with generating graphs that use "Closest to report date"
> for price data.
> 
> Basically, when I have the price of an asset and I try to graph it - it
> graphs the asset using the following day's price data. Example: A stock is
> worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
> price of $20 on Day1 and $10 on all other days. I spun up a new db to test
> this, and can't seem to figure it out...
> Results: https://imgur.com/a/fjmwnHc
> 
> If anyone has any idea as to what's going on and how to fix this, I'd
> really appreciate it. Thank you.

It's because the report time is midnight local and the quote time is  now 
neutral time (10:59 UTC) so that the price will have the same date in all 
timezones. Unless your time zone is east of UTC+2 (Central European Standard 
Time) 10:59Z the next day is closer to midnight than 10:59Z today. Use "Last up 
through report date" to align the prices the way you want.

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

Re: [GNC] Help

[Kalpesh Patel]

Just to recap what is being asked ... the basics are as follows (which are 
likely covered somewhere in the fine manual):

1A) On Windows, there are steps that you need to take to install Perl and 
Finance::Quote module:
- Click on the search (the magnifying glass) and type in 'Install Online Price 
Retrieval for GnuCash' and click on it.
- Wait some time (might want to get some refreshment while batch script does 
its magic)

OR

1B) On Linux, there are steps that you need to take to install 
Finance::Quote module:
- Open up your favorite shell console, whether sh, csh, zsh, bash or any choice 
of yours
- Run following command (this assume your CPAN is configured correctly - accept 
defaults when running it for the first time): perl -MCPAN -e 'install 
Finance::Quote'
- Wait some time (might want to get some refreshment while Perl does its magic)

2)  Define the security in GNUCASH: 
- On the main window of GNUCASH, click 'Tools' menu and select 'Security 
Editor' from that dropdown
- Click 'Add' button on the lower right corner on the 'Securities' window
- Type in 'Full Name' field (Example: Bank of New York Mellon Corp) in the 'New 
security' window
- Type in 'Symbol/abbreviation' field (Example: BK) in the 'New security' 
window 
- Type in 'Display symbol' field (Example: BK) in the 'New security' window
- Type in 'Namespace' field (Example: NYSE) in the 'New security' window
- Leave blank in 'ISIN, CUSIP or other code' field in the 'New security' window
- Leave 'Fraction traded 1/' field to read '1' in the 'New security' window

- Put a check mark on the 'Get Online Quotes' box by clicking on the box once 
that is in front of it.

- Under 'Type of quote source', click in front of 'Single' circle to select it. 
On the right side of it (which should read 'Alphavantage, US'), click on the 
arrow, scroll all the way down and select 'Yahoo as JSON'.

- Click 'OK' button in the 'New security' window.
- Click 'Close' button in the 'Securities' window.

3)  Retrieve online quotes:
- On the main window of GNUCASH, click 'Tools' menu and select 'Price Database' 
from that dropdown
- Click the arrow in front of the name space (Example from above: NYSE) and you 
should see your security there (Example from above: BK) in the 'Price Database' 
window
- Click the arrow in front of the security (Example from above: BK) and you 
should see no pricing in this newly created security
- Click 'Get Quotes' on the right side of the 'Price Database' window
- Wait some time (might want to get some refreshment while GNUCASH does its 
magic)
- When you get control back, a new line will be added which will be the price 
that GNUCASH retrieved via Perl's Finance::Quote module
- Celebrate success





-Original Message-
From: R Losey  
Sent: Tuesday, October 10, 2023 3:00 PM
To: Murugan Muruganandam 
Cc: gnucash-user@gnucash.org; James Baxter 
Subject: Re: [GNC] Help

To add to Murugan's advice:

What have you done? Have you set up the quotes to get them online? If you're 
not on Linux, you need to install other parts to get online quotes.

Enlighten the list, and you will receive help.

On Tue, Oct 10, 2023 at 6:47 AM Murugan Muruganandam < 
m.muruganan...@hotmail.com> wrote:

> James
>
> you need to give more details on your request, including version of 
> GNU and online quote, operating system and what ticker you aren ot 
> getting quote for.
>
>
> Saludos Cordiales
> Murugan
>
> 
> From: gnucash-user  hotmail@gnucash.org> on behalf of James Baxter via gnucash-user < 
> gnucash-user@gnucash.org>
> Sent: Monday, October 9, 2023 11:40 AM
> To: gnucash-user@gnucash.org 
> Subject: [GNC] Help
>
> This is James Baxter.I am writing email asking for help with the 
> import of stock/tickers from the web to Gnucash.
> I am not getting anything on this,
>
> WhyJames baxterkangaro...@yahoo.com
> ___
>
--
_
Richard Losey
rlo...@gmail.com
Micah 6:8


___
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] Tax report for India

[Adrien Monteleone]

It sounds like you created an account structure to separate taxable 
transactions, 'artificially'. (that is, you might have taxable and 
non-taxable version of the same account)


In that case, you don't run the Tax Report at all. (yes, it is only for USD)

Run a Transaction Report for those 'taxable' accounts.

If you are still not quite getting what you need from there, let us know 
as that report is quite powerful and flexible.


*note, in this case, it should also be possible to not need the use of 
distinct taxable accounts just for reporting purposes. You can include 
(say in the Notes field or Memo fields) your own 'tag' such as 
"taxable", "#taxable", or "@taxable" and the Transaction Report can 
filter for transactions based on that text. Use any text label for the 
tag you like, with or without a delimiter. (your filter for the report 
will simply work on whatever matching text you provide)


There is also a 'tag' based Transaction Report a user has created, and 
while I haven't tried it, the built-in facilities should do what you need.


Regards,
Adrien

On 10/11/23 11:27 AM, Paras Desai wrote:

Hello friends

I was trying to find work around for getting summary of taxable income at the 
end if financial year end. I tried following

1. I put In discerption field as "TAX" while creating different income accounts 
for incomes which are taxable (like salary, capital gain, interest, annuity etc)
2. So practically, while posting income, I seperate them out as taxable and non 
taxable
3. I also selected "Tax" in tax report for such accounts though it is for USA, 
but just to identify such income
  as taxable
4. When I run tax report all report generated with INR value in peranrhesis as 
part of text, and income as 0, because it took currency as USD.
5. I tried to run account summary / transaction report with filter word  as 
Tax, but could not generate desired report.

Is there any good and efficient way to achieve my above mentioned objective?


___
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] macOS Sonoma "Gnucash is damaged and can’t be opened" error

[Adrien Monteleone]

I thought Rosetta was included in this transition. (unlike the previous 
move from Power to Intel, where it had to be installed separately)


Regards,
Adrien

On 10/11/23 10:08 AM, R Losey wrote:

I thought that  for an M1 or M2 Mac, you need to have the Rosetta app to
allow Intel-based applications to run (such as GnuCash). Do you have that
installed?

I've never had any problems running GnuCash on my M1 iMac, but I'm still
running Ventura.



___
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] Tax report for India

[Paras Desai]

Hello friends

I was trying to find work around for getting summary of taxable income at the 
end if financial year end. I tried following

1. I put In discerption field as "TAX" while creating different income accounts 
for incomes which are taxable (like salary, capital gain, interest, annuity etc)
2. So practically, while posting income, I seperate them out as taxable and non 
taxable
3. I also selected "Tax" in tax report for such accounts though it is for USA, 
but just to identify such income
 as taxable
4. When I run tax report all report generated with INR value in peranrhesis as 
part of text, and income as 0, because it took currency as USD.
5. I tried to run account summary / transaction report with filter word  as 
Tax, but could not generate desired report.

Is there any good and efficient way to achieve my above mentioned objective?

Thank you in advance for your kind attention

With best regards
Paras

___
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] Closest to report date bug?

[Marta Neeziak]

Not sure what's going on here - but I updated to 5.4 last week and have
since had issues with generating graphs that use "Closest to report date"
for price data.

Basically, when I have the price of an asset and I try to graph it - it
graphs the asset using the following day's price data. Example: A stock is
worth $10 Day0, $10 Day1, $20 Day2, and $10 Day3 - GNUCash will display a
price of $20 on Day1 and $10 on all other days. I spun up a new db to test
this, and can't seem to figure it out...
Results: https://imgur.com/a/fjmwnHc

If anyone has any idea as to what's going on and how to fix this, I'd
really appreciate it. Thank you.
___
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] macOS Sonoma "Gnucash is damaged and can’t be opened" error

[R Losey]

On Tue, Oct 10, 2023 at 9:11 PM Vincent Lucarelli <
vincent.lucare...@gmail.com> wrote:

> Hi,
>
> I upgraded an Intel Mac to macOS Sonoma and downloaded Gnucash 5.4.  When
> I tried to run it, I got the error "Gnucash is damaged and can’t be opened.”
>
> In previous OS versions, there was an error about untrusted developer and
> in System Settings you could approve running the application. System
> Settings has been reorganized and I could not find anywhere to approve
> Gnucash.
>
> In the terminal, I ran
>
>   xattr -rds com.apple.quarantine /Applications/Gnucash.app
>
> and then has to launch Gnucash twice for it to finally run.
>


I thought that  for an M1 or M2 Mac, you need to have the Rosetta app to
allow Intel-based applications to run (such as GnuCash). Do you have that
installed?

I've never had any problems running GnuCash on my M1 iMac, but I'm still
running Ventura.

-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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] columns

[R Losey]

On Tue, Oct 10, 2023 at 9:09 PM Jose Fuenzalida 
wrote:

> I just learnt that I can add more columns to the account page by clicking
> on
> the triangle on the right top of the account page, is there a way to rename
> any column and how do I access the info if I need to change it .
>
> As far as I know, the columns represent summary information, and you
shouldn't want to change the data (other than by changing the data that
makes it up). For example, "Last Reconciliation Date" (or whatever it's
actually called) shows when you last reconciled an account. It changes when
you reconcile an account.

I don't know of any way to rename the columns, but they are pretty clear to
me.
-- 
_
Richard Losey
rlo...@gmail.com
Micah 6:8
___
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.