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?

       -----A----- ------B------
   3   Row Labels  Sum of Amount
   4   2012-000267             0
   5   CP                      0
   6   2012-000345             0
   7   CP                    200
   8   PL                   -100
   9   PT                   -100
  10   2012-001565             0
  11   CP                    100
  12   PL                   -100
  13   2012-001777             0
  14   CP                    300
  15   PT                   -300
  16   Grand Total             0

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