资源链接
的 工作辅助及示范 文件夹 SharePoint has helpful information for Workday reports 和任务 按主题组织.
常见工作日报表
Worktag报告:
- 提取基金
- 提取成本中心
- Extract custom organizations – auxiliary, financing source (still being tested) 和 function
- 提取项目
- 提取分类账
- 提取收入类别
- 提取消费类别
- 数据验证。程序
- View Integration Worktag Mapping – shows mapping from Banner to Workday
预算与实际报告:
- 密歇根州立大学-预算vs. Actuals by Ledger Account – Revenue 和 Expense
- Other reports coming soon (roll-up reports, expense only)
试算表 – accounting report, ties to budget vs actual reports
基金结余报告: (typically used for auxiliaries, projects, 只有几, Program Fees, Summer Revenue)
- MSU -基金余额摘要
- MSU -基金余额摘要 with Cost Center
事务级报告:
- 查找日志行-实际
- Find Plan Lines – overall budget loaded as initial 和 流动预算总额. 可能需要使用过滤器选项:
- Filter for only 流动预算总额
- 排除收入
- 排除一次性预算
- Filter by fund 和/or other worktags
其他有用的报告
MSU – Payroll Distribution Detail – For Company, MSU All Workers Costing Allocation, 查找采购订单, 查找供应商合同, MSU – Purchase Order Lines 和 Line Splits by Company, 分类账户结构
自适应 Insights 和 OfficeConnect
自适应 Insights is a system that is used by the Budget Office 和 campus for analysis 和 budget planning purposes. Every morning the system pulls current budget 和 actuals data from Workday to be available for analysis 和 reporting 和 for reference in identifying the budget for the coming fiscal year.
- Budget vs actual reports are available in 自适应 和 mirror those in Workday, but with a slightly different look 和 feel. 请参阅 培训视频 for further instruction on these reports. (的 budget vs actual reports in Workday are better suited for drilling into numbers.)
- Personnel reports are also available to provide information by level (cost center) including position information, 员工worktags, 工资, FTE, 以及资金分配.
Office Connect is an Excel Add-In program that is available to 自适应 users to design their own reports with custom layouts. 的se reports can be refreshed on dem和 with current information as of that day. To request access to Office Connect, please submit a request permissions ticket by clicking that red box on the right-h和 side of the ITS Enterprise Application Services 网页. Office connect 培训视频s are available 在这里.
更新
February 22, 2024: MSU Fund Balance Summary reports
We have temporarily hidden the fund balance summary reports since they currently cannot be used to determine the correct fund balance for cost centers or projects. Until the necessary adjustments can be made, please use the Prior Year Rollforward line in 密歇根州立大学-预算vs. Actuals by Ledger Account – Revenue 和 Expense to identify the beginning FY24 fund balance for budget tracking purposes. An update will be posted in the future when users can access the fund balance summary reports.
2024年2月5日: 期初基金结余
Beginning fund balance budget entries have been loaded for:
- 辅机
- 夏天的收入
- 只有几
- 项目费用
- Capital projects paid from the Plant Fund 和 Investment in Reserved for Plant Renewal fund.
This will improve the usefulness of the 密歇根州立大学-预算vs. Actuals by Ledger Account – Revenue 和 Expense report in Workday.
2024年2月5日: 预算与实际报告(工作日) & 自适应)
的 actuals column in the Workday budget vs actual report reconciles with the 试算表 report (Operating Book) 和 the 自适应 budget vs actual reports. This report is available in Workday is called 密歇根州立大学-预算vs. Actuals by Ledger Account – Revenue 和 Expense 和 can be accessed by typing this report name in the search bar (or you can simply type “msu bud rev”).
If you notice a difference in the numbers when you pull the 自适应 budget vs actual, this is due to timing since 自适应 is updated once a day at 5:00 AM 和 does not reflect real-time actuals the way that Workday does. Note that the other budget vs actual reports in Workday such as those with “Project”, “辅助”, “基金”, or “Cost Center” at the end of the name, have not yet been modified to reflect the reconciled actuals column. This will be rolled out soon with some other improvements we are pursuing to make the reports more efficient 和 user-friendly.