# Shelf Life Tracking Worksheet for Aircraft Maintenance Stores

> Source: https://netray.co/tools/mro-shelf-life-tracking-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable log of sealants, adhesives, greases and other limited-life materials with expiry, months left, value and action.

## Category

aerospace-defense

## Industry

Aerospace MRO

## Audience

- Stores supervisor
- Materials planner
- Quality inspector
- Buyer

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Material

**Key:** material

**Type:** text

#### Specification

**Key:** spec

**Type:** text

#### Batch or lot

**Key:** batch

**Type:** text

#### Store location

**Key:** location

**Type:** text

#### Qty

**Key:** qty

**Type:** number

#### UoM

**Key:** uom

**Type:** select

**Options:**

- EA
- KIT
- KG
- L
- CAN

#### Unit cost

**Key:** cost

**Type:** number

**Format:** currency

#### Stock value

**Key:** value

**Type:** number

**Expr:** qty * cost

**Format:** currency

#### Expiry date

**Key:** expiry

**Type:** date

#### Months left

**Key:** months

**Type:** number

**Unit:** months

#### Action

**Key:** action

**Type:** select

**Options:**

- Use first
- Normal
- Retest
- Extend (approved)
- Quarantine
- Scrap

**Rows:**

**Material:** Two-part polysulfide sealant

**Spec:** AMS-S-8802 class B

**Batch:** L240318

**Location:** Cold store A1

**Qty:** 24

**Uom:** KIT

**Cost:** 38

**Expiry:** 2026-12-15

**Months:** 2

**Action:** Use first

**Material:** Epoxy structural adhesive

**Spec:** Adhesive per OEM SRM

**Batch:** E230912

**Location:** Cold store A2

**Qty:** 10

**Uom:** KIT

**Cost:** 96

**Expiry:** 2027-03-31

**Months:** 5

**Action:** Normal

**Material:** Synthetic aircraft grease

**Spec:** MIL-PRF-23827

**Batch:** G250207

**Location:** Shelf C4

**Qty:** 18

**Uom:** CAN

**Cost:** 42

**Expiry:** 2028-02-28

**Months:** 16

**Action:** Normal

**Material:** Fluorinated bearing grease

**Spec:** Per component manual

**Batch:** G220611

**Location:** Shelf C5

**Qty:** 6

**Uom:** CAN

**Cost:** 210

**Expiry:** 2026-11-30

**Months:** 1

**Action:** Retest

**Material:** O-ring assortment, cure dated

**Spec:** AS568 sizes, nitrile

**Batch:** R2Q25

**Location:** Rack D2

**Qty:** 40

**Uom:** EA

**Cost:** 4.5

**Expiry:** 2027-06-30

**Months:** 8

**Action:** Normal

**Material:** Corrosion inhibiting compound

**Spec:** Per OEM spec

**Batch:** C240102

**Location:** Shelf B3

**Qty:** 12

**Uom:** CAN

**Cost:** 55

**Expiry:** 2026-10-31

**Months:** 0

**Action:** Quarantine

**Totals:**

#### Total quantity

**Key:** qty

**Agg:** sum

**Format:** number

#### Total stock value

**Key:** value

**Agg:** sum

**Format:** currency

#### Shortest remaining life (months)

**Key:** months

**Agg:** min

**Format:** number

**Summary:**

#### Average value per line

**Key:** avg_value

**Expr:** sum_value / count

**Format:** currency

#### Average months left

**Key:** avg_months

**Expr:** avg_months

**Format:** decimal

**Notes:** Sample rows are illustrative. Shelf life limits come from the material manufacturer and the governing specification, and any extension must follow your approved procedure and be recorded. The months-left column is typed in, so refresh it at each review.

## Content

**Intro:** Sealants, adhesives, greases and cure-dated rubber parts expire, and using an expired material on an aircraft is a quality escape. This worksheet gives stores and quality a simple log of batches, expiry dates, months left and the value that is about to be lost.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per batch or lot, not per material, because expiry belongs to the batch. Record the specification, location, quantity and unit cost, then enter the expiry date and months remaining. Choose an action: use first, normal, retest, extend under an approved procedure, quarantine or scrap. Review the list weekly, sort by months left, and hand the use-first list to the planners so those materials are drawn first. Export to Excel for a shared stores board, or to PDF for an audit file.

#### How shelf life works

**Body:** Shelf life is the period during which a material meets its specification when stored as the manufacturer requires. The clock may start at the manufacture date, the delivery date or the date a cold chain was broken, depending on the product. Some materials have a separate working life once opened or mixed, and some may be retested and extended under controlled conditions by the manufacturer or an approved process. Do not extend by judgement. Record who authorised an extension, the basis and the new date, and keep that with the batch record.

**Bullets:**

- Track by batch or lot, not by material name
- Record the storage condition, such as frozen or refrigerated
- Record opened and mixed dates for materials with a working life
- Keep extension approvals with the batch record

#### Reading the totals

**Body:** The total stock value tells you the size of the inventory under shelf-life control. The shortest months-left figure tells you how urgent the review is. Filter lines with zero to two months left and compare them with planned work. If a batch will expire before planned consumption, the right actions are to swap it with a nearer-use job, return it to the supplier if allowed, or scrap it early rather than at expiry. A pattern of repeated write-offs on one material usually means the minimum order quantity or the reorder point is too high.

#### Common mistakes

**Body:** The usual mistakes are tracking by material name instead of batch, forgetting the cold-chain history, and issuing from the wrong batch because first-expired-first-out is not enforced at the shelf. Another is relying on the ERP expiry date without checking that it was entered correctly at receipt. Check a sample of physical labels against the system each month. Finally, remember that expired materials must be physically segregated and tagged, because a stock status in a system does not stop someone from picking the can.

**Cta:** If your ERP already holds batch and expiry data, we can build alerts and use-first lists that run from it. Netray builds private, on-prem tools around SAP, Infor, Oracle and Dynamics.

**Faq:**

#### Do I track shelf life by batch or by part number?

**Answer:** By batch or lot. The part number tells you what the material is, but expiry belongs to the production batch. Two cans of the same part number can have different expiry dates, and issuing needs to follow the date on each can.

#### Can I extend shelf life?

**Answer:** Only when the manufacturer, the specification or your approved procedure permits it, and with a record of the test or approval. Never extend by judgement. Keep the evidence with the batch record and update the expiry date in your system and on the label.

#### What is the difference between shelf life and working life?

**Answer:** Shelf life is how long an unopened material remains acceptable in storage. Working life, sometimes called pot life, is how long a material can be used after opening or mixing. Both limits can apply to the same product, so track the one that matters at the point of use.

#### How often should I review the list?

**Answer:** Weekly is common for stores holding sealants and adhesives, with a monthly physical check of labels against the system. High-value or short-life materials may need a daily glance at the use-first list. Choose a rhythm that matches how fast your batches expire.

## Search terms

shelf life tracking worksheet, shelf life log excel, aircraft sealant shelf life tracking, limited life materials tracking, expiry date tracking stores, aerospace consumables shelf life, mro stores expiry log, shelf life extension record

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json