Monthly Income and Expenditure      
        Actuals         Forecast     Forecast
Area of Activity   Budget Apr 13 May 13 Jun 13 Jul 13 Aug 13 Sep 13 Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Total  Total v.
                                  Actuals Forecast Budget
Parish Council Receipts                                
Grants 0.00                         0.00 0.00 0.00
Precept & Council Tax Support Grant 87600.00 48086.00[1]         43800.00             91886.00 91886.00 4286.00
Interest 400.00                       400.00 0.00 400.00 0.00
Adverts 0.00                         0.00 0.00 0.00
Misc. Income 0.00 69.90[2]                       69.90 69.90 69.90
Allotment Income 900.00       20.00     785.00 140.00         805.00 945.00 45.00
Grass Cutting & Parish Paths   940.00 186.00[3]   794.26[4]         186.00[5]       186.00[6] 980.26 1352.26 412.26
Total Parish Council Receipts   89840.00 48341.90 0.00 794.26 20.00 0.00 43800.00 785.00 326.00 0.00 0.00 0.00 586.00 93741.16 94653.16 4813.16
                                 
Parish Council Payments                                
Salaries                                
Clerk Salary 10000.00 900.96 838.08 777.80 1013.82 771.25 1303.82 1195.24[7] 1229.06[8] 1034.47[9] 1051.38[10] 1050.00[11] 1050.00[12] 6800.97 12215.88 2215.88[13]
Village Groundsman 600.00   171.28   144.63   117.78 54.41 35.80       50.00 488.10 573.90 -26.10
Play Area upkeep/bin emptying 1620.00 134.26[14] 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 939.82 1611.12 -8.88
Inland Revenue PC Staff 5000.00 409.79 367.82 305.72 500.67 301.22 689.28 336.90[15] 354.75[16] 214.68[17] 226.10[18] 250.00[19] 250.00[20] 2911.40 4206.93 -793.07[21]
Sub Total 17220.00 1445.01 1511.44 1217.78 1793.38 1206.73 2245.14 1720.81 1753.87 1383.41 1411.74 1434.26 1484.26 11140.29 18607.83 1387.83
Administration                                
Clerk's expenses 20.00                       20.00 0.00 20.00[22] 0.00
Councillors' expenses 20.00                       20.00 0.00 20.00 0.00
Audit Fees 800.00   37.50     480.00           40.00   517.50 557.50 -242.50
Insurance 2700.00 2574.03                     525.00[23] 2574.03 3099.03 399.03
Subscriptions/Membership Fees 850.00 35.00[24] 653.55[25]   145.00[26]           48.00   30.00[27] 833.55 911.55 61.55
Elections 0.00                         0.00 0.00 0.00
Professional fees - legal etc. 0.00                         0.00 0.00 0.00
General admin 500.00 130.17[28] 68.58 2.00 61.20 14.73 42.85 10.00 78.70 10.00 10.00 61.80   329.53 490.03 -9.97
Magazine/newsletter expenses 265.00 133.95             59.36[29]     50.00   133.95 243.31 -21.69
Training 0.00                         0.00 0.00 0.00
PWLB Loan 57620.00   28808.62             28808.62       28808.62 57617.24 -2.76
Sub Total 62775.00 2873.15 29568.25 2.00 206.20 494.73 42.85 10.00 138.06 28818.62 58.00 151.80 595.00 33197.18 62958.66 183.66
Village Amenities                                
Allotments 200.00 14.30[30]         52.00[31] 105.22[32] 43.60[33]       120.70 171.52 335.82 135.82
Land Expenses 1500.00 304.00[34]   300.00       300.00     300.00   300.00 904.00 1504.00 4.00
Village Maintenance 2500.00 250.99[35]   800.00[36] 30.00[37] 110.00[38]     480.00[39] 498.00[40]     1309.01 1190.99 3478.00 978.00
Bus Shelter Cleaning/maintenance 300.00   40.00 20.00 20.00 30.00 20.00 40.00 20.00   50.00   50.00 170.00 290.00 -10.00
Plant trees hedges  2800.00           1200.00[41] 2050.00[42]         500.00[43] 3250.00 3750.00 950.00
Health & Safety 500.00     153.05[44] 445.80[45]     84.00[46] 32.50[47]   384.00[48] 153.05[49] 193.90[50] 682.85 1446.30 946.30[51]
Section 137 25.00               20.00[52]         0.00 20.00 -5.00
Play Park inspection RoSPA & maint. 350.00 99.60[53]       70.00             250.40 169.60 420.00 70.00
Tractor and machinery maintenance 400.00 72.00[54]     43.74[55]   51.69   44.40[56]       328.00 167.43 539.83 139.83
Fuel 750.00 106.84 94.73 174.64 274.92[57] 103.60 204.09   18.53       100.00 958.82 1077.35 327.35[58]
Storage of equipment   520.00       260.00             260.00   260.00 520.00 0.00
Sub Total 9845.00 847.73 134.73 1447.69 1074.46 313.60 1527.78 2579.22 659.03 498.00 734.00 413.05 3152.01 7925.21 13381.30 3536.30
                                     
Total Parish Council Payments   89840.00 5165.89 31214.42 2667.47 3074.04 2015.06 3815.77 4310.03 2550.96 30700.03 2203.74 1999.11 5231.27 52262.68 94947.79 5107.79
PC Variation -294.63[59]
                                         
        Monthly Income and Expenditure      
        Actuals         Forecast     Forecast
Area of Activity   Budget Apr 13 May 13 Jun 13 Jul 13 Aug 13 Sep 13 Oct 13 Nov 13 Dec 13 Jan 14 Feb 14 Mar 14 Total  Total v.
                                  Actuals Forecast Budget
                                 
Village Hall Receipts                                
VH doctors rent 11980.80 998.40 998.40 998.40 998.40 998.40 998.40 998.40 998.40 998.40 998.40 998.40 998.40 6988.80 11980.80 0.00
VH lettings based on bookings to date 22419.20 3567.48 1367.92 1252.43 1121.50 2538.63 1049.00 1975.86 1792.32 1710.92 1847.22 1970.00 1970.00 12872.82 22163.28 -255.92
Community Events Income/Donations       94.69[60]         728.00[61]           822.69 822.69 822.69
Total Village Hall Receipts   34400.00 4565.88 2461.01 2250.83 2119.90 3537.03 2047.40 3702.26 2790.72 2709.32 2845.62 2968.40 2968.40 20684.31 34966.77 566.77
                                 
Village Hall Payments                                
VH Gas 3000.00 400.32 252.98 314.02 95.35 76.19 76.07 109.73 191.10 282.42 309.97 350.00 350.00 1324.66 2808.15 -191.85
VH Electric 2500.00   456.22     181.00     483.39     500.00   637.22 1620.61 -879.39
VH Water 900.00 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 15.00 15.00 93.45 163.50 -736.50
VH Insurance 1500.00 1119.99                       1119.99 1119.99 -380.01
VH Consumables - cleaning etc. 700.00 18.12 180.52     118.52 76.77[62]     25.00[63]   125.00 0.00 393.93 543.93 -156.07
VH Consumables - contractor cleaning  1000.00 187.20   216.00 25.00[64]     25.00[65] 259.20     200.00   453.20 912.40 -87.60
VH Consumables - catering 1200.00 46.30 43.43     13.45 135.54 145.34 41.13 2.78       384.06 427.97 -772.03
VH Telephone 850.00   195.41   16.70[66] 184.43 17.30     65.97 141.68 200.00   413.84 821.49 -28.51
VH Staff Costs 8000.00 605.54 679.24 501.70 575.61 644.76 546.69 678.07 530.44 531.78 590.22 600.00 600.00 4231.61 7084.05 -915.95
VH Staff Inland Revenue Payments 300.00 28.45 77.98 -22.00 19.42 39.69 10.94 50.49 5.14 6.56 11.52 30.00 30.00 204.97 288.19 -11.81[67]
VH Marketing/Social Events 100.00   30.00[68]                     30.00 30.00 -70.00
VH Maintenance and Equipment 3500.00 125.90[69] 1036.64[70]   6.12 252.00[71] 3214.88[72] 222.00[73] 25.00[74]         4857.54 4882.54 1382.54
VH Service Contracts and Licence Fees 3250.00     95.76[75]   231.70[76] 216.00[77]       504.00[78] 300.00[79] 1500.00[80] 543.46 2847.46 -402.54
Recreation Field Grass Cutting 2500.00 327.60   448.50 257.40 261.30 460.20   105.30     100.00 250.00 1755.00 2210.30 -289.70[81]
Old Changing Rooms Main & Utilities 800.00 300.36 157.27[82] 74.83 36.71 113.48 156.71 36.71 69.07 32.00 53.20[83] 40.00 5.00 876.07 1075.34 275.34[84]
VH Rates 4300.00 424.20 420.00 420.00 420.00 420.00 420.00 420.00 420.00 420.00 420.00     2944.20 4204.20 -95.80
Total Village Hall Payments   34400.00 3597.33 3543.04 2062.16 1465.66 2549.87 5344.45 1700.69 2143.12 1379.86 2043.94 2460.00 2750.00 20263.20 31040.12 -3359.88
 
  Village Hall Variation 3926.65[85]
                                       
Earmarked Reserves                                
Road safety measures - Wood End 2000.00                     2000.00   0.00    
Renovation of Barograph area   6000.00                       6000.00[86] 0.00 6000.00 0.00
Total Earmarked Reserves   8000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2000.00 6000.00 0.00 6000.00 0.00
 
                                       
Total Receipts       52907.78 2461.01 3045.09 2139.90 3537.03 45863.05 4487.26 3116.72 2709.32 2845.62 2968.40 3554.40 114441.12 129635.58  
Total Expenditure       9187.09 34868.64 4826.55 4699.17 4844.81 9160.22 6266.50 4986.65 32373.72 4473.95 4459.11 7981.27 73852.98 128127.68  
                                     
VAT                            
Rebate           15.65             15.65 15.65
Payments         423.87 111.18 96.92 159.47 279.88   255.78 292.57 293.83 226.27     2139.77 2139.77
[1]
User:
Precept 43800
Spt Grant 4286
[2]
User:
Recycling bin
[3]
User:
Woodland Trust 2012/13
[4]
User:
Grass cutting grant
[5]
mandy:
woodland trust
[6]
User:
Woodland Trust FY2013/14
[7]
User:
Assumes mthly pay of £1175; deductions estimated iro. £125 assuming standard personal allowance.  Addl. Week allowed for handover.
[8]
User:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[9]
User:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[10]
User:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[11]
User:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[12]
User:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[13]
User:
Overspend reflects worst case should 23 hours per week be worked in all cases - in practice this should be an over-estimate.
[14]
User:
14 hours a month @ £9.59 per hour.
[15]
User:
Estimated reduced contributions assuming 944L tax code.
[16]
User:
Estimated reduced contributions assuming 944L tax code.
[17]
User:
Estimated reduced contributions assuming 901L tax code.
[18]
User:
Estimated reduced contributions assuming 901L tax code.
[19]
User:
Estimated reduced contributions assuming 901L tax code.
[20]
User:
Estimated reduced contributions assuming 901L tax code.
[21]
User:
Saving to offset salary increase - Line 17.
[22]
User:
This may increase depending on new Clerk requirements.
[23]
User:
Tractor and mower insurance - omitted from budget by mistake
[24]
.:
Data protection £35.00
[25]
User:
CAPALC
[26]
User:
SLCC
[27]
User:
Cambs ACRE
[28]
User:
Computer payment £49.42
Printer inks £80.75
[29]
mandy:
recruitment flyer cllrs
[30]
User:
Water
[31]
User:
Refund - Chapman
Wasp clearance £42.00
[32]
mandy:
water rates
[33]
mandy:
wasps nest and key deposit refund
[34]
.:
Feoffees rent £4.00
Field rent £300.00
[35]
User:
Fire hooks repair £125.99
Tree guard £125
[36]
User:
FY12/13 H&S review jobs
[37]
User:
Wasp removal - Meeting Walk
[38]
User:
Tree pruning in The Poplars and Recreation Field
[39]
mandy:
clearing of meeting walk
[40]
mandy:
repairs to fencing
[41]
User:
Hedge cutting contract
[42]
User:
General Hedge Cutting and balance of hedge contract
[43]
User:
Wedge for tree inspection as needed
[44]
User:
Dog exclusion order public notice
[45]
User:
Dog walk temporary fencing
[46]
mandy:
dog walk fence
[47]
mandy:
dog bin at meridian wood
[48]
mandy:
signs for dog walk
[49]
User:
Dog exclusion order public notice
[50]
User:
Wedge for h&s review tasks
[51]
User:
Dog walk fencing
[52]
User:
Poppy wreath
[53]
User:
Annual inspection
[54]
User:
Tractor battery
[55]
User:
Blades for J Deere
[56]
mandy:
new battery mower
[57]
User:
BCC 45.40
J Deere 57.00
Grasscutting 172.52
[58]
User:
Spend is weather dependent - monitoring new mower use
[59]
User:
Available funds against forecast income.
[60]
User:
Cambs Water rebate
[61]
User:
BCC Pitch Work
[62]
User:
Flip charts etc.
[63]
mandy:
window cleaning
[64]
User:
Window cleaning
[65]
mandy:
windows
[66]
User:
Clerk BT calls - VH
[67]
User:
Caretaker tax code has altered for 13/14 - to be monitored thru year.
[68]
User:
Party in Park advert
[69]
User:
Drs Surgery leak £121.76
[70]
User:
Heating system repairs 818.64
Shower pipe repair 50.00
Rear entrance sec. key pad 168.00
[71]
User:
Fascia work 10% deposit
[72]
User:
Grass seed 1st pitch 65.00
BCC pitch work £873.60
Fascia work £2268
[73]
mandy:
back up battery for alarm and emergency callout for sewer work
[74]
mandy:
bike racks
[75]
User:
Fire extinguisher service
[76]
User:
VH Licence 180.00
BB light ctt 51.70
[77]
User:
Fire alarm ctt  216.00
BB lights ctt 50.04
[78]
User:

PPL/PRS licence
[79]
mandy:
boiler service
[80]
User:
Sec. & CCTV service
Sewage pump service
[81]
User:
Weather dependent
[82]
User:
Gas meter removal 88.93
[83]
mandy:
21.20 for new lock and key for garage
[84]
User:
Standing charges for water, rates and electric. Electric heating to be monitored.
[85]
User:
Available funds against budget
[86]
User:
Wedge - work yet to be scoped