How to Fix a Sale on the Wrong Producer

You uploaded a sales file, and three sales ended up on the wrong producer. Happens in every agency. Here's how to fix it once and stop it from happening again.

In this guide:

• Why names don't match between your carriers and your software
• Step-by-step: fix one sale
• Step-by-step: add a name alias so it stops happening
• What to do when two producers have the same name

Time to finish: 5 minutes Best for: Owners and office managers.

Why do names get mis-matched in the first place?

Carriers write the same name in different ways. There's no industry-wide standard.

Here's how Jane Smith might show up across your files:

Four spellings, one person. In a spreadsheet, that means four separate tallies. In AgencyIQ, you set up aliases once and she always gets credit for her sales.

How does AgencyIQ match names automatically?

It uses fuzzy matching — it's tolerant of small differences.

AgencyIQ tries to match names with:

• Any word order (Smith Jane = Jane Smith)
• Any capitalization (JANE SMITH = Jane Smith)
• First initials (J. Smith = Jane Smith — if there's only one Smith on the team)
• Suffixes (Jane Smith Jr. = Jane Smith)

What happens at each confidence level

Step 1 — Find the sale in the Sales Log

Go to Data → Sales Log. Use the search bar or filter by date to find the sale.

Step 2 — Click the sale to open the edit window

Click any cell in the row. The edit window pops up with all the details.

Step 3 — Change the producer

Click the Producer dropdown and pick the right person. Click Save.

That's it — AgencyIQ updates the producer strip, pay numbers, and goal tracking in real time.

How do I stop the same problem from happening on future uploads?

Add a name alias. This tells AgencyIQ: "When you see this spelling, always route it to this producer."

Step 1 — Open the producer's team record

Go to Settings → Team Members and click the producer's name.

Step 2 — Scroll to Name Aliases

Near the bottom of their profile, you'll see a Name Aliases section.

Step 3 — Add the spellings you've seen

Type each spelling you want AgencyIQ to route to this producer. Press Enter between them.

Click Save. Every future upload with those spellings will route correctly.

Typical count: Most producers end up with 3–8 aliases. The list stops growing after your first couple of months.

What's the fastest way to build up all my aliases?

Fix them straight from the upload error list.

When an upload has rows it couldn't match, you get a list of "unknown producer" rows. Click each one, pick the right person from a dropdown, and AgencyIQ saves that spelling as an alias. No separate setup needed.

Most agencies build 80% of their alias list this way. You'll do the work once and never again.

What's the fastest way to build my alias list?

Let the upload errors teach you.

Every time you upload a sales file, the unmatched producer names land in the Unmapped Writers section on Settings → Team Members. Click each row, pick the right team member from the dropdown, and AgencyIQ saves that spelling as a permanent alias.

A 12-producer agency typically ends up with 50–80 aliases after the first few months. Each fix takes 5 seconds — and once saved, every future upload routes clean.

What about two producers with the same name?

The hard case. Every bigger agency has one.

You've got options:

1. Use a producer code or number. If your carrier files include a producer code, add that as the alias instead of the name. AgencyIQ will route on the code.
2. Add Sr. and Jr. (or I and II) to the team member names inside AgencyIQ. Make sure those suffixes also show up in your carrier exports.
3. Add a territory or office identifier. If John Smith in Tampa and John Smith in Orlando both write for your agency, the city can be the tiebreaker.

Heads up. If you skip this step, one of the two Johns will get every sale. Catch it before you run pay.

Does fixing the name change the pay?

Yes — as soon as you save.

Pay is calculated per producer. If a sale was on the wrong person, the wrong person's commission showed it. When you fix the attribution:

• The correct producer's dashboard updates
• Their monthly pace updates
• The next pay run uses the fixed data

If you've already run pay on the wrong attribution, you'll need to adjust the pay run. See How to Set Up Your First Commission Plan for how pay runs work.

Frequently Asked Questions

My carrier uses a producer number, not a name. Can I match on that?

Yes. Add the producer number as an alias the same way you'd add a name spelling.

What if a producer got married and changed their last name?

Keep both names as aliases on the same team member. Don't create a second record — that would split their sales history.

How accurate is the automatic matching?

On clean carrier files with distinct producer names, 98%+. On messy data, lower. Ten minutes of alias cleanup at the start gets you to near-perfect routing.

What if I upload a file before I've added my team?

AgencyIQ holds the unknown names on a pending list. When you add team members later, you can route the pending names to them — and all the historical sales reattach automatically.

Does this work for customer names too?

No — customer name matching is separate. It's used to link sales back to the internet lead that originated them. See How Lead-to-Sale Matching Works.

Stop fixing producer names every Monday morning

AgencyIQ is free during beta for Founding Members. Map every carrier's name format once, then every future upload routes clean.

Start free →

Founding Members get grandfathered pricing when we launch paid tiers later this year.

Last updated: 2026-04-18