Re: [GNC] No suitable backend was found

[David T. via gnucash-user]

I'll echo Adrien's comments regarding your use of a backup. 

On the reported problem, I'll note that your book file appears to be on a cloud 
drive ("OneDrive") and perhaps your connection to the cloud has been 
interrupted? You could test this by copying the data file to a known local 
folder on your hard drive...

⁣David T.​

On Jan 26, 2024, 10:36 AM, at 10:36 AM, Adrien Monteleone 
 wrote:
>That message is usually indicating you have the file saved in a
>database 
>format rather than the default XML, and you don't have the proper 
>database drivers installed. If you recently tried to save your file in 
>one of those formats, this could be the cause. If not, then someone
>else 
>might have some ideas. (I personally don't regularly use Windows and 
>even then, not with GnuCash, sorry.)
>
>Additionally, your error message shows the filename of your book you
>are 
>trying to open, and that reflects you are trying to open a backup of a 
>book called "send".
>
>How did you start GnuCash? Did you launch the app from an application 
>shortcut, or did you attempt to double-click the file you wanted to
>open?
>
>If the latter, try just launching GnuCash by itself, as it will always 
>open the last used file. (assuming that is the file you want)
>
>You may have also just accidentally double-clicked on the wrong file. 
>But if that is your book, or you think it is, and it is the one you've 
>been working in, then you might have a problem in that it is a backup, 
>not the original file. Double check that its last modified date is 
>1/24/2016 at 5:09pm. If the modified time is more recent, then you've 
>been working in that backup file. The numbers in that file name
>indicate 
>it was created as a backup on 1/24/2016 at 17:09:05 and the original 
>file was named 'send'.
>
>The problem with working in a backup file is that if you *also* were 
>sometimes working in the original file, the two have now diverged and
>do 
>not contain the same transactions. If you've ever notice that it seemed
>
>transactions you thought you entered were missing, that would be a sign
>
>you were working in two different files each time. If that turns out to
>
>be the case (I hope not!) it can be resolved, but will take some time 
>and tedious work depending on how much divergence there is between the 
>two files.
>
>Regards,
>Adrien
>
>On 1/21/24 9:18 AM, pwen...@gmail.com wrote:
>> Received message "No suitable backend was found for {file
>> path\filename.gnucash}.  Have been using Gnucash and this file for
>years.
>> Suddenly, I get the no suitable backend message, and I am not able to
>open
>> the file.  Would really appreciate any guidance to restore this file!
> Thx!
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to record tax credit for capital loss

[David T. via gnucash-user]

Ah. I missed the carryover part. That does complicate things. Sorry for the 
noise. 

⁣David T.​

On Jan 24, 2024, 6:55 PM, at 6:55 PM, Mattia Rizzolo  wrote:
>Here we don't do LT/ST, but it's only possible to offset losses up to
>the end of the 4th year after the loss was realized.  Meaning that 2019
>losses are now in stone.  Besides, one offests losses by fist pickin
>the
>furtherst year first, so it's good to know how much is left to offset
>from each given year for each broker (it's common practice in Q4 to
>look
>at what's left over from 3-4 years before and evaluate what to do to
>not
>lose the credit).
>
>See the screenshot of what I got right now, for example.
>Wouldn't obtaining these numbers, by putting both losses and gains in
>the same bucket and then using the standard-provided reports, be
>unnecessarily hard?
>
>
>Again, note that I'm not using this to compute my own taxes, that's
>done
>by the brokers already (I'm nowhere near the volume where it would make
>sense for me to take over that "job" - which I could fwiw), but I do
>want my data to match theirs.
>
>
>On Wed, Jan 24, 2024 at 06:32:08PM +0300, David T. via gnucash-user
>wrote:
>> Likewise not an accountant. 
>> 
>> In the US (my tax authority), gains are taxed at two rates (long term
>and short term), and gains and losses offset each other. I maintain
>separate income accounts for short term and long term gains/losses
>(income accounts because I'm an optimist!). These are placed in parent
>accounts for the brokerage (since each broker sends its own tax
>reports). There's no need to separate by year, since a saved report
>gives me last year's data instantly. 
>> 
>> To summarize:
>> 
>> Income
>>   - Realized gains
>>   - - Broker 1
>>   - - - LT gains
>>   - - - ST gains
>>   - - Broker 2
>>   - - - LT gains
>>   - - - ST gains
>> 
>> ⁣David T.​
>> 
>> On Jan 24, 2024, 5:22 PM, at 5:22 PM, Patrick James
> wrote:
>> >Again keeping in mind that I am NOT a tax authority.
>> >
>> >Now that we're on the equity side, let's move forward with your
>> >tracking.
>> >
>> >I very much doubt that you need two separate accounts for the losses
>> >and gains; from what you're suggesting, you need to match some gains
>> >with some losses. I would match these in a single account "
>Capital
>> >Gains" where it is known that CR is "gain" (the expected/desired
>> >'normal' balance) and DR is "loss." Just labeling an account
>"Capital"
>> >is difficult when looking back/keeping track of what is what. And
>one
>> >need not label it "Capital Gain or Loss," as the "or loss" part is
>> >understood based on the balance in the account.
>> >
>> >Given what you are requesting, I'd have something like this:
>> >
>> >Capital Gain
>> >2017 Broker 1
>> >2017 Broker 2
>> >2018 Broker 1
>> >2018 Broker 2
>> >
>> >You would know what is best in terms of subaccounts.
>> >
>> >Then run reports if you need some specific information, which could
>> >include separating the losses from the gains based on the debits and
>> >credits.
>> >
>> >Keep in mind that I'm providing some ideas about how to use GNUCash
>as
>> >a tool, and I have no idea about your tax requirements.
>> >
>> >
>> >> On 01/24/2024 3:11 AM PST Mattia Rizzolo 
>wrote:
>> >> 
>> >>  
>> >> Thank you Patrick for your suggestion!
>> >> 
>> >> I see what you are suggesting here… Mh.
>> >> 
>> >> It could easily become very messy as the rules for offsetting
>gains
>> >is
>> >> fairly annoying here: gains some financial instruments can offset
>> >losses
>> >> only from some other particular financial instruments (i.e.,
>"gains"
>> >> from the dividends can *never* be offeset, or losses from stocks
>> >can't
>> >> be offset by gain on ETFs, etc)…  Plus the fact that I'd need to
>> >split
>> >> losses by years and brokers… it's going to be annoying to have an
>> >> account clearly state the "correct" credit I'm due this way.
>> >> 
>> >> 
>> >> But I think you may have pointed me to the right direction, of
>> >keeping
>> >> everything within the equities, here is what I've done:
>> >> (yes, I realize that income/expenses ar

Re: [GNC] how to record tax credit for capital loss

[David T. via gnucash-user]

Likewise not an accountant. 

In the US (my tax authority), gains are taxed at two rates (long term and short 
term), and gains and losses offset each other. I maintain separate income 
accounts for short term and long term gains/losses (income accounts because I'm 
an optimist!). These are placed in parent accounts for the brokerage (since 
each broker sends its own tax reports). There's no need to separate by year, 
since a saved report gives me last year's data instantly. 

To summarize:

Income
  - Realized gains
  - - Broker 1
  - - - LT gains
  - - - ST gains
  - - Broker 2
  - - - LT gains
  - - - ST gains

⁣David T.​

On Jan 24, 2024, 5:22 PM, at 5:22 PM, Patrick James 
 wrote:
>Again keeping in mind that I am NOT a tax authority.
>
>Now that we're on the equity side, let's move forward with your
>tracking.
>
>I very much doubt that you need two separate accounts for the losses
>and gains; from what you're suggesting, you need to match some gains
>with some losses. I would match these in a single account " Capital
>Gains" where it is known that CR is "gain" (the expected/desired
>'normal' balance) and DR is "loss." Just labeling an account "Capital"
>is difficult when looking back/keeping track of what is what. And one
>need not label it "Capital Gain or Loss," as the "or loss" part is
>understood based on the balance in the account.
>
>Given what you are requesting, I'd have something like this:
>
>Capital Gain
>2017 Broker 1
>2017 Broker 2
>2018 Broker 1
>2018 Broker 2
>
>You would know what is best in terms of subaccounts.
>
>Then run reports if you need some specific information, which could
>include separating the losses from the gains based on the debits and
>credits.
>
>Keep in mind that I'm providing some ideas about how to use GNUCash as
>a tool, and I have no idea about your tax requirements.
>
>
>> On 01/24/2024 3:11 AM PST Mattia Rizzolo  wrote:
>> 
>>  
>> Thank you Patrick for your suggestion!
>> 
>> I see what you are suggesting here… Mh.
>> 
>> It could easily become very messy as the rules for offsetting gains
>is
>> fairly annoying here: gains some financial instruments can offset
>losses
>> only from some other particular financial instruments (i.e., "gains"
>> from the dividends can *never* be offeset, or losses from stocks
>can't
>> be offset by gain on ETFs, etc)…  Plus the fact that I'd need to
>split
>> losses by years and brokers… it's going to be annoying to have an
>> account clearly state the "correct" credit I'm due this way.
>> 
>> 
>> But I think you may have pointed me to the right direction, of
>keeping
>> everything within the equities, here is what I've done:
>> (yes, I realize that income/expenses are "the same thing")
>> 
>> Expenses
>>  |- Capital Loss
>> |- Broker 1
>> |- 2017
>> |- 2020
>> |- 2021
>> |- 2023
>> Income
>>  |- Capital Gain
>> 
>> So, I changed my losses to be posted against the proper "capital
>loss"
>> account instead of being a negative gain, and then I'm posting the
>> future gains as compensation of that loss (and only for the part that
>> can be compensated).
>> This way indeed the balance of the Broker1 account does match with
>what
>> the broker is showing me.
>> 
>> 
>> Do anybody believe I may be missing something out when recording
>capital
>> gains/losses this way?
>> 
>> 
>> On Tue, Jan 23, 2024 at 03:43:03PM -0800, Patrick James wrote:
>> > Let's start with your best bet is to work with your tax
>professional as to how best to keep track of what's needed for taxes.
>> > 
>> > In the US, what you call a "credit" generally would not be an asset
>account. The "credit" would be a potential offset to some future gain,
>if there is any future gain, so I would leave all this over on the
>equity side.
>> > 
>> > Day 0 Purchase:
>> > 
>> > Stock (asset) $100DR
>> > Cash $100CR
>> > Purchase of 100 shares of Stock Y for $1 per share
>> > 
>> > Day 365 Sale:
>> > 
>> > Cash $90DR
>> > Capital Gain $10DR
>> > Stock (asset) $100CR
>> > Sale of 100 shares of Day 0 Stock Y for $0.90 per share.
>> > 
>> > NOTE: One hopes that capital gains has a CR (gain) balance, rather
>than the DR balance above (loss).
>> > 
>> > Later, if there was some sale for a gain, then the CR recorded to
>Capital Gain would offset some or all of the DR.
>> > 
>> > Also note that matching the shares as I have done above is not
>always as simple as this single stock sale where all shares are
>purchased on a single day and the entire holding is sold a year later.
>> > 
>> > Again, talk to your tax professional about how to best keep the
>records necessary for tax compliance.
>> > 
>> > 
>> > > On 01/23/2024 1:43 PM PST Mattia Rizzolo 
>wrote:
>> > > 
>> > >  
>> > > Hello,
>> > > 
>> > > I'd like some input on how to best record a tax credit due to
>capital
>> > > loss, and possibly the following usage of such credit.
>> > > Disclaimer: I'm not doing this for anything worth, it's a
>personal book
>> > > that nobody 

Re: [GNC] Terminology WAS: Liability Balances - All payments disappeared

[David T. via gnucash-user]

The Gnucash community has had this discussion many times in the past. My 
recollection is that the following terminology is accepted:
* Each line is a "split," and thus a basic transaction has two such splits. 
* A transaction with more than two splits is referred to as a multi-split 
transaction. 

This terminology is not fully-agreed, but this is my recollection of those 
previous discussions. The best alternative terminology I recall was to use the 
word "entry" for what is now called a split, and reserve "split" for 
transactions with more than two entries. But that terminology has never been 
adopted by the community or in the documentation. 

⁣David T.​

On Jan 18, 2024, 8:02 PM, at 8:02 PM, Adrien Monteleone 
 wrote:
>Fair enough. We need a new term for one of these things. It is a 
>repeated source of confusion & consternation.
>
>Regards,
>Adrien
>
>On 1/18/24 9:54 AM, Michael or Penny Novack wrote:
>> Except I would never refer to a transaction that affect JUST TWO 
>> accounts to have any "splits". When I use the term "splits" I mean
>that 
>> either there is more than one debit account, more than one credit 
>> account, or both. ALL transactions involve at least two accounts, at 
>> least one debit and at least one credit. That is fundamental to
>double 
>> entry bookkeeping.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] FAQ (WAS: End of Year?)

[David T. via gnucash-user]

For the record, I'm also against this popup, but for a different reason. 

The FAQ is an overwhelming never-shrinking aggregation of items that would be 
better placed in other documentation. Including it on a monthly basis would not 
really benefit a new user with a specific problem. When I go to the FAQ, I am 
usually forced to do a find in the page to locate anything.

On a side rant, the fact that every year there is a spate of new users asking 
the same set of questions that are covered extensively in some form of the 
documentation underscores a disconnect that the community hasn't worked out. 

For whatever reason, the disconnect between how Gnucash is viewed by the 
outside world and how it actually works seems to cause a significant range of 
new user difficulties. 

⁣David T.​

On Jan 14, 2024, 1:23 AM, at 1:23 AM, Adrien Monteleone 
 wrote:
>Sorry, I would not like to see an FAQ pop up in this list on any 
>periodic basis.
>
>What you are describing there is akin to a 'sticky' or 'pinned' post in
>
>a web forum.
>
>This is not a web forum.
>
>We have the Wiki, which has the FAQ section. We also have the Help 
>Manual, and the Tutorial & Concepts Guide. Those are better places for 
>standard, regular advice on how to use the software. This list serves a
>
>different purpose — to offer assistance that those sources don't (maybe
>
>yet) cover.
>
>Some redesign of the website pointing to the FAQ might be in order, but
>
>that would take some careful analysis, and of course, someone to code 
>the changes.
>
>Regards,
>Adrien
>
>On 1/13/24 11:19 AM, R Losey wrote:
>> But the larger issue is that I believe this email list could benefit
>from a
>> FAQ that is posted monthly or every other month to this group. The
>wiki has
>> some neat ideas about tracking year to year equity growth.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

[David T. via gnucash-user]

Thanks all for the discussion. I can rest easy knowing that this is how the SX 
editor works. It just took me by surprise...

⁣David T.​

On Jan 12, 2024, 7:09 PM, at 7:09 PM, David Carlson 
 wrote:
>I consider the SX to be a graphical form of a script, and so I am not
>sure
>how the editor could detect what is safe to call an expression that
>could
>be evaluated while it is being edited.
>
>
>
>On Fri, Jan 12, 2024, 11:36 AM Adrien Monteleone <
>adrien.montele...@lusfiber.net> wrote:
>
>> What I meant was it would indeed be nice that the SX Template entry
>> allowed you to do math like a register does.
>>
>> I never meant to imply that one could edit the code from within the
>app!
>>
>> Regards,
>> Adrien
>>
>> On 1/12/24 11:27 AM, David Carlson wrote:
>> > I beg to differ.  Executing code while editing it would be an
>invitation
>> to
>> > disaster.
>> >
>> > On Fri, Jan 12, 2024 at 10:25 AM Adrien Monteleone <
>> > adrien.montele...@lusfiber.net> wrote:
>> >
>> >> Indeed, I should have tested it prior to commenting.
>> >>
>> >> Apologies for the noise.
>> >>
>> >> At the very least, being able to do math here with a result would
>be a
>> >> good RFE.
>> >>
>> >> I would only expect formulas to remain as formulas if they contain
>> >> variables which require a prompt for value.
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

[David T. via gnucash-user]

I'll look into these options. I just have it in my head that the point of a 
scheduled transaction is to save me from having to remember to create a 
transaction, and if I have to remember to run the SLR in order to have them 
created, then I've just changed the work, not reduced it. 

But thanks for some alternatives to try!

⁣David T.​

On Jan 11, 2024, 8:51 PM, at 8:51 PM, Adrien Monteleone 
 wrote:
>That sounds like you have an SX to autocreate. Perhaps turn that off
>and 
>it won't fire.
>
>Otherwise, perhaps turn off the preference to execute the Since Last
>Run 
>dialog on startup. You can still run it manually to fire any pending 
>SXs, but otherwise, not have it bother you if you just want to pop in 
>and out to check a balance.
>
>Another option (which I use for other reasons) is to simply leave 
>GnuCash open 24/7. That lets me see and do whatever I want, and I just 
>run the SLR periodically to fire my SXs. (Oddly, there is no 'watcher' 
>that fires them when the system date should otherwise trigger them)
>
>Regards,
>Adrien
>
>On 1/11/24 3:36 PM, David T. via gnucash-user wrote:
>> I've found the "Prompt for value" option with SXes to be downright
>annoying.
>> 
>> I go to Gnucash to check the balances in a savings account, and the
>SX dialog pops up asking me for a dollar amount for my electric bill
>(and won't seem to let me just click past). Inevitably, I just put in
>any old number-- defeating the whole purpose of that feature.
>> 
>> So, I've opted to have balanced transactions that may be off, which I
>correct when I reconcile the account. But then, I had to change some
>figures in one complex SX, and it didn't supply the balancing split.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

[David T. via gnucash-user]

I am pretty sure I tried that, but it didn't actually do the calculation in the 
SX window. Which makes sense, I think, because that window allows formulas that 
get processed at runtime. 

⁣David T.​

On Jan 11, 2024, 8:46 PM, at 8:46 PM, Adrien Monteleone 
 wrote:
>You don't have to do it in your head.
>
>While an extra step compared to normal registers, you can still do math
>
>on a split.
>
>When entering that balancing split, enter the amount as a sum formula. 
>(split one amount + split two amount, etc.) GnuCash will give you the 
>overall sum.
>
>Regards,
>Adrien
>
>On 1/11/24 2:55 PM, David T. via gnucash-user wrote:
>> I understand that there might be use cases in scheduled transactions
>where one might not want an automatic calculation, but is there a way
>to invoke it without manually adding up all the amounts in my head?
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Template Transactions Behavior in Scheduled Transaction Editor

[David T. via gnucash-user]

I've found the "Prompt for value" option with SXes to be downright annoying.

I go to Gnucash to check the balances in a savings account, and the SX dialog 
pops up asking me for a dollar amount for my electric bill (and won't seem to 
let me just click past). Inevitably, I just put in any old number-- defeating 
the whole purpose of that feature. 

So, I've opted to have balanced transactions that may be off, which I correct 
when I reconcile the account. But then, I had to change some figures in one 
complex SX, and it didn't supply the balancing split.

David T.​

On Jan 11, 2024, 8:17 PM, at 8:17 PM, "Stan Brown (using GC 4.14)" 
 wrote:
>On 2024-01-11 12:55, David T. via gnucash-user wrote:
>> Long time user working in Windows 10 with Gnucash 4.13. 
>> 
>> I have a number of scheduled transactions that I use; one of them
>> has multiple splits. With the new year, I needed to update this
>> scheduled transaction. I began modifying the amounts on different
>> lines of the transaction, and when I got to entering the contra
>> account against which all the other splits would balance, I was
>> surprised to find that the automatic calculation feature of Gnucash
>> registers was not active. I understand that there might be use cases
>> in scheduled transactions where one might not want an automatic
>> calculation, but is there a way to invoke it without manually adding
>> up all the amounts in my head?
>
>I've noticed that too. I'm not aware of any workaround. (Another
>difference is that if you enter an amount with fewer decimal places
>that
>appropriate for your currency, the SX editor does not fill in zeroes.
>They _are_ filled in when the transaction fires.)
>
>The SX editor doesn't force you to balance the transaction. I haven't
>tried this, but why not just leave it unbalanced, and when the
>transaction fires you'll have a split for Imbalance. You can then
>change
>that to the desired account.
>
>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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Template Transactions Behavior in Scheduled Transaction Editor

[David T. via gnucash-user]

Hello, 

Long time user working in Windows 10 with Gnucash 4.13. 

I have a number of scheduled transactions that I use; one of them has multiple 
splits. With the new year, I needed to update this scheduled transaction. I 
began modifying the amounts on different lines of the transaction, and when I 
got to entering the contra account against which all the other splits would 
balance, I was surprised to find that the automatic calculation feature of 
Gnucash registers was not active. I understand that there might be use cases in 
scheduled transactions where one might not want an automatic calculation, but 
is there a way to invoke it without manually adding up all the amounts in my 
head? 

⁣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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Starting a new year

[David T. via gnucash-user]

Grace might also look at https://wiki.gnucash.org/wiki/Closing_Books

⁣David T.​

On Jan 9, 2024, 8:27 PM, at 8:27 PM, Gyle McCollam  wrote:
>Grace,
>You can export your account tree in CSV format.  Look under
>"FILE/EXPORT".  If you "close  Books..." under tools it will simplify
>entering the starting balances for 2024.
>
>
>Thank You,
>
>Gyle McCollam
>
>Gyle McCollam
>
>gmccol...@live.com   email
>
>
>From: gnucash-user 
>on behalf of Grace 
>Sent: Tuesday, January 9, 2024 2:14 PM
>To: Gnucash Users 
>Subject: [GNC] Starting a new year
>
>Hello,
>
>I am just wondering how folks are dealing with starting a new year?
>
>Finishing 2023 I think is easy. You just stop using it.
>
>However, how do I start 2024 with the finishing balances of 2023? Do I
>have set up a brand new set of accounts, or is there a way of doing
>this
>that I have not found?
>
>Grace
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] posting of Switching of Mutual Fund

[David T. via gnucash-user]

Paras,

I used the lots feature for quite some time, and for a while I felt that it 
made my investments life so much easier. 

But. 

The day came when I had to change one capital gain entry that was off for some 
reason*. I changed it to the proper amount (as reported to the tax 
authorities), and moved on. 

Time passed. Reconciliations happened. I kept using the lots in the account on 
new accounts. And then the account wouldn't reconcile. Hours later, I 
discovered that the lots feature had "readjusted" my already-reconciled 
transaction back to what it believed was the correct number, all without any 
notice to me whatsoever. 

I will admit that the underlying issue was that I needed to change **which** 
lots were affected by a given sale, and that selecting the wrong lots (easy to 
do in a mutual fund where dividends are reinvested every so often, creating 
many small lots) would throw off the capital gains amounts. 

So, that's my fault for not understanding the accounting principles and 
transactions needed for recording capital gains. 

But any feature that's going to change reconciled transactions silently behind 
my back is simply not OK. 

So I do my capital gains transactions manually now. I need to be able to trust 
that the figures won't magically change on me. 

⁣David T.​

* the list discussion for all of this is at: 
https://lists.gnucash.org/pipermail/gnucash-user/2022-July/102059.html

On Jan 9, 2024, 3:11 PM, at 3:11 PM, Paras Desai  wrote:
>Hello Geoff,
>
>
>Firstly, I must salute you for your very methodical and illustrative 
>explanation. It is really heartening to see the kind of special efforts
>
>you put to first create the accounts, posting illustrative transactions
>
>yourself, taking screenshots and arranging them beautifully, so that
>one 
>can understand easily. My profound and heartfelt thanks to you.
>
>
>I adopted your second approach, as I need to report the taxable STCG. 
>However, I took little different approach by splitting the transaction 
>manually following the examples in your screenshot, and every thing
>fell 
>in place, closing balance of both the Mutual Funds, their current 
>valuation, STCG in Income head, realized gain in Advance Portfolio 
>report. I need little practice before I scrub my portfolio 
>automatically, as it has many entries, and I was bit hesitant,  so I
>did 
>it manually but will certainly learn the same.
>
>
>Once again thanks a ton and wish you a very happy new years ahead
>
>
>My best regards to you Geoff.
>
>
>Paras
>
>
>
>*From: *Geoff [mailto:cleanoutmys...@gmail.com]
>*Sent: *Tuesday, January 09, 2024 05:32 AM +5.5
>*To: *Paras Desai; GnuCash User List
>*Subject: *[GNC] posting of Switching of Mutual Fund
>
>Hi Paras
>
>This is very easy to do in GnuCash, and it will even calculate the 
>prices and capital gains (or losses) for you.
>
>1. Use the Security Editor to create the Securities for both funds.
>2. Create the Accounts for the funds and link them to the Securities.
>3. Enter the Buy on Liquid - note how GNC calculates the Price.
>4. Enter the Sell on Liquid, with Equity as the second account.
>
>See attached "gnc_paras01.jpg" and note:
>A. Price Database is automatically updated
>B. Gain does not appear on any of your Accounts
>C. Balance Sheet shows your Capital Gain as "Unrealised"
>
>And that is all done and dusted...
>
>...unless you need to "realise" your capital gains(losses) as 
>Income(Expenses) as tax time.  If so, please read on.
>
>
>GnuCash has a sensational feature called Lots that is designed to track
>
>and realise your capital gains & losses, but it can be a bit daunting 
>for new users.
>
>1. Open the Account for Liquid Fund
>2. Actions -> View Lots
>3. In the Lots window, click on "Scrub Account"
>
>See attached "gnc_paras02.jpg" and note:
>A. New Capital Gain/Loss transaction in Liquid Fund
>B. Gain now shows in your Accounts***
>C. Balance Sheet shows your Gain as "Retained Earnings"
>
>*** By default, the GnuCash Lot Editor puts all Gains & Losses in an 
>account called "Orphaned Gains" - you need to edit the Gain transaction
>
>and assign it to the appropriate Account - in this example, "STCG".
>
>
>Hope this helps.
>
>Regards
>
>Geoff
>=
>
>
>On 9/01/2024 1:19 am, Paras Desai wrote:
>> Hello Sirs,
>>
>> I have an investment in a liquid Mutual fund and I every week 
>> systematically transfer some amount to an Equity Fund (which is STP)
>>
>> While doing so, there is an effect of Capital gain or Loss and the 
>> money does not come to any account, but the fund gets transferred to 
>> another fund automatically
>>
>> The Transaction is like below
>>
>> A. Liquid Fund : SWITCH OUT  (PRACTICALLY SALE)
>>
>>   Units 773.14, Purchase Cost : 9696.630, Sales realization is : 
>> 1, Short term Capital Gain is 303.370
>>
>> B. Equity Fund: SWITCH IN (PURCHASE)
>>
>>  Units : 75.684, Value: 10,000
>>
>> Here, Money does not come to my bank or security account
>>
>> Normal Posting could be
>>
>> Cr 

Re: [GNC] Moving from Quicken

[David T. via gnucash-user]

I will echo R Losey's comments but also add that over the years, I've used (and 
abandoned) the various download transactional data features in favor of manual 
entry. 

First, many institutions have become restrictive in their download offerings 
and refuse to consider anything outside the commercial banking software 
ecosystem. In the US, that means Intuit. 

Second, Gnucash allows rapid transaction input (by memorizing previous 
transactions and copying them in for you) that can speed data entry immensely. 
(Aside, I understand that recent updates of this feature have been a little 
controversial)

Third, downloaded data needs to be validated and confirmed by me, which takes 
time. 

As a consequence of all this, I have found that importing took more work than 
just biting the bullet and doing it by hand. 

For what it's worth, I'm tracking at least three checking accounts, three 
taxable investment accounts, six retirement accounts, four pension accounts, 
and two credit card accounts. 

And using Gnucash 4.12, because I'm slow to innovate. 

⁣David T.​

On Jan 9, 2024, 3:06 AM, at 3:06 AM, R Losey  wrote:
>We've just trained ourselves to enter the data manually. It IS possible
>to
>download into GC; I just haven't used it.
>
>You can create separate asset accounts -- we also have more than one
>checking account, and we just have them as separate accounts and enter
>the
>data separately.  You can name them whatever makes sense to you:
>"Barry's
>Business Checking", "Joint Checking", "Susan's Business Checking" --
>for
>example.
>
>If you mean in reports, all reports are configurable; most (if not all)
>of
>them allow you to choose the accounts on which to report.
>
>On Mon, Jan 8, 2024 at 11:33 AM barry milliken
>
>wrote:
>
>> Thanks for your answer.
>> When I said personal accounting I oversimplified.
>> My wife and I both have independent consulting businesses.
>> That means we have 3 bank accounts and six credit cards for a total
>of 9
>> "accounts" (transaction sources)
>> Managing downloads manually would be too cumbersome.
>> How does Gnucash allow me display my source accounts separately?
>> Thanks
>>
>>
>> Barry Milliken
>> --
>> *From:* R Losey 
>> *Sent:* Monday, January 8, 2024 11:17:58 AM
>> *To:* barry milliken 
>> *Cc:* gnucash-user@gnucash.org 
>> *Subject:* Re: [GNC] Moving from Quicken
>>
>> I, too, left Quicken about 8 years ago and changed to GnuCash. I had
>a
>> slight familiarity with double-entry accounting, and I've seldom had
>any
>> issues with GnuCash.
>>
>> I thought about importing Quicken data, but then decided against
>it... I
>> reasoned that if I really did need to reference something I had in
>Quicken,
>> I could open those files.  In fact, I think I opened Quicken two or
>three
>> times in the first couple of years, and haven't touched it since.
>It's just
>> something to think about.
>>
>> I had trouble getting the downloads from financial institutions to
>work,
>> so I do them manually and regularly reconcile. I don't really miss
>this
>> function, but it is possible.
>>
>> As you will have heard, GnuCash doesn't have "categories"; it has
>> "accounts". At the risk of offending a great multitude of GnuCash
>users,
>> from the practical point of view, GnuCash accounts are very much like
>> categories in Quicken. I know that they are not really the same
>thing, but
>> as a former Quicken user, they are.
>>
>> In my experience, the one thing I had trouble with in GnuCash were
>the
>> reports - most of them seem to need some kind of tweaking to get them
>to do
>> what is wanted. Here's another thing to think about: instead of
>assigning
>> accounts as "tax deductible", if you have an account whose
>transactions are
>> deductible (such as charitable giving, you can create a report for
>just
>> these accounts. You just need the discipline to only enter deductible
>items
>> in such accounts. I do know that there is a US tax setup feature, but
>I
>> haven't made  full use of that -- and the report using the accounts I
>want
>> to know about for tax reasons works well enough for my needs.
>>
>> RL
>>
>> On Sat, Jan 6, 2024 at 9:50 PM barry milliken
>
>> wrote:
>>
>> I've been frustrated using Quicken for years.  Maybe GNUcash will do
>what
>> I want.
>>
>> My list of functions is small:
>> I use Quicken for personal accounting, mainly to categorize
>transactions
>> for tax reporting.
>> Can GNUcash do these things:
>> - import data from a Quicken QDF file as a starting point.
>> - allow downloads of transactions from my bank accounts and credit
>cards.
>> - allow me to assign a category to each transaction.
>> - create categories (or import quicken categories) and assign each as
>tax
>> deductible or not.
>> - report and summarize tax deductible transaction at tax time.
>>
>> That's all I care about.
>>
>> Thanks
>>
>>
>> Barry Milliken
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org

Re: [GNC] Help

[David T. via gnucash-user]

I don't really know. I don't pay any attention to the log files. They're there 
if I ever need them, and seem to disappear after a reasonable time. 

⁣David T.​

On Jan 8, 2024, 10:18 PM, at 10:18 PM, Max Crystal  
wrote:
>
>
>
>
>
>
>
>
>David,
>
>As you can see, I checked never for backup log to never.  Am I doing
>something wrong?  It is still posting to my hard drive files every
>time.  I Have version 5.5
>
>
>
>
>
>
>
>
>
>From: David T. 
>Sent: Monday, January 8, 2024 12:55 PM
>To: Max Crystal 
>Cc: gnucash-user@gnucash.org
>Subject: Re: [GNC] Help
>
>
>
>That's handled in settings. You can disable by setting the log file
>retention to 0.
>
>David T.
>
>On Jan 8, 2024, at 9:05 PM, Max Crystal  > wrote:
>
>Every time I open and close the register it creates a notepad log entry
>on
>my hard drive.  Can I disable this so I will not have multiple entries
>every
>day.
>
>Max
>
>
>
>--
>This email has been checked for viruses by Avast antivirus software.
>www.avast.com
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Help

[David T. via gnucash-user]

That's handled in settings. You can disable by setting the log file retention 
to 0.

⁣David T.​

On Jan 8, 2024, 9:05 PM, at 9:05 PM, Max Crystal  
wrote:
>Every time I open and close the register it creates a notepad log entry
>on
>my hard drive.  Can I disable this so I will not have multiple entries
>every
>day.
>
>Max
>
>
>-- 
>This email has been checked for viruses by Avast antivirus software.
>www.avast.com
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issues with gnucash files

[David T. via gnucash-user]

Maf,

With regards to Nigel's comment, over the past month and a half, there have 
been well over a hundred messages sprinkled across eight different threads that 
seek to address the situation. At some point, it would seem that the problems 
cannot be solved through this venue. For me, that was about 40-50 messages ago. 

⁣David T. ​

On Aug 28, 2023, 2:02 PM, at 2:02 PM, "Maf. King"  wrote:
>On Monday, 28 August 2023 11:44:54 BST Adrien Monteleone wrote:
>> But I see the solution as moving it to the regular user account,
>fixing
>> the file ownership and permission flags, and then proceeding to clean
>up
>> the multiple file/backup file apparent mess.
>
>
>+1.
>
>get everything RW and into a folder in the "Barry" tree.   find the
>most 
>recently changed file(s) and go from there (in a new folder) with the
>save 
>issue. then Barry will have to clean up the inevitable missing txns
>that 
>were made in backup files only.
>
>@Nigel Stapley.   ISTR the user Mahon Finbar has been on the list for
>years, 
>only occasionally having problems which I think have been solved in the
>past 
>quite swiflty or easliy  (or not).   I think he is having genuine
>problems 
>just now.  However, I agree that the problems as presented seem
>somewhat wider 
>than just GC.
>
>Maf.
>
>
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Fwd: Gnucash

[David T. via gnucash-user]

+1

⁣David T.​

On Aug 28, 2023, 12:34 PM, at 12:34 PM, Nigel Stapley  
wrote:
>As a watcher of this list might I suggest you good folk call a halt. I
>suggest to OP that he takes a basic course in managing his computer
>with
>Windows. Someone who doesn't appear to understand what is meant by
>"logging
>in" needs assistance way beyond the remit of this list. Although
>increasingly it looks like a wind-up to me!
>Nigel
>
>On Mon, 28 Aug 2023 at 09:41, Mahon Finbar via gnucash-user <
>gnucash-user@gnucash.org> wrote:
>
>> OK, as I answered earlier on this thread, today, I use Thunderbird as
>my
>> email software. I use it as a specific application.
>>
>> "C:\Program Files (x86)\Mozilla Thunderbird\thunderbird.exe"
>>
>> BTW my issues with sending attachments starts with file manage and
>> specifically with gnu files, don't know why.
>>
>> I also, reluctantly, use Gmail because I am 'named' by Google and
>cannot
>> send to gmail addresses except via gmail. If anybody knows how to
>become
>> a 'good boy' with Googleplease tell me how.
>>
>> Barry
>>
>> On 28/08/2023 00:40, Adrien Monteleone wrote:
>> > I specifically asked that question, either higher up in this
>thread,
>> > or in another related thread. (the very fact there are multiple
>> > threads on this subject, at least 5 by my current count, is another
>> > topic of discussion entirely)
>> >
>> > Good to know David that you managed to discern as much.
>> >
>> > Barry, please respond and confirm, but specifically, don't just
>> > confirm if you use a Gmail interface (it appears some times that
>your
>> > e-mail origination is *not* Gmail) but confirm what APP you use to
>> > access and send e-mail. That is: do you log into an e-mail website,
>or
>> > do you have a separate 'Mail' application you use. And in each
>case,
>> > WHAT specifically do you use. (that is, what is the EXACT URL of
>the
>> > website you use to access e-mail, or what is the actual name of the
>> > e-mail app you use if not web-based)
>> >
>> > Regards,
>> > Adrien
>> >
>> > On 8/27/23 2:17 PM, David Carlson wrote:
>> >> Ken,
>> >>
>> >> I checked one of Barry's messages and found that it was fent from
>a
>> >> gmail
>> >> server, so I assumed that he is using Gmail.
>> >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unsubscribe

[David T. via gnucash-user]

I think you meant to send that to one of the addresses listed in the message to 
which you replied (like gnucash-user-requ...@gnucash.org). Sending to the user 
group generally won't achieve your goal.
⁣
David T.​

On Aug 16, 2023, 12:27, at 12:27, teal-05plummy--- via gnucash-user 
 wrote:
>Unsubscribe
>
>> On 16 Aug 2023, at 1:28 am, gnucash-user-requ...@gnucash.org wrote:
>> 
>> Send gnucash-user mailing list submissions to
>>gnucash-user@gnucash.org
>> 
>> To subscribe or unsubscribe via the World Wide Web, visit
>>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> or, via email, send a message with subject or body 'help' to
>>gnucash-user-requ...@gnucash.org
>> 
>> You can reach the person managing the list at
>>gnucash-user-ow...@gnucash.org
>> 
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnucash-user digest..."
>> 
>> 
>> Today's Topics:
>> 
>>   1. Re:  About auto-completion (Sherman Yoder)
>>   2. Re:  Chase ofx support? (Kalpesh Patel)
>>   3. Re:  Today's searchfor .lck (Adrien Monteleone)
>>   4. Re:  how to search for transactions with new line character
>>  in description? (Adrien Monteleone)
>>   5. Re:  About auto-completion (Adrien Monteleone)
>>   6. Re:  Update F::Q in flatpak GC? (rsbrux)
>>   7. Re:  Update F::Q in flatpak GC? (rsbrux)
>>   8. Re:  Strange prices update issue (possibly with TSP)
>>  (Kalpesh Patel)
>>   9. Re:  Update F::Q in flatpak GC? (rsbrux)
>> 
>> 
>>
>--
>> 
>> Message: 1
>> Date: Mon, 14 Aug 2023 20:38:54 -0400
>> From: Sherman Yoder 
>> To: gnucash-user@gnucash.org
>> Subject: Re: [GNC] About auto-completion
>> Message-ID: <157e2095-aa2a-63ec-5e90-ec29a003e...@emypeople.net>
>> Content-Type: text/plain; charset="UTF-8"
>> 
>>   I love the "search throughout" feature. i am the treasurer of a
>foreign
>>   mission, and we track expenses by missionary family. All I have to
>do
>>   is to type in "david" and up come David's housing, transportation,
>and
>>   support accounts. That's so much nicer than typing
>>   Expenses:Housing:David, and so on.
>> 
>>   I hope this feature doesn't go away.
>> 
>>   Sherman
>> 
>>   On 8/14/2023 7:26 PM, Stan Brown (using GC 4.14) wrote:
>> 
>> On 2023-08-14 16:19, David Carlson wrote:
>> 
>> I wish to support the 'search throughout' method.  I admit that it
>took
>> me several seconds to get used to it but it reduces the size of the
>> short list of partial matches very quickly until I can pick the
>winner
>> very easily.  Since I am now expecting it I don't have to type
>several
>> introductory characters before typing the real meaty characters of my
>> search.
>> 
>> Thanks for posting, David. I was blinkered by what I was used to, but
>I
>> think you're right, it's just a matter of training myself to type
>> something unique from the interior when starting at the beginning
>would
>> come up with the account I didn't want.
>> 
>> All my accounts payable begin with "AP ", and all my accounts
>receivable
>> with "AR ". Maybe I should move those to the end of the account
>names.
>> I'll think on that for a while.
>> 
>> Stan Brown
>> Tehachapi, CA, USA
>> [1]https://BrownMath.com
>> ___
>> gnucash-user mailing list
>> [2]gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> [3]https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>> References
>> 
>>   1. https://BrownMath.com/
>>   2. mailto:gnucash-user@gnucash.org
>>   3. https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> 
>> 
>> --
>> 
>> Message: 2
>> Date: Mon, 14 Aug 2023 21:07:02 -0400
>> From: "Kalpesh Patel" 
>> To: "'John Ralls'" , "'D Ducky'"
>>
>> Cc: "'Jon Schewe'" , "'Gnucash Users'"
>>
>> Subject: Re: [GNC] Chase ofx support?
>> Message-ID: <012301d9cf14$cd35f020$67a1d060$@usa.net>
>> Content-Type: text/plain;charset="us-ascii"
>> 
>> Chase does supports download in CSV, QFX, QIF and QBO formats for
>Credit
>> Card and Bank accounts. 
>> 
>> QFX format seems to be the best and then importing it as a OFX/QFX
>has
>> worked well ...
>> 
>> -Original Message-
>> From: John Ralls  
>> Sent: Monday, August 14, 2023 4:43 PM
>> To: D Ducky 
>> Cc: Jon Schewe ; Gnucash Users
>
>> Subject: Re: [GNC] Chase ofx support?
>> 
>> 
>> 
>>> On Aug 14, 2023, at 1:33 PM, D Ducky 
>wrote:
>>> 
>>> Hello,
>>> 
>>> It seems Chase does not support OFX anymore.
>>> 
>>> 
>>
>https://www.banktivity.com/support/articles/banktivity-7/ofx-direct-connect-
>> will-no-longer-be-supported-by-chase-as-of-october-6th-2022/
>>> 
>>> 
>>> Is it possible to use some other method in gnucash to download
>> transactions from gnucash?
>>> 
>> 
>> No, there is no other method in GnuCash to 

Re: [GNC] Consolidation of family member accounts

[David T. via gnucash-user]

A transfer between two asset accounts (your account to your wife's) doesn't 
need any further entries, unless you're considering these transfers as some 
kind of bookable event. Are you paying them, or just transferring them funds? 
If the latter, then just two entries crediting/debiting the two assets. 

When your wife receives the funds this way, there's no change in the family net 
worth. When she buys something, the transaction includes her bank account and 
the proper expense account. 

⁣David T. ​

On Aug 13, 2023, 8:05 PM, at 8:05 PM, Paras Desai  
wrote:
>Hello sirs,
>
>1. I am adopting GNC for my family members (me, wife and son)
>2. There are lots of transfer takes place between family members. For
>example, I transfer an amount to wife account , for her expense or
>investment. Same for son.
>3. At present I can adopt two approach for such transfer
>Either I can show transferred amount as gift expense or create account
>receivable in name of family member.
>4. Neither is a good practice, as at family level, it will erroneously
>show duplicate expenses (mine as gift to wife and, wife's actual
>expenses with gifted fund)
>
>So my question is
>
>Is there a way in GNC to consolidate family members account to arrive
>at net worth of entire family?
>
>When we do consolidation of accounts, we eliminate inter transaction
>between members (as we do between a parent and subsidiary company in
>business scenario)
>
>I will be happy to explore the way, if there is any way I can achieve
>this in GNC
>
>Thank you
>
>Paras
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Today's search....for .lck

[David T. via gnucash-user]

Of course, that command would be:

DIR "C:\Users\Barry Mahon\Documents\Tax accounts and returns" > filename.txt

⁣David T. ​

On Aug 8, 2023, 4:17 PM, at 4:17 PM, Jack Lockard  wrote:
>maybe someone else who knows off the top of their head can advise a
>command that will export your file list to a text file
>
>To get the text file do the following:
>
>1, Open a Command window by typing CMD in the search box on the task
>bar.
>2. Type in DIR C:\Users\Barry Mahon\Documents\Tax accounts and returns
>> filename.txt and press enter.
>3. This will create a text file in the current folder location of the
>files in the folder specified in step 2.
>
>Hope this helps,
>Jack
>
>
>-Original Message-
>From: gnucash-user
> On Behalf Of
>Adrien Monteleone
>Sent: Monday, August 7, 2023 4:16 PM
>To: gnucash-u...@lists.gnucash.org
>Subject: Re: [GNC] Today's searchfor .lck
>
>First, for attachment images, they need to be 'as attachment' and *not*
>inline.
>
>That is, in your e-mail app, attach the screenshot. Do not just paste
>it into the message mixed in with the text.
>
>You may also have a setting in your e-mail app for this to toggle
>between 'inline' and 'attachment'. For the mailing list - you *do not*
>want 'inline'. (the mailing list software will simply strip them out of
>the message)
>
>Second, if you say there are hundreds of files, a screenshot isn't
>going to cut it anyway. (it would take many screenshots)
>
>I'm not well versed on Windows command line, so without me spending
>time looking it up, maybe someone else who knows off the top of their
>head can advise a command that will export your file list to a text
>file that you can attach here. Of course, you'd want to use whatever
>options are available to include the original creation date & time, as
>well as a last modified date & time. (those can be shown or not shown
>as desired)
>
>From that list, we should be able to reasonably guess which is your
>latest file (or maybe even several candidates for it) and then you can
>open them and confirm.
>
>I suspect though, that you have a condition where there are
>transactions in one file that aren't in another, and vice versa. And
>this may involve more than 2 files. You'll have to decipher that for
>yourself once you figure out the file situation, and then we can
>proceed with helping you consolidate them into one book.
>
>Lastly, it would be good to get a handle on how this happened in the
>first place, so the problem doesn't continue to compound.
>
>But I too don't think you lost any data unless you started deleting
>.gnucash files without backups. (.lck files aren't necessarily a
>problem)
>
>.gcm files store some preferences for each book. It would be best not
>to lose those for now, but losing them wouldn't be data lost.
>
>Regards,
>Adrien
>
>On 8/7/23 10:03 AM, Mahon Finbar via gnucash-user wrote:
>> Thank you for that. However, a file search for any file of that
>> structure only delivers 1 dated 18.02.2022, which I have mentioned in
>> an earlier post is the date on my 'currently loaded' file which won't
>save.
>>
>> There are a number of files with .GCM and number with LCK dated 2021,
>> others with .log, many more (recent ones) with shortcut.
>
>What do you mean by 'shortcut'? They are pointing to other gnucash
>files in some other location? This is concerning...
>
>>
>> All the rest are datestamped.
>>
>> You can see why I am confused and very worried that I have lost all
>> the recent data.
>>
>> Thanks to all for the help and advice. I feel stupid, I thought I was
>> reasonably capable in IT, but..
>>
>> I even have problems creating  the proper . versions for
>uploading.
>> 'save as' doesn't seem to be working.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Today's search....for .lck

[David T. via gnucash-user]

Yeah, that request has been around at least since 2008...

⁣David T. ​

On Aug 6, 2023, 7:00 PM, at 7:00 PM, Adrien Monteleone 
 wrote:
>I can see the benefit to having logs and backup files together with the
>
>data, but I'd prefer if they were in their own sub-directories 
>automatically.
>
>Regards,
>Adrien
>
>On 8/6/23 6:28 AM, Chris Green wrote:
>> At least someone agrees with me! :-)
>> 
>> I've been muttering about this, on and off, for quite a while!  There
>> should be a way to move the clutter of logs and backup files out of
>> the way, away from where the main GnuCash xml or database file is.
>> (By 'move' I mean a configuration option that allows one to keep them
>> out of the way, I know files can be moved 'by hand')
>> 
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Wells Fargo OFX

[David T. via gnucash-user]

I'll take the contrarian position and note that there are more ways to 
synchronize your account with the bank's. Some argue that using the bank to 
keep your books up to date leaves you dependent entirely on the bank for 
accuracy. I enter the transactions for my family's activities manually, and 
while it gets tedious at times, it does give me a chance to review the 
transactions and have a check on what we are spending money on. And generally, 
it goes pretty quickly anyway. 

⁣David T. ​

On Jul 23, 2023, 6:12 AM, at 6:12 AM, Brad Morrison  
wrote:
>Hi Chris/all,
>
>Did you already review the information & links from my last email 
>responding to your OFX/online banking issues?
>
>https://lists.gnucash.org/pipermail/gnucash-user/2023-July/107875.html
>
>If so, did you have more specific questions?
>
>Thanks,
>
>Brad
>
>
>On 7/22/23 19:13, Chris Miller wrote:
>> Hi Folks,
>> I bank with Wells Fargo and have done so for 30 years. I've used
>> QuickBooks and Quicken for most of that time and they have worked
>out
>> well. Regardless, I am not a fan of Intuit.
>> I'm investigating GnuCash, and the thing I find most important is
>being
>> able to synchronize my accounts with Wells Fargo. However I'm not
>> finding much advice on how to set up OFX.
>> Does anybody have experience with this? Does anybody have advice
>for me
>> on how to do it, or if I should do it.
>> Thanks for the help,
>> Chris.
>> Laboriously sent to you from my ... do you really care?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Should GNUCash allow a split to reference the same account twice

[David T. via gnucash-user]

There are many situations where that can legitimately happen-- for example, 
when you have two charges contributing to a particular total (think of a 
paycheck with income from base salary and income from bonuses). Your want to 
see each listed separately, even though they combine to one final figure. 

And yes, it can be confusing. I have found that changing the register view to 
Transaction View can simplify things by showing each transaction as a single 
entity, with each entry split showing as part of the whole. 

⁣David T. ​

On Jul 20, 2023, 9:19 PM, at 9:19 PM, Henry Law  wrote:
>Earlier today my wife was running GNUCash to update "her" bit of the
>accounts and got into a serious tangle because she (inadvertently)
>changed a newly-imported transaction so that its two splits -- which
>should have been our current account and her credit card account --
>both referred to the credit card account.  She then reconciled one half
>and not the other, which caused a cascade of issues which took me
>several hours and a manual edit to the GNUCash file to fix.
>
>Should GNUCash refuse to allow a transaction to have two splits into
>the same account?  My knowledge of accounting is scant, but with it I
>can't see why one would ever legitimately do that.
>
>-- 
>-- 
>Henry Lawn e w s @ l a w s h o u s e . o r g
>Manchester, England            
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Two Instances as opposed to two separate files

[David T. via gnucash-user]

That would be *OpenStacks* convention.

By all means, impose their rules here!
⁣
David T.​

P.S. The amount of energy expended on this topic is amazing to me--and I note 
that NONE of you Authorities On Email Etiquette bothered to change the subject 
of this thread to reflect the completely new (and ultimately fruitless) 
discussion of a topic that left the barn, died, and was buried years ago.

On Jul 17, 2023, 11:37, at 11:37, Paul Feakins  wrote:
>On 15/07/2023 01:56, R Losey wrote:
>> Is there really a convention for replies?
>
>Indeed there is: 
>https://wiki.openstack.org/wiki/MailingListEtiquette#Replies
>
>Paul Feakins.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transferring mutual funds

[David T. via gnucash-user]

Kalpesh,

Your assessment regarding capital gains rates is accurate; it's been one of my 
problems with this issue for some time. It also comes up with stock splits, 
where the "new" shares should have the original acquisition date. Honestly, 
this is not an easy issue to finesse without a boatload of work. 

For what it's worth (most likely not a lot), when I had a brokerage change many 
years back, I created a new account in GnuCash for that brokerage, and simply 
moved the stock accounts into that new brokerage account. It probably violates 
17 rules of accounting, but it worked for me. 

⁣David T. ​

On Jul 6, 2023, 3:39 PM, at 3:39 PM, Kalpesh Patel  
wrote:
>Hmmm. So I am a bit perplexed here. 
>
>Disclaimer: I am a new-bee when it comes minutiae's of the investment
>transactions so I might be wrong what I am about to state. Feel free to
>correct me.
>
>If you note such factitious sale or closing of the transaction to
>preserve the cost basis as you mentioned, are you not altering how long
>the security is held which will impact capital gains reporting? If you
>alter in such a way, I am not sure if that is same thing as
>transferring the security to another account, at least not the way
>brokerages do so in the US amongst them or within them. 
>
>Would you not want to simply move the original buy/sell transaction by
>re-pointing one of the split line item from the old account to new one?
>This I would think keeps the entire transaction intact as-is which what
>the transfer should be about and then you can have a zero valued
>transaction on the date of the transfer itself which would have no
>impact on any reporting.
>
>
>-Original Message-
>From: David Carlson  
>Sent: Wednesday, July 05, 2023 1:08 PM
>To: f...@mandfb.me.uk
>Cc: AC ; gnucash-user@gnucash.org
>Subject: Re: [GNC] Transferring mutual funds
>
>AC,
>
>Fred implied, but didn't elaborate on the point that the shares in the
>original brokerage account had a cost basis that was incurred when they
>were purchased.  When you transfer them out, that is equivalent to a
>sale or closing transaction, and the cost basis should be adjusted
>accordingly, even though there were no funds involved.  Of course, that
>exact cost basis needs to be added to the receiving account as if the
>shares were purchased at the original price.  This used to be described
>in great detail in one of the help manuals, including the somewhat
>tricky procedure to enter realized gains when an actual sale happens
>but I haven't checked lately to see if those parts are still there.  I
>know that if you do not do those things and later run a trial balance
>or if you use the Investment Portfolio report, you will quickly see the
>error of your ways.
>
>
>
>On Wed, Jul 5, 2023 at 11:33 AM Fred Bone  wrote:
>
>> On 04 July 2023 at 16:29, AC said:
>>
>> > I recently moved some mutual funds from one brokerage to another. 
>> > The process did not involve a sale, it was just a transfer of 
>> > control from
>> the
>> > old to the new.
>> >
>> > In my current books I keep mutual funds listed as subaccount under 
>> > each brokerage as such with their respective security/currency:
>> >
>> > Investments
>> > -Brokerage 1 (currency)
>> > --Fund A (security A)
>> > --Fund B (security B)
>> > -Brokerage 2 (currency)
>> > --Fund A (security A)
>> > --Fund C (security C)
>> > --Fund D (security D)
>> >
>> > I wanted to expand this to add the new brokerage and then perform a
>
>> > transfer of the funds from one to the other. Let's assume I moved 
>> > the funds under Brokerage 1 to Brokerage 3. So the tree would look 
>> > like the simplified version below (leaving out Brokerage 2 as it is
>unaffected):
>> >
>> > Investments
>> > -Brokerage 1 (currency)
>> > --Fund A (security A)
>> > --Fund B (security B)
>> > -Brokerage 3 (currency)
>> > --Fund A (security A)
>> > --Fund B (security B)
>> >
>> > The securities are the same because it's the same original mutual 
>> > funds, just moved to another brokerage. The tree would be left 
>> > intact with the funds under Brokerage 1 being zeroed out and the 
>> > funds under Brokerage 3 starting off with the incoming values.
>> >
>> > My natural tendency was to create a transfer directly within 
>> > Brokerage 1 Fund A that moved all the shares over to Brokerage 3 
>> > Fund A but that didn't create the transaction I expected.
>> >
>> > By example, I transferred Fund A on July 1 which contained 10
>shares 
>> > at the price of the shares on that day. So in Brokerage 1 I entered
>
>> > -10 shares with a total sell price of X as listed on the statement 
>> > from Brokerage 1. The price is autocalculated and the balance 
>> > correctly goes
>> to
>> > zero.
>> >
>> > Looking inside the Brokerage 3 Fund A account I only see a 
>> > transaction that has an amount in the buy column but no shares and
>a balance of zero.
>> > I can manually enter the same number of shares in that partially 
>> > empty transaction but why was my thought about the 

Re: [GNC] How to revert to previous input mode?

[David T. via gnucash-user]

You might help us all by telling us the version and OS you're using.

There's been a whole lot of turmoil and change in this area over the last few 
months, the upshot of which is that autofill has changed a lot between 5.2 and 
5.3. 5.4, which should be releasing soon (to fix another serious bug) might 
address your concerns.
⁣
David T.​

On Jul 1, 2023, 16:33, at 16:33, Pierre Fortin  wrote:
>Hi,
>
>Having used gnucash for many years, I've been quite happy with all my
>built-in history where most new entries could be done in a minimum of
>keystrokes.
>
>The new interface where it offers all(?) the possible choices is
>driving
>my nuts.  This change has slowed down data and entry wasting time... In
>my late 70s; this matters!
>
>This morning, trying to enter "Pens", it insists on picking "Camper
>expenses" unless I grab the mouse and click where TAB was all I needed.
>  
>
>Is there a way to revert back to the previous interface?  This should
>be
>a choice in settings.  Maybe it's there; but I haven't found it...
>
>Thanks for an otherwise great program,
>Pierre
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] GnuCash 5.3 autofill headaches

[David T. via gnucash-user]

I'm pretty sure there aren't any options for autofill; therefore, there won't 
be any entries in the FAQ for them. 

⁣David T. ​

On Jul 1, 2023, 2:32 PM, at 2:32 PM, Jack Slater  wrote:
>Where do I find the FAQ on the options for this latest version of the
>auto-suggest?
>
>On Fri, Jun 30, 2023 at 9:52 PM john  wrote:
>
>> David,
>>
>> OK, so not the marker transaction. I've got only 5 future
>transactions.
>>
>> The read line in Vincent's file is because he has read-only after N
>days
>> set in File>Properties. The transactions above the red line are
>read-only.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Jun 30, 2023, at 17:43, David H  wrote:
>> >
>> > Hello John,
>> >
>> > Sorry my bad, it's actually Big Sur version 11.7.8 on the iMac, NOT
>> Monterey - memories going !!!  The blank txn is my future credit card
>> payment - happens on the same day each month and I just fill in the
>amount
>> when I know it.  I have one in each of my 3 card accounts and
>multiple in
>> the cheque account for the other side of the splits in them.
>> >
>> > I used Vincent's test file that he posted earlier and it seems to
>do the
>> same thing see below, the register WITHOUT focus when re-opening only
>> displays the blank txn plus 1. He also has multiple blank txns in
>that
>> register.  Not sure where the red line comes from as I don't see it
>in my
>> own file and I can't see a preference for it ?
>> >
>> > Thanks David H.
>> >
>> > 
>> >
>> > On Sat, 1 Jul 2023 at 09:37, John Ralls > jra...@ceridwen.us>> wrote:
>> >> David,
>> >>
>> >> Huh. Two possibilities: I have only a few future transactions, not
>> enough to move the blank transaction that far up the screen, and I
>wonder
>> if that marker transaction (with no debit or credit value) matters.
>> >>
>> >> What macOS version on the iMac?
>> >>
>> >> Regards,
>> >> John Ralls
>> >>
>> >>
>> >> > On Jun 30, 2023, at 1:47 PM, David H > hell...@gmail.com>> wrote:
>> >> >
>> >> > Hi John,
>> >> >
>> >> > I hope I don't sound ungrateful, as always I really appreciate
>the
>> work you and the other devs/translators/etc put in on my most used
>app.
>> >> >
>> >> > Anyway here's a pic of what I'm seeing on all my pc's - haven't
>fired
>> up Ubuntu for a few days so can't say what happens there. I have
>standard
>> sort order on, future dated txns after the blank txn so they stand
>out for
>> me.  As you can see from the pic's different end points.  Looking at
>it
>> again this morning after a coffee I have noticed that if I close
>GnuCash
>> with an account register open that particular register exhibits the
>old
>> behaviour and is scrolled right to the bottom when GnuCash is
>re-opened.
>> Otherwise I only get the blank txn and 1 future dated txn in all open
>> registers.  Usually I close Gnucash with the focus on the Accounts
>tab so
>> it seemed like it affected all registers.   Aha, did I hear you say
>> something about lazy tab repainting/refreshing in a previous post -
>is
>> there a connection ?
>> >> >
>> >> > I've also noticed some of my icons disappearing, but only on my
>slow
>> old 2014 27" iMac - looks a bit weird - like 3 missing, 2 there, more
>> missing and if you move the cursor along the icon row they magically
>> reappear.  Really only an intermittent thing that I've only seen
>twice on
>> the one Mac.
>> >> >
>> >> > Hope this clarifies things somewhat.
>> >> >
>> >> > Cheers David H.
>> >> >
>> >> >
>> >> >
>> >> > 
>> >> >
>> >> > On Sat, 1 Jul 2023 at 03:55, John Ralls > jra...@ceridwen.us>> wrote:
>> >> >
>> >> >
>> >> > > On Jun 30, 2023, at 8:31 AM, Adrien Monteleone <
>> adrien.montele...@lusfiber.net
>>
>> wrote:
>> >> > >
>> >> > >> I also think that the registers now display a little
>differently
>> to what
>> >> > >> they used to.  In 5.1 any open registers always scroll all
>the way
>> to the
>> >> > >> end of the txns when you re-open your GnuCash data file.  In
>5.3
>> they don't
>> >> > >> seem to quite get all the way to the bottom meaning you have
>to
>> manually
>> >> > >> page down in every register you had open to see all your
>future
>> txns, which
>> >> > >> in my case is sometimes 15 - 20 as I like to know what's
>coming up
>> for the
>> >> > >> next 60 days cash flow wise.
>> >> > >
>> >> > > I don't use future-dated transactions, but if it doesn't even
>get
>> to the last transaction (and ideally the next empty one) that could
>get
>> quite annoying.
>> >> > >
>> >> >
>> >> > I just checked that and both open registers had the cursor in
>the
>> blank transaction just like always. There's a  preference to put the
>blank
>> transaction before future transactions. Even with that set I see all
>the
>> ones I have displayed below the blank transaction, but I can imagine
>that
>> if you have more than will fit in the window then GnuCash will scroll
>so
>> that the blank transaction is at the top of the window and some of
>those
>> future transactions aren't visible. I think that's correct 

Re: [GNC] Reversing a finished credit card reconciliation

[David T. via gnucash-user]

Both previous replies were on target-- but, I do wonder how you finished the 
first reconciliation, since GnuCash won't activate the finish button until the 
Difference value is zero. If the transaction was wrong, the balance would be 
non-zero?

⁣David T. ​

On Jun 25, 2023, 12:26 PM, at 12:26 PM, "Maf. King"  wrote:
>Hi Gregory,
>
>welcome to the list and Gnucash.
>
>
>Just ignore that the starting balance is wrong, go through the
>reconcilliation 
>as normal aiming for the correct ending balance.
>
>should sort itself out.
>HTH,
>Maf
>
>
>On Thursday, 22 June 2023 01:08:01 BST Gregory Donavon wrote:
>>  I hope you can help me unwind an error I made after not following
>one of
>> the steps in a busybee post video on youtube: I transposed a couple
>of
>> numbers on one transaction, this resulted in there being a difference
>of a
>> few dollars. Rather than hitting "postpone," I hit "finished" with
>the plan
>> of coming back later to figure out the location of the error. When I
>> changed the transposed entry to the correct amount, that didn't
>correct the
>> problem because when I went back in to reconcile , the starting
>balance was
>> wrong and I could not change it or bring up the original
>reconciliation
>> page. Is there anything I can do - this is my first month using
>gnucash.
>> Any suggestions you have for reversing the transactions would be
>> appreciated.
>> 
>> Thanks for your help,
>> Gregory Donavon
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to Upgrade Old GnuCash Version to Current Version

[David T. via gnucash-user]

I've updated that section now. 

⁣David T. ​

On Jun 8, 2023, 11:54 PM, at 11:54 PM, David Cousens  
wrote:
>Try the wiki https://wiki.gnucash.org/wiki/Installation#Upgrading. Not
>exactly
>extensive enough though.
>
>On Fri, 2023-06-09 at 12:17 +1000, flywire wrote:
>> > If you follow the upgrade path, the recommended method is...
>> 
>> OK, where is that documented? If the current version of GnuCash won't
>work
>> with older data file versions it should display an error message
>without
>> opening the file.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] report cutoffs - Trial Balance opening date

[David T. via gnucash-user]

Per the documentation:


10.3.5.11. Trial Balance


Trial Balance lists the ending balances in all accounts as of a particular 
date. It is typically run at the end of an accounting period and is primarily 
used to ensure that the total of all debits equals the total of all credits.


By definition, that means there *isn't* a start date. 

⁣David T. ​

On May 18, 2023, 11:38 PM, at 11:38 PM, "Rogier F. van Vlissingen" 
 wrote:
>somehow or other I had a discrepancy between my trial balance and my
>P
>and it turns out that the 22 trial balance is picking up transactions
>from
>20 and 21.
>
>What I cannot figure out is where to set the opening date for the trial
>balance.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Issue with Current Assets?

[David T. via gnucash-user]

I'll assume that "some number" <> $6,621.66, first. 

Next, is that from the Chart of Accounts, or a report? 

If it's the former, you might have transactions in Current Assets. 

If it's the latter, there may be other accounts beneath Current Assets that 
haven't been selected for display, but which affect a roll up value. 

⁣David T. ​

On May 15, 2023, 7:40 PM, at 7:40 PM, Don Gray  wrote:
>I may have missed something, or maybe got creative with entering data.
>
>My account structure
>
>Assets
>   Accounts Receivable - $ 0.00
>   Current Assets - -$6,621.66
>   Checking Account - $ some number
>   Petty Cash - $0.00
>   Savings Account - $ 0.00
>  
>The $ some number in the checking account is correct as it balances
>with the bank statements.
>
>How is the value in Current Assets computed?
>
>I did a Check & Repair all. It did not change the Current Assets value.
>
>Sincerely,
>
>Don Gray - Exploring Human Systems in Action
>+1 (336) 414-4645
>
>‌No plan survives contact with the enemy.‌
>von Moltke the Elder
>‌
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tax report options

[David T. via gnucash-user]

That's what accountants are for. Asking GnuCash to provide that level of 
monitoring is out of scope for the software. 

⁣David T. ​

On May 14, 2023, 5:25 PM, at 5:25 PM, Ken Farley  wrote:
>Form 1116 has cost me at least a couple of iterations of filing my
>taxes 
>in the past. It would be nice if something told me I needed it...but 
>unless I was paying taxes to a foreign nation directly, meaning a 
>transaction occurs in one of my accounts, I don't see how I would have 
>it included in this report. Dividends I get, interest received, capital
>
>gains, etc. These are all entries into my ledgers that the report can
>be 
>told to use. The taxes paid that are useful for the Form 1116 tax
>credit 
>are only known to me when I get my 1099 Forms from my investment 
>brokerage. I have absolutely no idea what they will be until I see that
>
>entry in the form. So, I don't understand how the tax report in Gnucash
>
>would be able to supply you with this information?
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tax report options

[David T. via gnucash-user]

I enter these foreign tax transactions as they are transmitted to me by the 
broker (my brokerage presents them all). They go to a separate foreign tax 
account, making tracking easy. 

⁣David T. ​

On May 14, 2023, 5:44 PM, at 5:44 PM, Fred Tydeman  
wrote:
>When I get the 1099 DIV forms for mutual funds and stock brokerage
>accounts,
>I add two transactions dated year end (if this is the only mention of
>foreign taxes):
>  Foreign tax:  +xxx  (expense)
>  Dividend:   +xxx  (income)
>for each net foreign tax paid for each security.
>I am looking for the total of all the foreign tax entries.
>
>Other investments, tell me about each gross dividend / interest payment
>and
>how
>much foreign tax was withheld.  Those I can enter as each is done.
>
>
>
>On Sun, May 14, 2023 at 4:24 PM Ken Farley  wrote:
>
>> Form 1116 has cost me at least a couple of iterations of filing my
>taxes
>> in the past. It would be nice if something told me I needed it...but
>> unless I was paying taxes to a foreign nation directly, meaning a
>> transaction occurs in one of my accounts, I don't see how I would
>have
>> it included in this report. Dividends I get, interest received,
>capital
>> gains, etc. These are all entries into my ledgers that the report can
>be
>> told to use. The taxes paid that are useful for the Form 1116 tax
>credit
>> are only known to me when I get my 1099 Forms from my investment
>> brokerage. I have absolutely no idea what they will be until I see
>that
>> entry in the form. So, I don't understand how the tax report in
>Gnucash
>> would be able to supply you with this information?
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tax report options

[David T. via gnucash-user]

You should be able to select an account and its children to receive a single 
tax code. In the past, you could only set a single account, but I believe now 
that you can assign multiple accounts to a single code.

Note that you cannot go through and set all your accounts to various tax 
assignments in one pass; the code doesn't allow that (or at least hasn't in my 
experience).

⁣David T. ​

On May 14, 2023, 11:43 AM, at 11:43 AM, Fred Tydeman  
wrote:
>I have marked a dividend parent account as Sch B dividend income.
>Is there an easy way to apply that to all of its child accounts?
>Or, do I have to add the income tax information to each child one by
>one?
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Tax report options

[David T. via gnucash-user]

Of course there is, but it's unlikely to be a simple fix. Alex A. has been the 
primary maintainer of the tax options code. From my recollections, the process 
is not entirely straightforward. 
⁣
David T.​

On May 14, 2023, 09:56, at 09:56, Fred Tydeman  wrote:
>Is there a way to add to the Edit -> Tax Report Options?
>For example, I would like to add Form 1116 Foreign Tax Credit
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Two accounts: same name, same parent

[David T. via gnucash-user]

That seems odd. In my experience GnuCash won't allow two accounts in the 
immediate context with the same name (despite the fact that internally GnuCash 
doesn't use the human readable account name at all). I'm not sure how you 
succeeded in that, but your remedy should be fine.
⁣
David T.​

On May 14, 2023, 09:39, at 09:39, Fred Tydeman  wrote:
>In looking at my account tree, I see two accounts with the same name
>with
>the same parent.  That seems wrong.  In looking at them, one is a
>placeholder, the other is a normal account.
>
>Now that I see that issue, I have moved the normal account to be a
>child of
>the placeholder and renamed it.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

As for missed threads, I've taken to opening the message queue on the mail 
server directly before I reply, just to be sure I'm replying with useful 
information...
⁣
David T.​

On May 11, 2023, 07:20, at 07:20, Adrien Monteleone 
 wrote:
>David,
>
>I didn't notice when I replied, that this thread broke (at least for
>me) 
>and there were more detailed replies.
>
>Now that I see what the OP was encountering, I agree, SQL won't be a 
>solution for anything not committed.
>
>Other than this special case, I'm not sure it would be a good idea to 
>auto-save uncommitted transactions. (especially if they don't balance 
>yet) I'd hazard some folks rely on that current behavior.
>
>I do agree some sort of visual indication as to which open registers 
>have uncommitted transactions would be helpful, as would the warning 
>message being more specific to avoid a guessing game.
>
>And certainly, the OPs original goal might be better implemented within
>
>the GUI so as to avoid the issue entirely, as it seems the cron job is
>a 
>work around. (thus it seems the problem isn't not auto-saving or 
>auto-committing transactions on exit, but rather the lack of ability to
>
>schedule price updates)
>
>Regards,
>Adrien
>
>On 5/10/23 11:02 PM, David T. via gnucash-user wrote:
>> Adrien,
>> 
>> The issue as stated is specifically the loss of an uncommitted
>transaction, so an SQL back end won't help with that. If, however, that
>open transaction prevents an entire session from being saved, then your
>suggestion merits attention. I personally don't know about that,
>though; the OP didn't mention.
>> 
>> ⁣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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

Adrien, 

The issue as stated is specifically the loss of an uncommitted transaction, so 
an SQL back end won't help with that. If, however, that open transaction 
prevents an entire session from being saved, then your suggestion merits 
attention. I personally don't know about that, though; the OP didn't mention. 

⁣David T. ​

On May 11, 2023, 6:13 AM, at 6:13 AM, Adrien Monteleone 
 wrote:
>The SQL backends will get you an instant auto-save, but only for 
>committed transactions. (as far as I know)
>
>You still have to hit Enter or Tab-through to finish a transaction, at 
>which point the file is auto-updated. (thus, save-on-commit)
>
>Regards,
>Adrien
>
>On 5/4/23 4:30 PM, David G. Pickett via gnucash-user wrote:
>> I often accidentally leave a transaction complete but with the cursor
>of that sheet still on the same line, so despite an aggressive auto
>save setting, such a transaction is not committed to the saved image. 
>Of course, if it is not in valid form, it cannot be committed!  But if
>the host goes down or gnucash terminates for any reason not a stable
>interactive exit, despite the auto save, the entire transaction or any
>change is lost.  I would like an option to auto-commit such
>transactions, if valid, before the timed auto save.
>> 
>> For me, this creates loss of input when I run my nightly cron job for
>quotes, where I kill any running gnucash and remove any lock to allow
>the quote additions.  (A side thought would to have the quote fetch
>built into the interactive gnucash such that it has a way to get quotes
>without being killed.  Maybe a gnucash service daemon that could
>negotiate the updates with any running interactive gnucash or do the
>updates if no interactive gnucash is running?  That in turn suggests a
>gnucash with a service and multiple interactive sessions so changes in
>any interactive session could be notified to other interactive
>sessions, supporting both quotes from a crontab scheduled service
>internal or external, and multiple interactive users to support larger
>enterprises.)
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[David T. via gnucash-user]

All good points! 

⁣David T. ​

On May 8, 2023, 7:36 PM, at 7:36 PM, Bruce Schuck  
wrote:
>On 5/8/23 13:05 +0300, David T. wrote:
>
>> It's a wiki, so you could put it in. You'd get to decide where that 
>> would best live, too.
>
>Perhaps sometime during the week I'll add something. With the obvious
>warnings about making backups and the possibility of making a mess for
>one's self.
>
>> FWIW, my method for doing this is to save the file as an SQLite
>> file, open the result in a DB reader, locate the appropriate table
>> there, and execute the change globally. Then I reopen the file in
>> GnuCash and save it back to xml.
>
>> It feels easier to me to do it this way and it doesn't take much 
>> time.
>
>SQLite queries may be a bit more than some users are willing to try.
>But 
>I can see where it would be easy for those comfortable with it. Same 
>reason xmlstarlet would be simple for those familiar with it.
>
>If I unpacked the .gnucash file to foobar.gnucash, this command would 
>change the quote source globally.
>
>xmlstarlet ed --inplace -u 
>'/gnc-v2/gnc:book/gnc:commodity/cmdty:quote_source["yahoo_json"]' -v 
>'alphavantage' foobar.gnucash
>
>One can also selectively change the quote source for a specific 
>namespace. This command would change the quote source for just the 
>NASDAQ securities.
>
>xmlstarlet ed --inplace -u 
>'/gnc-v2/gnc:book/gnc:commodity[cmdty:space="NASDAQ"]/cmdty:quote_source["yahoo_json"]'
>
>-v 'alphavantage' foobar.gnucash
>
>- Bruce S.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

Yes, one can imagine that. I can imagine that it would be possible to add 
something like that into the get quotes function that already exists, but I'm 
not a programmer, so I accept that if I want to track commodity values in 
GnuCash, I have to click the get quotes button. The get quotes button is as 
close to a listening socket as I'll get. 

I'm curious-- does auto save complete its process if a transaction is open? I'd 
imagine that it doesn't. You might want to check on that. It would be a drag to 
discover after the fact that a series of edits were lost because auto save 
didn't complete-- especially if you're going to keep using an external cron job 
script that relies on an unrelated function (auto save) to preserve your 
financial data. 

⁣David T. ​

On May 8, 2023, 5:55 PM, at 5:55 PM, "David G. Pickett"  
wrote:
>I use auto save, and if the app is running, the cron kills it and
>removes the lock before running the quote fetch.
>
>One can imagine the app having a listening socket to let you ask it to
>get quotes from a cron script.  Or having it maintain a schedule where
>it gets all quotes, like an internal crontab.
>
>
>-Original Message-
>From: David T. 
>To: David G. Pickett 
>Cc: David G. Pickett via gnucash-user 
>Sent: Sun, May 7, 2023 11:34 pm
>Subject: Re: [GNC] Auto commit with auto save?
>
>Nope and nope. Sorry. 
>
>It seems to me that leaving GnuCash open and running a con job against
>the open app is a recipe for troubles just like the ones you have
>encountered. You could tell the script to abort if it found the lock
>file, but that would require you to close the app every night, which
>you're not doing now. 
>
>David T. On May 7, 2023, at 9:25 PM, "David G. Pickett"
> wrote:
>Any suggestions on a) how a shell script tells that the auto save is
>incomplete, b) even if it knew, what it could do about it? 
> 
> 
>  -Original Message-
> From: David T. 
> To: David G. Pickett 
> Cc: gnucash-user@gnucash.org
> Sent: Sun, May 7, 2023 1:28 am
> Subject: Re: [GNC] Auto commit with auto save?
> 
>I agree that it would be nice to have some visual cue that a
>transaction has been edited but not saved; that would be useful. I'm
>honestly not sure why that hasn't been implemented. 
> 
>The app does throw a dialog onscreen when a user tries to save with an
>open transaction. Unfortunately, the message is generic, and a user is
>forced to look through the open tabs and try to figure out which
>register holds this transaction. Others have commented on this in the
>past. 
> 
>If I recall correctly, you were having trouble because you have a cron
>job set up to retrieve quotes at a specified time each day, and this
>job causes the file to close dirty if there is an open transaction. The
>problem in this case, is that this cron job doesn't have necessary
>fault testing and tolerance. I'd suggest working on ensuring that this
>cron job was properly set up to handle your specific situation. 
> 
>David T.  On May 6, 2023, at 9:02 PM, "David G. Pickett via
>gnucash-user" < gnucash-user@gnucash.org> wrote: 
>"Don't do that!" does not prevent data loss from human error, which for
>this app behavior is too easy to create and not realize.
>
> 
> 
>If the commit was automatic every time you modified a transaction when
>the new state was valid, then I would not leave the tab in an
>uncommitted state, but that is not how it was devised.  I leave because
>it looks fine.  There is no indication of an uncommitted transaction I
>can see.  In terms of human factors, one might go to another tab for
>information to complete a transaction, so we do not want to prevent the
>user leaving a tab with an uncommitted, possibly invalid transaction. 
>Maybe we should color the tab red while in this state?  Or pop up a
>dialog if it persists a bit too long, or if auto save fires on its
>timer?  But the user may have left, trusting in auto save, so I suggest
>an auto commit if valid on auto save. 
> 
>gnucash-user mailing list 
>gnucash-user@gnucash.org 
>To update your subscription preferences or to unsubscribe: 
> https://lists.gnucash.org/mailman/listinfo/gnucash-user 
>- 
>Please remember to CC this list on all your replies. 
>You can do this by using Reply-To-List or Reply-All.  
> 
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Untick multiple checkboxes in Importer

[David T. via gnucash-user]

I'm not at a machine right now, but what happens if you CTRL-click?

⁣
David T.​

On May 8, 2023, 11:23, at 11:23, and...@lists.savchenko.net wrote:
>I might be missing something obvious, but at least on Windows build of
>v4.14 it's impossible to untick multiple rows at once.
>
>Shift-click allows to select a range, but clicking on any of the
>A/U+C/C columns unticks only the last record.
>
>
>-- 
>With regards,
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Yahoo JSON - throwing unauthorized error

[David T. via gnucash-user]

It's a wiki, so you could put it in. You'd get to decide where that would best 
live, too.

FWIW, my method for doing this is to save the file as an SQLite file, open the 
result in a DB reader, locate the appropriate table there, and execute the 
change globally. Then I reopen the file in GnuCash and save it back to xml.

It feels easier to me to do it this way and it doesn't take much time.

⁣
David T.​

On May 8, 2023, 04:03, at 04:03, Bruce Schuck  
wrote:
>To the maintainers of the Wiki, would this be something perhaps helpful
>
>to include in the section about stocks and commodities?
>
>I can also add 'xmlstarlet' commands as an alternative to manually 
>editing the file.
>
>- Bruce S.
>
>On 05/07/23 15:12:21 EDT Bruce Schuck bschuck at asgard-systems.com
>wrote:
>
>> Last time I switched en-masse (alphavantage to yahoo_json) I manually
> > edited my foobar.gnucash file. Worked like a charm.
>
>** Create a backup ** of foobar.gnucash before following these steps.
>Replace 'vim' with your preferred editor.
>
>~$ cp /foobar.gnucash /tmp/foobar.gnucash.gz
>~$ cd /tmp
>/tmp $ gunzip foobar.gnucash
>/tmp $ vim foobar.gnucash
>
>In vim, change lines
>
>alphavantage
>
>to
>
>yahoo_json
>
>Save and exit
>
>/tmp $ gzip foobar.gnucash
>/tmp $ cp foobar.gnucash.gz /foobar.gnucash
>
> > Run GnuCash, confirm quote sources for a random few securities.
>
> > There is also a handy tool for editing XML files on the fly,
> > xmlstarlet. It can also be used to modify the uncompressed
> > .gnucash file.
>
>- Bruce S.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

Nope and nope. Sorry. 

It seems to me that leaving GnuCash open and running a con job against the open 
app is a recipe for troubles just like the ones you have encountered. You could 
tell the script to abort if it found the lock file, but that would require you 
to close the app every night, which you're not doing now. 

⁣David T. ​

On May 7, 2023, 9:25 PM, at 9:25 PM, "David G. Pickett"  
wrote:
>Any suggestions on a) how a shell script tells that the auto save is
>incomplete, b) even if it knew, what it could do about it?
>
>
>-Original Message-
>From: David T. 
>To: David G. Pickett 
>Cc: gnucash-user@gnucash.org
>Sent: Sun, May 7, 2023 1:28 am
>Subject: Re: [GNC] Auto commit with auto save?
>
>I agree that it would be nice to have some visual cue that a
>transaction has been edited but not saved; that would be useful. I'm
>honestly not sure why that hasn't been implemented. 
>
>The app does throw a dialog onscreen when a user tries to save with an
>open transaction. Unfortunately, the message is generic, and a user is
>forced to look through the open tabs and try to figure out which
>register holds this transaction. Others have commented on this in the
>past. 
>
>If I recall correctly, you were having trouble because you have a cron
>job set up to retrieve quotes at a specified time each day, and this
>job causes the file to close dirty if there is an open transaction. The
>problem in this case, is that this cron job doesn't have necessary
>fault testing and tolerance. I'd suggest working on ensuring that this
>cron job was properly set up to handle your specific situation. 
>
>David T. On May 6, 2023, at 9:02 PM, "David G. Pickett via
>gnucash-user"  wrote:
>"Don't do that!" does not prevent data loss from human error, which for
>this app behavior is too easy to create and not realize.
>
>
>If the commit was automatic every time you modified a transaction when
>the new state was valid, then I would not leave the tab in an
>uncommitted state, but that is not how it was devised.  I leave because
>it looks fine.  There is no indication of an uncommitted transaction I
>can see.  In terms of human factors, one might go to another tab for
>information to complete a transaction, so we do not want to prevent the
>user leaving a tab with an uncommitted, possibly invalid transaction. 
>Maybe we should color the tab red while in this state?  Or pop up a
>dialog if it persists a bit too long, or if auto save fires on its
>timer?  But the user may have left, trusting in auto save, so I suggest
>an auto commit if valid on auto save.
>
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Auto commit with auto save?

[David T. via gnucash-user]

I agree that it would be nice to have some visual cue that a transaction has 
been edited but not saved; that would be useful. I'm honestly not sure why that 
hasn't been implemented. 

The app does throw a dialog onscreen when a user tries to save with an open 
transaction. Unfortunately, the message is generic, and a user is forced to 
look through the open tabs and try to figure out which register holds this 
transaction. Others have commented on this in the past. 

If I recall correctly, you were having trouble because you have a cron job set 
up to retrieve quotes at a specified time each day, and this job causes the 
file to close dirty if there is an open transaction. The problem in this case, 
is that this cron job doesn't have necessary fault testing and tolerance. I'd 
suggest working on ensuring that this cron job was properly set up to handle 
your specific situation. 

⁣David T. ​

On May 6, 2023, 9:02 PM, at 9:02 PM, "David G. Pickett via gnucash-user" 
 wrote:
>"Don't do that!" does not prevent data loss from human error, which for
>this app behavior is too easy to create and not realize.
>
>If the commit was automatic every time you modified a transaction when
>the new state was valid, then I would not leave the tab in an
>uncommitted state, but that is not how it was devised.  I leave because
>it looks fine.  There is no indication of an uncommitted transaction I
>can see.  In terms of human factors, one might go to another tab for
>information to complete a transaction, so we do not want to prevent the
>user leaving a tab with an uncommitted, possibly invalid transaction. 
>Maybe we should color the tab red while in this state?  Or pop up a
>dialog if it persists a bit too long, or if auto save fires on its
>timer?  But the user may have left, trusting in auto save, so I suggest
>an auto commit if valid on auto save.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble Changing Imported Descriptions

[David T. via gnucash-user]

Of course, the specific problem that OP outlined here had to do with what 
happens in GnuCash *after* transactions have been imported, rather than the 
import itself.

David T.​

On May 6, 2023, 04:14, at 04:14, R Losey  wrote:
>It's issues like this that have made me wary of importing transactions;
>doing them manually doesn't take that much longer.
>
>
>On Fri, May 5, 2023 at 2:54 AM David T. via gnucash-user <
>gnucash-user@gnucash.org> wrote:
>
>> I have seen the exact same behavior, and find it more than just an
>> annoyance. This arbitrary reversion to different text strings can
>result in
>> flawed and erroneous data entering your books--including entering
>> transactions into placeholder (i.e., read-only) accounts.
>> ⁣
>> David T.​
>>
>> On May 5, 2023, 03:30, at 03:30, Paul Kroitor 
>wrote:
>> >This is part 2 of a two-part question about imported transactions.
>> >
>> >
>> >
>> >My bank invariably imports transactions in barely readable technical
>> >jargon.
>> >For example, a debit card purchase at Villeneuve & Sons comes into
>the
>> >Aqbanking importer as:
>> >
>> >
>> >
>> >"[PR]L. VILLENEUVE &"
>> >
>> >
>> >
>> >My problem is that it's nearly impossible to correct this
>description
>> >to
>> >"Villeneuve". I can type V, Vi, or even Villeneuve into the
>description
>> >and,
>> >upon pressing enter, it will jump back to the original description
>> >(because,
>> >apparently, that string is in the original version of the field,
>> >despite in
>> >being in a different case). Even typing Villeneuve doesn't
>work.
>> >The
>> >only way it will retain my lower-case version is if I type
>> >Villeneuve, which it will keep (because Villeneuve
>> >followed
>> >two spaces is not in the original).
>> >
>> >
>> >
>> >I understand why Gnucash needs to consider Villeneuve and VILLENEUVE
>as
>> >being the same entry, but not why it can't see that a manual
>override
>> >to
>> >"Villeneuve" should be reverted back to "[PR]L. VILLENEUVE &". There
>> >must be
>> >a way to say I want to enter my own version of the name!
>> >
>> >
>> >
>> >This is driving me crazy!
>> >
>> >___
>> >gnucash-user mailing list
>> >gnucash-user@gnucash.org
>> >To update your subscription preferences or to unsubscribe:
>> >https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> >-
>> >Please remember to CC this list on all your replies.
>> >You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>-- 
>_
>Richard Losey
>rlo...@gmail.com
>Micah 6:8
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trouble Changing Imported Descriptions

[David T. via gnucash-user]

I have seen the exact same behavior, and find it more than just an annoyance. 
This arbitrary reversion to different text strings can result in flawed and 
erroneous data entering your books--including entering transactions into 
placeholder (i.e., read-only) accounts.
⁣
David T.​

On May 5, 2023, 03:30, at 03:30, Paul Kroitor  wrote:
>This is part 2 of a two-part question about imported transactions.
>
> 
>
>My bank invariably imports transactions in barely readable technical
>jargon.
>For example, a debit card purchase at Villeneuve & Sons comes into the
>Aqbanking importer as:
>
> 
>
>"[PR]L. VILLENEUVE &"
>
> 
>
>My problem is that it's nearly impossible to correct this description
>to
>"Villeneuve". I can type V, Vi, or even Villeneuve into the description
>and,
>upon pressing enter, it will jump back to the original description
>(because,
>apparently, that string is in the original version of the field,
>despite in
>being in a different case). Even typing Villeneuve doesn't work.
>The
>only way it will retain my lower-case version is if I type
>Villeneuve, which it will keep (because Villeneuve
>followed
>two spaces is not in the original).
>
> 
>
>I understand why Gnucash needs to consider Villeneuve and VILLENEUVE as
>being the same entry, but not why it can't see that a manual override
>to
>"Villeneuve" should be reverted back to "[PR]L. VILLENEUVE &". There
>must be
>a way to say I want to enter my own version of the name!
>
> 
>
>This is driving me crazy!
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Changes to transaction entry, and quirks

[David T. via gnucash-user]

Hello, 

I am not sure exactly what changes have been implemented in the transaction 
entry logic, but I've begun seeing GnuCash offer me ancient transactions as 
templates for current data entry. So, instead of giving me a recent 
transaction, I end up with a transaction from 12 years ago. 

From the prompt, it's not possible to know that this is happening before 
accepting the suggestion; once accepted, I have to cancel the transaction and 
start over-- if I notice that the transaction is wrong! Moreover, since almost 
everything in my financial world has changed during my use of GnuCash, I am 
finding that I accidentally put transactions into unplanned and inappropriate 
accounts. This is even more troubling since I've found that GnuCash will add 
these transactions despite the destination accounts being placeholder accounts. 

I am pretty sure that this didn't happen in earlier versions, but I'm known to 
be wrong more often than not. 

Short of splitting my file apart (which I'm loath to do), is there any way to 
alter the suggestion list so that it doesn't offer me outdated transactions? 
Can I delete entries from the list? Can I tell it not to use transactions that 
involve placeholder accounts? 

And on a related note, I've found that the suggester does not always respect 
different character strings, and will conflate different strings into one 
transaction. What I mean is this: I previously entered a transaction with the 
description "Payment- Credit Card" (note the spacing with the hyphen).  This 
transaction transferred money to an account that is now a placeholder account. 
I now prefer "Payment - Credit Card" (again, note the spacing with the hyphen). 
When I type "Payment -" with the preceding space, I *should* get the new 
version of the transaction (and that is what displays in the prompt)-- but when 
I tab out of the field, the *old* transaction gets inserted instead of the new. 
I don't understand how this happens, but it has happened numerous times for me. 

⁣David T. ​
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transactions in Placeholder

[David T. via gnucash-user]

I'm going to follow up my own message to note that I have now found that 
GnuCash 4.13 under Windows 10 will add transactions to a placeholder account 
even while displaying a message stating that it cannot write transactions to 
placeholder accounts! 

I've just had GnuCash do this twice, when it used an ancient transaction as a 
template (I'll write about that in a different thread shortly) that has an 
account that I have since set as a placeholder account and hidden because it is 
closed. 

Something is clearly broken here.

⁣David T. ​

On Apr 29, 2023, 9:44 PM, at 9:44 PM, "David T. via gnucash-user" 
 wrote:
>Michael, 
>
>The OP problem had to do with the importer adding transactions to a
>placeholder account. So that's why I am discussing that, rather than
>bringing up the creation of new accounts in the process. I'm not even
>sure how that applies here; a newly-created account during the import
>process (if such is even achievable in the import process) would
>presumably not be set as a placeholder account. 
>
>GnuCash already prevents a user from entering transactions into a
>placeholder account-- and even prevents you from opening such accounts
>without an explicit (non standard) open mode. The only way I know of
>entering transactions into a placeholder account is to turn off the
>setting first. Of course, then, it's not a placeholder account...
>
>Again, in my example, you're missing the point. I'm not talking about
>the special case where a user has elevated rights and logs in specially
>to use them. I'm talking about a system allowing any user to change any
>file-- or worse, a system changing them as a result of some other
>action I took. If I, as a regular user, were to overwrite YOUR files,
>you'd be rather upset.
>
>I'll repeat: adding transactions to a placeholder account during an
>import should not be possible, since it violates the GnuCash definition
>of a placeholder account. 
>
>⁣David T. ​
>
>On Apr 29, 2023, 6:17 PM, at 6:17 PM, Michael or Penny Novack
> wrote:
>>On 4/29/2023 10:08 AM, David T. wrote:
>>> Michael,
>>>
>>> I disagree. The importer shouldn't put transacting into an account 
>>> that is--by definition-- write protected.
>>>
>>> My counter example would be a write-protected file folder. An 
>>> operating system that allowed a user to put data into a 
>>> write-protected folder would come in for serious criticism.
>>>
>>> Temporary records should go somewhere, for sure. It's been my 
>>> experience that GnuCash uses Imbalance-xxx for such transactions.
>Why
>>
>>> would you ever expect to put them in write-protected accounts?
>>>
>>You are talking about the  behavior of the IMPORTER.
>>
>>Your proposed solution would affect ANY entry of transactions.
>>
>>And an operating system SHOULD allow writing into a write protected 
>>folder whenever the person (or program) doing so has sufficient
>>"rights" 
>><< normally when I am logged in it is WITHOUT admin rights (even on my
>
>>home system) -- bear in mind decades in the cypher mines where I had
>to
>>
>>be very conscious of whether I was using my ordinary login or my
>>"prod*" 
>>log in. Like in the middle of the night emergency fix to a hanging 
>>production program -- doing this during the day I would walk over to
>>the 
>>desk of whoever normally handled "builds" and have them do the 
>>replacement of the program in the production library>>
>>
>>Michael
>>
>>PS --- By all means ask for a change to the behavior of the importer
>if
>>
>>you think that is in order. But actually what you want is that the 
>>importer verify that it isn't specifying an account that does not
>exist
>>
>>OR one that is a placeholder. We used to call something like the the 
>>"input editor" portion of a transaction handling program.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transactions in Placeholder

[David T. via gnucash-user]

Michael, 

The OP problem had to do with the importer adding transactions to a placeholder 
account. So that's why I am discussing that, rather than bringing up the 
creation of new accounts in the process. I'm not even sure how that applies 
here; a newly-created account during the import process (if such is even 
achievable in the import process) would presumably not be set as a placeholder 
account. 

GnuCash already prevents a user from entering transactions into a placeholder 
account-- and even prevents you from opening such accounts without an explicit 
(non standard) open mode. The only way I know of entering transactions into a 
placeholder account is to turn off the setting first. Of course, then, it's not 
a placeholder account...

Again, in my example, you're missing the point. I'm not talking about the 
special case where a user has elevated rights and logs in specially to use 
them. I'm talking about a system allowing any user to change any file-- or 
worse, a system changing them as a result of some other action I took. If I, as 
a regular user, were to overwrite YOUR files, you'd be rather upset.

I'll repeat: adding transactions to a placeholder account during an import 
should not be possible, since it violates the GnuCash definition of a 
placeholder account. 

⁣David T. ​

On Apr 29, 2023, 6:17 PM, at 6:17 PM, Michael or Penny Novack 
 wrote:
>On 4/29/2023 10:08 AM, David T. wrote:
>> Michael,
>>
>> I disagree. The importer shouldn't put transacting into an account 
>> that is--by definition-- write protected.
>>
>> My counter example would be a write-protected file folder. An 
>> operating system that allowed a user to put data into a 
>> write-protected folder would come in for serious criticism.
>>
>> Temporary records should go somewhere, for sure. It's been my 
>> experience that GnuCash uses Imbalance-xxx for such transactions. Why
>
>> would you ever expect to put them in write-protected accounts?
>>
>You are talking about the  behavior of the IMPORTER.
>
>Your proposed solution would affect ANY entry of transactions.
>
>And an operating system SHOULD allow writing into a write protected 
>folder whenever the person (or program) doing so has sufficient
>"rights" 
><< normally when I am logged in it is WITHOUT admin rights (even on my 
>home system) -- bear in mind decades in the cypher mines where I had to
>
>be very conscious of whether I was using my ordinary login or my
>"prod*" 
>log in. Like in the middle of the night emergency fix to a hanging 
>production program -- doing this during the day I would walk over to
>the 
>desk of whoever normally handled "builds" and have them do the 
>replacement of the program in the production library>>
>
>Michael
>
>PS --- By all means ask for a change to the behavior of the importer if
>
>you think that is in order. But actually what you want is that the 
>importer verify that it isn't specifying an account that does not exist
>
>OR one that is a placeholder. We used to call something like the the 
>"input editor" portion of a transaction handling program.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transactions in Placeholder

[David T. via gnucash-user]

Michael, 

I disagree. The importer shouldn't put transacting into an account that is--by 
definition-- write protected. 

My counter example would be a write-protected file folder. An operating system 
that allowed a user to put data into a write-protected folder would come in for 
serious criticism.

Temporary records should go somewhere, for sure. It's been my experience that 
GnuCash uses Imbalance-xxx for such transactions. Why would you ever expect to 
put them in write-protected accounts? 

⁣David T. ​

On Apr 29, 2023, 4:52 PM, at 4:52 PM, Michael or Penny Novack 
 wrote:
>On 4/29/2023 2:39 AM, David T. via gnucash-user wrote:
>> There's no hard rule either way. Some users feel strongly about not
>having any transactions in placeholder accounts, though, and advocate
>loudly on the list in support of it.  But there's nothing in the
>software preventing a placeholder account having transactions in it.
>>
>> That said, the importer really shouldn't put transactions into a
>placeholder, since the whole point of the placeholder designation is to
>prevent transactions from being put there. That sounds like a bug.
>
>I wouldn't go so far as to call it a bug. Do we really need a prevent 
>stupid mistake fence here? A hard fence? << a soft fence that can be 
>enabled/disabled as a user option significantly more work >>
>
>In the normal course of things, the logical INTENT of having a 
>placeholder account is that it is an account concept (sort of account) 
>that has a number of child  accounts dividing that concept up in finer 
>detail. That said 
>
>Consider the work flow ... you are entering transactions and in that 
>process find you have a number within that concept that do NOT properly
>
>fit any of the existing child accounts. Yes you can create accounts on 
>the fly BUT you might immediately see that once you have created this 
>new child or children, SOME of the transactions currently recorded in 
>one or more of the preexisting children really should be moved to one
>of 
>these new children.
>
>In other words, you have work to do, and maybe in the middle of
>entering 
>transactions not the best place to do that work. I, for one, do not
>want 
>to ever interrupt the task of entering a stack of transactions because 
>THAT is a possible source of error, one that gnucash or any other 
>accounting app does not protect us from << getting wrong where we were 
>when resuming entering that stack; do one twice or miss one >>
>
>SO  I like it that I could temporarily enter these transactions
>into 
>the parent and leave the clean-up for a later time. The presence of 
>transactions in the parent that is logically a placeholder serves as a 
>reminder "you've got work to do here" << for THAT reason I would use
>the 
>following work flow for that --- first create the new child/children, 
>second move any in the preexisting children that better fit here, and 
>only last distribute those in parent to the proper children. That way, 
>if this task is interrupted, the transactions remaining in the parent 
>serve to indicate "not done yet". And in exceptional situations maybe 
>you want to leave an oddball transaction there  (in the parent) because
>
>you do not expect there to be others oddball in the same way.
>
>So I would prefer using gnucash with the option "allow" (transactions
>in 
>parent intended as a placeholder) trusting my good sense from keeping
>me 
>from ACCIDENTALLY entering a transaction there.
>
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transactions in Placeholder

[David T. via gnucash-user]

There's no hard rule either way. Some users feel strongly about not having any 
transactions in placeholder accounts, though, and advocate loudly on the list 
in support of it.  But there's nothing in the software preventing a placeholder 
account having transactions in it. 

That said, the importer really shouldn't put transactions into a placeholder, 
since the whole point of the placeholder designation is to prevent transactions 
from being put there. That sounds like a bug. 

⁣David T. ​

On Apr 29, 2023, 8:30 AM, at 8:30 AM, Fred Tydeman  
wrote:
>My understanding is Placeholder accounts should have zero transactions
>in
>them.
>
>However, when I Import a QIF file, sometimes I end up with transactions
>in
>a Placeholder account.
>
>It would be nice if the importer would give a warning about putting
>transactions into a Placeholder account.  That way, I could pick a
>different account to import into.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] [Bug 798864] Budget Revalues for the Income are positive numbers.porting on select reports are wrong

[David T. via gnucash-user]

Richard,

Just a note that if you reply to Christopher's bug messages by email, the 
discussion at the bug website is incomplete. You and the community would be 
better served by your replying in the bug itself.

David T.​

On Apr 17, 2023, 11:02, at 11:02, Richard Lindgren  
wrote:
>Sounds like you understand my problem. However, since I'm not a
>programmer, I hesitate to tackle this patch. Maybe it is easier than it
>looks and is probably the best fix? I'm just nervous here.
>
>Let me ask this basic question. When I am creating my Budget, I have
>assumed this:
>1. All Income values are positive numbers.
>2. All Expense values are negative numbers.
>
>With that being said and used, my reports work for; a) Profit and Loss
>Report and b) my Budget Report.
>
>Now the question is, where do I go from here?
>
>Richard
>
>-Original Message-
>From: bugs-ad...@bugs.gnucash.org 
>Sent: Monday, April 17, 2023 12:19 AM
>To: rlindgr...@outlook.com
>Subject: [Bug 798864] Budget Reporting on select reports are wrong
>
>https://bugs.gnucash.org/show_bug.cgi?id=798864
>
>--- Comment #7 from Christopher Lam  ---
>Created attachment 374682
>  --> https://bugs.gnucash.org/attachment.cgi?id=374682=edit
>candidate patch
>
>Here's a candidate replacement for budget-income-statement.scm, or the
>patch pasted below. You can overwrite the budget-income-statement.scm
>somewhere into the Program Files\gnucash\etc...\ (you'll need admin
>access).
>
>It changes the definition of net-income from simple summation to a
>recalculation of balances of both income and expense budget amounts. I
>think this is the correct fix.
>
>modified   gnucash/report/reports/standard/budget-income-statement.scm
>@@ -428,7 +428,11 @@
>   (gnc:get-assoc-account-balances-total expense-account-balances))
>
>  (net-income
>-  (gnc:collector- revenue-total expense-total))
>+  (gnc:collector-
>+   (gnc:get-assoc-account-balances-total
>+(get-assoc-account-balances-budget
>+ budget (append revenue-accounts expense-accounts)
>+ period-start period-end
>gnc:budget-account-get-net
>
>  (table-env
>   (list
>
>--
>You are receiving this mail because:
>You are on the CC list for the bug.
>You reported the bug.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hidden Accounts

[David T. via gnucash-user]

For what it's worth: https://bugs.gnucash.org/show_bug.cgi?id=397135

⁣David T. ​

On Apr 15, 2023, 8:19 AM, at 8:19 AM, "David T. via gnucash-user" 
 wrote:
>That's the behavior since 2006. I never paid attention to the dialog,
>which is incorrect. To hide the account in the transfer drop down, you
>do have to set it as a Placeholder as well. There's a bug about this
>that has a long discussion about it. I can't find it right now. 
>
>⁣David T. ​
>
>On Apr 15, 2023, 3:29 AM, at 3:29 AM, Gyle McCollam
> wrote:
>>when you edit an account and select hidden the pop up tip/dialogue
>says
>>"This account (and any sub-accounts) will be hidden in the account
>tree
>>and will not appear in the popup account list in the register." (see
>>photo), but they do appear in the register when selecting an account
>in
>>the transfer column of the register.  Am I wrong in thinking this
>>should not be happening?  The only way I can have them not show up is
>>to make it a placeholder account.  If these should not be showing up,
>I
>>will file a bug report.
>>
>>PS I tried to snip this, but the dialog/tip would disappear so I had
>to
>>take a picture with my phone.
>>
>>
>>Thank You,
>>
>>Gyle McCollam
>>
>>Gyle McCollam
>>
>>gmccol...@live.com<mailto:gmccol...@gyleshomes.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
>>-
>>Please remember to CC this list on all your replies.
>>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Hidden Accounts

[David T. via gnucash-user]

That's the behavior since 2006. I never paid attention to the dialog, which is 
incorrect. To hide the account in the transfer drop down, you do have to set it 
as a Placeholder as well. There's a bug about this that has a long discussion 
about it. I can't find it right now. 

⁣David T. ​

On Apr 15, 2023, 3:29 AM, at 3:29 AM, Gyle McCollam  wrote:
>when you edit an account and select hidden the pop up tip/dialogue says
>"This account (and any sub-accounts) will be hidden in the account tree
>and will not appear in the popup account list in the register." (see
>photo), but they do appear in the register when selecting an account in
>the transfer column of the register.  Am I wrong in thinking this
>should not be happening?  The only way I can have them not show up is
>to make it a placeholder account.  If these should not be showing up, I
>will file a bug report.
>
>PS I tried to snip this, but the dialog/tip would disappear so I had to
>take a picture with my phone.
>
>
>Thank You,
>
>Gyle McCollam
>
>Gyle McCollam
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Locking the side bar items

[David T. via gnucash-user]

Honestly, the button could be removed altogether in my opinion. The close "X" 
on tabs is pretty standard in other apps, and has the benefit of being a direct 
action that most users understand intuitively. 

⁣David T. ​

On Apr 12, 2023, 1:07 AM, at 1:07 AM, Adrien Monteleone 
 wrote:
>I agree, the button could be more precise in its label.
>
>The tool tip in the status bar on hovering that button says, "close the
>
>currently active page".
>
>The functionality of that button and the entire toolbar (the UI really)
>
>is also covered in the Manual.
>
>I'd say this is a, "read the manual" sort of problem and GnuCash is 
>working as intended.
>
>Regards,
>Adrien
>
>On 4/11/23 4:12 PM, Gyle McCollam wrote:
>> The button in the toolbar should say "Close Tab", that would make it
>clearer.  In windows, the OP should get used to closing Gnucash with
>the "X" in the upper right corner.  As for the tabs, under
>Edit/Preferences/Windows and then the heading Tabs you can select to
>put a "Close Button" actually an "X" on each tab to close that tab.
>That way you don't have to memorize Crtl+W or Alt+F4, not that it is
>that difficult.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Cannot adjust right-hand column widths

[David T. via gnucash-user]

This *is* documented in the Guide.  

https://www.gnucash.org/docs/v5/C/gnucash-guide/basics-running-gnucash.html#basics-register2

⁣David T. ​

On Apr 3, 2023, 2:54 PM, at 2:54 PM, William Prescott  
wrote:
>Thanks David H.
>
>I had never mastered it before, but playing with the column widths in
>light of your email, I now see how to get it to do what I want..
>
>Will
>
>On Apr 3, 2023, at 05:12, David H  wrote:
>
>The Description column is a special case in that it auto re-sizes to
>fill
>the available width.  Always work from right most column (i.e. Balance)
>to
>the left most column.  Double click each header in turn to size the
>column
>automatically OR drag the right hand side column header delimiter left
>or
>right to adjust the column width.  When you are happy with all other
>columns then either double click the Description column header or left
>click and hold the right side delimiter and drag it sideways  a couple
>of
>cm's then just let it go to trigger it to auto adjust one final time.
>
>Cheers David H.
>
>On Mon, 3 Apr 2023 at 20:37, Nigel  wrote:
>
>> All columns can be resized except Description. This means that the
>> Balance column is not wide enough to display fully.
>> Regards,
>> Nigel
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Security timezone

[David T. via gnucash-user]

When I reconcile my brokerage account statements with my GnuCash books, I 
reconcile actual transactions and ensure that commodity balances are correct. 
As long as those are accurate, the valuation at any given time is essentially 
arbitrary; it only becomes important at the time of sale. 

A valuation at any given point only serves to make you feel something--good for 
how high it is, bad if it is lower than your hope.

⁣David T. ​

On Apr 2, 2023, 11:37 AM, at 11:37 AM, Fred Tydeman  
wrote:
>I am talking about price quotes.  I am trying to get month end and
>quarter
>end valuations.
>So that I can compare what GnuCash has versus statements from broker
>(to
>see if I have
>any missing or wrong transactions).
>
>In a couple of years, I plan on living full time on a ship as it
>travels
>around the world.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Security timezone

[David T. via gnucash-user]

I hesitate to jump in, since John is so much more knowledgeable and informed, 
but his reply (and my understanding of the back side functioning in this area) 
would suggest that the quote source doesn't usually include any time zone 
information, and the time zone that GnuCash inserts into its data set is chosen 
specifically to ensure that quote dates won't change when viewed in different 
times zones. So, it's not clear to me why you would encounter date changes. 

That being said, I have a few questions, the first being, how long is your 
trip? If it's a short term thing, perhaps you can accept the discrepancy until 
you return to your home time zone, at which time the shift would presumably 
revert to your expectation.  

The second is, how important is it to know that a given price relates to 
Monday, as opposed to Tuesday? My experience is that the specific dates of such 
valuations is secondary to the general valuation at some point in time. Any 
concern with a specific date and time is either related to an actual event 
(purchase/sale), or is due to my own obsessive nature. The former gets handled 
in the actual transaction, while the latter takes therapy.  ;)

The third is, are you actually discussing price quotes, or perhaps 
transactions? Your initial query refers to securities, while John interpreted 
that to mean price quotes. Transactions can have more specific times associated 
with them (although I can't imagine an actual security having any sort of time 
attached to it). Perhaps this is a source of confusion in this exchange? 

⁣David T. ​

On Apr 2, 2023, 6:41 AM, at 6:41 AM, Fred Tydeman  
wrote:
>I am on a trip where I am 10 hours ahead of home timezone.
>So prices appear to be one day ahead of home time
>with the default of Local timezone.
>So, I am hoping that picking New York timezone will help.
>
>On Sat, Apr 1, 2023 at 8:54 PM john  wrote:
>
>> There's nothing to do either.
>>
>> Do you have a price-source that actually sets a time? Most don't so
>we set
>> the default time (10:59 AM UTC) so that the date is right in all
>timezones.
>>
>> Regards,
>> John Ralls
>>
>>
>> > On Mar 31, 2023, at 10:51 PM, Fred Tydeman 
>> wrote:
>> >
>> > Is there a way to set a default timezone for adding security?
>> > Is there a way to mass change the timezones for existing
>securities?
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please remember to CC this list on all your replies.
>> > You can do this by using Reply-To-List or Reply-All.
>>
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Exporting reports to spreadsheet

[David T. via gnucash-user]

You could always forego the export aspect altogether. In the report window of 
GnuCash, select the entire report (Ctrl-A), copy the data (Ctrl-C), switch to 
LibreOffice (Alt-Tab), and paste your data (Ctrl-V). Finally, save the 
LibreOffice as a spreadsheet file, which should assign it the proper formatting 
and extension. 

⁣David T. ​

On Mar 29, 2023, 8:27 PM, at 8:27 PM, Patrick James 
 wrote:
>George,
>
>This is a Windows 'feature,' as Windows has file extension
>associations.
>
>If you do a quick online search, you should be able to find the
>instructions on how reassign the association of the ".ods" extension to
>LibreOffice Calc.
>
>Alternatively, try right-clicking the icon and selecting "Open with" 
>
>> On 03/29/2023 9:11 AM George Riner  wrote:
>> 
>>  
>> The setting:
>> 
>> Windows 10
>> Gnucash 4.13
>> 
>> When I Export a report I've been supplying a windows extension of 
>> ".ods". Which I assumed would cause that exported report file to open
>in 
>> some OpenDocumentSpreadsheet application, in my case: LibreOffice
>Calc.
>> 
>> But it doesn't do that. I double-click the file to open it in the 
>> default application and it opens in LibreOffice Writer.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error in "Close Book" help text

[David T. via gnucash-user]

Michael, 

I certainly agree with your concerns.

My statement includes my own implication that a good documentarian would 
explain the broader purpose of the feature as well as its results and means to 
manage it. My initial statement was terse enough that this aspect was missing. 

To explicate further, the documents would include: 

* a brief note regarding the reason for closing the books (i.e., the 
historical); 

* an explanation of what exactly the GnuCash CB feature does; 

* an explanation of how to reverse it; and,

* a description of how some reports handle the results. 

David T. 

P.S. I would hesitate to address users' misunderstandings of the accounting 
principles in GnuCash documentation for the reasons you often cite. I am not an 
accountant and rules vary by jurisdiction. I've always attempted just to 
explain clearly what the software *does* and let users figure out what they 
want to do with it based on those capabilities. 



On Mar 25, 2023, 4:57 PM, at 4:57 PM, Michael or Penny Novack 
 wrote:
>On 3/25/2023 4:28 AM, David T. wrote:
>> Michael,
>>
>> As a past documentation contributor, I'd assume any person taking up 
>> this bug would attempt to document the functionality of the newly 
>> added feature, regardless of the initial bug request.
>>
>> David T.
>
>What I meant is that it is easy for those inexperienced with 
>bookkeeping, especially those who never did it the old way, to conflate
>
>"close the books" (as a logical operation) and "close the books" using 
>this particular gnucash tool. We see lots of this sort of confusion
>with 
>"opening the books" using the opening value wizard vs doing it the old 
>fashioned way with explicit transaction(s)  to enter the initial
>values.
>
>It might seem unnecessary since most newbies hopefully read the 
>tutorial, etc. but some new to gnucash but experienced with other 
>similar software (like QuickBooks  not Quicken) or very experienced
>
>with old fashioned bookkeeping might jump right in and do things the
>old 
>way (without the shortcut/tools). This is also just like the 
>(unexpected?) behavior that to specify options for a report you first 
>run the report default and THEN  use edit=?options to specify the
>options.
>
>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
-
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 in "Close Book" help text

[David T. via gnucash-user]

Michael,

As a past documentation contributor, I'd assume any person taking up this bug 
would attempt to document the functionality of the newly added feature, 
regardless of the initial bug request.

David T.​

On Mar 25, 2023, 02:31, at 02:31, Michael or Penny Novack 
 wrote:
>On 3/24/2023 5:48 PM, Adrien Monteleone wrote:
>> When you first click 'New' or 'File a Bug', you get the option to 
>> select Documentation. (see screenshot) I'm not sure if you can move
>it 
>> after filing, but if not, one of the devs can do that for you. 
>
>Care should be used in defining this bug. The documentation change 
>should make it clear that this refers to closing the books using the 
>built in clod=se the books tool.
>
>As opposed to the logical/bookkeeping process "close the books" itself 
>(possibly done without the tool, in other words, "manually". THOSE 
>transactions would probably not be recognized as special. In which case
>
>would still need to be careful to run the Income
>Statement/P/Statement 
>of Revenues and Expenses (the different names refer to how different 
>types of entities know this report) BEFORE closing the books.
>
>If LITERALLY modelling the old way, would have closed to a special 
>account with a name like P and then THAT closed to equity by the net 
>profit of loss that brings it to zero.
>
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Error in "Close Book" help text

[David T. via gnucash-user]

If you've ever filled out an online form before, you should be fine. I'd simply 
copy your original email and paste it in the description. 

David T. 



On Mar 24, 2023, 11:44 PM, at 11:44 PM, Stan Brown  
wrote:
>Sigh. You're right, of course. I've never filed a bug report before, so
>I was hoping someone else would do it for me. But I'll figure it out --
>it's the least I can do in return for all the benefits I receive from
>using GnuCash.
>
>Stan Brown
>Tehachapi, CA, USA
>https://BrownMath.com
>
>On 2023-03-24 12:46, Adrien Monteleone wrote:
>> Maybe file a documentation bug for tracking?
>> 
>> Regards,
>> Adrien
>> 
>> On 3/23/23 6:06 PM, Stan Brown wrote:
>>> In 4.13, the Close Book help text, which is the Close Book section
>of
>>> the installed manual, includes the following text under "How It
>Works",
>>> as the second paragraph under "Necessity":
>>>
>>> "In fact, closing the books reduces the usefulness of the standard
>>> reports because the reports don’t currently understand closing
>>> transactions. So from their point of view it simply looks like the
>net
>>> income or expense in each account for a given period was simply
>zero. "
>>>
>>> That paragraph doesn't seem to be accurate any more. I closed the
>books
>>> in 4.13 and the ran an income statement for the full year. The
>account
>>> totals were given just as they were before I closed the book.
>>>
>>> Can whoever is maintaining the book look at deleting that paragraph,
>>> please? (And please note: This is the installed manual, not the one
>on
>>> the website. I have GnuCash running in a virtual machine with no
>>> Internet.)
>>>
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Finance Quote problem MacOS High Sierra.

[David T. via gnucash-user]

R.,

Generalizations aren't helpful, especially if they aren't fully accurate.

To assert that "one can forget Windows entirely" is contradicted by many users' 
experiences to the contrary. F::Q has worked for me under Windows for many 
years (and on Mac before that).
⁣
David T.​

On Mar 20, 2023, 22:38, at 22:38, R Losey  wrote:
>I'm impressed that you got this running on the iMac; I only have this
>working on Linux (and one can forget Windows entirely).
>
>
>On Sun, Mar 19, 2023 at 4:51 PM G R Hewitt  wrote:
>
>> Hello everyone,
>> Gnucash 4.13
>> Finance Quote 1.54
>> MacPro 2010 High Sierra
>> iMac 2017 Ventura
>>
>> After hours of much aggravation - don't ask ' I eventually got
>Finance
>> Quote 1.54 to install, the 'Get Quotes' button was active and I was
>well
>> pleased with myself.
>>
>> Anyway, on pressing it I got the dismaying message:
>> 'Unable to retrieve quotes for these items: CURRENCY:EUR'
>>
>> I have searched for answers and found none.
>>
>> Can anyone point me in the right direction, please to solving this.
>>
>> Thanks in advance.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>-- 
>_
>Richard Losey
>rlo...@gmail.com
>Micah 6:8
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Temporary Website URL

[David T. via gnucash-user]

Brad, 

I just want to note that your acquaintance has a remarkably parochial attitude 
about software. GnuCash has been available and actively developed for something 
like 25 years.

It seems to me that in this era of "big data," those commercial companies are 
more interested in the customer as a source of data mining income than as a 
partner using their software.

*And* outages with major commercial platforms (Twitter, Facebook?) underscore 
that it is not just open source projects that fail sometimes. 

David T. 



On Mar 18, 2023, 4:21 PM, at 4:21 PM, Robert Heller  wrote:
>At Sat, 18 Mar 2023 06:04:52 -0700 Brad Morrison
> wrote:
>
>> 
>> Thanks for point these situations out Ken! The reason I joined the 
>> GnuCash-User mailing lists was because I sent a link to an
>acquaintance 
>> that does bookkeeping professionally and he texted back that the
>website 
>> was down, he then did a Google search and tried the GnuCash result on
>
>> his own and that link didn't work either, and he then goes on to tell
>me 
>> that this is why he doesn't trust open source projects with his
>business 
>> or his clients' business. It was pretty embarrassing for me and I
>have 
>> hesitated to refer any possibly interested professionals that I meet
>to 
>> GnuCash since.
>> 
>> I can confirm the certificate error for website #1. It looks like 
>> gnucash.org uses Let's Encrypt (https://letsencrypt.org/) as the 
>> certificate authority and the certificate was valid from December 12,
>
>> 2022 until March 11, 2023. My understanding was that Let's Encrypt
>was 
>> free, so that might mean that it just has to be
>renewed/reauthorized...?
>
>Let's Encrypt uses a program "certbot" which is supposed to
>automagically 
>renew the certificate.  It does try to verify the domain it is for by
>visiting 
>the website.  Since there was a webserver config problem (the redirect
>config 
>was broken), it is likely that the automagical renewal failed...
>
>> 
>> I can confirm that website #2 still lists the "Apache2 Ubuntu Default
>
>> Page" error for the non-https/secure gnucash website. I believe that 
>> John mentioned that Linas upgraded his server in January and that
>broke 
>> this feature and it has not been fixed since.
>> 
>
>Yes, this webserver config error needs to be fixed.  Once it is fixed,
>the 
>Let's Encrypt certbot program will be able to renew the certificate,
>which 
>will fix the https://www.gnucash.org error.
>
>> I also see Gnucash website #3 as working well. I can see that that 
>> website also uses Let's Encrypt as the certificate authority and that
>
>> certificate is valid from March 5, 2023 until June 3, 2023.
>> 
>> I also noticed that website #1 & #2 has 2 "Subject Alt Names" 
>> (gnucash.org & www.gnucash.org) on that certificate, while website #3
>
>> has just 1 (code.gnucash.org).
>
>Yes, this is a "normal" thing.  Almost all www.xxx.yyy hostnames refer
>to the 
>same logical host as xxx.yyy -- eg while commonly normal websites start
>with 
>www, most also work without the 'www.'.
>
>> 
>> After briefly reading a few of the mailing list messages on US 
>> banks/credit unions that are not allowing their transaction to be 
>> downloaded/available in an open format, I have also wanted to start 
>> emailing various financial institutions about whether they intend to 
>> make such a format available. I would still need to further review
>the 
>> formatting situation described in the email chains before I start
>asking 
>> around and then opening an account at such a financial institution,
>but 
>> if the main GnuCash website still doesn't work, it is hard to write
>such 
>> emails at all.
>> 
>> Brad
>> 
>> 
>> On 3/17/23 11:00, Ken Pyzik wrote:
>> > So checking websites statuses today:
>> >
>> > https://www.gnucash.org  - privacy/certificate error
>> > http://www.gnucash.org  - Default appache2 page
>> > https://code.gnucash.org/website  - working perfectly.
>> >
>> > As noted - this has been an issue since 11 February.  The https://
>was working at one point a couple of weeks ago -- but now it is not.
>> >
>> > FYI -- Ken
>> >
>> > -Original Message-
>> > From:
>gnucash-user  On
>Behalf Of John Ralls
>> > Sent: Sunday, February 19, 2023 3:40 PM
>> > To:gnucash-annou...@lists.gnucash.org
>> > Cc: gnucash-devel; Gnucash
>Users
>> > Subject: [GNC] Temporary Website URL
>> >
>> > As most everyone already knowswww.gnucash.org  has been offline
>since 11 February because Linas Vepstas lost internet access and his
>ISP, Grande Networks in Austin, TX, has not fixed it.
>> >
>> > To provide replacement service until Linas gets back online we've
>set up an alternate site,https://code.gnucash.org/website/.
>> >
>> > Regards,
>> > John Ralls
>> >
>> > ___
>> > gnucash-user mailing list
>> > gnucash-user@gnucash.org
>> > To update your subscription preferences or to unsubscribe:
>> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> > -
>> > Please 

Re: [GNC] Change column widths

[David T. via gnucash-user]

Of course, reading 2.9.2.3. Setting Column Widths in the Guide might also help 
you out. 

David T. 



On Mar 13, 2023, 10:45 PM, at 10:45 PM, David H  wrote:
>Ops that should read...
>
>Personally I always start by double clicking the very rightwardcolumn
>and
>working towards the Description column leaving that until last.
>
>Cheers David H.
>
>On Tue, 14 Mar 2023 at 05:41, David H  wrote:
>
>> James/Bjorn
>>
>> ALWAYS adjust columns leaving the Description column to last as this
>> particular column is a special case and expands to fill the remaining
>> width.  So adjust the Transfer column first - double click on its
>header or
>> click on the right hand header delimiter and drag to the right.  When
>it's
>> where you want it to be then go back to the description column and
>either
>> double click the Description header OR click the right hand column
>> delimiter, drag it to the left and release.
>>
>> Personally I always start by double clicking the very leftward column
>and
>> working towards the Description column leaving that until last.
>>
>> Cheers David H.
>>
>> On Tue, 14 Mar 2023 at 05:29, Björn Sunde
>
>> wrote:
>>
>>> I would like to shorten the width of the Description column and
>increase
>>> the width of the Transfer column as some of the Transfer entries are
>>> very long.  Is there some way to do this?
>>>
>>> Thanks in advance.
>>>
>>> James Wilde
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] importing

[David T. via gnucash-user]

With regard to the import process, were the source files OFX/QFX, by chance? 

That file format includes unique transaction IDs to prevent reimport of 
previously imported transactions. Under the circumstances, I'd opt to manually 
enter the transactions in question and reconcile after.  

David T. 



On Feb 17, 2023, 5:55 AM, at 5:55 AM, Gyle McCollam  wrote:
>Liz,
>Yes, I record all my transactions and then match with bank, credit
>card, etc.  In this case, I think it was the gas stations fault as it
>happened with multiple Mastercard's.  It was nice not having to pay for
>gas for 6 months, but this month the charges showed up on both cards.
>
>
>Thank You,
>
>Gyle McCollam
>
>Gyle McCollam
>
>gmccol...@live.com   email
>
>
>From: gnucash-user 
>on behalf of ed...@billiau.net 
>Sent: Thursday, February 16, 2023 8:57 PM
>To: gnucash-user@gnucash.org 
>Subject: Re: [GNC] importing
>
>On Thu, 16 Feb 2023 23:53:35 +
>Gyle McCollam  wrote:
>
>> I ran into a unique problem with a credit card import.  I was buying
>> gas at a station using a mastercard.  The transaction was on my
>> credit card as pending, but would disappear and not be on my bill.
>> This went on for 6 months, but they finally corrected the problem and
>> billed me for the 6 months of gas this month.  However, when I
>> imported the file it said there were no matching transactions.  I
>> used preferences to change the import parameters, but I could not
>> change the dates to allow for transactions that old.  I could set the
>> proper expense account, but that would double up on the transaction.
>> Is there a way to click or double click on the import matcher and
>> manually select the matching transaction?
>>
>>
>> Thank You,
>>
>> Gyle McCollam
>
>This is an interesting case. Are you recording the credit card
>transactions in your books regardless of the errors of the credit card
>company?
>It is an example of the advantages of maintaining your record from your
>receipts and entering the transactions, because then you would know
>that money was owing, and how much.
>
>If something takes more than about 18 months to show up I remove it
>from active lists but preserve the data in case it turns up eventually.
>I won't specify a method, because it has failings.
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Feature Request

[David T. via gnucash-user]

I include the Last Reconciled Date column in my Chart of Accounts. I can't 
imagine how else that could be highlighted, though. 

David T. 



On Feb 15, 2023, 4:48 PM, at 4:48 PM, "Dr. Gideon Fell"  
wrote:
>   Hope this is the right place for this request. I would like to have 
>UNRECONSIlED  account somehow highlighted in the Account Summary
>report. 
>This could be by color or an asterix when run. With the site down I 
>don't know if this has been asked for or if a later manual/guide/help 
>document addresses this.
>
>Ron B.
>
>
>-- 
>"This is so abstract, it must be topologically invariant" - Raoul Bott
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Huge number of missing transactions

[David T. via gnucash-user]

I'll briefly chime in here to suggest that network issues and potential 
simultaneous access are more likely culprits for your data corruption and loss. 

A search for compatibility issues between GnuCash versions 3.6 and 4.11 did not 
yield any specific changes that would result in the loss of swathes of 
transactions from one version to the other, although access to the same file 
from different major versions isn't really a great idea regardless. 

In all my years of using GnuCash (18 and counting), I haven't heard of any 
documented examples of transaction loss that didn't ultimately have some other 
explanation (hardware failure, user error, unsupported uses, etc.). 

The only remotely-related problem I've personally encountered over the years 
was that at one time (around version 3.1 or so), one of my saved reports kept 
causing the saved reports file to truncate arbitrarily, leaving me without many 
saved reports. I ended up creating my saved reports from scratch, which 
eliminated the problem. But again, that wasn't accounting data; it was the 
supporting reports file. 

David T. 



On Feb 5, 2023, 2:44 AM, at 2:44 AM, Daine Pearson via gnucash-user 
 wrote:
>Sadly, no.. those help docs are pretty basic - I have looked at most of
>
>what can be found in the various docs and generally searching.
>I'll probably need to go to the code repository and look for comments
>or 
>something along those lines.
>
>Still would be good to at least confirm that our actions of accessing 
>the data file with two app versions was the issue.
>It was a pretty devastating number of transactions.
>
>Thanks!
>
>On 2/3/2023 9:11 PM, David H wrote:
>>
>https://wiki.gnucash.org/wiki/FAQ#Q:_What_are_all_these_.gnucash_and_.log_files_filling_up_my_directory.3F
>> https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-backup1.html
>>
>> Might give you an explanation of the log files...
>>
>> Cheers David H.
>>
>> On Sat, 4 Feb 2023 at 10:01, Daine Pearson via gnucash-user 
>>  wrote:
>>
>>
>> Hi all,
>>
>> I do see a few messages spread over the years about similar
>issues
>> but
>> most have gone unanswered so I thought I'd create a new one.
>>
>> My partner and I have been jointly using GNUcash for a few years.
>The
>> XML data files reside on a shared network drive.
>> I recently installed a new Win 10 computer and installed the
>> latest (at
>> the time) 4.11.
>> I did not think about the fact that her system was still running
>> 3.6 -
>> Probably the culprit...
>> Everything seems to have been going fine but yesterday she
>noticed
>> all
>> the payments into a credit card account were gone, leaving quite
>a
>> large
>> negative balance. I looked further and discovered this was true
>> for many
>> accounts but I do not believe any accounts were missing or
>> completely empty.
>> I went into the shared directory and could easily see by the file
>> size
>> that a large data reduction recently occurred as the size
>suddenly
>> drops
>> from ~900KB to ~600KB.
>> There is also a 17MB (136325 lines) log file in that same time
>period.
>> Not so much had happened in the few days after that file size
>drop
>> so I
>> exported some new transactions that had been manually entered in
>the
>> (corrupted) file and saved one of the earlier files as the new
>> data file.
>> I updated both machines to the latest stable 4.13 build, imported
>> those
>> new transactions and just for kicks, ran the repair function
>which
>> did
>> not throw any messages so presumably nothing was fixed.
>> Things seem to be fine but it occurred to me that it would be
>> useful if
>> I understood better what the log files actually might reveal and
>> if they
>> also show actions taken by the program?
>> It seems pretty clear that each new transaction generates a log
>entry
>> but I'm unsure how deletions, moved items, etc., are marked in
>the
>> logs.
>> I'm guessing the letters in the 'mod' column between Start & End
>mean
>> something but not sure what.
>>
>> I presume and hope that something about managing and saving the
>same
>> data file under both versions is what caused the mishap but it
>> would be
>> good to understand the situation better so all thoughts welcome.
>>
>> And presuming sharing files between different program version is
>a
>> danger (which it likely is), I guess it would be helpful if
>> opening an
>> account file would trigger a cancel message if it was last saved
>by a
>> different version, particularly a newer version.
>>
>> Thanks... DP
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please 

Re: [GNC] install 2nd app to start over

[David T. via gnucash-user]

The reference to the "terminal" suggests a Mac, but I'll defer to PH.

PH, it's not clear why you think configuring a transaction report would require 
any coding; most reports have extensive options to select specific transactions 
and accounts, so it's really necessary for you to describe what it is that is 
not happening.

I will note that the standard Transaction Report opens without any data 
initially, and that you must open Options and select accounts to include 
subsequently. But that doesn't involve coding or the terminal; is just clicking 
the Options button on the ribbon and selecting things. 

This is covered in the Tutorial and the Help.

David T. 



On Feb 3, 2023, 8:19 PM, at 8:19 PM, Murugan Muruganandam 
 wrote:
>can you please elaborate what exactly your problem while creating
>transaction report.
>Also please detail your operating system and the version of GNUCash
>
>
>
>
>Saludos Cordiales
>
>
>Murugan
>
>
>From: gnucash-user
> on behalf
>of ph hermes 
>Sent: Friday, February 3, 2023 12:33 PM
>To: Phyllis Bruce 
>Cc: Gnucash Users 
>Subject: Re: [GNC] install 2nd app to start over
>
>thanks phyllis
>
>i'm having a lot of trouble with creating transaction reports. and the
>solutions seem to involve going into terminal and getting code to
>identify
>a bug. to do this i'll have to take my laptop to a computer shop or
>find
>someone who can help me. i have not done this as i've been so busy, so
>i'm
>looking for an easier way for me to work around my problem
>
>yesterday i tried to create a transaction report, clicked on options
>and it
>just ignored me. other issues involve not being able to scroll down the
>whole list past page 1, etc.
>
>   ph
>
>~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:
>writer ~:~ photographer ~:~ book designer
>resident manager
>paulahendricks.com
>
>
>On Thu, Feb 2, 2023 at 10:35 AM Phyllis Bruce 
>wrote:
>
>> Why don't you just start another gnucash file?  Name it something
>> different and take it from there.
>>
>> On Thu, Feb 2, 2023 at 12:32 PM ph hermes 
>wrote:
>>
>>> hi everyone
>>>
>>> i've been struggling with my transaction reports and can't easily
>figure
>>> out how to fix things, so i thought i could install gnu cash again
>and
>>> simply start over (probably a good idea anyway as it's been years on
>the
>>> old file). it's a year when i feel many things could bear with a
>fresh
>>> start.
>>>
>>> can i just install it again? do i need to change the name when
>>> downloading/
>>> saving (ie gnucash-2) etc for latest version?
>>>
>>> any tips?
>>>
>>> thanks.
>>>
>>>ph
>>>
>>> ~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:
>>> writer ~:~ photographer ~:~ book designer
>>> resident manager
>>> paulahendricks.com
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transactions Window Sorting

[David T. via gnucash-user]

I think you meant to address this to me. 

I'm not really sure why you're bringing up the SLR dialog. Are you suggesting 
that the sort order for that dialog is going to affect how the editor window 
sorts? That would be a strange behavior indeed. 

Regardless, the dialog has no sorting capabilities. Neither does it have 
configuration options. 

Changing the sort order, exiting the application, and restarting does not 
result in saved sorting. It *does* save my change to the calendar setting (from 
12 months to 3), so there's that. 

David T. 



On Jan 28, 2023, 8:30 AM, at 8:30 AM, David Carlson 
 wrote:
>Adrien M,
>
>Are you able to sort transactions in the Since Last Run dialog as well
>as
>in the Scheduled Transactions Editor?  Are they still sorted the same
>way
>the next time that you open the Scheduled Transactions Editor?
>
>I think there may be some confusion about when the stickiness arises. 
>I
>think that it only arises in windows that are still open when the
>program
>is shut down with Alt-F-Q, Ctrl-Q, and possibly clicking the upper
>right
>red X in Windows or many Linux desktops.  I have no knowledge about
>Apples.
>
>With that in mind, I think that it would be a nice enhancement if there
>were a way to make the attributes of the current window such as sort
>order,
>window positions and column widths 'stick' in the same way in the user
>settings as they do now when the program is closed, but without
>actually
>closing the program.  I think that this could be added in the
>right-click
>menu for registers, possibly called Freeze Window Attributes.
>
>On Sat, Jan 14, 2023 at 9:03 AM David Carlson
>
>wrote:
>
>> David,
>>
>> I would wait for a reply from one of the more active developers.  I
>do
>> agree with your sentiments.
>>
>> On Sat, Jan 14, 2023 at 8:32 AM David T. via gnucash-user <
>> gnucash-user@gnucash.org> wrote:
>>
>>> Well, thanks for the confirmation.
>>>
>>> I disagree with the conclusion, though. Based on your reasoning,
>>> registers should only save a chronological sort; thankfully, they
>allow
>>> other sort orders for users who prefer them.
>>>
>>> ⁣David T. ​
>>>
>>> On Jan 14, 2023, 4:15 PM, at 4:15 PM, John Layman <
>>> john.lay...@laymanandlayman.com> wrote:
>>> >I'm running 4.13 on Windows 10 and can tell you that sort order is
>>> >'sticky' only if you are sorting on one of the two occurrence
>columns.
>>> >It's a calendar-oriented feature, so I can't say I consider that an
>>> >oversight.
>>> >
>>> >-Original Message-
>>> >From: gnucash-user
>>> > On Behalf
>Of
>>> >David T. via gnucash-user
>>> >Sent: Saturday, January 14, 2023 1:44 AM
>>> >To: Gnucash Users 
>>> >Subject: [GNC] Scheduled Transactions Window Sorting
>>> >
>>> >Hello,
>>> >
>>> >Gnucash 4.13 Windows 10.
>>> >
>>> >As I reacquaint myself with scheduled transactions, I find myself
>>> >opening that window regularly. Each time I open the window,
>>> >transactions are listed in last created order. This despite my
>having
>>> >sorted the list alphabetically the previous time.
>>> >
>>> >My question is this: is there some material reason why the
>Scheduled
>>> >Transactions Window sort order isn't sticky (like most other
>windows in
>>> >GnuCash), or is this simply an oversight?
>>> >
>>> >⁣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
>>> >-
>>> >Please remember to CC this list on all your replies.
>>> >You can do this by using Reply-To-List or Reply-All.
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>> --
>> 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
-
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: What scheduled transactions can't do

[David T. via gnucash-user]

It seems to me that the OP is running up against the fact that GnuCash has 
always been focused on Real, rather than Potential, transactions, since it 
follows a more strict accounting perspective. Users encounter this with 
Scheduled transactions; they encounter it with budgets; they encounter it with 
unrealized gains. Each of these arises in the lists with regularity. 

Since OP mentioned that having a reasonable estimated exchange rate would 
suffice in their situation, BOTH of their asks could be addressed by setting 
the scheduled transactions to create far into the future. The transactions 
would then be real entries in the books, and all the usual reports could be 
used to determine future amounts. 

And yes, there are pitfalls with creating real transactions in the books that 
may not actually get created, but that's a tradeoff. 

David T. 



On Jan 28, 2023, 8:06 AM, at 8:06 AM, David Carlson 
 wrote:
>Would it be possible to rework the Future Scheduled Transactions
>Summary
>report to display the scheduled transactions?
>
>On Fri, Jan 27, 2023 at 4:15 PM Michael or Penny Novack <
>stepbystepf...@comcast.net> wrote:
>
>>
>> > If you mean in number 1 that there's no way to specify a future
>exchange
>> rate, that's correct.
>>
>> ROFL
>>
>> If it were possible for gnucash to CORRECTLY predict what exchange
>rates
>> will be at some future date then I wouldn't be using it just to
>automate
>> my bookkeeping. I'd be using it to make a LOT of money..
>>
>> 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
>> -
>> 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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Gift of stock

[David T. via gnucash-user]

I think it's even more confusing in this case, because tax law does 
occasionally push the original cost basis to the later generation. I do not 
understand how it works, but the recipient "inherits" the original cost basis, 
while the donor declares the value of the gift at market price. I don't profess 
to understand this fully, and I wouldn't ask for advice on this here. It really 
needs an expert in estate planning. 

⁣David T. ​

On Jan 25, 2023, 4:03 AM, at 4:03 AM, David Carlson 
 wrote:
>The US allows gifts to go untaxed within certain limits.   Capital
>gains
>can get interesting as well.  If you're not certain,  talk to your
>accountant.
>
>On Tue, Jan 24, 2023, 6:48 PM Liz Dodd  wrote:
>
>> On Wed, 25 Jan 2023 10:34:51 +1100
>> flywire  wrote:
>>
>> > I doubt your jurisdiction is that naive. I'd expect you'd pay tax
>on
>> > the $25k capital gain on disposal and your son would have a $30k
>> > basis price.
>>
>>
>> I agree, you gave your son the equivalent of $30K, and you get to pay
>> tax on the capital gain.
>> However if your jurisdiction sees it as your son paying the capital
>> gain, then you gave him $5K in your books.
>>
>> 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
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Entering Dividend Confusion

[David T. via gnucash-user]

Try using Transaction Journal view mode. 

Use separate income accounts for Taxed and Untaxed dividends.

⁣
David T.​

On Jan 21, 2023, 11:15, at 11:15, Gnucash Xboxboy Mageia 
 wrote:
>Hi all,
>
>I'm trying to enter dividends, I'm following this video
>https://www.youtube.com/watch?v=WRNoabz1WSo but his page shows columns
>with shares/price/debt/credit, but mine has just buy/sell any ideas?
>How do
>I get those columns?
>
>I'm in Australia, so I wanted to enter dividend payments as 3 types:
>Taxed (franked), Untaxed (unfranked) and the Tax credit (input credit),
>and I reinvest the dividends typically.
>
>Thanks: All advice welcomed.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[David T. via gnucash-user]

Assuming you have the Liabilities and Credit Cards accounts created, it's 
simple.  From the Chart of Accounts page, select the account you want to move 
(e.g., Visa) click the edit button, locate the Parent Account, change it to 
Liabilities:Credit Cards, and click Save. 

Done. 

⁣David T. ​

On Jan 19, 2023, 6:41 PM, at 6:41 PM, Xe Roy  wrote:
>David T.
>
>Thanks.
>Your advice makes sense.
>Since I have already created my credit card accounts as top-level
>accounts and they have about a month's worth of data, is it possible to
>move them to another account?
>Example: move VISA to LIABILITIES > CREDIT CARDS > VISA
>
>
>
>Sent from Outlook
>
>
>From: David T. 
>Sent: Thursday, January 19, 2023 6:02 AM
>To: Xe Roy 
>Cc: Phyllis Bruce ; Fross, Michael
>; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>Just a note that it's more common to structure your GnuCash accounts
>with just five top level accounts:
>
>Assets
>Liabilities
>Equity
>Income
>Expenses
>
>You'd put the "Credit Cards" account under Liabilities, with each
>credit card in its own account within Credit Cards,  like so:
>
>Liabilities
>- Credit Cards
>- - Visa
>- - Mastercard
>
>This groups the accounts in ways that make reporting clearer and
>easier.
>
>David T.
>On Jan 19, 2023, at 2:07 AM, Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>Thanks everyone for your patience.
>I finally got it.
>I had to click on the transaction > click SPLITS > then find the line
>in the splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
>Sent from Outlook
>
>
>
>From: Phyllis Bruce 
>Sent: Wednesday, January 18, 2023 1:00 PM
>To: Fross, Michael 
>Cc: Xe Roy ; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>You will find if you just change your top level account in the
>transaction, the splits will follow it.  Just as Michael described
>above.  I've used jump but I find it just as easy to make that one
>correction.
>Additionally, if you found you chose the wrong account for one of your
>splits, just change it to the correct account and only that split gets
>changed.
>
>Hth - po
>
>On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
>mailto:mich...@fross.org>> wrote:
>When I notice I've placed a transaction in the wrong spot, I "jump" to
>the
>matching transaction and correct the credit card.  For example:
>
>I put my Walmart grocery into the CreditCard1 account instead of the
>CreditCard2 account.  I noticed this in the CreditCard1 account.
>
>1. "Jump" to the matching transaction.  So now I am in the Grocery
>account.
>2. Change that transaction to be CreditCard2 instead of the incorrect
>CreditCard1 account.
>3. Press enter.
>
>The transaction in Grocery is fine, but you'll find it's gone from
>CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>friend.
>
>Michael
>
>On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>I asked this question earlier but initial responses made me realize
>more
> detail was necessary.
>
> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
> A mistake I regularly make is to enter a transaction into the wrong
> account.
> I'll have several accounts open and I just forget to switch.
> In Quicken, I just move the transaction (splits and all) to the new
> account.
>The Internet chatter I've found so far lead me to believe this feature
>is
> missing from gnucash.
>I hope that's not true because it would really cause me excessive
>hassle.
> I hope there is a way to move a transaction (including any splits) to
> another account.
>
> Here is an example which illustrates a typical situation:
> Let's say I have two credit cards, VISA and MASTER CARD.
>Each has their own top-level CREDIT CARD account in gnucash, and each
>has
> its own tab in gnucash.
>I meant to enter a transaction in VISA but accidently entered it in
>MASTER
> CARD.
> The transaction is for $10 with WALMART in the description.
> So, the main entry shows $10 and the splits show $5 to the clothing
> account and $5 to the food account.
>I want to move the entire WALMART transaction, including the splits,
>from
>the MASTER CARD top-level account to the VISA top-level account in one
>easy
> step.
> This is easily doable in Quicken by right-clicking anywhere in the
> transaction, clicking MOVE, and selecting the new account VISA.
> How is this done in gnucash?
>
>
>
> Sent from Outlook
>
>
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -
> Please remember to CC this list on all 

Re: [GNC] How to move a transaction with splits from one top-level account to another - take 2

[David T. via gnucash-user]

Xe Roy,

Just a note that it's more common to structure your GnuCash accounts with just 
five top level accounts:

Assets
Liabilities
Equity
Income
Expenses

You'd put the "Credit Cards" account under Liabilities, with each credit card 
in its own account within Credit Cards,  like so:

Liabilities
- Credit Cards
- - Visa 
- - Mastercard

This groups the accounts in ways that make reporting clearer and easier. 

⁣David T. ​

On Jan 19, 2023, 2:07 AM, at 2:07 AM, Xe Roy  wrote:
>Thanks everyone for your patience.
>I finally got it.
>I had to click on the transaction > click SPLITS > then find the line
>in the splits that says MASTER CARD > change that to VISA > ENTER
>
>
>
>
>Sent from Outlook
>
>
>From: Phyllis Bruce 
>Sent: Wednesday, January 18, 2023 1:00 PM
>To: Fross, Michael 
>Cc: Xe Roy ; gnucash-user@gnucash.org
>
>Subject: Re: [GNC] How to move a transaction with splits from one
>top-level account to another - take 2
>
>Xe Roy,
>
>You will find if you just change your top level account in the
>transaction, the splits will follow it.  Just as Michael described
>above.  I've used jump but I find it just as easy to make that one
>correction.
>Additionally, if you found you chose the wrong account for one of your
>splits, just change it to the correct account and only that split gets
>changed.
>
>Hth - po
>
>On Wed, Jan 18, 2023 at 3:40 PM Fross, Michael
>mailto:mich...@fross.org>> wrote:
>When I notice I've placed a transaction in the wrong spot, I "jump" to
>the
>matching transaction and correct the credit card.  For example:
>
>I put my Walmart grocery into the CreditCard1 account instead of the
>CreditCard2 account.  I noticed this in the CreditCard1 account.
>
>1. "Jump" to the matching transaction.  So now I am in the Grocery
>account.
>2. Change that transaction to be CreditCard2 instead of the incorrect
>CreditCard1 account.
>3. Press enter.
>
>The transaction in Grocery is fine, but you'll find it's gone from
>CreditCard1 and now resides in CreditCard2.  The "Jump" command is your
>friend.
>
>Michael
>
>On Wed, Jan 18, 2023 at 3:31 PM Xe Roy
>mailto:xe...@hotmail.com>> wrote:
>
>> I asked this question earlier but initial responses made me realize
>more
>> detail was necessary.
>>
>> I am a newby to gnucash ... trying to switch from Quicken to gnucash.
>> A mistake I regularly make is to enter a transaction into the wrong
>> account.
>> I'll have several accounts open and I just forget to switch.
>> In Quicken, I just move the transaction (splits and all) to the new
>> account.
>> The Internet chatter I've found so far lead me to believe this
>feature is
>> missing from gnucash.
>> I hope that's not true because it would really cause me excessive
>hassle.
>> I hope there is a way to move a transaction (including any splits) to
>> another account.
>>
>> Here is an example which illustrates a typical situation:
>> Let's say I have two credit cards, VISA and MASTER CARD.
>> Each has their own top-level CREDIT CARD account in gnucash, and each
>has
>> its own tab in gnucash.
>> I meant to enter a transaction in VISA but accidently entered it in
>MASTER
>> CARD.
>> The transaction is for $10 with WALMART in the description.
>> So, the main entry shows $10 and the splits show $5 to the clothing
>> account and $5 to the food account.
>> I want to move the entire WALMART transaction, including the splits,
>from
>> the MASTER CARD top-level account to the VISA top-level account in
>one easy
>> step.
>> This is easily doable in Quicken by right-clicking anywhere in the
>> transaction, clicking MOVE, and selecting the new account VISA.
>> How is this done in gnucash?
>>
>>
>>
>> Sent from Outlook
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] Website from WIki

[David T. via gnucash-user]

Hmm. That is odd. The page identifies itself as the default page when Apache is 
installed under Ubuntu, suggesting an error in the GnuCash web server setup. 
"www.gnucash.org" works properly; "gnucash.org" does not. 

⁣David T. ​

On Jan 15, 2023, 9:32 AM, at 9:32 AM, Fred Tydeman  
wrote:
>I am doing a search (for T-bill) on the gnucash wiki.
>I get the Search Results page (with 181 results).
>On the left side of the page, I click on GnuCash Website.
>That gets me:  Apache2 Ubuntu Default Page
>That seems wrong to me.
>The URL in the address bar of Google Chrome is:  gnucash.org
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] TAX Report WAS Re: reports not working unless exported

[David T. via gnucash-user]

Phyllis, 

Tommy is right. In order for the tax report to work, you must go to Edit->Tax 
Report Options, locate each account in the left entry box, and enter the IRS 
form and line for which the account is relevant in the right box. It is a 
tedious process, but only has to be done once for a set of books (aside from 
changes that must be made as you modify your account structures or the tax code 
changes).

I did this many years ago, and have really liked the ability to get a quick 
snapshot of my overall tax situation in one quick report. Back in the day, you 
could use the report to populate several tax software packages (like TurboTax), 
but in recent years, these programs import forms directly from providers, 
rendering this aspect moot. But I still use this report regularly. 

When I set this up many years ago, it was necessary to assign each account 
separately, as in you had to exit the dialog after every account assigned; more 
recently, the interface has improved just a little bit, in that you can assign 
multiple accounts to the same IRS line at one pass (helpful for interest, 
dividend and capital gains accounts). But you cannot step through all your 
accounts and assign tax options sequentially in the one dialog. I don't know if 
this has changed, but I wouldn't expect it to have changed. 

David T. ​

On Jan 15, 2023, 1:36 AM, at 1:36 AM, Tommy Trussell  
wrote:
>reply below
>
>On Sat, Jan 14, 2023 at 3:49 PM Phyllis Bruce 
>wrote:
>
>> Okay, I can't stand it anymore.  I don't know what ubuntu is, or
>flatpak,
>> or a host of other terms you use.  I run windows and the latest
>version.
>> Embarrassed that I've not looked to documentation, but would that
>help me
>> or do I need to know?
>>
>> I will go to documentation to learn about the tax report.  There is
>> obviously something I'm not seeing but I did notice that when I chose
>> "Report Options" Start and end of accounting period, last year I got
>one
>> expense category for 2022.  I have so far been unable to add other
>income
>> or expense categories.  I know it's in the documentation and I will
>find it.
>>
>> Thanks
>>
>>> 
>>
>>
>The tax report is more complicated, and in fact I have never used it.
>But I
>just created a new subject for this thread.
>
>I believe you have to do quite a bit of setup to use the tax report --
>you
>have to identify the accounts that are relevant and you have to tag
>each of
>those accounts with the IRS form numbers.
>
>I believe the report also works for the German equivalent of the US
>IRS.
>
>
>
>
>>
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reports not working unless exported

[David T. via gnucash-user]

Michael, 

The tax report is different from every other report; it loads account data 
directly upon running.  This is due to the fact that it relies on the user 
pre-assigning accounts (Phyllis's categories) to tax lines in advance. 

Otherwise, your advice is spot on. 

⁣David T. ​

On Jan 15, 2023, 2:34 AM, at 2:34 AM, Michael or Penny Novack 
 wrote:
>On 1/14/2023 4:49 PM, Phyllis Bruce wrote:
>> Okay, I can't stand it anymore.  I don't know what ubuntu is, or
>flatpak,
>> or a host of other terms you use.  I run windows and the latest
>version.
>> Embarrassed that I've not looked to documentation, but would that
>help me
>> or do I need to know?
>>
>> I will go to documentation to learn about the tax report.  There is
>> obviously something I'm not seeing but I did notice that when I chose
>> "Report Options" Start and end of accounting period, last year I got
>one
>> expense category for 2022.  I have so far been unable to add other
>income
>> or expense categories.  I know it's in the documentation and I will
>find it.
>
>a) It might be slightly counterintuitive, but with gnucash you first
>run 
>a report and THEN (once the report exists) get to edit the report 
>(select desired options. What I suggest, if new to gnucash, for each 
>report you plan to run, try it (tell gnucash to run the report) and
>then 
>use edit => report options to set all the options you want (for
>example, 
>the effective date(s) of the report.
>
>    I strongly suggest (whenever dates are involved) that you use 
>explicit dates instead of things like "current accounting period" 
>because what THAT is will depend on the "real time" of when you are 
>running the report. Thus if on New Year's Eve I ran a report for 
>"current accounting period" I would get the report for 2022 but if I
>ran 
>it tonight I would not. Since you mention the Tax Report, if I ran
>that, 
>I would NEVER expect to be running it for the "current accounting
>period"
>
>b) What do you mean by the term "category". Because some other popular 
>software (not double entry bookkeeping) might use this term in a 
>particular way does not mean that gnucash does.
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transactions Window Sorting

[David T. via gnucash-user]

Well, thanks for the confirmation. 

I disagree with the conclusion, though. Based on your reasoning, registers 
should only save a chronological sort; thankfully, they allow other sort orders 
for users who prefer them. 

⁣David T. ​

On Jan 14, 2023, 4:15 PM, at 4:15 PM, John Layman 
 wrote:
>I'm running 4.13 on Windows 10 and can tell you that sort order is
>'sticky' only if you are sorting on one of the two occurrence columns.
>It's a calendar-oriented feature, so I can't say I consider that an
>oversight.
>
>-Original Message-
>From: gnucash-user
> On Behalf Of
>David T. via gnucash-user
>Sent: Saturday, January 14, 2023 1:44 AM
>To: Gnucash Users 
>Subject: [GNC] Scheduled Transactions Window Sorting
>
>Hello, 
>
>Gnucash 4.13 Windows 10.
>
>As I reacquaint myself with scheduled transactions, I find myself
>opening that window regularly. Each time I open the window,
>transactions are listed in last created order. This despite my having
>sorted the list alphabetically the previous time. 
>
>My question is this: is there some material reason why the Scheduled
>Transactions Window sort order isn't sticky (like most other windows in
>GnuCash), or is this simply an oversight?
>
>⁣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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Scheduled Transactions Window Sorting

[David T. via gnucash-user]

Hello, 

Gnucash 4.13 Windows 10.

As I reacquaint myself with scheduled transactions, I find myself opening that 
window regularly. Each time I open the window, transactions are listed in last 
created order. This despite my having sorted the list alphabetically the 
previous time. 

My question is this: is there some material reason why the Scheduled 
Transactions Window sort order isn't sticky (like most other windows in 
GnuCash), or is this simply an oversight?

⁣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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Scheduled Transactions Question

[David T. via gnucash-user]

Thanks. I did a little testing, trying both your suggestion and Stan's. Both 
seemed to have the same result: I was only prompted once. I suspect that 
"formula-izing" the transaction doesn't materially change anything here. 

In retrospect, I suspect user error in the first place. I now believe that I 
had created the test transaction without paying close enough attention to the 
start date-- and that GnuCash was creating multiple instances of the 
transaction (and therefore promoting for each).

⁣David T. ​

On Jan 14, 2023, 2:08 AM, at 2:08 AM, Adrien Monteleone 
 wrote:
>I had the same problem and I think I solved it by making all of the 
>variables part of a formula, so your transaction would look like:
>
>DB Checking TOTALAMT*1
>CR Asset TOTALAMT*1
>CR Income A TOTALAMT*1
>DB Income B TOTALAMT*1
>
>Regards,
>Adrien
>
>On 1/13/23 10:48 AM, David T. via gnucash-user wrote:
>> Hi,
>> 
>> Gnucash 4.13 Windows 10. Long time user.
>> 
>> I am trying out using a variable in a scheduled transaction for the 
>> first time, and it's not behaving the way I expect. I am creating a 
>> multi-entry transaction that transfers a single amount between two
>pairs 
>> of accounts. in other words:
>> 
>> DB Checking TOTALAMT
>> CR Asset TOTALAMT
>> CR Income A TOTALAMT
>> DB Income B TOTALAMT
>> 
>> [This is testing out how to create a transaction to track an IRA 
>> distribution]
>> 
>> I expect GnuCash to prompt me for the TOTALAMT figure once when the 
>> transaction is created, but GnuCash prompts me for *each* TOTALAMT
>entry 
>> in the transaction (i.e., four times). Is there a way to have just
>one 
>> request that gets assigned four times?
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommended Method of Entry for IRA Distributions

[David T. via gnucash-user]

Michael, 

Thanks again for your perspective. I admit to being a little confused by your 
comments here. 

My breakdown was based on an earlier post that emphasized the need to isolate 
the initial deposits into a "deferred income" account and add the extra entries 
at distribution time. I interpreted that to mean a separate income account; I 
don't know what a "standing account" is or where it would be placed in the 
hierarchy. Equity?

As for counting as income, most paychecks I've seen list the employee's gross 
income at the top, with contributions to tax-deferred accounts listed as 
deductions from the gross amount. This is why I placed deferred income under 
income; the income that my employer lists at year end includes this deferred 
income. I can, I imagine, chalk this up to another case of "their books, my 
books" (as in, "On their books, it's income; on my books it's not."), but I'd 
be happy to understand a little better. 

The case of an IRA can be even more confusing, in that a person can make IRA 
contributions entirely separately from income transactions and have those 
contributions affect income at tax time.

⁣David T. ​

On Jan 14, 2023, 1:10 AM, at 1:10 AM, Michael or Penny Novack 
 wrote:
>On 1/13/2023 11:48 AM, R Losey wrote:
>> Thanks. The only minor drawback is that I seem to be entering the
>data 
>> twice under "Income" just to keep track of IRA distributions on their
>
>> own. But hey, it's one way to make it work.
>>
>> And, as has been pointed out, since this is not really "income", it 
>> makes sense that the transaction has no net income. I think I'll
>adopt 
>> this method for 2023.
>>
>> In hindsight, since the Fiduciary Trust that keeps the IRA has to 
>> report to me on distributions, I haven't felt a need to have an 
>> account for this and to double-check them.
>>
>>
>>
>> On Thu, Jan 12, 2023 at 10:56 PM David T. 
>wrote:
>>
>> Two separate entries. In my mind, this would best be put in one
>> transaction, to make the association obvious.
>>
>> CR - Assets: IRA $1000
>> DB - Assets: Checking $1000
>> DB - Income: Deferred Income $1000
>> CR - Income: IRA Distribution $1000 *
>>
><<< it most certainly COULD be in one entry. A transaction can have
>more 
>than two accounts. It is only when entering via the shortcut "enter 
>directly into the ledger" that gnucash allows you to do that is limited
>
>to two accounts. When entering a "split" in "journal mode" you can have
>
>more than two. In the old days ALL transactions were entered first in 
>the journal and then posted to the ledger. But even in pen and ink days
>
>we had SOME shortcut possibilities, like "cashbook accounting" << where
>
>a small subset of the ledger allowed direct entry skipping the
>journal.>>
>
>BUT -- I would not have "deferred income" under income, because it is 
>more like a standing account. The money that you put into the 401k/IRA 
>did not get counted in your income in those years. The money
>contributed 
>by your employer (401k) did not get counted as income back then, nor
>the 
>annual increases in fund value as you perhaps marked to market at year 
>end (the investment income of the fund).
>
>When you take distributions later is when it becomes income << you are 
>undeferring that amount >>
>
>This is accounting, not gnucash
>
>Michael D Novack
>
>
>>
>> * Income: IRA Distribution is used to document the distribution
>> for tax purposes.
>>
>> David T.
>> On Jan 13, 2023, at 7:21 AM, R Losey  wrote:
>>
>> Thanks for all of the information... however, getting back to
>the original
>> question, I'm not sure how to record IRA taxable
>distributions. I thought I
>> was doing it, but I am apparently not.
>>
>> Let me write through a couple of cases.  In the first one,
>I'm selling
>> $1000 worth (10 shares) of security A and having it go
>directly to my
>> checking account with no income tax withholding. (some of
>these may be
>> USA-centric terms; I apologize for that).
>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Scheduled Transactions Question

[David T. via gnucash-user]

Hi,

Gnucash 4.13 Windows 10. Long time user.

I am trying out using a variable in a scheduled transaction for the 
first time, and it's not behaving the way I expect. I am creating a 
multi-entry transaction that transfers a single amount between two pairs 
of accounts. in other words:


DB Checking TOTALAMT
CR Asset TOTALAMT
CR Income A TOTALAMT
DB Income B TOTALAMT

[This is testing out how to create a transaction to track an IRA 
distribution]


I expect GnuCash to prompt me for the TOTALAMT figure once when the 
transaction is created, but GnuCash prompts me for *each* TOTALAMT entry 
in the transaction (i.e., four times). Is there a way to have just one 
request that gets assigned four times?


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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommended Method of Entry for IRA Distributions

[David T. via gnucash-user]

Two separate entries. In my mind, this would best be put in one transaction, to 
make the association obvious. 

CR - Assets: IRA $1000
DB - Assets: Checking $1000
DB - Income: Deferred Income $1000
CR - Income: IRA Distribution $1000 *

* Income: IRA Distribution is used to document the distribution for tax 
purposes.

⁣David T. ​

On Jan 13, 2023, 7:21 AM, at 7:21 AM, R Losey  wrote:
>Thanks for all of the information... however, getting back to the
>original
>question, I'm not sure how to record IRA taxable distributions. I
>thought I
>was doing it, but I am apparently not.
>
>Let me write through a couple of cases.  In the first one, I'm selling
>$1000 worth (10 shares) of security A and having it go directly to my
>checking account with no income tax withholding. (some of these may be
>USA-centric terms; I apologize for that).
>
>If I can create a "Sell" transaction that sells 10 shares at $1000; the
>other entry would be to increase my taxable distribution category by
>$1000.
>But what next? My checking account doesn't have the $1000 increase, but
>then what is the "other" category to use for that transaction??
>
>I looked at my data, and what I've been doing is that the other side of
>the
>Sell transaction is a deposit to my bank account, but this fails
>because
>there is no record of a taxable distribution.
>
>
>On Thu, Jan 12, 2023 at 2:42 PM Michael or Penny Novack <
>stepbystepf...@comcast.net> wrote:
>
>> On 1/12/2023 12:41 PM, R Losey wrote:
>> > Thanks; I know the information is out there, but intuitively, it
>doesn't
>> > make sense to me that depositing funds to my bank account is a
>"debit"
>> > transaction to the bank. It comes from the concept of credit being
>"added
>> > to" and debit being "substracted from", I suppose.
>> >
>> > Is the "Debit on the left" and "Credit on the right" true in
>general
>> > accounting, or just GnuCash?
>>
>> a) Double entry bookkeeping goes back a long way, long enough that
>Latin
>> still in use for communications among the educated in Europe. Think
>of
>> "debit" and "credit" not in terms of plus and minus (before European
>> math had negative numbers) but as "he owes"(me) and "he trusts" (me).
>In
>> other words  he owes me that amount and he trusts me for that amount
>(I
>> owe him)
>>
>> Now look again at the bank account.In YOUR books a debit (the
>bank
>> owes you this money) and in the bank's book a credit (the bank owes
>you
>> this money)
>>
>> b) Debit on the left and credit on the right. In the old days ledger
>> pages had two sides, one side for the debits and the other for the
>> credits (and no balance column). Perhaps within my lifetime it became
>> more common to use three column paper with debit and credit
>transactions
>> with one date, check number, description, and journal reference
>column
>> then a left for debit, a right (middle) for credit, and a balance. o
>a
>> running balance was kept << finding the balance was a process in the
>old
>> days before that >>
>>
>> NOTICE -- so far pen and ink on paper, and gnucash is simply
>modelling that
>>
>> 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
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>
>
>-- 
>_
>Richard Losey
>rlo...@gmail.com
>Micah 6:8
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] exporting from gnucash to Excel

[David T. via gnucash-user]

Indeed. 

I don't have to comply with this either, but it seems to me that "pressing a 
button" to export to Excel provides exactly the same automated reliability as 
CTRL-C/CTRL-V (two buttons, if you will) into Excel. The data in both cases 
will have the same reliability. 

⁣David T. ​

On Jan 13, 2023, 5:11 AM, at 5:11 AM, Adrien Monteleone 
 wrote:
>Do a list search on this topic. I'm pretty certain someone has a 
>solution already worked out. I recall several threads over the last 2 
>years or so about this.
>
>Apologies, but I don't use this myself, so I can't comment further.
>
>Regards,
>Adrien
>
>On 1/12/23 8:05 AM, Paul W via gnucash-user wrote:
>> To submit VAT data to HMRC here in the UK I am obliged to use a
>method which is automatic. So I need to find a way to trasnfer the
>balances from a couple of accounts to an Excel spreadsheet
>automatically ie not by copying and pasting. I need to press a button
>and it is done without the opportunity for errors to be introduced to
>the figures.Then I use some pre-approved software which reads the
>spreadsheet and uploads the data to HMRC. Is there some way to transfer
>a balance from an account to an Excel spreadsheet?
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Recommended Method of Entry for IRA Distributions

[David T. via gnucash-user]

Moshe,

This issue has come up many times over the years, for the very reason you 
raised: a direct transfer from the IRA asset account to your Checking at 
account won't show as income in reports. 

The best way I've seen for how to handle this requires that your initial pay 
records isolate the income you diverted to the IRA account. Technically, the 
income you sent to the IRA is separate, and should be categorized as "deferred 
income." 

In my books, that's meant that my paycheck entries have separate lines for the 
income that was sent to the IRA. So if I have a paycheck for $1,000, and send 
$50 to the IRA, the entry was:

Income:W2 $950 -> Checking
Income:IRA   $50 -> IRA Asset 

(Note that this will match your W-2 at the time) 

When you take the distribution, you create one transaction for the transfer 
from the IRA to Checking, but then you create an extra transaction (or extra 
splits, if you prefer), which transfers the distribution amount from Income:IRA 
to Income:Retirement Distributions. This second account should be assigned as a 
taxable account. Then it will appear on the TXf report. You can also select 
just that account on income statements. 

⁣David T. ​

On Jan 12, 2023, 6:53 AM, at 6:53 AM, Milton Stern  wrote:
>Hi,
>
>Please see below 
>
>Moshe
>
>On Wed, Jan 11, 2023 at 7:06 PM R Losey  wrote:
>
>> Hello.
>>
>> Assuming you take out $5,000 and they withhold 10% ($500), I would
>use a
>> split transaction... sell $5000 worth of the mutual fund, add $4500
>to your
>> bank account, and $500 to federal income tax paid.
>>
>
>> I apologize for not using "debit" and "credit" terms, but I'm not
>sure I'd
>> get them right.
>>
>
> Agreed. The component that I am having trouble with is the
>Pre-Tax
>IRA Distribution component. Because it is a Pre-Tax IRA, the
>distribution
>is taxable as income.
>The direct "sell $5000 worth of the mutual fund, add $4500 to
>your
>bank account" direct transaction will not show up in Income Reports.
>
>
>>
>> You can track them however you wish, but the above is how I would do
>> them... well, except, I never have the mutual fund withhold taxes; I
>pay my
>> own taxes quarterly.
>>
>
>** New for 2023. IRS requires the brokerage to withhold taxes from
>IRA
>Distributions. Last year you could specify 0% withholding.
>** They don't make it so easy this year. It is sort of a double
>hit.
>Even if you get it back as a tax refund, you can't put it back
>(Rollover)
>into the IRA to earn tax free.
>
>
>>
>>
>> On Wed, Jan 11, 2023 at 4:35 PM Milton Stern 
>wrote:
>>
>>> Hi,
>>>
>>> What would be the recommended method of Entry for an IRA
>Distribution?
>>>
>>> The Distribution is for a personal IRA (not Roth).
>>> The IRA is of Mutual Funds.
>>>
>>> The Mutual Fund is in Assets > Investments - Retirement > Brokerage
>> etc.
>>> > etc.
>>>
>>> Since this is taxable income, I need to track withholding (Federal)
>+ Net
>>> Distribution to a Checking Account (Assets > Current Assets).
>>> No Commission fees are applicable, but it would be nice to know
>where/how
>>> they would be tracked.
>>>
>>> Thank you in advance,
>>>
>>> Moshe
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>
>>
>> --
>> _
>> Richard Losey
>> rlo...@gmail.com
>> Micah 6:8
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] questions from a new user

[David T. via gnucash-user]

Michael,

I took Neil's comment to mean that he didn't want to connect to his bank 
account online. 

Neil,

I'd like to point out that, despite the scope of your endeavor, you're in 
business, which will entail a certain amount of record keeping. Gnucash is 
directly designed for this sort of business, and will allow you to manage those 
finances in the ways you've described, but it *does* have a stiff learning 
curve, and you do have to learn a bit about accounting to use it. That being 
said, many non-accountants (myself among them) have been able to use GnuCash 
successfully to meet their needs. 

⁣David T. ​

On Jan 9, 2023, 4:42 AM, at 4:42 AM, Michael or Penny Novack 
 wrote:
>On 1/8/2023 7:14 PM, Neil Morrish wrote:
>> Hi
>> I am not sure if gnucash is right for me, as it seems quite hard to
>get
>> started. Can you advise me what steps to learn about for my simple
>> requirement please?
>> I want to keep a record of business transactions so I can send
>invoices and
>> make an annual report for my tax calculation.
>> I do work for 4 or 5 customers and like to give an invoice that shows
>the
>> things I've done , the cost of the work, and the expenses I incur.
>> I dont want to link this to my bank account.
>> When it is set up, is it easy to input the entries quickly?
>
>By "I don't want to "link" to my bank account do you perhaps mean that 
>you are NOT wanting this to be a full personal set of books? You want 
>this JUST for your small number of customers business.
>
>Yes, you CAN use gnucash for this purpose. In effect, you are setting
>up 
>a subset of what would be full books. It WOULD have a "bank account"
>for 
>when the invoices you sent customers are paid. But this "bank account" 
>would be a (virtual) subset of your actual bank account. So don;t 
>(later) ask us how you can use gnucash's reconciliation << will be 
>manual for you >>
>
>So you would set up using the business features option and just the 
>income and expense accounts associated with your business plus that 
>asset account "bank". You will be able to run a report for the year 
>showing profit (or loss) for tax purposes. The only complication I can 
>see is if you file your taxes "cash basis" because using the business 
>features requires accrual basis, but it IS possible to adjust for that 
>at year end << for tax filing, subtract what's still in "receivables" 
>form income and what's still in "payables" from expenses >>
>
>BUT -- if new to double entry bookkeeping do carefully read the
>tutorial 
>and if that's not enough to give you understanding, some standard 
>"Bookkeeping 101" text or on-line. Software like gnucash is partially 
>automating the process of keeping double entry books but you still have
>
>to understand what you are doing.
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Trial balance

[David T. via gnucash-user]

John, 

Thanks for the information. I had no idea that the date range had a purpose on 
the TB.

⁣David T. ​

On Jan 8, 2023, 8:34 PM, at 8:34 PM, john  wrote:
>
>
>> On Jan 8, 2023, at 2:47 AM, David T. via gnucash-user
> wrote:
>> 
>> As I understand it, the Trial Balance report is As Of A Date, and
>therefore cumulative to that date. Not sure why the report includes
>start and end dates in that circumstance, except to follow settings
>provided by other reports.
>
>The start date is used to set a date range with end date for filtering
>out book-closing and adjusting splits according to patterns set on the
>Entries page of report options. The default values are descriptions
>"Closing Entries" and "Adjusting Entries" respectively. For all other
>purposes only the end date matters.
>
>Regards,
>John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
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

[David T. via gnucash-user]

As I understand it, the Trial Balance report is As Of A Date, and therefore 
cumulative to that date. Not sure why the report includes start and end dates 
in that circumstance, except to follow settings provided by other reports. 

As for multi currency trial balances, there have been many discussions about 
the effect of exchange rates on the report, but the trading accounts are 
supposed to address that. I've never had a trial balance report balance (in 15 
years of GnuCash use), but then I've also never turned trading accounts on 
(because I'm afraid of what it might change in those data).

An opening balance entry is not required; every account begins at some point in 
time at zero. 

I'm sure others can provide additional insights (and correct my inevitable 
inaccuracies).

⁣David T. ​

On Jan 8, 2023, 10:14 AM, at 10:14 AM, Fred Tydeman  
wrote:
>I have run a Transaction report (for all accounts) for just one day in
>the
>past (to find all the transactions on that one day).  It found just one
>transaction where I bought 600 yuan for 99.07 USD (at an ATM in china).
>The grand totals in the report are 0 USD and 0 yuan.
>
>That one transaction has four splits:
>Receive column:
>  Assets:...:$china 600
>  Trading:cash US:ftexx 99.07 Fid. TE MM
>Spend column:
>  Assets:..:Fid. TE MM  99.07 Fed. TE MM
>  Trading:CURRENCY:CNY  600
>
>That transaction is the first one in $china.  There is no Equity
>Opening
>Balance (which would be zero) for $china.
>
>I then ran a Trial Balance report; again for just that one day and all
>accounts.  The two totals at the bottom of the report do not match
>(differ
>by 5.46).  If I change the date to 6 days earlier (again for just one
>day),
>the two totals match.
>
>By one day, I mean both Start date and Date of report are the same.
>
>OS:  Fedora Linux 37
>GnuCash: 4.13
>Trading accounts are on.
>
>Is Trial Balance supposed to work when there is a mixture of
>currencies?
>Is Trial Balance supposed to work for just one day in the past?
>Do all accounts need an Equity Opening Balance?
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] reconcile dates

[David T. via gnucash-user]

Your records and the bank's differ. The reconciliation date may include entries 
that you've entered with later dates, and how would GnuCash determine the 
proper cutoff? 

Personally, I don't have trouble determining when the difference figure goes to 
0.

⁣David T. ​

On Jan 7, 2023, 11:45 PM, at 11:45 PM, Kevin T via gnucash-user 
 wrote:
>Is there some reason that the reconcile feature looks past the closing
>date specified?
>I have imported numerous months of transactions for an account.  Trying
>to reconcile only the first month with 0 balance and 0 transactions
>before the starting date.  I provide the 'statement date' to the
>reconcile feature and it brings up every transaction entered, even the
>ones after the 'statement date'.  
>This is not how a person would reconcile this.  We could concern
>ourselves with on the transactions that occur before the closing date
>'statement date'.
>Is there something I am missing ?
>Kevin
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Request for Automatic Reconciliation Function

[David T. via gnucash-user]

Bite Gao,

Jim mentions the import matcher, and I reiterate here to emphasize that GnuCash 
provides most of what you're asking, but places it in the import process, 
rather than in reconciliation. A user can match incoming entries to existing 
ones. They can also set the reconcile flag to "C" for imported transactions, 
which will automatically check those entries on the next reconciliation. These 
are both key parts of your proposal. 

And the problems that others raised continue to undermine the idea. 

⁣David T. ​

On Jan 7, 2023, 4:35 AM, at 4:35 AM, Jim DeLaHunt  wrote:
>Bite Gao:
>
>Thank you for continuing this conversation. I am glad to have your
>ideas 
>in this discussion.
>
>While I think I understand what feature you are asking for, I do see 
>some difficulties with it. For example, you say:
>
>On 2023-01-06 17:22, Bite Gao wrote:
>> …For each split record in the GnuCash file, the program scan for its 
>> counterpart in the bank statement.… Personally, I do not found that 
>> how computer program could make mistake in this process.…
>
>The obvious difficulty is that for a single transaction, the text in
>the 
>GnuCash file is probably different than the text in its counterpart in 
>the bank statement. For example, suppose I have a weekly purchase where
>
>I enter the description as "SPUD, Vancouver BC" and the date as January
>
>5, but the bank statement may say "Small Potatoes Delivery * Paypal"
>and 
>the date as January 6.  It is difficult — not impossible, but difficult
>
>— for GnuCash to see that these two transactions are counterparts.
>Their 
>description text and their dates differ.
>
>It turns out that GnuCash's Import Matcher can successfully recognise 
>the link between these two.  But it often makes mistakes in this
>process.
>
>Best regards,
>     —Jim DeLaHunt
>
>
>On 2023-01-06 17:22, Bite Gao wrote:
>> GnuCash Developers and Maintainers:
>>   Hello! While you pinpoint out the possibility of a mistake in 
>> automated process, it did not eliminate the meaning of the automatic 
>> reconciliation.
>>   What an automatic reconciliation does is: the program concatenates 
>> the transaction's date, check number and the transaction amount from 
>> both the bank statement and the GnuCash file. For each split record
>in 
>> the GnuCash file, the program scan for its counterpart in the bank 
>> statement. And when the counterpart is found, the program marks the 
>> split as reconciled.
>>   Personally, I do not found that how computer program could make 
>> mistake in this process. If you believe that the computer could have 
>> that happen, I would like to learn the detail about it.
>>
>>   Yours,
>>
>>    Bite Gao
>> Jan 7th, 2021
>>
>> On 2023/1/6 20:57, Adrien Monteleone wrote:
>>
>>> I understand your explanation, but if you aren't checking and 
>>> verifying every transaction, how do you ever discover when the 
>>> automated process makes a mistake?
>>>
>>> Reconciliation was invented long before computers, but I appreciate 
>>> that the process demands one to slow down, take your time, and 
>>> methodically verify the information.
>>>
>>> Think of it as proof-reading - the hard way. (I learned in school to
>
>>> read stuff backwards when proofing!)
>>>
>>> That is a pretty good analogy too:
>>>
>>> If you've ever used auto-correct with auto-checking for spelling and
>
>>> grammar, or auto-suggestion or auto-completion for entire words and 
>>> have seen the embarrassment and/or nightmare that can produce when 
>>> the computer 'gets it wrong', would you want something like that for
>
>>> your financial records?
>>>
>>> Regards,
>>> Adrien
>>>
>>> On 1/5/23 7:50 PM, Bite Gao wrote:
 GnuCash Developers and Maintainers:
    Hello! While you have mentioned the requirement of human 
 intervene in the reconciliation process, I do not see it
>contradicts 
 with the presence of automatically reconciliation system.
    In a reconcile process, the accountant check the record in the 
 account book with the record in the bank statement (or statement 
 from other institution). He (or she) may found out that two record 
 are identical, or he (or she) may found that some record are not 
 identical. Only the latter requires human notice, since there its
>no 
 point wasting time on reconciled accounting transactions. An 
 automatic reconciliation system can load the digital statement from
>
 the institution, compares the statement with the transaction in the
>
 accounting book, and pinpoints the discrepancies out. Then human 
 accountant could step in and perform manual operations, such as 
 checking other vouchers, contact with banks, etc. In the situation 
 of single user, the automatic reconcile system have no reason to 
 block manu
 al reconciliation.
    Besides, when I means "human err", I means that the accountant 
 overlook an discrepancy and regards it as identical. People do not 
 spend too much time on 

Re: [GNC] Register column sizing

[David T. via gnucash-user]

I think both changes would be excellent. As another person has noted, most 
people expect GnuCash columns to behave like a spreadsheet, and the Description 
column trips them up. And if the Price column doesn't have to be there, 
removing it will be beneficial as well. 

⁣David T. ​

On Jan 6, 2023, 6:42 AM, at 6:42 AM, john  wrote:
>Users,
>
>There have been occasional complaints for many years about column width
>sizing. See for e.g. https://bugs.gnucash.org/show_bug.cgi?id=563588.
>Most users seem to eventually get used to it, but I wonder if anybody
>really likes it.
>
>The problem boils down to the auto-sizing behavior of the Description
>column, which causes that column to grow or shrink when you adjust the
>window's width, and to make a horizontal scrollbar appear when you
>widen another column. Occasionally someone will complain about the
>normally hidden price column because it's possible to catch its handle
>and widen it when you mean to widen the balance column.
>
>It would be really easy to turn off autosizing on the Description field
>and only a little work to figure out another way to handle the price
>and ditch that column. Would anyone miss it?
>
>Regards,
>John Ralls
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Request for Automatic Reconciliation Function

[David T. via gnucash-user]

I agree with Adrien here fully, as well as with other points made elsewhere in 
the thread. 

As an open source software package, it's certainly possible for *someone* to 
write code for an automatic reconciliation, but I certainly wouldn't want the 
feature myself. Call me old school, but I want to check that the bank and I 
agree on the accounting, and I consider me to be the best judge of my 
transaction history. 

⁣David T. ​

On Jan 6, 2023, 3:59 PM, at 3:59 PM, Adrien Monteleone 
 wrote:
>I understand your explanation, but if you aren't checking and verifying
>
>every transaction, how do you ever discover when the automated process 
>makes a mistake?
>
>Reconciliation was invented long before computers, but I appreciate
>that 
>the process demands one to slow down, take your time, and methodically 
>verify the information.
>
>Think of it as proof-reading - the hard way. (I learned in school to 
>read stuff backwards when proofing!)
>
>That is a pretty good analogy too:
>
>If you've ever used auto-correct with auto-checking for spelling and 
>grammar, or auto-suggestion or auto-completion for entire words and
>have 
>seen the embarrassment and/or nightmare that can produce when the 
>computer 'gets it wrong', would you want something like that for your 
>financial records?
>
>Regards,
>Adrien
>
>On 1/5/23 7:50 PM, Bite Gao wrote:
>> GnuCash Developers and Maintainers:
>>    Hello! While you have mentioned the requirement of human intervene
>in 
>> the reconciliation process, I do not see it contradicts with the 
>> presence of automatically reconciliation system.
>>    In a reconcile process, the accountant check the record in the 
>> account book with the record in the bank statement (or statement from
>
>> other institution). He (or she) may found out that two record are 
>> identical, or he (or she) may found that some record are not
>identical. 
>> Only the latter requires human notice, since there its no point
>wasting 
>> time on reconciled accounting transactions. An automatic
>reconciliation 
>> system can load the digital statement from the institution, compares
>the 
>> statement with the transaction in the accounting book, and pinpoints
>the 
>> discrepancies out. Then human accountant could step in and perform 
>> manual operations, such as checking other vouchers, contact with
>banks, 
>> etc. In the situation of single user, the automatic reconcile system 
>> have no reason to block manu
>> al reconciliation.
>>    Besides, when I means "human err", I means that the accountant 
>> overlook an discrepancy and regards it as identical. People do not
>spend 
>> too much time on identical records, since major of the transaction
>would 
>> be in that state. However, it could cause severe consequences if
>there 
>> do have a discrepancy.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where do I set the "Accounting Period" for reports?

[David T. via gnucash-user]

Probably depends on the report.

David T.​

On Jan 6, 2023, 12:52, at 12:52, David H  wrote:
>Yeah it's Prefs >> Accounting Period - not sure if that's used by
>reports
>or just for registers ?
>
>Cheers David H.
>
>
>On Fri, 6 Jan 2023 at 19:31, David T.  wrote:
>
>> There is also a setting in preferences somewhere to change the
>accounting
>> period. As I don't use the feature, I don't know where it is in
>either the
>> general preferences or the file preferences.
>>
>>
>> David T.
>> On Jan 6, 2023, at 12:19, David H  wrote:
>>>
>>> Chris,
>>>
>>> Did you run a report then click on Options / General Tab - the
>reports I
>>> run allow you to set the period for each report?
>>>
>>> Cheers David H.
>>>
>>>
>>> On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:
>>>
>>>  Every year when I want to print annual reports I have this problem.

  I can never find where to set the 'accounting period' for reports.

  Where is it please?

  --
  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
  -
  Please remember to CC this list on all your replies.
  You can do this by using Reply-To-List or Reply-All.
>>>
>>>
>>> --
>>>
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Where do I set the "Accounting Period" for reports?

[David T. via gnucash-user]

There is also a setting in preferences somewhere to change the accounting 
period. As I don't use the feature, I don't know where it is in either the 
general preferences or the file preferences.

⁣
David T.​

On Jan 6, 2023, 12:19, at 12:19, David H  wrote:
>Chris,
>
>Did you run a report then click on Options / General Tab - the reports
>I
>run allow you to set the period for each report?
>
>Cheers David H.
>
>
>On Fri, 6 Jan 2023 at 19:06, Chris Green  wrote:
>
>> Every year when I want to print annual reports I have this problem.
>>
>> I can never find where to set the 'accounting period' for reports.
>>
>> Where is it please?
>>
>> --
>> 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
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to "Get Quotes" for a specific day?

[David T. via gnucash-user]

I've used Google sheets to retrieve prices which can be imported into GnuCash. 
In the referenced message, it should be simple to set whatever date you want. 

https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html

⁣David T. ​

On Dec 30, 2022, 7:48 AM, at 7:48 AM, Geoff  wrote:
>No.
>
>As far as I know the Finance::Quote module that GnuCash uses has no 
>provision to fetch historical prices.
>
>If you are into scripting and web scraping, checkout Selenium which has
>
>a nice Python interface.
>
>Good luck!
>
>Geoff
>=
>P.S.  Always include gnucash-user@gnucash.org on all correspondence.
>
>On 30/12/2022 3:23 pm, gnucash_2...@michaelaltfield.net wrote:
>>> 2. Import from a CSV file:-
>>>(File / Import / Import prices from a CSV file)
>> 
>> OK, Is there a way that I can generate this CSV file using
>`gnc-fq-dump` or `gnucash-cli` or similar so that I can script
>something to fetch/generate a CSV file and then import that CSV file
>for all my stocks for a specific date?
>> 
>> On Fri, Dec 30, 2022 at 03:25:02PM +1100, Geoff wrote:
>>> Hi Michael
>>>
>>> You can't do this.
>>>
>>> Alternatives:-
>>> 1. Key the prices directly into the Price Database:-
>>> (Tools / Price Data Database / Add)
>>> 2. Import from a CSV file:-
>>> (File / Import / Import prices from a CSV file)
>>>
>>> Historical prices are available from, inter alia,
>https://finance.yahoo.com/
>>>
>>>
>>> Regards
>>>
>>> Geoff
>>> =
>>>
>>> On 30/12/2022 3:06 pm, gnucash_2...@michaelaltfield.net wrote:
 How can I tell GNU Cash to update its "Price Database" for all
>known currencies, stocks, bonds, mutual funds, etc for a *specific*
>day?

 I'm trying trying to prepare a report for a date in the past. I've
>set the `Options` for the report to `nearest in time` so that it will
>grab the prices for the commodities from the Price Database that are
>closest to the date of the report as possible.

*
>https://gnucash-docs-rst.readthedocs.io/en/latest/guide/C/ch_invest.html?highlight=price%20database#the-price-source-in-reports
 Well, I checked the Price Database, and I have gaps in the prices
>for some of my stocks. For many stocks, I don't have any prices defined
>for the day of the report. Therefore, my report may be inaccurate.

 I know that I can go to `Tools` -> `Price Database` and click the
>`Get Quotes` button. This will fetch the current quote (price) and add
>it to the Price Database for all defined currencies, stocks, bonds,
>mutual funds, etc. But that will fetch and add the prices for *today's
>date* only.

 How can I do the equivalent of `Get Quotes` but for a specific day
>in the *past*?

 (see also
>https://superuser.com/questions/1760157/how-to-get-quotes-for-all-currencies-and-stocks-for-a-specific-day-gnu-cash)
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Feature request - prevent a transaction with todays date

[David T. via gnucash-user]

Dr. Kirkby,

While I understand the requirements for not editing existing transactions, I'll 
note that in your initial post, you mentioned going back to a backup and 
re-entering the transaction. Not to put too much of an emphasis here, but how 
does editing the date differ from opening a backup and re-entering the 
transaction? 

⁣David T. ​

On Dec 27, 2022, 3:07 AM, at 3:07 AM, "Dr. David Kirkby" 
 wrote:
>On Mon, 26 Dec 2022 at 19:22, William Prescott 
>wrote:
>
>> Your post puzzles me.
>>
>> > I am trying to enter some transactions from March. Every now and
>again I
>> > forget to change the date on something, so I get today’s date. Then
>I
>> have
>> > to go back to a backup file.
>>
>>
>> Why? Can't you just edit the date on the transaction and change it.
>
>
>I thought one wasn’t supposed to do that - at least in formula
>accounting.
>
>>
>>
>> > It would be nice when entering historical
>> > transactions if it was impossible to use todays date - one is
>forced to
>> > change the date is something in preferences prevented todays date
>being
>> > used.
>>
>> I must be missing something. Not being able to use today's day would
>make
>> it impossible to enter transactions on the day they occurred. Are you
>> asking for some switch that could be set before entering historical
>> transactions? It seems like a cumbersome solution to a non-problem.
>
>
>Yes, a switch for entering historical transactions.
>
>>
>> Will
>
>
>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
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Changing typeface using CSS (Windows 10)

[David T. via gnucash-user]

I'd try putting that font name in double quotes. 

⁣David T. ​

On Dec 21, 2022, 8:17 AM, at 8:17 AM, TERRENCE BRANSCOMBE 
 wrote:
>Yeah, had precisely what you had in your screenshot. 
>
>Here is what is now in my gtk-3.0.css file: 
>
>/* Application wide font setting */ 
>* { 
>font: 18px Microsoft Consolas; 
>} 
>
>No visible result, I'm afraid. 
>
>Cheers, 
>Terry 
>
>
>From: "Glenn Fowler"  
>To: "TERRENCE BRANSCOMBE"  
>Cc: "GnuCash users group"  
>Sent: Tuesday, December 20, 2022 6:18:54 PM 
>Subject: Re: [GNC] Changing typeface using CSS (Windows 10) 
>
>It would be the "Roaming" folder. There is probably a syntax error.
>Just copy/paste the whole thing, save, and restart GnuCash. 
>
>
>On Tue, Dec 20, 2022 at 2:34 PM TERRENCE BRANSCOMBE < [
>mailto:tlbransco...@shaw.ca | tlbransco...@shaw.ca ] > wrote: 
>
>
>
>Thanks for the suggestion, Glenn. 
>
>I tried this in both the "Roaming" and the "Local" versions of the
>gtk-3.0.css file; but, neither had any effect on the typeface I see. 
>
>Also, I did see you used "24px" whereas I had "24pt" originally, so I
>went with your suggestion. 
>
>Terry 
>
>
>From: "Glenn Fowler" < [ mailto:gfowl...@outlook.com |
>gfowl...@outlook.com ] > 
>To: "TERRENCE BRANSCOMBE" < [ mailto:tlbransco...@shaw.ca |
>tlbransco...@shaw.ca ] > 
>Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org |
>gnucash-user@gnucash.org ] > 
>Sent: Monday, December 19, 2022 3:43:07 PM 
>Subject: Re: [GNC] Changing typeface using CSS (Windows 10) 
>
>This should work: 
>
>/* Application wide font setting */ 
>
>* { 
>font : 24px Microsoft Calibri; 
>} 
>
>On Mon, Dec 19, 2022 at 6:33 PM TERRENCE BRANSCOMBE < [
>mailto:tlbransco...@shaw.ca | tlbransco...@shaw.ca ] > wrote: 
>
>BQ_BEGIN
>Hello all, 
>
>I've been a user for all of 2 weeks, so I apologize to everyone if this
>question/subject has been beaten to death in the past. My research
>online has not resulted in a fix, though, so I'd like to ask: has
>anyone running gnucash 4.12 or 4.13 on Windows 10 managed to change
>font families using CSS ? The documentation I've found on the subject
>suggests Windows users can change typefaces using CSS by editing the
>file GNC_CONFIG_HOME/gtk-3.0.css by adding a section like this : 
>
>/* Application wide font setting */ 
>gnc-id-main-window { 
>font-family: Microsoft Calibri; 
>font-size: 24pt; 
>} 
>
>Following these directions I edited the file gtk-3.0.css in the folder
>C:\Users\\AppData\Roaming\GnuCash with the setting shown
>above; but, upon restarting gnucash I see absolutely no font change
>whatsoever. For grins, I copied this file to the AppData\Local\GnuCash
>directory as well, and again restarted gnucash. Sadly, same non-result.
>
>
>Any hints greatly appreciated, 
>
>Terry 
>___ 
>gnucash-user mailing list 
>[ mailto:gnucash-user@gnucash.org | 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 ] 
>- 
>Please remember to CC this list on all your replies. 
>You can do this by using Reply-To-List or Reply-All. 
>
>
>
>
>BQ_END
>
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Best practice to change name of GnuCash file ("book")?

[David T. via gnucash-user]

Which is why it's a good idea to inform the list your operating system 
and the version of GnuCash you are using.


On 12/20/2022 6:51 PM, Maf. King wrote:

On Tuesday, 20 December 2022 15:48:11 GMT Eric Chapman wrote:

I do have a bunch of files named something like

xxx.gnucash.20221219140714.gnucash

and they are bigger than the xxx.gnucash file. The last one is dated
yesterday. So maybe that is a backup?

But I clicked on it, and it also opens as if it's a completely new file.


If you are on a MAC, you need file -> Open

clicking the data file does not work as you might expect it to.

Maf.



___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] How to use Vendors & Accts Payable, but pay via Credit card?

[David T. via gnucash-user]

Eric,

Check out 
https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_txns.html#txns-register-oview, 
especially the notes in 2.9.2.3 Setting Column Widths.


Your video shows successful resizing the Action column; following 
Derek's advice to double-click the column header to resize Bill would 
set that column, as well as the Balance column.


Best,

David T.

On 12/20/2022 5:40 PM, Eric Chapman wrote:
I cannot successfully get the field columns to be manageable. Attached 
is a .mov file (1.1MB, so may get stripped out) of the screencast of 
an attempt. This is on MacOS 13.1 Ventura with GnuCash 4.13.


Eric

On 12/20/22 09:16, Derek Atkins wrote:

Why don't you make the column wider?  Your description column is HUGE.
Try double-clicking on the "Bil" header to make it wider -- or grab the
right side and drag to the right --- and then reduce the description
column.

I believe that is the "Billable?" column, which says that the 
line-item is

billable back to a customer.

-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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.