[GNC] Need help importing Investment transactions

[David Carlson]

I am currently running release 3.8 in Linux Lite, which is Ubuntu 20.04
under a different label.  I think that the CSV transaction import has not
been changed, between 3.8 and 4.9.  If that is not correct, then some of my
issues may be bugs that have been fixed.

I have read the current help manual section on importing transactions in
csv format  which
gave me a start, but there are some things that I cannot make work
correctly.

I have come to the conclusion that my brokerage house World Equity Group
CSV exports probably need to be massaged, and possibly split up but there
are a couple of issues that I need to understand in order to determine how
to fix the import data and to assign the proper names to the various fields.

One issue is that in one test many transactions were imported as single
line unbalanced transactions with no transfer account, not even an
assignment to an unbalance account.  Why did GnuCash accept unbalanced
transactions containing amounts? Applying Check and Repair to some of those
transactions did not balance them to an unbalance account.

Another issue is that I have not figured out which column name should be
used for the number of shares in a purchase or sale transaction.

Yet another issue would be whether I can import everything into the
brokerage account or do I need to do something special to get stock
transactions assigned to the proper security account when appropriate?

A fourth issue would be whether I need to use the Multi-Split feature and,
if so, how to format the CSV file to make it assign the correct split lines
to the correct base transaction, and save it in CSV format if I built the
spreadsheet in LibreOffice Calc or equivalent

-- 
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 4.9 build with libicu library versions

[Mike Commissaris]

Thanks for the fast reply.
You are correct, libwebkit2gtk is the same version in both machines,
2.34.1-1, but the depends are different:
libicu63 in the machine running linux kernel 5.10
libicu67 in the machine running linux kernel 5.15
So at this point I don't know where to go to get to where the 5.10 kernel
machine will depend on libicu67.
I am not linux-knowledgeable enough yet. looks like I may need to upgrade
the kernel.


On Wed, Dec 22, 2021 at 3:37 AM Geert Janssens 
wrote:

> Op woensdag 22 december 2021 05:41:17 CET schreef Mike Commissaris:
>
> > But when I tried to build 4.9 on our office desktop I got the libicu
>
> > version failure. The desktop has:
>
> > kernel 5.10.0
>
> > gcc Debian 8.3.0-6
>
> > cmake 3.13.4
>
> > make 4.2.1
>
> > I had to downgrade and lock to libicu63.1 for successful 4.9 build.
>
> >
>
> > All other GNC dependencies require a "version or higher" situation.
>
> > So  my question is why are libicu and libicu-dev libraries not the same
> as
>
> > far as accepting the higher version? Can I upgrade something to allow
>
> > version 67?
>
> Hi Mike,
>
> GnuCash depends on WebkitGtk, which in turn depends on libicu. I know we
> have to version-lock icu in the Windows build of gnucash to match the icu
> version that is required by WebkitGtk. Perhaps it's WebkitGtk as well
> that's preventing you from using a more recent version of libicu in your
> office ?
>
> Regards,
>
> Geert
>


-- 
Mike
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Dark Theme Needed

[John Ralls]

Arc,

Thanks for the followup, but please remember to copy the list on all replies.

I've added the requested FAQ, see 
https://wiki.gnucash.org/wiki/FAQ#Q:_I.27m_vision-impaired._How_do_I_make_GnuCash_more_accessible.3F

Regards,
John Ralls



> On Dec 22, 2021, at 12:53 PM, S S  wrote:
> 
> John,
> 
> Wonderful, thank you so very much for your help! I simply created both files 
> in my User account directory as you specified below, and now I can read and 
> use GnuCash again. I hope someone can add this information to the FAQ at some 
> point so perhaps in the future no one feels a need to inquire for similar 
> help. I'm so glad plain text works fine and no special subject/header rules 
> are needed on this list. Thank you again for taking time out of your day for 
> me to be so specifically helpful, and may you have an awesome new year ahead! 
> 
> Thanks Again,
> Arc
> 
> From: john 
> Sent: Wednesday, December 22, 2021 2:31 PM
> To: S S 
> Cc: gnucash-user@gnucash.org 
> Subject: Re: [GNC] GnuCash Dark Theme Needed
>  
> Don't worry too much about formatting. It's an email list, so format it the 
> way you would any other plain-text email.
> 
> GnuCash isn't a Windows native application so it doesn't know anything about 
> Windows theme settings. In general GnuCash obeys the Gtk theme, but there's 
> one exception: The green bar display in the register. You can turn that off 
> in Preferences>Register by unchecking "Use GnuCash built in color scheme", 
> the first item under Graphics.
> 
> To get light text on dark, open (create if necessary) 
> AppData\Local\gtk-3.0\settings.ini in Notepad or some other plain-text 
> editor. Make it look like
> [Settings]
> gtk-application-prefer-dark-theme=true
> 
> To boost the font size create a second file in that directory, gtk.css. In it 
> add
> #gnc-id-main-window {
> font-size: 20pt;
> }
> 
> See https://wiki.gnucash.org/wiki/GTK3 for more ways to style GnuCash.
> 
> Regards,
> John Ralls
> 
> 
>> On Dec 21, 2021, at 1:04 PM, S S  wrote:
>> 
>> I apologize if my formatting is not appropriate to the list as I can't find 
>> anything about how to format posts to the list. My problem right now is that 
>> I downloaded GnuCash 4.9 and I can't read anything in the software as it is 
>> not honoring/inheriting/adopting Windows 10 High Contrast Dark theme 
>> settings properly. Even if I try to invert the colors manually, it is not 
>> displaying correctly and the text is upscaling so poorly it is illegible. 
>> For instance, in HomeBank, there's an Edit > Preferences option with subset 
>> "Interface" that has the options to "override" GTK font to increase the text 
>> size and there is a clear option for "Dark theme." These two options make 
>> that software accessible to me. Is there anything like this in GnuCash? Are 
>> there any other legally blind or low vision users of GnuCash who might be 
>> able to help with how they achieved readable text to use the software?
>> 
>> Thanks Very Much,
>> Arc
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Dark Theme Needed

[Liz]

On Tue, 21 Dec 2021 21:04:44 +
S S  wrote:

> I apologize if my formatting is not appropriate to the list as I
> can't find anything about how to format posts to the list. My problem
> right now is that I downloaded GnuCash 4.9 and I can't read anything
> in the software as it is not honoring/inheriting/adopting Windows 10
> High Contrast Dark theme settings properly. Even if I try to invert
> the colors manually, it is not displaying correctly and the text is
> upscaling so poorly it is illegible. For instance, in HomeBank,
> there's an Edit > Preferences option with subset "Interface" that has
> the options to "override" GTK font to increase the text size and
> there is a clear option for "Dark theme." These two options make that
> software accessible to me. Is there anything like this in GnuCash?
> Are there any other legally blind or low vision users of GnuCash who
> might be able to help with how they achieved readable text to use the
> software?
> 
> Thanks Very Much,
> Arc

Arc, your email suggests to me that you have impaired vision.
If you (or someone else) makes a suitable css file for Gnucash for
people with impaired vision, it would be good to share on the wiki.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dependency on AqBanking data (gnucash files referencing NUM in .aqbanking/settings6/accounts/$NUM)

[Liz]

On Tue, 21 Dec 2021 17:13:58 -
"Fred Bone"  wrote:

> On 21 December 2021 at 10:48, Justin said:
> 
> > I hadn't received "[GNC]" stamped copy.  I just checked my
> > subscription options, and I am supposed to be receiving a copy of
> > mail sent to the list.  Odd.  I turned on ack emails for next time.
> >  
> 
> Why odd? You're using Gmail. This is expected behaviour.
> 
> 

Fred's correct, the point at which you lose the mail is Gmail. If you
check in your "Allmail" you could find them there.

Liz
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Name Fonts

[Gyle McCollam]

Thaks John, it's not incomprehensible, but it is beyond me.  Therefore, the 
answer to me is no.  But still, thanks anyway!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email


From: gnucash-user  on 
behalf of john 
Sent: Wednesday, December 22, 2021 1:03 PM
To: Gyle McCollam 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Account Name Fonts



> On Dec 22, 2021, at 8:23 AM, Gyle McCollam  wrote:
>
> Is there a way to have an account name with different font attributes for 
> part of the name?  I want to have a larger font and bold for part of an 
> account name.
>

Yes, but it must be coded into the string passed to the widget; the widget 
styling accessible through gtk3.css applies only to the whole string. Writing a 
user-usable interface to style parts of the full account name would be an, um, 
interesting challenge for a very experienced Gtk-stack developer.

If that is utterly incomprehensible the simple answer is No.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
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 Dark Theme Needed

[john]

Don't worry too much about formatting. It's an email list, so format it the way 
you would any other plain-text email.

GnuCash isn't a Windows native application so it doesn't know anything about 
Windows theme settings. In general GnuCash obeys the Gtk theme, but there's one 
exception: The green bar display in the register. You can turn that off in 
Preferences>Register by unchecking "Use GnuCash built in color scheme", the 
first item under Graphics.

To get light text on dark, open (create if necessary) 
AppData\Local\gtk-3.0\settings.ini in Notepad or some other plain-text editor. 
Make it look like
[Settings]
gtk-application-prefer-dark-theme=true

To boost the font size create a second file in that directory, gtk.css. In it 
add
#gnc-id-main-window {
font-size: 20pt;
}

See https://wiki.gnucash.org/wiki/GTK3  for 
more ways to style GnuCash.

Regards,
John Ralls


> On Dec 21, 2021, at 1:04 PM, S S  wrote:
> 
> I apologize if my formatting is not appropriate to the list as I can't find 
> anything about how to format posts to the list. My problem right now is that 
> I downloaded GnuCash 4.9 and I can't read anything in the software as it is 
> not honoring/inheriting/adopting Windows 10 High Contrast Dark theme settings 
> properly. Even if I try to invert the colors manually, it is not displaying 
> correctly and the text is upscaling so poorly it is illegible. For instance, 
> in HomeBank, there's an Edit > Preferences option with subset "Interface" 
> that has the options to "override" GTK font to increase the text size and 
> there is a clear option for "Dark theme." These two options make that 
> software accessible to me. Is there anything like this in GnuCash? Are there 
> any other legally blind or low vision users of GnuCash who might be able to 
> help with how they achieved readable text to use the software?
> 
> Thanks Very Much,
> Arc
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Name Fonts

[Jesse MacDougall]

Great question

On Wed., Dec. 22, 2021, 08:24 Gyle McCollam,  wrote:

> Is there a way to have an account name with different font attributes for
> part of the name?  I want to have a larger font and bold for part of an
> account name.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Another Beginner Accounting Question

[Jesse MacDougall]

Just add the total amount of AR that is owed to you from the customer.
KISS (keep it simple sally)

On Wed., Dec. 22, 2021, 03:21 Patrick Skelton, 
wrote:

> Hi,
>
> Just when I was thinking I had accumulated all the pieces of the jigsaw I
> need, I discovered the A/R account.
>
> I have a shop that charges 50% margin on whatever they sell. So, if they
> sell one candle for £12 then I will invoice them only for £6. They get 30
> days credit, so ideally I'd use the A/R system. I've played around with
> this and it seems to do what I expect to the Balance Sheet and Profit &
> Loss Report except for one thing: I seem to lose any record of the 50% of
> the total sales value that they have taken.
>
> There is a Discount column in the invoice but this doesn't seem to show up
> anywhere in the accounts. I'd like to have some record of the money I am
> 'losing' in sales commission, maybe as an expense.
>
> Can anyone offer any advice on how this might best be approached, please?
>
> Kind wishes - Patrick
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Name Fonts

[john]

> On Dec 22, 2021, at 8:23 AM, Gyle McCollam  wrote:
> 
> Is there a way to have an account name with different font attributes for 
> part of the name?  I want to have a larger font and bold for part of an 
> account name.
> 

Yes, but it must be coded into the string passed to the widget; the widget 
styling accessible through gtk3.css applies only to the whole string. Writing a 
user-usable interface to style parts of the full account name would be an, um, 
interesting challenge for a very experienced Gtk-stack developer.

If that is utterly incomprehensible the simple answer is No.

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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Account Name Fonts

[Gyle McCollam]

Is there a way to have an account name with different font attributes for part 
of the name?  I want to have a larger font and bold for part of an account name.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com   email
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Another Beginner Accounting Question

[Michael or Penny Novack]

On 12/22/2021 6:20 AM, Patrick Skelton wrote:

Just when I was thinking I had accumulated all the pieces of the jigsaw I
need, I discovered the A/R account.

I have a shop that charges 50% margin on whatever they sell. So, if they
sell one candle for £12 then I will invoice them only for £6. They get 30
days credit, so ideally I'd use the A/R system. I've played around with
this and it seems to do what I expect to the Balance Sheet and Profit &
Loss Report except for one thing: I seem to lose any record of the 50% of
the total sales value that they have taken.

There is a Discount column in the invoice but this doesn't seem to show up
anywhere in the accounts. I'd like to have some record of the money I am
'losing' in sales commission, maybe as an expense.

The fact that THEY are selling the candle for  £12 has nothing to do 
with you (and your books). You are selling it to them for £6


Correct me if I m wrong, but is this a situation where you are selling 
both "retail" and "wholesale"? And that this is making you perceive that 
you are "losing" the difference between the wholesale price and the 
retail price? Why? What is the ratio of your sales, wholesale vs retail? 
Suppose that it were instead 100% wholesale? Would your perception of 
"loss" still make sense?


<< please note -- these are questions for you to think bout, not give us 
answers to >>


Now suppose the other way around, your business is mostly retail. They 
you might make provisions for a "discount" of 50% for select customers. 
Since I don't use the business features, I can't help with how you set 
that us on the invoice.


I do understand why you see this as a "commissions" expense, but you are 
giving up ownership of the stock to them. At least I think that is how 
you have set things up. In the possible case that you have set things up 
that they can return stock (along with partial payment of the invoice; 
what portion sold) then that is a different situation. I do not know 
what is customary for that sort of business so I strongly suggest you go 
through business accounting texts till you find that specific example.


Michael D Novack

PS -- there are a couple other sorts of (standard) business arrangements 
for which I haven't a clue what is customary. For example, I know that 
businesses that sell "on approval" usually send invoices, but they 
expect some if not often all to be "returns".



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GNC 4.9 build with libicu library versions

[Geert Janssens]

Op woensdag 22 december 2021 05:41:17 CET schreef Mike Commissaris:
> But when I tried to build 4.9 on our office desktop I got the libicu
> version failure. The desktop has:
> kernel 5.10.0
> gcc Debian 8.3.0-6
> cmake 3.13.4
> make 4.2.1
> I had to downgrade and lock to libicu63.1 for successful 4.9 build.
> 
> All other GNC dependencies require a "version or higher" situation.
> So  my question is why are libicu and libicu-dev libraries not the same as
> far as accepting the higher version? Can I upgrade something to allow
> version 67?

Hi Mike,

GnuCash depends on WebkitGtk, which in turn depends on libicu. I know we have 
to version-
lock icu in the Windows build of gnucash to match the icu version that is 
required by 
WebkitGtk. Perhaps it's WebkitGtk as well that's preventing you from using a 
more recent 
version of libicu in your office ?

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Another Beginner Accounting Question

[Patrick Skelton]

Hi,

Just when I was thinking I had accumulated all the pieces of the jigsaw I
need, I discovered the A/R account.

I have a shop that charges 50% margin on whatever they sell. So, if they
sell one candle for £12 then I will invoice them only for £6. They get 30
days credit, so ideally I'd use the A/R system. I've played around with
this and it seems to do what I expect to the Balance Sheet and Profit &
Loss Report except for one thing: I seem to lose any record of the 50% of
the total sales value that they have taken.

There is a Discount column in the invoice but this doesn't seem to show up
anywhere in the accounts. I'd like to have some record of the money I am
'losing' in sales commission, maybe as an expense.

Can anyone offer any advice on how this might best be approached, please?

Kind wishes - Patrick
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.