RE: Issues with Importing Invoices

2017-05-25 Thread Bruce Danielson
Nelson – OK, I just copied your exact header row and tried importing but with no ID’s (Invoice Number blank) – I got errors that No ID Set (or something like that). So, I plugged in Invoice Numbers – and it worked. 2 invoices to 2 users, perfect, just as you would expect. I then posted both

RE: Issues with Importing Invoices

2017-05-25 Thread Bruce Danielson
Thx Nelson – Let me try filling in the header row & see if it helps with the customer number at all. That is the central issue right now. When I post invoices on June 1, I don’t want all 34 to go to C001 (or whoever is first on the list). So I’m trying just these two customers to see if I can

Re: Issues with Importing Invoices

2017-05-25 Thread Nelson Handcock
Hi Bruce, In no particular order Please check your version of gnucash - most recent version is 2.6.16. It's best to keep up to date. Tou can't delete an invoice - but if it's left as not posted then it won't show in any of the accounts. It's a bit annoying but it's always been that way

Re: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Mike or Penny Novack
On 5/25/2017 11:49 AM, Maf. King wrote: Copying to list... On Thursday, 25 May 2017 16:33:39 BST you wrote: Maf thanks so much!!! Helpful certainly. But I don’t understand IIRC, YMMV and HTH. Side by side reports, etc. I can't really advise you on that as I do not try to do that sort of

Re: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Mike or Penny Novack
On 5/25/2017 11:05 AM, Anita Graves wrote: I am astounded at the amount of help you dear people offer! Thank you very much. ... My only reason for wanting to ‘close’ the books was in order to properly carry forward any account balances. In my case, I had some advanced fund balances in

Re: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Maf. King
Copying to list... On Thursday, 25 May 2017 16:33:39 BST you wrote: > Maf thanks so much!!! Helpful certainly. But I don’t understand IIRC, YMMV > and HTH. Mostly internet abbreviations. If I Recall Correctly Your Mileage Might Vary Hope That Helps > > How is it possible to keep the same

Re: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Derek Atkins
On Thu, May 25, 2017 11:33 am, Anita Graves wrote: > Maf thanks so much!!! Helpful certainly. But I don’t understand IIRC, > YMMV and HTH. If I Recall Corretly Your Mileage May Vary Happy To Help > How is it possible to keep the same file moving from one year to the next > in the same file?

Re: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Maf. King
On Thursday, 25 May 2017 16:05:27 BST Anita Graves wrote: > > I would very much like to know how these funds should be entered in the > accounts. You take money from the asset accounts (checking or cash) and > put it in special ‘earmarked’ expense subaccounts, then draw the funds > toward zero

Re: How to close a financial year

2017-05-25 Thread Mike or Penny Novack
On 5/24/2017 10: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 is fresh:

Re: Some GNU questions

2017-05-25 Thread Maf. King
Hi Martjin, Welcome to the list. answers in turn throughout the post. On Thursday, 25 May 2017 14:45:29 BST Martijn Heuts wrote: > Good morning, > I am working with GNU cash for several months now and have some questions: > 1. When I create a new invoice for a client, and type in a product and

Fwd: How to close a financial year & how to keep 'earmarked' funds

2017-05-25 Thread Anita Graves
> Begin forwarded message: > > From: Anita Graves > Subject: Re: How to close a financial year & how to keep 'earmarked' funds > Date: 25 May 2017 at 6:05:27 PM GMT+3 > To: Derek Atkins > Cc: doncram , DaveC49

Re: How to close a financial year

2017-05-25 Thread Derek Atkins
doncram writes: > 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

account report from search shows wrong numbers

2017-05-25 Thread Vojtech Fried
Hi, I was in Italy and I wanted to know my expenses there. I paid both by cash (EUR) and with a card (in CZK, my home currency). I tagged my expenses in Italy and succesfully found all the transactions with "Find...". From the "Search Results" I proceeded with Reports -> Account Report. It

Re: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Maf. King
Hi Anita, That sounds right to me - unless anyone knows of an automated way to do this in a more recent GC - last time I started a new year empty boo was probably still in the GC 2.2.x days, and there's been a lot of changes to GC since then! Maf. On Thursday, 25 May 2017 13:07:25 BST Anita

Re: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Anita Graves
Maf, I have already created an account summary of the previous file, so have the balances forward to enter in the new one and don’t mind using the Equity:Opening Balances account, but I also have separate asset subaccounts under that for cash, bank account (current), etc. I will then manually

Re: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Maf. King
Hi Anita, sorry if I missed your point. It is quite a few years since I started a new year with an empty file, but IIRC, the only way to carry account balances forward is to manually create the transactions to Equity:Opening Balances in the new, blank file. So all your asset & liability

Re: How to close a financial year

2017-05-25 Thread Liz
On Wed, 24 May 2017 22:56:25 -0400 doncram wrote: > *I still am gathering that password-locking the past period data is > not possible. It is 'possible', but its a naive sort of lock. It looks good, but the problem is that it is open to hacking. Mike Novack has made annual

Fwd: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Anita Graves
Well, I just discovered an error in my judgment! Friends, I did not go back to the previous year’s accounts to see how I took the cash advance in the first place. And because I did not carry forward the balances in the asset accounts, I did not correctly record these balances in my new

Re: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Maf. King
Hi Anita. why would you expect a change in the opening balance account? At the start of the year, you have some money (say €100), which shows up in an asset account as you say, transferred from Equity:OpeningBalances. You spend most of the money - so asset drops to €14, and expenses:whatever

Re: Handling religious organization 'earmarked' funds and in-kind contributions

2017-05-25 Thread Anita Graves
Hi again, folks! This message is about ‘earmarked’ funds for the religious organization for which I keep the accounts. It is a corporation without share capital but not a non-profit corporation. We are in Cyprus and the laws here are similar to British laws. We do pay taxes, but we have not