Welding Fabrication Quote and Job Tracker Spreadsheet Steel Cut List Price Calculator Google Sheets

How many quotes have you priced off the last stick of tube you bought and a number that felt right? And of the jobs that came back, how many paid what the quote said they would?

This tracker prices a job the way the job actually happens. Your steel sits in a library with its real weight per foot and cost per pound. You build the cut list and the weight and material cost figure themselves out — no scale, no guessing. Add the weld hours, consumables and finish, and the quote prices itself at your target margin, then flags itself if the price you actually sent came in under it. When a quote wins, it walks a job board from Quoted to Delivered, deposits and balances tracked as it goes. And when the job ships, the Actuals tab puts the quote and the truth side by side — steel, hours, and what the job really did. In the sample week inside, one corral-panel job everyone thought was fine lost $76.90. The sheet shows exactly where it went: an hour and a half of extra welding and $26.40 of extra steel.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 9 TABS

• Start Here — plain-English quick start, plus the two settings that run the whole sheet: your target margin % and your shop rate per weld hour

• Dashboard — quotes won and your win rate, value of won quotes, jobs in the shop and what they're worth, balances still owed to you, and profit on completed jobs

• Steel Library — 14 profiles (angle, tube, channel, beam, pipe, plate, bar) with weight per foot and cost per lb; cost per foot figures itself out, and you can add your own steel any time

• Cut List — one row per cut, tagged with its quote number: total length, weight and material cost pull from the library by themselves, and every quote totals itself up

• Quote Builder — one row per quote: steel cost pulls in from the cut list, you add weld hours by process (MIG, TIG, stick), consumables and finish — out comes the subtotal, a suggested price at your target margin, and a flag on any price you set below it

• Job Board — won quotes become jobs and walk the stages: Quoted, Approved, Cutting, Welding, Finishing, Delivered. Deposit in, balance due figures itself out

• Job Actuals vs Quote — the truth tab: material and hours, quoted vs actual, with variances, total real cost, profit and margin for every finished job

• Remnants & Drops — every usable offcut on the rack with its weight and estimated value from the library, ready to quote the next small job against

• Monthly Summary — jobs completed, revenue, real costs and profit by month, rolled up by itself

HOW A QUOTE IS FIGURED — ONE METHOD, NO HIDDEN MATH

Material comes straight off the Steel Library: weight = total cut length × weight per foot, and material cost = weight × cost per lb, so a quote is priced from the steel up, never guessed. Labor = weld hours × your shop rate (set on Start Here). Quote Subtotal = material + labor + consumables + finish. Suggested Price = subtotal ÷ (1 − target margin) — at the suggested price, with your costs covered, the margin you aimed for is the margin you keep. Your Price is always yours to set — the sheet just shows you the margin it really earns and flags anything below your target. The tracker starts at a 35% target margin and a $65/hour shop rate; change either in one shaded cell on Start Here and every price, margin and flag follows it. This is a quoting and record-keeping tool: it organizes your numbers and does the arithmetic — what you charge and what your shop earns are always your calls.

THE SAMPLE WEEK

It comes loaded with one fictional week (Ironroot Fabrication, October 2026 — five quotes out, six jobs on the board, three jobs graded in Actuals) so you can watch every formula work before you delete the samples and type your own. One quote prices under its target and flags itself. One finished job lost money and the Actuals tab shows why, line by line. Formulas are pre-filled down the columns — 10 quote rows, 20 cut-list rows, 20 job rows, 15 actuals rows, 20 remnant rows, ready to go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and it works on the shop computer, your phone at the steel yard, or wherever a customer asks "what would that run me?"

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.