Spreadsheet: 111494d1307875840-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 |  | OH18PD |  | Parcel2Go | Parcels | Credit |  |  | 100
2011-04-15 00:00:00 | CC | ADCC0411 |  | OH18PD |  | RAC Motoring Services | Breakdown cover | Essential Car User |  |  | 119.19
2011-04-15 00:00:00 | CC | ADCC0411 |  | _RR11 |  | Parking CC | Parking | Car Park |  |  | 2.47
 | CC | ADCC0411 |  | _RG1112 |  | Parking CC | Parking | Car Park |  |  | 5.13
 | CC | ADCC0411 |  | OH2SU |  | Parking CC | Parking | Car Park |  |  | 0.45
 | CC | ADCC0411 |  | OH2SU |  | Parking CC | Parking | Car Park |  |  | 5.9
 | CC | ADCC0411 |  | _WV1112 |  | Imperial London | CLP course | Accommodation |  |  | 80
 | CC | ADCC0411 |  | _YPBG1112 |  | Imperial London | Accommodation | Refunded December |  |  | 160
 | CC | ADCC0411 |  | _SE2011 |  | EC Mainline | CLP course | Train travel |  |  | 331.1
 | CC | ADCC0411 |  | _RR11 |  | Ryman | Sundries | Stationery |  |  | 22.06
 | CC | CMCC0411 |  | _[NAME] |  | Parking CC | Parking | Car Park |  |  | 4.3
 | CC | CMCC0411 |  | _CP1112 |  | Tesco Stores | Sundries | Various |  |  | 9.36
 | CC | CMCC0411 |  | _RR11 |  | Parking CC | Parking | Car Park |  |  | 4.63
 | CC | CMCC0411 |  | _WV1112 |  | Parking CC | Parking | Car Park |  |  | 0.55
 | CC | CMCC0411 |  | _RG1112 |  | Parking CC | Parking | Car Park |  |  | 0.32
 | CC | CMCC0411 |  | OH6PO |  | Stewart & Co at the CI | Fast Track Fiction | Hospitality |  |  | 7.05
 | CC | CMCC0411 |  | OH12TF |  | Parking CC | Parking | Car Park |  |  | 2.63
 | CC | CMCC0411 |  | OH17DC |  | Parking CC | Parking | Car Park |  |  | 4.38
 | CC | CRCC0411 |  | OH13BC |  | Parking CC | Parking | Car Park |  |  | 0.57
 | CC | CRCC0411 |  | _YW1112 |  | Party Plastics LLP-DOM | Sundries | Plastic cups |  |  | 12.71
 | CC | CRCC0411 |  | _SE2011 |  | 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