Standard Report Types
Standard reports in Real Estate Manager serve as essential tools for managing property portfolios efficiently. These reports enable users to monitor contracts, track financial obligations, ensure compliance with accounting standards, and maintain proper documentation throughout the lease lifecycle. Each report addresses specific business needs and can be customized to meet organizational requirements.
The following are the standard reports available:
Payment Review Report- Identifies invoices due within a specified period to support timely payment processing. Enables users to perform pre-payment checks to ensure accurate payments to landlords and vendors.
Lease Accounting Significant Contract Report- Provides synchronization status of contracts. Reports contracts that are rejected by real estate or accounting users, contracts not synchronized with the accounting application, enabling users to take appropriate action as needed.
Lease Asset Portfolio Report- Provides a snapshot of all leased assets and contracts, including term details, current costs, asset locations, and contract status such as archived, expired, or terminated. Users can apply filters to analyze data by location, cost categories, or contract status. Supports financial and operational planning by enabling targeted review of active and historical lease records.
Owned Asset Portfolio Report- Provides a snapshot of all owned assets and contracts, including term details, current costs, asset locations, and contract status such as archived, expired, or terminated. Users can apply filters to analyze data by location, cost categories, or contract status. Supports financial and operational planning by enabling targeted review of active and historical owned assets.
Document Repository Report- Provides a centralized view of all files linked to assets and contracts. Supports filtering by file type and tracking expiry dates to assist with document audits and compliance.
Contract Renewal Option Report- Tracks renewal options for active lease contracts, including option periods, exercise windows, and likelihood of extension. Supports proactive lease management by identifying contracts requiring renewal discussions.
Contract Clause Report- Provides a centralized view of all clauses linked to lease contracts. Enables users to review, manage, and track contractual clauses to support compliance, negotiation, and operational awareness.
Download a PDF version of the guide
Payment Review Report or Invoice Due Report
The Invoice Due Report is designed to help users identify all invoices that are due within a specified time frame. It supports proactive payment planning by listing invoices that require attention using the Real Estate Manager Payment functionality. This report is particularly useful for validating invoice data before initiating payment runs to landlords or vendors.
How to Use the Report
Follow these steps to generate and analyze the Invoice Due Report:
Navigate to the Reports section in Real Estate Manager.
Select Invoice Due Report from the list of available reports.
Apply filters to refine the data by vendor, cost category, date range, or lease accounting sync status.
Review the filtered report to analyze costs and identify due invoices.
Use the insights to prepare for payment processing.
Export the report to Excel for further analysis or sharing with stakeholders.
Field Definitions
| Field Name | Description |
|---|---|
| Asset | The asset associated with the invoice. |
| Currency | The currency in which the invoice is issued. |
| Asset Address | The address of the asset associated with the invoice. |
| Linked Contract Lease Account | Contract associated with the invoice. |
| Description | A brief explanation of the invoice. |
| Invoice Direction | Indicates whether the invoice is incoming or outgoing. |
| Invoice Date | The date the invoice was issued. |
| Invoice Number | A unique identifier for the invoice. |
| Incurred Start Date | The start date of the cost period. |
| Incurred End Date | The end date of the cost period. |
| Invoice Group | The group or category the invoice belongs to. |
| Invoice Recurrence Frequency | How often the invoice recurs (e.g., monthly, quarterly). |
| Invoice Recurrence Pattern | The pattern followed by recurring invoices. |
| Notes | Additional comments or remarks. |
| Cost Category | Classification of the cost (e.g., maintenance, utilities). |
| Base Amount | The base amount of the invoice before taxes. |
| Tax Amount | The tax amount applied to the invoice. |
| Vendor | The vendor to whom the payment is due. |
| Payment Batch File Name | The name of the batch file used for payment. |
| Payment Batch Description | A description of the payment batch. |
| AP Export Status | The status of the invoice export to accounts payable. |
| Payee Code | The vendor code used for payment. |
| Linked Contract Lease Accounting Readiness | Indicates status of contract synchronization. |
Customization Tips
Users can tailor the Invoice Due Report to their needs by:
Adding or removing fields to focus on relevant invoice data.
Applying filters to view invoices by vendor, cost category, or date range.
Saving filtered views for quick access in future sessions.
Using Excel export to create charts or pivot tables for deeper analysis.
Lease Accounting Significant Contract Report or Contract Sync Status Report
This report is designed to help users review contracts that are linked with Lease Accounting Manager (LAM) and require synchronization between Real Estate Manager and LAM.
The main purpose of this report is to identify contracts that need attention based on their lease accounting synchronization status. Real estate and accounting teams typically use it to ensure contract data is properly reviewed, approved, and synchronized.
Sync Status Definitions
No Lease Accounting Readiness Review: The user needs to perform lease accounting readiness review. After this, the contract will be available for approval and synchronization.
Pending Real Estate Approval: Real Estate Manager user needs to approve the initial setup of the contract or any changes made to the contract.
Approved by Real Estate: Contract is available to be synchronized with Lease Accounting Manager.
Pending Account Approval: Contract is synchronized with LAM but not booked and approved by LAM user.
Synchronized: The contract is synchronized. No further action needed.
Rejected by Accounting: The contract is rejected by accounting team in Lease Accounting Manager. Real Estate Manager user needs to check with accounting team for the reasons for rejection and reperform the actions in Real Estate Manager and synchronize the contract again with LAM.
Rejected by Real Estate: The contract is rejected by real estate approver. Real Estate Manager user needs to check with Real Estate Approver to understand the reasons for rejection and reperform the actions in Real Estate Manager and synchronize the contract again with LAM.
How to Use the Feature
Follow these steps to use the Contract Sync Status Report:
Navigate to the Reports section in Real Estate Manager.
Select Contract Sync Status Report from the available report options.
Use filters to narrow down contracts by asset, country, state, or readiness status.
Review all rejected contracts and prioritize them for follow-up.
Review contracts needing action from accounting.
Review contracts set up in Real Estate Manager but not yet synced with LAM.
Export the report to Excel for further analysis or sharing.
Field Definitions
| Field Name | Description |
|---|---|
| Contract Asset: Name | Name of the asset associated with the contract. |
| Contract Asset: Reference Number | Unique identifier for the asset. |
| Contract: Reference Number | Unique identifier for the contract. |
| Contract Asset: Address State | State where the asset is located. |
| Contract Asset: Address Country | Country where the asset is located. |
| Contract: Contract Commencement Date | Start date of the contract. |
| Contract: Contract Expiry Date | End date of the contract. |
| Contract: Lease Accounting Readiness | Status of the contract's readiness for lease accounting. |
Customization Tips
Users can customize the Contract Sync Status Report by:
Applying filters to view contracts by country, state, readiness status, or termination status.
Saving filtered views to the report if needed.
Reviewing contracts rejected by either accounting or real estate approvers and correcting them in Real Estate Manager before re-synchronizing with LAM.
Ensuring all readiness reviews are completed before attempting synchronization.
Note: Blank Lease Accounting Significant Status indicates the contract type does not require synchronization with the Lease Accounting Manager.
Lease and Owned Asset Portfolio Reports
The Asset Portfolio Report in Real Estate Manager helps users view and manage all properties and their related contracts in one place. It shows important details such as where each asset is located, who owns it, and the status of its lease or contract. This report is useful for tracking active and archived assets, understanding financial commitments, and planning for contract renewals or terminations.
The report includes two types of information:
Asset Information: Details about each property, such as name, location, ownership, and whether it's archived.
Contract Information: Details about the lease or contract linked to each asset, including start and end dates, costs, and termination status.
How to Use This Report
Review asset status to see which properties are active or archived.
Check contract dates to plan renewals or monitor upcoming expiries.
Track financials like annual costs and currency to manage budgets.
Filter by location or ownership to focus on specific regions or business units.
Add more fields if needed to customize the report for team needs.
Users can also export the report or apply filters to narrow down the data based on specific goals.
Field Definitions
| Field Name | Description |
|---|---|
| Asset: Full Name | The name of the property. |
| Asset: Reference Number | Unique ID for the asset. |
| Asset Contract: Is Archived | Shows if the asset is archived. |
| Asset: Archived Date | Date when the asset was archived. |
| Asset: Address Country | Country where the asset is located. |
| Asset: Address State | State or region of the asset. |
| Asset: Address City | City where the asset is located. |
| Asset: Entity | Business unit or entity that owns the asset. |
| Asset: Ownership | Ownership type or structure. |
| Asset Contract: Reference Number | Unique ID for the contract. |
| Asset Contract: Lease Accounting Contract Type | Type of lease for accounting purposes. |
| Asset Contract: Lease Accounting Review Status | Status of lease accounting review. |
| Asset Contract: Currency | Currency used in the contract. |
| Asset Contract: Contractor | Name of the contractor or service provider. |
| Asset Contract: Contract Direction | Indicates if the contract is incoming or outgoing. |
| Asset Contract: Commencement Selected Costs P.A | Annual cost at the start of the contract. |
| Asset Contract: Commencement Selected Costs P.A Total | Total annual cost across all selected items. |
| Asset Contract: Commencement Date | Start date of the contract. |
| Asset Contract: Expiry Date | End date of the contract. |
| Contract: Absolute Expiry Date | Final expiry date, including any extensions. |
| Contract: Is Terminated | Shows if the contract has been terminated. |
| Contract: Effective Termination Date | Date when the termination took effect. |
Best Practices
Reviewing the Current Portfolio: View all active assets and their associated contracts by filtering Asset Contract: Is Archived = No. This helps users understand which properties are currently managed.
Reviewing the Cost for the Portfolio: Analyze current financial commitments and compare properties using fields like Commencement Selected Costs P.A and Commencement Selected Costs P.A Total. Filter by currency or entity for budget planning.
Reviewing Contracts Expiring Soon: Identify contracts nearing their end by sorting or filtering 'Asset Contract: Expiry Date' or 'Contract: Absolute Expiry Date' within the next 3–6 months.
Using Asset Status to Identify Archived Contracts: Audit historical or inactive assets by filtering 'Asset Contract: Is Archived = Yes' and reviewing 'Archived Date'.
Identifying Terminated Contracts: Track contracts that have been ended early or completed by filtering 'Contract: Is Terminated = Yes' and reviewing 'Effective Termination Date'.
Comparing Cost Based on Location: Benchmark costs across regions or cities using Address Country, Address State, and Address City in combination with cost fields.
Document Repository Report
The Document Repository Report provides a centralized view of all documents uploaded to the system and linked to assets or contracts. It helps users identify contracts or assets missing supporting documentation, maintain a complete audit trail, and track document lifecycle events such as expiry. This report supports operational, legal, and compliance workflows by ensuring data completeness and accessibility.
How to Use the Report
Follow these steps to access and use the Document Repository Report:
Navigate to the Reports section in Real Estate Manager.
Select Document Repository Report.
Apply filters to narrow down by asset name, contract number, upload date, expiry date, or content type.
Review the report to identify missing documents and validate contract metadata.
Export the report to Excel for further analysis or sharing.
Field Definitions
| Field Name | Description |
|---|---|
| Asset | The name of the asset. |
| Asset: Reference Number | A unique identifier for the asset. |
| Asset Contract: Contract Number / Reference Number | The reference number for the asset contract. |
| Asset: Entity | The entity associated with the asset. |
| Asset Contract(s): Contract Comments | Comments related to the asset contract(s). |
| Asset Contract(s): Contract Display Date | The date when the contract is displayed. |
| Asset File(s): File Name | The name of the file associated with the asset. |
| Asset Contract(s): Content Type ID | Identifier for the type of content in the contract. |
| Asset File(s): Upload Date | The date when the file was uploaded. |
| Asset File(s): Expiry Date | The expiration date of the file associated with the asset. |
| Asset File(s): Extension | The file extension (e.g., .pdf, .docx). |
Best Practices
Use filters to find contracts with no associated files. These may need supporting documentation uploaded.
Sort by expiry date to identify documents nearing expiration.
Use Content Type ID to categorize documents (e.g., lease agreements, insurance certificates).
Review Contract Comments for negotiation notes or special terms.
Validate file formats using the Extension field to ensure compliance.
Contract Renewal Option Report
The Contract Renewal Option Report is designed to help lessee users and accounting teams track renewal options across lease contracts. It provides visibility into:
Renewal option details and timelines.
Whether options are exercised or not.
Whether options are reasonably certain to be exercised (for accounting purposes).
Key contract and asset metadata to support renewal planning and landlord discussions.
This report supports proactive lease management by identifying contracts that require attention from a term renewal perspective.
The report has already filtered out terminated and archived contracts to focus on active leases.
How to Use the Report
The users can perform the following:
Review option start/end dates and exercise windows.
Assess the state of each option to determine renewal likelihood.
Use notes to capture communication status or internal decisions.
Share the report with the accounting team, especially if using the Real Estate Manager–Lease Accounting Manager synchronization feature.
View multiple options per contract in one consolidated report.
To find Month-to-Month contracts, filter for records where the Contract Option End Date is blank. A blank end date indicates that the contract is continuing without a fixed renewal term, which is typical of MTM arrangements.
Field Definitions
| Field Name | Description |
|---|---|
| Contract: Reference Number | Unique identifier for the contract. |
| Contract: Contractor | Vendor or contractor associated with the contract. |
| Contract: Contract Commencement Date | Start date of the contract. |
| Contract: Is Contract Terminated | Indicates if the contract has been terminated. |
| Contract: Contract Expiry Date | End date of the current exercised term. |
| Contract Absolute Expiry Date | Refers to the final possible end date of a contract, including all renewal options, even if those options have not yet been exercised. |
| Contract Option: Name | Name or label of the renewal option. |
| Contract Option: Start | Start date of the renewal option term. |
| Contract Option: End | End date of the renewal option term. |
| Contract Option: Exercise Start | Date from which the option can be exercised. |
| Contract Option: Exercise End | Last date by which the option must be exercised. |
| Contract Option: Term/Option State | Indicates if the option is exercised, not exercised, or reasonably certain to be exercised. |
| Contract Option: Term Notes | Notes field for capturing internal comments or communication status (e.g., landlord discussions). |
Limitations
There is no dedicated field to track whether the option has been formally communicated to the landlord. Use the Term Notes field for this purpose.
Financial impact of exercising the option (e.g., post-renewal cost) is not available in this report.
Note: All renewal options linked to a contract are listed, allowing users to review multiple options in one view.
Best Practices
Portfolio Planning: Filter contracts with options expiring in the next 6 months to prepare for renewals.
Accounting Sync: Share contracts marked 'Reasonably Certain To Be Exercised' with accounting for lease liability updates.
-
Landlord Follow-up: Use 'Option Notes' to track communication status and follow-up actions.
Consider using custom fields or tagging in 'Option Notes' to track landlord communication milestones (e.g., 'Notice Sent', 'Awaiting Response').
Financial impact of renewal options is not included; use complementary reports for cost analysis.
Ensure all relevant options are reviewed, especially those marked as 'Pending' or 'Reasonably Certain'.
Contract Clause Report
The Clauses Report provides users with a centralized view of all clauses linked to lease contracts in Real Estate Manager. It allows users to review, manage, and track contractual clauses in one place, supporting better compliance, negotiation, and operational awareness.
How to Use the Report
Renewal & Negotiation Preparation: Identify key terms (e.g., break clauses, rent review clauses) before entering renewal discussions with landlords.
Compliance Monitoring: Ensure that critical obligations (e.g., maintenance, insurance, termination rights) are being tracked and followed.
Portfolio-Wide Clause Analysis: Compare clause types and terms across multiple contracts to identify trends, risks, or inconsistencies.
Operational Planning: Use clause data to inform property management, budgeting, and risk mitigation strategies.
Field Definitions
| Field Name | Description |
|---|---|
| Contract: Reference Number | Unique identifier for the contract. |
| Contract: Contractor | Vendor or contractor associated with the contract. |
| Contract: Is Contract Terminated | Indicates whether the contract has been terminated. |
| Contract Clauses: Category | Classification of the clause (e.g., financial, legal, operational). |
| Contract Clauses: Clause | Title or name of the clause. |
| Contract Clauses: Original Clause Text | The original wording of the clause as written in the contract. |
| Contract Clauses: Interpretation | Explanation or summary of what the clause means in practical terms. |
| Contract Clauses: Notes | Additional notes or comments related to the clause. |
| Contract Clauses: Document | Reference to the document where the clause is located or attached. |
| Contract Clauses: Comments | User-entered comments or feedback about the clause. |
| Contract Clauses: Amendment Date | Date when the clause was last amended. |
| Contract Clauses: Amendment Clause Text | Updated wording of the clause after amendment. |
| Contract Clauses: Triggered On | Date or condition when the clause was triggered or became active. |
Best Practices
Use filters to search clauses by category, amendment date, or triggered status.
Track clause lifecycle by reviewing 'Amendment Date' and 'Amendment Clause Text'.
Use 'Interpretation' to standardize understanding across teams.
Consider tagging high-risk clauses (e.g., indemnities, termination rights) for legal review.