A | C | D | E | F | G | H | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | Expenses | Income | |||||||||||||
8 | EX Date | EX Category | Ex Sub-Category | Comment | Cost | INC Date | INC Category | Comment | Cost | ||||||
89 | 1/1/16 | Accommodation | Rent | monthly rent | 800 | 1/1/2016 | Wage | wage | 3000 | ||||||
90 | 8/1/16 | Food | Groceries | monthly groceries | 400 | 1/2/2016 | Savings interest | ubank | 100 | ||||||
91 | 15/1/16 | Entertainment | Pub | beers with friends | 100 | 2/1/2016 | Wage | wage | 3000 | ||||||
92 | 22/1/16 | Transport | Vehicle-fuel | petrol for car | 200 | 2/2/2016 | Share dividends | XYZ | 50 | ||||||
93 | 29/1/16 | Accommodation | Electricity | electicity bill | 400 | 2/2/2016 | Share dividends | ABC | 50 | ||||||
94 | 5/2/16 | Accommodation | Rent | monthly rent | 800 | 2/2/2016 | Share dividends | AAA | $50.00 | ||||||
95 | 12/2/16 | Food | Groceries | monthly groceries | 400 | 2/2/2016 | Share dividends | BBB | 50 | ||||||
96 | 19/2/16 | Entertainment | Pub | beers with friends | 100 | 3/6/2016 | Wage | wage | 3000 | ||||||
97 | 26/2/16 | Transport | Vehicle-fuel | petrol for car | 200 | 3/7/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
98 | 4/3/16 | Accommodation | Rent | monthly rent | 800 | 4/6/2016 | Wage | wage | 3000 | ||||||
99 | 11/3/16 | Food | Groceries | monthly groceries | 400 | 4/7/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
100 | 18/3/16 | Entertainment | Pub | beers with friends | 100 | 5/7/2016 | Wage | wage | 3000 | ||||||
101 | 25/3/16 | Transport | Vehicle-fuel | petrol for car | 200 | 5/8/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
102 | 1/4/16 | Accommodation | Rent | monthly rent | 800 | 6/7/2016 | Wage | wage | 3000 | ||||||
103 | 8/4/16 | Food | Groceries | monthly groceries | 400 | 6/8/2016 | Portfolio Unrealised | shares decreased in value | -$200.00 | ||||||
104 | 15/4/16 | Entertainment | Pub | beers with friends | 100 | 7/8/2016 | Wage | wage | 3000 | ||||||
105 | 22/4/16 | Transport | Vehicle-fuel | petrol for car | 200 | 7/9/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
106 | 29/4/16 | Accommodation | Water | water bill | 100 | 7/9/2016 | Share dividends | XYZ | 50 | ||||||
107 | 6/5/16 | Accommodation | Rent | monthly rent | 800 | 7/9/2016 | Share dividends | ABC | 50 | ||||||
108 | 13/5/16 | Food | Groceries | monthly groceries | 400 | 7/9/2016 | Share dividends | AAA | $50.00 | ||||||
109 | 20/5/16 | Entertainment | Pub | beers with friends | 100 | 7/9/2016 | Share dividends | BBB | 50 | ||||||
110 | 27/5/16 | Transport | Vehicle-fuel | petrol for car | 200 | 8/8/2016 | Wage | wage | 3000 | ||||||
111 | 3/6/16 | Accommodation | Rent | monthly rent | 800 | 8/9/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
112 | 10/6/16 | Food | Groceries | monthly groceries | 400 | 9/8/2016 | Wage | wage | 3000 | ||||||
113 | 17/6/16 | Entertainment | Pub | beers with friends | 100 | 9/9/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
114 | 24/6/16 | Transport | Vehicle-fuel | petrol for car | 200 | 10/9/2016 | Wage | wage | 3000 | ||||||
115 | 1/7/16 | Accommodation | Rent | monthly rent | 800 | 10/10/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
116 | 8/7/16 | Food | Groceries | monthly groceries | 400 | 11/9/2016 | Wage | wage | 3000 | ||||||
117 | 15/7/16 | Entertainment | Pub | beers with friends | 100 | 11/10/2016 | Portfolio Unrealised | shares increased in value | $200.00 | ||||||
118 | 22/7/16 | Transport | Vehicle-fuel | petrol for car | 200 | 12/10/2016 | Wage | wage | 3000 | ||||||
119 | 29/7/16 | Accommodation | gas | gas bill | $150.00 | 12/11/2016 | Portfolio Unrealised | shares increased in value | $50.00 | ||||||
120 | 5/8/16 | Accommodation | Rent | monthly rent | 800 | ||||||||||
121 | 12/8/16 | Food | Groceries | monthly groceries | 400 | ||||||||||
122 | 19/8/16 | Entertainment | Pub | beers with friends | 100 | ||||||||||
123 | 26/8/16 | Transport | Vehicle-fuel | petrol for car | 200 | ||||||||||
124 | 2/9/16 | Accommodation | Rent | monthly rent | 800 | ||||||||||
125 | 9/9/16 | Food | Groceries | monthly groceries | 400 | ||||||||||
126 | 16/9/16 | Entertainment | Pub | beers with friends | 100 | ||||||||||
127 | 23/9/16 | Transport | Vehicle-fuel | petrol for car | 200 | ||||||||||
128 | 30/9/16 | Entertainment | Movies | batman | $50.00 | ||||||||||
129 | 7/10/16 | Accommodation | Rent | monthly rent | 800 | ||||||||||
130 | 14/10/16 | Food | Groceries | monthly groceries | 400 | ||||||||||
131 | 21/10/16 | Entertainment | Pub | beers with friends | 100 | ||||||||||
132 | 28/10/16 | Transport | Vehicle-fuel | petrol for car | 200 | ||||||||||
133 | 4/11/16 | Accommodation | Rent | monthly rent | 800 | ||||||||||
134 | 11/11/16 | Food | Groceries | monthly groceries | 400 | ||||||||||
135 | 18/11/16 | Entertainment | Pub | beers with friends | 100 | ||||||||||
136 | 25/11/16 | Transport | Vehicle-fuel | petrol for car | 200 | ||||||||||
137 | 2/12/16 | Accommodation | Rent | monthly rent | 800 | ||||||||||
138 | 9/12/16 | Food | Groceries | monthly groceries | 400 | ||||||||||
139 | 16/12/16 | Entertainment | Pub | beers with friends | 100 | ||||||||||
140 | 23/12/16 | Transport | Vehicle-fuel | petrol for car | 200 | ||||||||||
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 |