Contract Tracking Part I

A few months back, a general counsel of a non-profit organization wanted to see examples of how their legal and contracts team could use SharePoint.  Our team built this proof of concept to show how SharePoint forms and workflows can be used to build a system that tracks contracts and invoices against those contract.  This is part one of the video series.  Part two of the video can be found here.


The transcript for the video is below…

Welcome to Part one of a two-part video series on Using SharePoint for Contract Tracking. Hi, I’m Dean, a SharePoint expert at Xgility, and in this video I’m going to demonstrate how to use a document library in SharePoint to store contracts and to capture information about each contract. I am also going to demonstrate how to track changes within a contract and how to track different versions of a contract. Finally, I am going to demonstrate how views can be used to gain insights as to the status of the contracts. Let’s begin.

As you can see here, I already have a document library set up and named “Contracts.” In it, I have created several columns for collecting information about each contract. I’m collecting the name of the vendor, the contract status, the contract start and end date, the initial value of the contract, the available balance remaining on the contract, and the percentage of the value remaining on the contract. The balance remaining and percentage remaining are calculated after invoices are processed against a contract. That will be the subject of Part two of this video series.

Adding a new contract to the library is very easy. Simply click “Upload,” choose a file, and click “Okay.” You will then be prompted to add some more information about the contract. This is a very important step, as this additional information is needed when processing invoices against the contract. In this case, I copy the name of the contract and paste it into the title field, then select a vendor from the drop-down and change the contract status if I need to. However, in this case, I am not going to. I enter the contract start and end dates, then enter the initial value of the contract and the available balance, which is the same as the initial value, as no invoices have been processed against this contract as of yet. Then I click “Save” to complete the contract upload process.

Now, lets take a look at how track changes works in Microsoft Word 2013. In reviewing the contract, I see that there are a few changes that the vendor needs to make before I accept it. There’s a line about where the services were rendered that needs to be removed and I also want the vendor to add a title next to Contract 1 at the top of the page. The vendor is going to make the changes and email them to me. At this point, the vendor has made the changes and sent me the updated document, which I have now downloaded onto my computer. I can update the contract by re-uploading it into the library, replacing the existing file. Notice how the name of the updated contract is the same as the original version. There is no need to manually change the name of a contract to reflect different versioning. SharePoint takes care of version control automatically in the background, again, so there is no need to change the name of the file manually. I do have to re-enter the information about the contract and click “Save” to complete the upload process.

Lets open the file in Microsoft Word 2013 and see that the changes have been tracked… Everything looks good. I’m going to accept all the changes and save the document to complete the process. To view the version history of the contract, click in the white space between the two columns to select that contract line item. Then click the Files tab, and click version history. As you can see, there are two versions of the file. The original one the vendor sent and the one that I just uploaded. You can use Version History to use or restore previous versions. In our case, we’re okay. I’m going to go ahead and close the dialogue box.

Right now there are just 5 contracts in the library, so it’s fairly easy to analyze what we have. However, in a few weeks, we’re expecting to have hundreds of contracts, and it will be much more difficult to analyze their status. That’s where list views come in. Views let you non-destructively reorganize what contracts are displayed.  This is similar to a sort in Microsoft Excel. In the library, I have three different views that I’ve created. All Documents, which is the default view created automatically, which shows all of the contracts. The second view is called “Below 20% Remaining,” which shows all of the contracts whose percent remaining is less than or equal to 20%. In this case, there are no results because all of the contracts are above 20% remaining. The third view is called “expiring within 30 days.” That shows you all the contracts whose end date is within 30 days. As you can see, views allow you to look at your information in different ways.

SharePoint libraries are a perfect solution for storing and tracking your contracts. In Part 2 of the series, I will demonstrate how to process invoices against a contract and automatically update its available balance and its percent remaining. Thank you for reading.

If you have addition questions are would like help automating your workflow in SharePoint, Office 365, or SharePoint Online please contact us.


Author: Dean Virag

Editor: Alex Finkel