Tenant Accounts Receivable Reports

Leases Tab

Leases

This is a listing of all Leases. You have the ability to select active, expired, or all leases, for one or multiple developments. You can select leases that started within a specified date range, and also change the order so it prints by tenant last name, address, effective date of the lease, termination date of the lease (for expired leases), or unit number.

Vacancy Notice List

This is a listing of all families that have given notice that they are vacating their unit. You have the ability to select for one or multiple developments, and select notices given within a specified date range. You can also change the order so it prints by tenant last name, address, or unit number.

Pending Lease Changes

This is a listing of all future or pending lease changes. A lease change is where a recertification was completed and the lease amounts will change. You have the ability to select for one or multiple developments, and select notices given within a specified date range. You can also change the order so it prints by tenant last name, address, or unit number.

Lease Termination List

This is a listing of all leases that will terminate or have terminated within a specified date range. You have the ability to select for one or multiple developments, leases that started within a specified date range, and leases with a certain termination reason. You can also change the order so it prints by tenant last name, address, effective date, termination date, or unit number.

ORC Changes Report

This is a listing of all recertification records from the Occupancy & Rent Calculation program data. This listing should match the Pending Lease Changes report if the same date is used. You have the ability to select for one or multiple developments, and select changes that are effective within a specified date range. You can change the order so it prints by tenant last name, effective date of the change, tenant SSN, or unit number.

Units Tab

Master Unit Listing

This is a listing of all units in the program. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Vacant Unit

This is a listing of all units in the program that are vacant as of a specified date. You may exclude units from this report if they are flagged with specific reasons for being vacant, such as "property left in the unit," "damaged with insurance claim pending," etc. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Vacant Unit Status with Offers

This is a listing of all vacant units in the program that have a pending unit offer as of a specified date. You have the ability to select for one or multiple developments. You can also select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Occupied Units

This is a listing of all units that are "occupied" as of a specified date. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Unit Actions Log

This is a listing of unit actions, which are the transactions listed on a unit from move out to move in used in vacancy unit turnaround tracking. These may be "property left in the unit," "damaged with insurance claim pending," etc. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name. You may also run this report for a selected unit action or all actions.

Unit Summary

This is a listing of all units in the program. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name. This report is the same as the Master Unit Listing except it reports the occupancy status as of a specified date.

Move In Report

This is a listing of all families that moved in during a specified date range. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Move Out Report

This is a listing of all families that moved out during a specified date range. You have the ability to select for one or multiple developments, and select for a specified bedroom size or all bedrooms. This report can be ordered by unit number, apartment number, street number, bedrooms, or street name.

Reports Used to Generate PHAS

This area includes reports that use the lease issue date or move in date to select which unit transactions are included in the report. All records are included in the report where the move in or lease issue date is within the selected date range.

  1. Unit Reportable Elapsed Days (PHAS) is a listing of all unit turnaround records. These are the transactions for each unit from lease expiration to new lease issued tracking Down Time, Make Ready Time, and Lease Up Time with any reported exclusionary actions. You have the ability to select for one or multiple developments and to specify a date range for this listing.
  2. Cumulative Unit Reportable Elapsed Days (PHAS) is a cumulative summarization of the Unit Reportable Elapsed Days report above. Instead of showing each unit action, it summarizes the time period specified showing just the totals for each month in the report date range and a grand total.

For Management Only

This area includes reports that use the actual transaction date to select which are included in the report. A move in is not required to include a vacant unit on these reports.

  1. Unit Vacancy is a listing of all units that are/were vacant during the specified date range. You have the ability to select for one or multiple developments and to specify a date range for this listing.
  2. Cumulative Unit Vacancy is a cumulative summarization of the Unit Vacancy Vacant Days report above. Instead of showing each unit action, it summarizes the time period specified showing just the totals for each month in the report date range and a grand total.

Payments/Deposits Tab

Payment Listing

This report displays a list of all payments made during a specified date range. These are the payments made, not the deposits. This report can be ordered by customer or by date of the payment. It can be reported for one or all receivable offices, and for all payments or those taken into a specified cash drawer. You may select to include the payee address on the report, print in summary only for the selected grouping, and include the payment detail on the report.

Payment Listing by Payment Type

This report lists all payments made during a specified date range, grouped and subtotaled by type of payment. This report can be ordered by customer or by date of the payment. It can be reported for one or all receivables offices, and for all payments or those taken into a specified cash drawer.

Payment Listing by Development

This report lists all payments made during a specified date range, grouped and subtotaled by the development where the tenant lived. You can select one or a combination of multiple developments for this report. This report can be ordered by customer or by date of the payment. It can be reported for one or all receivables offices, and for all payments or those taken into a specified cash drawer. You may select to include the payee address on the report, print in summary only for the selected grouping, and include the payment detail on the report.

Payment Listing Condensed

This report lists all payments made during a specified date range. This report can be ordered by customer or by date of the payment. No other selection or options are available for this report.

Void Payment Listing

This report displays a list of all payments that were taken and subsequently voided.

Year to Date Payment Listing

This report displays a list of all payments made during a specified date range. The default report date range is for a time beginning one year prior to today through today. This date range can be changed which then changes the data reported. This report can be ordered by customer or by date of the payment.

Bank Deposit Listing

This report displays a list of all bank deposits made during a specified date range. These are deposits, not payments on account. This report may be reported for one or all receivables offices, and for all payments or those taken into a specified cash drawer. It can also be reported for all deposits made into all bank accounts or a selected bank account. If multiple bank accounts are selected, the report first groups and subtotals by bank account, then groups and subtotals by the sort order selected.

Receipt Listing

This report is a listing of all payments for a specified date range where a receipt was printed. The difference between this report and the Payment Listing report is whether a receipt was printed or not. This report can be ordered by customer or by date of the payment. It can be reported for one or all receivables offices, and for all payments or those taken into a specified cash drawer. You may select to include the payee address on the report, print in summary only for the selected grouping, and include the payment detail on the report.

Receipt Listing by Development

This is a listing of all payments for a specified date range where a receipt was printed, grouped and subtotaled by the development where the tenant lived. The difference between this report and the Payment Listing by Development report is whether a receipt was printed or not. This report can be ordered by customer or by date of the payment. It can be reported for one or all receivables offices, and for all payments or those taken into a specified cash drawer. You may select to include the payee address on the report, print in summary only for the selected grouping, and include the payment detail on the report.

Cash Drawer Balancing Report

This report reprints the Cash Drawer Balancing reports of all cash drawers closed out during a specified date range.

Receivable Tab

Daily Activity Summary Report

This report is a summary of all transactions within the system for a specified date range. This report can be for a single, all, or any combination of developments (for AMP reporting ability), and for any combination of customer account types. There is an option to include a final page at the end of the report that details and explains the columns on this report and how they relate to each other.

Account Summary Report

This report is a listing of all tenants and their customer accounts showing the balance as of the beginning report date, charges, payments, and transfers during the report date range selected, and the ending balance as of the end of the selected report dates. This report can be for one or more selected developments, and the report may be in the order of the customer name or by customer number. This report has an option to select all or a single customer account type. There is also a checkbox to show the development totals or summary only instead of listing each tenant name and their balances.

Charge Activity Report

This report lists all charges on a tenant account for a specified date range. You have the ability to select for a single or combination of developments, and for a single or combination of charge types. This report may be sorted in the order of the customer name, customer number, or transaction date.

Credit Listing Report

This is a report of all credits applied on customer accounts during a specified date range. This is usually used to list tenants with credit rent or utility allowance payments due, but can also be used to list any credit transaction applied to customer accounts. You have the ability to select for a single or combination of developments, and for a single or combination of charge types. This report may be sorted in the order of the customer name, customer number, or transaction date.

Transaction Listing

This report is used to list all transactions added to a customer account during a specified date range. You have the ability to select for a single or combination of developments, and may be sorted in the order of the customer name, customer number, or transaction date.

Voided Transaction Listing

This report is used to list all transactions that have been voided from a customer account during a specified date range. You have the ability to select for a single or combination of developments, and for a single or combination of charge types. This report may be in the order of the customer name, customer number, or transaction date.

Recurring Transaction Listing

This report lists all transactions that are defined as recurring or repeating transactions. These are the transactions that automatically apply to a customer account after generating monthly transactions.

Adjustment Listing

This is a report of all adjustments applied to customer accounts during a specified date range. You have the ability to select for a single or combination of developments, and for a single or combination of charge types. This report may be in the order of the customer name, customer number, or transaction date.

Account Transfers

This report is used to list transfers between customer accounts during a specified date range, such as transferring a security deposit to the accounts receivable account to pay for charges due. You have the ability to select for a single or combination of developments, and may be sorted in the order of the customer name, customer number, or transaction date.

Aged Balance Report

This report is a listing of all tenants and their customer accounts showing the ending balance as of the selected report date, and columns showing how past due the receivable amount is as of that date. This report can be for one or more selected developments, and may be sorted in the order of the customer name or by customer number. This report has an option to select all or a single customer account type. There is also a checkbox to exclude customers with zero or credit balances. You may also select all tenants, tenants with active leases, or tenants with expired leases.

Delinquent Report

This shows all tenants that are delinquent as of a specified date. This report can be for one or more selected developments, and may be sorted in the order of the customer name or by customer number. This report has an option to select all or a single customer account type. You may also select all tenants, tenants with active leases, or tenants with expired leases. There is also a checkbox to show delinquent for their rent charge only.

Refund Request List

This report displays a list of all tenants where a credit rent or utility allowance refund would be processed based on the policy settings for refunds as of a specific date range. This is usually used to list all tenants with a credit rent charge on their account. This report can be for one or a combination of developments, and it can be printed in order by customer name or customer number.

Tenant Account History

This report shows all transactions for a specified date range for one customer account type. You can choose to run this report in summary only, or in detail showing each customer and their transactions.

Ledger (Unposted) Pre-Posting

This report lists all GL transactions that have not been posted to the Ledger Journal file as of the specified report date. This report can be for one or more selected developments.

Rent Collection Performance Report

This report is designed to show the amount and percentage of rent collections over a specified period of time. It can be run for one or any combination of developments and for one or multiple customer account types. This can be printed showing the detail of each tenant or by summarizing each development without the tenant names. In detail form, tenants with zero amounts on all columns may be excluded. There is an option to include a final page at the end of the report that details and explains the columns on this report and how they relate to each other.

Cumulative Rent Receivable Summary Report

This report is a summary of the rent charged and collected with percentage collected for one or more developments for a specified date range.

Late Fee Exempt Report

This report is a listing of all customers that are marked as exempt from late fee calculations. There are no options to choose for this report.

Balance Transfer Report

This report is a summary of all balance transfers within the system for a specified date range. This report can be for a single, all, or any combination of developments (for AMP reporting ability), and for any combination of customer account types. For ease in viewing, each individual balance transfers' details are separated out by development, account type and then the actual balance transfer description and amounts. And at the end of the report, there is a summary of all balance transfers separated by balance transfer description, customer/tenant name, account type, and development.

Registers and Custom Reports Tab

Registers

These reports are user definable and can be added and modified, as needed. Each register can be printed for one or any combination of developments. They can be printed for a user selected date range, usually for the current or just past month, but can be for a longer time period. The user has the option of selecting tenants or customers only, or all. If the user selects tenants, registers can be for all tenants, active leases, or expired leases. These reports can be printed in order by last name, unit number, EPF file, account number, or the numeric unit.

Custom Reports

If the user has the necessary security rights, and is included in the Report Group in the Custom Report Writer program for Receivables Reports, then all custom reports designated as Receivable Reports Group reports are listed on the Custom Reports tab. If the user does NOT have the necessary security rights, the Custom Reports tab is unavailable and does not appear on the screen.

Copyright © Tenmast Software 2010