This page provides the current process to upload mass funding files that update funding for filled and unfilled positions that are not subject to a salary cap or do not have multiple components of pay (MCOP) in UCPath.
When multiple positions require funding updates, a mass funding Excel spreadsheet can be used to complete the updates in a single transaction. Use the guidelines below to complete the required fields within the spreadsheet.
Requirements for using the mass funding file include the following:
The department Suspense funding must be in place. If your department is new, contact General Accounting to ensure the Suspense funding is set up for your department. Refer to the following resource below for instructions on establishing or updating the Suspense FAU.
Establish or Update the Suspense FAUThe department must pre-approve all funding within the Excel file. Mass funding uploads skip the approval workflow engine (AWE) process in UCPath and the funding is automatically updated in UCPath without approval.
Effective dating and effective sequencing allow UCLA to retain historical, enter future, and identify the current fund source information.
The Funding Effective Date field indicates when Fund Sources take/took effect. The effective date can be in the future, but avoid entering effective dates and funding too far in the future in the event that Fund Sources change before the effective date.
Future effective date: If the date is in the future, the funding will be used when that future date becomes the current date.
Past effective date: If the effective date is in the past, the funding takes effect immediately unless there is another existing set of funding with an effective date that is more recent. If using a past effective date, you must enter a Salary Cost Transfer (SCT) transaction to correct the funding for any payrolls processed between the effective date and the current date.
Current effective date: If the effective date is today, the funding is applied to any subsequent payrolls until funding with another effective date is entered and approved.
The Eff Seq field prioritizes multiple entries that have the same effective date to indicate which entry is current and the sequence of historical values. UCPath automatically assigns the appropriate effective sequence. The first entry for a specific date is always 0. Subsequent entries for the same date are assigned sequence 1, 2, 3 and so on. The entry with the highest sequence number takes precedence over all other entries for that effective date.
The Funding End Date field indicates when Found Sources are no longer valid.
If the Funding End Date field is blank, the fund source remains in effect until funding with a new effective date takes effect.
If the Funding End Date field is populated and there is no funding populated after the end date, the department's Suspense/Default account is charged. For example, if a Fund Source has a Funding End Date of 09/30/2026, there should be a Fund Source with an Funding Effective Date of 10/01/2026, otherwise the Suspense/Default account will be charged.
The Funding End Date field is important during fiscal year end funding activities. Any distribution line with the Funding End Date field blank automatically rolls over to the new fiscal year during the automated rollover process. This means you do not have to re-enter active distribution lines at the start of the new fiscal year.
Leave the Ern Code field blank on at least one funding line to indicate that the fund source on that line should be charged for any earn code not specified on any other funding line. This is sometimes referred to as the "catch all" line.
For example, if the funding entry has line 1 with blank earn code and line 2 with REG earn code, all REG earnings will be charged to the fund source on line 2 and all earnings other than REG will be charged to the fund source on line 1.