- Overview
- Apply a Fee Matrix to an Element
- Remove a Fee Matrix from an Element
- Custom Row Fields Explanation
Overview
A fee matrix calculates on an element (e.g. Quote, Invoice, etc.) when it's used in a custom row on that element's definition. This article explains how to add that custom row to an element definition manually via the Element Definition settings page. If you haven't created the fee matrix yet, start with Add, Edit, and Delete a Fee Matrix.
The quickest way to apply and add a fee matrix to a total block view is from the fee matrix itself. See Configure a Fee Matrix.
To use these steps, the Can Configure Project Elements permission is required.
If you apply a fee matrix to an element definition, then make certain changes to an element from the past, it will add the new fee matrix amount to the total price or cost of that element. For more details, see Which Actions Will Cause a Financial Element to Recalculate?
Apply a Fee Matrix to an Element
- Go to Main Menu > Projects > Element Definitions.
- Double-click the element definition you want to add the fee matrix to.
- Click the Custom Rows tab.
- Click the Add New Custom Row icon in the bottom left.
- Set Calculation Method to "Fee Matrix," then choose an existing fee matrix in the Fee Matrix field.
- Enter the rest of the custom row information. See Custom Row Fields Explanation below for details.
- Click OK.
The fee now calculates and adds to the element total, but it won't show in the total block. To show it, see Add a Fee Matrix Amount to the Total Block of an Element.
Remove a Fee Matrix from an Element
To stop a fee matrix from calculating on an element, delete its custom row.
- Go to Main Menu > Projects > Element Definitions.
- From the element definition's Custom Rows tab, select the checkbox next to the custom row using the fee matrix.
- Click the Delete Selected Custom Row(s) icon.
- Select the I Agree checkbox, then click Yes.
A custom row can't be deleted while it's in a view's total block, or if existing elements have an amount for it. Remove it from every total block first. See Remove a Fee Matrix Amount from the Total Block.
Custom Row Fields Explanation
- Code: The identifier for the row. This is what you select when adding it to a total block.
- Description: A description of the custom row and its purpose.
- Calculation Method: How the custom row calculates. Choose "Fee Matrix," then choose the fee matrix in the Fee Matrix field that appears. For the other options, see Projects > Element Definitions.
-
Result Type: Whether the custom row results in a price or cost.
- Price: Charged to the client.
- Cost: An internal cost to you.
- Pass Through: Both a price and a cost.
-
Resource Type: If this field is set, the custom row amount will:
- Export to QuickBooks using this resource type, which is important for account mapping.
- Be taxed at this resource type's percentage in the element's sales tax rule. Only applies when Tax Treatment is "Use Standard Tax Rule."
-
Tax Treatment: How the custom row is taxed.
- Not Taxable: The amount isn't taxed.
- Use Standard Tax Rule: The amount is taxed using the element's sales tax rule.
- Discount Tax Pro Rata: The amount reduces the element's sales tax in proportion to the sales tax rule percentage.
- Transient Calculation: If Yes, the custom row is for display only and doesn't add to any totals.
- Is Waivable: If Yes, users can manually change the custom row amount in the element's total block.
- Must Be Negative: If Yes, any manually entered amount becomes negative.
If you don't choose a Resource Type and you set Tax Treatment to "Use Standard Tax Rule," the custom row is taxed at the "Default" percentage of the element's sales tax rule.