Frequently Asked Questions
What it is:
The Endowment Income Funds Pool (EIFP) holds prior year accumulated fund balances from income generated by pure (from donors, not funds functioning as endowment) endowments. Any fund balances generated in the current year and excluded from EIFP. EIFP income posts on object code 45605 (45610 prior to FY21), which rolls up under Investment Income, not Endowment Income. Therefore, EIFP is not forecast in the Tidemark Endowment Planning process. The EIFP policy states that any prior year unspent balances in pure endowment income funds are invested by the university in, essentially, short-term investments called money market funds. The resulting earnings from those investments are distributed to the endowments that have balances.
How to Forecast:
A way to forecast this activity is to estimate what your unspent pure endowment balances will be throughout the year. This will of course depend on your expenses and/or transfers to Operating Budget. Also, you would need to estimate what the money market rates will be in the upcoming year. It is quite challenging to guess the direction of interest rates. That said, they have ranged from over 2% in recent years to almost zero when interest rates are very low. Given that both the volume (unspent balances in endowment awards) and the rate (money market rates earned by the university) are constantly changing, there is no systematic way to forecast this revenue. One suggestion is to assume that unspent endowment balances will be the same as the prior fiscal year and then compare money market rates now versus over the prior twelve months. You can review historical money fund rates at https://fingate.stanford.edu/managing-funds/resource/money-fund-rate. If the current rates are lower than over the past 12 months, then we suggest reducing the rate estimate by the same percentage. With all this said, EIFP is usually not a large revenue source for budget units. The policy on EIFP is describedin the Admin Guide 3.3.2.
The Tidemark Endowment Planning application only includes awards that own shares in the university’s Merged Pool and endowed Pool PTAs. Furthermore, the Endowment Planning application is only updated monthly, on or about the 15th, with data from the prior month. As a result, there may be a delay in seeing very new endowed awards that have been set up in Oracle, either because they do not yet own Merged Pool shares or because the monthly Tidemark update has not yet happened.
Users can confirm whether their award has Merged Pool shares by using the OBI Revenue and Fund Management Reporting dashboard. On the Home tab, choose Endowment and Donor and run the report for your award and fiscal-year-to date equal to the current month. The Historical View of Investment Activities section shows if/when shares have been added to the award. If shares were added more than one month prior to the award, please contact the UBO to troubleshoot why the award is not appearing in Tidemark.
Tidemark uses a single hierarchy for expenditure types and object codes, referred to simply as the object code hierarchy. This hierarchy includes all expenditure and object codes from Oracle, as well as “B” codes used specifically for budgeting. “B” codes are setup as parent codes with groups of oracle codes for a category rolling up to each “B” code. This allows actuals to be “pooled” to the “B” code level and used for seeding budgets at that level.
The Tidemark hierarchy has many levels of aggregation, which roll up to categories meaningful for budget review.
To see the full hierarchy, go to the 03.Reporting process, and open 201. Con Bud report.
There is a filter to change your object code view from Summary to Detail or All.
The Object Code Hierarchy is also available in excel format: https://stanford.box.com/v/tidemarkpooledobjectcodes
Tidemark calculates several object codes used for budgeting. To run this calculation, look for the action called "Calculate All Indirect Costs." This action is available on multiple panels.
Running this action will calculate indirect costs for all PAs and PTAs in your organization (based on the slice on your page). This will apply to your entire budget, not just the data visible on the panel you are on. Once the calculation is complete, you will be able to refresh your page and immediately see the calculated values.
The UBO will run this calculation for the entire university every 2 hours during the day to ensure that data is updated frequently.
The full list of calculated codes is:
|Fringe for Contingent Employees
||FRINGE BENEFITS CONTNGT
|Fringe for Overseas Employees
||TAXES BNFTS OVERSEAS ONLY
|Fringe for PostDocs
||FRINGE BENEFITS POST DOC
|Fringe for RBE
||FRINGE BENEFITS RBE
|Fringe for Students
||FRINGE BENEFITS ZERO
|Fringe for TAs and RAs
||FRINGE BENEFITS GRAD
|Grad Stipend Health Surcharge
||GS HEALTH INS RECOVERY
|Tuition Grant Program (TGP)
||FRINGE BENEFITS TGP
|ISC for Expenses
||INTERDEPT ISC CHG EXPENDITURES
|ISC for Revenue
||INTERDEPT INFRAS-REV CHRG
|ISC for Transfers
||ISC ON TRANSFERS
|IDC (Indirect Cost for Sponsored Research)
||FACILITIES AND ADMIN CHARGE
|ITCC (Converged Communications)
||INTERDEPT CONV COMM/TECHNOLOGY
||BDGT SPONSORED REV
You will not be able to manually budget to these codes. They will always be calculated by the system.
The rate for these calculations is available in the “02. Setup and Fund Management” process in the Departmental Assumptions page. Unlike other types of assumptions, the rates for these calculations are set by the UBO, and may not be edited.
In general, the amount budgeted for related expenses is multiplied by the rate to determine the calculated cost. For example:
$ budgeted for RBE salaries * RBE Fringe Rate = 51750
Some calculated codes have additional restrictions based on specific PTAs or Award types. See the attached matrix for more detailed information. If you have questions, contact the UBO for assistance.
Tidemark brings in all PTAs and PAs (Project-Award) from Oracle every night. This includes both active and inactive accounts. If one or more of the segments are closed, “INACTIVE” will appear in the description of the PTA. All PTAs and PAs are available to see prior history, and for current budgeting. PAs and PTAs that are inactive should be reactivated in oracle if they are to be used for budgeting, otherwise, the budget data will be rejected when it is loaded to oracle.
All expenses in Tidemark are planned based on PTAs, and roll up based on the Task Owning Org (TOO). You will be able to see a PTA if you have access to the Task Owning Org (TOO).
All revenue is planned on PAs, and roll up based on the Award Owning Org (AOO). You will be able to see a PA if you have access to the Award Owning Org (AOO).
Transfers are planned as going from a PA to a PTA. These roll up by AOO and TOO respectively.
If you are looking for a specific PAs or PTAs in an entry panel, check to see if the PA/PTA shows up in the Organization page edge filter. If it does, then set the filter to that PA/PTA and click “Apply”. The grid should be filtered to display that PA /PTA. If no data is displayed, then the rows are likely being suppressed because there is no current data or history on the PA/PTA. This is typical for new PA/PTAs.
To unhide the empty grid rows, click the “Gear” icon in the lower left gray area of the panel. This will open the “Customize View” screen. Set the “Hide Empty Grid Rows” option to “Off” and close the “Customize View” screen. The missing PTA/PA rows should now be displayed.
If the PA/PTA is not searchable/filterable in the Organization filter page edge, check to make sure the slice and organization filter are set to an org to which the PTA TOO or PA AOO belongs and unhide empty grid rows. Also check that the other page edge filters such as “Award Type” are not set to filter it out.
If the above remedies do not help contact the UBO for assistance. If the PTA is recently setup in Oracle it should load to Tidemark by the next day.
Anywhere PTAs or PAs are displayed, they are sorted by Org, then by Award, then by Project, then by Task. You may want to use the Organization page edge to limit your list to the lowest level Org which owns the PTA, and then scroll to find it.
Most panels in the Position Planning path are organized based on the org which owns the position in Peoplesoft. If you don't have access to the position which owns the person you would like to budget, you have two options:
- Communicate with the department who owns the position you'd like to budget. Ask if they are planning to budget this position in Tidemark. If they are, they will be able to allocate the employee's salary to any PTA in the university, including yours. Once they budget the salary and assign the Labor Distribution for the position you're working on, you will be able to see the LD allocation on the "Approve charges for Positions in another department" panel. Here you can put a "1" in the "Labor Distribution PTA Approved Indicator" column. This will approve the salary to be added to your PTA. If you do not want to coordinate with the position owning department, or that department is not doing position planning in Tidemark, use the second option.
- Budget your expense as a salary reserve. Go to the "Monthly Reserve Adjustment" panel in Compensation planning. Click on the itemization icon on the left side of the screen then click on the "New" button in the lower left corner to create a new itemization. Double-click in each itemization field to select values. In the description or notes field, enter information about the position you are budgeting. You can enter separate itemizations for each position you would like to budget. These will be aggregated and included in your budget as soon as you click Apply.
Budgeting Salaries using Position Based Budgeting has two components: budgeting the annual salary for all positions and budgeting the labor distribution PTA allocation for all positions. If either one of these components is missing it will cause salary expenses to be understated.
Also, when positions are budgeted to PTAs where the position owning org (POO) is different from the PTA Task Owning Org (TOO), those need to be approved via the “Approve Labor Distribution Charges from Other Orgs” panel in the 01. Booked Budget: Expense and Revenue process. This approval is required even when both the POO and TOO roll up to your own authority. This step is often overlooked and causes salary expense to be understated.
Any line item that requires approval, will need to be re-approved after any change in Salary or LD. In this case, return to the "Approve Labor Distribution" panel and re-approve.
After the re-approval is done, check the 601 or 603 reports to see that the salary expense has been fully calculated.
There is no way to undo a seeding action to revert back to a prior saved version of your budget. However, if you run another seeding action, it will first clear the results of any prior seeding action, then it will populate based on the criteria of the action selected. There is also an action available on most panels to clear seeding. Be careful when using these actions because they will run based on the current slice and page edges so you may either be seeding or clearing for a larger or smaller population than was intended.
The Transfer “Source” is the PA that is providing funding (where the funds come from). The Transfer “Destination” is the PTA receiving funding (where the funds go to).
In the 02.Booked Budget: Setup and Fund Management process, on the Funding the Budget Matrix panel, the sources are listed as rows while the destinations are columns.
Transfers can be entered into your booked budget 3 different ways:
- Funding the Budget Matrix panel: This panel allows you to enter intra-unit transfers, or transfers where you control both the source and destination. The most common example of this is transferring Designated and restricted funds to cover expenses on Operating Budgets.
- External Transfers panel: This panel allows you to enter inter-unit transfers, or transfers where you control either the source or destination but not both. Label the side you do not own as ‘External’ to say that it is not a PA/PTA that you own.
- TAS – Transfer Administration System: This system allows the creation to 2 sided transfers for both budgeting and future creation in Oracle. Both sides must approve TAS transfers. They are loaded to Tidemark towards the beginning of the booked budget process, and can be adjusted in Tidemark using the External Transfers panel if needed.
It is possible for the UBO to upload your data to Tidemark. The upload process is managed via the budget officer so that uploads can be consolidated in the templates for a more efficient process. Please contact your budget officer to find out if they are allowing your school or department to submit upload files. If so, read this article (insert link to KA) for detailed instructions on how to format and validate your data prior to upload submission.
30001 – UNRESTRICTED FUND BAL
+ 400RV – REVENUES
+ 49001 – OPERATING TRANSFERS
- 50000 – TOTAL EXPENSES
+ 49INT – INTERUNIT FUND APPROPRIATED TO COVER EXPENSES
+ 49300 – ASSET TRANSFERS
= ENDFB – ENDING FUND BALANCE
If the Ending Fund Balance doesn’t look correct or reasonable, be sure to check that the Beginning Balance was budgeted correctly, then Expenses, Revenues, and Transfers.
Budget planning is first done at an annual level. Your Annual Adjusted Amount will be spread to the months in the year according to your historical actuals. If there is no history available, your annual adjusted amount will be spread evenly.
You can go to the Monthly Adjustment panel to see and adjust this spread.
Certain panels allow for itemized entries, often using a unit x rate calculation to provide supporting detail. An example is the monthly adjustment panel. In this panel you can select the itemization icon to open the itemization entry panel at the bottom half of the panel. Multiple rows can be entered using itemizations. The total amount for each PTA/PA and object code will be added to the above grid. Notes/explanations entered in itemizations will be retained for future review in the itemization panel only.
See the user guides for each process for screenshots, and a step by step walkthrough of entering itemizations.
Many panels in Tidemark give you the ability to make a percent or dollar adjustment to values in the rows. When you manually type in an adjustment and hit save, you should see your result automatically calculated. If you've saved a % adjustment, and are not seeing the result, try the following:
- Review the column to the left of the Adjustment % column. On most panels, this column is titled "Baseline Amount" and represents your starting amount for a percentage increase or decrease.
- If your Baseline Amount is blank, that means that you haven't run an action to “seed” a starting point for your budget. Applying a % adjustment will not have an effect, as there is no starting point for adjustment.
- Remove your annual adjustment %, and use the Annual Adjustment Amount to enter the full dollar amount you are trying to budget.
The Dropzone tool is a utility which was created by UBO in 2017 to mitigate some of Tidemark’s shortcomings in exported grids, especially the loss of indentation and number formatting. Since then, Tidemark has made enhancements to exported grids by offering the “Export with Formats” option, which preserves most formatting. As a result, the tool is no longer necessary except for certain reports such as the Appendix A report in the Budget Plan process. Also, because of the recent redesign of many reports, especially in the “03. Reporting” process, the Dropzone tool is no longer compatible.
Printing functionality in Tidemark has also improved. Whenever possible, you should simply rely on using the “Export with Formats” option. You’ll get the best printing results if you choose Landscape, Fit to Width, Legal, and Repeat Row and Column Headers.
This report, and a few others, use YTD (year-to-date) time members for selection, where a selection represents the time period starting at the beginning of the financial year (Sep) through the month designated. So, “2019 May YTD” represents the period spanning Sep 2018 through May 2019.
YTD reports will generally open initially at the YTD month with the most recent actuals. In the case of the 231 report, which also includes five years of actuals, each of those years will also reflect the same YTD month for that year; the default YTD month will result in “missing” history as a result.
To overcome this and see all of history, change the time page edge to the entire year, e.g. “FY 2019”, and the prior years of history will each show the entire year.
Tidemark Variance reports are included in Tidemark 03. Reporting process. There are five reports we suggest to analyze year-end variances and a few additional reports useful for longer trends and detailed analysis, see Variance Reporting Job Aid. Full descriptions of the reports can be found in the Variance Reporting Guide.
•204 – Variance by Object Code
•205 – Variance by Award Type and Object Code
•304 – Variance by Org Tree
•305 – Variance by Award Type and Org Tree
•231 – 5 Year History with Variances
•331 – Org Tree 5 Year History
•515 – All PTA Detail and Object Code Detail by Month
If you have some awards that incur ISC charges at 6% instead of 8%, then you can enter your 2% recovery adjusments manually. Which panel and code you make the ISC adjustment on depends on what type of ISC charge you are recovering against. They are all done in the ISC Adjustment panels within the process.
||ISC Revenue Adjustment
||ISC Transfer Adjustment
||ISC Expense Adjustment
Note: Indirect Cost Recovery (IDC) adjustments to Federal and Non-Federal G&C are made in the Booked Budget: Expense and Revenue Process.
•Open the appropriate Non-Salary Expense panel (YER or BB Annual or Monthly)
•Filter Page Edge CB Award Type: Federal or Non-Federal G&C
•Filter Page Edge Object Code to 56900
•May need to Unhide Empty Grid Rows using settings icon on left sidebar
•Enter + or – IDC Adjustment on code 5690B and click SAVE.
In order to capture all PA/PTAs in the mapping rule, the Award Purpose should be set to All Awards. If Budget Pool is chosen, it will only map Pool PA/PTAs, not all PTAs that match the criteria selected.
Yes. Sponsored research (Federal G&C, Non-Federal G&C and University Research) are already summarized to “summary members” in Tidemark. The “summary members” have names like QAUF-Federal G&C and summarize all activity in the Org and Award Type. But these summary members are not real PTAs in Oracle so they need to be mapped to a Budget Pool PTAs.
Awards for ISC allocation (BYxxx) should not be mapped, so that ISC can be properly recorded. The UBO has entered rules to prevent these from being mapped.
Beyond these rules, it is up to you (or your budget officer) to determine how pooling is used.
Yes. Pooling rules can be changed at any time and the results of changes in the rules will be reflected in Tidemark the next day. However, once you start budgeting, be careful making changes where budgets have already been entered. Pay special attention to changing rules that involve PTAs used for Labor Distribution or Transfers, as this may impact work that has already been done in your budget.
The consolidated budget is setup in the concept of a profit and loss (P&L) income statement.
It includes revenues, transfers and expenses. The bottom line of the consolidated budget is the surplus or deficit that is generated after subtracting Expenses from Revenues and Transfers.
If you are dealing with a single PTA such as an Operating Budget (which, by definition, only has expenses), its bottom line will be in a negative or deficit balance. It requires a transfer of funds to cover the deficit and balance the bottom line to $0.