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.
Note
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 Accounts Setup Tab
Required Setup for Rebilling Recoveries
Copyright © 2018 Infor. All rights reserved. www.infor.com.