Spreadsheet: 56465d1256655912-sumif-vlookup-combination-new-cash-flow-template
Sheet: Actual

Cash Flow Report:
Actuals
 | Current Week: | 54 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67
 |  |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | TOTAL | TOTAL
 |  |  |  | 2009-04-01 00:00:00 | 2009-04-06 00:00:00 | 2009-04-13 00:00:00 | 2009-04-20 00:00:00 | 2009-04-27 00:00:00 | 2009-05-04 00:00:00 | 2009-05-11 00:00:00 | 2009-05-18 00:00:00 | 2009-05-25 00:00:00 | 2009-06-01 00:00:00 | 2009-06-08 00:00:00 | 2009-06-15 00:00:00 | 2009-06-22 00:00:00 | 2009-06-29 00:00:00 | 2009-07-06 00:00:00 | 2009-07-13 00:00:00 | 2009-07-20 00:00:00 | 2009-07-27 00:00:00 | 2009-08-03 00:00:00 | 2009-08-10 00:00:00 | 2009-08-17 00:00:00 | 2009-08-24 00:00:00 | 2009-08-31 00:00:00 | 2009-09-07 00:00:00 | 2009-09-14 00:00:00 | 2009-09-21 00:00:00 | 2009-09-28 00:00:00 | 2009-10-05 00:00:00 | 2009-10-12 00:00:00 | 2009-10-19 00:00:00 | 2009-10-26 00:00:00 | 2009-11-02 00:00:00 | 2009-11-09 00:00:00 | 2009-11-16 00:00:00 | 2009-11-23 00:00:00 | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2009-03-29 00:00:00 | 2008/09 | 2009/10
 |  |  |  | 2009-04-05 00:00:00 | 2009-04-12 00:00:00 | 2009-04-19 00:00:00 | 2009-04-26 00:00:00 | 2009-05-03 00:00:00 | 2009-05-10 00:00:00 | 2009-05-17 00:00:00 | 2009-05-24 00:00:00 | 2009-05-31 00:00:00 | 2009-06-07 00:00:00 | 2009-06-14 00:00:00 | 2009-06-21 00:00:00 | 2009-06-28 00:00:00 | 2009-07-05 00:00:00 | 2009-07-12 00:00:00 | 2009-07-19 00:00:00 | 2009-07-26 00:00:00 | 2009-08-02 00:00:00 | 2009-08-09 00:00:00 | 2009-08-16 00:00:00 | 2009-08-23 00:00:00 | 2009-08-30 00:00:00 | 2009-09-06 00:00:00 | 2009-09-13 00:00:00 | 2009-09-20 00:00:00 | 2009-09-27 00:00:00 | 2009-10-04 00:00:00 | 2009-10-11 00:00:00 | 2009-10-18 00:00:00 | 2009-10-25 00:00:00 | 2009-11-01 00:00:00 | 2009-11-08 00:00:00 | 2009-11-15 00:00:00 | 2009-11-22 00:00:00 | 2009-11-29 00:00:00 | 2009-12-06 00:00:00 | 2009-12-13 00:00:00 | 2009-12-20 00:00:00 | 2009-12-27 00:00:00 | 2010-01-03 00:00:00 | 2010-01-10 00:00:00 | 2010-01-17 00:00:00 | 2010-01-24 00:00:00 | 2010-01-31 00:00:00 | 2010-02-07 00:00:00 | 2010-02-14 00:00:00 | 2010-02-21 00:00:00 | 2010-02-28 00:00:00 | 2010-03-07 00:00:00 | 2010-03-14 00:00:00 | 2010-03-21 00:00:00 | 2010-03-28 00:00:00 | 2009-03-31 00:00:00
 |  |  |  | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000 | £'000
 | Receipts
 |  | Rent |  | 322 | 2622 | 8377.75 | 3000 | 22794.81 | 5175 | 4571.25 | 51750 | 862.5 | 862.5 | 5819.98 | 15764.78 | 1403.98 | 8498.59 | 966 | 3638.76 | 7702.13 | 4740.99 | 8377.75 | 6258.97 | 17630.95 | 7702.13 | 7475 | 482.59 | 300 | 2366.61 | 2173.5 | 520 | 4122.75 | 52529.13 | 2484.59 | 8277.03 | 5141.65 | 3162.5 | 4479.19 | 4122.57 | 8337.5 | 16095.16 | 15223.99 | 1003.16 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 327139.74
 |  | Service Charge |  | 200 | 2019.9 | 3450 | 2500 | 2300 | 200 | 645 | 1435.37 | 800.86 | 188.6 | 2875 | 479.55 | 23805 | 1786.92 | 10465 | 146.51 | 175 | 4183.14 | 1084.22 | 1084.22 | 1084.22 | 1084.22 | 1084.22 | 100.73 | 129.87 | 536.17 | 67.18 | 67.18 | 242.15 | 18 | 814.79 | 226.69 | 131.9 | 703.45 | 67.18 | 254.86 | 131.9 | 129.87 | 45 | 321.95 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 67065.81999999999
 |  | Events |  | 3090.84 | 224.25 | 800 | 175 | 900 | 175 | 525 | 1600 | 525 | 525 | 525 | 695 | 1575 | 1050 | 1050 | 700 | 1225 | 1980 | 875 | 525 | 350 | 787.5 | 700 | 787.5 | 7440.5 | 8395 | 42780 | 5980 | 1150 | 11500 | 5750 | 5750 | 5750 | 5750 | 6325 | 6325 | 12.59 | 400 | 400 | 400 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 135473.18
 |  | Exhibitions |  | 400 | 400 | 400 | 400 | 575 | 400 | 400 | 400 | 1100 | 152.5 | 944.73 | 966 | 14432.5 | 368.21 | 100.73 | 60 | 400 | 421 | 421 | 421 | 421 | 421 | 421 | 75 | 60 | 58.5 | 323 | 3048.57 | 2142.97 | 150 | 450.75 | 369.91 | 9057.4 | 5047.35 | 645 | 300.04 | 920 | 970 | 11.51 | 575 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 48630.67
 |  | Development |  | 34 | 207.02 | 535.44 | 575 | 1369 | 745.2 | 3292.45 | 4370 | 3220 | 2760 | 4140 | 4140 | 1000 | 1000 | 799.95 | 300 | 577.32 | 577.32 | 577.32 | 577.32 | 131.9 | 267 | 67.33 | 37950 | 78847.34 | 3060.13 | 28750 | 55607.45 | 1500 | 641.2 | 115 | 637.2 | 24966.5 | 800 | 2250 | 2250 | 2250 | 2250 | 2250 | 2250 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 277638.39
 |  | Other |  | 2250 | 2250 | 100 | 453.26 | 81.77 | 273.7 | 150 | 350 | 175 | 3150 | 75 | 450 | 350 | 100 | 100 | 244.84 | 8.27 | 2250 | 75 | 175 | 275 | 100 | 175 | 100 | 421.12 | 45.3 | 100 | 2550 | 75 | 525 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 | 2850 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 45928.26
 | Total Receipts |  |  | 6296.84 | 7723.17 | 13663.19 | 7103.26 | 28020.58 | 6968.9 | 9583.7 | 59905.37 | 6683.360000000001 | 7638.6 | 14379.71 | 22495.33 | 42566.48 | 12803.72 | 13481.68 | 5090.110000000001 | 10087.72 | 14152.45 | 11410.29 | 9041.51 | 19893.07 | 10361.85 | 9922.55 | 39495.82 | 87198.82999999999 | 14461.71 | 74193.68 | 67773.2 | 9232.869999999999 | 65363.32999999999 | 12465.13 | 18110.83 | 47897.45 | 18313.3 | 16616.37 | 16102.47 | 14501.99 | 22695.03 | 20780.5 | 7400.11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 901876.0599999998
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0
 | Expenditure |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 0
 |  | Payroll: | Net Pay | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 | -1000 | -1500 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -50000
 |  |  | PAYE / NI | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 | -100 | -150 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -5000
 |  | VAT |  | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 | -5000 | -2000 | -1000 | -5000 | -500 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -108000
 |  | Suppliers |  | -100 | -200 | -400 | -50000 | -4000 | -250 | -100 | -200 | -400 | -50000 | -4000 | -250 | -993.6 | -19334.38 | -6.57 | -16772.27 | -1725 | -1278.26 | -557.3 | -157.71 | -192.75 | -18.6 | -512.5 | -87.5 | -512.5 | -87.5 | -512.5 | -87.5 | -512.5 | -87.5 | -512.5 | -87.5 | -512.5 | -29.89 | -3 | -2060 | -546.01 | -36.12 | -230 | -460.36 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -157814.32
 |  | Direct Debit |  | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 | -20 | -30 | -120 | -150 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -3200
 |  | Bank: | Charges | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 | -150 | -40 | -1 | -20 | -30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -1738
 |  |  | Capital | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 | -50000 | -200 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | -1004000
 | Total Expenditure |  |  | -56221 | -4100 | -52650 | -57150 | -55660 | -7131 | -53340 | -3230 | -56670 | -52420 | -60221 | -4270 | -53143.6 | -26364.38 | -51766.57 | -23773.27 | -54865 | -4188.26 | -56927.3 | -2697.71 | -56313.75 | -3918.6 | -52762.5 | -7237.5 | -52172.5 | -6968.5 | -53752.5 | -3117.5 | -56782.5 | -2507.5 | -56733.5 | -4107.5 | -52662.5 | -7059.89 | -51763 | -9061 | -53686.01 | -2946.12 | -56450 | -2960.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | -1329752.32
 |  |  |  | Excel [NAME]: |  | I am wanting to get the data on the 'Year data' tab put into the above table (It is currently cut and paste into there, as I will need to up date this weekly, it would be good to be formula driven)
 |  |  |  |  |  | I am wanting the information to be split over the above categories acording to the information in column F on the Year data tab.
 |  |  |  |  |  | I am also wanting the information to be allocated to the week it happened in per colmun D in Year data.
 |  |  |  |  |  | Note: I have simplified the year date. Some weeks there will be up to 50 transactions per category e.g. rent, and they will all be sprodic amounts.