Best Practices for Salary Data

To ensure accurate compensation modeling, analytics, and reporting

1. Upload Each Component Separately

Break down salary data into its individual components:

• Base Salary

• Bonus

• Benefits

• Allowances

• Other Compensation

This allows Agentnoon to calculate total compensation and run cost modeling with flexibility.

2. Use Consistent Field Naming

Ensure the field names used in the imported salary files exactly match the naming in your:

• Rate Cards

Example: If your salary upload uses Base_Salary, your rate card should not use BasePay—they must be the same.

3. Support for Multiple Currencies

If your data spans multiple currencies:

• Include a Currency column (e.g., USD, EUR, NGN)

• Include a Salary_Amount_Local field

(Optional) Add a Salary_Amount_USD field if conversion is pre-applied Agentnoon supports in-platform currency conversion, but clarity at upload helps validate totals.

4. Normalize Units Across Fields

Ensure all monetary values are uploaded in the same unit (e.g., annual, monthly). Use a Frequency field to denote if values are:

• Annual

• Monthly

• Hourly

This enables fair comparisons and accurate forecasting.

5. Avoid Free Text in Numeric Fields

Do not enter salary data as text with symbols (e.g., "$50,000"). Use numeric values only (e.g., 50000) with separate fields for currency or frequency.

6. Validate Totals Before Upload

Sum each salary record to ensure: Total Compensation = Base + Bonus + Benefits + Allowances + Other This prevents mismatches in dashboards or when filtering for salary bands.

7. Secure Sensitive Information

Ensure salary files are access-controlled and uploaded by authorized users only.