Prove the training happened — hours, competencies, and sign-offs in one owned file
A registered-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 record on paper — loose timesheets, a binder, one supervisor’s memory — and it falls apart the moment someone audits it.
The Apprenticeship / OJT Training-Hours Logbook is the fix: one owned workbook where every hour ties to the competency it built, every sign-off is recorded with who signed and when, and one Dashboard shows exactly who is ready to complete. Log for a single apprentice or a whole cohort — the whole program’s readiness stays in view.
What it does that a blank sheet or a pile of timesheets can’t
- Logs hours by competency, with the sign-off attached. Every block of on-the-job time ties to one competency and the mentor who trained it. Mark it signed off and record who verified it and when — the granular audit trail behind the totals.
- Turns hours into a signed-off competency. The Competency Progress tab pulls the required hours from your framework and sums the logged hours from the OJT Log, then reads its own status: Not started, In progress, Hours met (enough hours, awaiting a signature), or Signed off. You never total a column by hand.
- Flags who’s ready to complete. The Dashboard checks the same three things a completion review does — required OJT hours met, required RTI (classroom) hours met, and every tracked competency signed off — and flags each apprentice Ready for completion, Nearly there, or In progress.
- Counts the classroom too. The RTI Log captures the related technical instruction hours that run alongside the OJT, totaled against each apprentice’s required RTI — so the instruction side of the record is as complete as the hours side.
Built around your trade’s competencies
The workbook ships with a worked example for an Industrial Maintenance Technician — eight competencies across four areas, each with an example required-hours target — so you can see the whole thing working before you enter your own. Swap in your trade’s work processes and your sponsor’s required hours, add your apprentices, and the OJT Log, Competency Progress, and Dashboard all follow. Electrical, mechanical, plumbing, HVAC, welding, machining, manufacturing — it’s the same workbook, edited to your standards.
Works in Excel, Google Sheets, and LibreOffice
One .xlsx opens natively in Excel and LibreOffice Calc. Prefer Google Sheets? The download includes a one-click “Make a copy” link to a ready-made native Google Sheet — every dropdown, formula, and color already set up and tested. No importing, nothing to rebuild.
Own it, don’t rent it
You own this file outright — no seats, no monthly fee, no apprenticeship-management platform holding your program’s evidence behind a login. Keep it, reuse it for the next apprentice, and hand it to an auditor on your own terms. That’s the difference between a program that can prove itself and one that hopes it won’t be asked.
Try it free first
Want a taste before you buy? The free single-apprentice hours log lets you log one apprentice’s OJT hours with a running total — no signup. When you need sign-offs, competency progress, and completion readiness for a whole program, this is the full logbook.
What you get
A 7-tab workbook (Read Me, Competencies, Apprentices, OJT Hours Log, RTI Log, Competency Progress, Dashboard) plus four PDF guides — a Start Here guide, a Competencies & Sign-Off guide, a Hours & Readiness guide, and printable hours & sign-off sheets. Instant digital download; nothing is mailed.
A record-keeping and progress-tracking template — not legal, compliance, or registration advice. It is not affiliated with or endorsed by the U.S. Department of Labor, any state apprenticeship agency, or any Registered Apprenticeship program. The example apprentices and required-hours figures are fictional and illustrative; your registration agency’s or sponsor’s own required hours, competencies, forms, and process govern.
