How to Manage Team Salaries in AgencyIQ
Salary is usually your biggest line item. If you don't know who's paying for themselves, you're making growth decisions blind. This guide walks through recording every salary, tracking raises and ramps, and seeing the ROI per team member.
In this guide:
- What salary data to record
- Step-by-step: add a salary for a new hire
- How to record a raise (and why the dates matter)
- Where to see Employee ROI
- Archiving vs. ending a salary
Time to finish: 5 minutes per team member. Best for: Owners and office managers.
What salary data should I record?
Four pieces per team member:
| Field | What to enter |
|---|---|
| Amount | The dollar number |
| Pay type | Annual salary, hourly wage, or draw |
| Frequency | Weekly, bi-weekly, semi-monthly, monthly |
| Effective date | When this amount starts |
Tracking effective dates is the trick. When you give someone a raise, you don't replace the old salary — you add a new entry with a new start date. That way you can pull a report from 6 months ago and see what they were paid at the time.
Step 1 — Open the team member's profile
Go to Dashboard → Team and click the team member's name. Their profile opens.
Step 2 — Go to the Salary tab
On the profile, click the Salary tab. You'll see a list of every salary record for this person — blank if they're new.
Step 3 — Click Add Salary
In the top-right of the Salary tab, click Add Salary.
Step 4 — Fill in the form
Enter:
- Amount — the dollar figure
- Pay type — Annual / Hourly / Draw
- Frequency — how often they're paid
- Effective date — the day this amount starts
Click Save.
Example. A producer starting at $45,000 base with a draw: Amount $45,000, Pay type "Annual salary + draw," Frequency Bi-weekly, Effective date April 1.
How do I record a raise or salary change?
Don't edit the old entry. Add a new one.
Click Add Salary again. Enter the new amount and the effective date. AgencyIQ automatically ends the previous salary the day before the new one starts.
Why this matters. If you pull an Employee ROI report for March and the raise started April 1, the report uses the March salary — not the new one. Dates drive accuracy.
Can I record ramp-up plans for new producers?
Yes — by adding multiple entries with future effective dates.
New producers often have a salary that drops over time as they build their book. Common pattern:
| Month | Salary |
|---|---|
| Month 1–6 | $45,000 |
| Month 7–12 | $35,000 |
| Month 13–18 | $25,000 |
| Month 19+ | Full commission |
Add all four entries at once with their future effective dates. AgencyIQ applies each one when the date hits.
Where do I see Employee ROI?
On each producer's profile, in the ROI tab.
The ROI view shows:
- What you paid them (from salary history)
- What they earned in commission and wrote in premium
- The breakeven month — when their production cost the same as their salary
- The monthly net (production earned − salary paid)
What to look for. A healthy producer reaches breakeven in month 6–12 for a ramp hire, or immediately for an experienced hire with a book.
What's a healthy salary-to-production ratio?
For established producers: total pay (salary + commission) should be 30–45% of the commission they generate for the agency.
See What's a Healthy Salary-to-Revenue Ratio for full benchmarks.
What do I do when someone leaves?
End their salary record with an end date. Don't delete it.
Go to their Salary tab, click the active salary row, and add an End Date. Their salary record is preserved for historical reports.
Then archive the team member itself (see How to Invite and Set Up Your Team).
Can I track salaries for service staff and admin too?
Yes. Every team member has a salary record, regardless of role.
That matters for:
- Agency-wide payroll tracking
- Full-agency ROI (not just producers)
- Budget planning
Service and admin roles don't have commission, so their "ROI" is calculated differently — usually based on the revenue they help support (renewal retention they protect, policies they service).
Can other producers see each other's salaries?
No. Salary data is owner-and-admin only. Producers can't see teammates' salary or their own historical salary records.
Producers can see:
- Their current pay plan (commission structure)
- Their earned commission to date
- Their own paycheck summaries
They can't see salary history or anyone else's pay.
Frequently Asked Questions
Does AgencyIQ actually run payroll?
No — AgencyIQ tracks salary and commission for reporting and ROI. You still run payroll through your payroll provider (Gusto, ADP, Paychex, QuickBooks). AgencyIQ tells you what to pay; your payroll provider pays it.
Can I record bonuses separately from salary?
Yes. Bonuses earned through a commission plan are tracked automatically. One-off bonuses (like a holiday bonus) can be added on the Payouts page with a note.
What if a team member works on multiple pay types (base + hourly)?
Record the primary pay type (usually salary) and use the note field to document the hourly component. Or add a second "Hourly" entry alongside the salary entry.
How do I handle a producer who got a signing bonus?
Add the signing bonus on the Payouts page as a one-off entry. Don't fold it into their salary — signing bonuses are one-time, not recurring.
Can I see agency-wide total payroll?
Yes. On the Admin → Agency ROI page, you'll see total payroll paid per month across every team member. Useful for budget conversations.
Stop tracking salaries in a Google Sheet with 4 tabs
AgencyIQ is free during beta for Founding Members. Record every team member's salary, track raises with dates, and see who's paying for themselves — in one place.
Founding Members get grandfathered pricing when we launch paid tiers later this year.
Last updated: 2026-04-18