Year End Financial Task - Revision history

Sabrina Ryans: /* Tasks */

Sabrina Ryans — Thu, 11 Feb 2021 19:41:07 GMT

Tasks

←Older revision		Revision as of 19:41, 11 February 2021
Line 9:		Line 9:
	# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|not yet\|2020-02-24}}		# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|not yet\|2020-02-24}}
	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|not yet\|2020-02-23}}		# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|not yet\|2020-02-23}}
-	~~#* issues:~~
-	#** Accounts Payable (A/P) - USD shows a [[User:Brett Wuth/Working Notes/2020-02-23 Accounts Payable (A/P) - USD discrepancy\|consistent unresolved -$0.02]] {{status\|}} '''pending: may not be able to resolve for 2018-2019 year end
	# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|not yet\|2020-02-23}}		# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|not yet\|2020-02-23}}
	# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|not yet\|2020-02-23}}		# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|not yet\|2020-02-23}}

Sabrina Ryans: /* Tasks */

Sabrina Ryans — Thu, 11 Feb 2021 19:40:19 GMT

Tasks

Brett Wuth at 11:51, 24 February 2020

Brett Wuth — Mon, 24 Feb 2020 11:51:18 GMT

←Older revision		Revision as of 11:51, 24 February 2020
Line 1:		Line 1:
-	At the end of each financial year	+	At the end of each financial year, year end financial statements are produced.
		+
		+	This process can take around 30 hours, depending on the amount of corrections that need to be made.

	== Tasks ==		== Tasks ==

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 11:42:54 GMT

Tasks

←Older revision		Revision as of 11:42, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|done\|2020-02-24}}
-	# Prepare the Deferred Revenue Reconciliation statement {{status\|}}	+	# Prepare the Deferred Revenue Reconciliation statement {{status\|done\|2020-02-24}}
	# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}		# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 11:02:09 GMT

Tasks

←Older revision		Revision as of 11:02, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. File them as the year-end financial statements and with the [[Audit]] records. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|}}
		+	# Prepare the Deferred Revenue Reconciliation statement {{status\|}}
		+	# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 10:59:38 GMT

Tasks

←Older revision		Revision as of 10:59, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. ~~Submit~~ them as the year-end financial statements. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. File them as the year-end financial statements and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 10:52:35 GMT

Tasks

←Older revision		Revision as of 10:52, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# ~~Run~~ the [[~~FinancialStatementsTask~~]] for the end of the current year. Submit them as the year-end financial statements. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. Submit them as the year-end financial statements. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 10:51:25 GMT

Tasks

←Older revision		Revision as of 10:51, 24 February 2020
Line 17:		Line 17:
	# Record the [[Members:Book Keeping Task/GST\|GST rebatible]] {{status\|done\|2020-02-24}}		# Record the [[Members:Book Keeping Task/GST\|GST rebatible]] {{status\|done\|2020-02-24}}
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
-	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|}}	+	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
	# Run the [[FinancialStatementsTask]] for the end of the current year. Submit them as the year-end financial statements. {{status\|}}		# Run the [[FinancialStatementsTask]] for the end of the current year. Submit them as the year-end financial statements. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 10:23:05 GMT

Tasks

←Older revision		Revision as of 10:23, 24 February 2020
Line 5:		Line 5:

	# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|2020-02-22}}		# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|2020-02-22}}
-	# Make sure there are no transactions on the top-level accounts of ATB Casino or ATB Chequing {{status\|}}	+	# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|done\|2020-02-24}}
	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|done\|2020-02-23}}		# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|done\|2020-02-23}}
	#* issues:		#* issues:

Brett Wuth: /* Tasks */

Brett Wuth — Mon, 24 Feb 2020 10:06:56 GMT

Tasks

←Older revision		Revision as of 10:06, 24 February 2020
Line 5:		Line 5:

	# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|2020-02-22}}		# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|2020-02-22}}
		+	# Make sure there are no transactions on the top-level accounts of ATB Casino or ATB Chequing {{status\|}}
	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|done\|2020-02-23}}		# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|done\|2020-02-23}}
	#* issues:		#* issues:

←Older revision		Revision as of 19:41, 11 February 2021
Line 9:		Line 9:
	# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|not yet\|2020-02-24}}		# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|not yet\|2020-02-24}}
	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|not yet\|2020-02-23}}		# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|not yet\|2020-02-23}}
-	~~#* issues:~~
-	#** Accounts Payable (A/P) - USD shows a [[User:Brett Wuth/Working Notes/2020-02-23 Accounts Payable (A/P) - USD discrepancy\|consistent unresolved -$0.02]] {{status\|}} '''pending: may not be able to resolve for 2018-2019 year end
	# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|not yet\|2020-02-23}}		# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|not yet\|2020-02-23}}
	# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|not yet\|2020-02-23}}		# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|not yet\|2020-02-23}}

←Older revision		Revision as of 11:42, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|done\|2020-02-24}}
-	# Prepare the Deferred Revenue Reconciliation statement {{status\|}}	+	# Prepare the Deferred Revenue Reconciliation statement {{status\|done\|2020-02-24}}
	# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}		# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

←Older revision		Revision as of 11:02, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. File them as the year-end financial statements and with the [[Audit]] records. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|}}
		+	# Prepare the Deferred Revenue Reconciliation statement {{status\|}}
		+	# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

←Older revision		Revision as of 10:59, 24 February 2020
Line 18:		Line 18:
	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}		# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|done\|2020-02-24}}
	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}		# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|done\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. ~~Submit~~ them as the year-end financial statements. {{status\|}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. File them as the year-end financial statements and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}

←Older revision		Revision as of 19:40, 11 February 2021
Line 6:		Line 6:
	{{Tasks iteration date\|{{current or past month\|09}}-01}}		{{Tasks iteration date\|{{current or past month\|09}}-01}}

-	# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|~~2020~~-02-22}}	+	# Perform an inventory of all assets and adjust accounts as appropriate {{status\|won't\|2021-02-11}}
-	# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|~~done~~\|2020-02-24}}	+	# Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard {{status\|not yet\|2020-02-24}}
-	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|~~done~~\|2020-02-23}}	+	# Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. Correct or clarify any issues. {{status\|not yet\|2020-02-23}}
	#* issues:		#* issues:
	#** Accounts Payable (A/P) - USD shows a [[User:Brett Wuth/Working Notes/2020-02-23 Accounts Payable (A/P) - USD discrepancy\|consistent unresolved -$0.02]] {{status\|}} '''pending: may not be able to resolve for 2018-2019 year end		#** Accounts Payable (A/P) - USD shows a [[User:Brett Wuth/Working Notes/2020-02-23 Accounts Payable (A/P) - USD discrepancy\|consistent unresolved -$0.02]] {{status\|}} '''pending: may not be able to resolve for 2018-2019 year end
-	# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|~~done~~\|2020-02-23}}	+	# review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? {{status\|not yet\|2020-02-23}}
-	# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|~~done~~\|2020-02-23}}	+	# review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) {{status\|not yet\|2020-02-23}}
-	# the "Transaction List by Supplier" report for the financial year (to identify bills that have been entered entered twice and paid twice). {{status\|~~done~~\|2020-02-23}}	+	# the "Transaction List by Supplier" report for the financial year (to identify bills that have been entered entered twice and paid twice). {{status\|not yet\|2020-02-23}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the previous year. {{status\|~~done~~\|2020-02-24}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the previous year. {{status\|not yet\|2020-02-24}}
-	# Make sure that the financial statements match the year end financial statements that were [[Audit#Audits\|submitted the previous year]]. {{status\|~~done~~\|2020-02-24}}	+	# Make sure that the financial statements match the year end financial statements that were [[Audit#Audits\|submitted the previous year]]. {{status\|not yet\|2020-02-24}}
-	# If they don't you may have transactions that were booked for the wrong year or you may have transactions that were entered for the previous years that were entered after the last year's financial statements were prepared. If the latter, enter transactions on the year boundary to adjust the books. One on the last day of the financial year to recreate the audited statements, and a reversing one on the first day of the new year to reflect the true status. {{status\|~~done~~\|2020-02-24}}	+	# If they don't you may have transactions that were booked for the wrong year or you may have transactions that were entered for the previous years that were entered after the last year's financial statements were prepared. If the latter, enter transactions on the year boundary to adjust the books. One on the last day of the financial year to recreate the audited statements, and a reversing one on the first day of the new year to reflect the true status. {{status\|not yet\|2020-02-24}}
-	# Record the [[Members:Book Keeping Task/GST\|GST rebatible]] {{status\|~~done~~\|2020-02-24}}	+	# Record the [[Members:Book Keeping Task/GST\|GST rebatible]] {{status\|not yet\|2020-02-24}}
-	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|~~done~~\|2020-02-24}}	+	# Add the [[Book Keeping Task/Depreciation\|depreciation]] for the current year. {{status\|not yet\|2020-02-24}}
-	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|~~done~~\|2020-02-24}}	+	# Adjust the [[Members:Book Keeping Task/Deferred Revenue\|deferred revenue]]. {{status\|not yet\|2020-02-24}}
-	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|~~done~~\|2020-02-24}}	+	# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports\|Financial Statements]] for the end of the current year. {{status\|not yet\|2020-02-24}}
-	# Prepare the Deferred Revenue Reconciliation statement {{status\|~~done~~\|2020-02-24}}	+	# Prepare the Deferred Revenue Reconciliation statement {{status\|not yet\|2020-02-24}}
	# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}		# File them as the year-end [[Members:Financial/Statements\|financial statements]] and with the [[Audit]] records. {{status\|}}
	# Have the books and statements [[Audit\|audited]]. {{status\|}}		# Have the books and statements [[Audit\|audited]]. {{status\|}}