After you determine your dollar per hour goal for 2010, create a job costing report, and adjust prices as necessary; it is time to create and send out renewal contracts.

There are various ways to create renewal contracts. Some people do it manually, typing up each contract. Another option is to create a mail-merge in Microsoft Word using data from a CLIP report.
The easiest way is to create the contracts directly from CLIP using “Estimates in Jobs”. This feature will enable you to create customized proposals and automatically add pricing and contract information from CLIP.
The following will serve as an introduction to the steps involved in creating a proposal using Estimates in Jobs. At the bottom of the post, I will provide some other resources for further instruction.
Application Action: To best learn this process, I suggest that you create a test copy of CLIP and follow these directions step by step in your test copy of CLIP.
1. In File Maintenance, choose a customer and a job. From the Job Detail Screen, click on the small button next to the Estimate Code.

2. Click Add/Edit Templates.

3. Click Add.

4. Type in a contract code, description, and file name. If you want to use an existing file, click the small button next to the description field to choose the file. Click Save.

Note: If the file name does not exist, CLIP will ask you if you want to create it. Go ahead and do so.
5. Wait while CLIP creates the database necessary for the proposal. Click OK to close any dialog boxes that open up.
6. With the blank Microsoft Word document open, type or paste in your contract details.

7. Next you will need to add the “Merge” fields. This is the data that is transferred automatically from CLIP (i.e. price or number of visits). To add a merge field, click on the place in the document where you want to add the field. Next, click, insert merge field and select the data that you want to insert. Repeat for each field you want to add.
8. Preview the contract to make sure everything is correct by clicking the “Preview Results” button.

9. Save and Close the document.
10. In CLIP, click return twice to get you back to the Job Detail screen. Click Create Estimate.

11. Choose the proposal you just created from the list, then type in a description and click the button to the right of the description.

12. On the next screen, select the job(s) you want to include in the contract by checking off the “Include?” and/or “Part of Contract” buttons. Add any notes you want. Add contract information such as number of months, discounts, etc.
13. After you have ensured that all of the information is correct, click Continue.

14. CLIP will ask you if you want to see the spreadsheet created. Click NO.
15. You will now have the contract created and saved in CLIP for printing or later viewing.
This contract can now be used for other customers as well.
While the process outlined above only creates a proposal for one customer, you can use Estimates in Jobs to mass produce proposals as well. See the webinar below for details on mass producing proposals with this feature.
Additional features of Estimates in Jobs include:
- Create Estimates for New Customers
- Mass Produce Estimates (File Maintenance > Estimates/Proposals > Estimates in Jobs > Create Mass Estimates/Proposals)
- Create estimates including multiple jobs.
- Include some jobs in contract and leave some as pay per visit.
- Track the status of estimates.
For more information, check out these references:
Manuals:
| Estimates in Jobs |
 |
| Mail Merge Guide for CLIP |
 |
Webinars:
| Step 1 – Prepare Data |
 |
| Step 2 – Create a Simple Proposal for 1 Job |
 |
| Step 3 – Create a Proposal for Multiple Jobs |
 |
| Step 4 – Mass Mailing Estimates |
 |
More questions? Email me or post a comment.

Loading ...
Stay tuned for parts 5 and 6.
End of Year Projects Overview:
1. Revise our dollar-per-hour goal to account for any changes in the upcoming year.
Part 1 & Part 2
2. Use CLIP to create a job costing report for this year.
3. Analyze profitability of customers. Adjust prices as necessary.
4. Create and send renewal contracts.
5. Survey customers for feedback from this year.
6. Follow up in order to maximize contract renewals.