edit-article
Home
Up
Delete
Article Name:
Article Description:
] statement - expenses - 2017-09-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-09-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-09-19</a> - SUMMARY </strong></li> <ol> <li>] bal = 1381.40 </li> <li>] due = 2017-10-10 </li> <li>] pd = 1032. (2017-09-12, rc1, 800) (2017-08-28, rc1, 230.68) </li> <li>] int = 0.31</li> <li>] prev = 1032</li> <li>] period = 2017-08-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-10-10 </li> <li>] pd (2017-mm-dd, 0.68, via rc) </li> </ol> <h2>[EXAMPLE]</h2> <ol> <li><strong>] DIET.GROCERY(342.24) =</strong> /14</li> <ol> <li>] (2017-08-19, coop, 22.34), (2017-08-21, thriftys, 20.18), (2017-08-25, superstore, 8.38),(2017-08-26, hofstedes, 5.73),(2017-08-26, fraser valley meats, 15.40),(2017-08-27, safeway, 14.49),(2017-08-29, coop, 8.88),(2017-09-03, coop# uclu, 25.45), (2017-09-04, coop# uclu, 12.56), (2017-09-05, walmart, 144.29), (2017-09-10, coop, 9.27), (2017-09-13, coop, 5.25), (2017-09-14, save-on, 13.26), (2017-09-16, hofstedes, 36.76) </li> </ol> <li><strong>] DIET.REST(300.49) = /23</strong></li> <ol> <li>] (2017-08-17, mcdonalds, 2.81), (2017-08-18, starbucks, 2.89),(2017-08-19, third street cafe, 18.02), (2017-08-19, mcdonalds, 2.81),(2017-08-20, starbucks, 2.89), (2017-08-21, mcdonalds, 9.19), (2017-08-22, mcdonalds, 4.59), (2017-08-24, starbucks, 2.89), (2017-08-24, mcdonalds, 8.27),(2017-08-25, yale sushi, 78.61),(2017-08-27, DQ, 15.73),] (2017-08-29, starbucks, 2.89),(2017-08-29, mcdonalds, 4.59),(2017-08-30, mcdonalds, 3.55),(2017-08-31, mcdonalds, 4.69),(2017-09-01, marias souvlaki, 20.95), (2017-09-23, zoes bakery, 23.94), (2017-09-04, mcdonalds, 8.37), (2017-09-04, mcdonalds, 11.09), (2017-09-05, bedford regency, 62.14), (2017-09-07, starbucks, 2.89), (2017-09-14, mcdonalds, 3.76), (2017-09-15, starbucks 2.93) </li> </ol> <li><strong>] DIET.BAR (226.81) =</strong> </li> <ol> <li>] (2017-08-19, loghouse liquor, 26.83), (2017-08-26, bc liquor #170, 23.04),(2017-09-01, victoria spirits, 35.20),(2017-09-01, sidney cold beer, 24.19),(2017-09-03, tofino brewing, 22.00), (2017-09-06, keating liq 29.58), (2017-09-10, category 12, bar, 11.50), (2017-09-13, keating liq, 23.04) (2017-09-14, keating liq, 13.08, gift) (2017-09-16, friendly mikes, 18.35), </li> </ol> <li><strong>] TRANS.FUEL (141.45) = </strong></li> <ol> <li>] (2017-08-24, esso, 23.00), ?(2017-08-28, GB chilliwack, 40.40)?, (2017-09-04, petrocan, 45.05), (2017-09-11, shell, trans.gas, 33.00)</li> </ol> <li><strong>] TRANS.REPAIR(176.12) // MAINTENANCE = </strong></li> <ol> <li>] (2017-08-28, grt canadian oil, 48.14),(2017-09-16, walmart, 144.78 - 16.80, battery)</li> </ol> <li><strong>] TRANS.FARES(157.90) = </strong></li> <ol> <li>] (2017-08-25, bc ferries, 47.55),(2017-08-30, bc ferries, 37.85),(2017-09-15, bc ferries 72.50) </li> </ol> <li><strong>] BUSINESS()</strong></li> <ol> <li>] </li> </ol> <li><strong>] TELEPHONE ()</strong></li> <ol> <li>] </li> </ol> <li><strong>] ENTERTAINMENT/TELEVISION ()</strong></li> <ol> <li>] </li> </ol> <li><strong>] OTHER (7.48)</strong></li> <ol> <li>] (2017-08-24, dollarama, 7.48), </li> </ol> <li><strong>] SUBTOTAL (1,352.49// ) 1398.07-16.80 = 1381.40 ( 28.91) ERROR</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>