Reconciliation is the process of comparing information that exists in two systems or locations, analyzing differences and making corrections so that the information is consistent in both locations. Account reconciliations ensure consistency between the department's records and the University’s general ledger and resulting financial reports.
This policy requires that departments complete quarterly reconciliations of balances in specific balance sheet accounts at the WhoKey level to ensure that balances in the general ledger is equal to balances in sub-systems.
All funds within the balance sheet account must be included in the reconciliation.
Departments may use the reconciliation template provided or use their own format.
All reconciliations must be retained in the department and available to share as requested by central administration or auditors.
Detailed documentation to support the balance sheet balances must be retained in the department (see Adequate Documentation below).
At fiscal year-end, all reconciliations must be complete and available by the third weekend in August.
Responsibilities of Account Owner
- Designate a Reconciler for each relevant balance sheet account and document that reconciliations are completed in a timely manner.
- Review the quarterly reconciliation for reasonableness and focus on unusual fluctuations in balances.
- Assess the value of assets and liabilities to determine if valuation adjustments are necessary (receivables write-off, inventory adjustments, etc.).
- Review and obtain approval of all valuation adjustments from department head.
- Contact Accounting and Financial Services if balance sheet adjustments are required.
- Ensure that appropriate corrective actions have been taken, including communications with superiors as necessary.
Responsibilities of Reconciler
- Verify that prior period errors have been corrected.
- Compare the ending balance per the general ledger and the sub-system.
- Identify, research, resolve and document all variances and reconciling items.
- Complete reconciliation spreadsheet (departments may use template provided).
- Take appropriate action to resolve errors/discrepancies by collaborating with Account Owner as necessary.
- Document that the reconciliation is complete and communicate all issues to the Account Owner. This can be accomplished by sending an email to the Account Owner stating that balance sheet accounts have been reconciled and issues have been addressed.
Departments are responsible for proof of review and source documentation.
Furthermore, they are accountable for providing this information in a timely manner at the request of Central Administration, Internal Audit or external auditors. Documentation that is not maintained centrally must be maintained by departments.
Supporting documentation, either paper or electronic, must be adequate to support the financial transactions and balances.
This documentation must be maintained in the department and provide sufficient information to describe the activity and allow for retrieval of source documentation to support the balances and respond to auditor sampling.
1100, 1101, 1102, 1119, 1120
Due From Interdepartment
Accounts Payable – Other
Due To Interdepartment
Central Administration is responsible for reconciling other balance sheet accounts, particularly reconciliation of general ledger balances to major central subsystems.
WhoKey – The full MFK (Master File Key) consists of ten elements. A combination of six chartfield elements make up the “WhoKey” and these elements are Fund, Organizational Unit, Department/SubDepartment, Grant/Program and Function. The BRF (Budget Reference Field) is the sixth element that makes up a unique WhoKey only for externally-sponsored grants and contracts (fund 500 and 510 accounts that begin with a grant/program of ‘1’ or ‘2’) and cost sharing (grant/program accounts that begin with a ‘3’). All other WhoKeys that have a funding source other than externally-sponsored grants and contracts and cost sharing have no BRF value.
Account Owner – This is the person who has general decision making authority over the account and fiscal responsibility & accountability for the account. The Account Owner for non-grant accounts is typically the Departmental Administrator but may be delegated to a Business Manager, Financial Officer or Program Administrator. The Account Owner for grant accounts is the Principal Investigator. Research Administrators are not permitted to be the Account Owner.
Quarterly Reconciliation of Balance Sheet Accounts
Final Policy as of 2/18/08
Last updated 5/01/13