Re: [GNC] Fix assets

[David T. via gnucash-user]

Section 15.5 of the Guide enumerates fixed asset types, and chapter 16 
Depreciation goes into a bit of detail about this complex subject. The broad 
concepts are covered there, but consulting with a local expert is recommended 
in this area.

David

> On May 18, 2019, at 9:02 AM, Adrien Monteleone 
>  wrote:
> 
> Of course.
> 
> Unfortunately, the Help and Guide are sparse in their coverage of this topic, 
> but certainly, you can track any thing you can create transactions for.
> 
> You should probably speak to a local CPA to make sure you are recording 
> things in line with local laws, especially for tax purposes, but the general 
> procedure for transactions works just fine for any asset, long or short term, 
> as it does for anything else in GnuCash.
> 
> While there are no special asset features of GnuCash, (outside of investment 
> portfolios) you can enter transactions to record and track value, as well as 
> manage loans taken out on such assets like mortgages. You can create or run 
> custom reports to show you just the info you want, with regard to that asset.
> 
> Please describe in more detail (no numbers needed, or, fake numbers are fine) 
> what you are trying to accomplish and we’ll see if someone here can aid you 
> in creating the needed transaction entries.
> 
> Otherwise, basic purchase, sale, and depreciation schedule transactions can 
> be entered in GnuCash very easily.
> 
> Regards,
> Adrien
> 
>> On May 17, 2019, at 10:13 PM, Peter Peterson  wrote:
>> 
>> Hi, is there a way that I can manage my fixed assets? To track them. For
>> depreciation purposes?
>> 
>> Regards
>> Peter
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] QFX vs OXR/QXF

[David T. via gnucash-user]

Jeffrey,
Thanks for filling me in on the vagaries and nuances of bank processes. 

I stand by my assertion that if you are downloading your transactions from the 
bank, then you are by default choosing to accept *their* accounting of your 
money. 

If this level of difference bothers you, then you might consider manually 
entering the transactions yourself, and then conduct a true reconciliation when 
you receive your bank statement. Alternatively, you can change the details of 
the imported transactions. 

David

 
 
  On Thu, May 16, 2019 at 11:08, jeffrey black 
wrote:   On 5/15/2019 8:18 PM, D via gnucash-user wrote:
> Alton,
>
>
> On May 15, 2019, at 10:12 PM, Alton Brantley  wrote:
>
>> You should be aware that the OFX import will use the posting date only as 
>> its import date. Your statements will list the transaction date, so your 
>> statements and your ledger will not match directly.
> I don't understand. First off, in most cases debit card transactions have the 
> same date in the bank records as I do. The exceptions are handwritten checks, 
> the images of which most banks supply in their statements (so you can 
> adjust). Finally, if you are importing transactions from your bank, aren't 
> you already accepting their timing?
>


Real time transaction dates frequently will not match the posting date 
for debit/cc/ach/transfer transactions.  It depends primarily on when 
the payee runs a batch total.  Some are manually batched, others are 
automatically processed at a set time or number of transactions.  Banks 
typically postdate charges after closing on Saturday thru Sunday until 
Monday, unless Monday falls on a bank holiday (then Tuesday).

Checks by default will almost never match, typically a 2 day wait plus 
however long the payee decides to wait before depositing  it (I've had 
checks not show up for 3 months on statements).  The exception is if the 
payee goes directly to your bank and cashes it.

Irregardless, I try to go with the transaction date, especially on 
checks.  The ones I forgot to manually enter go with the date provided 
by the financial institution, unless I go back and edit them to match 
the date on the original receipt.

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


-- 
--JEffrey Black M.B.A.

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

Re: [GNC] QFX vs OXR/QXF

[David T. via gnucash-user]

The most common issue that crops up with importing QIF data seems to be date 
formatting, such as a date that is in dd-mm- format (when the rest of the 
file is mm-dd- format). 

Unfortunately, there really isn't any easy way to locate such errors, short of 
scanning through the source file for the errors (remember that QIF is a text 
file). Some have had success by breaking the file into pieces to narrow down 
the error. 

David

 
 
  On Thu, May 16, 2019 at 14:15, Richard wrote:   Thanks so 
much for the assistance, Derek. If I understand correctly, my 
Quicken 2016 exports to a proprietary file format - QXF.  GnuCash 
imports the more open/robust file format - QFX. These formats are not 
compatible. However, my bank does download to QFX so that should work 
with GnuCash. (I misspoke in my original statement saying that my 
Quicken exports to QFX - this stuff gets a bit confusing)

The trick now is to get my historical data from Quicken into GnuCash 
since my Quicken export QXF can not be imported by GnuCash QFX format.

I've exported from Quicken using the QIF format and that appears to work 
fine. However, when I try to import the QIF file into GnuCash, all seems 
to go fine through the first 14 steps but at step 15 (QIF Import - 
Start), it ends with the message "failed". At step 19 - QIF Import 
Summary, I get the message "There was a problem with the import" No 
additional information follows. See below.

Any ideas?

Thanks,

Richard


On 5/15/2019 9:27 AM, Derek Atkins wrote:
> Hi,
>
> Richard  writes:
>
>> Both my Quicken 2016 and my bank institutions export to QFX files. But
>> GnuCash only offers import from OXF/QXF files. Is this a GnuCssh typo
>> or bug, i.e., misplacement of the "X" in the file extension?
> It is not a typo.  There is a difference between
> OFX/QFX and QXF.
>
> OFX/QFX is the Open Financial eXchange (and a quicken variant).  GnuCash
> can import this.
>
> However, QXF is the Quicken eXchange Format, which is their new,
> proprietary storage format.  GnuCash cannot import QXF.
>
> Are you sure your bank is exporting QFX and not QXF?  Also, could you
> get quicken to export QIF?
>
> Hope this helps,
>
>> Thanks,
>>
>> Richard
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> -derek
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Dimensions in Accounts

[David T. via gnucash-user]

Colin--
Having top level accounts for entities only will work if all the subsidiary 
accounts are the proper type (that is, you can't mix asset accounts and 
liability accounts).
 
 
  On Mon, Apr 29, 2019 at 13:08, Colin Law wrote:   Is it a 
big complication to have top level asset accounts Me and Wife
(or whatever) with the relevant bank accounts under them?

Colin

On Mon, 29 Apr 2019 at 05:03, Sachin Danave  wrote:
>
> Dear All,
>
> This may sound like a feature request, but just wanted to know if anything
> like this already exists.
>
> I am preparing accounts for 2 persons (me and my wife) in the same set up.
> That gives me an advantage of seeing the whole financial status at one go.
> However, for Taxation purposes, I would like to have a dimension that
> specifies the owner of an account. E.g. A Bank account that is owned by me
> and a bank account owned by my wife. I could do this using Subaccounts,
> however, that complicates the Chart of Accounts substantially. Traditional
> accounting packages deal with this by allowing to define a dimension to
> different accounts, whereby you can classify the accounts. This
> classification field then can be used in reporting.
>
> My basic question is, can we add such "custom" fields in Accounts ? If so,
> any guidance is welcome !!!
>
> Thanks in advance
>
> Best Regards
>
> Sachin
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] De-Reconciliation Settings

[David T. via gnucash-user]

It was pointed out to me in another thread that one can reset specific warnings 
flags using Action->Reset Warnings. 

I’d like to raise a couple of points with this dialog, now that I have been 
introduced to it…

First off, the dialog is quite opaque, insofar as it is (apparently) only 
showing warnings for which I have selected options previously. There is no way 
for me to determine what (if any) other options I have here. I imagine it would 
be a whole lot clearer if I could have a listing of all the various options, 
along with their current setting. It is counterintuitive to me the way it is 
set up here.

Be that as it may, I have three entries listed here: “Change contents of 
reconciled split”“Remove a split from a transaction”“Commit changes to a 
transaction”

The first setting listed here refers to the behavior of de-reconciling a split 
in GnuCash. However, if a user changes Transaction-level data elements—such as 
the Description field—a split will become de-reconciled. Therefore, this 
preference is misnamed, and should be changed, since I should receive an alert 
if I change the description and the reconcile flag gets reset. Perhaps “Change 
reconcile flag upon edit” would be better?

Second, it seems to me that the boundary for when a split becomes de-reconciled 
needs to be drawn differently. I know this issue was discussed recently, and 
there were reasons given for why the logic falls the way it does. However, 
reconciliation applies to the *split*, as shown by the fact that each split in 
a transaction can be separately reconciled in its own account. Changing the 
status of the split based on a change in the transaction is inconsistent and 
illogical to me. 

I have transactions with as many as ten splits, in which several splits are 
reconciled. If, for some reason, I then change the description of the 
transaction, then every one of those reconciled splits will get de-reconciled-- 
requiring me to reconcile every linked account.

Finally, I will note that the program is at least consistent, in that when you 
change a description field, it does in fact change every cleared split in that 
transaction. I do, however, question whether that is the correct action to 
impose. 

David T. 


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

Re: [GNC] Dimensions in Accounts

[David T. via gnucash-user]

Sachin,
That sounds a lot like "Classes", which is a long standing feature request that 
has yet to be implemented. 

David t. 

 
 
  On Mon, Apr 29, 2019 at 9:32, Sachin Danave wrote:   
Dear All,

This may sound like a feature request, but just wanted to know if anything
like this already exists.

I am preparing accounts for 2 persons (me and my wife) in the same set up.
That gives me an advantage of seeing the whole financial status at one go.
However, for Taxation purposes, I would like to have a dimension that
specifies the owner of an account. E.g. A Bank account that is owned by me
and a bank account owned by my wife. I could do this using Subaccounts,
however, that complicates the Chart of Accounts substantially. Traditional
accounting packages deal with this by allowing to define a dimension to
different accounts, whereby you can classify the accounts. This
classification field then can be used in reporting.

My basic question is, can we add such "custom" fields in Accounts ? If so,
any guidance is welcome !!!

Thanks in advance

Best Regards

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

Re: [GNC] Changing account tree on large database

[David T. via gnucash-user]

David,

I think a couple of additional points of reference from you would be helpful. 

What operating system are you experiencing this slow performance? I believe 
it’s WIndows, but I could be mistaken. The relative performance benchmarks seem 
to be OS-dependent. I am using MacOS, and while some reports do load slowly 
(the Asset Barchart comes to mind), most of my experience has been positive on 
this regard. I do not see delays on entry—certainly not on order of seconds.

Similarly, what size is your data file? Mine goes back 13 years, and a quick 
survey of the file in SQL format shows 900 entries in accounts, a little over 
27,000 transactions with 63,000 splits overall. As compressed XML, it’s just 
over 4MB. My data file is larger than Cricket’s proposed import, and I am not 
seeing problems on my setup. Of course, that all could change when I migrate to 
different machine and OS later this year...

My point is that your experience, while real and a valid data point, is 
nonetheless your experience, and not necessarily the norm. My own (similarly 
singular) experience is starkly different from yours. I think the overall user 
experience is somewhere along the line between these two. 

FWIW, my import process from Quicken (way back when) took a while to work out, 
but I eventually was able to import the entire QIF file (account structure and 
all) directly into GnuCash. My method was to export the QIF, import into 
GnuCash, see the gaps and failures, go back to Quicken (where my familiarity 
allowed me to fix things quickly), change the Quicken data to address the gaps, 
and repeat until such point as the incoming data was clean enough to move 
forward.

David T.

> On Apr 27, 2019, at 3:20 AM, David Carlson  
> wrote:
> 
> Cricket,
> 
> One more point...
> 
> Strongly consider only moving one or two years data to GnuCash.  When your
> file gets large you may prefer to have a new file for each year or whatever
> to keep GnuCash from bogging down and running too slow.  It gets worse
> quickly if you leave a lot of reports and register windows open, or if you
> have a Hi-Res monitor, and having a powerful computer is not enough to
> prevent that.
> 
> In my case it takes over a minute to open my file and about 10 seconds
> every time I press the Enter key.  the periodic saves take so long that I
> can squeeze in about 1/2 a game of Solitaire.
> 
> David Carlson
> 
> On Fri, Apr 26, 2019 at 4:31 PM Cricket Onebit 
> wrote:
> 
>> On Thu, 25 Apr 2019 at 17:29, Adrien Monteleone <
>> adrien.montele...@lusfiber.net> wrote:
>> 
 I'm preparing to convert 14,000 transactions from Quicken. It's a bit
 overwhelming, and I've put it off for years.
>>> 
>>> Sounds like a daunting task. I don’t do such imports, but reading the
>>> various threads over the years, this will be a doozy.
>>> 
>> 
>> Yes, it's a daunting task, but I do't want to lose 10+ years of data. I'm
>> using an old version of Quicken, and don't trust the new version to be able
>> to read it. The old version might not work on newer Windows. I need to move
>> it.
>> 
>> I’d try finding some of those threads or asking about a general ‘best
>>> practices’ or ‘workflow’ to accomplish this with the least amount of
>>> headache.
>>> 
>> 
>> There doesn't seem to be an easy way to find those threads. I might not be
>> searching right. "site:lists.gnucash.org quicken" has posts from many
>> years
>> ago on the first page, but not any from 2019. I know there are some from
>> 2019.
>> 
>> Two gnucash.org pages need to be updated. They have broken links.
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> https://lists.gnucash.org/search/?idxinfo=gnucash-user
>> 
>> Yes, you can do this at will, over and over till you have your tree the way
>>> you like it. (and then re-factor it again months later when you change
>> your
>>> mind)
>>> 
>> 
>> Yay! for easy moving / promoting / demoting / etc child / parent / sibling
>> / cousin accounts. Both your suggested methods make sense.
>> 
>> One less reason to put off the migration.
>> 
>> Also, for this particular example, I’d opt for tags for each kid instead of
>>> accounts, see below about Cars.
>>> 
>> 
>> I didn't think GNUCash supported tags. I plan to use #tagone in a text
>> field. That's one of the things I need to do in Quicken. Search for each
>> transaction using a label, and put it in a text field. Problem: The text
>> fields are short. Maybe I'll create accounts/categories for each tag, and
>> add a $0.01 line. That will at least preserve the info. Then in GC edit
>> again to put the tags in a text field and undo the $0.01 split. (Not $0
>> because I think Quicken ignores $0 lines.)
>> 
>> I’ve not found one yet, though that may be in the documentation. Look into
>>> Double-Line mode to give you an extra note field. Once discovered, I now
>>> use it extensively.
>>> 
>> 
>> I like that GNUCash makes it easy to switch between journal, register, and
>> split views.
>> 
>> The #1 

Re: [GNC] Need help reconciling

[David T. via gnucash-user]

All of this is covered in the Guide at 
https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_txns.html#txns-reconcile1
 
,
 especially 2.9.4.1, which includes a section regarding the starting balance, 
as well as a note specifically about the starting balance:

Note
The first time you reconcile your account, the starting balance will be 0.00, 
thus probably not the opening balance of your account. When you reconcile the 
account, the opening balance for the account will be included in the 
reconciliation, and the result should balance.


ToddAndMango, you might try reading the documentation.

David T.

> On Apr 27, 2019, at 1:18 PM, Colin Law  > wrote:
> 
> On Sat, 27 Apr 2019 at 08:34, ToddAndMargo via gnucash-user
> mailto:gnucash-user@gnucash.org>> wrote:
>> 
>> On 4/27/19 12:11 AM, Colin Law wrote:
>>> I am sure we have been over this before.  You should not generally
>>> need to touch the reconcile column in the register yourself.  It is
>>> all done through the Reconcile feature.  Open the credit card (or
>>> bank) account and select Options > Reconcile.  Check the opening
>>> balance matches the opening balance on the statement from the bank,
>>> enter the closing balance from the statement and then tick off the
>>> transactions.
>>> 
>>> Colin
>> 
>> Something is wrong.  I don't have an opening Balance.  It
>> says it is zero
> 
> If it is the first time you have reconciled this account then it will
> be zero, and you should see your opening balance that you entered in
> the reconcile window.  Obviously that is not in the bank statement.
> This is a one-off situation due to the fact that you have started
> using gnucash with the account already up and running.
> 
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org 
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] QIF File import

[David T. via gnucash-user]

Tommy,

Thanks for pointing to the wiki! Note that your first link (to the FAQ) simply 
refers the reader to the page at the second link…

I think the page at this second link covers most of the issues that users have 
raised over the years.

David T.

> On Apr 27, 2019, at 4:17 AM, Tommy Trussell  wrote:
> 
> On Wed, Apr 24, 2019 at 9:58 PM Hardeep Sodhi  wrote:
> 
>> I am trying to import Quicken data into Gnucash.
>> 
>> I have created a QIF File. The import starts well, but stops at the
>> 'Tradeable Commodities' screen since there is no 'Next' button I can see at
>> the bottom of the screen ( as there is in screens previous).
>> 
>> I think this is a user interface issue. Have tried on my laptop as well as
>> desktop but with no success.
>> 
> 
> What version of GnuCash?
> What operating system?
> 
> Have you checked the FAQ?
> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...
> 
> Have you seen the FAQ link to the Quicken Migration page?
> https://wiki.gnucash.org/wiki/Quicken_Migration
> 
> I have not done a QIF import in many years, but if you're importing several
> years of data you might go back into Quicken and export just a single year
> or a single account category to get started. You can do several "test"
> imports and see ways to make the final import go a lot smoother. Since
> you're stumbling on "tradeable commodities," maybe at minimum it would help
> to export your trading accounts separately.
> 
> If you continue to have trouble at a specific point, you may need to look
> carefully at the QIF file in a text editor to see if you can see an obvious
> error in the data.
> 
> (Please don't forget to reply to the list, as suggested below.)
> 
> 
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Quicken import and duplicate records

[David T. via gnucash-user]

Priit,
When I migrated over, I did it the same way as you describe here-- that is, I 
imported the entire file in one pass. I went back to quicken numerous times to 
clean up the exported data, but eventually got an import that was clean enough. 
I offer that simply as a counter story to that of the others'. It is possible 
to import it all in at once.

David T. 
 
 
  On Tue, Apr 30, 2019 at 1:21, Priit Lilleleht 
wrote:   Hi David C!

Thank You, I have read the Quicken migration page in Wiki and probably
followed it mostly except for splitting the import into smaller pieces. The
first try was importing all 18 years of data at once. It took some time but
generally succeeded. I'll try to import just a few accounts to see if it
helps.

I would like to have all the financial history in one database so importing
only last years or so does not appear appealing (as the migration page
suggests)...

Best Regards,
Priit

Kontakt David Cousens () kirjutas kuupäeval P,
28. aprill 2019 kell 00:51:

> Priit,
>
> Are you following the suggestions on the following Wiki page
> https://wiki.gnucash.org/wiki/Quicken_Migration.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Questions

[David T. via gnucash-user]

1 - it's alphabetical. You could rename the accounts with numeric prefixes or 
use account codes and story on them. 
2 - the income statement isn't set up to accommodate those breakdowns. You 
might try creating a multi column report with income statements for different 
time periods.
3 - don't even know what "G/L" stands for here, so can't help. 
David

 
 
  On Mon, May 6, 2019 at 16:44, Stephen Camidge wrote:   
1) I set up a new book on the Mac version of gnucash using "A Simple 
Checkbook". The Chart of Accounts places Income below Expenses - why? I 
added Top Level Accounts for Liabilities and it was put below Income.  
The Transaction Report shows Income below Expenses.  How do I change the 
order?

2) Income Statement show the selected period in the right order but 
cannot show columns by month. Same with Profit and Loss. Transaction 
report can, but in the wrong order (see 1).

3) G/L report shows one account only, no matter how many I select. 
Transaction Report can select all.

What am I missing?

Thank you.





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

Re: [GNC] Questions

[David T. via gnucash-user]

3 - I spoke too soon. There is something weird going on there. I can select 
multiple accounts, and some will display, while others do not. Not sure what is 
going on there.

> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>  wrote:
> 
> 2 - Multicolumn reports are already part of GnuCash.
> 3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
> accounts, and received sane results. Is it possible that when you attempted 
> to select multiple accounts, you actually selected only the last account you 
> clicked? Many’s the time that I have thought I had the Command key held down, 
> only to discover that I’d succeeded in picking only that last account…
> 
> 
> David
> 
>> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
>> 
>> 1) OK
>> 
>> 2) yes - this would be most useful
>> 
>> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
>> only the first selected account appears in the General Ledger Report.
>> 
>> -- 
>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>> 
>> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>> 1 - As I mentioned, account codes will work for this. Assign each 
>>> account a numeric code, add the code column to the COA, and sort on it. 
>>> Done.
>>> 2 - Multicolumn reports.
>>> 3 - Are you talking about the “General Ledger” report, or the “General 
>>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>> behaves exactly like the generic “Transaction Report” you mention 
>>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>> able to select accounts for inclusion on the report. Can you explain 
>>> more specifically what you are doing and seeing, and what you expect to 
>>> find that you are not?
>>> 
>>> David
>>> 
>>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>>>> wrote:
>>>> 
>>>> 1) different order to reflect what I am used to seeing in other accounting 
>>>> programs
>>>> 
>>>> 2) I agree that comparative reports would be useful - other programs offer 
>>>> them as option, the program should too
>>>> 
>>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>>>> transaction report can do this, but the G/L detail report should.
>>>> 
>>>> 
>>>> -- 
>>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>>> 
>>>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>>>>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>>>>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>>>>>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>>>>>> I added Top Level Accounts for Liabilities and it was put below 
>>>>>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>>>>>> change the order?
>>>>> Collating sequence ( L > I)   Just curious, but why do you want a 
>>>>> different order?
>>>>> 
>>>>>> 2) Income Statement show the selected period in the right order but 
>>>>>> cannot show columns by month. Same with Profit and Loss. Transaction 
>>>>>> report can, but in the wrong order (see 1).
>>>>> You are asking for a series of "Income Statement" reports for 
>>>>> consecutive periods displayed side by side (each P aka Statement of 
>>>>> Revenues and Expenses < what called depends on entity, same report >. In 
>>>>> other words, EACH has a defined start and end date since this report is 
>>>>> for an interval.
>>>>> 
>>>>> To produce such a (finished) report, use an editor capable of supporting 
>>>>> columns and export each, then bring into its proper column. WHY not 
>>>>> "within" gnucash? Stop a moment and think. Think of all the possible 
>>>>> variations that would be wanted (how many to show in parallel, somebody 
>>>>> else might want quarters or years, not months). Think about the after 
>>>>> editing required (the CoA might have had changes, not exactly the same 
>>>>> in each interval).
>>>>> 
>>>>> BTW -- since I keep books for non-profits, usually doing two years in 
>>>>> parallel
>>>>> 
>>>&g

Re: [GNC] Questions

[David T. via gnucash-user]

1 - As I mentioned, account codes will work for this. Assign each account a 
numeric code, add the code column to the COA, and sort on it. Done.
2 - Multicolumn reports.
3 - Are you talking about the “General Ledger” report, or the “General Journal” 
report? My version of the former report (GC 3.4 under MacOX) behaves exactly 
like the generic “Transaction Report” you mention (indeed, I suspect that under 
the hood, that’s what it is). IOW, I am able to select accounts for inclusion 
on the report. Can you explain more specifically what you are doing and seeing, 
and what you expect to find that you are not?

David

> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
> 
> 1) different order to reflect what I am used to seeing in other accounting 
> programs
> 
> 2) I agree that comparative reports would be useful - other programs offer 
> them as option, the program should too
> 
> 3) multiple accounts in a G/L report are standard elsewhere - the transaction 
> report can do this, but the G/L detail report should.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
>> On 5/6/2019 7:13 AM, Stephen Camidge wrote:
>>> 1) I set up a new book on the Mac version of gnucash using "A Simple 
>>> Checkbook". The Chart of Accounts places Income below Expenses - why? 
>>> I added Top Level Accounts for Liabilities and it was put below 
>>> Income.  The Transaction Report shows Income below Expenses.  How do I 
>>> change the order?
>> Collating sequence ( L > I)   Just curious, but why do you want a 
>> different order?
>> 
>>> 2) Income Statement show the selected period in the right order but 
>>> cannot show columns by month. Same with Profit and Loss. Transaction 
>>> report can, but in the wrong order (see 1).
>> You are asking for a series of "Income Statement" reports for 
>> consecutive periods displayed side by side (each P aka Statement of 
>> Revenues and Expenses < what called depends on entity, same report >. In 
>> other words, EACH has a defined start and end date since this report is 
>> for an interval.
>> 
>> To produce such a (finished) report, use an editor capable of supporting 
>> columns and export each, then bring into its proper column. WHY not 
>> "within" gnucash? Stop a moment and think. Think of all the possible 
>> variations that would be wanted (how many to show in parallel, somebody 
>> else might want quarters or years, not months). Think about the after 
>> editing required (the CoA might have had changes, not exactly the same 
>> in each interval).
>> 
>> BTW -- since I keep books for non-profits, usually doing two years in 
>> parallel
>> 
>>> 
>>> 3) G/L report shows one account only, no matter how many I select. 
>>> Transaction Report can select all.
>> Why would you expect different reports to be the same in this regard?
>> 
>> Michael D Novack
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Questions

[David T. via gnucash-user]

2 - Multicolumn reports are already part of GnuCash.
3 - I just loaded 3.5, ran the G/L report, selected a random set of disjoint 
accounts, and received sane results. Is it possible that when you attempted to 
select multiple accounts, you actually selected only the last account you 
clicked? Many’s the time that I have thought I had the Command key held down, 
only to discover that I’d succeeded in picking only that last account…


David

> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  wrote:
> 
> 1) OK
> 
> 2) yes - this would be most useful
> 
> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
> only the first selected account appears in the General Ledger Report.
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>> 1 - As I mentioned, account codes will work for this. Assign each 
>> account a numeric code, add the code column to the COA, and sort on it. 
>> Done.
>> 2 - Multicolumn reports.
>> 3 - Are you talking about the “General Ledger” report, or the “General 
>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>> behaves exactly like the generic “Transaction Report” you mention 
>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>> able to select accounts for inclusion on the report. Can you explain 
>> more specifically what you are doing and seeing, and what you expect to 
>> find that you are not?
>> 
>> David
>> 
>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  wrote:
>>> 
>>> 1) different order to reflect what I am used to seeing in other accounting 
>>> programs
>>> 
>>> 2) I agree that comparative reports would be useful - other programs offer 
>>> them as option, the program should too
>>> 
>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>>> transaction report can do this, but the G/L detail report should.
>>> 
>>> 
>>> -- 
>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>> 
>>> On Mon, May 6, 2019, at 8:08 AM, Michael or Penny Novack wrote:
 On 5/6/2019 7:13 AM, Stephen Camidge wrote:
> 1) I set up a new book on the Mac version of gnucash using "A Simple 
> Checkbook". The Chart of Accounts places Income below Expenses - why? 
> I added Top Level Accounts for Liabilities and it was put below 
> Income.  The Transaction Report shows Income below Expenses.  How do I 
> change the order?
 Collating sequence ( L > I)   Just curious, but why do you want a 
 different order?
 
> 2) Income Statement show the selected period in the right order but 
> cannot show columns by month. Same with Profit and Loss. Transaction 
> report can, but in the wrong order (see 1).
 You are asking for a series of "Income Statement" reports for 
 consecutive periods displayed side by side (each P aka Statement of 
 Revenues and Expenses < what called depends on entity, same report >. In 
 other words, EACH has a defined start and end date since this report is 
 for an interval.
 
 To produce such a (finished) report, use an editor capable of supporting 
 columns and export each, then bring into its proper column. WHY not 
 "within" gnucash? Stop a moment and think. Think of all the possible 
 variations that would be wanted (how many to show in parallel, somebody 
 else might want quarters or years, not months). Think about the after 
 editing required (the CoA might have had changes, not exactly the same 
 in each interval).
 
 BTW -- since I keep books for non-profits, usually doing two years in 
 parallel
 
> 
> 3) G/L report shows one account only, no matter how many I select. 
> Transaction Report can select all.
 Why would you expect different reports to be the same in this regard?
 
 Michael D Novack
 
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 To update your subscription preferences or to unsubscribe:
 https://lists.gnucash.org/mailman/listinfo/gnucash-user
 If you are using Nabble or Gmane, please see 
 https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
 -
 Please remember to CC this list on all your replies.
 You can do this by using Reply-To-List or Reply-All.
 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> 

___
gnucash-user mailing list

Re: [GNC] Questions

[David T. via gnucash-user]

2 - You misunderstand me. I am not speaking about using the Transaction Report 
with subtotals. I am speaking about using multiple instances of the Income 
report you desire, each set for the period you want. Go to Reports->Sample & 
Custom Reports->Custom Multicolumn Report and set it up with (for example) two 
columns, with an Income report for the previous quarter in the first column, 
and an Income Report for the current quarter in the second column.

3 - There is something fishy with the General Ledger report. It doesn’t seem to 
recognize certain accounts, and there doesn’t seem rhyme or reason to the 
accounts it includes or omits. This is true in both 3.4 and 3.5. It doesn’t 
seem to be the currency of the accounts (that is, I can see some but not all 
accounts denominated in different currencies). It doesn’t seem to be the depth 
of the accounts selected (I can see some but not all accounts at numerous 
different levels of the hierarchy). I will note that it will not display a 
selected account if there are no transactions in the period selected. However, 
that doesn’t explain everything that’s going on here…

David


> On May 6, 2019, at 7:05 PM, Stephen C. Camidge  wrote:
> 
> 2) Yes, I can get multi column reports with the Transaction Report, show 
> totals monthly by account, but it will not display monthly totals and it will 
> not display Revenue separately from Expenses with totals for Revenue and for 
> Expenses.
> 
> 3) I did make the multiple selection. Thank you for confirming that something 
> is indeed going on.
> 
> 
> -- 
> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
> 
> On Mon, May 6, 2019, at 9:17 AM, David T. wrote:
>> 3 - I spoke too soon. There is something weird going on there. I can 
>> select multiple accounts, and some will display, while others do not. 
>> Not sure what is going on there.
>> 
>>> On May 6, 2019, at 6:38 PM, David T. via gnucash-user 
>>>  wrote:
>>> 
>>> 2 - Multicolumn reports are already part of GnuCash.
>>> 3 - I just loaded 3.5, ran the G/L report, selected a random set of 
>>> disjoint accounts, and received sane results. Is it possible that when you 
>>> attempted to select multiple accounts, you actually selected only the last 
>>> account you clicked? Many’s the time that I have thought I had the Command 
>>> key held down, only to discover that I’d succeeded in picking only that 
>>> last account…
>>> 
>>> 
>>> David
>>> 
>>>> On May 6, 2019, at 6:15 PM, Stephen C. Camidge  
>>>> wrote:
>>>> 
>>>> 1) OK
>>>> 
>>>> 2) yes - this would be most useful
>>>> 
>>>> 3) General Ledger - I can select multiple accounts, but for me (Mac, 3.5) 
>>>> only the first selected account appears in the General Ledger Report.
>>>> 
>>>> -- 
>>>> Stephen C. Camidge scami...@fastmail.fm   (519) 363-3912
>>>> 
>>>> On Mon, May 6, 2019, at 8:41 AM, David T. wrote:
>>>>> 1 - As I mentioned, account codes will work for this. Assign each 
>>>>> account a numeric code, add the code column to the COA, and sort on it. 
>>>>> Done.
>>>>> 2 - Multicolumn reports.
>>>>> 3 - Are you talking about the “General Ledger” report, or the “General 
>>>>> Journal” report? My version of the former report (GC 3.4 under MacOX) 
>>>>> behaves exactly like the generic “Transaction Report” you mention 
>>>>> (indeed, I suspect that under the hood, that’s what it is). IOW, I am 
>>>>> able to select accounts for inclusion on the report. Can you explain 
>>>>> more specifically what you are doing and seeing, and what you expect to 
>>>>> find that you are not?
>>>>> 
>>>>> David
>>>>> 
>>>>>> On May 6, 2019, at 5:56 PM, Stephen C. Camidge  
>>>>>> wrote:
>>>>>> 
>>>>>> 1) different order to reflect what I am used to seeing in other 
>>>>>> accounting programs
>>>>>> 
>>>>>> 2) I agree that comparative reports would be useful - other programs 
>>>>>> offer them as option, the program should too
>>>>>> 
>>>>>> 3) multiple accounts in a G/L report are standard elsewhere - the 
>>>>>> transaction report can do this, but the G/L detail report should.
>>>>>> 
>>>>>> 
>>>>>> -- 
>>>>>> Stephen C. Camidge sc

Re: [GNC] column widths - balance

[David T. via gnucash-user]

Note that Section 2.3.3 of the Guide includes the following:

Note
In the register windows, you can resize the various columns that GnuCash 
displays, but keep in mind that the Description and Balance columns behave 
differently from other columns.

The Description column is designed to expand automatically to fill all unused 
horizontal screen space. Therefore you should set the widths of all your other 
columns before setting the Description column width.

The Balance column must be resized by double-clicking on the column heading.


David T.

> On May 3, 2019, at 2:07 AM, David Carlson  wrote:
> 
> Every column except the description can be adjusted by grabbing and
> dragging the right edge with the mouse.  The balance column is a little
> harder to do that way, but the double click method usually makes an
> acceptable width.
> For the Description drag the right edge left until the horizontal scrollbar
> disappears.
> 
> 
> 
> On Thu, May 2, 2019 at 2:09 PM Jeff Albrecht  wrote:
> 
>> Try double clicking on column headers.
>> 
>>  - Jeff
>> 
>> On 5/2/2019 12:00 PM, Elmar wrote:
>>> For some reason I can't seem to expand the column width for the
>>> account balance (e.g. a bank cash money market account, last column in
>>> the register) - it will only display 5 places in front of the decimal
>>> point.  Is this a bug?
>>> 
>>> GC Version: 3.5 Build ID: git 3.5+(2019-03-30) on Linux Mint 19.1 Mate
>>> desktop.
>>> 
>>> - Elmar
>>> 
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> 
> 
> -- 
> David Carlson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] column widths - balance

[David T. via gnucash-user]

Well, look at that! It does work now. I’m pretty sure that’s a change. I will 
note that it is still quite picky, getting the correct cursor without hitting 
the scroll bar. And, as you note, moving to the right from the far right can be 
counterintuitive or even impossible. I think I’ll stick with double clicking 
the header.

Cheers,
David

> On May 3, 2019, at 7:29 PM, John Ralls  wrote:
> 
> Grabbing the right-hand border of the Balance Column and dragging it right or 
> left still works, at least on MacOS. That assumes that one can drag right, of 
> course. If the GnuCash window is on the right edge of the monitor, as is the 
> case in fullscreen mode, then there's nowhere for the pointer to go and one 
> won't be able to expand the balance column.
> 
> It's perhaps counter-intuitive even for users with space on the desktop that 
> dragging the border to the right past the edge of the GnuCash window will do 
> anything.
> 
> Regards,
> John Ralls
> 
> 
>> On May 2, 2019, at 7:21 PM, David Carlson  
>> wrote:
>> 
>> When did that change?  in release 2.6.19 you can still adjust the balance
>> by moving the right edge of the title.
>> 
>> On Thu, May 2, 2019 at 8:58 PM David T.  wrote:
>> 
>>> Note that Section 2.3.3 of the Guide includes the following:
>>> 
>>> Note
>>> 
>>> In the register windows, you can resize the various columns that *GnuCash*
>>> displays, *but keep in mind that the Description and Balance columns
>>> behave differently from other columns*.
>>> 
>>> The *Description* column is designed to expand automatically to fill all
>>> unused horizontal screen space. Therefore you should set the widths of all
>>> your other columns before setting the Description column width.
>>> 
>>> The *Balance* column must be resized by double-clicking on the column
>>> heading.
>>> 
>>> David T.
>>> 
>>> On May 3, 2019, at 2:07 AM, David Carlson 
>>> wrote:
>>> 
>>> Every column except the description can be adjusted by grabbing and
>>> dragging the right edge with the mouse.  The balance column is a little
>>> harder to do that way, but the double click method usually makes an
>>> acceptable width.
>>> For the Description drag the right edge left until the horizontal scrollbar
>>> disappears.
>>> 
>>> 
>>> 
>>> On Thu, May 2, 2019 at 2:09 PM Jeff Albrecht  wrote:
>>> 
>>> Try double clicking on column headers.
>>> 
>>> - Jeff
>>> 
>>> On 5/2/2019 12:00 PM, Elmar wrote:
>>> 
>>> For some reason I can't seem to expand the column width for the
>>> account balance (e.g. a bank cash money market account, last column in
>>> the register) - it will only display 5 places in front of the decimal
>>> point.  Is this a bug?
>>> 
>>> GC Version: 3.5 Build ID: git 3.5+(2019-03-30) on Linux Mint 19.1 Mate
>>> desktop.
>>> 
>>> - Elmar
>>> 
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> 
>>> 
>>> --
>>> David Carlson
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>> 
>>> 
>>> 
>> 
>> -- 
>> David Carlson
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] Change a batch of transactions from income to Expe

[David T. via gnucash-user]

That information has been in the documentation since 2.4. Not sure what edits 
you are referring to...
 
 
  On Fri, Jul 5, 2019 at 13:11, David Cousens wrote:  
 David,

Sorry I hadn't realized the section i put in on that had made it into the
current version of the docs. Thanks for pointing that out.

David 



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

Re: [GNC] Change a batch of transactions from income to Expense

[David T. via gnucash-user]

David, 

I am not sure why you say that the documentation lacks a description of debits 
and credits; I am sure you are aware of section 2.1 of the Guide, which goes 
into some detail about this precise issue. 

David T. 

 
 
  On Fri, Jul 5, 2019 at 3:32, David Cousens wrote:   
Alan,
The guide has an introductory session. The present version doesn't have a
full explanation of the way 
accountants use debits and credits but the next version will. You will find
a pretty good explanantion on Wikipedia and a few other sites. Look up
Double Entry, Debits and Credits with Google. In short form

Debits  increase the balance of Asset and Expense accounts
Credits decrease the balance of Asset and Expense accounts
Credits increase the balance of Liability, Equity and Income accounts
Debits decrease the balance of Liability, Equity and Income accounts

For an individual transaction  the sum of debits = sum of credits

Davdi



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

Re: [GNC] Change a batch of transactions from income to Expe

[David T. via gnucash-user]

I guess I don't know what part of it you're referring to. In 2.4 I see notes 
about the meaning of debit and credit, as well as general discussion about 
double entry accounting. It seemed to me that would have addressed OP's needs, 
but I defer to your perspective.  
 
  On Fri, Jul 5, 2019 at 16:19, David Cousens wrote:  
 David 

It hasn't been in the documentation in that form since 2.4 as it was only
inserted in commit 007ab9 on the 30th May and Frank merged into maint a
couple of weeks ago then when John did the V3.6 release it was included in
that.

This is par tof  the ToC from the pdf version of the 2.4 docs
2. The Basics
.
8
        Accounting Concepts
...
8
                The 5 Basic Accounts
..
8
                The Accounting Equation
.
8
                Double Entry
..
9
      Data Entry Concepts

9

Cheers

David



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

Re: [GNC] Adding custom reports

[David T. via gnucash-user]

rgdobie,
Your method modifies the gnucash package directly.  While it works to do this, 
your changes will be overwritten every time you upgrade.  There is a method 
which avoids this (although I admit it has never worked for me).
David
P.S. when you use nabble, none of the regular list users see the message you 
reference. As you can see below, your reply comes to the list without context. 
Using phrases like "I had a similar problem" makes no sense without that 
context. 
 
 
  On Fri, Jul 12, 2019 at 10:50, rgdobie wrote:   I had 
a similar problem. This is how I got around it.
Assume:
    You are running Windows 7 64 bit version.
    You are running GnuCash 3.5.
    The Wiki method of loading a custom report using config-user.scm does not
work for you.
    Your new report is contained in the file rgdreport.scm.

Copy your custom report (e.g. rgdreport.scm) to:
C:\Program Files (x86)\gnucash\share\gnucash\scm\gnucash\report\

In the same folder edit utility-reports.scm

Between the line 
(use-modules (gnucash utilities))
and
(use-modules (gnucash report hello-world))

insert a new line for your new report e.g.
(use-modules (gnucash report rgdreport))

Save utility-reports.scm

Run GnuCash.

Your new report will show on the sub-menu  under Reports | Sample & Custom



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

Re: [GNC] Editing List of Income/Expenses

[David T. via gnucash-user]

Each entry in your list of expenses is a separate account in your chart of 
accounts.  You edit the list by removing accounts.  Bear in mind that if your 
account has transactions in it, you will be asked the account to which you want 
these transactions to be moved. 
David

 
 
  On Wed, Jul 3, 2019 at 22:38, Amanda Schafer wrote:   
I'm wanting to edit the list of income and expenses so that my transactions
are more specific to my situation, but I can't find that anywhere in the
menu listing or in the Help Guide.  Can someone direct me to that area
please?
ASchafer
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] print check register

[David T. via gnucash-user]

While in the register, try Reports->Account Report. 

HTH,David
 
 
  On Wed, Jul 3, 2019 at 6:40, Chris Tsuji wrote:   

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

Re: [GNC] Column Width

[David T. via gnucash-user]

Readers might like to consult:
https://cvs.gnucash.org/docs/C/gnucash-guide/txns-shortcuts1.html 


Additionally, the behavior of the register columns (and in particular the 
Description and Balance columns) is described at:
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-running-gnucash.html#basics-register2
 


David

> On Apr 17, 2019, at 5:05 PM, Justin Mathew via gnucash-user 
>  wrote:
> 
> Michael,
> 
>> If you type only DD then  to the next field, it will assume the current 
>> month and year.
> 
> This works.
> 
>> If you type DD/MM and  you’ll get the current year.
> 
> I can't type in the character / or - for that matter.
> 
> 
> -
> Regards,
> Justin Mathew
> mjus...@protonmail.com
> 
> Sent with ProtonMail Secure Email.
> 
> ‐‐‐ Original Message ‐‐‐
> On Wednesday, April 17, 2019 4:59 PM, Michael Hendry 
>  wrote:
> 
>>> On 17 Apr 2019, at 11:48, Justin Mathew via gnucash-user 
>>> gnucash-user@gnucash.org wrote:
>>> Is there any way to enter dates from keyboard? Eg, if you have to enter a 
>>> record for past dates, you have to choose the dates from the drop down 
>>> calendar. Any format that I can type to get the dates?
>>> 
>>> -
>>> 
>>> Regards,
>>> Justin Mathew
>>> mjus...@protonmail.com
>> 
>> Just type it, in the form DD/MM/YY
>> 
>> If you type only DD then  to the next field, it will assume the current 
>> month and year.
>> 
>> If you type DD/MM and  you’ll get the current year.
>> 
>> Michael
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

[GNC] Plot Size on Piechart reports

[David T. via gnucash-user]

Hello,

The attached screen shot shows three iterations of a standard Piechart. 
Each has its own set of accounts and slices, but each is set to plot its 
chart to the same 485 by 240 dimensions--and yet, each one is clearly a 
different size! While the first is an Expense piechart, I believe that 
they all use the same base Scheme code. And that doesn't explain why the 
two different Income Charts (Primary and Cap Gains) are sized differently.


Does anyone know why this is happening, and what might be done to get 
three identically-sized pie charts?


David

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

Re: [GNC] Plot Size on Piechart reports

[David T. via gnucash-user]

Dang. New mail client ate my screen shot! Next try...

On 8/12/2019 9:07 PM, David T. via gnucash-user wrote:

Hello,

The attached screen shot shows three iterations of a standard 
Piechart. Each has its own set of accounts and slices, but each is set 
to plot its chart to the same 485 by 240 dimensions--and yet, each one 
is clearly a different size! While the first is an Expense piechart, I 
believe that they all use the same base Scheme code. And that doesn't 
explain why the two different Income Charts (Primary and Cap Gains) 
are sized differently.


Does anyone know why this is happening, and what might be done to get 
three identically-sized pie charts?


David

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

Re: [GNC] journal entries

[David T. via gnucash-user]

I'm not sure how this is a challenge, especially since both John and 
David C. pointed you in the right direction in the docs. Perhaps you are 
associating the term "Journal entry" with something special?


To begin, set your View preference to "Basic" and on the 
Preferences:Accounts tab, uncheck "Use formal accounting labels."


In the Chart of Accounts, double-click Assets:Cash

In the Cash account register:

 * Type the date of the transaction, for example, today is August 12,
   2019, so I would enter 8/12/19 because I use US style dates. Your
   date preferences might have this as 12-08-2019, or even 2019-08-12!
 * After entering the date, press the Tab key twice, which will move
   the cursor two columns to the right, to the Description field
 * Type a Description. For example, if you purchased Ibuprofen(r) from
   CVS, you might enter a description like "CVS"
 * Press the Tab key one time, and move the cursor to the Transfer column
 * In the Transfer column, select Expenses:Drugs
 * Press Tab *two more times* to the Decrease column
 * Enter the amount for the drugs.
 * Press the Enter Key

What part of this wasn't clear in the documentation?

David


On 8/12/2019 8:20 PM, Harold via gnucash-user wrote:


  I have searched, looked, and read what I could find about journal entries in 
GC but I am no closer to understanding what I need to do to enter a journal 
entry. I am not an accountant and am using GC for my personal bookkeeping. I 
have entered journal entries in Quickbooks in the past but don't understand how 
to do it in GC. Can anyone nudge me in the right direction?Thanks,Harold

 On Sunday, August 11, 2019, 5:15:41 PM CDT, John Ralls 
 wrote:
  
  


On Aug 11, 2019, at 11:56 AM, Harold via gnucash-user 
 wrote:

I want to start tracking the cash payments that I make for drugs. I have been 
searching about making a journal entry in Gnucash but haven't found anything 
yet. Where do I find how to enter a journal entry in Gnucash using Linux?
___

Have you studied the Tutorial and Concepts Guide [1]?

Regards,
John Ralls

[1] http://www.gnucash.org/viewdoc.phtml?rev=3???=C=guide or Help>Tutorial 
and Concepts Guide from inside the 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Unrealized gain/loss on Forex

[David T. via gnucash-user]

I believe that the "Unrealized Losses" entry on the Trial Balance report is 
calculated. You will need to create an account for it, as well as the 
transaction to account for the loss. 

HTH,
David 

 
 
  On Wed, Aug 14, 2019 at 11:40, Jayakumar 
Chakravarthy wrote:   Hi,


When I make an Invoice and receive money in a foreign currency and account
them in my home currency, where does the unrealized gain/loss go?


I observe an entry in Trial Balance having 'Unrealized Losses' with this
amount.  But where is that account?  How can I view it?

Thanks.


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


When I make an Invoice and receive money in a foreign currency and account
them in my home currency, where does the unrealized gain/loss go?


I observe an entry in Trial Balance having 'Unrealized Losses' with this
amount.  But where is that account?  How can I view it?

Thanks.


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

Re: [GNC] Get online quote for Canada Fund

[David T. via gnucash-user]

Note that adding the price source column to the security list will allow you to 
see at a glance which source all your stocks are using. 

 
 
  On Wed, Aug 14, 2019 at 8:17, David Reiser via 
gnucash-user wrote:   First, make sure that _none_ of 
your stocks are requesting quotes through yahoo. (yahoo_json is OK, though). It 
took me about 3 tries going through my stocks list to track down the straggling 
reference. Any stock whose online quote source is yahoo will cause the entire 
retrieval effort to fail.
--
Dave Reiser
dbrei...@icloud.com





> On Aug 13, 2019, at 9:29 PM, Kaman Wu  wrote:
> 
> Hello,  I still need someone help me.
> 
> I made changes of Cdnfundlibrary.pm.  Now when I run:
> 
> perl .\gnc-fq-dump -v fundlibrary  8282
> 
> I could get:
> 
> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary
> 8282
> Finance::Quote fields Gnucash uses:
>    symbol: 8282                <=== required
>      date: 08/12/2019          <=== recommended
>  currency: CAD                  <=== required
>      last: 14.91                <=\
>      nav:                      <=== one of these
>    price:                      <=/
>  timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock 8282
> 
> stock          field  value
> -          -  -
> 8282        currency: CAD
> 8282            date: 08/12/2019
> 8282          isodate: 2019-08-12
> 8282            last: 14.91
> 8282            link: https://www.fundlibrary.com/MutualFunds/Detail/8282
> 8282          method: fundlibrary
> 8282          source: http://www.fundlibrary.com
> 8282          success: 1
> 8282          symbol: 8282
> 
> 
> So the results looks correct to me.  BUT when I go to Tools->Price
> Database, and clicked "Get Quotes" button, I still CANNOT get the results.
> 
> How should I debug this problem?
> 
> Thanks a lot.
> 
> 
> 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Transaction Report Sign Reverses

[David T. via gnucash-user]

Hello,

I am trying to create a YTD Capital Gains report, and am encountering a 
problem with how the Transaction Report implements the Sign Reverses 
setting.


I recall some time back a discussion about the fact that the Sign 
Reverses setting reverses signs in these reports in a confusing way. 
There was some discussion about reversing the individual transactions 
but not the totals. Although I do not recall the specifics of the 
discussion, I am encountering the same situation now, where the 
transactions themselves respect the user setting, but the totals do not. 
To say this is confusing is an understatement.


It seems to me that other financial applications must have encountered 
the problem of displaying income to users as a positive value (since 
that is how most of us view income!) while still finding a way to 
display the correct accounting information.


To display my YTD report of Capital Gains, I ran a Transaction Report 
and selected the Income:Realized Gains accounts for the current year. 
The result shows losses as positive numbers, and gains as negative. I 
don't know about you, but my expectation is reversed from this. If I 
change the Sign Reverses setting to Income and Expense, then the 
transactions switch, but the totals do not. This result was the gist of 
the discussion in an earlier thread. Bleah!


Now, I know that I can copy the data, paste it into another program and 
change all the settings to my heart's content, but I am looking for a 
way to run a report in GnuCash that directly and unambiguously shows me 
whether I have gained money (a positive) or lost it (a negative) over 
the current year. Does anyone have suggestions?


FWIW, I attempted to turn this report around and have a report that 
lists transactions in the asset accounts, filtered by the 
Income:Realized Gains accounts, but that seems to report only the Asset 
account currency--in this case, the mutual fund or stock shares involved 
on the Gain/Loss transaction. Unfortunately, that's not the actual 
Gain/Loss value...


It would be nice if the sign reverses setting could be fixed. Barring 
that, does anyone have a workaround report setup that can give me a 
sensible YTD Capital Gains total as described?


David T.

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

[GNC] Windows Report Options Dialog Setting

[David T. via gnucash-user]

Hello,

GnuCash 3.5 on Windows 10.

I have discovered a UI problem that I believe to be a bug. It appears 
that if a user maximizes the Options dialog for a report, and then saves 
the options by clicking OK, the maximized window size becomes the 
default options window size from that point forward. This newly-saved 
window has the added unfortunate behavior that the edges of this window 
are not resizable without first moving the window, so it appears to the 
user as if the new arrangement for this dialog is a permanent change.


This is confusing; I was prepared to ask the list how I should get back 
the options dialog as a window, but ultimately figured out the odd steps 
needed to reset the window dimensions.


I would expect that the original window size would remain in effect, and 
that the maximized toggle status would also remain in effect. In other 
words, if I reopen the options dialog, I would either expect to see the 
original dialog window dimensions *or* a maximized dialog window that 
allows me to toggle back to normal size.


Instead, some version of the maximized window size is saved as the new 
dialog size. I say "some size" because the options window that opens up 
on subsequent tries is not the full screen--and the maximize button 
opens the (previously maximized) dialog a little bit more.


As I said, I believe this behavior is a bug.

David T.


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

Re: [GNC] Transaction Report Sign Reverses

[David T. via gnucash-user]

Well, it seems odd to me that "Double" display (as Adrien noted)(thank 
you, Adrien!) is able to display the figures as the user prefers. It is 
also odd to me that the report knows to switch the values of the 
individual transactions, but is unable to remember that fact when it 
comes to the totals. That right there is the problem.


As for the FAQ, it seems to me that there is a mistake in the example 
there: the GnuCash option is to change signs for Income *and* Expenses. 
But the example provided reverses Income but not Expenses. Were it to 
reverse both sets of accounts as the preference indicates, then the math 
should work out correctly ($100+10-20=$90). Or am I missing something here?


Why is it not possible to perform the calculation for totals and then 
apply a display modifier so that the user sees numbers as they prefer?


The current solution is a poor one.

On 8/12/2019 11:12 AM, Christopher Lam wrote:
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_does_the_Transaction_Report_.27Sign_Reversal.27_setting_not_work_on_subtotals 



This issue could be fixed if the scenario addressed in this FAQ can be 
resolved. I don't really know how to handle that particular case.


On Mon., 12 Aug. 2019, 13:02 David T. via gnucash-user, 
mailto:gnucash-user@gnucash.org>> wrote:


Hello,

I am trying to create a YTD Capital Gains report, and am
encountering a
problem with how the Transaction Report implements the Sign Reverses
setting.

I recall some time back a discussion about the fact that the Sign
Reverses setting reverses signs in these reports in a confusing way.
There was some discussion about reversing the individual transactions
but not the totals. Although I do not recall the specifics of the
discussion, I am encountering the same situation now, where the
transactions themselves respect the user setting, but the totals
do not.
To say this is confusing is an understatement.

It seems to me that other financial applications must have
encountered
the problem of displaying income to users as a positive value (since
that is how most of us view income!) while still finding a way to
display the correct accounting information.

To display my YTD report of Capital Gains, I ran a Transaction Report
and selected the Income:Realized Gains accounts for the current year.
The result shows losses as positive numbers, and gains as negative. I
don't know about you, but my expectation is reversed from this. If I
change the Sign Reverses setting to Income and Expense, then the
transactions switch, but the totals do not. This result was the
gist of
the discussion in an earlier thread. Bleah!

Now, I know that I can copy the data, paste it into another
program and
change all the settings to my heart's content, but I am looking for a
way to run a report in GnuCash that directly and unambiguously
shows me
whether I have gained money (a positive) or lost it (a negative) over
the current year. Does anyone have suggestions?

FWIW, I attempted to turn this report around and have a report that
lists transactions in the asset accounts, filtered by the
Income:Realized Gains accounts, but that seems to report only the
Asset
account currency--in this case, the mutual fund or stock shares
involved
on the Gain/Loss transaction. Unfortunately, that's not the actual
Gain/Loss value...

It would be nice if the sign reverses setting could be fixed. Barring
that, does anyone have a workaround report setup that can give me a
sensible YTD Capital Gains total as described?

David T.

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


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

Re: [GNC] Plot Size on Piechart reports

[David T. via gnucash-user]

Geert,

I was beginning to understand this point as well. Not that it makes 
sense in any way. Why would a user choose to define an image along with 
its accompanying text box by pixel? Further: the setting is "Plot width" 
--and not "Width of pie and accompanying text box" or something equally 
dense but accurate. "Plot" to me means "the image portion of this report."


I won't even go into the odd ways that these reports get jammed into a 
multi column report, since I can't begin to understand what the various 
factor are there. Suffice to say the result is not predictable or expected.


Now that I understand the idiosyncrasy, I will let the matter drop. 
Maybe someday someone will investigate an improved method for rendering 
these reports


Thanks,

David T.

On 8/14/2019 6:44 PM, Geert Janssens wrote:

Your screenshot doesn't show this, but did you report also display a legend ?

I believe the legend and chart together are fitted into the dimensions you
set. If the text in the legend varies from report to report, that my explain
why the charts themselves vary as well.

Geert

Op dinsdag 13 augustus 2019 10:47:43 CEST schreef David T. via gnucash-user:

I'm pretty sure that this code isn't making sizing decisions based on
readability-- at least not in my experience.  It is perfectly happy to cram
huge amounts of data into tiny on screen areas... Percentages default to
100%, but remember previously stored values.



   On Tue, Aug 13, 2019 at 13:24, Adrien
Monteleone wrote:   I could see how more
actual slices (regardless of how many accounts were chosen) would maybe
trigger a larger size than a really small one specified for readability.
But still, that should be only a default behavior and should not override a
specified size.

I think yes, the percentage is based on the width of the ???printable??? area of
the report. (and it looks like the default is 100% or else it just
remembers what I used last)

Regards,
Adrien


On Aug 13, 2019, at 2:45 AM, David T.  wrote:

I will try using percentages, although why a percentage (based off what?
Window dimensions?) would be more reliable is beyond my ability to
comprehend.


As for number of slices, they all are set to the same value; it's just
that the number of matching accounts is limited.  Again, why that would
affect overall pie size goes beyond my comprehension.


David

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

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





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

Re: [GNC] Unrealized gain/loss on Forex

[David T. via gnucash-user]

Jayakumar,

I am no expert on this subject. This has been discussed on the lists before, 
however, so I hope that one of the previous participants can explain the 
situation and its solution better than I will. 

David

 
 
  On Fri, Aug 16, 2019 at 11:14, Jayakumar 
Chakravarthy wrote:   David,
Normally I can account the unrealized loss by debiting 'Unrealized Gain/Loss' 
Account and crediting the Customer Account in my local currency.  But since 
here I have kept the Customer's account in foreign currency, the Customer's 
account is already showing nil balance.  Now where would the credit go?​Thanks.
Jayakumar ChakravarthyFounder - Consultant+91-9840 356 506www.Fulcrum-ACE.com


On 14-08-2019 at 14:09, David T.  wrote:
I believe that the "Unrealized Losses" entry on the Trial Balance report is 
calculated. You will need to create an account for it, as well as the 
transaction to account for the loss.  
 
 HTH, 
 David 

 
 
  On Wed, Aug 14, 2019 at 11:40, Jayakumar Chakravarthy 
 wrote:  Hi,


When I make an Invoice and receive money in a foreign currency and account
them in my home currency, where does the unrealized gain/loss go?


I observe an entry in Trial Balance having 'Unrealized Losses' with this
amount.  But where is that account?  How can I view it?

Thanks.


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



  
   David,

   Normally I can account the unrealized loss by debiting 'Unrealized
   Gain/Loss' Account and crediting the Customer Account in my local
   currency.  But since here I have kept the Customer's account in foreign
   currency, the Customer's account is already showing nil balance.  Now
   where would the credit go?

   ​

   Thanks.

   Jayakumar Chakravarthy

   Founder - Consultant

   +91-9840 356 506

   [1]www.Fulcrum-ACE.com

   [cid:0497594B0371F11C]

   On 14-08-2019 at 14:09, David T. <[2]sunfis...@yahoo.com> wrote:

 I believe that the "Unrealized Losses" entry on the Trial Balance
 report is calculated. You will need to create an account for it, as
 well as the transaction to account for the loss.

   HTH,

   David

   On Wed, Aug 14, 2019 at 11:40, Jayakumar Chakravarthy
wrote:

   Hi,
   When I make an Invoice and receive money in a foreign currency and
   account
   them in my home currency, where does the unrealized gain/loss go?
   I observe an entry in Trial Balance having 'Unrealized Losses' with
   this
   amount.  But where is that account?  How can I view it?
   Thanks.
   Jayakumar Chakravarthy
   ___
   gnucash-user mailing list
   [3]gnucash-user@gnucash.org
   To update your subscription preferences or to unsubscribe:
   [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user
   If you are using Nabble or Gmane, please see
   [5]https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
   -
   Please remember to CC this list on all your replies.
   You can do this by using Reply-To-List or Reply-All.

References

   1. http://www.Fulcrum-ACE.com/
   2. mailto:sunfis...@yahoo.com
   3. mailto:gnucash-user@gnucash.org
   4. https://lists.gnucash.org/mailman/listinfo/gnucash-user
   5. https://wiki.gnucash.org/wiki/Mailing_Lists
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Problems moving vertical lines between columns on

[David T. via gnucash-user]

As covered in the note at 
https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-running-gnucash.html#basics-register2
 
 
  On Tue, Aug 13, 2019 at 5:40, David Carlson 
wrote:   James,

Keep in mind that in the register view the description column is a special
case that essentially defaults to use all the space that is not explicitly
given to other columns.

This means setting the other widths first, then dragging the right edge of
the description column title box leftward and letting it snap back until
there is no horizontal scrollbar at the bottom.

Of course, this can get awkward for users that run the program on computers
with different display and font settings.  Since those settings are defined
as user settings, different computers normally each keep their own
settings, but if one accesses the program remotely via ssh, for example, it
can still get very interesting.

David Carlson

On Mon, Aug 12, 2019 at 6:15 PM James Fuller  wrote:

>
> Hi Guys,
>
> I'm having a problem figuring out how to move the vertical lines
> defining columns on registers.  I seem to remember that you place a
> mouse cursor on the vertical line, hold down the right mouse button, and
> move left or right to change the width of of the columns.  When I do
> that, the vertical line moves with my mouse. When I let go of the right
> button the line zips back.
>
> I'm using 3.2 Gnucash on a Windows 7 HP desktop.  What am I doing
> wrong?  BTW, I have read the Help Manual until I'm blue in the face and
> can't find it.
>
> Thank you
>
> James Fuller
>
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Plot Size on Piechart reports

[David T. via gnucash-user]

I'm pretty sure that this code isn't making sizing decisions based on 
readability-- at least not in my experience.  It is perfectly happy to cram 
huge amounts of data into tiny on screen areas... Percentages default to 100%, 
but remember previously stored values. 

 
 
  On Tue, Aug 13, 2019 at 13:24, Adrien 
Monteleone wrote:   I could see how more actual 
slices (regardless of how many accounts were chosen) would maybe trigger a 
larger size than a really small one specified for readability. But still, that 
should be only a default behavior and should not override a specified size.

I think yes, the percentage is based on the width of the ‘printable’ area of 
the report. (and it looks like the default is 100% or else it just remembers 
what I used last)

Regards,
Adrien

> On Aug 13, 2019, at 2:45 AM, David T.  wrote:
> 
> I will try using percentages, although why a percentage (based off what? 
> Window dimensions?) would be more reliable is beyond my ability to 
> comprehend. 
> 
> 
> As for number of slices, they all are set to the same value; it's just that 
> the number of matching accounts is limited.  Again, why that would affect 
> overall pie size goes beyond my comprehension. 
> 
> 
> David
> 


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

Re: [GNC] Thank you

[David T. via gnucash-user]

And, yes, it would be more useful if it weren't set as either an 
absolute date or "Previous Quarter"...


On 9/4/2019 8:08 PM, Christopher Lam wrote:

FWIW in the 4.x series it is planned to allow a book-specific
accounting-period, so, one can select (e.g. 30-June for Australia, 5-April
for UK, or another arbitrary date) an eofy date, and reports should be able
to pick 'current-FY' or 'previous-FY' as report dates...

On Wed, 4 Sep 2019 at 13:56, Doug  wrote:


Adrien,
  one thing that would help in Australia is in the setup to be able to set
the year start as 1 July, & end as 30 June.
Currently the only options are the beginning of the year, monthly,
quarterly, or absolute.
  I usually use absolute, resetting each year.

regards, Doug


On Wed, 4 Sep 2019 23:09:55 +1000
Doug  wrote:


Thanks Adrien. Every year I need to send my data to my accountant who

does not (yet) use Gnucash. I did not have any success exporting to .qif
files: not sure why. (Would not read into Quickbooks)

I thought a spreadsheet might be better way to go.

  This is a new accountant because my last accountant retired (at 85! &

still runs a farm: tough people these rural folk). Previously I supplied
hard copy reports because they were old-school.

The new accountant is quite happy for electronic version, but last year

I had no success with her reading my files.

Basically, I have always prepared a report on each account for the 12

months which detail my tax deductible transactions.

I am no accountant, & even tho I have used Gnucash for years, I still

have issues every tax year but usually bumble through.

regards, Doug


On Tue, 3 Sep 2019 13:14:05 -0500
Adrien Monteleone  wrote:


Regarding the export,

What is the purpose of the export and what data are you trying to get

out? (there might be a way to craft a report in GnuCash that shows the same
info)

What are the steps you are currently taking to do the export?

(copy/paste/save report results or export -> CSV)

Finally, what spreadsheet app are you using to read the exported data?

(Libreoffice Calc, Gnumeric, something else?)

Regards,
Adrien


On Sep 3, 2019 w36d246, at 7:26 AM, Doug 

wrote:

...

I have had little success exporting successfully to a spreadsheet,

but that is probably my lack of skills. One advantage of the full history
of the accounts is when a property is sold: all the old figures are at your
fingertips which is much easier than the other well known commercial
products (which do not easily run on Linux anyway). I am a PCLinuxOS user,
also for many years (Easy to use & recommended too).


I also would like to thank the developers. I have seen the

advancements over the years. The program is now far more polished than the
early versions. I have had hiccups, but never lost any data in 25 years!

regards, Doug (Nth Coast, NSW, Australia, near Byron Bay. Someone

has to put up with this lifestyle: sunny one day & perfect the next!)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


--
Doug 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


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


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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 

Re: [GNC] Thank you

[David T. via gnucash-user]

Of course, one can currently set the accounting period for the OS user 
at Preferences->Accounting Period. ALthough not the same as per-book 
settings, it is nonetheless a useful option for many.


On 9/4/2019 8:08 PM, Christopher Lam wrote:

FWIW in the 4.x series it is planned to allow a book-specific
accounting-period, so, one can select (e.g. 30-June for Australia, 5-April
for UK, or another arbitrary date) an eofy date, and reports should be able
to pick 'current-FY' or 'previous-FY' as report dates...

On Wed, 4 Sep 2019 at 13:56, Doug  wrote:


Adrien,
  one thing that would help in Australia is in the setup to be able to set
the year start as 1 July, & end as 30 June.
Currently the only options are the beginning of the year, monthly,
quarterly, or absolute.
  I usually use absolute, resetting each year.

regards, Doug


On Wed, 4 Sep 2019 23:09:55 +1000
Doug  wrote:


Thanks Adrien. Every year I need to send my data to my accountant who

does not (yet) use Gnucash. I did not have any success exporting to .qif
files: not sure why. (Would not read into Quickbooks)

I thought a spreadsheet might be better way to go.

  This is a new accountant because my last accountant retired (at 85! &

still runs a farm: tough people these rural folk). Previously I supplied
hard copy reports because they were old-school.

The new accountant is quite happy for electronic version, but last year

I had no success with her reading my files.

Basically, I have always prepared a report on each account for the 12

months which detail my tax deductible transactions.

I am no accountant, & even tho I have used Gnucash for years, I still

have issues every tax year but usually bumble through.

regards, Doug


On Tue, 3 Sep 2019 13:14:05 -0500
Adrien Monteleone  wrote:


Regarding the export,

What is the purpose of the export and what data are you trying to get

out? (there might be a way to craft a report in GnuCash that shows the same
info)

What are the steps you are currently taking to do the export?

(copy/paste/save report results or export -> CSV)

Finally, what spreadsheet app are you using to read the exported data?

(Libreoffice Calc, Gnumeric, something else?)

Regards,
Adrien


On Sep 3, 2019 w36d246, at 7:26 AM, Doug 

wrote:

...

I have had little success exporting successfully to a spreadsheet,

but that is probably my lack of skills. One advantage of the full history
of the accounts is when a property is sold: all the old figures are at your
fingertips which is much easier than the other well known commercial
products (which do not easily run on Linux anyway). I am a PCLinuxOS user,
also for many years (Easy to use & recommended too).


I also would like to thank the developers. I have seen the

advancements over the years. The program is now far more polished than the
early versions. I have had hiccups, but never lost any data in 25 years!

regards, Doug (Nth Coast, NSW, Australia, near Byron Bay. Someone

has to put up with this lifestyle: sunny one day & perfect the next!)


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


--
Doug 
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see

https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


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


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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:

Re: [GNC] could not obtain lock on file maybe in use some wh

[David T. via gnucash-user]

Adrien,

Under most circumstances in this situation, I'd agree with you that the problem 
was an unsuccessful exit. However, Bob clearly notes that not only does he have 
troubles with the load, but also with saving and backup creation. That sounds 
very much like some sort of permissions problem. 

Bob, verify that you have full permissions for the folder in question. Also: is 
this folder a cloud folder, like dropbox? Sometimes remote folders cause 
problems. I'm sorry to be vague; I only recall that others have reported 
troubles on Windows with cloud-stored files. A search of the list archives 
might point to some further areas to investigate. 

David

 
 
  On Tue, Sep 10, 2019 at 6:38, Adrien 
Monteleone wrote:   Delete the .lck files in 
the directory you are storing your books.

(presuming you know for a *fact*, that the data files aren’t already open in 
GnuCash but you just don’t see the window)

You should then be able to then open any data file.

You could also choose ‘Open-Anyway’ with the same result.

There might be several causes, but other than the most obvious (that the file 
really is already opened) is that the app crashed last time you were accessing 
that file and the .lck file was not removed due to the ‘ungraceful’ shutdown of 
GnuCash.

I don’t think a permissions issue would cause this, but I could be mistaken. 
Make sure you have full permissions on the folder you are storing the files.

Regards,
Adrien

> On Sep 9, 2019 w37d252, at 7:45 PM, Bob Hammons  wrote:
> 
> I have a windows 10 laptop.  Today I got this message when I opened my file.
> I have 3 different files on this computer and they all say the same thing.  
> It will not allow any  backups so anything I did today is gone.
> I tried older files and the same thing happened.
> I tried my backups that were on a thumb drive.  They seemed to work from 
> thumb drive.  I then copied them to a new directory on the computer and I got 
> same message and no backups.
> I updated to 3.7 with the same results.
> My windows has been updating a couple time a week.  Could this be a windows 
> problem?
> 
> Thanks for any help!

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

Re: [GNC] QIF Import Problem

[David T. via gnucash-user]

... And I have none of these problems with 13 years of history. No lags, 
loading, while slow, has neither decreased nor increased over the years 
with a growing file size. YMMV, but I've used both Mac versions, and now 
the Windows version (currently 3.5).


I've said it before, but it bears repeating. When I imported many years 
ago, I exported everything from Quicken into GnuCash in one grand pass. 
GnuCash set up the accounts based on the transactions and picked up the 
matching sides of transfers such as the OP mentioned.


David T.

On 8/5/2019 2:38 AM, David Carlson wrote:

I would suggest that it would probably create a very ponderous data file to
cover 15 years' data.  I have 10 years' history in my current file and I
regret putting so much into one file, as it generates lags of several
seconds for some very common operations, and minutes to open or close..

I would suggest at most one or two years of history for your GnuCash file.
Then the one-account-at-a-time procedure is not so overwhelming.

I think, but I am not sure, that Quicken will continue to work off-line if
you want to review older history in the future.

David Carlson

On Sun, Aug 4, 2019 at 2:53 PM Colin McLellan 
wrote:


Hi,

I'm trying to switch to GnuCash from Quicken 2016 and I'm running into a
problem where all transfers between accounts are duplicated after the QUF
import.  I am aware that this is not a new problem and I have read meany
threads on here going back at least ten years about this.

I tried exporting just one month of my chequing and savings accounts to
separate QIF files and then importing them into GnuCash simultaneously and
separately.  In each case, 100% of the time all transfers between the
accounts are duplicated in each account.  Whatever is supposed to be
flagging these duplicates is not working.  If I do them separately, I do
get the option to select the duplicates, but ultimately I want to import
the past 15 years of transaction level detail, and I am not willing to go
the manual route.

My question is: Is there any new information about a solution to this
problem?

Thanks,

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




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

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

[David T. via gnucash-user]

Building on Christopher's comment, my experience was that if a transaction to 
be imported has the flag set, Gnucash imports that value. I'm not sure the 
exact mechanics or heuristics (and it was a long time ago that I migrated to 
Gnucash), but I know I didn't have to reconcile my imported transactions all 
over again. 

This is another reason (probably a significant one) not to tinker with the 
reconcile values, BTW. Someone would have to rewrite every incoming transaction 
to use 'R' instead of the 'Y' from other apps.

David
 
 
  On Wed, Aug 7, 2019 at 13:38, Christopher Lam 
wrote:   Hi Geert
Wish to add a small contribution:

On Wed., 7 Aug. 2019, 15:43 Geert Janssens, 
wrote:

>
> For the other importers, this isn't implemented. The idea is that you
> typically import from bank statements in qif/ofx/csv format and banks
> don't
> have reconcilation information. The other acounting application I use can
> also
> import bank statements, but won't reconcile them either.
>

The qif importer does have ability to set a split's reconciliation status.
The qif C line may specify * cleared X reconciled ! budgeted (unused by
importer) transactions, but I guess only quicken exports should have 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Migration

[David T. via gnucash-user]

I won't comment on whether the migration process has become simpler over the 
years, as I haven't done it in about as long. 

There has been a huge amount of discussion over the years on the question of 
migration from Quicken (usually tied either to the beginning of a new calendar 
year, or the imposition of a new fee structure by Intuit).

A search of the mailing list archives will turn these up. 

Additionally, the wiki includes a summary of many of the points that have been 
raised on the topic.  wiki.gnucash.org/wiki/FAQ#Importing.2FExporting_Data

I can't comment on the ease of migration from the other application, but I can 
say that the strict enforcement of double entry accounting in gnucash causes 
most Quicken refugees some discomfort. People with complicated stock holdings 
also encounter special challenges typically. 

David
 
 
  On Thu, Aug 1, 2019 at 6:54, Jean-David Beyer via 
gnucash-user wrote:   On 7/31/19 5:01 PM, Clint 
Chaplin wrote:
> Hi all,
> 
> I am looking for, well, some assurance here.
> 
> How many of you migrated to GnuCash from another financial product?  If you
> did, what did you migrate from?  How much data did you have to migrate?
> And would you do it again knowing what you know now?
> 

I ran Quicken for a few years, but I could not stand Windows 95 (current
at the time), so I switched to Red Hat Linux 5 in about mid 1998. A
little later, I started using GnuCash. It could presumably convert from
Quicken, but it made such a mess of mine that I just dropped all the old
data and started afresh.

I suppose in the decade or more since than, Gnucash has improved the
behavior of the conversions.


-- 
  .~.  Jean-David Beyer
  /V\  PGP-Key:166D840A 0C610C8B
 /( )\ Shrewsbury, New Jersey
 ^^-^^ 21:15:01 up 6 days, 6:07, 2 users, load average: 5.41, 5.02, 4.87
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash-user Digest, Vol 196, Issue 61

[David T. via gnucash-user]

Migrating investment transactions is particularly challenging because of the 
issue of capital gains and cost basis. I gave up trying, and instead rely on 
the broker-derived assessment of gain because of it. With individual stocks, 
GnuCash's lot features work pretty well, though. 

 
  On Fri, Aug 2, 2019 at 3:26, Clint Chaplin wrote:   In 
this case, DRIPs are not your friend

On Thu, Aug 1, 2019 at 2:53 PM David Cousens 
wrote:

> Clint,
>
> You canhandle existing investments in the same manner you handle an
> existing
> bank account which has a balance when you start. You will have a credit
> entry to Equity:Opening Balances to match the debit entry to the account in
> which you are maintaining the record of your investment (which would
> normally be created somewhere under Assets:Non Current Assets:...).
>
> This would assume you are going to be able to access your existing records
> to get the historical information.
>
> You can add historical information retrospectively, shifting the dates
> back
> and adjusting the amounts of the opening entries as you add data going
> further back.
>
> David Cousens
>
>
>
> -
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Proposed change of "U+R" and "R" in the Import main matcher.

[David T. via gnucash-user]

Indeed. I ask myself, "which character do I see after invoking this 
option?" It isn't "R"--it is "C."


Furthermore, the imported transaction isn't "Reconciled," it is 
"Cleared." You still have to reconcile it.


As for changing the Reconcile value to "R," well, that goes a little 
further down the path, and leads me logically to the thought that the 
field should then be renamed "Status." At this point, it feels like 
we're beginning to stray from the broader (as in beyond GnuCash) 
community terminological consensus. And we're making a lot of work for 
programmers and documentationers.


David

On 8/6/2019 4:29 PM, Fross, Michael wrote:

I agree as well. This was confusing to me when I started.

  I also think instead of putting a ???Y??? in the reconciled column in the
register, I would put a ???R???.

Michael

On Mon, Aug 5, 2019 at 9:46 PM Robin Chattopadhyay 
wrote:


+1

On Mon, Aug 5, 2019 at 7:53 PM David Cousens 
wrote:


I have raised bugs in the
code(https://bugs.gnucash.org/show_bug.cgi?id=797338) and documentation
(https://bugs.gnucash.org/show_bug.cgi?id=797337) proposing changing the
"U+R" and "R" tags in the import main matcher to "U+C" and "C" where the
curent use of R refers to the term reconciliation. The use of the term
reconciliation in this context may cause some confusion with the
reconciliation process of checking transactions for a period against an
external statement, particularly for new users. The import matcher does
not
assign a "reconciled" status to an imported transaction but does set it

as

"c" cleared. You would not normally be importing transactions in which

the

splits to the account being imported to are already reconciled, i.e.
marked
"y" in a register however this might occur if you are importing records
separately to a credit and a bank account where there are transfers
between
them (credit card payments). In this case the importer would flag the
record
not to be imported where there is an exact match to an existing
transaction.
AFAIK there is no checking of the reconciliation status of the existing
transaction in GnuCash in the matching process but I may not yet have dug
deeply enough.

In a discussion with John Ralls and Frank Ellenberger over other changes
to
the import matcher documentation, I initially proposed "U+M" and "M".

John

felt "U+C" and "C were more indicative and clearer.

I am raising this here to canvas a wider audience before making the
changes.
Please comment here preferrably (or in the bug comments)  if you have any
objections/support  to the proposed change .

As John has suggested this is copied from GnuCash Dev to GnuCash users to
further widen the input.

David Cousens



-
David Cousens
--
Sent from:

http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

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


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


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

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

Re: [GNC] Use of "dash" as a Separator Character

[David T. via gnucash-user]

I figure they are bound to crop up, so leave them where I can watch 
them. I keep them empty. A quick check shows me areas needing work!


David

On 7/24/2019 8:19 PM, Derek Atkins wrote:

D  writes:


Derek,

I don't know about renaming, but you certainly can move them! I've had
my Imbalance accounts placed in a different top level account (Special
Accounts) for years.

That is good to know.
I try not to have the accounts exist in my books ;)


David T.

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

-derek


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

Re: [GNC] Find dialog not working

[David T. via gnucash-user]

Comment three on three bug report includes instructions on fixing the problem 
by editing a line in the report file. 

 
 
  On Thu, Nov 7, 2019 at 15:08, mcmurchy1917techy via 
gnucash-user wrote:   Thanks John

I'll keep an eye on the bug report and test when a fix becomes available.

Alex


On 07/11/2019 04:23, John Ralls wrote:
> That's https://bugs.gnucash.org/show_bug.cgi?id=797460
>
> Regards,
> John Ralls
>
>
>> On Nov 6, 2019, at 7:05 AM, mcmurchy1917techy via gnucash-user 
>>  wrote:
>>
>> If it helps
>>
>>> git bisect log
>>> git bisect start
>>> # good: [d42695e75a5b8865331694c9490c7446af7ebcc3] Release GnuCash 3.6
>>> git bisect good d42695e75a5b8865331694c9490c7446af7ebcc3
>>> # bad: [84cfc5743bc31160e338e6cb7c734548d9ef92a4] Release GnuCash 3.7
>>> git bisect bad 84cfc5743bc31160e338e6cb7c734548d9ef92a4
>>> # good: [112cf99d2d0c7a68c71d9085ad911eba93337d9a] [test-report-html] add 
>>> coverage and function test
>>> git bisect good 112cf99d2d0c7a68c71d9085ad911eba93337d9a
>>> # good: [112cf99d2d0c7a68c71d9085ad911eba93337d9a] [test-report-html] add 
>>> coverage and function test
>>> git bisect good 112cf99d2d0c7a68c71d9085ad911eba93337d9a
>>> # good: [6b0bfa075ca5c964e4b2df775b228271b2ecf378] [register] fix Transfer 
>>> acc for single-account splits
>>> git bisect good 6b0bfa075ca5c964e4b2df775b228271b2ecf378
>>> # good: [6b0bfa075ca5c964e4b2df775b228271b2ecf378] [register] fix Transfer 
>>> acc for single-account splits
>>> git bisect good 6b0bfa075ca5c964e4b2df775b228271b2ecf378
>>> # bad: [16a69e2a63f462346f498918eee738e5443bea58] I18n fix: Trim 
>>> user-visible strings from unneeded whitespace.
>>> git bisect bad 16a69e2a63f462346f498918eee738e5443bea58
>>> # good: [f00777ca07f5ca6f7e2bc5443823e02c8fa8c7c2] Add scm-srfi64-extras 
>>> and scm-qif-import as check dependencies
>>> git bisect good f00777ca07f5ca6f7e2bc5443823e02c8fa8c7c2
>>> # good: [bb4348fce97668af5de08e0a38867437d7e7f81f] Bug 797378 - QIF file 
>>> import fails: Loading gives wrong type argument in position 2
>>> git bisect good bb4348fce97668af5de08e0a38867437d7e7f81f
>>> # bad: [ef3157db19e5ebee4c669da03757ed5ec8fe8321] [budget] rename envelope 
>>> option to 'Use accumulated amounts'
>>> git bisect bad ef3157db19e5ebee4c669da03757ed5ec8fe8321
>>> # bad: [fa6948a2bee6ba8e59ba487097590ff2ce782588] [dialog-search] 
>>> expand search results
>>> git bisect bad fa6948a2bee6ba8e59ba487097590ff2ce782588
>>> # bad: [e3ba73683e3c6ccfa84a63c6d0a5e648856412dc] Fix file copy destination 
>>> for accounts/he
>>> git bisect bad e3ba73683e3c6ccfa84a63c6d0a5e648856412dc
>>> # first bad commit: [e3ba73683e3c6ccfa84a63c6d0a5e648856412dc] Fix file 
>>> copy destination for accounts/he
>>
>>
>> On 06/11/2019 14:50, mcmurchy1917techy via gnucash-user wrote:
>>> I've got a problem with the Edit -> Find dialog in 3.7.
>>>
>>> I can't see the drop down menus for the search criteria namely Description, 
>>> Contains or the search text box. It looks like the they'll all been 
>>> squashed vertically within their group box.
>>>
>>> I'm using Slackware 14.2 with KDE4.
>>>
>>> I've backed out 3.7 and reinstalled 3.6 and the Find dialog works as 
>>> expected.
>>>
>>> Alex
>>>
>>>
>>>
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by 

[GNC] Problem with Saved Report

[David T. via gnucash-user]

Hello,

I am using GnuCash 3.5 on Windows 10. GnuCash 3.5 is the latest version 
I have ever used.


I have a report that I customized and saved in an earlier version of 
GnuCash (I can't tell you the version, but I know that it is an earlier 
version). I can't be certain which base report I used, since the saved 
configuration in saved-reports-2.8 only gives me the GUID of that base 
report, although I imagine it is a basic Transaction Report (since I 
have had trouble with version compatibility on this report previously). 
ISTR that I brought a similar problem with the Transaction Report to the 
list some time back, but cannot remember what the fix was supposed to be.


Instead of getting a report, I get a message that under the 
circumstances is gibberish:


"This report was saved using a later version of GnuCash. One of the 
newer multichoice options '7' is not available, fallback to the option '2'."


First, it is unclear to me how I could have saved my report using a 
version that I have never used or loaded. Second, this message is 
remarkably cryptic and misleading; I don't understand how I am using a 
newer option for a report that is invoked in the highest version I have. 
Third, despite informing me it is using a fallback option '2', the 
report fails to load, leaving me with no way to remedy the problem.


I am feeling rather frustrated here; GnuCash shouldn't break a saved report!

David T.

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

Re: [GNC] Will the reports file "saved-reports-2.8" recreate

[David T. via gnucash-user]

David, 

It's one file: saved-reports-2.8.

You can easily parse the text that is contained in this file and isolate 
individual report customizations.  Cutting and pasting the complete content of 
one of these segments, you can port them around (although the changes in data 
files will render this approach largely pointless).
David T. 

 
 
  On Tue, Nov 12, 2019 at 9:36, David Carlson 
wrote:   Related to Fran3's question 2, are all the reports in one large file 
or can
a user pick and choose which reports [s]he wants to restore from his or her
archive?

David Carlson

On Mon, Nov 11, 2019 at 10:00 PM John Ralls  wrote:

>
>
> > On Nov 11, 2019, at 1:11 PM, Fran_3 via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> >
> > I have about 40 reports I created for this project and I  would like to
> keep them for future reference.
> > BUT that many reports clutter up the view when retrieving saved report
> configurations...
> > I may not reference these particular reports for a year so I would like
> to  stash them... that is stash  their definitions/configuration file
> "saved-report-2.8" in another folder until I need those particular reports
> again.
> >
> >
> > Question 1: If I move the reports config file saved-report-2.8 to a
> backup folder for future use and then delete it from its normal folder at
> > C:\Users\User-X\AppData\Roaming\GnuCash
> > Will gnuCash recreate a new "saved-report-2.8" file when I re-launch the
> gnuCash App?
> >
> > Question 2: If months down the road I need to recover the
> saved-report-2.8 file that I stashed elsewhere...
> > Can I swap the current saved-report-2.8 file with the one I stashed...
> and visa-versa as needed?
> >
> > Question 3: I made a simple Transaction Report named Test that only
> looked at the checking account. Then I made a copy of saved-report-2.8 and
> looked at it with NotePad++.
> >
> > The text in the file, I assume, consist of instructions used by gnuCash
> to create the report...
> >
> > meaning the contents of saved-report-2.8 is not a language to query the
> gnuCash data... right?
> > Thanks for any help. Fran3
> >
>
> 1. No, unless you create new saved report configs.
> 2. Yes. Just make sure to shut down GnuCash while you're switching the
> files.
> 3. The current version of the file contains the report names and a Scheme
> (that's a computer programming language) representation of the options you
> changed from the default values to create the custom report. You are
> correct that it does not contain queries. Most GnuCash reports work by
> iterating over the accounting objects in memory rather than using the query
> framework.
>
> Regards,
> John Ralls
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


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

Re: [GNC] Problem with Saved Report

[David T. via gnucash-user]

Hmm.

Apparently, I didn't click the dialog box enough. After 10 iterations of 
the same error, the report does load. FWIW, it's a custom report that is 
based on the Assets Pie Chart.


Moreover, it would appear that the setting that causes trouble is the 
"Account Depth" setting. When this is set to "6", I get this error; when 
it is set to "5" or lower, this error goes away. Since "6" is the 
seventh entry in the list (following "All" and the first 5 levels), this 
would also explain the "Fallback" to option '2'.


I'm not sure why anyone would alter the Account Depth setting lower, 
thus limiting the user's ability to manage this report. If anything, I'd 
argue this setting should be allowed to go even higher.


David T.

On 11/6/2019 10:14 PM, David T. via gnucash-user wrote:

Hello,

I am using GnuCash 3.5 on Windows 10. GnuCash 3.5 is the latest 
version I have ever used.


I have a report that I customized and saved in an earlier version of 
GnuCash (I can't tell you the version, but I know that it is an 
earlier version). I can't be certain which base report I used, since 
the saved configuration in saved-reports-2.8 only gives me the GUID of 
that base report, although I imagine it is a basic Transaction Report 
(since I have had trouble with version compatibility on this report 
previously). ISTR that I brought a similar problem with the 
Transaction Report to the list some time back, but cannot remember 
what the fix was supposed to be.


Instead of getting a report, I get a message that under the 
circumstances is gibberish:


"This report was saved using a later version of GnuCash. One of the 
newer multichoice options '7' is not available, fallback to the option 
'2'."


First, it is unclear to me how I could have saved my report using a 
version that I have never used or loaded. Second, this message is 
remarkably cryptic and misleading; I don't understand how I am using a 
newer option for a report that is invoked in the highest version I 
have. Third, despite informing me it is using a fallback option '2', 
the report fails to load, leaving me with no way to remedy the problem.


I am feeling rather frustrated here; GnuCash shouldn't break a saved 
report!


David T.

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

Re: [GNC] Budget Questions and Observations

[David T. via gnucash-user]

Chris's,
Bug 780717?
 
 
  On Thu, Dec 12, 2019 at 13:40, Christopher Lam 
wrote:   First, what is your global Reverse Balanced preference (Edit / 
Preference /
Accounts / Reversed Balance)?

On Thu, 12 Dec 2019 at 07:07, Tommy Trussell 
wrote:

> Does anyone use the Budget features in GnuCash? I have been giving it a try
> and am finding some aspects quite puzzling. I have never been trained in
> budgets so maybe I need to read up on some particular methodology to make
> better sense of it. Maybe someone can weigh in with some background.
>
> A few weeks ago I asked about the lack of account codes in budgets and
> budget reports and got no response. I wasn't surprised as I am sure very
> few folks use account codes in GnuCash. I did open bug #797489.
> https://bugs.gnucash.org/show_bug.cgi?id=797489
>
> My greatest astonishment with Budgets has been that all the INCOME numbers
> on the budget show as NEGATIVE. Is this by design? I have concluded this
> must be a bug, but maybe I'm doing something wrong, so I thought I would
> ask here before reporting it.
>
> As a result of the negative income figures, to project budgeted income I
> have to enter income figures into the budget as negatives. Regardless the
> budgeted and actuals (by default) "normally" get displayed RED. (!) Then
> when I'm looking at the numbers, I have to tell myself that when looking at
> incomes, negative (red) incomes and differences are "good" and positive
> (black) income difference numbers are "bad." Is that right? I'm never
> certain. But I'm easily confused. Well, needless to say budgeted income
> numbers are darned hard to read.
>
> I keep wanting a way to pair up particular income and expense accounts in a
> budget so they offset each other. I realize this may be beyond the scope of
> the budget feature, but that one thing would it a lot easier to track
> encumbered or designated funds. (The budget I'm working with is for a
> church.) While I'm wishing, maybe budget and actual income and expense
> amounts could be grouped and added or subtracted usefully using some
> additional factor, such as account codes or search strings.
>
> When entering budget amounts it would sometimes be useful to be able to
> enter one annual amount OR separate monthly budget amounts. But even with
> the existing design, when entering budget figures over multiple months it
> would be great if GnuCash could handle the math rather than having to
> divide by 12 on a calculator. At the very least it could parse math
> expressions like it does in the registers. I opened bug #727488 for this
> one.
> https://bugs.gnucash.org/show_bug.cgi?id=797488
>
> GnuCash contains several specialized Budget reports... but I suspect most
> haven't been fully implemented or tested. (I haven't opened any bugs for
> the following.)
>
> The "Budget Report" works pretty well, but if you turn on all the columns
> and try to print it, you lose everything off the right side. (In other
> words, the report paginates properly vertically, but not horizontally.)
>
> Fortunately the Budget Report exports quite easily, so I can turn on as
> many columns I want and export the report and import it into a spreadsheet.
> With reformatting (like changing fonts and freezing column and row
> headings), a spreadsheet is a great way to view the budget numbers.
> Unfortunately copying and pasting into a spreadsheet from this report
> doesn't work reliably. You have to use the export feature.
>
> The Budget Chart report works, after a fashion. But its two chart options
> are limited and inflexible. I suspect exporting the Budget Report to a
> spreadsheet would be a better basis for generating charts.
>
> I am not certain I understand the purpose of the "Budget Income Statement"
> or "Budget Profit & Loss" They seem to show only budgeted amounts, not
> actuals. Are they intended to "test" a proposed budget for sanity? My
> negative budget amounts to workaround the negative income numbers (noted
> above) are not compatible with these reports because they work just the
> same as GnuCash's regular reports elsewhere.
>
> The "Budget Balance Sheet" and "Budget Flow" reports ... I do not
> understand how these reports could ever be used. What is the effective date
> of the Balance Sheet? It's not labeled, nor is it adjustable (unless I
> missed something). The flow report has no label to show the selected budget
> period, and no labels over the columns, so even if it contains some useful
> data, it's inscrutable. Furthermore, the flow report provides only a very
> limited period display option -- just one period at a time, no multiple
> period options.
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> 

Re: [GNC] MacOS Catalina Gnucash 3.7 won't start

[David T. via gnucash-user]

Chris,
Any chance you have or had a second monitor on your system?
 
 
  On Mon, Oct 28, 2019 at 8:42, John Ralls wrote:   Chris,

Weird. With GnuCash (sort of) running, open /Applications/Utilities/Activity 
Monitor. Find gnucash in the process list and select it. Click the gear icon at 
the left end of the toolbar and pick "spindump" from the menu. It will collect 
for a few seconds and then present a window with a bunch of stack traces that 
may show what GnuCash is waiting for.

Regards,
John Ralls


> On Oct 27, 2019, at 4:53 PM, Chris Martin  wrote:
> 
> Thanks Chris and John,
>    I can confirm that in System Preferences->Security &
> Privacy->Privacy->Files and Folders Gnucash is shown as "Full Disk Access"
> as a result of me adding it to the Full Disk Access list earlier in my
> debugging.  Out of curiosity, I removed it from the Full Disk Access list
> and it made no difference.
>    After returning it to "Full Disk Access," I then added the "--nofile"
> option to ./Gnucash (and then again in addition to --debug and --extra) and
> Gnucash still just hangs with no stdout or stderr output and *without*
> generating a trace file.  Running a ps seems to show that the process is
> just sleeping.
> 
> 25294 s000  S+    0:00.00 ./Gnucash --nofile
> 
>  I tried a kill -9 in addition to a kill -2 to get it to write a trace
> file, but no joy.
> 
> 
> -Chris
> 
> On Sun, Oct 27, 2019 at 12:37 PM chris graves  wrote:
> 
>> Chris,
>> 
>> Under System Preferences->Security & Privacy->Privacy->Files and Folders,
>> does Gnucash.app have access to the Documents Folder (or the folder where
>> your Gnucash data file lives?
>> 
>> Also, try again running from the terminal and add the --nofile option
>> 
>> Chris
>> 
>> On Oct 27, 2019, at 12:17 PM, Chris Martin  wrote:
>> 
>> ./Gnucash --debug --extra
>> 
>> 
>> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see 
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

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

Re: [GNC] Font problem

[David T. via gnucash-user]

Adrien,

With regard to your assertion in #3, Paul's problem sounds entirely different 
from the page rendering problem that you reference (most recently at 
https://lists.gnucash.org/pipermail/gnucash-user/2019-October/087363.html). To 
me, "bullet holes" suggests some sort of corrupted font definition. Your 
suggestion to try different fonts should clear that ambiguity up. 

David

 
 
  On Wed, Oct 16, 2019 at 0:11, Adrien 
Monteleone wrote:   #1 - you didn’t need to 
install GTK3 from MacPorts to utilize a custom CSS file. You only need this if 
you want to run the GTKInspector on MacOS to find out the hooks to tweak 
various UI parts via that custom CSS file. But even then, you’ll only need to 
do that for those elements not documented already on the wiki. (though most of 
those not documented aren’t alterable by CSS anyway)

#2 - you can attach an image file to a message, but make sure to put it at the 
end, not in-line. Mailman strips out in-line images. A foolproof method would 
be to use a free image hosting service (like imgur.com) to upload your image 
and then put the link to it in your reply.

#3 - this might be a known issue with webkit on MacOS, but a sample result 
image might help to narrow it down. I’ve seen threads discussing this problem 
on the bottom line of a page, but not within the page.

Finally, try different fonts, including the default, and see what the printed 
result looks like.

Regards,
Adrien

> On Oct 15, 2019 w42d288, at 12:57 PM, Paul de Vries  
> wrote:
> 
> on Mac OSX 10.11 El Capitan and 10.13 High Sierra, after switching from 
> 2.6.19 to 3.5 a long time ago, I have a font problem. 
> 
> I installed GTK3 from MacPorts, then
> cat ~/Library/Application\ Support/Gnucash/config/gtk-3.0/gtk.css
> * {
>  font: 12pt DejaVuSans, sans-serif;
> }
> 
> Select an invoice, hit the 'print invoice' button.
> 
> It is difficult to describe in text, I would like to show a picture, but I 
> suppose I cannot attach it to this mail.
> 
> It is about missing parts of letters, lowercase only, for example the down 
> lines (stem?) of 'n' and 'm' or up lines of 'u' have different sizes. It 
> looks like bullet holes in some letters.

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

Re: [GNC] Just updated to MacOSX Catalina and GnuCash will not open.

[David T. via gnucash-user]

I'm curious what you did that didn't work, as well as what you mean by "removed 
all references to earlier iterations." Would you elaborate?
David

 
 
  On Thu, Oct 24, 2019 at 14:11, GJS wrote:   On 22/10/2019 
02:20, D wrote:
> /Installation is covered in the wiki, and linked directly on 
> //www.gnucash.org//on the navigation menu (4th item under 
> "Information")--"Installation"./
Hi,
I did find that and followed the instructions repeatedly - didn't work. 
I'd just about given up but decided to follow all your prompting. 
However, this time I removed all reference to earlier iterations. It 
works! Now I have a major job resurrecting past records.
My thanks to David, John and Derek for your helpful responses.
Gra
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
  
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

[GNC] Dot Directories in Win10

[David T. via gnucash-user]

Hello,

I am using Gnucash 3.5 on Windows 10 (installed on a new Windows machine 
June 2019), and I notice a couple of dot directories placed in my user 
folder (C:\Users\sunfish): .cache and .dbus-keyrings


The cache folder has a fontconfig folder with a couple of subfolders in 
it; the dbus folder has one text file in it org_gtk_gdbus_general


My Windows machine is quite new--meaning that I haven't installed much 
on it beyond some image apps--and I suspect that GnuCash or one of its 
dependencies has created these two folders. My first question is: is 
this assumption correct? Next, what are these folders? Next, are they 
necessary, or can I delete them? Finally, I was under the?? impression 
that work has been done to sequester these entries in a Windows way 
(either in a registry entry, or under AppData or some other Windows 
nook); is this a glitch on my machine, or is it an area that needs 
further refinement?


TIA,

David


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

Re: [GNC] How can I add statement balances to my accounts as

[David T. via gnucash-user]

This is interesting. Let's say that at a later point, a transaction were added 
prior to one of these entries. How will this transaction help in a way that 
looking at the statements wouldn't?
You see, one of the basic truisms of reconciliation is that your balance as of 
a given date will differ from the bank's.  That's because you have entered 
transactions that the bank won't know about. So, the account's balance on the 
date of reconciliation *when correct* will not match the bank's.  If at some 
later point, these change relative to one another, how are you going to know?

 
 
  On Sun, Oct 13, 2019 at 13:47, AEG via gnucash-user 
wrote:   The way I deal with this is not entirely automatic as it involves 
setting up
a scheduled transaction for every account that has a regular statement, but
it does allow me to check back for errors later.

For each of my bank or credit card accounts, the statements are normally
compiled on the same date every month so I set up a single line scheduled
transaction to trigger on that date in which the debit and credit cells are
left blank. In the Description box I enter the name of the bank and in the
Notes box I enter the words "Statement:£" so that it is ready for me to
enter the statement total when it arrives. From this, I can check its
accuracy at the time of reconciliation and deal with any discrepancies I
find.

In the future, if I notice a problem, I can look back through transactions
until I find the last time statements and balances matched, thereby
narrowing the dates to check for errors.

Alan



armanschwarz wrote
> Suppose on July 1, 2019 I get a statement that my account balance is $100.
> Since I know this is true and won't change in the future, I should be able
> to tell GnuCash that this is the expected balance, and for some kind of
> warning to appear if that condition is ever violated for the corresponding
> account in GnuCash (kind of like a unit test).
> 
> Looking at the documentation for Reconciliation, it seems like this that
> feature more targeted at individual transactions rather than setting known
> values for balances at given points in time. If I reconcile an account for
> 12 months every month, and then stop reconciling it the year after, what's
> stopping all of those historic balances from getting thrown out of whack?
> Does GnuCash remember what the balances should be and prevent this?
> 
> Also, if I accidentally enter a wrong date every 5% of the time, and I
> accidentally reconcile them incorrectly 5% of the time, then for a large
> number of transactions I'm virtually guaranteed to have my history broken,
> whereas remembering statement balances would avoid this problem.





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

Re: [GNC] Chaning left sidebar spacing

[David T. via gnucash-user]

Adrien,

I included the link to the discussion in my previous reply. The wiki does not 
include the tab padding commands. 

David T. 

 
 
  On Thu, Jan 2, 2020 at 6:20, Adrien 
Monteleone wrote:   Bill,

There was a long thread last fall (2018) about css. I think the title makes it 
appear to be dealing with fonts, but it also covered lots of the UI, and in 
particular we covered the padding in tabs. Unfortunately, I don’t recall off 
hand the exact declarations to use. (are they not in the wiki gtk page?)

If you find that list thread but are still stumped, report back here and I’ll 
see what I can dig up. (and then put it in the wiki if it in fact isn’t there)

Regards,
Adrien

p.s. - Colin, the browser shouldn’t make a difference as it is a separate app 
entirely and GnuCash doesn’t use it for the UI. Really, the OS shouldn’t 
either. The padding is spec’d specifically, but font size might make a 
difference if the padding is set in ems.


> On Jan 1, 2020 w1d1, at 4:31 PM, Colin Law  wrote:
> 
> I see what you mean.  On Ubuntu with Waterfox browser they are much tighter
> packed (gnucash 3.6).
> 
> Colin
> 
> On Wed, 1 Jan 2020 at 17:00, William Marshall  wrote:
> 
>> Colin,
>> 
>> I can’t do a conventional capture, since I need things highlighted by
>> selection and mouse activity to show what I mean, but here’s a photo from
>> me phone of what I'm talking about.  Notice first that “USAA Sav” is
>> selected and see how high the top and bottom boundary are for that
>> selection.  Then notice that my mouse is hovering over “USAA Visa” and see
>> that it has the same excessive (to my eye) top and bottom boundaries.
>> ALSO, notice that there is a separator between the two.  I’d really like to
>> scrunch everything together like it used to be.
>> 
>> I really appreciate any help you can provide.
>> 
>> Bill
>> 
>> 
>> 
>> On Jan 1, 2020, at 10:00 AM, Colin Law  wrote:
>> 
>> Can you post a screenshot showing exactly what you mean?
>> 
>> Colin
>> 
>> On Wed, 1 Jan 2020 at 00:55, William Marshall via gnucash-user
>>  wrote:
>> 
>> 
>> Hi All,
>> 
>> I don’t know if this is the right pace to ask this or not, and I’m sure
>> it’s already been asked many times, but Googling for solutions hasn’t
>> provided me any relief.  How do I reduce the spacing on the left sidebar
>> that lists the accounts and reports that I’ve opened?  Right now, they way
>> spread out vertically, which happened when I switched to GnuCash 3.X.  I’m
>> currently using GnuCash for Mac version 3.7, Build ID: 3.7+(2019-09-07).
>> 
>> Thank you,
>> Bill Marshall
>> 
>> 
>> 
> 


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

Re: [GNC] Gnucash logs

[David T. via gnucash-user]

Thanks. Don't know why I couldn't see that before. I guess the 
terminology didn't register in my  mind.


On 4/29/2020 11:59 AM, David H wrote:

David T.,

Preferences >> General >> Path Head for Transaction Association Files 
is probably the setting you're looking for :-)


Cheers David H.


On Wed, 29 Apr 2020 at 16:12, David T. > wrote:


If the setting were per book and user-configurable, then a user could
choose to set each data file to use a different set of folders, by
changing the file default from "logs" to "logs-file1"

Does the Attachments functionality provide a blueprint for how this
could work for backups and logs? It seems to me that there is a
setting
somewhere that allows the user to point to a particular folder for
external file association (although my attempts at locating that
setting
have failed).

But your point about the logs and backups having different
filenames is
apt as well.

David T.

On 4/29/2020 8:55 AM, Chris Good wrote:

> From: David H mailto:hell...@gmail.com>>
> Sent: Wednesday, 29 April 2020 12:49 PM
> To: Chris Good mailto:goodchri...@gmail.com>>
> Cc: Gnucash Users mailto:gnucash-user@gnucash.org>>
> Subject: Re: [GNC] Gnucash logs
>
>
>
> Chris,
>
>
>
> How would you see this working with my 2 data files that I have
in the same gnucash folder ???  Would the subdirectory(ies)
include the name of the data file to clearly identify them or
would all log/backup files be lumped in together in a single
subdirectory ?  When I save my gnucash file under another name
using save as would it create the required subdirectories for the
new data file if they are separate subdirectories ?
>
>
>
> My own situation is that I've set the log files to be deleted
after 30 days which seems to work on Mac Catalina.  My data files
are in a dedicated folder in my Documents folder and I must
confess that I have NEVER had a need to go looking for backup
files or log files since starting with Gnucash in 2010.
>
>
>
> Cheers David Halverson.
>
>
>
> On Wed, 29 Apr 2020 at 11:48, Chris Good mailto:goodchri...@gmail.com> > > wrote:
>
>  Original Message 
> From: Michael or Penny Novack mailto:stepbystepf...@comcast.net>
> >
> Sent: Tue Apr 28 22:11:04 GMT+05:30 2020
> To: "D." mailto:sunfis...@yahoo.com>
> >
> Cc: Gnucash Users mailto:gnucash-user@gnucash.org> > >
> Subject: Re: [GNC] Gnucash logs
>
> On 4/27/2020 10:50 PM, D. wrote:
>> Michael,
>>
>> I take your point; we users will often create duplicated file
names for
> different content. I believe that many users only keep one set
of books. I
> don't have any statistics on general GnuCash usage to be able to
say whether
> more users have one file or many.
>> However, given that operating systems prevent identical file
names to
>> coexist in a folder, it would seem to me that there is a simple
remedy
>> to overlapping log files: per book log folder settings. In your
case,
>> business1financials/ledger.gnucash would use
business1financials/logs
>> and organization1financials/ledger.gnucash would use
>> organization1financials/logs
>>
>> Problem solved.
>>
> Yes, but that is solving the problem by a different method (not
writing the
> log files to a dedicated directory for all log files but writing
them into a
> subdirectory of the directory containing the data file).
> Would be easy for gnucash when starting to check for the
existence of this
> subdirectory, if not there, create it. Much as it checks for the
existence
> of a lock file.
>
> Had THAT been suggested you would not have seen an objection
from me.
> But about "almost all users have only one set of books" I have
to laugh.
> If all those rare situations never existed, designing/writing
software would
> be a snap. Software solution have to ALWAYS work. A commonly
quoted rule of
> rule of thumb, 80% of the design/write time will be handling
just 20% of the
> cases, but in my experience, 50% of the time will be handling
those that are
> 1% or less.
>
> Michael
>
> Hi,
>
> I like the idea of putting logs in a 'log' subdirectory of the
data file
> folder and also putting the backups in a 'backup' subdirectory
of the data
> file folder. GnuCash would create these on startup if needed.
>
> If I could get general approval 

Re: [GNC] Gnucash logs

[David T. via gnucash-user]

If the setting were per book and user-configurable, then a user could 
choose to set each data file to use a different set of folders, by 
changing the file default from "logs" to "logs-file1"


Does the Attachments functionality provide a blueprint for how this 
could work for backups and logs? It seems to me that there is a setting 
somewhere that allows the user to point to a particular folder for 
external file association (although my attempts at locating that setting 
have failed).


But your point about the logs and backups having different filenames is 
apt as well.


David T.

On 4/29/2020 8:55 AM, Chris Good wrote:


From: David H 
Sent: Wednesday, 29 April 2020 12:49 PM
To: Chris Good 
Cc: Gnucash Users 
Subject: Re: [GNC] Gnucash logs

  


Chris,

  


How would you see this working with my 2 data files that I have in the same 
gnucash folder ???  Would the subdirectory(ies) include the name of the data 
file to clearly identify them or would all log/backup files be lumped in 
together in a single subdirectory ?  When I save my gnucash file under another 
name using save as would it create the required subdirectories for the new data 
file if they are separate subdirectories ?

  


My own situation is that I've set the log files to be deleted after 30 days 
which seems to work on Mac Catalina.  My data files are in a dedicated folder 
in my Documents folder and I must confess that I have NEVER had a need to go 
looking for backup files or log files since starting with Gnucash in 2010.

  


Cheers David Halverson.

  


On Wed, 29 Apr 2020 at 11:48, Chris Good mailto:goodchri...@gmail.com> > wrote:

 Original Message 
From: Michael or Penny Novack mailto:stepbystepf...@comcast.net> >
Sent: Tue Apr 28 22:11:04 GMT+05:30 2020
To: "D." mailto:sunfis...@yahoo.com> >
Cc: Gnucash Users mailto:gnucash-user@gnucash.org> >
Subject: Re: [GNC] Gnucash logs

On 4/27/2020 10:50 PM, D. wrote:

Michael,

I take your point; we users will often create duplicated file names for

different content. I believe that many users only keep one set of books. I
don't have any statistics on general GnuCash usage to be able to say whether
more users have one file or many.

However, given that operating systems prevent identical file names to
coexist in a folder, it would seem to me that there is a simple remedy
to overlapping log files: per book log folder settings. In your case,
business1financials/ledger.gnucash would use business1financials/logs
and organization1financials/ledger.gnucash would use
organization1financials/logs

Problem solved.


Yes, but that is solving the problem by a different method (not writing the
log files to a dedicated directory for all log files but writing them into a
subdirectory of the directory containing the data file).
Would be easy for gnucash when starting to check for the existence of this
subdirectory, if not there, create it. Much as it checks for the existence
of a lock file.

Had THAT been suggested you would not have seen an objection from me.
But about "almost all users have only one set of books" I have to laugh.
If all those rare situations never existed, designing/writing software would
be a snap. Software solution have to ALWAYS work. A commonly quoted rule of
rule of thumb, 80% of the design/write time will be handling just 20% of the
cases, but in my experience, 50% of the time will be handling those that are
1% or less.

Michael

Hi,

I like the idea of putting logs in a 'log' subdirectory of the data file
folder and also putting the backups in a 'backup' subdirectory of the data
file folder. GnuCash would create these on startup if needed.

If I could get general approval in principle, I could even start work on it.

Regards, Chris Good

___



Hi David H,

  


The backup filenames and log filenames already include the book name and I see 
no reason to change that.

People could still have multiple books in the same directory, although I 
suggest best practice is to put each book’s data file in a separate directory.

  


Regards, Chris Good

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

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

Re: [GNC] Porting the Tutorial & Concepts Guide to ReadTheDocs.org

[David T. via gnucash-user]

Adrien,

Given that the dev team has discussed documentation formats since at 
least 2013 (cf. https://bugs.gnucash.org/show_bug.cgi?id=722016), I 
wouldn't expect a rapid transition to some other format just because 
someone comes up with a fancy new tool.



David T.

On 5/6/2020 11:15 AM, Adrien Monteleone wrote:

Could be it just hasn’t been seen widely yet. Posts here are odd beasts in that 
some get lots of activity and others nary a peep. Being that they are mail, 
this may be a semi-permanent condition for a thread.

I’ll hazard a guess that it may have been appealing more for potential 
documenters than readers, and probably not something a casual user would 
comment on. If would-be documenters haven’t seen the thread or investigated...

Don’t sweat it. I’ll offer the perspective that while I’m not very chatty on 
this particular topic here on the list at the moment, I initially like the idea 
and I’ll look more into it for working on the documentation and as a user. But 
I can’t promise a flurry of testing or commentary on a specific time frame, 
with my 7000 irons in 30 fires. I’m sure I’m not the only one in that boat, odd 
as it may seem. I also have some previous GC ‘projects’ I’ve started that I’d 
like to finish before the 4.0 freeze, though they just involve some research 
and beta testing mostly.

I suspect something major like moving documentation to a new platform won’t 
happen for 4.0, though that isn’t out of the question. I personally would like 
to see its development move to something with less of a hurdle or learning 
curve as that could include more seasoned users who aren’t build savvy.

Regards,
Adrien


On May 6, 2020 w19d127, at 12:11 AM, flywire  wrote:

I thought there would have been more comments on Porting the Tutorial &
Concepts Guide to ReadTheDocs.org tested recently at
https://gnucash-docs-rst.readthedocs.io/


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

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

[GNC] Tabs Behaviors in GNC4.1

[David T. via gnucash-user]

Hello,

I'm running GNC4.1 on Windows 10, and I've noticed a couple of changes 
in the tab interface in recent versions that are irksome to me. I have 
my preferences set so that account tabs are placed on the left side of 
the window.


The first issue I've noticed is that new tabs now open directly under 
the Chart of Accounts tab on the screen. In the past, they opened at the 
very end of the list.


Thus, the tab list after opening a new account currently looks like this:

{Chart of Accounts}
{Newly-Opened Account}
{Old Account A}
{Old Account B}
{Old Report A}

In earlier versions, new tabs always opened at the bottom of the list, thus:

{Chart of Accounts}
{Old Account A}
{Old Account B}
{Old Report A}
{Newly-Opened Account}

I much prefer this latter approach, since I usually have a default set 
of accounts always opened, and the tabs below are for more situational 
information. Is there a setting that I can change to get the earlier 
behavior back?


The second issue I have is that tabs shrink and expand to show the full 
account name up to a certain point. In older versions, I believe that 
the tab width was fixed, and account names that didn't fit were ellipsed 
when they got too long. The current solution is weird; the tabs 
automatically adjust wider or narrower based on the name of the opened 
tabs--up to a point, after which ellipses are still used. While I 
understand the utility of displaying the full account name on screen, I 
nevertheless find the changing of the window geometry distracting, and 
would much prefer to have the tabs set to a single width that doesn't 
fluctuate. (Personally, I would expect that this area would require the 
user to manually reset widths, similar to adjusting the columns in a 
spreadsheet--but I understand that this is my own expectation) Is there 
a setting I can change to keep the tabs at a certain width?


TIA,

David T.

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

[GNC] Register Column Widths

[David T. via gnucash-user]

Hi,

Could anyone tell me the current status on the storage of saved register 
column widths? I was under the impression that there was a change made 
somewhat recently to the the logic of how GNC stored column widths for 
different registers.


Previously, register column widths were stored on an account-by-account 
basis; the new system stored only a single setting for all accounts of a 
given type, and users had to actively save the column width settings for 
a given account type. There was a bit of discussion about where in the 
menus the column save feature was to be found. However, I have looked in 
every menu and submenu I could think of (File->Properties, 
Edit->Preferences, View, and Windows, to name a few), and I cannot see 
this save option. Searches of Bugzilla, the lists, and Git failed to 
turn up information that would inform me, so I turn to the list for 
assistance.


If this feature is still present in GNC4.1 on Windows, how am I to save 
a given set of column widths?


TIA,

David T.

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

Re: [GNC] Capital Gain Calculations on Split Stocks

[David T. via gnucash-user]

Thanks!

On 8/25/2020 9:48 AM, Stan Brown wrote:

On 2020-08-24 20:06, D. via gnucash-user wrote:

I'll have to figure out how I'd trigger the --extra flag in Windows

METHOD 1: a. Duplicate your GnuCash shortcut
b. Right-click the duplicate, select Properties
c. Add the flag in the Target box.

METHOD 2: a. Open a command prompt.
b. Type CD followed by a space and the path to your GnuCash folder,
which is probably C:\Program Files (x86)\gnucash\bin
c. type GnuCash --extra

There are other methods too.


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

[GNC] More Fun with Lots

[David T. via gnucash-user]

Hello,

Having now fiddled with the Lots features some more, I have encountered 
some issues with its implementation.


First, if I open up the lots viewer to see what it is doing with lot 
allocations, the interface appears to automatically recalculate the gain 
in the entire account, and it does this silently when you simply click 
on a given lot (e.g., to see its allocation). I discovered this issue 
because I was attempting to clean up several accounts in which a stock 
split had occurred at some point in the past, and for which I still had 
active holdings. Attempting to adjust the transaction for the stock 
split to account for an adjusted cost basis caused all gains to become 
adjusted--even ones that had been manually entered to match my 
institution's accounting.


Second, I am having troubles with the Scrub feature. While manually 
assigning a sale to a particular lot, when I clicked Scrub (not Scrub 
Account) I found that the viewer would automagically assign subsequent 
transactions to the lot--even though I had specifically assigned only 
particular transactions to a lot. For example, I have one account where 
I had two purchases (i.e., two lots), followed by a partial sale (which 
could be assigned wholly to the first lot with remaining shares in that 
lot), followed by a reverse split, followed by another sale. For reasons 
that were not clear, when I assigned the first sale manually to a 
particular lot and then clicked Scrub, the subsequent transaction for 
the reverse split kept getting added to the lot. It appears that the 
scrub function insists on adding all subsequent share transactions to 
the lot. Given that there is no way to process the lot without using the 
Scrub in one of its forms, the user is left having to either delete all 
subsequent transactions and reconstruct the account step by step, or 
abandon the lots altogether for that account. This leaves the user with 
the unfortunate situation of having to remember which accounts use lots, 
and which don't.


I am not sure how best to proceed for my own accounts; I generally like 
the lots features, and hope to find a way to use them even in this 
particular use case. I welcome suggestions.


Best,

David


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

Re: [GNC] More Fun with Lots

[David T. via gnucash-user]

 transaction 
in the register.


Resist the temptation to click on the "Scrub" button.

Review all the "Realized Gain/Loss" transactions in the register. 
Replace the default description with some details of the Sale (eg cut 
and paste the description from the Sale transaction).


DELETE the "Orphaned Gains-XXX" account and move its transactions to 
your regular Capital Gains / Losses accounts.


Rinse and repeat.


Good luck!

Geoff
=

On 26/08/2020 12:44 am, David T. via gnucash-user wrote:

Hello,

Having now fiddled with the Lots features some more, I have 
encountered some issues with its implementation.


First, if I open up the lots viewer to see what it is doing with lot 
allocations, the interface appears to automatically recalculate the 
gain in the entire account, and it does this silently when you simply 
click on a given lot (e.g., to see its allocation). I discovered this 
issue because I was attempting to clean up several accounts in which 
a stock split had occurred at some point in the past, and for which I 
still had active holdings. Attempting to adjust the transaction for 
the stock split to account for an adjusted cost basis caused all 
gains to become adjusted--even ones that had been manually entered to 
match my institution's accounting.


Second, I am having troubles with the Scrub feature. While manually 
assigning a sale to a particular lot, when I clicked Scrub (not Scrub 
Account) I found that the viewer would automagically assign 
subsequent transactions to the lot--even though I had specifically 
assigned only particular transactions to a lot. For example, I have 
one account where I had two purchases (i.e., two lots), followed by a 
partial sale (which could be assigned wholly to the first lot with 
remaining shares in that lot), followed by a reverse split, followed 
by another sale. For reasons that were not clear, when I assigned the 
first sale manually to a particular lot and then clicked Scrub, the 
subsequent transaction for the reverse split kept getting added to 
the lot. It appears that the scrub function insists on adding all 
subsequent share transactions to the lot. Given that there is no way 
to process the lot without using the Scrub in one of its forms, the 
user is left having to either delete all subsequent transactions and 
reconstruct the account step by step, or abandon the lots altogether 
for that account. This leaves the user with the unfortunate situation 
of having to remember which accounts use lots, and which don't.


I am not sure how best to proceed for my own accounts; I generally 
like the lots features, and hope to find a way to use them even in 
this particular use case. I welcome suggestions.


Best,

David


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

[GNC] Capital Gain Calculations on Split Stocks

[David T. via gnucash-user]

Hi,

In the last couple of days, I have learned TONS about how to manage 
capital gains with assorted lots in the GnuCash realm. The financial 
institution I use has algorithms that adjust my accounts to minimize tax 
implications. This results in sales against specific lots within 
GnuCash, and I've been able to match sales with specific lots and 
achieve numbers in GnuCash which match the institution's calculations. 
All good!


However, I have one account with a single purchase, followed by a two 
for one split, followed by a partial sale. Using the lots in this case, 
however, yields wildly variant and incorrect results. In the attached 
image, you can see the full transaction history, along with the lots 
window indicating the assignment of the February sale to Lot 0 with a 
loss of $169.96.


This happens because 7*53.29 (the original share price) = $373.03, and 
203.07 - 373.03 = -169.96


If I choose to use Lot 2 for the match, the result is $203.07 gain 
(7*0=$0 cost). This also is wrong.


The correct calculation is: $203.07 - (7 * 53.29 / 2) = $16.55, which is 
what the institution is reporting. I am hesitant to adjust the gain 
value to match this amount, as I suspect that GnuCash will then report 
the account as out of balance. I have seen in the past that incorrect 
gains calculations can throw off the balance sheet, with painful 
remedies and memories. My questions here are:


1) Is there a way to have GnuCash properly track cost basis in an 
account with a stock split?


2) If I arbitrarily change the gains transaction, will subsequent 
balance sheet numbers be in balance?


3) What is the proper way to handle a stock split?

TIA,

David T.

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

Re: [GNC] clip board paste across catagories

[David T. via gnucash-user]

I am not an expert, but perhaps if you're writing the format yourself, 
maybe you could adopt an existing standard (e.g., QIF, QFX, CSV) and 
import that into GnuCash?


Also, Chapter 18 in the Guide is all about importing business data. 
Perhaps that might lead somewhere?


On 9/29/2020 4:20 PM, ToddAndMargo via gnucash-user wrote:


On Sep 27, 2020, at 12:23 AM, ToddAndMargo via gnucash-user 
 wrote:


Any special character I can throw at it to get it to paste across 
fields?  I can insert anything I want into the string






On 2020-09-29 08:55, John Ralls wrote:
No. Aside from the special transaction copy-paste that Liz mentioned 
copy-paste is one field at a time. You'll note that you're able to 
select only one field at a time: GnuCash isn't a spreadsheet.


What's the source of the clipboard item?

Regards,
John Ralls



I am the source of the data.   I have written a program
that reads new purchase orders from my inventory
database and formats it into an eMail format that my
vendors have started requiring.

My goal was to take my data and create a format that I
could paste into GnuCash.  I frequently forget to enter
orders into GnuCash and THAT make for an INTERESTING
reconciliation with my bank statement.

Since I am the programmer, I can insert anything in the
clipboard I want, including weird characters.


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

Re: [GNC] Checking account withdrawals for cash boxes

[David T. via gnucash-user]

Not an accountant, but I'd probably go with Assets:Cash

How you handle the subsequent procedures will better be addressed by others.

On 9/29/2020 4:16 PM, Roderick A. Anderson wrote:

Good day to all.

I have a question that may require me contacting an accountant but 
this is my first pass.


First I am the Treasurer for a small US 501c3.  Never been an 
accountant nor played one on TV. ;-)


We have an annual fund raiser.  I withdraw cash from the 
checking/General account for the cash boxes. In the past (and what I 
inherited) was to make it an expense entry.  Just doesn't seem right 
since we still have the money.


Should I create another Asset account and record it there?


TIA,
Rod
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

[GNC] Reconcile Status Redux: New Odd Behavior, or Is It Me Again?

[David T. via gnucash-user]

Hello,

I know no one wants to hear from me these days, but I've noticed strange 
behavior with reconciled transaction entries in GnuCash 4.1 under 
Windows 10.


Specifically, when I edit the amount of a reconciled transaction entry 
(a.k.a. "split"), I receive a notice that I am attempting to edit a 
reconciled split (as is appropriate). After I confirm that I wish to 
change this entry, I am then taken into the entry, and I make my edit. 
When I change the amount, the reconcile flag changes to "n", but when I 
leave the split, *the split reverts to reconciled status.* I have tested 
this in a couple of different register types (commodity, cash), and I 
have tried both tabbing out of the split and using enter, with the same 
result.


Similarly, trying to change the date of the transaction as a whole gives 
this message; however, none of the reconcile status flags are changed in 
this case. The only instance in which I've been able to reverse the 
reconcile flag is to directly click the field in the register.


I don't recall now whether there has been a change in logic on this  
front, such that reconciled transactions are left reconciled except when 
the flag is directly changed. Previously, any attempts to alter a 
transaction resulted in its reconcile flag being turned off.


Does anyone else see this behavior, is it intended to be this way, or is 
it once again some odd setting that I have somehow managed to set?


David T.

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

[GNC] Error with Advanced portfolio report

[David T. via gnucash-user]

If someone could advise on further steps for the following...

Gnucash 4.1, Windows 10

Attempt to open Advanced Portfolio report (Reports->Assets & 
Liabilities->Advanced Portfolio) yields the following:


Report error

An error occurred while running the report.

In c-interface.scm:
 24:4 19 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
    829:9 18 (catch #t # …)
In c-interface.scm:
    29:37 17 (_)
In unknown file:
  16 (eval-string "(gnc:report-run 5)" #)
In ice-9/boot-9.scm:
   2312:4 15 (save-module-excursion #)
In ice-9/eval-string.scm:
 38:6 14 (read-and-eval # #:lang _)
In report-core.scm:
    689:4 13 (gnc:report-run _)
In c-interface.scm:
 66:2 12 (gnc:backtrace-if-exception _ . _)
 24:4 11 (gnc:call-with-error-handling _ _)
In ice-9/boot-9.scm:
    829:9 10 (catch #t # …)
In c-interface.scm:
    28:40  9 (_)
In report-core.scm:
   691:29  8 (_)
   673:25  7 (gnc:report-render-html #< type: "21d7cfc59fc7…> …)
In standard/advanced-portfolio.scm:
  1057:10  6 (advanced-portfolio-renderer _)
In ice-9/boot-9.scm:
    829:9  5 (catch div/0 # …)
In standard/advanced-portfolio.scm:
   428:10  4 (table-add-stock-rows #< col-headers: (("A…> …)
In srfi/srfi-1.scm:
    640:9  3 (for-each # …)
In standard/advanced-portfolio.scm:
   460:21  2 (_ _)
In srfi/srfi-1.scm:
    640:9  1 (for-each # …)
In standard/advanced-portfolio.scm:
   515:41  0 (_ #)

In procedure module-lookup: Unbound variable: parent-or-sibling?

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

[GNC] Experimental Balance Sheet report

[David T. via gnucash-user]

Hello,

Today, I tried out the "Balance Sheet (Multicolumn)" report in the 
Experimental reports section, and I'd like to share some observations.


1. When initially run, I receive an empty report. This is similar to the 
initial result of the basic Transaction report, except in the latter 
case, users are given a note that links them to the report options. It 
would seem to me that at the least, this report should do the same. A 
better solution in both cases would be to have initial parameters that 
return some kind of data--however unrelated to the user's end 
goal--rather than an empty page. It seems to me that users are better at 
changing something they see that is wrong, rather than trying to conjure 
it up out of thin air. (the famous quote from US Supreme Court Justice 
Potter Stewart regarding obscenity comes to mind here: "I know it when I 
see it. This is not it."). In the Balance Sheet, changing the Period 
Duration setting from its default "None" to anything else (I'd suggest 
"Year") yields data from which a user can build. (I have no suggestions 
for the Transaction Report.)


2. The report defaults to including all accounts, including hidden and 
placeholder accounts. While there is an option on the Accounts tab to 
display hidden accounts, I think the decision to include hidden accounts 
in the report by default is confusing, given that the Account tab 
doesn't display hidden accounts by default. I think it makes more sense 
for the report either to default to omitting hidden accounts, or to 
default to displaying hidden accounts in the options dialog. I see that 
the standard Balance Sheet report also includes hidden accounts by 
default, although this is masked because the standard report limits the 
accounts to 3 levels (the Experimental report defaults to All levels). I 
will note that there is an option on the Display tab to omit zero 
balance accounts, which may have been seen as a way to skip hidden 
accounts. However, while it may not be prudent or common practice to 
hide accounts that have balances, there is nothing in the program to 
prevent this, which means that hiding zero balance accounts is not the 
same as including hidden accounts. I'll note that if I Clear All and 
then click Select All on the Accounts tab, the report properly omits all 
hidden accounts, which it should also do by default. I suggest that both 
reports should default to omitting Hidden accounts on opening, and that 
the default level setting should be the same for both.


3. The report propagates balances all the way up the account hierarchy, 
which makes sense for accounts denominated in a currency. However, with 
accounts denominated in commodities (such as Stock or Mutual Fund 
accounts), it makes less sense, and in fact renders the report extremely 
difficult to follow, especially with accounts with many different 
commodities. Seeing a full listing of all 150 different commodities (and 
various subsets thereof) repeated for


Assets,

Assets:Investments,

Assets:Investments:Taxed,

Assets:Investments:Taxed:Self, and

Assets:Investments:Taxable:Self:Brokerage A

gets old and confusing very quickly. It would be better to propagate 
totals for the book currency  only, and leave the tallying of stock and 
mutual fund holdings to the Advanced Portfolio report. I will note that 
initially, I was going to ask why some entries in the report were listed 
as hyperlinks, while others were not. After some puzzling, I figured out 
that the non-linked entries were summarizations of holdings further down 
the hierarchy. Removing the numerous duplications of commodity 
summmarizations would at least make it a little clearer what is going on 
in this regard. I will further note that the standard report does not 
repeat this information up the hierarchy.


Best,

David T.


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

Re: [GNC] Gnucash - user

[David T. via gnucash-user]

I think it means that GnuCash-user will ride on highways as well 
as it runs on ski slopes. 


On 7/8/2020 11:01 AM, Derek Atkins wrote:

flywire  writes:


This will change when (if) we migrate to mailman3, which includes the
"hyperkitty" forum-like interface, but at this point in time we do not
have a timeline for when this will happen.

mailman3 would put wheels on the sled.

I must admit I don't know exactly what you mean by this.  :-)


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

-derek


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

Re: [GNC] Bulk moving transactions

[David T. via gnucash-user]

If you search for these transactions or filter them in the (wrong, 
problematic) register, it is simple enough to merely change the 
erroneous Transfer account and tab off the specific line. This will 
change the entry, which will instantly remove it from the current view, 
since the split that anchors the transaction to the current (wrong) 
register no longer exists. You can power through hundreds of such 
transactions this way in a matter of minutes. At least, I can.


David T.

On 6/30/2020 5:02 PM, Jean Laroche wrote:
not that I know of. That's one limitation of GC that I would really 
love to fix (or see fixed). It's usually impossible to select multiple 
transactions and do something on them (except in a few situations).
If you have very many of them, you could export them to cvs, then 
reimport them in the right account? But that's really a kludge.

J.


On 6/30/20 1:46 PM, V. Vatsal via gnucash-user wrote:

Hello,

I am running GnuCash on Mac.

Somehow a month’s worth of credit card transactions ended up in the 
top level Bank Accounts account. Is there some quick way to move or 
edit them to the appropriate credit card account? It’s not possible 
even to move them manually, as far as I can tell, without jumping to 
the corresponding Expense account for each, and then changing the 
source account there.


Thanks,

Nike


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.

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

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

Re: [GNC] Gnucash-User

[David T. via gnucash-user]

Stan,

It's true, I did write that. My point was more about *individuals* 
signed up for Nabble; if an individual were get their GnuCash-users fix 
directly from lists.gnucash.org, instead of getting it ad-ded up by the 
lesser provider Nabble, then that individual would not have the 
Nabble-rousing experiences that such users trot out on occasion (e.g., 
https://lists.gnucash.org/pipermail/gnucash-user/2015-February/058530.html)


On 7/6/2020 12:50 PM, Stan Brown wrote:


On 2020-07-06 08:34, John Ralls wrote:

On Jul 6, 2020, at 3:22 AM, Liz  wrote:

On Sun, 5 Jul 2020 21:24:25 -0700
Stan Brown  wrote:


I guess all that would recommend abandoning nabble altogether, and
drinking the gnucash Kool ade directly from lists.gnucash.org...
just saying.?.

I did not write that. I believe it was written by "D." but I could be
mistaken.


I don't know how we could, because no-one knows who actually signed
Gnucash lists up to Nabble in the first place.

Maybe a few DMCA takedown notices? After all, they're violating our copyright 
by republishing our works on this list without permission or recompense, and 
doing so for commercial purposes (they run ads on the website).
P.S. Lessee, to make things more interesting:
Copyright 2020 John Ralls, Fremont California. All rights reserved.
Publication permission granted solely to lists.gnucash.org.

I think that ship sailed with Usenet. When Google took over Dejanews,
some of us put similar notices in our articles. Google ignored them,
used our articles in search results anyway.


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

[GNC] Cursor Focus on Wrong Tab

[David T. via gnucash-user]

Hello,

I swear I reported troubles with this a long time ago, and I could have 
sworn I added a bug about it. My recollection was that I was the only 
person who could duplicate the issue, and so it never went anywhere 
further. However, I find no evidence on Bugzilla or in the lists. Alas. 
My search skills are clearly lacking.


The issue is this: when I am in Tab "H" and duplicate a transaction by 
clicking the toolbar Duplicate button, once I have concluded the process 
by selecting a new date and pressing Enter, my cursor appears to be in 
tab "H", but is actually on Tab "B" (which is the first register 
account, after the COA). If I attempt to edit the transaction at this 
point, the transaction that receives input is NOT the visible 
transaction in tab H, but rather the hidden transaction on tab B.


In the attached image, "Base Salary" is the aforementioned tab H, in 
which I have just created a new transaction by clicking the Duplicate 
button, choosing today's date and pressing Enter, which has created the 
06/19/2020 transaction that is visible on screen.


If you look down where the big arrow is pointing, however, you will see 
"66.59" clearly displayed. "66.59" is actually the value of a 
transaction in the Checking register. If I start typing, the 
transaction that receives input *is in the Checking register and NOT the 
visible transaction in the Base Salary register.* I have to remember to 
use the mouse to actively click in the on screen transaction in order to 
"select" the transaction I just created on the currently-visible 
register and which appears to currently have focus.


To say this is confusing is an understatement--and it only gets worse if 
I start typing, fail to see any change, and then remember to click the 
current register. Now, the visible register gets focus--and the hidden 
register (which has changes I unwittingly have made) gets a commit. 
Obviously, this can have significant negative effects: the transaction I 
blindly edited has changed and been saved. Maybe that transaction is now 
unreconciled. Maybe I put gibberish into the description. Maybe I put 
gibberish into the transfer account, and GnuCash will send me a 
mysterious message that the account doesn't exist, would I like to 
create it. Maybe I have changed the amount on that transaction.


I hope that this email provides enough information that others can now 
see the problem that I have seen for a long time; if others can 
duplicate this, I'll enter a bug report.


David T.

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

Re: [GNC] Error with Asset Chart report

[David T. via gnucash-user]

Thank you. Yes. At least now I know that it's not just my personal 
electromagnetic signature causing the problem.


As for the levels on display, if you've followed the thread (and even my 
eyes glaze over reading through it), you will know that I am quite 
puzzled about this error.


David T.

On 12/7/2020 2:59 PM, David H wrote:

You mean this error :-)

Running on Gnucash 4.2 on Win 10 Pro.  If I click the error it 
re-displays, click again and it shows the chart but only levels 4 & 6 ??


Cheers David H.


On Tue, 8 Dec 2020 at 04:47, David T. via gnucash-user 
mailto:gnucash-user@gnucash.org>> wrote:


Odd.

I don't think it has to do with the account type, since I
replicated the
problem for both assets and liabilities accounts.

I don't believe my accounts have something in them that could
generate
this error. I've been able to create a brand new file with an account
structure and just a few transactions in it that (on my machine)
exhibit
these errors. I attach that test file here. For me, this file
generates
errors when I run either the Asset Chart or the Liability Chart
reports.

To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build
from 2020-11-21). I predict that you will not see any errors on your
Mac. I wonder if another Windows user experiences this problem
with this
file.

David


*From:* Adrien Monteleone
*Sent:* Mon Dec 07 12:31:07 EST 2020
*To:* gnucash-u...@lists.gnucash.org
<mailto:gnucash-u...@lists.gnucash.org>
*Subject:* Re: [GNC] Error with Asset Chart report

I created several level-7 and level-8 asset accounts and put a
transaction in one at level-8.

I then tried both the Bar & Pie charts, both using '6' and 'All'
options
and all executed properly without errors.

Perhaps something is amiss with one (or more) your accounts at
that depth?

Maybe the type of asset account makes a difference. I created my tests
as standard type Asset. (not any of the special types like AR, Stock,
Fund, etc.)

Regards,
Adrien

On 12/7/20 11:23 AM, Adrien Monteleone wrote:

    That is quite interesting. As noted, I don't have any >6 level
Asset
    (or Liability) accounts. But I do have level-7 Expense accounts. I
    tried the Expense Chart & Expense Pie Charts, and both execute
    without errors for both All and '6' options. (and yes, those
level-7
    accounts have many transactions in them) Now, this could still
be an
    OS specific thing, but if those two work for you, perhaps Chris
    could merge the code from them to the other offending
    charts/reports. I see he made a change to not report deeper
than '6'
    but I haven't received clarification if that is just for the
option
    '6' or for 'All' as well. (which would render reporting/charting
    deeper than level-6 impossible.) I'll see about creating some
dummy
    level-7 asset accounts and try to trigger the error.




gnucash-user mailing list
gnucash-user@gnucash.org <mailto: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>
<https://lists.gnucash.org/mailman/listinfo/gnucash-user
<https://lists.gnucash.org/mailman/listinfo/gnucash-user>>
If you are using Nabble or Gmane, please
seehttps://wiki.gnucash.org/wiki/Mailing_Lists
<http://wiki.gnucash.org/wiki/Mailing_Lists>
<https://wiki.gnucash.org/wiki/Mailing_Lists
<https://wiki.gnucash.org/wiki/Mailing_Lists>> for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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


___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 

[GNC] Error with Asset Chart report

[David T. via gnucash-user]

Hello,

I am on Windows 10, using Version: 4.2
Build ID: git 4.2-213-g562b4be22+(2020-11-21)

Back in June 2019 
(https://lists.gnucash.org/pipermail/gnucash-user/2019-June/085636.html), 
I reported a problem with an odd error in a saved report. After some 
back and forth, I don't believe that any resolution occurred, and I have 
re-encountered the error.


This time, I am using the stock Asset Chart report, and again I 
encounter the nonsensical error repeatedly:


"This report was saved using a later version of GnuCash. One of the 
newer multichoice options '7' is not available, fallback to the option '2'."


Testing reveals that this error is referring to the fact that I am 
selecting the "Show Accounts until level" to use the provided value of 
'6' (which is the seventh option in the list, which includes All and 
1-6). It pops up numerous times when I run the report, presumably 
because it iterates through the accounts and barfs each time it gets to 
a sixth-level account.


This error is nonsensical because:

1) I am invoking the report from the Report menu for the first time in 
THIS version of GnuCash; there are no saved versions of the report


2) There are no newer versions of GnuCash that I have run on my machine, and

2) I am SELECTING THE VALUE THAT IS PROVIDED IN THE REPORT OPTIONS.

This error can easily be replicated; just open the base GnuCash Asset 
Chart (Report->Assets & Liabilities->Asset Chart), select some accounts, 
and choose '6' in the "Show Accounts until level" drop down. The error 
will then trigger.


If there is a simple hack I can apply to remove this error, I'd 
appreciate knowing it. As it stands, the result is annoying, and the 
fact that it is embedded in the GnuCash-supplied report is problematic.


David T.


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

Re: [GNC] Error with Asset Chart report

[David T. via gnucash-user]

Odd.

I don't think it has to do with the account type, since I replicated the 
problem for both assets and liabilities accounts.


I don't believe my accounts have something in them that could generate 
this error. I've been able to create a brand new file with an account 
structure and just a few transactions in it that (on my machine) exhibit 
these errors. I attach that test file here. For me, this file generates 
errors when I run either the Asset Chart or the Liability Chart reports.


To reiterate, I am running Windows 10 with Gnucash 4.2 (nightly build 
from 2020-11-21). I predict that you will not see any errors on your 
Mac. I wonder if another Windows user experiences this problem with this 
file.


David


*From:* Adrien Monteleone
*Sent:* Mon Dec 07 12:31:07 EST 2020
*To:* gnucash-u...@lists.gnucash.org
*Subject:* Re: [GNC] Error with Asset Chart report

I created several level-7 and level-8 asset accounts and put a
transaction in one at level-8.

I then tried both the Bar & Pie charts, both using '6' and 'All' options
and all executed properly without errors.

Perhaps something is amiss with one (or more) your accounts at that depth?

Maybe the type of asset account makes a difference. I created my tests
as standard type Asset. (not any of the special types like AR, Stock,
Fund, etc.)

Regards,
Adrien

On 12/7/20 11:23 AM, Adrien Monteleone wrote:

   That is quite interesting. As noted, I don't have any >6 level Asset
   (or Liability) accounts. But I do have level-7 Expense accounts. I
   tried the Expense Chart & Expense Pie Charts, and both execute
   without errors for both All and '6' options. (and yes, those level-7
   accounts have many transactions in them) Now, this could still be an
   OS specific thing, but if those two work for you, perhaps Chris
   could merge the code from them to the other offending
   charts/reports. I see he made a change to not report deeper than '6'
   but I haven't received clarification if that is just for the option
   '6' or for 'All' as well. (which would render reporting/charting
   deeper than level-6 impossible.) I'll see about creating some dummy
   level-7 asset accounts and try to trigger the error. 





gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user  

If you are using Nabble or Gmane, please 
seehttps://wiki.gnucash.org/wiki/Mailing_Lists  
  for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



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

Re: [GNC] Updates on Windows

[David T. via gnucash-user]

Derek,

Thanks for the quick reply. Not being a Linux user (much), I immediately 
wonder whether the Linux removal and reinstallation process removes 
existing menu shortcuts that a user may have implemented, such as 
placing an icon on the OS menu bar. Do you know?


David

 On 1/21/2021 8:58 AM, Derek Atkins wrote:

David,

I will just suggest that it is Mac tht is the oddity here.
Linux packages also remove older versions when upgrading.

-derek

On Thu, January 21, 2021 8:53 am, David T. via gnucash-user wrote:

Hello,

I've used GnuCash for a very long time, under different operating
systems (currently GC4.4 on WIndows 10), and I have a minor question
about the upgrade process under Windows.

When I updated under MacOS, I was able to install multiple versions in
parallel simply by renaming the app bundle in Applications (for example,
from Gnucash.app to Gnucash-3.11.app). It was then possible to run
either version, if needed. Under Windows, however, the installation
process begins by removing the earlier version from the system.

Setting aside the wisdom or folly aspect of having or running multiple
versions of GnuCash, I am curious why it is that the Windows installer
always removes the previous version before installing the next. While
this is a minor point, it *does* have an effect in my daily usage. I pin
the Gnucash icon to the taskbar, to make it easy to find and run (Aside:
one of the things I like least about Windows 10 is its management of the
Apps menu). When the new version gets installed, this is not preserved,
and I have to re-pin the icon after every update. As I've already noted,
this is a minor point, but it's the kind of oddity that sticks in my
brain.

Could someone explain this oddity to me?

TIA,

David

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




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

[GNC] Updates on Windows

[David T. via gnucash-user]

Hello,

I've used GnuCash for a very long time, under different operating 
systems (currently GC4.4 on WIndows 10), and I have a minor question 
about the upgrade process under Windows.


When I updated under MacOS, I was able to install multiple versions in 
parallel simply by renaming the app bundle in Applications (for example, 
from Gnucash.app to Gnucash-3.11.app). It was then possible to run 
either version, if needed. Under Windows, however, the installation 
process begins by removing the earlier version from the system.


Setting aside the wisdom or folly aspect of having or running multiple 
versions of GnuCash, I am curious why it is that the Windows installer 
always removes the previous version before installing the next. While 
this is a minor point, it *does* have an effect in my daily usage. I pin 
the Gnucash icon to the taskbar, to make it easy to find and run (Aside: 
one of the things I like least about Windows 10 is its management of the 
Apps menu). When the new version gets installed, this is not preserved, 
and I have to re-pin the icon after every update. As I've already noted, 
this is a minor point, but it's the kind of oddity that sticks in my brain.


Could someone explain this oddity to me?

TIA,

David

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

Re: [GNC] New Imbalance-XXX Behavior

[David T. via gnucash-user]

@Derek:

Please re-read my email. In it you will see that I am NOT/NOT asking 
about how to handle entries that are automatically added to 
Imbalance-USD. I am fully aware of Gnucash behaviors in regard to the 
creation of entries into Imbalance-USD, and I have a long-established 
workflow in place for handling such created entries.



What I was noting is a CHANGE IN BEHAVIOR from earlier versions of 
Gnucash. In earlier versions, entries to Imbalance-USD would be added to 
the EXISTING Imbalance-USD account, regardless of its placement in the 
Chart of Accounts. In my books, I moved Imbalance-USD to be a child 
account of a new Top Level account that I created called "Special 
Accounts."



I have Used "Special Accounts" since around 2007 to encapsulate any and 
all "Imbalance-XXX" accounts, any "Orphaned Gains-XXX" accounts, any 
"Orphan-XXX" accounts (whatever they got created for), as well as my own 
"Unspecified" account (used on exceedingly rare occasions). This keeps 
the clutter down in the main Chart of Accounts. For the record, in each 
of these cases, I took the automatically-created account and MOVED it 
into its subsidiary location, a process I attempted with the 
GC4.5-vintage Imbalance-USD account without success.


In ALL prior versions (prior to 4.5), any imbalance entries would be 
added to "Special Accounts:Imbalance-USD", and I would periodically go 
through that account and clear up discrepancies. In GnuCash 4.5, these 
imbalance entries are ALWAYS placed in a top level account named 
"Imbalance-USD" regardless of the existence of "Special 
Accounts:Imbalance-USD".


@David:

Thank you for the vote of support.

On 5/31/2021 10:56 AM, David Carlson wrote:
The Imbalance-xxx account will reappear the next time an error is made 
in balancing a transaction, or if a transaction is intentionally left 
out of balance to be fixed later, so it is useless to delete the account.
I agree with David T that new entries should go to the existing 
account, even if it is not in the default position in the CoA.


On Mon, May 31, 2021 at 9:45 AM Derek Atkins > wrote:


The existence of an Imbalance account means you have an error in a
transaction.  So you should fix it and empty it..

-derek
Sent using my mobile device. Please excuse any typos.
On May 31, 2021 10:34:48 AM "D. via gnucash-user"
mailto:gnucash-user@gnucash.org>> wrote:

> Hello,
>
> I have noticed a new behavior in regards to the automatic
creation of
> entries to Imbalance-XXX (in my case,  Imbalance-USD).
>
> When I first started using Gnucash, I found the creation of a
top level
> imbalance account to be additional unwanted clutter to my Chart of
> Accounts. I found, by sheer coincidence, that I could move the
top level
> account into a different area of my CoA (in my case, a top level
> placeholder called Special Accounts, which includes a number of
these types
> of accounts), and Gnucash would use that newly-situated
Imbalance-XXX
> account for all new automatically-created imbalance entries.
>
> Alas, this is no more. In my most recent session, I have found
that Gnucash
> has decided that it must ALWAYS use a top level Imbalance
account for these
> entries. I find the concomitant clutter of my books annoying.
>
> This is disappointing. Does anyone know why this behavior has
changed, and
> is there any point to submitting a bug request to have the previous
> behavior restored?
>
> David T.
> Gnucash user since 2005
> Current: GC 4.5 on Windows 10
>
> ??
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user

> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
> -
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

___
gnucash-user mailing list
gnucash-user@gnucash.org 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user

If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists
 for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



--
David Carlson

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

[David T. via gnucash-user]

Given how easy it is to correct these problems (i.e., change the Account 
in the erroneous entry from Imbalance-XXX to some other account and 
press enter), I don't see why we continue to beat upon this subject.


On 6/3/2021 10:12 AM, Adam Funk wrote:

On 2021-06-01, DaveC49 wrote:


Laura,

The reason Imbalance entries exist is that it is a fundamental principle in
double entry accounting that the sum of the debits and credits to the
various accounts that make up a transaction must be zero.

The Imbalance results if a user creates and saves a transaction in which
this is not true. GNuCash tries to force your hand on this. You will notice
that if you create a transaction in which the sum of the debits and credits
is not zero, GnuCash will open a new line with an amount which will balance
that sum with no account selected in the account column. If you select an
account to assign that imbalance to, then the transaction is then balanced.
If you do not and save the transaction without specifically assigning an
account to it, GnuCash will assign the amount by which the transaction is
unbalanced to an Imbalance account in the currency of the accounts. If the
transaction involves more than one currency it will be in the currency which
is imbalanced in the transaction.

The only problem I have is that it is far too easy (IMO, IME!) to
accidentally create or use Orphan-* and Imbalance-* accounts just by
hitting the tab key one time too many. I'd prefer to be able to set an
option to disable that and to force me to balance the transaction
before leaving 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
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

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

[GNC] Account Sort Order

[David T. via gnucash-user]

Hello,

I'm using GnuCash 4.4 under Windows 10, and I am wondering how GnuCash 
sorts accounts in the Chart of Accounts window. My chosen sort order is 
by Account Code; however, I choose not to assign account codes for a 
large number of accounts (such as individual commodities in a brokerage 
account). For these accounts, I assumed that GnuCash sorts accounts by 
their names, based on an ASCII sort--which is generally what I see. The 
result is something like:


1599 - Broker A
-- 21st Century Fox
-- Alphabet
-- IBM

1600 - Alphabetically Earlier Account with higher account code

and so forth. And, indeed, that is how I see most of these accounts.

However, I decided to change up my structure and add a cash account to 
one of my brokerage accounts, and  no matter what I name this account, 
it shows up after every commodity account, like so:


1599 - Broker A
-- 21st Century Fox
-- Alphabet
-- IBM
-- 1 Cash

I've tried putting "*" "-" " ", and the result is the same; Cash appears 
after the commodities. Can anyone explain to me how GnuCash is arriving 
at this sort? Can anyone tell me if there is some way I can get the Cash 
account to appear before the commodities, without assigning account 
codes to them all? Assigning codes is out of the question because I'd 
have to resequence every commodity account after the purchase of any new 
commodity, which would get old very quickly.


TIA,

David

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

[GNC] Autofill Oddity

[David T. via gnucash-user]

Hi,

GnuCash 4.4 under Windows 10. Long time user.

Recent releases have included an update to the Autofill feature, which 
generally is a good thing. However, others have reported strange hitches 
using the new feature under Windows--situations where the register hangs 
and the application appears to stop working. I have also experienced 
these problems, but could not see any specific aspects that would help. 
However, I have now noticed one detail on my machine that may help in 
tracking this down. To wit, when I first start GnuCash, the first 
transaction entered in a register hangs after the user enters the first 
character in the Transfer column. The combo box indicator shows, but 
there is no further indication that anything has happened; the machine 
just stops. The application doesn't respond to keyboard input, but 
clicking elsewhere in the register window causes the Create account 
dialog to display. Cancelling this dialog then brings focus back to the 
Transfer column, the Accounts combo box shows, and all behaves as 
expected. From this point forward, Autofill seems to work as expected.


Best,

David T.

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

[GNC] Ghost Equity Accounts

[David T. via gnucash-user]

Hello,

I thought I saw something about this not too long ago, but cannot put my 
finger on the thread.


I am using GC4.4 on Windows 10, and have been using GnuCash since 2005.

Basically, I recently purchased shares of a new stock, and I followed my 
usual procedure in GnuCash: I created a new asset account of type Stock 
for the new equity under my brokerage account (Assets:Brokerage:XXX 
Stock). While creating the account, I used the new commodity option to 
create the entry in the security database. Having done this, I then 
opened the register and entered the buy transaction in the usual way.


All good to this point.

However, now I find a new account in the Equity hierarchy for the new 
commodity: Equity: Opening Balances - XXX


This account is empty, so I can just delete it, BUT...

Why is this account getting created? I didn't set up an existing 
holding, which might ostensibly have required an opening balances 
transaction (but which I would not have done in this way anyhow). And I 
didn't explicitly ask for a new equity account to be created.


Will I get Equity accounts created when I add other kinds of accounts? 
I'll note that I also have a new Equity account for a mutual fund 
account I added at the same time. But, what about Bank accounts? 
Liabilities? And if not, why not?


And why am I only seeing this NOW? As I've said, I've used GnuCash for a 
long long time, and none of the OTHER equities I've created over the 
years (and there have been a LOT!) have generated these spurious Equity 
accounts. So, why now?


Finally, Is there some way to NOT have GnuCash create these accounts 
every time I create a new Stock or Mutual Fund Account?


Cheers,

David T.

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

[GNC] A Couple of Budgeting Notes

[David T. via gnucash-user]

Hello,

In recent days, I've been tinkering around (again) with GnuCash's budget 
features, and I thought I'd share a couple of things that were not 
obvious to me from the interface or the documentation with regards to 
setting budget values.


First, it was not clear to me how the Estimate function operated. 
Specifically, if I use this function and leave the "Use Average" box 
unchecked, I didn't understand that each value in the result was derived 
from the corresponding period in sequence in the sample. In other words, 
the first budget amount was set to the first period transactions, the 
second budget amount to the second period of transactions, and so on. As 
an example, imagine I have a 12-month budget from 3/1/2020 to 2/28/2021, 
and I set the Estimator to use transactions from 10/1/2010. The amount 
budgeted for 3/1/2020 will be equal to the transactions in 10/2010, 
4/1/2020 will be equal to the transactions in 11/2010, etc. On this 
subject, the Guide simply says that the estimator will look at all 
transactions in the selected period but doesn't explain how the numbers 
are derived or allocated.


Second, it may be of use to others to know that it is easy to set some 
accounts to use an equal budgeted amount, while setting others to vary 
over time to reflect seasonal changes in amounts. The way to accomplish 
this is to use the Estimate function separately for each type of budget 
account. Open the Estimate option, select the accounts for which you 
want varying amounts and uncheck the Use Average button. Now, repeat the 
process for the fixed value accounts, and check the Use Average box. 
Your budget will now have both fixed and varying amounts in the 
different accounts. As I said, this may be obvious to some, but it 
wasn't something that I realized for some time.


I hope that sharing these points with the list will help others make 
more productive use of the budget features.


Cheers,

David T.

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

Re: [GNC] Coloring the Action field

[David T. via gnucash-user]

I use something like Michael's approach with paychecks, but my simple 
workaround is that I enter the correct amount deposited to my checking 
account (that *is* what I'm most interested in!), using a previous pay 
transaction as the template. Inevitably, IT DOES NOT BALANCE, and I end 
up with an entry in Imbalance-USD, which I monitor for zero balance.


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


For Stephen's use case, I don't see how creating inaccurate entries 
using the loan scheduler is somehow better than creating inaccurate 
entries using other techniques.


David T.

On 12/16/2021 4:36 PM, David Carlson wrote:

I think that it would be possible to use the loan wizard to build a
Scheduled loan payment Transaction pointing to an Unallocated Funds account
that could be used just as Michael suggested, adjusting for the correct
interest amount when the value is known.

I need to try that.

On Thu, Dec 16, 2021 at 12:55 PM Stephen M. Butler <
stephen.m.butle...@gmail.com> wrote:


On 12/16/21 10:05, Michael or Penny Novack wrote:

It might perhaps be better to describe WHAT you want to accomplish
instead of asking about possibilities for the first HOW that came to
your mind. Why? Because there might be other "hows" even simpler.


On 12/16/2021 2:25 AM, AC wrote:

For example, I have a couple loans that are paid fixed amounts each
month but the split of principal and interest varies (of course). I
have automatic payments at the bank set up to pay those fixed amounts
regularly and I have a matching scheduled transaction in GnuCash that
is a placeholder for it so I know how much comes out of my checking
account. What I don't know at that moment is the split between
principal and interest.

I'll reword that -- you don't have access (in advance) to the
amortization schedule and even if you did, would not help with an
automated transaction (but would if a manual transaction_

   When the payment has gone through I will check the loan records
wherever the loan is held to see how they distributed the payment and
then go back and update the splits to reflect that.

I do a similar thing for my paychecks, setting up a scheduled
transaction with an estimated amount across splits and then go back
to update the splits with the various amounts withheld from the check
(I mark these as "Deposit").

Let's stop here for a second to describe your PROCESS. In either case,
you first need to be able to have an automatic transaction (unsplit)
that you later need to go back to in order to split once you have the
information to do that. You think you need a "marker" of some sort to
find the transaction later, to mark the ones you have not yet done.

But what was the other side of the transaction?. Let's do the loan one
first. That was an automatic (scheduled) transaction, credit to your
bank account and debit to (there are always tow sides in double entry
bookkeeping) what? Let's say for am moment you had an account under
Expense with a name like "unallocated loan payments".

Every so often you look. Is the balance of this account zero? No, then
you have a loan payment you have not yet allocated to principle and
interest. Assuming enough time has passed that you have that
information, Enter split mode. Change the account "unallocated loan
payments" to "interest" and the amount to what that portion is. The
remainder will now have an account Imbalance which you change to "loan
principle".

Now THAT transaction will no longer appear in "unallocated loan
payments" << and if there are no other payments still not allocated
the balance of the account  will be zero >>

In  other words, the very presence of a transaction in "unallocated
loan balance" can serve as your "marker" and is the transaction you
want to split. You can do the same for your paychecks, except you
would use an account under Income "unallocated paychecks".

Michael D Novack


Why not point to the loan wizard and how it can setup an automated
transaction schedule?  Sure, it is off a few pennies every so often but
if a person is looking at the loan details a their bank (or get a
monthly statement) it is easy to adjust the existing transactions.

Once you understand the resulting schedule formula, you can modify for
extra monthly payments and won't need the wizard to setup the next loan.

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

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, 

Re: [GNC] new subaccounts and updating saved reports

[David T. via gnucash-user]

My experience matches that of George, and I don't see how changing the levels 
could gather a new account into the report. 

The issue has been raised before recently, although I couldn't track it down. 
Short of rewriting the report code to re-evaluate the account set every time a 
report is run, I can't see how to fix the problem-- and even then, how would 
gnucash know when a given account should be added to any given report or not? 

There are plenty of use cases where a saved report includes a subset of 
accounts on purpose-- for example, when one wants a report that includes 
expenses for an isolated cost area (think rental properties). I might even 
hazard a guess that this would be one of the primary features of saved report 
configurations. The lists here have countless threads advising users to do just 
that. So automatically adding new subaccounts to existing reports could be 
detrimental for many users with saved reports. 

That's not to say that I haven't wished for some way to automate this aspect. I 
just don't see how you would implement it. 

David T.

On March 22, 2022 6:49:25 PM EDT, davidcousen...@gmail.com wrote:
>George
>
>Have you tried changing the number of sub-account levels in the report options?
>(Edit->Report Options with the report open). It may be possible that changing
>from the default level of 3 and/or changing the option to flatten the account
>structure (you can always change it back again if the result is not desirable)
>may force a reevaluation of the included accounts. Not sure if this will work
>but it may be worth a try. If you get the report showing the added accounts 
>then
>resave the report.
>
>David Cousens
>
>
> On Tue, 2022-03-22 at 11:53 -0700, George Riner wrote:
>> I am learning that when I add another subaccount to an account already 
>> has subaccounts and the account is already in several "saved report 
>> configurations" that I now have to go back through each and every one of 
>> my "saved report configurations" and update its Options to include that 
>> new subaccount.  It won't automatically include that new subaccount just 
>> because it's a subaccount of an account that's already selected in the 
>> options for those saved report configurations.
>> 
>> Is there a way to make it work that way?
>> 
>> :George
>> Platform: Windows 10 (64-bit) build 19044.1586 (32Gb RAM)
>> Gnucash: 4.9+(2021-12-18) English
>> Finance Quote: 1.51a
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] gnucash v 2.6.19 or newer on 32bit linux

[David T. via gnucash-user]

I think it would be helpful to know a bit more about the versions of Gnucash on 
the two machines. The message he got was that he needed *at least* 2.6.19, not 
that he needed to use it. 

Jonathan, does this imply that your older machine is running Ubuntu 16.04? The 
Gnucash wiki says that 16.04 had 2.6.12, while 18.04 had 2.6.19. The vintage of 
Ubuntu might affect your options here. 

And if your older system has a version greater than 2.6.19 on it, something 
else has gone wrong, and more info would be needed. 


On March 24, 2022 9:20:25 PM EDT, Adrien Monteleone 
 wrote:
>Caveat:
>
>You can have some dependency issues on that old machine that might 
>prevent building the current version or using Flatpak.
>
>I'd think you *should* be able to build 2.6.19 or 2.6.21 though. (2.6.21 
>was the last 2.6 version)
>
>Please do report back what you are able to accomplish.
>
>If nothing works, consider possibly using RDP or VNC to your 64bit 
>machine rather than a local install.
>
>Regards,
>Adrien
>
>On 3/24/22 8:00 PM, Adrien Monteleone wrote:
>> Jonathan,
>> 
>> You should be able to build a current version of Gnucash on your 32bit 
>> machine.
>> 
>> See the instructions here:
>> 
>> https://wiki.gnucash.org/wiki/Building
>> 
>> And you can update to current on your 64bit machine to match.
>> 
>> You might also be able to use the Flatpak if you don't want to build. 
>> (I'd try that first)
>> 
>> Regards,
>> Adrien
>> 
>> On 3/23/22 2:52 AM, Jonathan Francoeur wrote:
>>> I have my accounts in dropbox and I was using a newer version of GNU 
>>> cash on my 64bit computer.  Now I"m trying to use the files on my 
>>> older 32bit computer and I get the error:
>>>
>>>
>>> This Dataset contains features not supported by this version of 
>>> GnuCash. You must use a newer version of GnuCash in order to support 
>>> the following features:
>>> * Use account GUID as key for bayesian data and store KVP flat 
>>> (requires at least Gnucash 2.6.19)
>>>
>>>
>>> I have not been able to install the Gnucash 2.6.19 from the tar.gz 
>>> files.  I'm used to using .deb files on following instructions by copy 
>>> pasting in to the terminal.  I haven't found anything like that for 
>>> installing a newer version on GNU cash on a 32bit linux machine.  Any 
>>> ideas?
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] how to put loan downpayments in budgets

[David T. via gnucash-user]

I would imagine the down payment would go into an asset account. I.e., transfer 
from Assets:Savings into Assets: HouseValue? A down payment doesn't go into the 
liability. It is still your asset...

On March 29, 2022 7:05:07 PM EDT, davidcousen...@gmail.com wrote:
>Karin
>It is not an expense but a liability. When you open the Budget you can expand
>the liability accounts and enter budget amounts against the liability account
>for the loan/mortgage at the period the  payments are due. If necessary you can
>change the budget interval to suit. 
>
>A reduction in the balance of a liability account is a debit to it and a credit
>to your bank account just as when you enter an expense the increase in expenses
>is recorded as a debit and credit to the bank account. 
>
>David Cousens
>
>On Tue, 2022-03-29 at 20:56 +0200, Karin Lagesen wrote:
>> Hi!
>> 
>> I am trying to figure out how to put my mortgage downpayment into my
>> budget. It is not exactly an expense, but I do need to have income enough
>> each month to cover that in addition to expenses. I've tried googling to
>> see how to do this, but the parts of the manual I manage to find (and other
>> things) do not seem incredibly helpful on this, so any pointers are much
>> appreciated.
>> 
>> Thanks!
>> 
>> Karin
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report Help

[David T. via gnucash-user]

Another option would be to create a multicolumn report with two Account Summary 
reports side by side-- one set to the start date, the second to the end date. 

On March 21, 2022 9:24:14 PM EDT, Adrien Monteleone 
 wrote:
>The Account Summary is a snapshot, that's why it doesn't let you select 
>a range. (similar to a Balance Sheet)
>
>Your other options are an Income Statement/P (which won't show 
>anything but Expense & Income accounts) or perhaps an Equity Statement 
>or the Balance Sheet which includes Equity, Assets & Liabilities. (which 
>again, are snapshots and rolls Income/Expense into Equity)
>
>The closest to the Account Summary with a date range is the Trial 
>Balance Report. (be sure to set Account Depth to 'All' on the Accounts 
>tab in Options)
>
>You can get sort of close with a Transaction Report if you select all 
>accounts on the Accounts tab, clear everything *but* Account Name & 
>Totals on the Display tab, set your desired date range on the General 
>tab, and then select "Show subtotals only (hide transactional data)" on 
>the Sorting tab.
>
>Regards,
>Adrien
>
>On 3/19/22 10:39 AM, Brock Rycenga wrote:
>> Hello,
>> 
>> Looking for help with [custom] reports. I like the look of the Account
>> Summary report, but there is no way to fully customize the date range (only
>> a starting date, or ending date - not both). I like that report format the
>> best because it shows the account hierarchy with a total for the top level
>> of any account with sub-accounts. Anyone know how to do this with a
>> transactional report? Is there another report I should start with to get
>> the look/feel of the Account Summary report, but with a fully custom date
>> range?
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report Help

[David T. via gnucash-user]

What are you talking about? What's broken? The page? A link? Custom reports? 

On March 20, 2022 12:34:01 AM EDT, flywire  wrote:
>https://wiki.gnucash.org/wiki/Custom_Reports - it's broken when you get
>down into it.
>
>There are two basic reports, the transaction report, and most of the
>others are based on the income and expense report.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Report Help

[David T. via gnucash-user]

Well, I see that you put a note in that section saying it didn't work in 4.6 
last September, so you are already aware of this fact. 

Since in my 17 years (!) of using gnucash I have never succeeded in creating or 
even loading a custom report-- and believe me, there were times when I really 
tried--I will not attempt to offer you advice with your custom report problem, 
whatever it may turn out to be. 

I *will* say that you'll have better success if you tell people what you're 
trying to accomplish, and what specifically the problem is that you've 
encountered. Telling us the page is broken is just noise and serves no purpose. 

It's clear from the page history that you know how that content came into being 
(i.e., Gnucash users), and also how it can be changed. So once you figure out 
what does work, you can update the wiki for everyone else. 


On March 20, 2022 4:54:10 PM EDT, flywire  wrote:
>This:
>https://wiki.gnucash.org/wiki/Custom_Reports#Technique_to_reload_reports_without_restarting_GnuCash
>
>Except for the bash script the process works the same in Windows as linux.
>The code comments work well:
>https://github.com/Gnucash/gnucash/blob/maint/gnucash/report/reports/example/hello-world.scm
>
>On Mon, Mar 21, 2022 at 4:44 AM David T.  wrote:
>
>> What are you talking about? What's broken?
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Reconciliation discrepancies

[David T. via gnucash-user]

Reconciled entries *are* marked read only. If you aren't getting a notice on 
editing, it's because you told gnucash not to notify you any more. That can be 
reset somewhere in the preferences. 

David


On April 12, 2022 5:25:51 AM PDT, "R. Victor Klassen"  
wrote:
>I run into such issues once in every one or two blue moons.  The starting 
>balance is off.
>I’ve reconciled successfully the previous month, but something somehow 
>(dis)appeared in the meantime.  I assume it disappeared, although the symptoms 
>could be generated by something appearing.
>
>I hope it’s more than a year old, and live with it.  Meaning I do a balance 
>adjustment and move on.
>
>It’s disturbing, but the size of my file is such that I have no reasonable 
>means of tracking down whatever may have happened.
>
>Possible that it’s user error, but unlikely.  Possible that it results from 
>one of the periodic crashes I experience, or power failures, that appear to be 
>fully recovered from at the time.  Pretty much impossible to reproduce.
>If it is due to user error, that would be an argument in favour of the ability 
>to mark old transactions as read-only.  Yes I’m very aware that “read-only” 
>can be worked around.  But when it’s about protecting one from oneself, that 
>kind of read-only could be useful.  If it’s due to bit rot/power 
>glitches/crash recovery, not so much.
>
>> On Apr 12, 2022, at 6:09 AM, Liz  wrote:
>> 
>> On Mon, 11 Apr 2022 14:36:41 -0700 (PDT)
>> Rich Shepard  wrote:
>> 
>>> Every now and then one of my bank accounts doesn't reconcile because
>>> what the bank shows differs from what GnuCash shows. The amounts are
>>> significant. What puzzles me is that the previous month's balances
>>> (bank and GC) match and so do all the transactions. But, the end of
>>> month balances don't match.
>> 
>> Rich when I get into a mess, I do very small increments on the
>> reconcile. For example, just choosing a date about 10 transactions
>> down, or one week, and then I will go through very slowly, doing small
>> chunks. 
>> Assume this is one month, and I am doing weekly...
>> I find the bank's ending balance for 7th of month, put 7th of correct
>> month and the balance from the bank statement into the reconcile
>> dialogue, and check off that week's items from the bank statement. When
>> the residual is zero, I mark finished, and move forward to the 14th.
>> (Procedure loops)
>> 
>> By looking at such a small number of transactions it is possible to
>> find whatever the errors are.
>> I too have been on Gnucash for a couple of decades, but still found 4
>> errors in one file this March, payments not entered as received, and
>> digit transposition.
>> 
>> I hope you find what is happening and let us know.
>> 
>> liz
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> If you are using Nabble or Gmane, please see 
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Transaction Imports

[David T. via gnucash-user]

Further to this: you care about how much money something cost (the amount you 
have spent), and how much you got for it (the amount of shares you purchased). 
The first affects how much money you have in your bank account, the second 
affects how many shares show in your mutual fund.

On April 11, 2022 8:16:06 PM EDT, Stu Perlman  wrote:
>Thank for the heads up.
>
>On Mon, Apr 11, 2022 at 3:03 PM D  wrote:
>
>> Not going to go into great detail here, but you definitely DON'T want to
>> have gnucash calculate shares. Have it calculate price.
>> On Apr 11, 2022, at 11:21, Stu Perlman  wrote:
>>>
>>> Hello Everyone,
>>>
>>> I am looking for some guidance on how to import a few hundred transactions
>>> from my 401(k) account.
>>> Unfortunately, the plan administrator does not offer a good option for
>>> exporting the transaction data but I am able to get what I need with some
>>> basic web scraping.
>>>
>>> I have been experimenting with creating a multi-split CSV import from the
>>> data that I have captured.
>>> What I wanted to do was a file layout such as:
>>>
>>> *Date,Description,Account,Deposit,SharesAsMemo,Price*
>>> 01/04/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.916289038,326.6
>>> 01/19/2021,Contribution,Cash,-299.26
>>> ,,Vanguard Institutional Index Institutional Fund,299.26,0.892008703,335.49
>>>
>>>
>>> My wishful thinking was that I could put the number of shares into the memo
>>> column for reference (but that the system would auto-calculate that number
>>> using the provided Price and transaction amount ("Deposit")).
>>> I hit a blocker on the second to last step of the import wizard with the
>>> message: "*The account 'Vanguard Institutional Index Fund' has a different
>>> commodity to the one required, 'US Dollar'. Please choose a different
>>> account.*"
>>>
>>> So I'm wondering if there are other ways I can go about what I'm trying to
>>> accomplish?  I started with the CSV importer because I figured it would be
>>> the easiest record layout to create but I'm not against using a different
>>> format if what I want to accomplish can be done.
>>>
>>> I have a backup plan which is that I will NOT do the multi-split import and
>>> will just select the Cash account for all rows in the Import Preview
>>> screen. I could pack the memo field with the ticker symbol, price,
>>> quantity, and total debit and let it all dump into the Imbalance-USD
>>> account. I would then have to either manually fix them one by one or
>>> possibly script it out.  I have done this with success in the past but
>>> would rather just get it right at the data import step if that's in any
>>> way possible.
>>>
>>> My thanks in advance for any advice offered.
>>>
>>> - Stu
>>> --
>>>
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> To update your subscription preferences or to unsubscribe:
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> If you are using Nabble or Gmane, please see 
>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>> -
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>>
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] Unusual book need

[David T. via gnucash-user]

Jean,

Your assessment is about right, although I wouldn't characterize it as a 
shortcoming, just an area that requires manual intervention. 

Jeff, 

While it may seem onerous to consider, it turns out that creating and deleting 
transactions is not that great an effort, given auto completion. If you open 
both sets of books and display them side by side, you can quickly work through 
your dad's file and add the transactions to your books. 

Once you are satisfied with the accuracy of the new transactions, you can 
delete them from your dad's books. Turning off the delete transaction 
confirmation for the session can speed that up significantly. 

It's possible to make, move, and delete hundreds of transactions in a short 
period of time. (This fact, coupled with the relative infrequency of needing to 
do this and the programming overhead involved is the reason why nobody has 
developed a tool for this.) 

David T.

On April 15, 2022 3:20:27 AM PDT, Jean Laroche  wrote:
>As far as I know, there's no easy way to delete a group of transactions, 
>I think that's one of the shortcomings of GC?
>You can do a search to find all of them using the right criterion but 
>I'm pretty sure after that you can't really do much with that (except 
>create a report which isn't useful for you).
>
>But maybe the experts know of a way.
>
>One useful feature would be the ability to delete/move transactions in a 
>search result, since GC does not allow selecting multiple transactions 
>and acting on them (to move them to a new account / delete them etc) 
>doing it on the result of a search could be a useful workaround.
>
>J
>
>
>On 4/15/22 11:00 AM, Jeff wrote:
>> I need to move transactions from from one set of books to another one.
>>
>> I didn't realize while entering transactions in my dads books that 
>> they should have gone into mine.  My dad opened a bank account that I 
>> did not know about until I started entering charges that my son made 
>> with feed stores (debit card).  I had not been informed about the bank 
>> account that grandpa opened in my sons name, and I am responsible for 
>> all of his income/debits until he is 21.  And many of these 
>> transactions affect my income/loss.
>>
>> Is there an easy way to move those entries from one journal to the 
>> other or will I have to find all of them and manually delete them from 
>> one journal and reenter them in mine?  These are separate journal files.
>>
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: [GNC] 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] 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] 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] New to GnuCash SQLite on Windows: I have questions

[David T. via gnucash-user]

On 4/21/2022 8:07 AM, Derek Atkins wrote:

HI,

On Thu, April 21, 2022 7:57 am, Chris Green wrote:

On Thu, Apr 21, 2022 at 07:20:51PM +1000,davidcousen...@gmail.com  wrote:

Chris,


[snip]

If I look in (one of) my Gnucash directories I see:-

 chris@esprimo$ ls
 building2022.gnucash
general2022.gnucash.-452605816.1384867.LNK
 building2022.gnucash.-452605816.1385351.LNK
general2022.gnucash.-452605816.4124828.LNK
 cheques  giftaid

[snip]

As an example of the sort of thing I would expect look at this:-

 chris@esprimo$ ls pcc
 Pass_Certificate.pdf   'TR takeaway Jeremiah.pdf'
auditedAc2019.pdf
 SpiritualityOfFundraising.pdf   Whoswho.docx
parishReturn2019.pdf

No long suffixes, obvious names and no backup/log files in the same
directory.

So you're complaining about 4 vs 7 characters in the suffix??  Seriously?

As for the logs/backups, I certainly see the point of storing those in a
"different" location, but ... where?  Keep in mind, this is financial
data, not some love-letter, so having an archive can be important.  So we
try very hard to ensure that we *CAN* make a backup, and the safest place
to ensure that is in the same place the data file is written.  But you're
right, we *could* make a subdir, like "gnucash-backups" and store the
files there.


This is an outstanding feature request:https://gnucash.uservoice.com/forums/101223-feature-request/suggestions/1470507-configuration-option-for-backup-location  
___

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

Re: [GNC] Tip of the day - dates

[David T. via gnucash-user]

I don't know what the tip currently says. The full information is placed in 
https://cvs.gnucash.org/docs/C/gnucash-guide/txns-shortcuts1.html. Honestly, I 
think tips are meant to suggest possibilities, rather than give exhaustive 
guidance. But that is just my opinion. 

I believe there's a place on the project git for managing the tips. You could 
suggest a change there. 

As for the implementation of the shortcuts, you'd have to change the code for 
that, I assume. I'd also assume it could be a minor change. I'll note that the 
increment functions behave the way you're describing (i.e., repeatedly invoking 
them keeps the dates changing). Changing this behavior would of necessity 
change how they are described as well. 

David T.



On April 23, 2022 11:23:49 AM EDT, Fred Tydeman  wrote:
>The Tip of the Day entry for dates should be expanded to include:
> M = beginning of Month
> H = end of montH
> Y = beginning of Year
> R = end of yeaR
>Are there any others?
>
>It would be nice if pressing MM went back two months,
>instead of doing M-M.  Same for HH instead of H+H.
>___
>gnucash-user mailing list
>gnucash-user@gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>If you are using Nabble or Gmane, please see 
>https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>-
>Please remember to CC this list on all your replies.
>You can do this by using Reply-To-List or Reply-All.
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.