One inbox, nine companies (EN)

12:46 · English · Asset Management

Watch this video

Enter your details to access the library. We'll email you a code to verify your address.

See how we use your data in our Privacy Policy.

About this video

Nine companies building one Tampa tower drop their paper into one shared inbox, named however they like; Ellie's Librarian files every document where the rules say and holds what it will not guess at.

Full description

Sandiford Riverwalk is a 1.1 million square foot mixed-use development in Tampa with a US$1.2 billion Ironbrook construction loan behind it. Every month nine companies send the owner and the lender a piece of paper: the general contractor's pay applications, lien waivers and site scans, the architect's instructions, counsel's executed amendments, the supplier's invoices, the insurer's renewal certificate, the property manager's budget, the leasing agent's report. Recorded live: three drops land in one shared inbox and Ellie's Librarian runs three times, filing each document under a name that says what it is, archiving the drafts the executed versions supersede, catching a duplicate, holding an earlier negotiation draft and a budget with salaries in it for a human, and republishing the Document Register after every run. Then the lender's asset manager asks the filed room what is still outstanding for Draw 18: a US$2.18 million holdback traced to a transposed purchase order number and missing off-site insurance, a lien waiver a month short, and a builder's risk renewal that dropped the lender as loss payee and doubled the windstorm deductible.

Key points

  • One inbox for every party; a Librarian that files by content, not by filename
  • Supersession, duplicates and drafts handled by rule, never two live versions side by side
  • Sensitivity overrides classification: a budget with salaries goes to a human, not to Finance
  • A Register republished every run, every row linking to its source file
  • Then the lender's question: what is outstanding for Draw 18, in dollars, cited to the clause
Transcript

Sandiford Riverwalk, a 1.1 million square foot tower going up on the Tampa Riverfront, a $1.2 billion construction loan behind it, and nine companies who each send the owner and the lender a piece of paper every month. This workspace is their shared data room. Everyone uploads to one folder, and a librarian does the filing. The room already holds the standing paper, the loan agreement and its first amendment, the GMP contract, the curtain wall supply agreement and its purchase orders, last month's pay application and monitor report, the builder's risk certificate, 10 documents, each filed under a name that says what it is, and one folder called inbox.

Right now, it holds nothing but the note telling participants to drop their files. Here it is. The last week of August. Bexmoor's superintendent scans the week's daily reports off the site printer. Their accountant sends a draft pay application. The architect issues an instruction on the podium waterproofing and the RFI log. Tarnhill, the curtain wall supplier, invoices a milestone and certifies the units sitting in their yard in Minneapolis. The developer files the owner's monthly report and a budget reallocation request.

Lenders counsel uploads the executed second amendment to the loan and a month late last month's title endorsement. The insurer sends the builder's risk renewal 12 files named however each of them liked. Scan_000038.pdf inv 2026871 riverwalk OMR August version 3 final. Nobody in this list is going to find anything by file name. so we run the librarian. It is a filing clerk, not an analyst. It reads each document only far enough to know what it is, who it is from, and what date it carries, then files it against the room's written rules.

Watch it start. It hashes every file in the inbox against the inventory, so it knows a duplicate before it reads a word. Then it reads the filing rules in full and only then opens the documents. 12 documents will take it about a quarter of an hour. We will let it work and come back when the inbox is empty. 9 minutes later, 12 documents seen, 12 filed, and the inbox is empty. Here is the librarian's own account of where everything went. it read the filing rules first, then every document, and it names each one for what it is.

The scan off the site printer scan 0038 is now Bexmoor's superintendent daily reports week 34 under capex and projects. The insurers's renewal is a certificate filed by policy period. The builder's draft pay application is recorded as a draft not as a live payment position because it is stamped not for payment. And the register is republished at the end of the run under the same title every time. Every row linking back to its file. 22 documents. Now, one choice worth a second look.

Tarnhill's stored materials certificate went under warranties and certificates because the room's rules were written for a standing building and never named development paper at all. The librarian found the nearest shelf. It is not allowed to invent a new one. So, a human extends the rules, not the librarian. We ask Ellie to make three edits to the filing rules in the room. development paper, lien waivers, stored materials, certificates, monitor reports, change orders gets one consistent home under capex and projects.

And the lender's draw paper goes under debt and financing. Ellie edits the file in place and shows the diff. Version 1.2. The librarian will read it on its next run because it reads the rules in full every time. First week of September, the real pay application arrives. Signed and notorized. The lien waiver bundle. Change order 31 signed by all three parties. The schedule update. Wrenfield's draft monitor report, the draw request with its sources and uses, Kerridge's first pre-opening budget, the leasing status from Bramwell Cross, and tidying her own files, the development manager uploads the July draft of the loan amendment that counsel executed a week ago.

And 10 minutes after sending the waiverss, Bexmoor's accountant sends them again. 11 files, one of them a byte for byte duplicate, one of them a draft of a document that is already executed and live. we run the librarian again. It starts the same way every time. Hash the inbox against the inventory. Read the rules. Now, version 1.2. Then the documents. 10 minutes. 11 documents, eight filed, three held, one duplicate suppressed, one supersession. This is the run that shows why a room needs a clerk.

The executed pay application is filed as version two and it supersedes the draft. The draft moves to the archive, keeping its original path beneath it, and its row in the inventory flips to supersede. Two live versions of the same document never sit side by side. The waiver bundle that was sent twice, same hash, same 26,000 bytes filed once, the copy held in suspected duplicates. The July draft of the loan amendment, same type, same counterparty as the executed version that is already live, so it did not supersede anything.

It is held as a likely earlier draft for a human to decide. and Kerridge's pre-opening budget, plainly a budget, but its staffing tab names eight people with their salaries. Sensitivity overrides classification. It goes to the sensitive queue, not to finance. And it notices without acting on it that the borrower asked for 31.4 million while the monitor's draft recommends 29.2 and that one waiver runs to the end of July, not August. Cataloged, not judged.

Reconciling them is not a filing matter. On the shelves, it looks like this. The archive holds the superseded draft under the path it came from. And the quarantine holds what a human needs to look at the certificate. The rules did not cover the duplicate, the negotiation draft, the budget with salaries in it. The following week, Wrenfield's final monitor report recommending 29.2 million against the 31.4 requested, the draw 18 title endorsement, Ironbrook's funding approval, the structural inspection record for levels 22 to 26, and an invoice from the architect for concept design on parcel C, the next phase, which is not part of this loan at all.

Third run. 8 minutes, five documents. The final monitor report supersedes its draft, which moves to the archive. The title endorsement is filed next to last month's because each covers its own advance. The lender's funding memo is held as lender internal, the same call it made for draw 17. And the architect's parcel C invoice is filed as an invoice with a note that it concerns a site this room has never seen. Opening a new asset is a human call, so it says so and moves on.

Three drops, three runs, and the register on the homepage has been republished each time under the same title. 38 documents, 31 live, five in quarantine, two superseded. Every row links to its file. The original file name, the filed name, where it went, who it is from, its date, its status. This is the index of record, and nobody typed a line of it. The clerk has done its job. Now, the lender's asset manager asks the room a question a clerk would never answer.

Is draw 18 ready to fund? What did the monitor hold back and why? And does the paper the nine companies sent actually support it? Ellie starts with the loan agreement. 7 minutes later, the answer. Wrenfield held back $2.18 million, the whole curtain wall line. Tarnhill's invoice sites purchase order 0117. That order covered levels 8 to 12 and was paid in draw 12. The open order for the levels on the invoice is 0171 for exactly the amount invoiced.

A clerical error, but paid against the wrong order. It would have been a $2 million duplicate payment. The lien waivers, 11 of the 12 run through the 31st of August. Halvane electricals runs through July. $3.2 million of electrical work with the whole of August unwaved. And the monitor noted it without deducting it. and the insurance renewal that nobody had read. The lender is no longer named as mortgagee and loss payee on a $780 million policy. The named windstorm deductible went from 2% to 5, $23 million of extra retained risk on a Tampa waterfront in hurricane season against a covenant that caps it at two.

Then the list of what the borrower still owes before the advance can fund in full in the order that releases the money. Each item traced to the clause that requires it. $5.4 million of the request is exposed until they cure. Nine companies, one inbox, three runs of a clerk that never guesses, and one question the room could finally answer. Not a tidier folder, a data room every party can write to and one lender can trust.

Fifth Dimension for asset managers

Asset performance, always current

Video details
Roles
Owner, Lender
Processes
Asset Management
Geographies
US
Markets
United States
Tags
riverwalk-dataroom-inbox, data-room, development