Making OneDrive and SharePoint actually work for deal teams

The folder structure problem

Left alone, folder structures evolve on their own. One partner creates folders by client name. Another creates them by year. A third uses a hybrid of both. Before long nobody can find anything without asking someone, and the firm's filing logic lives in the heads of the people who created the folders.

The fix is a standard deal folder template, applied every time a new mandate opens. Each mandate gets an identical structure of engagement letters, NDAs, financial information, due diligence materials, process documents and correspondence, with subfolders that follow the deal lifecycle. Anyone who opens a mandate folder knows where to look. SharePoint site templates can apply reusable lists, themes and layouts to a new site, so the set-up does not depend on whoever happens to open the mandate.

Access control that actually works

SharePoint's permission system is powerful but easy to get wrong. Firms often land at one of two extremes: everything shared with everyone, or nothing shared at all. For deal work the better model is mandate-level permissions. Each deal folder is open only to the team assigned to that mandate, and people outside the firm get time-limited access to specific documents when they need it, such as a CIM for a prospective buyer.

SharePoint supports this directly. Administrators can make guest access expire automatically and can require Anyone links to expire. Microsoft is also clear that you cannot track who has opened an item shared through an Anyone link, so links to named people are the better choice for deal documents.

It also gives you a better answer when a client asks who had access to what. Administrators can use the Microsoft 365 audit log to see how files were shared, including with people outside the firm. "Everyone in the firm could see everything" is not an answer anyone wants to give.

Version control without the pain

Version history is easy to overlook. It is built into SharePoint and OneDrive, and it shows when a file changed and who changed it. You can view or restore an earlier version, and compare versions of a Word or Excel file. For deal documents, where "final_final_v3_ACTUAL.docx" is a genuine filename pattern, that removes much of the version confusion that slows a deal team down.

One caution: versions can be trimmed. Administrators and site owners set limits by count and by age, and anything past those limits is deleted automatically. Check the policy before relying on it for an old draft.

The best document management system for a small firm is often the one it already has, configured properly.

Integration with deal workflow

The real value arrives when document storage is connected to the deal workflow. When a new mandate opens in the deal system, the matching folder can be created with the right structure and permissions. When a document is uploaded, it can be tagged to the relevant mandate. When someone searches for a file, they search within a deal rather than across the firm's entire library.

That moves OneDrive and SharePoint from passive storage to an active part of the deal process. It is the difference between having a filing cabinet and having a filing system.