General Instructions Balance Sheet Reconciliations Page 6
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10 If a Pivot is being used, revise amounts (groupings, etc) to reflect changes during
the current period and update the Details of Account area of the reconciliation.
Ensure that only appropriate items are recorded in the Details of Account, all
other items which require corrective action must be listed in the Reconciling
Item(s) area. The Details of Account area needs to have sufficient details of the
transactions or grouped balances to make it clear that these are appropriate
items or grouped balances for the account.
If the sum of the Sub-Module Report Balance and/or the Details of Account do
not balance to the PeopleSoft General Ledger Balance, the remaining
transactions must be identified under Reconciling Item(s).
Investigate and take corrective action to clear all Reconciling Item(s), either
through a sub-module correction or by manual journal entry, as appropriate, by
the next month end.
The Unreconciled Balance must equal to zero.
♦ More detailed information and procedures are included in the Balance Sheet
Reconciliation Excel Template document (link is below).
♦ Forward the completed reconciliation to the assigned Department based Reviewer (if
applicable), or to Financial Reporting at
acctrecs@ucalgary.ca
.
4) Contact Information and Document Links:
For assistance with these
Email
acctrecs@ucalgary.ca
requirements or procedures
Telephone
403-210-6533
Balance Sheet Account
Reconciliation Requirements
under Month/Quarter End Procedures
January 2013
Account Reconciliation List 2013
under Month/Quarter End Procedures
Balance Sheet Reconciliation
Excel Template
under Month/Quarter End Procedures
Balance Sheet Reconciliation
under Month/Quarter End Procedures
Excel Sample
Financial Reporting Contact List
General Instructions Balance Sheet ReconciliationsV1.0.docx
6
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Business