Hi Adrian
Unless you are comfortable saving your data into an SQL database (eg
SQLite) and doing manipulation using SQL queries, your suggestion of
exporting, manipulating, and reimporting is the best solution.
I suggest you:
(a) Take a backup
(b) Export all transactions in your Utilities Account
(c) Rename the Account to Utilities-OLD
(d) Import your modified transactions
(e) Check that Utilities + Phone = Utilities-OLD
(f) Delete the Utilities-OLD Account.
Regards
Geoff
=====
On 11/02/2025 6:47 pm, Adrian Holbrook wrote:
I have a number of entries that I have classified under the expense category "Utilities".
I now wish to remove all my phone payments from that category and have a new category for
"Phone". The description for all these entries is the same so I have sorted by
description and am laboriously going through 20 years of records to transfer each one individually.
Is there a way of doing this as a batch process? I have thought of exporting the transactions as a
CSV file, importing into Excel, filtering them and editing the transactions and importing back into
Gnucash.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
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.