IndiaUnbox PO Project Tracker

Your PO’s status, dates, documents, and risks—all in one place.
This page is where you monitor production progress, inspections, shipments, and delivery. We keep the plan realistic (with buffers), surface risks early, and attach proof (photos/reports) at each milestone.

What you’ll see on the tracker

• Milestone timeline
  PO confirmed → deposit → raw materials → T1/PP samples → DUPRO (20–60%) → PSI (≥80% packed) → booking → ETD/ETA → customs → last-mile.
  Each line shows Planned vs Actual, with statuses: On Track, Due Soon, Overdue, or Completed.
  
• QA & inspections
  AQL level, sample size, defect counts, PASS/FAIL, and the inspection report link (photos + defect glossary).
  
• Shipments
  Mode (LCL/FCL/Air), booking reference, container/AWB, vessel/voyage, ETD/ETA, free days, delivery appointment, live tracking link.
  
• Documents
  CI, PL, COO, test reports, BL/AWB, insurance—status + file links in a single “Docs Vault.”
  
• Risks & CAPA
  Open risks with owner and mitigation; non-conformance CAPAs with due dates and verification links.
  
• Notifications
  Choose who gets milestone, delay, and docs alerts (instant / daily / weekly).
  

Status definitions (RAG)

• On Track (green): planned date is more than 3 days out.
  
• Due Soon (amber): within 3 days.
  
• Overdue (red): planned date has passed with no actual logged.
  
• Completed (grey): actual date posted.
  

Escalations & SLAs

• Delay > 3 days vs plan on any critical step (PP, DUPRO, PSI, ETD) triggers an escalation note with recovery options.
  
• Failed PSI or conditional pass creates a CAPA entry and re-inspection slot.
  
• Docs at risk (missing CI/PL/COO before ETD-2 days) triggers a broker pre-alert and owner assignment.
  

Download a ready-to-use tracker (Excel)

• IndiaUnbox_PO_Project_Tracker.xlsx
  Tabs: PO_Master, Milestones (auto status & day deltas), Inspection_Summary, Shipment_Tracking, Docs_Vault, Risk_Log, CAPA_Log, Notifications, plus a ReadMe.
  

Download the PO & Project Tracker (Excel)

How we keep you updated

• Weekly snapshot: brief email with changes vs last week (dates moved, risks, docs status).
  
• Milestone alerts: same-day email when a key step completes or slips.
  
• Shared folder: all reports and proofs are added to your project drive.