During the week of May 26, a new financial trending report will be made available. The new "Sources and Uses - Monthly Trending" report allows the user to select the Period, as well as worktag information and then will show Actuals broken out by each period in the respective "Fiscal Year," along with Year to Date Encumbrances, Beginning and Ending Equity numbers. See the full post for more details and where to send questions.
Tagged: Financial Accounting
Coming Soon: New "Sources and Uses - Monthly Trending" Financial Report
Juliette Lonsert | May 16, 2025New Inventory Spend Categories
Juliette Lonsert | May 16, 2025New inventory spend categories have been created to improve visibility into inventory write offs and adjustments. These include: Inventory - Shrinkage (SC10744), Inventory - Cost Adjustment (SC11040), Inventory - Obsolete (SC11039), and Inventory - Spoilage (SC11041). See the full post for details.New Accounting Journal Validation Rules
Cristina Cardenas | May 2, 2025New custom validations have been implemented for accounting journals for The Ohio State University ONLY. The following journal sources are excluded: Central Correction No ACP, Conversion, Supplier Discount, and Capital Expense Reclass. See the full post for a list of validation rules.FY25 Year-end Business Document Clean Up
Cristina Cardenas | May 2, 2025As part of year end procedures and to help ensure a successful procurement roll forward, it is recommended that units review and close out old items with remaining balances if they will no longer be invoiced. Two helpful reports are available to assist with year-end business document clean up: the "UNIV Remaining Encumbrances - Requisitions, POs, Spend Authorizations" report and the "Purchase Orders with Documents Awaiting Action" report. See the full post for more details and report criteria information.Policy Updates: Deposit of Funds Policy and Petty Cash Funds, Change Funds and Cash Advance Payments Policy
Cristina Cardenas | April 4, 2025Effective April 1, 2025, the Deposit of Funds policy and Petty Cash Funds, Change Funds, and Cash Advance Payments policy (formerly named the Cash and Cash Alternatives Payment Methods policy) have been revised by the Office of Business and Finance. These polices provide updated guidance on how units should manage their cash activity. Review the full post for details.Sources and Uses by Cost Center - Field Update
Cristina Cardenas | March 21, 2025Sources and Uses by Cost Center will be updated the week of Monday, March 24. Pre-encumbrance activity will be added to the Encumbrance column so both are captured within the same column. The column name will change from Encumbrance to Pre-Encumbrance/Encumbrance.FY25 Year-End Checklist for Finance and Supply Chain Activities
Ric Hunter | March 7, 2025A downloadable year-end checklist for Finance and Supply Chain activities" is available under the "I want to..." heading found on the Business and Finance website's Controller page.Enhancement to "Payroll Accounting Adjustment Status" Report
Richard Hunter | February 21, 2025Effective the week of Monday, February 24, the "Payroll Accounting Adjustment Status" report will have some enhancements made to its prompt functionality. First, this report will include "Initiated By" as a prompt. Secondly, the prompt functionality for Current Expense Worktags and Proposed Expense Worktags will change to look at what is entered in either prompt.
Below is a brief example using two PAAs.
Enhancement to "Accounting Adjustment Status - OSU" Report
Richard Hunter | February 21, 2025Effective the week of Monday, February 24, a prompt for "Prior Worktags" will be added to the "Accounting Adjustment Status - OSU" report. This particular prompt will use the "or" logic so that if a value is entered in another prompt, such as Proposed Organization, the results will return adjustments that have the proposed organization OR the prior worktags entered in the prompt. This is similar to the change being implemented for Current Expense Worktags and Proposed Expense Worktags on the Payroll Accounting Adjustment Status report.
Reporting Update - Spend Category Hierarchy Grouping Rollup
Richard Hunter | February 21, 2025The reports listed below will be updated during the week of Monday, February 24 to enhance user ability to analyze expenses. Current state, these reports have the ability to expand directly from the ledger account value into all Spend Category detail lines. This update will group the Spend Categories into groupings determined in the All Spend Categories hierarchy. Reports will populate level 5 of this hierarchy with the ability to further expand to detail line items if needed. The hierarchy groupings can be viewed in the “Spend Categories â FDM Values" report.