// 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.
- 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.
and tied out
// 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
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.
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.
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.
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.
- 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
| On the same 20 to 30 files | Spread your team built | The AI draft |
|---|---|---|
| Contract price, cost to date and estimated gross profit on each job | Filled in on your files | Filled in on your files |
| Billings, and over and under billings, job by job | Filled in on your files | Filled in on your files |
| Totals tied to the balance sheet lines | Filled in on your files | Filled in on your files |
| Revenue and cost tied to the income statement | Filled in on your files | Filled in on your files |
| Statement date, level of CPA work and accounting basis | Filled in on your files | Filled in on your files |
| Numbers that don't tie, listed with both figures | Filled in on your files | Filled in on your files |
| Jobs missing from either the schedule or the completed list | Filled in on your files | Filled in on your files |
// 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
- 01Next
Bid bond requests
Contractor requests read against the bid documents and summarized for the surety's underwriter.
- 02Then
Interim schedule comparisons
This quarter's schedule set beside last quarter's, with jobs added, dropped or changed listed for your account manager.
- 03After that
Final bonds after award
Award letters and contracts matched to the bid bond and the required forms.
// 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?
Can it read a scanned CPA statement?
Our spread has its own format. Do you need it?
What happens to an owner's personal financial statement?
Is this accounting or underwriting advice?

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.
