Help, need to work out rent

[burty85]

Ok, I self managed one of my properties to a mate.

This is a little slack on my behalf, but working 2 jobs and renovating I didn't really keep track of the rent coming in at all times.

The lease started on 8th Mar 10 and ended on 26 Feb 11 @ 270p/w.

Is there a quick way to work out the total rent for this period to the day??

 

[jaycee]

I do things on computer, but sometimes the long way and the simple way.

Make out a list in excel, you can use formulae for the dates to save time,

Start Date............End Date............Rent$Due
8/3/10..................14/3/10..............$270
15/3/10................21/3/10..............$270
22/3/10................28/3/10..............$270
etc

Then you have a clear record everyone can clearly see and understand.

 

[Rickardo]

Ok, I self managed one of my properties to a mate.

This is a little slack on my behalf, but working 2 jobs and renovating I didn't really keep track of the rent coming in at all times.

The lease started on 8th Mar 10 and ended on 26 Feb 11 @ 270p/w.

Is there a quick way to work out the total rent for this period to the day??

356 days in total - http://calculators.ato.gov.au/scripts/axos/AXOS.asp

Rent per day = 270 * 52 / 365 = $38.4658 (depending on how many decimal places you go to)

= $13,693