CASE 21
Contract Engagement Ledger
Signed agreements used to live wherever they landed, in inboxes, folders, and memory. Now one ledger answers the question that matters: who has signed what. 123 counterparties, 215 executed agreements across six agreement types, each filed to its record with the latest date in view.
- Role
- Document workflow, filing logic, and ledger design
- Client
- A growing team with a roster of clients
- Year
- 2026
- Stack
- Web app · Automation · Document pipeline
- Status
- Live in production
01 The problem
Every signed contract starts life as an attachment in an inbox. Filing one by hand means downloading it, working out whose it is, renaming it, dropping it in the right folder, and pasting the link back onto the record. A growing team and a roster of clients turn that into a recurring afternoon, and the chore gets put off. The deeper cost shows up later, as a question nobody can answer quickly: do we have a signed service agreement with this client, an executed contractor agreement for that hire, a HIPAA BAA on file with this partner? The answer lived across an inbox, a folder tree, and somebody’s memory.
02 The system
One ledger holds the whole answer. Every counterparty sits on its own row. Across the row, a column for each agreement type: service agreements, contractor agreements, software development agreements, statements of work, HIPAA BAAs, and everything else. A check means the executed copy is on file. The latest date sits at the end of the row, drafts are flagged until they are signed, and a search plus type filters cut 123 counterparties down to the one you mean. Underneath, the filing pipeline keeps the ledger honest on its own. It sweeps for completed agreements, keeps the executed copy straight from the e-sign service, shelves each document where it belongs, and links it onto the counterparty’s record. Signed agreements are sensitive paperwork, and the pipeline keeps them in the folders and records the team already runs rather than building a pile of its own, the same thinking behind keeping no central store of sensitive documents. Nobody opens an attachment or drags a file anywhere.
03 The details that make it hold up
The sweep uses a filing key to skip agreements already recorded, so a scheduled rerun or restart after interruption does not create another ledger entry under the tested path. It sorts on agreement content rather than a filename, and sets unusual documents aside for review. The source is the executed copy from the e-sign service, with cover sheets and certificates excluded. A counterparty can be renamed or refiled under the right agreement type without breaking the document link. The first run processed the available back-history in one pass.
04 The result
The question that used to take a dig through the inbox now takes a glance. 123 counterparties, 215 executed agreements, six agreement types, one screen. New agreements file themselves and light up their row on their own, drafts show as drafts until the signature lands, and the day someone needs the signed copy itself, it is already on the record, named, dated, and one click away.
05 Frequently asked questions
What is a contract engagement ledger?
One screen that tracks every counterparty and every executed agreement in a business. Each counterparty holds a row, each agreement type holds a column, and a check means the signed copy is on file and linked to the record. This one tracks 123 counterparties and 215 executed agreements across six agreement types.
How do you track which clients have signed agreements?
Stop tracking it by memory and inbox search. The ledger shows a check for every executed agreement a counterparty has, with the latest date beside the row and drafts flagged until they are signed. Search and type filters answer questions like which clients have a signed service agreement in seconds.
How does automated contract filing avoid duplicates?
The pipeline checks a filing key and skips an agreement already recorded. That idempotent path covers scheduled reruns and recovery after an interrupted pass without creating another ledger entry.
How do you know the filed copy is the final signed version?
The pipeline takes the executed copy from the e-sign service and excludes its cover sheets and certificates. The saved record links back to that executed source, while unusual document structures are held for review.
· How it works
- 01
Pull the signed copy
It sweeps for every completed agreement and keeps the executed copy straight from the e-sign service, skipping the cover sheets and certificates so only the real signed document is saved.
- 02
Sort by what it is
It reads each agreement and shelves it on its own: a client service agreement to the client archive, a contractor agreement to the people archive, anything unusual set aside for a look.
- 03
File it onto the record
Every file is dated, named the same way, made shareable for the team, and linked onto the counterparty it belongs to, so the signed copy sits one click from the profile.
- 04
Light up the ledger
The ledger updates itself: a check appears in that counterparty's row under the right agreement type, with the latest date beside it and drafts flagged until they are signed.
· Results
- Counterparties
- 123
- Executed agreements
- 215
- Agreement types
- 6 tracked
1. The filing key skips agreements already recorded, which makes scheduled reruns and recovery after an interrupted pass idempotent under the tested path.
2. Routing uses the agreement content rather than the filename. Unusual or low-confidence documents are set aside for review instead of being forced into a shelf.