Monthly Income and Expenditure      
        Actuals Actuals Actuals Actuals Actuals forecast forecast forecast forecast forecast forecast forecast     Forecast
Area of Activity   Budget Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec-14 Jan-15 Feb-15 Mar-15 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 43800.00           43800.00           87600.00 87600.00 0.00
Interest 500.00                         0.00 0.00 -500.00
Adverts 0.00                         0.00 0.00 0.00
Misc. Income 0.00       147.40[1]     7500           7647.40 7647.40 7647.40
Allotment Income 920.00 22.00         1030.00             1052.00 1052.00 132.00
Grass Cutting & Parish Paths   1000.00 186.00     794.26[2]                 980.26 980.26 -19.74
Total Parish Council Receipts   90020.00 44008.00 0.00 0.00 941.66 0.00 1030.00 51300.00 0.00 0.00 0.00 0.00 0.00 97279.66 97279.66 7259.66
                                 
Parish Council Payments                                
Salaries                                
Clerk Salary 13000.00 738.67 1177.37[3] 1258.14 1033.80 1025.24 1025.00 1025.00 1025.00 1025.00 1025.00 1025.00 1025.00 12408.22 12408.22 -591.78[4]
Village Groundsman 600.00   232.10 98.05 103.54   105.00 105.00           643.69 643.69 43.69
Play Area upkeep/bin emptying 1620.00 135.66 135.66 135.66 135.66 135.66 135.66 135.66 135.66 135.66 135.66 135.66 135.66 1627.92 1627.92 7.92
outstanding bank holiday payment   2806.52                       2806.52 2806.52 2806.52[5]
Inland Revenue PC Staff 2500.00 22.19 176.94 386.89 209.77 178.37 205.00 205.00 150.00 150.00 150.00 150.00 150.00 2134.16 2134.16 -365.84[6]
Sub Total   17720.00 3703.04 1722.07 1878.74 1482.77 1339.27 1470.66 1470.66 1310.66 1310.66 1310.66 1310.66 1310.66 19620.51 19620.51 1900.51
Administration                                
Clerk's expenses 20.00                         0.00 0.00[7] -20.00
Councillors' expenses 20.00                         0.00 0.00 -20.00
Audit Fees 600.00     71.88   480.00               551.88 551.88 -48.12
Insurance 3216.00   1745.29[8]                     1745.29 1745.29 -1470.71
Subscriptions/Membership Fees 450.00 35.00 685.57[9]   147.00[10]                 867.57 867.57 417.57
Elections 0.00                         0.00 0.00 0.00
Professional fees - legal etc. 0.00                         0.00 0.00 0.00
General admin 400.00 19.60 31.29 43.75 12.15[11] 93.72[12] 40.00 40.00 40.00 40.00 40.00 40.00 40.00 480.51 480.51 80.51
Magazine/newsletter expenses 200.00       190.03[13]     150.00           340.03 340.03 140.03
Training 0.00   169.30[14]   235.00[15]                 404.30 404.30 404.30
PWLB Loan 57620.00   28808.62           28808.62         57617.24 57617.24 -2.76
Sub Total   62526.00 54.60 31440.07 115.63 584.18 573.72 40.00 190.00 28848.62 40.00 40.00 40.00 40.00 62006.82 62006.82 -519.18
Village Amenities                                
Allotments 200.00 32.77     36.80[16]   30.00             99.57 99.57 -100.43
Land Expenses 1504.00 304.00   300.00     300.00     300.00     300.00 1504.00 1504.00 0.00
Village Maintenance 2500.00   67.98 275.00[17] 138.19[18] 233.20[19] 250.00 250.00 250.00 250.00 250.00 250.00 250.00 2464.37 2464.37 -35.63
Bus Shelter Cleaning/maintenance 300.00 60.00 20.00 20.00   50.00 20.00 20.00 20.00 20.00 20.00 20.00 20.00 290.00 290.00 -10.00
Plant trees hedges  2400.00             2400.00           2400.00 2400.00 0.00
Health & Safety 450.00   27.25                     27.25 27.25 -422.75[20]
Section 137 50.00                         0.00 0.00 -50.00
Play Park inspection RoSPA & maint. 350.00 99.60                       99.60 99.60 -250.40
Tractor and machinery maintenance 300.00 54.00                       54.00 54.00 -246.00
Fuel 1200.00 150.37[21] 197.94[22] 114.83[23] 143.39[24] 85.05 150.00 150.00 150.00 150.00 150.00 150.00 150.00 1741.58 1741.58 541.58[25]
Storage of equipment   520.00 260.00   260.00                   520.00 520.00 0.00
Sub Total 9774.00 960.74 313.17 969.83 318.38 368.25 750.00 2820.00 420.00 720.00 420.00 420.00 720.00 9200.37 9200.37 -573.63
                                     
Total Parish Council Payments   90020.00 4718.38 33475.31 2964.20 2385.33 2281.24 2260.66 4480.66 30579.28 2070.66 1770.66 1770.66 2070.66 90827.70 90827.70 807.70
PC Variation 6451.96[26]
                                         
        Monthly Income and Expenditure      
        Actuals Actuals Actuals Actuals Actuals forecast forecast forecast forecast forecast forecast forecast     Forecast
Area of Activity   Budget Apr 14 May 14 Jun 14 Jul 14 Aug 14 Sep 14 Oct 14 Nov 14 Dec-14 Jan 15 Feb 15 Mar-15 Total  Total v.
                                  Actuals Forecast Budget
                                 
Village Hall Receipts                                
VH doctors rent 13224.00 1723.60[27] 1101.60 1413.60[28] 1101.60 1101.60 1473.60 1101.60 1101.60 1413.60 1101.60 1101.60 1413.60 15149.20 15149.20 1925.20
VH lettings based on bookings to date 22291.00 1308.32 2282.62 2444.46 1313.36 1639.12 1602.00 1397.00 1462.00 1313.00 1462.00 1462.00 1462.00 19147.88 19147.88 -3143.12
Misc Income       519.89[29] 24.00[30]                 543.89 543.89 543.89
Community Events Income/Donations   750.00               500.00         500.00 500.00 -250.00
Total Village Hall Receipts   36265.00 3031.92 3384.22 4377.95 2438.96 2740.72 3075.60 2498.60 3063.60 2726.60 2563.60 2563.60 2875.60 35340.97 35340.97 -924.03
                                 
Village Hall Payments                                
VH Gas 3000.00 308.34 213.59 145.58 -185.87[31] 81.28 80.00 150.00 150.00 150.00 150.00 150.00 150.00 1542.92 1542.92 -1457.08
VH Electric 2250.00   491.02   294.57   295.00   491.00   491.00     2062.59 2062.59 -187.41
VH Water 850.00 18.31 18.31 18.31 18.31 18.31 18.31 18.31 18.31 18.31 18.31     183.10 183.10 -666.90
VH Insurance 1550.00   872.33[32]                     872.33 872.33 -677.67
VH Consumables - cleaning etc. 725.00       85.80 28.66 30.00 30.00 30.00 30.00 30.00 30.00 30.00 324.46 324.46 -400.54
VH Consumables - contractor cleaning  1000.00   212.20 25.00   85.00 212.20       212.20     746.60 746.60 -253.40
VH Consumables - catering 1000.00   10.41 75.00 6.41     75.00           166.82 166.82 -833.18
VH Telephone 850.00   206.45     61.33[33] 35.00 23.94 23.94 23.94 23.94 23.94 23.94 446.42 446.42 -403.58
VH Staff Costs 9000.00 1474.66 562.96 489.50 493.15 276.23 500.00 500.00 500.00 500.00 500.00 500.00 500.00 6796.50 6796.50 -2203.50[34]
VH Staff Inland Revenue Payments 550.00 631.68 246.63 215.32 217.19 140.60 200.00 200.00 200.00 200.00 200.00 200.00 200.00 2851.42 2851.42 2301.42[35]
VH Marketing/Social Events 250.00 100.00[36] 30.00                     130.00 130.00 -120.00
VH Maintenance and Equipment 3500.00 717.84 728.00 326.19[37] 1224.35[38] 125.04[39]               3121.42 3121.42 -378.58
VH Service Contracts and Licence Fees 3000.00       75.96[40] 216.00 480.00             771.96 771.96 -2228.04
Recreation Field Grass Cutting 2675.00 235.70[41] 631.47[42] 332.10 379.88 310.23               1889.38 1889.38 -785.62[43]
Old Changing Rooms Main & Utilities 800.00   34.32   104.13                 138.45 138.45 -661.55[44]
VH Rates 4515.00 460.04[45] 461.00[46] 461.00 461.00 461.00 461.00 461.00 461.00 461.00 461.00     4609.04 4609.04 94.04
Total Village Hall Payments   35515.00 3946.57 4718.69 2088.00 3174.88 1803.68 2311.51 1458.25 1874.25 1383.25 2086.45 903.94 903.94 26653.41 26653.41 -8861.59
 
  Village Hall Variation 7937.56[47]
                                     
Earmarked Reserves                                
Road safety measures - Wood End 2000.00                       0.00 0.00    
Renovation of war memorial 600.00                              
Renovation of Barograph area   6000.00                       0.00[48] 0.00 0.00 -6000.00
Total Earmarked Reserves   8600.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 -6000.00
 
                                       
Total Receipts     126285.00 47039.92 3384.22 4377.95 3380.62 2747.72 4105.60 53798.60 3063.60 2726.60 2563.60 2563.60 2875.60 132627.63 132627.63  
Total Expenditure     134135.00 9016.47 38287.20 5585.94 5649.59 4241.34 4572.17 5938.91 32453.53 3453.91 3857.11 2674.60 2974.60 118705.37 118705.37  
                                     
VAT                            
Rebate         7.00               7.00 7.00
Payments         351.52 93.20 533.74 89.38 156.42               1224.26 1224.26
[1]
Tracey:
recycling credits 47.40
lloyds complaint 100.00
[2]
Tracey:
contribution from CCC
[3]
Tracey:
1032.47 - Tracey
144.90 - Sue Morgan end of year
[4]
User:
Overspend reflects worst case should 23 hours per week be worked in all cases - in practice this should be an over-estimate.
[5]
Tracey:
bank holiday expenses claim for previous clerk - 2014-15 only
[6]
User:
Saving to offset salary increase - Line 17.
[7]
User:
This may increase depending on new Clerk requirements.
[8]
Tracey:
Zurich only NFU expected in March 2015
[9]
Tracey:
CAPALC fees - over spend due to new clerk
[10]
Tracey:
SLCC membership
[11]
Tracey:
paper - 11.22
postage - .93
[12]
Tracey:
stamps 34.55
ink cartridges - 59.17
[13]
Tracey:
165.03 printing
25.00 brownie delivery
[14]
Tracey:
training - 118.80
Manual -50.50
[15]
Tracey:
new councillor - 210
clerk - 25
[16]
Tracey:
H & S signs - 26.80
key deposit - 10.00
[17]
Tracey:
notice board repairs - 75.00
school car park repairs - 200
[18]
Tracey:
100.00 clearing of Meeting walk
4.20 - padlock school carpark
13.99 - varnish notice boards
20.00 - strimmer repair
[19]
Tracey:
73.20 - jerry can, ear defenders, etc
160.00 - benches
[20]
User:
Dog walk fencing
[21]
Tracey:
JASearle
[22]
Tracey:
57.88 - R Frost
34.02 - JA Searle
18.50 D Gedye
29.56 R Frost
57.98 J A Searle
[23]
Tracey:
Ray - 29.78
Searle - 85.05
[24]
Tracey:
Ray - 58.34
J Searle - 85.05
[25]
User:
Spend is weather dependent - monitoring new mower use
[26]
User:
Available funds against forecast income.
[27]
Tracey:
includes difference of rent from Jan - March & cleaning for 3 month period
[28]
Tracey:
includes £312 cleaning for quarter
[29]
Tracey:
Insurance claim following break in at cricket club store
[30]
Tracey:
equipment rental
[31]
Tracey:
credit note - 145.58 & 213.59
bill - 173.30
[32]
Tracey:
Zurich insurance costs NFU expected in March 2015
[33]
Tracey:
Final BT bills phone and internet
[34]
bank holiday expenses claim 2009-2013.  additional £1330.00 for 14-15 only
[35]
User:
tax increase due to bank holiday payments
[36]
Tracey:
return of hall deposit
[37]
Tracey:
Insurance claim repairs to store 322.05 & bulb 4.14
[38]
Tracey:
37.98 - microphone
1068.08 - Boiler maintenance
83.50 - garage repairs
34.79 - printer geoff
[39]
Tracey:
76.14 - first aid supplies
45.00 - Fire safety log book
3.90 - bulb
[40]
Tracey:
75.96 - Fenland fire service of extinguishers
[41]
Tracey:
March invoice
[42]
Tracey:
April & May invoice
[43]
User:
Weather dependent
[44]
User:
Standing charges for water, rates and electric. Electric heating to be monitored.
[45]
Tracey:
includes hall and field
[46]
Tracey:
hall - £429
ground - £32.00
[47]
User:
Available funds against budget
[48]
User:
LHI bid contribution