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
Alternatively, simply click here to make a copy of this template.
9
10
Read this first (instead of asking us to make the sheet editable)
11
12
13
14
15
16
17
18
19
20
Step 2: Define your stages
21
In the 'Settings & Instructions' sheet:
22
Add each step (stage) of your sales process under the 'Stage name' column.
23
Assign a closing probability to each stage in the 'Probability' column.
24
For more detailed targets and forecast, try Salesflare for free at https://app.salesflare.com
25
26
Step 3: Set targets
27
In the 'Settings & Instructions' sheet:
28
Add/remove team members in the 'Sales rep' column.
29
Set your targets per team member.
30
For more detailed targets and forecast, try Salesflare for free at https://app.salesflare.com
31
32
Step 4: Fill your funnel sheet
33
In the 'Sales Funnel' sheet:
34
Add your current leads to the 'Sales Funnel' sheet and assign them a stage.
35
You can also add other data: size of the deal, expected closing date and sales rep working on the deal.
36
Feel free to add/remove columns from the 'Sales Funnel' sheet.
37
38
Step 5: Check your initial metrics
39
In the 'Sales Forecast' sheet:
40
Follow your progress in the sales forecast dashboard.
41
The sales forecast is calculated automatically for you based on your other sheets.
42
Hover on the red corners of tables/graphs to find out where they're calculated from.
43
44
Step 6: Set a reminder every 2 weeks
45
In your calendar:
46
Do spring cleaning every one or two weeks.
47
Check up on all the deals in your funnel sheet and identify the ones that hold up the pack.
48
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.
49
50
Step 7: Upgrade to a smarter CRM
51
When you're ready:
52
Save time by letting Salesflare automatically enrich your data for you.
53
Find leads with Salesflare's email finder and LinkedIn sidebar.
54
Use code CRM25OFF for 25% off for the first 6 months.
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