Book Keeping Task/Monthly review

From PCSAR

< Book Keeping Task(Difference between revisions)
Jump to: navigation, search
Current revision (04:21, 25 August 2018) (edit) (undo)
 
(14 intermediate revisions not shown.)
Line 10: Line 10:
** Are the ending amounts the same?
** Are the ending amounts the same?
** Are there transactions that haven't cleared which should have?
** Are there transactions that haven't cleared which should have?
 +
Specifically:
Specifically:
-
* Get a copy of the latest Mastercard {{link|Members:Contact/Alberta Treasury Branch/Credit Card/Statements}} {{status|not yet|2017-09-01}}
+
* Get a copy of the latest {{link|Members:Contact/Alberta Treasury Branch/Credit Card/Statements|Mastercard statement}} {{status|not yet|2017-09-01}}
 +
* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=52&showHistory=true&displayReport=true Mastercard 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}}
 +
 
 +
 
 +
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}}
 +
 
 +
 
 +
For ATB chequing
 +
* Get a copy of the latest [https://ca.qbo.intuit.com/app/reconcile?accountId=274&showHistory=true&displayReport=true ATB Chequing 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 deposits older than 10 days 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}}
 +
 
 +
 
 +
For ATB casino
 +
* 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 balance match {{status|not yet|2017-09-01}}
 +
* Verify that there are no uncleared deposits older than 10 days 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}}
 +
 
 +
 
 +
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}}
 +
 
 +
 
 +
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}}
 +
 
 +
 
 +
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 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
 +
{{status|not yet|2017-09-01}}
 +
 
 +
Review the current
 +
[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}}

Current revision

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


The ATB accounts all use one consolidated statement


For ATB chequing

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


For ATB casino

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


For ATB GICs

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


Similarly for ATB T-Bill

  • Get a copy of the latest ATB T-Bill reconciliation link= (not yet for 2017-09-01)
  • Verify that the ending dates match link= (not yet for 2017-09-01)
  • Verify that the ending balance match link= (not yet for 2017-09-01)
  • Verify that there are no uncleared transactions older than 10 days prior to the statement end date link= (not yet for 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 current Accounts Payable Aging Detail report for any bills over 30 days as possible duplicates or outstanding bills link= (not yet for 2017-09-01)

Review the current Accounts Receivable Aging Detail report for any invoices over 90 days that need following up on link= (not yet for 2017-09-01)

Facts about Book Keeping Task/Monthly reviewRDF feed
Tasks iteration date 2024-06-01  +
Retrieved from "http://pcsar.dyndns.org:8080/mediawiki/index.php/Book_Keeping_Task/Monthly_review"
Personal tools