Monthly Income and Expenditure      
        Actuals               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                       259.88 259.88 259.88 -140.12
Adverts 0.00                         0.00 0.00 0.00
Misc. Income 0.00 69.90[2]                     216.04[3] 285.94 285.94 285.94
Allotment Income 900.00       20.00     785.00 140.00         945.00 945.00 45.00
Grass Cutting & Parish Paths   940.00 186.00[4]   794.26[5]         186.00[6]       0.00[7] 1166.26 1166.26 226.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 475.92 94543.08 94543.08 4703.08
                                 
Parish Council Payments                                
Salaries                                
Clerk Salary 10000.00 900.96 838.08 777.80 1013.82 771.25 1303.82 1195.24[8] 1229.06[9] 1034.47[10] 1051.38[11] 1064.02[12] 1106.40[13] 12286.30 12286.30 2286.30[14]
Village Groundsman 600.00   171.28   144.63   117.78 54.41 35.80       0.00 523.90 523.90 -76.10
Play Area upkeep/bin emptying 1620.00 134.26[15] 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 134.26 1611.12 1611.12 -8.88
Inland Revenue PC Staff 5000.00 409.79 367.82 305.72 500.67 301.22 689.28 336.90[16] 354.75[17] 214.68[18] 226.10[19] 234.72[20] 263.18[21] 4204.83 4204.83 -795.17[22]
Sub Total 17220.00 1445.01 1511.44 1217.78 1793.38 1206.73 2245.14 1720.81 1753.87 1383.41 1411.74 1433.00 1503.84 18626.15 18626.15 1406.15
Administration                                
Clerk's expenses 20.00                         0.00 0.00[23] -20.00
Councillors' expenses 20.00                         0.00 0.00 -20.00
Audit Fees 800.00   37.50     480.00               517.50 517.50 -282.50
Insurance 2700.00 2574.03                     573.08[24] 3147.11 3147.11 447.11
Subscriptions/Membership Fees 850.00 35.00[25] 653.55[26]   145.00[27]           48.00     881.55 881.55 31.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 10.00 10.00 448.23 448.23 -51.77
Magazine/newsletter expenses 265.00 133.95             59.36[29]       46.19 239.50 239.50 -25.50
Training 0.00                         0.00 0.00 0.00
PWLB Loan 57620.00   28808.62             28808.62       57617.24 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 10.00 629.27 62851.13 62851.13 76.13
Village Amenities                                
Allotments 200.00 14.30[30]         52.00[31] 105.22[32] 43.60[33]     270.00[34]   485.12 485.12 285.12
Land Expenses 1500.00 304.00[35]   300.00       300.00     300.00     1204.00 1204.00 -296.00
Village Maintenance 2500.00 250.99[36]   800.00[37] 30.00[38] 110.00[39]     480.00[40] 498.00[41]   130.00[42]   2298.99 2298.99 -201.01
Bus Shelter Cleaning/maintenance 300.00   40.00 20.00 20.00 30.00 20.00 40.00 20.00   50.00     240.00 240.00 -60.00
Plant trees hedges  2800.00           1200.00[43] 2050.00[44]       1140.00   4390.00 4390.00 1590.00
Health & Safety 500.00     153.05[45] 445.80[46]     84.00[47] 32.50[48]   384.00[49] 114.00[50] 715.92[51] 1929.27 1929.27 1429.27[52]
Section 137 25.00               20.00[53]         20.00 20.00 -5.00
Play Park inspection RoSPA & maint. 350.00 99.60[54]       70.00               169.60 169.60 -180.40
Tractor and machinery maintenance 400.00 72.00[55]     43.74[56]   51.69   44.40[57]       81.60 293.43 293.43 -106.57
Fuel 750.00 106.84 94.73 174.64 274.92[58] 103.60 204.09   18.53         977.35 977.35 227.35[59]
Storage of equipment   520.00       260.00                 260.00 260.00 -260.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 1654.00 797.52 12267.76 12267.76 2422.76
                                     
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 3097.00 2930.63 93745.04 93745.04 3905.04
PC Variation 798.04[60]
                                         
        Monthly Income and Expenditure      
        Actuals               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 11980.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 1846.82 1914.60 1549.22 21686.70 21686.70 -732.50
Community Events Income/Donations       94.69[61]         728.00[62]           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.22 2913.00 2547.62 34490.19 34490.19 90.19
                                 
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 345.44 301.06 2754.65 2754.65 -245.35
VH Electric 2500.00   456.22     181.00     483.39     947.07 -119.93 1947.75 1947.75 -552.25
VH Water 900.00 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 13.35 18.31 165.16 165.16 -734.84
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[63]     25.00[64]   25.00[65] 201.26 645.19 645.19 -54.81
VH Consumables - contractor cleaning  1000.00 187.20   216.00 25.00[66]     25.00[67] 259.20         712.40 712.40 -287.60
VH Consumables - catering 1200.00 46.30 43.43     13.45 135.54 145.34 41.13 2.78     4.41 432.38 432.38 -767.62
VH Telephone 850.00   195.41   16.70[68] 184.43 17.30     65.97 141.68 206.76   828.25 828.25 -21.75
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 376.02 513.62 6773.69 6773.69 -1226.31
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 176.10 234.24 638.53 638.53 338.53[69]
VH Marketing/Social Events 100.00   30.00[70]                     30.00 30.00 -70.00
VH Maintenance and Equipment 3500.00 125.90[71] 1036.64[72]   6.12 252.00[73] 3214.88[74] 222.00[75] 25.00[76]     295.10[77]   5177.64 5177.64 1677.64
VH Service Contracts and Licence Fees 3250.00     95.76[78]   231.70[79] 216.00[80]       504.00[81]   912.00[82] 1959.46 1959.46 -1290.54
Recreation Field Grass Cutting 2500.00 327.60   448.50 257.40 261.30 460.20   105.30       0.00 1860.30 1860.30 -639.70[83]
Old Changing Rooms Main & Utilities 800.00 300.36 157.27[84] 74.83 36.71 113.48 156.71 36.71 69.07 32.00 53.20[85] 34.32 0.00 1064.66 1064.66 264.66[86]
VH Rates 4300.00 424.20 420.00 420.00 420.00 420.00 420.00 420.00 420.00 420.00 420.00     4204.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 2419.16 2064.97 30314.25 30314.25 -4085.75
 
  Village Hall Variation 4175.94[87]
                                     
Earmarked Reserves                                
Road safety measures - Wood End 2000.00                       0.00 0.00   -2000.00
Renovation of Barograph area   6000.00                       0.00[88] 0.00 0.00 -6000.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 0.00 0.00 0.00 0.00 -8000.00
 
                                       
Total Receipts       52907.78 2461.01 3045.09 2139.90 3537.03 45863.05 4487.26 3116.72 2709.32 2845.22 3013.83 3023.54 129149.75 129149.75  
Total Expenditure       9187.09 34868.64 4826.55 4699.17 4844.81 9160.22 6266.50 4986.65 32373.72 4473.95 5516.16 5043.05 126246.51 126246.51  
                                     
VAT                            
Rebate           15.65         100.83   116.48 116.48
Payments         423.87 111.18 96.92 159.47 279.88   255.78 292.57 293.83 226.27   47.45 2187.22 2187.22
[1]
User:
Precept 43800
Spt Grant 4286
[2]
User:
Recycling bin
[3]
Tracey:
found during end of year return.  Unallocated during the year
[4]
User:
Woodland Trust 2012/13
[5]
User:
Grass cutting grant
[6]
mandy:
woodland trust
[7]
User:
Woodland Trust FY2013/14
[8]
User:
Assumes mthly pay of £1175; deductions estimated iro. £125 assuming standard personal allowance.  Addl. Week allowed for handover.
[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:
Assumes mthly pay of £1175; deductions estimated @ £125 assuming standard personal allowance.
[14]
User:
Overspend reflects worst case should 23 hours per week be worked in all cases - in practice this should be an over-estimate.
[15]
User:
14 hours a month @ £9.59 per hour.
[16]
User:
Estimated reduced contributions assuming 944L tax code.
[17]
User:
Estimated reduced contributions assuming 944L 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:
Estimated reduced contributions assuming 901L tax code.
[22]
User:
Saving to offset salary increase - Line 17.
[23]
User:
This may increase depending on new Clerk requirements.
[24]
User:
Tractor and mower insurance - omitted from budget by mistake
[25]
.:
Data protection £35.00
[26]
User:
CAPALC
[27]
User:
SLCC
[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]
mandy:
new dip tank
[35]
.:
Feoffees rent £4.00
Field rent £300.00
[36]
User:
Fire hooks repair £125.99
Tree guard £125
[37]
User:
FY12/13 H&S review jobs
[38]
User:
Wasp removal - Meeting Walk
[39]
User:
Tree pruning in The Poplars and Recreation Field
[40]
mandy:
clearing of meeting walk
[41]
mandy:
repairs to fencing
[42]
mandy:
sign for boulder
resiting of picnic table
[43]
User:
Hedge cutting contract
[44]
User:
General Hedge Cutting and balance of hedge contract
[45]
User:
Dog exclusion order public notice
[46]
User:
Dog walk temporary fencing
[47]
mandy:
dog walk fence
[48]
mandy:
dog bin at meridian wood
[49]
mandy:
signs for dog walk
[50]
mandy:
new grit bin
[51]
mandy:
dog control order
[52]
User:
Dog walk fencing
[53]
User:
Poppy wreath
[54]
User:
Annual inspection
[55]
User:
Tractor battery
[56]
User:
Blades for J Deere
[57]
mandy:
new battery mower
[58]
User:
BCC 45.40
J Deere 57.00
Grasscutting 172.52
[59]
User:
Spend is weather dependent - monitoring new mower use
[60]
User:
Available funds against forecast income.
[61]
User:
Cambs Water rebate
[62]
User:
BCC Pitch Work
[63]
User:
Flip charts etc.
[64]
mandy:
window cleaning
[65]
mandy:
window cleaning
[66]
User:
Window cleaning
[67]
mandy:
windows
[68]
User:
Clerk BT calls - VH
[69]
User:
Caretaker tax code has altered for 13/14 - to be monitored thru year.
[70]
User:
Party in Park advert
[71]
User:
Drs Surgery leak £121.76
[72]
User:
Heating system repairs 818.64
Shower pipe repair 50.00
Rear entrance sec. key pad 168.00
[73]
User:
Fascia work 10% deposit
[74]
User:
Grass seed 1st pitch 65.00
BCC pitch work £873.60
Fascia work £2268
[75]
mandy:
back up battery for alarm and emergency callout for sewer work
[76]
mandy:
bike racks
[77]
mandy:
plumbing repairs
smoke alarm call out
[78]
User:
Fire extinguisher service
[79]
User:
VH Licence 180.00
BB light ctt 51.70
[80]
User:
Fire alarm ctt  216.00
BB lights ctt 50.04
[81]
User:

PPL/PRS licence
[82]
User:
Sec. & CCTV service
Sewage pump service
boiler service
[83]
User:
Weather dependent
[84]
User:
Gas meter removal 88.93
[85]
mandy:
21.20 for new lock and key for garage
[86]
User:
Standing charges for water, rates and electric. Electric heating to be monitored.
[87]
User:
Available funds against budget
[88]
User:
LHI bid contribution