4.23 Exhibit 2 ELI Template.xls

XLS spreadsheet 70 KB Posted

Attached to
Mechanical Engineering Support and Assistance (MESA) Request for Proposal (RFP)
Solicitation number
CZ-2664-06012025
Issued by

About this file

This document is an Electronic Labor Invoicing (ELI) Template detailing comprehensive invoice submission requirements and rejection codes for subcontractor invoices at the Jet Propulsion Laboratory (JPL). The template provides detailed guidelines for electronic labor invoicing, including specific requirements for invoice type codes (such as FFEE, AFEE, IFEE, COST, RET), mandatory fields, and a comprehensive list of 135 potential rejection codes with corresponding actions for JPL Subcontracts Manager, Supplier, and Supplier Payment teams.

The template includes specific instructions for different invoice types (Cost Type and Fixed Price), with precise requirements for data entry, such as date formats, required fields, and acceptable cost description values. Each rejection code specifies detailed actions for the supplier, subcontracts manager, and payment team, covering issues ranging from affiliate name mismatches and incorrect billing rates to exceeding contract ceilings and unauthorized overtime. The template serves as a critical procedural document to ensure accurate and compliant invoice submissions for JPL subcontractors, with a focus on maintaining strict financial and administrative controls.

View the file

Other files

File Type Posted
Addendum 5 - MESA RFP.pdf PDF
A-22 SB Joint Venture Certificate.docx DOCX document
Addendum 4 - MESA RFP.pdf PDF
Addendum 3 - MESA RFP.pdf PDF
Addendum 2 RFP MESA.pdf PDF
Addendum 1 RFP MESA.pdf PDF
JPL Acknowledgement Form 2384-A1.docx DOCX document
Notice of SB JPL Form 4022-A6.docx DOCX document
Acct Sys JPL Form 7370 A-20.doc DOC document
Past Perform JPL Form 0358-A14.docx DOCX document
4.23 Exhibit 13 FP LimitationJPLObligation.pdf PDF
4.23 Exhibit 7 Cyber Review Template Rev.41.xlsx XLSX spreadsheet
CPFF MESA Std Subcontract Final.pdf PDF
4.23 Exhibit 6 Unescorted Access Form 7394-B12.pdf PDF
4.23 Exhibit 12 CR Stds of Conduct Form 4412-B11 (1).pdf PDF
4.23 Exhibit 3 Weekly Status Report Template.xlsx XLSX spreadsheet
RFP-CZ-2664-06012025 FINAL.pdf PDF
4.23 Exhibit 4 JPL Design Principles.pdf PDF
CPFF Article 2 Payment Provisions - Rate Table.xlsx XLSX spreadsheet
4.23 Exhibit 5 MESA SDRL.pdf PDF
Attachment A-15 CPFF CEB.xlsx XLSX spreadsheet
FP Article 2 Payment Provisions - Rate Table.xlsx XLSX spreadsheet
4.23 Exhibit 1 SWO Procedure MESA.pdf PDF
4.23 Exhibit 14 MESA List of Applicable DRDs.pdf PDF
Attachment A-15 FP CEB.xlsx XLSX spreadsheet
Fixed Price MESA Std Subcontract Final.pdf PDF
Show all 26

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cover

Exhibit No.: 2
Subcontract No.:
Dated 3/24/2025
Electronic Labor Invoicing (ELI) Template

PO Template Requirements

TypeCodeInvoiceNoInvoiceDatePOSWOProjectTaskAmountCostDescriptionWeekEnding
PORequiredRequiredRequiredRequiredRequiredRequiredRequiredRequired
PORequiredRequiredRequiredRequiredRequiredRequiredRequiredRequired
RETRequiredRequiredRequiredRequiredRequiredRequired
Cost Description Values:
FFEE - Invoice charges for the fixed fee by SWO.
AFEE - Invoice charges for the award fee by SWO.
IFEE - Invoice charges for the incentive fee by SWO.
COST - Invoice charges for cost by SWO.
RET - Invoice charges for retention by SWO.
Date Format:
DD-MON-YYYY

&C&"Arial,Bold"ELI &A

FP Template Requirements

TypeCodeInvoiceNoInvoiceDateSWOProjectTaskAmountWeekEnding
FPRequiredRequiredRequiredRequiredRequiredRequiredRequired
RET-FPRequiredRequiredRequiredRequiredRequired
Cost Description Values:
FP - Fixed price invoice charges
RET-FP - Retention
Date Format:
DD-MON-YYYY

&C&"Arial,Bold"ELI &A

Rejection Codes

RejectionRejection ReasonSupplier ActionJPL Subcontracts Manager (SCM) ActionJPL Supplier Payment Action (IMS)
1Affiliate Name or Badge not matched with HRConfirm that name and badge is correct in the invoice file.Confirm that name and badge is

correct in the invoice file. Confirm that HR has the correct name.

2 Affiliate Name or Badge not matched with the SWO or violates transaction control Confirm that the name and badge is correct in the invoice file. Confirm that name and badge is correct in the invoice file. Confirm that SEPA has the correct name and badge.

3Amount and Hour fields must have the same signCorrect invoice file and resubmit.
4No Invoice DateCorrect invoice file and resubmit.
5Multiple Affiliate SWO travel charges cannot be submitted on the same invoiceCorrect invoice file and resubmit.Compare total billed amount to ceiling.

Mod SWO if ceiling is insufficient.

Resolve billing discrepancies as necessary.

6 Exceeds SWO Ceiling (SMS) Compare total billed amount to ceiling.

Contact SCM if ceiling is insufficient.

Confirm previous billing plus current billing If ceiling is insufficient, SCM will contact CTM to inquire about potential ceiling increase If ceiling needs to be increased, request PR from CTM

7Billing Period not within Subcontract POPConfirm week ending date is within POP.Confirm week ending date is within POP.
8No Billing RateCorrect invoice file and resubmit.Confirm billing rate is correct for the

week ending. Resolve discrepancies as necessary.

9 Billing Rate not matched with SMS Confirm billing rate is correct for the week ending. Contact the SCM to resolve sescrepancies. Confirm billing rate is correct for the week ending. Resolve discrepancies as necessary.

10Duplicate Invoice NumberCorrect invoice file and resubmit.
11Billing type unknownCorrect invoice file and resubmit.
12Exceeds Project/Task or no CommitmentConfirm total billed amount to commitment.

Contact SCM to mod PO to increase commitment.

Contact Supplier Payment if thereare billing discrepancies. Confirm total billed amount to commitment. Mod PO to increase commitment if necessary. Resolve billing discrepancies as necessary.

13 Exceeds Subcontract Ceiling Confirm total billed amount to subcontract ceiling.

Contact SCM to mod subcontract to increase ceiling.

Contact Supplier Payment to resolve billing discrepancies. Confirm total billed amount to subcontract ceiling. Mod subcontract to increase ceiling if necessary.

Resolve billing discrepancies as necessary.

14 Exceeds SWO Ceiling Confirm total billed amount to SWO ceiling.

Contact SCM to mod SWO to increase ceiling.

Contact Supplier Payment to resolve billing discrepancies. Confirm total billed amount to SWO ceiling. Mod SWO to increase ceiling if necessary. Resolve billing discrepancies as necessary.

15Billing Rate not matched with Approved Rate for the periodConfirm billing rate is correct for the week ending.
Contact the SCM to resolve discrepancies.Confirm billing rate is correct for the

week ending. Resolve discrepancies as necessary.

16Overtime not allowed without ST hour charges for PositionConfirm that straight time has been billed for the same week ending date.
17Invalid Hours, Rate or AmountCorrect invoice file and resubmit.
18Invalid Project/Task for SWOCorrect invoice file and resubmit.
19Invalid Service CodeContact the CTM for resolution
20Invalid Hour CodeCorrect invoice file and resubmit.
21Invalid SWO NumberCorrect invoice file and resubmit.
22Invalid Work Order NumberCorrect invoice file and resubmit.
23No Affiliate recordConfirm that badge number and name is correct in the invoice file.
Contact SCM to resolve this issue.Confirm that affiliate record exist in

HR. Fix data as necessary.

24No AmountCorrect invoice file and resubmit.
25No Badge NumberCorrect invoice file and resubmit.
26Accrual Invoice must be cancelled, prior to invoice creationJPL Supplier Payment has received notification.
Contact the Supplier Payment analyst for resolution.Cancel accrual in AP. None/System cancels the accrual
27No error for this line
28No SWOCorrect invoice file and resubmit.
29No HoursCorrect invoice file and resubmit.
30No Last NameCorrect invoice file and resubmit.Confirm swo, project, task, and week

ending date has previously been billed. Resolve billing discrepancies as necessary.

31No previous amount billed for negative chargeConfirm project, task, and week ending date has previously been billed.
32No Project NumberCorrect invoice file and resubmit.
33No Hour Code for labor chargeCorrect invoice file and resubmit.
34No SWO or PO NumberCorrect invoice file and resubmit.
35No Task NumberCorrect invoice file and resubmit.
36No Invoice NumberCorrect invoice file and resubmit.
37No WE DateCorrect invoice file and resubmit.Confirm SWO is authorized for ODC.

Mod SWO to authorize if necessary.

38ODC not authorizedConfirm SWO is authorized for ODC.
Contact SCM for authorization if needed.Confirm overtime is within

authorized hours for the week ending. Mod SWO to increase overtime if necessary.

39 Overtime exceeds authorized hour in SMS Confirm overtime is within authorized hours for the week ending.

Contact SCM for data discrepancies. Confirm that the affiliate is nonexempt and that 8 hours of straight time has been billed for the same week ending date.

40 Overtime not allowed without a min of 8 ST hour charges Confirm that the affiliate is non-exempt and that 8 hours of straight time has been billed for the same week ending date. Confirm that the affiliate is nonexempt and straight time hours has been billed for the same week ending date.

41 Overtime not allowed without any ST hour charges Confirm that the affiliate is exempt and straight time hours has been billed for the same week ending date. Confirm SWO is authorized for overtime for the week ending date.

Mod SWO to authorize if necessary.

42 Overtime not Authorized Confirm SWO is authorized for overtime for the week ending date. Contact SCM to mod SWO to authorize if necessary. Confirm overtime is authorized for the position. Mod subcontract to allow overtime for the position if necessary.

43 Overtime not authorized for position Confirm overtime is authorized for the position.

Contact the SCM to mod subcontract to allow overtime for the position. Contact CTM to inquire about whether OT should be authorized If authorized, request a PR from CTM

44Project and/or Task are not chargeableContact the CTM for resolution
45Project Number not foundConfirm that project is correct in the invoice file.

Contact the CTM for resolution.

46 Project/Task Number not Authorized for Affiliate Confirm that the project task was authorized for the affiliate to charge for the week ending date.

Contact the CTM for resolution.

47Requires ODC Cost Description for chargeConfirm that cost description is present for ODC invoice line.
48Requires Travel Cost Description for chargeConfirm that cost description is present

for Travel invoice line.

49 Invalid Cost Description for charge Confirm that cost description contains the correct pre-defined values.

50 Service Center Project Number not Authorized for Affiliate charging Confirm that the project task was authorized for the affiliate to charge for the week ending date.

Contact the CTM for resolution.

51Service Code RequiredContact the CTM for resolution
52ST hours Exceed Schedule, possible Duplicate Invoice or Work Schedule requiredConfirm that straight time billed has not
exceeded 40 hours.Supplier needs to use AW code after it's approved by SCM if applicable. Confirm that straight time billed

has not exceeded 40 hours. Resolve discrepancies as necessary.

53 Status not Affiliate for Transaction Date Confirm that badge number and name is correct in the invoice file.

Contact SCM to resolve this issue. Confirm that affiliate record exist in HR for the weekending date. Fix data as necessary.

54 Travel & ODC on same invoice is not allowed Confirm that Travel and ODC invoice lines do not have the same invoice number.

55 Submittal Date is over 90 days past WE date Supplier to delete invoice line and handle these charges offline. Need to obtain approval from SCM. If approved need to work with Supplier Payment to process the lines through. Approve invoices as necessary.

Provide direction to supplier and Supplier Payment.

56 Task Number not found Confirm that task is correct in the invoice file.

Contact the CTM for resolution.

57 Transaction and Type Code Mismatch Confirm that on non-labor line (all type codes except LABOR, LABOR-C, CATX, RATE), hour code and rate fields are blank.

Confirm that on type code FAC, FEE, ODC-C, PMOX, PMOA, RADJ, MAT-T, ODC-T, SUB-T, and TRV-T, last name and badge number fields are blank.

Confirm that on labor and T&M non- RATE (type codes other than RATE) lines, cost description is blank.

Confirm that on type code RATE, FAC, FEE, ODC-C, PMOX, PMOA, RADJ, MAT-T, ODC-T, SUB-T, and TRV-T, SWO number field is blank.

Confirm that on invoice lines other than

TRVO, periodNo action from SCM; but, available to answer and/or clarify anything if supplier needs more information on Subcontract/SWO
58Transaction Date not within Project Date RangeConfirm that the charges are authorized.

Work with the SCM or CTM to either get project end date extended or obtain new cost account to charge. Confirm that the charges are authorized. Work with the PRA or CAM to either get project end date extended or obtain new cost account to charge.

59 Transaction Date not within SWO Start/End Date Confirm that SWO, week ending date is correct. Work with SCM to get SWO extended. Confirm that SWO, week ending date is correct. Work with CTM to resolve issue if necessary.

60 Transaction Date not within Task Date Range Confirm that the charges are authorized.

Work with the SCM or CTM to either get task end date extended or obtain new cost account to charge. Confirm that the charges are authorized. Work with the PRA or CAM to either get task end date extended or obtain new cost account to charge.

61 Transaction requires a Period Start and Period End Date Correct invoice file and resubmit. No action from SCM; action/change performed by supplier Period Start/End dates available to supplier on subcontract/SWO 62 Travel not authorized in SMS Confirm travel is authorized. Work with SCM to obtain authorization. Confirm travel is authorized.

Provide authorization if necessary 63 Type Code unknown Confirm that type code in the invoice file is correct.

64Rate Type not authorized for SubcontractConfirm rate type is authorized. Work
with SCM to obtain authorization.Confirm rate type is authorized.

Provide authorization if necessary.

65 Project and/or Task is not chargeable, violates transaction controls Confirm that P/T is authorized.

Contact SCM or CTM to correct transaction controls. Confirm that P/T is authorized.

Work with PRA or CAM to correct transaction control.

66WE Date is not a SundayCorrect invoice file and resubmit.
67WE Date not within SWO Start/End DateConfirm that SWO, week ending date is correct.
Contact the SCM to resolve discrepancies.Confirm that SWO, week ending date

is correct. Resolve discrepancies as necessary.

68 WE Date not within WAM POP Confirm that the charges are authorized for the week ending with the SCM/CTM.

If authorized, CTM to authorize P/T in

SWAM.

69Rate Type unknownConfirm that rate type is correct.
70Possible Duplicate ChargeConfirm that no other invoice lines exist

with the same exact data. If one exists, combine the lines and resubmit.

71 Exceeds 85 Percent of Authorized Fee Withholding Required Confirm that RET lines exist in the file submission. If not, add RET line and resubmit.

72 Exceeds Max Authorized Cost Confirm that COST lines in the current invoice file and previous billing do not exceed the max authorized cost. If there is still an issue with the cost listed on the Subcontract/SWO, determine origin of discrepancy with Supplier and communicate with CTM If there is an error on the subcontract/SWO, request narrative and PR from CTM to make the necessary change

73Retention not required
74Exceeds Max WithholdingConfirm that RET lines are in the current

invoice file and previous billing do not exceed the retention cap.

75Invalid Amount and/or SWO Number
76Invalid SWO and/or PO NumberConfirm that SWO or PO number in the

file submission is correct. If yes, contact the Subcontract Manager for direction. Confirm that SWO or PO number in the file submission is the same as in Oracle Purchasing.

77 Service Code not required Contact the CTM for resolution Confirm that the project task billed is not a service order task.

78 Invoice contains labor and other charges For TTAPS subcontracts, confirm that labor and non-labor invoice lines do not appear on the same invoice number.

For T&M subcontracts, confirm that position and non-position invoice lines do not appear on the same invoice number.

79Affiliate Type not defined in HRContact the SCM for resolution.Confirm that affiliate type is defined in HR for the POP.
80Non labor Hour/Qty and Amount fields must equalConfirm that hour/qty and amount field

for non-labor invoices lines are the same figure.

81 Authorized Fee not found Contact the SCM for resolution. Confirm that the authorized fee amount has been entered in Oracle Purchasing.

82 Exceeds Max Authorized Fee Confirm that fee amount billed in the current invoice file and previously billed are less than the maximum authorized fee amount.

83Date cannot be in the futureCorrect invoice file and resubmit.
84No Type CodeCorrect invoice file and resubmit.
85Rejected Based on Associated Fee LineCorrect other invoice lines and resubmit.
86Double-time not allowed without ST and OT chargesConfirm that straight time and overtime

hours for the SWO are either in the current invoice or have been previously billed. Contact Supplier Payment to resolve discrepancies. Supplier to check prev. billing. Confirm that straight time and overtime hours for the SWO are either in the current invoice or have been previously billed. Resolve discrepancies as necessary.

87Invalid Invoice NumberCorrect invoice file and resubmit.
88SWO Mod No required for travel chargeCorrect invoice file and resubmit.
89Material, ODC and subcontractor charges cannot be submitted on the same invoiceConfirm that different types of non-rate

related charges are not billed on the same invoice number.

90 Invalid subcontractor category Confirm that badge number field for CATY affiliates is blank. Resolve discrepancies with SCM. Confirm that affiliates correctly classified as either CATA or CATY.

Resolve discrepancies with HR if necessary.

92Invalid Work ScheduleContact the CTM for resolution
93Negative invoice amount exceeds amounts previously invoiced on matched PO linesConfirm previous billing plus current billing.
95Retention not requiredReview invoice for retention line
97Retention amount invalidReview invoice and confirm retention amount
103Project and Task must be blank for Retention invoice linesReview invoice
104Final Retention invoice exceeds amount withheldContact Supplier Payment for resolution.
105Final invoice must have 'final' in invoice numberReview invoice
999Internal ExceptionContact the JPL Helpdesk
112Project/Task not authorized for SWOContact SCM for resolution.If a new P/T needs to be added, the CTM must authorize this change via a supplemental PR
114Week Ending Date not within SWO Start/End DateContact SCM for resolution.
115Job classification is not authorized on SWOContact SCM for resolution.
116Second Tier not authorizedContact SCM for resolution.
117Travel not authorizedContact SCM for resolution.
118Exceeds hours authorized for job classificationContact SCM for resolution.
121Billed costs exceed SWO CeilingConfirm previous billing plus current billing.If there is an error on the SWO, request narrative and PR from CTM to make the necessary change, if not, then there is no action from SCM
122Not eligible for overtime for affiliateContact SCM for resolution.
124Week Ending Date not within job classification Start/End DateContact SCM for resolution.
125Retention amount is invalidContact Supplier Payment for resolution.
127Retention exceeds max retention amount and/or Retention bill back is not allowedContact Supplier Payment for resolution.
128ST hours exceeds maximum allowable hours for week ending dateConfirm previous billing plus current billing.
129Required fields missing informationContact the JPL Helpdesk
130No ST and OT charges for affiliateConfirm previous billing plus current billing.
131Double Time is not authorized for job classificationContact SCM for resolution.
133Affiliate Expenditure Category Type (labor category) not matched in HRContact SCM for resolution.
134Retention RequiredConfirm that there is a retention line for the submitted invoice file.IMS has no access to comfirm. Confirm that the contract has retention defined and that a retention percent is defined in the ELI lookups.
135Retention must be less than or equal to the total retention amount widthheld.Confirm that you are not billing back for more retention than what you initially gave. (ex. If you gave us $200 is retention previously, you cannot bill us back for $300). Contact Supplier Payment if unable to resolve.

File details come from the government source that posted it. Updated .