Re: [GNC] Calculation of Unrealized Losses

[John Ralls]

David is referring to https://bugs.gnucash.org/show_bug.cgi?id=797796, which is 
probably the issue you're seeing: You have some three-commodity transactions 
involving USD, CAD, and a Vanguard fund and the average-cost algorithm used in 
the trial balance report doesn't work well in that case.

Regards,
John Ralls




> On May 2, 2022, at 7:54 PM, David Carlson  wrote:
> 
> Bill,
> 
> If I recall correctly, one or more of the methods GnuCash uses to calculate
> exchange rates for reports is technically not correctly defined , so it
> obscures the  fact that it is not calculating the expected value.  That is
> leading to strange results when, for example, one attempts to do a trial
> balance.   I know very little about accounting so I cannot tell you details
> about that.
> 
> Some of the developers can help with some of those issues.  Hopefully they
> can at least tell you which calculation methods to avoid when you want
> accurate results .
> 
> On Mon, May 2, 2022, 9:27 PM Bill Dika  wrote:
> 
>> Can anyone help me with this?
>> 
>> Do I have to supply more/different information?
>> 
>> I have been using gnucash personally for a couple of years now and would
>> like to develop more confidence in the program.
>> 
>> Thank you in advance for your help.
>> 
>> Bill Dika
>> 
>> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika  wrote:
>> 
>>> My default currency is Canadian dollars. I have some US dollar
>>> accounts in my balance sheet.
>>> 
>>> I have an unrealized loss in the equity section of my balance sheet at
>>> July 31 2021 of $12.68 and cannot figure out how it was calculated. I
>>> also have US dollar accounts expressed in Canadian dollars that I am
>>> unable to determine how the translation from US dollars to Canadian
>>> dollars occurs.
>>> 
>>> For example I have a US dollar account of $353.75 for Tesla (see
>>> us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22
>>> in Canadian dollars at July 31 2021 (see
>>> us-dollar-accts-july-31-2021.png). This is an exchange rate of
>>> 1.28966. I am unable to figure out how Gnucash arrives at that rate
>>> (see us-dollar-rates-price-database.png). It is not the rate at July
>>> 31 2021. It is not the average rate for all rates I have up to July 31
>>> 2021 and it is not the average rate for all rates I have in the price
>>> database.
>>> 
>>> Also the $12.68 loss arises from only one change in the US dollar
>>> accounts from June 30 2021 to July 31 2021. That is a $524.80 US
>>> dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see
>>> change-in-us-dollar-acct-july-2021.png).
>>> 
>>> Attached are images of the following:
>>> equity-jun-30-2021.png = showing the equity section almost balanced
>>> (.01 unrealized gain) (in Canadian dollars)
>>> equity-july-31-2021.png = showing the $12.68 unrealized loss (in
>>> Canadian dollars)
>>> us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts
>>> (in US dollars)
>>> us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian
>>> dollars)
>>> us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet
>>> accounts (in US dollars)
>>> us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian
>>> dollars)
>>> change-in-us-dollar-acct-july-2021.png = shows the only change in the
>>> US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US
>>> dollars)
>>> us-dollar-rates-price-database.png = all the US to Canadian exchange
>>> rates in my database
>>> 
>>> I am a Canadian CPA and feel quite confident about the accounting in
>>> the gnucash file. I have reviewed the journal entries for the period
>>> and they all balance. The only thing I can ascertain is that the
>>> unrealized loss arises from the US dollar accounts but I cannot figure
>>> out how gnucash is calculating it nor can I figure out how gnucash
>>> translates US dollars to Canadian dollars for those accounts.
>>> 
>>> I have searched the list but cannot find anything that helps me in my
>>> calculation.
>>> 
>>> I am on Arch linux using Gnucash 4.9.
>>> 
>>> Any help would be much appreciated.
>>> 
>>> Thank you.
>>> 
>>> Bill Dika
>>> 
>> ___
>> 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 lis

Re: [GNC] Calculation of Unrealized Losses

[John Ralls]

No need, we all read this one too.

Regards,
John Ralls


> On May 5, 2022, at 9:52 AM, Bill Dika  wrote:
> 
> Thanks David.
> 
> I'll try the gnucash developers list.
> 
> Bill Dika
> 
> On Mon, May 2, 2022 at 10:54 PM David Carlson 
> wrote:
> 
>> Bill,
>> 
>> If I recall correctly, one or more of the methods GnuCash uses to
>> calculate exchange rates for reports is technically not correctly defined ,
>> so it obscures the  fact that it is not calculating the expected value.
>> That is leading to strange results when, for example, one attempts to do a
>> trial balance.   I know very little about accounting so I cannot tell you
>> details about that.
>> 
>> Some of the developers can help with some of those issues.  Hopefully they
>> can at least tell you which calculation methods to avoid when you want
>> accurate results .
>> 
>> On Mon, May 2, 2022, 9:27 PM Bill Dika  wrote:
>> 
>>> Can anyone help me with this?
>>> 
>>> Do I have to supply more/different information?
>>> 
>>> I have been using gnucash personally for a couple of years now and would
>>> like to develop more confidence in the program.
>>> 
>>> Thank you in advance for your help.
>>> 
>>> Bill Dika
>>> 
>>> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika  wrote:
>>> 
 My default currency is Canadian dollars. I have some US dollar
 accounts in my balance sheet.
 
 I have an unrealized loss in the equity section of my balance sheet at
 July 31 2021 of $12.68 and cannot figure out how it was calculated. I
 also have US dollar accounts expressed in Canadian dollars that I am
 unable to determine how the translation from US dollars to Canadian
 dollars occurs.
 
 For example I have a US dollar account of $353.75 for Tesla (see
 us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22
 in Canadian dollars at July 31 2021 (see
 us-dollar-accts-july-31-2021.png). This is an exchange rate of
 1.28966. I am unable to figure out how Gnucash arrives at that rate
 (see us-dollar-rates-price-database.png). It is not the rate at July
 31 2021. It is not the average rate for all rates I have up to July 31
 2021 and it is not the average rate for all rates I have in the price
 database.
 
 Also the $12.68 loss arises from only one change in the US dollar
 accounts from June 30 2021 to July 31 2021. That is a $524.80 US
 dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see
 change-in-us-dollar-acct-july-2021.png).
 
 Attached are images of the following:
 equity-jun-30-2021.png = showing the equity section almost balanced
 (.01 unrealized gain) (in Canadian dollars)
 equity-july-31-2021.png = showing the $12.68 unrealized loss (in
 Canadian dollars)
 us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts
 (in US dollars)
 us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian
 dollars)
 us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet
 accounts (in US dollars)
 us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian
 dollars)
 change-in-us-dollar-acct-july-2021.png = shows the only change in the
 US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US
 dollars)
 us-dollar-rates-price-database.png = all the US to Canadian exchange
 rates in my database
 
 I am a Canadian CPA and feel quite confident about the accounting in
 the gnucash file. I have reviewed the journal entries for the period
 and they all balance. The only thing I can ascertain is that the
 unrealized loss arises from the US dollar accounts but I cannot figure
 out how gnucash is calculating it nor can I figure out how gnucash
 translates US dollars to Canadian dollars for those accounts.
 
 I have searched the list but cannot find anything that helps me in my
 calculation.
 
 I am on Arch linux using Gnucash 4.9.
 
 Any help would be much appreciated.
 
 Thank you.
 
 Bill Dika
 
>>> ___
>>> 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.
> Y

Re: [GNC] QFX file for Bank of American business account not

[Peter Wu]

There is no such an option to download other versions. My other options are cvs 
files.

Sent from my iPhone

On May 5, 2022, at 11:59 AM, Kalpesh Patel  wrote:


You mentioned that you downloaded file using  “Web Connect for Quicken 2018 and 
above?”. Can you try to download 2017 or earlier version and import it to see 
if that is abiding by stricter OFX format and happily works with GNC?

___
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] QFX file for Bank of American business account not

[Kalpesh Patel]

You mentioned that you downloaded file using  "Web Connect for Quicken 2018
and above?". Can you try to download 2017 or earlier version and import it
to see if that is abiding by stricter OFX format and happily works with GNC?

 

___
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] Change layout and font sizes in Transaction Report - how?

[Chris Green]

On Thu, May 05, 2022 at 01:13:06PM -0500, Adrien Monteleone wrote:
> I just played around with it on the Transaction Report and came up with
> this:
> 
> td:first-child {
>   font-weight: bold;
>   font-size: large;
> }
> 
> The Account Name doesn't have a class or id to target, but it just so
> happens to be always the first td child of a new tr element in the entire
> report. (best I can tell, I didn't play with all options)
> 
> Give that a go.
> 
> I do see prominent Account Totals but I agree, the initial Account Name
> starting each section should be more noticeable.
> 
That's clever!  I'd looked at the output HTML but I didn't know about
the "first child" modifier.  I'll certainly try it, thank you.

-- 
Chris Green
___
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] Change layout and font sizes in Transaction Report - how?

[Chris Green]

On Thu, May 05, 2022 at 12:59:55PM -0500, Adrien Monteleone wrote:
> 
> On 5/5/22 3:12 AM, Chris Green wrote:
> > Is there any guarantee that the CSS Stylesheet wll allow me to access
> > every selector I can see in the HTML output?  I guess I can simply
> > take a look and try it out.
> > 
> The old built-in 'stylesheets' probably do not. But there is a CSS-based
> (experimental) sheet that is just open text. You spec any id or class or
> element you want with your chosen rules.
> 
Yes, exactly, that's why I asked the question! :-)  I was referring to
the 'experimental' CSS style sheet.

However on looking at the Transaction Report HTML there's no selector
(class or anything) for the sub-account heading so it's not possible
(as far as I can see) to do what I want with the CSS Stylesheet.

-- 
Chris Green
___
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] Change layout and font sizes in Transaction Report - how?

[Adrien Monteleone]

I just played around with it on the Transaction Report and came up with 
this:


td:first-child {
  font-weight: bold;
  font-size: large;
}

The Account Name doesn't have a class or id to target, but it just so 
happens to be always the first td child of a new tr element in the 
entire report. (best I can tell, I didn't play with all options)


Give that a go.

I do see prominent Account Totals but I agree, the initial Account Name 
starting each section should be more noticeable.


Regards,
Adrien

On 5/5/22 12:59 PM, Adrien Monteleone wrote:
The old built-in 'stylesheets' probably do not. But there is a CSS-based 
(experimental) sheet that is just open text. You spec any id or class or 
element you want with your chosen rules.


Mind you, GnuCash uses Webkit for rendering, so you need to check 
caniuse.com if you are unsure about a rule working as expected.



Regards,
Adrien

On 5/5/22 3:12 AM, Chris Green wrote:

Is there any guarantee that the CSS Stylesheet wll allow me to access
every selector I can see in the HTML output?  I guess I can simply
take a look and try it out.


___
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] Change layout and font sizes in Transaction Report - how?

[Adrien Monteleone]

The old built-in 'stylesheets' probably do not. But there is a CSS-based 
(experimental) sheet that is just open text. You spec any id or class or 
element you want with your chosen rules.


Mind you, GnuCash uses Webkit for rendering, so you need to check 
caniuse.com if you are unsure about a rule working as expected.



Regards,
Adrien

On 5/5/22 3:12 AM, Chris Green wrote:

Is there any guarantee that the CSS Stylesheet wll allow me to access
every selector I can see in the HTML output?  I guess I can simply
take a look and try it out.



___
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] Can one save report option defaults?

[Adrien Monteleone]

I use this method for a monthly P&L for a running 'at a glance' when I 
want it. Since the report is set to reference dates (start/end of this 
month) rather than specific dates, I don't have to change any options. 
It just rolls over to the new month when the date changes.


Regards,
Adrien

On 5/5/22 9:32 AM, Michael or Penny Novack wrote:



I find I nearly always change the same five or six report options
every time I want a new report.  For example I nearly always want to
select all accounts (at least initially) and I want the secondary sort
key to be Date.

Is there any way I can set up GnuCash so the report options always
start with the values I want?


No there is not unfortunately.


If the report is still open (tab) it will be the last way you ran it.

Thus if I am running an "Income Statement" or "Balance Sheet" there a 
while bunch of options I want to remain the same and a few, maybe just 
the dates or date (for those two reports respectively) that I will 
always want to change. So I go to the tab for that report and use edit 
=> report options and just change the date. The rest of my non default 
selections are still there.


What report specifically are you have the problem of options not 
"sticking" if the report was left open << of course if you closed it and 
are opening a fresh report, will all be default >>



___
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] Is there a way to handle same-named GnuCash files sensibly?

[Adrien Monteleone]

XCIF is your friend!

You can back-date the meta for those images and scans with something 
like `exiftool`. No definitive word of if it runs on Linux, but it does 
on MacOS and other Unix systems.


Otherwise there is a web implementation: https://exif.tools

Regards,
Adrien

On 5/5/22 11:39 AM, Chris Green wrote:

On Thu, May 05, 2022 at 10:25:08AM -0400, Michael or Penny Novack wrote:


So yes, I look at dates in file names as a very good thing. If like me you
had lived through that "hell week" trying to get caught back up you would
too.


I agree to an extent, it's just that the 'date as part of filename' in
my case is in the directory structure rather than the file name.  It's
not just for GnuCash and other similar sorts of things.  I have my
photo collcetion in a decade/year/month/day directory hierarchy.

So photos I took on 24th March this year are in:-

 /home/chris/pictures/2020s/2022/03/24

... and I can very easily find pictures I took on my school summer
holidays in the 1960s, and everywhere in between.



___
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] Is there a way to handle same-named GnuCash files sensibly?

[David T. via gnucash-user]

If it's typing characters that has you bothered, rename "building.gnucash" 
"bldg.xgc", and associate xgc with GnuCash in your OS (xgc appears to only 
be used by one gaming platform). You'll save hundreds of keystrokes...

On May 5, 2022 4:09:17 AM EDT, Chris Green  wrote:
>On Wed, May 04, 2022 at 07:18:32PM -0400, Michael or Penny Novack wrote:
>> 
>> > Yes, I noticed too that there a files with a number added to the base
>> > name, e.g.:-
>> > 
>> >  building.gnucash.gcm
>> >  building.gnucash_2.gcm
>> > 
>> > ... but I'm not sure that it's a perfect system.
>> > 
>> > I have reverted to having the year as part of the file name and a
>> > wrapper script that finds the data file corresponding to the year
>> > directory I'm in.
>> > 
>> UH ... just because you as a human consider abcd and abcd_3 to be the same
>> name misses the point that they ARE different file names as far as the
>> computer is concerned, as different as you consider Fred and Freda different
>> names
>> 
>Yes, I do realise that, I was just pointing out what GnuCash appears
>to do if you have two different data files (in different directories)
>with the same name.  I've never had a data file called
>building.gnucash_2.gnucash so (I assume) GnuCash has created that file
>when it found there was already a building.gnucash.gcm file for
>*another* data file.
>
>
>> However, including the year in the name when in fact these are :the same
>> file except for a different year is an EXCELLENT way to go
>> 
>Yes, except that it does make for rather long filenames.  I'd really
>be happiest if my GnuCash 'building' bank account data file was simply
>called 'building'.  It's in a directory called ~/pcc/2022 which tells
>me that it's Parochial Parish Council data for 2022.
>
>-- 
>Chris Green
>___
>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] Calculation of Unrealized Losses

[Bill Dika]

Thanks David.

I'll try the gnucash developers list.

Bill Dika

On Mon, May 2, 2022 at 10:54 PM David Carlson 
wrote:

> Bill,
>
> If I recall correctly, one or more of the methods GnuCash uses to
> calculate exchange rates for reports is technically not correctly defined ,
> so it obscures the  fact that it is not calculating the expected value.
> That is leading to strange results when, for example, one attempts to do a
> trial balance.   I know very little about accounting so I cannot tell you
> details about that.
>
> Some of the developers can help with some of those issues.  Hopefully they
> can at least tell you which calculation methods to avoid when you want
> accurate results .
>
> On Mon, May 2, 2022, 9:27 PM Bill Dika  wrote:
>
>> Can anyone help me with this?
>>
>> Do I have to supply more/different information?
>>
>> I have been using gnucash personally for a couple of years now and would
>> like to develop more confidence in the program.
>>
>> Thank you in advance for your help.
>>
>> Bill Dika
>>
>> On Wed, Apr 27, 2022 at 1:42 PM Bill Dika  wrote:
>>
>> > My default currency is Canadian dollars. I have some US dollar
>> > accounts in my balance sheet.
>> >
>> > I have an unrealized loss in the equity section of my balance sheet at
>> > July 31 2021 of $12.68 and cannot figure out how it was calculated. I
>> > also have US dollar accounts expressed in Canadian dollars that I am
>> > unable to determine how the translation from US dollars to Canadian
>> > dollars occurs.
>> >
>> > For example I have a US dollar account of $353.75 for Tesla (see
>> > us-dollar-accts-in-us-dollars-july-31-2021.png) that shows as $456.22
>> > in Canadian dollars at July 31 2021 (see
>> > us-dollar-accts-july-31-2021.png). This is an exchange rate of
>> > 1.28966. I am unable to figure out how Gnucash arrives at that rate
>> > (see us-dollar-rates-price-database.png). It is not the rate at July
>> > 31 2021. It is not the average rate for all rates I have up to July 31
>> > 2021 and it is not the average rate for all rates I have in the price
>> > database.
>> >
>> > Also the $12.68 loss arises from only one change in the US dollar
>> > accounts from June 30 2021 to July 31 2021. That is a $524.80 US
>> > dollar addition to "Vanguard Intl Equity Total World Stock ETF" (see
>> > change-in-us-dollar-acct-july-2021.png).
>> >
>> > Attached are images of the following:
>> > equity-jun-30-2021.png = showing the equity section almost balanced
>> > (.01 unrealized gain) (in Canadian dollars)
>> > equity-july-31-2021.png = showing the $12.68 unrealized loss (in
>> > Canadian dollars)
>> > us-dollar-accts-in-us-dollars-jun-30-2021.png = balance sheet accounts
>> > (in US dollars)
>> > us-dollar-accts-jun-30-2021.png = balance sheet accounts (in Canadian
>> > dollars)
>> > us-dollar-accts-in-us-dollars-july-31-2021.png = balance sheet
>> > accounts (in US dollars)
>> > us-dollar-accts-july-31-2021.png = balance sheet accounts (in Canadian
>> > dollars)
>> > change-in-us-dollar-acct-july-2021.png = shows the only change in the
>> > US dollar accounts ($524.80 USD) from June 30 to July 31 2021 (in US
>> > dollars)
>> > us-dollar-rates-price-database.png = all the US to Canadian exchange
>> > rates in my database
>> >
>> > I am a Canadian CPA and feel quite confident about the accounting in
>> > the gnucash file. I have reviewed the journal entries for the period
>> > and they all balance. The only thing I can ascertain is that the
>> > unrealized loss arises from the US dollar accounts but I cannot figure
>> > out how gnucash is calculating it nor can I figure out how gnucash
>> > translates US dollars to Canadian dollars for those accounts.
>> >
>> > I have searched the list but cannot find anything that helps me in my
>> > calculation.
>> >
>> > I am on Arch linux using Gnucash 4.9.
>> >
>> > Any help would be much appreciated.
>> >
>> > Thank you.
>> >
>> > Bill Dika
>> >
>> ___
>> 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] Is there a way to handle same-named GnuCash files sensibly?

[Chris Green]

On Thu, May 05, 2022 at 10:25:08AM -0400, Michael or Penny Novack wrote:
> 
> So yes, I look at dates in file names as a very good thing. If like me you
> had lived through that "hell week" trying to get caught back up you would
> too.
> 
I agree to an extent, it's just that the 'date as part of filename' in
my case is in the directory structure rather than the file name.  It's
not just for GnuCash and other similar sorts of things.  I have my
photo collcetion in a decade/year/month/day directory hierarchy.

So photos I took on 24th March this year are in:-

/home/chris/pictures/2020s/2022/03/24

... and I can very easily find pictures I took on my school summer
holidays in the 1960s, and everywhere in between.

-- 
Chris Green
___
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] Can one save report option defaults?

[john]

> On May 4, 2022, at 7:49 AM, Chris Green  wrote:
> 
> On Wed, May 04, 2022 at 09:36:19AM -0500, David Carlson wrote:
>> On Wed, May 4, 2022 at 9:32 AM Chris Green  wrote:
>> 
>>> I find I nearly always change the same five or six report options
>>> every time I want a new report.  For example I nearly always want to
>>> select all accounts (at least initially) and I want the secondary sort
>>> key to be Date.
>>> 
>>> Is there any way I can set up GnuCash so the report options always
>>> start with the values I want?
>>> 
>> At the top of the report there is a button labelled "Save Config/"
>> 
> Yes, I know that.  However it only saves the settings for one report
> and when you retrieve it you get exactly the report you saved.  What I
> want is to be able to save the more general report settings so that
> whenever I open a new report I get those settings.
> 
> There's already a few things that can be configured 'system wide' in
> Edit->Preferences->Reports, for example you can set the default
> currency for *every* report there.  I'd like to be able to set more
> things like this so that they apply to every report. Then I won't have
> to set/unset the same half-dozen or so things I have to change every
> time I create a new report.  The problem is that I sometimes forget
> some of them! :-)


The report option defaults are hard-coded in the report code. That design makes 
it impractical to add a lot of customizations to the preferences system. The 
route to custom report option defaults is custom reports: You can copy those 
files (in the sources in gnucash/report/reports/standard) edit the defaults to 
your liking and install them as custom reports, see 
https://wiki.gnucash.org/wiki/Custom_Reports 
 for detailed instructions.

But you can also get there with saved configurations too, because you can open 
a saved configuration, change some options, and save that as a new saved 
configuration. You'll need to work out a naming convention if you have a lot of 
them so that you can easily find the one you want in the saved config dialog.

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.

Re: [GNC] Can one save report option defaults?

[Michael or Penny Novack]

I find I nearly always change the same five or six report options
every time I want a new report.  For example I nearly always want to
select all accounts (at least initially) and I want the secondary sort
key to be Date.

Is there any way I can set up GnuCash so the report options always
start with the values I want?


No there is not unfortunately.


If the report is still open (tab) it will be the last way you ran it.

Thus if I am running an "Income Statement" or "Balance Sheet" there a 
while bunch of options I want to remain the same and a few, maybe just 
the dates or date (for those two reports respectively) that I will 
always want to change. So I go to the tab for that report and use edit 
=> report options and just change the date. The rest of my non default 
selections are still there.


What report specifically are you have the problem of options not 
"sticking" if the report was left open << of course if you closed it and 
are opening a fresh report, will all be default >>


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
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] Is there a way to handle same-named GnuCash files sensibly?

[Michael or Penny Novack]

Yes, except that it does make for rather long filenames.  I'd really
be happiest if my GnuCash 'building' bank account data file was simply
called 'building'.  It's in a directory called ~/pcc/2022 which tells
me that it's Parochial Parish Council data for 2022.

It is probably because of my decades in the cypher mines (and working 
under mainframe OSs) that I am seeing "file name" differently that you.


I see ALL file names as "long" because the FULL NAME of files IS long. 
Most modern OSs allow you a "shortcut" in specifying file names by 
allowing you to specify being in a directory (aka file folder) and then 
you specify the "name" as from that point outward. In other words, you 
don't have to include in the file name you specify the path of that 
directory. Everything in that directory has THAT part of the (full) name 
in common.


It's also why I see being able to HAVE long file names (the part we 
usually see) as good/freedom since back in those days not allowed to be 
more than 8 characters.in any part of the name. It In other words, why I 
consider being able to have long file names a benefit, not a curse.


Dates as part of the names? Well once upon a time one at of the largest 
"financials" in the world somebody goofed and a previous week's backup 
of a file was reloaded (they used cycle names, A, B, C, etc. so all 
files for the A run had an .A. in a name (in the file system of this OS 
"." not "/" to separate parts of path). So all the jobs in the A run, 
the B run, the C run, etc had the file names correct for that run. BUT 
-- the names repeated in a cycle so a mistake of the sort I described 
was possible.  This happened on a Thursday, discovered the next 
Monday, and it took till Friday working around the clock till we were 
caught up (rerun Thursday, rerun Friday, then do Monday => )   They 
asked me, "Mike, can you come up with something so that this can never 
happen again?"


My solution was instead of cycles that repeated, a DATE associated with 
the run. Of course beyond human effort to edit all the names in each job 
of the run for that, so one directory with the jobs having symbolics in 
the names (for things like "this run", "previous run", "last months 
run", etc) and a program that given this directory and a "date of run" 
would edit all of those jobs into another directory with all the 
substitutions made and then these would be the jobs for that run, names 
never used again >> I was an "applications" programmer but for this tech 
support declared me "honorary tech support" and gave me my own set of 
system manuals just for the presentation of the concept (I was of course 
also the person who then designed and wrote the actual calendar and 
editor programs)


So yes, I look at dates in file names as a very good thing. If like me 
you had lived through that "hell week" trying to get caught back up you 
would too.


With gnucash, I am not closing the books but I DO make backups, and the 
year end one is special. A copy goes offsite and for organizations, an 
additional  copy to another officer to be usable as proof (by compare) 
that I didn't alter books. So all of the books do have the current year 
in the name of those copies, and then the active file gets renamed for 
the next (now current) year.


Ask yourself -- if I am using "what directory it is in" to indicate 
correct file (correct year), what could go wrong?


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
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] Change layout and font sizes in Transaction Report - how?

[Manfred Usselmann]

Am 2022-05-04 12:40, schrieb Chris Green:

The Transaction Report probably provides the information that my
auditor wants by listing each account's transactions in order and
giving the total amount below each account.

However the formatting and font sizes seem a little odd and I'd like
to change them if I can.

I have two fairly simple requirements:-

Increase the space below "Total for " before the
name of the next account appears.

Increase the font size for the account name that appears at the
top of each account's transactions.  As it is at present it's just
in the default small size used for all the 'body' text and so the
name doesn't stand out to indicate the start of the next account.


I agree, it is difficult to see the beginning a new account because of 
the small size of the name of the account. If you find a solution, 
please share... :-)


Thanks.

Regards,
Manfred

___
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] Change layout and font sizes in Transaction Report - how?

[Glenn Fowler]

There is also Edit > Preferences > Reports > Default zoom level

In my case, increasing that made the reports readable and fit my screen
better.

On Thu, May 5, 2022 at 2:33 AM Adrien Monteleone <
adrien.montele...@lusfiber.net> wrote:

> Export the report. The format is HTML, then you can examine it with a
> text editor and/or open it in a browser and use its inspector.
>
> Alternatively, just open it in a spreadsheet app and manipulate it from
> there.
>
> Regards,
> Adrien
>
> On 5/4/22 5:40 AM, Chris Green wrote:
> > The Transaction Report probably provides the information that my
> > auditor wants by listing each account's transactions in order and
> > giving the total amount below each account.
> >
> > However the formatting and font sizes seem a little odd and I'd like
> > to change them if I can.
> >
> > I have two fairly simple requirements:-
> >
> >  Increase the space below "Total for " before the
> >  name of the next account appears.
> >
> >  Increase the font size for the account name that appears at the
> >  top of each account's transactions.  As it is at present it's just
> >  in the default small size used for all the 'body' text and so the
> >  name doesn't stand out to indicate the start of the next account.
> >
> >
> > I can 'do' CSS but there don't seem to be any obvious selectors for
> > the items I want to change.  Is there any detailed description of what
> > selectors are available in the CSS stylesheet?
> >
>
> ___
> 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] QFX file for Bank of American business account not invoking Import Matcher

[Peter Wu]

Thanks Jean.

If you are using BofA business credit card, there are few keys and rows you 
need to delete.  There maybe more, but here is what we know so far:



MERCHCAT

EXPCAT

CARDNUM

CARDNAME

MCC

Protip, use visual studio code to edit qfx.  Find the word, highlight the 
selection ctl+shift+L, ctl+I to edit multiple lines and delete all occurrences 
with few strokes.
(Search how to delete multiple lines VScode.)

I filed a bug with libOfx to handle this better.

For Gnucash communities, do you think we could use above fields to better match 
transactions?  Content for above fields are like:
COMM. SPORTS, PROF. SPORTS CLUBS, ATHLETIC FI
Amusement and Entertainment
 9767
 ELExxx xxx LLC

I am not sure what MCC is, but other fields are self explanatory.

Best,
Peter

From: Jean L 
Date: Wednesday, May 4, 2022 at 22:09
To: Peter Wu , gnucash-user@gnucash.org 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher

You launch GC with the --debug flag. If you're on MacOS, you have to go to a 
console, find the path to your Gnucash, then do 
GnucashApp/contents/MacOs/Gnucash/Gnucash --debug (from memory, so I'm sure 
some of this is wrong)

Same idea on windows and linux, launch from the command line with the --debug 
flag.

J

On 5/4/2022 8:23 PM, Peter Wu wrote:
@Jean Laroche, can you send some instructions on how 
to run the debug mode?

I have another QFX file from BofA too.  It failed even after I remove CARDNUM, 
CARDNAME and MCC elements.

I suspect there are more invalid tags in this file.

Btw, the sample file I give you worked after removing above three tags.

Best,
Peter

From: gnucash-user 

 on behalf of Jean Laroche 
Date: Wednesday, May 4, 2022 at 09:52
To: gnucash-user@gnucash.org 

Subject: Re: [GNC] QFX file for Bank of American business account not invoking 
Import Matcher
Running gnucash with --debug shows what the issue is.

Removing the lines that contain the CARDNUM, CARDNAME and MCC elements
makes the file import correctly.
I'm not sure why ofxlib does not just ignore the unrecognized elements,
but that's the way it is.
Perhaps file a bug with libofx?

Jean

LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E:
element "CARDNUM" undefined

(Above message occurred on Line 39, Column 14)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: -50.00
(Above message occurred on Line 39, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E:
element "CARDNAME" undefined

(Above message occurred on Line 40, Column 15)
  X ERROR: startElement: incoming_data should be empty! You are
probably using OpenSP <= 1.3.4.  The following data was lost: 9767
(Above message occurred on Line 40, Column 6)
LibOFX ERROR: OpenSP parser: otherError (misc parse error):
/var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E:
element "MCC" undefined



On 5/4/22 8:38 AM, Peter Wu wrote:
> Hi David C,
>
> It is all new transactions.  If it is previously imported transaction, it 
> would give a error dialog saying no new transaction.
>
> But for the given QFX, it just does nothing after you click okay to import 
> the file.
>
> By the way, I am using the latest Mac OS on latest Gnucash version.
>
> Should I reply all with email or just reply to the mailing list?
>
> Best,
> Peter
>
> From: David Carlson 
> 
> Date: Wednesday, May 4, 2022 at 08:30
> To: Peter Wu 
> Cc: stepbystepf...@comcast.net 
> , Gnucash 
> Users 
> Subject: Re: [GNC] QFX file for Bank of American business account not 
> invoking Import Matcher
> If your file already contains a transaction that was previously imported with 
> the same reference number,  Gnucash does not import it again.
>
> On Wed, May 4, 2022, 9:11 AM David Carlson 
> mailto:david.carlson@gmail.com>>
>  wrote:
> Probably, but you do not explain what happens or doesn't happen when you 
> click on "Import OFX/QFX"?  Are you able to see the filename and select it?  
> Is there an error message?
>
> On Wed, May 4, 2022 at 9:03 AM Peter Wu 
> mailto:peter_cd...@hotmail.com>>
>  wrote:
> Quote:
> What is your reasoning to expect THAT (data intended for some sort of 
> bookkeeping that is NOT doubl

Re: [GNC] Is there a way to handle same-named GnuCash files sensibly?

[Geert Janssens]

Chris,

I have decided to simply do the test.

As an intro, the files in ~/.local/share/books are called metadata files. They 
store (among 
others) which windows and tabs you had open the last time you used a file, 
column widths in 
various tabs, filters in registers and so on. They don't contain your 
accounting data itself.

When you create a new gnucash data file, this file will get a unique ID (the 
book ID). That id is 
what is used to map a metadata file to a gnucash file. So far so good. Each 
time you create a 
new file, it will have its own unique book ID and hence it will be mapped to 
its own metadata 
file, regardless of whether the gnucash data file has a unique name or not.

However, when you copy a gnucash file in your file manager from one directory 
to another, 
this is not the case. So if you create your 2022 gnucash file by copying the 
2021 gnucash file 
to a new directory but with the same file name, both will be mapped to the same 
metadata 
file. Depending on the use case this is a feature or a flaw. In your case it 
would be a flaw. 
There is however not much gnucash can do about it, other than rewriting the 
code to no 
longer depend on metadata files. I once made a proposal in that direction. 
Unfortunately I 
lack the time to effectively implement it.

Note that if you copy the file to a different name, that new file will not have 
any metadata 
associated with it. So the first time you open it, there will be no tabs open 
other than the 
Accounts tab, customizations to this tab are gone, window size is back to 
default and so on.

Other than copying a gnucash file around in your file manager, you could also 
create a copy 
by using gnucash' built-in "Save As..." feature. I tested it and it also 
doesn't change the 
unique book ID. That means that if you save the file under the same name in a 
different 
directory it will also share the mapped metadata file. It does however behave 
differently if 
you save to a new file name. In this case the current state of the new file  
(which is the one 
currently open when the save operation completes) will also be saved for the 
new gnucash 
file and will be separate from the original gnucash file.

So in summary, if you want your per year gnucash files to have unique metadata 
files, you 
have to create them as truly new files (File->New... in gnucash) or use "Save 
As..." to save 
them under a different name (in any directory you prefer). I don't know which 
way you 
typically start your new year's books, at least you now know the limitations of 
the current 
implementation.

Personally I think the Save As... behaviour is flawed. It should create a new 
unique book ID. I 
can't imagine a use case where this would fail to work (or there isn't a 
reasonable alternative 
way to achieve the same thing for that alternative use case). If you feel like 
it you could file 
an enhancement request for this in our Bugzilla.

Regards,

Geert

Op donderdag 5 mei 2022 10:09:17 CEST schreef Chris Green:
> On Wed, May 04, 2022 at 07:18:32PM -0400, Michael or Penny Novack wrote:
> > > Yes, I noticed too that there a files with a number added to the base
> > > name, e.g.:-
> > > 
> > >  building.gnucash.gcm
> > >  building.gnucash_2.gcm
> > > 
> > > ... but I'm not sure that it's a perfect system.
> > > 
> > > I have reverted to having the year as part of the file name and a
> > > wrapper script that finds the data file corresponding to the year
> > > directory I'm in.
> > 
> > UH ... just because you as a human consider abcd and abcd_3 to be the same
> > name misses the point that they ARE different file names as far as the
> > computer is concerned, as different as you consider Fred and Freda
> > different names
> 
> Yes, I do realise that, I was just pointing out what GnuCash appears
> to do if you have two different data files (in different directories)
> with the same name.  I've never had a data file called
> building.gnucash_2.gnucash so (I assume) GnuCash has created that file
> when it found there was already a building.gnucash.gcm file for
> *another* data file.
___
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] QFX file for Bank of American business account not

[Peter West]

> On 5 May 2022, at 7:40 am, Jean Laroche  wrote:
> 
> 
> cat stmt.qfx | sed -E "/ stmt_fixed.qfx
> 

For mac users:

cat stmt.qfx | gsed -E '/\|\|\/d' >stmt_fixed.qfx

This works with gsed, but not with macos sed. Getting a robust expression with 
macos sed is kinda messy. You’re probably better off using a perl one-liner.

cat stmt.qfx | perl -pe '$_ = "" if /\b(CARDNUM|CARDNAME|MCC)\b/‘ 
>stmt_fixed.qfx


—
Peter West
p...@ehealth.id.au
Then one of them, named Cleopas, answered him, “Are you the only visitor to 
Jerusalem who does not know the things that have happened there in these days?”


> I'm not a sed guru, so maybe there's a better/more robust way to do it. But 
> this should give you a temporary solution?
> 
> Jean
> 
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:39:13:E: 
> element "CARDNUM" undefined
> 
> (Above message occurred on Line 39, Column 14)
>  X ERROR: startElement: incoming_data should be empty! You are probably 
> using OpenSP <= 1.3.4.  The following data was lost: -50.00
> (Above message occurred on Line 39, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:40:14:E: 
> element "CARDNAME" undefined
> 
> (Above message occurred on Line 40, Column 15)
>  X ERROR: startElement: incoming_data should be empty! You are probably 
> using OpenSP <= 1.3.4.  The following data was lost: 9767
> (Above message occurred on Line 40, Column 6)
> LibOFX ERROR: OpenSP parser: otherError (misc parse error):
> /var/folders/j6/7t8sg1vj4q97zhh9z5cdmxbm4rz935/T//libofxtmpcNQLhJ:41:9:E: 
> element "MCC" undefined
> 

___
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] Can one save report option defaults?

[Chris Green]

On Thu, May 05, 2022 at 01:29:28AM -0500, Adrien Monteleone wrote:
> On 5/4/22 9:31 AM, Chris Green wrote:
> > I find I nearly always change the same five or six report options
> > every time I want a new report.  For example I nearly always want to
> > select all accounts (at least initially) and I want the secondary sort
> > key to be Date.
> > 
> > Is there any way I can set up GnuCash so the report options always
> > start with the values I want?
> > 
> No there is not unfortunately.
> 
> I've seen it discussed and there is probably an RFE filed on it.
> 
OK, thanks Adrien, at least I know I haven't missed anything obvious
*and* other people have suggested it might be a good idea.

-- 
Chris Green
___
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] Change layout and font sizes in Transaction Report - how?

[Chris Green]

On Thu, May 05, 2022 at 01:33:51AM -0500, Adrien Monteleone wrote:
> On 5/4/22 5:40 AM, Chris Green wrote:
> > The Transaction Report probably provides the information that my
> > auditor wants by listing each account's transactions in order and
> > giving the total amount below each account.
> > 
> > However the formatting and font sizes seem a little odd and I'd like
> > to change them if I can.
> > 
> > I have two fairly simple requirements:-
> > 
> >  Increase the space below "Total for " before the
> >  name of the next account appears.
> > 
> >  Increase the font size for the account name that appears at the
> >  top of each account's transactions.  As it is at present it's just
> >  in the default small size used for all the 'body' text and so the
> >  name doesn't stand out to indicate the start of the next account.
> > 
> > 
> > I can 'do' CSS but there don't seem to be any obvious selectors for
> > the items I want to change.  Is there any detailed description of what
> > selectors are available in the CSS stylesheet?
> > 
> Export the report. The format is HTML, then you can examine it with a text
> editor and/or open it in a browser and use its inspector.
> 
Is there any guarantee that the CSS Stylesheet wll allow me to access
every selector I can see in the HTML output?  I guess I can simply
take a look and try it out.

-- 
Chris Green
___
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] Is there a way to handle same-named GnuCash files sensibly?

[Chris Green]

On Wed, May 04, 2022 at 07:18:32PM -0400, Michael or Penny Novack wrote:
> 
> > Yes, I noticed too that there a files with a number added to the base
> > name, e.g.:-
> > 
> >  building.gnucash.gcm
> >  building.gnucash_2.gcm
> > 
> > ... but I'm not sure that it's a perfect system.
> > 
> > I have reverted to having the year as part of the file name and a
> > wrapper script that finds the data file corresponding to the year
> > directory I'm in.
> > 
> UH ... just because you as a human consider abcd and abcd_3 to be the same
> name misses the point that they ARE different file names as far as the
> computer is concerned, as different as you consider Fred and Freda different
> names
> 
Yes, I do realise that, I was just pointing out what GnuCash appears
to do if you have two different data files (in different directories)
with the same name.  I've never had a data file called
building.gnucash_2.gnucash so (I assume) GnuCash has created that file
when it found there was already a building.gnucash.gcm file for
*another* data file.


> However, including the year in the name when in fact these are :the same
> file except for a different year is an EXCELLENT way to go
> 
Yes, except that it does make for rather long filenames.  I'd really
be happiest if my GnuCash 'building' bank account data file was simply
called 'building'.  It's in a directory called ~/pcc/2022 which tells
me that it's Parochial Parish Council data for 2022.

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