Book Keeping Task/Monthly review

From PCSAR

Revision as of 16:37, 2 April 2018 (edit) Brett Wuth (Talk | contribs) ← Previous diff		Revision as of 16:40, 2 April 2018 (edit) (undo) Brett Wuth (Talk | contribs) Next diff →
Line 54:		Line 54:
-		+	Review the
		+	[https://ca.qbo.intuit.com/app/reportv2?token=AP_AGING_DET&show_logo=false&date_macro=today&low_date=&high_date=2018-04-02&divideby1000=false&hidecents=false&negativenums=1&negativered=false&show_header_title=true&show_header_range=true&show_footer_custom_message=true&show_footer_date=true&show_footer_time=true&header_alignment=Center&footer_alignment=Center&show_header_company=true&company_name=Pincher%20Creek%20Search%20and%20Rescue%20Society&footer_custom_message=&aging_as_of=true&aging_period=30&num_periods=4&past_due=&exportTargetTool=undefined Accounts Payable Aging Detail report] for any bills over 30 days as possible duplicates
		+	{{status|not yet|2017-09-01}}
	Check for unpaid invoices, bills		Check for unpaid invoices, bills

---

Revision as of 16:40, 2 April 2018

Every month, the books should be reviewed for assurance that they are being kept up to date and accurate. This is normally done by the person the Bookkeeper reports to: e.g. the Treasurer.

The Bookkeeper should do this in advanced to make sure everything is correct and ready before the review.

• Copies of each statement is examined and compared with the reconciliation report
  • Are the ending dates the same?
  • Are the ending amounts the same?
  • Are there transactions that haven't cleared which should have?

Specifically:

• Get a copy of the latest Mastercard statement (not yet for 2017-09-01)
• Get a copy of the latest Mastercard reconciliation (not yet for 2017-09-01)
• Verify that the ending dates match (not yet for 2017-09-01)
• Verify that the ending balance match (not yet for 2017-09-01)
• Verify that there are no uncleared transactions older than 10 days prior to the statement end date (not yet for 2017-09-01)

The ATB accounts all use one consolidated statement

• Get a copy of the latest ATB consolidated statement (not yet for 2017-09-01)

For ATB chequing

• Get a copy of the latest ATB Chequing reconciliation (not yet for 2017-09-01)
• Verify that the ending dates match (not yet for 2017-09-01)
• Verify that the ending balance match (not yet for 2017-09-01)
• Verify that there are no uncleared deposits older than 10 days prior to the statement end date (not yet for 2017-09-01)
• Verify that there are no uncleared cheques older than 6 months prior to the statement end date (not yet for 2017-09-01)

For ATB casino

• Get a copy of the latest ATB Casino reconciliation (not yet for 2017-09-01)
• Verify that the ending dates match (not yet for 2017-09-01)
• Verify that the ending balance match (not yet for 2017-09-01)
• Verify that there are no uncleared deposits older than 10 days prior to the statement end date (not yet for 2017-09-01)
• Verify that there are no uncleared cheques older than 6 months prior to the statement end date (not yet for 2017-09-01)

For ATB GICs

• Get a copy of the latest ATB GIC reconciliation (not yet for 2017-09-01)
• Verify that the ending dates match (not yet for 2017-09-01)
• Verify that the ending balance match (not yet for 2017-09-01)
• Verify that there are no uncleared transactions older than 10 days prior to the statement end date (not yet for 2017-09-01)

Similarly for ATB T-Bill

• Get a copy of the latest ATB T-Bill reconciliation (not yet for 2017-09-01)
• Verify that the ending dates match (not yet for 2017-09-01)
• Verify that the ending balance match (not yet for 2017-09-01)
• Verify that there are no uncleared transactions older than 10 days prior to the statement end date (not yet for 2017-09-01)

Review the Accounts Payable Aging Detail report for any bills over 30 days as possible duplicates (not yet for 2017-09-01)

Check for unpaid invoices, bills