Expense Table Tab

Use this tab to add or edit expense tables. This tab appears when you click Add Expense Table or click a code from the Expense Tables Setup grid.

ClosedFields

NoteNote

An asterisk (*) indicates a required field.

Code *

Type the identification code for the expense table, up to 10 alphanumeric characters (for example, CAM for Common Area Maintenance).

Description *

Type a description of the expense table code, up to 40 alphanumeric characters (for example, CAM for Common Area Maintenance).

Recovery Billing *

From the drop-down list, select the income code to use for billing recoveries to tenants assigned to the expense table. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Free Billing

Select the income code to use for billing concessions to tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Recovery Adj *

The income code used to subtract the amount already billed or paid to the tenant during the Recovery period.  Select the income code to use for recovery adjustment transactions for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Recovery Mgmt Fee

Select the income code to use for recovering management fees for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Free Mgmt Fee

Select the income code to use for the free management fee (concessions) for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Mgmt Fee Adj

Select the income code to use for adjusting management fee recoveries for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established on the Income Codes Tab at Setup—Property—Income Codes.

Overhead

This field is affected by the property policy, Recovery Overhead Fee. If left blank, this field does not display. Overhead is an additional fee that can be charged to a tenant during the Recovery process. It appears as a separate line item on the invoice.

Select the income code to use for recovering overhead expenses from tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Free Overhead

This field is affected by the property policy, Recovery Overhead Fee. If left blank, this field does not display.

Select the income code to use for calculating free overhead for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Overhead Adj

Select the income code to use for entering overhead adjustment transactions for tenants assigned to the expense table from the drop-down list. This selection sets the default for recovery escalations and validates the input against the Income Codes file. Income codes are established in Income Codes setup.

Mgmt Fee Percentage

The display of this field is triggered by the selection of an income code in at least one of these fields: Mgmt Fee, Free Mgmt Fee, or Mgmt Fee Adj. If at least one income code was not selected, this field does not display.

Select percentage of the management fee to bill back tenants during the recovery process from the drop-down list. Your selection becomes the default setting used in recoveries.

Day Basis

This field defaults to Actual or 360 Days. Accept the default indicating this is the prorate type to use when calculating prorated expenses for the expense table. Or, select a different prorate type from the drop-down list.

Show Vacant Suite

Select this check box if you want vacant suites included on the Expense Tables Setup report. Or, leave this check box cleared if you do not want vacant suites to be included on the report.

Calculated Amount For

The display-only field that shows the date the table was last used to calculate actual recovery billings.

Budget Import

The display-only field that shows the date expense table budgets were last imported from the general ledger.

Updated Amount For

The display-only field that represents the date the table was last used in an expense rebilling calculation; which updates tenant charges. This date is populated when the Actual Recovery Worksheet or Estimated Recovery is processed.

Forecast Import

The display-only date showing when forecasts associated with the expense table were last imported from the general ledger.

Actual Import

The display-only date showing when actual expenses associated with the expense table were last imported from the general ledger.

See Also

Expense Tables Overview

Expense Tables Setup Grid

Expense Tables Accounts Setup Tab

Expense Account Tab

Expense Details Setup Tab

Rebilling Recoveries Overview

Required Setup for Rebilling Recoveries

Commercial Setup

 

Copyright © 2018 Infor. All rights reserved. www.infor.com.