How to Add & Manage a Vendor Exception Fee Plan on Mercury Network®

Overview

The Mercury Network® platform allows you to create and manage fee plans through the Fees Module. Vendor fees are automatically calculated based on data points such as product type, geographic area, and property value. Vendor Exception Fee Plans allow you to specify different fees for orders assigned to specific vendors. When applicable, the Exception Fee Plans will override the standard Vendor Fee Plans. These plans apply to UAD 3.6 products.

How to Create a New Vendor Exception Fee Plan

Exception fee plans will override the baseline vendor fee plans when the order is associated to the selected vendor(s).

Note: These plans apply to UAD 3.6 products.

1. Navigate to the top navigation bar and select Preferences.

2. Select Fees in the dropdown menu.

3. Click the double arrow icon at the top of the sidebar to open the left navigation, then select Vendor Exception Fee Plans.

   Note: You must configure value tiers before creating fee plans. Tiers are determined by the property’s Sales Price or the Owner’s Estimate of Value. For detailed instructions, refer to the article: How to Add & Manage Fee Plan Value Tiers.

4. On the Vendor Exception Fee Plans page, select Create New Plan.

   1. Select Bulk Upload. The bulk spreadsheet method is the primary way to create multiple fee plans.

   2. Enter a plan name in the Fee Plan Name field.

   3. Choose your Base Fees methodology for the plan such as:

      1. Use vendor default fees - Uses the assigned provider’s standard rates as configured in their vendor profile.  

      2. Set fees as a percentage of the client price - Calculates fees based on a percentage of the client fee that is calculated for the order.  To utilize this approach, you must establish a Client Price Plan.

      3. Manually add fees - Allows the user to specify custom fees for different kinds of orders. User will need to enter base fees and add-on fees for all applicable products and geographies.

   4. Click Next.

5. On the Upload Plan Details section, click on the Instructions to view the file requirements.

   1. Download the Vendor Exceptions template.

6. Populate the fee plan spreadsheet

   1. On the Plan tab:

      1. List every combination of products and geographic areas your fee schedule requires.

      2. For each product, include a base fee for each configured Value Tier. This is only applicable if you chose the Manually Add Fees option.

      3. Specify add-on fees for any order data points that, when true for the order, increase the fee. The total vendor fee for an order is calculated by adding the base fee + any applicable add-on fees. This is only applicable if you chose the Manually Add Fees option

         Note: Required fields on the spreadsheet template have column headers highlighted in Red, while optional fields have column headers highlighted in Green. You must populate both the Plan and the List tab. Please click on the Instructions link below. Add-on fees are optional.

   2. On the List tab:

      1. List the specific vendor(s) this plan applies to. These fees will override the default plan for the specified Vendors.

7. Upload your fee plan spreadsheet.

   1. Click Browse file to upload the completed template back into the system. You may assign any name to your file; the system does not require a specific naming convention.

   2. Click Save Fee Plan.

8. On the Vendor Exception Fee Plans page, click View Fees to monitor your spreadsheet upload status and confirm the plan passed validation.

   1. If the plan validation fails, the user who uploaded the spreadsheet will receive an email notification.

   2. In the Fee Plans section, a failed icon 🚫 will display in Status column.

Note: You can click the “History Log” button to the left of the “Create New Plan” button to see every successful and attempted upload in your current profile. If there was a validation error during your upload, the reason will be outlined here.

9. If plan validation fails, click Delete to remove the plan, then update the spreadsheet template to resolve the errors.

   1. Create a new plan using the corrected spreadsheet template.

How to View, Edit and Delete a Vendor Exception Fee Plan

1. Navigate to the Fee Plans section.

2. Locate a plan using the Search field or by filtering by Plan Name, Status, or # of Vendors.

3. To view or edit an existing plan, click View Fees. To remove a plan, click Delete.

4. From the existing fee plan page, click the Edit (pencil) icon to rename the Vendor Fee Plan if necessary.  

5. Use the Product and Locations filters to narrow your search for items.

6. To edit an existing fee plan, click Export, and update the data in the spreadsheet as required.

   1. Click Modify Plan to upload your updated spreadsheet and replace the existing fee plan.

   2. Click Browse file to upload the spreadsheet into the system.

   3. Click Update Fee Plan.

   4. Monitor your fee plan to ensure it does not encounter any validation errors.

Outcome

You have now configured exception fee plans that automatically calculate the correct total vendor fee for an order. You can differentiate fees for specific vendors that differ from your standard vendor fee plans.  When applicable, the Exception Fee Plans will override the standard Vendor Fee Plans.