Cashflow Template

	A	B	C	D	E	F	G	H	I	J	K	L
1		Aug 2019	Sep 2019	Oct 2019	Nov 2019	Dec 2019	Jan 2020	Feb 2020	Mar 2020	Apr 2020	May 2020	Jun 2020

2	Revenue
3	Client 1	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000	2,000
4	Client 2	500	500	500	500	500	500	500	500	500	500	500
5	Client 3	800	800	800	0	800	800	800	800	800	800	800
6	Client 4	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000	1,000
7	Client 5	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000	5,000
8	Subtotal	7,300	9,300	9,300	8,500	9,300	9,300	9,300	9,300	9,300	9,300	9,300
9	Actual	7,300	10,000	8,000	6,000	11,000	10,000
10
11
12	Chequing Expenses
13	Salary A	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000	4,000
14	Contractor A	500	500	500	500	500	500	500	500	500	500	500
15	AdWords	0	0	0	300	300	300	300	300	300	300	300
16	Blue Cross	322	458	458	458	458	787	787	787	787	787	787
17	Credit Card Payment	1,200	1,200	1,200	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500
18	GST	0	1,000	0	0	1,000	0	0	1,000	0	0	1,000
19	Office Insurance	218	218	218	218	218	218	218	218	218	218	218
20	Marketing	200	0	200	0	200	0	200	0	200	0	200
21	Meals/Entertainment	100	100	100	100	100	100	100	100	100	100	100
22	Misc.	250	250	250	250	250	250	250	250	250	250	250
23	Office Supplies	15	15	15	15	15	15	15	15	15	15	15
24	Payroll Tax/Source Deductions	231	231	231	231	233	223	233	233	233	233	233
25	Professional Services	0	0	600	0	0	0	0	0	0	0	0
26	Bank Monthly Fee	25	25	25	25	25	25	25	25	25	25	25
27	TD Other Fees	2	2	2	2	2	2	2	2	2	2	2
28	Taxes	500	500	500	500	500	500	500	500	500	500	500
29	Subtotal	7,563	8,499	8,299	8,099	9,301	8,420	8,631	9,431	8,631	8,431	9,631
30	Actual	7,550	8,200	7,100	7,690	8,700	8,900
31
32
33	Credit Card
34	Business License	0	0	0	0	350	0	0	0	0	0	0
35	Event Tickets	0	0	0	0	0	0	0	0	0	0	0
36	Google Ads	0	0	0	300	450	450	450	450	450	450	450
37	Google Apps	35	35	35	308	35	35	35	35	35	35	35
38	Google Storage	3	3	3	3	3	3	3	3	3	3	3
39	Hosting	65	65	65	65	65	65	65	65	65	65	65
40	Parking	80	80	80	80	80	80	80	80	80	80	80
41	Meals/Entertainment	57	125	125	125	125	125	125	125	125	125	125
42	Misc.	300	300	300	300	300	300	300	300	300	300	300
43	Phone	169	169	169	169	169	169	169	169	169	169	169
44	Internet	68	68	68	68	68	68	68	68	68	68	68
45	TD Bank Interest Charges	10	10	10	10	10	10	10	10	10	10	10
46	Travel	0	0	0	0	2,000	0	0	0	0	0	0
47	Subtotal	786	855	855	1,427	3,655	1,305	1,305	1,305	1,305	1,305	1,305
48	Actual	600	1,100	700	1,500	3,800	1,100
49
50
51
52	Totals
53	Projected Revenue	7,300	9,300	9,300	8,500	9,300	9,300	9,300	9,300	9,300	9,300	9,300
54	Actual Revenue	7,300	10,000	8,000	6,000	11,000	10,000	0	0	0	0	0
55	Projected Expense	7,563	8,499	8,299	8,099	9,301	8,420	8,631	9,431	8,631	8,431	9,631
56	Actual Expense	7,550	8,200	7,100	7,690	8,700	8,900
57
58
59	Net
60	Projected Net Income	-263	801	1,001	401	-1	880	669	-131	669	869	-331
61	Actual Net Income	-250	1,800	900	-1,690	2,300	1,100	669	-131	669	869	-331
62
63
64	Cash
65	Projected Cash	-263	5,072	7,072	7,372	5,280	8,461	9,350	9,220	9,889	10,759	10,428
66	Actual Cash	-250	6,071	6,971	5,281	7,581	8,681	9,350	9,220	9,889	10,759	10,428
67
68
69	Opening Balances
70	Chequing	4,521	4,271	6,071	6,971	5,281	7,581	8,681	9,350	9,220	9,889	10,759
71	Credit Card	-1,500	-1,086	-741	-395	-323	-2,477	-2,282	-2,086	-1,891	-1,695	-1,500
72	Net Cash + Credit Cards	3,021	3,185	5,330	6,576	4,958	5,104	6,399	7,264	7,329	8,194	9,259
73
74