Free steel & bolting QC · Excel

Free Bolt Torque & Erection Log

A structural bolt tightening log with pre-installation verification, a pick-by-pick steel erection sequence plan, and a flange bolt-up record, all with live formulas.

  • Bolt log: F3125 A325/A490/TC, dia., qty, joint type, method
  • Automatic check: PIV missing/failed, method, faying surface
  • PIV record: 3 samples vs. required tension → PASS/FAIL
  • Erection plan: pick weight, % of crane chart, critical-lift flag
  • Bracing, temporary connections, and hold points per pick
  • Flange bolt-up: target torque, pass torques, passes, sign-off
  • Print-ready landscape layout with sign-off blocks

Bolt Torque & Erection Log

We'll email you a copy + send the file to your browser right now.

Excel (.xlsx) · works in Excel, Google Sheets, Numbers

Want it with your logo on it?

A free account puts your logo, company info, and license # on every template, and adds one-click template packs. Free forever, even after the trial.

Get branded templates free →

By downloading you agree to receive occasional Field PM updates. Unsubscribe anytime. We don't share your email — read our privacy policy.

What's inside the workbook

Pre-formatted, print-ready, with embedded Field PM branding. Works in Excel, Google Sheets, and Numbers.

01

Bolt Tightening Log

Connection-by-connection bolting record with an automatic check column and a pre-installation verification record that feeds it.

02

Erection Sequence Plan

Pick-by-pick sequence with total lift weight, % of crane chart, a CRITICAL / OVER CHART flag, bracing, temporary connections, and hold points.

03

Flange Bolt-Up Record

Flange joints with gasket, studs, lubricant, target torque from your procedure, calculated pass torques, final and gap checks, and status.

04

Instructions

Joint types, PIV, lift classes, and flange assembly. What to enter and where the numbers come from.

Want this automated?

Stop re-typing the same form on every job.

Field PM has this exact form built in — crews fill it out from a phone, the data flows into the project record, and you get a clean PDF for the GC or owner with one click. No re-typing, no lost paperwork, no missed signatures.

30 days free · no credit card · every feature unlocked from day one.

Paper / Excel

  • ✗ Hand-writes the form on the jobsite
  • ✗ Re-types into Excel at the trailer
  • ✗ Emails the PDF back to the office
  • ✗ No audit trail, no signatures
  • ✗ Data never feeds payroll or the budget

Field PM

  • ✓ Fill out from a phone in under 3 min
  • ✓ Photos, signatures, and audit log built in
  • ✓ One-click PDF for the GC and owner
  • ✓ Data feeds payroll, budget, and reports
  • ✓ Replaces 5 forms with one platform

On your phone & tablet

Every template — in the app, in your pocket

This template and every other one is built into the Field PM app. Fill them out right from the jobsite on any iPhone, iPad, or Android — photos, signatures, and a clean GC-ready PDF included. Download free:

Download on theApp StoreGet it onGoogle Play

Frequently asked questions

What is the difference between snug-tight, pretensioned, and slip-critical joints?

Snug-tight joints only need the plies pulled into firm contact, the kind of tight an ironworker gets with the full effort of a spud wrench or a few impacts. Pretensioned joints must be tightened to at least a specified minimum bolt tension using an approved method. Slip-critical joints are pretensioned and also depend on friction at the faying surfaces, so the surface class (coating or blast profile) has to match the design. The engineer of record sets the joint type on the drawings.

What is pre-installation verification (PIV)?

Before pretensioned or slip-critical bolts are installed, representative assemblies from each bolt/nut/washer lot are tightened in a tension calibrator using the same method and tools the crew will use. The test shows that the method actually reaches the minimum tension required. It is covered in Section 7 of the RCSC Specification; check the edition on your contract. This template records each PIV and marks it PASS or FAIL, and the bolting log flags any connection whose PIV is missing or failed.

Does the template include bolt pretension or torque values?

No. Minimum tension, flange torque, pass percentages, and critical-lift thresholds are all user inputs. They come from the RCSC Specification, your bolting procedure, the gasket and lubricant manufacturers, and your company lift policy. The example rows use sample numbers only, to show how the formulas work.

Why not just use torque for structural bolts?

Torque is a poor indicator of bolt tension. Thread condition, lubrication, and galling can move it a lot. That is why calibrated-wrench installation has to be verified daily with the actual lot, and why turn-of-nut, twist-off (TC) bolts, and direct tension indicators (DTIs) are common. Flange joints are different: they are usually assembled to a torque target from a procedure based on a known lubricant nut factor.

What does the erection sequence plan calculate?

For each pick it adds member weight and rigging weight, divides by the crane chart capacity you enter for that radius, and flags the lift as Standard, CRITICAL (at or above your threshold), or OVER CHART. It also tracks bracing and guying, temporary connections, hold points, and status for each pick.

The bolting record the inspector asks for

Structural bolting is inspected by connection: which grade, which joint type, which method, and whether that lot passed pre-installation verification. This free Excel log records all of it as the steel goes up and flags anything that would hold up acceptance, such as a missing PIV, a failed lot, no method, or an unconfirmed faying surface.

The workbook also includes an erection sequence plan that checks each pick against the crane chart, and a flange bolt-up record for piping and equipment joints. No RCSC, AISC, or ASME values are built in. You enter tension, torque, and thresholds from your specs and procedures. For the welding side of steel QC, use the WPS / PQR & NDT tracking log.

Field PM runs these QC checks as mobile inspections with hold-point sign-offs and photos, so the record builds itself instead of waiting for someone to type it up.

Bolting and erection records that hold up at turnover

High-strength bolting is easy to do and easy to leave undocumented. The connection gets tightened, the ironworkers move on, and three weeks later the special inspector asks which lot went into the moment connections at C-5 and whether it passed pre-installation verification. This workbook keeps that record as the work happens. It covers structural bolt tightening with PIV on one tab, the erection sequence on the next, and flange bolt-up for the mechanical side on the third.

Tab 1: Structural bolt tightening log

Use one row per connection, or per group of identical connections. The columns match what the inspector checks:

ColumnWhat to enter
Connection ID / Grid, Piece Mark / DwgWhere it is and which erection drawing shows it.
Bolt GradeASTM F3125 Grade A325 or A490, the F1852/F2280 twist-off grades, or A307. A325 and A490 are now grades within F3125.
Dia., Length, QtyFrom the connection detail. Qty rolls up into total bolts by joint type.
Joint TypeSnug-tight, pretensioned, or slip-critical, as shown on the design drawings.
Faying SurfaceFor slip-critical joints: the surface class the design assumes. The mill scale, blast profile, or coating on the steel has to match it.
Tightening MethodTurn-of-nut, calibrated wrench, TC bolt, or DTI.
PIV Done / PIV Ref #Which pre-installation verification covers this lot and method.
Installed By, Inspector, Date, ResultWho did it, who checked it, and the result.

The Check column reviews each row in order: pretensioned or slip-critical with no PIV → PIV missing. PIV number not found or marked FAIL → PIV not passed. No tightening method → Method not set. Slip-critical with no faying surface class → Faying surface?. Then Awaiting inspection, Rework, or OK. Anything red is holding up acceptance.

Pre-installation verification record

Below the log, record each PIV: lot number, grade, diameter, length, method, calibrator ID, the required minimum tension, and three sample readings. The lowest sample has to meet the requirement for the lot to PASS. Enter the required tension from the pre-installation verification table in the RCSC Specification edition on your contract. The example values are only there to show the math. Log calibrated-wrench PIVs daily, and again whenever the lot, lubrication, or wrench changes.

What the inspector is really checking

  • Turn-of-nut: matchmarks on nut and bolt end after snugging, and the correct rotation for the bolt length.
  • Calibrated wrench: a daily calibration record for the lot and the wrench, and hardened washers where required.
  • TC bolts: the spline sheared off, and no bolts spun or "pre-twisted" before the joint was snug.
  • DTIs: the right side of the DTI facing the turned element, and feeler-gauge refusals in the required number of spaces.
  • All pretensioned joints: the joint snugged fully before final tightening, working from the stiffest part of the joint outward.

Inspection requirements are in RCSC Section 9 and AISC 360 Chapter N. Verify against the editions on your project.

Tab 2: Erection sequence plan

A good sequence builds a stable, braced bay first and grows from it. For each pick the plan captures the area and members, crane and setup, member and rigging weight, radius, and chart capacity. It calculates total pick weight, % of chart, and lift class. Picks at or above your critical-lift threshold show CRITICAL, which means a written lift plan. Anything over 100% shows OVER CHART. The threshold is your company or site policy; 75% is only an example. Chart capacity has to come from the load chart for the actual configuration, not from memory or last job.

The plan also records bracing / guying, temporary connections, and hold points such as survey and plumb checks, EOR release, grout cure, special inspection, and weather holds. OSHA 1926.756(a)(1) does not let the load come off the hook on a solid-web member until it is secured with at least two bolts per connection, of the size and strength shown on the erection drawings, drawn up wrench-tight (or the equivalent specified by the EOR). Columns need at least four anchor rods (1926.755). Those minimums belong on the sheet the crew actually reads.

Tab 3: Flange bolt-up record

Flange leaks at hydrotest or startup usually come back to assembly: the wrong gasket, a dry stud, one pass at full torque, or a joint that was never finished. The record tracks each joint's flange size and class, gasket, stud size and quantity, stud/nut material, lubricant, and target torque from your procedure. You enter the pass percentages from your bolting procedure once in the header, and the sheet calculates the torque for each pass on every joint.

ASME PCC-1 (Guidelines for Pressure Boundary Bolted Flange Joint Assembly) describes stepped torque passes in a cross pattern followed by circular passes at 100% until the nuts stop turning. The Status column follows that sequence: Pass n next → Final check due → Gap check due → Awaiting sign-off → COMPLETE. Record the tool ID on every joint so that if a wrench fails calibration, you know which joints to re-check.

Target torque depends on the lubricant. A nickel anti-seize and a moly paste have different nut factors, so the same torque gives different bolt loads. If the crew changes lubricant, the procedure torque has to change too.

Related free templates and references

Field PM runs QC inspections, hold points, and sign-offs from the phone, with photos attached and records filed to the job. Start a free 30-day trial.

Rated by contractors on

Field PM reviews on CapterraField PM reviews on GetAppField PM reviews on Software Advice