Spreadsheet: 111328d1307710584-summarising-data-from-multiple-worksheets-cashbook-sample
Sheet: Credit card expenditure

Date | Transaction Type | Invoice ref (Ours) | Bank Ref | Cost Centre | Originator invoice number | Paid To | Budget Header | Description | Net Amount | VAT amount | Total invoice amount
2011-04-14 00:00:00 | CC | ADCC0411 |  | OH6PO |  | Parcel2Go | Parcels | Credit |  |  | 100
2011-04-15 00:00:00 | CC | ADCC0411 |  | OH16TRS |  | RAC Motoring Services | Breakdown cover | Essential Car User |  |  | 119.19
2011-04-15 00:00:00 | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 2.47
 | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 5.13
 | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 0.45
 | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 5.9
 | CC | ADCC0411 |  | OH3TR |  | Imperial London | CLP course | Accommodation |  |  | 80
 | CC | ADCC0411 |  | OH16TRS |  | Imperial London | Accommodation | Refunded December |  |  | 160
 | CC | ADCC0411 |  | OH3TR |  | EC Mainline | CLP course | Train travel |  |  | 331.1
 | CC | ADCC0411 |  | _DBF10 |  | Ryman | Sundries | Stationery |  |  | 22.06
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 4.3
 | CC | CMCC0411 |  | _DBF10 |  | Tesco Stores | Sundries | Various |  |  | 9.36
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 4.63
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 0.55
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 0.32
 | CC | CMCC0411 |  | _ADV1011 |  | Stewart & Co at the CI | Fast Track Fiction | Hospitality |  |  | 7.05
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 2.63
 | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 4.38
 | CC | CRCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 0.57
 | CC | CRCC0411 |  | _DBF10 |  | Party Plastics LLP-DOM | Sundries | Plastic cups |  |  | 12.71
 | CC | CRCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park |  |  | 4.7
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC
 | CC