Exclude Options From Argus Tenant Rent Roll Report: A Step-By-Step Guide

how to exclude options from argus tenant rent roll report

When generating an Argus Tenant Rent Roll Report, it’s often necessary to exclude specific options or data points to ensure the report is tailored to your needs. Excluding options can help streamline the report, remove irrelevant information, or focus on specific criteria such as lease types, tenant categories, or property details. To achieve this, users can leverage Argus’s filtering and customization tools, which allow for precise control over the data included in the report. By understanding how to exclude options effectively, users can create more accurate and actionable rent roll reports that align with their analysis or reporting requirements.

shunrent

Filtering by Lease Status: Exclude terminated or expired leases from the tenant rent roll report

When generating a tenant rent roll report in Argus, it's often necessary to exclude terminated or expired leases to ensure the report reflects only active tenants. This can be achieved by applying specific filters based on lease status. To begin, navigate to the reporting module in Argus and select the tenant rent roll report option. Once you’ve accessed the report setup, look for the filtering or criteria section, where you can define which leases to include or exclude. The key here is to focus on the lease status field, which typically categorizes leases as active, terminated, expired, or pending.

In the filtering section, locate the lease status dropdown or checkbox options. Depending on the Argus version, you may find a list of statuses or a custom filter field. Select the option to exclude specific statuses. Here, you will uncheck or remove the "Terminated" and "Expired" lease statuses from the inclusion criteria. This ensures that only leases marked as "Active" or "Pending" (if desired) are included in the final report. Be meticulous in this step, as overlooking one of these statuses could result in inaccurate reporting.

If the Argus interface allows for advanced filtering, you can create a custom rule to exclude terminated or expired leases. For example, you might set a condition such as "Lease Status does not equal Terminated" and "Lease Status does not equal Expired." This approach provides greater control, especially if there are additional statuses you wish to exclude or include. Ensure that the logic is correctly applied to avoid inadvertently filtering out active leases.

After applying the filters, preview the report to verify that terminated and expired leases have been successfully excluded. Check the lease details for a few tenants to confirm the accuracy of the filtering. If discrepancies are found, revisit the filter settings and adjust the lease status criteria accordingly. Saving the filter settings as a template can streamline future reporting, ensuring consistency and saving time in subsequent report generations.

Finally, document the steps taken to exclude terminated or expired leases for future reference or to assist other team members. Clear documentation ensures that the process can be replicated accurately, maintaining the integrity of tenant rent roll reports. By effectively filtering by lease status, you can generate a clean, focused report that provides valuable insights into the current tenant landscape without the clutter of inactive leases.

shunrent

Date Range Exclusion: Remove tenants outside a specific move-in or lease date range

When generating a Tenant Rent Roll report in Argus, you may need to exclude tenants based on specific move-in or lease dates to focus on a particular period. Date Range Exclusion is a powerful feature that allows you to filter out tenants who fall outside your desired timeframe. To begin, open your Argus software and navigate to the Tenant Rent Roll report module. Once there, locate the "Filters" or "Report Options" section, which typically contains parameters for customizing the report. Look for the "Date Range" or "Lease Date" filter, as this will be the primary tool for excluding tenants outside your specified period.

In the Date Range filter, you will typically find options to set a start and end date for either move-in dates or lease dates. For example, if you want to include only tenants who moved in between January 1, 2022, and December 31, 2022, input these dates into the respective fields. Ensure you select the correct date type (move-in or lease) based on your reporting needs. Argus may also provide additional options, such as excluding tenants with leases expiring before or after a certain date, which can further refine your report. Double-check the filter settings to confirm they align with your exclusion criteria before proceeding.

After setting the date range, apply the filter and generate a preview of the report to verify that the exclusion has been applied correctly. If tenants outside the specified date range still appear, revisit the filter settings to ensure no overlapping or conflicting criteria are selected. Some versions of Argus may require you to use advanced filtering options or custom queries for more complex date-based exclusions. Refer to the software’s help documentation or user guide for specific instructions on accessing these features if needed.

For users working with large datasets, combining date range exclusion with other filters, such as property type or tenant status, can further streamline the report. However, when focusing solely on date range exclusion, ensure other filters do not inadvertently include tenants outside your desired period. If you encounter issues, consider resetting the filters and reapplying them step by step to identify any errors in the exclusion process.

Finally, once you’ve successfully excluded tenants outside the specific move-in or lease date range, save the report settings as a template for future use. This will save time when generating similar reports in the future. Remember that the exact steps may vary slightly depending on your Argus version, so always consult the software’s documentation or support resources for version-specific guidance on date range exclusion in Tenant Rent Roll reports.

shunrent

Unit Type Filtering: Exclude specific unit types (e.g., commercial, storage) from the report

When generating a tenant rent roll report in Argus, it's often necessary to exclude specific unit types, such as commercial or storage units, to focus on residential or other relevant categories. To achieve this, start by accessing the report generation interface in Argus. Navigate to the "Filters" or "Report Options" section, where you can customize the data included in the report. Look for the "Unit Type" filter, which allows you to select or deselect specific unit categories. By default, all unit types may be included, so you’ll need to manually deselect the ones you want to exclude, such as commercial or storage units.

Once you’ve located the "Unit Type" filter, carefully review the list of available unit types. Ensure that the options like "Commercial," "Storage," or any other irrelevant categories are unchecked. If the filter uses a dropdown menu, you may need to select "Residential" or another specific type and exclude the rest. Some versions of Argus may allow you to type in or search for specific unit types to exclude, making the process more efficient. Double-check your selections to confirm that only the desired unit types remain included in the report.

In cases where the unit type filter is not immediately visible, explore advanced filtering options or custom report settings. Argus often provides a "Custom Filters" tab or section where you can define more granular criteria. Here, you can create a rule to exclude units based on their type by selecting the "Unit Type" field and choosing the "Exclude" or "Not Equal To" operator. Input the specific unit types you want to omit, such as "Commercial" or "Storage," ensuring they are separated by appropriate delimiters if multiple exclusions are needed.

After applying the unit type filter, preview the report to verify that the excluded unit types are no longer present. If you notice any discrepancies, revisit the filter settings and adjust them accordingly. Saving your filter preferences can streamline future report generation, as Argus often allows you to save custom report templates. This ensures that each time you run the report, the same unit type exclusions are automatically applied, saving time and reducing errors.

Lastly, if you encounter difficulties or if the unit type filtering options seem limited, consult the Argus user manual or reach out to their support team for guidance. They can provide version-specific instructions or alternative methods to exclude unit types effectively. Mastering this filtering technique enhances the accuracy and relevance of your tenant rent roll reports, ensuring they align with your specific analytical needs.

shunrent

Balance Thresholds: Remove tenants with zero balances or balances below a set threshold

When generating a Tenant Rent Roll report in Argus, it's often necessary to exclude tenants with zero balances or balances below a specific threshold to focus on more relevant data. This can be achieved by applying balance thresholds within the report settings. To begin, navigate to the "Tenant Rent Roll" report in Argus and access the customization options. Look for the "Filters" or "Settings" section, where you can define criteria for excluding certain tenants based on their balance information.

In the filters section, locate the "Balance" or "Financial" criteria, which typically includes options for filtering tenants by their current balance. Here, you can set a threshold value to exclude tenants with balances below a certain amount. For instance, if you want to remove tenants with balances less than $100, input this value as the minimum threshold. This ensures that only tenants with balances meeting or exceeding the specified amount are included in the report, providing a more targeted view of the data.

Additionally, to exclude tenants with zero balances, check for an option that allows filtering by "Balance Greater Than Zero" or a similar criterion. Enabling this option will automatically remove any tenants with no outstanding balance from the report. Combining this with the minimum balance threshold ensures a comprehensive exclusion of irrelevant tenants, streamlining the report to highlight only those with significant financial activity.

For more advanced customization, explore whether Argus allows for the use of conditional logic or custom formulas in the filtering process. This could enable you to create complex balance-based exclusions, such as removing tenants with balances below a certain percentage of their total rent due. If such functionality is available, consult Argus’s documentation or support resources for guidance on implementing these formulas effectively.

Lastly, after applying the balance thresholds, review the report preview to ensure the exclusions have been correctly applied. Make any necessary adjustments to the threshold values or filter settings to achieve the desired output. By carefully configuring these balance thresholds, you can generate a Tenant Rent Roll report that focuses exclusively on tenants with meaningful financial contributions, enhancing the report’s utility for analysis and decision-making.

shunrent

Custom Field Criteria: Exclude tenants based on custom fields like occupancy type or tags

When customizing the Argus Tenant Rent Roll Report to exclude specific tenants based on custom fields such as occupancy type or tags, the first step is to navigate to the report’s filtering options. Within the report setup, locate the "Custom Field Criteria" section, which allows you to apply detailed filters based on tenant-specific data. This feature is particularly useful for narrowing down the report to exclude tenants that meet certain criteria, ensuring the output is tailored to your needs. For example, if you want to exclude tenants with a specific occupancy type, such as "Vacant" or "Short-Term," you can define this condition within the custom field criteria.

To exclude tenants based on occupancy type, begin by selecting the custom field labeled "Occupancy Type" from the dropdown menu in the Custom Field Criteria section. Next, choose the operator that best fits your exclusion rule, such as "is not" or "does not contain," depending on the options available in Argus. Then, input the specific occupancy type you wish to exclude, such as "Vacant." This ensures that any tenant marked with that occupancy type will be omitted from the final rent roll report. Repeat this process if you need to exclude multiple occupancy types by adding additional criteria lines and selecting the appropriate logical operator (e.g., "AND" or "OR") to combine the conditions.

Similarly, excluding tenants based on tags follows a comparable process. Tags are often used to categorize tenants for various purposes, such as delinquencies, special agreements, or lease types. In the Custom Field Criteria section, select the "Tags" field and specify the tag(s) you want to exclude. For instance, if you wish to exclude tenants tagged as "Delinquent," set the criteria to filter out any tenant with this tag. This method allows for precise control over which tenants are included or excluded from the report, ensuring the data aligns with your reporting objectives.

When working with multiple custom fields, such as combining occupancy type and tags, ensure you use logical operators effectively. For example, if you want to exclude tenants that are both "Vacant" and tagged as "Under Renovation," set up two criteria lines: one for occupancy type and one for tags. Link these lines with an "AND" operator to ensure only tenants meeting both conditions are excluded. This level of granularity ensures the report accurately reflects the desired tenant subset.

Finally, after setting up your custom field criteria, preview the report to verify that the exclusions have been applied correctly. Argus typically provides a preview function that allows you to see the filtered results before finalizing the report. If adjustments are needed, return to the Custom Field Criteria section to refine your conditions. By leveraging custom fields like occupancy type and tags, you can create highly customized Argus Tenant Rent Roll Reports that exclude specific tenant groups, enhancing the relevance and utility of the data for your analysis or presentation.

Frequently asked questions

To exclude specific tenants, use the "Exclude Tenants" filter in the report settings. Add the tenant names or IDs you want to exclude, and they will not appear in the final report.

Yes, you can exclude vacant units by applying the "Occupancy Status" filter. Select "Occupied" to remove vacant units from the report.

Use the "Lease Type" filter in the report settings. Choose the lease types you want to include and exclude the ones you don’t need by deselecting them.

Yes, you can exclude specific properties or buildings by using the "Property" or "Building" filter. Simply deselect the properties or buildings you want to exclude from the report.

Written by
Reviewed by
Share this post
Print
Did this article help you?

Leave a comment