Each year all Professional Development & Foundation Projects must be certified by the current Project Approver. Project Approvers are certifying that all financial activity from the previous fiscal year followed Mines Financial Policy and any specific purpose and or restrictions of the applicable Foundation gift.
Moving forward these certification requests are being sent as a single email based on the Project Approver. A separate email will be sent to the Project Approver and their supervisor to review any projects that ended in deficit in the prior year.
Also new moving forward, Project Approvers are responsible for reviewing all the financial activity within Workday. There are two methods we recommend for reviewing this activity which are detailed below, and can be accessed using the information provided in the email sent by the General Accounting team. A sample of the email that will be sent is at the bottom of the page.
Review Expense Activity using the Workday Balance Reports
For this method, you will need to use the new Balance Reports, specifically the Detailed Version - Operating Accounts, Cash Projects, & Foundation Gifts Balance Report (AFBR | My Funds). This single report will allow you to review both Professional Development Worktags (under Cash Projects) and Foundation Projects at once.
- To access any of the balance reports go to the list of icons on the left side of the screen, gover over General Ledger and select Financials Dashboard
- Navigate to the section titled "Budget Vs. Actuals" and select New AFBR Dashboard.
- The new dashboard will open, from here select Detail Version - Operating Accounts, Cash Projects, & Foundation Gifts Balance Report (AFBR | My Funds).
- This report will prompt the following, see the hints in Red for what values to use for the FY26 Annual Certification:
- Time Period – This prompt indicates the timeframe for which you would like to run the report. This should default to "Current Period YTD ", if not select it.
- Period – This prompt allows you to select a specific financial reporting period—such as a month, quarter, or fiscal year. The report will return results only for the selected period/time period combination. "2026 - P12 - Jun"
- Cash Project/Foundation Gift Worktags – Use this prompt for your worktags starting with a “1”, “3”, “9”, or “6” Enter the worktag(s) on the Certification email received.
- Operating Account Worktags – Use this prompt for your worktags starting with a “2”
- Worktags – Here you can enter the Fund, Function, Ledger Account or other worktags to narrow down report results
- Cost Center – Use this prompt to find all worktags that fall under a specific Cost Center
- Financial Manager – This prompt will default to you as the logged-in-user. You can choose to keep this default to run for all worktags where you are listed as the Account Manager or Project Approver, add in other names, or clear the default entirely and enter in new names.
- The Balance Report should open with rows that can be expanded for each of the Projects listed on the report prompt in step four. For more information on how to read the balance reports you can download the applicable balance diagrams connected to this article.
- The Balance Report shows the sum of activity by type (Revenue, Expense, Transfer etc.) but not the specific transactions that must be reviewed. To see the transaction level detail you can click on any of the values that appear in blue and a pop-up window will appear showing all the transactions for that category. This can be viewed within Workday or exported to Excel for easier viewing.
- Note, one of the advantages of viewing this within Workday is that you can further drill down into a transaction and see the operational details and applicable documentation. If you do this, it is recommended to right-click and select the option to open the specific transaction in a new tab to avoid losing the current report. If you view the data in Excel, you can "drill down" on a specific transaction by searching for the transaction by the document number in the Workday search bar.
Review Expense Activity using the Find Journal Lines Report
This second method is ideal if you prefer to view data in Excel and or want to see all financial activity, regardless of type, at once.
- To access the report type "Find Journal Lines - Reference ID - Campus Copy" into the main Workday search bar. Once you select the report a prompt window will open and the following fields will need to be completed as described below:
- Company: Colorado School of Mines
- Year: 2025
- Period: P12 - Jun
- Ledger: Actuals
- Book: Common Book
- Status: Posted
- Ledger Account Type: (Select all three) Revenue, Transfer, Expense
- Worktags: This is where you will enter the Project Number(s). You can pull the report one project at a time or all at once and then filter the actual data once pulled.
- Once all the fields have been filled out click OK and a report will open. This can be viewed within Workday and filtered by clicking on any of the column headers or it can be extracted to Excel for easier viewing of the transactions. For more information on how to read the report please download the Find Journal Lines diagram connected to this article.
- Note, unlike the balance report, this report's data is not summarized so each record/line represents a transaction. If you choose to review within Workday and want to drill down to see more information for a specific transaction, it is recommended to right-click on the record and select the option to see in a new tab to avoid losing the current report. If you view the data in Excel, you can "drill down" on a specific transaction by searching for the transaction by the document number in the Workday search bar.
After the financial activity has been reviewed, please reply directly to the email sent by the General Accounting team. See an example of the email below.
- If you want to certify that all the financial activity for all of the projects included on the email are compliant with Financial Policy and applicable Gift restrictions, reply Approved to the email.
- If you only want to certify specific projects, reply with a list of the projects that are approved and status update on the remaining projects.
- If you were contacted about projects that you currently manage but did not oversee during the period of financial activity please work with the prior Project Approver or reply directly to the email and the General Accounting team will work with you directly.
- If you have questions about specific transactions or projects, reply directly to the email with a brief explanation of what you would like help with and the General Accounting team will work with you directly.
Email Example
