Overview
This guide provides details on how Net Position is calculated and displayed in MyReports.
Introduction to Net Position
The term Net Position is similar to the for-profit concept of equity. It represents the accumulated resources in a Fund, Dept ID, Project, or a combination of those three chartfields.
This guide provides more details on how Net Position is calculated and displayed in MyReports.
MyReports provides a Net Position calculation on all Management Reports and on some Operational and Faculty Portfolio Reports. The term Net Position was previously known as “Equity”, “Fund Balance”, “Unexpended Balance”, or “Net Assets”.
How is Net Position Calculated?
| 1 - Net Position Beginning of Period | + | 2 - Change in Net Position, or Increase/(Decrease) in Net Position | = | 3 - Net Position End of Period |
|---|---|---|---|---|
| Net Position is carried forward at the Fund/DeptID/Project/Activity Period level from the previous fiscal year. | Calculated As: Revenues |
Net Position in MyReports
- Daily calculation and update:
Net Position is reported down to the Fund/DeptID/Project/Activity Period/Function/Flexfield level, and is updated daily in MyReports. - Year-end calculation and carry forward balances:
At fiscal year-end, Net Position is calculated at the Fund/Dept ID/Project/Activity Period level, and the balance is carried forward to the beginning of the next fiscal year. - Chartfields that do not carry forward balances:
Function and Flexfield are rolled up to the Fund/DeptID/Project/Activity Period level at year-end.
Sample Net Position Report with Net Position Calculation
Net Position Carry-Forward at Year-End Considerations: Function and Flexfield
Due to the PeopleSoft year-end closing rules for Net Position, Function and Flexfield are not carried forward from the year-end calculation of Net Position to the Beginning Net Position balance at the start of the next fiscal year.
Management or Operational reports that are run for chartstrings that include Function or Flexfield will not show a Beginning Net Position balance at the start of each fiscal year. Net Position balances at the Function and Flexfield level at fiscal year-end will roll up to Fund/Dept ID/Project/Activity Period at the beginning of each new fiscal year. As this may create some reporting anomalies, please be aware that this is due to the PeopleSoft year-end closing rules for Net Position rather than an error in the report.
| Fund 4-Character | Dept ID 6-Character | Project 7-Character | Activity Period 2-Character | Function 2-Character | Flexfield 6-Character | |
|---|---|---|---|---|---|---|
| Chartfields carry forward. Net position balance is retained in period 0 for each chartfield combination. | X | X | X | X | ||
| Chartfields do not carry forward. Net Position is not retained. | X | X |
MyReports Net Position Calculation Data Sources from the Data Warehouse
MyReports extracts its information from the Data Warehouse and uses these data sources to calculate Net Position:
| Item | PeopleSoft | Data Warehouse |
|---|---|---|
| Calculation of Net Position | At year-end only | Daily, monthly, quarterly, and year-end |
| Net Position – Beginning of Fiscal Year |
| Sourced from PeopleSoft at the beginning of the fiscal year |
| Revenues | Updated daily for all chartfields | Sourced from PeopleSoft nightly for all chartfields |
| Expenses | ||
| Income/(Loss) from Operations | Not calculated in PeopleSoft | Revenues less Expenses, calculated nightly for all chartfields |
| Other Changes | Updated daily for all chartfields | Sourced from PeopleSoft nightly for all chartfields |
Change in Net Position, or Increase/(Decrease) in Net Position | Not calculated in PeopleSoft | Revenues less Expenses plus Other Changes, calculated nightly for all chartfields |
| Net Position – End of Period | Beginning Net Position plus Increase/(Decrease) in Net Position for all chartfields | |
Net Position – Beginning of Period (any period other than July 1) | Carry forward Net Position from the previous period (daily, monthly, or quarterly) in the current fiscal year | |
| Net Position – End of Fiscal Year | At year-end, balances in Function and Flexfields are rolled up to Fund/DeptID/Project/Activity Period | Beginning Net Position plus Change in Net Position, or Increase/(Decrease) in Net Position for all chartfields |
Additional Information and Assistance
- More information about MyReports, including how to request access and additional training, can be found in the MyReports section of the Controller’s Office website.
- If you require help with a technical problem or have a question about a specific report, contact the Controller’s Office Solution Center at [email protected] or 415.476.2126.
- To stay informed about MyReports news, follow the directions on the MyReports section of the Controller’s Office website to join the MyReports ListServ.