The Management Summary Report (MSR) provides you with real-time insights into the overall health of your business by giving at-a-glance information on your property’s net revenue, invoices, occupancy, rental activity, leads conversion, delinquency, liabilities, discounts and promotions, key performance indicators like Autopay enrollment, Coverage enrollment, overlocked spaces, lifetime values, length of stay, etc. 

This report provides a detailed breakdown of each summarized section across different tabs in Excel. 
Note: The detailed tabs are only available in the XLSX format, not in PDF.

Tabs such as Leads, Payments, Refunds, Write-offs, Invoices, Promotions - Discounts, Applied Credits, Move-ins, Move-outs, Transfers, and Reservations display data specific to the report date. For example, if the report is downloaded on September 5th, 2024, the Move-ins tab shows all move-ins that occurred on that day (not MTD or YTD). If no move-ins occurred on September 5th, the tab is empty.

Tabs like Occupancy, Delinquencies, Past Due Invoices, Liabilities, Rent Change, No Rent Change in the Last 12 Months, Coverage, Autopay Enrolled, and Overlocked Spaces include all relevant data up to the report date. For example, if the report is downloaded on September 5th, 2024, the Past Due Invoices tab will display all past due invoices up to that date.

This report provides a summarized view of the operational and financial metrics for a property or group of properties. It can also be used to share your property's financial and management data with banks.

To view the MSR:

1. Expand the Management Reports folder from your Reports Library and click Management Summary Report. Alternatively, you can use the Search bar available in the Reports library.

2. Provide the following information: 

• Report Time Period - The timeframe for which you want to view the data, i.e. Today, yesterday, etc. You can specify a specific date by clicking Custom Date from the drop-down list and selecting the required date from the calendar. 

• File Type - The preferred file format for downloading the report, i.e. .pdf or .xlsx
• Property - The property for which you want to view the associated data in the report. 

3. Click Run Report. 
Alternatively, you can run the report by clicking Run Report from the corresponding vertical ellipsis. 

Note: Since the MSR is a static report, it cannot be customized to add or remove fields, filter, or sort data. It is downloaded to your computer in a fixed format.

Management Summary Report Sections 

Net Revenue 

The actual income earned by the property from its operations, minus any deductions such as discounts, allowances, refunds, and any other costs directly associated with generating that income. This can also be called total payments collected, total revenue generated, or total deposits.

The report provides the net revenue for different timeframes that can help you track the short-term as well as the long-term performance of your property: 

• Month-to-date (MTD) - The net revenue generated from the beginning of the current month up to the present date. For example, if today's date is August 11th, the MTD revenue would be calculated by summing up all the revenue earned from August 1st to August 11th.  
  You are also presented with the MTD value on the same day last month. This can help you track short-term performance and make timely business decisions based on current revenue figures.
• Year-to-date - The total net revenue earned from the beginning of the current calendar year up to the present date. It involves summing up all the net revenue generated from 1st January of the current year up to the present date, i.e. 11th August.  
  The Year-to-date revenue can help you access your property’s performance over a longer time frame and understand how it's tracking toward its annual revenue goals.

The numbers in the Net Revenue should match with Deposits & Refunds section and Deposits by Product Type Section.

Occupancy 

This section displays your property’s current occupancy percentages by square foot, spaces, and economic occupancy. 

• SQ FT - Utilization of your property based on its square footage. You can access how efficiently a Space is being utilized from this and make decisions about lease agreements, rental rates, space optimization, etc. 
• Spaces - Measurement of occupancy based on the number of Spaces occupied compared to the total number of Spaces available. This can provide insights into the demand and utilization of rental Spaces. 

Rental 

This section provides an overview of the total number of move-ins and move-outs at your property on the Report date, Month-to-date (MTD), and Year-to-date (YTD) bases. You can also view the net activity, which is calculated by subtracting the number of move-outs from move-ins. A negative net value indicates that there have been more move-outs than move-ins during the period.

Leads 

In this section, you can view the total number of leads received from various sources, such as the website, phone calls, emails, walk-ins, third-party integrations, and more. It also shows the number of lead conversions for the current date, Month-to-Date (MTD), and Year-to-Date (YTD).
In the example provided below, the Conversion Rate for MTD is calculated by dividing 153 (number of conversions) by 194  (total leads), resulting in a 78.9% conversion rate.

Deposits & Refunds

This section provides a detailed overview of your property's deposits and refunds, categorized by different payment methods, such as Cash, Check, ACH, and Debit/Credit Cards. The data is displayed for the current day, Month-to-Date (MTD), and Year-to-Date (YTD).
Additionally, you can view the number of NSFs (Non-Sufficient Funds), which indicate instances where a payment could not be processed due to insufficient funds in a tenant’s account. The section also includes information on payment reversals, which may occur due to advanced payments, duplicate deductions, chargebacks, or ACH reversals.

The numbers in this section should align with those in the Net Revenue and Deposits by Product Type sections.

Note: The Refunds in the Deposits & Refunds section will not match the Refund Amount in the Refunds Report. The MSR Refunds section includes only payment methods such as cash, card, ACH, and check, excluding credit. However, the Refunds Dynamic Report includes refunds where the payment method is credit.

This section can be reconciled with the following reports:

• Payments Report / Payments and Credits: Select the relevant date or date range and payment method to reconcile Cash, Check, ACH, or Card payments. The Refunds Given column in the Payments Report can be used to reconcile NSF/reversals.
• Accounting Export: Download the Accounting Export for the relevant period and filter by Card, Check, ACH, and Cash payments. Refunds are already included in the Accounting Export, so there's no need to add NSF/reversals separately.
• Close of Day Deposits: Use the Close of Day Deposits report to reconcile transactions for a specific date.
• Cash Audit Report: This report is organized by date and payment method, allowing easy reconciliation.
• Payments by Product Type: While this report does not provide a breakdown by payment source, it can be used to reconcile total amounts.
• Financial Summary Report: Similar to the Payments by Product Type report, it doesn't break down payments by source but can be used to reconcile overall figures.
• Reconciliation Report (BETA): Download this report for the same period to reconcile the relevant entries.
• Portfolio KPI: Download this report for the corresponding period and use it to reconcile relevant entries.
• Refunds Report: The MSR Refunds section only includes payment methods like cash, card, ACH, and check, excluding credit. However, the Refunds Dynamic report includes payments made with credit, which may cause a discrepancy between the two reports.

Invoices 

This section provides the total amount of all invoiced amounts due within the selected time frame (e.g., on the report date, Month-to-Date, or Year-to-Date). It estimates the income your property is projected to earn in a future period based on due invoices. These invoices account for potential income sources, such as rent, insurance/protection, service fees, merchandise, and other miscellaneous revenue. Any discounts or promotions applied to these invoices are also reflected in this section.

This report can be reconciled with the MSR Detail - Net Revenue and Projected Income and Invoices Report

Accounts Receivable  

This section includes the total amount you are expected to receive from all leases within the selected time frame, including both active and closed leases. Accounts Receivable refers to all outstanding amounts you are yet to collect for the services or products you have provided.

• AR Balance (Active Leases): This includes all the amount due (there is no date constraint here) from the delinquent tenants with active leases. This should match with the Total of Delinquency by Days section in MSR.
• Running Total (With Move-Out): This includes all the amount due (there is no date constraint here) from all tenants (including moved out). This should match with the Total of AR Aging section in MSR and Balance Due column in Accounts Receivable dynamic report.

Additionally, you can reconcile this report with the Accounting Export. Download the Accounting Export for the relevant period (daily, monthly, or yearly) and match the Accounts Receivable GL Code with the entries in the MSR.

Prepaid Liabilities 

Prepaid Liabilities refer to payments collected before an invoice's due date. These payments can be classified as amounts paid before or on the due date (i.e., payment date ≤ due date).  This section's report date, MTD (Month-to-Date), and YTD (Year-to-Date) values are based on the payment date. For example, if a tenant pays $1,200 on January 1st for a space costing $100 per month, the Prepaid Liabilities section of the MSR report for January will display $1,200 in the MTD column. This amount will also appear in the YTD column, as the payment was received in January. For reports generated in later months, the YTD column will continue to reflect the $1,200 payment made in January.

The prepaid Liabilities Balance indicates all the prepaid amounts for future invoices that are not yet past their due date. 

This comprehensive view includes all advance payments received, regardless of their due dates, providing a complete record of prepaid amounts. This should align with the Liabilities tab in the MSR Excel report or the MSR Detail Liabilities report.

Liability Recognition 

Liability Recognition event only occurs for Prepaid Liabilities. This means that a prepaid liability transitions to a recognized liability once the invoice due date has passed. At this point the monthly amount due is shown as a recognized liability. 

For example, in January, if a tenant pays $1,200 upfront, the Liability Recognition section for January will display $100 in both the MTD and YTD columns, reflecting the amount due for that month (January). Only the January amount has passed its due date, making it eligible for recognition.

An additional $100 becomes due in February. For February, the MTD column will show $100, and the YTD column will display $200, accumulating $100 from January and $100 from February.

Recognition is based on the invoice due date. For instance, if a payment is made on September 10th for an invoice due on October 15th, it will remain under Prepaid Liabilities until October 15th. After that date, the October amount is transferred to Liability Recognition.

In the previous version of the MSR ((pre-October 2024, no longer available), the Liabilities section displayed only prepaid amounts due after the report date, effectively showing the outstanding balance of prepaid amounts. For example, if a report was downloaded on October 25, it includes all prepaid rent, insurance, fees, and deposits due after October 25. However, this section does not show any prepaid amounts with due dates before the report date. For example, this section does not show an invoice due in April that was paid in March.

In the current version of the MSR, the Prepaid Liabilities section now reflects the total of all prepaid funds collected, covering both future and past due dates. For example, if a tenant pays $1,200 on January 1 for a space that costs $100 per month, the MTD (Month-to-Date) column in the Prepaid Liabilities section for January will show $1,200. This amount will also appear in the YTD (Year-to-Date) column since it was received in January. For reports generated in the following months, the YTD column will continue to reflect the initial $1,200 payment made in January, showing the cumulative prepaid amount over time.

If you want to view only the prepaid amounts due after the report date and the outstanding prepaid balance, refer to the MSR Detail - Liabilities Summary Report (Hummingbird Static Report) or check the Liabilities tab in the Excel version of the MSR Summary Report.

To view only the prepaid balance to be collected, use the MSR Detail - Liabilities Summary Report. 

To view the total prepaid collected as of a specific date, refer to the Pre-paid Liabilities section in the in the Excel version of the MSR Summary Report.

Performance Indicators 

These metrics help measure and evaluate your property's performance, including key data points like autopay enrollment, insurance/protection participation, delinquent tenant overlocks, and rent stability over the past 12 months.

• Autopay Enrollment: Total number of spaces enrolled in autopay. The percentage is calculated by dividing the number of autopay-enrolled spaces by the total number of occupied spaces.
• Coverage Enrollment: Total number of spaces enrolled in insurance/protection coverage. The percentage is calculated by dividing the number of covered spaces by the total number of occupied spaces.
• Overlocked Spaces: Total number of spaces currently in overlock status due to tenant delinquency. The percentage is calculated by dividing the number of overlocked spaces by the total number of occupied spaces.
• Reserved Spaces: Total number of spaces marked as reserved. The percentage is calculated by dividing the number of reserved spaces by the total number of occupied spaces. 
  Note: Reserved spaces are included in the Vacant Spaces count in the Space Occupancy section.
• Complimentary Spaces: Spaces with a rent amount of $0 are classified as complimentary. The percentage is calculated by dividing the number of complimentary spaces by the total number of spaces. 
  Note: Complimentary spaces are included in the Occupied Spaces count in the Space Occupancy section.
• No Rent Change in Last 12 Months: This displays the number of leases for which the rent has not been adjusted in the past 12 months. The percentage is calculated by dividing the number of leases with no rent change by the total number of leases.
• Average Length of Stay (LOS)- Based on Moved-Out Leases: The average number of days a tenant occupies a space, considering only leases that have ended. This is calculated by taking the difference between the move-in and move-out dates.
• Average Length of Stay (LOS)- Aggregated: The average number of days a tenant occupies a space, including both active and moved-out leases. For active leases, the calculation uses today's date to determine the length of stay.
• Lifetime Value-Based on Moved-Out Leases: This metric estimates the total revenue generated from a tenant over the course of their relationship with the property (for tenants who have moved out). The formula is the sum of all payments (including rent, merchandise, insurance, etc.) divided by the total number of moved-out leases.
• Lifetime Value-Aggregated: This metric estimates the total revenue generated from current and former tenants over the course of their relationship with the property. The formula is the sum of all payments (including rent, merchandise, insurance, etc.) divided by the total number of leases (active and moved out).

Revenue Statistics 

Revenue Based on Occupancy Status of Spaces. This section outlines the revenue generated depending on the occupancy state of spaces, such as offline, vacant, or occupied. It includes the following columns:

• Gross Potential Revenue: This represents the total revenue that could be earned if all available spaces were rented at their respective rates, either the Set rate or the Sell rate. It assumes 100% occupancy and does not account for vacancies or discounts. To calculate Gross Potential Revenue, sum the rental rates of all available spaces at your property.
  • Set Rate: A predetermined rental price for a space, generally stable and influenced by market conditions. It serves as a base rate for calculating rent adjustments.
  • Sell Rate: The price a property owner aims to rent a space for. However, the final rental amount may differ depending on the rental agreement.
  • $ Value: The total revenue generated when all spaces are rented at either the Sell Rate or the Set Rate.
  • % Value: The percentage of Gross Potential Revenue generated from the Sell or Set Rate, relative to the total potential revenue. The total percentage will always sum to 100%.
  • $/Sqft Value: The revenue generated per square foot if all spaces are rented at either the Set Rate or Sell Rate.
    Example: Suppose your property has a total of 5 spaces, each measuring 100 square feet. The total square footage of the property is 500 square feet.
    Set Rate ($):
    - Set Rate for Space 1: $100
    - Set Rate for Space 2: $150
    - Set Rate for Space 3: $200
    - Set Rate for Space 4: $250
    - Set Rate for Space 5: $300
    Gross Potential Revenue (Set Rate): To calculate the Set Rate Gross Potential Revenue (GPR), sum the Set Rates of all spaces:
    - Set Rate GPR = $100 + $150 + $200 + $250 + $300 = $1,000
    Sell Rate ($):
    - Sell Rate for Space 1: $100
    - Sell Rate for Space 2: $170
    - Sell Rate for Space 3: $230
    - Sell Rate for Space 4: $240
    - Sell Rate for Space 5: $310
    Gross Potential Revenue (Sell Rate): To calculate the Sell Rate Gross Potential Revenue, sum the Sell Rates of all spaces:
    - Sell Rate GPR = $100 + $170 + $230 + $240 + $310 = $1,050
    Revenue per Square Foot ($/sqft):
    - Set Rate $/sqft: Set Rate GPR / Total Square Footage = $1,000 / 500 sqft = $2/sqft
    - Sell Rate $/sqft: Sell Rate GPR / Total Square Footage = $1,050 / 500 sqft = $2.10/sqft         
• Gross Offline Revenue: The total potential revenue that could be generated if all offline spaces were rented at their respective rental rates (Set or Sell rate).
  - $ Value: The total revenue generated if all offline spaces were rented at either the Sell Rate or Set Rate.
  - % Value: The percentage of Gross Offline Revenue compared to the Gross Potential Revenue. Formula: (Offline revenue from Set or Sell Rate) / (Gross Potential Revenue).
  - $/Sqft Value: The revenue generated per square foot if all offline spaces were rented at the Set or Sell Rate.
• Gross Vacant Revenue: The potential revenue that could be generated if all vacant spaces were rented at their respective rental rates (Set or Sell rate). This figure represents the revenue lost due to vacant spaces.
• Gross Occupied Revenue: The total revenue generated from all occupied spaces on the property. This metric provides insight into the actual revenue collected from rented spaces over a given period.
• Occupied Rate Variance: Measures the financial impact of the difference between the actual occupancy rate and the target or expected occupancy rate. This helps gauge how variations in occupancy affect overall revenue.
  - $ Value: Gross Occupied Revenue - Economic Occupancy.
    - % Value: (Gross Occupied Revenue - Economic Occupancy) / Gross Potential Revenue.
    - $/Sqft Value: (Gross Occupied Revenue - Economic Occupancy) / Total square footage of occupied spaces.
• Economic Occupancy: A measure that compares the actual rent collected with the potential rent if all spaces were rented at the Set or Sell rates. This metric reflects the efficiency of revenue generation and how effectively the property converts potential income into actual revenue.
  - $ Value: The total current (actual) rent collected from all occupied spaces.
  - % Value: Current (actual) rent collected from all occupied spaces / Gross Potential Revenue.
  - $/Sqft Value: Current (actual) rent collected from all occupied spaces / Total square footage of occupied spaces.
• Net Payments (Deposits): The total amount received from tenants after accounting for any refunds, reversals, adjustments, chargebacks, or other credits.
  - $ Value: The total rental deposits collected for Month-to-Date (MTD), including revenue from storage, parking, and other sources from the beginning of the month until the current date.
  - % Value: Total rental deposits collected for MTD / Gross Potential Revenue.
  - $/Sqft Value: Total rental deposits collected for MTD / Total square footage of occupied spaces.

Space Statistics 

This section provides key data regarding your property's occupied, vacant, and offline spaces. It includes the following metrics for each space type:

• Average SQ FT/Space - This is the average size of a space, calculated by dividing the total square footage by the total number of spaces for occupied, vacant, and offline spaces.
• Average Rent/Space ($) - This is the average rent for each space, calculated by dividing the total rent of all spaces by the total number of spaces for occupied, vacant, and offline spaces.
• Average Rent/SQ FT ($) - This is the average rent per square foot, calculated by dividing the total rent of all spaces by the total square footage for occupied, vacant, and offline spaces.

Space Occupancy 

This section provides a detailed overview of your property’s space occupancy status. Here, you can view the total number and percentage of spaces that are Occupied, Vacant, or Offline. Additionally, you can see the square footage and the percentage of total rentable space attributed to each category.

Leads 

This section provides an overview of the number of leads generated from various sources, such as web, walk-in, phone, etc. It also shows how many of these leads were converted into tenants within the selected time frame.
- Leads Converted: This displays all the leads that were converted into tenants on the report date, Month-to-Date (MTD), or Year-to-Date (YTD).
For example, if a lead was created in September and converted in October, it appears as a converted lead in the October report, not the September report. Leads are tracked by their creation date, while converted leads are recorded based on the conversion date.

Rent Analysis 

This section analyzes your property's rental performance compared to Set and Sell rates, including space counts, variances, and the financial impact. This analysis helps identify overperforming or underperforming spaces in terms of rent revenue, enabling management to better understand rental performance, assess pricing strategy effectiveness, and make informed decisions to optimize revenue and occupancy.
Key Metrics:

• Count: The number of spaces rented above and below the Set or Sell rates.
• Count Variance: The difference between the number of spaces rented above the Set or Sell rate and those rented below it.
• $ Value: The total revenue generated from spaces rented above and below the Set or Sell rates.
• $ Variance: The difference in revenue generated from spaces rented above the Set or Sell rate compared to those rented below.
  Example: Let’s assume the following rental rates for a few spaces:
  - Space 1: $100  
  - Space 2: $150  
  - Space 3: $90  
  - Space 4: $200  
  The t Rate is $110, and the l Rate is $130.
  - Revenue from Spaces Above Set Rate ($110):  
   - Space 1: $110 - $100 = $10  
   - Space 3: $110 - $90 = $20  
   - Total Revenue: $10 + $20 = $30
  - Revenue from Spaces Below Set Rate ($110):  
   - Space 2: $110 - $150 = -$40  
   - Space 4: $110 - $200 = -$90  
   - **Total Revenue**: -$40 + -$90 = -$130
  - $ Variance: Revenue above Set Rate - Revenue below Set Rate = $30 + (-$130) = - $100
  A similar calculation can be done to measure revenue variance for the Sell Rate.
  Note:
  - A positive variance for the Set or Sell rate indicates that spaces rented above the rate generate more revenue than those rented below.
  - A negative variance suggests that spaces rented below the rate generate more revenue than those above it.

Rental Statistics 

This section details Rental Activity , Transfers and Reservations within the selected time frame.

• Move Ins: All the move ins which were done on the report date , MTD and YTD.  
• Move Outs: All the move outs which were done on the report date , MTD and YTD. 
• Net Activity: The total move ins minus the total move outs on the report date, MTD and YTD.  
• Transfers: Displays all tenant transfers that occurred on the report date, Month-to-Date (MTD), or Year-to-Date (YTD).
• Reservations: All the reservations which were done on the report date , MTD or YTD.

Rental Statistics SQFT 

• SQFT Move In - The total square footage of spaces where tenants moved in during the specified time frame. Ex - If two tenants moved into 5x5 spaces, the total SQFT Move-In for that day would be 50 sqft. 
• SQFT Move Out -  The total square footage of spaces from which tenants moved out during the specified time frame. Ex - If four tenants moved out of 5x5 spaces, the total SQFT Move Out for that day would be 100 sqft.
• Net SQFT Activity - The difference between the total square footage of spaces where tenants moved in and those vacated by tenants. Ex - If SQFT Move Out is 100 sqft and SQFT Move In is 50 sqft, then the Net SQFT Activity is -50 sqft.

Allowances 

The Allowances section summarizes the concessions given to tenants on the report date, Month-to-Date (MTD), and Year-to-Date (YTD). This includes all discounts, promotions, and write-offs applied to your property.

• Discounts and Promotions: Any reductions or special offers provided to tenants. The totals should match the MSR Detail - Discounts/Promotions Report (Static) and the Discounts and Promotions (Dynamic) Report.
• Write-Offs: Write-offs are reductions in potential revenue due to amounts deemed uncollectible, also referred to as bad debts. These totals should align with the MSR Detail - Writeoffs Report.

Credits and Adjustments  

This section outlines any adjustments made to tenant accounts, such as credit transfers or refunds, that reduce the amount owed to the property. The adjustments are displayed for the report date, Month-to-Date (MTD), and Year-to-Date (YTD), providing insight into adjustment trends over time.
All credits and adjustments listed here can be reconciled with the MSR Detail - Applied Credits Report.

Deposits by Product Type  

This section provides a comprehensive overview of the revenue generated from deposits across various product types offered by your self-storage property, including storage and parking rent, fees, merchandise, services, insurance, and miscellaneous deposits. It offers insights into revenue performance for different timeframes, enabling you to track both short-term and long-term property performance. You can view revenue figures for:

• Current Date: Revenue generated as of today.
• Month-to-Date (MTD): Revenue accumulated from the beginning of the current month to the present date.
• Year-to-Date (YTD): Total net revenue earned from January 1st of the current year up to the present date.
  Revenue Breakdown:
• Total Rent: Revenue from all space types, including storage, parking, and residential. Any additional space types may be categorized under “Other Revenue.”
  - Total Fee: This includes revenue from various fees, excluding administrative, late, or NSF fees. General Fee Revenue encompasses all other applicable fees.
  - Total Merchandise: Revenue generated from merchandise sales is detailed here. Other merchandise items, such as batteries, may be allocated under Other Revenue.
  Note: Sales tax and security deposits are classified as liabilities and are not included in this revenue section.

AR Aging 

The AR Aging Report provides a detailed list of delinquent and moved-out tenants. This report allows you to assess how long tenants have been delinquent, their total unpaid amounts, and their move-out dates.
Key Differences:  
- AR Aging: Includes all leases (both active and moved out).
- Delinquency: Only displays information for active leases.
You can reconcile this report with the AR Aging (Static) Report.

• Dollar Amount Column: Displays amounts at the invoice level. Some buckets can show a dollar amount while the count remains at 0. This situation occurs when the leases associated with those invoices have already been counted in previous ranges.
• Count Column: Represents the number of leases at the lease level. A lease may be late on multiple invoices, resulting in a count of 1 for the oldest invoice. The total number of due invoices will be distributed based on their due dates.

For further clarification on why there may be a count of 0 in the MSR Delinquency by Days while still showing a positive dollar amount, please refer to the section Explanation of Count of 0 in MSR Delinquency by Days with Positive $ Amount.

Delinquency By Days  

This section presents information about tenants who are delinquent, categorized by the number of days they are past due, such as 0-10 days, 11-30 days, and greater than 30 days. Here, you can view both the number and percentage of delinquent tenants, along with their corresponding past-due amounts.

Rent Change Summary  

This section provides details regarding rent changes for leases at your property. These changes may result from lease renewals, market fluctuations, and other factors. The Count indicates how many leases or tenants have experienced a rent change in the last six months.
The Rent Variance is calculated as the absolute difference between the old and new rent.

Note: This section provides an overview of rent changes for currently active leases and helps ensure no lease has gone without a rent adjustment for more than 24 months. For example:

Example 1 - If a tenant had a rent increase in January and then moved out in February, that rent increase would not be reflected in the Rent Change Summary if you're viewing the report for March.

Example 2: If a tenant received rent increases in January 2024, May 2024, and December 2024, the widget will only count the December 2024 increase.

Explanation of Count of 0 in MSR Delinquency by Days with Positive $ Amount

The Count column reflects the number of leases at the lease level, while the $ Amount column is based on individual invoices. A lease may have multiple late invoices, resulting in a count of 1 for its oldest unpaid invoice. In this scenario, any additional due invoices is distributed across their respective due dates.

In the example, even though this lease has invoices across six different ranges, it will only be counted in the range associated with the oldest invoice, which is 202401-1-1447 for $275.25 in the 180-360 days bucket.

As a result, it is possible for some buckets to show a dollar amount while the count remains at 0. This occurs when the leases linked to those invoices, which contribute to the dollar amount, have already been included in earlier ranges.