At my two-attorney firm, I’m refining our will-drafting workflow and estate asset tracking — right now it’s a 2-page intake questionnaire plus an Excel ledger and HotDocs templates. What general resources or templates have helped you keep fiduciary notices, pecuniary bequests, and tangible property memos organized without overcomplicating the file? Looking for workflow ideas only; jurisdiction-specific questions will be handled by the supervising attorney.
Add ‘asset class’ and notice-due columns to your Excel; map HotDocs fields accordingly; ACTEC’s resources help: Resources for Law Associates & Students.
I’ve had good results with a single “beneficiary matrix” tab that drives both bequests and fiduciary notices — think of it like a cast list for the estate. Each row is the person/entity with columns for gift type (pecuniary/specific/residuary), notice trigger/recipient, doc cite, and a tangible‑memo reference; HotDocs pulls by row ID so Excel stays the source of truth. Building on @jthompson21, would it fit your intake to add one checkbox that, if a tangible memo is expected, auto‑generates the memo template plus a reminder letter, or is that too much for a two‑attorney shop?
Quick win: build a one-page ‘cover sheet’ auto-filled from HotDocs that lists each GiftID, recipient, notice trigger, and where it lives in the file, and mirror that with a GiftID column in your Excel so everything cross-references. It keeps notices and specific gifts straight without bloating the workbook — think of it as a luggage tag for every disposition. Caveat: split gifts or charity conditions may deserve their own IDs or lines; would a simple ‘event log’ tab for sent/received dates fit your flow?