The monthly package for the bank. Today it's eight manual steps against a day-10 deadline, with reconciliation done by eye and tracking done in email threads.
Find the file on SharePoint, copy it, rename it for the current month.
Each item allocated by cost code category. Copy and paste doesn't work. Slow and easy to get wrong — a Copilot trial never became standard practice.
Run the report by job code, export to Excel, paste into the Current tab.
Check that totals match. Items entered outside MRI regularly cause variances that have to be traced by hand.
Export PDFs ordered by cost code. The order has to match the workbook.
Print Excel tabs to PDF, combine manually with the invoice PDFs.
Open the Word documents, update draw values and draw number. The requirement changes by lender.
Adam reviews everything from scratch, signs, submits by day 10. Tracking lives in email and a basic Excel file with no consolidated view.
Copies the prior draw workbook, creates the current-month version on SharePoint, and asks for the two exports by day 6.
The only touchpoint with internal systems. Two exports, about five minutes.
If both are there, the sequence runs. If not, the reminder goes out again.
Moves Current to Prior with the right cost code categorisation, populates the Current tab from the MRI export, compares totals, and produces a variance list — only what needs a person.
Tabs to PDF, combined with invoices in the right order. Lien waivers and disbursement requests pre-filled with draw values, per lender.
Package ready, variance list, documents waiting for signature.
Adam sees only what Claude flagged. Twenty to thirty minutes instead of hours.
Adam submits the package. When the bank responds, he tells Claude and the tracking view updates.
The same workbook, rolled forward tab by tab, every month. The work is identical each time — which is exactly what makes it worth handing over.
Locate and copy the file, every month.
For every prepaid: reduce months remaining, highlight the next line, update the amortised balance. Repeated tab by tab.
Export the monthly trial balance and paste it into the main tab by hand.
Compare every account balance to the support tabs. The variance has to be zero — anything else is investigated manually.
Adam reads every tab to validate the financial statements.
Copies the prior month file and asks for the trial balance once the numbers close.
The only step that needs MRI access.
Reads each prepaid tab, reduces months remaining, highlights the next line, recalculates amortised balances — all tabs, in one pass.
Positions the trial balance in the main tab and compares each account against its support. Delivers what tied out and what didn't.
The workbook arrives reconciled with variances highlighted. Focused review instead of re-reading every tab.
Brian has no visibility into where the team's work stands across projects. Processes and their statuses live in people's heads, so getting an update means asking someone directly.
Where it stands today
What we propose
We will build a lightweight tracking environment inside Microsoft 365 — a board or list per project where the team marks where each task stands. Brian gets the view he needs without adding another tool or login.
Brian realises he doesn't know where a project stands.
He messages or calls the owner of that piece of work.
The team member recalls the current state, sometimes checking other people first.
Brian has the answer for now, but nothing is stored for next time.
Sees every project and its current stage in one view.
As work moves, the owner moves the card or updates the status.
Filters by project, owner, or status. No need to interrupt anyone.
Past projects show how long stages took, making future planning easier.
To see where a project stands financially, the only route today is MRI — open it, pull the statement for that property, then do it again for the next one. There's no view of the portfolio as a whole.
Where it stands today
What we propose
We don't integrate with MRI. The export is the interface. Claude consolidates the exports into a single Excel workbook — one row per property, standard columns — and the dashboard reads that workbook.
The statements you already pull, saved to a folder instead of read on screen.
One location, already governed by your existing permissions.
Reads every export, normalises it, writes one row per property.
A single Excel file, refreshed on a schedule. Auditable, and openable on its own.
Portfolio view, drill-down per property, current whenever it's opened.