Expense Table

Click this radio button to print all the Expense Tables set up for the selected property. This is the default.

Expense Accounts

Click this radio button and new fields display. The report will print the selected Expense Accounts for the selected Expense Table:

• At Expense Table, select an expense table from the drop-down list.
• At Expense Accounts, select expense account(s) from the Expense Accounts pop-up and then click Save.

  Expense Accounts Pop-up Window

  Select check box(es) as appropriate:

  * Check Select  to select all expense Accounts.

  * Or, select check box(es) for individual expense accounts.

Expense Detail

Click this radio button and new fields display. The report detail will print for the selected Expense Accounts for the selected Expense Table using the from and through dates specified:

• At Expense Table, select an expense table from the drop-down list.
• At Expense Accounts, select expense account(s) from the Expense Accounts pop-up and then click Save.

  Expense Accounts Pop-up Window

  Select check box(es) as appropriate:

  * Check Select  to select all expense Accounts.

  * Or, select check box(es) for individual expense accounts.

• At From Date (MMYYYY), select a from date for the report.
• At Thru Date (MMYYYY) select a through date for the report.

Note

This topic provides report details for commercial properties only; that is, properties with the property type set to 6-Standard Commercial.

Expense Table Listing (Expense Tables)

Code

Code used to identify the expense table.

Description

A brief description of the expense table.

Day Basis

Proration type used for calculating the prorated expenses for this table.

Options: Actual or 360

Recovery (Income Code)

The default income code defined for Recovery billings for tenants linked to the expense table.

Free (Income Code)

The default income code defined for Free billings for tenants linked to the expense table.

Adj (Income Code)

The default income code defined for recovery adjustment transactions for tenants linked to the expense table.

Recovery (Management Fee)

The default income code defined for recovering management fees for tenants linked to the expense table.

Free (Management Fee)

The default income code defined for free management fees (concessions) for tenants linked to the expense table.

Adjustment (Income Code)

The default income code defined for management fee recovery transactions for tenants linked to the expense table.

Mgmt Fee %

Percent of management fee to charge tenants on recoveries.

O/H (Overhead)

The default income code defined for recovery overhead for tenants linked to the expense table.

Free O/H (Overhead)

The default income code defined for free (concessions) overhead for tenants linked to the expense table.

Adj (Overhead)

The default income code defined for overhead adjustment transactions for tenants linked to the expense table.

Show Vacant Suites

Lists whether or not vacant suites should be shown on the calculation detail report.

Expense Accounts Listing (Expense Accounts)

Expense Table

Code used to identify the expense table.

Line

Line number of this expense account within the expense account table.

Type

The account type defined as H–Header, D–Detail or T–Totaling account.

Description

Full description of the expense account.

Print Code

When this account will print.

Options: A–Always, S–Sometimes, or N–Never.

G/L Account Begin/End

The beginning and ending G/L accounts for the range of accounts to use when transferring recovery expense or budget amounts from the General Ledger.  

Spaces Before/After

Number of blank lines to print before and after printing this expense account line on statements.

Underline Before/After

Underline character to print before and after printing this expense account line on statements.

Grossup

Identifies if this expense account line should be grossed up based on occupancy.

Pass-thru %

Percentage of the expense to be passed through to tenants.

Calculators

Calculator used to total the amounts printed on recovery statements.

Excluded Accounts

Each Expense Table includes an account range. During expense table setup, you have the option to exclude certain accounts from the table. This section of the report shows you which GL accounts have been excluded.

Expense Details Listing (Expense Details)

Expense Table

Code used to identify the expense table. For instance, CAM.

Description

A brief description of the expense table. For instance, CAM Rebilling.

Line

Line number of this expense account within the expense account table.

Description

Full description of the expense account.

Month

The period of the actual, budget or forecast amounts.

Actual

The actual expense amount for this account line and period.

Budget

The budgeted expense amount for this account line and period.

Forecast

The forecasted amount for this account line and period.

Import Date

The date this amount was imported from the General Ledger.

1. From the eSite menu, select Reports—Setup Reports—Expense Table List.
2. Select the information you want to see on the report (refer to the Selection Criteria for this report).
3. Select a Report Format option: Acrobat Reader (default), Crystal Viewer, Excel.
4. Click Display. If you selected the printing option, Excel, you are prompted to open or save the report Excel file. Otherwise, the report opens in your preferred format.

User security permissions must be granted in the System module to access this menu item.

System—Security—Users—eSite—Reports—Setup Reports—Expense Tables

 

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