Re: Issues with Importing Invoices

2017-05-24 Thread Mike Evans
I'd like to see an example of your CSV file before I can look into this. Can you post an (anonomised) example please. I assume you are using Windows since you mention Excel. Mike E On Tue, 23 May 2017 19:58:08 -0700 "Bruce Danielson" wrote: > > One issue is that if I leave the ID field bl

Re: Issues with "Assets over time" report

2017-05-24 Thread Jose Gómez
Still, there is something I don't get. Why would weighted average not use the value of USD stocks, and only use the initial value for EUR stocks? ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-use

Re: How to close a financial year

2017-05-24 Thread doncram
The advice to Anita to close a year's books, with warning present in the that doing so will destroy usability of reports henceforth, is quite alarming! What is meant by "closing" in GnuCash-jargon seems different than what is meant more usually in accounting. In an entirely manual accounting, clo

Hiding accounts

2017-05-24 Thread Dianna Broughton
Hi everyone, I hope I can explain my question well enough for someone to be able to answer. I know how to hide unused accounts, but when I go an asset or liability account, and choose an account in the Transfer column, all accounts show up (including the hidden accounts). It would spe

Re: Hiding accounts

2017-05-24 Thread Colin Law
On 24 May 2017 at 17:06, Dianna Broughton wrote: > Hi everyone, > > > > I hope I can explain my question well enough for someone to be able to > answer. > > > > I know how to hide unused accounts, but when I go an asset or liability > account, and choose an account in the Transfer column, all acco

Re: Hiding accounts

2017-05-24 Thread Maf. King
Hi Dianna, I think you have to mark the hidden accounts as placeholder too, then the don't appear in the transfer list. HTH, Maf. On Wednesday, 24 May 2017 17:06:55 BST Dianna Broughton wrote: > Hi everyone, > > > > I hope I can explain my question well enough for someone to be able to > an

RE: Hiding accounts

2017-05-24 Thread Dianna Broughton
Thank you - checking the placeholder box (in addition to the hidden box) worked! I should've asked long before now! Warmly, Dianna ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Ple

Re: How to close a financial year

2017-05-24 Thread David T. via gnucash-user
Don, As I mentioned originally, there is an annual discussion about the capabilities of GnuCash in regards to closing the books—and the philosophies behind each of the options that users might choose in that regard. Reading some of those past discussions will help you understand GnuCash’s appro

Re: Hiding accounts

2017-05-24 Thread David T. via gnucash-user
This is actually documented in the Help file at 5.4.1. David > On May 24, 2017, at 9:35 PM, Dianna Broughton > wrote: > > Thank you - checking the placeholder box (in addition to the hidden box) > worked! > > I should've asked long before now! > > Warmly, > Dianna > > > __

Re: How to close a financial year

2017-05-24 Thread Mike or Penny Novack
On 5/24/2017 10:46 AM, doncram wrote: ... What is meant by "closing" in GnuCash-jargon seems different than what is meant more usually in accounting. I 4. Freezing forever the accounts for the period (in software, this would be done by putting a lock on any transactions before

Re: Issues with "Assets over time" report

2017-05-24 Thread Adrien Monteleone
As for initial value concerns, if there is no other transactional value, that’s the only one used. If you only bought the EUR stocks once, there is only one value to average. If you made more than one purchase then there will be a calculation for GC to do. Weighted average only works on transact

Re: Issues with "Assets over time" report

2017-05-24 Thread Adrien Monteleone
I’ve mine set to Most Recent since I was only concerned with current Balance Sheet and P&L statements, but I can see now using the bar charts and historical reports that Nearest In Time is much more entertaining. Thanks! > On May 23, 2017, at 11:19 PM, Edward Doolittle > wrote: > > My unders

Re: Issues with Importing Invoices

2017-05-24 Thread Nelson Handcock
Bruce, I've attached a sample of an invoice import file that I recently prepared and successfully loaded up. If you change the "memberidn" to match your customer ID's and also change the account names then it should work for you. The key thing for me is sorting my source data by Member ID and the

RE: gnucash-user Digest, Vol 170, Issue 49

2017-05-24 Thread Chris Good
> Message: 8 > Date: Tue, 23 May 2017 17:50:34 -0500 > From: John Griessen > To: Gnucash > Subject: gnucash debian packages > Message-ID: 86de4eae5...@industromatic.com> > Content-Type: text/plain; charset=utf-8; format=flowed > > gnucash (1:2.6.16-1) is in experimental. > > Is this good to tr

RE: gnucash debian packages

2017-05-24 Thread Chris Good
> -Original Message- > From: Chris Good [mailto:chris.g...@ozemail.com.au] > Sent: Thursday, 25 May 2017 8:17 AM > To: 'gnucash-user@gnucash.org' > Subject: RE: gnucash-user Digest, Vol 170, Issue 49 > > > Message: 8 > > Date: Tue, 23 May 2017 17:50:34 -0500 > > From: John Griessen > > T

RE: gnucash debian packages

2017-05-24 Thread Chris Good
> Message: 10 > Date: Tue, 23 May 2017 21:50:18 -0500 > From: David Carlson > To: John Griessen > Cc: Gnucash > Subject: Re: gnucash debian packages > Message-ID: >mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > I am using Debian Jessie and the latest version I can find i

Re: How to close a financial year

2017-05-24 Thread doncram
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 quest

Re: How to close a financial year

2017-05-24 Thread Adrien Monteleone
> On May 24, 2017, at 9:56 PM, 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 i

Re: How to close a financial year

2017-05-24 Thread 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 hier