Entry Counts - Cash Flow Template.xlsx

	B	C	D	E
1
2	Reminders
3	What caused the bank accounts to increase or decrease? = this is our cash flow
4	Use gross amounts including GST
5	The data used determines the best steps
6	Below is an example using a TB
7
8
9	Step	Stage	Task	Links
10	1	Get data	Run the trial balance or the Notes for 3 periods
11	2	Get data	Export to sheets / XLSX paste into the notes	Notes
12	3	Clean up data	Sort data into relevant format, use positive balances, create groups
13	4	Clean up data	Split revenue into CASH and NON-CASH sections
14	5	Clean up data	Split revenue into GST revenue and NON-GST revenue, then gross up
15	6	Clean up data	Split expenses into CASH and NON-CASH sections
16	7	Clean up data	Split expenses into GST expenses and NON-GST expenses, then gross up
17	8	Clean up data	Split assets, liabilities and equity into cash flow sections	Column D
18	9	Clean up data	Run movement formula for the relevant sections
19
20	Step	Stage	Task	Links
21	1	Operating	Connect the operating calculations to the sheet results	Operating
22	2	Operating	The RED amounts are what needs to be updated
23	3	Operating	Main groups are customers, suppliers, interest, income tax
24	4	Investing	Use the movement calculations to determine investing activities
25	5	Investing	The account transactions report may show more
26	6	Financing	Use the movement calculations to determine financing activities
27	7	Financing	The account transactions report may show more
28
29	Step	Stage	Task	Links
30	1	Create cash flow	Either use this template or Xero	Cash flow
31	2	Create cash flow	Transpose amounts into sections
32	3	Create cash flow	Check Xero mapping = ASS.CUR.CAS.BAN
33	4	Create cash flow	Add opening balance from year 3
34	5	Create cash flow	Check balance sheet matches
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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