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

[bilabonic]

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

 

[kevshed]

see attached... let me know if this now does what you need...

 

[bilabonic]

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.