Re: [GNC] Dealing with discounts when not using Business Features

[Michael Hendry]

On 1 Jun 2023, at 02:50, Murugan Muruganandam  
wrote:

> 
> michael
> 
> for Bursary accounting purposes you can use the liability option
> 
> Bursary account funding from the donor
> Cr Liability: Bursary:Donor 1 : $1000
> Dr Assets: Bank : $ 1000
> Payment to student invoice
> Dr Assets: Bank : $125 (student pays)
> Cr Income: Fees: $375
> Dr Liability: Bursary: Donor 1: $250 (bursary pays)
> 
> 
> 
> Saludos Cordiales
> 
> Murugan

Thanks, Murugan.

Some years ago I set up a Liability Account for cash received specifically for 
bursaries but was advised by the accountant who examines our books prior to 
their submission to the Office of the Scottish Charity Regulator (“OSCR”) that 
this wasn’t acceptable under Scottish charity accounting rules - we should keep 
track of this cash separately from our books.

We don’t have any such restricted funds now, and meet the cost of bursaries 
along with general expenditure.

Our accountant does the examination of our books for a nominal sum, but I may 
have to impose this query on him to be sure of avoiding wasting his time when I 
submit our records for his approval.

Regards,

Michael

___
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] Gnucash 5.1 Online Quotes not working

[Kalpesh Patel]

Hi Kevin - 

 

I am glad it is sorted out and working now, in workaround that is a bit of a
pain.

 

That behavior though seems odd. I lodge a bug on it at
https://bugs.gnucash.org/.

 

Just to understand what actions manifested the issue - did you upgrade the
version of GNC, moved it over from one platform (windows, Linux or mac ) to
another, bulk import the securities or anything else by chance? If you have
an earlier version of the file somewhere (you did enable auto-backup, right)
then worth attaching to the bug report. If the file has sensitive data then
you can reach out to dev team (on this list) to see how they like you to
provide a sample so that they can reproduce. There is anonymizing the data
process but I am leaning that it may change things to auto-magically fix the
issue and loose an opportunity to get to root of the bug.   

 

From: thornefamilytr...@bigpond.com  
Sent: Thursday, June 01, 2023 12:17 AM
To: 'Kalpesh Patel' ; 'Murugan Muruganandam'
; 'David H' 
Cc: gnucash-user@gnucash.org
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

 

Hi Kaplesh,

 

Had to switch off each get online quotes for all commodities in price editor
and then switch each one on again one at a time and they started updating!!

 

From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> > 
Sent: Saturday, May 27, 2023 6:32 AM
To: thornefamilytr...@bigpond.com  ;
'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> >; 'David H' mailto:hell...@gmail.com> >
Cc: gnucash-user@gnucash.org  
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

 

Kevin - 

 

Given that the price retrieval facility is known to work correctly, only
scenario I can think of is that there might be two different definition of
the same security under two different namespace and that might be colliding
with each other. Only other trial I can suggest is that delete the security
in the file where it is not working, close GNC, relaunch and add the
security back in again. Before removing the security, I HIGHLY recommend you
create backup (multiple of them) to restore back if other things break in
this process.

 

Otherwise I am out of wits and I think the folks that are in-&-in (hint
development team) thick of the things may need to help debug as I think for
me this is first time I am coming across a scenario where a security price
can and cannot be retrieved is function of which file is open. This is NOT
how it supposed to function )-: .

 

The remotest thing that comes to mind is that something might be corrupt
semantically within a file provided that it is being stored in XML format.
Only thought that comes to mind in that case is -- sadly too painful - to
export out all data using CSV format and then import it back in as CSV
starting with accounts first and then transaction.

 

The other alternative I can suggest is to run an offline python script that
I've written and import prices in as CSV afterwards. See
https://github.com/ka-patel/dl_quotes repo for details.  

 

From: thornefamilytr...@bigpond.com 
mailto:thornefamilytr...@bigpond.com> > 
Sent: Thursday, May 25, 2023 9:23 PM
To: 'Kalpesh Patel' mailto:kalpesh.pa...@usa.net> >;
'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> >; 'David H' mailto:hell...@gmail.com> >
Cc: gnucash-user@gnucash.org  
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

 

Kalpesh - 

 

Some success .

 

My perl location the same as below

 

Setup clean GNU with BRK-B using Alphavantage and ANZ with ASX the price for
both updates when running the Get Quotes

 

But . using same settings in current GNU file there I can still not update
quotes

 

From: Kalpesh Patel mailto:kalpesh.pa...@usa.net> > 
Sent: Wednesday, May 24, 2023 11:21 PM
To: 'Murugan Muruganandam' mailto:m.muruganan...@hotmail.com> >; thornefamilytr...@bigpond.com
 ; 'David H' mailto:hell...@gmail.com> >
Cc: gnucash-user@gnucash.org  
Subject: RE: [GNC] Gnucash 5.1 Online Quotes not working

 

Kevin -

 

In addition to below what Murugan has mentioned . two additional items to
try:

 

1)  Check which perl is GNC using (this is to eliminate munged up path
or GNC is looking at different Perl install base - unlikely but validation
won't hurt)

To do so, type in following in an clean CMD window:

 

where Perl

 

This for me returns back 'C:\Strawberry\Perl\bin\perl.exe'

 

2)  Start with a clean slate in GNC . also recommend that you fully turn
off Norton mal-ware/anti-virus software for duration of this clean slate
test. 

a.   Open GNC 

Select 'File' -> 'New File' (select default all the way through and save the
file as 'test' or something like that at a known location in a separate
folder. You'll want to delete the folder once test is over)

b.   Define the 'Berk

Re: [GNC] OFX transactional data downloads from FDIC insured banks

[Kalpesh Patel]

Completely concur. 

 

Need of one seems to overpower need of the many… opposite of what Spock 
(Leonard Nimoy) said in Wrath of Khan -- the Star Trek motion picture. 

 

From: David Carlson  
Sent: Sunday, May 28, 2023 2:55 PM
To: Kalpesh Patel 
Cc: Brad Morrison ; gnucash-user@gnucash.org; 
fdxmemberservi...@financialdataexchange.org; 
fdxsupp...@financialdataexchange.org
Subject: Re: [GNC] OFX transactional data downloads from FDIC insured banks

 

Too many of us Americans have forgotten about core values like teamwork, 
compromise, morality...

 

On Sun, May 28, 2023 at 1:06 PM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

See responses in-line (with 'KP -->' line) ...

-Original Message-
From: Brad Morrison mailto:bradmorri...@sonic.net> > 
Sent: Saturday, May 27, 2023 2:15 PM
To: gnucash-user@gnucash.org  
Cc: fdxmemberservi...@financialdataexchange.org 
 ; 
fdxsupp...@financialdataexchange.org 
 
Subject: Re: [GNC] OFX transactional data downloads from FDIC insured banks

Aha, thanks Kalpesh! I did not understand the technical differences between OFX 
(https://financialdataexchange.org/ofx &
https://en.wikipedia.org/wiki/Open_Financial_Exchange) & QFX 
(https://en.wikipedia.org/wiki/QFX_(file_format)).

So based on what you are highlighting here, GnuCash does NOT typically have 
issues importing downloaded QFX files (nor downloaded OFX files) and the main 
differences in GnuCash between OFX & QFX are the ability to directly connect to 
your financial institution using OFX Direct Connect
- correct?


KP-->For this truly it has never not worked in many years. GNC technically uses 
OFX format for Direct Connect, but for import OFX and QFX are treated equally. 
Direct Connect and import process are two distinct and un-joined operation in 
GNC although they may share the same libraries call in the back-end to parse 
the data.


https://wiki.gnucash.org/wiki/OFX_Direct_Connect_Bank_Settings & 
https://wiki.gnucash.org/wiki/Setting_up_OFXDirectConnect

If so, searching for a bank that specifically allows OFX transactional data 
downloads may just be pursuing open source only for the sake of being open 
source and may not be relevant to many GnuCash users. I have been surprised at 
how many people on this mailing list still use Windows and Mac OSs, but what do 
I know...


KP-->In short, yes. At the end of the day banks are doing so as result of what 
makes the most money for them and that means attracting variety of customers 
including customers that utilize personal financial management application with 
Intuit Quicken and defunct MS Money being the earliest pioneers. They sort of 
created the standard which has been ingrained in many bank's offering for many 
moons as nothing else existed for very long time, thus quite a good deal of 
them continue to offer OFX format to be widely compatible or it has been there 
and working so why bother ripping it out. Windows or Mac OS doesn’t have 
anything to do with the download offering. There are some that have gone from 
the open source to proprietary direction (Schwab did that few years back where 
only connection from Quicken infrastructure is permitted to download data in 
OFX format. Of course this most likely involves money being exchange between 
the parties to become closed eco system). Typically large banks have enough 
staff and IP to be able to offer it themselves from in-house while other 
regional smaller banks who outsource their platform to third parties also offer 
them because they can tout it as a feature available to Banks to offer to 
customers.  


https://financialdataexchange.org/ofx - this OFX Work group page does not 
appear to have been updated since my May 18 email (below), so I will cc the FDX 
email addresses I found once again. Silicon Valley Bank is still listed as a 
"Active OFX solution providers participant" although SVB does still seem to 
exist as a division of First Citizens Bank (https://www.svb.com/). And 2020 is 
still listed as the copyright year for FDX at the bottom...


KP-->Sadly OFX is dying by thousands cuts as newer and better APIs have become 
available that provide better fidelity, along with security, of data as part of 
the innovation from Internet coming together. Bank of America and Chase are in 
this boat. Also there is continent divide as well. The US has languished behind 
in standardization innovation behind the EU,  hence GNC offering multiple types 
of import.  


I will look more into Plaid later -
https://en.wikipedia.org/wiki/Plaid_Inc.

Thanks,

Brad

On 5/22/23 11:21, Kalpesh Patel wrote:
> I can confirm thathttps://www.chase.com/    provides 
> download of accounts (credit card, checking or saving) in QFX format from 
> their web site. At one Chase even provided direct connect OFX download via an 
> API call which they shut

Re: [GNC] Dealing with discounts when not using Business Features

[Michael or Penny Novack]

As I said, I haven’t been using the Business Features because they’re an added 
complication, and because our accounts are kept on a cash basis.

A Bursary is a grant made to assist a talented student who might otherwise be 
unable to afford a course. It’s doesn’t usually involve competition (like a 
scholarship), and is intended to encourage a talented individual to take up a 
course s/he couldn’t otherwise afford.



I knew what a "bursary" was --- but this more a difference in the  usage 
of the term "scholarship" across the pond. American English not always 
the same as yours. Long ago we ceased distinguishing "scholarship" that 
way, taking the meaning to be just "grant for the purpose of study".


How to treat this (with reference to accounting, not really a gnucash 
question) depends on:


a) Do you want to inflate income/expense of not? Same net done either way.

b) How independent (in a legal sense) is the source of these bursary 
funds? In a moral sense? << thus here, a quasi independent fund might be 
legally under the umbrella of a 501(c)3 << not its own 501(c)3 >> . Thus 
I am on the boards of a pair like that, the quasi independent fund << 
used to be legally under a different 501(3)3 >> and the 501(c)3 it is 
now under (moved there when that organization became 501(c)3. The 
purpose of the quasi-independent fund being to subsidize the attendance 
of children at events put on by the now parent organization at a site 
that does not have lower rates for children.


So very much like your "bursary" fund. But because the special purpose 
org was once legally independent (and de facto still is) this is handled 
by negotiated settlement between the boards, one agreeing to subsidize X 
amount of the children's rate and the organization just sends out 
registration forms with the resulting lower rate per child. I am giving 
this particular example because IN ADDITION parents who still could not 
afford that could apply for "scholarship" help << US usage* >>


Michael D Novack

* The split in usage goes back a ways. In the very beginning 
"scholarships" meant the same both sides of the pond. But then over here 
we began getting things like benefactors setting up funds with special 
terms (eg: descendants of so and so: needy students form the town of X, 
etc.) and in some cases the legislators had funds in their "gift and 
favor". Institutions might offer "scholarships" to applicants with 
athletic prowess. Or just need**. So we now no longer associate 
"scholarship" as being won by competitive academic exam.


** In some cases this is closer to the UK sense in that there are some 
top academic unis that are well endowed and consider "you made the cut 
to get in" as winning the exam and will then offer aid toward the 
tuition of students who need it.


___
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] Dealing with discounts when not using Business Features

[Michael Hendry]

Thanks, Michael.

IIRC, we exchanged some posts on the list some years ago, when I created 
Liability accounts for donations that were earmarked by the donors for 
particular purposes and later had to backtrack, following the advice of the 
accountant who examines our books. Indeed, I think you may have suggested this 
method.

See interpolations below.

Regards,

Michael
> On 1 Jun 2023, at 15:14, Michael or Penny Novack  
> wrote:
> 
> 
>> As I said, I haven’t been using the Business Features because they’re an 
>> added complication, and because our accounts are kept on a cash basis.
>> 
>> A Bursary is a grant made to assist a talented student who might otherwise 
>> be unable to afford a course. It’s doesn’t usually involve competition (like 
>> a scholarship), and is intended to encourage a talented individual to take 
>> up a course s/he couldn’t otherwise afford.
> 
> 
> I knew what a "bursary" was --- but this more a difference in the  usage of 
> the term "scholarship" across the pond. American English not always the same 
> as yours. Long ago we ceased distinguishing "scholarship" that way, taking 
> the meaning to be just "grant for the purpose of study".
> 
> How to treat this (with reference to accounting, not really a gnucash 
> question) depends on:
> 
> a) Do you want to inflate income/expense of not? Same net done either way.

Neither. The student pays the net course fee, usually with a deposit and one or 
more additional tranches, before attending the course. What I wanted was to be 
able to report the net course fees as an income account, but be able to report 
the gross amount by student including the net course fee along with any 
discounts and bursaries so that we can easily detect over- or under-payments 
and take appropriate action. Sometimes a student will pay the full amount and 
subsequently qualify for a discount because another member of the family has 
signed up, for example.At present, there isn’t a simple way of determining how 
much we’re “spending” on discounts and bursaries from the books.

> 
> b) How independent (in a legal sense) is the source of these bursary funds? 
> In a moral sense? << thus here, a quasi independent fund might be legally 
> under the umbrella of a 501(c)3 << not its own 501(c)3 >> . Thus I am on the 
> boards of a pair like that, the quasi independent fund << used to be legally 
> under a different 501(3)3 >> and the 501(c)3 it is now under (moved there 
> when that organization became 501(c)3. The purpose of the quasi-independent 
> fund being to subsidize the attendance of children at events put on by the 
> now parent organization at a site that does not have lower rates for children.

We haven’t had donations for bursaries recently, and applications are rare in 
any case. In essence, we forgo the income that would have come from the student 
with a bursary, in the same way as we forgo income when granting discounts.

> 
> So very much like your "bursary" fund. But because the special purpose org 
> was once legally independent (and de facto still is) this is handled by 
> negotiated settlement between the boards, one agreeing to subsidize X amount 
> of the children's rate and the organization just sends out registration forms 
> with the resulting lower rate per child. I am giving this particular example 
> because IN ADDITION parents who still could not afford that could apply for 
> "scholarship" help << US usage* >>
> 
> Michael D Novack
> 
> * The split in usage goes back a ways. In the very beginning "scholarships" 
> meant the same both sides of the pond. But then over here we began getting 
> things like benefactors setting up funds with special terms (eg: descendants 
> of so and so: needy students form the town of X, etc.) and in some cases the 
> legislators had funds in their "gift and favor". Institutions might offer 
> "scholarships" to applicants with athletic prowess. Or just need**. So we now 
> no longer associate "scholarship" as being won by competitive academic exam.
> 
> ** In some cases this is closer to the UK sense in that there are some top 
> academic unis that are well endowed and consider "you made the cut to get in" 
> as winning the exam and will then offer aid toward the tuition of students 
> who need it.

Regards,

Michael
___
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] Dealing with discounts when not using Business Features

[Michael or Penny Novack]

On 6/1/2023 12:24 PM, Michael Hendry wrote:

Thanks, Michael.

IIRC, we exchanged some posts on the list some years ago, when I created 
Liability accounts for donations that were earmarked by the donors for 
particular purposes and later had to backtrack, following the advice of the 
accountant who examines our books. Indeed, I think you may have suggested this 
method.

See interpolations below.

Regards,


Whether restricted donations are properly treated as liabilities depends 
on:


1) Whether formally or informally restricted (moral restriction only)  
<< in other words, whether would need to return if not used for 
designated purpose >>


2) Your jurisdiction

Follow the advice of your accountant

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] Dealing with discounts when not using Business Features

[Stan Brown]

But even if formally restricted, I believe it's not a liability but a
_contingent_ liability. It only becomes a liability if the organization
makes a decision not to use it in that way, or if a deadline runs out.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-06-01 11:06, Michael or Penny Novack wrote:
> Whether restricted donations are properly treated as liabilities depends
> on:
> 
> 1) Whether formally or informally restricted (moral restriction only) 
> << in other words, whether would need to return if not used for
> designated purpose >>
___
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] flatpak with new Finance::Quote

[Dale Alspach]

I just installed the latest flatpak (for linux mint 21.1)
Build ID: Flathub 5.1
Finance::Quote: 1.5301
Will there be a release with Finance::Quote 1.56 or at least instructions
for upgrading within the flatpak sandbox.
I tried a little but there seem to be some dependency issues that require
some special perl settings to resolve.
Dale
___
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] gunzip test.gnucash fails

[David G. Pickett via gnucash-user]

Now if only the digest email back was a readable as and, unmodified from, the 
email out?


-Original Message-
From: David G. Pickett 
To: gnucash-user@gnucash.org 
Sent: Wed, May 31, 2023 3:00 pm
Subject: Re: [GNC] gunzip test.gnucash fails

Quick tutorial on OS file name extensions (suffixes) and file type: While '.gz' 
tells your OS it needs to go to gunzip to be uncompressed into a file without 
the '.gz', gunzip does not care about the name.  To bypass the OS extension 
association, you can force the input and output file names using command line 
I/O redirection: gunzip < input_file > output_file.  Since gunzip reads from 
standard input file descriptor 0 by default, and write to standard output file 
descriptor 1 by default, it will gladly uncompress your gnucash data into an 
editable xml text file.  Of course, it has to like the taste of the file it 
reads!  :D  You can even name the output_file as some_base_name.txt so you text 
editor will gladly open and write it.

As to editing XML, as long as you only modify the strings inside ... , and not any punctuation, like the fragment below where 
it says 'alphavantage' you could 
change 'alphavantage' to another source, if you know the *exact* string for 
that source.  Change one the slow way to see what the magic word is!  The 
second example is a description IRC where 
you can change 'IRC' to whatever pleases you, but try not to stick anything 
funny or huge in there!
  AMEX  
DIA  DIA  
1000    
alphavantage    
          user_symbol      DIA      
 . . .
  20d545fb18b34e7ca920c11335705ac4      
CURRENCY    USD  
      2023-05-22 10:59:00 
+        2023-05-26 
14:36:25 +    
IRC

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