ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Use this checklist to help you get started.
3
4
Step 1: Make a copy of the template
5
In File > Make a copy:
6
This template is in 'View-only' mode so that it can be shared with everyone.
7
Make a copy in 'File > Make a copy' so that you can use it as your own sales forecast. ๐Ÿ‘ˆ
8
9
Read this first (instead of asking us to make the sheet editable)
10
11
12
13
14
15
16
17
18
19
Step 2: Define your stages
20
In the 'Settings & Instructions' sheet:
21
Add each step (stage) of your sales process under the 'Stage name' column.
22
Assign a closing probability to each stage in the 'Probability' column.
23
For more detailed targets and forecast, try Salesflare for free at https://app.salesflare.com
24
25
Step 3: Set targets
26
In the 'Settings & Instructions' sheet:
27
Add/remove team members in the 'Sales rep' column.
28
Set your targets per team member.
29
For more detailed targets and forecast, try Salesflare for free at https://app.salesflare.com
30
31
Step 4: Fill your funnel sheet
32
In the 'Sales Funnel' sheet:
33
Add your current leads to the 'Sales Funnel' sheet and assign them a stage.
34
You can also add other data: size of the deal, expected closing date and sales rep working on the deal.
35
Feel free to add/remove columns from the 'Sales Funnel' sheet.
36
37
Step 5: Check your initial metrics
38
In the 'Sales Forecast' sheet:
39
Follow your progress in the sales forecast dashboard.
40
The sales forecast is calculated automatically for you based on your other sheets.
41
Hover on the red corners of tables/graphs to find out where they're calculated from.
42
43
Step 6: Set a reminder every 2 weeks
44
In your calendar:
45
Do spring cleaning every one or two weeks.
46
Check up on all the deals in your funnel sheet and identify the ones that hold up the pack.
47
You donโ€™t have to get rid of them. Instead, put them in an alternative funnel or create aย 'fridge' stage, to follow up on later.
48
49
Step 7: Upgrade to a smarter CRM
50
When you're ready:
51
Save time by letting Salesflare automatically enrich your data for you.
52
Find leads with Salesflare's email finder and LinkedIn sidebar.
53
Use code CRM25OFF for 25% off for the first 6 months.
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100