The Reconciliation report leverages the Transaction Summary report, enabling users to monitor and perform real time reconciliation of transactions as they post to a budget (for which they have access).
What is reconciliation?
According to the University of Washington’s Internal Controls website, "reconciliation is the process by which departments verify that their source documentation matches a fiscal report from the central accounting system. Further, reconciliation involves resolving any discrepancies that may have been discovered."
The purpose of regular reconciliation of budget activity is to ensure:
- All charges are for the correct purpose and amount, and allowable
- Errors are detected, investigated and resolved
- All required documentation is maintained
For more information about reconciliation and reconciliation guidelines, refer to the Budget Activity Reconciliation Process Guidelines.
Why use MyFD Reconciliation to reconcile online?
Create notes, flag items for follow-up or check items as they post to a budget and increase department or school/college visibility to reconciliation information. See where in the process the budget/month is at with the Status Bar. Easily share this report with others* so they may review/perform reconciliation duties. The Reconciliation report provides a convenient means to electronically record fiscal oversight by using the Reconciliation Status (often referred to as budget "sign off" process). Additionally, reports in MyFD meet records retention requirements and do not need to be printed. Note that any reports, including MyFD reports, which are printed, signed and dated to document reconciliation activity must be maintained in accordance with the University's retention schedule. Read more about printing MyFD reports before developing a process to print them.
*NOTE: Access to Reconciliation is governed by ASTRA authorization for a budget or organization code, which allows the MyFD user to perform reconciliation duties. Additional ASTRA authorizations may be required for some source documents, like those for UW-IT Rome Technology Service Equipment (TSE) and Long Distance (LD) bills.
Working with the Reconciliation report:
1. Select Reconciliation from the Reports drop down menu.
2. Input a budget number in the View Budget # field, select a time period, and click Go.
There are three views of the Reconciliation report for managing reconciliation activity.
1. Read-Only View: Primarily used for monitoring transaction reconciliation activity. No actions may be taken while in read-only view.
2. Update View: Allows the report to be edited / updated with comments, flags check marks, and more notes. Users can only update items if they:
have been granted access to the budget
switch from Read Only to Update view
3. Expense Transfer View: Provides a convenient way to initiate an expense transfer directly from the Reconciliation Report. While in Expense Transfer View, notes, comments and flags may be applied.
For a list of helpful transaction codes, see the Transaction Summary webpage.
The Reconciliation Status Bar provides an implied process flow for a budget/month’s status. While each must be set in a sequential order, there are no requirements that each status must be used. The status in bold indicates the current status of the budget/month being viewed. The status may not be changed until after a month has closed. MyFD does not send notifications when a status changes. To see a full table of status definitions see the Reconciliation Status Report page.
The Change Status/View Audit Trail button is where a status is set or undone. This is also where to find status change notes or identify who made a status change. Each time a status is changed, the Reconciliation Status Report will be updated to reflect the current state and next step.
Tip: Check out our one page guide! How to Sign-Off on Reconciliation activity
Share a Link:
Provides a direct link to that specific budget and month that can be emailed or copy and pasted into another document. The person receiving the link must also have ASTRA authorization for that budget information sent. If they do not they will not be able to view the information. MyFD does not send email notifications when normal status changes or reconciliation activity occurs.
The Enable Filter and Sort checkbox allows the transactions visible on the Reconciliation Report to be narrowed down/sorted. This is useful for large budgets or when you only want to reconcile a specific set of items. Filtering is also helpful when searching for specific transactions.
Filtering allows large budgets (over 5000 transactions in a given month) to more easily manage reconciliation activities.
Budget Revision Reference Codes:
The Budget Revision code located to the right of the Transaction Date reflects the amount allotment type for State budgets.
|Reference Code||Reference Code Name||Reference Code Description|
|C||CarryForward||That portion of a permanent (on-going) commitment that is not funded in the current biennium|
|P||Permanent||Amounts permanently added to the budget which can be used once each biennium but are also allocated for subsequent biennia|
|T||Temporary||Amounts added for only a single budgeting period|
These terms come from the Office of Planning and Budgeting's Glossary.
Links to Online Source Documents
Source Documents are documents can be either electronic or paper. MyFD facilitates the linking to online source documents for various billing systems. MyFD does not store the source document but rather provides a way for report users to access the information hosted in different systems and needed to perform budget reconciliation.
The systems MyFD links to have various record retention periods. We recommend you acquaint yourself with the table below. Departments should continue to store original source documents within the department when required to do so and according to record retention guidelines.
Locating Source Documents
- Login to MyFinancial.desktop
- Select the Reconciliation option from the Reports drop-down menu
- Enter a budget number, select a time period and click the Go button
- Look in the Amount column for blue text, which provides a hyperlink to the system containing the source document
- Exception: Expense transfer documents can be viewed by clicking the blue date linked in the Ref3 field.
|System||Data first available as of||Data retained in
Source system for
|Academic Technologies||7/1/2013||6 email@example.com|
|Creative Communications||3/1/2009||6 firstname.lastname@example.org|
|Expense Transfer||2008||6 years|
|UW Facilities||1/1/2008||6 years|
|Health Sciences Library (HSL) CTIs||7/1/2015||6 email@example.com|
|Journal Vouchers||3/1/2012||6 firstname.lastname@example.org|
|Library CTIs and ISDs||7/1/2007||6 email@example.com|
|Mailing Services||7/1/2011||6 firstname.lastname@example.org|
|Non-PO Invoice||12/1/2011||6 years|
|ProCard & Travel Card||ProCard: 2/1/2009
|Payment to Individuals (P2I)||10/1/2013||6 email@example.com|
UW-IT Bank and Finance
UW Connect Bill Viewer: 10/30/2021
Additional MyFD Learning Opportunities:
- Take a look at our eLearning opportunities including an overview of reconciliation
- Quick Guide Reference for the Reconciliation Report
- How to "Sign Off" on Budget Activity with the Reconciliation Report
- Review the University’s General Records Retention Schedule (UW-GS6 for Financial Records)
- Review Financial Reporting's Internal Controls website
- Review Financial Reporting's Reconciliation Best Practices and Policies
- Review your departmental reconciliation process and procedures, and update as necessary
Need More Information?
See our FAQs on Reconciliation