Editing Book Keeping Task/Monthly review

From PCSAR

Warning: You are not logged in. Your IP address will be recorded in this page's edit history.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.

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.

{{tasks iteration date|{{#time: Y-m-01|}} }}

* 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 {{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
* 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}}

Please note that all contributions to PCSAR are considered to be released under the Attribution-Share Alike 3.0 Unported (see PCSAR:Copyrights for details). If you don't want your writing to be edited mercilessly and redistributed at will, then don't submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. DO NOT SUBMIT COPYRIGHTED WORK WITHOUT PERMISSION!

Summary:

Cancel | Editing help (opens in new window)

Templates used on this page:

Retrieved from "http://pcsar.dyndns.org:8080/mediawiki/index.php/Book_Keeping_Task/Monthly_review"

Editing Book Keeping Task/Monthly review

From PCSAR

Views

Personal tools

Navigation

Search

Toolbox

@@ Line 48: / Line 48: @@
 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}}