Recategorizing / bulk acount changing

Elwood elwoodblues at bellsouth.net
Wed Feb 5 23:08:59 EST 2014


Would search and replace in the XML data file, or a replace query in mySQL be possible?

Sent from my iPad

> On Feb 5, 2014, at 9:03 PM, "David T." <sunfish62 at yahoo.com> wrote:
> 
> You have read the documentation correctly, There really is no way to change most (but not all) transactions in an account register to a different destination. My experience is that this sort of need decreases as you get your books the way you actually need them.
> 
> What I have done in this circumstance is:
> 1) open the account register from which I am moving some transactions in Auto Split mode, 
> 2) change the first target transaction to use the new account and copy the full new account info before leaving the field,
> 3) commit the transaction, which removes the transaction from this register, since it is no longer anchored to this account.
> 4) repeat 1-3 for every other transaction I wish to move, using Paste to enter the new destination account
> 
> Before too long, you have worked through the complete register.
> 
> HTH,
> David
> 
> From: Elwood <elwoodblues at bellsouth.net>
> To: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org> 
> Sent: Wednesday, February 5, 2014 6:42 PM
> Subject: Recategorizing / bulk acount changing
> 
> As I'm reading through the various sources of GnuCash documentation, and experimenting with various tasks in the user interface, it just struck me that there seems to be no easy way to move multiple transactions from one account to another.  (I read about how you can delete a parent account and have it absorb the child account transactions, but that's not always practical.)
> 
> As someone trying to migrate away from Quicken, this strikes me as a big need.  It would be especially helpful for cleaning up the data imported from Quicken.  It also seems like it would be useful in general for the personal finance user (as opposed to the business accounting user) because they will naturally make a lot of mistakes in categorization/account setup, and will constantly be in the mode of improving and changing where expenses go.
> 
> Am I missing something here?
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 


More information about the gnucash-user mailing list