Create Custom Consolidation Reports Using Properties

Overview

"Properties as a Frequency" allows users to harness the Properties feature to create custom groupings of Entities and then display the consolidated Entities as columns in a side-by-side manner in reports. The feature essentially takes an output which looks like the top report below and consolidates Entities in any customized consolidation format, such as the report on the bottom.

• This feature is specific to each Qvinci Company/Qvinci Client.
• Additionally, this feature is only available as a templated report under the My Reports tab, not as a Basic Report. 

3 Steps in this process

1. Create the custom property

The first step to utilizing Properties as a Frequency is to create the Properties themselves. The options, or buckets, that are created inside a property will be the custom groupings that are desired as the column outputs in the reports. As such, the user will want to name the options/buckets accordingly, with the column header output in mind.

Step 1. The Qvinci Admin or Leader should visit the Manage > Properties tab in the left navigation bar.

Step 2. The Property name itself is not shown in the report; just the option/bucket names. For example, if the user desired to consolidate Entities by region, they would call the Property "Region" or "Regional Groupings", etc.

• • If the Property is not tracking a Date or Number, then the user should always select "List" as the type of Property. This will allow the user to key in text naming conventions.

Step 3. After creating and saving the Property, create the list options on the second half of the page. 

• • Using the same example of a "Regional Groupings" Property, the user would begin entering the options/buckets for the regions. IE: Northwest, Southeast, Pacific, etc. Entities will then be tagged into those options, and it is those naming conventions that will appear as column headers in the report.

  • It may be preferable to create an "N/A" or "Other" option as a placeholder for new/future Entities as well.

2. Assign property options to entities

 After you have been created the options/buckets, the user needs to assign Entities into them.

Step 1. Visit the Manage > Entities tab and click on an Entity in the column.

Step 2. In the center of the screen click on the Properties link that appears under the Entity name.

Step 3. Assign the Entity into the desired option/bucket.

Step 4. Repeat the process for each Entity until all are assigned. 

3. Build a report template that includes the property

After Entities are assigned into the Property options/buckets, the user is able to construct the template which will deliver the desired output.

Step 1. If the user does not already have a formatted template in their Mine tab, visit the Qvinci Gallery under Reports & Libraries > Libraries to find one. Typically, any P&L or Balance Sheet template will work, as the user is going to edit it anyway. 

Be sure to click the blue "Edit" button and not "Preview" when opening the template. IE: No financial values should appear in the rendered template.

Step 2. With the template open, click "Save As" and give the template a custom name.

Step 3. Click on the cell in the first column which contains a Column Chooser macro (typically Column C).

Step 4. Select the  Column Chooser icon from the top left. 

Step 5. In the "Select Frequency" dropdown, choose "Property". 

Step 6. In the secondary dropdown that appears for "Select Property", choose the desired Property by which to sort the report columns.

Step 7. After making selections for the rest of the report, such as date range, etc., be sure to save the preferences.

Step 8. After preferences for the Column Chooser are made for that particular column, be sure to Save the report. A Preview or Package download will only render the most recently saved template changes.

Step 9. Remove any additional column macros that are not desirable (if this template was saved from another version) and click Save again.

Step 10. After saving the template changes, click Preview. 

Step 11. The user should see that the columns are arranged by Property option names. 

• • The user may still use the "Filter Entities" tab at the top of the report to further filter the Entities that should be included in the report output.

    ---

    Have Questions?
    We're More Than Happy to Help

    Schedule a call with Customer Success below, email us at support@qvinci.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!

    Schedule an Appointment with Customer Success