Form: Calibration Certificate and CMMS Reconciliation Log

This is a ready-to-use periodic reconciliation log for the hybrid record formed by a calibration certificate (paper or signed PDF) and its corresponding entry in an electronic calibration management system (CMMS). It does not replace the calibration record itself (the as-found/as-left data for a single event); it is a sampling control that proves the CMMS status a reviewer trusts actually matches the certificate behind it. Replace every <<FILL: ...>> placeholder. A filled sample row follows. This content is general educational reference, not legal or regulatory advice.

Instructions

Pull a risk-based sample of instruments from the CMMS each reconciliation cycle, biased toward high-criticality equipment, instruments due or recently calibrated, and any instrument flagged in a prior cycle.
For each sampled instrument, retrieve the certificate behind the current CMMS status and complete one row.
Any mismatch is a finding; route it per the instructions in the Field table below, never silently correct the CMMS without a record of why.
Retain completed logs per the records retention schedule, for not less than <<FILL: retention period>>.
Who performs this: <<FILL: role, e.g. Metrology Coordinator>>. Who reviews and approves: <<FILL: role, e.g. Quality Assurance>>. Frequency: <<FILL: e.g. quarterly, sample size N instruments or X% of the active population>>.

Field table

Field	Format	Required	Who completes it	When
Instrument ID / asset number	Text, matches CMMS asset tag	Yes	Reviewer	At sampling
CMMS status (due date, pass/fail)	As shown in the system at time of review	Yes	Reviewer	At sampling
Certificate located and attached in CMMS (Y/N)	Y/N	Yes	Reviewer	At sampling
Certificate due date	Date, as stated on the certificate	Yes, if certificate found	Reviewer	At sampling
Due dates match (Y/N)	Y/N	Yes, if certificate found	Reviewer	At sampling
Certificate as-found result	In tolerance / Out of tolerance, adjusted / Out of tolerance, not adjusted	Yes, if certificate found	Reviewer	At sampling
CMMS result matches certificate as-found result (Y/N)	Y/N	Yes, if certificate found	Reviewer	At sampling
Multi-point data reviewed, any single point out of tolerance despite overall “Pass” (Y/N)	Y/N	Yes, where the certificate reports multiple test points	Reviewer	At sampling
Finding raised (Y/N, reference)	Y/N and deviation/CAPA number if Y	Yes	Reviewer	At sampling
Disposition	`<<FILL: resolved how>>`	Yes	Reviewer + QA	At closure

What a finding means

What you found	How to treat it
Certificate attached, due dates and pass/fail match	No finding. Record and move on.
Certificate not attached but located elsewhere and confirmed to match	Documentation gap. Attach it, note the gap, trend for pattern.
Due date on the certificate disagrees with the CMMS due date	Investigate whether the instrument was used past its true due date before correcting either record; raise a deviation if it was.
Certificate reports “out of tolerance, adjusted” but CMMS shows only “Pass” with no narrative	Significant finding. Assess product/data impact of readings taken before the adjustment; correct the CMMS to carry the full result, not a collapsed binary.
Certificate cannot be located at all	Treat the CMMS status as unsupported until the certificate is found or the calibration is repeated; do not treat “system says Pass” as sufficient on its own.

Acceptance criteria

Every sampled instrument’s CMMS status is supported by an attached, matching certificate. Due dates on the certificate and in the CMMS agree, or a documented investigation explains and resolves the discrepancy. Any as-left adjustment on a certificate is reflected in the CMMS narrative, not hidden inside a binary pass. Every finding is dispositioned with a record of what was done, not a silent correction.

Filled sample row

Field	Entry
Instrument ID	Balance BAL-0142
CMMS status	Pass, due 14 March 2027
Certificate located and attached	Y
Certificate due date	14 March 2027
Due dates match	Y
Certificate as-found result	Out of tolerance at the 200g point, adjusted
CMMS result matches certificate	N, CMMS showed only “Pass” with no adjustment narrative
Multi-point data reviewed	Y, the 200g point was out of tolerance; 10g and 1000g points were in tolerance
Finding raised	Y, DEV-2026-0311
Disposition	Product-impact assessment opened for batches weighed on BAL-0142 between its prior calibration and this event; CMMS narrative field updated to record the as-found deviation and adjustment

Common inspection findings this log prevents

A CMMS status relied on with no certificate ever produced to support it.
A calibration due date quietly changed in the CMMS with no corresponding change on, or explanation against, the certificate.
An out-of-tolerance-then-adjusted result buried inside a system that only records “Pass,” hiding a product-impact question that was never asked.

How to adapt this log

Set your sample size and frequency from the size and criticality of your equipment population; a larger population generally needs a larger or more frequent sample to give the same assurance.
Point the deviation reference field at your actual data integrity or quality event procedure.
If your CMMS already captures multi-point data natively, adjust the “multi-point data reviewed” field to a direct system query rather than a manual re-check of the certificate.