Running balance for accounts payable data

I have a spreadsheet where I have the following data:
A: Date 1/20/2015
B: Code 4010.0700
C: Vendor Jaguar
D: Booked 1534.25
E: AP Paid 1605.30
F: Balance -71.05

I am trying to do a pivot table that would show me what their current balance is and I am having issues doing that.
I don't know if I need to put a code on the data sheet, or if I should do it in the pivot table.
I have multiple vendors in the list and would like the result to be a clean list that shows something like this:

4010.0700 Jaguar 1534.25 1605.30 -71.05
next vendor's data

The problem is, as months get added to this, I no longer get a clean list because I am not doing a proper running balance for each customer.
I am having a hard time explaining this, so I certainly apologize in advance!

So basically, I will have a large list with many months of the same data, but I want to see at a given date, what each vendor's balance is.

please attach sample excel file

See the attached file

Simply drag the Booked and AP Paid fields from Row Labels Fields to Values fields
Change value field settings from Count to some

Thanks for your feedback and adding reputation