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

David, Sorry I hadn't realized the section i put in on that had made it into the current version of the docs. Thanks for pointing that out. David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___

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

David,  I am not sure why you say that the documentation lacks a description of debits and credits; I am sure you are aware of section 2.1 of the Guide, which goes into some detail about this precise issue.  David T.  On Fri, Jul 5, 2019 at 3:32, David Cousens wrote: Alan, The guide

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

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

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] Change a batch of transactions from income to Expense

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] Change a batch of transactions from income to Expense

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

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

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

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

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

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

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

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

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

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] Change a batch of transactions from income to Expense

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] Change a batch of transactions from income to Expense

If you post it again but Select View->Transaction Journal it will expand the transaction splits so we can better see what is happening on import. Might also help to be able to see one or two records of the CSV file.Cheers David Cousens - David Cousens -- Sent from:

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

You will find it useful to have a basic account structure already in place but you can usually add extra accounts as you need then. I think the dialogue which comes up when you select an account has a new account button but GnuCash's windows are not generally modal so you can usually go back to

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

Are your sub-accounts assets under your bank account? Your screenshot looks like every transaction has both a debit and a credit to the same sub-account, thus zero net. Most transactions should be either an income or an expense resulting in either a deposit or a withdrawal resp. to or from a

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

Hi Sorry for the bother. My exact method was. 1. Create a new company 2. Create a New Main Bank account. 3. Create all the sub accounts ie Camps in Camps out etc 4. Import the transactions csv file. 5. Map using date for date. Account for type ie Camps in Camps out, Description and deposit

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

Sorry, I might have misunderstood. Does the csv file contain 8 splits per transaction or are you just ending up with duplicates after the imports? The importer is supposed to check for duplicates so it doesn’t re-import something, but if you’re importing with different assignments it might not

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

This is one of the imported accounts Camps In I have own server so could upload files for you to have a look. If possible. Screenshot -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

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

You can just copy and paste it into a reply. (might have to format it a bit with tabs or spaces to make it readable) If you use the list directly instead of through Nabble you can try posting a screenshot. (though image hosting services like imgur work best) Regards, Adrien > On Jul 3, 2019,

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

can i email you the file or attach it somewhere on the forum Thanks -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

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

8 splits for each transaction? Could you provide an example. (you can make up amounts of course, or make the payee/description generic if you like) I’m curious to see what accounts those 8 splits are assigned to. Are they generally the same for each transaction. Are one set of 4 always the

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

Ok story so far. Managed to import the file but when checking the transactions I have 4 entries for each one 4 incomes and 4 charges. Set the transfer account setting to account date etc ok. When i go to the next stage everything is green but then all as mentioned at the start. Back to dear old

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

Good Morning David Thats a great bit of help. I will keep at it and see how I get on, I only have about 170 transactions I need to import. I was using an online tool to convert the csv to other formats also my date is different it was coming up with error as I have the / rather than the -. To

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

The CSV import documentation is not very clear yet as the process was rewritten and the documentation needs some updating - on the to do list.. >From the description you seem to be importing transactions to a bank account. CSV formats are highly variable. I usually setup a new dummy test file

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

Morayweb you may try one of the tricks mentioned in https://wiki.gnucash.org/wiki/FAQ#Q:_Is_there_a_way_to_merge_two_accounts_into_one.3F On Mon, 1 Jul 2019 at 12:02, morayweb wrote: > Hi I imported a qif file but when i went into the transactions they are all > income and none of them are

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

On 7/1/19 9:17 AM, morayweb wrote: > Hi > I can get a csv version of the file would that make it easier to import? > Thank you. > > C That depends on how good the vendor is at building the csv file.  My Citi's csv file for my cc insists on putting minus signs on the credit column values. 

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

morayweb, Try it. I am not looking over your shoulder. In my experience, I try OFX first, QIF next, and CSV last, especially since some banks don't use comma separators because they use commas for other purposes, but to each his own. David Carlson On Mon, Jul 1, 2019 at 11:19 AM morayweb

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

Hi I can get a csv version of the file would that make it easier to import? Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription

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

There are as many possibilities as there are accountants to cause or fix your dilemma. The simplest is to assume that your source simply got the sign wrong on some of the numbers in the QIF. However, since you are calling the account "Rebate" maybe the numbers are actually supposed to be

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

Tried it again after deleting all transactions but the debit amount is in the rebate part. What is the best way to check the qif file and sort it out. I exported from an online system ? Thanks -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

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

Oh, fix the problem with the QIF file first. On Mon, Jul 1, 2019 at 7:40 AM David Carlson wrote: > If you have a backup from just before the import, just use that and import > again. > > David Carlson > > On Mon, Jul 1, 2019 at 7:03 AM morayweb wrote: > >> Hi I imported a qif file but when i

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

If you have a backup from just before the import, just use that and import again. David Carlson On Mon, Jul 1, 2019 at 7:03 AM morayweb wrote: > Hi I imported a qif file but when i went into the transactions they are all > income and none of them are expense. Is it possible to change the ones