Re: [GNC] Finance-Quote 1.60 released!
> On Apr 17, 2024, at 20:25, David G. Pickett via gnucash-user > wrote: > > Will there be a flatpak release? No hurry, as yahoo fetching is still off > the rails. So many web pages one can scrape the price off of! Not on flat hub, but the nightly builds at https://code.gnucash.org/builds/flatpak/stable have 1.60 starting today. 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] Finance-Quote 1.60 released!
Will there be a flatpak release? No hurry, as yahoo fetching is still off the rails. So many web pages one can scrape the price off of! ___ 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] What account name do you use to record the apartment/house expenses related to the building?
https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111588.html Michael or Penny Novack wrote: > I don't think you are picturing what I meant by both ways. Yes, it is very clear but given my experience with other financial software I don't agree endlessly dividing the COAs into unknown future categories is a useful approach. Multidimensional accounting is a method of organizing financial data that goes beyond the traditional chart of accounts. It involves using dimensions, such as departments, locations, or projects, to categorize transactions and provide more detailed and operationally relevant reporting. This approach eliminates the need for complex account codes, making the general ledger easier to use and reducing errors and delays. The multidimensional chart of accounts (COA) is an account numbering system that has multiple segments defined within an account structure. These segments, or dimensions, enable tracking and reporting at a greater level of detail. This type of COA is typically used by larger organizations that need to track their financial transactions from more than one identifier within the general ledger. In summary, multidimensional accounting offers a flexible and powerful way to track and report on your business, providing more detailed and operationally relevant information than traditional accounting methods. Note: AI-generated answer. Please verify critical facts. Thank you to Vincent Dawans for a workable implementation in GnuCash demonstrated at https://github.com/dawansv/gnucash-custom-reports?tab=readme-ov-file#tag-prefix https://lists.gnucash.org/pipermail/gnucash-user/2024-April/111596.html Michael or Penny Novack wrote: > a) Accounts of type "expense" and accounts of type "income" are really the > same type of temporary account of fundamental type equity... They really > differ just in the sense of their normal balance, debit for expenses and > credit for income. We get the top level types "income" and "expense" only > so that we do NOT have to specify them for the P&L. We have a different reading list but that is a useful concept to understand. 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 - 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 account name do you use to record the apartment/house expenses related to the building?
On Wed, Apr 17, 2024 at 4:09 PM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > > If the events are fixed, such as "Memorial Day Celebration" and > "Independence Celebration", you could make an expense category and then > have sub-categories for it. I assume that you can run P&L on one set of > categories. Would that work? You'd have similar sub-categories. I'm pretty > sure you could get a breakdown for the events, but if you also want a total > (for example) "postage" from each category, I'm not sure how to do that, > especially if you want all the sub-categories summarized. Perhaps > exporting to a spreadsheet and creating a pivot table? (or something along > those lines?) > > _ > Richard Losey > rlo...@gmail.com > Micah 6:8 > > d) But WHAT is this "category: business? Why are you (still?) talking > about categories.If you mean account, say account. We're doing standard > double entry bookkeeping here. > > Michael D Novack > > Noted: sub-account... in my mind, I was thinking of categorizing expenses, and the "category" came to mind. You're right, of course. -- _ 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] Help with setting up stock price updates
cpanm Finance::Quotego to gnucash\binperl gnc-fq-update might have to uninstall finance quote if problemscpanm --uninstall Finance::Quote On Wednesday, April 17, 2024 at 03:10:48 PM GMT-7, Anna Scott wrote: Hello all … I’m advancing beyond basics for the first time and am stuck trying to create a new security in pricing editor - under “Quote Source Information” it gives error message that “Warning: Finance: Quote not installed properly”. I’ve seen other references to this as a bug … but don’t know if it’s been resolved? I’m using GNUCASH 5.3 on a MAC with Sonoma 14.0 . Id appreciate any and all help! Thanks in advance, A ___ 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] Help with setting up stock price updates
Hello all … I’m advancing beyond basics for the first time and am stuck trying to create a new security in pricing editor - under “Quote Source Information” it gives error message that “Warning: Finance: Quote not installed properly”. I’ve seen other references to this as a bug … but don’t know if it’s been resolved? I’m using GNUCASH 5.3 on a MAC with Sonoma 14.0 . Id appreciate any and all help! Thanks in advance, A ___ 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] What account name do you use to record the apartment/house expenses related to the building?
If the events are fixed, such as "Memorial Day Celebration" and "Independence Celebration", you could make an expense category and then have sub-categories for it. I assume that you can run P&L on one set of categories. Would that work? You'd have similar sub-categories. I'm pretty sure you could get a breakdown for the events, but if you also want a total (for example) "postage" from each category, I'm not sure how to do that, especially if you want all the sub-categories summarized. Perhaps exporting to a spreadsheet and creating a pivot table? (or something along those lines?) _ Richard Losey rlo...@gmail.com Micah 6:8 a) Accounts of type "expense" and accounts of type "income" are really the same type of temporary account of fundamental type equity. If you know the historical development of double entry bookkeeping over the last several hundred years you will know where they came from. They really differ just in the sense of their normal balance, debit for expenses and credit for income. We get the top level types "income" and "expense" only so that we do NOT have to specify them for the P&L. b) That means we can create the subtree for an event EITHER under income or expense and put all children of this event there whether they are "really" income or expense. The "wrong" ones are simply contra in sense. A debit balance account of type income is a "negative" income, that is, an expense. c) Assuming we consistently made all the printing and postage accounts the same (all expense) we can produce a report showing all of them. Surely you can picture and income and expense report where JUST some expense accounts were included. Don't have to export to a spreadsheet. BUT the latter is exactly what I would do in practice. You have run the FULL P&L (all accounts) and exported it and opened as a spreadsheet. Now say you want just a few accounts. COPY the spreadsheet giving it a name like "Printing and Postage" and then delete everything but the accounts for printing and postage and the spreadsheet will total those for you. Do the same for whatever else you need, say each event by itself, say all of the events (but nothing else), say the events each without it printing and postage (if you have ever done a 990/990EZ you'll know where that goes depending on whether your events make revenue or are an expense. d) But WHAT is this "category: business? Why are you (still?) talking about categories.If you mean account, say account. We're doing standard double entry bookkeeping here. 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] Finance-Quote 1.60 released!
On 4/17/24 11:57 AM, Kalpesh Patel wrote: You can also save cookies to a file named cookies.txt as follows: #curl -c cookies.txt https://login.yahoo.com -I Some info: The user having issues with YahooJSON that I've been having a discussion with tried the simple curl command. Just *one* cookie is returned from https://login.yahoo.com/. I've tried it on 5 different systems in 3 different places (work, home, a FreeBSD server in NYC I have access to) and curl returns 4 cookies. The user having an issue is in Europe, I believe Spain. Maybe this is a geo based issue? Just guessing. On a side note about the "-I/--head" option to curl. It doesn't happen often but some websites disallow the HEAD fetch method. Which is why I default to using "-i/--include". On a better note (I won't say good), I have identified how to get the YahooWeb and Fool modules to work. Notes are added to the issues (https://github.com/finance-quote/finance-quote/issues/379 and https://github.com/finance-quote/finance-quote/issues/377) if someone wants to work on pull requests to address those before I get a chance to. Thank you. Bruce S ___ 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] What account name do you use to record the apartment/house expenses related to the building?
On Wed, Apr 17, 2024 at 8:44 AM Michael or Penny Novack < stepbystepf...@comcast.net> wrote: > >> d) What you can;t do is have it both ways. Traditional double entry > >> bookkeeping allows only one tree structure for the CoA. To get it > >> different in different reports you would have to BOTH set up the CoA > >> correctly AND select just certain accounts for the report. > > Of course you can by running the report filtered for transactions with or > > without tag(s). (It is an unfortunate term because most searches will > find > > the term used in the context of computer code rather than filtering > > transactions for reports.) > > I don't think you are picturing what I meant by both ways. > > Say doing organizational reporting, and this organization (among its > other activities) conducts several "events" every year. naturally the > BoD will want to see accounting by event (what were the expenses and > revenues for THIS event; how much did it cost us to put on the event or > how much did we make, compare the separate event report with those of > prior years, how about all events together (will come back to that). > > One of the expenses associated with each event would be for printing > fliers, postage for mailing, etc. (things that can be considered > "printing and postage") so under each event, such an account. BUT > "printing and postage" is a line item on the 990/990EZ and also going to > have to report the total for this activity sort WITHOUT printing and > postage since that's a separate line item. > > So -- if the CoA structured correctly will be able to produce reports. > > a) For each event, P&L (select just the accounts of that event) > > b) The totals for all events NOT including the "printing and postage" > expense (again, by selecting the accounts to include) > > c) Printing and postage total for the organization (again selecting all > the "printing and postage" accounts -- note that some of these will be > other than as an expense of some event) > > You aren't thinking of all the things the Treasurer of an org is going > to be wanting from the books. ONE set of books, able to produce reports > for various purposes, at different levels of detail. For example, the > BoD might want to see the total for "independent contractors" but not > how much paid to each let alone how much of what was paid to each was > "compensation" and how much "reimbursement of expenses" (so whether a > 1099-MISC will be needed to be filed to whom and if so, for how much) > > That's why I am stressing "get the CoA" right so you can get all that > you need out of it. You can always reduce the amount of detail in > reports, specialize reports, etc. later but only if captured in the > first place. And keep in mind that you do not necessarily have to do all > the reduction of detail, specialization, etc. INSIDE gnucash. You can > also export reports and then do the rest of it using your favorite > editor << that's how I was told to do it by a lawyer/accountant on one > of the BODs -- he said that's how any of us accountants would do it -- > and mind, as a "pro" I could have coded custom reports ->> > > Michael D Novack > If the events are fixed, such as "Memorial Day Celebration" and "Independence Celebration", you could make an expense category and then have sub-categories for it. I assume that you can run P&L on one set of categories. Would that work? You'd have similar sub-categories. I'm pretty sure you could get a breakdown for the events, but if you also want a total (for example) "postage" from each category, I'm not sure how to do that, especially if you want all the sub-categories summarized. Perhaps exporting to a spreadsheet and creating a pivot table? (or something along those lines?) -- _ 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] Finance-Quote 1.60 released!
On 4/17/24 11:57 AM, Kalpesh Patel wrote:
You can also save cookies to a file named cookies.txt as follows:
#curl -c cookies.txt https://login.yahoo.com -I
and then following to display 11 characters crumb by using cookies
saved in previous command: #curl -H "user-agent: Mozilla/5.0
(Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/39.0.2171.95 Safari/537.3" -b cookies.txt
https://query2.finance.yahoo.com/v1/test/getcrumb
I'm not interested in saving the cookies at this time. I've been having
a discussion with another user having the same (or similar) issue. In
debug mode his cookie jar has only 1 cookie, the "AS=v=1&s=..." cookie.
### [Wed Apr 17 08:59:30 2024]cookie_jar : bless( {
### COOKIES => {
### 'login.yahoo.com' => {
### '/' => {
### AS => [
### 0,
###
'v=1&s=pdMraThU&d=A6620c4d1|itU7Kpb.2SoujXrNK8pQPMi...
### undef,
### 1,
### 1,
### undef,
### 1,
### {
### HttpOnly => undef
### }
### ]
### }
### }
### }
### }, 'HTTP::Cookies' )
The other 3 cookies that I get can see in debug mode are not in the
cookie jar. My theory is that for those it is not working, they are not
getting all 4 cookies.
Bruce S
___
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] Finance-Quote 1.60 released!
You can also save cookies to a file named cookies.txt as follows:
#curl -c cookies.txt https://login.yahoo.com -I
and then following to display 11 characters crumb by using cookies saved in
previous command:
#curl -H "user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1)
AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.3" -b
cookies.txt https://query2.finance.yahoo.com/v1/test/getcrumb
Output of a working F::Q example with DEBUG=1 set should be similar to below
... note A1, A3, A3S and AS cookies listed and corresponding crumb value at the
end
### [Wed Apr 17 14:31:18 2024]cookie_jar : bless( {
### COOKIES => {
###
'.yahoo.com' => {
###
'/' => {
###
A1 => [
###
0,
###
'd=AQABBHYVIGYCENNwdHR1aVcaemtvqQ4t4WcFEgEBAQFmIWYpZtxH0iMA_eMAAA&S=AQAAApUVRCc9YJK2Hw8hmnctLGc',
###
undef,
###
1,
###
1,
###
1744936278,
###
undef,
###
{
###
HttpOnly => undef,
###
SameSite => 'Lax'
###
}
###
],
###
A1S => [
###
0,
###
'd=AQABBHYVIGYCENNwdHR1aVcaemtvqQ4t4WcFEgEBAQFmIWYpZtxH0iMA_eMAAA&S=AQAAApUVRCc9YJK2Hw8hmnctLGc',
###
undef,
###
1,
###
1,
###
undef,
###
1,
###
{
###
SameSite => 'Lax'
###
}
###
],
###
A3 => [
###
0,
###
'd=AQABBHYVIGYCENNwdHR1aVcaemtvqQ4t4WcFEgEBAQFmIWYpZtxH0iMA_eMAAA&S=AQAAApUVRCc9YJK2Hw8hmnctLGc',
###
undef,
###
1,
###
1,
###
1744936278,
###
undef,
###
{
###
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 11:58:37 -0400 "Kalpesh Patel" wrote: > Richard, > > Is this happening on Windows 10 with Strawberry perl? > > There is one other user is having problem getting secure cookies on > Windows 10 which is what this appears to be as well. It is related to > some Perl's SSL package being broken or not installed correctly but > haven't been able to pinpoint it. Hi Kalpesh, I'm running Arch Linux with perl 5.38.2. -- Richard signature.asc Description: OpenPGP digital signature ___ 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] Finance-Quote 1.60 released!
Wed Apr 17 11:58:37 EDT 2024, Kalpesh Patel writes:
Is this happening on Windows 10 with Strawberry perl?
There is one other user is having problem getting secure cookies on
Windows 10 which is what this appears to be as well. It is related to
some Perl's SSL package being broken or not installed correctly but
haven't been able to pinpoint it.
Wednesday, April 17, 2024 5:44 AM, Richard Ullger writes:
yahoojson and yahooweb are not working for me either in v1.60 and
they didn't work in 1.59_01.
WRT "yahooweb", Yahoo made changes to their finance pages. The URL used
for the web scrape, aside from some formatting changes that break the
module, also returns a huge amount of header information (over 16k bytes
when I fetch it using curl). While I have a fix for the large amount of
header information, work needs to be done to change the parsing to
retrieve the data (see
https://github.com/finance-quote/finance-quote/issues/377).
WRT "yahoo_json" (which now allows it to be called "yahoojson"), some
users are reporting the same. Turning debug on within Perl has so far
indicated that not all the required cookies are being returned.
From using "curl" the following cookies should be retrieved:
AS=v=...
A1=d=...
A3=d=...
A1S=d=...
From one user, it looks like only the "AS=v=..." cookie is returned.
Those having the same issue as Richard, please execute "curl --head
https://login.yahoo.com"; or "curl --include https://login.yahoo.com"; and
look for the "set-cookie:" lines in the header.
Here is a way to test outside of GnuCash on Linux and Mac. Utilizes
cached package source left behind from install using "cpan".
# lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description:Ubuntu 22.04.4 LTS
Release:22.04
Codename: jammy
# If you have installed 1.60 more than once (perhaps different
# library paths), 1.60-0 may be 1.60-1 or 1.60-2, or ...
cd $HOME/.cpan/build/Finance-Quote-1.60-0
export PERL5LIB=$HOME/.cpan/build/Finance-Quote-1.60-0/lib:$PERL5LIB
./Examples/stockdump.pl yahoo_json AAPL
$VAR1 = {
'AAPLlow' => '168.27',
'AAPLopen' => '171.71',
'AAPLsymbol' => 'AAPL',
'AAPLeps' => '6.42',
'AAPLvolume' => 58572152,
'AAPLisodate' => '2024-04-16',
'AAPLname' => 'AAPL (Apple Inc.)',
'AAPLdiv_yield' => '0.5501187',
'AAPLcurrency' => 'USD',
'AAPLdate' => '04/16/2024',
'AAPLhigh' => '173.755',
'AAPLtype' => 'EQUITY',
'AAPLpe' => '26.457943',
'AAPLlast' => '169.86',
'AAPLyear_range' => ' 162.8 - 199.62',
'AAPLexchange' => 'NasdaqGS',
'AAPLsuccess' => 1,
'AAPLclose' => '172.69',
'AAPLmethod' => 'yahoo_json'
};
You can output debugging information by adding "DEBUG=1" before
executing the stockdump.pl script.
$ DEBUG=1 ./Examples/stockdump.pl yahoo_json AAPL
For those still having an issue with v1.60, my guess is that you will
find the "AS=" cookie in the debug output.
As Kalpesh theorized, the issue could lie within another Perl
module/package.
On Wed, 17 Apr 2024 08:23:38 +0200, Adam Griffis writes:
> However, YahooJSON is still giving me the same error. Is an API key
> required for YahooJSON now?
No, Yahoo is not requiring an API Key.
Bruce S
___
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] Finance-Quote 1.60 released!
Richard,
Is this happening on Windows 10 with Strawberry perl?
There is one other user is having problem getting secure cookies on Windows 10
which is what this appears to be as well. It is related to some Perl's SSL
package being broken or not installed correctly but haven't been able to
pinpoint it.
-Original Message-
From: Richard Ullger
Sent: Wednesday, April 17, 2024 5:44 AM
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 08:23:38 +0200
"Adam Griffis" wrote:
> Yes, I have the AlphaVantage api key set. But that's not the issue --
> I'm not pulling from AlphaVantage. I'm pulling from YahooJSON.
>
> If I understand correctly, the 1.60 update should include a fix to get
> YahooJSON working again, resolving the "cookie and crumb" issue.
> However, YahooJSON is still giving me the same error. Is an API key
> required for YahooJSON now?
>
> Thanks,
> Adam
yahoojson and yahooweb are not working for me either in v1.60 and they
didn't work in 1.59_01.
I have perl-http-cookiejar installed.
perl-finance-quote has been dropped from the arch repos to the AUR.
It's still at 1.59 in the AUR so I've taken the PKGBUILD and modified
it for 1.60.
I am currently running gnucash v4.14.
The output for yahoojson is...
gnc-fq-dump -v yahoojson AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L<=== required
date: **
missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: Error retrieving quote for AEI.L. Attempt to
fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=AEI.L&crumb={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}&modules=price,summaryDetail,defaultKeyStatistics resulted in
HTTP response 401 (Unauthorized)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
AEI.L symbol: AEI.L
The output for yahooweb is...
gnc-fq-dump -v y
ahooweb AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L (deduced) <=== required
date: ** missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: 500 Header line too long (limit is 8192)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
--
Richard
___
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] What account name do you use to record the apartment/house expenses related to the building?
d) What you can;t do is have it both ways. Traditional double entry bookkeeping allows only one tree structure for the CoA. To get it different in different reports you would have to BOTH set up the CoA correctly AND select just certain accounts for the report. Of course you can by running the report filtered for transactions with or without tag(s). (It is an unfortunate term because most searches will find the term used in the context of computer code rather than filtering transactions for reports.) I don't think you are picturing what I meant by both ways. Say doing organizational reporting, and this organization (among its other activities) conducts several "events" every year. naturally the BoD will want to see accounting by event (what were the expenses and revenues for THIS event; how much did it cost us to put on the event or how much did we make, compare the separate event report with those of prior years, how about all events together (will come back to that). One of the expenses associated with each event would be for printing fliers, postage for mailing, etc. (things that can be considered "printing and postage") so under each event, such an account. BUT "printing and postage" is a line item on the 990/990EZ and also going to have to report the total for this activity sort WITHOUT printing and postage since that's a separate line item. So -- if the CoA structured correctly will be able to produce reports. a) For each event, P&L (select just the accounts of that event) b) The totals for all events NOT including the "printing and postage" expense (again, by selecting the accounts to include) c) Printing and postage total for the organization (again selecting all the "printing and postage" accounts -- note that some of these will be other than as an expense of some event) You aren't thinking of all the things the Treasurer of an org is going to be wanting from the books. ONE set of books, able to produce reports for various purposes, at different levels of detail. For example, the BoD might want to see the total for "independent contractors" but not how much paid to each let alone how much of what was paid to each was "compensation" and how much "reimbursement of expenses" (so whether a 1099-MISC will be needed to be filed to whom and if so, for how much) That's why I am stressing "get the CoA" right so you can get all that you need out of it. You can always reduce the amount of detail in reports, specialize reports, etc. later but only if captured in the first place. And keep in mind that you do not necessarily have to do all the reduction of detail, specialization, etc. INSIDE gnucash. You can also export reports and then do the rest of it using your favorite editor << that's how I was told to do it by a lawyer/accountant on one of the BODs -- he said that's how any of us accountants would do it -- and mind, as a "pro" I could have coded custom reports ->> 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] Use same transfer column info for identical description
Glad it went well. If there are improvement ideas please file in
bugs.gnucash.org
On Tue, 16 Apr 2024, 5:59 pm Adrien Laveau, wrote:
> Hello!
> I went deeper into the importer yesterday night. I sorted 1400 transaction
> in 2h. It could be of course improved but honestly the experience was
> great.
> I have done the hard work and quicker than expected.
>
> Let's see for future updates how the automatic detection works.
>
> Thanks everyone
>
> El mar., 16 abr. 2024 5:19, Christopher Lam
> escribió:
>
>> The importer has had some upgrades in the past couple years. You can sort
>> by description in the importer, select multiple transactions with similar
>> descriptions, mass assign to a particular account, mass rename the
>> description too, via the right click menu.
>>
>> On Tue, 16 Apr 2024, 4:14 am Adrien Laveau,
>> wrote:
>>
>>> Hello,
>>>
>>> Thank you both for your time answering my question.
>>>
>>> At the moment my data being in GNC or not is not a big deal.
>>> I have the CSV/XLS fiel extracts (sadly my banks do not connect with GNC
>>> online systems).
>>> It is of the following form :
>>> Description Amount Date
>>> DescA xx 2024/03/12
>>> DescB yy ...
>>> DescC zz
>>> DescB ii
>>> DescB aa
>>> DescC rr
>>> ...
>>>
>>> And I want DescA to go in one transfer, DescB to go in another one and C
>>> in
>>> another one.
>>> I have understood your method and remember it, but for the moment I
>>> cannot
>>> use it as the "initial répartition" is not done.
>>>
>>> And also it does not seem to solve the problem of future transaction witj
>>> the same description.
>>> Indeed I plan to regularly get the CSV from sll my accountd and import
>>> them
>>> in GNC and I would have expected those new transaction to take the
>>> correct
>>> transfer action.
>>>
>>> The best guess I have now is to do it in Excel before importing and
>>> having
>>> the mapping I am looking for, directly in Excel.
>>>
>>> Thanks again
>>>
>>> El lun., 15 abr. 2024 14:12, Kevin Buckley via gnucash-user <
>>> gnucash-user@gnucash.org> escribió:
>>>
>>> > On Monday, April 15th, 2024 at 04:40, Jim DeLaHunt <
>>> list+gnuc...@jdlh.com>
>>> > wrote:
>>> > >
>>> > > Hello, Adrien, and welcome to MusicBrainz!
>>> >
>>> > Surely: "... welcome to GnuCash!" ?
>>> >
>>> > >
>>> > > On 2024-04-14 13:03, Adrien Laveau wrote:
>>> > >
>>> > > > Hello community,
>>> > > >
>>> > > > I uploaded 5 years worth of bank account transaction to gnu-cash.
>>> > > >
>>> > > > I would like the apply the same transfer information to all the
>>> > > > transactions having the same description and keep applying it
>>> > > > automatically to all future transaction.
>>> > >
>>> > >
>>> > > It sounds like you want to do two different things:
>>> > >
>>> > > 1. Change the details ("transfer column info") which you have already
>>> > > imported into your book file to match your desired contents.
>>> > > 2. Ensure that GnuCash uses your desired contents for future
>>> > > transactions which you enter into GnuCash using the "same
>>> description".
>>> > >
>>> > > I don't have easy suggestions for #1, except to go through
>>> transactions
>>> > > one by one and correct them. It may be tedious, but you only have to
>>> do
>>> > > it once. (I have a difficult suggestion: to edit the GnuCash XML book
>>> > > file. This is dangerous but sometimes effective. It requires skills
>>> in
>>> > > working with XML and file formats.)
>>> > >
>>> >
>>> > As someone who's not completely unfamiliar with editing GnuCash's
>>> > XML, I would like to say that doing what you are suggesting you
>>> > want to do here, by editing the XML, is going to be a large task,
>>> > because you would have to identify the various GUIDs (32 character
>>> > strings of text that give you no clue as to what each one is) that,
>>> > in the XML file, take the place of what you see, as the transfer
>>> > account, in the Register.
>>> >
>>> > As Jim implies, it could be done, but I'm not sure you would want
>>> > to.
>>> >
>>> > There may, depending on how cleanly your old data was imported,
>>> > be a bit of a "saving grace", as to what you are trying to do,
>>> > via an approach that doesn't mean you need to go through ALL
>>> > your TXNs one by one. You might still need to address a small
>>> > number of outliers.
>>> >
>>> > It does, however, mean "Deleting" some things, but don't stop
>>> > reading yet, as it's not as bad as it sounds.
>>> >
>>> > As I understand things, you have ended up with a lot of TXNs that
>>> > look like, where Desc1 is the same string every time
>>> >
>>> > Description: Desc1, Transfer account: XFR1
>>> > Description: Desc1, Transfer account: XFR2
>>> > Description: Desc1, Transfer account: XFR1
>>> > Description: Desc1, Transfer account: XFR3
>>> > Description: Desc1, Transfer account: XFR3
>>> > Description: Desc1, Transfer account: XFR2
>>> > Description: Desc1, Transfer account: XFR1
>>> >
>>> > scattered across any number of accounts, whereas you wan
Re: [GNC] Finance-Quote 1.60 released!
On Wed, 17 Apr 2024 08:23:38 +0200
"Adam Griffis" wrote:
> Yes, I have the AlphaVantage api key set. But that's not the issue --
> I'm not pulling from AlphaVantage. I'm pulling from YahooJSON.
>
> If I understand correctly, the 1.60 update should include a fix to get
> YahooJSON working again, resolving the "cookie and crumb" issue.
> However, YahooJSON is still giving me the same error. Is an API key
> required for YahooJSON now?
>
> Thanks,
> Adam
yahoojson and yahooweb are not working for me either in v1.60 and they
didn't work in 1.59_01.
I have perl-http-cookiejar installed.
perl-finance-quote has been dropped from the arch repos to the AUR.
It's still at 1.59 in the AUR so I've taken the PKGBUILD and modified
it for 1.60.
I am currently running gnucash v4.14.
The output for yahoojson is...
gnc-fq-dump -v yahoojson AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L<=== required
date: **
missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: Error retrieving quote for AEI.L. Attempt to
fetch the URL
https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbols=AEI.L&crumb={"finance":{"result":null,"error":{"code":"Unauthorized","description":"Invalid
Cookie"}}}&modules=price,summaryDetail,defaultKeyStatistics resulted in
HTTP response 401 (Unauthorized)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
AEI.L symbol: AEI.L
The output for yahooweb is...
gnc-fq-dump -v y
ahooweb AEI.L
Finance::Quote fields Gnucash uses:
symbol: AEI.L (deduced) <=== required
date: ** missing **<=== recommended
currency: ** missing **<=== required
last: **missing** <=\
nav: **missing** <=== one of these
price: **missing** <=/
timezone: <=== optional
** This stock quote cannot be used by GnuCash!
All fields returned by Finance::Quote for stock AEI.L
stock field value
- - -
AEI.Lerrormsg: 500 Header line too long (limit is 8192)
AEI.Llast: **missing**
AEI.L nav: **missing**
AEI.L price: **missing**
AEI.L success: 0
--
Richard
signature.asc
Description: OpenPGP digital signature
___
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.
