A buyout log that counts only real savings.
One row per bid package from budget to executed subcontract. Each award is leveled for the scope the bidder left out, so the savings you report are savings, and packages that are late or over budget flag themselves.
What’s in the workbook
The download is one Excel file (77 KB) with 3 sheets: Instructions, Buyout log, Summary. The formulas are live, the inputs are marked, and it opens in Excel for Windows and Mac, Excel for the web, Google Sheets and LibreOffice. This is the Buyout log sheet with the sample data:
Formula in I5: =IF(H5="","",C5-H5)| A | B | C | D | E | F | G | H | I | J | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Buyout log | |||||||||||
| 2 | Project | Riverside Medical Center (sample) | As of | |||||||||
| 3 | Blue cells on yellow are inputs. One row per bid package. Leveled buyout cost = award + the scope gaps you carry for exclusions. Savings = buyout budget − leveled cost. Sample data is illustrative. | |||||||||||
| 4 | Cost code | Scope / bid package | Buyout budget | Status | Vendor | Award amount | Scope gaps carried | Leveled buyout cost | Savings / (loss) | Savings % | Days to need-by | Flag |
| 5 | 03-3000 | Cast-in-place concrete | $2,240,000 | Executed | Summit Concrete | $2,105,000 | $18,000 | $2,123,000 | $117,000 | 5.2% | ||
| 6 | 05-1200 | Structural steel and deck | $1,960,000 | Executed | Northline Steel | $1,885,000 | $0 | $1,885,000 | $75,000 | 3.8% | ||
| 7 | 07-5400 | Roofing | $610,000 | Executed | Apex Roofing | $598,000 | $0 | $598,000 | $12,000 | 2.0% | ||
| 8 | 08-4100 | Storefront and glazing | $430,000 | Awarded | ClearSpan Glass | $412,000 | $9,500 | $421,500 | $8,500 | 2.0% | ||
| 9 | 09-2900 | Gypsum board and framing | $2,960,000 | Executed | Metro Interiors | $3,120,000 | $0 | $3,120,000 | ($160,000) | -5.4% | Bought out over budget | |
| 10 | 22-1000 | Plumbing | $1,720,000 | Executed | Riverside Plumbing | $1,668,000 | $12,000 | $1,680,000 | $40,000 | 2.3% | ||
| 11 | 23-0000 | HVAC | $3,100,000 | Leveling | 14 | Award due in 14 days | ||||||
| 12 | 26-0500 | Electrical | $3,820,000 | Awarded | Bright Electric | $3,760,000 | $25,000 | $3,785,000 | $35,000 | 0.9% | ||
| 13 | 09-3000 | Tiling | $540,000 | Bidding | 28 | |||||||
| 14 | 09-9100 | Painting | $380,000 | Not started | 42 | |||||||
| 15 | 10-2800 | Toilet accessories and partitions | $145,000 | Not started | -7 | Past need-by date | ||||||
| 16 | ||||||||||||
| 17 | ||||||||||||
Sheets
- Instructions
- What each column means, how leveling works and how to set the savings split.
- Buyout log
- 40 rows with status and date checks, leveled cost, savings, days to need-by and flags.
- Summary
- Packages and budget by status, share bought out, net, gross savings and overruns, late packages and the contract savings split.
Built in
- Live formulas: change an input and every total, flag and chart updates
- Frozen header rows and columns, so labels stay put as you scroll
- Drop-down lists and value checks on the input cells
- Conditional formatting for flags and overruns
- An Instructions sheet with every column defined
- Prints landscape, one page wide, with the header row repeated
Worked example: eleven packages on Riverside
Illustrative log from the sample file, as of 11/2/2026. $13,740,000 of budget is bought out, 76.7% of the $17,905,000 buyout budget, at a leveled cost of $13,612,500: net savings of $127,500.
The net hides a bad package. Gypsum board was bought out ($160,000) against its budget after the low bidder dropped, so gross savings of $287,500 shrink by $160,000 of overruns.
HVAC is still being leveled and is due within two weeks; toilet accessories are -7 days past the need-by date. With a 25.0% contractor share of savings, the contractor keeps $31,875 and $95,625 goes to the owner under the contract.
The formulas in the file
Leveled buyout costBuyout log · H5
=IF(OR($A5="",F5=""),"",F5+N(G5))Award amount + the scope gaps carried for the bidder’s exclusions.
Savings / (loss)Buyout log · I5
=IF(H5="","",C5-H5)Buyout budget − leveled buyout cost.
FlagBuyout log · M5
=IF($A5="","",IF(AND(OR(D5="Awarded",D5="Executed"),F5=""),"Award amount missing",IF(AND(I5<>"",N(I5)<0),"Bought out over budget",IF(AND(L5<>"",N(L5)<0),"Past need-by date",IF(AND(L5<>"",N(L5)<=14),"Award due in 14 days","")))))Award amount missing, bought out over budget, past need-by date or award due within 14 days.
Net buyout savingsSummary · B16
=B13-B15Budget bought out − leveled cost of those packages.
Contractor shareSummary · B26
=MAX(0,B16)*B25Positive net savings × the contractor share from your contract.
Buyout log template: printable version
os.construction · free template- Project
- Job #
- As of
- Kept by
Buyout log (sample rows)
| Cost code | Scope / bid package | Buyout budget | Status | Award amount | Scope gaps carried | Leveled buyout cost | Savings / (loss) | Days to need-by | Flag |
|---|---|---|---|---|---|---|---|---|---|
| 03-3000 | Cast-in-place concrete | $2,240,000 | Executed | $2,105,000 | $18,000 | $2,123,000 | $117,000 | ||
| 05-1200 | Structural steel and deck | $1,960,000 | Executed | $1,885,000 | $0 | $1,885,000 | $75,000 | ||
| 07-5400 | Roofing | $610,000 | Executed | $598,000 | $0 | $598,000 | $12,000 | ||
| 08-4100 | Storefront and glazing | $430,000 | Awarded | $412,000 | $9,500 | $421,500 | $8,500 | ||
| 09-2900 | Gypsum board and framing | $2,960,000 | Executed | $3,120,000 | $0 | $3,120,000 | ($160,000) | Bought out over budget | |
Sample rows are illustrative and marked for deletion. Your contract, drawings and specifications govern. Template from os.construction/resources/templates/buyout-log
Using the buyout log template
- List every bid package with its cost code and buyout budget before bidding starts, and set the need-by award date from the procurement schedule (long-lead items first).
- Move the status along as packages go out, come in and get leveled. Leveling means adding back the cost of anything a bidder excluded that you still have to buy.
- When you award, enter the award and the scope gaps you carry. The log computes the leveled cost and the saving or overrun against the budget.
- Review the flags weekly: packages bought out over budget, awards past their need-by date and awards due within 14 days.
- Use the Summary in the monthly cost review: share of the budget bought out, net savings and, on GMP or cost-plus work, the split your contract sets between owner and contractor.
- Package budgetedEstimate carried to the budget
- BiddingBid package issued
- LevelingExclusions priced back inRebid the scope: back to “Bidding”
- AwardedSavings or overrun known
- ExecutedSubcontract or PO signed
Text version
- Package budgeted: Estimate carried to the budget
- Bidding: Bid package issued
- Leveling: Exclusions priced back in
- Awarded: Savings or overrun known
- Executed: Subcontract or PO signed
Rebid the scope: from “Leveling” back to “Bidding”.
Do this in os.construction instead of a spreadsheet
In os.construction, Bidding takes a bid package from invitation to submitted quotes, award review and a draft commitment with the cost codes and amounts carried over. From the award receipt, the buyout review compares the award with a captured Budget snapshot by cost code, showing revised budget, prior committed and direct cost, headroom and variance per code before you approve the buyout plan. Budget modifications move the savings between lines, so contingency and buyout transfers stay visible.
Try it on the sample project
Every trial workspace includes a sample project to run this workflow on. 14-day free trial. Pricing for paid plans isn't set yet.
Questions about the buyout log template
What is buyout in construction?
Buyout is the period after award when the contractor turns its estimate into signed subcontracts and purchase orders, package by package. The goal is to commit the whole job, on time, for no more than the budget carried for each scope.
How are buyout savings calculated?
Buyout savings = the budget for a scope − the leveled cost of buying it, where leveled cost is the award plus the cost of anything the bidder excluded that you must still buy. A low bid with exclusions is not a saving until those gaps are priced back in.
Who keeps buyout savings on a GMP job?
The contract decides. Some GMP contracts return savings to the owner, some move them into contingency and some split them between owner and contractor. The Summary sheet applies the contractor share you enter from your contract.
When should buyout be finished?
Each package should be awarded by the date the schedule needs it, counting submittal review, fabrication and delivery. Long-lead packages like switchgear, elevators and curtain wall come first; the log flags any package past its need-by date.
Should buyout overruns be netted against savings?
Report both. Net savings tell you where the job stands; gross savings and gross overruns show whether one bad package is hiding behind several good ones. The Summary shows all three.
Keep going
- Pillar guideBidding to an awarded commitment
- Free toolContingency drawdown tracker
- os.constructionProject financials: budget, commitments and buyout
- GlossaryBid Leveling
- GlossaryBuyout
- GlossaryBuyout Savings
- GlossaryCommitment
- GlossaryGuaranteed Maximum Price (GMP)
- GlossaryShared Savings (GMP Savings Split)
- GlossarySubcontract
- Free resourceBid tabulation and leveling template (Excel)
- Free resourceHow to run a construction buyout
- Free resourceContingency drawdown tracker
- TemplatePunch list template
- TemplateMeeting minutes template
- TemplateInspection checklist starter pack
- TemplateT&M ticket template
- TemplateRFI writing checklist
- TemplateDaily log checklist
- TemplateChange event log
- TemplateBack charge notice and log
- TemplateThree-week look-ahead template
- TemplateSafety observation log
- TemplateAction item tracker
- TemplateCloseout and TCO checklist
- TemplateNotice to proceed template
- TemplateJob cost report template
- TemplateConstruction schedule (Gantt) template
- TemplateChange order log template
- TemplateBid tabulation and leveling template
- TemplateCash flow projection template
- TemplateASI log template
Keep exploring
Related across os.construction
- ExplainerBuyout savings to commitment change: award a subcontract and track the change (video)
- DocsBuyout: from budget to committed costHow construction buyout turns budget lines into subcontracts and POs, how buyout savings and losses are measured per cost code, and how os.construction checks each award against a frozen budget snapshot.
- Free toolBid tabulation and leveling templateFree bid tab template for Excel.
- BlogHow to run a construction buyout: buy-by dates, a buyout log and where the savings goBuyout turns the estimate into signed subcontracts and purchase orders. Run it as a schedule, not a to-do list: work back from each package's need-on-site date to a buy-by date, bid and level, write the scope into the contract, record every variance against the budget, and track the log weekly. Here is each step with a worked buyout log.
- BlogGeneral contractor vs construction manager: roles, risk and how each gets paidA general contractor holds the construction contract and the trade subcontracts, usually after design is done. A construction manager joins during design, either as the owner's adviser or at risk under a guaranteed maximum price. Here is how the roles differ, when each fits, a worked example and the mistakes owners and builders make.
- Free toolContingency drawdown trackerOwner vs contractor contingency against percent complete, with an Excel tracker.