Re: F::Q 1.40 uploaded

[David T. via gnucash-user]

Erik,

Thank you for working on a fix to the Yahoo! Finance problem. I am sure it has 
been a challenge.

As a general question to the GnuCash-users list: How do various GnuCash users 
upgrade their F::Q to use this newest version, and how should the environment 
variable be set? On my Mac, for example, trying to “upgrade Finance::Quote” 
from a CPAN shell tells me that F::Q is up to date, even though it is at 1.38. 
Moreover, if I export the variable at a terminal prompt, it seems to go away 
upon exit. I imagine I am not the only Mac user challenged by these points, and 
I don’t know what Windows users have to do at all. Some guidance would be 
greatly helpful!

David

> On Nov 6, 2017, at 12:17 AM, Erik Colson  wrote:
> 
> Hello,
> 
> F::Q 1.40 adds support for the symbol field for AlphaVantage.  This
> seems to be required for Gnucash users.
> 
> best
> --
> erik colson
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Bank reconciliation history

[David T. via gnucash-user]

Mark,

The simple answer is “No.” There isn’t any way from the GnuCash application to 
see which transactions were reconciled on which statements.

I believe that the GnuCash data file does store reconcile information in the 
data file, but that information is not exposed in the GUI. You might be able to 
save your data in SQL format and then open your data in an SQL tool that would 
allow you to create an SQL query to extract this information. But that is not 
for the faint of heart.

HTH,
David

> On Oct 30, 2017, at 3:00 PM, Mark Roworth via gnucash-user 
>  wrote:
> 
> Hi all,
> Is there anyway I can see a list of bank statements and which transactions 
> were reconciled to which statements? For the life of me I can't find it?
> Thanks for any help received,
> Mark 
> Mark roworthrowor...@yahoo.co.uk
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: help finding my file

[David T. via gnucash-user]

Lorrie,
With regard to the files on the desktop, David Carlson's advice is sound.
As for keeping the app on your computer, I suspect that you were opening 
gnucash from the downloaded disk image; you must drag gnucash.app from that 
image into the Applications folder to complete the installation. 
David 

 
 
  On Fri, Oct 20, 2017 at 16:32, David Carlson 
wrote:   Lorrie, you should have replied to All because I do not have a Mac, 
and I
cannot help you.  Others here can.

David C

On Fri, Oct 20, 2017 at 12:32 AM, Lorrie E Clemens 
wrote:

> Hi David,
> No, I have a Mac.
> Lorrie
>
> On Thu, Oct 19, 2017 at 8:49 PM, David Carlson <
> david.carlson@gmail.com> wrote:
>
>> Hi Lorrie,
>>
>> Welcome to GnuCash.
>>
>> For this discussion I am assuming that you have installed GnuCash onto a
>> Windows computer.  You only need to do that once.
>>
>> First, create a folder under My Documents called LorrieGnuCashData or
>> something like that.
>>
>> If you have your file explorer set to show file extensions then your
>> Gnucash data files will have .gnucash extension or .gnucash with a 14 digit
>> number and either a .log or .gnucash extension.  yes, there are a lot of
>> them but they are all backups except for the newest one with the short
>> extension name, which is your actual data file.  There is a setting for how
>> long to keep the backups.  You will want to make a separate backup now and
>> then for the day that your hard drive fails.
>>
>> Then undelete all those files that GnuCash cluttered up your desktop with
>> and move them to to that new folder.
>>
>> Finally, pick the newest file that has a simple .gnucash file extension
>> and double click on it.
>>
>> Thereafter you can either double click that filename or the GnuCash Icon.
>>
>> David C
>>
>> On Thu, Oct 19, 2017 at 7:45 PM, Lorrie E Clemens 
>> wrote:
>>
>>> Hello,
>>> I am new to GnuCash.
>>> I was able to download all of my information and balance my accounts
>>> earlier this month and I did make a copy.
>>> While I was doing all of the input I ended up having a lot of GnuCash
>>> folders on my desk top.  I put them into the trash but have not deleted
>>> them.
>>> I wanted to put in more payments today, but I am not sure how to access
>>> my
>>> data.  If I click on Gnucash-Intel it cannot pull up my account.
>>> So I do I get back into my account and how do I prevent scores of GnuCash
>>> folders from downloading on my desktop?  Also, how do I install the
>>> GnuCash
>>> app so that it stays on my computer?  Or do I have to go on line to
>>> reinstall every time?
>>> Sincerely,
>>> Lorrie Clemens
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@gnucash.org
>>> 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
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
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: command line QIF import

[David T. via gnucash-user]

What do you mean "failed"? They aren't in the gnucash file at all? Or, they 
import incorrectly? 
If the latter, take a look at some of the transactions that failed; is there 
something in common?  In my Quicken data, it was transactions that had no 
categories that caused the most problems. Fill things in, try again and see 
what happens. Rinse and repeat until your data is clean enough, and pick up the 
rest afterwards. 
If they didn't import at all, I don't know what to say. 
David

 
 
  On Sun, Oct 15, 2017 at 22:50, Nelson wrote:   
Thank you for your answer David.

I am aware that QIF is a text file and I can open it in text editor. 

I have a 235000 lines QIF file created by quicken. Most of the transactions
are being imported properly but there are thousands failing as well. I have
no way to identify those failed transactions other than going line by line
in each account. What shall I "edit in quicken first" to insure a successful
import?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: importing

[David T. via gnucash-user]

Frank,

The *other* David suggested importing each account separately; I was suggesting 
importing all at once. In my (admittedly ancient) experience, I worked to get 
the Quicken data just so, and when I imported everything, I had little to no 
duplicates.

David (T.)

> On Oct 7, 2017, at 7:17 PM, Frankie Raney  wrote:
> 
> You are right as to what is being done When I import, it sees the 
> duplicates, but there are hundredsit would take forever to Mark themI 
> do not know how to export just one account at a timeI could try to figure 
> it out and try that way I guess.
> 
> On Oct 6, 2017 8:34 PM, "D"  > wrote:
> Frank,
> 
> Like the other David, on the other thread, it has been a while since I 
> imported from Quicken. When I did, I was able to bring in everything in one 
> huge pass. Gnucash properly created the many accounts and captured most of 
> the transfers as well.
> 
> Are you exporting each account from Quicken separately? It sounds as if you 
> are getting both sides of your transactions, i.e., the transfer payment from 
> checking to your credit card is being processed once for the checking and 
> once for the credit card. If this is what is happening for you, then there 
> are two solutions: either match the second version to the first during the 
> import process, or don't import the second transaction.
> 
> I seem to recall that I didn't have to do much manual massage to my large 
> quicken file when I imported way back when, so I believe that exporting the 
> whole file (accounts, categories and transactions for it all) will catch 
> those duplications. But I've been known to be wrong before.
> 
> David T.
> 
> On October 7, 2017, at 6:24 AM, frank raney  > wrote:
> 
> >I thought I had the importing figured out, but no...
> >I exported my quicken data to qif format.  When I import it into GC I get a 
> >lot of double entries.  Quicken uses catagories, GC uses accounts... How do 
> >I import my cash accounts without getting all the duplicates.
> >My checking account imports as do all my categories to the same accounts in 
> >GC.  I am given a list of possible duplicates, but it will take days to go 
> >through this.  Isn't there a way import without sorting through the list?  
> >If I do not go through the list (just import everything as is, I end up with 
> >every account with double entries, double money.  
> >I am trying to get away from quicken because of all the troubles they are 
> >having, but now I wonder if it is worth it.  I am always for programs like 
> >GC, but sometimes they are very cumbersome, like this appears to be.  What 
> >am I missing?
> >Frankie Raney
> >12454 Auberry Rd. 
> >
>  
> >Clovis,
>  Ca 
> .
> >559.297.8577  H
> >559.304.1751  C
> >---
> >This email has been checked for viruses by Avast antivirus software.
> >https://www.avast.com/antivirus 
> >___
> >gnucash-user mailing list
> >gnucash-user@gnucash.org 
> >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
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: Mac OS X and mouseclick

[David T. via gnucash-user]

Is there a window hiding off screen somewhere?

> On Oct 6, 2017, at 9:23 PM, Rich Harover  wrote:
> 
> Hello list from a newb.
> 
> GC is running fine for me on my MacBook Pro (Mac OS X 10.12.6).
> 
> I installed v 2.6.18 and tried to run on my iMac (Retina 5k, late 2015 model 
> running OS X 10.12.6), and while the program launches just fine, it won't 
> register any mouse clicks of any kind.  In fact, I have to kill the program 
> to quit.
> 
> Any thoughts or advice is appreciated.
> 
> Thanks,
> 
> R
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Can't print checks or reports using gnucash

[David T. via gnucash-user]

Walter,

I am not an expert, but the error kind of sounds like maybe Perl isn’t properly 
(re) installed?

David

> On Oct 3, 2017, at 1:19 AM, Walter Cinsavich  wrote:
> 
> I had a major windows 10 64 bit error. It was necessary to do a major
> recovery process of windows 10. All programs and apps were lost during the
> windows recovery. However, my gnucash data was saved. After the recovery
> was performed, I had to reinstall Gnucash. All my gnucash data was
> recovered and in good shape. Since the recovery, I cannot print any checks
> or reports. Everytime I execute a print command, blank data is sent to the
> print. The printer gets the alert to print but nothing is available to
> print. I am using gnucash 2.6.18. The trace log is as follows:
> * 10:30:16  WARN  Could not spawn perl: Failed to execute
> child process (No such file or directory)
> Can anyone help me?
> walter
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Report Question

[David T. via gnucash-user]

Mike,

I think the question is more about the report and how it aggregates 
information, rather than how the accounts are structured (although, of course 
that too can affect things). As Christopher Lam replied to the original 
poster’s posting of this on Saturday, the likely answer is to change the 
settings on the report to increase the number of bars in the report, or to do 
as Maf suggests, and reduce the accounts selected for the report.

Joe, did you try what Christopher suggested on Saturday, when you posted this 
originally? If not, why did you post the question again?

David

> On Oct 2, 2017, at 6:01 PM, Mike or Penny Novack 
>  wrote:
> 
> On 10/2/2017 4:42 AM, Joseph Hesse wrote:
>> Hi,
>> I am using the latest version 2.6.17 of gnucash.  I just ran the report 
>> "Expense Over Time = Expense Barchart" with the maximum number of vertical 
>> bars selected. The report lists all my expense items including one called 
>> "Other". Since the amount of "Other" is high, I would like to get a 
>> breakdown of the expense items included under "Other".
>> 
>> Is there a way to do this?
>> 
>> Thank you,
>> Joe Hesse 
> 
> Yes of course there is, you set up your CoA for as many categories of 
> expenses as you like.
> 
> Step back a moment and think about this problem. Suppose you had NO sub 
> accounts under "expense" (all lumped together). You would then have this 
> problem with ALL of your expenses. So you decided to have some number of sub 
> accounts that let you characterize (group) like expenses and then a bucket 
> "other" for those you choose not to categorize/group because totally 
> unrelated and/or unimportant.
> 
> At some later time, you realize that a number of transactions in this "other" 
> account ARE related* and so you want them grouped also. Then DO THAT. Create 
> a new expense sub account for those and move them there << The technically 
> correct procedure would be to create a "correcting transaction" to do that 
> but you will perhaps choose to edit the existing transactions >>
> 
> When you create your books, you will be very unlikely to know all of the 
> accounts you will eventually need or want.
> 
> Michael D Novack
> 
> * Or maybe just one, but clearly so important/significant to your finances 
> that you want it clearly listed instead of buried in a miscellaneous category.
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Default terms

[David T. via gnucash-user]

> On Sep 30, 2017, at 3:31 PM, Geert Janssens <geert.gnuc...@kobaltwit.be> 
> wrote:
> 
> On zaterdag 30 september 2017 12:17:11 CEST Maf. King wrote:
>> On Saturday, 30 September 2017 10:15:29 BST David T. via gnucash-user wrote:
>>> Bob,
>>> 
>>> I’m no expert, but the Guide at 14.5 says:
>>> 
>>> "You can specify the billing terms on each invoice/bill. Invoice billing
>>> terms will default from the customer billing terms. Bill billing terms
>>> will
>>> default from the vendor billing terms.”
>>> 
>>> It makes no statement about setting up default terms for customers,
>>> however. To me, that would imply that you had to set each customer up
>>> with terms yourself, unfortunately. That sounds like it would be a useful
>>> enhancement, though.
>>> 
>>> I will let others, who use the business features expand on my answer.
>> 
>> Hi,
>> 
>> Indeed, the "new customer" dialog (and, by extension I presume, but haven't
>> actually checked, the Edit Customer box)  allows for a default terms
>> setting. It is on the 2nd tab, "billing information"
>> 
>> HTH,
>> Maf.
> 
> That's right. However what is missing is a book wide setting similar to how 
> you can set a book wide default for which tax table to use by default for 
> bills and invoices (in File->Properties->Business). So you have to remember 
> to 
> set a term each time you create a new customer/vendor.
> 
> Geert

…which I believe the original poster was after—a default that would preclude 
his having to set terms for every new customer he was creating.

David

> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Default terms

[David T. via gnucash-user]

Bob,

I’m no expert, but the Guide at 14.5 says:

"You can specify the billing terms on each invoice/bill. Invoice billing terms 
will default from the customer billing terms. Bill billing terms will default 
from the vendor billing terms.”

It makes no statement about setting up default terms for customers, however. To 
me, that would imply that you had to set each customer up with terms yourself, 
unfortunately. That sounds like it would be a useful enhancement, though. 

I will let others, who use the business features expand on my answer.

David


> On Sep 29, 2017, at 7:28 PM, Bob Brush  wrote:
> 
> Is there a way to make new customers or vendors automatically have terms set 
> to a default?  And is there a way to set all existing customers to a default 
> terms?
> 
> Thanks, Bob
> 
> Raleigh Tile of Beckley ** West Virginia
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Basic Register - Removing Unwanted Columns

[David T. via gnucash-user]

With regard to Debit/Credit: common use of these terms is not the same as use 
in formal accounting. Take a look at the Guide beginning at 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-accounting1.html 


Cheers,
David

> On Sep 13, 2017, at 7:48 PM, Fross, Michael  wrote:
> 
> Keith,
> 
> I unchecked "Use Formal Accounting Labels" in the Preferences Accounts
> tab.  This confused me as well, but the new "Deposit" "Withdrawal" make a
> lot more sense to me.
> 
> I'm interested to hear how this is correct in accounting speak.
> 
> Michael
> 
> On Wed, Sep 13, 2017 at 9:37 AM, Keith Winans  wrote:
> 
>> I only want to use the gnucash register to keep track of my deposits and
>> payments.
>> I would like to remove 'Num, Transfer, and R' from the list of columns.
>> Is there any way to do this?
>> 
>> Also, the Debit and Credit columns seem to me to be backward.
>> I enter a deposit in the Credit column and it comes out as a negative.
>> I enter a payment in the Debit column and it comes in as a deposit.
>> Please clarify this for me please, this is my first time to use a check
>> register program.
>> Thanks,
>> Keith
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
> 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
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: custom reports: guile or eguile

[David T. via gnucash-user]

The referenced reports can be found in the list archives.
 
 
  On Mon, Sep 11, 2017 at 13:54, Dennis Powless wrote:   
Where did u find the report?

D

Sent from my iPhone

> On Sep 11, 2017, at 4:37 AM, Gour  wrote:
> 
> Hello,
> 
> thanks to reports written by Doug Doughty I've become inspired to definitely
> stay with Gnucash and learn to write some custom reports, but wonder whether
> how much can be done with Eguile or it is recommended to use Guile considering
> the current status and/or further development of Eguile?
> 
> 
> Sincerely,
> Gour
> 
> -- 
> Even a man of knowledge acts according to his own nature, for
> everyone follows the nature he has acquired from the three modes.
> What can repression accomplish?
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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
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: Add icon for "Get Transactions..."

[David T. via gnucash-user]

Drew,

As I understand it, there is no facility to customize the toolbars in GnuCash, 
since the underlying toolkit, gtk, doesn’t offer it. At least, that is what I 
was told when I asked a similar question a couple of years back.

Sorry. As Derek noted, patches to enable this would be welcomed.

David

> On Sep 8, 2017, at 7:03 PM, Drew H.  wrote:
> 
> Thanks for replying, David. I’m referring to “Actions -> Online Actions -> 
> Get Transactions” when you’re in a bank register. It would be nice to just 
> click a button rather than navigate the menu. Thanks!
>   <>
> From: David T. [mailto:sunfis...@yahoo.com ] 
> Sent: Friday, September 8, 2017 7:12 AM
> To: dre...@outlook.com ; gnucash-user@gnucash.org 
> 
> Subject: Re: Add icon for "Get Transactions..."
>  
> Drew, 
>  
> I'm not sure what suggestion you are talking about. Could you supply some 
> context? 
>  
> David
>  
> P.S. Use Google to search the list archives. 
> 
>  
> On Fri, Sep 8, 2017 at 16:13, Drew H.
> > wrote:
> I tried to search the archives to find anything regarding this suggestion but 
> the link is broken. Any ideas on when/if it could be implemented? Thanks!
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org 
> 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
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: Add icon for "Get Transactions..."

[David T. via gnucash-user]

Drew, 
I'm not sure what suggestion you are talking about. Could you supply some 
context? 
David
P.S. Use Google to search the list archives. 

 
 
  On Fri, Sep 8, 2017 at 16:13, Drew H. wrote:   I tried to 
search the archives to find anything regarding this suggestion but the link is 
broken. Any ideas on when/if it could be implemented? Thanks!
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Reports with Month-end rather that Month-start

[David T. via gnucash-user]

Ken,

I don’t know where in the code base you want to look—but I will note that “the 
last day of the month” is more difficult to calculate than “the first day of 
the month.” The first day is always number 1; the last day varies month to 
month. I know some software packages make use of a conceptual "zero day of a 
month” to equate to the day before the first, but I do not know whether that 
convention applies in the GnuCash/Scheme. Not being a GnuCash programmer, I’ll 
let someone else with more experience weigh in.

David

> On Sep 5, 2017, at 7:47 PM, km22  wrote:
> 
> Hi Gnucash community,
> 
> I want to start editing -- and eventually creating -- my own reports and
> figures.  I think one place for me to start learning is by playing with
> some existing report settings -- such as the report date functionality. 
> Currently when I run a report with a "monthly" period I get the 1st day
> of each month.  How could I edit the report settings so I get the last
> day of each month instead?  (I am a Windows 7 user if that makes a
> difference on where to find/edit files.)
> 
> Thanks,
> 
> Ken
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: New user

[David T. via gnucash-user]

John,  Peter, 
Whatever the reason for Morris to want this (I, for example occasionally want 
to see all the payments to/from one payee), the fact remains that GnuCash 
already offers this functionality, although it is buried in View->Sort by (our 
whatever that menu option is).
So, Morris is mostly asking for an interface improvement to make using this 
feature more accessible. Frankly, I think it might make sense. 
David

 
 
  On Sat, Sep 2, 2017 at 8:01, prl wrote:   In addition to 
John Ralls' comments, what do you want to achieve by 
doing a sort on the description?

Would it be better achieved by doing a search on the register (which can 
be case-insensitive), or by looking at the register that contains the 
other split in the transactions of interest (resp. registers that 
contain the other splits)? Does it indicate that your chart of accounts 
doesn't match your needs?

Cheers,
Peter

On 1/09/2017 01:54, morris hindle wrote:
> Please direct me to the proper place to ask these questions:
>
> 1) When I do a sort (for example) on Description, it is apparently case
> sensitive. No one does case sensitive search or sort anymore. How do I set
> the sort to be case (and diacritic) insensitive?
> 2) Pretty much all spreadsheet-like software these days does a sort if you
> click on the column name at the top (Excel comes to mind). Gnucash seems
> not to do that. Is that a design decision? Or just something that has not
> been implemented yet?
>
> Thanks,
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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
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: Version Migration

[David T. via gnucash-user]

The biggest problem with the database back end is users' misconception that its 
use implies database functionality. They think it will allow them to perform 
database actions on the data set,  as well as have multiple users 
simultaneously. As you know, neither of these is true at this time. 
David

 
 
  On Wed, Aug 30, 2017 at 1:04, Colin Law wrote:   On 29 
August 2017 at 19:12, D  wrote:
> ...
> The database back end is stable, and has been for a while now. There is
> nothing to prevent a user from making use of it, even for production.

OK, but note the OP is going to use 2.6.15, which was released in Dec
2016 I believe. I don't know whether there have been any significant
sql related bugs since then.

Even if not, then it cannot be denied that the xml backend has had
vastly more use than the sql backend. Certainly anyone using a db
should make sure they take regular backups of the db (which can be
trickier than just copying the xml file).

Colin  
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: OFX data file question

[David T. via gnucash-user]

http://www.ofx.net/

 
 
  On Wed, Aug 16, 2017 at 17:12, Jeffrey Black 
wrote:   I'm not sure where to look to find this information.  I am looking for 
a
description/list of the  fields GnuCash uses or rather needs out of
OFX/QFX files.

I am tired of GnuCash screaming at me on any of the ofx/qfx transactions it
imports if I miss keying in a receipt.

Every transaction I miss keying in it screams :"HEY IDIOT YOU HAVE AN OFX
TRANSACTION HERE FROM ONO MARIO CAS".  Since we are pretty much creatures of
habit I know that the transaction is :"Casey's Marionvile Farm Fuel".  I do
not need 9 leading zeroes on check numbers, lop em off.  Checks posted
electronically at Wally World have a check number in the  field, find
it put it in the  field.  I habitually put "txfr", "dbt" and  "eft"
in check number fields.  Same problem with credit cards, the fields are all
upper case, that is as far as I am concerned screaming.


I managed to learn enough Perl to rewrite Lloyd's Perl script for PayPal
csv2qif to give me qif files I could use to fairly easily make sense of the
mess my wife makes of business and personal accounts with PayPal.  Now I am
working on trying to make ofx/qfx files that shall we say are more "pretty".

The problem is I am not good enough with Perl, yet, to put all the fields
the script reads in back in the output file in the right order unless I am
specifically look for them,  or I have to add one (like adding ).

What I need to know is where to find what fields GnuCash's importer expects
to find in a credit card type file and in a bank file.  Can anyone out there
tell me where to go..eh rephrase that.  Where can I find the information on
what the importer thinks it needs to properly import an ofx/qfx file?

--JEffrey Black M.B.A.

I'm beginning to wish I had just fired up a Pascal or COBOL compiler and
been done with it but; gotta do something to keep these old brain cells
learning new tricks.





--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/OFX-data-file-question-tp4693310.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Exporting custom made reports

[David T. via gnucash-user]

Try looking at:

https://www.gnucash.org/docs/v2.6/C/gnucash-guide/basics-migrate-settings.html 


> On Jul 27, 2017, at 11:11 PM, Martijn Heuts  wrote:
> 
> Hello, I just setup GNU cash to a different computer, I was able to get 
> everything back on the new computerhowever I don't see my custom created 
> reports. 
> Can anyone tell me how to export/import them?
> Thanks and have a great day!
> Martijn
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Scheduled transactions editor does not include ACTION feature | Use Bugzilla

[David T. via gnucash-user]

That peach colored area threw me as well; it is the main difference between the 
editor and a register. That was what I referred to earlier. Glad you got it 
figured out. 

 
 
  On Tue, Jul 25, 2017 at 7:45, aegross wrote:   Fred Bone 
wrote
>  
> This seems strange. Using 2.6.17 on Windows, I did this: 

I upgraded to .17 on my Mac and the ACTION field is working fine.  That
said, I may have been all along clicking in the peach colored area instead
of the green colored area -- a true PEBKAC error.

Thanks for your assistance!

Andrew

 




--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-transactions-editor-does-not-include-ACTION-feature-Use-Bugzilla-tp4692761p4692811.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Unsubcribe

[David T. via gnucash-user]

Then do it. The power is in your hands!

> On Jul 24, 2017, at 9:45 PM, Uma Ananth  wrote:
> 
> I have a similar request. Please unsubscribe uma...@gmail.com
> Thanks
> Uma
> On Jul 24, 2017 7:51 AM, "Ashwin A"  wrote:
> 
>> Request you to unsubscribe agentash...@gmail.com from the mailing lists
>> 
>> --
>> Ashwin A
>> 31- 687 14 5363
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> 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
> 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
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: Scheduled transactions editor does not include ACTION feature | Use Bugzilla

[David T. via gnucash-user]

Andrew, 
I believe that you and I are talking about the same field, and that you are NOT 
talking about the Actions menu,  which Dave H. was talking about. 
I specifically said the action field in a _transaction_; whether that 
transaction is in a register or the transaction editor should be, I believe,  
immaterial. If there is a behavioral difference between them, that would be an 
issue. 
That was why I asked you what specific steps you were taking to arrive at this 
conclusion, to see if the problem can be reproduced. 

Again, taking into account that I don't use scheduled transactions much, I do 
recall that the transaction editor is slightly different from a normal 
register, and that there is an extra line that is not present in a normal 
register. That confused me the few times I tried to edit transactions there. 
I should add that the devs say they prefer noting enhancements either in 
Bugzilla or on Uservoice, precisely because requests on the lists get lost. I'm 
not sure there is a clear delineation of when to use which. 
Cheers, David 
 
 
  On Mon, Jul 24, 2017 at 7:55, aegross wrote:   GnuCash - 
User mailing list wrote
> the Action field in a given transaction. 

I am **not** talking about the ACTION  field in any particular account
register.  Rather,  once a scheduled transaction has been setup; if that
transaction is going to be edited, it needs to be edited in the Scheduled
Transaction Editor.  I am saying that in that Editor, the action field does
not work.    This is **somewhat** similar to Bugzilla bug 776564 where the
notes field had a problem **in the Editor**. 


GnuCash - User mailing list wrote
> re few extra developer cycles for edge cases.

Totally understood!  Just wanted to know where to record my 2 cents.

Best,
AEG





--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Scheduled-transactions-editor-does-not-include-ACTION-feature-Use-Bugzilla-tp4692761p4692788.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Manually Post Scheduled Transactions

[David T. via gnucash-user]

Have you looked at section 4.5 of the Tutorial and Concepts Guide? 
https://www.gnucash.org/docs/v2.6/C/gnucash-guide/txns-sxn1.html 


Let us know what that fails to cover.

David

> On Jul 23, 2017, at 10:54 PM, pfwoolver...@juno.com wrote:
> 
> I am struggling with Schedule in GC 2.6.16.  I want to manually post 
> scheduled transactions and have the transactions show dates I select.
> 
> I reviewed the Concepts Guide and the Help Manual, and searched the user 
> archives without success.  I have bits and pieces, but still do not 
> understand how to manually post the transactions.
> 
> My prior experience is with MS Money 3.0.  MS Money shows a window with a 
> list of future transactions.  To post a transaction in MS Money, I select it 
> and update fields such as date, amount, and memo.  Then I enter the 
> transaction.  The transaction is posted and a new, future transaction is 
> created in the list.
> 
> I would like step-by-step instructions on how to manually post a scheduled 
> transaction starting with a transaction which is not set to be created by GC. 
>  Is there a source for such instructions?
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Tracking a TIAA mixed fund account

[David T. via gnucash-user]

I may be misunderstanding,  but it seems like the following would work:
Assets:TIAA (cash)Assets:TIAA:Lifecycle 1 (commodity)Assets:TIAA:Lifecycle 2 
(commodity)Assets:TIAA:TIAA Mutual Fund (commodity)
My experience of the so called "Lifecycle" funds is that they are just like any 
other mutual funds. 
When I handle payroll deductions, the dollars go into the cash account, and a 
separate purchase transaction moves the cash into fund shares. It's a little 
cumbersome, but it allows me to ensure that the right numbers get in. 
HTH, David
 
 
  On Sun, Jul 23, 2017 at 8:38, AC wrote:   I want to 
start tracking my TIAA retirement portfolio for informational
purposes (no reporting needs, filings, etc.) but I need some suggestions
on structuring the account trees so that it doesn't affect my existing
accounts.  However, possibly later I'll edit things so that the paycheck
contributions are directed accordingly so I'd want the new accounts to
allow that eventually (i.e. for now I'll add contributions manually
using a virtual source and eventually go back through and move those to
withdraw from my paycheck, the amount withheld is already accounted)

The trick with my TIAA portfolio is that it has three different products
within it.  Two of them are TIAA funds (one of the lifecycle multi-asset
funds) that does not have a breakdown of the individual holdings (like a
mutual fund).  These two only document the employer contributions, my
contributions, shares and interest/dividends.  The third product is a
TIAA mutual fund for which the individual holdings are broken out with
all the same data as a typical mutual fund (shares, prices, etc.)

What I expect to have is some type of top-level account that tracks the
overall value of the portfolio in dollars and then either within that or
somewhere nearby an account or account tree for each of the three
products.  At first I had considered just making the two TIAA funds into
an account that was basically a mutual fund with a single holding but I
wasn't quite sure how to combine that with the one real mutual fund when
each of the three funds receives different amounts of contributions and
individual dividends.  Perhaps it would be a top-level account then
three sub-accounts that are all mutual funds with two of them having one
holding and the last is the broken out holding?

I don't plan on using this for any official reporting (I get those
documents already), and I don't plan on downloading statements, quotes,
or anything else.  I'll just manually track things as my statements come
in and I enter the data from those, perhaps updating symbol share prices
manually if I'm interested at a particular time.  I don't currently use
much reporting as is with my existing accounts except an occasional cash
flow report so as long as that isn't affected I'm fine.  I do currently
have a mutual fund being tracked so I want to be careful not to cause
trouble for that either.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Flash Drive

[David T. via gnucash-user]

Christoph,
Portable apps,  I believe, is Windows only; John was working with Linux. But 
portable apps could help some others. 
David

 
 
  On Mon, Jul 17, 2017 at 11:43, Christoph R 
wrote:   Hi John,
even if you gave up on the topic I would like to point you to: 
https://portableapps.com/de/apps/office/gnucash_portable. 
I did not use it for a while but it worked for me nicely with an older version.

Cheers,
Christoph

Am 15.07.2017 um 21:31 schrieb John Wright :
David,

I have pretty much given up on that idea, as you said its a very complex 
approach, and to be honest, probably not worth the time for the benefit.  I saw 
the space used on the hard drive, and yes I do have enough space for that, so I 
think I will store the data on the flash drive and run the app from the hard 
drive.  As you said, that's a pretty trivial thing to do and won't take a lot 
of time.

Thanks.

John


On 07/15/2017 12:19 AM, David T. wrote:

John,

I seem to have misunderstood. I thought you said you were only trying to store 
the data file on the flash drive; this sounds like you are trying to store the 
entire application there.

Storing the data file is trivial, but trying to load the entire application is 
another story. Since I am not a Linux guy, I will defer to the comments made 
here by the others about the difficulties of running an application from 
removable storage.

Gnucash on my mac takes a total of about 175Mb of space. Surely that could fit 
in the limited space available to you? If that is still a stretch, you can 
probably delete some of the different language help files; the Japanese docs 
especially eat up a lot of space.

David


    On Sat, Jul 15, 2017 at 1:08, John Wright
     wrote:

    David,

    Yes, in fact I have gotten the error several times. My first
    attempt at running gnucash from a flash drive went this way. Installed 
it on the hard drive,  then moved all the gnucash files
    (except libs) to flash drive,  added a .desktop file to
    user/share/applications.  That worked ok, but I couldn't find the
    icon, and all the lib files were still on the hard drive.

    The reason I want to do this is that the laptop I just purchased
    has a 15GB m-stat sshd.  So I really don't have a lot of room to
    play with.  Sort of a throwback to the days when everything we ran
    was stored on floppy drives and either a very small hard drive or
    no hard drive at all.  Of course that was way before the internet.

    John


    On 07/14/2017 01:20 PM, David wrote:


    I guess it's lucky that John only wants to load his data from the
    flash drive, then.

    John, be aware that GnuCash always tries to load the last file it
    had open; if the folder isn't available when you fire it up, you
    will receive an error. Just be sure the USB stick is inserted and
    mounted before you start GC, and you should be fine.

    David



    
    *From:* David Carlson 
    
    *Sent:* Fri Jul 14 22:00:33 GMT+05:00 2017
    *To:* Robert Heller 
    
    *Cc:* "gnucash-user@gnucash.org"
     
    , John Wright
     
    *Subject:* Re: Flash Drive

    Perhaps this is not sensible, but I once experimented with installing
    Gnucash on a USB key configured as a Tails OS with persistent storage.
    That is based on Debian Linux.  It worked, but it was somewhat clumsy.  The
    nice thing is that all the data is completely encrypted and insulated from
    intruders, "sandboxed" if you will.

    David C

    On Fri, Jul 14, 2017 at 10:30 AM, Robert Heller 
  wrote:

    > At Fri, 14 Jul 2017 14:39:17 +0100 Colin Law  
  wrote:
    >
    > >
    > > On this list you have to use Reply All to reply otherwise the message
    > > just goes to the previous user (as this did). Forwarding this to the
    > > list for information.  Also see reply below.
    > >
    > > On 14 July 2017 at 12:31, John Wright  
  wrote:
    > > > Colin,
    > > >
    > > > Sorry for the confusion.  I what to just run gnucash from the flash
    > drive.
    > > > Fedora will be installed on the pc and gnucash as well as all the
    > gnucash
    > > > data will be on the flash drive.
    > >
    > > To be pedantic you don't want to run gnucash from the flash drive, you
    > > want to run gnucash from the HDD and write and read the accounts file
    > > to the removable drive, which should be no problem. Gnucash does not
    > > care where you save to and read from. If you 

Re: Copying many transactions

[David T. via gnucash-user]

Actually, the dividends DON'T have to go to the fund account. You could 
register the reinvestment as a dividend transaction (to a cash account), 
followed by a buy transaction. That is how I handle these. 
YMMV.
Best, David  

 
 
  On Sat, Jul 15, 2017 at 12:15, azalea4va wrote:   
GnuCash - User mailing list wrote
>  In other words, money comes from the income account (e.g.,
> Income:Dividends) and goes to the brokerage account (Assets:Brokerage) . I
> am not sure you need that second transaction at all.
> ...
> Without the second transaction, things get much simpler.

The dividends MUST go to the fund account, the questions is wether or not to
show them in the brokerage account.  I could just have Income:Dividends ->
Asset:Brokerage:Fund and that would be simpler.  The dividend MUST go to the
fund account because it is buying additional shares of that fund.  But if I
lack the in/out transaction fo the money going through the brokerage fund,
that account no longer matches what I see when I get a listing from the
brokerage company.  Also, by putting that information on the brokerage
account, I have one account that shows all money movement into and out of
that account.

So yes, I do not NEED the second transaction. Having it is a value
judgement.  Do I want simple or am I willing to deal with some complexity to
get a clearer view of what is happening?  Fortunately I was able to automate
the process using the shell script I mentioned in an earlier post,
eliminating much of the manual labor.



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Copying-many-transactions-tp4692519p4692692.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Transaction report - what are default accounts?

[David T. via gnucash-user]

If you are hoping to have your own account selections as a personal “default”, 
rename the report (on the General tab) and click "Save Report Configuration 
As.” Your custom settings will now be available under Reports->Saved Report 
Configurations.

HTH,
David

> On Jul 15, 2017, at 5:21 AM, Adrien Monteleone  
> wrote:
> 
> Yes, ‘default’ is the state of an option that is chosen by the programmers. 
> It is not your default, but theirs. So clicking it restores the options to 
> their original ‘default’ state.
> 
> Note, the button says ‘select’ default, not ‘set’ default. By clicking the 
> button, you are not telling GnuCash to “set these selections as my default” 
> rather you are telling the app to “select the default accounts” which are 
> none for the first option and expenses for the filter option.
> 
> Some applications allow you to set defaults or change them. At least in this 
> case, for these options, GnuCash does not allow this. (I’m not sure of any 
> other defaults you can change, but there are preferences you can set)
> 
> If you want to save your own account and filter selections to use again in 
> another run of the report, you need to use the ‘save configuration’ button, 
> give the customized report a name, and use that in the future instead of the 
> base report.
> 
> Regards,
> Adrien
> 
>> On Jul 14, 2017, at 11:18 AM, George Riner  wrote:
>> 
>> I don't get the behavior you describe.
>> 
>> I create a new Transaction report. I select a couple of entries in the 
>> 'Accounts' window and a couple entries in the 'Filter by' window and click 
>> 'Apply' and then 'OK' to dismiss the window.
>> 
>> I then re-open the Options window, click on 'Select Default' and all 
>> selections are cleared.
>> 
>> I find this a curious interpretation of the word 'Default'. From the way you 
>> describe it, the button would be more aptly named 'Revert to initial 
>> selections', or 'Cancel changes'.
>> 
>> :George
>> 
>> 
>> 
>> On 7/13/2017 9:14 AM, Adrien Monteleone wrote:
>>> You don’t notice them doing anything because you’ve already got the default 
>>> selected when you first bring up the report.
>>> 
>>> Try making some selections and applying, then bring up the options and 
>>> click the select default button, you’ll notice the selections switch to the 
>>> defaults, which is what you started with (hence ‘default’) which are 
>>> nothing selected for Accounts, and Expenses selected for Filter By.
>>> 
>>> 
>>> Regards,
>>> Adrien
>>> 
 On Jul 13, 2017, at 9:59 AM, George Riner  wrote:
 
 I've got Gnucash 2.6.17 on Windows 10.
 
 I'm selecting the "Transaction Report" from the Reports menu. This brings 
 up a blank report. Clicking on the "Options" button, it brings up the 
 "Transaction Report" dialog box. In the "Accounts" tab it shows the upper 
 list of accounts and the lower list of "Filter By...". Each of these lists 
 has a button beneath labeled "Select Default". Thinking that these buttons 
 might be a reasonable way to select accounts and filters, I click on the 
 "Select Default" buttons and as far as I can tell, nothing happens. No 
 selection states change in either list.
 
 What are these "Select Default" buttons supposed to do and where is it 
 explained? I can't find an explanation of these on-line.
 
 :George
 
 ___
 gnucash-user mailing list
 gnucash-user@gnucash.org
 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
>>> 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
>> 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
> 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
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:

[David T. via gnucash-user]

Kendall, 

I also see no problem:

david$ ./gnc-fq-dump yahoo ITOT
Finance::Quote fields Gnucash uses:
symbol: ITOT <=== required
  date: 07/11/2017   <=== recommended
  currency: USD  <=== required
  last: 55.3989  <=\   
   nav:  <=== one of these
 price: 55.3989  <=/
  timezone:  <=== optional

What quote source are you using?

David T.

> On Jul 11, 2017, at 10:08 PM, David Reiser  wrote:
> 
>> On Jul 11, 2017, at 12:37 PM, kendall.gr...@gmail.com wrote:
>> 
>> How do you get online quotes for ETF's such as iShare's ITOT, ISTB,
>> AGG, IEFA ?  they are listed sometimes as NYSEARCA:ITOT, but when I
>> enter this in the Security Editor under NYSE or enter just ITOT, for
>> example, I get the message about continue with good quotes with these
>> listed as the bad quotes.
>> 
>> -- 
>> Kendall B. Green D649DA6E
>> 
> yahoo finance has those quotes.
> 
> In the Security Editor for any of the ETFs, I selected “Single" as the Type 
> of Quote Source, and chose Yahoo USA as the source. 
> 
> Get Quotes raised no objections. Make sure the symbol is all caps, e.g. ITOT. 
> The NYSE or other designation does not matter with respect to retrieving 
> quotes. I also never used any prefix to the symbol.
> --
> Dave Reiser
> dbrei...@icloud.com
> 
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: When importing transactions, what happens to non-identical data in the description and notes fields?

[David T. via gnucash-user]

The importer includes three options: A, R and R+U. These mean:

A = add the transaction as new 
R+U =  reconcile the transaction with a matching transaction and update the 
existing GC transaction with the incoming data (description field etc.) 
R = Reconcile the incoming transaction with the existing transaction 

What you choose affects what you get.

HTH,
David

> On Jul 9, 2017, at 8:12 PM, pfwoolver...@juno.com wrote:
> 
> 
> I import transactions in QIF, GFX and CSV formats to GC 2.6.16.  When I 
> import transactions, GC proposes to match some of the imported transactions 
> with transactions in my file.  GC highlights these transactions in green.  
> These transactions do not have identical data in the date, description, and 
> notes fields.  What happens to the non-identical data in the description and 
> notes fields?  Which date survives the match.
> 
> Paul
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Reporting Repository ?

[David T. via gnucash-user]

John, 
I am curious now about the status of the various reports included with gnucash. 
There have been a number of well-constructed reports put together by Doug that 
seemingly could be added to the program, and there are some bugs suggesting 
removal or rearrangement of some of the current reports. Are any of these 
slated to be incorporated any time soon? 
David

 
 
  On Mon, Jul 3, 2017 at 8:33, John Ralls wrote:   

> On Jul 2, 2017, at 5:05 PM, aegross  wrote:
> 
> There isn't a reporting repository (for those who have written their own
> reports and would like to share), correct?  I found a few threads on this
> but nothing conclusive.

No, we don’t have a separate “contrib” repo because there’s never been any need 
for one. We could create a “src/reports/contributed_reports” directory in the 
gnucash repo to collect them, but contributors would have to submit pull 
requests to add to it. The current approach is for contributors to add reports 
to one of the existing report directories.

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Tracking Primary Residences

[David T. via gnucash-user]

Leo,

I am sorry you were having trouble getting messages to the list. I am glad you 
got that straightened out.

As to the point of tracking the value of your house, I’ll begin by saying I am 
not an accountant. However, I *have* been through the precise situation you 
describe, and I found out through experience the pointlessness of counting the 
value of my primary residence until it came time to sell that house. All of the 
interim values I entered as unrealized gains had no relation to the amount of 
money we ultimately received. The lesson I learned was that all that effort 
served only to make me feel worried/eager about how much value my house had 
lost/gained—with no actual effect on the final selling amount (which was 
neither as much nor as little as I had figured). 

This, coupled with the fact that you were asking how to prevent these numbers 
from skewing your reports, led me to suggest that you not track them in 
GnuCash. I see from your other reply that you’ve chosen that path anyhow.

Best,
David

> On Jun 25, 2017, at 11:18 PM, Leo Bolta  wrote:
> 
> My sincere apologies if there were duplicates of this email previously sent.
> I was having some problems getting back onto the list after delisting a few
> months ago.  My test that I was actually back on board, was to also receive
> a copy in my email in-box.  The email sent this morning to the list, was the
> first in which I actually got a copy back, which indicated to me that this
> attempt was finally successful.
> 
> Why to track a primary residence may not make sense to an accountant but
> everyone's situation may be different.  For example, one may live in a peak
> demand area and it may one day prove to be a timely decision to moving into
> less popular area, where prices are not so hyped and geared more towards a
> lifestyle that one may prefer.  I acknowledged in my email, that it was not
> a standard practice to track primary residence, but I don't necessarily
> follow standards and was hoping to get a reply from someone who may have
> thought a similar situation through.
> 
> Leo  
> 
> -Original Message-
> From: David T. [mailto:sunfis...@yahoo.com] 
> Sent: June-25-17 11:40 AM
> To: lbo...@rogers.com
> Cc: gnucash-user@gnucash.org
> Subject: Re: Tracking Primary Residences
> 
> Leo,
> 
> First, I don't understand why you sent your email verbatim again to the
> list.
> 
> Next, it seems to me that if you didn't track the unrealized gains on your
> condo (which are not actually real, BTW), then you wouldn't have a problem
> with the graphing of the non-existent gains. 
> 
> While it may feel good to imagine how much wealth is accruing to your
> investment, the reality is that none of it counts until you have a buyer who
> has paid you for the asset. SInce you claim to want to be staying in your
> house-and that you don't care about the eventual capital gain, then why
> track it at all?
> 
> David
> 
>> On Jun 25, 2017, at 7:13 PM, Leo Bolta  wrote:
>> 
>> 
>> Although I understand it does not seem to be standard accounting 
>> practice to track appreciation on a condo which is a principal 
>> residence, I can't help but want to implement incorporating very 
>> conservative periodic values into GnuCash, possibly as much as twice a 
>> year as the condo represents a considerable percentage of my net
> worth/portfolio.
>> 
>> My attempt at treating the condo as a fixed asset with an unrealized 
>> capital gain aspect was to incorporate the set-up as per 'Example 11.3 of
> Chapter
>> 11" in the GnuCash manual.   However because of a quite a hot
>> real-estate/condo market, my unrealized gains are now so significant 
>> that the previous unrealized gain dwarfs the fixed income amounts to 
>> the point that the bar charts such as "Income/Expense Chart" displays 
>> a skyscraper sized income bar in the graph, next to a very miniscule 
>> bungalow sized bar representing my expenses. Prior to implementing the 
>> new set-up, the Income vs. Expense chart was much more meaningful as a 
>> gage to monitor tangible income against real expenses. I've even tried 
>> taking the total bi-annual gain and evenly distributing the total into 
>> the past six months but the reports still don't have the meaningful
> representation it once had for me.
>> 
>> Because the condo is my principal residence which I don't have any 
>> intention of selling anytime soon, is there a way to account for 
>> periodic appreciated values, without it effecting income in such a 
>> profound way when the gains are in reality mere paper gains? I am also 
>> not so concerned about the eventual capital gain, since the sale of a 
>> primary residence are not treated as a taxable gain here in Canada.
>> 
>> ___
>> gnucash-user mailing list
>> gnucash-user@gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -
>> Please remember to CC this list on all 

Re: Tracking Primary Residences

[David T. via gnucash-user]

Leo,

First, I don’t understand why you sent your email verbatim again to the list.

Next, it seems to me that if you didn’t track the unrealized gains on your 
condo (which are not actually real, BTW), then you wouldn’t have a problem with 
the graphing of the non-existent gains. 

While it may feel good to imagine how much wealth is accruing to your 
investment, the reality is that none of it counts until you have a buyer who 
has paid you for the asset. SInce you claim to want to be staying in your 
house—and that you don’t care about the eventual capital gain, then why track 
it at all?

David

> On Jun 25, 2017, at 7:13 PM, Leo Bolta  wrote:
> 
> 
> Although I understand it does not seem to be standard accounting practice to
> track appreciation on a condo which is a principal residence, I can't help
> but want to implement incorporating very conservative periodic values into
> GnuCash, possibly as much as twice a year as the condo represents a
> considerable percentage of my net worth/portfolio.  
> 
> My attempt at treating the condo as a fixed asset with an unrealized capital
> gain aspect was to incorporate the set-up as per 'Example 11.3 of Chapter
> 11" in the GnuCash manual.   However because of a quite a hot
> real-estate/condo market, my unrealized gains are now so significant that
> the previous unrealized gain dwarfs the fixed income amounts to the point
> that the bar charts such as "Income/Expense Chart" displays a skyscraper
> sized income bar in the graph, next to a very miniscule bungalow sized bar
> representing my expenses. Prior to implementing the new set-up, the Income
> vs. Expense chart was much more meaningful as a gage to monitor tangible
> income against real expenses. I've even tried taking the total bi-annual
> gain and evenly distributing the total into the past six months but the
> reports still don't have the meaningful representation it once had for me.  
> 
> Because the condo is my principal residence which I don't have any intention
> of selling anytime soon, is there a way to account for periodic appreciated
> values, without it effecting income in such a profound way when the gains
> are in reality mere paper gains? I am also not so concerned about the
> eventual capital gain, since the sale of a primary residence are not treated
> as a taxable gain here in Canada. 
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Transaction Journal View - blank "Memo" instead of Description

[David T. via gnucash-user]

> On Jun 11, 2017, at 3:54 AM, Adrien Monteleone  
> wrote:
> 
> 
>> On Jun 10, 2017, at 4:30 PM, Waitman Gobble  wrote:
>> 
>> 
>> Thanks. It appears top posting is preferred here?
>> 
> 
>> 
>> It would be nice if I could double-click the invoice line and open the 
>> invoice, maybe I am missing something?
> 
> That would be nice too. I agree. Please file a Request For Enhancement on 
> Bugzilla.
> 
> Regards,

There is the “Jump” button on the toolbar, which will open the other account 
when you are on a particular split.

David
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: GNUCash value proposition

[David T. via gnucash-user]

I won’t tell you how much trouble I had years ago when a bank employee 
accidentally keyed in the dollar portion of a check twice, and instead of a 
$621 check, I got tagged for $621,621. Imagine my surprise when I saw that my 
account was overdrawn by some $600,000…

David

> On Jun 5, 2017, at 1:47 PM, prl  wrote:
> 
> On 5/06/2017 18:24, Colin Law wrote:
>> On 5 June 2017 at 03:21, Lincoln A Baxter  wrote:
>>> If we all had the time and discipline to enter every transaction as it
>>> was made, this is all true. Entering transactions as they are made is
>>> very hard, and without a client that you carry with you it is virtually
>>> impossible, even if one existed, it would be tedious. The fact is the
>>> Bank is that application, they do it for you.  They HAVE to!  The
>>> reason import exists and is widely used (I do), is that it saves the
>>> time of entering all the transactions.
>> It depends on whether you trust your bank and, for example, its OCR
>> cheque reader. I keep all my receipts then it is easy to enter the
>> transactions. A little tedious I agree but for most using this for
>> personal accounts I imagine it is only a handful a day.  For business
>> users I would have thought that keeping receipts and entering
>> transactions manually is mandatory.  For cash I enter significant
>> items (that I have kept receipts for) then balance the cash in hand
>> with GC once a week or so, assigning the missing cash to
>> Expenses:misc.
>> 
>> Colin
> It's not just the bank that can be the source of erroneous transactions. I've 
> had instances where I was double charged on a credit card (the same charge 
> twice for a single restaurant meal), and I was once double charged for my 
> home and contents insurance (again two transactions on the account for the 
> same amount for a single premium). In both cases it wasn't the "banks 
> application" that had made the error, it was the business making the charges. 
> The bank had done nothing wrong.
> 
> Peter
> 
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Reconciling an account

[David T. via gnucash-user]

John, 
That sounds way more complicated than using the reconcile feature in Gnucash 
and following the guidance in the concept guide at chapter 4.4 & 5.4.
When I reconcile using this method, I click reconcile, I select the correct 
ending date, adjust the closing balance to match the statement. Then, I check 
off the debits and credits that match. Usually, when I have checked off what is 
in the statement, everything matches, and I am done. That is very 
straightforward. 
China, if you have done all this and things don't match, I would double check 
that there aren't errors in your transactions. 
David

 
 
  On Sun, Jun 4, 2017 at 8:07, John Walker wrote:   Hi 
China Blue

This particular issue baffled me for some time until I came up with a 
process that tells me what to expect.  My GnuAccount opening balance 
hardly ever is the starting balance in the relevant statement because 
inputs and outputs from previous statements as well as the current 
statement are not always fully accounted for (pardon the pun).

Here is the process:

*To reconcile Credit Card, GnuCash vs Bank:*

1.Copy LAST entry in Gnucash before entries that are being reconciled 
i.e. last reconciled entry

2.ADD New Transactions and Charges (not closing balance) from current 
bank statement

3.SUBTRACT payments/Refunds from bank statement

4.Result should be the same as LAST entry being currently reconciled in 
GnuCash

5.If there is a difference, subtract actual entry in GnuCash from 
calculated entry

6.This is the value that needs to be found – it should either be an 
incorrectly made entry or a missing/extra entry or a combination

7.Easy way to check is to print statement and hand tick on paper

Cheers
Phantom


On 4/06/2017 10:08 AM, Michael via gnucash-user wrote:
> On Sat, 3 Jun 2017 15:51:01 -0700 (PDT)
> EngineInstitute  wrote:
>
>> I am having problems reconciling an account. The starting balance
>> agrees with the statement but ending balance does not. OK so I
>> changed the ending balance to the correct one in the initial dialog
>> box. I then went on to the next task of checking all of the debts and
>> credits. I did that and compared the sum of the total debt and credit
>> amounts against the statement so far ok. BUT the ending balance still
>> does not agree even there are no additional debts logs and one
>> outstanding credit and I cannot close the account for that period.
>> What am I missing?
>>
>> Thanks.
>>
>>
>>
>> -
>> China Blue
>> --
>> View this message in context:
>> http://gnucash.1415818.n4.nabble.com/Reconciling-an-account-tp4691993.html
>> Sent from the GnuCash - User mailing list archive at Nabble.com.
>> ___ gnucash-user mailing
>> list gnucash-user@gnucash.org
>> 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.
> Did you adjust the closing date on the reconcile window to match your
> statement, rather than adjust the closing amount?  With the correct
> date, you should get the right amount, unless you have additional
> transactions or interest that have not been entered in gnucash.
> Otherwise not sure what else it could be.  Mike
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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
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: How to close a financial year

[David T. via gnucash-user]

Don, 
Your contributions will be welcome. As I do not close my books, and also do not 
use the business features, I can only offer you editorial guidance and general 
help in the process. 
As for the term "Chart of Accounts", Gnucash uses this term for the page that 
displays all accounts in a hierarchical tree, i.e., the first summary page when 
you open a file. This page in Gnucash includes balances, although it is 
configurable. This is noted in the glossary, although the definition might be 
improved to explain Gnucash's spin on the term. 

As stated elsewhere, the wiki is not the same as the documentation, and this is 
intentional. The docs are more formal, whereas the wiki is more immediate. In 
the past, information has tended to gravitate in one place or the other, and 
once there, stays there. If your goal is to improve the docs (which I endorse), 
I think you should file a bug and work through that mechanism, rather than put 
stuff into the wiki that you intend to place in the docs. 
David
 
 
  On Thu, May 25, 2017 at 7:57, doncram wrote:   Thank you 
to David T. and to Michael D Novack and others for observations
on closing.  Ideas from these and other comments that I can look for in
past ("annual") discussions oughta be incorporated into documentation.
Some notes while this is fresh:

*Annual discussions, true "frequently asked questions" --> opportunity to
improve documentation

*The Tutorial and Concept Guide does not address closing at all, if I am
not mistaken...it should be covered in Chapter 13 about businesses and it
also should be covered in closing for personal finances

*The Wiki coverage (http://lists.gnucash.org/wiki/Closing_Books) is
alarming to me in the difference of its terminology from that of
introductory accounting textbook treatment of the topic...it suggests the
purpose of closing is to zero out account balances or to "zero
transactions". I need to review textbook treatment myself, but what's
needed in explanation to regular users is a discussion of all the usual
aspects, starting with making adjusting entries -- a huge theme in chapter
after chapter of textbooks (e.g. recognize accrued interest in mortgages,
loan & bond liabilities and assets, for one i didn't mention yet).  Provide
example journal entries of each type.

*Then go through discussion of all the logical steps of closing in a manual
system or in big commercial accounting software, and how you can
approximate that in GnuCash (e.g., as suggested, make a point of backing up
the data and securely storing/distributing it).

*Note freezing is not the same...the prior years data stays in your system,
and if it is not frozen then errors can be introduced, you might
accidentally add or change a prior year transaction.  In commercial
standard accounting, the past data is locked by password at least, and
prior year info is only changed in exceptional circumstances (explain
those...and how even for public restatements of financials, the past info
is likely not changed).

*I still am gathering that password-locking the past period data is not
possible.

*Both the Wiki and the Help coverage use incorrect-to-my-ears language
about the Chart of Accounts, both saying that the Chart of Accounts will
show amounts of some kind.  GnuCash usage should be brought into conformity
with accounting usage where the Chart of Accounts is a list of the account
names and account numbers and account types only;  it does not have any
dollar amounts.  The GnuCash usage is referring to what I would call Trial
Balances i think.

*What is the goal in closing?  I think it is about bringing the state of
financial reporting into a "good state", e.g. where the Balance Sheet and
the Income Statement/Statement of Revenues and Expenses are accurate in
accordance with your organization's or your personal accounting standards,
perhaps U.S. Generally Accepted Accounting Principles perhaps with
modifications, or perhaps compliance with Tax filing (or both).  Perhaps it
is cash basis.  What your nonprofit's board or independent accountant will
likely accept.  An individual may want their accounting to match tax filing
(close but not same as cash basis), e.g. use depreciation per tax standards
rather than GAAP, which is a choice.  The goal could be to accurately
state your income as will match on tax forms.  A number of adjusting
entries are needed, and once a year perhaps is good for considering
revaluations of property, etc.  Side note: for U.S. personal taxes if you
deduct car usage for personal business usage according to mileage at
allowable rate, that means that you need to make an accrual, an adjustment,
relating to difference between that vs. your "actual" car expenses.  The
Tutorial and Concept Guide treatment should start with the goal(s) you can
have.

I gather I should submit a bug through Bugzilla to address changes for the
Manual and changes for the Tutorial and Concept Guide. Presumably I could
just edit the Wiki section 

Re: Bulk Import Into Security Editor?

[David T. via gnucash-user]

Correct.

How many securities do you have, that you would need a bulk import? 

David

> On May 19, 2017, at 7:52 AM, Andrew Gross  wrote:
> 
> The Security Editor does not have a "bulk import" feature, correct?
> 
> 
> Andrew Gross
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: lots

[David T. via gnucash-user]

Robert:

1) I believe you are confusing “Lots” and “Trading Accounts”, but I could be 
wrong. I am not aware of needing to change any settings to use lots. Lots 
technically aren’t necessary, since a user can manage the gains aspect 
manually. To use the lots feature, select Actions->View Lots in a Stock/Mutual 
Fund account. Trading Accounts are a different animal, one that I haven’t met 
in the wild (i.e., I don’t use them).

2) I do not believe there is. I assume here that when you say actual buys and 
sells, you really mean that you want information about the gains on those buys 
and sells, since it is trivial to run a report that lists the actual Buy and 
Sell transactions in any given account or selection of accounts.

3) Most reports have been incorporated into the distributed application. There 
are a number of reports that have been offered over the years to the community 
via this list. I don’t know whether there is any easy way to search for them.

Cheers,
David

> On May 17, 2017, at 10:20 PM, Robert Hoogendoorn  wrote:
> 
> Hi,
> 
> I am using version 2.6.16
> 
> 1. I understood that there is some kind of tick box which needs to be set
> to use lots in the investment section, however I can´t find it. Do you know
> where this needs to be set?
> 2. Is there a portfolio report available which shows actual lots (buys and
> sells)?
> 3. Is there a site on which persons make customized reports available for
> other gnu users?
> 
> Kind regards,
> Robert
> ___
> gnucash-user mailing list
> gnucash-user@gnucash.org
> 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
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: Fixing opening balance for an incorrectly reconciled account

[David T. via gnucash-user]

Andrew, 
Presumably, if you fixed a reconciled transaction, it should be right. If it is 
now right, then your ending balance should now be right, and you should see 
below. 
If your ending balance is wrong, then you have ANOTHER problem in your account, 
and you should look for THAT error, rather than keep entering and reversing 
spurious transactions.  
If you are seeing an incorrect starting balance in the reconcile window, but a 
correct closing balance, then I suggest you go back to section 4.4.1 again, and 
read it closely. It very clearly explains this situation, and how to recover 
from it. 
David

 
 
  On Tue, May 16, 2017 at 7:53, Andrew Gross wrote:   
On Mon, May 15, 2017 at 5:23 PM, Dave H  wrote:

Personally I would have have fixed up the incorrect already reconciled 
transaction

Wasn't able to figure out how to do that.  It was a month or two ago -- I have 
been doing my hack since then.   Is the  idea that this cannot be fixed unless 
I go back, find that transaction and somehow re-reconcile it?


Andrew Gross

  
___
gnucash-user mailing list
gnucash-user@gnucash.org
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: Fixing opening balance for an incorrectly reconciled account

[David T. via gnucash-user]

Andrew, 
I reread your messages. You say you "fixed" a reconciled transaction, and now, 
you have to enter an extra transaction which you reversed afterward. Do I have 
that right? 
OK, if you"fixed" a reconciled transaction, then presumably now, it is correct. 
First question: how did you get the account to reconcile before? If your 
transaction was wrong,  then it shouldn't have balanced. 
Next question: now that you fixed the wrong transaction, why do you need any 
dummy transactions at all? Again, the reconciliation should then work (once you 
take note of the note in 4.4.1 and ignore the starting balance).
Despite what others are saying about creating fixing transactions, I think you 
haven't demonstrated to me that you need any such transactions. 
David

 
 
  On Mon, May 15, 2017 at 7:21, Andrew Gross wrote:   David,
I used the wrong terminology -- I should have said "starting balance".  I am 
looking at 4.4.1 of the documentation 
(https://www.gnucash.org/docs/v2.6/C/gnucash-guide/txns-reconcile1.html) and I 
did create a dummy transaction and then reversed it after the reconciliation.  
Do you believe this is just a one-time fix?  I would doubt that since it 
wouldn't change the underlying starting balance.  I think I am misunderstanding 
something here...  
ThanksAEG
Andrew Gross
917 750 6981
On Sun, May 14, 2017 at 9:51 PM, David T.  wrote:

Andrew, 
What do you mean, you can't fix the opening balance? If you are talking about 
your "Opening Balance" transaction, that is just another transaction, and of 
course you can edit that. (The recent discussion about reversing transactions 
was about a technicality for business books, and not necessary for personal 
books)
If you are talking about the "Starting Balance" when you reconcile each month, 
take a look in the Guide at 4.4.1, and read the note there about how to handle 
that. 
Either way, it's a one time fix. 
David

 
 
 On Mon, May 15, 2017 at 6:20, Andrew Gross wrote:  
Greetings -- have looked at a couple of old threads on reconciliation
issues that come close to this question, but not quite. In two of my
accounts (one asset; one liability) I committed a transgression; I
attempted to fix a reconciled transaction.  Since then, I have to put in a
"fix" to balance each account.  I add a bogus transaction; reconcile; and
then reverse the transaction.  Essentially, I need to be able to reset the
opening balance in order to fix this.  I know changing the opening balance
is not an option; is there an alternative so I can stop using the "bogus
transaction" method?

Thanks everyone,


Andrew Gross
__ _
gnucash-user mailing list
gnucash-user@gnucash.org
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
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: Fixing opening balance for an incorrectly reconciled account

[David T. via gnucash-user]

Andrew, 
What do you mean, you can't fix the opening balance? If you are talking about 
your "Opening Balance" transaction, that is just another transaction, and of 
course you can edit that. (The recent discussion about reversing transactions 
was about a technicality for business books, and not necessary for personal 
books)
If you are talking about the "Starting Balance" when you reconcile each month, 
take a look in the Guide at 4.4.1, and read the note there about how to handle 
that. 
Either way, it's a one time fix. 
David

 
 
  On Mon, May 15, 2017 at 6:20, Andrew Gross wrote:   
Greetings -- have looked at a couple of old threads on reconciliation
issues that come close to this question, but not quite. In two of my
accounts (one asset; one liability) I committed a transgression; I
attempted to fix a reconciled transaction.  Since then, I have to put in a
"fix" to balance each account.  I add a bogus transaction; reconcile; and
then reverse the transaction.  Essentially, I need to be able to reset the
opening balance in order to fix this.  I know changing the opening balance
is not an option; is there an alternative so I can stop using the "bogus
transaction" method?

Thanks everyone,


Andrew Gross
___
gnucash-user mailing list
gnucash-user@gnucash.org
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
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.