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] 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] 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] 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] 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] 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] Transaction Imports

[D via gnucash-user]

Not going to go into great detail here, but you definitely DON'T want to have 
gnucash calculate shares. Have it calculate price. 

On Apr 11, 2022, 11:21, at 11:21, Stu Perlman  wrote:
>Hello Everyone,
>
>I am looking for some guidance on how to import a few hundred
>transactions
>from my 401(k) account.
>Unfortunately, the plan administrator does not offer a good option for
>exporting the transaction data but I am able to get what I need with
>some
>basic web scraping.
>
>I have been experimenting with creating a multi-split CSV import from
>the
>data that I have captured.
>What I wanted to do was a file layout such as:
>
>*Date,Description,Account,Deposit,SharesAsMemo,Price*
>01/04/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.916289038,326.6
>01/19/2021,Contribution,Cash,-299.26
>,,Vanguard Institutional Index Institutional
>Fund,299.26,0.892008703,335.49
>
>
>My wishful thinking was that I could put the number of shares into the
>memo
>column for reference (but that the system would auto-calculate that
>number
>using the provided Price and transaction amount ("Deposit")).
>I hit a blocker on the second to last step of the import wizard with
>the
>message: "*The account 'Vanguard Institutional Index Fund' has a
>different
>commodity to the one required, 'US Dollar'. Please choose a different
>account.*"
>
>So I'm wondering if there are other ways I can go about what I'm trying
>to
>accomplish?  I started with the CSV importer because I figured it would
>be
>the easiest record layout to create but I'm not against using a
>different
>format if what I want to accomplish can be done.
>
>I have a backup plan which is that I will NOT do the multi-split import
>and
>will just select the Cash account for all rows in the Import Preview
>screen. I could pack the memo field with the ticker symbol, price,
>quantity, and total debit and let it all dump into the Imbalance-USD
>account. I would then have to either manually fix them one by one or
>possibly script it out.  I have done this with success in the past but
>would rather just get it right at the data import step if that's in any
>way possible.
>
>My thanks in advance for any advice offered.
>
>- Stu
>___
>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] I try to set up GNUCash and it says that my attempt to save the file is denied

[D via gnucash-user]

Out of curiosity, were you trying to run gnucash from inside the dmg, or did 
you actually copy the app onto your hard drive? 

On Mar 31, 2022, 07:19, at 07:19, David H  wrote:
>Check your settings, have you allowed Gnucash to have access to your
>Folders - Preferences >> Security & Privacy >> Privacy ?  You should
>have
>seen some sort of prompt when attempting to save your file the first
>time ?
>
>Cheers David H.
>
>
>On Thu, 31 Mar 2022 at 19:22, W. Neal Lewis 
>wrote:
>
>> I am trying to set up GNUCash on a Mac Pro running Mojave.
>>
>> I just downloaded the latest release for Intel Mac.
>>
>> After doing the preliminary work and setting up the files, I try to
>save
>> it.
>>
>> It always tells me that the save attempt is denied.
>>
>> I am running Intego AntiVirus software. I own the computer and am the
>> administrator.
>>
>> Any thoughts or comments?
>>
>> Thanks,
>>
>> Neal Lewis
>> ___
>> 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 Edit

[D via gnucash-user]

Set them to placeholder as well. 

On Mar 28, 2022, 05:41, at 05:41, Jack Dill  wrote:
>I have been a user of Gnucash for years.  As you might expect over the
>years I have added many accounts.  Recently I did some account editing
>to hide accounts that I no longer use.
>
>When entering a transaction those accounts that I hid continue to show
>in the account drop-down list.  What do I need to do to hide those
>accounts so my accounts for selection becomes more manageable?
>
>Many thanks for you help.
>
>Jack Dill
>___
>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] IRA/401K income detection

[D. via gnucash-user]

Thanks for the detailed reply. 

I apologize to you and everyone else for the tone of my reply; I didn't intend 
to insult anyone or malign accountants in particular. Sometimes my frustrations 
get the better of me, and I see note that this occurred in this situation. 

Sorry. 


 Original Message 
From: Stan Brown 
Sent: Thu Mar 17 09:48:26 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] IRA/401K income detection

On 2022-03-16 17:49, D. via gnucash-user wrote:
> But one of the big selling points of IRA/401Ks is that they earn
> money tax deferred (which I've also isolated into their own income
> accounts). How does Joe allocate the distributions-- or does it
> even matter? Each distribution is going to include a portion of
> deferred income and a portion of untaxed dividends (at least how
? I've captured the txns thus far). Is there a different way to
> manage those dividends?   

Were _all_ of your IRA or 401(k) contributions pretax money, or did you
pay income tax on any of them when you made the contributions? I'm going
to assume it's the former, which is the most common situation.

In that case, there is no need to keep separate track of dividends and
gain in asset value. As far as the tax code is concerned, it's all
ordinary income when you withdraw it, and there's no allocation of how
much is gains, how much is dividends, and how much is your original
contribution.

If you made any contributions that were _not_ deducted at the time, then
only a portion of your withdrawal is taxable. The basic idea is to
divide your original contributions by the current total value, then
multiply by the amount of the withdrawal, and that amount is
non-taxable. But it's more complicated than that: you have to keep track
of your "basis" from year to year, and file form 8606 each year you make
a non-deductible contribution or take any withdrawal. But still there's
no distinction between dividends and asset value gains.

Since you don't have to account for dividends for tax purposes in either
case, you're free to allocate the withdrawal any way you please. Or you
could drop the dividend account entirely, which is what I do.

> Yeah, I get that an accountant doesn't call this income, but frankly,
> I don't really care about the esoterica of accounting in this case. I
> care about what the government says is income. Accountants can yap all
> day long about how the IRA payouts aren't income; the IRS is still
> going to fine me if I don't pay up.

If you call a withdrawal income, then you're going to make a credit
entry to some income account. You will also make a credit entry to the
asset account for the amount of the withdrawal. There will be a
corresponding debit entry to Cash/Banks for the withdrawal. What will be
your corresponding debit entry to the credit entry for income?

-- 

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] IRA/401K income detection

[D. via gnucash-user]

Yeah, I get that an accountant doesn't call this income, but frankly, I don't 
really care about the esoterica of accounting in this case. I care about what 
the government says is income. Accountants can yap all day long about how the 
IRA payouts aren't income; the IRS is still going to fine me if I don't pay up. 


 Original Message 
From: Stan Brown 
Sent: Wed Mar 16 20:32:51 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] IRA/401K income detection


On 2022-03-16 15:09, D. via gnucash-user wrote:
> when Joe Retiree takes money from their IRA, the IRS considers it income, and 
> taxes it accordingly. But when Joe tries to enter the transfer from their IRA 
> to their checking account in GnuCash,  it doesn't get treated as income

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

Because it _isn't_. (The tax code's definition of income is not the same
as an accountant's.)

It is a debit to the asset of Cash/Banks, and a credit to the asset of
investments.

As several people have said, this can be record as the above simple
2-split transaction, in which case taxes are tidied up later when the
income tax is paid, or as a four-way split:

Debit:   Assets:Cash/Banks
Credit:  Assets:IRA
Credit:  Liability:Taxes payable
Debit:   Expenses:Income tax

-- 
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] IRA/401K income detection

[D. via gnucash-user]

Michael, 

I think I get what you're saying. In my own case, I've taken to separating the 
pretax streams into their own income accounts, which seemingly addresses some 
of your points. 

But one of the big selling points of IRA/401Ks is that they earn money tax 
deferred (which I've also isolated into their own income accounts). How does 
Joe allocate the distributions-- or does it even matter? Each distribution is 
going to include a portion of deferred income and a portion of untaxed 
dividends (at least how I've captured the txns thus far). Is there a different 
way to manage those dividends?   

I started receiving pension payouts, and they dutifully inform me every year 
how much of those payouts were from my own contributions, and how much from 
their pot. The IRS seems to care about these distinctions, but, I honestly 
don't know.

Maybe I'm just overthinking this? 

David T. 


 Original Message 
From: Michael or Penny Novack 
Sent: Wed Mar 16 19:10:50 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] IRA/401K income detection

On 3/16/2022 6:09 PM, D. via gnucash-user wrote:
> Adrien,
>
> Overall, I think you're right, but I believe the tax features you're 
> referring to are used to calculate taxes for a business? The issue with 
> deferred income-- and this has been true for as long as I can remember-- is 
> that when Joe Retiree takes money from their IRA, the IRS considers it 
> income, and taxes it accordingly. But when Joe tries to enter the transfer 
> from their IRA to their checking account in GnuCash,  it doesn't get treated 
> as income, and there doesn't appear to Joe to be a straightforward way in 
> GnuCash to make it into income that they can track for taxes. That is a 
> decidedly different tax issue than the one you've mentioned, IMHO.
>
> David T.

There was the reverse problem when the contribution was made. The 
solution used then (if 401k treated as an asset) would cancel the 
"problem" now.

The problem is that I am willing to bet that the books were opened with 
a starting amount for the 401k, opposite side "starting equity". 
Instead, the credit side of that should have been a "deferred income" 
account << that could well be placed under equity >>

So a distribution transaction is then a transfer between the assets 
"401k" and "cash" AND a transfer between "deferred income" and "income".

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] importing prices from csv

[D. via gnucash-user]

Every stock has a Namespace in Gnucash. "NYSE"  "NASDAQ" are examples. 

I have an online spreadsheet into which I can paste my Advanced Portfolio data, 
and then a second worksheet in the file compiles the prices for the result set, 
which can be cut and pasted locally for import. 


 Original Message 
From: George Riner 
Sent: Wed Mar 16 19:47:26 EDT 2022
To: Gnucash Users 
Subject: Re: [GNC] importing prices from csv

Thanks.

One question... I don't know what is "the entry from Gnucash" ? err... 
what entry from Gnucash?

:George

On 3/16/2022 2:59 PM, D. wrote:
> I am able to import prices from csv with a four column source:
>
> Ticker,  Namespace, Price,  Date
>
> Namespace is the entry from Gnucash.
> 
> *From:* George Riner
> *Sent:* Wed Mar 16 11:36:14 EDT 2022
> *To:* gnucash-user@gnucash.org
> *Subject:* [GNC] importing prices from csv
>
> My specs:
>
> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
> Gnucash: 4.9+(2021-12-18) Enaaglish
> Finance Quote: 1.51a
> I live and work in California, USA.
>
> I've been trying to use the "Import Prices from a CSV file..." tool.
> I've got a CSV with symbols ('ticker symbols'?) and prices, and it
> includes the name of the fund that the ticker symbol is for.
> It has a 'date' column for the date of the fund price.
> It has a column for 'Amount' that is the price of that fund.  The prices
> are in USD.
>
> I set "Currency To" to "USD (US Dollar)" in the drop down above the
> panel where it shows the rows of the CSV
>
> But I'm stumped what "Commodity From" is supposed to be. The CSV has
> prices (in USD) for various different funds - are funds commodities? If
> I pick "USD (US Dollar)" for Commodity From, the error is "Commodity
>   From can not be the same as 'Currency To'". Looking through the list
> offered in the 'Commodity From' drop down, I see all sorts of currencies
> and securities I've entered through the Security Editor.  What am I
> supposed to pick?
>
> :George
> California, USA
>
> 
>
> 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.

Re: [GNC] IRA/401K income detection

[D. via gnucash-user]

Oh, I know about using the tax flag and TXF report. Done it for years. But 
unless you figure out how to do what Mike has mentioned (consistently over the 
years), if you flag these accounts as tax-related, they still don't show as 
income, because you're transferring money from one asset account to another. 


 Original Message 
From: Adrien Monteleone 
Sent: Wed Mar 16 19:20:57 EDT 2022
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] IRA/401K income detection

GnuCash also lets you mark accounts as tax implicated and you can I 
think tie them to certain 'lines' or certain 'forms'. That's used for 
personal taxes as well.

I wasn't even thinking about the sales tax features for invoices/bills 
which is something entirely separate.

If simply marking the relevant accounts are not enough to get it onto a 
Tax Report, then yes, virtual type tracking will be needed.

Regards,
Adrien

On 3/16/22 5:09 PM, D. via gnucash-user wrote:
> Adrien,
> 
> Overall, I think you're right, but I believe the tax features you're 
> referring to are used to calculate taxes for a business? The issue with 
> deferred income-- and this has been true for as long as I can remember-- is 
> that when Joe Retiree takes money from their IRA, the IRS considers it 
> income, and taxes it accordingly. But when Joe tries to enter the transfer 
> from their IRA to their checking account in GnuCash,  it doesn't get treated 
> as income, and there doesn't appear to Joe to be a straightforward way in 
> GnuCash to make it into income that they can track for taxes. That is a 
> decidedly different tax issue than the one you've mentioned, IMHO.

___
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] IRA/401K income detection

[D. via gnucash-user]

Adrien, 

Overall, I think you're right, but I believe the tax features you're referring 
to are used to calculate taxes for a business? The issue with deferred income-- 
and this has been true for as long as I can remember-- is that when Joe Retiree 
takes money from their IRA, the IRS considers it income, and taxes it 
accordingly. But when Joe tries to enter the transfer from their IRA to their 
checking account in GnuCash,  it doesn't get treated as income, and there 
doesn't appear to Joe to be a straightforward way in GnuCash to make it into 
income that they can track for taxes. That is a decidedly different tax issue 
than the one you've mentioned, IMHO. 

David T.


 Original Message 
From: Adrien Monteleone 
Sent: Wed Mar 16 13:09:10 EDT 2022
To: gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] IRA/401K income detection

I could be missing something, but I thought that was already covered by 
one of the answers. Also, I'm pretty sure the proper place to record and 
track that is in an Asset account, not Equity.

As for the transactions, if you need to do virtual 'extra tracking' 
beyond just the physical withdrawal, you can do that all in one 
transaction rather than 2 or more.

A transaction can have more than 2 splits. So you'll have your real 
splits modeling the real world movement of funds, then you can have 
additional pair(s) of splits that handle 'tax due' type of tracking.

Finally, there are Tax Features built in. Have you investigated them and 
do they not address the 'tax due' tracking you are looking for? (you may 
not need additional accounts and virtual tracking transactions, just run 
a report)

Sorry I can't help more specifically. I don't use GnuCash for such 
purposes. Plenty on this list do however. Someone is sure to be able to 
offer a step by step at some point.

Regards,
Adrien

On 3/16/22 9:48 AM, David G. Pickett via gnucash-user wrote:
> OK, not anything like an accountant, so my books have just asset, liability, 
> income, expense.  Equity might be a better place for the IRA/401K, since it 
> is an asset with a varying value and an attached tax liability TBD.  So, how 
> should I have set up such 100% pretax deferred income accounts to capture the 
> income when money is transferred out, preferably without two transactions 
> (talk about your double entry!)?

___
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] importing prices from csv

[D. via gnucash-user]

I am able to import prices from csv with a four column source:

Ticker,  Namespace, Price,  Date

Namespace is the entry from Gnucash. 


 Original Message 
From: George Riner 
Sent: Wed Mar 16 11:36:14 EDT 2022
To: gnucash-user@gnucash.org
Subject: [GNC] importing prices from csv

My specs:

Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
Gnucash: 4.9+(2021-12-18) Enaaglish
Finance Quote: 1.51a
I live and work in California, USA.

I've been trying to use the "Import Prices from a CSV file..." tool.
I've got a CSV with symbols ('ticker symbols'?) and prices, and it 
includes the name of the fund that the ticker symbol is for.
It has a 'date' column for the date of the fund price.
It has a column for 'Amount' that is the price of that fund.  The prices 
are in USD.

I set "Currency To" to "USD (US Dollar)" in the drop down above the 
panel where it shows the rows of the CSV

But I'm stumped what "Commodity From" is supposed to be. The CSV has 
prices (in USD) for various different funds - are funds commodities? If 
I pick "USD (US Dollar)" for Commodity From, the error is "Commodity 
 From can not be the same as 'Currency To'". Looking through the list 
offered in the 'Commodity From' drop down, I see all sorts of currencies 
and securities I've entered through the Security Editor.  What am I 
supposed to pick?

:George
California, USA

___
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] MySQL

[D. via gnucash-user]

Henrik, 

As the third David on this thread, I fully echo what the other two have said, 
but will further add that if you are hoping to access the data serially and 
singly from a common location, the default XML file format can work equally 
effectively. And you don't have to maintain a MySQL server. 

David T.


 Original Message 
From: davidcousen...@gmail.com
Sent: Sun Mar 13 18:28:45 EDT 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] MySQL

Henrik,

I doubt if the reliability problem you are experiencing is intrinsically in
GnuCash itself although it may be associated with the library used to connect to
MMySQL.
  
GnuCash is not designed for multiple access in particular, i.e. multiple users
cannot simultaneously access the same data file without significant risk of
error. The libraries and routines for SQL access currently do not have the
record locking capability to support multiple simultaneous use. You will need to
establish administrative protocols, if using several computers to access
GNuCash, to ensure such access is not simultaneous.

I would initially trial testing on a single computer which is also running the
MySQL server supplying the data, to ensure there are no server installation
problems before trying to access the server remotely.  Once this is functioning
you can then be reasonably sure that any remote access problems are
communication/permissions issues and not intrinsic issues within GnuCash.
David Cousens

On Sun, 2022-03-13 at 18:37 +, Henrik Morsing wrote:
> Hi,
> 
> I'm new to GnuCash but really wanted it to save to MySQL so I could easily
> access it form different locations. It seems extremely un-reliable though, is
> this expected? Half the time is just hangs and says "The server experienced
> and error..." even though I can connect and log in manually with no issues.
> 
> Thanks for any tips

___
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] Fwd: GnuCash page FAQ has been changed by Flywire

[D. via gnucash-user]

Thanks to flywire for putting it together. 


 Original Message 
From: Geoff 
Sent: Tue Mar 08 21:28:52 EST 2022
To: "D." 
Cc: Adrien Monteleone , GnuCash-User 

Subject: Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

Looks good to me!

Thanks

Geoff
=

On 9/03/2022 12:59 pm, D. wrote:
> I have moved the entire text of this question to Using Gnucash,  and 
> left a bread crumb in the FAQ.
> 
> *From:* Geoff
> *Sent:* Tue Mar 08 17:08:02 EST 2022
> *To:* adrien.montele...@lusfiber.net, gnucash-u...@lists.gnucash.org
> *Subject:* Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire
> 
> And I'll third that motion.
> 
> "Using GnuCash" is quite an omnibus, it even has:
> 
> https://wiki.gnucash.org/wiki/Using_GnuCash#GnuCash_on_Holidays_with_your_friend
>   
> <https://wiki.gnucash.org/wiki/Using_GnuCash#GnuCash_on_Holidays_with_your_friend>
> 
> :--))
> 
> Thanks
> 
> Geoff
> =
> 
> On 9/03/2022 7:16 am, Adrien Monteleone wrote:
> 
>     I second moving it to Using GnuCash.
> 
> Regards,
> Adrien
> 
> On 3/8/22 6:13 AM, D. via gnucash-user wrote:
> 
> Geoff,
> 
> Your points are valid.
> 
> If we accept your assertions (and I'm willing to), my thinking
> is that
> this information might be better placed on the Using Gnucash page.
> 
> 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
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
> <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  
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
> If you are using Nabble or Gmane, please 
> seehttps://wiki.gnucash.org/wiki/Mailing_Lists  
> <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] Fwd: GnuCash page FAQ has been changed by Flywire

[D. via gnucash-user]

I have moved the entire text of this question to Using Gnucash,  and left a 
bread crumb in the FAQ.


 Original Message 
From: Geoff 
Sent: Tue Mar 08 17:08:02 EST 2022
To: adrien.montele...@lusfiber.net, gnucash-u...@lists.gnucash.org
Subject: Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

And I'll third that motion.

"Using GnuCash" is quite an omnibus, it even has:

https://wiki.gnucash.org/wiki/Using_GnuCash#GnuCash_on_Holidays_with_your_friend

:--))

Thanks

Geoff
=

On 9/03/2022 7:16 am, Adrien Monteleone wrote:
> I second moving it to Using GnuCash.
> 
> Regards,
> Adrien
> 
> On 3/8/22 6:13 AM, D. via gnucash-user wrote:
>> Geoff,
>>
>> Your points are valid.
>>
>> If we accept your assertions (and I'm willing to), my thinking is that 
>> this information might be better placed on the Using Gnucash page.
>>
>> 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.
___
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] Fwd: GnuCash page FAQ has been changed by Flywire

[D. via gnucash-user]

Jim, 

1. Hear hear! 

2. I agree completely. In the past I have actually done precisely what you 
describe.

3. I think this is the underlying issue I have with this entry in the FAQ.

David T.


 Original Message 
From: Jim DeLaHunt 
Sent: Tue Mar 08 03:26:22 EST 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

Hello, all:

Well, if list discussion on this documentation change is invited, I have 
three comments:

1. It's great to have people writing more documentation. There is a lot 
to be explained, and it's wonderful when people take the time to explain 
it. Thank you!

2. I am lukewarm on the topic, but I would not delete it because of 
that. However, I think it a bit long to be an FAQ answer. It is one of 
the longer answers in the FAQ. It would be better off on a separate wiki 
page, linked to from a 1-2 sentence answer in the FAQ. The page could be 
named "Rental Property Accounting" or something like that.

3. Is it really a "frequently asked" question?  Does it need to be 
linked from the FAQ page?  I think the FAQ page is long and unwieldy. 
Partly that is because I think we have let the FAQ page be the only 
entryway we can imagine into the wiki. Thus every topic has to be framed 
as a frequent question and linked from the FAQ page. A number of FAQ 
answers would be better off as separate wiki pages. A number of topics 
could be cut from the present FAQ page and put onto other topic pages.

I don't feel moved to make any changes based on these opinions, but 
maybe this helps encourage someone else.

Best regards,
     —Jim DeLaHunt, Vancouver, Canada

On 2022-03-07 21:28, Geoff wrote:
> Hi David
>
> [[ Before responding I took the time to read the 
> https://wiki.gnucash.org/wiki/FAQ from top to bottom. ]]
>
> I understand the important role that reviewers like yourself play in 
> keeping multi-author documents to a coherent readable whole.  I also 
> understand your concern that the overall solution involves a 
> spreadsheet, however I believe there is sufficient merit in this 
> answer to retain it in the FAQ.  My reasons are:
>
> (1) It is a well written and illustrated answer to a real world 
> problem that multiple GunCash users face.
>
> (2) To paraphrase John Donne, "no software package is an island" and 
> spreadsheets are a natural complement to GnuCash and other accounting 
> software packages.
>
> (3) There is a whole section of the FAQ under "Accounting Questions" 
> that is arguably "not really relevant to using GnuCash per se" as you 
> put it, but it still adds value to the overall GnuCash ecosystem.
>
> (4) It does no harm.
>
> So, my vote is to retain it.
>
> Regards
>
> Geoff
> =
> P.S. THANK YOU Flywire for taking the time and making the effort to 
> update the FAQ.  You have inspired me to try and do the same in 2022.
>
>
>
> On 8/03/2022 12:45 pm, D. via gnucash-user wrote:
>> Flywire,
>>
>> I received the attached notice about an addition you made to the wiki 
>> FAQ page. The addition you made concerned rental statements. However, 
>> the solution you offered was to use a spreadsheet. While the 
>> information is likely to be useful to some users, it's not really 
>> relevant to using gnucash, per se, and thus I don't think it belongs 
>> on the Gnucash FAQ. Given that users are advised to check the mailing 
>> lists as well as the wiki and manuals for guidance, I think that 
>> adding this to the wiki isn't really necessary.
>>
>> I'm sending this to the list because I'd rather discuss the issue in 
>> the group, rather than simply changing your entry.
>>
>> I am open to being wrong about this, but I think that this info would 
>> be better placed somewhere else.
>>
>> David T.
>>
>>
>>  Original Message 
>> From: GnuCash 
>> Sent: Mon Mar 07 19:43:32 EST 2022
>> To: Sunfish62 
>> Subject: GnuCash page FAQ has been changed by Flywire
>>
>> Dear Sunfish62,
>>
>> The GnuCash page FAQ has been changed on 8 March 2022 by Flywire, see
>> https://wiki.gnucash.org/wiki/FAQ for the current revision.
>>
>> To view this change, see
>> https://wiki.gnucash.org/wiki/index.php?title=FAQ=next=20959
>>
>> For all changes since your last visit, see
>> https://wiki.gnucash.org/wiki/index.php?title=FAQ=0=20959
>>
>> Editor's summary: How can I print a Rental Statement for my Tenant?
>>
>> Contact the editor:
>> mail: https://wiki.gnucash.org/wiki/Special:EmailUser/Flywire
>> wiki: https://wiki.gnucash.org/wiki/User:Flywire
>>
>> There will be no other notifications in case of furthe

Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

[D. via gnucash-user]

Geoff, 

Your points are valid. 

If we accept your assertions (and I'm willing to), my thinking is that this 
information might be better placed on the Using Gnucash page.

David T.


 Original Message 
From: Geoff 
Sent: Tue Mar 08 00:28:06 EST 2022
To: "D." , GnuCash-User 
Subject: Re: [GNC] Fwd: GnuCash page FAQ has been changed by Flywire

Hi David

[[ Before responding I took the time to read the 
https://wiki.gnucash.org/wiki/FAQ from top to bottom. ]]

I understand the important role that reviewers like yourself play in 
keeping multi-author documents to a coherent readable whole.  I also 
understand your concern that the overall solution involves a 
spreadsheet, however I believe there is sufficient merit in this answer 
to retain it in the FAQ.  My reasons are:

(1) It is a well written and illustrated answer to a real world problem 
that multiple GunCash users face.

(2) To paraphrase John Donne, "no software package is an island" and 
spreadsheets are a natural complement to GnuCash and other accounting 
software packages.

(3) There is a whole section of the FAQ under "Accounting Questions" 
that is arguably "not really relevant to using GnuCash per se" as you 
put it, but it still adds value to the overall GnuCash ecosystem.

(4) It does no harm.

So, my vote is to retain it.

Regards

Geoff
=
P.S. THANK YOU Flywire for taking the time and making the effort to 
update the FAQ.  You have inspired me to try and do the same in 2022.



On 8/03/2022 12:45 pm, D. via gnucash-user wrote:
> Flywire,
> 
> I received the attached notice about an addition you made to the wiki FAQ 
> page. The addition you made concerned rental statements. However, the 
> solution you offered was to use a spreadsheet. While the information is 
> likely to be useful to some users, it's not really relevant to using gnucash, 
> per se, and thus I don't think it belongs on the Gnucash FAQ. Given that 
> users are advised to check the mailing lists as well as the wiki and manuals 
> for guidance, I think that adding this to the wiki isn't really necessary.
> 
> I'm sending this to the list because I'd rather discuss the issue in the 
> group, rather than simply changing your entry.
> 
> I am open to being wrong about this, but I think that this info would be 
> better placed somewhere else.
> 
> David T.
> 
> 
>  Original Message 
> From: GnuCash 
> Sent: Mon Mar 07 19:43:32 EST 2022
> To: Sunfish62 
> Subject: GnuCash page FAQ has been changed by Flywire
> 
> Dear Sunfish62,
> 
> The GnuCash page FAQ has been changed on 8 March 2022 by Flywire, see
> https://wiki.gnucash.org/wiki/FAQ for the current revision.
> 
> To view this change, see
> https://wiki.gnucash.org/wiki/index.php?title=FAQ=next=20959
> 
> For all changes since your last visit, see
> https://wiki.gnucash.org/wiki/index.php?title=FAQ=0=20959
> 
> Editor's summary: How can I print a Rental Statement for my Tenant?
> 
> Contact the editor:
> mail: https://wiki.gnucash.org/wiki/Special:EmailUser/Flywire
> wiki: https://wiki.gnucash.org/wiki/User:Flywire
> 
> There will be no other notifications in case of further activity unless
> you visit this page while logged in. You could also reset the
> notification flags for all your watched pages on your watchlist.
> 
> Your friendly GnuCash notification system
> 
> --
> To change your email notification settings, visit
> https://wiki.gnucash.org/wiki/Special:Preferences
> 
> To change your watchlist settings, visit
> https://wiki.gnucash.org/wiki/Special:EditWatchlist
> 
> To delete the page from your watchlist, visit
> https://wiki.gnucash.org/wiki/index.php?title=FAQ=unwatch
> 
> Feedback and further assistance:
> https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents
> ___
> 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.

[GNC] Fwd: GnuCash page FAQ has been changed by Flywire

[D. via gnucash-user]

Flywire,

I received the attached notice about an addition you made to the wiki FAQ page. 
The addition you made concerned rental statements. However, the solution you 
offered was to use a spreadsheet. While the information is likely to be useful 
to some users, it's not really relevant to using gnucash, per se, and thus I 
don't think it belongs on the Gnucash FAQ. Given that users are advised to 
check the mailing lists as well as the wiki and manuals for guidance, I think 
that adding this to the wiki isn't really necessary. 

I'm sending this to the list because I'd rather discuss the issue in the group, 
rather than simply changing your entry.

I am open to being wrong about this, but I think that this info would be better 
placed somewhere else. 

David T.


 Original Message 
From: GnuCash 
Sent: Mon Mar 07 19:43:32 EST 2022
To: Sunfish62 
Subject: GnuCash page FAQ has been changed by Flywire

Dear Sunfish62,

The GnuCash page FAQ has been changed on 8 March 2022 by Flywire, see
https://wiki.gnucash.org/wiki/FAQ for the current revision. 

To view this change, see
https://wiki.gnucash.org/wiki/index.php?title=FAQ=next=20959

For all changes since your last visit, see
https://wiki.gnucash.org/wiki/index.php?title=FAQ=0=20959

Editor's summary: How can I print a Rental Statement for my Tenant? 

Contact the editor:
mail: https://wiki.gnucash.org/wiki/Special:EmailUser/Flywire
wiki: https://wiki.gnucash.org/wiki/User:Flywire

There will be no other notifications in case of further activity unless
you visit this page while logged in. You could also reset the
notification flags for all your watched pages on your watchlist.

Your friendly GnuCash notification system

--
To change your email notification settings, visit
https://wiki.gnucash.org/wiki/Special:Preferences

To change your watchlist settings, visit
https://wiki.gnucash.org/wiki/Special:EditWatchlist

To delete the page from your watchlist, visit
https://wiki.gnucash.org/wiki/index.php?title=FAQ=unwatch

Feedback and further assistance:
https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents
___
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] Subject: Re: Keeping tenant accounts on Gnucash - periodic 'rent owing' ?

[D. via gnucash-user]

With your system, you could use your spreadsheet as a data source for a Word 
mail merge document that would fill in the receipt information from the 
spreadsheet. No editing necessary, just process the single entry to a new 
document (or pdf). Probably could have a calculated cell in Excel for balance 
due as well. 

It ain't Gnucash, but it might make you happier...

David


 Original Message 
From: arthur brogard via gnucash-user 
Sent: Mon Mar 07 14:35:44 EST 2022
To: "gnucash-u...@lists.gnucash.org" 
Subject: [GNC] Subject: Re: Keeping tenant accounts on Gnucash - periodic 'rent 
owing' ?


Thanks for these inputs.  Hope I haven't done anything wrong.  I'm still 
blundering around trying to understand how to work the mailing list thing.
It all looks too complicated to me.  Not worth the hassle. 

I'll tell you what I"ve got right now:
  I have a spreadsheet that I enter money received,  date received,  payer 
into. It shows me then immediately which weeks rents have been pad and what the 
balance is at that rent day.
If they've paid money for 'other', i.e. not rent money, I enter that amount 
into 'other' and only the rent amount into rent.
The 'other' bit is not automated at all.  I have to eyeball it and calculate 
balance each time.  

So I enter their payment in there and see what balances I've got.
Then I go to Word and pick up the last receipt I sent them and I modify it to 
suit this week's numbers.  And save it with the date of it.  Hence I've got a 
record of every receipt sent and I've got the spreadsheet.
The receipts, I know, are not required by law because they pay by direct 
deposit.  But I prefer to do it that way.  

Now the pain is modifying that receipt.
If I could have an account where I simply enter the receipt and it shows me the 
balance and I print that out as a receipt that'd be great.
That account would have to have automatically incremented the 'amount due' as 
the real life dates passed. 

Well, two balances:  the rent and the 'other'.
That's all I'm after.
When I asked I really thought I'd get a reply saying that all such cases of 
meeting period payments, recording them, printing out statements of account and 
receipts are done by 'such and such' software or 'this and that' feature of 
gnucash.
I realise (now) I'm making things abnormal in that my 'receipt' is really a 
receipt AND a statement, isn't it?  

A plain receipt would be easy as pie.  

No.  I need more than that.  Everything has to be crystal clear to this tenant. 
What he's paid for rent, what for other, what the balances are when the next 
payment is due,  which weeks have been paid for.
What I will do is start using gnucash with my present state of knowledge and 
just find out what happens.  See how I go.
I'll use cash accounting I guess.  See no need for accrual as best I hazily 
remember my accounting. (It was over 20 years ago).  

Do we have to tell gnucash which we're using or its all in how we enter things?
Thanks for all the interest and help.

___
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] mac fails to open gnucash file

[D. via gnucash-user]

I'm not using a Mac anymore, but you should know that double clicking a file in 
Finder will not open that file in GnuCash but will open the last opened file 
instead. It is a Known Mac Thing. 

You might want to try using File -> Open to see whether your File really won't 
open...


 Original Message 
From: brad 
Sent: Fri Mar 04 21:07:22 EST 2022
To: gnucash-user@gnucash.org
Subject: Re: [GNC] mac fails to open gnucash file

Upgraded to 4.9.  It still fails to open.   Also when closing GC it 
crashes.  I don't know if the list will allow it, but I'll attach the 
crash report.

On 3/4/22 17:48, William Prescott wrote:
> There was a problem with 4.8 on Monterey. I don't remember the symptoms, but 
> upgrading to 4.8-2 or 4.9 fixed it. Either should be compatible with 4.8 on 
> Linux.
>
> Will
>
> On 2022 Mar 4, at 03-04 18:39:04, brad  wrote:
>
> I suddenly can't open a gnucash file (it worked recently) on Mac. Gnucash 
> 4.8.   The Mac recently updated to 12.2.1, Monterey & that may have broken 
> gnucash.
> It will have an error msg like: 'Can't parse the URL/Volumes/.../brad.gnucash'
> We usually run it on a Samba share, but I copied it over to the Mac and it 
> can't open it on the hard drive either.   I've tried opening from finder, or 
> from GC
>
> If the answer is to update GC to 4.9 on the mac, can I keep running 4.8 on 
> linux and be compatible?
>
> Thx
> Brad
> ___
> 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] Stock Transaction

[D. via gnucash-user]

I'd say yes. 


 Original Message 
From: Jack Frillman via gnucash-user 
Sent: Wed Mar 02 12:11:30 EST 2022
To: gnucash-user@gnucash.org
Subject: [GNC] Stock Transaction


I had a stock (INFO) in a company that was purchased by another company 
(SPGI).  INFO no longer exists but I now have x shares of SPGI.
What's the recommended way of recording this in GNUCash?

This looks very similar to a Mutual Find conversion I asked about a few 
weeks ago. Can this stock transaction be handled the same way?

Thanks.

-- 
Old Unix programmers never die, they just mv to /dev/null
- Anonymous

___
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] Report question

[D. via gnucash-user]

If you took the report data and pasted it directly into your favorite 
spreadsheet, you could save the result as CSV, no problem. 

At this point, it might be more useful if you explained more completely what it 
is you're trying to accomplish. Then people on the list could help you solve 
the problem, rather than half answer your half-stated question. 

David


 Original Message 
From: Paul Kinzelman 
Sent: Sat Feb 26 11:56:27 EST 2022
To: Tommy Trussell 
Cc: Gnucash Elist 
Subject: Re: [GNC] Report question

Thank you for the detailed instructions.
I found that 'Transaction Report' will do what I want, but then
I can't export to CSV.

I can export to HTML by Export Report
I can 'Export as PDF' but not CSV. That's what I'm missing.
This would be really nice to add.

I can Export Transactions, but that does not export the transactions
of the transaction report which is what I wanted to do.

On 2/25/2022 6:08 PM, Tommy Trussell wrote:
> On Fri, Feb 25, 2022 at 9:27 AM Paul Kinzelman  wrote:
>
> Do you mean Account Report? But when I go to File | Export, it asks
> me which accounts again, it doesn't export the actual report.
>
> When I export the transactions I want, it exports both sides of the
> transaction, so the column sum is always zero whereas I want the
> sum of the transactions.
>
> In other words, each transaction takes two lines, the line I want
> (the expense of what I bought), and the next line which is the
> account that paid it (like a charge card).
>
> How do I get rid of the double-lines on the export?
>
>
> We're apparently not seeing the same thing you are.
>
> Here's a way to get an Account Report for your credit card 
> transactions. (This is using GnuCash 4.9.)
>
> 1) Open the account
>    Accounts tab --> open Liabilities : Credit Cards : BigBankTwo VISA  
> (yours will differ)
>
> 2) Use Filter By to select the transactions you want [while the 
> register is active]
>    View --> Filter By (choose parameters such as date, number of days, 
> reconciled, etc.)
>
> 3) Open Account Report [while the filtered register is active]
>     Reports --> Account Report
>
> 4) Adjust the options on the report
>    Edit --> Report Options
>    (here you can adjust specific columns, single or double amount 
> columns, totals or running total, style, report name, etc.)
>
> 5) Export the report
>     You can copy what's on your screen and paste it into a word 
> processor or spreadsheet
>     OR
>     File --> Export --> Export Report  (give it a name -- it will save 
> an .html file you can open with a web browser or a spreadsheet program)
>
> -
> 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] Profit & Retained Earning don't match

[D. via gnucash-user]

Derek, 

Thanks for raising those legitimate points. I think a flag or trigger to 
reselect accounts would be helpful. 

I would note that, to my way of thinking, when I call up a saved report, I *am* 
running it from scratch, although I understand your perspective. From my 
corner, when I call up a custom report, I'm doing the exact same steps as when 
I run a system report "from scratch." I open the reports menu, and I ask to run 
my report. In one case, it's a new report from scratch; the other is not. 
That's confusing to me. 

David


 Original Message 
From: Derek Atkins 
Sent: Fri Feb 25 21:07:49 EST 2022
To: Stan Brown 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Profit & Retained Earning don't match

HI,

On Fri, February 25, 2022 7:07 pm, Stan Brown wrote:
> On 2022-02-25 15:09, D. wrote:
>>
>> My recollection was that standard reports based on a class of accounts
>> (assets, liabilities) will recompile the account list each time.
>>
>> It would seem useful to extend this functionality to saved reports as
>> well...
>
> That's what I was trying to suggest, but you stated it much more clearly!

ANY report you re-run from scratch will start with the current set of
accounts.

Changing the list of accounts on a Saved Report, however, could have
negative consequences, especially if the user explicitly set the set of
accounts.  Imagine if you explicitly wanted a Cash Flow report with all
but one Asset account, saved it, and then when you re-ran the report that
account got added in!  That would change the report results.

Arguably there *could* be a flag for "using the default" which would cause
the saved report to use the current default (which may be different than
the default at the time the report was saved).  I'm not sure how we would
encode that, and it certainly would not be a backwards-compatible change.

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

Re: [GNC] Profit & Retained Earning don't match

[D. via gnucash-user]

Derek, 

Some of the standard reports automatically update the account selection when 
they are invoked. See, for example, the Advanced Portfolio report, which 
automatically selects new commodity accounts each time it is run. 

My recollection was that standard reports based on a class of accounts (assets, 
liabilities) will recompile the account list each time. 

It would seem useful to extend this functionality to saved reports as well...

David T.


 Original Message 
From: Derek Atkins 
Sent: Fri Feb 25 16:56:36 EST 2022
To: Stan Brown 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] Profit & Retained Earning don't match

HI,

On Fri, February 25, 2022 4:49 pm, Stan Brown wrote:
>
> On 2022-02-25 13:14, Derek Atkins wrote:
>> For example, if you ran the report, then added an account, that new
>> account would not be included by default in the report if you refresh
>> it.
>> You need to manually add the new account into the report.
>>
>> This also applies to saved reports.
>
> Wow -- I did not know this, but it explains why my balance sheet and
> income statement sometimes miss accounts. (With the income statement in
> particular, I run it only at the end of the year, so any accounts could
> have been added almost a whole year ago, and I wouldn't remember when I
> added them.)
>
> I select accounts for my saved reports in what seems like a sensible
> way: all Income And Expense accounts for the income statement, and all
> Assets, Liabilities, and Equities for the balance sheet.
>
> I don't know how hard this would be to do, but it would be nice if GC
> would keep track in a saved report of how accounts were selected. If the
> selection was by a hierarchy rather than individual accounts, GC could
> then automatically include all accounts within that hierarchy when
> running the saved report.

Yeah, sorry -- that's not how it works.  It honestly doesn't know anything
about "accounts" per se, let along hierachies.  It just knows "Object
GUIDs".

The good news is that it's only a few clicks to get "all accounts" added.

But yeah, if you save a report, or have a report "open", it wont learn
about new accounts.

This has been the case since, oh... 2003?  2005?  Something like that.

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

Re: [GNC] exporting search?

[D. via gnucash-user]

Moreover, if you've already assigned your accounts to tax lines, the TXF report 
will quickly give you exactly how much you spent on each tax line last year. 
That's what the report is for. 

The TXF report will also break up tax lines by gnucash account, which is why I 
have brokerage-based income accounts for capital gains and dividends. That way, 
I can quickly see whether my numbers align with the broker 1099 forms. 

I usually change the options to suppress transaction detail, then I see only 
totals. I also hide zero dollar accounts. 


 Original Message 
From: David H 
Sent: Mon Feb 21 04:04:56 EST 2022
To: Jeff 
Cc: Gnucash Users 
Subject: Re: [GNC] exporting search?

What's wrong with the transaction report for this - gives you a total at
the bottom and you can also export and print the results ?

Cheers David H

On Mon, 21 Feb 2022 at 17:53, Jeff  wrote:

>
> I have had trouble with this as well.  Each medical expense can have 2
> or more related transactions.  Medical expense, mileage, travel expense
> (ie. meals, fuel), lodging,etc.  All are separate entries on U.S.
> taxes.  I know that you can assign tax values to individual accounts,
> but a total dollar value in a specific search would be advantageous.  It
> would be nice to search for all transactions in a specific search and
> give me the total dollars spent in that search.
>
> I.E. search total dollars spent on lodging in the medical travel account
> from 6/21/2002 to 8/21/2002.
>
> I have yet to see where GNC gives me a total dollar amount spent in a
> search.  Add it to my wish list.
>
>
> --
>
> --JEffrey Black M.B.A.
>
> ___
> 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] exporting search?

[D. via gnucash-user]

Personally, I'd have a separate account for medical expenses, and then a 
transaction report for that account would quickly give me totals for any given 
period. 


 Original Message 
From: Geoff 
Sent: Sat Feb 19 18:32:43 EST 2022
To: p...@kinzelman.com, Gnucash Elist 
Subject: Re: [GNC] exporting search?

Hi Paul

Your original request said you required a list of expenses.  If you only 
want the totals amount, there is no need to export at all.  Just scroll 
to the bottom of the Account Report, which shows the the total Debits, 
Credits, and Balance.

As to your other useful suggestions, please excuse the editorial.  I see 
that the lead article on your web site is titled "The Importance of 
Building a Strong Community".

The great thing about GnuCash is that it is built, maintained, and 
supported by a wonderful volunteer open source community.  Please feel 
free to join us.  I am sure that someone with your background and 
experience could make and make a valuable contribution:

https://wiki.gnucash.org/wiki/Contributing_to_GnuCash

Regards

Geoff
=

On 20/02/2022 10:03 am, Paul Kinzelman wrote:
> Thank you!
> 
> I see now how I can do that, but it's not all that convenient to do, seems
> like it would be something that lots of people would want to do.
> 
> Copy/paste from HTML seems like not a good way to expect people
> to do it as well.
> All I want is a total of the columns of a search, seems like this ought
> to be a feature built in already.
> 
> I also looked for this kind of search/export in the documentation and
> couldn't find it, it'd be nice to say something about that too.
> 
> I tried things like "export search results" and nothing came up.
> Even "search results" didn't say much.
> A section on common things people like to do would be good.
> 
> 
> 
> On 2/19/2022 3:40 PM, Geoff wrote:
>> Hi Paul
>>
>> From the Search Results tab, choose Reports / Account Report.
>>
>> This opens a new tab with a variant of the Transaction Report showing 
>> just the transactions in your Search Results.  The Report Options let 
>> you tweak which columns are displayed.
>>
>> From there, you can either File / Export / Report, or just select all 
>> and copy /paste.
>>
>> The export format is HTML, but it pastes into Microsoft Excel in a 
>> usable format.
>>
>> Regards
>>
>> Geoff
>> =
>>
>> On 20/02/2022 6:49 am, Paul Kinzelman wrote:
>>> Is there some way to export search results?
>>>
>>> I was trying to get a list of medical expenses for the past year and 
>>> I didn't
>>> see any easy way to do this, is there a good way to do it?
>>>
>>> I tried search but I couldn't export it or total the columns.
>>> It seems like I should be able to export this list - this is a
>>> general question.
>>>
>>> I tried income expense cash flow for the year, but it gave me just
>>> money-in and money-out. I was looking for detail to export to a 
>>> spread sheet.
>>>
>>> I finally did File Export Transactions and got what I wanted but it 
>>> seems
>>> like there should be an easier way.
>>>
>>> Suggestions?
>>>
>>> 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] mortgage calculator

[D. via gnucash-user]

I manually edit each mortgage entry as well. I use the mortgage statements to 
reconcile the final amounts. 

I mean, there aren't that many transactions to consider. I don't see this as 
much of a burden. 

David


 Original Message 
From: Derek Atkins 
Sent: Fri Feb 18 14:50:22 EST 2022
To: Alan Schold 
Cc: gnucash-user@gnucash.org
Subject: Re: [GNC] mortgage calculator

HI,

On Fri, February 18, 2022 2:42 pm, Alan Schold via gnucash-user wrote:
> Is there a way to get the mortgage repayment module to account for
> regular extra monthly payments? Now the calculations proceed as if I'm
> just paying the basic mortgage amount, and I have to recalculate the
> principal balance each month. The calculator is only right once!

Sorry, no.

This is a long-standing limitation of the calculator (and trust me, it's
been hitting me forever!!).

The MAIN issue is the lack of a "GetBalanceAsOfDate()" function usable
within the scheduled transaction (SX) functions, and tied into the SX
system where it can supply the date as part of the SX firing methods. 
Adding it is, unfortunately, not as straightforward as you would think,
which is why nobody has done it, yet.

Me, I just periodically go through and update the P/I splits from my
mortgage and loan statements.

Sorry,

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

Re: [GNC] Help with reconcile menu

[D via gnucash-user]

The opening balance tallies every transaction that was previously reconciled, 
regardless of date. The Guide notes that the starting balance is less important 
than the closing balance. If the closing balance is correct, proceed with your 
reconciliation and finish when the difference is zero. 

On Feb 5, 2022, 11:41, at 11:41, Martin Dupras  wrote:
>Hi,
>
>I'm still relatively new to GnuCash, so I may be misunderstanding
>something.
>
>I have an account for which I have entered several years of
>transactions
>(not as they happening, as an exercise to look at my expenses for the
>last
>three years.)
>
>All of the transaction amounts on the account are correct; but
>somewhere
>along the way something happened which broke the reconciliation. What
>seems
>to happen is that whenever I try to reconcile, the ending balance is
>correct, but the opening balance is wrong.
>
>The opening balance on the account is right, and it's the first
>transaction
>for the account. Yet, when I try to reconcile it, the dialogue window
>shows
>"Starting Balance: £1000.00".
>
>I can't see an invisible transaction anywhere (all boxes ticked in the
>"status" tab of "Sort By").
>
>Can anyone clarify how GnuCash figures out this £1000? If I knew where
>to
>look, I might be able to fix it.
>
>Thanks!
>
>- martin
>___
>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] report subaccounts totals on stacked barchart

[D. via gnucash-user]

Mattia,

I believe you want to experiment with the Account Level setting. It controls 
how far down into the account hierarchy the report displays. It will total up 
lower level accounts into the parent if they are also selected accounts. 

Unfortunately, you can't set different levels for different types of account, 
as you indicated; there is one setting for the whole report.

My workaround would be to create separate reports for each "level" report, and 
put them side by side on a multicolumn report. 

HTH,
David T.


 Original Message 
From: Mattia Rizzolo 
Sent: Tue Feb 01 06:25:24 EST 2022
To: gnucash-user@gnucash.org
Subject: [GNC] report subaccounts totals on stacked barchart

Hi!

My liabilities have this (pretty common, I think) structure:

Liabilities
 |-AP
 | |- x
 | |- y
 | |- z
 |
 |-Credit Cards
 | |- Bank1
 | | |- x
 | | |- y
 | |
 | |- Bank2
 | |- Bank3
 |
 |-Loans
 | |- Bank1
 | | |- Loan1
 |
 |-Security Deposits # this is money I'm keeping as deposit
 | |-Apartment1  # for an apartment I'm renting out
 |
 |-Tax Provision
 | |-2021
 | | |- Tax1
 | | |- Tax2
 | |
 | |-2022
 | | |- Tax
 | | |- Tax2

In this, only the leaf accounts actually contain transactions, all the
others are marked as "placeholder".

Now, I'd like to have 2 different "Liabilities barchart"s:
* one very detailed that contains all possibile stacks
* one that contains only the branch totals plus some subaccounts

I'm having troubles figuring out which options I should pick in the
report settings to get the latter.  I'd like to see a barchart
containing a stack for each of the following:
 * AP
 * Credit Cards:Bank1:x
 * Credit Cards:Bank1:y
 * Credit Cards:Bank2
 * Credit Cards:Bank3
 * Loans
 * Tax Provision:2021
 * Tax Provision:2022
Basically, I want specific stacks for all of the credit cards, but only
the total of the other categories.

Currently, if in the report account selection I pick the higher level
account, nothing is shown on the report, probably because it's not
considering the subaccounts.  If I click the "Select Children" button,
then it goes and shows all subaccounts with each subaccounts with one
stack (which is the "detailed" variant that I do want in the other
case).


I'm using gnucash 4.8, I'd be glad if anybody can show me if and how to
accomplish my goal! :)
Thank you in advance!

-- 
regards,
Mattia Rizzolo

GPG Key: 66AE 2B4A FCCF 3F52 DA18  4D18 4B04 3FCD B944 4540  .''`.
More about me:  https://mapreri.org : :'  :
Launchpad user: https://launchpad.net/~mapreri  `. `'`
Debian QA page: https://qa.debian.org/developer.php?login=mattia  `-
___
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] Short-Term Capital Gains question - Entering Mutual Fund or EFT Distribution

[D. via gnucash-user]

Art, 

I'm no accountant, and I'm only speaking from my own experience. 

I have similar holdings and reporting. For my purposes, I track dividends,  
LTCG and STCG in separate accounts by brokerage.  That way, I can match my 
accounts against the EOY reports issued by the brokerages and track down my 
inevitable errors. 

So, essentially (my actual structure is different, but the principle holds) :
Income
- Broker A
- - Dividends
- - LTCG
- - STCG
- Broker B
- - Dividends
- - LTCG
- - STCG

etc. This works especially well for stock accounts, but also works for mutual 
funds and ETFs.

For tax purposes, you can assign different accounts to the same tax line as 
needed and then run the TXF report. The TXF report (without transaction detail) 
quickly shows me what I need for the IRS. 

This approach gives flexibility for tracking things while allowing 
summarization. 

HTH,
David T. 


 Original Message 
From: Art Chimes 
Sent: Fri Jan 21 13:42:42 EST 2022
To: Gnucash Users 
Subject: [GNC] Short-Term Capital Gains question - Entering Mutual Fund or EFT 
Distribution

Most of my mutual funds and exchange-traded funds distribute earnings
in three categories — dividends, short-term capital gains, and
long-term capital gains.

In the U.S., LTCG are profits from the sale of securities one year or
more after purchase, and they are taxed at a favorable rate. STCG are
profits from securities held for a shorter period of time, and they are
taxed (usually? always?) at the higher ordinary income rate — same
as salary or dividends.

Statements from brokers and mutual fund companies carefully assign
distributions to one of these three categories.

This confuses many people because for tax purposes the STCG amounts are
lumped in with dividends on Schedule B, as opposed to Schedule D,
where LTCG (frequently referred to as just plain "capital gains") are reported.
There may be exceptions; I don't know.

Since STCG are combined with dividends at tax-reporting time, is
there any need to use a STCG-only Income account in Gnucash, or can
one safely put dividends and short-term capital gains in the same
"dividend" income account?

I suppose it might be considered poor accounting practice, but I'm
asking as a non-professional who just uses this software to keep track
of my personal finances and help me at tax time, which is
fast-approaching.

If there is a reason to maintain a separate STCG income accounts,
please enlighten me as to why and when it would be helpful.

If it matters, I use GnuCash 4.9 on Windows 10 Home.

Thanks to all in the GnuCash community

~Art~
___
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] Exiting GNUCash

[D. via gnucash-user]

Odd. On my machine, it all works as expected. Save, Cancel, and Close without 
Saving. 

Any chance you might try a reinstallation?


 Original Message 
From: Gyle McCollam 
Sent: Tue Jan 18 14:27:56 EST 2022
To: "D." , "gnucash-user@gnucash.org" 

Subject: Re: Re: [GNC] Exiting GNUCash

First, I would like to say that when I was referring to clicking the "x" it was 
for GNUCash, which the brings up the dialog for "Save/Close without 
Saving/Cancel".  However, if I click the cancel button it "crashes" as well.  
Also, even if I click the Save, it does the same thing.  All instances "crash" 
GNUCash and any entries not saved since the last automatic save are lost.  I 
also feel it has nothing to do with OneDrive as it worked fine until this last 
problem.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

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


From: D. 
Sent: Tuesday, January 18, 2022 1:46 PM
To: David Carlson 
Cc: Gyle McCollam ; D. via gnucash-user 

Subject: Re: [GNC] Exiting GNUCash

David,

That's off topic. And I don't use OneDrive. Better to start a different topic.

David T.

From: David Carlson
Sent: Tue Jan 18 13:42:16 EST 2022
To: "D."
Cc: Gyle McCollam , "D. via gnucash-user"
Subject: Re: [GNC] Exiting GNUCash

David T,

Is One Drive able to hide all the file system lags that it introduces from 
programs like GnuCash?  If so, I need to consider using it.  That is why I am 
asking for more comments here.

On Tue, Jan 18, 2022, 12:11 PM D. < 
sunfis...@yahoo.com<mailto:sunfis...@yahoo.com>> wrote:
David,

What Gyle is describing has nothing to do with OneDrive. Gnucash shouldn't exit 
the program when he closes the "Save/Close without Saving/Cancel" dialog box by 
clicking the "X" for the dialog-- and it sure shouldn't leave the lock file in 
place when it does so. That the lock file still exists supports the idea of a 
crash.

Gyle: what happens if you click Cancel?

David T.

From: David Carlson
Sent: Tue Jan 18 12:01:53 EST 2022
To: Gyle McCollam
Cc: " gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>"
Subject: Re: [GNC] Exiting GNUCash


That is an issue with the way you have your file system organized, but it
is not necessarily bad or wrong, just an artifact, I think.  I do not use
OneDrive or equivalent yet myself because I have not decided how to manage
that very issue of the lag while background updates are happening to my
data file storage system.

You are getting that lock warning because your OneDrive has not caught up
with you yet.  If you open anyway, you are burdening the OneDrive with more
work to keep the data intact, and I do not know if it can handle that, thus
I do not try it.  Perhaps other users of that type of arrangement can give
us their experience.That is probably also the cause of the Save Changes
warning.  That may actually lose your recent work just as warned.  Again,
perhaps others have experience with OneDrive.

On Tue, Jan 18, 2022 at 10:38 AM Gyle McCollam 
mailto:gmccol...@live.com>> wrote:




  David, Hopefully I can clarify what is happening.  I did not abandon an

 edit.  I finished an entry, but clicked on the "x" to shutdown before

 saving.  Included is a screenshot of a test entry that was completed (see

 last line).  Then, I clicked on the "x" to shutdown and the dialogue popped

 up.

 I seem to remember that "cancel" brought you back into GNUCash and "save"

 atctually save the current state of the file.  Now, it doesn't matter which

 option I choose it, I think it crashes GNUCash.  Then on the next startup

 it tells me:



 I select "Open Anyway" and the test entry is gone.  I hope this make it

 more clear.





 Thank You,

 *Gyle McCollam*



 Gyle McCollam



 609.680.2326 Mobile




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






 *From:* David Carlson <
 david.carlson@gmail.com<mailto:david.carlson@gmail.com>>

 *Sent:* Monday, January 17, 2022 8:46 PM

 *To:* Gyle McCollam <
 gmccol...@live.com<mailto:gmccol...@live.com>>

 *Cc:*
 gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <
 gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>>

 *Subject:* Re: [GNC] Exiting GNUCash



 It is not clear what you think happened.  It seems that more than one

 thing did not transpire as you expected, since abandoning an edit, the

 presumed cause of the shutdown without saving warning, and the attempt to

 open a file already in use are differen

Re: [GNC] Exiting GNUCash

[D. via gnucash-user]

David, 

That's off topic. And I don't use OneDrive. Better to start a different topic. 

David T.


 Original Message 
From: David Carlson 
Sent: Tue Jan 18 13:42:16 EST 2022
To: "D." 
Cc: Gyle McCollam , "D. via gnucash-user" 

Subject: Re: [GNC] Exiting GNUCash

David T,

Is One Drive able to hide all the file system lags that it introduces from
programs like GnuCash?  If so, I need to consider using it.  That is why I
am asking for more comments here.

On Tue, Jan 18, 2022, 12:11 PM D.  wrote:

> David,
>
> What Gyle is describing has nothing to do with OneDrive. Gnucash shouldn't
> exit the program when he closes the "Save/Close without Saving/Cancel"
> dialog box by clicking the "X" for the dialog-- and it sure shouldn't leave
> the lock file in place when it does so. That the lock file still exists
> supports the idea of a crash.
>
> Gyle: what happens if you click Cancel?
>
> David T.
> --
> *From:* David Carlson
> *Sent:* Tue Jan 18 12:01:53 EST 2022
> *To:* Gyle McCollam
> *Cc:* "gnucash-user@gnucash.org"
> *Subject:* Re: [GNC] Exiting GNUCash
>
> That is an issue with the way you have your file system organized, but it
> is not necessarily bad or wrong, just an artifact, I think.  I do not use
> OneDrive or equivalent yet myself because I have not decided how to manage
> that very issue of the lag while background updates are happening to my
> data file storage system.
>
> You are getting that lock warning because your OneDrive has not caught up
> with you yet.  If you open anyway, you are burdening the OneDrive with more
> work to keep the data intact, and I do not know if it can handle that, thus
> I do not try it.  Perhaps other users of that type of arrangement can give
> us their experience.That is probably also the cause of the Save Changes
> warning.  That may actually lose your recent work just as warned.  Again,
> perhaps others have experience with OneDrive.
>
> On Tue, Jan 18, 2022 at 10:38 AM Gyle McCollam  wrote:
>
>  David, Hopefully I can clarify what is happening.  I did not abandon an
>>  edit.  I finished an entry, but clicked on the "x" to shutdown before
>>  saving.  Included is a screenshot of a test entry that was completed (see
>>  last line).  Then, I clicked on the "x" to shutdown and the dialogue popped
>>  up.
>>  I seem to remember that "cancel" brought you back into GNUCash and "save"
>>  atctually save the current state of the file.  Now, it doesn't matter which
>>  option I choose it, I think it crashes GNUCash.  Then on the next startup
>>  it tells me:
>>
>>  I select "Open Anyway" and the test entry is gone.  I hope this make it
>>  more clear.
>>
>>
>>  Thank You,
>>  *Gyle McCollam*
>>
>>  Gyle McCollam
>>
>>  609.680.2326 Mobile
>>
>>  gmccol...@live.comemail
>> --
>>
>>  *From:* David Carlson 
>>  *Sent:* Monday, January 17, 2022 8:46 PM
>>  *To:* Gyle McCollam 
>>  *Cc:* gnucash-user@gnucash.org 
>>  *Subject:* Re: [GNC] Exiting GNUCash
>>
>>  It is not clear what you think happened.  It seems that more than one
>>  thing did not transpire as you expected, since abandoning an edit, the
>>  presumed cause of the shutdown without saving warning, and the attempt to
>>  open a file already in use are different events.
>>  Then how did you ascertain that, in fact, GnuCash did not save.  What,
>>  exactly did it not save?  Did you allow sufficient time for GnuCash to
>>  actually complete the entire shutdown?  Sometimes it takes a really long
>>  time to shut down.  For example, when Linux decides to put some of
>>  GnuCash's virtual RAM onto hard drive swap space, it may take over a minute
>>  for the OS to recover and close the open file.
>>
>>
>>
>>  On Mon, Jan 17, 2022 at 6:04 PM Gyle McCollam  wrote:
>>
>>  I usually don't forget to save first so I don't know how long this has
>>  been happening.  Today I didn't save, so when the dialogue box came up, I
>>  selected "cancel".  GNUCash shutdown without saving and when I tried to
>>  open it thought there was another instance running, but I said open
>>  anyway.  I tested this again with the same result.  Then I tried it again,
>>  this time telling the system to save.  It shut down again, but it did not
>>  save!  I got the same message about the file already in use.
>>
>>  Has anyone else encounter this error?  I am using Win11 and GNUCash 4.9.
>>
>>
>>  Than

Re: [GNC] Exiting GNUCash

[D. via gnucash-user]

David, 

What Gyle is describing has nothing to do with OneDrive. Gnucash shouldn't exit 
the program when he closes the "Save/Close without Saving/Cancel" dialog box by 
clicking the "X" for the dialog-- and it sure shouldn't leave the lock file in 
place when it does so. That the lock file still exists supports the idea of a 
crash. 

Gyle: what happens if you click Cancel? 

David T.


 Original Message 
From: David Carlson 
Sent: Tue Jan 18 12:01:53 EST 2022
To: Gyle McCollam 
Cc: "gnucash-user@gnucash.org" 
Subject: Re: [GNC] Exiting GNUCash

That is an issue with the way you have your file system organized, but it
is not necessarily bad or wrong, just an artifact, I think.  I do not use
OneDrive or equivalent yet myself because I have not decided how to manage
that very issue of the lag while background updates are happening to my
data file storage system.

You are getting that lock warning because your OneDrive has not caught up
with you yet.  If you open anyway, you are burdening the OneDrive with more
work to keep the data intact, and I do not know if it can handle that, thus
I do not try it.  Perhaps other users of that type of arrangement can give
us their experience.That is probably also the cause of the Save Changes
warning.  That may actually lose your recent work just as warned.  Again,
perhaps others have experience with OneDrive.

On Tue, Jan 18, 2022 at 10:38 AM Gyle McCollam  wrote:

> David, Hopefully I can clarify what is happening.  I did not abandon an
> edit.  I finished an entry, but clicked on the "x" to shutdown before
> saving.  Included is a screenshot of a test entry that was completed (see
> last line).  Then, I clicked on the "x" to shutdown and the dialogue popped
> up.
> I seem to remember that "cancel" brought you back into GNUCash and "save"
> atctually save the current state of the file.  Now, it doesn't matter which
> option I choose it, I think it crashes GNUCash.  Then on the next startup
> it tells me:
>
> I select "Open Anyway" and the test entry is gone.  I hope this make it
> more clear.
>
>
> Thank You,
> *Gyle McCollam*
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.comemail
> --
> *From:* David Carlson 
> *Sent:* Monday, January 17, 2022 8:46 PM
> *To:* Gyle McCollam 
> *Cc:* gnucash-user@gnucash.org 
> *Subject:* Re: [GNC] Exiting GNUCash
>
> It is not clear what you think happened.  It seems that more than one
> thing did not transpire as you expected, since abandoning an edit, the
> presumed cause of the shutdown without saving warning, and the attempt to
> open a file already in use are different events.
> Then how did you ascertain that, in fact, GnuCash did not save.  What,
> exactly did it not save?  Did you allow sufficient time for GnuCash to
> actually complete the entire shutdown?  Sometimes it takes a really long
> time to shut down.  For example, when Linux decides to put some of
> GnuCash's virtual RAM onto hard drive swap space, it may take over a minute
> for the OS to recover and close the open file.
>
>
>
> On Mon, Jan 17, 2022 at 6:04 PM Gyle McCollam  wrote:
>
> I usually don't forget to save first so I don't know how long this has
> been happening.  Today I didn't save, so when the dialogue box came up, I
> selected "cancel".  GNUCash shutdown without saving and when I tried to
> open it thought there was another instance running, but I said open
> anyway.  I tested this again with the same result.  Then I tried it again,
> this time telling the system to save.  It shut down again, but it did not
> save!  I got the same message about the file already in use.
>
> Has anyone else encounter this error?  I am using Win11 and GNUCash 4.9.
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com   email
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
> --
> David Carlson
>


-- 
David Carlson




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

Re: [GNC] I don't understand this IRA distribution solution

[D. via gnucash-user]

Looking at that thread, I believe that the crucial points are these:

1) You need to isolate the tax deferred income as you go. So, for example, you 
have $2000 gross income on a paycheck, of which $250 is deposited into your 
IRA. The payroll transaction will need to have separate entries of $1750 Income 
and $250 deferred income, each going into their asset account. 

2) When you take a distribution, there will be two balanced entries-- one from 
the IRA asset account to your checking account, and a second one with the same 
amounts from the deferred income account to your taxed income account. So, 
$250 cr IRA, $250 dr Checking
$250 dr Taxable $250 cr deferred income

Note that I am not an accountant, and I may have it wrong (especially the whole 
dr/cr thing)

But that's how I understand that. 

HTH,
David T.



 Original Message 
From: Morris Beavers 
Sent: Mon Jan 17 17:16:07 EST 2022
To: gnucash-user@gnucash.org
Subject: [GNC] I don't understand this IRA distribution solution

I am an ex-quicken user, with no formal accounting training (only
gnucash manuals).

I hope to track money between my banking accounts, identify who is
receiving payments, and budget (income >= expense).

I started by using the wizard for common + investment accounts.

I didn’t see a problem until my investments generated an IRA distribution
with money to federal, state, and checking. I didn’t want to record the
federal, state deductions as an actual cash expense so I created an
“Investment Expense” root expense account to track the payments.

Now a new year has started and I’m trying to reuse my account tree but I
can not identify why the budget income is not reporting the sum of the
income sub-accounts.

Thinking my IRA distribution solution was the root of the problem I found
in gnucash-user “Accounting Treatment of Taxable IRA Distributions” thread.
There is a statement of a solution which I do not understand, “How did you
open your books? I bet your opening transaction had the balancing amount of
that IRA lumped into equity. But you should instead had it as a "deferred
income" under equity (a child). The equity total still correct, but now it
becomes easy for you to "undefer" that income as you take a distribution.
Understand? The distribution has TWO effects. One is to reduce the IRA
balance as it increases money in your checking account. The second is to
"undefer" that amount of income, reduce "deferred" and increase current
income (your regular income account).”

Would someone please explain this solution as accounts and transactions?

Thanks, very much,
Morris
___
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]

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_CONFIG_HOME

Cheers David

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

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
> 

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-user@

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] 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] 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] 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] 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] 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] 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]

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]

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] 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:

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] 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/Income Statement to use the report Option to filter 
based on various fields like the Transaction Report can. (the included 
P 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] 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] 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] 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] 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] 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] 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] 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]

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] 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] 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=C=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 Nabble or 

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] 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] 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] 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] 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] 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] 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 

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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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 

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 

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] 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] 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] 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] 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] 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:
> 

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=lnt=qdr:y=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] 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] 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] 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 

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 

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 

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.