The Library · Agents

The Reporter

Assembles the recurring report from systems that do not talk.

An agent that assembles the recurring report out of the systems that do not talk to each other, on schedule, and leads with what actually changed rather than restating what did not.

3 min read (core) · last reviewed

Somebody in your business spends several hours a week rebuilding a report they built last week, out of the same systems, in the same order, and mostly it says the same thing.

The job today

The report is due Monday, so Friday afternoon or Monday morning someone starts.

They export from one system. They export from another. The two do not agree, and reconciling them is a step everybody has stopped mentioning because it has always been there. They paste into the spreadsheet with the formulas in it, which one person built and only that person fully understands. They check the numbers that looked odd. They write a short commentary at the top. They send it.

Three things are true about this and everyone knows all three.

It takes hours, and those hours belong to someone senior enough to know what the numbers mean, which is exactly the person whose time is worth the most.

It is late or missing whenever that person is out, which tells you how robust the process really is.

And most weeks, most of it has not changed. The report is a full restatement of everything, every time, so the two things that actually moved are buried among the thirty that did not. People stop reading it, which is not laziness — it is a rational response to a document with a very low signal density.

What the agent does

It pulls from each system directly rather than through an export, applies the same reconciliations the person applied, and assembles the report on schedule whether or not anyone is at their desk.

That much is the easy half and it is what most people picture. The half that makes it worth doing is what it does next.

It compares this period to the last one and leads with what moved. Not every number — the numbers that changed by more than they normally change. Three lines at the top saying what is different this week, why it is different where the systems can tell, and what it means, followed by the full detail underneath for anyone who wants it.

Where two systems disagree, it says so out loud rather than quietly picking one. That disagreement is usually a real problem in the business wearing a costume, and surfacing it weekly is often more valuable than the report itself.

And when nothing meaningful changed, it is allowed to say that in a sentence. A report that can say "nothing moved this week that needs you" is trusted in a way that a report which always produces four pages is not.

What changes

The report arrives. On time, when the person who used to build it is on vacation, in the same format every period. That reliability is worth more than the hours saved.

The senior person stops assembling and starts explaining. Their contribution moves from producing the numbers to saying what to do about them, which is what you were paying for all along.

And it starts getting read. Because the top of it is three things that changed rather than thirty that mostly did not.

What it connects to

Every system the report draws from. Accounting, the operational system, payroll, the CRM, whatever else. Most have a proper connection available; the awkward ones are the spreadsheets that have quietly become systems of record, and those are worth identifying early because they are usually where the reconciliations live.

A decision about which system wins. When the field system says the job made money and accounting says it did not, one of them is right, and today somebody resolves it by hand every week using judgment they have never written down. Getting that written down is the real project, and it is the part that improves the business whether or not you build anything.

Your definitions. What counts as revenue, when a job is complete, which costs are allocated where. These are usually consistent in one person's head and inconsistent across the systems. This is the second conversation, and it is the one that occasionally uncovers that two departments have been measuring the same thing differently for years.

And a delivery path — the inbox, the chat channel, a page people can open. Where it lands determines whether it is read, and the report going somewhere people already are beats the best-designed dashboard nobody opens.

You probably need this if

Where this shows up

The same agent, in businesses that describe it completely differently.

Trades and home services

Commercial cleaning and janitorial

  • Labor cost per site against contract value, so unprofitable buildings are visible
  • Inspection scores by site and supervisor
  • Turnover and coverage gaps by region

Garage doors and overhead

  • Revenue per truck and per technician
  • Quote approval rate by technician and job type
  • Project margin against estimate on commercial work

HVAC, plumbing and electrical

  • Weekly numbers assembled from the field service platform and QuickBooks, which disagree
  • Job costing that shows which job types actually make money after truck time
  • Callback rate by technician and by job type

Landscaping and lawn care

  • Job costing by property, so unprofitable accounts are visible before renewal
  • Crew hours against estimated hours by route
  • Enhancement revenue by account manager

Pest control

  • Route density and revenue per hour by technician
  • Cancellation rate and reasons by branch
  • Recurring revenue and lapses month over month

Restoration and remediation

  • Jobs by stage and by carrier program, with what is holding each
  • Equipment utilization and billing days against equipment deployed
  • Cycle time against program scorecards

Roofing and exteriors

  • Jobs by claim stage, and where each one is stuck
  • Supplement approval rate by carrier and by estimator
  • Job costing that includes supplements, so you know the real margin

Security and low voltage

  • Recurring monthly revenue, attrition and net growth
  • Project margin against estimate by job
  • Service response times against contract commitments

Construction and real property

Architecture and engineering

  • Fee earned against hours spent by project and phase
  • Utilization and realization by staff
  • Backlog and projected workload against capacity

Civil and site work

  • Production against bid by cost code, updated daily rather than monthly
  • Equipment utilization and cost against internal rates
  • Projected cost to complete and margin by job

Commercial subcontracting

  • Labor productivity against estimate by cost code
  • Job cost to complete and projected margin by project
  • Change order volume and approval rate by general contractor

General contracting

  • Weekly job cost against budget, reconciled between the PM platform and accounting
  • Which projects are trending over and how early the signal appeared
  • Certified payroll assembled from timecards on schedule

Mortgage lending

  • Pipeline by stage, with pull-through and turn times
  • Volume and margin by loan officer, product and referral source
  • Files stalled and where they are stuck

Property management

  • The monthly owner packet, assembled and explained rather than exported
  • Delinquency by property, with what has already been attempted
  • Maintenance spend by property and by vendor over time

Real estate brokerage

  • Pipeline by stage and projected closings by month
  • Lead source performance and cost per closed transaction
  • Agent production and split position against cap

Title and escrow

  • Orders, closings and revenue by source and by escrow officer
  • Cycle time from order to close, and where files stall
  • Outstanding post-closing and policy issuance backlog

Manufacturing and distribution

Contract manufacturing

  • On-time delivery and quality performance by customer
  • Quoted versus actual cost by part and program
  • Scrap, yield and downtime by work center

Equipment dealers and rental

  • Absorption rate, service profitability and technician efficiency
  • Rental utilization and revenue per unit
  • Inventory aging and floorplan cost by unit

Food and beverage production

  • Yield, giveaway and cost per unit by production run
  • Retailer chargebacks by type and root cause
  • Quality holds and release cycle time

Job shops and machining

  • Quoted versus actual cost by part, so estimating learns from what happened
  • On-time delivery by customer, assembled without anyone building it
  • Machine and work center utilization against what was scheduled

Wholesale distribution

  • Margin by customer and by product line, assembled without a spreadsheet
  • Fill rate and backorder aging by supplier
  • Which customers are buying less than they were, before anyone notices

Health and care

Behavioral health

  • Utilization, no-show rate and cancellation patterns by clinician and slot
  • Outcomes from standardized assessments over time
  • Days in accounts receivable and denials by payer

Dental practices

  • Production, collection and case acceptance by provider
  • Schedule utilization and open time for the coming two weeks
  • Unscheduled treatment value sitting in the system

Home health and hospice

  • Visit completion and missed visit rate by caregiver and patient
  • Caregiver retention and time to fill open shifts
  • Days in accounts receivable by payer

Med spas and aesthetics

  • Revenue and retention by treatment type and provider
  • Package and membership redemption liability
  • Marketing spend against booked and completed treatments

Medical practices

  • Denials by payer and reason, so the pattern is visible
  • Schedule utilization, no-show rate and open capacity
  • Days in accounts receivable by payer

Physical and occupational therapy

  • Visits per plan of care and completion rate by therapist
  • Cancellation and no-show rate by time slot
  • Denials by payer and reason

Senior living

  • Occupancy, move-ins, move-outs and net census against budget
  • Care level mix and revenue per occupied unit
  • Agency labor use and overtime against staffing plan

Veterinary practices

  • Revenue per visit, compliance rates and preventive care uptake
  • Schedule utilization and open capacity by doctor
  • Inventory turns and dispensing margin

Professional and financial services

Accounting and CPA firms

  • Season progress by preparer, stage and deadline, updated without anyone building it
  • Realization by client and by service line
  • Which clients have not been contacted about planning before year end

Consulting firms

  • Utilization and realization by consultant and by engagement
  • Pipeline against capacity for the next quarter
  • Engagement profitability including unbilled time and expenses

Financial advisory and RIAs

  • Assets, flows and revenue by advisor and household
  • Client service activity against the service model each tier was promised
  • Pipeline and onboarding status

Insurance agencies and brokerages

  • Book of business by carrier, line and producer, without a spreadsheet
  • Retention and hit ratio by producer, assembled monthly
  • Which accounts are approaching renewal without any recent contact

IT services and MSPs

  • Ticket volume, response and resolution by client and technician
  • Effective hourly rate by contract, so unprofitable clients are visible
  • Security and backup posture per client, assembled on schedule

Law firms

  • Realization and write-offs by matter type and by attorney
  • Matters by stage, with what is holding each one
  • Origination and referral sources, tracked without anyone maintaining it

Marketing and creative agencies

  • Client profitability, comparing recorded time against retainer value
  • Campaign performance across platforms, assembled on a schedule
  • Utilization by person and capacity for the coming month

Staffing and recruiting

  • Submissions, interviews and placements by recruiter and by client
  • Fill time and fall-off rate by job type
  • Gross margin by placement and by client

Transport and logistics

Courier and last mile

  • Cost per stop and margin by customer and route
  • On-time performance against each contract's service level
  • Driver productivity and stop density

Freight brokerage

  • Margin by lane, customer and rep
  • On-time performance by carrier
  • Quote-to-book conversion by customer and lane

Moving and storage

  • Lead conversion by source and estimator
  • Revenue per truck day and per crew hour
  • Claims frequency and cost by crew

Trucking and fleets

  • Revenue per mile by lane, customer and driver
  • Deadhead and utilization by unit
  • On-time performance by customer

Consumer and retail

Auto and powersports dealerships

  • Gross by department, unit and salesperson
  • Service absorption, effective labor rate and technician efficiency
  • Lead source performance through to delivered units

Auto repair and collision

  • Effective labor rate, technician efficiency and hours sold per repair order
  • Approval rate by advisor and by recommendation type
  • Cycle time and parts delay by supplier

Catering and events

  • Event profitability including labor, rentals and food cost
  • Inquiry to booking conversion by source and season
  • Booking pace against the same period last year

E-commerce and DTC

  • Contribution margin by product after ad spend, shipping and returns
  • Cohort retention and repeat purchase behavior
  • True channel performance reconciled against actual orders

Funeral homes

  • Case volume by type, service mix and average revenue
  • Preneed pipeline and funding position
  • Referral sources and their contribution

Gyms and fitness studios

  • Churn, retention and lifetime value by membership type
  • Class utilization by time slot and instructor
  • Lead conversion by source

Hotels and lodging

  • RevPAR, ADR and occupancy against pace and last year
  • Channel mix and true net revenue after commission
  • Housekeeping and maintenance turnaround times

Independent retail

  • Sell-through and margin by category, vendor and season
  • Slow-moving inventory and its carrying cost
  • Sales by hour, so staffing matches traffic

Restaurants and food service

  • Food and labor cost against sales, daily rather than monthly
  • Item-level profitability and menu mix
  • Delivery platform net revenue after all fees

Salons and spas

  • Rebooking rate, retail attachment and average ticket by stylist
  • Chair utilization and gap analysis by day and time
  • New client retention past the second visit

Self storage

  • Occupancy, street rate and economic occupancy by facility
  • Delinquency aging and lien pipeline
  • Rate increase acceptance and move-out response

Community, education and public

Associations and member organizations

  • Membership growth, retention and lapse by category
  • Event registration pace against prior years
  • Non-dues revenue by source against budget

Childcare and early education

  • Enrollment, capacity and revenue by classroom
  • Ratio compliance and staffing cost against enrollment
  • Waitlist depth by age group and projected openings

Churches and faith organizations

  • Attendance, giving and engagement trends by household
  • Volunteer coverage and gaps by ministry
  • Guest to member conversion over time

Municipal and public sector

  • Service request volume, response time and backlog by department
  • Budget against actual by fund and department
  • Permit activity and revenue against prior periods

Nonprofits

  • The board packet, assembled from finance, program and development data
  • Donor retention, acquisition and lifetime value
  • Program outcomes in the format each funder requires

Private and charter schools

  • Admissions funnel by stage, with yield against last year
  • Re-enrollment and attrition by grade
  • Advancement progress against goal by constituency

Trade schools and training providers

  • Enrollment funnel by source, with cost per enrolled student
  • Retention and completion by cohort and program
  • Placement rate and verification status for reporting

Worth a conversation?

Start a conversation