ABCDEFGHIJ
1
YOU CANNOT EDIT THIS TEMPLATE - CLICK "FILE" and "MAKE A COPY" FIRST THEN GET STARTED UPDATING YOUR INFO
2
3
4
5
6
GET STARTED WITH YOUR
7
CRM REPORT
8
9
If you are looking for a system to organize your contacts, solidify a sales process, and automate some of your ongoing tasks then you need a CRM (customer relationship management) solution. This template provides you with the basics of a CRM. It's the perfect place to start if you aren't quite ready for a full-blown CRM with advanced features. This mini-CRM automatically saves changes so you will never lose data. To get started, just enter your contacts manually or copy and paste existing data into this sheet.
10
11
12
13
14
15
16
17
18
How to use this template
19
20
21
1When setting up this mini-CRM for the first time, go to the "Settings" tab to define categories for characteristics such as Contact Type for People or Stage for Opportunities2Keep the CRM up-to-date by updating or adding rows as you engage with "People", "Companies", and "Opportunities". To add rows, right click on the left side of the spreadsheet somewhere between the top and bottom existing rows and select "Insert Above".
3Use the CRM to plan your daily, weekly, and monthly goals. The "Dashboard" provides a summary of how your sales pipeline is doing to help you decide what to address next.
22
23
24
25
Let's walk you through the tabs listed at the bottom of this sheet.
26
27
28
Dashboard
29
Think of the Dashboard tab as your control panel for your opportunities. You'll see the following information:

- The total value of all your opportunities
- Total number of People, Companies, and Opportunities in this CRM
- The number of Opportunities by stage and the value of Opportunities by stage

This is a great place to start planning your daily goals!
30
31
People
32
A Person is someone you have already qualified to do business with. They may be a current customer, potential customer, or some other type of contact or relationship. This is the Person that works for a Company you want to do business with.
33
34
35
Companies
36
A Company is an organizational entity that you are either doing business with now, or may be doing business with soon. We like to think of the Company as the building that the People you are dealing with work in. The Company record is the top level record that we relate other records such as People or Opportunities to.
37
38
39
40
Business Opportunities
41
A Business Opportunity represents any kind of business development effort that you would like to track and move along through a process. You could also call an Opportunity a "deal" or a "sale". An Opportunity could represent the sale of a product, billings associated with services, or an activity that has no direct monetary value, like increasing your press coverage.
42
43
44
45
Investors
46
An investor is someone you have already qualified as interested in making an investment.
They may be a current investor, potential investor, or some other contact type.
This is the Person that works for a Company/Fund you want to do business with.
47
48
49
50
Investment Opportunities
51
An Investor Opportunity represents any kind of investor contact that you would like to track and move along through a process.
Make sure to accurately update your expected close date for the specified round.
This will allow you to better forecast what your expected inbound investments are for your round.
52
53
54
55
Setting
56
This is where you define the following items that will set the data rules in your Sheet:

- Contact Type for People and Company
- Stage, Status, Source, and Loss Reason for Opportunities

You'll want to adjust this to what makes the most sense for your business process.
57
58
59