Producing balancing entries

**The Phil** · 02-03-2013, 07:59 PM

There was no simple way to put this for the title.

(Note: whether you understand accounting lingo or not shouldn't matter once you see the example.) I have a bunch of accounting entries for 3 different clients that were processed together. Each batch of entries currently balances to zero, but it is broken up between the three clients. What I need to do is expand each batch to make each batch balance to each client. There are going to be a few hundred thousand lines of data.

The attachment should make it clear. The color formatting can be ignored, it was just to make it easier to follow.

Please ask if you have any question.

Thanks!!

Book1.xlsx

**shg** · 02-03-2013, 08:05 PM

How about just a pivot table?

Please Login or Register  to view this content.

**The Phil** · 02-03-2013, 08:43 PM

I think I see what you did, but I'm not sure what to do with that to give me the extra entry lines I need to balance things. Also keep in mind I have a hundred thousand lines of data.