Property Management & Accounting
RealPage + ATALI ELECTRIC
Load multifamily rent rolls from RealPage OneSite and operating statements from RealPage Accounting report exports into the income approach.
CSV/XLSX upload or SFTP drop (SSH key authentication)How it works
RealPage OneSite is the system of record for unit-level leasing at a large share of institutional apartment communities, and RealPage Accounting holds the general ledger behind the property's operating statement. ATALI ELECTRIC reads the Excel and CSV files your site or accounting team exports from those standard and ad hoc reports, so the connection runs on reports the property already produces at month end. ATALI ELECTRIC does not connect to RealPage systems directly and holds no RealPage partnership.
Multifamily appeals turn on the gap between scheduled rent and what the property actually collects. The rent roll import separates occupied, vacant, model, down and employee units, compares lease rent to market rent to measure loss to lease, and totals concessions. The operating statement is mapped account by account to normalization categories once per chart of accounts, so later uploads separate debt service, depreciation, capital replacements and non-recurring turn costs automatically before NOI is capitalized.
- Authentication
- CSV/XLSX upload or SFTP drop (SSH key authentication)
- Sync cadence
- On upload; SFTP folders are checked hourly
Data flows
- Unit rent roll InboundOneSite rent roll exported to Excel or CSV as of the valuation date, with unit, floor plan, square feet, unit status, market rent, lease rent and lease dates.
- Operating statement InboundTrailing twelve-month income statement by GL account from RealPage Accounting, exported to Excel.
- Concessions and other income InboundConcession, bad debt and ancillary income lines (parking, storage, utility reimbursement) used to move from gross potential rent to effective gross income.
- Chart of accounts InboundAccount numbers and descriptions used to build the reusable mapping from GL accounts to normalization categories.
- Normalized pro forma OutboundXLSX export of economic vacancy, loss to lease, concessions and the normalized statement for review by the asset manager.
Field mapping
- UnitUnit ID
- Floor plan / unit typeUnit type (bed/bath mix)
- Sq FtUnit area (sq ft)
- Unit statusOccupancy status
- Market rentMarket rent
- Lease rentContract rent
- Lease endLease expiration date
- GL AccountNormalization category
Set up in 5 steps
- 1Run the rent roll in OneSite and the twelve-month income statement in RealPage Accounting as of the assessment valuation date.
- 2Export each report to Excel or CSV.
- 3Upload the files to the parcel, or place them in your firm's ATALI ELECTRIC SFTP folder named by property.
- 4Map GL accounts and unit status codes on the first upload; the mapping is reused for every community on the same chart of accounts.
- 5Review economic vacancy and loss to lease, then approve the normalized pro forma for the evidence binder.
Used for
- →Showing economic vacancy and concessions for a 312-unit garden community in lease-up when the assessor applied stabilized occupancy.
- →Normalizing operating statements across a regional apartment portfolio before Texas protest season.
- →Separating unit turn capital from repairs and maintenance before NOI is capitalized.
Stop overpaying commercial property tax on a flawed mass appraisal.
Upload an assessment notice. ATALI ELECTRIC returns a valuation audit and comp analysis in about two minutes.