Skip to main content
Data Dare real estate L2 sticker: the findi360 mascot analysing Lease Billing, Collections and Property Maintenance.

DD-REA-002

Lease Billing, Collections and Property Maintenance

Decide which leases are worth renewing, where collections fall behind billing, and how much maintenance is quietly eating the rent.

  • Real Estate
  • L2 · CSV
  • ~30,000 rows
  • 8 tables
  • 40 questions
Get the data 40 questions

Get the data

v1.0 · 6 files

Files are for members. A free account takes a minute, and you come straight back here.

Create a free account Sign in
  • Question Book PDF DD-REA-002_Question_Book.pdf 1.2 MB · v1.0
  • Dataset Documentation / Data Dictionary XLSX DD-REA-002_Data_Dictionary.xlsx 14.8 KB · v1.0
  • Business Introduction PDF DD-REA-002_Business_Introduction.pdf 1.8 MB · v1.0
  • Relationship Diagram PDF DD-REA-002_Relationship_Model.pdf 47.1 KB · v1.0
  • Raw fact data FactLeaseLedger.csv 6 MB · v1.0
  • Dimension / supporting data DD-REA-002_Dimensions.zip 157.5 KB · v1.0

Questions

Open one to discuss it
  1. Q001 Easy Establish the gross amount charged to tenants
  2. Q002 Easy Quantify actual cash collections
  3. Q003 Easy Measure unresolved tenant receivables
  4. Q004 Easy Measure billing-to-cash conversion
  5. Q005 Easy Measure operating occupancy from transactional records
  6. Q006 Easy Establish the portfolio property count
  7. Q007 Easy Establish total unit capacity
  8. Q008 Easy Establish the tenant population
  9. Q009 Easy Identify the strongest revenue-generating property
  10. Q010 Easy Identify the main property-level concentration of arrears
  11. Q011 Easy Explain the distribution of collection outcomes
  12. Q012 Easy Quantify completely unpaid tenant obligations
  13. Q013 Easy Create an actionable record-level ageing classification
  14. Q014 Easy Identify peak monthly billing performance
  15. Q015 Easy Track billed revenue through time
  16. Q016 Easy Compare annual operating performance
  17. Q017 Medium Quantify year-on-year billing growth
  18. Q018 Medium Identify the strongest cash-collection month
  19. Q019 Medium Reconcile billed income against actual cash
  20. Q020 Medium Show how revenue accumulated during the reporting horizon
  21. Q021 Medium Identify the owner reporting population
  22. Q022 Medium Quantify the active contract-management population
  23. Q023 Medium Identify the largest revenue-contributing owner
  24. Q024 Medium Locate the highest owner-level arrears exposure
  25. Q025 Medium Measure near-term renewal workload
  26. Q026 Medium Measure the typical contractual commitment
  27. Q027 Medium Quantify contractual rental obligations
  28. Q028 Medium Measure embedded future rental uplift
  29. Q029 Medium Identify and clean the available billing categories
  30. Q030 Medium Identify the main billing category
  31. Q031 Medium Quantify maintenance charges passed through to tenants
  32. Q032 Medium Measure financial recovery from late payments
  33. Q033 Medium Measure concessions granted across the portfolio
  34. Q034 Medium Quantify property operating expenditure
  35. Q035 Medium Measure income after operating expenses
  36. Q036 Medium Measure operating profitability relative to billings
  37. Q037 Hard Track owner portfolio contribution through time
  38. Q038 Hard Quantify critical overdue exposure
  39. Q039 Very Hard Identify the strongest invoice cohort for collections
  40. Q040 Very Hard Summarise the owner-facing operational picture

General discussion

Anything about this dataset that is not one question — loading the files, which tool, how you set it up.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in