[GNC] Deleting Multiple Transactions

pyz01 at cox.net pyz01 at cox.net
Tue Nov 19 00:01:41 EST 2019


To all gnu-cash users --- found this on the net today and it was a
lifesaver.  Not sure if anyone else needs it - but it was extremely helpful
for me. 

"How can I delete multiple transactions in a batch in GnuCash?"

For me I made a copy of my current file.  Then on the copy I wanted to
delete any transaction after 1/1/2018.  This file now become an archive
file.  Now re-open my current file.  Delete any transactions in it prior to
1/1/2018.  Before deleting, make note of account balance amounts so I can
make sure I am balanced once I delete.  Enter new "Opening balance amounts"
as needed to ensure balances are current and balanced.  Now I have a file
with just the last 2 years transaction.   Did a search on the net and found
this: 

"As a workaround I made a shortcut key for deleting transactions. I modified
the C:\Users\username\.gnu-cash\accelerator-map file (with gnucash closed)
by changing the line

; (gtk_accel_path
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction" "")

To:

(gtk_accel_path
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction"

"<Primary>Delete")

Now I could delete transactions by pressing ctrl+delete. Pressing and
holding this key combination allowed continuous deleting at a predictable
rate so it was quite easy to delete a few hundred transactions quickly.

Might not be the best solution if you have many thousands of transactions
that you want to delete but for a few hundred it was quite painless.

As a follow-up to this very useful info, on a Windows PC, the file is
located in:

C:\Users\UserName\AppData\Roaming\GnuCash\accelerator-map

The way the edited line is displayed in the above answer is correct but it
may not be immediately obvious to everyone that like some other languages,
the semicolon needs to be removed as well. The semicolon is a comment tag
that disables the line it is on.

Notes:

<Primary> is the same as "Command" on macs and "Ctrl" on Windows. Other
modifiers are <Shift> and <Alt> and they can be combined so to make it a bit
more difficult to do accidentally, my new line is:

(gtk_accel_path
"<Actions>/GncPluginPageRegisterActions/DeleteTransactionAction"
"<Primary><Shift>Delete") 

AKA: Control + Shift + Delete

I presume it was the same in earlier versions but I am new to GNUcash so
it's also useful to note that, at least as of GNUcash 3.5, this keyboard
shortcut triggers the Yes/No dialog to confirm that the transaction should
be deleted. Additionally, you can select to ignore the dialog for the rest
of the session or never show the dialog. "

This works in 3.7 (what I am using) for Windows.  If you need or want to
delete multiple transactions - this is very handy.  Thanks to all.  

One last comment - I am not sure if this will work when I upgrade to the
next version - or even if I shutdown Gnu-cash and re-open it.  But
nevertheless, it is an easy fix for when I want to use the functionality of
deleting multiple transactions.  

Ken

 



More information about the gnucash-user mailing list