--- title: How to Create your Compensation Cycle in Pequity! description: How to create or clone and update your cycle directly in Pequity --- [Skip to content](https://helpcenter.pequity.com/support/create-clone-comp-cycle#main-content) English Show submenu for translations [More support](https://helpcenter.pequity.com/support/kb-tickets/new?hsLang=en) ![Logo (1)](https://helpcenter.pequity.com/hs-fs/hubfs/Logo%20(1).png?width=202&height=50&name=Logo%20(1).png) - [Pequity](https://pequity.com/) - [Platform](https://pequity.com/solutions) - [Blog](https://blog.pequity.com/) - [Login](https://pequity.app/login) - [Get a demo](https://pequity.com/contact) Open main navigation Close main navigation - [Pequity](https://pequity.com/) - [Platform](https://pequity.com/solutions) - [Blog](https://blog.pequity.com/) - [Login](https://pequity.app/login) - [Get a demo](https://pequity.com/contact) - English Show submenu for translations - [More support](https://helpcenter.pequity.com/support/kb-tickets/new) - Contact us Contact us How can we help you? - There are no suggestions because the search field is empty. 1. [Support Center](https://helpcenter.pequity.com/support?hsLang=en) 2. [Pequity Features & Workflows](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en) 3. [Pequity Comp Cycles](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#pequity-comp-cycles) # How to Create your Compensation Cycle in Pequity! ## An overview of the comp cycle setup in Pequity, including how to configure columns, manage data, apply formulas, and adjust layouts so the tool supports your planning process.   ### **Bringing in Data & Managing Columns** Bring data into the cycle using the **Add Employees** function, which pulls directly from the People page. - Run Add Employees again anytime to update columns or sync new hires. - Choose whether to bring in all employees or only a subset, and deselect columns that don’t belong in the cycle. - Sync updates from the People page as needed, and remove terminated employees if they no longer apply. For data that doesn’t live on the People page (like performance ratings), upload it through the **Import** experience. The system can automatically match columns by employee ID, even if the names differ slightly. ### **Editing Columns & Display Options** Adjust the layout to fit planning needs: - Reorder, regroup, or ungroup columns to make navigation easier. - Stack related fields to save space - Apply colors to guide planners or align with branding. Common setup patterns include: - Merit eligibility rules (e.g., based on hire date). - Performance ratings as dropdowns, editable by planners or restricted to admins. - Formulas for salary increases or bonus payouts tied to ratings and targets. ### **Imports & Naming Conventions** When importing data: - Map sheet column names to existing cycle columns to avoid duplicates. - Create new columns if needed, stack them with existing ones, or hide helper fields used only for calculations. ### **Formulas & Flexibility** Capture proration and multipliers directly in the tool: - Calculate tenure-based prorations. - Apply company-wide pool adjustments. - Use hidden helper columns for clean planner views. ### **Tooltips & Guidance** Add **tooltips** to any column to give context or instructions. This reduces questions and keeps everyone aligned. ### **Layouts & Roles** Control what different audiences see: - Create layouts (views) tailored to each role. - Assign layouts so, for example, HR partners can view performance information without compensation details. - Toggle access to comments or sensitive notes where appropriate. ### **Waves & Planning Groups** Structure planning phases with waves: - Waves define *when* planning happens, while planning groups define *who* is included. - Use multiple waves if employees need input from more than one level of leadership. - Group waves in the workbook to organize divisions or planning depths more clearly. ### **Ranges & Total Compensation** Decide how ranges and benchmarks are displayed: - Show low/mid/high or a single benchmark target. - Use Radford codes or internal structures. - Calculate total comp in the tool or upload precomputed values. - Import and stack historical comp data for context. ### **Commonly Used Formulas** 1. **STRING(value)** - Converts a value to a string. - Example: STRING(@co\_employee\_id) 2. **CONTAINS(string, substring)** - Checks if a string contains another substring. - Example: CONTAINS(@job\_family, "Engineer") 3. **RANGELOOKUP(co\_dept, co\_role, co\_geo, co\_level, attribute)** - Looks up compensation range data based on role attributes. - Example: RANGELOOKUP(@job\_family\_group, @job\_family, @geo, @level, "co\_salary\_low" #### Logical Functions - **ISBLANK()**: Check for missing values - **AND()**: Combine multiple conditions - **OR()**: Check if any condition is true - **NOT()**: Negate a condition - **IF()**: Create conditional logic - **IFS()**: Check multiple conditions #### Mathematical Functions - **MOD()**: Calculate remainders - **ROUND()**: Round to nearest value - **MROUND()**: Round to a multiple - **MROUNDUP()**: Round up to a multiple - **MROUNDDOWN()**: Round down to a multiple - **AVERAGE()**: Calculate averages #### Text Functions - **LOWER()**: Convert text to lowercase - **UPPER()**: Convert text to uppercase #### Date Functions - **NETWORKDAYS()**: Calculate working days between two dates - **TODAY()**: Return the current date - **DAY()**: Extract the day from a date - **MONTH()**: Extract the month from a date - **YEAR()**: Extract the year from a date - **DATE()**: Create a date value #### Error Handling - **IFERROR()**: Gracefully handle errors #### Comparison Operators - **\>** : Greater than - **\<** : Less than - **\>=** : Greater than or equal - **\<=** : Less than or equal - **=** : Equal to - **\<\>** : Not equal to #### Arithmetic Operators - **+** : Addition - **-** : Subtraction - \*\*\*\*\* : Multiplication - **/** : Division #### Important Notes - All formulas must start with an equals sign (`=`). - Use `@` to reference fields. - Functions mirror the behavior of spreadsheet formulas. - Designed for compensation-specific calculations. - [Getting Started with Pequity](https://helpcenter.pequity.com/support/getting-started-with-pequity?hsLang=en#main-content) - [Pequity Setup & Company Admin Onboarding](https://helpcenter.pequity.com/support/getting-started-with-pequity?hsLang=en#pequity-setup-company-admin-onboarding) - [Personal Settings](https://helpcenter.pequity.com/support/getting-started-with-pequity?hsLang=en#personal-settings) - [Integrations & Data Management](https://helpcenter.pequity.com/support/getting-started-with-pequity?hsLang=en#integrations-data-management) - [ADP Lyric HCM Integrated Pequity](https://helpcenter.pequity.com/support/adp-lyric-hcm-integrated-pequity?hsLang=en) - [Managing Your Team in Pequity](https://helpcenter.pequity.com/support/managing-your-team-in-pequity?hsLang=en#main-content) - [General User Access](https://helpcenter.pequity.com/support/managing-your-team-in-pequity?hsLang=en#general-user-access) - [Single Sign-On (SSO) Integration](https://helpcenter.pequity.com/support/managing-your-team-in-pequity?hsLang=en#single-sign-on-sso-integration) - [People Manager Access](https://helpcenter.pequity.com/support/managing-your-team-in-pequity?hsLang=en#people-manager-access) - [Pequity Features & Workflows](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#main-content) - [Pequity Comp Cycles](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#pequity-comp-cycles) - [Pequity Ranges Tool](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#pequity-ranges-tool) - [Pequity People Tool](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#pequity-people-tool) - [Pequity Approvals Tool](https://helpcenter.pequity.com/support/pequity-features-workflows?hsLang=en#pequity-approvals-tool) - [Pequity Best Practices](https://helpcenter.pequity.com/support/pequity-best-practices?hsLang=en) - [Security & Compliance in Pequity](https://helpcenter.pequity.com/support/security-compliance-in-pequity?hsLang=en) - [Proactive Support & Troubleshooting](https://helpcenter.pequity.com/support/proactive-support-troubleshooting?hsLang=en) - [Pequity Updates & Insights](https://helpcenter.pequity.com/support/pequity-updates-insights?hsLang=en) - [Pequity University](https://helpcenter.pequity.com/support/pequity-university?hsLang=en#main-content) - [Comp 101](https://helpcenter.pequity.com/support/pequity-university?hsLang=en#comp-101) - [Reward Letters](https://helpcenter.pequity.com/support/reward-letters?hsLang=en) [![Pequity](https://helpcenter.pequity.com/hubfs/Pequity%20an%20adp%20company%20final%5B96%5D%20(1).svg "Pequity")](http://pequity.com) 1 ADP Boulevard Roseland, NJ 07068 Copyright © 2026 Pequity, an ADP Company