Re: [GNC] unrealized gain / losses for mutual funds

[D via gnucash-user]

I have no idea how NFTs change the concept of gains. 

And suggesting that tax laws in the US are going to adopt these guidelines is 
speculation at best. More likely it's wishful thinking-- or tilting at 
windmills.



On May 18, 2022, 15:03, at 15:03, Kenneth Schneider  
wrote:
>
>
>Ken Schneider 
>
>> On May 18, 2022, at 10:49 AM, David T. via gnucash-user
> wrote:
>> 
>> A couple of points here:
>> 
>> First, the analogy of a painting's unrealized gains to those of any
>other asset is perfectly valid. The only difference is that there is
>only one "share" of the painting, while there are many shares of a
>stock or mutual fund. Their change in value is going to be the
>unrealized gain or loss. The math for gain on a single item is simple,
>making the example perhaps easier to comprehend, at the risk of
>oversimplification the questions. 
>
>With introduction of NFT’s this no longer stamped in concrete.
>
>> 
>> Second, my (admittedly very basic) understanding of accounting is
>that unrealized gains, from an accounting perspective *don't exist.*
>You don't have the gains until you sell the asset. Gnucash applies this
>concept rather strictly. 
>
>If you live in the U.S. our illustrious leaders have indicated that
>they would like taxing gains as the occur in a held investment. Whether
>this happens or not is anyone’s guess.
>
>> 
>> These points being said, there have been suggestions made in this
>list by others more qualified than I on the circumstances in which a
>user might need to track unrealized gains and account for them on an
>ongoing basis. I believe the term they used was "mark to market." You
>might look for those threads in the list archives. 
>> 
>> David T. 
>
>___
>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] error when I try to save in MySQL or sqlite3

[D via gnucash-user]

Oh. My mistake. It's in the Guide at:

https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-files1.html

On May 28, 2022, 17:47, at 17:47, John Ralls  wrote:
>What wiki page is that?
>
>Regards,
>John Ralls
>
>
>> On May 28, 2022, at 11:49 AM, David T. > wrote:
>> 
>> I guess the wiki page that suggests that sql drivers might not be
>available for Windows could be updated...
>> 
>> On May 28, 2022 2:44:14 PM EDT, "David T. via gnucash-user"
>mailto:gnucash-user@gnucash.org>> wrote:
>> Oh. Okay. Thanks for the correction. 
>> 
>> On May 28, 2022 10:42:43 AM EDT, John Ralls > wrote:
>> You are mistaken. The Windows bundle includes everything necessary to
>connect to Postgres and MySQL.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> On May 28, 2022, at 5:17 AM, David T. via gnucash-user
>mailto:gnucash-user@gnucash.org>> wrote:
>> 
>> Gustavo,
>> 
>> The image didn't come through, and you didn't give the version of
>Gnucash you're using, but the mail client tag line suggests that you
>are on Windows, and I'll assume it's a recent version of Gnucash. 
>> 
>> Most likely, you're using the standard download of Gnucash for
>Windows, which I believe doesn't include the database drivers for
>postgresql by default. You would need to download and compile Gnucash
>yourself to get that functionality, something that requires a bit of
>research and work on your part. 
>> 
>> You might explain why you are trying to use the SQL back end in the
>first place; most users don't benefit from using them. 
>> 
>> David
>> 
>> 
>> On May 26, 2022 12:26:29 PM EDT, Gustavo Adolfo Landaeta Mantilla
>mailto:glandaet...@hotmail.com>> wrote:
>> Hi
>> 
>> I tried to save a new book in postgres that I just installed but is
>giving me an error :
>> [cid:image001.png@01D87125.7088C5D0
>]
>> 
>> I followed the tutorial in google (https://youtu.be/3DuNTVVhupc
>)  and I can see that it works for him,
>but I don’ t know why is not working for me.
>> 
>> Can yo help with this issue?
>> 
>> Kind Regards
>> 
>> Gustavo
>> 
>> 
>> Sent from Mail> for Windows
>> 
>> 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.
___
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] questions on 4.1

[D via gnucash-user]

Thanks for the kind words, Gyle.

On the topic, it'd be nice if the Accounts menu bar could somehow keep the 
options button (the aforementioned triangle) on screen, instead of being off 
screen to the far right. Maybe the button should go on the left?

David T. 

On Jun 12, 2022, 10:21, at 10:21, Gyle McCollam  wrote:
>Jay,
>Happy you found this helpful.  I respond to questions because others
>have responded to me or I have found their responses to other helpful,
>as you did this response.  I don't know enough programing, just enough
>to be dangerous, so I help where I can.  I have picked up several
>tip/tricks along the way and I am grateful to those who take the time
>to respond to questions.  I picked this up from a previous
>question/answer session and feel it is part of my obligation to pass it
>on when I can.  Several names keep appearing in response to questions. 
>Do you hear me: Adrein, David T, Michael, and others.  Thanks to you
>and everyone that takes the time!
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>
>From: ja...@comcast.net 
>Sent: Sunday, June 12, 2022 7:57 AM
>To: 'Gyle McCollam' 
>Subject: RE: [GNC] questions on 4.1
>
>Gyle, Thank you. I had overlooked that arrow and feature.
>
>-Original Message-
>From: gnucash-user 
>On
>Behalf Of Gyle McCollam
>Sent: Saturday, June 11, 2022 3:42 PM
>To: Top Cat ; gnucash-user@gnucash.org
>Subject: Re: [GNC] questions on 4.1
>
>I'm sure your aware, but just in case.  Did you know there is a down
>arrow
>at the far right of the account heading screen.  This allows you to add
>or
>remove columns from the accounts page.  Maybe, the account code box is
>not
>checked (3rd one down).
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>
>From: gnucash-user 
>on
>behalf of Top Cat 
>Sent: Saturday, June 11, 2022 12:44 PM
>To: gnucash-user@gnucash.org 
>Subject: [GNC] questions on 4.1
>
>I have been using gnucash since 2.x with a MySQL database
>
>
>
>I recently build a new machine and updated to 4.1, and have run into
>several
>issues
>
>1.  On the accounts page, I can no longer show the account numbers,
>or
>sort by them
>2.  On reconciliations, paired transactions (like transfers from
>one
>subaccount to another) no longer clear "both sides" when one is checked
>- it
>requires manually marking both sides separately.
>
>
>
>Is this correct behavior? Are there settings I am missing? do I need to
>reinstall/save and restore data?
>
>
>
>Any help would be appreciated
>
>___
>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.
>
>___
>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] How to reorganize the account tree

[D via gnucash-user]

There's even a function somewhere in the menus to assign codes automatically. 
Can't recall where it is, or how well it works. ISTR it behaved rather well. 

On Jun 13, 2022, 10:52, at 10:52, Stan Brown  wrote:
>
>On 2022-06-13 07:31, Gyle McCollam wrote:
>> As someone suggested, you could assign account codes and sort on
>them.  I would use at least a four digit number, so you have room to
>add accounts in between in the future.  I would suggest 1000s for
>assets, 2000s for liabilities, 3000s for income, and 4000s for expense.
>
>
>My old accounting system had three-digit account codes, which I used
>when I created my GnuCash chart of accounts. As time went by and I had
>to add more accounts, I ended up using decimals. They sot as I
>expected,
>but it's ugly that most accounts have NNN codes yet some have NNN.N
>codes.
>
>Gyle's suggestion of four-digit codes makes sense to me, in hindsight.
>I
>almost wrote "if I had it to do over again, I'd use four-digit account
>codes." But of course it's possible to change an account code at any
>time, so I think I'm off to renumber my accounts now. :-)
>
>-- 
>Stan Brown
>Tehachapi, CA, USA
>https://BrownMath.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
>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] rookie question Imbalance-USD

[D via gnucash-user]

Thanks; my apologies to you as well. 

On Jun 21, 2022, 09:46, at 09:46, Gyle McCollam  wrote:
>Liz,
>Even though your email was not directed at me, I too want to apologize
>for my part in the exchange.  My apology is not only to you, but to the
>user base and to David T. as well.
>
>
>Thank You,
>Gyle McCollam
>
>Gyle McCollam
>
>609.680.2326 Mobile
>
>gmccol...@live.com   email
>
>
>From: gnucash-user 
>on behalf of Liz 
>Sent: Tuesday, June 21, 2022 12:55 AM
>To: David T. via gnucash-user 
>Subject: Re: [GNC] rookie question Imbalance-USD
>
>On Sun, 19 Jun 2022 10:57:19 -0400
>"David T. via gnucash-user"  wrote:
>
>> I made my comment from that perspective; your snarky comment just
>> underscores for me the kind of person YOU are. Go stuff yourself.
>>
>> David T.
>
>
>David,
>As the moderator, I don't want to see such words in the archives.
>You put in lots of good information, please refrain from those sorts of
>comments.
>
>Liz
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>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] [GNC-dev] ANNOUNCE: GnuCash Windows Bundle 4.11-1 Released

[D via gnucash-user]

Frank,

The announcements are sent both to -users and -devel. Since the guidance of the 
list is to reply all, a user reply-all will go to both lists. 

Just like your reply did. 

David T. 

On Jul 14, 2022, 11:36, at 11:36, "Frank H. Ellenberger" 
 wrote:
>Hello Allan,
>
>as this is a user question it should have been sent to gnucash-users
>only.
>
>Yes, the fix did not happen in GnuCash itself, but its bundled
>dependencies:
>https://github.com/Gnucash/gnucash-on-windows/commit/03f7f35342d717c1a137e82ad4d8f4973fa4f934
>
>Regards
>Frank
>
>Am 14.07.22 um 07:31 schrieb Alan A Holmes:
>> I've just installed this latest update, as I do all updates, after
>return
>> from holiday. Though the setup.exe is definitely a different size to
>V4.11,
>> Help->About gives me exactly the same version number and build date.
>Is that
>> what I would expect?
>> 
>> 
>> Alan A Holmes
>___
>gnucash-devel mailing list
>gnucash-de...@gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-devel
___
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] Type-ahead search stalls

[D. via gnucash-user]

Sebastian,

This may be related to https://bugs.gnucash.org/show_bug.cgi?id=798162, which I 
posted recently. If you think it's the same problem, please add any details you 
have there for the developer's benefit. The bug includes a link to the mailing 
list thread that led to the bug submission. 

David T. 




 Original Message 
From: cirakana via gnucash-user 
Sent: Sun May 02 04:43:16 EDT 2021
To: "gnucash-user@gnucash.org" 
Subject: [GNC] Type-ahead search stalls

Hello

When I try to assign an account to a transaction in the register the type-ahead 
stalls. After I type one or two characters nothing shows up and I can't edit 
the text field for at least a couple of seconds. After the delay I can type a 
character more (or delete a character) and the field freezes again. No results 
are showed when typing in the account text field and often I have to click 
outside the text field so the error box "xxx account dosen't exist. Do you wish 
to create it?" (where xxx are the characters typed) appears and I can click 
"No" to regain control of the text field.
Sequential search works (typing the first letter of an account, typing ":" and 
then typing the first letter of the child account and so forth)

I've looked through /tmp/gnucash.trace when launching gnucash with --debug, but 
no log entries are generated during this error. Here are some of the entries 
before and after the error:

* 10:22:06 INFO  [qof_collection_foreach] Hash Table size of Split 
before is 2196
* 10:22:06 INFO  [qof_collection_foreach] Hash Table size of Split 
after is 2196
* 10:22:06 INFO  [qof_query_run_internal] matching 
objects=0x560a436cc040 count=1091
* 10:22:06 INFO  [qof_object_foreach] type=Split
* 10:22:06 INFO  [qof_collection_foreach] Hash Table size of Split 
before is 2196
* 10:22:06 INFO  [qof_collection_foreach] Hash Table size of Split 
after is 2196
* 10:22:06 INFO  [qof_query_run_internal] matching 
objects=0x560a436d5380 count=8
* 10:22:06 INFO  [gnc_split_register_move_cursor] after move 4345 0
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=119306212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=119306212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=119306212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=119306212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] baln=1706212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] baln=1706212/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=11750/100
* 10:22:06 INFO  [xaccAccountGetBalanceInCurrency] 
baln=11750/100
 Type-ahead search stalls 
* 10:22:18 INFO  [gnc_split_register_move_cursor] after move 4361 0
* 10:22:22 INFO  [gnc_split_register_save] beginning edit of trans 
0x560a440be570
* 10:22:22 INFO  [gnc_split_register_save] finished saving split "" 
of trans "Test"
* 10:22:22 INFO  [trans_cleanup_commit] get rid of rollback 
trans=0x560a4375f990
* 10:22:22 INFO  [qof_event_generate_internal] id=7 
hi=0x560a4474a960 han=0x7f93ef7763e0 data=0x560a440c23f0
* 10:22:22 INFO  [qof_event_generate_internal] id=6 
hi=0x560a442ef540 han=0x7f93ef7763e0 data=0x560a440c23f0
* 10:22:22 INFO  [qof_event_generate_internal] id=5 
hi=0x560a44201770 han=0x7f93ef588350 data=0x560a440c23f0
* 10:22:22 INFO  [qof_event_generate_internal] id=4 
hi=0x560a43f782e0 han=0x7f93ef5ef990 data=0x560a440c23f0
* 10:22:22 INFO  [qof_event_generate_internal] id=3 
hi=0x560a43e8c310 han=0x7f93ef74a470 data=0x560a440c23f0

Also no clues from dmesg or journalctl.

GNUCash version: 4.5+(2021-03-27)
Manjaro Linux (5.10.32-1-MANJARO) with MATE DE (1.24.1)

I've searched Google, the FAQ and the mail list archives with no luck. I hope 
you can help me.

Sincerely
Sebastian Hirsch
___
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] apply a factor to profit/loss report

[D. via gnucash-user]

Peter, 

That seems like a particularly narrow use case, meaning that any such patch 
would likely have to originate with you. Since gnucash is open source, it's 
entirely in the realm of possibility to do that-- if you have that ability. 

I am no expert, but I wonder if you couldn't somehow overload the tax tables 
features to parse out your coefficients? 

David T. 


 Original Message 
From: "Peter Münster" 
Sent: Tue May 18 10:34:00 EDT 2021
To: Gnucash User 
Subject: Re: [GNC] apply a factor to profit/loss report

On Tue, May 18 2021, Derek Atkins wrote:

>> Is it possible to apply a factor (or coefficient) to accounts in the
>> profit/loss report?
>
> No.

Thanks for your fast answer.

How much work would it be to patch Gnucash, to add that option?


> Your best best is to extract the report and import it into Calc and then
> apply your factor(s) there.

I would really like to avoid such manipulations.


> Either that, or pre-apply your 70% via Split Transactions,

That would be too much work.


> I'm assuming some sort of VAT?

No. My kayak club has a contract with a local administration, and each
year we have to deliver a profit/loss report with special coefficients
for most accounts. For example 75% of the pay for our employee, 30% of
electricity and so on. That is because we deliver services for the local
authority and they consider that our employee spends 75% of his time for
the services and 25% for your club.

I'm the treasurer and I have to make a normal report for the club (no
coefficients at all) and another for this contract.

-- 
   Peter
___
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] Migrating and updating 2.6.21 in Windows 7 to 3.11 in Windows 10 No sub-accounts

[D. via gnucash-user]

Roger, 

Your experience is exceptional,  insofar as I've never heard that particular 
problem before. Your description is puzzling to me; how is it that your top 
level accounts show correct balances, if the subaccounts are not there? 
Something is off there... 

Here are some ideas:

I'll assume that you closed gnucash after the Check & Repair and restarted it. 
I know sometimes that helps unstick things.

Since you're having trouble with the canonical upgrade process, what happens if 
you examine the file without performing the Check & Repair? 

I am going to assume that your statement that the saved reports are not 
important implies that you haven't actually written Scheme-based custom reports 
(because if you'd gone down THAT rabbit hole, those reports would be important 
to you), but that you have saved a number of standard reports with basic 
customization, such as a subset of accounts on an income report, or a special 
date range, etc. If that is the case, you could simply copy {yourfile}.gnucash 
from the Windows 7 box to the new machine, and open that with 3.11. Later, you 
could try to find your saved-reports.2.x fileand copy it over to the new 
machine (in the new folder for version 3 and above).

If none of those fix your problem, perhaps you can send a screen shot of the 
Chart of Accounts. Maybe that will shed some light...

David T. 


 Original Message 
From: rmom...@gmail.com
Sent: Tue May 18 16:03:59 EDT 2021
To: GnuCash 
Subject: [GNC] Migrating and updating 2.6.21 in Windows 7 to 3.11 in Windows 10 
No sub-accounts

I am going to try again by starting a new thread to get past where I'm stuck
updating version 2.6.21 on a Windows 7 computer to version 3.11 on a Windows
10 computer.

 

I moved the 2.6.21 database to the Windows 10 computer along with the
.gnucash file with the saved reports. Saved reports is not as important as
getting access to the data completely. I installed version 3.11 on the new
computer, opened the program and from there opened the 2.6.21 data file.
Then I ran Action>Check & Repair>Check & Repair All. 

 

The problem I'm having is that the sub-accounts under Assets appear but not
under liabilities, equity, income and expenses. Running Action>Check &
Repair>Check & Repair sub-accounts one at a time for liabilities, equity,
income and expenses seems to work so some extent but not completely. There
are three levels of sub-accounts in some cases. The totals under the major
account headings, assets, liabilities, etc. appear to be correct and the
information is in the database, just having trouble opening the arrow to
access the sub-accounts. 

 

We couldn't stop work so have continued to use the Windows 7 computer to
keep up with the account while we figure this out. When we do, we will have
to start again and move the latest version of the database to the new
computer, replacing the file we are working with and go through the check
and repair process again.

 

What step am I missing to correct this problem?

 

Thanks,

Roger

___
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] apply a factor to profit/loss report

[D. via gnucash-user]

Peter, 

My tax table suggestion was based on Derek's suggestion to use separate 
accounts for the main amount and your "coefficients." If your kayak 
transactions were split between the main account and the coefficient account, 
you could aggregate them where necessary, and separate them elsewhere. 

But really, the best solution is to munge the data in a spreadsheet. It can't 
be more work than trying to drag this feature out of gnucash. A little bit of 
creative formula building might allow you to copy the gnucash report into one 
tab, have the coefficients in a second tab, and use lookups in a third tab to 
generate the final report. I've used this approach to get stock prices for my 
portfolio using Google sheets. 

David


 Original Message 
From: "Peter Münster" 
Sent: Tue May 18 16:42:27 EDT 2021
To: Gnucash User 
Subject: Re: [GNC] apply a factor to profit/loss report

On Tue, May 18 2021, D. wrote:

> it's entirely in the realm of possibility to do that-- if you have
> that ability.

I don't know, if I have. I have some experience with Common Lisp and
Emacs Lisp. And I guess, that I should
- copy the income-statement.scm to a new file
- make some changes, so that there won't be any conflicts with the
  original file (namespace, identifiers and such)
- multiply the amounts in this new file with an attribute of the account
  (for example "code")

Probably not too hard, but I don't have enough time for that. Where
could I offer a bounty for this feature please?


> I am no expert, but I wonder if you couldn't somehow overload the tax tables
> features to parse out your coefficients?

I've tried, but it seems that the profit-loss-report does not use such
coefficients...

-- 
   Peter

P.S.: I've just realized, that I already asked this question about
2 years ago. I've totally forgotten that. Please excuse me for this
reposting.
___
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] (no subject)

[D. via gnucash-user]

So, perhaps you could send a screen shot of your non-working chart of accounts? 
Someone might be able to see what the problem is.

For the record, there is/was a *folder* in windows that was called ".gnucash", 
and the default extension for a gnucash data file is ".gnucash". The former 
included a number of files that controlled the software (such as 
saved-reports.x.x, which contains your saved report settings), while the latter 
is a simple file ("myaccounts.gnucash", for example) stored in a location of 
your choosing. For what it's worth, the location of the settings folder was 
changed between 2.6 and 3.0, I believe. 

David


 Original Message 
From: Roger Oliver 
Sent: Thu May 20 18:22:13 EDT 2021
To: sunfis...@yahoo.com, gnucash-user@gnucash.org
Subject: 

Thanks David T.

Puzzling to me too. It dawned on me that the only indication we saw that
the check and repair function was working was that the menus and icons at
the top of the page were grayed out and unavailable. Probably need to give
it more time until those come back to life.

Examining the file without check and repair shows the arrows to the left of
the accounts on the chart of accounts page but they do not respond to a
click.

You are correct, saved reports means adjustments to the existing reports.
We did move the .gnucash file from the old computer to the new before
installing the 3.11 and opening the GnuCash data file. The reports didn't
show up. Wonder if the .gnucash file in Windows 10 has a different name,
maybe GnuCash. At any rate, saved reports were not there when we opened the
data file in 3.11

Roger

Message: 5
Date: Tue, 18 May 2021 17:05:58 -0400
From: "D." 
To: rmom...@gmail.com
Cc: GnuCash 
Subject: Re: [GNC] Migrating and updating 2.6.21 in Windows 7 to 3.11
in Windows 10 No sub-accounts
Message-ID: <0f7274aa-55bb-4ccc-990f-ea8efbc53...@yahoo.com>
Content-Type: text/plain; charset=UTF-8

Roger,

Your experience is exceptional,? insofar as I've never heard that
particular problem before. Your description is puzzling to me; how is it
that your top level accounts show correct balances, if the subaccounts are
not there? Something is off there...

Here are some ideas:

I'll assume that you closed gnucash after the Check & Repair and restarted
it. I know sometimes that helps unstick things.

Since you're having trouble with the canonical upgrade process, what
happens if you examine the file without performing the Check & Repair?

I am going to assume that your statement that the saved reports are not
important implies that you haven't actually written Scheme-based custom
reports (because if you'd gone down THAT rabbit hole, those reports would
be important to you), but that you have saved a number of standard reports
with basic customization, such as a subset of accounts on an income report,
or a special date range, etc. If that is the case, you could simply copy
{yourfile}.gnucash from the Windows 7 box to the new machine, and open that
with 3.11. Later, you could try to find your saved-reports.2.x fileand copy
it over to the new machine (in the new folder for version 3 and above).

If none of those fix your problem, perhaps you can send a screen shot of
the Chart of Accounts. Maybe that will shed some light...

David T.

___
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] Proposed: "Realized Gain/Loss" transactions considered harmful

[D. via gnucash-user]

Peter, 

I'll step in to say that you're certainly welcome to create your own practices 
for your own books. I personally like to see that the sell transaction in the 
stock account matches what my brokerage indicates, and in my experience, that 
means a sale at the actual price and entries that account for the gain or loss. 
While the creation of the gain transaction is decidedly kludgy, I don't find it 
all that difficult to handle or understand. I certainly wouldn't call it 
"harmful."

David T. 

By the way, I'm not sure that the price database is used to calculate gains; I 
would rather expect that gains are calculated using the information from the 
purchase transaction. 


 Original Message 
From: peterb 
Sent: Tue May 25 09:15:30 EDT 2021
To: Geoff 
Cc: GnuCash Users 
Subject: Re: [GNC] Proposed: "Realized Gain/Loss" transactions considered 
harmful

On Tue, May 25, 2021 at 4:38 AM Geoff  wrote:

> I personally found the current process quite confusing for a long long
> time until one day it finally "clicked" and now I am used to using the
> Lots functionality for tracking capital gains & losses.
>

Hi, Geoff! I'm in the same boat. I'm used to it as well, but I spend a lot
of time looking at how other systems model these transactions and that's
what has me concerned; this is first and foremost a correctness issue, but
it's also a data portability issue.

I do want to distinguish between "using the lots feature to calculate
capital gain" and "how the calculated gains are journaled." I'm focused
entirely on how the capital gains are reflected in the journal entries - we
should be able to keep the exact same view lots UI even if we change how
the lots UI journals things.

It seems to me that your proposal, in essence, involves including the
> capital gain as one of the splits of the sale transaction, whereas the
> current Gnucash functionality requires you to "transfer" the gain out of
> the stock account and into the income account as a separate transaction
> to the sale itself.  And the Lots functionality can do this for you,
> either by you choosing the individual lots, or automatically on a first
> in, first out basis.
>

This is a fair description, although I think of the transfer as coming out
of the income account, not into. The existing functionality works because
stock accounts are not dollar-denominated, so the dollars (or whatever
currency) you debit into it in your 0-share transaction evaporate upon
contact. This brings up a related point that I didn't touch, which is that
it's arguably better (though certainly not required) for the gain
calculation to be part of the sale transaction - if you've ever made a sale
which touches 10 lots, the current method creates 10 consecutive "Realized
Gain/Loss" transactions which have no obvious ordering or connection to the
lots sold - if you need to go back for any reason, you have to do detective
work to figure out which is which.


> Have you considered generalising your proposal to cover other stock
> related capital gain scenarios, for example:
> * The sale includes brokerage, taxes, or other charges
> * The sale of several lots that were bought at different prices
>
These two should be treated just as they are now (GnuCash probably can't
take a strong stance on them because of differing local tax laws.)


> * A share split or consolidation with partial return of capital
> * Takeover
> * Liquidation
>
I haven't thought deeply about these scenarios yet, but they should be
conceptually similar.


> The biggest drawback I see with your proposal is that the selling price
> is no longer recorded in the price column, but is only held in the split
> description?  You seem to be recording the original buying price as the
> price on the sell transaction, which is confusing at first glance and,
> in a sale of multiple lots scenario, would require the entry of many
> such splits?
>

I want to be clear that what I was trying to get at in my proposal is a
*simulation* of what we might want, and as such you can imagine UI changes
that accomplish the same thing in a better way; I'm using the 'price' field
here so I can show how I think it should be modeled, not because I'm
literally saying we should actually use the price field like this.

The crux of the issue to me is that the "price" field in the stock ledger
is doing two things, and *those two things are actually unrelated*:

(1) It is used as part of the calculation of the debit or credit of the
account on buy or sell transaction (and GnuCash is so ambivalent about its
role here that we need to throw a sheet to ask the user for their intent
almost any time it changes - the "Do you want to recalculate value, price,
or number of shares?" question)
(2) It is used to populate the Price Database for the security for that
date, which is in turn used to calculate unrealized gains/losses.

I've got no problem with using the market price for (2), and if we wanted
to keep it in the register for that pu

[GNC] Cancel Transaction Interface Oddity

[D. via gnucash-user]

Hello, 

GC4.5 (Build ID 4.5+ (2021-03-27)) Windows 10

I have noticed that while entering a new transaction, that if I click the 
Cancel button, the cursor remains in whatever field had the focus at the time 
of cancelation. For the record, I most commonly cancel a transaction from the 
amount field because autofill puts the same amount into the transaction, which 
tells me I already entered that transaction. In this circumstance, the amount 
field remains the active field after the transaction has been canceled. 

This is disconcerting, as it means that my next action MUST be to relocate the 
cursor back to the date field in order to create a new transaction. Typing at 
this point puts information into the amount field, and pressing enter creates a 
spurious transaction. 

Given these points, I think it is a UI error to leave the cursor at this 
location after canceling, and I will file a bug if others agree with me. 

David T.

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

[GNC] New Imbalance-XXX Behavior

[D. via gnucash-user]

Hello, 

I have noticed a new behavior in regards to the automatic creation of entries 
to Imbalance-XXX (in my case,  Imbalance-USD).

When I first started using Gnucash, I found the creation of a top level 
imbalance account to be additional unwanted clutter to my Chart of Accounts. I 
found, by sheer coincidence, that I could move the top level account into a 
different area of my CoA (in my case, a top level placeholder called Special 
Accounts, which includes a number of these types of accounts), and Gnucash 
would use that newly-situated Imbalance-XXX account for all new 
automatically-created imbalance entries.

Alas, this is no more. In my most recent session, I have found that Gnucash has 
decided that it must ALWAYS use a top level Imbalance account for these 
entries. I find the concomitant clutter of my books annoying. 

This is disappointing. Does anyone know why this behavior has changed, and is 
there any point to submitting a bug request to have the previous behavior 
restored?

David T. 
Gnucash user since 2005
Current: GC 4.5 on Windows 10

⁣​
___
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] New Imbalance-XXX Behavior

[D. via gnucash-user]

Michael, 

I'm not sure what behavior you think I am seeing? I do think you're missing my 
point, which is that prior to 4.5, automatically-generated entries for 
Imbalance-USD would be placed in my existing Imbalance-USD account, which is 
located under Special Accounts. That is,  "Special Accounts: Imbalance-USD". It 
doesn't do that any more, and instead insists that all such entries be made 
only into a top level account.

I'm not interested in having multiple Imbalance-USD accounts littering my CoA 
(let alone any additional top level Imbalance-XXX accounts for any other 
currencies my books might track); I am looking for Gnucash to use the Imbalance 
accounts that already exist. 

David


 Original Message 
From: Michael or Penny Novack 
Sent: Mon May 31 17:36:23 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] New Imbalance-XXX Behavior

On 5/31/2021 1:08 PM, David T. via gnucash-user wrote:


> Please re-read my email. In it you will see that I am NOT/NOT asking 
> about how to handle entries that are automatically added to 
> Imbalance-USD. I am fully aware of Gnucash behaviors in regard to the 
> creation of entries into Imbalance-USD, and I have a long-established 
> workflow in place for handling such created entries.
>
>
> What I was noting is a CHANGE IN BEHAVIOR from earlier versions of 
> Gnucash. In earlier versions, entries to Imbalance-USD would be added 
> to the EXISTING Imbalance-USD account, regardless of its placement in 
> the Chart of Accounts. In my books, I moved Imbalance-USD to be a 
> child account of a new Top Level account that I created called 
> "Special Accounts." 


David, for a very good reason, I suspect you were not seeing the 
behavior you thought you were seeing. An account is NOT defined by its 
name but by its name within the context of its position in the tree (the 
CoA). Does you CoA not have ANY account names that are duplicated except 
for their position in the tree? For example, suppose among your expenses 
you were tracking the costs associated with automobiles, with one of 
these being fuel.

Expenses

     Automobile expenses

    Auto 1

   fuel

    Auto 2

   fuel

Now those two accounts for fuel have the same name but they are NOT the 
same account. You would not expect to simply specify "fuel" as the 
account affected by a transaction but also which one you meant.

But you are saying you had this working for the name "Imbalance". That 
you moved this to a different place in the tree but gnucash still 
treated it as the same account as the normal (special account) Imbalance.

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.

___
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] New Imbalance-XXX Behavior

[D. via gnucash-user]

Well, that's how it worked before. 


 Original Message 
From: David G Hamblen 
Sent: Tue Jun 01 07:08:28 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] New Imbalance-XXX Behavior

Since Gnucash uses guid's, perhaps let it create the imbalance account 
in the root account, then rename/move it to a location of your 
choosing.  That way it maybe gets added to the list of valid imbalance 
accounts?

On 5/31/21 11:23 PM, DaveC49 wrote:
> David,
>
> I'm not sure why the behaviour has changed, but from a programming
> prospective, it is much simpler to create the imbalance accounts at the top
> level. There is no need to search for a location which may be different in
> every user's CoA. One reason perhaps for keeping it at the top level is that
> it sticks out and alerts the user they have made an error in a transaction,
> which is perhaps a benefit for new users, although annoying for those who
> have an established workflow which takes care of detecting errors anyway
>
> If an older version of GnuCash was able to create new imbalance accounts in
> a lower level position in the account heirarchy, then it had to be recording
> that location in the heirarchy that the Imbalance account had been shifted
> to after its initial creation at the top level in some manner.
>
> It should not be too hard to have a preference setting for the Imbalance
> account location and if a user shifts an Imbalance account from the default
> location, set that preference location to the location in the CoA the
> account is moved to and use that for subsequent creation of Imbalance
> account entries.  I can imagine that some users could want to have Imbalance
> accounts for different currencies in different locations which would require
> a preference location for each currency in use.
>
> Just requires someone to program/reprogram it.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
> .

-- 
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

___
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] New Imbalance-XXX Behavior

[D. via gnucash-user]

And, having downgraded to 4.4, I can confirm that this new behavior began with 
4.5.


 Original Message 
From: "D. via gnucash-user" 
Sent: Tue Jun 01 08:12:27 EDT 2021
To: David G Hamblen 
Cc: Gnucash Users 
Subject: Re: [GNC] New Imbalance-XXX Behavior

Well, that's how it worked before. 


 Original Message 
From: David G Hamblen 
Sent: Tue Jun 01 07:08:28 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] New Imbalance-XXX Behavior

Since Gnucash uses guid's, perhaps let it create the imbalance account 
in the root account, then rename/move it to a location of your 
choosing.  That way it maybe gets added to the list of valid imbalance 
accounts?

On 5/31/21 11:23 PM, DaveC49 wrote:
> David,
>
> I'm not sure why the behaviour has changed, but from a programming
> prospective, it is much simpler to create the imbalance accounts at the top
> level. There is no need to search for a location which may be different in
> every user's CoA. One reason perhaps for keeping it at the top level is that
> it sticks out and alerts the user they have made an error in a transaction,
> which is perhaps a benefit for new users, although annoying for those who
> have an established workflow which takes care of detecting errors anyway
>
> If an older version of GnuCash was able to create new imbalance accounts in
> a lower level position in the account heirarchy, then it had to be recording
> that location in the heirarchy that the Imbalance account had been shifted
> to after its initial creation at the top level in some manner.
>
> It should not be too hard to have a preference setting for the Imbalance
> account location and if a user shifts an Imbalance account from the default
> location, set that preference location to the location in the CoA the
> account is moved to and use that for subsequent creation of Imbalance
> account entries.  I can imagine that some users could want to have Imbalance
> accounts for different currencies in different locations which would require
> a preference location for each currency in use.
>
> Just requires someone to program/reprogram it.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
> .

-- 
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

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

___
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] New Imbalance-XXX Behavior

[D. via gnucash-user]

I wonder whether a change in the underlying account functions in pull request 
#921 has caused this change in behavior. The PR appears to have rearranged the 
list order to improve performance, and I wonder if by rearranging, the embedded 
imbalance account is no longer found?  I'll note that with 4.5, I have seen the 
account drop down scrolling through the account structure to reach accounts 
deep in the hierarchy. This scrolling also is not present in 4.4. It doesn't 
ultimately affect the system functionality, but it is a little disconcerting...


 Original Message ----
From: "D. via gnucash-user" 
Sent: Tue Jun 01 08:21:26 EDT 2021
To: David G Hamblen 
Cc: Gnucash Users 
Subject: Re: [GNC] New Imbalance-XXX Behavior

And, having downgraded to 4.4, I can confirm that this new behavior began with 
4.5.


 Original Message ----
From: "D. via gnucash-user" 
Sent: Tue Jun 01 08:12:27 EDT 2021
To: David G Hamblen 
Cc: Gnucash Users 
Subject: Re: [GNC] New Imbalance-XXX Behavior

Well, that's how it worked before. 


 Original Message 
From: David G Hamblen 
Sent: Tue Jun 01 07:08:28 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] New Imbalance-XXX Behavior

Since Gnucash uses guid's, perhaps let it create the imbalance account 
in the root account, then rename/move it to a location of your 
choosing.  That way it maybe gets added to the list of valid imbalance 
accounts?

On 5/31/21 11:23 PM, DaveC49 wrote:
> David,
>
> I'm not sure why the behaviour has changed, but from a programming
> prospective, it is much simpler to create the imbalance accounts at the top
> level. There is no need to search for a location which may be different in
> every user's CoA. One reason perhaps for keeping it at the top level is that
> it sticks out and alerts the user they have made an error in a transaction,
> which is perhaps a benefit for new users, although annoying for those who
> have an established workflow which takes care of detecting errors anyway
>
> If an older version of GnuCash was able to create new imbalance accounts in
> a lower level position in the account heirarchy, then it had to be recording
> that location in the heirarchy that the Imbalance account had been shifted
> to after its initial creation at the top level in some manner.
>
> It should not be too hard to have a preference setting for the Imbalance
> account location and if a user shifts an Imbalance account from the default
> location, set that preference location to the location in the CoA the
> account is moved to and use that for subsequent creation of Imbalance
> account entries.  I can imagine that some users could want to have Imbalance
> accounts for different currencies in different locations which would require
> a preference location for each currency in use.
>
> Just requires someone to program/reprogram it.
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
> .

-- 
dhamb...@afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440

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

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

Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

Laura, 

Welcome to gnucash. 

The question about imbalance entries goes back a long ways in GnuCash, and you 
can find discussions about it in the lists over the years. 

Essentially, the debate boils down to this: is it better to allow a user to 
enter an imbalanced transaction and automatically create the balancing entry in 
a dummy account (Imbalance-XXX generically speaking), or should the program nag 
the user to balance the transaction every time? Gnucash choose the former many 
years ago, and has stuck with that model since. 

David


 Original Message 
From: men...@fastmail.fm
Sent: Tue Jun 01 10:04:09 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

Michael wrote 

" automatically-generated entries for Imbalance-USD would be placed in my 
existing Imbalance-USD account, which is located under Special Accounts. "

First, thank you to the developers of GnuCash.  I started using it a couple of 
months ago to replace Quicken because it drove me nuts with its constant 
nagging to update to a new version, and because I could not get the Quicken 
version I owned to work on my Windows 10 computers. It still works on my Win 7 
computer, but that's it.   I've been very happy with GnuCash - you all have 
done a very nice job.  I also use QuickBooks for my business accounting and may 
end up switching those over to GnuCash at some point.

As I've been reading the discussion about the imbalance account, it occurred to 
me to ask why GnuCash allows entries that are out of balance?  In theory and 
practice, we should not have entries that don't balance...credits should equal 
debits...and if they don't, we have an error in the entry.  And not that I 
would say QuickBooks is a work of art, but it doesn't allow one to make an 
entry that doesn't balance.  In other words, it forces the user to at least 
consciously assign an imbalance to an account (either an already existing one 
or a new one.  This allows one to fudge the entry if one doesn't know the 
answer in that moment and then go find out the answer and fix the entry later). 
 But, the user is "on notice" that there was a problem with the entry.

As the discussion about the Imbalance account highlights, GnuCash does allow an 
out of balance entry.  This automatic action may easily be missed if one 
doesn't quickly the develop the habit of checking the Imbalance account.  

I'm simply curious, why doesn't GnuCash prevent these entries to begin with?

Thank you for your time to answer in advance, Laura
___
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D via gnucash-user]

Two reasons:
1- the dev team tries to minimize stored settings, and
2- no one has written the code. 

On Jun 1, 2021, 11:56, at 11:56, s310...@gmail.com wrote:
>hi,
>why not make it configurable (either nag or create a dummy
>account/entry)
>as a settings option?
>
>Shay
>
>On Tue, Jun 1, 2021 at 5:30 PM  wrote:
>
>> David, thank you for taking the time to fill me in the thought
>process.
>> Laura
>>
>> - Original message -
>> From: "D." mailto:sunfish62%40yahoo.com>>
>> To: men...@fastmail.fm 
>> Cc: Gnucash Users > gnucash-user%40gnucash.org>>
>> Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST
>CURIOUS
>> Date: Tuesday, June 01, 2021 9:23 AM
>>
>> Laura,
>>
>> Welcome to gnucash.
>>
>> The question about imbalance entries goes back a long ways in
>GnuCash, and
>> you can find discussions about it in the lists over the years.
>>
>> Essentially, the debate boils down to this: is it better to allow a
>user
>> to enter an imbalanced transaction and automatically create the
>balancing
>> entry in a dummy account (Imbalance-XXX generically speaking), or
>should
>> the program nag the user to balance the transaction every time?
>Gnucash
>> choose the former many years ago, and has stuck with that model
>since.
>>
>> David
>>
>>
>> ___
>> 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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

Of course, you can suppress zero balance accounts in the View menu, if that's 
your preference...


 Original Message 
From: David Cousens 
Sent: Tue Jun 01 18:46:57 EDT 2021
To: John Morris , Gnucash Users 
Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

John,

I agree. There is a case for not displaying the Imbalance accounts in the CoA
tab if there are no entries to them, i.e. they are zero balance. This is an
option in reports but not in the account tab. They can of course be left in the
CoA and hidden in the Account tab by editing the account and setting the hidden
flag but they then remain hidden even when new entries to them are created.

I would go further and hide them totally if the balance in them was zero and
change either the background or the font color to a bright red or even flashing
red( that would clearly need to be optional) to  highlight them when they are
present with a non-zero balance. 

Their usefulness to indicate incorrect entries would be enhanced if they are
hidden when the balance is zero as their presence whether highlighted or not
indicates an error.  Similarly with the orphan transactions created when an
account with existing transactions to it has been deleted without moving the
transactions to another account.

I would take a look at it but I am currently heavily involved in a physics
project programming exercise at the moment. The change in behaviour from the
previous version probably needs to be tracked down and, where possible fixed
first, before adding any further enhancements to minimize conflicting changes.

David Cousens

On Tue, 2021-06-01 at 18:10 -0400, John Morris wrote:
> > Actually you are given the opportunity to fix it during entry. When the
> > Imbalance account appears in a transaction in the account column, all you
> > have to do is click on it in the Account column and assign the correct
> > account from the drop down list, before closing (pressing Enter) the
> > transaction.
> 
> Unfortunately, by then the damage is already done. The Imbalance account has
> been created and I must go and delete it yet again. I don’t like extra
> accounts cluttering up my carefully designed CoA.
> 
> Best,
> John
> 
> ___
> 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.

___
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

Why delete an account that's only going to get created again? 


 Original Message 
From: Michael Hendry 
Sent: Wed Jun 02 12:25:39 EDT 2021
To: Peter West 
Cc: GnuCash users group 
Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

> On 2 Jun 2021, at 02:44, Peter West  wrote:
> 
> I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX accounts 
> (at top level in my CoA) extremely useful, and I understand why they are 
> there. If I ever see a balance, I know I have to fix something, which is a 
> good reason to have them at the top. I can’t comment on any changes that 
> might have occurred in the behaviour of these accounts recently. However, in 
> respect of the tidiness of the CoA, one possible solution is to create a 
> special case for these accounts, such that they only display in the CoA 
> listing when they have a non-zero balance.
> 
> Peter


Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out 
the problem and zeroed their contents - they’ll be created automatically if 
required.

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

The discussion about the location of Imbalance-XXX accounts is under a 
different thread, and I explained there my reasons for my account structure and 
Gnucash's previous implementation. Suffice to say that I'd rather keep 
Imbalance-USD around (since it will get created all over again), but put it in 
the location of MY choosing. 


 Original Message 
From: "w...@theprescotts.com" 
Sent: Wed Jun 02 13:37:34 EDT 2021
To: GnuCash Users 
Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

I am just an uninterested observer of this discussion of the location of the 
Imbalance account(s). It has never bothered me. But Michael's suggestion seems 
like a good one for those that are bothered by it. Then if the account appears, 
you know there are some unbalanced transactions. If there are none, you don't 
have to look at the account on the list.

Will

On 2021 Jun 2, at 06-02 11:25:39, Michael Hendry  
wrote:

Why not simply delete the Imbalance and Orphan accounts when you’ve sorted out 
the problem and zeroed their contents - they’ll be created automatically if 
required.

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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.

___
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

Michael, 

I expect gnucash should know the "full name" of the imbalance account BECAUSE 
THAT'S WHAT IT DID BEFORE 4.5. 

David


 Original Message 
From: Michael or Penny Novack 
Sent: Wed Jun 02 16:39:05 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

On 6/2/2021 2:27 PM, D. via gnucash-user wrote:
> The discussion about the location of Imbalance-XXX accounts is under a 
> different thread, and I explained there my reasons for my account structure 
> and Gnucash's previous implementation. Suffice to say that I'd rather keep 
> Imbalance-USD around (since it will get created all over again), but put it 
> in the location of MY choosing.

The "location" of an account is, in effect, part of its name, its full 
name. You could have half a dozen accounts with the "name" Imbalance as 
long as each was a different leaf of the tree (location in the CoA). How 
do you propose gnucash to "know" WHICH of these you intend to be used as 
the account to use for imbalance situations?

What you are asking form in effect, is the ability to specify an account 
to be used for the purpose.

I know you are thinking, just look for a leaf with name Imbalance. That 
could work IF gnucash reserved the name, disallowed you creating an 
account with that name. Account names in gnucash do NOT have to be 
unique/distinct.  Is it the case that in your own books you do not have 
accounts with the same "name" but different leaves of the tree so you 
don't see the problem. The developers put Imbalance at the top level of 
the tree precisely because that would be unique (could only be one).

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.

___
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] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

[D. via gnucash-user]

Yeah,  I actually don't care about the account existing; it's easy enough to 
correct the problems, which, quite frankly, are more trouble to avoid than fix. 
So, I'm happy just to let it be there, which cuts down on my having to alter my 
CoA. 

And as I have noted time and time and time again in this thread, my quibble is 
with the change in GnuCash behavior with version 4.5. No one has explained why 
this change has occurred, let alone explain to me what I might do, short of 
downgrading and staying forevermore on 4.4, to get this fixed. 

David


 Original Message 
From: "Stephen M. Butler" 
Sent: Wed Jun 02 17:23:54 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS

On 6/2/21 11:22 AM, D. via gnucash-user wrote:
> Why delete an account that's only going to get created again?

1.  So you know when something needs attention.
2.  Make you more careful to not let the account be created in the first 
place.

--Steve
>
>
>  Original Message 
> From: Michael Hendry 
> Sent: Wed Jun 02 12:25:39 EDT 2021
> To: Peter West 
> Cc: GnuCash users group 
> Subject: Re: [GNC] WHY ARE THERE "IMBALANCE ENTRIES" AT ALL ?? JUST CURIOUS
>
>> On 2 Jun 2021, at 02:44, Peter West  wrote:
>>
>> I’m a fairly naive user, but I find the Imbalance-XXX and Orphan-XXX 
>> accounts (at top level in my CoA) extremely useful, and I understand why 
>> they are there. If I ever see a balance, I know I have to fix something, 
>> which is a good reason to have them at the top. I can’t comment on any 
>> changes that might have occurred in the behaviour of these accounts 
>> recently. However, in respect of the tidiness of the CoA, one possible 
>> solution is to create a special case for these accounts, such that they only 
>> display in the CoA listing when they have a non-zero balance.
>>
>> Peter
>
> Why not simply delete the Imbalance and Orphan accounts when you’ve sorted 
> out the problem and zeroed their contents - they’ll be created automatically 
> if required.
>
> Michael
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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.


-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] How to do property asset and loan when acquired in the past

[D. via gnucash-user]

I'll just note that I have *never* in 15 years had a gnucash-generated loan 
transaction that matched the actual bank transaction. I have *always* had to 
adjust the amounts manually after the fact, because the bank will calculate 
interest and principle amounts based on the exact day (and probably the hour, 
minute, and second) they receive my payment, which I cannot know in advance. 
David T. 


 Original Message 
From: David Carlson 
Sent: Tue Jun 08 08:34:33 EDT 2021
To: flywire 
Cc: Gnucash Users 
Subject: Re: [GNC] How to do property asset and loan when acquired in the past

The part about tracking loan payments when trying to create a partially
paid down loan in GnuCash is tricky.  GnuCash only does simple interest
calculations, so many times the best you can do is get an estimated
periodic payment transaction which you will have to correct manually each
month after you know the actual values .

On Tue, Jun 8, 2021 at 6:51 AM flywire  wrote:

> Work through https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide
>
> It would have been simpler as a tutorial if it was only two accounts deep.
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>


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

___
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] Large Negative Account Total

[D. via gnucash-user]

Usually, income accounts and expense accounts are placed in different top level 
hierarchies (Income and Expenses, respectively). Rearranging the accounts to 
segregate these would be a first step to gaining some clarity. 


 Original Message 
From: Jim DeLaHunt 
Sent: Tue Jun 08 17:23:55 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Large Negative Account Total

Jack:

On 2021-06-08 14:04, Jack Frillman via gnucash-user wrote:
> …The parent account "Investment Misc" is an expense account and is 
> marked as a place holder account.…
> …In my account tabs the "Investment Misc" parent account shows a 
> negative amount. (-$70 K range) …
>
> Questions:
> + What can I do to get the large negative amount for the Investment 
> Misc parent account not to be negative?

Off the top of my head, I will guess that it is a sign that your 
investments are successful. Think about the signs of an expense-type 
account. You spend money, money goes out, the transaction has a positive 
sign. You get a refund, money comes in, the transaction has a negative 
sign. You get lots of refunds, you have a large credit in your 
expense-type account, you have a negative balance.

The parent account "Investment Misc" is a expense-type account. If the 
total of all transactions in its child accounts adds up to money coming 
in, then the "Investment Misc" account ought to show a negative balance, 
right?  It's a good thing! You have money!

Someone who knows accounting theory could probably explain this in terms 
of credits and debits to Equity and Assets. I think I have heard that 
Expense and Income, and positive and negative signs, are a layer of ease 
of use on top of these fundamentals.

An experiment to try would be to redesignate "Investment Misc" as an 
Income-type account. That might flip the sign of the account total.

> …I didn't what to go willy-nilly changing things in fear of really 
> messing things up.

Remember, every time you quit GnuCash, it makes a backup of your book 
file. If you want to try an experiment, you can:

1. Quit GnuCash.

2. Make a copy of the book file

3. Start GnuCash.

4. Try your experiment.

5. See if you like the results of the experiment.

6. If you do, keep using the new book. If you do not, then quit Gnucash, 
delete the most recent copy of your book file, and replace it with the 
copy you saved. Then restart GnuCash.

Best regards,
     —Jim DeLaHunt


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

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

Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't installed properly" on macOS

[D. via gnucash-user]

Jim,

I understand your complaint here, but it seems to me that the issue here is 
that MacPorts is prepending its directories into the environment path. Because 
they altered the path to prefer their own executables before the Apple supplied 
ones, gnucash-cli fails. That doesn't seem to me to be a fault of Gnucash or 
its documentation. 

David


 Original Message 
From: Jim DeLaHunt 
Sent: Sat Jun 12 21:31:41 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] gnucash-cli says, "No quotes retrieved. Finance::Quote isn't 
installed properly" on macOS

On 2021-06-12 09:13, John Ralls wrote:

>> On Jun 12, 2021, at 12:22 AM, Jim DeLaHunt  wrote:
>>
>> OK, I can understand that the MacPorts installation of perl may be 
>> configured to look for perl packages in MacPorts locations, and ignore the 
>> system locations. But I don't understand wny the GUI app of GnuCash 
>> apparently can find Finance::Quote when run from the GUI, but the 
>> gnucash-cli app apparently cannot. What is different?
> Because applications started by LaunchServices don't get the environment from 
> your shell's startup files. That means GnuCash is running /usr/bin/perl, not 
> /opt/local/bin/perl but when you run a program from Terminal the environment 
> is read so gnucash-cli runs /opt/local/bin/perl.

Thank you, John, this explanation is very helpful. I can understand that 
the GnuCash GUI and the gnucash-cli experience different environments, 
especially different $PATH values, because the OS invokes them in 
different environments.

But I find it very confusing to have gnucash-cli be presented as an 
integral part of GnuCash, and all the references to a singular action of 
"update Finance::Quote on the system", then have gnucash-cli behave 
differently and require a different installation of Finance::Quote than 
the GnuCash GUI.

It seems to me that if both gnucash-cli and the GnuCash GUI would invoke 
the perl executable at an absolute path, then they would have consistent 
behaviour. Thus I wonder why GnuCash lets the environment find the perl 
executable.

I have filed Bug 798209, "gnucash-cli might not use the same perl and 
Finance::Quote as GnuCash GUI", 
 , to track this.

My workaround as a MacPorts user: install Finance::Quote into the 
MacPorts perl environment:

```
% port install p5-finance-quote


    —Jim DeLaHunt

___
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] Starting the program with 6 months of data.

[D. via gnucash-user]

It's called Equity: Opening Balances. 

This is covered in the Guide, as well as numerous threads in the list. 


 Original Message 
From: Glenn Fowler 
Sent: Tue Jun 22 16:43:47 EDT 2021
To: Howard Krawitz , GnuCash users group 

Subject: Re: [GNC] Starting the program with 6 months of data.

Since income and expenses are carried over, everything automatically
balanced out for my bank account which is under "Assets". I did have to
make one bogus entry not in my regular chart of accounts which was my
positive bank balance at the beginning of the year to start 2021.
There might be a better way though.

On Tue, Jun 22, 2021 at 4:29 PM Howard Krawitz <
how...@resultsdatasolutions.com> wrote:

> Hi Glenn,
>
>
>
> Thanks for the input. How did you handle the Balance in your bank account?
> Where do you put it. Etc.
>
>
>
> Thank again,
>
>
>
> Howard
>
>
>
> *From:* Glenn Fowler 
> *Sent:* Tuesday, June 22, 2021 1:18 PM
> *To:* Howard Krawitz 
> *Cc:* gnucash-user@gnucash.org
> *Subject:* Re: [GNC] Starting the program with 6 months of data.
>
>
>
> Hi Howard,
>
>
>
> I recently did the same thing. I didn't want to data entry months of
> transactions so what I did was put in one entry for each account from the
> previous system. For example:
>
>
>
>
> Description--Transfer--Spend
>
> Transfer from previous systemExpenses:Marketing---$100
>
> Transfer from previous systemExpenses:Travel$200
>
>
>
> That way year end will be correct in GnuCash. This is just one way to do
> it but I figured it would be the least disruptive.
>
>
>
> On Tue, Jun 22, 2021 at 3:22 PM Howard Krawitz <
> how...@resultsdatasolutions.com> wrote:
>
> I want to install the first 6 months of the year of transactions. I don't
> know the best way to accomplish that. For instance the starting balance in
> the bank account, invoices that have been paid, expenses that have been
> paid etc.
>
> If someone can help me it would be greatly appreciated.
>
> Thanks
>
> Howard Krawitz
> Resultsdatasolutions.com
> 818-203-5337
> ___
> 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.

___
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] GNU cash keeps adding trading accounts

[D. via gnucash-user]

This may or may not be the same problem as in the earlier issue. The earlier 
issue concerned accounts created in Equity erroneously, not Trading. The (mis-) 
creation of trading accounts in different tree structures sounds like a 
different but related problem. Perhaps the fix implemented there will work for 
this as well, but then again, maybe not. 



 Original Message 
From: David H 
Sent: Sun Jun 27 03:55:29 EDT 2021
To: Public Address 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] GNU cash keeps adding trading accounts

I think this is a known bug discussed/reported back in late April which has
been fixed and will presumably be released in v4.6 shortly.  Check out
https://lists.gnucash.org/pipermail/gnucash-user/2021-April/096343.html for
more details.  Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798093

Cheers David H.

On Sun, 27 Jun 2021 at 17:00, Public Address 
wrote:

> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: 1.49
> Windows 10
>
> I have been entering stock transactions.  All stocks are successfully set
> up in the security editor.
>
> However, if (say) I buy AMD shares
>
>
> 1 Buy 10 shares in Brokerage account:AMD
>
> 2 GNU reduces cash in Brokerage account:USD Cash
>
> 3 GNU then automatically creates TRADING:NASDAQ:AMD
>
> 4 Which is fine
>
> 5 Then buy 20 shares of MSFT in Brokerage account:MSFT
>
> 6 GNU reduces cash in Brokerage account:USD Cash
>
> 7 GNU then automatically creates TRADING:NASDAQ:MSFT
> as a totally separate tree ie not under TRADING:NASDAQ created in 3
>
> So for every ticker GNU is creating a separate tree.
>
> I get that I can move the MSFT under NASDQ to sit with AMD but why is GNU
> creating a totally separate tree each time?
>
> Thanks
>
> ___
> 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.

___
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] GNU cash keeps adding trading accounts

[D. via gnucash-user]

My apologies. I was remembering a different thread and bug from the same time 
frame. 


 Original Message 
From: "D. via gnucash-user" 
Sent: Sun Jun 27 07:42:45 EDT 2021
To: David H 
Cc: Michael via gnucash-user , Public Address 

Subject: Re: [GNC] GNU cash keeps adding trading accounts

This may or may not be the same problem as in the earlier issue. The earlier 
issue concerned accounts created in Equity erroneously, not Trading. The (mis-) 
creation of trading accounts in different tree structures sounds like a 
different but related problem. Perhaps the fix implemented there will work for 
this as well, but then again, maybe not. 



 Original Message 
From: David H 
Sent: Sun Jun 27 03:55:29 EDT 2021
To: Public Address 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] GNU cash keeps adding trading accounts

I think this is a known bug discussed/reported back in late April which has
been fixed and will presumably be released in v4.6 shortly.  Check out
https://lists.gnucash.org/pipermail/gnucash-user/2021-April/096343.html for
more details.  Bug report at https://bugs.gnucash.org/show_bug.cgi?id=798093

Cheers David H.

On Sun, 27 Jun 2021 at 17:00, Public Address 
wrote:

> Version: 4.5
> Build ID: 4.5+(2021-03-27)
> Finance::Quote: 1.49
> Windows 10
>
> I have been entering stock transactions.  All stocks are successfully set
> up in the security editor.
>
> However, if (say) I buy AMD shares
>
>
> 1 Buy 10 shares in Brokerage account:AMD
>
> 2 GNU reduces cash in Brokerage account:USD Cash
>
> 3 GNU then automatically creates TRADING:NASDAQ:AMD
>
> 4 Which is fine
>
> 5 Then buy 20 shares of MSFT in Brokerage account:MSFT
>
> 6 GNU reduces cash in Brokerage account:USD Cash
>
> 7 GNU then automatically creates TRADING:NASDAQ:MSFT
> as a totally separate tree ie not under TRADING:NASDAQ created in 3
>
> So for every ticker GNU is creating a separate tree.
>
> I get that I can move the MSFT under NASDQ to sit with AMD but why is GNU
> creating a totally separate tree each time?
>
> Thanks
>
> ___
> 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.

___
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] pricehist: a tool to fetch historical prices

[D. via gnucash-user]

Derek, 

Your point is well-taken; making changes to the datafile outside of the API is 
Risky. 

That being said, the price db operates somewhat independently of a file's 
transactions. Adding or removing items from the price db can be done without 
disruption to transactions. 

I find it interesting to read this announcement; a number of years back, I did 
a very similar project in perl, which more directly reconstructed a book's 
commodity prices with monthly prices for all holdings past and present. I was 
able to rebuild my own multi year price history for a file with over a hundred 
different commodities using it. Whether it's still valid and still works are 
legitimate questions, but Chris might find it an interesting read. 

For everyone else: don't use my code. 

https://github.com/sunfish62/NewPriceHistory

David T.


 Original Message 
From: Derek Atkins 
Sent: Thu Jul 01 09:52:35 EDT 2021
To: ch...@chrisberkhout.com
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] pricehist: a tool to fetch historical prices

Hi,

Just note that GnuCash (and more generally, the GnuCash team) does not
support modifications of the gnucash database outside of GnuCash.  Doing
so may break your data file, especially as it changes over time.  If
you're not using the GnuCash APIs to modify your data file, you "void the
warranty".  YMMV.

-derek

On Thu, July 1, 2021 9:45 am, Chris Berkhout wrote:
> Hi all,
>
> I've written a command-line tool to fetch daily historical prices. It
> currently supports 5 sources of data and will generate output in 4
> formats,
> including SQL for a GnuCash database.
>
> https://gitlab.com/chrisberkhout/pricehist
>
> Fetching prices and immediately applying them to a GnuCash database is
> done
> as in the following examples:
>
> pricehist fetch ecb EUR/USD -s 2021-06-25 -o gnucash-sql | sqlite3
> Accounts.gnucashpricehist fetch ecb EUR/USD -s 2021-06-25 -o
> gnucash-sql | mysql -u username -p -D databasenamepricehist fetch ecb
> EUR/USD -s 2021-06-25 -o gnucash-sql | psql -U username -d
> databasename -v ON_ERROR_STOP=1
>
> I discuss some details of the generated SQL in the source code:
>
> https://gitlab.com/chrisberkhout/pricehist/-/blob/master/src/pricehist/outputs/gnucashsql.py
>
> As far as I am aware GnuCash's built-in price fetching is for current
> prices only. The wiki documents wrapper scripts for the Finance::QuoteHist
> Perl module, and the Piecash library has a Commodity.update_prices method
> for fetching historical prices, but I hope that pricehist will make
> fetching historical prices easy for GnuCash users who don't want to write
> their own code for it.
>
> If pricehist might be useful for you please try it and let me know what
> you
> think. I'm still improving error handling and some other things but the
> main functionality is done.
>
> Cheers,
> Chris
> ___
> 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.
>


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

___
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] GNU cash - Introduction

[D. via gnucash-user]

Hello, 

Gnucash is double entry accounting. You're putting both entries for the 
transaction into the same account. Try reading the Guide (available at the 
website) to grasp the concepts, especially 
https://www.gnucash.org/docs/v4/C/gnucash-guide/basics-accounting1.html#basics-accountingdouble2

David


 Original Message 
From: 3JS Airconandtechservices <3jsairconandtechservi...@gmail.com>
Sent: Fri Jul 02 08:10:43 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] GNU cash - Introduction

Hi there,

Can someone please help me, our  problem is whenever i add an income (not
only income but also all other sales like acount) transaction , it
willautomatically duplicate this particular transaction but the amount is
now tranferred to "Charge" resulting to zero balance.
see sample screenshot below :
[image: image.png]


Thanks in advance!.




___
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] how to find

[D. via gnucash-user]

Billie,

I can read your frustration in your message(s). However, you're not helping 
yourself with this message. Asking this group why gnucash is not like 
quickbooks is like asking why a PC couldn't be more like a Mac. They're 
different. Get used to it, or pay for quickbooks. 

Instead, you should tell us what you expect or want to have happen-- 
specifically! -- and then tell us what you get instead. We can then explain 
better what is going on, why you are seeing what you see, and how you can work 
with gnucash. Since every transaction in GnuCash technically includes at least 
two splits, telling us that you "tried splits again" tells us virtually nothing 
about your issues. 

For the record, your previous message is at: 
https://lists.gnucash.org/pipermail/gnucash-user/2021-June/096772.html

I found it by going to the user list archives and searching last month's 
threads for your name. 

I'll note that the previous thread provided you numerous resources and 
recommendations. Have you consulted/considered them? 

David T.


 Original Message 
From: Billie-Internet 
Sent: Sat Jul 03 07:58:31 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] how to find

Good Morning,
Two weeks ago I got help on split transactions.  How do I find that thread?
I tried splits again yesterday and what a mess.  Why can't they just
work like quick books?


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

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

Re: [GNC] gnucash version 4.6 precission issue in price

[D via gnucash-user]

I seem to recall a bug about this in recent days, but cannot locate it now. 

On Jul 3, 2021, 16:12, at 16:12, s310...@gmail.com wrote:
>hi David,
>
>thanks for the reply,
>
>I tried to change the precision as you noted. but it didn't help
>
>some more info:
>I am not using the online quotes option. I enter the prices manually
>every
>weekend.
>The issue started with version 4.6. in version 4.5 I didn't experience
>any
>issue and it is the same gnucash file (no new stocks/bonds have been
>added
>for a while now).
>As a matter of fact, I have reinstalled version 4.5 and it works fine
>with 4.5.
>
>BR,
>Shay
>
>
>
>On Sat, Jul 3, 2021 at 10:37 PM David Carlson
>
>wrote:
>
>> In the  price database the precision is individually set for each
>currency
>> or commodity.  That is defined in the securities database using the
>> Security editor, normally when you initially define the currency or
>> security, tho you can change it later.  If you are at the stage of
>entering
>> a transaction where you need a price to complete the transaction, it
>is
>> usually easiest to enter the number of shares and total value and let
>> GnuCash calculate the price.
>>
>> On Sat, Jul 3, 2021 at 2:19 PM  wrote:
>>
>>> hi,
>>>
>>> in the price database tool, I am trying to set a price of 1.0079 but
>it
>>> "corrects" me to 1.01
>>> a value of 1.0001 becomes 1
>>>
>>> I tried to change the preferences -> numbers -> decimal point to
>4/5/6
>>> places, and also remove the "force prices to display as decimals"
>>> but it didn't work
>>>
>>> What am I missing? Is there a bug?
>>>
>>> BR,
>>> Shay
>>> ___
>>> 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.
>>>
>>
>>
>> --
>> David Carlson
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
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] how to import a csv of transactions?

[D. via gnucash-user]

I would also wonder at Arman's comment "getting transactions out of one gnucash 
file and into another."

What exactly are you trying to do, Arman? It sounds like you believe you need 
to export your old data into the new version. This is not necessary; gnucash 
can read the existing data file. 

If you're trying something else, I apologize. If you share your goal with the 
list, perhaps a clearer path will appear. 

David


 Original Message 
From: Geoff 
Sent: Mon Jul 12 08:39:50 EDT 2021
To: Arman Schwarz , GnuCash users group 

Subject: Re: [GNC] how to import a csv of transactions?

Hi Arman

Yes, this *definitely* works with v4.4 on Windows.  I haven't tried v4.6 
yet, but I'd be surprised if it was broken.

See the fifth post in this thread which includes screenshots and a 
sample CSV file:

http://gnucash.1415818.n4.nabble.com/GNC-Tracking-cash-flows-with-balanced-transactions-td4721056.html

Good luck!

Geoff
=

On 12/07/2021 10:01 pm, Arman Schwarz wrote:
> I've tried on both 4.4 and 4.6 but it seems that importing csv transactions
> is broken. Before I continue down this path, is csv importing an actually
> supported feature or are the issues with it known? Normally I'd put more
> effort into repro steps but I think it's so broken the devs hopefully
> already know about it. Errors I encountered:
> 
> - Anything more than 200 transactions results in a fatal exception when
> selecting "GnuCash export format"
> - Account name is ignored, meaning you have to manually link every account.
> 
> I'm on windows.
> 
> Are there any working alternatives for getting transactions out of one
> gnucash file and into another?
> 
> Sorry again for the lack of detail.
> 
> Arman
> ___
> 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.
___
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 anyone help with this issue please - GNC-FQ Not able to collect data

[D. via gnucash-user]

Out of curiosity, have you tried reinstalling Finance::Quote from the menu 
option? I recently resumed use of F::Q, but found it non functional. I 
reinstalled from the menu, and things started working again...


 Original Message 
From: david.rom...@davidjromano.com
Sent: Mon Jul 19 08:04:11 EDT 2021
To: 'Geoff' , gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to 
collect data

I think your right - does not look good - no output at all

C:\Program Files (x86)\gnucash\bin>perl -MFinance::Quote -e "my $q = 
Finance::Quote->new(); print $q->currency(q/USD/,q/GBP/);"

C:\Program Files (x86)\gnucash\bin>

Best regards,

David Romano,

UK Direct line: +44 (0) 23 9234 1647
UK Mobile & WhatsApp: +44 (0) 79 4830 8868
Skype Video Call: David.J.Romano

-Original Message-
From: Geoff  
Sent: 19 July 2021 13:01
To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not able to 
collect data

Hmmm, something is definitely broken there.

Let me know what you get with my second email.

Geoff
=

On 19/07/2021 9:57 pm, david.rom...@davidjromano.com wrote:
> Sorry Geoff, I was pasting from my troubleshooting notes not what I typed.
> 
> I’ve attached the screenshot
> 
> Best regards,
> 
> David Romano,
> 
> UK Direct line: +44 (0) 23 9234 1647
> 
> UK Mobile & WhatsApp: +44 (0) 79 4830 8868
> 
> Skype Video Call: David.J.Romano
> 
> -Original Message-
> From: Geoff 
> Sent: 19 July 2021 12:41
> To: david.rom...@davidjromano.com; gnucash-user@gnucash.org
> Subject: Re: [GNC] Can anyone help with this issue please - GNC-FQ Not 
> able to collect data
> 
> Hi David
> 
> This problem is because you are pasting not just the command itself, 
> but also its expected output.
> 
> This is the command:
> 
> echo (currency "USD" "GBP") | perl gnc-fq-helper
> 
> And this is the expected output:
> 
> (("USD" (symbol . "USD") (gnc:time-no-zone . "2021-07-19 21:27:37") 
> (last . #e0.72922) (currency . "GBP")))
> 
> See attached screenshot.
> 
> Hope this helps.
> 
> Regards
> 
> Geoff
> 
> =
> 
> On 19/07/2021 7:08 pm, david.rom...@davidjromano.com 
>  wrote:
> 
>  > Good morning Geoff - I'm now back in the office and have run 
> through your
> 
>  > suggestions with the following result:
> 
>  >
> 
>  >
> 
>  > a) C:\Program Files (x86)\gnucash\bin>set
> 
>  > ALPHAVANTAGE_API_KEY=[MYKEY]
> 
>  >
> 
>  > > LOOKS OK
> 
>  >
> 
>  > b) C:\Program Files (x86)\gnucash\bin>echo 
> %ALPHAVANTAGE_API_KEY%
> 
>  > [MYKEY]
> 
>  >
> 
>  > > RETURNS KEY CORRECTLY
> 
>  >
> 
>  > c) C:\Program Files (x86)\gnucash\bin>echo (currency 
> "USD" "GBP") |
> 
>  > perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone . 
> "2021-03-10
> 
>  > 08:40:01") (last . #e0.72002) (currency . "GBP")))
> 
>  >
> 
>  > > RETURNS ERROR STRING:
> 
>  >
> 
>  > C:\Program Files (x86)\gnucash\bin>echo 
> (currency "USD"
> 
>  > "GBP") | perl gnc-fq-helper (("USD" (symbol . "USD") (gnc:time-no-zone .
> 
>  > "2021-03-10 08:40:01") (last . #e0.72002) (currency . "GBP")))
> 
>  >
> 
>  > Can't open ((USD: No 
> such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open (symbol: No 
> such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't do inplace edit: . 
> is not a regular file at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open USD): No 
> such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open
> (gnc:time-no-zone: No such file or
> 
>  > directory at gnc-fq-helper line 331.
> 
>  > Can't do inplace edit: . 
> is not a regular file at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open 2021-03-10
> 08:40:01): Invalid argument at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open (last: No 
> such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't do inplace edit: . 
> is not a regular file at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open #e0.72002): 
> No such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't open (currency: 
> No such file or directory at
> 
>  > gnc-fq-helper line 331.
> 
>  > Can't do inplace edit: . 
> is not a regular file at
> 
>  > gnc-fq-helper line 331.
> 
>  >   

Re: [GNC] Balance Sheet and Win Loose Statement

[D. via gnucash-user]

Silvio,

Perhaps you might explain further what precisely you're trying to do, and why. 
If I wanted to see the data in a Balance Sheet or a Profit & Loss Statement, 
I'd just run those reports from the menu. Further, if I needed to manipulate 
the information more, I'd probably copy and paste the contents into a 
spreadsheet and work on that. Why use python at all? 

Best, 
David T.


 Original Message 
From: Silvio Siefke 
Sent: Sun Jul 25 07:29:08 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] Balance Sheet and Win Loose Statement

Hello,

is there a way with python to ask Gnucash (MySql) for the values of 
Balance Sheet and Win Loose Statement? 

I had take a look on github but be not sure what is right, most
of the scripts use xml file of GnuCash.

Thanks for help.
Silvio




___
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] Balance Sheet and Win Loose Statement

[D. via gnucash-user]

I believe one can set the date for the balance sheet using options, and that 
would be how I handled that. I'd assume that getting these numbers for past 
years (say, for 2010) would be a one time process, assuming that your 2010 
books wouldn't change any more, once they are complete. Once derived, they 
could be written down, printed, or otherwise captured in final form for future 
reference, so I don't see why you're looking to introduce a new level of 
complexity to the process. 

As for your ideas about python functions, I don't work with gnucash at that 
level, so I'll let someone else try and answer whether such functions exist 
(but I doubt they do).

David T.


 Original Message 
From: Silvio Siefke 
Sent: Sun Jul 25 11:54:47 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Balance Sheet and Win Loose Statement

Hi,

> Perhaps you might explain further what precisely you're trying to do, and 
> why. If I wanted to see the data in a Balance Sheet or a Profit & Loss 
> Statement, I'd just run those reports from the menu. Further, if I needed to 
> manipulate the information more, I'd probably copy and paste the contents 
> into a spreadsheet and work on that. Why use python at all? 

Now I go to Reports > Balance Sheet and see the Balance after give the 
year. But I want make some statistics and its hard ever change the year. 

Assets + Liabilities are the same sum so this sum is what I need.
* https://en.wikipedia.org/wiki/Balance_sheet

Same for Income statement only need NET INCOME thats all.
* https://en.wikipedia.org/wiki/Income_statement

I have read gnucash work with python maybe there is libary where
can do like:

./python_gnucash 2010 "Balance Sheet Sum"
./python_gnucash 2010 "Income statement NET INCOME"

So is my idea would make easier, when can handle the complete
Income Statement / Balance Sheet is great but at end only need the sum!

Regards & Thank you
Silvio




___
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] Scheduled transaction with variable amount

[D. via gnucash-user]

Creating a transaction for a total amount as of a certain date doesn't seem 
particularly useful. What if you have a dispute, or a return, or a transaction 
that is not accurate, or needs correction? An automatically-created transaction 
will need to be corrected as well. 

Gnucash provides an option during the final step of the reconcile process to 
create a payment in the total statement amount. From an accounting perspective, 
this is the best point to create this payment. You have just established that 
your books and theirs match, and the amount due is confirmed. 

If you're not seeing this dialog during the reconcile process, you have turned 
the feature off for that account, but it can be reset. Just don't ask me how...

David T. 


 Original Message 
From: Aleksandar Kocic 
Sent: Tue Jul 27 21:51:04 EDT 2021
To: David Carlson 
Cc: Gyle McCollam , "gnucash-user@gnucash.org" 
, Derek Atkins 
Subject: Re: [GNC] Scheduled transaction with variable amount

Thanks,

While there is a way to not enter the amount, it is not an automated
process, and, in a sense, it is not different from putting a random value
and changing it later. Also, if a transaction can't be created
automatically, it means it will be even more manual steps to get it done.

What I was looking for is a scheduler checking the account balance and
setting the value automatically.

Maybe one day.

Regards,
Aleksandar

On Tue, Jul 27, 2021 at 8:43 PM David Carlson 
wrote:

> Gyle,
>
> I believe you cannot create a transaction with a variable automatically
> created, i.e. do not check the second box in the editor screen.  Then it
> will ask for a value when you run the since last run assistant.
>
> On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam  wrote:
>
> > Derek, this is something I was looking for, however when I tried to put
> > "total" in the debit and credit formula it wouldn't allow the "s.  So I
> > tried with the quotes and it wouldn't save the scheduled transaction.
> See
> > the attach screen shot.  Can you tell me what I did wrong?
> >
> > [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
> >
> > Thank You,
> >
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.com   email
> >
> > 
> > From: gnucash-user 
> on
> > behalf of Derek Atkins 
> > Sent: Tuesday, July 27, 2021 4:37 PM
> > To: Aleksandar Kocic 
> > Cc: Gnucash Users 
> > Subject: Re: [GNC] Scheduled transaction with variable amount
> >
> > Hi,
> >
> > On Tue, July 27, 2021 4:24 pm, Aleksandar Kocic wrote:
> > > Hi there,
> > >
> > > I wonder if it would be possible to schedule a transaction with a
> > variable
> > > amount. For example, if I want to schedule a credit card payment, I
> need
> > > to
> > > provide a fixed amount per transaction although we know that these
> > > amounts vary month to month. Instead, it would be nice to have a way to
> > > set
> > > a transaction that would just pay the balance every month.
> >
> > Yes, just put a variable (string) in the debit/credit formula.  Eg,
> > "total".  When the SX fires, it will ask you for the actual amount to put
> > in.
> >
> > Enjoy.
> >
> > >
> > > Please advise.
> > >
> > > Regards,
> > > Aleksandar
> >
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > --
> >Derek Atkins 617-623-3745
> >de...@ihtfp.com www.ihtfp.com
> >Computer and Internet Security Consultant
> >
> > ___
> > 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.
> >
>
>
> --
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all yo

Re: [GNC] Scheduled transaction with variable amount

[D via gnucash-user]

So, now this thread is officially hijacked. I hope OP finds a solution to his 
problem, or reports back his solution. 

On Jul 28, 2021, 11:33, at 11:33, David Carlson  
wrote:
>Gyle,
>
>It looks like there are some spurious characters somewhere in your
>data.
>Do you see problems in any other windows such as import windows, the
>chart
>of accounts or other places?
>
>On Wed, Jul 28, 2021 at 9:30 AM Gyle McCollam 
>wrote:
>
>> Speaking of reconciliation, I have a problem with deposits not
>showing on
>> one of my accounts and I don't know why this is happening (see
>below).  I
>> didn't include the right side, which is fine, because it shows other
>banks
>> and credit accounts.  Even if I maximize the page it doesn't change.
>> [cid:4011b06e-5772-49ff-b374-e249e2baaa78]
>>
>>
>> Thank You,
>> Gyle McCollam
>>
>> Gyle McCollam
>>
>> 609.680.2326 Mobile
>>
>> gmccol...@live.com   email
>>
>> 
>> From: D. 
>> Sent: Wednesday, July 28, 2021 8:17 AM
>> To: Aleksandar Kocic 
>> Cc: David Carlson ; Gyle McCollam <
>> gmccol...@live.com>; gnucash-user@gnucash.org
>;
>> Derek Atkins 
>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>
>> Creating a transaction for a total amount as of a certain date
>doesn't
>> seem particularly useful. What if you have a dispute, or a return, or
>a
>> transaction that is not accurate, or needs correction? An
>> automatically-created transaction will need to be corrected as well.
>>
>> Gnucash provides an option during the final step of the reconcile
>process
>> to create a payment in the total statement amount. From an accounting
>> perspective, this is the best point to create this payment. You have
>just
>> established that your books and theirs match, and the amount due is
>> confirmed.
>>
>> If you're not seeing this dialog during the reconcile process, you
>have
>> turned the feature off for that account, but it can be reset. Just
>don't
>> ask me how...
>>
>> David T.
>> 
>> From: Aleksandar Kocic
>> Sent: Tue Jul 27 21:51:04 EDT 2021
>> To: David Carlson
>> Cc: Gyle McCollam , "gnucash-user@gnucash.org" , Derek Atkins
>> Subject: Re: [GNC] Scheduled transaction with variable amount
>>
>>
>> Thanks,
>>
>> While there is a way to not enter the amount, it is not an automated
>> process, and, in a sense, it is not different from putting a random
>value
>> and changing it later. Also, if a transaction can't be created
>> automatically, it means it will be even more manual steps to get it
>done.
>>
>> What I was looking for is a scheduler checking the account balance
>and
>> setting the value automatically.
>>
>> Maybe one day.
>>
>> Regards,
>> Aleksandar
>>
>> On Tue, Jul 27, 2021 at 8:43 PM David Carlson
>> >
>> wrote:
>>
>>  Gyle,
>>
>>  I believe you cannot create a transaction with a variable
>automatically
>>  created, i.e. do not check the second box in the editor screen. 
>Then it
>>  will ask for a value when you run the since last run assistant.
>>
>>  On Tue, Jul 27, 2021 at 7:18 PM Gyle McCollam 
>wrote:
>>
>>  Derek, this is something I was looking for, however when I tried to
>put
>>  "total" in the debit and credit formula it wouldn't allow the "s. 
>So I
>>  tried with the quotes and it wouldn't save the scheduled
>transaction.
>>  See
>>  the attach screen shot.  Can you tell me what I did wrong?
>>
>>  [cid:b223ae00-6131-45ea-a805-a1b590e0d7dc]
>>
>>  Thank You,
>>
>>  Gyle McCollam
>>
>>  Gyle McCollam
>>
>>  609.680.2326 Mobile
>>
>>  gmccol...@live.com   email
>>
>> 
>>
>>  From: gnucash-user > http://gmail.com>@gnucash.org>
>>  on
>>  behalf of Derek Atkins 
>>  Sent: Tuesday, July 27, 2021 4:37 PM
>>  To: Aleksandar Kocic 
>>  Cc: Gnucash Users 
>>  Subject: Re: [GNC] Scheduled transaction with variable amount
>>
>>  Hi,
>>
>>  On Tue, July 27, 2021 4:24 pm, Aleksandar Kocic wrote:
>>  Hi there,
>>
>>  I wonder if it would be possible to schedule a transaction with a
>>  variable
>>  amount. For example, if I want to schedule a credit card payment, I
>>  need
>>  to
>>  provide a fixed amount per transaction although we know that these
>>  amounts vary month to month. Instead, it would be nice to have a way
>to
>>  set
>>  a transaction that would just pay the balance every month.
>>
>>  Yes, just put a variable (string) in the debit/credit formula.  Eg,
>>  "total".  When the SX fires, it will ask you for the actual amount
>to put
>>  in.
>>
>>  Enjoy.
>>
>>
>>  Please advise.
>>
>>  Regards,
>>  Aleksandar
>>
>>  Please remember to CC this list on all your replies.
>>  You can do this by using Reply-To-List or Reply-All.
>>
>>  -derek
>>
>>  --
>> Derek Atkins 617-623-3745
>> de...@ihtfp.com
>www.ihtfp.com<
>> http://www.ihtfp.com>
>> Computer and Inte

Re: [GNC] Multi-split CSV Import

[D. via gnucash-user]

As an aside, the documentation discrepancies between the Help and the Guide 
that flywire noted are due to the differing preferences of the documentarians 
behind the files. The person who worked assiduously to document the CSV 
importer prefers the Help files, and so placed his text there. 

Updating and improving the documentation so that subsequent users can find 
assistance there is one way end users can give back to the community. This 
includes rewriting sections in one doc to support and reinforce what is said in 
the other. 

David T. 


 Original Message 
From: Geert Janssens 
Sent: Fri Aug 20 05:54:18 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Multi-split CSV Import

Multisplit is a gnucash specific variant of a csv file. In short it's csv in 
which certain fields can be left empty if they are the same on consecutive 
rows. This avoids having to repeat transaction specific data for each split of 
a transaction.

Or put differently, the format expects full transaction details, both 
transaction specific and split specific.
Each line should define
- one split via split specific fields (account and deposit/withdrawal as bare 
minimum) *and* 
- to which transaction the split belongs via transaction specific fields (date 
and description as bare minimum).
There is a convenience built in that you don't have to repeat the transaction 
fields if the split belongs to the same transaction as the previous one (though 
you can repeat them if that makes csv preparation easier)

Missing date does not define whether or not import data is multi-split or not. 
The requirement is that we need a date for every transaction to import. Given 
that for a multi line import only the first line of a transaction requires 
transaction fields set, it follows that multi line import data may have 
secondary line that have no date field set.

Then there's the question of why account data is fully filled on csv export. I 
can think of a few motivations I had back then:
1. the intention of the exporter is to create a file that can be imported with 
minimal effort. So if you export a file from a gnucash data file and import it 
in another, only the accounts should be trained once. If one account would be 
missing from the import data the transaction matcher would have to be trained 
as well.
2. The transaction matcher code also predates the multi line import 
implementation and I honestly don't know how well it would handle imbalanced or 
incomplete multi-split transactions. It may well work but it was too much of a 
scope back then to test all of that as well. So the multi line import's primary 
use case is data that fully describes each transaction, including an account 
for each split. It may be possible to change that to the same concept of 
incomplete transaction data where an imbalance in the provided splits is 
handled via adding a balancing split in:the base account. That would require 
careful study of the transaction matcher and a lot of testing.

Regards,

Geert

flywire  schreef op 20 augustus 2021 09:44:32 CEST:
>CSV Import is documented in
>https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-csv
>In a lot more detail than the Guide and Concepts Manual (which is
>hardly
>more than a list of headings).
>
>The only dataset demonstrated is a screenshot in Figure 6.5. The CSV
>Import
>Preview Panel
>https://www.gnucash.org/docs/v4/C/gnucash-help/figures/Help_CSV_Import_transactions_Preview.png
>
>So, the csv imports account transactions with the transfer account.
>
>* Multi-split: Selecting this check box allows the splits for a single
>transaction to be defined on consecutive lines within the file with
>each
>line defining a single split. If not selected each line is assumed to
>contain the information for a single transaction including one or two
>splits;
>
>A file or at least an image is needed to go with that multi-split
>statement.
>
>From the manual it's clear all that is required are the extra splits,
>but
>this isn't the case is it? In a previous post the direction is just
>export
>a multi-split and look at the file.
>
>Required data: Date, Deposit/Withdrawal, Description??, Account,
>Transfer
>Account??. I haven't been through the code but understand a missing
>date
>entry indicates it's a multi-split (so csv lines aren't data records in
>the
>normal sense). That's a lot simpler than a csv export. An export has an
>account line for *every* transaction. Why would that be required for a
>csv
>import of an account when it isn't needed for single splits? It's
>redundant
>data complicating file preparation.
>
>I expect CSV Import is fairly close to the initial process for most
>users
>and I knew something wasn't right about it compared to other software.
>It's
>described in The Emperor's New Clothes (as with the definition of
>split).
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription

Re: [GNC] Multi-split CSV Import

[D. via gnucash-user]

Glad you're putting this into a narrative. In the past, I've worked on the 
docs, on both Mac and Windows environments. If I* can do it, it's most 
certainly possible!

David

* Geert and other long term devs can vouch for my high level of ineptitude 
regarding the development tools. 


 Original Message 
From: flywire 
Sent: Fri Aug 20 09:32:16 EDT 2021
To: Gnucash Users 
Subject: Re: [GNC] Multi-split CSV Import

Geert, thank you. With that pretty simple explanation I completely
understand it.

I've rolled all that together ordering the split description lines the same
as the input form and added an example based on the Tutorial and Concepts
Guide. David T, I'm with you on contributing but iirc the development
environment to contribute to the docs is all but unachievable on Windows.
I'll leave this as a suggestion.

==

* Multi-split: Selecting this check box allows the splits for a single
transaction to be defined on consecutive lines within the file with each
line defining a single split. If not selected each line is assumed to
contain the information for a single transaction including one or two
splits;

Multi-split is a gnucash specific variant of a csv file to support easier
data preparation.

Each line should define one split via:
- transaction-specific fields (date and description as bare minimum) *and*
- split specific fields (account and deposit/withdrawal as bare minimum).

There is a convenience feature built-in so you don't have to repeat the
transaction fields if the split belongs to the same transaction as the
previous one (though you can repeat them if that makes csv preparation
easier).

Sample Multi-split.csv

Date,Description,Deposit,Account
05/03/2006,Grocery Store,-45.21,Assets:Checking
,,45.21,Expenses:Groceries
14/03/2006,Employers R Us,670.00,Assets:Checking
,,180.00,Expenses:Taxes:Federal
,,90.00,Expenses:Taxes:Medicare
,,60.00,Expenses:Taxes:Social Security
,,-1000.00,Income:Salary
___
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 the .gnc suffix now the default?

[D. via gnucash-user]

Per https://wiki.gnucash.org/wiki/FAQ#Q:_What.27s_the_GnuCash_file_extension.3F

".gnucash" is the data file extension. 

Creating a simple shell script that invokes gnucash with the "--no-file" option 
would be my method. 


 Original Message 
From: Chris Green 
Sent: Mon Aug 23 12:59:30 EDT 2021
To: gnucash-user@gnucash.org
Subject: [GNC] Is the .gnc suffix now the default?

I'm running gnucash 4.4 on Linux, I see the man page now shows:-

SYNOPSIS
   gnucash [options] [ accounts.gnc ]

Has .gnc replaced .gnucash as the account file default suffix now?  


Also is it possible to have some sort of configuration file to set
command line options?  I'd like to default to --nofile whenever I run
gnucash as I just about never want the same accounts file twice.

-- 
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] Financial Account Structure for Australian Shares and ETFs

[D. via gnucash-user]

Regarding your search: I get results from:
https://www.google.com/search?q=franking+site%3Agnucash.org

I'm not sure why Google.ca would have different results, or whether my broader 
site designation draws in more. Mind you, they're older than the previous year, 
but this discussion has occurred.


 Original Message 
From: flywire 
Sent: Fri Aug 27 08:39:23 EDT 2021
To: Gnucash Users 
Subject: Re: [GNC] Financial Account Structure for Australian Shares and ETFs

Thanks Chris, that helps me understand it a bit more but a little
differently. I see Franking Credits as Income. Maybe someone with a formal
accountancy background has an opinion.

So, Income account has Franked, Unfranked (from Bank) and Franking Credit
(from Asset). I'm not sure how taxes should be accounted for but I have an
Expense:Tax:Personal account and normally get a refund which I put through
as a credit. I can see that should clear the [Asset] Franking Credit
account.

Let's see if the screenshot below comes through with a dividend for 100 MQG
shares:

[image: image.png]

btw, Google search isn't returning anything for Franking over the last
year:
https://www.google.ca/search?q=site:lists.gnucash.org/pipermail/gnucash-user+franking&source=lnt&tbs=qdr:y&bih=1003

>




___
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] QIF imports for security pricing

[D. via gnucash-user]

I've used csv imports for commodity prices many times. Because of problems with 
retrieving prices through Finance::Quote that started when Yahoo! deactivated 
its servers, I set up a process that worked pretty well to get weekly price 
updates into gnucash. 

I built a spreadsheet in Google Sheets in which I pasted the output of the 
Advanced Portfolio report on one sheet. I then pulled tickers from this pasted 
info, and then used Google's finance functions to get current quotes. This all 
was in a sheet with stock symbol, date, and price, that I could then cut and 
paste into a new csv file, which I then imported into gnucash using a saved csv 
profile. 

Although it sounds complex, it actually only took a couple of minutes to 
perform the routine, once I had it worked through. 

David T. 


 Original Message 
From: David Carlson 
Sent: Tue Sep 07 10:32:21 EDT 2021
To: Kalpesh Patel 
Cc: Gnucash Users 
Subject: Re: [GNC] QIF imports for security pricing

Kalpesh,

Have you tried to put together a way to get prices in a CSV file and import
that?  I will admit that I haven't tried that myself, so if any others
could elaborate on a way to do that?

On Tue, Sep 7, 2021 at 8:56 AM Kalpesh Patel  wrote:

> I am at version 4.4 (2020-12-28) and had to roll back to version 4.4
> because
> it appears that the changes in the later versions of libofx included in the
> subsequent version of GnuCash is severely impacting OFX imports for
> investment accounts.
>
> Securities themselves exist under "FUND" section of security editor and
> were
> created as part of the investment transactions import.
>
> Looks like I will have to make a choice ... loose certain functionality of
> OFX and upgrade, or live without QIF security pricing import and stay
> behind. A dreaded conundrum ...
>
> -Original Message-
> From: Dong Lin 
> Sent: Monday, September 06, 2021 3:56 PM
> To: Kalpesh Patel 
> Cc: gnucash-user@gnucash.org
> Subject: Re: [GNC] QIF imports for security pricing
>
>
> Which GNC version are you using? Price database update from QIF imports is
> added in version 4.5.
>
> In order to propagate the price db through import, you need to ensure the
> security account type is mutual_fund or stock and the corresponding
> security
> exists in the security editor.
>
>
> > Hello GnuCash Dev and user community -
> >
> >
> >
> > Looking for answer to few questions related to GnuCash use, so I am
> > hoping community can provide guidance.
> >
> >
> >
> > -  Recently I tried to import a QIF file containing mutual fund
> > transactions and pricing info into an investment account. The
> > securities transactions in it imported fine but it appears that the
> > importer skipped security prices that were also defined in that file.
> > I tried same file with Quicken 2017 to make sure there were no errors
> > in the file and it imported all data without any problem, and with a
> > brand new clean GnuCash file and importing it. Price database do not
> > show any pricing information either.
> > Is
> > this the intended behavior of the importer?
> >
> >
> >
> > -  After importing transactions, I noticed that Present (USD),
> > Cleared (USD), Reconciled (USD), and total (USD) columns in the
> > account list displays zero for the value of the account or the
> > individual security sub-account. Since these are non-public mutual
> > funds, I am unable to get them downloaded via any of the financial
> > sources nor do symbol exist for them. Is this the intended behavior?
> > How should symbol for each mutual fund be specified? Is there a way to
> > tell it to use the last provided price for the mutual fund to
> > calculate total for that account and show in at least one of those
> > columns?
> >
> >
> >
> > -  Where can I find what is expected in the format of import
> > prices
> > from csv mechanism? Specifically I am getting tripped up with "From
> > Namespace" column. I RTFM but I couldn't make sense out of this
> > specific field.  If there is any guidance on simply importing pricing
> > via CSV that has three columns - date, mutual fund name, and price for
> > that day - it would be appreciated.
> >
> >
> >
> > Look forward to replies.
> >
> >
> >
> > Thanks.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ___
> > 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-

Re: [GNC] QIF imports for security pricing

[D. via gnucash-user]

I don't understand. Why would you need to KEEP importing prices? Once you've 
imported your transactions, you can simply update the price db separately using 
the process I described.

I attach a Google sheet that gets prices for me. Run the Advanced Portfolio 
report for your books, select all, copy, put your cursor in cell A2 of the SRC 
sheet, and paste. Then go to the PriceDB tab. Select 
File->Download->Comma-separated values and save the data. Then in GnuCash, 
choose File->Import->Import Prices from a CSV file. Import the file you just 
created, using the information in the data window to guide you. I just tested 
this, and it works.

David T.


 Original Message 
From: Kalpesh Patel 
Sent: Tue Sep 07 15:02:22 EDT 2021
To: "'D.'" , 'David Carlson' 
Cc: 'David Reiser via gnucash-user' 
Subject: RE: [GNC] QIF imports for security pricing

David & David – that was my next route. 

 

I can write a small program (using python or shell) to convert QIF prices into 
CSV format but I am tripped up with the "From Namespace" column details as I 
cannot move to next screen in the import process as it wants correct column 
identified for import. I did try that with just three columns file - date, 
security name and price – but no luck. Not sure what it is expecting in that 
column (is it the issuer like NYSE, NASDAQ, FUND?) but haven’t been able to 
figure it out so far. Anywhere I can find that info is welcome. It sounds like 
I am overlooking something simple.

 

Investment transactions are in QIF format already so was hoping to just perform 
one import of QIF that was combined of both and call it a day instead of 
performing two separate imports, QIF for transactions and CSV for pricing. I 
could even live with last prices that were used from the last transaction but 
that isn’t being used to display total amount for either. I can live with two 
imports once I figure out what the data should be in for "From Namespace" 
column needs…

 

 

 

 

From: D.  
Sent: Tuesday, September 07, 2021 2:42 PM
To: David Carlson 
Cc: Kalpesh Patel ; David Reiser via gnucash-user 

Subject: Re: [GNC] QIF imports for security pricing

 

I've used csv imports for commodity prices many times. Because of problems with 
retrieving prices through Finance::Quote that started when Yahoo! deactivated 
its servers, I set up a process that worked pretty well to get weekly price 
updates into gnucash. 

I built a spreadsheet in Google Sheets in which I pasted the output of the 
Advanced Portfolio report on one sheet. I then pulled tickers from this pasted 
info, and then used Google's finance functions to get current quotes. This all 
was in a sheet with stock symbol, date, and price, that I could then cut and 
paste into a new csv file, which I then imported into gnucash using a saved csv 
profile. 

Although it sounds complex, it actually only took a couple of minutes to 
perform the routine, once I had it worked through. 

David T. 

  _  

From: David Carlson 
Sent: Tue Sep 07 10:32:21 EDT 2021
To: Kalpesh Patel 
Cc: Gnucash Users 
Subject: Re: [GNC] QIF imports for security pricing



 

Kalpesh,

Have you tried to put together a way to get prices in a CSV file and import
that?  I will admit that I haven't tried that myself, so if any others
could elaborate on a way to do that?

On Tue, Sep 7, 2021 at 8:56 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote:

 I am at version 4.4 (2020-12-28) and had to roll back to version 4.4
 because
 it appears that the changes in the later versions of libofx included in the
 subsequent version of GnuCash is severely impacting OFX imports for
 investment accounts.

 Securities themselves exist under "FUND" section of security editor and
 were
 created as part of the investment transactions import.

 Looks like I will have to make a choice ... loose certain functionality of
 OFX and upgrade, or live without QIF security pricing import and stay
 behind. A dreaded conundrum ...

 -Original Message-
 From: Dong Lin mailto:c54e-gnuc...@yahoo.com> >
 Sent: Monday, September 06, 2021 3:56 PM
 To: Kalpesh Patel mailto:kalpesh.pa...@usa.net> >
 Cc: gnucash-user@gnucash.org  
 Subject: Re: [GNC] QIF imports for security pricing


 Which GNC version are you using? Price database update from QIF imports is
 added in version 4.5.

 In order to propagate the price db through import, you need to ensure the
 security account type is mutual_fund or stock and the corresponding
 security
 exists in the security editor.



 Hello GnuCash Dev and user community -



 Looking for answer to few questions related to GnuCash use, so I am
 hoping community can provide guidance.



 -  Recently I tried to import a QIF file containing mutual fund
 transactions and pricing info into an investment account. The
 securities transactions in it imported fine but it appears that the
 importer skipped security prices that were also defined in that file.
 

Re: [GNC] Build 4.8 docs issue

[D. via gnucash-user]

If Arthur can load the html in your link on his Kindle, he could install an 
epub app (such as Overdrive) and get his flow going using that. 


 Original Message 
From: flywire 
Sent: Sun Oct 03 07:25:44 EDT 2021
To: Gnucash Users 
Subject: [GNC] Build 4.8 docs issue

Arthur, that's a nice summary of a
https://en.wikipedia.org/wiki/Reflowable_document

The issue has been raised and
https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was
offered as a format. Does it work on a Kindle?
___
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] Build 4.8 docs issue

[D. via gnucash-user]

The app question depends on the type of Kindle you're using. The Fire has 
supported apps in the past, but more bare bones Kindles don't. 


 Original Message 
From: A Harvey 
Sent: Sun Oct 03 15:30:50 EDT 2021
To: "D." 
Cc: flywire , Gnucash Users 
Subject: Re: [GNC] Build 4.8 docs issue

Flywire and D.
Thanks for the suggestions.  I will try them tonight and report back.

The Kindle has what Amazon calls the "Experimental Browser".  I have tried
it a few times in the past just to see what it's like.  What it's like is
pouring molasses, but it works.  I will try entering the link in the Kindle
browser.  I will also try to display an HTML document loaded to my Kindle
to compare the speed.  I assume that would be much faster. To get an HTML
document to a Kindle, I either have to email it to an address that is
unique to my account which will store it with the rest of my docs on an
Amazon server, or plug my Kindle into a PC and copy the document from the
PC to the Kindle.

With respect to downloading an app, I don't think the Kindle supports apps
of any kind. I should say I have never seen any downloadable apps on Amazon
or on the web. I have seen a few grumbles about Kindle not having
downloadable games.
-Arthur

On Sun, Oct 3, 2021 at 9:29 AM D. via gnucash-user 
wrote:

> If Arthur can load the html in your link on his Kindle, he could install
> an epub app (such as Overdrive) and get his flow going using that.
>
>
>  Original Message 
> From: flywire 
> Sent: Sun Oct 03 07:25:44 EDT 2021
> To: Gnucash Users 
> Subject: [GNC] Build 4.8 docs issue
>
> Arthur, that's a nice summary of a
> https://en.wikipedia.org/wiki/Reflowable_document
>
> The issue has been raised and
> https://gnucash-docs-rst.readthedocs.io/en/latest/index.html was
> offered as a format. Does it work on a Kindle?
> ___
> 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.
>
___
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] Making the leap to latest

[D. via gnucash-user]

Of course, the Windows installer takes care of uninstalling other versions for 
you, so upgrading or downgrading is a simple matter of running the appropriate 
exe. And if you retain the different versions' download files,  running them is 
simply a matter of double clicking the proper one. 



 Original Message 
From: AC 
Sent: Wed Oct 06 03:52:18 EDT 2021
To: Peter West 
Cc: GnuCash users group , Derek Atkins 

Subject: Re: [GNC] Making the leap to latest

The main problem is that you can't have side-by-side installations on a
Windows system (as has been pointed out to me).  So upgrading the
software means uninstalling the old one, installing the new one and, if
anything goes wrong, reversing that entire process.  A side-by-side
install would let me run both to make sure no issues and then I can
uninstall the older one later once I tested the new one.

However, I think I have a workaround, I'll install a Linux guest VM (I
already have other VMs running on the same box) and do the updates
through the VM first reading in the data each time to save to the new
formats.  If all goes well I'll install the Windows version on the
machine and move the newly converted data files back to the machine from
the VM.

On 2021-10-03 20:27, Peter West wrote:
> I would disagree with “don’t upgrade unless entirely necessary." Open source 
> software (OSS) requires a different approach. Proprietary software offers 
> guarantees of the support lifetime of the software you purchase, paid for by 
> your money. The resources for development and support are very limited and 
> voluntary. The benefits of OSS come with some implied responsibilities.
> 
> Keep your software up-to-date.
>   Keep the installer for you current version of the software. When the 
> next version is released, secure the backup of your date and install the new 
> software. If something goes wrong, re-install the working version, restore 
> your date, and report your problem. We recently had two successive install 
> difficulties, for example. You don’t need to keep the dud installers, 
> obviously.
> 
> Keep an eye on the mailing list, and offer your suggestions to other users if 
> yo think you know how to fix their problems.
> 
> Peter
> —
> Peter West
> p...@ehealth.id.au
> “The one who hears you hears me, and the one who rejects you rejects me, and 
> the one who rejects me rejects him who sent me.”
> 
> 
>> On 3 Oct 2021, at 8:11 am, AC  wrote:
>>
>> I agree don't upgrade if not absolutely necessary but I will likely be
>> replacing this computer in a few months so starting from a newer
>> installation is much more likely to happen in that case.
>>
>> So you're saying I should be able to do three stages of 2.6.last,
>> 3.x.last and then 4.x.last?
>>
>> Are there any big changes to basic functionality from 2.6 to 4.x?  I'm
>> making my way through the change logs but a lot of it is related to
>> various features I don't use (at least that which I've read thus far).
>>
>>
>> On 2021-10-02 15:06, Derek Atkins wrote:
 From 2.6.3 you will need to jump to 2.6.last, then 3.x, then 4.x
>>>
>>> At every version you should load your data file and then save it.
>>>
>>> While there is no requirement to upgrade, and "if it ain't broke, don't
>>> fix it" may apply, if you have a system crash and need to rebuild your
>>> system, it'll be easier to use recent versions.
>>>
>>> -derek
>>> Sent using my mobile device. Please excuse any typos.
>>> On October 2, 2021 5:56:23 PM AC  wrote:
>>>
 Ok, I've been running along on 2.6.3 on Win 10.  No issues to date that
 I can see.

 I know there's been various changes throughout the rest of the 2.x and
 3.x series and we're now on 4.x which sparks some questions:


 Do I really need to update?  I only use the basis ledgers for standard
 banking accounts, credit cards, loans, mutual funds; scheduled
 transactions; and basic reports (typically just the standard transaction
 report when I need a list for taxes). I don't use online transactions,
 imports, or business features.  Can I assume that the basics still work
 the same way?

 If it's better for me to go ahead and update how painful will it be to
 update?

 I recall some suggestions previously about upgrading in increments and
 if that's the case how many increments am I going to need (hopefully not
 one for every point version)?

 ___
 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] Reconciliation Changes

[D. via gnucash-user]

Chris, 

I believe she's implementing envelope budgeting 
(https://www.thebalance.com/what-is-envelope-budgeting-1293682) using sub 
accounts. A fair number of users of Gnucash do this, which has been discussed 
on the lists over the years. 

David T. 


 Original Message 
From: Chris Good 
Sent: Thu Oct 14 03:11:57 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Reconciliation Changes

Hi Lisa,

This change was done under https://bugs.gnucash.org/show_bug.cgi?id=797648
for reasons explained in the bug.
The first fix went live in 3.9 which forced all splits in a transaction to
the new selected reconciled state when one of them was changed, rather than
just toggling the reconciliation status of all the splits for the account
being reconciled.
This was deemed incorrect, so a change was made in 3.11 where changing the
reconciliation status of a split in a transaction had no effect of other
splits in the transaction for the account being reconciled.

I wouldn't recommend running an old version like 3.10. Never upgrading until
you have to greatly increases your risk of falling foul of a security issue
(or just a bug) that may have already been fixed.

I don't upgrade immediately a new version is available, but I do after a
little while so it is likely that any major problems with a new release will
have been found and probably fixed.

It seems unusual to create different subaccounts in a bank account for
different types of expenses.
I believe it is more usual to split your income and expenses into different
income and expense accounts, and do your budgeting based on the totals of
those accounts.

Regards,
Chris Good

Message: 6
Date: Tue, 12 Oct 2021 20:31:44 -0700
From: Lisa Reynoso 
To: David Carlson 
Cc: DaveC49 , Gnucash Users

Subject: Re: [GNC] Reconciliation Changes
Message-ID: <916d45e4-a319-4ab9-bfb9-fd7a6557f...@gmail.com>
Content-Type: text/plain;   charset=utf-8

Well, my computer reformatted, so I had to start over. But in almost two
decades, I started over several times, and this last time is the only time
this problem occurred. I can?t imagine that had anything to do with it. 

I?m going to look at an old hard drive I saved from a couple computers back
and see if I have an old installation file and see what it does if I do. Or
what happens if I import old files from years back (if they are still
there). I?ll let you know how it goes. 

Lisa

Sent from my iPhone

> On Oct 12, 2021, at 5:35 PM, David Carlson 
wrote:
> 
> ?
> Sub accounts under the same bank account are not the same as transfer s to
outside accounts. 
> 
> If I recall correctly, they must be of the same type as the parent
account.  I think that should still work as before in reconciliations.  Were
you able to import your table of accounts from an old file or did you start
over, possibly different somehow this time?
> 
> 
> 
>> On Tue, Oct 12, 2021, 7:18 PM Lisa Reynoso  wrote:
>> Okay, first, I don?t know what version I had before. It was about 2 years
ago that I downloaded it, and my hard drive was wiped, so I have no idea. 
>> 
>> Second, you completely misunderstood my problem. I understand the
reconciliation process intricately; I?ve been using it for a decade and a
half. I understand about clicking the ?include sub accounts? box; it?s the
sub account feature that turned me on to the program, since I was doing that
on paper as my mother did; a computer was so much faster, since it did most
of the math for me. I like math, but it gets tedious entering numbers in a
calculator. But I digress. 
>> 
>> There are two basic examples to illustrate. I have a checking account,
divided into various sub accounts, such as gas, groceries, clothing, school
bill, etc. When I deposit a paycheck, I split the deposit into various
accounts. Likewise when i purchase both food and toothpaste at the grocery
store; toothpaste doesn?t come from the food budget. When I want to
reconcile the checking, I used to be able to check one of those splits and
have them all highlight. So if I checked the toothpaste transaction, the
grocery charge would check as well. Of course the expense account wouldn?t
reconcile; I wasn?t referring to that. 
>> 
>> But the other example is when I transfer money within the checking
account from one sub account to another. Like my original gas to groceries
(or vice versa) analogy. In that case, when I would check the credit, the
debit would check automatically as well, and the balance on the
reconciliation would not change, because no money actually entered or left
the checking. It was just moved around within it. Now I have to check one
and then scroll down to find the other. I make several dozen of these
transactions every month, and it is tedious to have to check them both. 
>> 
>> I downloaded version 4.4 when this problem first made itself felt. I
downloaded 3.11 today, and it still doesn?t do what it used to. I have
Windows 10; I don?t know if an earlier version will work or not. 
>> 
>>

Re: [GNC] My begining balance is wrong

[D. via gnucash-user]

Derek,  Billie,

I'm going out on a limb here, but I'm going to guess that the various problems 
(unsaved changes, reversion to different points, lost progress, etc.) have to 
do with the attempts to back up the data file using Save As. It would be very 
easy under these circumstances to access the wrong file and wonder where the 
last set of changes had gone. 

And to take another point up here, Billie, you didn't ask specifically, but I 
imagine you probably should take a look at the wiki page on backups 
(https://wiki.gnucash.org/wiki/Backup) as well as the FAQ entries about file 
naming 
(https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_...). 

David T. 


 Original Message 
From: Derek Atkins 
Sent: Thu Oct 14 09:52:31 EDT 2021
To: Billie-Internet 
Cc: Gnucash Users 
Subject: Re: [GNC] My begining balance is wrong

Hi,

On Thu, October 14, 2021 9:32 am, Billie-Internet wrote:
> Good Morning,
> I am running
> Version: 4.4
> Build ID: 4.4+(2020-12-28)
>  on windows 10.
>
[snip]
> So today, while reconciling, rather than leave, I jumped back and forth
> from the check register that was open in the background to the reconcile
> to
> enter the few transactions that were on my bank statement but had not been
> put in the register.  I had put these transactions in yesterday but they
> were gone today.

For what it's worth, this is how I operate.  I have the account register
open next to the reconcile window and just go back and forth adding new
transactions instead of exiting the reconcile every time.  Considering
sometimes I'm adding in 50 transactions, that would be a LOT of exiting
sometimes!

> After I clicked finish and then clicked the save button on the menu bar, I
> did a file> save as and saved what I hope is a complete backup to my
> downloads file.  I was trying to achieve a stop/start point at the
> completion of the reconcile.  I did this with QB everymonth and I am not
> sure why I quit doing it with gnucash when I started using it at the
> beginning of this year.
> Now, however, since I did the save as, it appears gnu is saving every time
> to downloads instead of where I had it set to auto save to which is my
> company files.

Yes.  By doing "Save As" you are telling GnuCash "this file is now located
in this new location with this new name", and it will use that as the
primary name going forward.  To save as a backup you need to copy the file
in the background, or, just after you File -> Save As, you should File ->
Open the original file again.

Note:  If you have been making additional changes you should probably File
-> Save As back to the original location.

> [image: image.png]
> So here are my questions.
> Does anyone have any idea why my system reverterted back to a month
> previous?

Perhaps you opened a Backup file?  Honestly, don't know.

> Why would my reconcile not be saving the reconcile when I ask to postpone?

Don't know.

> How do I get my files backing up to my "company files" file where I
> normally save them?

See above.

> Could having a version of quickbooks open at the same time as gnucash have
> caused these issues?  I had quickbooks open to get a report from last year
> for the accountant.

Extremely unlikely. I can't see how there would be any interaction between
them.

> One last question, will I ever become competant with this program?  I used
> QB for 25 years and knew how to work with it but the thought of paying
> $200
> a year for a program you should be able to buy, just killed me so I went
> to
> gnucash.  I have been using gnucash since Jan 2021 and I am amazed that  I
> am still struggling with split transactions not balancing!!  I am just
> lamenting.  I know there is no answer to this but time!

Yes, you will become proficient, eventually.  There are certain "tricks"
that you eventually learn as you use the program.  For example, when
entering a split transaction you should never hit the [Enter] key until
you are absolutely done, and you should be sure you have an anchor split
entered first, so the transaction doesn't disappear from the current view.

Good Luck!

> Thanks for any and all help.
>
>
> Billie
> 706-383-9057

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

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

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

Re: [GNC] My begining balance is wrong

[D. via gnucash-user]

Well, I'm glad you've seen the docs on this! 


 Original Message 
From: Billie-Internet 
Sent: Thu Oct 14 16:42:43 EDT 2021
To: "D." 
Cc: Derek Atkins , Gnucash Users 
Subject: Re: [GNC] My begining balance is wrong

David,
These problems started before the save as issue. Before that, all I ever
used was the save button on the menu.
[image: image.png]
I did read the info on file names before asking question so I knew what
file I was looking for .   I did not know about the wiki on backups.  I
will read it as follow up.

FYI to all, reconcile is still not holding checked transactions.


Billie
706-383-9057




On Thu, Oct 14, 2021 at 12:31 PM D.  wrote:

> Derek,  Billie,
>
> I'm going out on a limb here, but I'm going to guess that the various
> problems (unsaved changes, reversion to different points, lost progress,
> etc.) have to do with the attempts to back up the data file using Save As.
> It would be very easy under these circumstances to access the wrong file
> and wonder where the last set of changes had gone.
>
> And to take another point up here, Billie, you didn't ask specifically,
> but I imagine you probably should take a look at the wiki page on backups (
> https://wiki.gnucash.org/wiki/Backup) as well as the FAQ entries about
> file naming (
> https://wiki.gnucash.org/wiki/FAQ#Basics:_Filenames.2C_Directories.2C_...).
>
>
> David T.
> --
> *From:* Derek Atkins
> *Sent:* Thu Oct 14 09:52:31 EDT 2021
> *To:* Billie-Internet
> *Cc:* Gnucash Users
> *Subject:* Re: [GNC] My begining balance is wrong
>
> Hi,
>
> On Thu, October 14, 2021 9:32 am, Billie-Internet wrote:
>
>>  Good Morning,
>>  I am running
>>  Version: 4.4
>>  Build ID: 4.4+(2020-12-28)
>>   on windows 10.
>
>
> [snip]
>
>>  So today, while reconciling, rather than leave, I jumped back and forth
>>  from the check register that was open in the background to the reconcile
>>  to
>>  enter the few transactions that were on my bank statement but had not been
>>  put in the register.  I had put these transactions in yesterday but they
>>  were gone today.
>>
>
> For what it's worth, this is how I operate.  I have the account register
> open next to the reconcile window and just go back and forth adding new
> transactions instead of exiting the reconcile every time.  Considering
> sometimes I'm adding in 50 transactions, that would be a LOT of exiting
> sometimes!
>
>  After I clicked finish and then clicked the save button on the menu bar, I
>>  did a file> save as and saved what I hope is a complete backup to my
>>  downloads file.  I was trying to achieve a stop/start point at the
>>  completion of the reconcile.  I did this with QB everymonth and I am not
>>  sure why I quit doing it with gnucash when I started using it at the
>>  beginning of this year.
>>  Now, however, since I did the save as, it appears gnu is saving every time
>>  to downloads instead of where I had it set to auto save to which is my
>>  company files.
>>
>
> Yes.  By doing "Save As" you are telling GnuCash "this file is now located
> in this new location with this new name", and it will use that as the
> primary name going forward.  To save as a backup you need to copy the file
> in the background, or, just after you File -> Save As, you should File ->
> Open the original file again.
>
> Note:  If you have been making additional changes you should probably File
> -> Save As back to the original location.
>
>  [image: image.png]
>>  So here are my questions.
>>  Does anyone have any idea why my system reverterted back to a month
>>  previous?
>>
>
> Perhaps you opened a Backup file?  Honestly, don't know.
>
>  Why would my reconcile not be saving the reconcile when I ask to postpone?
>>
>
> Don't know.
>
>  How do I get my files backing up to my "company files" file where I
>>  normally save them?
>>
>
> See above.
>
>  Could having a version of quickbooks open at the same time as gnucash have
>>  caused these issues?  I had quickbooks open to get a report from last year
>>  for the accountant.
>>
>
> Extremely unlikely. I can't see how there would be any interaction between
> them.
>
>  One last question, will I ever become competant with this program?  I used
>>  QB for 25 years and knew how to work with it but the thought of paying
>>  $200
>>  a year for a program you should be able to buy, just killed me so I went
>>  to
>>  gnucash.  I have been using gnucash since Jan 2021 and I am amazed that  I
>>  am still struggling with split transactions not balancing!!  I am just
>>  lamenting.  I know there is no answer to this but time!
>>
>
> Yes, you will become proficient, eventually.  There are certain "tricks"
> that you eventually learn as you use the program.  For example, when
> entering a split transaction you should never hit the [Enter] key until
> you are absolutely done, and you should be sure you have an anchor split
> entered first, so the transaction doesn't disappear from the current view.
>
> Good Luc

Re: [GNC] Can I reverse the "deposit" and "withdrawal" columns for checkbook entry?

[D. via gnucash-user]

"despite the great variety of the world, one cannot expect much flexibility in 
GnuCash"

Seriously? I'm personally astounded by the myriad ways gnucash can be 
implemented to meet a worldwide community's diverse needs. But, sure, say what 
you like.


 Original Message 
From: John Morris 
Sent: Sat Oct 16 14:53:19 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Can I reverse the "deposit" and "withdrawal" columns for 
checkbook entry?

All these arguments hold very little water in the real world. The fact remains 
that the OP's bank does not follow the rules that some people think "should 
be." That bank is not alone in its practice. I interact regularly with three 
different financial institutions, only one of which follows the practice 
advocated by the most ardent GnuCash supporters. Another follows the OP's 
bank's practice and puts the deposits on the right and the withdrawals on the 
left, although it does call these credits and debits, respectively, in 
alignment with the GnuCash description of these terms. The third institution 
gives no running balance and reports both deposit and withdrawal transactions 
in the same column. Such is the variety of the world, and I'm sure it is much 
greater than this.

   Spouting rules and practices does not change the fact that there is still 
very little standardization in the financial world. We each have ways we like 
to work and, given the variety in the world, it is relatively easy to find 
examples to support just about any reasonable choice.


   The main point to take away from this discussion is that, despite the great 
variety of the world, one cannot expect much flexibility in GnuCash. Ease of 
use is not a GnuCash feature. It does things the way the developers think they 
should be done, and anyone who would like to do things differently can just go 
find some other software or develop their own. Tough luck!

Best,
John
On 10/16/21 2:01 PM, Stan Brown wrote:
> 
> On 2021-10-16 08:22, Tom Browder wrote:
>> My bank's checkbook register has the "withdrawal" and "deposit" columns in
>> the reverse order of that shown in Gnucash. Is there any way to reverse
>> them in Gnucash for ease of use?
> 
> I'm sticking my neck out here, but I believe the answer is "no".
> 
> * A deposit is a debit entry to your checking account because it
> increases the value of that asset, and a debit -- which is an increase
> of assets or expenses but a decrease of liabilities,  equity, or income
> -- always goes on the left.
> 
> * Contrariwise, a withdrawal is a credit entry to your checking account
> because it decreases the value of that asset, and a credits -- which is
> a decrease of assets or expenses but an increase of the other account
> types -- always go on the right. (A bookkeeping text that I read many
> years ago said that "debit" and "credit" were just accountants' words
> for "left" and "right", and that when accountants talk about balancing
> books they mean that the totals on the left and right must be equal.)
> 
>  From your bank's point of view, the register is correct because _your_
> withdrawal decreases their obligation (liability) to you and is
> therefore a debit on their books, while _your_ deposit increases their
> obligation and is therefore a credit on their books. The bank's own
> accounting entries are thus exactly opposite to yours.
> 
> My suggestion is to relabel the columns in your checkbook register.
> 
> However ... do you actually need a paper checkbook register? Isn't that
> just duplicating your checking account records in GnuCash?
> 
___
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] Undo Reconciliation

[D. via gnucash-user]

Joe,

You could try loading a backup file from before the erroneous reconciliation. 

David T. 


 Original Message 
From: davidcousen...@gmail.com
Sent: Sat Oct 16 22:24:35 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Undo Reconciliation

Joe,

In the reconciliation window it is possible to click on the debit or credit pane
and then use CTRL-A to select all displayed transactions in either pane and
either set them as reconciled or unreconciled.

There is not any other mechanim to unreconcile transactions other than one at a
time in the register.

David Cousens

On Sat, 2021-10-16 at 04:40 +0200, Joseph Hesse wrote:
> Hello,
> How do I unreconcile about 100 transactions in an account?
> Thank you,
> Joe
> 
> ___
> 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.
___
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] Net Worth Linechart report - can't select hidden accounts

[D. via gnucash-user]

I see the same behavior with GC 4.8 under Windows 10, with the Net Worth 
Linechart as well as with other reports that use the View Hidden Accounts 
option. It's probably related to the fix for bug 363339 
(https://bugs.gnucash.org/show_bug.cgi?id=363339), which was closed as fixed in 
2009. Odd that no one noticed before this. 

As a short term fix, I'd unhide the accounts in question, which can be quickly 
done from the Chart of Accounts page if you have the hidden flag set to show in 
the tree. You can check and uncheck as many accounts as you like (of course, 
set the view to show hidden accounts).

David T. 

By the way, it usually takes a little more time for people to respond to issues 
raised on the list-- especially when the issue is a technical one, like this 
one is. Patience is a virtue. 


 Original Message 
From: Colin Arndt 
Sent: Mon Oct 18 12:03:24 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Net Worth Linechart report - can't select hidden accounts

Just bumping this question. Does anyone have experience or thoughts on this? 

Thanks,
Colin

> On Oct 15, 2021, at 2:59 PM, Colin Arndt  wrote:
> 
> Running the latest 4.8-2 on macOS, and for some time now, I’ve noticed if I 
> select any hidden accounts for this report, the setting doesn’t stick. 
> 
> Going into Options, I select Accounts, then “Show Hidden Accounts.” After 
> selecting the relevant accounts, I click Apply and close out the window. When 
> I come back to the Options screen and re-display Hidden Accounts to verify 
> they’re active... I see they’ve unselected themselves.
> 
> Since the Net Worth report goes back several years, it includes accounts that 
> I’ve since sunsetted and hidden in GnuCash. If I can’t include these in the 
> report, it’s not nearly as accurate or useful.
> 
> Thanks for any help on this,
> Colin

___
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] Net Worth Linechart report - can't select hidden accounts

[D. via gnucash-user]

Not to put words into Colin's mouth, but the linechart report covers a period 
of time, which can be configured in options. So, it's entirely possible 
(likely, in fact), that such a report would need to draw on hidden accounts to 
determine overall status, even if they are now zero balance. 


 Original Message 
From: Adrien Monteleone 
Sent: Mon Oct 25 17:53:36 EDT 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Net Worth Linechart report - can't select hidden accounts

You are no longer using those accounts (have hidden them) and they do 
not contain a zero balance?

While maybe the setting *should* stick, I think it a fair assumption not 
to use hidden accounts in a NetWorth chart/report as they should 
generally have a zero balance and thus not affect the equation at all.

Including them or not, should not have an affect on the chart/report.

(unless you are hiding them for some reason other than that they are now 
zero, and no longer needed)

Regards,
Adrien

On 10/15/21 4:59 PM, Colin Arndt wrote:
> Since the Net Worth report goes back several years, it includes accounts that 
> I’ve since sunsetted and hidden in GnuCash. If I can’t include these in the 
> report, it’s not nearly as accurate or useful.
> 
> Thanks for any help on this,
> Colin

___
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] How to save Accounts to External Drive

[D. via gnucash-user]

File->Save As


 Original Message 
From: Gerald Smith 
Sent: Tue Oct 26 15:21:12 EDT 2021
To: "gnucash-user@gnucash.org" 
Subject: [GNC] How to save Accounts to External Drive

How do you save accounts to an external drive?
G. Smith
___
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] How to save Accounts to External Drive

[D. via gnucash-user]

All good suggestions, but File->Save As eliminates the need to worry about most 
of them right off the bat...

Personally, I'd really like to have an "eternal" drive, but it would have to 
include infinite storage to be really useful... ;-)


 Original Message 
From: Michael or Penny Novack 
Sent: Tue Oct 26 18:12:18 EDT 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to save Accounts to External Drive

On 10/26/2021 5:28 PM, D. via gnucash-user wrote:
> File->Save As

PS:  After "moving" your file to an eternal drive, I strongly suggest 
you rename (if not deleting) the file on the internal drive so that 
gnucash will not find it. You do NOT want to accidentally open it after 
you have begun using the file on the external drive which could happen 
if you opened gnucash while the external drive was not connected.

Michael

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] Updating from v 2.6.16.

[D. via gnucash-user]

2.6.21 is available at 
https://sourceforge.net/projects/gnucash/files/gnucash%20%28stable%29/2.6.21/gnucash-2.6.21-setup.exe/download

Check and repair is a menu option within the program itself. 

David T.


 Original Message 
From: Mike Stillingfleet 
Sent: Fri Nov 05 06:50:03 EDT 2021
To: Fred Bone 
Cc: gnucash Users 
Subject: Re: [GNC] Updating from v 2.6.16.

Thank you Fred.

Please excuse my ignorance but from where would I download 2.6.21.

Is the check and repair functions is there a guide as to how to download and 
run these?

Thank you.

On Fri, Nov 5, 2021, at 10:39 AM, Fred Bone wrote:
> On 05 November 2021 at 7:26, Mike Stillingfleet said:
>
>> Hi David,
>> 
>> Ok so just to clarify are we saying the 2.6.16 can be updated to 4.8
>> directly or do I have to update to 3.11 first.
>
> You might do better to upgrade to 2.6.21 first, then to 3.11, then to 
> 4.8. And run the check-and-repair process after each major-version 
> upgrade.
>
> Upgrading directly beyond a single major release is likely to fail, or at 
> the very least is unsupported (you could be lucky but ...).
>
> See the FAQs at
> https://wiki.gnucash.org/wiki/FAQ#Q:_Can_I_exchange_Gnucash_file_with_any_
> other_version_of_GnuCash.3F

-- 
  Mike Stillingfleet
  mikestillingfl...@fastmail.co.uk
___
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] Problem changing report configuration location

[D. via gnucash-user]

Mark, 

I'm no expert, but my experience of the various cloud services under Windows is 
that their mappings as folders is not always what they appear to be. You may be 
running into some issue related to the following email on the list earlier: 
https://lists.gnucash.org/pipermail/gnucash-user/2021-July/097159.html

David


 Original Message 
From: Mark Itzcovitz 
Sent: Mon Nov 08 17:36:44 EST 2021
To: gnucash-user@gnucash.org
Subject: [GNC] Problem changing report configuration location

I'm trying to change the location of the report configuration files,
so I can put them on OneDrive to share between machines.  I've created
the file environment.local in the same place as the file environment,
C:\Program Files (x86)\gnucash\etc\gnucash, containing this line:
GNC_DATA_HOME=C:\Users\mji\OneDrive\Software\gnucash_data_home
I've also created the gnucash_data_home directory.

My problem is that GnuCash is still using the file saved-reports-2.8
in C:\Users\mji\AppData\Roaming\GnuCash.  Can anyone suggest why that
might be?

As you'll have gathered, I'm running on Windows.  My GnuCash version is 4.5.

Thanks,

Mark
___
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] currency of "value" in stock account

[D. via gnucash-user]

I feel like we have heard this all before? 


 Original Message 
From: "Lionel Élie Mamane" 
Sent: Tue Nov 09 05:44:34 EST 2021
To: gnucash-user@gnucash.org
Subject: [GNC] currency of "value" in stock account

I setup a security.
I create an account of type "Stock" that uses that security, let's say
assets:investments:foobar
I open the register for that account

To enter an operation, in column "shares", I enter the number of
shares. That's clear.

Now, there are columns "price" (which is per-share-price), and columns
"buy" and "sell" which are the total price of the transaction. What is
not clear to me, is what currency are these columns in? I didn't make
a choice for that, and it doesn't seem to be indicated on screen.

There seems to something strange going on, because I enter, in basic
ledger mode, say:

Date: 09/11/21
Memo: test purchase
account: assets:current assets:some bank account
shares: 5
Price: 21

then I press tab/tab/tab to validate the entry and go to the next
line. The "Buy" column is computed and filled in automatically. So far
so good.

But in the "assets:current assets:some bank account" ledger,
both splits of that transaction have an empty amount :-|

In assets:investments:foobar, the bank account split has (when I show
the splits) a "Tot Sell" of 105, that is the 5*21 that I entered.

Thanks in advance for your explanations,

Lionel
___
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] changing accounts?

[D. via gnucash-user]

If you're changing every ABC to DEF, you can delete ABC and tell gnucash to 
move the transactions into DEF. That's documented in the wiki. 

If you're only deleting a bunch (but not all) there isn't one find and replace 
command. When push comes to shove, though, even fixing 100 transactions will 
only take a few minutes' time. 

If it were me in this second scenario (and it has been, believe me!), I'd 
search for the offending transactions, putting them all in a separate register, 
copy the new account designation, and paste it into each transaction at the 
appropriate point before pressing enter to commit them away. 

David


 Original Message 
From: Paul Kinzelman 
Sent: Wed Nov 10 17:25:51 EST 2021
To: Gnucash Elist 
Subject: [GNC] changing accounts?

Is there some way to change all the entries for a set of
items in an account to be charged to one account to
charge them all to another account?

For instance, if I have a monthly charge from XYZ that I charge
to account ABC, and I have a bunch of them in my Checking
account, is there a way to change all of them to DEF without
going in and poking each one? And that's where a simple
account name change ABC->DEF won't work because there's
other stuff in there.

In other words, like a global replace?

TIA!


___
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] changing accounts?

[D. via gnucash-user]

Precisely. Thanks David H.


 Original Message 
From: David H 
Sent: Wed Nov 10 18:38:01 EST 2021
To: p...@kinzelman.com
Cc: Gnucash Elist 
Subject: Re: [GNC] changing accounts?

I'm putting words into David's mouth here, but I think he meant to do a
search, possibly more than 1, so that all the txns you want to change end
up in a separate search result tab. If you've already done a COPY (CTRL /
CMD C) of the new destination account you can then just tab into each txn,
CTRL-V in the correct place and hit enter - as you update each one it will
disappear from the search result tab all going well.

Cheers David H.


On Thu, 11 Nov 2021 at 08:44, Paul Kinzelman  wrote:

> You're a little bit fast for me on that one. :-)
>
> I did it by hand for what I needed right now, but I was asking for next
> time.
>
> In the 3rd paragraph, by "separate register" do you mean create a temp
> account,
> and by "putting them in a separate register" do you mean cut/paste each
> transaction?
> Then delete the temp and move the transactions to the new account?
>
> The replace is one of the features I really miss from Quicken.
>
> On 11/10/2021 3:37 PM, D. wrote:
> > If you're changing every ABC to DEF, you can delete ABC and tell
> > gnucash to move the transactions into DEF. That's documented in the wiki.
> >
> > If you're only deleting a bunch (but not all) there isn't one find and
> > replace command. When push comes to shove, though, even fixing 100
> > transactions will only take a few minutes' time.
> >
> > If it were me in this second scenario (and it has been, believe me!),
> > I'd search for the offending transactions, putting them all in a
> > separate register, copy the new account designation, and paste it into
> > each transaction at the appropriate point before pressing enter to
> > commit them away.
> >
> > David
> > 
> > *From:* Paul Kinzelman
> > *Sent:* Wed Nov 10 17:25:51 EST 2021
> > *To:* Gnucash Elist
> > *Subject:* [GNC] changing accounts?
> >
> > Is there some way to change all the entries for a set of
> > items in an account to be charged to one account to
> > charge them all to another account?
> >
> > For instance, if I have a monthly charge from XYZ that I charge
> > to account ABC, and I have a bunch of them in my Checking
> > account, is there a way to change all of them to DEF without
> > going in and poking each one? And that's where a simple
> > account name change ABC->DEF won't work because there's
> > other stuff in there.
> >
> > In other words, like a global replace?
> >
> > TIA!
> >
> >
> > 
> >
> > 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 seehttps://
> 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.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Account Name Matching

[D. via gnucash-user]

Dale, 

I wonder if this is somehow related to 
https://bugs.gnucash.org/show_bug.cgi?id=798162

That bug was resolved in 4.6, but your problem sounds suspiciously similar...

David T.


 Original Message 
From: Dale Alspach 
Sent: Fri Nov 12 17:23:34 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: [GNC] Account Name Matching

I have encountered what appears to be buggy behavior when entering the
Transfer account for a transaction. If I make a typing error so that no
existing account matches, the Transfer cell does not allow editing, i.e.,
backspace doesn't work, arrows don't work, the cursor position can be
changed with the mouse but delete doesn't work. If I can get the "Do you
want to create this account?" popup to appear (answer No), I can sometimes
get something sensible to happen and then fix the name.
This is on linux mint 20 with the 4.8 flatpak.
Has anyone else seen this?
Dale
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
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] import csv transactions

[D via gnucash-user]

If that's exactly your file format, it's not csv. Setting that aside, you'd 
need to import from within the bank account register, and then designate an 
account in gnucash to match up with TRANSPORT.

On Nov 13, 2021, 14:06, at 14:06, Chris Matchett  wrote:
>Hi,
>
>I am experimenting with gnucash. I am trying to import a csv file of my
>business bank statement. Starling bank in the UK.
>
>I assume the date and description fields are good below for the
>mandatory
>requirements? I am not sure how to match deposit and/or withdrawal and
>which account to use?
>
>*(Date)* Date - 21/01/2020
>Counter Party - Citybus Ticket Kiosk
>*(Description)* Reference - CITYBUS TICKET KIOSK
>Type - CONTACTLESS
>Amount (GBP) - -15.5
>Balance (GBP) - 480.1
>Spending Category - TRANSPORT
>Notes -
>
>Many thanks,
>
>Chris
>
>-- 
>https://freeperiod.co.uk
>___
>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] Data load from CSV files - duplicates

[D. via gnucash-user]

...Fifth, I think Leo is using the term "match" to refer to the process of 
*assigning* the second split to an account. ISTR that there is a step in the 
process where the user can actually match imported transactions to existing 
ones, along with the option to use the existing description or replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile. 

David T.


 Original Message 
From: David Carlson 
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] Data load from CSV files - duplicates

There are a number of things that may be impacting your results.

First, check Edit > Preferences > Online Banking to be sure that options
under Generic Importer are still checked and the values listed are
reasonable.

Second, the entire chapter 16 of the Help manual has details that come into
play.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher
>

Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

> Greetings from Cairns Qld Australia,
>
> I have my new accounts hierarchy data saved in a new file in the SQLite
> format.
>
> I have read the concepts guide & help docs.
>
> I have searched with our favourite search engine around the issue of
> imports from CSV etc files, and matching, and how to sort out duplicates
>
> I am somewhat aghast at the outcomes mentioned - deleting duplicates
> and/or doing reversals.
>
> I am therefore going to be more verbose than the mail list items
> questioners I found, to set out my frustration.
> ---
>
> I created a new file to do this test. I completely deleted all
> transactions from a previous file, the account balances all read zero, and
> saved this as my new test file.
>
> In my accounts, I have an assets, savings acct.   I have a csv file of
> savings account transactions export from my bank.
>
> In my accounts, I have a liabilities, credit card acct.   I have a csv
> file of credit card transactions export from my bank.
>
> These are my first 2 imports.
>
> I imported the credit card transactions first, from CSV.
>
> In the matching stage, for payments into the credit card from the savings,
> GnuCash did not offer any matches
> I set the match to be the savings account.
> Loaded, no errors, -
>
> And it created transactions in the savings account (presumably the second
> split of the credit card account transactions)
> ---
>
> I then imported the savings account transactions from CSV.
>
> In the matching stage, for payments from the savings into the credit card,
> GnuCash did not offer any matches
> I set the match to be the credit card account.
> Loaded, no errors, -
>
> And it created transactions in the credit card account (presumably the
> second split of the savings account transactions)
>
> NOW, - I have 2 versions of each of these transactions, - which are in
> fact the same transaction, - in each of the savings, and, the credit card
> accounts!! completely fouling up balances.
> ---
>
> Have I done something wrong?
>
> I don't want to be manually trying to delete some transaction splits, or
> trying to delete or reverse some transactions -
>   .  it would be just another manual tedious process
>   .  I would likely do it wrong and break the transaction(s) completely.
> ---
>
> If I don't provide manual matching, the transactions all end up listed in
> the Imbalance acct.
> ---
>
> If I were to import the credit card transactions - without providing
> manual matching -
>
>  When I then import the savings account transactions -
>
> How to I tell it that -
> This transaction - x - being loaded into this savings account should be
> matched to that existing transaction - y - in that credit card account
> AND - remove that transaction - y - from the Imbalance acct
>
> I find it quite frustrating that it appears that I have to match during
> both imports, and then do more manual jiggery pokery to sort out the
> duplicates!
>
> There has to be a better way.
> ---
>
> I have not tried it - BUT -
> Could I import the credit card transactions, with no matching - second
> splits will be in Imbalance -
> THEN, when I do savings import, - is it possible to do the matching to the
> credit 

Re: [GNC] Data load from CSV files - duplicates

[D. via gnucash-user]

Leo, 

In case it helps clarify things, I'll note that in the second import, you're 
not trying to assign the split to an account-- you're trying to tell the 
importer that the transaction already exists in the file, and you want to match 
up the new transaction with the existing old one. That's what I was getting at 
with the terminology statement. 

I don't do much importing any more, but I thought there was a spot in the 
process where you were given the opportunity to match incoming transactions 
with ones that are already in the file. But maybe that isn't the case with csv?

David T.


 Original Message 
From: Leo Vaccaneo 
Sent: Mon Nov 22 20:46:16 EST 2021
To: "D." , David Carlson 
Cc: Gnucash Users 
Subject: Re: Re: [GNC] Data load from CSV files - duplicates

Thanks to David T and David Carlson -

to David T (and David Carlson) -
yes - I believe you have hit what I am looking for - so, trying to say it again 
in a hopefully helpful way -

being able to assign / match (the term in the CSV importer process) the second 
split of the transaction being loaded -

to an existing transaction in the 'destination' 'other side / end of the 
transaction' account -

instead of creating a replica of the trans being loaded - as the second split 
-in the 'destination' 'other side / end of the transaction' account
---

to David Carlson -

I will work my way through each of your suggestions, and give an update -

The GNU installer was downloaded yesterday.

The rest - I will need to work through.

Sounds like it will be well worth my while to try the QIF import if I can get 
that format export from my bank (have to check).

Thanks again to all

Leo Vaccaneo



From: D. 
Sent: Monday, 22 November 2021 9:47 PM
To: David Carlson 
Cc: Leo Vaccaneo ; Gnucash Users 

Subject: Re: [GNC] Data load from CSV files - duplicates

...Fifth, I think Leo is using the term "match" to refer to the process of 
*assigning* the second split to an account. ISTR that there is a step in the 
process where the user can actually match imported transactions to existing 
ones, along with the option to use the existing description or replace it, 
which would eliminate that occurrence of a second transaction. Or perhaps I'm 
just getting senile.

David T.

From: David Carlson
Sent: Mon Nov 22 05:21:16 EST 2021
To: Leo Vaccaneo
Cc: "gnucash-user@gnucash.org"
Subject: Re: [GNC] Data load from CSV files - duplicates


There are a number of things that may be impacting your results.

First, check Edit > Preferences > Online Banking to be sure that options
under Generic Importer are still checked and the values listed are
reasonable.

Second, the entire chapter 16 of the Help manual has details that come into
play.  Reread <
https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#trans-import-matcher


Third, there have been some issues with some parts of the CSV and Generic
importers that have been discussed here in the last several weeks.  The
exact release of your GnuCAsh program could make a difference.  Please tell
us which version and which OS you are using.

Fourth,  while the OFX/QFX and QIF importers have some issues as well, they
have the advantage of being more mature and their limitations are better
understood by users.  If your bank offers either of these types of exports,
try them.  The QIF seems to work well for initial imports, taken in fairly
small chunks, say a month's data at a time.

When you have distilled your results to more specific issues, users here
can give better advice to address your problems.

On Mon, Nov 22, 2021 at 3:20 AM Leo Vaccaneo  wrote:

 Greetings from Cairns Qld Australia,

 I have my new accounts hierarchy data saved in a new file in the SQLite
 format.

 I have read the concepts guide & help docs.

 I have searched with our favourite search engine around the issue of
 imports from CSV etc files, and matching, and how to sort out duplicates

 I am somewhat aghast at the outcomes mentioned - deleting duplicates
 and/or doing reversals.

 I am therefore going to be more verbose than the mail list items
 questioners I found, to set out my frustration.
 ---

 I created a new file to do this test. I completely deleted all
 transactions from a previous file, the account balances all read zero, and
 saved this as my new test file.

 In my accounts, I have an assets, savings acct.   I have a csv file of
 savings account transactions export from my bank.

 In my accounts, I have a liabilities, credit card acct.   I have a csv
 file of credit card transactions export from my bank.

 These are my first 2 imports.

 I imported the credit card transactions first, from CSV.

 In the matching stage, for payments into the credit card from the savings,
 GnuCash did not offer any matches
 I set the match to be the savings account.
 Loaded, no errors, -

 And it created transactions in the savings account (presumably the second
 split of

Re: [GNC] Accounts Payable payment entry is marked as an Invoice

[D. via gnucash-user]

Seems to me a bad design decision to allow a user to have UI access to change 
things one way, but not the other. It is also bad user design to allow users to 
change things in an account that will always break when the user changes 
anything, something that's been true for as long as I've used gnucash. 

It would be better to make the account a placeholder account by default, and 
rewrite the business logic to push the changes into the account despite the 
placeholder setting, but I imagine that's a lot of work, and the people who 
know how to do the work will explain why my ideas are no good. 

David




 Original Message 
From: Adrien Monteleone 
Sent: Mon Nov 22 20:44:46 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Accounts Payable payment entry is marked as an Invoice

I'm aware of the label meanings, but I didn't realize clicking them 
would change anything. Sounds like a bug.

I don't recall ever clicking on the "I/P" at any time however, but I 
think I get the picture now. (I never edit from AP/AR, always some other 
account or through the Edit Payment window)

So I can reasonably edit this directly? (not officially supported, I 
understand)

I'm using the SQLite backend.

I'm guessing the db scheme in the wiki can point me to the I/P flag? Or 
is there some additional 'immutable' flag I need to change instead/also?

Perhaps I should file a bug on the report code taking the user to the 
AR/AP account directly since that might be troublesome, as well as on 
the immutability issue being triggered without warning?

Regards,
Adrien

On 11/22/21 7:28 PM, Derek Atkins wrote:
> Adrien,
> The "I" means "Invoice" (which internally can mean Customer Invoice,
> Vendor Bill, etc).  It is in both AR and AP accounts, and it is labled "I"
> in there in either case.
> NORMALLY when you make a payment it gets a P.
> If you post and Invoice (or Bill/Credit Note/etc) it gets an I.
> 
> When it has an I, the transaction is immutable from the register --
> because you are supposed to edit it by unposting the Invoice/Bill/etc and
> then re-posting it.
> 
> HOWEVER, the I/P/? column can be "clicked on" by a user, which will
> transition it to the "next" type, and, if you do this *manually* and it
> transitions to an I --- it becomes immutable... and there is no way in the
> UI to undo that.
> 
> So Chris was basically saying "don't do that".
> 
> MOST likely this is the cause of your issue.  The only fix is to go into
> the data file and remove the flag from the transaction under the covers.
> There is no UI way to fix it, because you're not supposed to go into AR/AP
> accounts.
> 
> -derek
> 
> On Mon, November 22, 2021 8:05 pm, Adrien Monteleone wrote:
>> I'll add that I'm not totally dense, and it seems like you're offering a
>> fix, but either some important details are missing, or, we are
>> misunderstanding one another.
>>
>> Regards,
>> Adrien
>>
>> On 11/22/21 6:04 PM, Christopher Lam wrote:
>>> You must have opened the AR register, and clicked on the Transaction
>>> type
>>> "I" payment split. This stupidly changes it to "P".
>>> The official fix is to not click on the AP/AR register.
>>>
>>> On Tue, 23 Nov 2021, 5:45 am Adrien Monteleone, <
>>> adrien.montele...@lusfiber.net> wrote:
>>>
 I was entering annual property tax bills, and noticed for one from last
 year, that it has a notation on the Vendor Report of:

 "Please note some transactions were not processed
 1. Transaction has type invoice but no owner or lot"

 Viewing the AP register shows the payment entry, but marked with an "I"
 instead of a "P".

 Jumping to the Invoice shows it as PAID, and viewing lots shows both
 invoice and payment with a zero balance. (no balance really)

 Any ideas on what caused this and how to fix it?

 (using 4.7 on BigSur)
 --
 Regards,
 Adrien

___
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] Using Gnucash to access file over flaky network

[D. via gnucash-user]

Everyone in this thread should read 
https://wiki.gnucash.org/wiki/FAQ#SQL_Database

It explains many points regarding gnucash and its implementations of the 
database back end. It explains the dbms that are supported (postgresql is among 
them) as well as the limitations to the current implementation. 


 Original Message 
From: Jean-David Beyer via gnucash-user 
Sent: Thu Nov 25 07:23:05 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Using Gnucash to access file over flaky network



On 11/25/21 04:47, Geoff wrote:
> Hi Chris
> 
> In my opinion this is really an SQLite question, not a GnuCash question.
> 
> To quote the SQLite dev team:-
> "Rely upon it at your (and your customers') peril. See How To Corrupt 
> Your Database Files.
> 
> Choose the technology that is right for you and your customers. If your 
> data lives on a different machine from your application, then you should 
> consider a client/server database. SQLite is designed for situations 
> where the data and application coexist on the same machine. SQLite can 
> still be made to work in many remote database situations, but a 
> client/server solution will usually work better in that scenario."
> 
> https://www.sqlite.org/draft/useovernet.html
> 
> 
> Good luck!
> 
> Regards
> 
> Geoff

I do not  know if Gnucash can run with postgreSQL, but if it can, 
perhaps that would be a better relational dbms to use?

-- 
   .~.  Jean-David Beyer
   /V\  Shrewsbury, New Jersey
  /( )\ Red Hat Enterprise Linux
  ^^-^^ up 4 days, 22 hours, 58 minutes
___
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] Flatpak/Flatseal Gnucash fails to launch

[D. via gnucash-user]

Elmar,

This thread isn't hijacked, but your query regarding Nabble is embedded into 
this thread, which is why you drew Frank's scolding. 

Personally, I think you're perfectly entitled to bring this issue to the user 
list, and if I used flatpak, I'd try to help you, instead of suggesting you go 
the Google route. 

David T.


 Original Message 
From: Elmar 
Sent: Sat Nov 27 15:29:34 EST 2021
To: "Frank H. Ellenberger" 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Flatpak/Flatseal Gnucash fails to launch

I'm not sure how I "hijacked" the thread.  I thought I started a new one 
- apparently not.  Sorry.

I'm pretty sure that flatpak itself is the problem.  I just don't know 
how to diagnose it, or provide the right data so that it can be 
diagnosed by someone better than I.  I was hoping that since the 
inability to launch  gnucash is how I ran into this, that somone else 
would have had this problem and solved it.  I'll go the google route - 
searching the Mint forums didn't help.  And I guess the gnucash list is 
also not the place :)  I'll quit this thread here.

- Elmar

On 11/27/21 1:58 PM, Frank H. Ellenberger wrote:
> Hi Elmar,
>
> At first, yiu should not hijack other threads. For a new thread, do
> *not* respond to another mail, but create a new mail to the list.
>
> Am 25.11.21 um 18:42 schrieb Elmar:
>> Flatseal also reacts the same way, i.e. does not open, although if
>> flatpak is really isntalled it should at least show its window.
> If other apps behave similar, is is usually a problem with your flatpak
> installation. Try to google terms like "flatpak linux mint 20"
>
> Regards
> Frank

___
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] Budget Report Liability "Act" VS Liability Report "Delta"

[D. via gnucash-user]

Charles, 

I'm glad you've been able to track down the differences. 

It would seemingly be sensible for the different reports to use the same 
boundary definitions. Whether that can happen is another story. 

The budget reports as far as I know have not received any developer attention 
for some time. I believe Chris Lam has been the main person working on the 
reports; he may have more to say about the issue. 

David


 Original Message 
From: Charles Crossan 
Sent: Mon Nov 29 08:57:58 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Budget Report Liability "Act" VS Liability Report "Delta"

I believe I found the answer to this.

The Budget report (and the Transaction Report) are showing the "expected"
values for changes to liability account balances - how much debt I actually
paid off this month.

The Net Worth Report (and Liabilities Over Time Report) also show "arguably
correct" values for changes to liability account balances - How much debt I
added this month; ignoring any payments I made on the first day of the
month.

The discrepancy arises when transactions occur on the reporting boundary
days.  For instance, If I apply a $2,000 payment to a credit card on the
first of the month, and then spend $500 on that card throughout the month,
the Budget Report (and the Transaction Report) will show that a decrease of
that credit card account by $2,000; however, the Net Worth (and Liabilities
Over Time) report will show a Liability increase of $500.

It would seem that the Time-series reports use the balance of the accounts
at the "end of the day" for the reporting period boundaries(i.e. including
transactions from the beginning boundary day); whereas the
transaction-tracking reports use actual ingress and egress values from
transactions against the account during the reporting periods.

Is there a way to adjust the behavior of Time-Series reports so that they
choose the balance from before the first transaction of the reporting
period (and after the last transaction of the end of the reporting period)?

On Sun, Nov 28, 2021 at 8:47 PM Charles Crossan 
wrote:

> Hello!
>
> I've been using GNUCash (gratefully, and happily) for 10 years, and this
> is my first time reaching out to the mailing list.
>
> I recently noticed that the "Budget Report" for the current period shows a
> different "Act" value for "changes in Liabilities" than the
> manually-calculated liability delta from the "Net Worth Report" or the
> "Liability report" (using the same set of accounts) for the same one-month
> period.
>
> For instance, budget report "act" says "Liabilities Decreased by $1500",
> but the liabilities report says " Liabilities  increased by $3500"
>
> I feel like my comprehension of accounting is betraying me.  How is this
> possible?  Has anyone else seen something like this before?
>
> --
> Thanks,
>
>
> Charles Crossan
> @crossan007 
> 215-804-9851
> https://www.ccrossan.com
>
>

-- 
Thanks,


Charles Crossan
@crossan007 
215-804-9851
https://www.ccrossan.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
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] read-only accounts

[D. via gnucash-user]

Adrien, 

Placeholder account registers are displayed as greyed out. While it's not 
necessarily obvious upon first viewing, it becomes clearer when you try to add 
a transaction (and it prevents you).

I do agree with the OP that the way gnucash handles transactions in placeholder 
accounts is very confusing. I've raised this point in the past 
(https://lists.gnucash.org/pipermail/gnucash-devel/2017-February/040345.html).

Clearly, it's a complicated issue. 

David T.


 Original Message 
From: Adrien Monteleone 
Sent: Fri Dec 03 13:22:58 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] read-only accounts

Maybe the warning could be more helpful. (via a more accurate description)

If the issue involves affecting a placeholder account that shouldn't be 
edited, and *not* just the editing of a reconciled transaction, the 
warning should inform the user this is the case. (or maybe the register 
should show some special designation for placeholder accounts, so the 
user would catch this at a glance)

While the rules around the reconciled warning have been relaxed, there 
are times where editing them is acceptable, but without remembering 
which accounts were marked placeholders, this incomplete warning can 
result in 'unexpected' behavior.

Though I'll concede this particular case still at least prevents 
'inadvertent' editing since you have to dismiss the warning.

Regards,
Adrien

On 12/3/21 8:37 AM, Derek Atkins wrote:
> HI,
> 
> On Fri, December 3, 2021 9:17 am, Mattia Rizzolo wrote:
>> On Thu, Dec 02, 2021 at 08:33:51PM -0500, Derek Atkins wrote:
>>> Mark the account as a PlaceHolder account and it'll be read-only.
>>
>> Oh, that's a nice trick I didn't think of!  Thanks!
>>
>> Howver, it seems to me that it doesn't fully lock down the account.  If
>> I tried to change a split belonging to that account from "the other
>> side", it first nags me about changing a reconciled split, then it
>> errors out saying that "the account doesn't allow transactions" (because
>> it's read-only), but it then still proceeds to record the changes,
>> regardless of the warning.
>> Is that the expected behaviour?
> 
> Yes.
> 
> GnuCash told you "don't do that" but you did it anyways.
> 
> -derek
> 

___
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] Bitcoin is legal currency in El Salvador - why not

[D. via gnucash-user]

Furthermore, the topic has been discussed at great length numerous times in the 
past on these lists. Searching on Google with "bitcoin site:lists.gnucash.org" 
will turn up many of these discussions, dating back a decade or so.


 Original Message 
From: davidcousen...@gmail.com
Sent: Tue Dec 07 15:15:54 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Bitcoin is legal currency in El Salvador - why not

Kalpesh,

John's answer is pretty explicit. It is not, at least yet, a "true " currency
and as such does not obey the "rules" that financial regulation applies to true
currencies that allow their treatment as currencies. There needs to be a
regulated international system of financial exchange which does not yet exist
for bitcoin. At present it is regulated in only one or two countries not the
rest of the world. It is more appropriate to describe it as a stock or mutual
fund at this point in time.

David Cousens

On Tue, 2021-12-07 at 14:19 -0500, Kalpesh Patel wrote:
> Why not to set this up as a true currency in GNC, instead of Stock or Mutual
> Fund?
> 
>  
> 
> --
> 
>  
> 
> Message: 8
> 
> Date: Tue, 7 Dec 2021 12:42:21 +
> 
> From: Eric Coates   >
> 
> To: gnucash-user@gnucash.org  
> 
> Subject: Re: [GNC] Bitcoin is legal currency in El Salvador - why not
> 
> add BTC?
> 
> Message-ID: <6bc32ed3-ac6b-5924-1990-f852c6829...@talktalk.net
>  >
> 
> Content-Type: text/plain; charset=utf-8; format=flowed
> 
>  
> 
> Hi
> 
>  
> 
> To (slightly) misquote John Ralls
> 
> "Bitcoin is neither a major nor a minor currency. It's not a currency at
> all:...[it is]? a speculation vehicle, not a currency."
> 
> but as shares are also "speculation vehicles" a possibility arises.
> 
>  
> 
> Starting from Dustin Henning's comment, some trivial experimentation shows
> that it is possible to set up a Bitcoin account in GnuCash by classifying it
> as a Stock (although Mutual Fund may be more appropriate as, I understand,
> fractional parts of Bitcoin are possible) and setting up Bitcoin as a
> security. And (somewhat to my surprise) it is possible to get on-line quotes
> by specifying the Symbol/abbreviation as BTC-GBP and using Yahoo as JSON as
> the source in the Single source drop-down. 
> 
> (BTC -USD is also available, others may be - I haven't checked).
> 
>  
> 
> So (probably after some experimentation) Bitcoin can already be handled
> within GnuCash!
> 
>  
> 
> "They knew not how well they built"
> 
>  
> 
> Take care
> 
>  
> 
> Eric
> 
>  
> 
>  
> 
>  
> 
>  
> 
> ___
> 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.
___
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] Advanced Portfolio Template: Population of data with dividends

[D via gnucash-user]

Well, it seems that "Money In" is an ambiguous phrase. Perhaps there is a 
better term that this report could use instead? "Purchase Cost" comes to 
mind

On Dec 9, 2021, 06:39, at 06:39, Thomas  
wrote:
>Thanks for the clarification Richard!
>it seems like the dividends are added in another column that I did not
>look into as I always expected to see the dividends in the 'money in'
>column.
>
>Thanks to all of your feedback!
>
>On Wed, 8 Dec 2021 at 19:09, Richard Ullger  wrote:
>>
>> I recall the discussions that took place on the mailing list years
>ago
>> when fixing up the Advanced Portfolio Report.
>>
>> The 'Money In' column reflects only the actual cash You have used to
>> purchase the security. Dividend and interest income is included in
>the
>> 'Income' column only and not in the 'Money In' column.
>>
>> 'Basis' does include the cost of the security whether bought from
>your
>> own funds or from income.
>>
>>
>> On 08/12/2021 17:36, Thomas wrote:
>> > Thanks Tom and David for your quick replies!
>> >
>> > I actually found that info some time ago as well, but it seems not
>to
>> > do the trick (for me).
>> > In the security's account I have the buy transactions (which are
>taken
>> > into account by the advanced portfolio template) and also the
>dividend
>> > payments in a "neutral" transaction as part of the dividend payment
>> > transaction. That means that the dividend transaction has multiple
>> > accounts involved (translated, so terms might not be 100%
>accurate):
>> > - "Earnings:Dividends" containing the whole amount I get from the
>company
>> > - "Expenses:Taxes" the amount of taxes that was deducted from the
>above
>> > - "Assets:ClearingAccount" the amount that remained after the
>deduction of taxes
>> > - "Assets:Securities:CompanyXY" just added without any amount
>> >
>> > Is there something I am missing to make it work?
>> >
>> > Best,
>> > Thomas
>> >
>> > On Wed, 8 Dec 2021 at 16:45, David Carlson
> wrote:
>> >>
>> >> IIRC Tom's suggestion is the key to getting dividends correctly
>assigned in
>> >> the Advanced Portfolio Report.  I cannot find the documentation
>either, but
>> >> there is a lot of information in the Tutorial chapter on
>investments <
>> >> https://gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide>
>> >>
>> >> On Wed, Dec 8, 2021 at 9:36 AM Tom Teixeira
>
>> >> wrote:
>> >>
>> >>> On 12/8/21 10:09 AM, Thomas wrote:
>>  Dear User-List,
>> 
>>  I successfully populated the advanced portfolio template with
>most of
>>  the data by selecting of all the accounts of my securities.
>>  What I did not manage to get filled is the "money in" column, to
>also
>>  include received dividends in the calculations. I tried to add
>the
>>  accounts with the dividends, but that was not successful.
>>  My question essentially is, how to properly fill the "money in"
>column
>>  with dividends.
>> >>>
>> >>> I don't remember where it is in the manual, but add a split to
>the
>> >>> dividend transaction and include the asset account for the stock.
>You
>> >>> shouldn't have to enter any amount for the stock itself unless
>you are
>> >>> reinvesting some or all of the dividend.
>> >>>
>> >>>
>> >>> ___
>> >>> 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.
>> >>>
>> >>
>> >>
>> >> --
>> >> David Carlson
>> >> ___
>> >> gnucash-user mailing list
>> >> gnucash-user@gnucash.org
>> >> To update your subscription preferences or to unsubscribe:
>> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >> If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> >> -
>> >> Please remember to CC this list on all your replies.
>> >> You can do this by using Reply-To-List or Reply-All.
>> > ___
>> > 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 Nabbl

Re: [GNC] Changing colors and layout on 4.8

[D. via gnucash-user]

Much of the interface (such as tab height) can be controlled through css. The 
colors in the register may be special, however, and not as readily changed (but 
I could be wrong). Others have documented these settings on the lists and in 
the wiki. Searches in the list archives and on the wiki should help you. 


 Original Message 
From: AC 
Sent: Thu Dec 09 19:01:05 EST 2021
To: GnuCash users group 
Subject: [GNC] Changing colors and layout on 4.8

Ok, finally got upgraded to 4.8, so far so good.

A couple things I want to change if at all possible:

First is the color schemes, I'd like to change the ledger to dark grays 
and also change the overall UI to have a darker color if possible.

The other thing I was hoping to do is reduce the size of the tabs.  They 
seem to be using a touchscreen sizing (large areas of empty space to 
allow for finger tapping) and I'd like to shrink that down, especially 
the register tabs (I have them set to the left and they are quite tall).

Where would I go about making these changes if possible?
___
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] Changing colors and layout on 4.8

[D. via gnucash-user]

As far as I know, yes. 


 Original Message 
From: AC 
Sent: Thu Dec 09 20:14:47 EST 2021
To: "D." 
Cc: GnuCash users group 
Subject: Re: [GNC] Changing colors and layout on 4.8

I see information in the wiki on Gnucash 3.x because it changed to GTK3. 
  Is it safe to assume that Gnucash 4 is still using GTK3 so the 
instructions would be the same?

On 2021-12-09 17:08, D. wrote:
> Much of the interface (such as tab height) can be controlled through css. The 
> colors in the register may be special, however, and not as readily changed 
> (but I could be wrong). Others have documented these settings on the lists 
> and in the wiki. Searches in the list archives and on the wiki should help 
> you.
> 
> 
>  Original Message 
> From: AC 
> Sent: Thu Dec 09 19:01:05 EST 2021
> To: GnuCash users group 
> Subject: [GNC] Changing colors and layout on 4.8
> 
> Ok, finally got upgraded to 4.8, so far so good.
> 
> A couple things I want to change if at all possible:
> 
> First is the color schemes, I'd like to change the ledger to dark grays
> and also change the overall UI to have a darker color if possible.
> 
> The other thing I was hoping to do is reduce the size of the tabs.  They
> seem to be using a touchscreen sizing (large areas of empty space to
> allow for finger tapping) and I'd like to shrink that down, especially
> the register tabs (I have them set to the left and they are quite tall).
> 
> Where would I go about making these changes if possible?
> ___
> 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] Stock data export to Portfolio Performance

[D via gnucash-user]

The answer really is embedded in what format Portfolio Performance needs for 
its input. I didn't see anything leap out at me in their website about that in 
my brief scan. Most likely, you'd use a gnucash report to output data to a 
spreadsheet and import to PP from there. 

On Dec 10, 2021, 06:15, at 06:15, Thomas  
wrote:
>Hi Christopher,
>thanks for your reply!
>With "Portfolio Performance", I was referring to specific (external)
>tool with that name. I forgot to mention that explicitly.
>My hope was that I could record all the data and changes in GnuCash
>and just regularly export the required information about my current
>stock portfolio to have additional tooling and visualizations in
>"Portfolio Performance".
>
>The website of "Portfolio Performance":
>https://www.portfolio-performance.info/en/
>
>Best,
>Thomas
>
>On Fri, 10 Dec 2021 at 12:09, Christopher Lam
> wrote:
>>
>> Imnsho, portfolio "performance" is a popular term, and I'm not sure
>it has an official definition.
>>
>> There's an IFRS report in the experimental menu to analyse a single
>stock activity. It aims to calculate a mathematical average cost price
>of the stock. You can then compare it with the stock latest price to
>generate a performance metric.
>>
>>  (Not an accountant).
>>
>> On Fri, 10 Dec 2021, 6:53 pm Thomas,
> wrote:
>>>
>>> Hello everybody,
>>>
>>> in order to have a detailed and interactive overview of all my stock
>>> portfolio, I would like to export the data I have in gnucash (e.g.,
>>> when I bought how many stocks at what price) and import it into
>>> Portfolio Performance. It is a rather stock-focused tool, which is
>why
>>> I want to stick with gnucash, but would love to have some of the
>>> visualization and calculation tools of Portfolio Performance.
>>>
>>> Does anybody do this in any way already or could give a hint how
>that
>>> could be doable?
>>> If there are other (more compatible) tools of the type of Portfolio
>>> Performance that are freely available, I'd also be interested in
>>> hearing about how you do it with these tools.
>>>
>>> Thanks a lot in advance!
>>>
>>> Best,
>>> Thomas
>>> ___
>>> 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.
___
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] Changing colors and layout on 4.8

[D. via gnucash-user]

A while back, someone (named Adrien!) shared tips on formatting the tabs at 
https://lists.gnucash.org/pipermail/gnucash-user/2020-January/088583.html


 Original Message 
From: Adrien Monteleone 
Sent: Fri Dec 10 21:45:51 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Changing colors and layout on 4.8

Note too that there are some 'defined' register colors. The example CSS 
files linked from the wiki should at least illustrate these. (though I 
don't think there is much 'documentation' on them, their names should be 
self-explanatory)

I'll dig into my own CSS file to see if I adjusted that tab-height 
property. Or barring that, fire up the inspector myself. But you should 
be able to see a property that affects it.

Caveat: respect the Cascade! thus, if a child of the tab, say a 'tab 
label' has a 'font-size' specified in *any* independent measurement (not 
in reference or dependent on the tab dimensions itself) that child 
element will then 're-size' the tab if the tab is set to contain *all* 
of its content. (I'm not describing that precisely correct for all 
cases, but I think I'm conveying the right idea) This is a 'thing' in 
Web CSS, but for some elements of GTK CSS, it is baked in. That is, 
those elements always adjust to fit content of their children and you 
don't have an easy means to change their behavior via CSS.

So you can set a tab height to 1px, but if your child tab-label is 12px, 
(plus or not — margin/padding), then your resulting tab will be that 
much larger regardless of the 'official' tab-height property.

I suspect that is the problem.

First, find a nice font-size for the entire UI. Stick with it. (there is 
good reason for this)

Then adjust *padding* on the 'tab' or *margin and/or padding* on the 
'label' of the tab as needed.

That's what I've done so far, and it works well enough for me, though 
I'm not trying to shrink my tabs into near oblivion.

Regards,
Adrien

On 12/10/21 5:48 PM, AC wrote:
> The syntax is roughly the same which is fine but what I'm finding harder 
> is identifying the appropriate selectors based on the output of the 
> inspector is harder.
> 
> I've gotten most of everything I wanted fixed except for the height of 
> the register tabs. The inspector so far isn't showing me anything 
> helpful to tweak that would let me reduce their height.

___
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] Entering dividends of stock in another (new) company

[D. via gnucash-user]

A Google search of "spinoff site:gnucash.org" yields a number of results over 
the years which should lead you to some answers. 


 Original Message 
From: hnh.63...@gmail.com
Sent: Sat Dec 11 09:47:03 EST 2021
To: gnucash-user@gnucash.org
Subject: [GNC] Entering dividends of stock in another (new) company

In recent years, several companies have spun off stock into a new 
company.  Examples are HP (DXC and others) and Pfizer (Veritas). Now IBM 
has created Kyndryl.  I have combed the help files and wiki and can't 
figure out how to best enter this.  Any ideas?

TIA

Howard Neuwirth-Hirsch

___
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] A repository for user-contributed files

[D. via gnucash-user]

Dr. Kirkby,

I appreciate your enthusiasm for this idea. 

I honestly doubt you'll get many contributors. 

When I joined the Gnucash community back in 2006, one of the areas I'd hoped 
for improvement was in reporting, and I raised the issue in the lists. It was 
suggested to me at the time that the tools existed for users to contribute 
their own reports-- and that those reports might then get added to the project. 
I was directed to a guide for programming in Scheme and the Gnucash wiki pages 
for creating one's own custom reports. 

And that's where my dreams of contributing custom reports to gnucash died. 
Writing reports for gnucash in Scheme is hellaciously complicated (no offense, 
Derek!), and most of my energy now has been focused on how to manipulate the 
existing reports to do something close to my goals. 

Judging by the paucity of actual new reports (never mind fixes to existing 
ones, which languished for years and years until Christopher Lam came 
along)(thank you, Chris!!) in the Gnucash stable of reports over the years, I'd 
have to say my own experience is rather common. 

Far more useful, in my opinion, is for users to share their tricks for getting 
gnucash to do their bidding, for which pages on the wiki (such as 
https://wiki.gnucash.org/wiki/Using_GnuCash) were created to allow. 

Best, 
David T. 



 Original Message 
From: "Dr. David Kirkby" 
Sent: Mon Dec 13 16:52:27 EST 2021
To: Dustin Henning 
Cc: GNU Cash User 
Subject: Re: [GNC] A repository for user-contributed files

On Mon, 13 Dec 2021 at 20:36, Dustin Henning  wrote:

> I don't know if one exists already or not, but assuming no, one path
> forward might be GitHub (or a competing non-Microsoft git service that
> also has a decent web interface).  I am operating under the assumption
> that some such service is free or has a reasonable free tier.  This
> would allow for multiple maintainers and the ability for people to
> submit reports from their own repositories.  It would also allow for
> resuscitation via a fork if all active maintainers stopped contributing
> around the same time.  One big drawback would likely be that GitHub
> doesn't seem very user-friendly for users that aren't in it regularly.
>

I agree about the user interface to github. There's some alternatives to
github here.

https://itsfoss.com/github-alternatives/

I don't know how you square the circle of allowing multiple people to
upload files, but avoiding rootkits and the like.

If some open-source alternative could be found, it would probably be
possible to run the code on a free AWS instance. if a script was run to

a) Make files read only
b) Strip off the execute bit

it should prevent someone over-writing files, or trying to execute their
code.

Given the size of the files, it should be possible for multiple people to
make backups on a regular basis. So if the maintainer drops dead, no data
is lost.

Dave
___
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] Coloring the Action field

[D. via gnucash-user]

What I mean is that variations from paycheck to paycheck result in changes in 
the amount going into my checking account. When I adjust that amount, the 
transaction no longer balances, and gnucash puts the difference into 
Imbalance-USD. 


 Original Message 
From: Michael or Penny Novack 
Sent: Thu Dec 16 18:45:33 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Coloring the Action field

On 12/16/2021 5:58 PM, David T. via gnucash-user wrote:
> I use something like Michael's approach with paychecks, but my simple 
> workaround is that I enter the correct amount deposited to my checking 
> account (that *is* what I'm most interested in!), using a previous pay 
> transaction as the template. Inevitably, IT DOES NOT BALANCE, and I 
> end up with an entry in Imbalance-USD, which I monitor for zero balance.

   I am not sure what you mean by "inevitably it does not balance".

>
> My workaround with my mortgage is to download the transaction history 
> for the mortgage once a year (more frequently, if I'm feeling 
> twitchy), and then I reconcile the MORTGAGE principle account. If the 
> transactions there are "N", then I know I need to check them for 
> accuracy.

For a mortgage, you are likely to have to reconcile once a year in any 
case when the amount for the insurance/taxes escrow gets recalculated. 
Note that this monthly amount is NOT 1/12 of the insurance and taxes. It 
will be an amount such that the balance of the escrow account remains 
positive as these monthly payments go in and on the due dates, tax 
payments and insurance payments, etc, go out. That's why this amount the 
mortgage holder bills you each month jumps around so much when they 
recalculate it once a year. With that recalculation you get a statement 
showing what was paid when so you can add the transactions for RE Tax 
and Insurance.

Michael D Novack

PS: The escrow account should be an asset account in your books. Each 
month the escrow portion of you mortgage payment goes in,m and when you 
get the statement (for the escrow being held) you will be able to enter 
the actual RE tax and insurance transactions going 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.
___
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] How to remove oldest transactions

[D. via gnucash-user]

One might also read the wiki page on closing books at

https://wiki.gnucash.org/wiki/Closing_Books

(Splitting a file at some point in time is essentially closing the books at 
that point).


 Original Message 
From: Glenn Fowler 
Sent: Sat Dec 18 11:49:47 EST 2021
To: Marc Lacroix 
Cc: GnuCash users group 
Subject: Re: [GNC] How to remove oldest transactions

Please vote for that here:
https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1973589-select-several-items-at-once-in-any-list


On Sat, Dec 18, 2021 at 11:24 AM Marc Lacroix via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I am using gnucash for many years, and the database is becoming huge.
>
> Is it possible to remove the oldest transaction?
>
> How?
>
>
> ___
> 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.
___
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] How to remove oldest transactions

[D. via gnucash-user]

Thank you Michael for stepping in. You've summarized the process to which I was 
alluding.

I'll note that deleting old transactions using a keyboard shortcut is going to 
throw the balances off for every account that the deleted transactions touched, 
so you'll end up creating correcting balance transactions all over the place 
anyhow. 


 Original Message 
From: Michael or Penny Novack 
Sent: Sat Dec 18 15:03:37 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] How to remove oldest transactions

On 12/18/2021 1:40 PM, Gyle McCollam wrote:
> Yes, you can close the book and it will zero out income and expense accounts, 
> but it does not remove any transactions and it will not reduce the size of 
> the file.  In fact, since it creates entries in all the expense and income 
> accounts, the file will actually be larger.
>
>
BUT --- this in fact how to proceed.

Imagine we were still in the old days of pen and ink on paper (in bound 
books of lined journal and ledger paper). They would normally "close the 
books" and open a new set each year (or whenever the volumes became full)

You can do the same thing with gnucash. You close the books and produce 
a Balance Sheet report. It will only have the "standing" accounts. You 
now export the CoA and import that into a new set of books. No 
transactions in it yet. You now enter the opening transaction(s) using 
the data from that Balance Sheet. Yes, can do it in one transaction, but 
since entering a giant split is far easier if split on just one side 
(either the debit or the credit side) easier if you use two, one for 
assets and the other for liabilities. In other words, you credit 
"starting equity" with the amount of "total assets" and then split up 
the debits of all those assets and you debit "starting equity" with the 
amount of "total liabilities" and then split up the credits of all the 
liabilities.

At this point your new books have just TWO transactions.

Michael D Novack

PS: Of course you keep the file that was the closed books just prior to 
this. If you ever have to refer back to something you would tell gnucash 
to open that file instead of the current one. Use good sense naming the 
files to serve as a reminder. Thus you might have Books2020.gnucash, 
Books2021.gnucash, Books2022.gnucash, etc.

PPS: The PITA is if you end up having to re-examine some activity that 
spanned a YE. But how often is that likely to happen?


___
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] Job Expenses? Job Profit Reports?

[D. via gnucash-user]

Adrien, 

You've submitted quite a few responses today to threads that are several months 
old. Is this something on your side, or the list's? 

David


 Original Message 
From: Adrien Monteleone 
Sent: Tue Dec 28 19:16:36 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Job Expenses? Job Profit Reports?

The short answer is, "you can't." 'Jobs' aren't quite what the name 
implies. Rather, think 'Purchase Order'.

There are various use cases the 'Jobs' feature does not work for:

Multiple Customers (and even split with stock orders) for the same Job. 
Yeah, I know this sounds weird, but if a Job is really just a PO, it is 
not un-common to place a single PO with a Vendor that covers not only 
items for multiple customers, but also for stock inventory.

The Job assigned to a Vendor and the Job assigned to a Customer are 
*not* the same 'job' despite them both having the same 'job name'.

The intended use case is extremely limited.

There are several other threads about job/project/property reporting. 
Other than using outside software entirely, you have perhaps 4 options:

1. Create special expense/income accounts for each job/project/property 
and only include those in the relevant reports. The drawback is 
cluttering your CoA, especially if such special accounts aren't 
on-going. (easier for rental properties, less so for one-offs)

2. Use your own 'tags' in various fields to identify what 
job/project/property the expense/revenue applies to. Then use the 
Transaction Report, exporting to a spreadsheet if needed to make it 
pretty the way you want.

3. Modify the P&L/Income Statement to use the report Option to filter 
based on various fields like the Transaction Report can. (the included 
P&L doesn't have this option)

4. Craft your own entirely custom report that uses these 'tags'.

-
I say 'tags' because GnuCash doesn't have that as an established 
feature. You'd simply include text with an identifier like '@' '#' et 
cetera before the tag text and put that tag in one of the 'Description' 
'Notes' 'Memos' or 'Action' fields as you find useful.

Regards,
Adrien

On 9/21/21 1:26 AM, Christian Peritore wrote:
> Looking everywhere for this function but can't seem to find it.
> 
> How to connect a given Job to any Expense? Then how to Report a Job's net 
> profit (and connected total Expenses and total Income)?
> 
> Entering Expenses doesn't seem to offer a Job to spend against. I presume I 
> need to bring the Expense into an Invoice manually? Ok...
> 
> But then how to view the total of Expenses for a given Job, thus it's net 
> profit?

___
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] Job Expenses? Job Profit Reports?

[D. via gnucash-user]

Oh. OK. That's fine. I'm just easily confused.


 Original Message 
From: Adrien Monteleone 
Sent: Tue Dec 28 21:56:10 EST 2021
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Job Expenses? Job Profit Reports?

Me, sorry.

I took a break for some time, and decided to look over some threads that 
didn't get answers and see if I could help.

A few other threads looked interesting and where I thought I could add 
to the discussion, decided to chime in.

I happen to be all done now!

(There are a few unanswered threads I marked for 'investigation' so I 
might still reply later, but I have to test some problems/solutions first.)

Apologies to anyone if it looked like noise.

Regards,
Adrien

On 12/28/21 8:47 PM, D. via gnucash-user wrote:
> Adrien,
> 
> You've submitted quite a few responses today to threads that are several 
> months old. Is this something on your side, or the list's?
> 
> David

___
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] Advancing scheduled transactions

[D. via gnucash-user]

Roger, 

I still don't understand. 

If you set your scheduled transactions to be created 45 days in advance, then 
your January 1, 2022 transaction will be created in mid-November (with a date 
of 01-01-2022), and you can change its date directly in the register at any 
point after that. Why is that any more difficult than what you're asking for? 

David T.


 Original Message 
From: rmom...@gmail.com
Sent: Thu Dec 30 08:52:05 EST 2021
To: stephen.m.butle...@gmail.com
Cc: 'GnuCash' 
Subject: Re: [GNC] Advancing scheduled transactions

Thanks Steve,

 

Kind of what I suspected. All my scheduled transactions are set to post on the 
1st of the month regardless of the date posted. Not worth the trouble to do 
more than that for an occasional early payment. Yes, it would be a nice feature 
that isn't essential and probably not worth the developers' effort. Not sure 
where to submit an enhancement request.

 

Great program regardless, worth a lot more than it costs. Reminds me of 
Airforce MAC flights. There are three things you can say about a MAC flight if 
you get on one, 1. It's a free ride, 2. It's a free ride, and 3. It's a free 
ride. 😊

 

Happy new year,

Roger

 

-Original Message-
From: Stephen M. Butler  
Sent: Wednesday, December 29, 2021 7:00 PM
To: rmom...@gmail.com
Cc: GnuCash 
Subject: Re: [GNC] Advancing scheduled transactions

 

Roger,

 

That would be nice.  Need to enter an enhancement request to have that added 
during the copious amounts of free time the developers have!

 

But, to get around that limitation, I do use the "Create in Advance" so it is 
in the register early (but for the scheduled date).  That way I can just adjust 
the date on the transaction that is already waiting.

 

That's the only way now to move a scheduled transaction earlier. Now, if you 
want an extra one, duplicate it from the prior month.

 

--Steve

 

On 12/29/21 16:15,   rmom...@gmail.com wrote:

> 

> Steve,

> 

> Just want the option to trigger a post manually, not a permanent 

> change in the schedule. As you do, I set up my scheduled transactions 

> to post on the 1^st of the month regardless of the date of the 

> transaction. I usually wait till the first to pay and post my bills to 

> accommodate the scheduled transactions limitations. It would be like 

> skipping a scheduled transaction for one month only the opposite, 

> activating it early. Pick a scheduled transaction and tell the program 

> to go ahead and post it today, on the 30^th of month prior to the next 

> scheduled transaction date. Hope that explains what I’m looking for.

> 

> Thanks,

> 

> Roger

> 

> *From:* Steve Butler <  
> stephen.m.butle...@gmail.com>

> *Sent:* Wednesday, December 29, 2021 10:47 AM

> *To:*   rmom...@gmail.com

> *Subject:* Re: [GNC] Advancing scheduled transactions

> 

> Not sure what you are asking.  Do you want to permanently change the 

> date the transaction fires?

> 

> Or is this just a random change because it came early that month?

> 

> Note:  I generally have scheduled transactions automatically post

> 15-20 days early so I can see their effect in the registers of 

> interest.  If I note that the transaction posted on a date different, 

> it is easy to change the date in that register.

> 

> I haven't tried editing the general/overview panel on a scheduled 

> transaction to see if the scheduled date could be permanently changed.

> 

> On Wed, Dec 29, 2021, 08:24 <  rmom...@gmail.com> 
> wrote:

> 

> Is there a way to advance a specific scheduled transaction in

> Version: 4.6

> Build ID: 4.6+(2021-06-26). Be nice to have an option of advancing a

> scheduled transaction for example when I get paid before the end

> of the

> month. I don't see a way to do that. Hasn't been one as far as I

> know in

> previous versions. Just be a handy feature.

> 

> 

> 

> Happy New Year,

> 

> Roger

> 

 

 

--

Stephen M Butler, PMP, PSM

  stephen.m.butle...@gmail.com

  kg...@arrl.net

253-350-0166

---

GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

 

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

Re: [GNC] A repository for user-contributed files

[D. via gnucash-user]

For what it's worth, I went to the wiki page that another David (how many of us 
subscribe to this list!?!?) referenced. At the top of that page are links for 
outside projects on Sourceforge.net and Git. The first takes you to a list of 
40 projects; the second to a listing of 578. I'm not evaluating what those 
projects are or claim to do, but it seems to me that there are potentially a 
lot of resources already shared in those places. 


 Original Message 
From: Robin Lake 
Sent: Fri Dec 31 15:33:36 EST 2021
To: gnucash-user@gnucash.org
Subject: Re: [GNC] A repository for user-contributed files

Dave --

Thank you for making the storage area available. I hope it gets usage.

~ Robin

On 12/31/2021 3:14 AM, Dr. David Kirkby wrote:
> On Thu, 30 Dec 2021 at 05:59, Adrien Monteleone <
> adrien.montele...@lusfiber.net> wrote:
>
>> Thanks for the link, and I'll take a look, but I am curious...
>>
>> Why not just post that info on the Wiki in that place?
>>
>> What happens if your company site goes down/dark?
>>
>> Do the various tips not still apply to GnuCash which has no relation to
>> your company?
>>
>> Are you opposed to sharing your tips and tricks with the broader GnuCash
>> community?
>>
>> Do you mind if they are posted on the GnuCash wiki directly?
>>
>> Regards,
>> Adrien
>
> I think if you take a look, you will realise that the intension was to
> share them, requesting others to take backups, in case I die and the
> website goes down. So I was obviously not expecting them to be specific to
> my company, the fact I was requesting others to take backups.
>
> Sending an email to this list, adding an entry to the Wiki were all
> mentioned.
>
> When I asked about a repository, I was told one didn’t exist. Someone
> suggested GIT, someone else mentioned the ownership of git.
>
> I was just offering some storage area if it was wanted.
>
> Dave
>
>

-- 
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
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] A repository for user-contributed files

[D. via gnucash-user]

I am not resentful; I was pointing out that there may be resources already 
available to users. 

As I said, I didn't review the results, so I can't comment on the projects on 
sourceforge. And while Microsoft may now own github, it started out as an 
independent outfit that was purchased by Microsoft in 2018. I don't know 
whether the FUD of Microsoft ownership has actually been borne out in 
experience. 


 Original Message 
From: "Dr. David Kirkby" 
Sent: Sat Jan 01 15:50:22 EST 2022
To: "D." 
Cc: Robin Lake , kb1912 via gnucash-user 

Subject: Re: [GNC] A repository for user-contributed files

On Sat, 1 Jan 2022 at 16:17, D. via gnucash-user 
wrote:

> For what it's worth, I went to the wiki page that another David (how many
> of us subscribe to this list!?!?) referenced. At the top of that page are
> links for outside projects on Sourceforge.net and Git. The first takes you
> to a list of 40 projects; the second to a listing of 578. I'm not
> evaluating what those projects are or claim to do, but it seems to me that
> there are potentially a lot of resources already shared in those places.


I have not checked the github  ones, but if you follow the links on
Sourceforge, you will find a very large fraction are links to commercial
accounting software. Today I was looking on there for software to model
heat transfer. 90% of that was either links to accounting software, or
links to commercial software related to what I wanted.


I am the author of several projects on Sourceforge

Transmission line calculator
http://atlc.sourceforge.net/

Chess database
https://sourceforge.net/projects/chessdb/

Noise figure meter
https://sourceforge.net/projects/hp8970/

Antenna analyzer
https://sourceforge.net/projects/yagiuda/

but I would never put anything else on there.  Source gorge seems little
more than an ad-machine now. Here’s a  few screenshots when I try finding
my own software on there.

Someone mentioned that the user interface to github was not very friendly,
and the fact it owned by Microsoft.

My intension when setting up the space was to try to be helpful.  Although
one person emailed me to say thank you for setting up some file space, I
sense a bit of resentment by others. If the offer is thought not to be
useful, I can easily delete the subdomain.

Dave



-- 
Dr. David Kirkby,
Kirkby Microwave Ltd,
drkir...@kirkbymicrowave.co.uk
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892.
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United
Kingdom
___
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] A repository for user-contributed files

[D via gnucash-user]

Actually, Getting Help links there. As do a couple of other random pages. 

On Jan 2, 2022, 17:50, at 17:50, David Carlson  
wrote:
>No page links to that page.  I wonder how I found it myself.
>https://wiki.gnucash.org/wiki/Published_tools
>
>On Sun, Jan 2, 2022 at 4:33 PM brad  wrote:
>
>> Is that page linked to on another wiki page?  Perhaps it doesn't get
>> attention because no one knows it is there
>>
>> On 12/31/21 08:19, David Carlson wrote:
>> > There is a page in the GnuCash WIKI for user "Tool" submissions. 
>It does
>> > not get as much attention as it deserves.  It is located here: <
>> > https://wiki.gnucash.org/wiki/Published_tools>
>> >
>> > On Fri, Dec 31, 2021 at 5:16 AM Dr. David Kirkby <
>> > drkir...@kirkbymicrowave.co.uk> wrote:
>> >
>> >> On Thu, 30 Dec 2021 at 05:59, Adrien Monteleone <
>> >> adrien.montele...@lusfiber.net> wrote:
>> >>
>> >>> Thanks for the link, and I'll take a look, but I am curious...
>> >>>
>> >>> Why not just post that info on the Wiki in that place?
>> >>>
>> >>> What happens if your company site goes down/dark?
>> >>>
>> >>> Do the various tips not still apply to GnuCash which has no
>relation to
>> >>> your company?
>> >>>
>> >>> Are you opposed to sharing your tips and tricks with the broader
>> GnuCash
>> >>> community?
>> >>>
>> >>> Do you mind if they are posted on the GnuCash wiki directly?
>> >>>
>> >>> Regards,
>> >>> Adrien
>> >>
>> >> I think if you take a look, you will realise that the intension
>was to
>> >> share them, requesting others to take backups, in case I die and
>the
>> >> website goes down. So I was obviously not expecting them to be
>specific
>> to
>> >> my company, the fact I was requesting others to take backups.
>> >>
>> >> Sending an email to this list, adding an entry to the Wiki were
>all
>> >> mentioned.
>> >>
>> >> When I asked about a repository, I was told one didn’t exist.
>Someone
>> >> suggested GIT, someone else mentioned the ownership of git.
>> >>
>> >> I was just offering some storage area if it was wanted.
>> >>
>> >> Dave
>> >>
>> >>
>> >> --
>> >> Dr. David Kirkby,
>> >> Kirkby Microwave Ltd,
>> >> drkir...@kirkbymicrowave.co.uk
>> >> https://www.kirkbymicrowave.co.uk/
>> >> Telephone 01621-680100./ +44 1621 680100
>> >>
>> >> Registered in England & Wales, company number 08914892.
>> >> Registered office:
>> >> Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3
>6DT,
>> United
>> >> Kingdom
>> >> ___
>> >> 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.
>>
>
>
>-- 
>David Carlson
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
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] A repository for user-contributed files

[D. via gnucash-user]

Yes. That's where I got the information in the first place. I named the only 
one that 
I thought a user might see if they were trying to find such information.

I don't see how users would even know about the categories feature on our wiki. 


 Original Message 
From: "Frank H. Ellenberger" 
Sent: Mon Jan 03 02:58:04 EST 2022
To: David Carlson 
Cc: D , kb1912 via gnucash-user 
Subject: Re: [GNC] A repository for user-contributed files

Hi,

Am 03.01.22 um 01:55 schrieb D via gnucash-user:
> Actually, Getting Help links there. As do a couple of other random pages. 
> 
the full list:
https://wiki.gnucash.org/wiki/Special:WhatLinksHere/Published_tools

It is also in the categories Usage & Tools.

Regards
Frank

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

Re: [GNC] GNUCash 4.9

[D. via gnucash-user]

Actually, every time you save, Gnucash makes a timestamped backup file. So 
Steve is deleting each of his backups. 


 Original Message 
From: Peter West 
Sent: Mon Jan 03 19:58:06 EST 2022
To: Steve Mortimer 
Cc: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] GNUCash 4.9

Use File > Save as… to close GnuCash, and specify the location and file name 
(without the date.) That then becomes the file that you always open. The files 
with dates are the backups. If you take the earlier advice, you will set the 
number of backup files to keep in Preferences > General – Retain backup files.


—
Peter West
p...@ehealth.id.au
“Behold, this child is appointed for the fall and rising of many in Israel, and 
for a sign that is opposed (and a sword will pierce through your own soul 
also), so that thoughts from many hearts may be revealed.”

> On 4 Jan 2022, at 10:27 am, Steve Mortimer  wrote:
> 
> Adrien,
> 
> Here is what I have found out.  Each time the program is closed it adds that 
> date and time to the name of the file.  How can this be stopped?
> 
> I can change the name of the file so that there is only one date for the file 
> name and bring it up with all of the transactions in the file.  I close the 
> program and the file now has two dates showing on it.
> 
> Guess there is no original file on the computer.
> Steve
> 
>> Steve Mortimer 
>> Monday, January 3, 2022 5:40 PM
>> Thanks.  Looking into this.
>> Steve
>> 
>> 
>> Adrien Monteleone 
>> Monday, January 3, 2022 4:12 PM
>> Steve,
>> 
>> I'll add that it appears you are opening backup files, not the main GnuCash 
>> file. The very long file names indicate this. So it seems you have backups 
>> of backups. If you find the main file, it might not have all the same 
>> transactions as whatever you are currently working in.
>> 
>> Regards,
>> Adrien
>> 
>> 
>> 
>> ___
>> 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.
>> 
> 
> -- 
> Steve Mortimer
> 
> 2 Timothy 3:16-17 (ESV)
> All Scripture is breathed out by God and profitable for teaching, for 
> reproof, for correction, and for training in righteousness that the man of 
> God may be complete, equipped for every good work
> ___
> 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.
___
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] Trial Balance Report Settings

[D. via gnucash-user]

I think the OP is looking to save the settings from one iteration to the next, 
which I'd achieve by saving the settings as "My Trial Balance" and then calling 
that report whenever I needed it. 


 Original Message 
From: Jesse MacDougall 
Sent: Tue Jan 04 20:19:08 EST 2022
To: Benjamin Soffer 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Trial Balance Report Settings

Yes i saw a setting for this somewhere dont recall exactly

On Tue., Jan. 4, 2022, 16:41 Benjamin Soffer, 
wrote:

> Hello,
>
> Is it possible to configure the trial balance report so that hidden
> accounts or zero-balance accounts would be excluded from the report?
>
> Ben Soffer
> ___
> 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.
___
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] Transaction Date issues during import OFX file (TD Bank)

[D. via gnucash-user]

I'd be annoyed at the shift.

I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to have 
0200 as their time; subtracting 5 hours from that would return -3 o'clock (and 
presumably shift the date back one).


 Original Message 
From: David Carlson 
Sent: Tue Jan 11 12:53:59 EST 2022
To: "xraive ." 
Cc: Gnucash Users 
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Your bank creates the Ofx file.   Gnucash just accepts what they give you.
Sometimes it may appear to be incorrect when it is a misunderstanding about
whether transactions are posted on the same day they occur.

Does it really make a difference?




On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:

> I downloaded transactions from my bank (TD) in Canada and when I tried
> importing the file into GNUCASH all the dates were set to one day earlier
> then the actual transactions.  I'm including sample transactions below.
>
> OFX file imported to GNUCASH
>
> 
> DEBIT
> 2021072202[-5:EST]
> -14.64
> 21203175847980020
> Best Buy
> 
> 
> CREDIT
> 2021072602[-5:EST]
> 21.83
> 2120719980010
> Home Depot
> 
>
> Any help would be greatly appreciated.  If you need additional information
> please let me know.
>
> Thanks
> ___
> 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.
___
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] Transaction Date issues during import OFX file (TD Bank)

[D. via gnucash-user]

But EFT transactions (which are the bulk of my txns these days) shouldn't get 
shifted around much at all. I'd be miffed if every EFT entry were a day off. 


 Original Message 
From: Gyle McCollam 
Sent: Tue Jan 11 13:33:51 EST 2022
To: "D." 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I find my dates usualy do not agree with the bank dates.  I record credit card 
bills when I pay them (electronically) and they are recorded by the payee on 
the same date.  However, they usually hit my bank the next banking day.  This 
isn't and shouldn't be a problem or concern.  Actual physical checks take even 
longer to show up at the bank.  This is all normal.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email

________
From: gnucash-user  on 
behalf of D. via gnucash-user 
Sent: Tuesday, January 11, 2022 1:20 PM
To: David Carlson 
Cc: GnuCash 
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

I'd be annoyed at the shift.

I wonder what happens if the "[-5:EST]" gets removed.  The dates seem to have 
0200 as their time; subtracting 5 hours from that would return -3 o'clock (and 
presumably shift the date back one).


 Original Message 
From: David Carlson 
Sent: Tue Jan 11 12:53:59 EST 2022
To: "xraive ." 
Cc: Gnucash Users 
Subject: Re: [GNC] Transaction Date issues during import OFX file (TD Bank)

Your bank creates the Ofx file.   Gnucash just accepts what they give you.
Sometimes it may appear to be incorrect when it is a misunderstanding about
whether transactions are posted on the same day they occur.

Does it really make a difference?




On Tue, Jan 11, 2022, 10:12 AM xraive .  wrote:

> I downloaded transactions from my bank (TD) in Canada and when I tried
> importing the file into GNUCASH all the dates were set to one day earlier
> then the actual transactions.  I'm including sample transactions below.
>
> OFX file imported to GNUCASH
>
> 
> DEBIT
> 2021072202[-5:EST]
> -14.64
> 21203175847980020
> Best Buy
> 
> 
> CREDIT
> 2021072602[-5:EST]
> 21.83
> 2120719980010
> Home Depot
> 
>
> Any help would be greatly appreciated.  If you need additional information
> please let me know.
>
> Thanks
> ___
> 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.
___
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] access to Gnucash Nabble

[D. via gnucash-user]

So, 

My gtk-3.0.css is in 

C:\Users\{USERNAME}\AppData\Roaming\GnuCash

And the designator that changes fonts looks like this:

* {
   font-size: 16px;
   font-family: "Arial", sans-serif;
}

You'd be better off following that, rather than copying from another app.

David T.


 Original Message 
From: David JamesTK 
Sent: Sat Jan 15 20:12:23 EST 2022
To: David H 
Cc: GnuCash users group 
Subject: Re: [GNC] access to Gnucash Nabble

Copied the config file containing this

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Into empty file location C:\Users\david\AppData\Local\gtk-3.

No change, this happened with Thunderbird too, option there was edit css file 
something mentioned on wiki also.

Cheers


From: David H 
Sent: 16 January 2022 00:50
To: David JamesTK 
Cc: Glenn Fowler ; GnuCash users group 

Subject: Re: [GNC] access to Gnucash Nabble


It’s my understanding the file is optional so won’t appear in all locations? 
Have you tried copying your file into the app data location which is currently 
empty by the look of things?

Cheers David H.

On Sun, 16 Jan 2022 at 10:35 am, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Cheers David, tried the local folder first but appears empty (hide system files 
option off)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

Searching C drive for gtk-3.0 returns four entries below with my comments in 
blue;

C:\Program Files (x86)\gnucash\etc\gtk-3.0  (currently in this folder)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

C:\Program Files (x86)\gnucash\share\themes\Default\gtk-3.0 (contains css file 
gtk-keys)

C:\Program Files (x86)\gnucash\share\themes\Emacs\gtk-3.0  (contains css file 
gtk-keys)


From: David H mailto:hell...@gmail.com>>
Sent: 16 January 2022 00:09
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: Glenn Fowler mailto:gfowl...@outlook.com>>; GnuCash 
users group mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Probably not, depends what you set GNC_DATA_HOME to I guess  - check that wiki 
again - https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME

Cheers David H.
GTK_DATA_HOME

Versions: 3.x and more recent only

GnuCash uses GTK for its graphical user interface; thus, locations that are 
used by GTK are also relevant. Note the base directories on Windows and macOS 
for this differ from the base directories for 
GNC_DATA_HOME.

Linux
USER_DATA_HOME/gtk-3.0
Windows
%LOCALAPPDATA%\gtk-3.0
macOS
HOME/.local/share/gtk-3.0


On Sun, 16 Jan 2022 at 09:56, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Thanks Glen.

Currently in this folder C:\Program Files (x86)\gnucash\etc\gtk-3.0  on Windows 
10 Pro
editing this file settings.ini

Before

[Settings]
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

After

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Is this the right folder location and entry (18 font not needed, just making it 
super obvious for any changes)

Thanks, David



From: Glenn Fowler mailto:gfowl...@outlook.com>>
Sent: 15 January 2022 23:47
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: GnuCash users group 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Hi,

You can use any text editor


On Sat, Jan 15, 2022, 6:20 PM David JamesTK 
mailto:davidjame...@hotmail.co.uk>>>
 wrote:
Hello all,

No idea if this will reach anyone but wanted to ask a question please.

Just switched back to using Windows (long story) but noticed the font is 
smaller than on Mint using the same screen.

Followed most of the GTK 3.0 instructions on Wiki including editing 
settings.ini file as per their help file, unfortunately no change at all.

Do I need to run GTK inspector to edit or can this be done in notepad (as I 
have done?)

Thanks,

David


___
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] access to Gnucash Nabble

[D. via gnucash-user]

BTW, what does any of this have to do with Nabble? 


 Original Message 
From: "D. via gnucash-user" 
Sent: Sat Jan 15 21:55:10 EST 2022
To: David JamesTK 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] access to Gnucash Nabble

So, 

My gtk-3.0.css is in 

C:\Users\{USERNAME}\AppData\Roaming\GnuCash

And the designator that changes fonts looks like this:

* {
   font-size: 16px;
   font-family: "Arial", sans-serif;
}

You'd be better off following that, rather than copying from another app.

David T.


 Original Message 
From: David JamesTK 
Sent: Sat Jan 15 20:12:23 EST 2022
To: David H 
Cc: GnuCash users group 
Subject: Re: [GNC] access to Gnucash Nabble

Copied the config file containing this

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Into empty file location C:\Users\david\AppData\Local\gtk-3.

No change, this happened with Thunderbird too, option there was edit css file 
something mentioned on wiki also.

Cheers


From: David H 
Sent: 16 January 2022 00:50
To: David JamesTK 
Cc: Glenn Fowler ; GnuCash users group 

Subject: Re: [GNC] access to Gnucash Nabble


It’s my understanding the file is optional so won’t appear in all locations? 
Have you tried copying your file into the app data location which is currently 
empty by the look of things?

Cheers David H.

On Sun, 16 Jan 2022 at 10:35 am, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Cheers David, tried the local folder first but appears empty (hide system files 
option off)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

Searching C drive for gtk-3.0 returns four entries below with my comments in 
blue;

C:\Program Files (x86)\gnucash\etc\gtk-3.0  (currently in this folder)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

C:\Program Files (x86)\gnucash\share\themes\Default\gtk-3.0 (contains css file 
gtk-keys)

C:\Program Files (x86)\gnucash\share\themes\Emacs\gtk-3.0  (contains css file 
gtk-keys)


From: David H mailto:hell...@gmail.com>>
Sent: 16 January 2022 00:09
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: Glenn Fowler mailto:gfowl...@outlook.com>>; GnuCash 
users group mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Probably not, depends what you set GNC_DATA_HOME to I guess  - check that wiki 
again - https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME

Cheers David H.
GTK_DATA_HOME

Versions: 3.x and more recent only

GnuCash uses GTK for its graphical user interface; thus, locations that are 
used by GTK are also relevant. Note the base directories on Windows and macOS 
for this differ from the base directories for 
GNC_DATA_HOME<https://wiki.gnucash.org/wiki/Configuration_Locations#GNC_DATA_HOME>.

Linux
USER_DATA_HOME<https://wiki.gnucash.org/wiki/Configuration_Locations#USER_DATA_HOME>/gtk-3.0
Windows
%LOCALAPPDATA%<https://wiki.gnucash.org/wiki/Configuration_Locations#Environment_variables_LOCALAPPDATA_and_APPDATA>\gtk-3.0
macOS
HOME<https://wiki.gnucash.org/wiki/Configuration_Locations#HOME>/.local/share/gtk-3.0


On Sun, 16 Jan 2022 at 09:56, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Thanks Glen.

Currently in this folder C:\Program Files (x86)\gnucash\etc\gtk-3.0  on Windows 
10 Pro
editing this file settings.ini

Before

[Settings]
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

After

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Is this the right folder location and entry (18 font not needed, just making it 
super obvious for any changes)

Thanks, David



From: Glenn Fowler mailto:gfowl...@outlook.com>>
Sent: 15 January 2022 23:47
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: GnuCash users group 
mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Hi,

You can use any text editor


On Sat, Jan 15, 2022, 6:20 PM David JamesTK 
mailto:davidjame...@hotmail.co.uk><mailto:davidjame...@hotmail.co.uk<mailto:davidjame...@hotmail.co.uk>>>
 wrote:
Hello all,

No idea if this will reach anyone but wanted to ask a question please.

Just switched back to using Windows (long story) but noticed the font is 
smaller than on Mint using the same screen.

Followed most of the GTK 3.0 instructions on Wiki including editing 
settings.ini file as per their help file, unfortunately no change at all.

Do I need to run GTK inspector to edit or can this be done in notepad (as I 
have done?)

Thanks,

David


___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org<mailto:gnucash-

Re: [GNC] access to Gnucash Nabble

[D. via gnucash-user]

On Windows, I'm not sure there are many other gtk apps installed-- or whether a 
generic settings manager would work. I know the specific commands I cited work; 
I used them on my own machine before posting. 


 Original Message 
From: David H 
Sent: Sat Jan 15 23:05:20 EST 2022
To: "D." 
Cc: David JamesTK , Gnucash Users 

Subject: Re: [GNC] access to Gnucash Nabble

It seems from https://wiki.gnucash.org/wiki/GTK3 that you can use
settings.ini for ALL GTK apps installed or the gtk-3.0.css to affectGnuCash
only...  Settings.ini seems to use the gtk-font-= format.

Cheers David H.

Typefaces

There are two ways of setting a default font and size for GnuCash.
The first sets an option in GTK's settings.ini for *all GTK applications* (GIMP
etc.),the other uses css to accomplish the same for *GnuCash only*.

   - If neither you nor a program changed the default values before, the
   files mentioned in this section will *not exist*. In this case just
   create them as *pure text files* and with normal file access rights.

The examples below with both set the *default font* to Arial and *font size* to
14.
Via settings.ini

Create if necessary and add the following line to GTK_CONFIG_HOME

/settings.ini:

[Settings]gtk-font-name=Arial 14

General notes

   - In settings.ini, lines beginning with a # and blank lines are
   considered comments.
   - If the file exists and has a [Settings] line just add the font line
   beneath it.
   - Setting font family via settings.ini doesn't work on macOS and
   Microsoft Windows. Use CSS to set font family on those operating systems.

Via css

Create if necessary and add the following to GNC_CONFIG_HOME

/gtk-3.0.css:

* {
  font: 14pt arial, sans-serif;}


On Sun, 16 Jan 2022 at 12:55, D.  wrote:

> So,
>
> My gtk-3.0.css is in
>
> C:\Users\{USERNAME}\AppData\Roaming\GnuCash
>
> And the designator that changes fonts looks like this:
>
> * {
>font-size: 16px;
>font-family: "Arial", sans-serif;
> }
>
> You'd be better off following that, rather than copying from another app.
>
> David T.
> --
> *From:* David JamesTK
> *Sent:* Sat Jan 15 20:12:23 EST 2022
> *To:* David H
> *Cc:* GnuCash users group
> *Subject:* Re: [GNC] access to Gnucash Nabble
>
> Copied the config file containing this
>
> [Settings]
> gtk-font-name=Arial 18
> gtk-xft-antialias=1
> gtk-xft-hinting=1
> gtk-xft-hintstyle=hintfull
> gtk-xft-rgba=rgb
>
> Into empty file location C:\Users\david\AppData\Local\gtk-3.
>
> No change, this happened with Thunderbird too, option there was edit css file 
> something mentioned on wiki also.
>
> Cheers
>
> --
>
> From: David H 
> Sent: 16 January 2022 00:50
> To: David JamesTK 
> Cc: Glenn Fowler ; GnuCash users group 
> 
> Subject: Re: [GNC] access to Gnucash Nabble
>
>
> It’s my understanding the file is optional so won’t appear in all locations? 
> Have you tried copying your file into the app data location which is 
> currently empty by the look of things?
>
> Cheers David H.
>
> On Sun, 16 Jan 2022 at 10:35 am, David JamesTK 
> mailto:davidjame...@hotmail.co.uk>> wrote:
> Cheers David, tried the local folder first but appears empty (hide system 
> files option off)
>
> C:\Users\david\AppData\Local\gtk-3.0  (empty)
>
> Searching C drive for gtk-3.0 returns four entries below with my comments in 
> blue;
>
> C:\Program Files (x86)\gnucash\etc\gtk-3.0  (currently in this folder)
>
> C:\Users\david\AppData\Local\gtk-3.0  (empty)
>
> C:\Program Files (x86)\gnucash\share\themes\Default\gtk-3.0 (contains css 
> file gtk-keys)
>
> C:\Program Files (x86)\gnucash\share\themes\Emacs\gtk-3.0  (contains css file 
> gtk-keys)
>
> --
>
> From: David H mailto:hell...@gmail.com>>
> Sent: 16 January 2022 00:09
> To: David JamesTK 
> mailto:davidjame...@hotmail.co.uk>>
> Cc: Glenn Fowler mailto:gfowl...@outlook.com>>; GnuCash 
> users group mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] access to Gnucash Nabble
>
> Probably not, depends what you set GNC_DATA_HOME to I guess  - check that 
> wiki again - 
> https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME
>
> Cheers David H.
> GTK_DATA_HOME
>
> Versions: 3.x and more recent only
>
> GnuCash uses GTK for its graphical user interface; thus, locations that are 
> used by GTK are also relevant. Note the base directories on Windows and macOS 
> for this differ from the base directories for 
> GNC_DATA_HOME.
>
> Linux
> USER_DATA_HOME/gtk-3.0
> Windows
> %LOCALAPPDATA%\gtk-3.0
> macOS
> HOME

Re: [GNC] access to Gnucash Nabble

[D. via gnucash-user]

David, 

Until you create gtk-3.0.css, it's not going to exist. 

Use Notepad, copy and paste what I sent (maybe use "24px" as a test), and Save 
it as:

C:\Users\david\AppData\Roaming\GnuCash\gtk-3.0.css

Then start gnucash and see if things are changed.


 Original Message 
From: David JamesTK 
Sent: Sun Jan 16 00:16:05 EST 2022
To: "D." 
Cc: David H , "gnucash-user@gnucash.org" 

Subject: Re: [GNC] access to Gnucash Nabble

Thanks D, searched C: drive but no gtk-3.0.css file found.

With Windows 10 changing the overall size of everything is easy, can be done in 
small increments too only problem is all items are made larger - Chrome is 
already bordering on too big at the moment.

Nabble

Yes, sorry the title is a bit misleading as originally asking where the Nabble 
mailing list forum (not a forum) thingy had moved to, thought support may have 
stopped.

David H, can I respond to you also, the wiki page is my reference point too, if 
you can highlight what needs to be typed i.e correct syntax as per D response 
that would be great.

Cheers

From: D. 
Sent: 16 January 2022 02:55
To: David JamesTK 
Cc: David H ; gnucash-user@gnucash.org 

Subject: Re: [GNC] access to Gnucash Nabble

So,

My gtk-3.0.css is in

C:\Users\{USERNAME}\AppData\Roaming\GnuCash

And the designator that changes fonts looks like this:

* {
   font-size: 16px;
   font-family: "Arial", sans-serif;
}

You'd be better off following that, rather than copying from another app.

David T.

From: David JamesTK
Sent: Sat Jan 15 20:12:23 EST 2022
To: David H
Cc: GnuCash users group
Subject: Re: [GNC] access to Gnucash Nabble


Copied the config file containing this

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Into empty file location C:\Users\david\AppData\Local\gtk-3.

No change, this happened with Thunderbird too, option there was edit css file 
something mentioned on wiki also.

Cheers



From: David H 
Sent: 16 January 2022 00:50
To: David JamesTK 
Cc: Glenn Fowler ; GnuCash users group 

Subject: Re: [GNC] access to Gnucash Nabble


It’s my understanding the file is optional so won’t appear in all locations? 
Have you tried copying your file into the app data location which is currently 
empty by the look of things?

Cheers David H.

On Sun, 16 Jan 2022 at 10:35 am, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Cheers David, tried the local folder first but appears empty (hide system files 
option off)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

Searching C drive for gtk-3.0 returns four entries below with my comments in 
blue;

C:\Program Files (x86)\gnucash\etc\gtk-3.0  (currently in this folder)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

C:\Program Files (x86)\gnucash\share\themes\Default\gtk-3.0 (contains css file 
gtk-keys)

C:\Program Files (x86)\gnucash\share\themes\Emacs\gtk-3.0  (contains css file 
gtk-keys)



From: David H mailto:hell...@gmail.com>>
Sent: 16 January 2022 00:09
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: Glenn Fowler mailto:gfowl...@outlook.com>>; GnuCash 
users group mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Probably not, depends what you set GNC_DATA_HOME to I guess  - check that wiki 
again - https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFIG_HOME

Cheers David H.
GTK_DATA_HOME

Versions: 3.x and more recent only

GnuCash uses GTK for its graphical user interface; thus, locations that are 
used by GTK are also relevant. Note the base directories on Windows and macOS 
for this differ from the base directories for 
GNC_DATA_HOME.

Linux
USER_DATA_HOME/gtk-3.0
Windows
%LOCALAPPDATA%\gtk-3.0
macOS
HOME/.local/share/gtk-3.0


On Sun, 16 Jan 2022 at 09:56, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Thanks Glen.

Currently in this folder C:\Program Files (x86)\gnucash\etc\gtk-3.0  on Windows 
10 Pro
editing this file settings.ini

Before

[Settings]
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

After

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Is this the right folder location and entry (18 font not needed, just making it 
super obvious for any changes)

Thanks, David




From: Glenn Fowler mailto:gfowl...@outlook.com>>
Sent: 15 January 2022 23:47
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: GnuCash users group 
mailto:gnucash-user@gnucash.org>>
Subject

Re: [GNC] access to Gnucash Nabble

[D. via gnucash-user]

As I mentioned earlier, I used exactly those settings to change the fonts, 
repeatedly. Different faces, different sizes. So something isn't right on your 
machine. 

Two quick questions:
1) are you restarting gnucash each time after you save gtk-3.0.css?
2) did Notepad add ".txt" to your file name (making it gtk-3.0.css.txt)?

For the record, many people have changed the fonts in GnuCash, so that's just 
your frustration bleeding into the process. A search of the lists will show you 
many discussions in the past, as well as numerous resources on the wiki, 
indicating user interest in the topic. 

David T. 


 Original Message 
From: David JamesTK 
Sent: Sun Jan 16 11:23:10 EST 2022
To: "D." 
Cc: David H , "D. via gnucash-user" 

Subject: Re: [GNC] access to Gnucash Nabble

Followed to the letter but no change.

Desktop which is a new build and new GNUCash install does have this path above, 
results should match your own.

Created a text file gtk-3.0.css in C:\Users\david\AppData\Roaming\GnuCash\

The text file only contains the below

* {
   font-size: 24px;
   font-family: "Arial", sans-serif;
}

Has no one else asked to change the font before ?

Cheers all

From: D. 
Sent: 16 January 2022 13:29
To: David JamesTK 
Cc: David H ; D. via gnucash-user 
Subject: Re: [GNC] access to Gnucash Nabble

David,

Until you create gtk-3.0.css, it's not going to exist.

Use Notepad, copy and paste what I sent (maybe use "24px" as a test), and Save 
it as:

C:\Users\david\AppData\Roaming\GnuCash\gtk-3.0.css

Then start gnucash and see if things are changed.

From: David JamesTK
Sent: Sun Jan 16 00:16:05 EST 2022
To: "D."
Cc: David H , "gnucash-user@gnucash.org"
Subject: Re: [GNC] access to Gnucash Nabble

Thanks D, searched C: drive but no gtk-3.0.css file found.

With Windows 10 changing the overall size of everything is easy, can be done in 
small increments too only problem is all items are made larger - Chrome is 
already bordering on too big at the moment.

Nabble

Yes, sorry the title is a bit misleading as originally asking where the Nabble 
mailing list forum (not a forum) thingy had moved to, thought support may have 
stopped.

David H, can I respond to you also, the wiki page is my reference point too, if 
you can highlight what needs to be typed i.e correct syntax as per D response 
that would be great.

Cheers

From: D. 
Sent: 16 January 2022 02:55
To: David JamesTK 
Cc: David H ; gnucash-user@gnucash.org 

Subject: Re: [GNC] access to Gnucash Nabble

So,

My gtk-3.0.css is in

C:\Users\{USERNAME}\AppData\Roaming\GnuCash

And the designator that changes fonts looks like this:

* {
   font-size: 16px;
   font-family: "Arial", sans-serif;
}

You'd be better off following that, rather than copying from another app.

David T.

From: David JamesTK
Sent: Sat Jan 15 20:12:23 EST 2022
To: David H
Cc: GnuCash users group
Subject: Re: [GNC] access to Gnucash Nabble


Copied the config file containing this

[Settings]
gtk-font-name=Arial 18
gtk-xft-antialias=1
gtk-xft-hinting=1
gtk-xft-hintstyle=hintfull
gtk-xft-rgba=rgb

Into empty file location C:\Users\david\AppData\Local\gtk-3.

No change, this happened with Thunderbird too, option there was edit css file 
something mentioned on wiki also.

Cheers





From: David H 
Sent: 16 January 2022 00:50
To: David JamesTK 
Cc: Glenn Fowler ; GnuCash users group 

Subject: Re: [GNC] access to Gnucash Nabble


It’s my understanding the file is optional so won’t appear in all locations? 
Have you tried copying your file into the app data location which is currently 
empty by the look of things?

Cheers David H.

On Sun, 16 Jan 2022 at 10:35 am, David JamesTK 
mailto:davidjame...@hotmail.co.uk>> wrote:
Cheers David, tried the local folder first but appears empty (hide system files 
option off)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

Searching C drive for gtk-3.0 returns four entries below with my comments in 
blue;

C:\Program Files (x86)\gnucash\etc\gtk-3.0  (currently in this folder)

C:\Users\david\AppData\Local\gtk-3.0  (empty)

C:\Program Files (x86)\gnucash\share\themes\Default\gtk-3.0 (contains css file 
gtk-keys)

C:\Program Files (x86)\gnucash\share\themes\Emacs\gtk-3.0  (contains css file 
gtk-keys)





From: David H mailto:hell...@gmail.com>>
Sent: 16 January 2022 00:09
To: David JamesTK 
mailto:davidjame...@hotmail.co.uk>>
Cc: Glenn Fowler mailto:gfowl...@outlook.com>>; GnuCash 
users group mailto:gnucash-user@gnucash.org>>
Subject: Re: [GNC] access to Gnucash Nabble

Probably not, depends what you set GNC_DATA_HOME to I guess  - check that wiki 
again - https://wiki.gnucash.org/wiki/Configuration_Locations#GTK_CONFI