ABCDEFGHIJK
1
2
 Getting started
Go to Cash flow continuity playbook
a
3
4
5
6
Before you begin
Client namePlanner start date
7
This is a view-only document. Sign in to your Google account.
Sample client27-Apr-2020
8
Go to File and select Make a copy to create a copy you can edit.
9
For an Excel version, go to File and select Download.
10
Bank balance (1) $ 3,621.50
11
Step 1:
Enter your client's name and the start date for the planner. Then
Bank balance (2) $ 1,100.00
12
enter the financial information. This will give you an initial cash balance.
Bank balance (3) $ 300.00
13
Make sure all transactions are reconciled and the books are clean.
Bank balance (4) $ -
14
Bank balance (5) $ 100.00
15
Step 2:
Go to the Cash flow planner tab to calculate the cash on hand
Bank balance (6) $ (900.00)
16
for the business over the next 12 weeks. Use the what-if scenarios
Bank balance (7) $ -
17
to identify the best options for staying cash positive.
Outstanding checks $ 875.00
18
Undeposited funds $ 1,465.00
19
We automated some functions in this planner. To give permission
20
for us to use them, select Run now, and then select Continue.
TOTALS
21
Cash balance (cash on hand) $ 4,811.50
22
23
Step 3:
Go to the Summary tab to see a week-by-week breakdown of
24
cash balance, net cash flow, and overall money in/money out.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55