The overwhelming majority of private companies, institutions and organizations are providers of some type of service which, in turn, are defined and controlled through contracts of various types.
As business revenue depends on the completion and, most of the time, contract renewal, it is essential to have all the information about each of them in hand to be able to analyze and make good decisions.
We have developed a control and contract tracking worksheet with that purpose and I will demonstrate how it works and can help you below.
1. Registration of Customers, Sellers and Types of Contracts
In all contract negotiations you have these 3 parts: contractor (customer), contract (seller) and agreement (contract). The basics of the basics is to always know who these 3s are in each situation. Therefore, the beginning of this worksheet is the registration of each of the parties.
2. Record of Contracts
Using the customer database, vendors, and contract types previously registered, you must record each agreement individually. This will be the basis of all your control, analysis and decision making.
At this point, you are already starting to gain time because it will not record all the information of a contract, but rather the most relevant ones such as duration, date of signature, value and expiration!
In that section of the spreadsheet you start earning time. Instead of searching hundreds of contract pages to find out where each one is, you can review the most important information from each contract individually by selecting from a menu.
In addition to all the practicality of finding the contract quickly with the necessary information, the spreadsheet also has an overview that allows you to make decisions also looking at the general situation of your contracts.
5. Report for Printing
If you wanted to review the reports in print or send / submit to others in the company, the spreadsheet already automatically compiles all the graphs and results ready for printing!
6. Indicators panel
Finally, you can analyze visual graphics about your current situation.
If you are interested, know the Contract Management Worksheet.