If you build software — or you just think like someone who does — tax-season hour tracking looks like a data-integrity problem. The "schema" is simple. The failure mode is human: late writes, missing foreign keys (which property?), and blobs of evidence that are not joined to the event they support. This post treats a material participation hour log like a small production system you keep running all year.
Still not tax advice. IRS Publication 925 is the primary public reference for passive activity and material participation concepts. Your CPA interprets it for you.
The schema
Each activity row needs:
date property_id actor # you vs invited participant minutes # actual, not rounded fantasy category # repair, turnover, bookkeeping, ... description # human-readable evidence[] # optional but valuable attachments created_at # when the record was written
Enter fullscreen mode
Exit fullscreen mode
Contemporaneous created_at close to date is part of the story you may later need to explain.…