# Welding Consumables Issue and Return Log > Source: https://netray.co/tools/welding-consumables-issue-log-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Track electrodes, wire and flux issued to each job, returned stock and consumption by heat or lot number for traceability and costing. ## Category quality ## Industry Fabrication ## Audience - Welding store keeper - Welding engineer - Quality engineer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Date **Key:** date **Type:** date #### Job or work order **Key:** job **Type:** text #### Consumable **Key:** consumable **Type:** text #### Heat or lot number **Key:** lot **Type:** text #### Welder ID **Key:** welder **Type:** text #### Issued **Key:** issued **Type:** number **Unit:** kg #### Returned good **Key:** returned **Type:** number **Unit:** kg #### Stubs and scrap **Key:** stubs **Type:** number **Unit:** kg #### Net consumed **Key:** consumed **Type:** number **Unit:** kg **Expr:** issued - returned - stubs #### Cost per kg **Key:** unit_cost **Type:** number **Format:** currency #### Consumed cost **Key:** cost **Type:** number **Expr:** (issued - returned) * unit_cost **Format:** currency **Rows:** **Date:** 2026-10-12 **Job:** WO-48213 **Consumable:** E7018 3.2 mm **Lot:** H-77120 **Welder:** WLD-019 **Issued:** 5 **Returned:** 1.2 **Stubs:** 0.6 **Unit cost:** 2.4 **Date:** 2026-10-12 **Job:** WO-48213 **Consumable:** ER70S-6 1.2 mm wire **Lot:** W-30458 **Welder:** WLD-027 **Issued:** 15 **Returned:** 4.5 **Stubs:** 0 **Unit cost:** 1.9 **Date:** 2026-10-13 **Job:** WO-48220 **Consumable:** ER308L 2.4 mm TIG rod **Lot:** T-9021 **Welder:** WLD-012 **Issued:** 2 **Returned:** 0.8 **Stubs:** 0.3 **Unit cost:** 14.5 **Date:** 2026-10-14 **Job:** WO-48220 **Consumable:** E71T-1 1.2 mm flux cored **Lot:** F-5513 **Welder:** WLD-033 **Issued:** 12 **Returned:** 3 **Stubs:** 0 **Unit cost:** 3.1 **Date:** 2026-10-15 **Job:** WO-48231 **Consumable:** E7018 4.0 mm **Lot:** H-77121 **Welder:** WLD-044 **Issued:** 6 **Returned:** 0.5 **Stubs:** 0.9 **Unit cost:** 2.4 **Totals:** #### Total issued **Key:** issued **Agg:** sum **Format:** decimal #### Total returned **Key:** returned **Agg:** sum **Format:** decimal #### Net consumed **Key:** consumed **Agg:** sum **Format:** decimal #### Total consumed cost **Key:** cost **Agg:** sum **Format:** currency **Summary:** #### Stubs as share of issued **Key:** stub_share **Expr:** if(gt(sum_issued,0), sum_stubs / sum_issued * 100, 0) **Format:** percent #### Average cost per issued kg **Key:** avg_cost **Expr:** if(gt(sum_issued,0), sum_cost / (sum_issued - sum_returned), 0) **Format:** currency **Primary:** true **Notes:** Record the heat or lot number so that every weld can be traced back to the consumable certificate (for example an EN 10204 3.1 certificate). Net consumed removes stubs, so consumed cost is on issued minus returned stock. Stub loss is shown as a separate share. Rewrite units if you issue by spool, box or electrode count. ## Content **Intro:** Consumable control is a quality requirement and a cost line. This log records what left the store, what came back and what ended up as stubs, with heat or lot numbers so a weld can be traced to its filler. **Sections:** #### How to use the log **Body:** Add a row each time a welder or foreman draws consumables. Enter the job, the specific product, the heat or lot number and the issued quantity. When stock comes back, enter the returned good quantity, and enter stubs and scrap separately. The sheet calculates net consumption and cost. Export weekly to Excel for costing or to the quality department for traceability audits. Keep the paper or scanned certificates for each lot together with this log. **Bullets:** - Issue low hydrogen electrodes from a heated oven only - Never mix lots on one row - Record returns the same day - Weigh wire spools rather than estimating #### Why traceability matters **Body:** Fabrication codes and customer specifications often require that filler metals can be traced to the certificate and the weld. Without a lot number on the issue record, a failed chemical or mechanical test cannot be tied back to the welds that used that lot. The log gives you that link in a simple form. Cost is the second reason. Rod and wire are a small share of total weld cost compared with labor, but over a year the stubs, spoiled rods and over-issues become visible in the numbers. #### Reading the example **Body:** The sample rows show issue and return for four processes. The summary shows stub share, which for stick electrodes is driven by stub length discipline, and the average cost per net kilogram taken from the shop. A stub share much above the normal range for stick work can indicate poor discipline or electrodes discarded because of moisture. Compare lots when one shows unusually high returns, as that may point to damaged packaging. #### Common mistakes **Body:** A consumables log is only useful if it is used every time. **Bullets:** - Issuing without a lot number so traceability is lost - Leaving unused electrodes in the open and issuing them again as good - Not separating stubs from returned stock - Mixing different diameters in one row - Costing on issued quantity when returns are significant **Cta:** If consumable issues should post as inventory transactions in your ERP with lot traceability, we can help design that without double entry. **Faq:** #### Why record the heat or lot number? **Answer:** It ties each weld to a mill or manufacturer certificate. If a consumable fails a test or a recall occurs, you can find every job that used that lot. Many fabrication and pressure equipment specifications require it. #### What is a normal stub loss for stick electrodes? **Answer:** Stub length is usually specified as about 40 to 50 mm, which on a 350 mm electrode is roughly 11 to 14 percent of the length. Real losses also include spoiled electrodes, so use your own history rather than a fixed number. #### Should returned electrodes be reissued? **Answer:** Only if they were kept dry according to the manufacturer's storage rules. Low hydrogen electrodes returned from the field normally go back into a holding oven and are reissued within limits, or are discarded. Follow your procedure. #### Can the log handle spools and boxes? **Answer:** Yes. Change the unit label or enter the weight of the spool in kilograms. Use the same unit consistently within one log so totals and cost stay correct. ## Search terms welding consumables issue log, welding electrode issue register, welding consumable control log excel, filler metal issue record, welding rod issue return format, welding consumables traceability log --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json