How to Track Apprenticeship OJT Hours for an Audit (Trades & Manufacturing)

An apprenticeship or on-the-job-training (OJT) program runs on evidence. The hours an apprentice puts in, the competencies they master, and the sign-offs that prove it are the record a sponsor or registration agency asks to see. Most programs keep that on paper — loose timesheets, a binder, one supervisor’s memory — and it falls apart the moment someone audits it. Here’s how to document it so it holds up.

This is the method behind the Apprenticeship / OJT Training-Hours Logbook, and you can follow it in any spreadsheet.

Step 1 — Build your competency framework

Hours on their own don’t prove much. “Two thousand hours” means little; “2,000 hours across lockout/tagout, bearings and couplings, motor controls, and PLC troubleshooting, each signed off” is a record.

List the work processes an apprentice must master, grouped by area, and set a required-hours target for each — straight from your trade’s or your sponsor’s published standards, not from scratch. For an industrial maintenance technician, that might be:

Keep the competency names short and unique — they’re the key every logged hour will point back to.

Step 2 — Log OJT hours against the competency they built

Record each block of on-the-job time as it happens: the date, the apprentice, the one competency it built, the hours, and the mentor who trained it. Log by the day, the week, or the pay period — whatever your program records. The discipline that matters is tying every hour to a competency, so a raw total becomes evidence of what was trained.

The single most valuable habit in the whole system is logging as you go — at the end of each rotation or pay period, not in a scramble before a review.

Step 3 — Capture the sign-off with a name and a date

An auditor rarely doubts that hours were worked — they doubt the hours were verified. A sign-off is a named mentor or supervisor attesting, on a date, that the work was done to standard. Capture it at two levels:

• On the hours as they’re logged — the granular trail behind the totals.
• On the whole competency once the apprentice is judged competent in it — the line a completion review reads: competency X, signed off by Y, on date Z.

Sign off while the work is fresh. The hardest signature to get is the one you chase six months later, when the supervisor barely remembers the job.

Step 4 — Track the related classroom (RTI) hours

Most registered apprenticeships require Related Technical Instruction (RTI) — classroom or online theory — alongside the OJT. Log each course, its hours, and whether it’s completed, against each apprentice’s required RTI total. A program that nails its OJT hours but loses track of the classroom hours is still only half-documented.

Step 5 — Read completion readiness

Sooner or later you have to answer the question a sponsor and a registration agency both ask: is this apprentice done? A completion review checks the same three things:

1. OJT hours — are the required on-the-job hours in?
2. RTI hours — is the related instruction complete?
3. Competency sign-offs — is every tracked competency signed off?

Only when all three are true is an apprentice ready to put forward. Short of that, they’re nearly there, in progress, or not started — and one glance tells you who to submit and who still has hours or signatures outstanding.

“Ready” means the record shows everything your standards require is in place — not that a credential has been granted. The actual completion or certification is your registration agency’s or sponsor’s to award, under their process.

Do it in a workbook you own

You can build all of this in a blank spreadsheet, but you’ll write every competency rollup, sign-off status, and readiness flag yourself. To log one apprentice’s hours for free, start with the single-apprentice hours log — an ungated taste. When you need the sign-offs, the per-competency progress, the RTI tracking, and the completion-readiness dashboard for a whole program, the Apprenticeship / OJT Training-Hours Logbook does all of it in one owned file — Excel, Google Sheets, or LibreOffice, with a one-click Google Sheets copy — so you keep the record and hand it to an auditor on your own terms.

This is a record-keeping and progress-tracking method, not legal, compliance, or registration advice. Ardent Workshop is not affiliated with or endorsed by the U.S. Department of Labor, any state apprenticeship agency, or any Registered Apprenticeship program. Required hours, competencies, and forms vary by trade, agency, and state — confirm yours against your own standards.