UND Foundation Flow-Through Funds
When a donor approaches UND about wanting to donate funds to a specific department, UND directs those donations to the UND Alumni Association & Foundation (referred to as the UND Foundation from this point forward). The donated funds are deposited into an existing UND Foundation fund or a new separate UND Foundation distribution fund is established. Every fund at the UND Foundation is assigned a 5-digit fund number.
When a UND department wants to spend funds that were donated to the UND Foundation for the benefit of a specific UND department, they do this by:
- Incurring the expense in UND’s financial ERP system and submitting a summary of those expense to the Foundation for reimbursement. To use this process, the expense has to be an allowable expense using UND funds and allowable with any donor restrictions at the UND Foundation.
- Submitting an RFP to the UND Foundation and requesting that an expense be paid directly to a supplier by the UND Foundation. This process is utilized for expenses that are unallowable at UND. The expense needs to be allowable per the donor restrictions of the fund. For any questions regarding the RPF process, please contact the UND Foundation directly.
UND Flow-Through Fund Process
A department establishes an alumni flow-through fund at UND. These funds fall in the range of 26000 through 26999. A list of the active UND alumni flow-through funds can be fund on the UND Finance reports website. You’ll need to input your NDUS user ID and password to log into the site. The listing is called “Chartfields – Fund Code Listing”.
When a department wants to spend money from one of their assigned funds at the UND Foundation, they charge the expense to a UND fund number that is an alumni flow-through fund in the range of 26000 – 26999. In addition to using a 26XXX fund, they are also required to use a project ID to code every transaction. The project ID is formatted as UNDF0XXXXX at the end of the project ID correlates to a fund number at the UND Foundation. A department should enter the project ID that correlates to the fund number at the UND Foundation that they want to use to reimburse the expense that they are charging to the UND 26XXX fund. A list of available UNDF project IDs can be found on the UND Finance reports website. You’ll need to input your NDUS user ID and password to log into the site. The listing is called “Chartfields – UND Foundation Project ID Listing.”
When entering a project ID, the following data may also need to be inputted (not all systems required each of the following):
- PC Bus Unit = UND01
- Activity = 1
- An Type = GLE
The project IDs are not budgeted. PeopleSoft Finance checks to see that a valid UNDF project ID has been included in the transaction but will perform no additional validation checks.
On a monthly basis, the UND Controller’s office accumulates all expenses that were posted to funds in the 26000-26999 fund range in a report. They send a summary of the expenses to the UND Foundation, requesting that those expenses be reimbursed to UND, using the UND Foundation fund that is listed within the UNDF0XXXXX project ID of every expenses transaction included in the billing summary.
The UND Foundation receives the billing file of all expenses that UND is requesting to be reimbursed for. They review the expenses to determine that there is enough funding available to cover the expense and that the expense is allowable per the donor agreement. For example, if a donor donated funds to be used for student scholarships, that fund could not be used to reimburse UND for a new laptop that a department wanted to purchase for a faculty member. Once the UND Foundation has reviewed the expenses and determined that they are allowable per the donor agreements, they sent a payment to UND.
The payment that is received by UND is deposited into the individual 26XXX funds and UNDF0XXXXX projects that incurred the expense. In a fiscal year, the expenses that are charged to a 26XXX fund should match the revenue that was recorded to that 26XXX fund as reimbursement is received from the UND Foundation.
The UND Foundation sends data from their financial ERP to UND. This data is used in the Fund Listing report, Fund Activity Details report, and Fund restrictions report in UND’s financial reporting software, TIBCO. Data in these reports is current as of the end of the prior business day.
How to Use Alumni Flow-Through Funds in Various Transaction Types
Below are the various transaction types at UND and how a UND Foundation flow through fund (26XXX) and related project ID (UNDF0XXXXX) can be utilized in each type.
Each journal line that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX), the PC Bus Unit (UND01), Activity (1), and An Type (GLE) entered.
Each journal line that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX), the PC Bus Unit (UND01), Activity (1), and An Type (GLE) entered.
Each travel and expense report line that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX), the PC Bus Unit (UND01), and Activity (1) entered.
Each journal voucher lines that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX), the PC Bus Unit (UND01), and Activity (1) entered.
Each line item that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX) entered. You can enter the project ID, or use the lookup feature in UND Marketplace (click the blue arrow) and a listing of the projects will display.
Each line item that uses a flow-through fund (26XXX) will need to have a UND Foundation fund project ID (UNDF0XXXXX), the PC Bus Unit (UND01), and Activity (1) entered.
UNDF0XXXXX project IDs need to be used to code transactions in PeopleSoft HCM that are coded to 26XXX funds. If a position number needs to be paid using a UNDF project ID that hasn’t been used previously in the fiscal year, a new combo code needs to be requested. The instructions for requesting a new combo code can be found on the Training/Resource Planning & Allocation drop-down. Departments are responsible for requesting any new combo codes, this will not be coordinated by the UND Controller’s office.
Alumni Flow-Through Fund Reporting and UND Foundation Reporting
Reporting: UND Foundation Data
Reporting that contains data from the UND Alumni Association & Foundation is available to UND departments via UND’s financial reporting software, TIBCO. If you don’t have access to TIBCO, please contact your college or unit’s Chief Business Officer or Financial Manager.
These reports show transactions that originated in the UND Foundation’s financial ERP system, including expenses that were submitted to the UND Foundation from UND for reimbursement.
The Chief Business Officer or Financial Manager of each unit or college is responsible for running reports in TIBCO and distributing them within their unit, as needed.
Reporting: UND Data
Reporting that contains data from UND related to the Foundation flow through funds (26XXX) and corresponding project IDs (UNDF0XXXXX) are available in UND’s financial reporting software, TIBCO. If you don’t have access to TIBCO, please contact your college or unit’s Chief Business Officer or Financial Manager.
These reports show transactions that originated in UND’s financial ERP system and were later submitted to the UND Foundation for reimbursement.
Data can also be accessed directly in UND’s finance ERP system, PeopleSoft Finance.
Questions
For any questions related to the alumni flow-through fund process, please contact Jodi Morgan.
- jodi.morgan@UND.edu
- 701.777.6866
-
Bronson Center Room 120
Grand Forks ND 58202-8364