Intacct Real Estate
Intacct Real Estate
Breadcrumbs

Straight Line Rent.

1. Introduction

Purpose

The Straight Line Rent report helps users review the monthly straight-line rent calculation for leases whose properties are configured to calculate straight-line rent.

The report compares the actual scheduled base rent for each month against a fixed straight-line rent amount calculated across the full lease or charge schedule. It is mainly used to identify the monthly accounting adjustment needed to normalize rent over the lease term.

Aggregation Level

This report is presented at the lease, unit, base rent item, and month level.

Each lease is grouped separately, and the detail rows show the monthly rent schedule for each eligible base rent charge.

2. How to Use the Report

Step 1 - Select Filters

Open the report and set the parameters in the following order:

  1. Entity ID (multi-select)

  2. Property Name (multi-select)

  3. Lease Status (multi-select)

  4. Display Start Date (optional)

  5. Display Years (optional)

Step 2 - Run the Report

After selecting the parameters, run or refresh the report.

The report is scoped to properties where straight-line rent calculation is enabled. If a selected property is not configured for straight-line rent, leases from that property will not be included in the calculation.

Step 3 - Review Display Date Controls

The display date controls affect only which monthly rows are shown in the report. They do not change the straight-line rent calculation.

Use Display Start Date to control where the visible monthly timeline begins.

  • If Display Start Date is blank, the report starts the visible month display from the lease start date or the beginning of the base rent charge schedule.

  • If Display Start Date is selected, the report starts the visible month display from the month of the selected date.

Use Display Years to control where the visible monthly timeline ends.

  • If Display Years is blank or 0, the report shows months through the lease end date or recurring charge end date.

  • If Display Years is 1, the report shows one year from the visible start date.

  • If Display Years is 2, the report shows two years from the visible start date.

  • If Display Years is 10, the report shows up to ten years from the visible start date.

  • If a value greater than 10 is entered, the visible range is capped at ten years.

These controls are useful when users want to review only a shorter reporting window, such as the next year, without changing the underlying straight-line rent calculation.

Step 4 - Review Each Lease Section

After the report loads, review each lease section and the visible fields:

  • Lease

  • Property

  • Details

  • Base Rent

  • Date

  • Invoice Amount

  • STL Rent Amount

  • Adjustment Amount

Step 5 - Review the Monthly Detail Table

Use the monthly detail table to compare:

  • Invoice Amount: the scheduled base rent amount for that month

  • STL Rent Amount: the fixed monthly straight-line rent amount

  • Adjustment Amount: the difference between actual scheduled rent and straight-line rent

Expected Display

  • Each lease appears in its own grouped section

  • Detail rows show monthly scheduled base rent activity

  • The visible months are controlled by Display Start Date and Display Years

  • STL Rent Amount remains fixed across the same lease, unit, and base rent charge schedule

  • Adjustment Amount shows the monthly difference between actual scheduled rent and straight-line rent

3. Technical Explanation

Eligibility and Filter Behavior

The query first selects eligible leases and units from the selected properties. A lease is included only when:

  • the property is selected by the user

  • the lease matches the selected lease status

  • the property has calculate_straight_line_rent enabled

  • the lease has a start date

  • the lease or recurring charge has a valid end date for the calculation

Base Rent Selection

The query identifies recurring charges that count as base rent.

This is controlled by property_charge_controls where base_rent = true, so the report only uses recurring charges configured as base rent for the property.

Monthly Schedule Calculation

For each eligible recurring charge, the query builds a monthly schedule from the beginning of the charge or lease schedule through the ending date.

It reads all effective-dated recurring charge amounts, applies frequency normalization to monthly values, and produces one row per month.

Straight-Line Rent Calculation

The straight-line rent amount is calculated as:

Straight-Line Rent Amount = Total Scheduled Base Rent / Number of Monthly Periods

The adjustment amount is calculated as:

Adjustment Amount = Invoice Amount - Straight-Line Rent Amount

This means:

  • months where actual rent is below the straight-line average show a negative adjustment

  • months where actual rent is above the straight-line average show a positive adjustment

  • STL Rent Amount stays fixed for all months in the same lease, unit, and base rent charge schedule

Example

For a 3-year lease with annual increases:

Year 1: 12 months x 1,000.00 = 12,000.00

Year 2: 12 months x 1,050.00 = 12,600.00

Year 3: 12 months x 1,102.50 = 13,230.00

Total scheduled rent = 37,830.00

Total monthly periods = 36

Straight-line rent amount = 37,830.00 / 36 = 1,050.83

The report would show 1,050.83 as the straight-line rent amount for each month. The monthly adjustment would be the difference between each month's actual invoice amount and 1,050.83.

Display Period versus Calculation Period

The report separates the calculation period from the display period.

The calculation period always uses the full eligible lease or base rent charge schedule. The SQL calculates:

  • total invoice amount across the full schedule

  • total number of monthly periods across the full schedule

  • straight-line rent amount across the full schedule

Only after that calculation is complete does the query apply the display controls:

  • Display Start Date controls the first visible month

  • Display Years controls how many years are shown from that visible start month

Because these parameters are applied only to the display window, changing Display Start Date or Display Years can hide earlier or later rows, but it does not recalculate the straight-line rent amount using only the visible months.

For example:

  • If Display Start Date is blank, the report uses the lease start date or base rent charge schedule start as the beginning of the visible month display.

  • If Display Years is blank, the report shows months through the lease end date or recurring charge end date.

  • If Display Years is entered, the report limits the visible months based on that number of years from the visible start date.

Current Layout Note

The report layout contains the visible end-user parameters:

  • Entity ID

  • Property Name

  • Lease Status

  • Display Start Date

  • Display Years

The current layout shows the intended table labels for base rent, date, invoice amount, straight-line rent amount, and adjustment amount.

4. Troubleshooting

No Data Returned

Possible causes:

  • No selected property has straight-line rent calculation enabled

  • The selected lease statuses do not match the leases expected in the report

  • Leases are missing a start date

  • Leases or recurring charges do not have a valid end date for the calculation

  • Base rent items are not configured in property charge controls

Possible fixes:

  • Confirm that at least one selected property has straight-line rent calculation enabled

  • Broaden the Lease Status selection

  • Confirm that the lease has a start date and either a lease end date or recurring charge termination date

  • Confirm that base rent items are configured in property charge controls

A Lease Is Missing

Possible causes:

  • The lease does not belong to the selected property

  • The lease status is not included in the Lease Status filter

  • The lease does not have eligible recurring charges tied to the lease unit

  • The property does not have calculate_straight_line_rent enabled

Possible fixes:

  • Verify that the lease belongs to the selected property

  • Confirm that the lease status is included in the selected values

  • Check whether the lease has eligible recurring charges tied to the lease unit

  • Confirm that straight-line rent calculation is enabled for the property

Monthly Amount Seems Unexpected

Possible causes:

  • Recurring charge effective dates affect the monthly schedule

  • Non-monthly frequencies are converted to monthly values

  • The recurring charge may have a termination date earlier than the lease end date

Possible fixes:

  • Review the recurring charge effective dates

  • Confirm the recurring charge frequency

  • Check whether the recurring charge has a termination date before the lease end date

Adjustment Amount Seems Unexpected

Possible causes:

  • The straight-line rent amount is calculated across the full eligible schedule, not only the visible rows

  • The total invoice amount or number of periods may differ from what the user expects

Possible fixes:

  • Compare the total invoice amount and number of monthly periods used for the lease, unit, and base rent charge

  • Review the full schedule before interpreting an individual monthly adjustment

Expected Months Are Not Displayed

Possible causes:

  • Display Start Date is filtering out earlier months

  • Display Years is limiting how many years are shown

  • The visible display period ends before the natural lease or recurring charge end date

  • A value greater than 10 entered for Display Years is capped at ten years

Possible fixes:

  • Clear Display Start Date to start from the lease start date or base rent charge schedule start

  • Clear Display Years to show months through the natural lease or recurring charge end date

  • Increase Display Years if you need to show a longer visible period, up to the report limit

5. Customization

Possible enhancements for this report include:

Filter Enhancements

  • Adding a Lease Name filter

  • Adjusting display controls for start date and number of years shown

Calculation and Summary Enhancements

  • Showing total invoice amount and total straight-line rent by lease

  • Adding schedule start and schedule end dates to the output

  • Adding a summary page with total adjustment by property or entity

Field and Layout Enhancements

  • Adding unit, tenant, square footage, or city columns to the visible layout

  • Exporting one row per lease and month for accounting reconciliation

  • Refining export formatting for accounting review

These modifications can be requested as a report customization through the customer portal.