Book Keeping Task/Monthly review - Revision history

Brett Wuth at 04:21, 25 August 2018

2018-08-25T04:21:26Z

←Older revision		Revision as of 04:21, 25 August 2018
Line 33:		Line 33:

	For ATB casino		For ATB casino
-	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?~~ReconcileSummary~~=true ATB Casino reconciliation] {{status\|not yet\|2017-09-01}}	+	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=403&showHistory=true&displayReport=true ATB Casino reconciliation] {{status\|not yet\|2017-09-01}}
	* Verify that the ending dates match {{status\|not yet\|2017-09-01}}		* Verify that the ending dates match {{status\|not yet\|2017-09-01}}
	* Verify that the ending balance match {{status\|not yet\|2017-09-01}}		* Verify that the ending balance match {{status\|not yet\|2017-09-01}}

Brett Wuth at 16:52, 2 April 2018

2018-04-02T16:52:36Z

←Older revision		Revision as of 16:52, 2 April 2018
Line 58:		Line 58:
	Specifically:		Specifically:

-	Review the	+	Review the current
	[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 or outstanding bills		[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 or outstanding bills
	{{status\|not yet\|2017-09-01}}		{{status\|not yet\|2017-09-01}}

-		+	Review the current
-	Review the	+
	[https://ca.qbo.intuit.com/app/reportv2?token=AR_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 Receivable Aging Detail report]		[https://ca.qbo.intuit.com/app/reportv2?token=AR_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 Receivable Aging Detail report]
	for any invoices over 90 days that need following up on		for any invoices over 90 days that need following up on
	{{status\|not yet\|2017-09-01}}		{{status\|not yet\|2017-09-01}}

Brett Wuth at 16:50, 2 April 2018

2018-04-02T16:50:01Z

←Older revision		Revision as of 16:50, 2 April 2018
Line 53:		Line 53:
	* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}

		+
		+	Further the monthly review should verify that bills and invoices are being completed.
		+	This helps verify that there are no fictional bills or invoices distorting the accrual reports.
		+	Specifically:

	Review the		Review the

Brett Wuth at 16:46, 2 April 2018

2018-04-02T16:46:10Z

←Older revision		Revision as of 16:46, 2 April 2018
Line 55:		Line 55:

	Review the		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	+	[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 or outstanding bills
	{{status\|not yet\|2017-09-01}}		{{status\|not yet\|2017-09-01}}

Brett Wuth at 16:43, 2 April 2018

2018-04-02T16:43:04Z

←Older revision		Revision as of 16:43, 2 April 2018
Line 58:		Line 58:
	{{status\|not yet\|2017-09-01}}		{{status\|not yet\|2017-09-01}}

-	~~Check~~ for ~~unpaid~~ invoices~~, bills~~	+
		+	Review the
		+	[https://ca.qbo.intuit.com/app/reportv2?token=AR_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 Receivable Aging Detail report]
		+	for any invoices over 90 days that need following up on
		+	{{status\|not yet\|2017-09-01}}

Brett Wuth at 16:40, 2 April 2018

2018-04-02T16:40:24Z

←Older revision		Revision as of 16:40, 2 April 2018
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

Brett Wuth at 16:37, 2 April 2018

2018-04-02T16:37:20Z

←Older revision		Revision as of 16:37, 2 April 2018
Line 41:		Line 41:

	For ATB GICs		For ATB GICs
-	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=51&showHistory=true&displayReport=true	+	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=51&showHistory=true&displayReport=true ATB GIC reconciliation] {{status\|not yet\|2017-09-01}}
-	ATB GIC reconciliation] {{status\|not yet\|2017-09-01}}	+
	* Verify that the ending dates match {{status\|not yet\|2017-09-01}}		* Verify that the ending dates match {{status\|not yet\|2017-09-01}}
	* Verify that the ending balance match {{status\|not yet\|2017-09-01}}		* Verify that the ending balance match {{status\|not yet\|2017-09-01}}

Brett Wuth at 16:36, 2 April 2018

2018-04-02T16:36:56Z

←Older revision		Revision as of 16:36, 2 April 2018
Line 49:		Line 49:

	Similarly for ATB T-Bill		Similarly for ATB T-Bill
		+	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=131&showHistory=true&displayReport=true ATB T-Bill reconciliation] {{status\|not yet\|2017-09-01}}
		+	* Verify that the ending dates match {{status\|not yet\|2017-09-01}}
		+	* Verify that the ending balance match {{status\|not yet\|2017-09-01}}
	* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}

Brett Wuth at 16:34, 2 April 2018

2018-04-02T16:34:55Z

←Older revision		Revision as of 16:34, 2 April 2018
Line 22:		Line 22:
	The ATB accounts all use one consolidated statement		The ATB accounts all use one consolidated statement
	* Get a copy of the latest {{link\|Members:Contact/Alberta Treasury Branch/Consolidated Statements\|ATB consolidated statement}} {{status\|not yet\|2017-09-01}}		* Get a copy of the latest {{link\|Members:Contact/Alberta Treasury Branch/Consolidated Statements\|ATB consolidated statement}} {{status\|not yet\|2017-09-01}}
		+

	For ATB chequing		For ATB chequing
Line 38:		Line 39:
	* Verify that there are no uncleared cheques older than 6 months prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared cheques older than 6 months prior to the statement end date {{status\|not yet\|2017-09-01}}

-	~~Similarly for~~ ATB T-~~Bill~~	+
		+	For ATB GICs
		+	* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=51&showHistory=true&displayReport=true
		+	ATB GIC reconciliation] {{status\|not yet\|2017-09-01}}
		+	* Verify that the ending dates match {{status\|not yet\|2017-09-01}}
		+	* Verify that the ending balance match {{status\|not yet\|2017-09-01}}
	* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}

-	Similarly for ATB ~~GICs~~	+
		+	Similarly for ATB T-Bill
	* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}
		+



	Check for unpaid invoices, bills		Check for unpaid invoices, bills

Brett Wuth at 15:55, 2 April 2018

2018-04-02T15:55:11Z

←Older revision		Revision as of 15:55, 2 April 2018
Line 43:		Line 43:
	Similarly for ATB GICs		Similarly for ATB GICs
	* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}		* Verify that there are no uncleared transactions older than 10 days prior to the statement end date {{status\|not yet\|2017-09-01}}
		+
		+
		+
		+	Check for unpaid invoices, bills