Re: [GNC] Searching mailing lists

[Brad Morrison]

Hi David/Bo/Derek/GNUCash users, 

FWIW, the current version of Fedora is 41, so 29 is quite, uh, old...
https://fedoramagazine.org/announcing-fedora-linux-41/ &
https://distrowatch.com/table.php?distribution=fedora 

I do not know if the issue with upgrading Fedora to the current version
is hardware related, but if it is, maybe those interested in upgrading
to Fedora 41 in order to upgrade to the current version of Mailman
(01-Oct-2024 Mailman 3.3.10 (Tom Sawyer) - https://www.list.org/) could
chip in a donation to https://gnucash.org/donate.phtml 

---
Thanks, 

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

On 2025-02-12 19:46, David Carlson wrote:

> In defense of Derek, I just checked the Mailman website.  Mailman 2.1 is
> still the default version.  Release 3, while it is considered reliable, it
> is treated as if it is beta software, at least in the sense that there is
> no clearly automated migration path due partly to different infrastructure
> configuration.  see 
> He has life as we all do, and he may not have the time to plan, test and
> execute a migration to release 3.whatever of mailman.
> 
> On Wed, Feb 12, 2025 at 9:19 PM flywire  wrote:
> 
> https://lists.gnucash.org/search/?idxinfo=gnucash-user is useless and
> should be replaced with
> https://www.mail-archive.com/gnucash-user@gnucash.org/maillist.html before
> updating the wiki.
> 
> Bo Buckley wrote
> https://lists.gnucash.org/pipermail/gnucash-user/2025-February/115450.html
> :
> 
> In the docs: https://wiki.gnucash.org/wiki/GnuCash_Forum It claims: 
> * The *GnuCash project* does *not* use ancient *forum* software for its *>* 
> online user support. It uses mailing list technology.*

It's absurd. Let's call it alternative facts: eMail is 50 years old
and Mailman is 25 years old, even Mailman 2.1.19 is from 2018.

I raised https://bugs.gnucash.org/show_bug.cgi?id=797702 about
upgrading to Mailman 3 and received the following reply:

> Derek Atkins 2020-04-25 18:32:15 EDT
> Code runs Fedora 29.  Mailman 3 isn't available on F29.
> When code gets upgraded, mailman will be upgraded.
> As for turning off the reminder; you can turn it off yourself.
> Thank you.

Of course Mailman 3 had run on Fedora 29 for years. My recollection of
Derek's signature at the time:

> Derek Atkins 617-623-3745
> de...@ihtfp.com www.ihtfp.com [1]
> Computer and Internet Security Consultant

In addition to not emailing passwords back to users in clear text I
highlighted through the mailing list Mailman 3 has a forum-like
interface with search facilities.

I understand Derek manages the Mail server for the community and the
configuration isn't public.

Lastly, I acknowledge and thank Derek for the time and effort he
freely gives to me as a member of the community in support of Gnucash.

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.
 

Links:
--
[1] http://www.ihtfp.com
___
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] Searching mailing lists

[Derek Atkins]

Hi.

Issue is not hardware based -- indeed, code runs as a VM, and I've got
other VMs running F41.  It's not a technical issue; it's mostly a matter
of time & effort.  Yes, F29 is old.  I know that.  But upgrading is not an
easy or fast operation.

Code runs a bunch of services, and I'd have to migrate each and every one
of them.  The last time I did this it took me a few weeks, and that was a
relatively minor update!  Also, back then, I had more time (see below).

Just as a case in point, the IETF, which has a cadre of professionals who
are PAID to manage their services, took over a year to migrate their
mailing lists from mailman2 to mailman3.  They had to back out of the
update multiple times.  They had to write special scripts to perform the
migration.  And I believe they STILL run a custom front-end UI.   I don't
know if ANY of that code/effort was donated back to the MM3 team.

I'm just one guy, with a full time $DayJob.  I manage the GnuCash server
in my spare time, which has grown smaller and smaller as my kids have aged
up into the range where they are doing sports nearly every weekend.  While
I have time to maintain the status quo, I don't have time for a major
project like a MM2 -> MM3 migration.

I tend to only upgrade the distro every couple years.  "If it aint
broke"  So THAT is why code is still running such an old distro.  It
was built in 2017 with F25.  It took a week to build and test the system
before I migrated the data from the previous system.  Another few weeks to
stabilize the system.. I then upgraded to F29 in 2019.   After that, well,
Covid and Real Life hit.   I haven't looked back because "it works", and
then because MM2 was "removed" in F35.  This means I could only update up
to F34 -- but what's the point now?

I hope this explains the current status.

Thanks,

-derek

On Fri, February 14, 2025 9:11 am, Brad Morrison wrote:
> Hi David/Bo/Derek/GNUCash users,
>
> FWIW, the current version of Fedora is 41, so 29 is quite, uh, old...
> https://fedoramagazine.org/announcing-fedora-linux-41/ &
> https://distrowatch.com/table.php?distribution=fedora
>
> I do not know if the issue with upgrading Fedora to the current version
> is hardware related, but if it is, maybe those interested in upgrading
> to Fedora 41 in order to upgrade to the current version of Mailman
> (01-Oct-2024 Mailman 3.3.10 (Tom Sawyer) - https://www.list.org/) could
> chip in a donation to https://gnucash.org/donate.phtml
>
> ---
> Thanks,
>
> Brad - https://www.facebook.com/brad.morrison.12327/ &
> https://nextdoor.com/profile/01mP46jj8KCzj3sP4 &
> https://norcal.social/@BradMorrison
>
> On 2025-02-12 19:46, David Carlson wrote:
>
>> In defense of Derek, I just checked the Mailman website.  Mailman 2.1 is
>> still the default version.  Release 3, while it is considered reliable,
>> it
>> is treated as if it is beta software, at least in the sense that there
>> is
>> no clearly automated migration path due partly to different
>> infrastructure
>> configuration.  see 
>> He has life as we all do, and he may not have the time to plan, test and
>> execute a migration to release 3.whatever of mailman.
>>
>> On Wed, Feb 12, 2025 at 9:19 PM flywire  wrote:
>>
>> https://lists.gnucash.org/search/?idxinfo=gnucash-user is useless and
>> should be replaced with
>> https://www.mail-archive.com/gnucash-user@gnucash.org/maillist.html
>> before
>> updating the wiki.
>>
>> Bo Buckley wrote
>> https://lists.gnucash.org/pipermail/gnucash-user/2025-February/115450.html
>> :
>>
>> In the docs: https://wiki.gnucash.org/wiki/GnuCash_Forum It claims:
>> * The *GnuCash project* does *not* use ancient *forum* software for its
>> *>* online user support. It uses mailing list technology.*
>
> It's absurd. Let's call it alternative facts: eMail is 50 years old
> and Mailman is 25 years old, even Mailman 2.1.19 is from 2018.
>
> I raised https://bugs.gnucash.org/show_bug.cgi?id=797702 about
> upgrading to Mailman 3 and received the following reply:
>
>> Derek Atkins 2020-04-25 18:32:15 EDT
>> Code runs Fedora 29.  Mailman 3 isn't available on F29.
>> When code gets upgraded, mailman will be upgraded.
>> As for turning off the reminder; you can turn it off yourself.
>> Thank you.
>
> Of course Mailman 3 had run on Fedora 29 for years. My recollection of
> Derek's signature at the time:
>
>> Derek Atkins 617-623-3745
>> de...@ihtfp.com www.ihtfp.com [1]
>> Computer and Internet Security Consultant
>
> In addition to not emailing passwords back to users in clear text I
> highlighted through the mailing list Mailman 3 has a forum-like
> interface with search facilities.
>
> I understand Derek manages the Mail server for the community and the
> configuration isn't public.
>
> Lastly, I acknowledge and thank Derek for the time and effort he
> freely gives to me as a member of the community in support of Gnucash.
>
> Regards
> __

Re: [GNC] Searching mailing lists

[flywire]

https://lists.gnucash.org/pipermail/gnucash-user/2025-February/115508.html
Derek
Atkins wrote:
>
> I tend to only upgrade the distro every couple years.  "If it
> aint broke"  So THAT is why code is still running such an old distro.


That is not the reality. It is an old platform with issues without a
reasonable migration path. This is exactly why many old forums are archived
when they are ultimately upgraded.

https://wiki.gnucash.org/wiki/index.php?title=Mailing_Lists&oldid=13014#Searching_the_List_Archives
(15 September 2017‎)

> Currently, there is no on-site mechanism to search the mailing lists *and
> the search link on the archive page is broken*.


Is updating https://lists.gnucash.org/search/?idxinfo=gnucash-user
achievable in
the interim?

Contrary to Liz's experience with duckduckgo I don't have success with
Google.

Regards
[image: image.png]
___
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] version 5.10 - how to adjust fonts/ font size?

[Gilberto Reis Filho]

Create/edit a text file in your AppData/Roaming folder (if you are on
Windows) named gtk-3.0.css

Put this code in this file and save it:

*{
  font: 10pt Calibri, sans-serif;
}

Change font and size as needed to meet what you need.

Regards


-

Hi Gerry/GNUCash users,

Some basics:

What operating system are you using?

What version of GNUCash are you
using?https://www.gnucash.org/download.phtml - 5.10 is the current
release
https://wiki.gnucash.org/wiki/GTK3#Typefaces - this is not a great
description of how to setting a default font and size for GnuCash, but
it is what is on the GNUCash Wiki...

---
Thanks,

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

On 2025-02-13 17:01, Gerry Starnes via gnucash-user wrote:

>* The fonts or font size is so small that they are difficult to read. I can't 
>find any way to adjust them or the kerning so I don't need readers and an 
>occasional magnifying glass.
*> >* Any suggestions as to where I should make font or font size adjustments?
*> >* Gerry Starnes
*>* gstarnes at me.com 
*> >* ___
*>* gnucash-user mailing list
*>* gnucash-user at 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] version 5.10 - how to adjust fonts/ font size?

[Phyllis Bruce]

Now, if someone could work out how to reduce the width of the description
field so these larger fonts would fit in their columns on the screen - and
stay that way!.

po

On Fri, Feb 14, 2025 at 4:13 PM Gilberto Reis Filho <
gilberto.reis.fi...@gmail.com> wrote:

> Create/edit a text file in your AppData/Roaming folder (if you are on
> Windows) named gtk-3.0.css
>
> Put this code in this file and save it:
>
> *{
>   font: 10pt Calibri, sans-serif;
> }
>
> Change font and size as needed to meet what you need.
>
> Regards
>
>
> -
>
> Hi Gerry/GNUCash users,
>
> Some basics:
>
> What operating system are you using?
>
> What version of GNUCash are you
> using?https://www.gnucash.org/download.phtml - 5.10 is the current
> release
> https://wiki.gnucash.org/wiki/GTK3#Typefaces - this is not a great
> description of how to setting a default font and size for GnuCash, but
> it is what is on the GNUCash Wiki...
>
> ---
> Thanks,
>
> Brad - https://www.facebook.com/brad.morrison.12327/
> &https://nextdoor.com/profile/01mP46jj8KCzj3sP4
> &https://norcal.social/@BradMorrison
>
> On 2025-02-13 17:01, Gerry Starnes via gnucash-user wrote:
>
> >* The fonts or font size is so small that they are difficult to read. I
> can't find any way to adjust them or the kerning so I don't need readers
> and an occasional magnifying glass.
> *> >* Any suggestions as to where I should make font or font size
> adjustments?
> *> >* Gerry Starnes
> *>* gstarnes at me.com <
> https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> *> >* ___
> *>* gnucash-user mailing list
> *>* gnucash-user at gnucash.org
> 
> *>* To update your subscription preferences or to unsubscribe:
> *>* https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 
> *>* -
> *>* Please remember to CC this list on all your replies.
> *>* You can do this by using Reply-To-List or Reply-All.*
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exchange Rate to Price Database issue with low transactions amounts

[Bo Buckley]

Thanks so much for digging into this John.

Yes, I can confirm that after updating using flatpak to 5.10 I also no
longer see this issue. I'm not familiar with the code base whatsoever, but
I'm also surprised that commit is related to this issue.

If the "fix" can't be explained, it may be worth adding some sort of
check/warning system for this. Two rough ideas come to mind:

1. Make an independent memory copy of the value of the user entered
Exchange Rate when a user presses ok in the Transfer Funds dialog and check
this against the value to be written to the Price Database. As you
explained, this isn't expected to be an exact match, but something as
simple as a console warning/error when the value is off by > X% would at
least make it visible if it ever appeared again. The idea being that so
long as the copy of the Exchange Rate is independent, and not used
elsewhere other than this test, any shared memory errors that may be
unintentionally introduced by compilation/etc can be identified at runtime.
2. Some unit test that mimics the test I created to exemplify this issue.
Is there any way to recreate this behavior programmatically rather than gui
clicks?

Otherwise this may reappear accidentally sometime in the future and since
it is a silent error, I'd be worried about this indefinitely.

Thanks again!

On Fri, Feb 14, 2025 at 1:17 PM John Ralls  wrote:

> Bo,
>
> I tried your example file and CSV import today and found that I could
> reproduce the incorrect rounding behavior in 5.9 but not in 5.10. I did a
> bisect (a binary search through the commits, building and testing at each
> stop) to locate exactly what commit fixed it. It was
> https://github.com/Gnucash/gnucash/pull/2otherwise036
>  and the fix was completely
> accidental. Even in retrospect I can’t explain why the rounding was wrong
> before that change and is correct after it. I did double-check by reverting
> it on current stable and observing that the bad rounding reappears.
>
> So upgrade to 5.10 and you’ll be able to import your CSV file.
>
> Regards,
> John Ralls
>
>
> On Feb 12, 2025, at 01:00, Bo Buckley  wrote:
>
> Dear Jim,
>
> Thank you for your reply.
>
> After b), you enter an exchange rate in the Exchange Rate field, press tab
>> to move focus out of that field. See if the exchange rate in the equation
>> to the right updates with the Exchange Rate you supplied.
>
>
> Yes, it updates as expected, but does not change the observed behavior
> after pressing OK.
>
> Another thing to try is to click the radio button by Debit Amount in the
>> Transfer Funds dialogue, then in that field, enter a formula of > as a positive number> * 0.0066 . I expect Gnucash can calculate a USD debit
>> amount and put it in that field.  If the amount is a whole number of
>> dollars, that is further evidence of a bug.
>>
>
> Results for same test.csv import set:
> Date Description Transaction Amount DebitAmountGivenInTransferFundsDialog
> ExchangeRateRecordedInPriceDatabase
> 2025/01/29 Transfer Fee 20 270*0.0066 89/13500
> 2025/01/29 Transfer Fee 110 175*0.0066 -29/4375
> 2025/01/29 Transfer Fee 175 110*0.0066 -29/4375
> 2025/01/29 Transfer Fee 270 20*0.0066 -0.0065
>
> Note the header change from before as now I am entering the Debit amount
> and not the Exchange Rate as requested. This is even more bizzare, but I
> wasn't sure why you recommended using the positive JPY value so I tried
> with the negative and got:
>
> Date Description Transaction Amount DebitAmountGivenInTransferFundsDialog
> ExchangeRateRecordedInPriceDatabase
> 2025/01/29 Transfer Fee 20 -270*0.0066 89/13500
> 2025/01/29 Transfer Fee 110 -175*0.0066 89/13500
> 2025/01/29 Transfer Fee 175 -110*0.0066 89/13500
> 2025/01/29 Transfer Fee 270 -20*0.0066 0.0065
>
> which looks more reasonable. Although this doesn't really work as a
> workaround as the real-world scenario isn't all for transactions for a
> single date (i.e. I'd have to manually look up the exchange rate for each
> date and input it into this Debit field for every transaction, over an
> entire year of transactions). That sounds about as efficient as pen and
> paper over GNUcash :D, so I hope to avoid that if possible.
>
> Assuming I make a temporary JPY expense account duplicate for everything.
> Is there an efficient way of pushing these back to a USD expense account
> after this bug is resolved? Or would that just be pushing off the
> inevitable requirement for manually typing out every transaction again?
>
> Thanks again.
>
> On Wed, Feb 12, 2025 at 7:33 AM Jim DeLaHunt 
> wrote:
>
>> Bo:
>>
>> On 2025-02-11 04:30, Bo Buckley wrote:
>> > Dear John,
>> >
>> > Thanks for your time again. I uploaded the video, test.gnucash and the
>> > test.csv file used to import the example transactions to my Network
>> > Accesible Storage. You should have public access here:
>> >
>> > https://gofile.me/7Ad2L/z8EsrYEzD
>>
>> I was able to watch your "output.mp4" video. Good idea to post it! I

Re: [GNC] version 5.10 - how to adjust fonts/ font size?

[David H]

Not too difficult having just set my default font to "font: 20px arial;" to
cater for my aging eyes :-)  Start with the right hand column header
(Balance in my case) and double click it to automatically set the column
width. Don't worry if it goes off the edge of the screen for now.  Do the
same for all of the column headers working from right to left i.e. from
Balance to Date columns in turn but skipping over the Description column.
The Description column is a special case and always expands to use the
remaining space.  Sometimes this process results in one or more of the
columns on the right being pushed off the  screen so what I do to reset the
width of the Description column is to left mouse "click and hold" the
column divider on the right side of the Description column and flick it 2-3
cms to the left and let go of the mouse button although I assume just
dragging left and releasing the mouse button would probably also do the
trick.  This usually reduces the width of the Description column to fit and
brings any columns that have been pushed too far to the right back into
view.  Unfortunately you may have to do this for each register but it is
what it is :-)

Hope this helps, Cheers David H.


On Sat, 15 Feb 2025 at 08:24, Phyllis Bruce  wrote:

> Now, if someone could work out how to reduce the width of the description
> field so these larger fonts would fit in their columns on the screen - and
> stay that way!.
>
> po
>
> On Fri, Feb 14, 2025 at 4:13 PM Gilberto Reis Filho <
> gilberto.reis.fi...@gmail.com> wrote:
>
> > Create/edit a text file in your AppData/Roaming folder (if you are on
> > Windows) named gtk-3.0.css
> >
> > Put this code in this file and save it:
> >
> > *{
> >   font: 10pt Calibri, sans-serif;
> > }
> >
> > Change font and size as needed to meet what you need.
> >
> > Regards
> >
> >
> > -
> >
> > Hi Gerry/GNUCash users,
> >
> > Some basics:
> >
> > What operating system are you using?
> >
> > What version of GNUCash are you
> > using?https://www.gnucash.org/download.phtml - 5.10 is the current
> > release
> > https://wiki.gnucash.org/wiki/GTK3#Typefaces - this is not a great
> > description of how to setting a default font and size for GnuCash, but
> > it is what is on the GNUCash Wiki...
> >
> > ---
> > Thanks,
> >
> > Brad - https://www.facebook.com/brad.morrison.12327/
> > &https://nextdoor.com/profile/01mP46jj8KCzj3sP4
> > &https://norcal.social/@BradMorrison
> >
> > On 2025-02-13 17:01, Gerry Starnes via gnucash-user wrote:
> >
> > >* The fonts or font size is so small that they are difficult to read. I
> > can't find any way to adjust them or the kerning so I don't need readers
> > and an occasional magnifying glass.
> > *> >* Any suggestions as to where I should make font or font size
> > adjustments?
> > *> >* Gerry Starnes
> > *>* gstarnes at me.com <
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> > *> >* ___
> > *>* gnucash-user mailing list
> > *>* gnucash-user at gnucash.org
> > 
> > *>* To update your subscription preferences or to unsubscribe:
> > *>* https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > 
> > *>* -
> > *>* Please remember to CC this list on all your replies.
> > *>* You can do this by using Reply-To-List or Reply-All.*
> > ___
> > gnucash-user mailing list
> > gnucash-user@gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] version 5.10 - how to adjust fonts/ font size?

[Brad Morrison]

Hi Gerry/GNUCash users, 

Some basics: 

What operating system are you using? 

What version of GNUCash are you using?
https://www.gnucash.org/download.phtml - 5.10 is the current release 

https://wiki.gnucash.org/wiki/GTK3#Typefaces - this is not a great
description of how to setting a default font and size for GnuCash, but
it is what is on the GNUCash Wiki... 

---
Thanks, 

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

On 2025-02-13 17:01, Gerry Starnes via gnucash-user wrote:

> The fonts or font size is so small that they are difficult to read. I can't 
> find any way to adjust them or the kerning so I don't need readers and an 
> occasional magnifying glass. 
> 
> Any suggestions as to where I should make font or font size adjustments?
> 
> Gerry Starnes
> gstar...@me.com
> 
> ___
> 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] version 5.10 - how to adjust fonts/ font size?

[sunfish62--- via gnucash-user]

For the record, you can also double click the Description column and get it to 
adjust. 

Simplifies the process. 

As for the "repeat for every register" comment, it is possible to edit the 
settings file (*.gcm somewhere, I believe) that controls column widths for all 
accounts and find/replace all to use a specific setting. It's not ideal, but it 
does get some measure of sanity to register displays. (Usual warnings about 
editing settings files outside the app apply, although a borked gcm can simply 
be deleted and GnuCash will regenerate it.)

There may also be a setting for the default register geometry, but that's above 
my pay grade. 

⁣David T. ​

On Feb 15, 2025, 6:08 AM, at 6:08 AM, David H  wrote:
>Not too difficult having just set my default font to "font: 20px
>arial;" to
>cater for my aging eyes :-)  Start with the right hand column header
>(Balance in my case) and double click it to automatically set the
>column
>width. Don't worry if it goes off the edge of the screen for now.  Do
>the
>same for all of the column headers working from right to left i.e. from
>Balance to Date columns in turn but skipping over the Description
>column.
>The Description column is a special case and always expands to use the
>remaining space.  Sometimes this process results in one or more of the
>columns on the right being pushed off the  screen so what I do to reset
>the
>width of the Description column is to left mouse "click and hold" the
>column divider on the right side of the Description column and flick it
>2-3
>cms to the left and let go of the mouse button although I assume just
>dragging left and releasing the mouse button would probably also do the
>trick.  This usually reduces the width of the Description column to fit
>and
>brings any columns that have been pushed too far to the right back into
>view.  Unfortunately you may have to do this for each register but it
>is
>what it is :-)
>
>Hope this helps, Cheers David H.
>
>
>On Sat, 15 Feb 2025 at 08:24, Phyllis Bruce 
>wrote:
>
>> Now, if someone could work out how to reduce the width of the
>description
>> field so these larger fonts would fit in their columns on the screen
>- and
>> stay that way!.
>>
>> po
>>
>> On Fri, Feb 14, 2025 at 4:13 PM Gilberto Reis Filho <
>> gilberto.reis.fi...@gmail.com> wrote:
>>
>> > Create/edit a text file in your AppData/Roaming folder (if you are
>on
>> > Windows) named gtk-3.0.css
>> >
>> > Put this code in this file and save it:
>> >
>> > *{
>> >   font: 10pt Calibri, sans-serif;
>> > }
>> >
>> > Change font and size as needed to meet what you need.
>> >
>> > Regards
>> >
>> >
>> > -
>> >
>> > Hi Gerry/GNUCash users,
>> >
>> > Some basics:
>> >
>> > What operating system are you using?
>> >
>> > What version of GNUCash are you
>> > using?https://www.gnucash.org/download.phtml - 5.10 is the current
>> > release
>> > https://wiki.gnucash.org/wiki/GTK3#Typefaces - this is not a great
>> > description of how to setting a default font and size for GnuCash,
>but
>> > it is what is on the GNUCash Wiki...
>> >
>> > ---
>> > Thanks,
>> >
>> > Brad - https://www.facebook.com/brad.morrison.12327/
>> > &https://nextdoor.com/profile/01mP46jj8KCzj3sP4
>> > &https://norcal.social/@BradMorrison
>> >
>> > On 2025-02-13 17:01, Gerry Starnes via gnucash-user wrote:
>> >
>> > >* The fonts or font size is so small that they are difficult to
>read. I
>> > can't find any way to adjust them or the kerning so I don't need
>readers
>> > and an occasional magnifying glass.
>> > *> >* Any suggestions as to where I should make font or font size
>> > adjustments?
>> > *> >* Gerry Starnes
>> > *>* gstarnes at me.com <
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> > *> >* ___
>> > *>* gnucash-user mailing list
>> > *>* gnucash-user at gnucash.org
>> > 
>> > *>* To update your subscription preferences or to unsubscribe:
>> > *>* https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > 
>> > *>* -
>> > *>* Please remember to CC this list on all your replies.
>> > *>* You can do this by using Reply-To-List or Reply-All.*
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> >
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>_

Re: [GNC] Trading Accounts Balance

[Bo Buckley]

Dear John,

Thank you for your reply.

I don’t understand what you mean by “zero this out for today”.


Maybe I misunderstood what you meant when you said,

If the net gains aren’t taxable then you can book them to a separate
> non-taxable income account.


Say I'm doing my US reporting, and this transfer from USD to JPY wouldn't
be taxable (as far as I know, only the opposite would be). Then to "book
them to a separate non-taxable income account" would involve what exactly?
Say I had an Income:NonTaxable account, what would the transaction look
like? I apparently can't offset a debit to Income:NonTaxable with either
Trading account, so not sure what this would look like.

Thanks again.

On Fri, Feb 14, 2025 at 10:38 AM John Ralls  wrote:

> Bo,
>
> I don’t understand what you mean by “zero this out for today”.
>
> The Totals column on the Accounts page presents the ending balance for
> each account (even if that’s in the future), converted to the book currency
> using the most recent exchange rate available from the account’s commodity
> to the book currency.
>
> The manually created trading splits will look just like the automatically
> created ones. The difference will be that you have to create them yourself,
> selecting the taxable or non-taxable balance. Remember that the trading
> accounts are outside of the accounting equation and exist to help you keep
> track of your conversions into and out of commodities so that you book the
> gains and losses and keep your overall book in balance. The goal of
> splitting the trading accounts would be to make it clearer which trading
> gains income account—taxable or not-taxable—needs to be adjusted to balance
> your book. Mind that I’m not an accountant and even if I was I wouldn’t be
> *your* accountant. I also have no experience as an ex-pat paying US taxes
> on income earned in somebody else’s currency.
>
> One other thing to be aware of: The register displays currency differently
> depending on whether trading accounts are enabled: When they’re enabled the
> debit and credit numbers represent the amount in the split’s account’s
> commodity; when trading accounts are off the credit and debit numbers are
> the values in the current register’s account’s currency. In other words
> with trading accounts off all of the amounts in your JapaneseChecking
> register will be JPY and in Banking Service Fees they’ll all be USD.
>
> Regards,
> John Ralls
>
>
> On Feb 13, 2025, at 16:39, Bo Buckley  wrote:
>
> Thank you for your reply John,
>
> >If the net gains aren’t taxable then you can book them to a separate
> non-taxable income account.
>
> Even if I zero this out for today as an example, won't the Trading account
> balance continue to fluctuate even after doing so as new price entries come
> on day to day? I'm trying to understand how to finalize the transaction in
> the same way I would wrap up a GOOG stock sale (i.e. I would never expect
> to keep tracking unrealized gains/losses on the idea that the USD received
> from the stock sale is waiting to be "sold" to return back to GOOG.
>
> >GnuCash also can’t automatically handle multiple trading accounts per
> commodity. If you need that you’ll have to turn off trading accounts in
> File>Properties and manage the trading accounts and splits manually.
>
> Assuming I turn it off, do you have an example transaction to help me
> understand what you're proposing here? I'm not sure I understand what this
> would solve.
>
> Thanks in advance.
>
>
>
> On Fri, Feb 14, 2025, 02:37 John Ralls  wrote:
>
>>
>>
>> > On Feb 13, 2025, at 01:19, Bo Buckley  wrote:
>> >
>> > In the foreign currency docs:
>> > https://gnucash.org/docs/v5/C/gnucash-guide/currency_trading_accts.html
>> >
>> > The Trading and CURRENCY placeholder accounts now indicate a modest
>> >> realized loss of 0.82 USD on the currency transactions.
>> >
>> >
>> > it appears to explain that the Trading top-most account balance
>> represents
>> > a loss if positive or a gain if negative. I only have a single
>> transaction
>> > so far that involves converting USD to JPY for a transfer. See attached
>> for
>> > the transaction. The Trading account already shows a balance of 247.38
>> USD.
>> > How does this make sense? I didn't lose money on the transfer (other
>> than
>> > the fee). It appears this balance is calculated based on the most recent
>> > Price Database entry for the currency (i.e. JPY at 0.0066 for
>> 02/09/2025). :
>> > 4,964.32 - (714,688* 0.0066) = 247.38.
>> >
>> > It seems to be interpreting a currency exchange from 1/9/2024 as a loss
>> > even though at the time of the trade it was not a loss. How am I to
>> > interpret this and what is this Trading Balance used for elsewhere? I
>> don't
>> > want it unintentionally affecting some other report calculations.
>> >
>> > For the sake of clarification, lets compare this behavior to stock
>> trading.
>> > USD and JPY are two commodities, just like USD and GOOG. For my example
>> > transfer from USD to JP

[GNC] Reporting Exchange Rates

[Bo Buckley]

In all examples I've seen so far with regards to the handling of foreign
currencies the user is physically moving money from one currency to another
(e.g. an online transfer) where an actual exchange occurs. What about the
case where users have to do reports for different countries in their own
respective currency (e.g. Japan in JPY and US in USD). I must report all
income in both Japan and the US (thanks IRS!) so I need a way to convert my
books between USD and JPY.

For example say I have an Expenses:Advertising account with account
currency USD and book currency USD. I can deduct these as business expenses
both on US and Japanese reports, but I must convert them all to JPY to do
so. Is there any way of doing this within GNUcash? Until now I've just been
creating an Income Statement in USD and copying this to a spreadsheet and
converting from there (not ideal).

I see in the Income Statement options, I can change the Report's currency
to JPY, but what is going on in the background here? Are all transactions
converted per date, or just a single rate used on the totals? Based on what
I can see at the bottom of the report, it appears to use the most recent
rate limited by the report ending date (e.g. 12/31/2024), which would not
be a standard way to report this. The two options I was told from a
Japanese accountant to use would be
1. (Yearly Average TTS + Yearly Average TTB) / 2  from a Japanese bank
(e.g. https://www.murc-kawasesouba.jp/fx/year_average.php)
2. (Preferred) Use exchange rates specific to each transaction.

Thanks in advance for any advice.
___
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.