SMT Stencil Usage and Cleaning Log (Excel)
A worn, dirty or slack stencil is a hidden cause of bridging, insufficient solder and SPI drift. This log keeps each stencil's print count, cleaning date, tension and status in one editable table so that nobody runs a stencil past its useful life.
| Stencil ID | Assembly | Foil thickness (mm) | Foil type | Prints to date | Print life limit | Prints remaining | Life used | Last deep clean | Tension (N/cm) (N/cm) | Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|
37,600 | 24.8% | ||||||||||
8,200 | 83.6% | ||||||||||
23,800 | 20.7% | ||||||||||
1,100 | 96.3% |
Print life is not a universal number. Set it from your own history of print quality, SPI trends and aperture wear, and shorten it for fine pitch stencils. Most stencil frame suppliers recommend a minimum tension and a measurement method; confirm the value for your frame type and use the same gauge each time. Record deep cleaning and any frame or foil damage in the status column.
Automate tooling life tracking
Optional: discuss feeding stencil and tooling counts from machines into your ERP.
Optional. The tool and every export work without this. No spam.
How to use the log
Add one row per stencil when it arrives and record foil thickness and type. Update the print count at the end of each job from the printer counter, and log the date of the last deep clean and the latest tension reading. The sheet calculates prints remaining and the percentage of life used. Sort by life used to see which stencils need replacement orders, and use the status dropdown to flag stencils that should not be loaded.
- Set the life limit from SPI and defect history, not a catalog number.
- Record deep clean after each job family or per your procedure.
- Measure tension with the same gauge and location on each check.
- Retire stencils with damaged apertures or loose foil.
Why stencil condition matters
Paste transfer depends on aperture quality, foil flatness and seal against the board. Dried paste narrows apertures and reduces volume, while worn nano-coating or dents increase underside smear and bridging. Foil tension affects registration and gasket seal. Tracking stencils like tooling turns a vague problem into a documented one, and it gives you evidence when paste volume trends in SPI move gradually over weeks.
Reading the example
STN-17730-A has used 41,800 of 50,000 prints, so about 84 percent of its life, and its tension is flagged as due for a check. STN-31092-C is electroformed with a fine 0.08 mm foil, has a shorter life limit, and needs cleaning. STN-11204-A has reached 96 percent of its life and has lost tension, so it is marked for retirement and a replacement order should already be placed.
Common mistakes
Teams often track prints with a manual tally, which gets lost during shift changes; read the printer counter instead. Others use one life limit for all stencils, even though a 0.08 mm foil with 0.4 mm pitch apertures wears differently from a 0.15 mm step stencil. Finally, do not store stencils with residual paste; clean them, dry them and store them in a protected rack.
Frequently Asked Questions
How many prints does an SMT stencil last?
There is no fixed number. Laser cut stainless stencils can often print tens of thousands of boards, while fine pitch or step stencils wear faster. Set the limit from SPI trends, defect rates and visual inspection of apertures.
How often should a stencil be cleaned?
Underside wipes happen during printing, typically every few prints for fine pitch and less often for coarse pitch. Deep cleaning with a stencil cleaner or ultrasonic system is done after each job or at defined intervals. Follow your paste and stencil supplier's guidance.
What tension should a stencil have?
Typical numbers are in the range of 30 to 50 N/cm for tensioned frames, but the right value depends on the frame and supplier. Measure at the same points each time and replace foils that drop below the supplier's minimum.
Can I reuse a stencil for a changed board revision?
Only if the apertures still match the new pad design and the engineering change notice confirms it. If pads changed, order a new stencil; do not modify old foils by hand.
If you already track tooling in an ERP or MES, we can add stencil counts automatically from the printer so the log updates itself.
Related Tools
PCBA First Article Inspection Report Template
A fill-in first article report for a new PCB assembly job: setup verification, BOM and placement checks, solder inspection and sign-off.
MES & Shop FloorSMT Line Changeover and Feeder Setup Worksheet
Plan the daily SMT schedule with changeover, feeder setup and run time per job so you can see true line utilization.
Quality & InspectionPCBA AOI Defect Log and DPMO Worksheet
An editable defect log that computes defects per million opportunities (DPMO) and defect rate for each lot or shift.
Electronics ManufacturingMSD Moisture Sensitive Device Floor Life Log
An editable log to track moisture sensitivity level, bag open date, floor life used and remaining hours for each reel or tray.
More Electronics Manufacturing tools
See all- J-STD-020 MSL Floor Life and Soak Reference
- PCB Panelization Calculator
- Solder Paste Volume Calculator
- SMT Placement Rate and Cycle Time Calculator
- Solder Alloy Melting Point Reference Table
- PCB Trace Current Capacity and Temperature Rise Calculator
- PCB Microstrip Impedance and Delay Calculator
- PCBA First Pass Yield and DPMO Calculator
- MSL Floor Life Remaining Calculator