ACDEFGHJKLMNOPQ
1
Guidelines:
2
0. For instructions refer to : http://www.ramblingsofanextrememan.wordpress.com/
3
1. Include a nil cost dummy entry for all categories and sub-categories to make the pivot fully populate in the dashboard page
4
2. If buying something to upgrade, when you sell the old thing put it through as a negative entry to offset the purchase, backdate it to offset purchase, but record sold date
5
3. If paying tax put a minus entry in the income side, tax is not consumption, it's a consequence of income
6
4. Ctrl + Shift + ; will place todays date in a cell
Balance$18,200.00
7
ExpensesIncome
8
EX DateEX CategoryEx Sub-CategoryCommentCostINC DateINC CategoryCommentCost
89
1/1/16AccommodationRentmonthly rent8001/1/2016Wagewage3000
90
8/1/16FoodGroceries
monthly groceries
4001/2/2016Savings interestubank100
91
15/1/16EntertainmentPub
beers with friends
1002/1/2016Wagewage3000
92
22/1/16TransportVehicle-fuelpetrol for car2002/2/2016Share dividendsXYZ50
93
29/1/16AccommodationElectricityelecticity bill4002/2/2016Share dividendsABC50
94
5/2/16AccommodationRentmonthly rent8002/2/2016Share dividendsAAA$50.00
95
12/2/16FoodGroceries
monthly groceries
4002/2/2016Share dividendsBBB50
96
19/2/16EntertainmentPub
beers with friends
1003/6/2016Wagewage3000
97
26/2/16TransportVehicle-fuelpetrol for car2003/7/2016Portfolio Unrealised
shares increased in value
$50.00
98
4/3/16AccommodationRentmonthly rent8004/6/2016Wagewage3000
99
11/3/16FoodGroceries
monthly groceries
4004/7/2016Portfolio Unrealised
shares increased in value
$50.00
100
18/3/16EntertainmentPub
beers with friends
1005/7/2016Wagewage3000
101
25/3/16TransportVehicle-fuelpetrol for car2005/8/2016Portfolio Unrealised
shares increased in value
$50.00
102
1/4/16AccommodationRentmonthly rent8006/7/2016Wagewage3000
103
8/4/16FoodGroceries
monthly groceries
4006/8/2016Portfolio Unrealised
shares decreased in value
-$200.00
104
15/4/16EntertainmentPub
beers with friends
1007/8/2016Wagewage3000
105
22/4/16TransportVehicle-fuelpetrol for car2007/9/2016Portfolio Unrealised
shares increased in value
$50.00
106
29/4/16AccommodationWaterwater bill1007/9/2016Share dividendsXYZ50
107
6/5/16AccommodationRentmonthly rent8007/9/2016Share dividendsABC50
108
13/5/16FoodGroceries
monthly groceries
4007/9/2016Share dividendsAAA$50.00
109
20/5/16EntertainmentPub
beers with friends
1007/9/2016Share dividendsBBB50
110
27/5/16TransportVehicle-fuelpetrol for car2008/8/2016Wagewage3000
111
3/6/16AccommodationRentmonthly rent8008/9/2016Portfolio Unrealised
shares increased in value
$50.00
112
10/6/16FoodGroceries
monthly groceries
4009/8/2016Wagewage3000
113
17/6/16EntertainmentPub
beers with friends
1009/9/2016Portfolio Unrealised
shares increased in value
$50.00
114
24/6/16TransportVehicle-fuelpetrol for car20010/9/2016Wagewage3000
115
1/7/16AccommodationRentmonthly rent80010/10/2016Portfolio Unrealised
shares increased in value
$50.00
116
8/7/16FoodGroceries
monthly groceries
40011/9/2016Wagewage3000
117
15/7/16EntertainmentPub
beers with friends
10011/10/2016Portfolio Unrealised
shares increased in value
$200.00
118
22/7/16TransportVehicle-fuelpetrol for car20012/10/2016Wagewage3000
119
29/7/16Accommodationgasgas bill$150.0012/11/2016Portfolio Unrealised
shares increased in value
$50.00
120
5/8/16AccommodationRentmonthly rent800
121
12/8/16FoodGroceries
monthly groceries
400
122
19/8/16EntertainmentPub
beers with friends
100
123
26/8/16TransportVehicle-fuelpetrol for car200
124
2/9/16AccommodationRentmonthly rent800
125
9/9/16FoodGroceries
monthly groceries
400
126
16/9/16EntertainmentPub
beers with friends
100
127
23/9/16TransportVehicle-fuelpetrol for car200
128
30/9/16EntertainmentMoviesbatman$50.00
129
7/10/16AccommodationRentmonthly rent800
130
14/10/16FoodGroceries
monthly groceries
400
131
21/10/16EntertainmentPub
beers with friends
100
132
28/10/16TransportVehicle-fuelpetrol for car200
133
4/11/16AccommodationRentmonthly rent800
134
11/11/16FoodGroceries
monthly groceries
400
135
18/11/16EntertainmentPub
beers with friends
100
136
25/11/16TransportVehicle-fuelpetrol for car200
137
2/12/16AccommodationRentmonthly rent800
138
9/12/16FoodGroceries
monthly groceries
400
139
16/12/16EntertainmentPub
beers with friends
100
140
23/12/16TransportVehicle-fuelpetrol for car200
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180