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

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 is

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 account

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 posts on that topic to

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 accoun

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 e

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

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 seem

Some GNU questions

2017-05-25 Thread Martijn Heuts
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 price, it will be remembered by GNU Cash which is an awesome feature.The question is: Can I create a report on how many times I used tha

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 accounting. AFAIK all t

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

2017-05-25 Thread Anita Graves
I am astounded at the amount of help you dear people offer! Thank you very much. After glancing at all the replies, I have decided to back away from any idea of ‘closing the file’ for the previous year. I say this because a) I am a novice at GnuCash and b) I have an accountant who will take a

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 , > gnucash-user@gnucash.org > > I am astounded at the amount of help you dear peo

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

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: 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 a

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

2017-05-25 Thread Anita Graves
Maf thanks so much!!! Helpful certainly. But I don’t understand IIRC, YMMV and HTH. How is it possible to keep the same file moving from one year to the next in the same file? How can I turn over the accounts for one year only to an accountant? How can you compare side by side if everything

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? J

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 file

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 t

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 t

Exchange rate in profit and loss

2017-05-25 Thread zorngibel
Dear all, I have a problem with dual currencies in the Profits and Loss report. I have some profits in GBP and some in EUR, my account is in GBP. For most functions the conversion of EUR to GBP works fine, but in the Profit and Loss report the exchange rate is way off (and obviously different from

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 AFAIK

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 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 a

Re: Issues with Importing Invoices

2017-05-25 Thread Nelson Handcock
Glad to hear you got it working! If you google "gnucash counters" or look in the online tutorial guide you might find some hints that may help you get that aspect working. I guess having a header row for the invoice import forces all the optional fields as having blank values and also forces the