Esc

↑↓ move↵ openIndex · Pagefind

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.

  • Free
  • No signup
  • Excel · Google Sheets · LibreOffice
The Excel file

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:

I5Formula in I5: =IF(H5="","",C5-H5)
Buyout log template: preview of the “Buyout log” sheet in buyout-log-template.xlsx, with the sample data
ABCDEFGHIJLM
1Buyout log
2ProjectRiverside Medical Center (sample)As of
3Blue 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.
4Cost codeScope / bid packageBuyout budgetStatusVendorAward amountScope gaps carriedLeveled buyout costSavings / (loss)Savings %Days to need-byFlag
503-3000Cast-in-place concrete$2,240,000ExecutedSummit Concrete$2,105,000$18,000$2,123,000$117,0005.2%
605-1200Structural steel and deck$1,960,000ExecutedNorthline Steel$1,885,000$0$1,885,000$75,0003.8%
707-5400Roofing$610,000ExecutedApex Roofing$598,000$0$598,000$12,0002.0%
808-4100Storefront and glazing$430,000AwardedClearSpan Glass$412,000$9,500$421,500$8,5002.0%
909-2900Gypsum board and framing$2,960,000ExecutedMetro Interiors$3,120,000$0$3,120,000($160,000)-5.4%Bought out over budget
1022-1000Plumbing$1,720,000ExecutedRiverside Plumbing$1,668,000$12,000$1,680,000$40,0002.3%
1123-0000HVAC$3,100,000Leveling14Award due in 14 days
1226-0500Electrical$3,820,000AwardedBright Electric$3,760,000$25,000$3,785,000$35,0000.9%
1309-3000Tiling$540,000Bidding28
1409-9100Painting$380,000Not started42
1510-2800Toilet accessories and partitions$145,000Not started-7Past need-by date
16
17
InstructionsBuyout logSummary
Rendered from the downloadable file: same formulas, same sample numbers, same conditional formatting. Sample data is illustrative.

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
Download the .xlsx
Worked example (illustrative)

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-B15

Budget bought out − leveled cost of those packages.

Contractor shareSummary · B26

=MAX(0,B16)*B25

Positive 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 codeScope / bid packageBuyout budgetStatusAward amountScope gaps carriedLeveled buyout costSavings / (loss)Days to need-byFlag
03-3000Cast-in-place concrete$2,240,000Executed$2,105,000$18,000$2,123,000$117,000
05-1200Structural steel and deck$1,960,000Executed$1,885,000$0$1,885,000$75,000
07-5400Roofing$610,000Executed$598,000$0$598,000$12,000
08-4100Storefront and glazing$430,000Awarded$412,000$9,500$421,500$8,500
09-2900Gypsum board and framing$2,960,000Executed$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

How to use it

Using the buyout log template

  1. 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).
  2. 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.
  3. 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.
  4. Review the flags weekly: packages bought out over budget, awards past their need-by date and awards due within 14 days.
  5. 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.
From budget to executed subcontractPackage budgeted, then Bidding, then Leveling, then Awarded, then Executed. Rebid the scope: from Leveling back to Bidding.Rebid the scopePackage budgetedEstimate carried to the budgetBiddingBid package issuedLevelingExclusions priced back inAwardedSavings or overrun knownExecutedSubcontract or PO signed
  1. Package budgetedEstimate carried to the budget
  2. BiddingBid package issued
  3. LevelingExclusions priced back inRebid the scope: back to “Bidding”
  4. AwardedSavings or overrun known
  5. ExecutedSubcontract or PO signed
From budget to executed subcontract
Text version
  1. Package budgeted: Estimate carried to the budget
  2. Bidding: Bid package issued
  3. Leveling: Exclusions priced back in
  4. Awarded: Savings or overrun known
  5. Executed: Subcontract or PO signed

Rebid the scope: from “Leveling” back to “Bidding”.

In os.construction

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.

FAQ

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

Open file