30-min call with RobBook a proof-of-concept call
Job 02 · Bond desk

// Surety bond agencies · WIP schedule spreads

A contractor's WIP schedule and CPA statements, spread into your format and tied out.

Year-end statements and quarterly schedules arrive as PDFs and spreadsheets, and someone on your desk keys them into the agency's spread. In a free AI proof of concept, AI spreads copies of 20 to 30 files your team has already done and lists what doesn't tie. Your reviewer, the account manager who knows contractors' numbers best, sets each draft beside the spread your team built.

Book a proof-of-concept call30 minutes with Rob
Files already spread
20 to 30
Logins to your system or a surety's portal
None
Bonds decided by AI
None

// The one job

A schedule and a statement in. A tied-out spread for your desk.

A contractor's CPA sends the financial statements, often with a schedule of contracts in progress and one of completed contracts, and between statements the contractor sends its own work-in-progress schedule. An account manager moves all of it into your agency's format: contract price, cost to date, estimated gross profit, billings, and over and under billings for each job, beside the balance sheet and income statement lines the surety reads against them.

In the proof of concept, AI reads copies of those files and drafts the spread job by job. It works out earned revenue and over or under billings from the figures on the schedule, and lists every number that doesn't tie to the statement, with the page on each side. It doesn't change a figure, correct a CPA or judge the contractor.

WIP schedule and statementPDF from the contractor
Statement date
Level of CPA work
Basis
Open jobs
JobContract priceBilled to date
Made-up schedule, for illustration
Spread
and tied out
Agency spreadDraft
Balance sheet tie
Revenue tie
Over and under
Doesn't tie
JobEarnedOver / under
Made-up spread, for illustration

// What makes it hard

Where a spread comes apart

The columns depend on who built the schedule. SBA Form 994F, the schedule of work in process a small contractor gives its surety agent for a Surety Bond Guarantee application, has contract price including approved change orders, total billed to date including retainages with any disputes explained, total cost to date and total estimated cost to complete. It asks for all work, bonded and unbonded, with cost plus jobs noted, and SBA collects a new one on a Prior Approval application when more than 90 days have passed since the last. A CPA's schedule of contracts in progress uses different column names and a different order, and a contractor's own report may match neither. The draft maps each onto your format and lists anything it couldn't place.

What goes in a column is a rule. One surety's published instructions for its work-in-progress form say contract price and estimated cost should carry approved change orders only and leave out claims and disputed items. Unit price jobs get restated at the original price and cost per unit, costs leave out general and administrative overhead, billings and costs carry the same date, and estimated cost to complete has to be a revised figure, not merely a subtraction. Your format has its own version of those rules, and they go into the success criteria.

Tying out is most of the job. Under billings on the schedule should match the asset line the CPA uses for them, and over billings the matching liability. Revenue earned during the period, across open jobs and jobs finished in it, should add up to the income statement, and job costs to cost of revenue the same way. Job names and numbers have to agree between the contractor's report and the CPA's, which is the point one bond agency stresses in its advice to CPAs. A job that vanished from last quarter's schedule and isn't on the completed list is a question for the contractor. The draft shows each tie, both figures and the gap, and leaves the difference for your account manager to run down.

The statement says what the numbers mean. The level of the CPA's work belongs on every spread. A preparation engagement under the AICPA's AR-C 70 usually comes with no report, only a statement on each page that no assurance is provided; a compilation, a review and an audit sit above it. The basis matters as well, since a contractor's own cash-basis figures won't line up with a CPA's percentage-of-completion numbers until someone reconciles them. CPA notes under ASC 606 name the method used to measure progress, input or output, and give opening and closing balances of receivables, contract assets and contract liabilities unless they are shown separately, though a nonpublic company can leave out other quantitative detail. The draft records the statement date, the level of work and the basis from the page. It gives no accounting advice.

Underwriters adjust what a spread shows. A surety's published guidance to contractors lists soft assets it leaves out, among them goodwill, notes from shareholders or employees, deferred tax assets, restricted cash and receivables more than 90 days past due, and it asks for a CPA review or audit within 150 days of year-end, with internal numbers about 60 days after. A bond agency's note to CPAs adds that the 90-day cut doesn't count retention. A CPA firm's write-up warns that over billings stop being healthy when they turn into job borrow, one job's cash covering another's losses, so large over billings should show up as cash and receivables on the balance sheet. The draft marks what your format calls for and notes the dates. Whether an asset counts stays with the surety's underwriter.

// What you send

Files your desk has already spread

Copies only
Redacted or look-alike
01

20 to 30 spread files

CPA statements and work-in-progress schedules as they arrived, from several contractors and CPAs. Include one that didn't tie, one on an interim schedule and one scanned rather than exported.

02

The spreads your team built

The finished spread for each file, in your agency's format, with any notes that went to the surety. Those are the answer key.

03

Your format and its rules

Your spread template and how your desk treats approved change orders, retainage, cost plus jobs and joint ventures. A page of notes is enough.

04

NDA first, then copies

The NDA comes before any file moves. Contractor names can be redacted, and a file that can't leave the office becomes a look-alike built with your reviewer. Keep an owner's personal financial statement out of the sample, or redact it.

// Before it starts

Settled before the first statement moves

The owner puts each of these in writing first.

Terms for the spread testOwner's sign-off
Your reviewer
The owner's pick: usually the account manager who spreads the most contractors
Success criteria
Which fields must match, and how a gap on a tie-out is scored
Format
Your agency's spread, with your rules for change orders and retainage
Who decides
The surety's underwriter, on every bond
Price
A range for the live job, given before any file moves

// How it's judged

Your team's spread beside each draft

File by file
on the same statements
On the same 20 to 30 filesSpread your team builtThe AI draft
Contract price, cost to date and estimated gross profit on each jobFilled in on your filesFilled in on your files
Billings, and over and under billings, job by jobFilled in on your filesFilled in on your files
Totals tied to the balance sheet linesFilled in on your filesFilled in on your files
Revenue and cost tied to the income statementFilled in on your filesFilled in on your files
Statement date, level of CPA work and accounting basisFilled in on your filesFilled in on your files
Numbers that don't tie, listed with both figuresFilled in on your filesFilled in on your files
Jobs missing from either the schedule or the completed listFilled in on your filesFilled in on your files
No scores yet. Every cell waits until the test has spread your own files.Your reviewer marks each draft, and that decides it.

// After a yes

About 30 days on new statements

With your reviewer's yes, new schedules and statements go through the same job for about 30 days.

An account manager approves each spread before it goes to a surety or into your files. The AI never changes a contractor's numbers, adjusts an asset on its own or says anything about capacity; the surety's underwriter handles that.

Scoring continues on the same written criteria. Other jobs wait their turn, each with its own price, and monthly support follows.

// Possible next jobs

What could follow WIP spreads

Ideas, ranked
One at a time
  1. 01

    Bid bond requests

    Contractor requests read against the bid documents and summarized for the surety's underwriter.

    Next
  2. 02

    Interim schedule comparisons

    This quarter's schedule set beside last quarter's, with jobs added, dropped or changed listed for your account manager.

    Then
  3. 03

    Final bonds after award

    Award letters and contracts matched to the bid bond and the required forms.

    After that

// One hard limit

It never decides whether a bond gets written.

The draft spreads copies and lists what doesn't tie. It never touches your agency management system, a surety's portal or a live request, it uses redacted or look-alike contractor financials where the file can't leave, and it never issues a bond, sets capacity or corrects a CPA. An account manager checks every spread, and the surety's underwriter decides every bond.

Priced per job. You get a range before the proof of concept and a fixed price before you sign.

The range depends on how many contractors you spread in a year and how many arrive as scanned PDFs rather than spreadsheets.

// Questions

What surety account managers ask

Will it change a contractor's numbers to make them tie?
No. It copies each figure as printed and lists what doesn't agree, with both figures and the pages. Your account manager and the contractor or CPA sort out any difference.
Can it read a scanned CPA statement?
Scanned statements belong in the sample, since many arrive that way. Where a page or number can't be read, the draft marks the line instead of guessing, and your reviewer scores what it caught.
Our spread has its own format. Do you need it?
Yes, it is part of what you send. The draft fills your format using your rules for change orders and retainage, so your reviewer is comparing like with like.
What happens to an owner's personal financial statement?
It stays out of the sample or is redacted before anything moves. The test covers a contractor's company statements and work-in-progress schedules only.
Is this accounting or underwriting advice?
No. It is a document test. The contractor's CPA decides how the accounts are kept, and the surety's underwriter decides what counts and whether a bond gets written.
Rob Eason

Rob Eason, founder

// Book a proof of concept call

Start with contractors you've already spread.

Thirty minutes with Rob Eason. You'll share your agency and role, pick WIP schedule spreads as the job, and estimate how many contractors your desk spreads in a year. Keep every statement and schedule with you until the NDA is signed.

  • Co-owned a 60-employee financial services firm and sold his share to his partner.
  • Ran GOSO Technologies, a Boston solar company rated 5/5 across 24 Google reviews.
  • 5/5 across 83 reviews in HighLevel's Certified Admin Directory.
  • 4.3/5 from 6 Google reviews of Massmarket AI.
  • Every directory and Google review, critical ones included, is shown word for word at massmarket.ai/reviews.
  • Takes every proof-of-concept call himself.