Most independent adjusting firms can tell you their total outstanding receivables. Far fewer can tell you, without a long export-and-pivot exercise, how much revenue a single adjuster generated, how much of it was actually billed, and how much has been collected. Yet that is the number that tells you whether your busiest field adjuster is also your most profitable, whether work is slipping through to invoices that never went out, and whether a carrier is quietly slow-paying everything one person touches.

Reconciling receivables by adjuster is the discipline of closing three gaps for each person who works claims: the gap between work done and work billed, the gap between what the fee schedule says and what was invoiced, and the gap between what was invoiced and what was paid. Do it well and receivables stop being a monthly scramble and become a management tool for the whole book.

The steps below are deliberately tool-agnostic. You can run this with spreadsheets and a lot of discipline, or you can run it inside a system that already keeps claims, invoices, and adjusters connected. Either way, the sequence is the same.

Six steps to reconcile receivables per adjuster

Work claim by claim, adjuster by adjuster. The order matters: each step depends on the one before it.

  1. Tie every claim to the adjuster who worked it

    Reconciliation starts with attribution. Each closed and in-progress claim needs a clear owner: the adjuster whose work generated the fee. For claims handled by more than one person, decide on a consistent rule up front (credit to the closing adjuster, or split by hours on time-and-expense files) and apply it the same way every cycle.

    If your claims and your billing live in different places, this is where most reconciliation breaks. The claim number is your join key. Make sure every invoice can be traced back to a claim, and every claim back to an adjuster, before you try to total anything.

  2. Pull each adjuster's completed-but-unbilled work

    Before you reconcile what was billed, find what should have been billed. Run an unbilled-work view for each adjuster: closed claims, with completed work, that have no invoice attached. This is the work-done-vs-work-billed gap, and it is where earned revenue most often disappears.

    Group it by adjuster and by carrier so you can see patterns. A single adjuster with a stack of uninvoiced closed claims usually points to a documentation or hand-off problem, not a billing one.

  3. Recalculate the expected fee from the carrier's schedule

    For each billed claim, independently work out what the fee should be under that carrier's current fee schedule, then compare it to the amount that was actually invoiced. You are checking two things at once:

    • Flat-rate claims billed at the correct tier for the claim amount
    • Time-and-expense claims billed at the right hourly rate and mileage, with all logged T&E captured

    Underbilled claims are silent revenue leaks. Overbilled claims are a carrier-relationship risk. Both are easiest to catch when the expected fee is derived from a single saved schedule rather than re-keyed from memory each time.

  4. Match invoiced amounts to payments received

    Now close the invoiced-vs-paid gap. For each adjuster's invoices, match payments against them and flag the differences: full payments, partial payments, and short-pays where the carrier remitted less than billed. Short-pays are worth special attention; a recurring shortfall on one carrier often means a fee-schedule disagreement you can correct going forward.

  5. Age the open balance and separate slow from stalled

    Whatever remains unpaid is your live receivable. Age each open invoice from its send date into current, 30, 60, 90, and 120+ day buckets, and read it against each carrier's normal payment rhythm. A carrier that typically pays in 45 days sitting at 50 is slow but expected; the same carrier at 120+ is an exception worth escalating. Viewing aging by adjuster, not just by carrier, surfaces whether stalled invoices cluster around one person's claims.

    For a deeper treatment of this step, see how to track invoice aging across carriers.

  6. Roll up earned, billed, and collected per adjuster

    Finally, summarize each adjuster into three numbers: revenue earned (including anything still unbilled from step 2), revenue billed, and revenue collected. The gaps between them are the whole point. A wide earned-to-billed gap is a workflow problem; a wide billed-to-collected gap is a follow-up problem. Track these per adjuster over time and they become an honest read on who is carrying the load and how cleanly their work turns into cash, which is exactly what you need for staffing decisions and 1099 payouts.

Spreadsheets vs. a connected operating view

The steps above are simple in principle. What makes them painful is keeping claims, fee schedules, invoices, and adjusters connected long enough to total them.

Reconciling by hand

  • Adjuster attribution lives in someone's head or a column that is easy to mistype
  • Expected fees are re-keyed from memory, so underbilling goes unnoticed
  • Aging has to be rebuilt by hand every time someone asks "what's outstanding?"
  • Revenue per adjuster only exists after a long export-and-pivot session

One operating view

  • Every invoice stays tied to its claim and the adjuster who worked it
  • Fees calculate from a saved carrier schedule, so expected vs. billed is automatic
  • Aging buckets update from each invoice's send date without rebuilding
  • Earned, billed, and collected roll up by adjuster and by carrier on demand

Keep the join intact end to end

Reconciling by adjuster only stays accurate when the link between claim, adjuster, fee schedule, invoice, and payment never breaks. FileRidge is operations software for IA firms that keeps each invoice tied to the claim and the adjuster who worked it, calculates the fee from the carrier's saved schedule, ages every invoice from its send date, and rolls revenue and outstanding balances up by adjuster and by carrier. The six steps above stop being a monthly project and become a view you can open. It is one surface of a broader platform that brings claims, files, receivables, and daily follow-ups into a single operating picture for the firm.

Reconciling receivables by adjuster

What does it mean to reconcile receivables by adjuster?

It means tying every billed claim back to the adjuster who worked it, then comparing the fee that should have been charged under the carrier's schedule to what was actually invoiced and what the carrier actually paid. The goal is a clean view of earned, billed, and collected revenue per adjuster, so you can see who is producing, where invoices stalled, and where money was left on the table.

Why reconcile revenue per adjuster instead of just firm totals?

Firm totals tell you whether cash is coming in, but not why. Reconciling per adjuster shows throughput and billed revenue by person, which helps with staffing, 1099 payouts, and spotting gaps between work completed and money collected on a specific adjuster's claims. It turns receivables from a bookkeeping task into a way to manage the book of business.

How does FileRidge help reconcile receivables by adjuster?

FileRidge keeps each invoice tied to the claim and the adjuster who worked it, calculates the fee from the carrier's saved fee schedule, ages each invoice from its send date, and rolls revenue and outstanding balances up by adjuster and by carrier. That keeps earned, billed, and collected amounts connected in one operating view instead of spread across spreadsheets and portals.

See revenue per adjuster the way an operator should

We'll walk through how your firm attributes claims, bills carriers, and tracks collections today, and how FileRidge keeps earned, billed, and collected revenue connected by adjuster in one view.

Explore more: Receivables & invoice aging · Track invoice aging across carriers · IA firm software · Pricing