# Material Check Out Sheet: Free Job-Based Material Check Out List > Source: https://netray.co/tools/material-check-out-sheet-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable material check out sheet that logs each issue against a job number, tracks returns, and totals the cost of material used. ## Category supply-chain ## Audience - Shop floor lead - Storeroom clerk - Inventory controller ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Date **Key:** date **Type:** date #### Job / work order **Key:** job **Type:** text #### Part / material **Key:** part **Type:** text #### UoM **Key:** uom **Type:** select **Options:** - EA - FT - M - KG - LB - BOX - ROLL #### Qty checked out **Key:** qty_out **Type:** number #### Qty returned **Key:** qty_ret **Type:** number #### Net used **Key:** net **Type:** number **Expr:** qty_out - qty_ret **Format:** number #### Unit cost **Key:** cost **Type:** number **Format:** currency #### Cost of material used **Key:** ext **Type:** number **Expr:** (qty_out - qty_ret) * cost **Format:** currency #### Checked out by **Key:** by **Type:** text #### From bin **Key:** bin **Type:** text **Rows:** **Date:** 2026-10-19 **Job:** WO-10452 **Part:** 6061-T6 bar 1.5 in **Uom:** FT **Qty out:** 24 **Qty ret:** 3 **Cost:** 6.8 **By:** R. Singh **Bin:** A-04-2 **Date:** 2026-10-19 **Job:** WO-10452 **Part:** Hex bolt M8x30 **Uom:** EA **Qty out:** 120 **Qty ret:** 0 **Cost:** 0.14 **By:** R. Singh **Bin:** C-11-1 **Date:** 2026-10-20 **Job:** WO-10466 **Part:** Gasket sheet 3 mm **Uom:** EA **Qty out:** 6 **Qty ret:** 1 **Cost:** 18.5 **By:** L. Chen **Bin:** B-02-5 **Date:** 2026-10-20 **Job:** WO-10471 **Part:** Cutting fluid 20 L **Uom:** BOX **Qty out:** 2 **Qty ret:** 0 **Cost:** 74 **By:** M. Okoye **Bin:** D-01-1 **Date:** 2026-10-21 **Job:** WO-10466 **Part:** Copper tube 12 mm **Uom:** M **Qty out:** 30 **Qty ret:** 4 **Cost:** 5.2 **By:** L. Chen **Bin:** A-07-3 **Totals:** #### Total qty out **Key:** qty_out **Agg:** sum **Format:** number #### Total qty returned **Key:** qty_ret **Agg:** sum **Format:** number #### Total cost of material used **Key:** ext **Agg:** sum **Format:** currency **Summary:** #### Return rate **Key:** return_rate **Expr:** if(gt(sum_qty_out,0), sum_qty_ret / sum_qty_out * 100, 0) **Format:** percent **Description:** Share of checked-out quantity that came back to stock. **Notes:** Print one sheet per day or per job. Every line needs a job or work order number, otherwise the cost cannot be charged to anything. Reconcile the sheet against ERP material issue transactions at the end of each shift. ## Content **Intro:** A material check out sheet records who took which material, how much, and for which job, so stock and job cost stay correct. This editable check out list totals returns and cost and exports to Excel or PDF. **Sections:** #### How to use the material check out sheet **Body:** Add one row per pick. Enter the job or work order number first, then the part, unit of measure, quantity taken and the unit cost. When leftover material comes back to the storeroom, fill in Qty returned on the same row so Net used and Cost of material used update. Export to Excel for the month-end job cost review, or print the PDF and keep it at the storeroom window. The example rows show a typical mix of bar stock, fasteners, sheet and consumables. **Bullets:** - One line per part per pick, never combine two jobs on one line - Record the bin so the next cycle count is faster - Fill Checked out by with a name, not a team - Record returns on the original line so the pick history stays traceable #### What a good check out list must capture **Body:** A check out list is a control document. Auditors and cost accountants look for the same five things: an identifiable job, an identifiable part, a quantity with its unit of measure, a person, and a date. Without the job number the material becomes unallocated overhead. Without the unit of measure a line that says 10 can mean ten feet or ten boxes. For lot or serial controlled material, add the lot number in the part field so traceability survives. For regulated work such as aerospace or medical devices, keep completed sheets with the job record for the retention period your quality system sets. #### Mirroring the sheet in ERP material issues **Body:** In an ERP the same event is a material issue or backflush against a work order or project. SAP posts it as a goods issue to a production order (movement type 261), Infor SyteLine uses Job Material Transactions, Oracle Fusion uses a WIP issue transaction, and NetSuite uses a work order issue. A paper or spreadsheet check out sheet is useful as a fallback when scanners are down, when the storeroom is not yet on ERP, or for tools and consumables not tracked per job. Whenever you keep both, make the sheet the input and the ERP the record, and key sheet lines into the ERP the same shift. **Bullets:** - Compare sheet totals to ERP issue totals per job weekly - Investigate any job where sheet quantity differs from ERP quantity - Use the Return rate figure to spot over-picking by planners or kitting #### Common mistakes **Body:** The most common failure is taking material without a line and fixing it later from memory, which produces phantom inventory. The second is logging returns as a new negative line with no job reference, so the job never gets credited. The third is mixed units, such as pulling bar by the foot and logging it by the piece. Set one issue unit per part and put it in the part master. If your sheet and ERP disagree repeatedly, the cause is almost always timing, so key lines in at the point of pick. **Cta:** If your storeroom still reconciles paper to ERP by hand, Netray can add a private AI layer that flags job issue mismatches directly from your ERP data, on-prem if needed. **Faq:** #### What is a material check out sheet? **Answer:** It is a log of material taken from stores, recording the date, job number, part, quantity, unit of measure and the person who took it. Its purpose is to keep inventory accurate and charge material cost to the correct job. #### Is a material check out list the same as a material requisition? **Answer:** Close but not identical. A requisition requests material and is usually approved before the pick. A check out list records what was actually taken. Many shops combine both on one form with an approval signature column. #### How do I post returns? **Answer:** Record the returned quantity against the original job line on the sheet, and in ERP post a material return or negative issue to the same work order so the job cost is credited and stock is restored to the correct bin. #### Can I use this sheet instead of ERP? **Answer:** For a small shop it can work, but you lose automatic costing and traceability. It is best as a fallback or as the pick record that feeds ERP transactions, not as a long term replacement for inventory control. ## Search terms material check out sheet, material check out list, materials check out sheet, material issue log template, stockroom check out sheet excel, material requisition log, job material issue form, inventory check out log --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json