Chapter 15
Reports
Section 1 Ledgers
- Non-HAP
- HAP
- Ledger (Tax Credit Only)
Section 2 Receivables
- Rent Roll
- Aging Detail/Summary
Section 3 Extremely Low Income Report
Section 4 Budget Comparison/Balance Sheet
Section 5 Financial Reports located under NHE custom menu
Section 1
Ledgers
· To pull a resident ledger you will need to be in the Roles of Affordable Entire Set.
o Across the top of the screen click on Guest, then Find Resident from drop down box.
o
Once you have found your resident you will click on Reports.
o From the drop-down menu you will then choose Ledger, which shows both HAP and tenant details, Ledger-HAP, or Ledger- non HAP, or Ledger (Tax Credit properties).
]
Section 2
Receivables
· Rent Roll
o You will need to be in the role of Affordable Entire Set found on the left hand side menu towards the top
o Click on the Monthly Procedures tab.
o Choose Affordable Reports.
o Fill in property, Dates (Beginning & Ending), choose Rent Roll from drop down menu under Report Type, and choose Unit under summarize by.
o You can then choose to Display on the screen or export to Excel or PDF file.
· Aging Detail Summary
o From your monthly procedures menu you will click on Affordable Receivable Reports.
o Choose property, current or past residents (or leave blank for both)
o Choose Receivable Aging Detail from drop down box for Report Type
o Summarize By – Resident
o Input Post To(MM/YY) date
o Minimum Amt is 0.01 and exclude HUD subsidies.
o You can display on screen or export to Excel or PDF file.
Section 3
Extremely Low Income Report
·
Click Reports from the left-hand menu then click SQL Reports at the bottom.
o Search for Extremely Low Income Report then select from right hand side
o
Fill in Property, Effective Date Range, choose Screen as destination and press Submit.
Section 4
Budget Comparison/Balance Sheet
·
You will need to be in the NHE Custom Menu role to pull these reports.
o
Choose Analytics, then Financial Analytics.
o For Budget Comparison: fill in Property, Accrual for Book, choose Budget Comparison from Report Type drop down menu, and fill in dates.
o For Balance Sheet: fill in Property, Accrual for Book, choose Balance Sheet from Report Type drop down menu, and fill in period.
o You can display to screen or export to Excel or file.
9 of 9