Don,
thanks for your advice and explanation.
I've done it the way you described and it took me 50 sec per year for
one account, so in total 25 minutes.
Nevertheless I think having the layout of the database can help making
own reports easy.
Fred.
Op 26-11-10 15:21, Donald Allen schreef:
I'd like to suggest another possibility. My understanding is that you
have a number of years of payments to utilities all charged to one
expense account that you now want to separate into more specific
accounts. If the descriptions of the payments allow you to distinguish
them with 'Find' in gnucash, you can end up with a register displaying
just, say, the payments for electricity. You then correct the expense
account of the first payment, select the correct account, ctrl-c to
copy, and then either use the mouse to select the expense account of
the next transaction and paste, or do the navigation from the
keyboard, which I find much easier and faster. If you do it from the
keyboard, you will use a combination of down-arrow (to move to the
correct row), tab (to move to and select the account), ctrl-v (to
paste the correct expense account) and enter (to record the change in
the transaction) to correct the next transaction. I don't think you
will have trouble figuring out the correct sequence. Once you do, and
get into the flow, you'll correct a transaction every few seconds. If
you have 10 years of data and you've paid your electric bill
once/month, that's 120 transactions. A piece of cake. Then repeat the
process for the remaining transaction types. If you end up processing,
say, 400 or 500 transactions, I think you'll spend less time getting
it right this way (if it's 500 transactions and you spend 10
seconds/transaction, which is slow, that's 5000 seconds, or less than
1.5 hours; and I think you can do it faster) than trying to learn
enough to write the code to mess with a .qif file or the data base,
write the code, and debug it. Hacking might be more fun, but I think
it will take you hours to get it right. I'd suggest gritting your
teeth and doing it the boring, manual way.
/Don
Fred.
-derek
Op 25-11-10 20:53, David T. schreef:
Fred--
I don't know how you have your accounting set up in Money. When I used
Quicken, though, I had categories for Electricity, Gas, and Telecom, and
these imported into Gnucash as separate accounts.
Perhaps you could rearrange your accounts in Money to use categories (or
whatever they are in Money), using a find and replace, export to QIF,
and then import the QIF into Gnucash.
David
--- On Thu, 11/25/10, Fred Verschueren<f...@fremar.be> wrote:
From: Fred Verschueren<f...@fremar.be>
Subject: Re: queries on mysql
To: "Derek Atkins"<warl...@mit.edu>
Cc: gnucash-devel@gnucash.org
Date: Thursday, November 25, 2010, 1:20 AM
I have an assets:bankaccount:bank with payments for
electricity,
telecom, gas, aso to expense:XX.
I want electricity to go to expense:electricity, telecom to
expense:telecom, gas to expense:gas, aso
This are monthly payments for more than 10 years.
So, a way to automate this would be very welcome.
Fred.
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
_______________________________________________
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
