Spreadsheet: 111500d1307880624-summarising-data-from-multiple-worksheets-cashbook-sample-2
Sheet: Data

Date | Source | Transaction Type | Invoice ref | Bank Ref | Cost Centre | Invoice number | Paid To | Budget Header | Description | VAT CODE | Total invoice amount | VAT amount | Net Amount
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | _RG1112 |  | [NAME] | Research & Development | Books | Z | 24.24
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | OH2SU | IBM201734 | [NAME] | Office sundries | Coffee, tea for office | Z | 6
2007-04-03 00:00:00 | Bank | BULKPAY | 000011 | 11120001 | OH2SU |  | [NAME] | Research & Development |  | S | 114
2011-04-01 00:00:00 | Bank | D/D | 001540 |  | OH18PD | MA40384 | [NAME] | Subscriptions | Misc | S | 22.5
2011-04-04 00:00:00 | Bank | BULKPAY | 000003 | 11120001 | OH18PD | 8745932 | [NAME] | Research & Development | Project A | Z | 250
2011-04-04 00:00:00 | Bank | BULKPAY | 000016 | 11120001 | _RR11 |  | [NAME] | Previews | Project B | S | 2400
2011-04-04 00:00:00 | Bank | BULKPAY | 000002 | 11120001 | _WV1112 |  | [NAME] | Writer Lecturer | Writers fee | Z | 500
2011-04-04 00:00:00 | Bank | BULKPAY | 000001 | 11120001 | _YPBG1112 |  | [NAME] | Reader in Residence | Fee | Z | 100
2011-04-04 00:00:00 | Bank | BULKPAY | 000015 | 11120001 | _SE2011 | 14sh934vv | [NAME] | Photography | Project C | Z | 300
2011-04-04 00:00:00 | Bank | CHQ | 000005 | 6017 | _RR11 | 1112SJKHH2 | The National Trust | Reading Groups | Meetings | S | 42
2011-04-04 00:00:00 | Bank | CHQ | 000013 | 6018 | _[NAME] |  | [NAME] | Festival | Travel | Z | 211
2011-04-04 00:00:00 | Bank | CHQ | 000006 | 6019 | _CP1112 |  | [NAME] | Research & Development | Travel | S | 252
2011-04-04 00:00:00 | Bank | CHQ | 000010 | 6020 | _RR11 |  | [NAME] | Research & Development | Freelance support | Z | 100
2011-04-04 00:00:00 | Bank | CHQ | 000004 | 6021 | _WV1112 | [NAME] | [NAME] | Accommodation | Writers expenses | S | 240
2011-04-04 00:00:00 | Bank | CHQ | 000007 | 6022 | _RG1112 |  | [NAME] | Research & Development | Books | Z | 9.26
2011-04-04 00:00:00 | Bank | CHQ | 000014 | 6023 | OH6PO |  | Digital Communications Limited | Franking machine consumables | Cartridges | Z | 89.02
2011-04-05 00:00:00 | Bank | D/D |  |  | OH12TF |  | Vodafone | Telephone & Broadband | April | Z | 142.97
2011-04-11 00:00:00 | Bank | SO |  |  | OH17DC |  | Inovica | Website hosting | Website.com | S | 79.2
2011-04-14 00:00:00 | Bank | D/D |  |  | OH13BC |  | Barclays Bank | Service Charges | Fees | Z | 26.98
2011-04-14 00:00:00 | Credit Card | CC | ADCC0411 |  | OH6PO |  | Parcel2Go | Parcels | Credit | Z | 100
2011-04-15 00:00:00 | Bank | SO |  |  | _YW1112 |  | [NAME] | Workshops | April | Z | 200
2011-04-15 00:00:00 | Bank | D/D |  |  | _SE2011 | 346580 | Travelodge | Accommodation | Guest accommodation | S | 835.9200000000001
2011-04-15 00:00:00 | Bank | CHQ |  | 6024 | OH1PC |  | Cash | Petty Cash | Cash | Z | 100
2011-04-15 00:00:00 | Bank | BULKPAY |  | 2 | OH15SAL |  | [NAME] | Deputy Director | April | Z | 2196.31
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH16TRS |  | RAC Motoring Services | Breakdown cover | Essential Car User | Z | 119.19
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 2.47
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 5.13
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 0.45
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 5.9
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH3TR |  | Imperial London | CLP course | Accommodation | Z | 80
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH16TRS |  | Imperial London | Accommodation | Refunded December | Z | 160
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | OH3TR |  | EC Mainline | CLP course | Train travel | Z | 331.1
2011-04-15 00:00:00 | Credit Card | CC | ADCC0411 |  | _DBF10 |  | Ryman | Sundries | Stationery | Z | 22.06
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 4.3
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | _DBF10 |  | Tesco Stores | Sundries | Various | Z | 9.36
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 4.63
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 0.55
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 0.32
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | _ADV1011 |  | Stewart & Co at the CI | Fast Track Fiction | Hospitality | Z | 7.05
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 2.63
2011-04-15 00:00:00 | Credit Card | CC | CMCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 4.38
2011-04-15 00:00:00 | Credit Card | CC | CRCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 0.57
2011-04-15 00:00:00 | Credit Card | CC | CRCC0411 |  | _DBF10 |  | Party Plastics LLP-DOM | Sundries | Plastic cups | Z | 12.71
2011-04-15 00:00:00 | Credit Card | CC | CRCC0411 |  | OH5RE |  | Parking CC | Parking | Car Park | Z | 4.7
2011-04-20 00:00:00 | Petty Cash | PC | 2002-04-01 00:00:00 |  | _CP1112 |  | Taxi | Russia Day | Travel | Z | 5
2011-04-26 00:00:00 | Petty Cash | PC | 2001-04-01 00:00:00 |  | OH2SU |  | Milk | Sundries | Milk | Z | 0.59
2011-05-03 00:00:00 | Petty Cash | PC | 2001-05-01 00:00:00 |  | OH5RE |  | [NAME] | Parking | Manors | Z | 10.7
2011-05-09 00:00:00 | Petty Cash | PC | 2002-05-01 00:00:00 |  | OH5RE |  | [NAME] | Parking | Manors | Z | 9.5
2011-05-20 00:00:00 | Petty Cash | PC | 2003-05-01 00:00:00 |  | OH2SU |  | Asda | Office expenses | Sundries | Z | 9.36
2011-05-20 00:00:00 | Petty Cash | PC | 2004-05-01 00:00:00 |  | OH2SU |  | Newsagent | Newspapers & Magazines | Newspapers | Z | 2
2011-05-23 00:00:00 | Petty Cash | PC | 2005-05-01 00:00:00 |  | OH2SU |  | [NAME] | Office expenses | Washing up liquid | Z | 1
2011-05-24 00:00:00 | Petty Cash | PC | 2006-05-01 00:00:00 |  | OH16TRS |  | [NAME] | Staff Expenses | Travel & Subsistence | Z | 24.45
2011-05-27 00:00:00 | Petty Cash | PC | 2007-05-01 00:00:00 |  | OH2SU |  | Superdrug | Sundries | Batteries | Z | 4.99
2011-06-03 00:00:00 | Petty Cash | PC | 2001-06-01 00:00:00 |  | OH2SU |  | Wilkinsons | Sundries | Teatowels and washing up bowl | Z | 5.97
2011-06-09 00:00:00 | Petty Cash | PC | 2002-06-01 00:00:00 |  | OH2SU |  | Wilkinsons | Sundries | Washing up liquid, gaffer tape, cling film | Z | 4.91