Embedded Files
UPDOC Templates
UPDOCs allow users to load and submit multiple transaction entries to COMPAS by using specific Excel spreadsheet templates. This process converts the uploaded templates into system transaction documents which then route for review and approval.
Please note: These templates are only available for use in the COMPAS test environment.
UPDOC Template Instructions
Please be advised that UPDOC templates must not be altered or modified in any way aside from user data entry.
For a successful UPDOC experience, you must first DOWNLOAD the template to Excel (.xlsx) on your local computer and use that clean, unmodified version for your transactions.
Do not add, delete, rename or rearrange any tabs.
Do not add, delete, rename or rearrange any columns.
Do not modify any protected or hidden fields.
Using a modified template is the most common cause of UPDOC upload failures.
Completing the spreadsheet:
The spreadsheet contains two tabs. Screen reader users may navigate between tabs by pressing Control + Page Up or Page Down.
Some fields contain dropdown menus. These can be opened by pressing Alt + Down Arrow.
Fill in data as needed or required, beginning with Transaction Name, Record Date, etc.
The spreadsheet will validate to ensure data does not exceed system field maximum lengths and that the required fields are populated.
NOTE: All fields with an asterisk in the header are required.Columns may be hidden or resized for ease of use and entry, but should never be deleted.
Entry of dates must use mm/dd/yyyy format.
The maximum number of rows is 1000. Additional data should be populated and loaded in subsequent spreadsheets.
Uploading to the system:
Log into COMPAS.
Type 'UPDOC' in the Global Search bar.
Click 'Upload Spreadsheet' in the upper right-hand side of the page.
Drag the UPDOC file to the drop zone or click 'Browse' to locate your UPDOC file. Enter the appropriate transaction code in the Transaction Code field.
Click 'Upload'.
4. Confirm the load:
Log into COMPAS.
Type 'UPDOC' in the Global Search bar.
Locate your spreadsheet by User ID and file name. This view will show whether or not the file was processed successfully.
Once located, click the three-dots on the right side of the line, select Related Pages, select View Logs to see your entries. Select individual entries to see transaction data and specific errors encountered during processing.
Additional Information
Additional templates will be released for use during the implementation.
Errors may vary. If COMPAS does not provide adequate information in the error notification, please email SoC_COMPAS@state.co.us with User ID, file name, time of upload for additional assistance.
Transaction Templates
LDPM - Labor Distribution Profile Management - v1 (Jan 2026)
Use this template to create or modify Labor Distribution Profiles (replacing Accounting Templates as the tool used to allocate payroll expenses). Some specific column information is included below:
Column A is numbered based on unique LDPR codes.
Columns B and C should copy down.
Column D is the department you're creating the documents under.
Column G will be numbered inside Column A. If the LDPR has a three-way split, here is where you would number 1, 2, 3, inside the same number of Column A.
Column O then needs to add up to 1.0 for these lines.
The rest of the asterisked columns are required.
OTDED - One-Time Deduction - v1 (Jan 2026)
Use this template to create one-time deductions for employees to process on the next scheduled payroll.
Column A is numbered down for each OTDED transaction.
Columns B and C should copy down.
Column D is the department you're creating the documents under.
Column G will be numbered inside Column A. If adding multiple deduction codes, here is where you would number 1, 2, 3, inside the same number of Column A.
Column H is the EID for the employee receiving the deduction.
Column J is 1 for add and 2 for replace.
Columns L and M are for the Deduction Code and corresponding Deduction Plan.
Column N is for the date of the deduction.
Columns O and P are for the dollar or rate of the deduction, respectively (if the code isn’t configured for a set dollar/rate).
The rest of the asterisked columns are required.
OTPAY - One-Time Payment - v1 (Jan 2026)
Use this template to create one-time payments for employees to process on the next scheduled payroll.
Column A is numbered down for each OTPAY transaction.
Columns B and C should copy down.
Column D is the department you're creating the documents under.
Column G will be numbered inside Column A. If adding multiple earnings codes, here is where you would number 1, 2, 3, inside the same number of Column A.
Column H is the EID for the employee receiving the payment.
Column J is for the earnings code being paid.
Column K is the amount to be paid.
Column L is for the date of the payment.
Column M should copy down.
Columns O is:
2 if you’re completing Columns R thru AU
3 if you’re completing Column P
4 if the expense should be allocated to the default funding LDPR on the position record
The rest of the asterisked columns are required.
TADJ - Time Sheet Adjustment - v1 (Jan 2026)
Use this template to create time sheet adjustments for employees to process on the next scheduled payroll.
Column A is numbered down for each unique EID.
Columns B and C should copy down.
Column D is the department you're creating the documents under.
Column G will be numbered inside Column A. If adding multiple lines earnings codes per employee, here is where you would number 1, 2, 3, inside the same number of Column A.
Column H is the EID for the employee receiving the timesheet adjustment.
Column L is the event date.
Column M is for the earnings code.
Column N is for the amount – hh:mm if a time-based code (REG) or $$.$$ if a dollar-based code (BNS).
Columns Q is:
1 if you’re completing Columns S thru AV
2 if you’re completing Column R
3 if the expense should be allocated to the default funding LDPR on the position record
The rest of the asterisked columns are required.
Page updated
Report abuse