Rental tracker spreadsheet

My tenant sometimes pays rent a bit less frequently than desired, meaning sometimes payments could be spaced 5 upto 10 days apart instead of 7 days for weekly rent. I have my own tracker spreadsheet for this but I find it hard sometimes to convey this to the tenant, eg. If he has paid a few rents that have been 8 or 9 days apart, this equates to a missed rent and then there is a bit of a back and forth with me explaining this.

Ive thought of sending them a rental statement every month so they can clearly see which week their rent has gone towards etc. What are some solutions to prevent this happening in the future or any good rental statements or reciepts/spreadsheets out there that clearly show what's been paid and owed/missed/extra/partial rent payments. Thanks

 

Thanks for sharing that, I will definitely be getting a property manager in if I ever need to relist.

So if a tenant misses rent for 1 pay period, would you leave that period blank on the tracker so that it's easily seen which period was missed, or would you fill that in with the next rent so the rent payments are now not aligned with the pay periods, but you could still clearly see they are a rent behind. Just having a bit of trouble adapting this for a tenant in simple illustrated spreadsheet.

 

You could have a column for what is expected to be due. Then another for when its paid. Any late or unpaid should be clear.

Note when you dont use a PM that RECEIPTING the period being paid is VERY important to tribunals. A spreadsheet isnt a receipt etc

 

Use a sheet similar to the one posted above, if not aligned to pay period you could use a column "rent paid to" which is calculated from the amount paid and the previous paid to date this would show if behind

If missed for a period you could add comments - same as when a double/extra payment is made to make up for that missed one

AFAIK there is no receipt required to be issued in QLD for electronic payments but if asked for must be provided along with the payment records within a defined time

 

Just need a field/column to track the number of days in arrears or advance.
Hate to say it, but schools should really be teaching children how to read and understand a tenancy ledger as that is the way the world is going. The amount of adults who cannot even basic math or understand this stuff is rough.....

 

The date that they transferred you the money should be divorced from the "paid from/to" dates.

For example, if the rent is $350wk and they are paid to 01/01 prior to the below 'ledger' entries:
DATE AMOUNT PAID FROM/TO
01/01 $700 01/01-14/01
08/01 $350 15/01-21/01
10/01 $300 22/01-27/01
24/01 $725 28/01-09/02 (Part-Payment $25)

You can see from the above that the tenants are paying irregularly, in some cases only part of a week's rent, but they are not in arrears. This ledger reflects "effective paid to" dates, which is the true date, since rent is really calculated daily regardless of whether tenants are due rent weekly/fortnightly/monthly.

The numbers are more painful when the rent can't be perfectly divided into 7, in which case you might find it easier to reflect the part-payment as any amount that isn't equal to a full week, which would make the example differ as below. Bear in mind however that the part payments are still considered rent paid, so in the below example the effective paid to date on the last entry is still 09/02, it's just expressed differently:
DATE AMOUNT PAID FROM/TO
01/01 $700 01/01-14/01
08/01 $350 15/01-21/01
10/01 $300 21/01-21/01 (Part-Payment $300)
24/01 $725 22/01-04/02 (Part-Payment $325)


Excel is a very powerful tool, you can probably build formula to fill in some of these fields automatically as well?