Rent statements Simon Walsh

  • Moving-in date: 2013-02-09
  • Moving-out date: 2014-02-15

  • Four weeks' deposit 560.00, paid by transfers: 2013-01-13: 100.00, 2013-01-31: 460.00
  • Monthly rate: 650.00 (140.00 weekly from 2014-02-09)
  • Share of electricity bill 30% (40% when 3rd room vacant)

  • Final balance: -226.39 → refund: 560.00 - 226.39 = 333.61

    2013-01

    Carry Over 0.00
    Rent 0.00
    Share of electricity 0.00
    Transfer 2013-01-31 650.00
    Balance 650.00


    2013-02

    Carry Over 650.00
    Rent
    20*(650.00/28)    		 -464.28
    Share of electricity
    70232 - 69902 = 330 units @ 14p → 46.20 * 30% → 13.86
    37567 - 37316 = 251 units @ 6p → 15.06 * 30% → 4.51    		 -18.37
    Balance 167.35


    2013-03

    Carry Over 167.35
    Rent -650.00
    Share of electricity
    70646 - 70232 = 414 units @ 14p → 57.96 * 30% → 17.38
    37927 - 37567 = 360 units @ 6p → 21.60 * 30% → 6.48    		 -23.86
    Transfer 2013-03-06 650.00
    Transfer 2013-03-29 650.00
    Balance 793.49


    2013-04

    Carry Over 793.49
    Rent -650.00
    Share of electricity
    70873 - 70646 = 227 units @ 14p → 31.78 * 30% → 9.53
    38212 - 37927 = 285 units @ 6p → 17.10 * 30% → 5.13    		 -14.66
    Transfer 2013-04-30 650.00
    Balance 778.83


    2013-05

    Carry Over 778.83
    Rent -650.00
    Share of electricity
    71077 - 70873 = 204 units @ 14p → 28.56 * 30% → 8.56
    38468 - 38212 = 256 units @ 6p → 15.36 * 30% → 4.60    		 -13.16
    Balance 115.67


    2013-06

    Carry Over 115.67
    Rent -650.00
    Share of electricity
    71275 - 71077 = 198 units @ 14p → 27.72 * 30% → 8.31
    38716 - 38468 = 248 units @ 6p → 14.88 * 30% → 4.46    		 -12.77
    Transfer 2013-06-04 650.00
    Balance 102.90


    2013-07

    Carry Over 102.90
    Rent -650.00
    Share of electricity
    71492 - 71275 = 217 units @ 14p → 30.38 * 30% → 9.11
    38998 - 38716 = 282 units @ 6p → 16.92 * 30% → 5.07    		 -14.18
    Transfer 2013-07-01 650.00
    Balance 88.72


    2013-08

    Carry Over 88.72
    Rent -650.00
    Share of electricity
    71717 - 71492 = 225 units @ 14p → 31.50 * 30% → 9.45
    39228 - 38998 = 230 units @ 6p → 13.80 * 30% → 4.14    		 -13.59
    Transfer 2013-08-01 650.00
    Balance 75.13


    2013-09

    Carry Over 75.13
    Rent -650.00
    Share of electricity
    71937 - 71717 = 220 units @ 14p → 30.80 * 30% → 9.24
    39450 - 39228 = 222 units @ 6p → 13.32 * 30% → 3.99    		 -13.23
    Transfer 2013-09-02 650.00
    Balance 61.90


    2013-10

    Carry Over 61.90
    Rent -650.00
    Share of electricity
    72124 - 71937 = 187 units @ 14p → 26.18 * 30% → 7.85
    39688 - 39450 = 238 units @ 6p → 14.28 * 30% → 4.28    		 -12.13
    Transfer 2013-10-01 650.00
    Balance 49.77


    2013-11

    Carry Over 49.77
    Rent -650.00
    Share of electricity
    72344 - 72124 = 220 units @ 14p → 30.80 * 30% → 9.24
    39998 - 39688 = 310 units @ 6p → 18.60 * 30% → 5.58    		 -14.82
    Transfer 2013-11-01 650.00
    Balance 34.95


    2013-12

    Carry Over 34.95
    Rent -650.00
    Share of electricity
    72680 - 72344 = 336 units @ 14p → 47.04 * 30% → 14.11
    40408 - 39998 = 410 units @ 6p → 24.06 * 30% → 7.38    		 -21.49
    Transfer 2013-12-02 650.00
    Transfer 2013-12-27 650.00
    Balance 663.46


    2014-01

    Carry Over 663.46
    Rent -650.00
    Share of electricity
    73337 - 72680 = 657 units @ 14p → 91.98 * 30% → 27.59
    41175 - 40408 = 767 units @ 6p → 46.02 * 30% → 13.80    		 -41.39
    Transfer 2014-01-28 120.00
    Balance 92.07


    2014-02

    Carry Over 92.07
    Rent
    8*(650.00/28) + 6*(140.00/7)    		 -305.71
    Share of electricity
    73529 - 73337 = 192 units @ 14p → 26.88 * 30% → 8.06
    41436 - 41175 = 261 units @ 6p → 15.66 * 30% → 4.69    		 -12.75
    Balance -226.39


    Any questions, email me at [email protected].