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

2019-07-04 Thread morayweb
Thanks David Will try and get it into my head. I think it’s the gnucasg account system that’s maybe confusing me rather than categories. Thanks again. Alan -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user

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

2019-07-04 Thread David Cousens
Alan, The guide has an introductory session. The present version doesn't have a full explanation of the way accountants use debits and credits but the next version will. You will find a pretty good explanantion on Wikipedia and a few other sites. Look up Double Entry, Debits and Credits with

Re: [GNC] Search, amounts not correct

2019-07-04 Thread John Ralls
> On Jul 4, 2019, at 3:47 AM, elvo wrote: > > Hi. > I have an issue that is bugging me.. > When I search an account for i.e a description, the result always shows the > entries with ALOT of zero's. > Almost impossible to see the amount. And When I mark the row/amount, that > selection just

[GNC] Import Price from CSV Bug?

2019-07-04 Thread Robin Chattopadhyay
Hi all- I have been using the Import Price from CSV function successfully up through and including v3.5 (both Ubuntu 18.04 and Linux Mint 19). I have set my input file/mapping to: - CUSIP --> Commodity From - Shares --> None - Market Value --> None - Price --> Amount - Date -->

Re: [GNC] Unable to reconcile

2019-07-04 Thread David Carlson
Alan, Your experience was strange. If it ever repeats, it would be interesting to see if it relates to a language or font issue or something completely different. David Carlson On Thu, Jul 4, 2019 at 9:42 AM Alan A Holmes wrote: > Just to say that I had a problem reconciling one of my

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

2019-07-04 Thread Mike or Penny Novack
On 7/4/2019 10:06 AM, morayweb wrote: That sound brilliant. What would be the costs for that. I am in Scotland just thinking of time diference. Thank you. No charge (I am long retired from doing systems/business analysis for a living). Time difference matters less when it is exchange of

Re: [GNC] Unable to reconcile

2019-07-04 Thread Alan A Holmes
Just to say that I had a problem reconciling one of my accounts, my Current Account / Cheque account, this morning. I did what I normally do, i.e. obtain electronic statements up to today's date and then reconcile based on the balance on the bank statement as of this morning. It ended up being

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

2019-07-04 Thread morayweb
That sound brilliant. What would be the costs for that. I am in Scotland just thinking of time diference. Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list

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

2019-07-04 Thread Mike or Penny Novack
Morayweb, Gnucash, well any method of double entry bookkeeping can do so much more for you. What you have described is much as double entry was many centuries ago. You can (and should) set up the accounts so that you can get much more information about the finances of the camp. Imagine

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

2019-07-04 Thread morayweb
Thanks david when I get home I will have a go and read this more thoroughly and the manual. The only thing I cant quite grasp is when the account is Camps out I dont quite see how it increases the balance rather than decrease. Sorry I must be thick. -- Sent from:

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

2019-07-04 Thread David Cousens
To deal with money coming in you would have to create an income account Income: Camp Fees for example. Depending on how your bank implemented the CSV either the values in the column I assigned the Withdrawal header, labelled Debit in the first column your bank supplied. If so you don't need to

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

2019-07-04 Thread David Cousens
I think I can see what is happening. i am assuming that these are all expenses incurred in th conduct of the items described in the description field. When you spend money a transaction is going to have two components. You needto record the act of taking money out of your account and also record

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

2019-07-04 Thread morayweb
Hi sorry for all this hastle. I am trying to setup a simple money in and out system for a non profit scout group. We have a Bank account with all money in it. If we were holding a camp say, then Camp out would be the money spent on food and expenses for the camp and Camp In would be Money

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

2019-07-04 Thread Geert Janssens
In gnucash a transaction is always between two accounts, but your csv file only hints at one. That means you need to help gnucash to learn what the second account should be. What you have created now are transactions from the "Camps Out" to the "Camps Out" account, which really means no

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

2019-07-04 Thread morayweb
I have followed the user manual word for word and seperated my accounts into seperate csv files. Here is a screenshot of the transaction journal Transaction Journal screenshot also the csv of the section i used to import is here CSV file

[GNC] Search, amounts not correct

2019-07-04 Thread elvo
Hi. I have an issue that is bugging me.. When I search an account for i.e a description, the result always shows the entries with ALOT of zero's. Almost impossible to see the amount. And When I mark the row/amount, that selection just empties/clears, and if I mark another entry, the value of the

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

2019-07-04 Thread morayweb
Morning David Wow what an explanation brilliant. No i don't have the sub-accounts under assets. I only have a bank account then all the other accounts as top level as well. Will read through your stuff and change the levels. Is the basic cheque account the best one to start off with and just

[GNC] Moving invoice details to new invoice or job

2019-07-04 Thread WB5FDP
In the past I have just deleted an entry on the invoice before it is posted and created it on a new invoice. I was thinking there must be a way to simply "move" a line-item to an existing invoice, under a different job. Is this possible? Rick

Re: [GNC] Unable to reconcile

2019-07-04 Thread Anna
It was mentioned that this issue arose after an update - in fact, that it was the first reconciliation since that update. On 01/07/2019 17:10:49, David Carlson wrote: As others have also mentioned, they are not seeing the same issue that you are, at least with the given details.  While your

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

2019-07-04 Thread morayweb
Morning David Wow what an explanation brilliant. No i don't have the sub-accounts under assets. I only have a bank account then all the other accounts as top level as well. Will read through your stuff and change the levels. Is the basic cheque account the best one to start off with and just

Re: [GNC] best accounting practice for refund

2019-07-04 Thread Geert Janssens
As guess as to what might have happened: When you select the invoice and credit note in the payment window, gnucash will automatically calculate the difference between them and set the payment or refund field to that amount. That is, it assumes you intend to fully "pay" for all the documents