The upgrade of CUNY’s Financial systems into one integrated package is a key element of CUNYfirst. The Finance Pillar contains a variety of processes that are part of CUNY’s day to day business.

The main areas of the Project focus on:

The CUNYfirst General Ledger launched July 1, 2008. It is the foundation for all future CUNYfirst financial processes and will become the repository of all financial data and reporting.

Finance and business professionals are currently using the General Ledger to enter month-end closing data and financial balances, as well as tuition payment data.

The graphic below denotes that the General Ledger is the foundation for CUNY’s Financial “House”. By providing a base, future processes will continue to populate the General Ledger to provide a full picture of CUNY’s current financial information.

General Ledger Documents

  • Additional Files for Spreadsheet Upload using Windows 7

In order for Spreadsheet Upload to work with Windows 7, the system file “msxml.dll” needs to be placed under C:\Windows\system32 (for Windows 32-bit version) OR C:\Windows\sysWOW64 (for Windows 64-bit version).

Download the file and have your Local Help Desk install it on your machine.

Click to save file – msxml.dll

  • Spreadsheet Upload Files

Click the icons to use or view the attached files

On files 1-3 don’t open, but right click to save to your hard drive

1. Add this file to your local hard drive
2. Add this file to your local hard drive
3. Add this file to your local hard drive
4. Instruction Sheet
5. Template without the upload macros to help users organize their data prior to copying it to #2

The CUNYfirst Planning and Budgeting Module focuses on the advanced Financial planning activities that prepare the university and our colleges for the upcoming fiscal cycles.

The goal for Planning and Budgeting is to create integrated, uniform seamless budget, planning and forecasting processes to be used across CUNY, and to incorporate campus processes, documentation requirements, compliance with laws and regulations, workflow and reporting needs.

 

Planning and Budgeting Terms:

 

EPM – Enterprise Performance Management – The database that holds PeopleSoft Planning & Budgeting 9.0 information.

Budget Development – The annual process, in EPM, where organizations develop spending and revenue projections for the next fiscal year. When adopted and finalized, budgets are exported to Financials and posted to Commitment Control.

ETL – Extract, Transform & Load – The process by which Financials and HCM data is transferred into the EPM database. ETL’s are also used to transfer completed budget data back to Financials and HCM.

Budget Activities – Determine budget development approaches: Line Item, Position, and Asset Activities.

Target Setting – High level top down Line Item Activity used to set the limits for Budget Development.

Line Item Activity – Mostly referred to as Bottom Up Budgeting. Budget is prepared by business unit, account, department, fund and other chartfields as needed.

Position Budgeting – Prepare salaries, earnings and benefits budgets for positions and employees. These budget amounts are inserted into the Line Item Budgeting activity.

Forecasting – Line Item Budgeting that allows multiple years and future periods to be open for projecting spending and revenue.

Asset Budgeting – Prepare budget based on assets and asset categories. The asset and depreciation budget amounts related to the assets are calculated and can be inserted to the Line Item activity.

Purchasing, Accounts Payable, Travel and Expense Requests/Approvals, Credit Card Management.

Tracking of all physical assets of CUNY from buildings and grounds, to equipment, materials and goods and services.