Sensible Topic Can anyone alter this EXCEL Document for me PLEASE ??

bilabonic

VIP Member
VIP Member
Joined
Apr 12, 2007
Messages
2,826
Hi All,

I have found this EXCEL document to keep track of rents BUT it is NOT as i would exactly like it.

https://www.tenancy.govt.nz/assets/Forms-templates/rent-summary-sheet.xlsx

It self calculates amounts owed/over payments.

I need the NUMBER OF WEEKS column removed as it is not applicable and messes with payments made to me randomly.

Also 52 weeks is NO good, i would like to go for AS LONG as possible (into thousands not 52)

I can easily manually delete the weeks and its heading BUT i am unable to extend it in ANY way ? (the rent period date from/to is also NOT needed as well)

Can anyone help please

Cheers
 

bilabonic

VIP Member
VIP Member
Joined
Apr 12, 2007
Messages
2,826
see attached... let me know if this now does what you need...
Cheers mate..

I gave up trying to create one in the end and paid £10 for one on Fiverr ...lol

Here it is if anyone needs it, i had rent period removed (as some of my tenants pay cash weekly etc)...I also had amount rent paid column so any payments in between the standard weekly/monthly payments payments can be added..

Works a treat and saves me manually calculating it all the time for several properties.
 

Attachments

TEST
Top