Complete AI Training
Sign inGet my AI kit

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

AI agent for actors

Residual and Agent Commission Reconciliation Agent

A monthly reconciliation that ties every payment to a booking and lists missing or wrong amounts

Residual and Agent Commission Reconciliation Agent: what goes in, what the agent does and what you get

What it does

Actors get paid through agents, payroll companies and residual checks that arrive months after the work. Matching each payment to a booking is tedious, so errors slip by. Each month this agent reads payroll stubs, residual statements and the agent's commission statement, and matches every payment to a booking in your log. It recalculates commission at the agreed rate and checks residuals against expected airings when the production reports them. Payments that do not match go into a follow-up list. After matching, it checks that totals per job equal gross pay minus commission and withholding. If they do not, it recalculates by line and looks for split payments. It drafts questions to the agent or payroll company, but you send them. Edge case: commission should not be taken on some residuals, so it uses your contract terms per job.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueYes, continueApprovedNoNo 1 STARTS WHEN New month begins 2 USES A TOOL Import agent statements, payroll stubs and residualstatements 3 DOES Match each payment to a booking by production, dateand gross 4 CHECKS THE RESULT Is every payment matched to a booking? If not: try matching split payments and alternateproduction names, then list the rest as unknown. Back tostep 3. 5 DOES Recalculate commission per payment from contractterms 6 CHECKS THE RESULT Do net totals per job equal gross minus commissionand withholding? If not: recalculate line by line and mark the exact linethat differs. Back to step 5. 7 DOES List bookings with expected payments that neverarrived 8 USES A TOOL Draft questions to the agent and payroll companies 9 YOU APPROVE Actor reviews and sends the questions 10 RESULT Monthly reconciliation sheet
Read the steps as a list
  1. New month begins
  2. Import agent statements, payroll stubs and residual statements
  3. Match each payment to a booking by production, date and gross
  4. Is every payment matched to a booking?If not: try matching split payments and alternate production names, then list the rest as unknown. Back to step 3.
  5. Recalculate commission per payment from contract terms
  6. Do net totals per job equal gross minus commission and withholding?If not: recalculate line by line and mark the exact line that differs. Back to step 5.
  7. List bookings with expected payments that never arrived
  8. Draft questions to the agent and payroll companies
  9. Actor reviews and sends the questionsThe agent waits here for your OK.
  10. Monthly reconciliation sheet

How it decides

A payment is matched when production, date and gross agree with a booking within a small tolerance. A commission is wrong when it differs from the contract rate on that payment type.

  • Match within a 1% tolerance on gross
  • Flag commission that differs from the contract rate by any amount over 5 units of currency
  • Flag a booking as unpaid when no payment arrives 45 days after the wrap date
  • Treat residuals as no-commission when the contract says so

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Commission rates per job type
  • Days before a booking counts as unpaid (default 45)
  • Matching tolerance (default 1%)
  • Which statements to import
  • Report format (sheet or summary)

What keeps you in control

It always asks you first

  • Sending any query to the agent, union or payroll company

Hard limits

  • Never contact the agent or payroll company directly
  • Never share bank details in drafts

It stops when

  • Done: all payments matched or listed with a drafted question
  • Stop: statements missing for the month, asks the actor to upload them

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensIn April, the agent matched 11 of 13 payments. One 412.50 residual had no booking until the loop tried the series working title, which matched. The commission check then failed on a 2,400 commercial session fee where 15% was taken instead of the contract 10%. The agent drafted a note asking the agent for 120 back. The actor approved and sent it.

More agents for actors