Remove all zero-value Imbalance-XXX splits?

Jeff Kletsky gnucash at
Wed Jan 19 14:13:18 EST 2011

On 01/19/2011 10:09 AM, Tommy Trussell wrote:
> On Mon, Jan 17, 2011 at 10:46 PM, Jeff Kletsky<gnucash at>  wrote:
>> Many transactions seem to end up with zero-value Imbalance-USD splits that
>> make it hard to ensure that all transactions have valid splits as we go
>> along.
>> Is there a way (short of munging the XML or database directly) of removing
>> such "meaningless" splits?
>> You can't easily open the Imbalance-USD register view and delete them from
>> there.
> [...]
> Two ways I can think of to fix the bad transactions:
> 1) Open the Imbalance-USD register, select a transaction and use the
> Actions-->Jump command to go to the source of the split.
> 2) Use  Edit -->  Find to search for transactions using the
> Inbalance-USD account and edit the splits in the results window. (If
> it still won't allow you to edit them, you might have to resort to
> using option #1, above.)

Thanks for the reply!

I was hoping to be able to avoid the "Jump" for each of the 
transactions, but either the Imbalance-USD register or the "find" 
approach end up with the message about not being able to delete the 
split because it anchors the transaction to the view.

Once I cross off some of the more pressing things from my list, I might 
look into a parallel to the "repair transactions" commands to remove all 
Imbalance-XXX and Orphan-XXX splits that have zero value.

They tend to come about because of auto-fill transactions that aren't 
completely cleaned up after entering the proper splits.


More information about the gnucash-user mailing list