Download the spreadsheet by clicking on the above link. In the first column, enter the date the rent was due (for example, if the tenancy started on 3 February, the rent is due calendar monthly, the dates you might put in the 1st column are 3/5/13, 3/6/13, etc.). There is no need to enter rents due or paid BEFORE the tenant goes into arrears, you can start from the first point that rent was late or missed.
In the second column, enter the amount of rent due. Following the above, if the rent is £550.00 per calendar month, enter this amount next to the 3 May 2013 etc
Finally, enter the receipts from the tenant. Following the above, if the tenant paid £200.00 on 5 May, £300.00 on 31 May and £100 on 8 July, enter the date of payment in the 1st column and the amount paid in the 3rd column.
The system automatically calculates the arrears and places the balance (arrears) in the last column. Using the above, the calculator should look like this.
|Date||Rent Due||Payment received||Balance|
|03 May 2013||£550.00||-£550.00|
|05 May 2013||£200.00||-£350.00|
|31 May 2013||£300.00||-£50.00|
|03 June 2013||£550.00||-£600.00|
|03 July 2013||£550.00||-£1,150.00|
|08 July 2013||£100.00||-£1,050.00|
You can save the above on your computer, print it out and attach it to the Notice and also update it and use it in Court to prove the arrears due if necessary.
This is a good example why we recommend serving both Section 8 and Section 21 at the same time (click here for more details). Whilst the tenant is over £1,000 in arrears, they are NOT two months in arrears so the Courts wont give repossession. If you serve a Section 21 Notice at the same time, the Courts MUST give repossession (subject to legal “stuff”).