Reports¶
PropMan provides a number of reports to help you keep up with your Buildings and Residents. Many of the reports can be gerated to PDF or Excel, and the menu will provide that option where available.
Most of the reports are available from the Reports menu on Building card.
Reports Menu
PropMan will default to the most generally useful report date if no date is specified. This is usually what you want.
The Tenant History Report is available by clicking a button on the Resident Details page.
Mailing Labels¶
Residents of a Building and their mailing address, which is not always the same as the address of the unit, formatted for standard Avery mailing labels.
Trial Balance¶
A Trial Balance is a report that shows the balances of all the accounts in the general ledger.
Example Report
Bank Reconciliation¶
The Bank Reconciliation report is a summary of the reconciliation process. This serves as a check on the reconciliation process, and once completed, is a good report to save for future reference.
Example Report
Bank Statements¶
PropMan does not generate Bank Statements, but you can upload a bank statement to the system, and it will be available for use later in the Bank Reconciliation process or at any point in time.
Bank Statements screen
Recon Report Package¶
The Recon Report Package is a set of PropMan reports that are considered important to completing the reconciliation process.
See Recon Report Package for more information.
Checks¶
Checks represent monies paid from a Building to a Vendor. PropMan uses Cash Basis Accounting, meaning that the book balance is reduced by the amount of the check at the time of its writing. Tracking checks outstanding and cleared is important for the Bank Reconciliation process.
Outstanding Checks¶
Outstanding Checks are checks that have been written but not yet cleared by the bank.
Note
Outstanding are a liability to the Building. Clearing or voiding a check will reduce the outstanding balance.
Example Report
See the Clear Checks Screen.
Cleared Checks¶
Cleared Checks are checks that have been cleared by the bank. The report shows checks cleared for a given month.
Example Report
Ledger¶
A collection of “ledger” reports. These reports provide both monthly and year-to-date options, as well at the option to provide sprcific start and end dates.
General Ledger Menu
General Ledger¶
The General Ledger report provides a detailed view of all transactions for a given period with respect to the Building’s accounts.
Example Report
Note
Resident payments are summed and grouped by month and GL Account. For a breakdown by Resident, see the Cash Ledger report.
Cash Ledger¶
The Cash Ledger report provides a detailed view of all Resident Payments for a given period with respect to the Building’s Capital Accounts.
This differs from the General Ledger report in that it breaks down the individual Resident Payments.
Example Report
Occupant Ledger¶
A complete accounting of all bills, payments, and one-time adjustments for all Residents of a Building, broken out by Resident.
Example Report
Management Report¶
Providing a Complete Management Report to a Building’s board is a key part of the management process, and a good way to keep the board informed build trust.
The Management Report is a comprehensive report that includes multiple individual reports which can be run individually if needed.
Example Report
All of the following reports are included in the Management Report:
Budget & Cashflow - Financial Statement
Statement of Disbursements - Paid Bills
Statement of Journal Entries - Journal Entries
Rent Roll - Collection Status
Aged Arrears - Arrears Report
Budget & Cashflow¶
The Budget & Cashflow report provides a detailed view of the Building’s financials, including the balance sheet and budget.
The report breaks down actual vs budget revenues, disbursements, and other activity by GL Account, and into three categories:
Current Month
Year-to-Date
Annual
Example Report
Revenue Budgets Special Handling
Given the nature of Resident payment timing, a budget that splits cash revenues evenly across the year may not be representative of the actual cashflow. To account for this, PropMan uses a logarithmic curve to smooth out the cashflow.
The annual revenue budget can be represented as
\(A = \sum_{m=1}^{12} V_m\)
Where \(V_m\) is the monthly budget allocation
\(V_m = F + b \cdot \log(m)\)
\(b = \frac{A - 12F}{\log(12!)}\)
Where:
\(V_m\) is the value for month \(m\)
\(F\) is the first month’s budget
\(b\) is the log curve scaling factor
\(\log(12!) \approx 19.9872\)
This allows PropMan to find a suitable percentage of the annual budget to allocate to the first month, and then scale the remaining.
Statement of Disbursements¶
The Statement of Disbursements report gives a line-by-line view of all disbursements for a given period. This includes checks as well as journals against the operating account.
Example Report
Statement of Journal Entries¶
The Statement of Journal Entries report lists all journal entries for a given period showing a line for each side of the entry.
This report will look similar to the view on the Transactions screen, where Include Checks is unchecked and Include Journals is checked.
Example Report
Rent Roll¶
The Rent Roll report breaks down the collection status of all Residents in a Building for a given period.
Opening and closing balances are shown for each Resident, charges and credits for the period, and payments received. All amounts are broken out by allocation to the appropriate GL Accounts as defined by bills on the account and the PropMan allocation engine.
Example Report
Note
See Tax Abatements for more information about applying recurring credits to Resident accounts.
Aged Arrears¶
The Aged Arrears report lists all Residents with a past due balance, broken out by the number of days past due.
Example Report