# Calibration Log Template > Source: https://netray.co/tools/calibration-log-template > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable calibration record log with as-found results and a running out-of-tolerance rate. ## Category quality ## Audience - Quality technician - Metrology technician - Quality manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Gage ID **Key:** id **Type:** text #### Description **Key:** desc **Type:** text #### Calibration date **Key:** cal_date **Type:** date #### Next due date **Key:** due_date **Type:** date #### Interval (months) **Key:** interval **Type:** number #### As-found result **Key:** result **Type:** select **Options:** - In tolerance - Out of tolerance - Adjusted - Rejected #### Out of tolerance as found (1 or 0) **Key:** oot **Type:** number **Help:** Enter 1 if found out of tolerance, otherwise 0. #### Certificate no. **Key:** cert **Type:** text #### Calibrated by **Key:** by **Type:** text **Rows:** **Id:** CAL-0012 **Desc:** Digital caliper 0-150 mm **Cal date:** 2026-03-04 **Due date:** 2027-03-04 **Interval:** 12 **Result:** In tolerance **Oot:** 0 **Cert:** C-26-0188 **By:** Internal metrology **Id:** MIC-0044 **Desc:** Outside micrometer 25-50 mm **Cal date:** 2026-03-04 **Due date:** 2027-03-04 **Interval:** 12 **Result:** In tolerance **Oot:** 0 **Cert:** C-26-0189 **By:** Internal metrology **Id:** TQW-0007 **Desc:** Click torque wrench 10-50 Nm **Cal date:** 2026-05-19 **Due date:** 2026-11-19 **Interval:** 6 **Result:** Out of tolerance **Oot:** 1 **Cert:** EXT-77421 **By:** External lab **Id:** PIN-0120 **Desc:** Pin gage set 1.00-3.00 mm **Cal date:** 2026-06-10 **Due date:** 2027-06-10 **Interval:** 12 **Result:** Adjusted **Oot:** 0 **Cert:** EXT-77502 **By:** External lab **Id:** HGT-0003 **Desc:** Digital height gage 0-300 mm **Cal date:** 2026-08-25 **Due date:** 2027-08-25 **Interval:** 12 **Result:** In tolerance **Oot:** 0 **Cert:** C-26-0301 **By:** Internal metrology **Totals:** #### Calibration events **Key:** id **Agg:** count **Format:** integer #### Average interval (months) **Key:** interval **Agg:** avg **Format:** decimal #### Out of tolerance as found **Key:** oot **Agg:** sum **Format:** integer **Summary:** #### As-found out-of-tolerance rate **Key:** oot_rate **Expr:** 100 * sum_oot / count **Format:** percent **Notes:** Record the as-found condition before any adjustment. For each out-of-tolerance event, open a record to assess product measured since the last good calibration. Dates follow your regional format in the export. ## Content **Intro:** Auditors under ISO 9001, AS9100 and IATF 16949 expect calibration records they can trace to the instrument, the date, the result and the certificate. This template gives you a clean log you can fill in and export. **Sections:** #### How to use it **Body:** Add one row per calibration event, not per instrument. Enter the gage ID that matches your master list, the date, the interval and the next due date. Choose the as-found result, mark out-of-tolerance events with 1 in the flag column, and reference the certificate number from the lab. The totals count events, average the intervals and compute the as-found out-of-tolerance rate, which is the number you need for interval reviews and management review. #### What the standards expect **Body:** ISO 9001 clause 7.1.5 requires monitoring and measuring resources to be calibrated or verified at specified intervals against traceable standards, and records kept as evidence. It also requires you to assess the validity of earlier results when equipment is found unfit. AS9100 and IATF 16949 add expectations on records, including as-received condition, and for IATF 16949 on laboratory scope. A log like this is the evidence trail linking each event to a certificate. **Bullets:** - Instrument ID and description - Date and next due date - As-found condition - Certificate number and who calibrated - Action on out-of-tolerance findings #### Common mistakes **Body:** Logging only the as-left state hides drift and makes interval reviews impossible, so always capture as-found. Keep due dates computed from the calibration date, not the date the instrument came back. Do not delete old rows when you retire an instrument; mark it retired in your gage master list instead. Finally, make sure the certificate number actually leads to a stored document, because a number without a file will not satisfy an auditor. **Cta:** If calibration due dates and out-of-tolerance impact reviews should be driven from your ERP, Netray can help connect them. **Faq:** #### Is a spreadsheet log acceptable to auditors? **Answer:** Yes, if it is controlled: restricted editing, backups, version history and a defined owner. Many organizations later move to a CMMS or QMS module for automatic due-date alerts and stronger access control. #### What should I record for an out-of-tolerance finding? **Answer:** Record the as-found readings, the date, the instrument ID and the product or processes it was used on since the last good calibration. Then document the impact assessment and any recall or re-inspection decision. #### How long should calibration records be kept? **Answer:** Retention is set by your quality system and customers. Many keep records for at least the life of the instrument plus a few years, and aerospace or medical customers may require much longer. #### Do I need one log per instrument? **Answer:** Either approach works. A single log with a gage ID column is easier to filter and summarize, while some labs keep a history card per instrument. Make sure the IDs match your gage master list exactly. ## Search terms calibration log template, calibration record template excel, calibration log sheet, equipment calibration record form, calibration tracking spreadsheet, calibration register template, ISO 9001 calibration records, gauge calibration record --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json