User:Brett Wuth/Running Notes/2017-12

From PCSAR

(Difference between revisions)
Jump to: navigation, search
(2017-12-29)
(2017-12-29)
Line 208: Line 208:
* 2017-01-31 Invoice 71 Pincher Creek RCMP 2016-12-31 2,198.50 2,198.50
* 2017-01-31 Invoice 71 Pincher Creek RCMP 2016-12-31 2,198.50 2,198.50
* 2017-08-31 Invoice 76 Pincher Creek Emer Services 2017-08-31 90.90 90.90
* 2017-08-31 Invoice 76 Pincher Creek Emer Services 2017-08-31 90.90 90.90
 +
 +
 +
ATB Casino reconciliation report uncleared transactions
 +
* 2017-06-08 Deposit Pincher Creek Search and Rescue -232.50

Revision as of 08:46, 29 December 2017

Contents

2017-12-02

#SuggestionReferred to
0001Pick up stuff for Equipment Manager from Brian Balakequipment

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.

  • Reconciled to 2017-06-30

2017-07-18 Mastercard payment $71.14. No transaction entered.

  • enter as transfer

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.
  • Reconciled to 2017-07-31


Mastercard payment $122.44 on 2017-08-18 (according to bank statement).

  • Entered as bill payment on 2017-08-25 deleted
  • enter as transfer
  • Reconciled to 2017-08-31

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)

A/P Aging Detail

  • 2017-05-24 Bill 20161030 Claus / Wanda Burchert 2017-06-03 208 76.14 0.02 (to investigate)
  • 2017-05-27 Bill 20161119 Rose Bonertz 2017-06-06 205 100.00 100.00 (bogus removed)
  • 2017-06-23 Bill 20170623 Telus Communications 2017-07-23 158 53.50 53.50 (duplicate removed)
  • 2017-07-23 Bill July 23, 2017 Telus Communications 2017-08-22 128 47.99 47.99
  • 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 2016-12-05,2017-04-28 Brett Wuth 2017-09-09 110 127.59 127.59

2017-12-29

A/R Aging Detail

  • 2009-09-17 Payment Russell & Jill Bruder 2009-09-17 -43.70 -43.70
  • 2012-03-01 Payment 0070 PCCEMA 2012-03-01 -516.00 -516.00
  • 2014-08-14 Invoice 57 Russell & Jill Bruder 2014-08-14 43.70 43.70
  • 2014-08-14 Invoice 58 PCCEMA 2014-08-15 516.00 516.00

fixed linked payments to invoices to close invoices

  • 2017-01-31 Invoice 71 Pincher Creek RCMP 2016-12-31 2,198.50 2,198.50
  • 2017-08-31 Invoice 76 Pincher Creek Emer Services 2017-08-31 90.90 90.90


ATB Casino reconciliation report uncleared transactions

  • 2017-06-08 Deposit Pincher Creek Search and Rescue -232.50
Personal tools