I would like a Cleanup Utility to remove split lines split to Imbalance-CD and with no memo and no amount or zero amount on the line

[David]

Rita--

First, welcome to GnuCash.

GnuCash is an Open Source software project, so changes occur when someone contributes the code for it. If you can write the code yourself, or can convince someone to write the code, then you will get that functionality. Otherwise, the change will not happen.

As for your particular situation, I honestly don't understand. If you are importing your transactions, why would you zero them out?  Or, to put it another way, is a transaction still a transaction if it doesn't track the money?

Addressing the question of changing many Imbalance splits, there is no facility to do that. It is possible to "move" these transactions by opening the Imbalance account in Full mode, and changing the Imbalance split to the correct one. Each such transaction will disappear from the current register, and eventually all the entries will be gone from Imbalance (they will appear in their new registers). This can be tedious, but is do-able.

Another option would be to use a text editor on the QIF file to pre-edit the transactions before import.

HTH,
David



_____________________________________________
From: Yawar Amin <yawar.amin at gmail.com>
Sent: Sat Jan 05 15:09:40 PST 2013
To: Rita Hall <margh at taosnet.com>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
Subject: Re: I would like a Cleanup Utility to remove split lines split to Imbalance-CD and with no memo and no amount or zero amount on the line


Hi,

I am forwarding your email to the GnuCash users mailing list, which is a
public discussion forum where everyone can benefit from sharing
questions and answers. To participate in the mailing list, click the
‘Reply All’ button in your email program whenever you get an email from
someone in the list.

Regards,

Yawar

On 2013-01-04 11:14, Rita Hall wrote:
> Dear GNUcash
>
> I have just finished using XL2QIF plus Excel macros and VBA to import
> Quickbooks file data (via a CTDR) into GNUCash. The very biggest bottleneck
> was importing 29 balance sheet qifs into GNUCash. I had an idea that I
> think would be relatively easy to implement and only require import of one
> QIF file. It would also be very convenient for other purposes.
>
> It was easy enough in Excel to turn all my transactions into split
> transactions with zero amount and then import them into the single account
> Imbalance-CD (which was type "bank" for importation and then changed to
> "expense" in hopes the split line to that account would disappear from my
> transactions when GNUCash found that all the memos and amounts on that line
> were zero or blank. I found and tried a do a repair transactions menu
> option to see if that helped but it didn't. The unwanted split to
> Imbalance-CD could only be removed one transaction at a time, even worse
> than the 29 qifs. Looking at my balance sheet accounts the imports all
> looked good except all transactions showed up, of course, as split
> transactions with that useless line. So:
>
> I wish you had a little cleanup utility that would remove all Imbalance-CD
> splits from all transactions that had an empty memo and an empty or zero
> amount on that split line. An alternative would be the ability to record a
> simple macro in GNUCash and loop it thru the transactions in one or more
> accounts, so the process of deleting the unwanted split line by line could
> be automated. Either of these capabilities would be useful in other
> situations as well.
>
> I know this is more about development than documentation but I lost patience
> trying to find out on the internet who and how to contact. I hope you can
> forward it to somebody that might be able to write that clean-up utility.
>
> Sincerely,
>
> Rita Hall
> margh at taosnet.com
>
>


_____________________________________________

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.