[GNC] Batch transfer from one expense category to another.

[Geoff]

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 at 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.