2017-12-03
Potential trainings for Tuesday:
Tue, 5 Dec A mix of sun and cloud. High minus 2.
Night Clear. Low minus 7.
Indoors:
Outdoors:
2017-12-04
documents:
2017-12-06
documents:
2017-12-09
Cheques marked as reconciled in Quick Books Online, but did not clear account in 2017-07 or later, all dated 2017-07-29:
- 1954 dated 2017-05-23, entered as dated 2017-07-29 corrected, cleared 2017-06-09
- 1958 dated 2017-05-24, entered as dated 2017-07-29 corrected, cleared 2017-06-09
- 1959 dated 2017-05-24, entered as dated 2017-07-29 corrected, cleared 2017-06-19
- 1960 dated 2017-05-24, entered as dated 2017-07-29 corrected, cleared 2017-06-09
- 1963 dated 2017-05-24, entered as dated 2017-07-29 corrected, cleared 2017-06-29; entered as $76.14 corrected, but cleared as $76.12.
- 1964 dated 2017-05-24, entered as dated 2017-07-29 corrected, cleared 2017-06-08
Journal Entry 22 dated 2017-06-30
- Credit $0.02 ATB Chequing
- Debit $0.02 Training:Hosted Courses:SAR Basics Course:SAR Basics Prev Yr Carried For.
- Marked as reconciled. Dereconcile
Same payment of $170.22 Mastercard entered twice.
- 2017-06-15 as a transfer (deleted and recreated)
- 2017-06-27 as a Bill payment (Reconciled); date was 2017-06-15 according to chequing statement deleted
Previous Reconciled Balance $10,493.45 shows correct for May 31.
2017-07-18 Mastercard payment $71.14. No transaction entered.
Need to enter Credit Card payment:
- https://community.intuit.com/articles/1145523-record-credit-card-payment
- Susanna's 2017-05-18 051817 Cheque Expense ATB Mastercard 2546 ATB Mastercard $337.55 R
- Rose's 2017-06-15 06302017 Bill Payment ATB Mastercard 2546 2000 Accounts Payable $170.22
- Not clear that QBO can create "Cheque Expense" transaction types, perhaps only import.
- best method is as transfer.
Mastercard payment $122.44 on 2017-08-18 (according to bank statement).
- Entered as bill payment on 2017-08-25 deleted
- enter as transfer
Reconcile Mastercard statement of 2017-06-27
- Record payment 2017-05-24 $50.19 Telus
- Record payment 2017-06-16 $20.95 InReach
To be completed: Reconcile Mastercard statement of 2017-07-27
Uncleared:
- 2017-07-29 Bill Payment 1962 Ryan McFarlan -32.62
- 2017-07-29 Bill Payment 1961 Jonas Hoke -32.62
- 2017-06-30 Journal 22 0.02
2017-12-28
Reconciled Mastercard statement of 2017-07-27
- Record payment 2017-07-24 $47.99 Telus
- Add inReach bill of 2017-07-07 $20.95
- Record payment 2017-07-15 $20.95 inReach
- Add Telus bill of 2017-07-23 $53.50
- Record Telus payment 2017-07-28 $53.50
Reconciled Mastercard statement of 2017-08-25
- Add inReach bill of 2017-08-07 $22.95
- Record payment 2017-08-15 $22.95 inReach
- Add expense 2017-08-03 $65.00 mastercard annual fee
- Add Telus bill of 2017-08-23 $47.99
- Record Telus payment 2017-08-24 $47.99
Review "A/P Aging Detail" report
- 2017-05-24 Bill 20161030 Claus / Wanda Burchert 2017-06-03 208 76.14 0.02 (to review)
- 2017-05-27 Bill 20161119 Rose Bonertz 2017-06-06 205 100.00 100.00
- 2017-06-27 Bill MC Payment IRL Supplies (2011) Ltd 2017-07-07 174 147.27 147.27
- 2017-08-15 Bill Annual Fee ATB Mastercard 2546 2017-08-25 125 65.00 65.00
- 2017-08-16 Bill 8492186 inreach Canada 2017-08-26 124 22.95 22.95
- 2017-08-30 Bill August Pay Rose Bonertz 2017-09-09 110 734.48 734.48
- 2017-08-30 Bill Prov Gen Meeting Matt Lynch 2017-09-09 110 503.73 503.73
- 2017-08-30 Bill July Pay Rose Bonertz 2017-09-09 110 400.00 400.00
- 2017-08-30 Bill August Expenses Rose Bonertz 2017-09-09 110 172.90 172.90
- 2017-08-30 Bill August 2017 Brett Wuth 2017-09-09 110 127.59 127.59
Review "Bill Payment List"
Review "Supplier Balance Detail"
ATB Mastercard 2546
* 2017-08-15 Bill Annual Fee 2017-08-25 65.00 65.00 65.00 (duplicate removed)
Remove duplicate bill for inReach 2017-08-16 $22.95
IRL Supplies (2011) Ltd
- 2017-06-27 Bill MC Payment 2017-07-07 147.27 147.27 147.27
Correct expense account for $147.20 map mylar from "IRL Supplies" to "response supplies" from "vehicle expense".
simirlar correct 2017-04-25 flagging tape
Entered as expense.
Remove bill for same amount.
Rose Bonertz
- 2017-05-27 Bill 20161119 2017-06-06 100.00 100.00 100.00
- 2017-08-30 Bill August Expenses 2017-09-09 172.90 172.90 272.90
- 2017-08-30 Bill July Pay 2017-09-09 400.00 400.00 672.90
- 2017-08-30 Bill August Pay 2017-09-09 734.48 734.48 1,407.38
Transaction List by Supplier, Last Fiscal Year
Telus
- 2017-08-24 Bill Payment (Credit Card) Yes ATB Mastercard 0.00 (delete empty bill)
- 2017-08-25 Bill Payment (Credit Card) Yes ATB Mastercard 101.49 (delete bogus payment)