Template and calculator · Workplace safety

OSHA 300 log in Excel with the 300A and a TRIR calculator

Enter your recordable cases and hours and the calculator returns TRIR, DART and LTIR. Below: whether a case is recordable, what goes in each column of Form 300, the deadlines of 29 CFR 1904 and a template that adds up the 300A for you.
Get the Excel templateGet early access

Informational guide, not legal advice. Check the current rule at osha.gov (29 CFR 1904) and consult your safety professional.

TRIR

6.58

recordable cases per 100 full-time workers

DART rate

3.95

days away, restricted or transferred

LTIR

2.63

lost-time cases per 100 full-time workers

Rate = cases × 200,000 ÷ hours worked (BLS formula).

Free template

OSHA 300 log template, with the 300A and the rates calculated

The Form 300 columns with drop-down picks, the 300A totals, TRIR and DART for the year and by month, and a Check column that flags what an inspector would ask about.

  • · The Form 300 columns, with G to J and M1 to M6 checked from two drop-down picks
  • · The 300A totals calculated from the log, with the certification block
  • · TRIR, DART and lost-time rates for the year and by month, with the BLS formula
  • · Checks for cases entered after 7 days, privacy cases with a name and which report to OSHA applies

It mirrors the OSHA forms; whether it works as an equivalent form for your establishment is your call (29 CFR 1904.29(b)(4)).

What TRIR measures

Recordable cases per 100 full-time workers

The 200,000 in the formula is 100 people working 40 hours a week for 50 weeks, so the rate reads as cases per 100 full-time workers. With the calculator's numbers, 6.58 of every hundred: the red dots.

For reference, the Bureau of Labor Statistics reported 2.3 total recordable cases per 100 full-time workers across private industry in 2024. Compare against your own industry's rate on bls.gov, not the overall average.

The formulas

TRIR, DART and LTIR, from the same log

TRIR

Formula

Recordable cases × 200,000 ÷ hours worked

Cases counted

Every case on the log (G + H + I + J)

DART rate

Formula

(H + I cases) × 200,000 ÷ hours worked

Cases counted

Cases with days away, restriction or transfer

LTIR

Formula

H cases × 200,000 ÷ hours worked

Cases counted

Days-away cases only

These are BLS incidence-rate formulas; the rates are not part of Form 300A. Use hours worked from payroll for the same period as the cases, including overtime and temporary workers you supervise.

Is it recordable?

Check a case against 29 CFR 1904.4 to 1904.7

A case goes on the log if it is work-related, new and meets one of the general recording criteria in 1904.7. Answer one question at a time.

Question 1 of 7 · 29 CFR 1904.5

Did an event or exposure at work cause or contribute to it, or significantly aggravate a pre-existing condition?

Needlesticks, medical removal, hearing loss and tuberculosis have their own sections (1904.8 to 1904.11).

Form 300

What goes in each column of the log

The template keeps the letters of the official OSHA forms, so the 300A totals line up column by column.

A-C

What you enter

Case number, employee name (or "Privacy case"), job title

Watch out

Privacy cases are listed in 1904.29(b)(7); keep a separate confidential list of names.

D-F

What you enter

Date of injury or onset, where it happened, what happened and what was hurt

Watch out

Enough detail to tell the cause and severity; one or two lines.

G-J

What you enter

One check: death, days away, job transfer or restriction, or other recordable

Watch out

The most serious outcome. The template checks it from a single pick.

K-L

What you enter

Days away from work and days of transfer or restriction

Watch out

Calendar days, not counting the injury day; may be capped at 180.

M1-M6

What you enter

Injury, or one illness type: skin, respiratory, poisoning, hearing loss, other

Watch out

Totals by type go to the 300A.

Deadlines

The recordkeeping year, in six dates

From 1904.29, 1904.39, 1904.32 and 1904.41. The template's Check column flags the first two case by case.

  1. 7 days

    Enter each case on the 300 and its 301

    1904.29(b)(3)

  2. 8 h / 24 h

    Report a fatality / hospitalization, amputation or eye loss

    1904.39

  3. Feb 1

    Post the certified 300A

    1904.32

  4. Mar 2

    Electronic submission, if your size and industry require it

    1904.41

  5. Apr 30

    The 300A can come down

    1904.32

  6. 5 years

    Keep the log, 300A and 301s

    1904.33

Worked example

One year at a jam plant, already in the template

Five recordable cases and 152,000 hours worked at a fictional plant: TRIR 6.58, DART 3.95 and LTIR 2.63. The hearing-loss case was entered 14 days after the retest, and the template flags it.

Case

2026-01

Date

Jan 14

Job title

Line operator

Laceration to the palm from a broken jar; 4 sutures

Classification

Other recordable (J)

Case

2026-02

Date

Mar 3

Job title

Maintenance technician

Back strain lifting the conveyor motor M-204

Classification

Restriction (I) · 6 days

Case

2026-03

Date

Apr 28

Job title

Packaging operator

Standard threshold shift, both ears

Classification

Other recordable (J) · hearing loss

Case

2026-04

Date

Jul 9

Job title

Cook

Steam burn to the forearm at kettle K-1

Classification

Days away (H) · 3 days

Case

2026-05

Date

Oct 15

Job title

Warehouse operator

Fractured toe, foot run over by a pallet jack

Classification

Days away (H) · 12 + 5 days

In the app

The log comes from recording every incident

If each incident is logged and signed the day it happens, the 300 log and the year-end 300A do not depend on anyone remembering.

Get early accessFree app, in early access.

Frequently asked questions

OSHA 300 log and TRIR FAQ

What is the OSHA 300 log?
Form 300, the Log of Work-Related Injuries and Illnesses, is where an employer covered by 29 CFR 1904 records each recordable case within 7 calendar days. At the end of the year its totals go to Form 300A, the annual summary, and each case also gets a Form 301 incident report or an equivalent.
Can I keep the OSHA 300 log in Excel?
Yes. 1904.29 allows computer records and equivalent forms, as long as they have the same information, are as readable and understandable, and are completed using the same instructions as the OSHA form. Whether your file meets that is your call; many employers still print the official 300A to post it.
Who has to keep an OSHA 300 log?
Most employers with more than 10 employees. Employers with 10 or fewer employees at all times during the previous calendar year (1904.1) and establishments in the low-hazard industries listed in appendix A to subpart B (1904.2) are partially exempt. Every employer, exempt or not, must report fatalities, in-patient hospitalizations, amputations and losses of an eye (1904.39).
When do I post the OSHA 300A?
From February 1 to April 30 of the year after the one it covers, where notices to employees are usually posted, even if there were no cases. A company executive must certify it first (1904.32).
How do you calculate TRIR?
Multiply the number of recordable cases by 200,000 and divide by the total hours worked by all employees in the same period. 200,000 hours are 100 full-time employees working 40 hours a week for 50 weeks, so the result reads as cases per 100 full-time workers.
What is the DART rate?
Days Away, Restricted or Transferred: the cases in columns H and I of the 300 log, times 200,000, divided by hours worked. It counts the more serious cases, the ones that kept someone from their normal job.
Do I have to submit the 300 log to OSHA electronically?
Depending on size and industry. Under 1904.41, establishments with 20 to 249 employees in the industries of appendix A to subpart E, and establishments with 250 or more, submit the 300A each year; those with 100 or more in the industries of appendix B also submit the 300 and 301. The deadline is March 2 of the following year.
How long do I keep the records?
Five years after the end of the calendar year they cover, and you update the 300 log during that time if a case changes (1904.33).

Sources: 29 CFR 1904 · 1904.29 Forms · 1904.32 Annual summary · 1904.39 Reporting · 1904.41 Electronic submission · OSHA recordkeeping forms · BLS Injuries, Illnesses, and Fatalities. Reviewed on November 5, 2026.

Keep reading

Templates and guides for the plant floor

Job hazard analysis templateBreak a job into steps, rate each hazard and record the controls, with an Excel JHA.Maintenance log templateOne row per intervention, downtime calculated and repeat failures flagged.Work order managementFrom the request to the signed close-out, with response and repair time.All free templatesEvery spreadsheet with working formulas and a worked example.

Every shift without a record is data you lose. Start free.

  1. 1Request early access, free
  2. 2Pick your trade: maintenance, production or safety
  3. 3Your team starts with the chat and its trade helper
Get early accessBook an assessment

No credit card. Your data stays yours.

PLANT · SHIFT A
Tasks
Luis · maintenance
OVERDUE
Sugar silo 1
No signal since 05:40
Sensor · supply
TODAY
M-204 vibration
4.1 mm/s, above normal
Detected by the sensor
PROPOSED
Check the capper
14 badly seated lids since 08:30
AcceptDismiss
HomeTasksChatMore