The Scenario
You are an HR business partner. The annual pay review cycle starts in three weeks. The compensation committee has asked for a salary audit across all six departments before the review meetings begin, so they can spot pay-band gaps and inconsistencies before making any decisions.
You need every employee's name, department, salary, salary basis, and effective date in one Google Sheet. BreatheHR has it all. Getting it out in a usable form is the question.
The slow version:
- Export the salary report from BreatheHR
- Import it into Google Sheets
- Realize the export only shows current salaries, not the effective date
- Go back and find where effective dates live in BreatheHR
- Export that separately
- Merge the two exports
- Notice that twelve employees have multiple salary records because they were promoted mid-year
- Decide which record is current for each
- It is a week before the pay review cycle and you have not started the analysis.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects to BreatheHR and pulls the salary audit table you need, already resolved to one row per employee.
Open the SheetXAI sidebar and type:
Pull all BreatheHR employee salaries into this sheet. Include employee name, department, salary amount, salary basis, and effective date. Where an employee has multiple salary records, keep only the most recent one. Sort by department, then by salary amount descending.
SheetXAI calls BreatheHR, resolves multiple salary records to the current one, and writes the sorted audit table into your sheet. One pull, one row per employee, three weeks before the review cycle instead of one.
What You Get
A salary audit table ready for the compensation committee:
- Employee name — from the BreatheHR record
- Department — current department assignment
- Salary amount — current salary, one value per employee
- Salary basis — annual, hourly, or daily as recorded
- Effective date — when the current salary came into force
Pay-band gaps are visible immediately. Sort by salary within each department and the outliers are the first rows you see.
The compensation committee can mark up the sheet directly. When they are done, ask SheetXAI to push the approved changes back to BreatheHR as change requests.
What If the Data Is Not Quite Ready
Pay audit tables for review cycles need more than raw numbers. SheetXAI adds the analysis in the same prompt.
When salary basis is mixed and the committee needs like-for-like comparison
Some employees are paid hourly, some annually. Comparing them directly is misleading.
Pull all BreatheHR employee salaries. Where salary basis is "Hourly," calculate annual equivalent assuming 37.5 hours per week and 52 weeks, and put that in a new column called "Annual Equivalent." Where basis is "Annual," copy the salary directly. Sort by department, then by annual equivalent descending.
When the committee wants to see how long ago each salary was last updated
An effective date alone does not tell you if a salary has been untouched for three years.
Pull all BreatheHR employee salaries with effective date. Add a column showing how many months have passed since the effective date, using today as the reference. Flag any employee whose salary has not been updated in more than 24 months.
When you need the audit grouped by pay band rather than department
The CFO wants a pay-band breakdown across the whole company, not a department view.
Pull all BreatheHR employee salaries (annual equivalent where needed). Assign each employee to a pay band: "Under £30k," "£30k–£50k," "£50k–£75k," "Above £75k." Add a summary table at the top showing headcount per pay band and average salary per band.
When the compensation committee wants a gap analysis against market benchmarks
You have a Benchmarks tab with target salary ranges per job title. The audit should flag anyone paid below the lower bound.
Pull all BreatheHR employee salaries. Join each employee to the Benchmarks tab by job title. Add a "Gap" column showing how far the employee's salary is below the lower bound of their benchmark range (negative means below, zero means within range). Flag any employee more than 10% below the lower bound.
The pattern: instead of pulling a raw export and building the analysis separately, you describe the audit you need and SheetXAI builds it, data and analysis together.
Try It
Get the 7-day free trial of SheetXAI and open any compensation or salary sheet, then ask it to pull the full BreatheHR salary export. The BreatheHR integration is included in every SheetXAI plan. For related workflows, see how to export the full employee directory or the BreatheHR in Google Sheets overview.