edit-article
Home
Up
Delete
Article Name:
Article Description:
] statement - expenses - 2017-10-19*
Chapter ID/Name:
Status:
Write
Writing
Written
Add Photo:
Owner ID:
Content:
use HTML
Edit Content
<h1 style="text-align: center;">statement - expenses - 2017-10-19</h1> <h2>[WHAT]</h2> <ol> <li>] by __ @ __ - this is a review/breakdown of all the expenses on this statement.</li> </ol> <h2>[WHY]</h2> <ol> <li>] the goal is to categorize each expense and then summarize the total spending by budget category</li> </ol> <h2>[WHERE]</h2> <ol> <li><strong>[x] <a href="/view/article?id=5740" target="_blank">2017-10-19</a> - SUMMARY </strong></li> <ol> <li>] bal = </li> <li>] due = 2017-11-10 </li> <li>] pd = </li> <li>] int = </li> <li>] prev = 1385</li> <li>] period = 2017-mm-20 - 2017-09-19</li> </ol> <li><strong>] READ THE FULL ARTICLE</strong></li> <ol> <li>] FILE pc-mc-2017-09-19.pdf </li> </ol></ol> <h2>[WHEN]</h2> <ol> <li>] due = 2017-11-10 </li> <li>] pd (2017-mm-dd, 0.68, via rc) </li> <li><strong>[] current + = new V3 </strong> </li> <ol> <li>] (2017-10-31, save on, 23.05, groc) ( (approx. subtotal to date = 1225 +3000) PD 200</li> <li>] TD credit 3000</li> <li>] (2017-10-30, keating liquor, 10.13, bar)</li> <li>] (2017-10-30, starbucks, 8.09, rest)</li> <li>] (2017-10-30, bc ferries, 72..50, trans)</li> <li><span style="background-color: #ff0000;">] (2017-10-29, shell, 50..00, trans)</span></li> <li>] (2017-10-29, garrison wine and liquor, 10..00, bar)</li> <li>] (2017-10-29, maru sushi, 48.48, rest) </li> <li>] (2017-10-27, bc ferries, 72..50, trans) </li> <li>] (2017-10-27, bc ferries, 2.93, rest) </li> <li>] (2017-10-27, esso mt newton, 20.00, trans) </li> <li>] (2017-10-24, save-on, 9.91, rest) </li> <li><span style="background-color: #c0c0c0;">] (2017-10-23, macdonalds, 4.00, rest) cash</span></li> <li><span style="background-color: #c0c0c0;">] (2017-10-22, michells, 4.50, rest) cash</span></li> <li>] (2017-10-20, sidney cold beer, 22.20, bar) </li> <li>] (2017-10-20, save-on, 19.73, groc)</li> <li>] (2017-10-19, keating pizza, 5.45, rest) </li> <li>] (2017-10-18, save on, 35.09/34.84, groc) </li> <li>] (2017-10-17, public mobile, 8.96, ) </li> <li>] (2017-10-16, save on, 28.21/24.84, groc)</li> <li>] (2017-10-16, macdonalds, 6.79, rest)</li> <li>] (2017-10-13, starbucks, 2.89, rest) (approx. subtotal to date = 770) </li> <li>] (2017-10-13, green wasabi, 16.75, rest)</li> <li>] (2017-10-11, thriftys, 11.12, rest)</li> <li>] (2017-10-10, starbucks, 2.89, rest)</li> <li>] (2017-10-10, bc ferries, 37.85, travel)</li> <li>] (2017-10-10, chevron, 40.09, travel)</li> <li>] (2017-10-07, dominos, 17.84, rest)</li> <li><span style="background-color: #c0c0c0;">] (2017-10-07, laundry, 18.00, misc, cash)</span></li> <li>] (2017-10-05, macdonalds, 2.72, rest)</li> <li>] (2017-10-05, bc ferries, 37.85, travel)</li> <li>] (2017-10-05, chucks burger bar, 25.38, rest)</li> <li>] (2017-10-04, shell, 32.99,v3) ( approx. subtotal to date = 570) </li> <li><span style="background-color: #c0c0c0;">] (2017-10-04, macdonalds, 5.00, cash)</span></li> <li>] (2017-10-03, save-on, 16.69, v3)</li> <li>] (2017-10-03, staples, 0.15, business?)</li> <li><span style="background-color: #c0c0c0;">] (2017-09-29, save-on, 9.98, cash)</span></li> <li><span style="background-color: #c0c0c0;">] (2017-09-29, marias greek, 8.40, cash)</span></li> <li>] (2017-09-28, sidney cold beer, 23.91, diet bar) </li> <li>] (2017-09-28, save-on, 18.95, diet groc) </li> <li>] (2017-09-27, save-on, 34.02, diet groc) </li> <li>] (2017-09-24, coop, 8.53, diet groc) </li> <li>] (2017-09-24, category12, 14.00, diet bar)</li> <li>] (2017-09-22, public mobile, 134.40, tel ) ( subtotal to date = 417 )</li> <li>] (2017-09-20, sidney cold beer, 24.19, diet bar)</li> <li>] (2017-09-20, save-on-foods, 11.78, diet groc)</li> <li><span style="background-color: #c0c0c0;">] (2017-09-20, dollarama, 4.25, other =batteries, choc icing )</span></li> <li>] (2017-09-18, sweet theak cake, 8.50, diet rest)</li> <li>] (2017-09-18, starbucks, 2.89, diet rest) </li> <li>] (2017-09-18, bc ferries, 72.50, trans fares )</li> <li>] (2017-09-16, shell, 44.30 , trans fuel)</li> <li>] (2017-09-17, jimmy j's, 29.03, diet rest)</li> <li>] (2017-09-16, bozzinis, 89.84, diet rest)</li> </ol></ol> <h2>[EXAMPLE]</h2> <ol> <li><strong>] DIET.GROCERY(<strong>0.00</strong>) =</strong> /14</li> <ol> <li>] </li> </ol> <li><strong>] DIET.REST(<strong>0.00</strong>) = /23</strong></li> <ol> <li>] </li> </ol> <li><strong>] DIET.BAR (<strong>0.00</strong>) =</strong> </li> <ol> <li>] </li> </ol> <li><strong>] TRANS.FUEL (<strong>0.00</strong>) = </strong></li> <ol> <li>] </li> </ol> <li><strong>] TRANS.REPAIR(<strong>0.00</strong>) // MAINTENANCE = </strong></li> <ol> <li>] </li> </ol> <li><strong>] TRANS.FARES(<strong>0.00</strong>) = </strong></li> <ol> <li>] </li> </ol> <li><strong>] BUSINESS(<strong>0.00</strong>)</strong></li> <ol> <li>] </li> </ol> <li><strong>] TELEPHONE (<strong>0.00</strong>)</strong></li> <ol> <li>] </li> </ol> <li><strong>] ENTERTAINMENT/TELEVISION (<strong>0.00</strong>)</strong></li> <ol> <li>] </li> </ol> <li><strong>] OTHER (0.00)</strong></li> <ol> <li>] </li> </ol> <li><strong>] SUBTOTAL (<strong>0.00 </strong>// ) <strong>0.00</strong> = <strong>0.00</strong> ( <strong>0.00</strong>) </strong></li> <ol> <li>] </li> </ol></ol> <h2>[HOW-TO]</h2> <ol> <li>] scan amt for 44.38 = nothing</li> <li>] STMT - trans ttl = 61 - 21 + 30 + 10 , includes 1 refund, 1 interest </li> <li>] HERE - trans ttl = 59</li> <li>21 to bar, + 37 = 58 + 1 for interest, looks like missing 2 trans for total of 44.38</li> <li>x] verified all pg1, pg2 and pg3 trans are present here</li> <li>x] verify subtotals are correct</li> <li>x] verify all transactions in each category, adjusted groc by < $ 1, all others exactly as before </li> <li>] pg1 338.01, pg2 (1084.38 -338.01), pg3 = 1389.81-16.80 = 1373.01 ( 8.39 )</li> </ol> <h2>[REFERENCE]</h2> <ol> <li>] # 7391 - <a href="/view/task?id=7391" target="_blank">CREATE-list</a> - expense-statements-summary (2017)</li> <li>] # # - LIST-expenses - monthly</li> </ol> <h1 style="text-align: center;"> </h1>