Year End Financial Task

From PCSAR

(Difference between revisions)
Jump to: navigation, search
(Tasks)
Current revision (19:41, 11 February 2021) (edit) (undo)
(Tasks)
 
(51 intermediate revisions not shown.)
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 ==
{{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}}
-
* Visually inspect each account in the online accounting system making sure they make overall sense. Review transactions for the last fiscal year. {{status|}}
+
# 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}}
-
** issues:
+
# 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}}
-
*** "GST rebate receivable" does not have any transactions listed
+
# 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}}
-
*** "Golf Shirts" show no inventory; when did we purchase?
+
# 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}}
-
*** "T-Shirts" show no inventory; when did we purchase?
+
# 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}}
-
**** compare 2018-12-31 on "6117 Search Hats", "6118 Search Shirts"
+
# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports|Financial Statements]] for the end of the previous year. {{status|not yet|2020-02-24}}
-
*** "Avalanche Gear" show no purchases; when did we purchase?
+
# 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}}
-
*** "Computer" show no purchases; when did we purchase?
+
# 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}}
-
*** 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]] starting 2018-11-19
+
# Record the [[Members:Book Keeping Task/GST|GST rebatible]] {{status|not yet|2020-02-24}}
-
**** error is in balance at start of fiscal year
+
# Add the [[Book Keeping Task/Depreciation|depreciation]] for the current year. {{status|not yet|2020-02-24}}
-
**** needs adjusting journal entry at start of fiscal year 2018-09-01
+
# Adjust the [[Members:Book Keeping Task/Deferred Revenue|deferred revenue]]. {{status|not yet|2020-02-24}}
-
**** exchange rate at 2018-09-18 1.297353
+
# Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports|Financial Statements]] for the end of the current year. {{status|not yet|2020-02-24}}
-
*** "Deferred revenue (2018 Provincial Training)"
+
# Prepare the Deferred Revenue Reconciliation statement {{status|not yet|2020-02-24}}
-
**** should probably be separate accounts for each year's grant
+
# File them as the year-end [[Members:Financial/Statements|financial statements]] and with the [[Audit]] records. {{status|}}
-
**** does not appear to have been cleared of $7700 since earlier course was run
+
# Have the books and statements [[Audit|audited]]. {{status|}}
-
*** "Incidents:2019-07-04 Boulder Run" and "Incidents:2019-07-06 Lethbridge search"
+
-
**** appear not to have been invoiced to tasking agency, may need to be written off
+
-
*** weird journal entry 2018-10-17 $964.70 deleting avalanche transcievers
+
-
*** "4200 Provincial Training Grant" shows no income
+
-
* Prepare the [[Members:Book Keeping Task/QuickBooks/Online/Reports|Financial Statements]] for the end of the previous year. {{status|}}
+
-
* Make sure that the financial statements match the year end financial statements that were submitted the previous year. {{status|}}
+
-
* 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. {{status|}}
+
-
* Record the GST recoverable {{status|}}
+
-
* Add the [[Book Keeping Task/Depreciation|depreciation]] for the current year. {{status|}}
+
-
* Adjust the [[Members:Book Keeping Task/Deferred Revenue|deferred revenue]]. {{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|}}
+

Current revision

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.

[edit] Tasks

  1. Perform an inventory of all assets and adjust accounts as appropriate link=
  2. Make sure there are no transactions on the top-level accounts of ATB Casino, ATB Chequing or ATB Mastercard link= (not yet for 2020-02-24)
  3. 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. link= (not yet for 2020-02-23)
  4. review the "A/R Aging Detail" report; question any A/R older than 90 days -- are these in error? link= (not yet for 2020-02-23)
  5. review the "A/P Aging Detail" report (to identify bills that may have been entered but never paid, or entered twice) link= (not yet for 2020-02-23)
  6. the "Transaction List by Supplier" report for the financial year (to identify bills that have been entered entered twice and paid twice). link= (not yet for 2020-02-23)
  7. Prepare the Financial Statements for the end of the previous year. link= (not yet for 2020-02-24)
  8. Make sure that the financial statements match the year end financial statements that were submitted the previous year. link= (not yet for 2020-02-24)
  9. 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. link= (not yet for 2020-02-24)
  10. Record the GST rebatible link= (not yet for 2020-02-24)
  11. Add the depreciation for the current year. link= (not yet for 2020-02-24)
  12. Adjust the deferred revenue. link= (not yet for 2020-02-24)
  13. Prepare the Financial Statements for the end of the current year. link= (not yet for 2020-02-24)
  14. Prepare the Deferred Revenue Reconciliation statement link= (not yet for 2020-02-24)
  15. File them as the year-end financial statements and with the Audit records. link=
  16. Have the books and statements audited. link=
Personal tools