Sharpe CPA / Footnotes / Contracts in progress
Written for the reader who sets the bonding line or the credit line. Enter the jobs from the work-in-progress schedule and the note builds itself — costs and estimated earnings, underbillings and overbillings, retainage, loss provisions, fade, and the backlog rollforward — with the schedules a surety expects. Free, and it runs in your browser.
The contractor
Contracts in progress
One row per job, from the work-in-progress schedule. Contract amount includes approved change orders. The prior-year columns are optional: they give this year’s revenue and the fade or gain on jobs carried over.
Contracts completed during the year
Receivables and retainage
Contract balances at the beginning of the year
Optional. Gives the opening and closing balances ASC 606-10-50-11 asks for.
Estimates, claims and losses
Backlog
What the surety or the bank will see
Not part of the note — the analysis a bonding company or lender runs on these figures. Equity and working capital are optional.
Highlighted text is still to be filled in or checked. The Word file adds the schedules of contracts in progress and completed contracts on landscape pages, as supplementary information.
Written for the surety and the bank
A contractor’s bonding capacity and its line of credit are set from these numbers. The surety underwrites the work in progress — whether the estimates hold, how much is underbilled, how much profit is left in the backlog — and the bank watches receivables, retainage and the cash tied up in underbillings. The note gives them the figures; the schedules give them each job.
See also the contractor Note 1. The surety ratios here are common practice, not GAAP; each surety sets its own. Check the references against the current text before relying on them; the CPA who signs the report owns every word.