Transcription:

Welcome to Training with VLU. This course is designed to provide you with an overview of some of our key non-accounting standard reports.

By the end of this course, users should be able to:

• Navigate the Standard Lease Reporting module.
• Identify the various means of including or excluding leases from a general report
• Differentiate between the list of available reports to find data.
• And, leverage report options for each report to review lease data in a meaningful way

Please take a moment to review the course agenda. If you are looking for a specific topic, feel free to jump to the corresponding timestamp.

In this video you will learn how to access and set up your standard lease report criteria in the VLU platform.

A quick note before we begin – if any of the reports covered in this course are missing from your platform, it may be a result of which reports are enabled within User Settings or your user group access. You can adjust your user settings at any time by clicking the Profile icon in the top right of Visual Lease and navigating to the Lease tab.  Your user group access can be updated by your platform administrator should you need access to a specific report.

To access the reporting module, click the Reporting tab, and then click Standard Lease Reports.

When you land on the reports page, you’ll see its split into several sections that correspond with the steps you’ll need to take to generate reports.

You will need to determine which leases you want to report on.

To do this, use the Lease Selection options in the left sidebar to choose which leases to include in your reports.

You can use a fixed list of leases, which can be accomplished by entering text in the Select Lease field that matches specific lease IDs, towns, addresses, etcetera.

Or you can search for leases based on shared data points, by changing the Lease Selection option to Based on Criteria.  From there, you can use the different options to filter through your lease portfolio.

For example, you can search by commencement dates, geographic locations, or shared contact.

With either Lease selection, you also have the ability to load previously saved filtered lists, here.

The default filter is always Active or Pending Leases – I’ll leave this as my filter for this demonstration.

Once your selections are made in the left side bar you can click the “Show Leases”, here, to see a list of all the leases associated with the filters that you’ve selected.

Next, you’ll choose which details you want to see by selecting a report from the list in the middle of the page.

Note in the Report Options section, the information you can input will change based on the selected report.

 

In this video, we will take a more in-depth look at some of the more common reports used by organizations that are offered in the VL Platform.

Please note: The list of available reports may be different on your screen based on your permissions level. If you do not see a report you would like to run on the list, the first thing you can do is check your User Settings> Lease Reports Tab. If this does not work, please contact your platform administrator for appropriate access.

The Abstract report provides you with a detailed summary of the information captured throughout the selected lease records into a single report.  You can determine which details are included or excluded from the report based on your preferences.

The Abstract Report can be downloaded for a single lease directly from the lease record, or you can use this report to generate Abstracts for multiple leases at one time.

First, let me show you an Abstract Report for a single lease.  I’ll navigate to a lease record using my Recently Opened window on the right and select this lease.

From here, I’ll click here in the lease sidebar on the left, then click Abstract Report- to generate the abstract into a PDF file.

As I scroll through the different sections, you can see how this report conveniently summarizes the lease’s information, including General Information, like the Owner Type and Status, commencement and expiration dates, and other details pulled from the General Tab.

Beneath that, there are additional details provided, such as key lease contacts, financial information and even clauses.

While it is considered a summary of a record, it’s still a thorough and comprehensive report that can provide several pages worth of detail related to this single lease.

Now, let’s jump back into the main reporting page.

If I were to download this report for all of the leases included in this filter, I’d have a multiple page report for each lease.

For that reason, it may be beneficial to download the Abstract report directly from the lease or generate the report for smaller subsets of your lease portfolio at a time.

If you are going to generate the report from this page, I’d like to point out the checkbox that displays in the Report Options section under the report list.  This checkbox is telling the platform to use the default options to populate the report.  The default options are defined in your User Settings – let me show you where those are set.

Once the User Settings are open, we will navigate to the Lease Reports tab. Here, you can check or uncheck which lease details you’d like to be included in your Abstract report each time it’s generated.  For example, you may not be concerned with Allocations, so you can uncheck the box here.  This allows you to easily control which details are pulled onto the report, so you do not have to make these selections each time.

Back on the reporting page, if I leave the checkbox checked, it will generate the Abstract report based on the default selections.  However, if for some reason I wish to override them, I can uncheck the box.  I can then make adjustments to the included sections prior to generating the report.  Keep in mind that your selections here do not affect the default Abstract Report options defined in your User Settings – these will only apply to the report you are about to generate.

The Alerts report allows you to view all of the alerts set up for the selected leases.

In the Report Options section, you can choose to report on your alerts in a variety of ways:

If you choose to leave the Report Options blank, and click Generate Report at the top of the screen, the platform will then pull all alerts that exist on your leases

If you’d prefer to narrow down the results, you have the flexibility to do this in multiple ways:

You can use theses field to search for alerts that have critical dates between two specific dates

In another course, we explain that alerts can be scheduled based on specific critical dates. So one way to narrow down the alerts is to specify the range in which the critical dates fall.

You then have the ability to filter the report even further by selecting which alert types you would like included.

Let’s take a moment to review what each of these dates capture:

Clause Critical Dates are captured within clauses. They include fields such as Alert Date, Action Date, Date Detail and Option Exercise windows.

Lease Critical Dates are the dates contained on the General tab within the Dates section – these include your commencement and expiration dates, as well as other key dates you may be capturing.

Financial Critical Dates are dates related to financial entry changes, such the Effective Date, Applied Date, Arrears Date or Increase Date.

Custom alerts are alerts that are not based on Critical Dates in the platform but instead are based on timing and contents specified by the user.

Lastly, you have the ability to select whether you would like the report to output additional lease fields such as Property Type and Manager. If these fields are relabeled in your account, you may see different labels here. These fields live on the General tab of the record.

Now I will generate the report with no additional filters selected

This report shows alerts already within your account along with the alert date for each, corresponding comments, and recipients. Additionally, the report always downloads with two tabs. The first tab shows future alerts and second tab outlines sent alerts to assist with tracking.

If you’re using the Allocations module, this report will allow you to easily view Allocation information, including the rentable area, organization, space utilization, and other ways space may be allocated within the lease.

You can also select whether you would like additional fields from the lease to output in the report.

As with all of our standard reports, the first column always starts with lease ID. The remainder of the columns output details that were entered within the Allocations module such as organization breakdown, allocation type (for instance space, percentage, or fixed), and amount.

Moving onto the Change Log Report. This is an especially critical report from an audit perspective, as it enables you to easily view field changes to various components of one or more lease records.  It also provides visibility into changes made within the Administrator module. It tracks which user made what change (such as whether the user Inserted, Updated, or Deleted data), when the change occurred, and a description of the old and new values.

Taking a look at the Report Options,  you’ll first define a date range.

Next, you will apply which system areas you would like to see.

To view changes made within leases, you can view changes to calculations, accounting lease information, financial entries, or fields on the general tab.

If instead you want to view administrative changes, you can select discount rate, financial categories, users or system settings from the drop-down list.

You can choose to run the report on one specific system area or select multiple.

Even though most of the System Areas do not pertain to individual lease records, the report still requires a set of leases as search criteria. To yield results, simply set the Lease Selection sidebar to ‘Based on Criteria.’  This loads the default lease filter, which contains leases with a Status of Active or Pending.

Lastly, within the Report Options section, you have the ability to select whether you would like the report to include deleted or archived leases that fell within the date range you specified.

Next, we see the Contacts report. This report allows you to view all contact information related to the contacts stored on your leases.

If you would like the report to pull in all contacts without filtering down further, you can simply click Generate Report without updating the Report Options.

Instead, if you’d prefer to filter the contacts further,  you can use the report options to view only contacts with a certain name or company, title, city, country, party type or contact role.

You can also choose to include or ignore contact associations and/or lease parties (such as landlord, tenant, payor or payee) by checking or unchecking the boxes at the bottom.

Lastly, as we’ve seen before, users have the ability to output additional lease fields to the report such as Property Type and Manager.

As you can see here, the report is organized first by Lease ID. Then, as we scroll over to the right, you see the contact information, such as address, phone number and email address.

I will now move onto the Critical Dates report. This report will allow you to view all critical dates information associated with your leases.

As a reminder, critical dates are important dates stored within your leases, such as expiration dates or option exercise windows.

This report will help you keep track of these dates related to obligations that if missed, may result in large financial penalties.

You can use the Report Options below to filter the results to view only certain critical dates such as: Action and Alert Dates, Effective and Expiration Dates, Financial Entry Increase dates, Clause dates, Option Exercise dates, and Rentable Area Change dates.

You also have the ability to only include critical dates that fall within a specified date range

As you can see here, the report is organized first by Lease ID. Then, as we scroll over to the right, you see the critical date information, such as the type, the date being captured, a description, and additional details or comments

Moving over to the Documents report, this option allows you to view the Document type, title and attached file name for all documents associated with leases.

Report Options include the ability to filter by the document creation date as well as additional lease fields to output lease property type and manager information in the report.

As a reminder, this report does not provide links to actual documents. Only information about each document

In the report, you will see the document date, the type of document, the title, any additional comments, and which user uploaded the document

The Facilities report enables you to view important information that a facilities manager may find beneficial, such as location details, rentable area, space utilization and critical date information regarding the selected leases.

Again, you can choose to include Type and Manager in the report in report options.

The first column in the report contains the lease ID.

As you scroll to the right you will see additional lease information such as address, rentable area, financial information, organizational details, and space utilization.

The financial analysis report allows you to easily analyze financials over a designated period of time.

The financials can be grouped in a variety of ways. You can use the report grouping area to choose how you want the information presented within the report.

The report can automatically sum up various categories.

Here, you can generate a financial report of expenses organized and grouped by various financial fields and organizations one by one or many at a time.

Your Report Options allow you to further filter by the Report Date Range, grouping frequency, and you also have the ability to include allocations as well

At the top of the generated report, you’ll see a section that summarizes the selections made within report options. This helps you easily identify the information displayed within the report. As you can see, it groups the information based on the selections that were made.

The financial variance report allows you to compare current period financials against prior periods

Report options enable you to compare periods based on:

Current and Previous month; current and previous fiscal year; and a current custom range vs a previous custom range

You can select Show Lease Data to show basic information about each selected lease in the lease data worksheet

The Show Financials Details checkbox will show details of each financial entry in both the current and previous periods and its variance, each in its own row.

If you would like the report to include ALL financial categories, you can leave this next checkbox selected. However, if you would like to drill down into a specific category or categories, you can deselect, and choose from the provided tree.

Lastly, you can choose to include only Accounting feed entries, only leases where there is a variance, and/or entries where there is a payee change

As you can see, each period comparison is included in its own section, with each column containing different information about your financials.

For example, you have your frequency, financial type, the current and prior periods, as well as the variance amount and percentage.

Moving on to the Financials standard report. This report allows users to view the lease’s financial entries, increases and transactions for a specified date range.

Under Report Options, you can view Entries, increases and/or transactions each on their own tab.

Lastly, users will have the option to select the date range they would like to pull into the report

Depending on the selections made with report options, your generated report may contain multiple tabs.

The first tab is going to contain entries. Which summarizes the financial entries to each lease.

The first column contains the Lease ID. Followed by subsequent financial information. So, for example, you will see the expense category, the frequency and type, the schedule, the amount, as well as additional information.

This report also provides visibility into which user created each financial entry as well as the date they were entered.

The increases tab will summarize financial entry planned increases. So again, it begins with the Lease ID and the Expense category, then provides visibility into planned increases. Such as the increase date, type, and frequency.

The transactions tab will summarize any transactions related to the various financial entries within each lease.

The report, again, begins with the lease ID, an expense category, then provides the transaction date and type, scheduled amount, payee name, and any additional comments.

This tab also creates visibility into the user that created the transaction and the date it was created.

The Standard Invoice report allows you to build generic invoices for any outstanding receivables for the selected leases.

The report options allow you to specify verbiage and settings to allow personalization of your company’s invoices. Specify the financial date range to pull receivables or payables from your leases.

You also have the ability to indicate an invoice threshold amount to exclude entries that are lower than a specific amount.

The platform will not automatically generate an invoice number; therefore you should indicate the invoice start number so it can generate from there

The Standard Notes Report allows you to collect a specified number of notes from each lease.

Report Options include the ability to output additional lease fields such as property type, manager, and rent per unit area information in addition to notes in the report.

Users also have the ability to pull in only specific note categories to filter their results even further.

It is important to keep in mind that the categories displayed only reflect the note categories that have been assigned to notes in your platform.  You may have additional Note Types that have been configured, but if there are no notes with that type, you will not have the option to check that box on the report.

The generated report displays the date, the user that created the note, the category, subject and note detail.

It also provides additional information including the lease ID, organization details, and address information.

Next, the options report is a critical report, that provides an efficient method to gather and view various options information.

With Report Options, you can filter the results based on the Lease Expiration or Critical Date range, which in this case would be your exercise window dates.

You can also narrow down the results based on the Option Type or Status – so if you only wanted to see Available Renewal options, simply select renewal under option type, and available under option status.

The Last option on this report is the Likely to Be Exercised checkbox– if you only want to see options you’re reasonably certain you’re going to act on, make sure that box is checked.

The generated report begins with the lease ID and expiration.

It also contains additional lease details that are relevant to each record. As you scroll further to the right on the report, you’ll see additional columns that pertain to the option information. Including the option name, type, whether that option is likely to be exercised, the exercise window start and end dates, and the status.

The Payees Report allows you to view payee information for the selected leases.

Use Report Options to filter results for payees with a specific name, location, ID number, status, or type.

As with other reports, you can also choose to output additional lease fields, such as property type and manager.

The first few columns on the generated report contain information relevant to the lease. As you scroll further to the right you will see additional information related to the payee such as the payee name and type, vendor number and additional details such as the address.

The Payments report allows users to view payment information for a specific date range for their selected leases. This report pulls data specifically from the Payments module under the Financials tab on lease records.

Report Options under the report include the ability to view additional lease data, allocations, and an aging report.

In the Financial Settings, specify the payments running balance start date to adjust the balance calculations across all leases. Lastly, you can specify the date range and financial type to further filter the results.

On the generated report, you can easily identify each Lease ID, the payment record type and category, the payment from or to, the date, the amount, and any running balance due.

The Payments Activity Report allows you to view a PDF report summarizing the payment activity, per lease, over a specific date range.

The report can also output a designated running balance start date, and financial type.

The Report options include the ability to group payments together by Payee or Expense Category and to view the data by date or outstanding amount.

The generated PDF allows to easily view the Type, Expense Category, Date, Amount, Running Balance Due, the age, and any related comments to the payment activity

 

That concludes our course on the Standard Reporting Module in Visual Lease.  We reviewed how to include groups of leases in your reports, what information each report provides and how to filter the output even further by leveraging the report options.

Thank you for attending this course – any questions, suggestions or feedback can be sent to support@visuallease.com

Transcription:

Welcome to Ad Hoc Reporting with VLU.  This course is designed to provide you with an overview of the Ad Hoc Reports module.

By the end of this course, users will be able to:

• Define the different fields that can be included in a custom report
• Leverage the Report and Excel Settings to further tailor the output.
• And generate and save unique reports based on business needs.

Please take a moment to review the course agenda. If you are looking for a specific topic, feel free to jump to the corresponding timestamp.

The Ad Hoc Reporting module is accessed via Reporting in the main menu bar.  Let’s briefly review the various options you’ll see in this menu.

New Ad Hoc Report is where you can create new custom reports.

Once you begin building and saving custom reports, you can easily access them in the Ad Hoc Report list.

If you create a report that you will view or generate frequently, you can set it as a Favorite Ad Hoc Report through User Settings.

 

The New Ad Hoc Reports page is split into two sections: here we have the name and report viewer, along with the options to Save, Generate and Email the report.

The sidebar menu enables you to control which leases are included in the report, what details are pulled into the report and the ability to adjust additional settings and preferences.

Let’s take a closer look at the menu.

This section allows you to filter the list of leases you would like to see in your report.

This will always default to Active and Pending leases.

To change this, click Edit. A dialogue box will appear allowing you to select a previously saved filter.

Once you have found your desired filter, click Apply.

The Report Fields section is where you can specify which data points you would like to capture in the report.

In other words, this is where you can select the columns you would like to see in your generated report.

You can include virtually all data points captured in the platform.

By default, any new ad hoc report contains the fields listed here.  To change these fields, click Edit.

The fields that are available for reporting are displayed here. The fields are grouped into categories based on where they are captured within a lease.  You can click to expand each section, then scroll through the list to browse the available fields.

The fields that you have chosen to include in the report are displayed here.

Let’s imagine that you would like to add the Commencement Date to the report.

Simply expand the Dates section and select the Commencement Date.

Click and drag it into the selected fields section until you see the yellow placeholder.

Then, drop the field into the box and reorder your fields as needed.

You will now see the Report Viewer has updated to include columns based on my selections.

Once you have selected your desired fields, and reordered the lists as needed, Click Apply.

You will now see the Report Viewer has updated to include columns based on your selections.

 

Let’s take a look at the Additional Table Fields section.

The Additional Table Fields are preselected bundles of data that can be output alongside of your selected fields.

You may notice these are similar to some of the options you see in Standard Lease Reports.  With our standard reports, there is little customization available, and each report generates as-is, meaning you cannot choose to output additional information along with the standard report detail.

However, you have the option to include these preselected data sets in the custom report you’re creating.  While the columns within the tables themselves cannot be manipulated, this option allows you to view the data alongside additional details that would not otherwise be visible.

Check the box next to the table field or fields you wish to include in your report then click Apply.

This will add the fields in a separate tab on the report viewer and will generate an additional tab once the report is exported to Excel.

 

Let’s review how to further customize your report by exploring the Report Settings section.

This area allows you to adjust additional settings and specifications for the report you are creating.

Let’s take a deeper look at the options you’ll find here.

The Key Word option allows you to define key words or tags that make this report searchable within the Ad Hoc Report List. For example, you can enter “Commencement Date” into this field; once I save the report, other users can search “Commencement Date” to easily locate this report.

Security allows you to set the preferred security level for the reports. All reports default to Public but select Private if this is a user-specific report.

This next section relates to Reporting Currency and Units – if the Reporting Currency check box is not selected, the report will use the specific currency of each lease.  If the Reporting Measurement or Land Units check box is not selected, the report will use the local unit for each lease.  Otherwise, select a currency and/or units to apply to all data in the report.

Report Date Range is helpful for running reports for financial or rentable area information. All reports default to the current month but you can choose to report on different time aggregates instead of, or in addition to, the current month.  Depending on the dropdown choice, you’ll also get a secondary dropdown to choose how you want the data displayed – based on total, yearly, or monthly amounts.

• The Financial Area Options is helpful in further refining your results when running reports on financial or rentable area information.
• The options you have are as following:
• The Financial Types allows you to select a financial type – meaning payables, receivables, or both. This controls the data that flows into any column pertaining to financial entry information.
• Here, select one or more frequencies to include values paid at those frequencies in the financial entry columns of your report. Your options are: One time, Monthly, Quarterly, Semi Annual, or Annual
• Include AP Feed Type is where you select whether to include financial values that are flagged to be sent to feeds, not sent to feeds, or both.
• When Include Rentable Area History is selected, this tells Visual Lease to show the Rentable Area value that was effective at the First Day of the Period or Last Day of the Period. This is specifically used to cover the situation where the View data for date is the month during which the rentable area was changed.
• The Accounting Standards displays only leases that have selected financial categories in the Report Fields that represent columns in an accounting schedule of the selected standard type.
• Invert Sublease values: Causes the Rentable Area and any Financial values to be treated as negative numbers, which allows you to view Net values for any Over lease-sublease properties.
• Last is the Include Rentable Area History: Select this check box to show the Rentable Area value that was effective since the month/year being viewed, in the Rentable Area column.

Once you have selected your preferred options, click Apply.

The Excel Settings section allows you to specify how you would like your report outputted to Excel.

Let’s review the options you have here:

The first few settings pertain to templates.  Rather than exporting the report to a blank Excel workbook, Visual Lease gives you the ability to upload a report to a pre-formatted template.

For example, if you have a report you’re required to submit on a regular cadence, creating and applying a template makes it so the data outputs directly into a sheet with titles, logos, charts, tables and more so it requires little-to-no manipulation each time its generated.

The Sheet Name is the name of the sheet the template will generate into.

The Start Row and Start Column allows you to specify the row or column you would like to see your data begin populating in.  For example, if you have titles or logos at the top of the template, you can make it, so the data does not begin outputting until row 3 or 4.

Output Report Headers allows you to see report headers on the Excel sheet that is generated.  If you have different report headers you’d like to use, simply uncheck this box.

By default, financial entries for the same category, frequency, and type display as an aggregate of the lease in a single row.  If instead you’d prefer to see a separate amount listed for each year, check Additional Fields Financial Entries on Separate Lines.

Vertical format allows you to see data fields and results vertically, rather than horizontally, for each record.

In the Table Data Output section, you can determine if you would like to see additional fields on separate sheets or combined into a single sheet.

To save any changes, click Apply.

 

Let’s review how to save and generate the report.

You can save the report at any time by clicking Save Report.

You will want to give the report an appropriate name – keep in mind that the name should be specific enough to allow yourself, or other users, to easily identify what the report is. Once you’re done, click Apply.

Once a Report is saved, you will be able to find it again via the Ad-Hoc Report List or through your Recently Opened sidebar.

To view the results of your Custom Report click Generate Report so it generates to Excel.

Once your report is saved, click Generate Report to run the report in Excel.

This will show all the columns, rows and any data calculations that are not easily visible on the Report Viewer.

Finally, if you would like to email this report to yourself, click Email Report

This will send an email with an attached Excel sheet to the email address associated with your user profile.

Now that the report has been saved, let’s review the Quick Links section.

The Save As option allows you to copy the current report as a new ad hoc report. You will have to rename the report, but this is helpful if you would like to create a mostly identical report with a few minor changes.

The Report History allows platform administrators to view when the report has been generated and by which users.

The Author section displays who created a report, when the report was created, who last modified a report, and when this took place.

To specify a report as your favorite, select User Settings and navigate to the General tab.

From here, select the report you would like to save as your favorite, then click Save Settings.

Once I expand the Reporting menu and select Favorite Ad Hoc Report it will bring me directly to this report.

This concludes our course on Ad Hoc reporting. This module allows you to build your own reports designed to capture information useful to you and your company.

You can easily tailor the output based on the different report and excel options available in the platform.

Easily access and save reports when you need them.

Thank you for attending this course. If you have questions, suggestions or feedback please send this to support@visuallease.com.