Automate annual rent registration preparation and validation
Sign in
Connect your Google account to access the tool.
1Upload Rent Roll
2Prior Year Data
3Set Guidelines
4Validate
5Review & Export
Step 1: Upload Current Year Rent Roll
i
Upload your current rent roll Excel file
Supported formats: .xls, .xlsx, .csv. The file should contain unit numbers, tenant names, current rent amounts, and lease dates.
Drop your rent roll file here
or click to browse
OK
filename.xlsx
60 units loaded
Step 2: Prior Year DHCR Registration Data
i
Provide last year's DHCR registration data
This is usually the prior year's DHCR PDF export. You can also upload a prior rent roll (Excel/CSV/JSON), or use the pre-loaded 2024 DHCR data from the sample files.
Drop last year's DHCR PDF here
or click to browse (.pdf recommended; .xls, .xlsx, .csv, .json supported)
OK
Prior Year Data
60 units loaded
Preview (First 5 Units)
Unit
Tenant Name
Legal Rent
Lease End
Step 3: Configure Rent Guidelines
i
NYC Rent Guidelines Board Orders
Pick a default guideline order below. The engine selects the order by lease start date (default is used as fallback).
--
Default Order
--
Effective From
--
Effective To
Default Guideline Order
Type a year to filter orders whose effective window overlaps that year, then choose the default order.
The selected order's details appear below.
Example: entering 2025 shows orders that include any date in 2025.
Step 4: Validation Results
0
Total Units
0
Passed
0
Warnings
0
Failed
Unit
Unit Code
Tenant
Status
Prior Rent
Current Rent
Expected Rent
Increase
Lease Start
Lease End
Lease Term
Issues
Step 5: Review & Export
OK
Validation Complete
Your data has been validated. You can now export the DHCR-ready format and audit report.
!
Issues Detected
There are failed validations that should be addressed before submission.
You can still export to review the issues.
Export Options
Excel Validation Report
Complete validation report with all calculations, issues, and DHCR-ready format in Excel.
DHCR JSON Format
Machine-readable JSON format ready for DHCR portal integration or API submission.
Audit Trail Report
Detailed audit report showing all calculations and pass/fail status per unit.
Automated DHCR Submission (Playwright)
Runs a browser automation flow from the server. Set DHCR_USERNAME and
DHCR_PASSWORD in your environment. Use headed mode if MFA is required.
i
Queued
Activity Log
Manual DHCR Portal Submission
To submit manually, visit the NYS DHCR Web Access Portal and follow these steps: