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. .. image:: ../images/reports/dropdown_menu_reports.png :alt: Reports Menu :align: center :width: 500 :smaller:`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 :doc:`Resident Details <../residents/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. .. image:: ../images/reports/trial_balance.png :alt: Trial Balance :align: center :width: 500 :smaller:`Example Report` .. _Bank Reconciliation: 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. .. image:: ../images/reports/bank_reconciliation.png :alt: Bank Reconciliation :align: center :width: 500 :smaller:`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. .. image:: ../images/reports/bank_statements.png :alt: Bank Statements :align: center :width: 500 :smaller:`Bank Statements screen` :ref:`Recon Report Package` !!!!!!!!!!!!!!!!!!!!!!!!!!! The *Recon Report Package* is a set of PropMan reports that are considered important to completing the reconciliation process. See :ref:`Recon Report Package` for more information. Checks ------ Checks represent monies paid from a Building to a :doc:`Vendor <../vendors>`. 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 !!!!!!!!!!!!!!!!!!! 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. .. image:: ../images/reports/outstanding_checks.png :alt: Checks :align: center :width: 500 :smaller:`Example Report` See the *Clear Checks Screen*. .. _Cleared Checks: Cleared Checks !!!!!!!!!!!!!! Cleared Checks are checks that have been cleared by the bank. The report shows checks cleared for a given month. .. image:: ../images/reports/cleared_checks.png :alt: Cleared Checks :align: center :width: 500 :smaller:`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. .. image:: ../images/reports/general_ledger_menu.png :alt: GL Menu :align: center :width: 500 :smaller:`General Ledger Menu` .. _General Ledger: General Ledger !!!!!!!!!!!!!! The *General Ledger* report provides a detailed view of all transactions for a given period with respect to the Building's accounts. .. image:: ../images/reports/general_ledger.png :alt: GL Report :align: center :width: 500 :smaller:`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. .. image:: ../images/reports/cash_ledger.png :alt: Cash Ledger :align: center :width: 500 :smaller:`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. .. image:: ../images/reports/occupant_ledger.png :alt: Occupant Ledger :align: center :width: 500 :smaller:`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. .. image:: ../images/reports/management_report.png :alt: Management Report :align: center :width: 500 :smaller:`Example Report` All of the following reports are included in the Management Report: - :ref:`Budget & Cashflow` - *Financial Statement* - :ref:`Statement of Disbursements` - *Paid Bills* - :ref:`Statement of Journal Entries` - *Journal Entries* - :ref:`Rent Roll` - *Collection Status* - :ref:`Aged Arrears` - *Arrears Report* .. _Budget & Cashflow: 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 .. image:: ../images/reports/budget_and_cashflow.png :alt: Statement of Disbursements :align: center :width: 500 :smaller:`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 :math:`A = \sum_{m=1}^{12} V_m` Where :math:`V_m` is the monthly budget allocation :math:`V_m = F + b \cdot \log(m)` :math:`b = \frac{A - 12F}{\log(12!)}` Where: - :math:`V_m` is the value for month :math:`m` - :math:`F` is the first month's budget - :math:`b` is the log curve scaling factor - :math:`\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: 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. .. image:: ../images/reports/statement_of_disbursements.png :alt: Statement of Disbursements :align: center :width: 500 :smaller:`Example Report` .. _Statement of Journal Entries: 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 :doc:`Transactions <../transactions>` screen, where *Include Checks* is unchecked and *Include Journals* is checked. .. image:: ../images/reports/statement_of_journals.png :alt: Statement of Journal Entries :align: center :width: 500 :smaller:`Example Report` .. _Rent Roll: 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. .. image:: ../images/reports/collection_status.png :alt: Rent Roll :align: center :width: 500 :smaller:`Example Report` .. note:: See :doc:`Tax Abatements <../residents/tax_abatements>` for more information about applying recurring credits to Resident accounts. .. _Aged Arrears: Aged Arrears !!!!!!!!!!!! The *Aged Arrears* report lists all Residents with a past due balance, broken out by the number of days past due. .. image:: ../images/reports/aged_arrears.png :alt: Aged Arrears :align: center :width: 500 :smaller:`Example Report`