Rent spreadsheet

  • Filter
  • Time
  • Show
Clear All
new posts

  • Rent spreadsheet

    Has anyone got a good rent spreadsheet that they wouldn't mind sharing with me.


  • #2
    The spreadsheet you sent me was for weekly rent.

    Has anyone got a monthly rent spreadsheet?


    • #3
      Rent Spreadsheet

      Anyone have a decent template with regards to logging rent in and costs to a property?

      Or is it best to create your own?

      Any help is greatly appreciated.


      • #4


        I simply note rent in - date, amount, if late & for expenditure not everything initially in date order & put all receipts in a file... Then for tax return go over both, plus bank accounts & credit card bills are develop the spreadsheet into one split by HMRC box-numbers..then leave "last" years as a old sheet etc. etc...

        Think the important thing is to keep records, obsessively just-in-case. There are various silver-tongued "consultants" who claim to have fab. software for doing these things automagically.. Me? I'm an old cynic.
        I am legally unqualified: If you need to rely on advice check it with a suitable authority - eg a solicitor specialising in landlord/tenant law...


        • #5
          I wrote a very simple Excel rents workbook years ago. One sheet for each property. One section for rents received, one section for essential outgoings - insurance, Gas safe inspections, ground rent, service charges, agent's fees and so on then another section for incidential rxpenses - repairs and maintenance e.t.c. Summary totals from these sheets were then pasted to a summary spreadsheet for analasys purposes. Copies of these are then furnished to my accountant who sorts out my tax man.

          Any information given in this post is based on my personal experience as a landlord, what I have learned from this and other boards and elsewhere. It is not to be relied on. Definitive advice is only available from a Solicitor or other appropriately qualified person.


          • #6
            Excel has its strengths, but to be honest, it is best to use an accounting software like Quickbooks, because you can generate invoices / statements to provide to tenants if they fall in arrears.

            Also, handly for checks and balances e.g. do your bank statements tally with say your accounting software.

            The Accounting software is a handy to look up information. Say if the washing machine break downs, you check when it was last repaired (based on previous bills) or even if it is under guarantee.


            • #7
              jeffrey - I did perform a search and read the results, but nothing of great help.
              theartfullodger & P.Pilcher - thanks for your helpful input - i'm going to dust of my Excel skills and give it a whirl.
              rajeshk4u - thank you, think i'll give Excel a try and if it doesn't work out i'll look to invest in something like QuickBooks.

              Thanks for your help!


              Latest Activity


              • if we haven't signed the renewal are we still liable?
                Our 6 month short term assured tenancy agreement ended on the 2nd August. We are with a reputable agency. We were invited to renew for a further 6 months back in July and were asked to email our confirmation that we wish to renew in writing. This I did. We were sent the renewal tenancy to sign. We have...
                22-08-2017, 14:00 PM
              • Reply to if we haven't signed the renewal are we still liable?
                I would say your original AST continues as SPT.
                If now a new verbal AST, you may have a new fixed term and you cannot serve NTQ during fixed term (6 months?).
                Talk to LL directly, rather than LA.
                Why did you agree to a new AST, rather than request rolling over to SPT....
                23-08-2017, 00:30 AM
              • 6 year deposit claim
                Hi guys, I know that a tenant can claim a penalty on an unprotected deposit but I just wondered when the 6 year clock starts ticking.
                22-08-2017, 16:43 PM
              • Reply to 6 year deposit claim
                As memory fades over time, can someone provide a 'sticky' for dates when key elements of LL&T Legislation changed? I believe Apr 2012 predates later deposit timescales.
                23-08-2017, 00:08 AM
              • NTQ during fixed term?
                Can a LL issue a valid NTQ during the six-month fixed term of an AST agreement?
                (A residential let in England.)
                11-08-2017, 14:53 PM
              • Reply to NTQ during fixed term?
                It's worth noting that guidance is under part 4 where tenant obviously is given notice to end of a period and therefore apportionment would not be applicable.

                The reference to the notice to quit ending the tenancy on the notice date does not change the fact that it obviously does however,...
                22-08-2017, 23:24 PM
              • Reply to NTQ during fixed term?
                I think thats exactly what the section I have just quoted confirms.

                And thereafter, if you choose not to accept they are leaving as a result of the section 21 you must insist on a notice to quit or await a court ordering possession (where you will be ordered to apportion anyway)
                22-08-2017, 23:13 PM
              • Reply to NTQ during fixed term?
                A lot of energy has been expended in this debate. It has been suggested a LL has no need to take Court action if T apparently vacates after receiving a s21 but with no Notice. LL cannot safely assume has vacated without Court confirmation, to avoid a T allegation of 'illegal eviction'. Equally I would...
                22-08-2017, 23:00 PM
              • Reply to NTQ during fixed term?
                If someone could copy and paste section 21 (4) a and b (I'm really not technical!), the law seems to recognise that a tenancy CAN end as a result of a section 21 and before a possession hearing.

                21(4)b........the tenancy could be brought to an end by notice to quit given by the landlord...
                22-08-2017, 22:38 PM
              • Reply to 6 year deposit claim
                Assuming that the money originally paid had been used as a deposit for the single tenant tenancy, then 6 years and 30 days from when the 2012 tenancy started. And... if that was a fixed term tenancy, then 6 years and 30 days for any subseqent renwal and likewise from when it went periodic.
                22-08-2017, 22:22 PM