Property Management Rent Ledger
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals everything for any date range.
- Industry
- Property Management
- Deliverable
- Property Management.xlsm
- Built with
- Excel VBA, UserForms
Before
Rent, fees and landlord payments were reconciled in separate statements.
After
Each property has its own ledger and the dashboard totals everything for any date range.
More like this
Related projects
Cost & Savings Progression Model
Telecom / Hardware
A scenario model that projects component costs and savings as hardware moves from analog to IP over time. One button recalculates four scenarios using the ramp…
View project
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by…
View project
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project