article

statement - expenses - 2017-09-19

[WHAT]

  1. ] by __ @ __ - this is a review/breakdown of all the expenses on this statement.

[WHY]

  1. ] the goal is to categorize each expense and then summarize the total spending by budget category

[WHERE]

  1. [x] 2017-09-19 - SUMMARY 
    1. ] bal = 1381.40 
    2. ] due = 2017-10-10  
    3. ] pd = 1032. (2017-09-12, rc1, 800) (2017-08-28, rc1, 230.68)  
    4. ] int = 0.31
    5. ] prev = 1032
    6. ] period = 2017-08-20 - 2017-09-19
  2. ] READ THE FULL ARTICLE
    1. ] FILE pc-mc-2017-09-19.pdf 

[WHEN]

  1. ] due = 2017-10-10  
  2. ] pd (2017-mm-dd, 0.68, via rc) 

[EXAMPLE]

  1. ] DIET.GROCERY(342.24) = /14
    1. ] (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) 
  2. ] DIET.REST(300.49) = /23
    1. ] (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) 
  3. ] DIET.BAR (226.81) = 
    1. ] (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), 
  4. ] TRANS.FUEL (141.45) = 
    1. ] (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)
  5. ] TRANS.REPAIR(176.12) // MAINTENANCE = 
    1. ] (2017-08-28, grt canadian oil, 48.14),(2017-09-16, walmart, 144.78 - 16.80, battery)
  6. ] TRANS.FARES(157.90) = 
    1. ] (2017-08-25, bc ferries, 47.55),(2017-08-30, bc ferries, 37.85),(2017-09-15,  bc ferries 72.50) 
  7. ] BUSINESS()
    1. ] 
  8. ] TELEPHONE ()
    1. ] 
  9. ] ENTERTAINMENT/TELEVISION ()
    1. ]  
  10. ] OTHER (7.48)
    1. ] (2017-08-24, dollarama, 7.48), 
  11. ] SUBTOTAL (1,352.49// ) 1398.07-16.80 = 1381.40  ( 28.91) ERROR
    1. ] 

[HOW-TO]

  1. ] scan amt for 44.38 = nothing
  2. ] STMT - trans ttl = 61 - 21 + 30 + 10 , includes 1 refund, 1 interest 
  3. ] HERE  - trans ttl = 59
  4. 21 to bar,  + 37 = 58 + 1 for interest, looks like missing 2 trans for total of 44.38
  5. x] verified all pg1, pg2 and pg3 trans are present here
  6. x] verify subtotals are correct
  7. x] verify all transactions in each category, adjusted groc by < $ 1, all others exactly as before 
  8. ] pg1 338.01, pg2 (1084.38 -338.01), pg3 =  1389.81-16.80 = 1373.01 ( 8.39 )

[REFERENCE]

  1. ] # 7391 - CREATE-list - expense-statements-summary (2017)
  2. ] # # - LIST-expenses - monthly

 

Details Photos Edit more

Details

ID: 5740

NAME: statement-MC-2017-09-19

DESCRIPTION: ] statement - expenses - 2017-09-19

AUTHOR: article.author/s

EDITOR: article.editor/s

PUBLISHER: article.publisher/s

STATUS: Write

PRIORITY: -5

OWNER ID: 75

Content Photos Edit more

photos

page_photo

actions

Email Email-Owner SMS and