Tenant Monthly Balance Report

This report will show tenant monthly balances by category, i.e., retro rent, late charges, excess electric, etc. The report will provide a total by category for each area and overall grand total.

NAVIGATION: REPORTS ACCOUNTING menu > Historical Reporting > Monthly Balance Report

OR

NAVIGATION: END OF MONTH menu > Pre-Closing Reports > Tenant Monthly Balance Report - By Category

  1. Area Number: enter or select the area; leave blank to see all areas
  2. Community Number: enter or select the community; leave blank to see all communities
    1. A community cannot be selected if the Area Number was left blank.
  3. Month Ending: Enter the last day of the month you are running the report for.
  4. Status Selection: select one of the following options:
    1. All Tenants
    2. Active Tenants Only
    3. Vacant Tenants Only
  5. Sort Order: select one of the sort options:
    1. Unit Order
    2. Alpha within Community
    3. Status/Unit  -  Move-out tenants will be at the end of the report with this option.
  6. Paper Type: select one of the following paper sizes:
    1. Legal
    2. Letter
  7. No Page Break by Community: enter a check mark in this field if you do not want a page break by community
  8. Enhanced Merge Create Merge Interface: Enter a check mark in this field before running the report to have the report information available to print batch letter or forms based on this report.
    1. Preview or print this report and then go to Batch Letters and Forms and press the Build from Last Report button to populate the grid
  9. Column Control: up to nine columns can be added to the report.
    1. Use the drop down button to select/change the order of the columns on the report.
    2. To remove a column, use the drop down to select the blank line above Court Costs
    3. Column options include:
      1. Court Costs
      2. Excess Utilities
      3. Excess Electric
      4. HAP Rent
      5. Hauling
      6. Late Charge
      7. Maintenance
      8. Notes
      9. NSF Check Fee
      10. Pet Fee
      11. Retro Rent
  10. Preview or print the report (see Report Preview, Print and Save Options).

7/2023

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388