Budget Planning

Compensation Audit AI

Upload allocation results to identify outliers, inconsistencies, misuse patterns, and budget inefficiencies before final approval.

IntegrationsBudget distributor, audit review, and manager reporting connections
InputsAllocation + policy data
Budget plans Salary ranges Performance
IntelligenceCompensation Audit AI
Risk flagsPolicy checksQA findings
Connected review
MeritManager ReportsLeadership

Audit findings flow into corrective planning, manager review, and leadership oversight.

Input
Excel Budget Distributor AI allocation workbook
Uses
Allocated Budget, Allocated Percent, current salary, manager, department, and range fields
Feeds
Merit Increase Planner AI corrections and Manager View Only reporting packets
Debug exportsSelect a workbook to export CompaAuditRows

Export the normalized CompaAuditRows workbook to inspect the row-level audit payload used by the compensation engine. This is useful for validating parsed allocation data, troubleshooting unexpected findings, and sharing a clean diagnostic file for support.

Example flag12 employees exceed range maximum after allocation
Example flag3 managers used more than 110% of budget
Example flag8 high performers received below-guideline increases
Example flag5 records have missing salary or performance data

Audit Coverage

  • Budget over-allocation
  • Zero or missing allocation values
  • Allocation percent outside policy range
  • Employees above salary range maximum
  • Employees below salary range minimum
  • High increases for low performers
  • Low increases for high performers
  • Department or manager budget concentration
  • Duplicate employee rows
  • Missing current salary, grade, manager, department, or performance rating

Required Workbook Columns

  • Employee Id
  • Employee Name
  • Department
  • Manager
  • Current Salary
  • Salary Range Minimum
  • Salary Range Midpoint
  • Salary Range Maximum
  • Performance Rating
  • Allocated Budget
  • Allocated Percent
  • New Salary

Pre-Upload Checklist

  • Confirm final allocation file is saved as .xlsx
  • Remove blank header rows
  • Use one employee per row
  • Confirm salary and allocation fields are numeric
  • Include manager and department fields for grouping analysis

Audit Severity Legend

CriticalLikely approval blocker
HighRequires HR/Comp review
MediumShould be validated before finalization
LowInformational cleanup item

What the Audit Workbook Includes

  • Executive Summary
  • AI Review Summary
  • Top Risks
  • Budget Exceptions
  • Policy Exceptions
  • Salary Range Issues
  • Manager / Department Outliers
  • Employee-Level Detail
  • Recommended Follow-Up Actions