Deal Intel: Income Statement Upload Best Practices

To ensure your income statement is processed accurately in Deal Intelligence, please follow the guidelines below when preparing your file. Proper formatting and structure will help avoid delays and ensure your data is interpreted correctly.

Your file must be submitted as an Excel workbook (.xlsx), and all relevant data should be contained within a single sheet. Files with multiple tabs or split data may not process correctly.

Each file should represent only one community. Please do not include combined data from multiple communities or separate sections for different properties within the same sheet.

The income statement must reflect a trailing 12-month (T12) period with monthly detail. Include at least 12 individual months of financial data, but remove any additional months or year-to-date columns that extend beyond the most recent 12-month period.

Column headers should clearly indicate the month and year for each period. If your file includes extra header rows, occupancy metrics, RevPOR analysis, or other supplemental information at the top, please remove these elements or place them in a separate workbook.

For consistency in calculation, both revenue and expense values should be shown as positive numbers.

To support accurate Net Operating Income (NOI) calculations, your file must include clear total rows for key sections. Specifically, there should be a total operating revenue line beneath all revenue items, a total operating expense line beneath all expense items, and a net operating income (NOI) line below total operating expenses.

The exact naming of these rows does not need to match a specific format, but the meaning should be clear and easy to interpret.

Any “below the line” items—such as depreciation, reserves, or one-time capital expenses—should appear after the NOI line to ensure standardized performance calculations.

Each line item should have a unique account code. Avoid using the same code for multiple rows. Additionally, ensure that account codes are consistently applied and correctly aligned with their category, whether revenue or expense.

Before uploading, take a moment to confirm that your file meets all of the above requirements. Ensuring the file is clean, consistent, and properly structured will help your data process smoothly and deliver accurate results within Deal Intelligence.