The Lease Net Income by Month or by Year reports summarize the entire costs for the month or for the year by calculating income minus expense for all associated recurring costs for each lease included in the report. The Lease Net Income by Month report shows monthly data for one year; the Lease Net Income by Year report shows yearly data for the selected years.
The report has a Filter console that you can use to restrict the leases included in the report by geographical location, cost category, cost class, and year. You can enter multiple cost categories and classes to view multiple categories and classes at one time. By default, the report shows all recurring costs for all leases. If a recurring cost has been scheduled, it is not included in the report summary.
This topic includes the following information:
The Lease Net Income by Month or Year reports are view analysis views that enable you to drill down to see the cost records included in the summary. When viewing recurring cost details, you can export the detail data to Excel by clicking the XLS button. The detail report shows the time frame for the costs shown.
To analyze the cost data, you can drill down from the Lease Net Income (Recurring Costs - Not Scheduled) - Total Costs section to view recurring cost details for:
Note: The Lease Net Income Report uses the Yearly Factor and Seasonal Cost adjustments (when relevant for the selected dates) when calculating net income. However, when you drill down, the details report shows the recurring cost record as it is entered. The Amount - Expense and Amount- Income do not show the expense or income adjusted for the yearly factor and seasonal costs, although this adjustment is made for the calculation in the summary report.
Note: If your organization is using the Cost Administration application to record recurring costs and to schedule them to create specific cost instances, be aware that the Lease Administration reports summarize only recurring costs that have not yet been scheduled. If you drill down for a cost record that appears in the summary as 0.00 , and see that this record shows an amount other than 0.00, this means that the recurring cost record for that time frame has been scheduled and is therefore not included in the summary.
To generate the Lease Net Income by Month or by Year report:
The Lease Net Income section shows the net costs for the selected costs and leases in the geographic locations you selected.
You can export the summarized data to Excel by clicking XLS.
The following image shows the Lease Net Income by Month report indicating the cells you can click on to drill down to see the cost records included in the summary.
When the ARCHIBUS Enhanced Global Feature Set are enabled, you can generate the Lease Net Income report to show Total Costs, Base Costs, or VAT Costs using the currency you select. Just as when the ARCHIBUS Enhanced Global Feature Setare not enabled, the Lease Net Income report calculates the net income (income - expenses) value for each cost category's cost type. However, when the VAT and multicurrency fields are enabled, the report shows this net amount as Total Costs, Base Costs, or VAT Costs depending on the selections you make to generate the report. See Selecting VAT Cost Types and Currency for Reports for a description of the cost fields used to show VAT costs in different currencies.
When you drill down to see the records included in the net income summary, the cost records show Total Costs, Base Costs, and VAT Costs using the currency type you select to generate the report. For example, if you generate the report to show Total Costs in the Budget Currency, the drill down shows the Total Cost, VAT Cost, and Base Cost for each cost record included in the summary using the Budget Currency. If you generate the report to show Base Costs in the User Default Currency, the drill down still shows the Total Cost, VAT Cost, and Base Cost using the Payment Currency.
See Also
Lease Administration Reports Overview
| Copyright © 1984-2014, ARCHIBUS, Inc. All rights reserved. |