When you need data that doesn't come from your HRIS or EMS

## When you need data that doesn't come from your HRIS or EMS

Your HRIS and EMS integrations populate most of the employee data in a cycle, but some data points need to come from elsewhere: performance ratings from a separate system, promotion decisions from leadership, custom calculations you've built, or per-employee budget amounts from finance. There are two ways to bring this data into the cycle.

### Data upload (CSV)

Upload a spreadsheet of values mapped to employees. Best for data that originates outside of Pave and needs to be imported in bulk, like performance ratings, promotion flags, flight risk scores, or pre-calculated budget amounts.

### Calculated columns (formulas)

Write a Handlebars formula that computes values from other columns already in the cycle. Best for data that can be derived from existing cycle data, like "new salary = current salary + salary raise" or "bonus target = 5% of base pay if performance exceeds expectations."

|    | Data upload | Calculated columns |
|----|----|----|
| **Data source** | External (CSV file) | Internal (formula referencing other columns) |
| **Editable by planners** | Yes, if column permissions allow | No, always read-only |
| **Recalculates automatically** | No, static until re-uploaded | Yes, updates when referenced columns change |
| **Good for** | Performance ratings, promotion decisions, custom employee attributes, per-employee budget amounts | Derived metrics, conditional logic, aggregations across columns |



## Data upload

### How it works


1. Open the cycle and go to **Configurations** > **Data Upload**.
2. Select the columns you want to populate from the table of uploadable columns.
3. Click **Upload Data**. In the modal, click **Generate CSV** to download a template pre-filled with current values.
4. Fill in the template with your data. Use employee emails to match rows to employees. Use local currency without symbols for currency fields.
5. Upload the completed file. The upload portal validates your data and flags errors for you to fix before saving.

 ![](https://brainfish-storage-prod.s3-accelerate.amazonaws.com/uploads/eb9365bf-c937-4d2f-b407-a7b5603ae429/b6841389-2a40-4913-810f-78b3373249ac/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIAUPPN5IL3X2IGETGH%2F20260505%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260505T181040Z&X-Amz-Expires=3000&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEL3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMiJIMEYCIQCQVojjq9gzaRKxR%2BK7GQVtJ0cYZ9ST4FqRbCRoPgInWAIhAKxwNLIJj%2BSPaQebnIAxK87e2ifzaEQ2yGPo%2BAd0Z9SfKuUFCIf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAhoMMzA4MTI1OTc1Mjg3IgzQEttNES%2FB4gutiaYquQWSC3LCV8essRK%2FeMOtY6cHdMVvHWaEjZt6sABfeE%2F3PagZ%2BzlVR1lES0U8OW8rkJwlRlsUbWa%2BSCZbsZEr3DZdGAb2cytlE2sXdzqJx%2FeWwrpX%2FsDzPZfo4setqnSkqv2vPNqP92CGODkkEf7ybIc4zvfh2NSq75bdb6jT7WMpLgNBwf4%2BOb2eju2Rv4qen%2B%2BsWhFhoeWU9TjQW6ahwW95sjAEjR8nqwDjMj%2BIjtOglkE5ji2dbPsaTU0GTOHrwLAHDAtpSmRGSfoAxGzVmoVBOHD4MxWZINPryfDcE%2F1A%2FXkg5dob1Zb4LngQy1jIb5aCSGDXwpPE0etD9W64W8e2Gw%2BJUFIisMarlA0qyQ0BUp6QnBsiOgXycWM6ZsdH0h3shJ6%2FhtzlX%2FZS%2F6YtMNyx55u8FDPmBAVZCGds0EapyIZ8tTMiJC0IenYa2cJVfUiDzD%2B8jyARQMjD8dgwhD64zQAScFJ4ejmBalUHI4%2Fr1Eo2xrzBUw9ex9FPjX1v5p8gS59a18l0EHmdykozAUPGneMC66Kq5iGlhjoiK2uo0D2447261nX9ZvF2FQV5tahMkYHJ7Llp4MRgSkhH%2FfITgW80qM8yYJ4hViRGbr1EZLhj25RdaMkjtfBzjtHUJeX4T0%2F0jWbrUfncAS61VGmLgUu039dH4Qw%2BfN%2Fih0WsYyso0ldlKd3JiWvq3PVeK3JMA7kSojvEtEZvXzL2KNGfon%2B5QxiVn1nUjG6sviP7wgoOvRKtlinZ3CoUojfypmcJGTvHZB4LEs8hjMPx2d4pD%2BdnKN7fzp6dEnbltU%2Bz%2BHu6cyqNieQVQDgrOZcbDyisu9RGmf1puxF744cqRm0ris0WK4DaJ2NkbQKM6PMbrVbFiOVV73jN57lQmMysrDqUNkZjnTeHXUn31BGoX6J0ghyco0zbMA2AMILi588GOo8B7gJ5Cf9%2F0cAMSHLywm5RnRKrODsWlAAtp09dHNqaj5YcQLvUq6k1BaYmsFTYVGXcLcVjD3EVheiagXneVojNeT8cWeGLTzt62nTxglczwfxB0Svu25WTUFFbCn%2B7rDXMFy7enNWl4K%2B8G0O5SVGQMjdZP0Vf2nfhR9wL07wGJJlH5Jw1aV0qRm5KMSPbebk%3D&X-Amz-Signature=06dfd2b77ecd084c3ee8ec513bd59d149ff25b25efad2b7fa23aaa12fea0343f&X-Amz-SignedHeaders=host&response-content-disposition=attachment " =966x596")

### What you can upload to

You can upload data to any column configured to accept uploads. This includes:

* **Direct column values**: Salary raise amounts, bonus amounts, custom attributes
* **Recommendation values**: Upload target recommendations for any pay type (shown as "Recommendation: \[Column Name\]")
* **Per-employee budget amounts**: Upload budget values for bottom-up budgets (shown as "Budget: \[Column Name\]")

### Override behavior

By default, uploaded data does not overwrite values that planners have manually entered. If a planner has already saved a value for an employee, the upload leaves it in place.

To replace planner inputs, check **"Override planner inputs with uploaded data"** before uploading. This overwrites any manually saved values and cannot be reversed. The override checkbox only appears when you've selected columns where planners can enter data (it's hidden for recommendation and budget columns, which don't have planner inputs to override).

### What happens after upload

* Values appear in planners' worksheets immediately.
* Any calculated columns that reference the uploaded data recalculate automatically.
* Recommendations and budgets that depend on uploaded values refresh.
* An entry is added to the audit log showing who uploaded, when, which columns were affected, and whether override was enabled.
* If an employee email in your CSV doesn't match anyone in the cycle, that row is skipped and you're notified.

### Uploading currency data

Currency values in the CSV should be in the employee's local currency. The system converts them to the cycle's base currency using the exchange rates configured for the cycle. Equity values follow the cycle's equity currency setting if one is defined.



## Calculated columns (formulas)

### How it works


1. Go to **Configurations** > **Columns**.
2. Create a new custom column or edit an existing one.
3. In the column properties, enter a Handlebars formula in the **Formula** field. The formula can reference any other column in the cycle using `columns.[columnKey]`.
4. Use the live preview to test your formula against real employee data before saving.

 ![](https://brainfish-storage-prod.s3-accelerate.amazonaws.com/uploads/eb9365bf-c937-4d2f-b407-a7b5603ae429/2dcf3077-5577-4d1c-8afa-954b8b1887d2/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIAUPPN5IL3X2IGETGH%2F20260505%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260505T181040Z&X-Amz-Expires=3000&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEL3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMiJIMEYCIQCQVojjq9gzaRKxR%2BK7GQVtJ0cYZ9ST4FqRbCRoPgInWAIhAKxwNLIJj%2BSPaQebnIAxK87e2ifzaEQ2yGPo%2BAd0Z9SfKuUFCIf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAhoMMzA4MTI1OTc1Mjg3IgzQEttNES%2FB4gutiaYquQWSC3LCV8essRK%2FeMOtY6cHdMVvHWaEjZt6sABfeE%2F3PagZ%2BzlVR1lES0U8OW8rkJwlRlsUbWa%2BSCZbsZEr3DZdGAb2cytlE2sXdzqJx%2FeWwrpX%2FsDzPZfo4setqnSkqv2vPNqP92CGODkkEf7ybIc4zvfh2NSq75bdb6jT7WMpLgNBwf4%2BOb2eju2Rv4qen%2B%2BsWhFhoeWU9TjQW6ahwW95sjAEjR8nqwDjMj%2BIjtOglkE5ji2dbPsaTU0GTOHrwLAHDAtpSmRGSfoAxGzVmoVBOHD4MxWZINPryfDcE%2F1A%2FXkg5dob1Zb4LngQy1jIb5aCSGDXwpPE0etD9W64W8e2Gw%2BJUFIisMarlA0qyQ0BUp6QnBsiOgXycWM6ZsdH0h3shJ6%2FhtzlX%2FZS%2F6YtMNyx55u8FDPmBAVZCGds0EapyIZ8tTMiJC0IenYa2cJVfUiDzD%2B8jyARQMjD8dgwhD64zQAScFJ4ejmBalUHI4%2Fr1Eo2xrzBUw9ex9FPjX1v5p8gS59a18l0EHmdykozAUPGneMC66Kq5iGlhjoiK2uo0D2447261nX9ZvF2FQV5tahMkYHJ7Llp4MRgSkhH%2FfITgW80qM8yYJ4hViRGbr1EZLhj25RdaMkjtfBzjtHUJeX4T0%2F0jWbrUfncAS61VGmLgUu039dH4Qw%2BfN%2Fih0WsYyso0ldlKd3JiWvq3PVeK3JMA7kSojvEtEZvXzL2KNGfon%2B5QxiVn1nUjG6sviP7wgoOvRKtlinZ3CoUojfypmcJGTvHZB4LEs8hjMPx2d4pD%2BdnKN7fzp6dEnbltU%2Bz%2BHu6cyqNieQVQDgrOZcbDyisu9RGmf1puxF744cqRm0ris0WK4DaJ2NkbQKM6PMbrVbFiOVV73jN57lQmMysrDqUNkZjnTeHXUn31BGoX6J0ghyco0zbMA2AMILi588GOo8B7gJ5Cf9%2F0cAMSHLywm5RnRKrODsWlAAtp09dHNqaj5YcQLvUq6k1BaYmsFTYVGXcLcVjD3EVheiagXneVojNeT8cWeGLTzt62nTxglczwfxB0Svu25WTUFFbCn%2B7rDXMFy7enNWl4K%2B8G0O5SVGQMjdZP0Vf2nfhR9wL07wGJJlH5Jw1aV0qRm5KMSPbebk%3D&X-Amz-Signature=2f5d0e0bd5f76ebf1980eb9455605162293c2a55fffa16d8924ce9b3afee153e&X-Amz-SignedHeaders=host&response-content-disposition=attachment "left-50 =483x440")

### What formulas can do

Formulas support arithmetic, comparisons, conditionals, date operations, string manipulation, and formatting. Some common patterns:

* **Arithmetic**: `{{multiply columns.basePay 0.03}}` (3% of base pay)
* **Conditional**: `{{inlineIf (gt columns.performanceRating "Exceeds") 5000 2500}}` (different amounts based on rating)
* **Aggregation**: `{{add columns.salaryRaise columns.marketRaise}}` (sum two columns)
* **Date logic**: `{{monthDiff columns.startDate columns.cycleStartDate}}` (tenure in months)

For full syntax documentation, see our documentation on [Writing formulas with Handlebars](https://support.pave.com/en-us/articles/writing-formulas-with-handlebars-UY3vIXn2gv?draftPreview=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6ImViOTM2NWJmLWM5MzctNGQyZi1iNDA3LWE3YjU2MDNhZTQyOSIsImRvY3VtZW50SWQiOiJlZThiMzA2NS04MDIyLTQ3MjktOWI1YS05MDIxZGY2YWMzYTgiLCJjcmVhdGVkQXQiOiIyMDI2LTA1LTAxVDAwOjExOjE0LjI5MFoiLCJleHBpcmVzQXQiOiIyMDI2LTA1LTAxVDAxOjExOjE0LjI5MFoiLCJ0eXBlIjoiZHJhZnRfcHJldmlldyIsImlhdCI6MTc3NzU5NDI3NH0.3cl-T1u5zGF8dLTnYZckMChjsWXyn_PA7b_W6Zk2iOs).

### How calculated columns behave

* **Always read-only.** Planners cannot edit formula column values. The formula controls the output.
* **Automatically recalculate.** When any column referenced in the formula changes (from a planner edit, data upload, or another formula), the calculated column updates.
* **Available to other features.** Calculated column values can be used in budgets, smart flags, and other formulas.


## Things to know

* **Finalized cycles.** Data cannot be uploaded after a cycle is finalized. Calculated columns still display their values but inputs can no longer change.
* **Audit trail.** Every data upload is logged with the author, timestamp, columns affected, and override status.
* **Combining both approaches.** You can upload raw data (like performance ratings) and then build calculated columns on top of it (like a bonus amount that varies by rating). The calculated columns will recalculate whenever you re-upload.




Adding non-integration data to your cycle

Configurations overview

Cycle access permissions

Overview

Employee eligibility

Approval chains

Planning windows

Budgets

Recommendation logic

Reward letters

Cycle Setup

Columns

OTE planning

Writing formulas with Handlebars

Hourly and monthly pay

Columns and Formulas

Using the planner worksheet

Using the employee detail view

Cycle Progress dashboard

Budgets dashboard

Cycle Outcomes dashboard

Worksheet Experience

Overview of smart features in compensation planning

Peer Comparison

Smart Flags

Priority Sort

Compensation Outliers

Manager Compression Flag

Vesting Drop Flag

Flags and Insights

Compensation Planning

Market Data Connections Overview

Market Data Connections Set up

Integrations 101

Integrations

Team View Overview

Team View Column Configuration

Team View Customizations

Re-ordering Columns

Deleting Columns

Adding Columns

Team View Settings

Team View

How much does Pave Market Data access cost?

How does Pave Work?

Intro to Pave

Contact Us

Pave 101

Total Compensation

Compensation 101

ISO Tax Implications

The Basics of Stock Options

The Confusing AMT (Alternative Minimum Tax)

ISO Strategies

An Overview of How Stock Options Work

The Stock Option Lifecycle

Equity 101

Login Troubleshooting and FAQ

How does company size affect which department, job family and job level I should choose?

How does Pave determine a role level and role family?

Troubleshooting Rippling Zero Records Error

What Market Data Connections does Pave currently support?

Account Creation Troubleshooting and FAQs

How to Benchmark Executive Compensation

FAQs

Creating an Account

How to add a colleague to Pave’s Market Data Platform

Market Data Role Management

Why does it matter to get levels and role families right?

SSO Configuration Guide

Logging In

Custom Role Creation Guide

Account Setup

Getting Started

Grades

Setting up Company Job Architecture

Company Job Architecture

Job Architecture 101

Pay Zone Manager

Step 1: Build Foundation

Generate Bands from Market Data

Editing Bands

Calculated Columns

Bands Set Audit Log

Bulk & Manually Associate Market Data to Bands

Employee Distribution in Bands

How to duplicate band sets

Managing & Reordering Calculated Columns

Unmatched Employees

View changes

Pay Types: Calculated TDC, Annual Equity, and Refresh Equity

Manually Create New Band Sets

Band Sets

Upload/Download Bands

Step 3: Update Ranges

Advanced Filters

Compare Bands

Generate Bands for New Jobs in Your Job Architecture

Relative Permissions

Ongoing Management & Analysis

Edit and apply benchmarks

Set weights and logic

Map data sources to jobs

Supported survey providers

Manage Pave data sources

Manage survey data sources

Benchmarks overview

Survey aging

Step 2: Benchmarking

Market Pricing

Notifications

Multirole Permissions

Standard Pave Permissions

Role Management

Impersonation as a Pave Admin

Auto-manager Assignment

Admin Notification Dashboard

General

How do I know if I’m impersonating someone else?

Can I act on another’s behalf while impersonating them?

Who is able to impersonate?

Who can I impersonate?

How do I impersonate a user?

What is Impersonation?

How can I view Pave as another role?

How do I add multiple users to a role at once?

How can I change the permission settings for a role?

How can I create a new role?

Can a user have more than one role at a time?

Am I able to change another user’s permissions or login credentials while impersonating?

Can I impersonate another user in one page while having other Pave tabs open?

Permissions & Settings FAQs

Account & Permissions

How to Search for a Benchmark

Pave Data and Methodology Guide

Market Data 101

Job Families

Calculated Benchmarks

Compensation Types

Data Collection and Aggregation

Percentiles

Filters

Consistency Labels

Pave's Data

Calculated Benchmarks FAQ

Location and Global Data FAQs

Equity Practices FAQs

Consistency Labels FAQ

Market Data FAQs

Job Levels

Global Location Insights

Advanced Equity

Market Data Pro

Market Data

Understanding Equity in Total Rewards

Display Original Grant Value

Compensation Simulator Configurations

Compensation Simulator Overview

Learning Hub Configuration

Learning Hub Overview

Reward Letters

Accessing your Total Rewards portal

Total Rewards 101

Visual Offer Letters with Workday

Visual Offer Letters with Greenhouse

Visual Offer Letters with Lever

Visual Offer Letter as a Candidate

Previewing Visual Offer Letters

Visual Offer Letters with Ashby

Creating and sending Visual Offer Letters in Pave

Visual Offer Letter 101

Why is my equity different in the equity tab on the left hand side compared to the equity valuation on the graphs?

Why can't I view my own Total Rewards portal?

Total Rewards and Visual Offer Letter FAQ

How can I complete our Greenhouse connection if "API credential management" is not in my Greenhouse menu?

Adding non-integration data to your cycle

Share

Share

Adding non-integration data to your cycle

Share

Share