Reports (Client Financial)

Users can build, copy and preview custom financial reports at the Client Admin level. Although many default (canned) leasing reports are available upon implementation, all financial reports are custom built at the Client Admin level.

Note: Newly created Reports (financial) need to be assigned to Client Admin Roles & Permissions in order to be viewed by common Users. Although they are inherently assigned to the creator (e.g. a Client Administrator with the assigned budget Role, Project Administrator), they need to be assigned to other Roles within the organization in order to be viewed.

Pane 1

In Pane 1, create a new report by adding a row and designating the report name, the template (or columnar structure) and key run-time parameters. In Panes 2 and 3, build the row and account structure of the report. 

Report - Title

Template - Drop-down list of available financial templates; defines the columnar structure of the Report.

Chart - Chart of Accounts - select the Chart of Accounts to be used for the report

Quick Pick - Yes or No to adding the report to Quick Pick Reports list

Default Version - For Quick Pick reports and what initially loads in the Reports section parameters grid: Account, Subaccount, Budget Detail, Report Design, Budget Detail - Short

Info: Quick Pick Reports, located in the sliding pane at the Building level, allows Users to easily access and generate leasing and financial Reports that are building-centric and use default report parameters.

• Default (canned) leasing reports are available upon implementation and are all 'Quick Pick' available by default
• When building custom financial Reports at the Client level, the Quick Pick (Yes/No) and Quick Pick Version (Account, Subaccount, Budget Detail, or Report Design) need to be assigned

Pane 2

In Pane 2, design the report rows by adding new rows and using the columns to define the look and feel of the report rows. In Pane 3, identify which accounts, account ranges, or formulations to assign to each row.  When Pane 2 is complete,  click Save on the pane 2 toolbar.

Tip: Pane 2 report design rows can be reordered by holding down the left-click button on the mouse and dragging the row to the desired location within the report design.

Row Description - section title

Row Type options:

• Header Only - Report section name/title
• Group Total w/Details - Displays all accounts with balances
• Group Total - Displays the sum total of the account range; does not display account by account detail
• Ratio - Report Design - Numerator & Denominator in pane 3. Currently only applicable to N-Year reports using either the Comparison (Annual) or Multi-Way Comparison financial report templates

Font - Bold, Normal, Italics (N-Year Only), Bold Italics (N-Year Only)

Border - None, Single Line, Double Line

Line Spacing - None, Space After

Zero Suppress - For N-Year Reports Only. Hides sections of report that do not contain balances or net to $0; Yes or No

Comparison - This options applies to Comparison template reports only and allows you to define which rows should have their sign flipped to signify favorable or unfavorable variance amounts. For example, when comparing 2021 reforecast expenses to 2021 budgeted expenses, the comparison math is 2021 Ref - 2021 Bud. The resulting math may be a positive number, but for an expense variance, this is often viewed as an unfavorable variance. Many companies prefer to show that unfavorable variance as a negative. In that case, the Comparison column should be set to "Flipped" indicating that the resulting expense variance sign should be flipped. Each row can be treated independently.

Pane 3

Next, individually selecting pane 2 rows opens pane 3 for adding report design detail pertaining to Accounts, Formulations, and/or Report Design (pane 2 structure of report) when creating a new report, in addition to adding, editing, or deleting detail from a Report.

Detail Wizard button opens the "Details Wizard" window:

Detail Type

• Account - Available Details populates with all accounts (Active & Inactive) from the selected Chart of Accounts
• Formulation - Available Details populates with Active Formulations of Type = All and Reporting (best practice)
• Report Design

Percent (%) - Defaults to 100%

Available Details - Assigned Details - Available Accounts, Formulations, and/or Report Designs (pane 2 report structure)

Add button

For all pane 2 rows with a Row Type of Group Total and Group Total w/Details, assign the appropriate account ranges, Formulations, and/or report designs.

Percent (%) - Percentage value to include in the report

Type

• Account - Selection populates with all accounts (Active & Inactive) from the selected Chart
• Formulation - Selection populates with Active Client level Formulations
• Report Design - Selection populates with row structure of the report

Selection - Account From: & To:, and SubAccount From: & To: (if applicable)

Tip: The pane 1 toolbar contains a copy feature used to assist Users in creating a new financial Report that may contain a few differences.

Delete

Alert: Deleting a Report in pane 1 entirely deletes the Report including all pane 2 report design, as well as pane 3 report design detail.

• Deleting pane 2 report design also deletes its pane 3 report design detail
• Deleting pane 3 report design detail pertaining to accounts, Formulations, and/or report designs can be individually deleted
• In any case, a pop-up warning will appear asking to confirm and to prevent accidental deletion