NEED HELP
Please see attached my rent package which has taken me 5 month to create. I've got no experience in excel until what I just done.
I'm looking to see if someone can update my package with a User friendly dashboard
The Dashboard could be userform to allow to add a new Tenant, remove existing Tenant, Add payment allowing to set Date (monthly only).
It would be nice to notify user with arrears for each property and end of EPC, Gas Cert and Insurance.
Also in the Arrears column i feel i haven't calculated the formula correctly. It should be Whatever rent amount due - rent paid - HB Paid. It should only show previous arrears and not future. For example if we are in march then only show arrear upto March
Would nice to have is a Insight page that shows loss in a line chart for each property
Bookmarks