--- schema_version: "1" id: 87ea752684c75613b5722b6d8017363bf04e34960709190ecab5f16d73ae1460 title: Set Up a Commission Expense Report in Salesforce Spiff collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_expense_create.md canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_expense_create.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: cbc3c89d5d9b8399048e5a84342a4da68914766273f7eeeb0e9acbacd8c5f8c0 description: To create a commission expense report, set up general ledger accounts, establish fringe benefit rules, and create a commission expense portfolio. products: - Sales Cloud - Sales Enablement release: "264" --- # Set Up a Commission Expense Report in Salesforce Spiff To create a commission expense report, set up general ledger accounts, establish fringe benefit rules, and create a commission expense portfolio. ### Required Editions

Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience

Available in: Enterprise, Unlimited, and Developer Editions

Available for an additional cost in: Professional Edition with Web Services API Enabled

User Permissions Needed
To create a commission expense report:	A Spiff user role with these permissions turned on. Expense Reports: Edit Expense Portfolios: Edit

User Permissions Needed

To create a commission expense report:

A Spiff user role with these permissions turned on.

Expense Reports: Edit
Expense Portfolios: Edit

## Set Up a General Ledger Account Set up general ledger accounts before you create expense portfolios and fringe benefit rules. 1. Click the **Accounting Reports** icon in the header. ![Accounting Reports icon in the Spiff header](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_expense_accounting_reports.png) 2. Click the **+** icon next to the search bar in the left-hand panel and select **New General Ledger Account**. 3. Enter the general ledger account details.

Name	A description of the account.
Number	The account number in your accounting system.
Type	Whether the account is a Balance Sheet or P&L.

4. Enter all the general ledger accounts used for recording capitalization and amortization of ‌commission expenses or fringe benefits. ## Create a Fringe Benefit Rule To account for extra bonuses in expense reports for certain deals, add fringe benefit rules to a portfolio. For example, a rep receives a retirement account match for deals that exceed a certain ARR amount. 1. In the Accounting Reports view, click the **+** icon next to the search bar in the left-hand panel and select **New Fringe Benefit Rule**. 2. Enter a name, description, incremental costs rule, and accounts for with the fringe benefit. 3. Save your changes. ## Create a Commission Expense Portfolio Create a portfolio for your fringe benefit rule. If you have multiple types of commissions and several rules with different expense time lines, create a separate portfolio for each rule. 1. In the Accounting Reports view, click the **+** icon next to the search bar in the left-hand panel and select **New Expense Portfolio**. 2. Enter a name and description. 3. For Effective Date, specify an effective start date and optional end date. These dates specify when the portfolio tracks expenses. 4. For Commission Values, select the commission values to expense. 1. Click **Add new rule** and select an amount from any existing payout rule in Designer. 2. To add other rules, click **Add new rule** again. 3. To specify logic for evaluating the rules, click **Add Additional Logic** and enter a function or expression, such as applying a calculation to a field or amount. We recommend that you create a field upstream in Payout Rules that calculates the amount to expense, and then you can reference that field in this logic. Or, adding logic is helpful when you don’t want to expense the entire commission at one time or if you need to handle specific departments, products, or regions separately. Additional logic can add rows to the report with values of 0 for records that don’t satisfy the condition. To omit these rows from the report, select **Exclude '0' values**. For example, exclude deals with a Services product name that return a commission amount of $0.00. ![Commission Values rules and logic, excluding deals with a Services product that have no commission amount](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_expense_exclude_zero.png) 5. For Expense Rules, specify amortization options. - To set up amortization that depends on the length of a contract, select **Yes, Straightline Amortization** and **Dynamic Duration**. For Start Date and End Date, specify the contract dates. You don’t have to track residual amortizations for each deal, because the tracking is dynamic and uses the same data that’s used for calculating commissions. - To set up amortization for a perpetual contract with no defined start and end date, or if you want to amortize costs over the length of an average customer contract, select **Yes, Straightline Amortization** and **Average Duration**. Enter the average amortization period in months. - To expense commissions immediately, select **No, Expense Immediately**. Enter the date to expense these amounts, such as statement\_period.end\_date. - To do divide the expense from the purchase amount evenly across all periods, even partial periods, select the **Straight-line, by even periods** amortization method. - To divide the amount equally over each day within the period and then sum the amount for the period, select the **Straight-line, using exact days** amortization method. Because each period can have a different number of days, each period can have a different amount. ![Example amortization options](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_expense_rules.png) The Capitalization Date and Start Date values can be different. The date fields support date functions and fields such as `end_of_month(CloseDate)` or `Contract_Start_Date__c`. Or, reference a custom date field in a datasheet, such as AmortizationStartDate, that calculates more specific logic, such as `beginning_of_month(months_ago(CloseDate, -3))`. For any field you reference, calculate it within plan logic and include the field in the trace so the report can show it. See [Connector Fields and Calculations in Salesforce Spiff Reports](https://help.salesforce.com/s/articleView?id=sales.spiff_report_fields.htm&release=264.0.0&type=5 "When you’re using connector fields or calculations in Salesforce Spiff reports, encapsulate each those items in their own calculated field."). ![Example Start Date and End Date custom field calculations](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_expense_dates.png) 6. For Fringe Benefit Amortization Rules, select the fringe benefit rules you created. If the benefit applies only to a certain time period, such as the end of the year, specify Effective As Of or Effective Until dates. 7. For General Ledger Settings, select the general ledger accounts you created. 8. Save your changes. ## Create the Expense Report After you create the portfolio, set up the report. 1. In Reporting, select **Expense Reports**, and then click **Custom Expense Report**. 2. Enter a name and optional description. 3. For Report Time Frame, select start and end dates. 4. For Capitalization Time Frame, select start and end dates. With this date range, you can include records where the capitalization date occurred before the Report Time Frame start date but that are still amortizing. 5. Add portfolios to the report. 6. Save your changes. Manage and customize the expense report like other Spiff reports. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_note.png) Note When you turn off Capture Trace for a calculated field, the field isn’t available in expense reports. #### See Also - [Reports and Dashboards in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_reports_dashboards.htm&release=264.0.0&type=5 "Salesforce Spiff provides several prebuilt standard reports for individual commission breakdowns, team performance summaries, and time visualization. Spiff also includes custom reports so managers can create their own reports for more strategic incentive compensation insights. Prebuilt dashboards organize all your visual reports and custom reports in one place.") - [Capture Trace View in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_trace.htm&release=264.0.0&type=5 "Admins and reps in Salesforce Spiff can visualize how metrics, rule totals, and deal amounts are calculated in statements. In trace view, also called Capture Trace, users can click into a highlighted item and view more details. Tracing calculations in Spiff helps you debug calculations, test new calculations, provide transparency, or conduct an audit. Admins can turn off trace for some items in Designer.")