--- schema_version: "1" id: ed070f57e01b634ab3a79bedb62dbb5e7e310b1db69f28bcb72dece49b33d17b title: Create a Payroll 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_payroll.md canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_payroll.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: f1ca31af20d907876f9a1841ffff0921ac90157c622a031d7b43ea6e2931a03e description: Ensure accurate and efficient reporting of payroll data for each rep in Salesforce Spiff. Automate the payroll process and make payroll data readily available for every custom report. products: - Sales Cloud - Sales Enablement release: "264" --- # Create a Payroll Report in Salesforce Spiff Ensure accurate and efficient reporting of payroll data for each rep in Salesforce Spiff. Automate the payroll process and make payroll data readily available for every custom report. ### 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 payroll report:

A Spiff user role with these permissions turned on.

  • Designer Configuration: Manage
  • Custom Reports: Edit
  • Statements: Recalculate
1. Sync payroll data from your CRM ,or upload an export from your payroll or HR system. To link records to the correct reps, make sure the uploaded file contains unique IDs and fields. The tab name is what the object or table is named in Salesforce Spiff. 2. Connect the uploaded data to Designer. 1. From the left panel under Data, click **Manage Objects & Fields**. 2. Select the data source and expand the object dropdown. 3. Click the **+** icon next to any field you want available for this report. 3. Create a filter to map payroll records to the correct representatives. 1. From the left panel under Data, click **Filters**. 2. Select the .csv file you uploaded and click **New Filte**r. 3. Name the filter PayrollDataByRep and enter syntax. ``` User_Id = rep.Id ``` 4. Create a worksheet to pull in necessary payroll data from a rep’s record. 1. Create a separate folder for payroll data and add a worksheet. 2. Name the payroll information and enter the payroll formulas. ``` Payroll Code =single(transform_list(PayrollDataByRep, Payroll_Code)) ``` ``` Payroll Region =single(transform_list(PayrollDataByRep, Payroll_Region)) ``` 3. Continue with any other payroll data from your upload. Selecting different representatives dynamically updates the values returned. ![A worksheet to pull a rep's payroll data](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_payroll_report.png) 5. Establish a ghost payout rule that calculates the payroll fields for each rep on that plan. The ghost rule guarantees that the data is included in rule logic but results in a zero payout. 1. On the payroll worksheet, name the ghost rule and enter the payroll formulas. ``` =if(PayrollCode, 0, 0) + =if(PayrollRegion, 0, 0) ``` 2. Create a payout rule on a plan and turn the ghost rule on. You can reuse this rule and add it by default to every plan to make sure you always have the payroll data you need in your reports. 6. Calculate statements and create the report. 1. Calculate any unfrozen statements to make sure data flows through to the report. 2. From Reports, click **Create Report**. 3. Click **Add Columns** to add payroll fields to your report. 4. Click **Apply** and then click **Run & Save**. #### See Also - [Imported Data in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_import.htm&release=264.0.0&type=5 "You can manually import data into Salesforce Spiff, in addition to data synced from external sources, such as Salesforce. You can view your imported data in Data Sources and Designer.") - [Considerations for Worksheets and Worksheet Calculations](https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_considerations.htm&release=264.0.0&type=5 "Worksheets provide the functionality to create calculations that produce a single output. Worksheet calculations are flexible and can be used in data filters, other worksheet fields, and in datasheet fields tied to objects on unrelated plans.") - [Functions in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_functions.htm&release=264.0.0&type=5 "Salesforce Spiff Designer provides a library of functions for calculating values and handling different data types.")