4.23 Exhibit 2 ELI Template.xls
XLS spreadsheet 70 KB Posted
- Solicitation number
- CZ-2664-06012025
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
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
| TypeCode | InvoiceNo | InvoiceDate | PO | SWO | Project | Task | Amount | CostDescription | WeekEnding |
| PO | Required | Required | Required | Required | Required | Required | Required | Required | |
| PO | Required | Required | Required | Required | Required | Required | Required | Required | |
| RET | Required | Required | Required | Required | Required | Required | |||
| 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
| TypeCode | InvoiceNo | InvoiceDate | SWO | Project | Task | Amount | WeekEnding |
| FP | Required | Required | Required | Required | Required | Required | Required |
| RET-FP | Required | Required | Required | Required | Required | ||
| Cost Description Values: | |||||||
| FP - Fixed price invoice charges | |||||||
| RET-FP - Retention | |||||||
| Date Format: | |||||||
| DD-MON-YYYY |
&C&"Arial,Bold"ELI &A
Rejection Codes
| Rejection | Rejection Reason | Supplier Action | JPL Subcontracts Manager (SCM) Action | JPL Supplier Payment Action (IMS) |
| 1 | Affiliate Name or Badge not matched with HR | Confirm 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.
| 3 | Amount and Hour fields must have the same sign | Correct invoice file and resubmit. | |
| 4 | No Invoice Date | Correct invoice file and resubmit. | |
| 5 | Multiple Affiliate SWO travel charges cannot be submitted on the same invoice | Correct 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
| 7 | Billing Period not within Subcontract POP | Confirm week ending date is within POP. | Confirm week ending date is within POP. |
| 8 | No Billing Rate | Correct 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.
| 10 | Duplicate Invoice Number | Correct invoice file and resubmit. |
| 11 | Billing type unknown | Correct invoice file and resubmit. |
| 12 | Exceeds Project/Task or no Commitment | Confirm 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.
| 15 | Billing Rate not matched with Approved Rate for the period | Confirm 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.
| 16 | Overtime not allowed without ST hour charges for Position | Confirm that straight time has been billed for the same week ending date. | |
| 17 | Invalid Hours, Rate or Amount | Correct invoice file and resubmit. | |
| 18 | Invalid Project/Task for SWO | Correct invoice file and resubmit. | |
| 19 | Invalid Service Code | Contact the CTM for resolution | |
| 20 | Invalid Hour Code | Correct invoice file and resubmit. | |
| 21 | Invalid SWO Number | Correct invoice file and resubmit. | |
| 22 | Invalid Work Order Number | Correct invoice file and resubmit. | |
| 23 | No Affiliate record | 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. Fix data as necessary.
| 24 | No Amount | Correct invoice file and resubmit. | ||
| 25 | No Badge Number | Correct invoice file and resubmit. | ||
| 26 | Accrual Invoice must be cancelled, prior to invoice creation | JPL Supplier Payment has received notification. | ||
| Contact the Supplier Payment analyst for resolution. | Cancel accrual in AP. None/System cancels the accrual | |||
| 27 | No error for this line | |||
| 28 | No SWO | Correct invoice file and resubmit. | ||
| 29 | No Hours | Correct invoice file and resubmit. | ||
| 30 | No Last Name | Correct invoice file and resubmit. | Confirm swo, project, task, and week |
ending date has previously been billed. Resolve billing discrepancies as necessary.
| 31 | No previous amount billed for negative charge | Confirm project, task, and week ending date has previously been billed. | |
| 32 | No Project Number | Correct invoice file and resubmit. | |
| 33 | No Hour Code for labor charge | Correct invoice file and resubmit. | |
| 34 | No SWO or PO Number | Correct invoice file and resubmit. | |
| 35 | No Task Number | Correct invoice file and resubmit. | |
| 36 | No Invoice Number | Correct invoice file and resubmit. | |
| 37 | No WE Date | Correct invoice file and resubmit. | Confirm SWO is authorized for ODC. |
Mod SWO to authorize if necessary.
| 38 | ODC not authorized | Confirm 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
| 44 | Project and/or Task are not chargeable | Contact the CTM for resolution |
| 45 | Project Number not found | Confirm 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.
| 47 | Requires ODC Cost Description for charge | Confirm that cost description is present for ODC invoice line. |
| 48 | Requires Travel Cost Description for charge | Confirm 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.
| 51 | Service Code Required | Contact the CTM for resolution | |
| 52 | ST hours Exceed Schedule, possible Duplicate Invoice or Work Schedule required | Confirm 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, period | No action from SCM; but, available to answer and/or clarify anything if supplier needs more information on Subcontract/SWO | ||
| 58 | Transaction Date not within Project Date Range | Confirm 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.
| 64 | Rate Type not authorized for Subcontract | Confirm 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.
| 66 | WE Date is not a Sunday | Correct invoice file and resubmit. | |
| 67 | WE Date not within SWO Start/End Date | Confirm 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.
| 69 | Rate Type unknown | Confirm that rate type is correct. |
| 70 | Possible Duplicate Charge | Confirm 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
| 73 | Retention not required | |
| 74 | Exceeds Max Withholding | Confirm that RET lines are in the current |
invoice file and previous billing do not exceed the retention cap.
| 75 | Invalid Amount and/or SWO Number | |
| 76 | Invalid SWO and/or PO Number | Confirm 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.
| 79 | Affiliate Type not defined in HR | Contact the SCM for resolution. | Confirm that affiliate type is defined in HR for the POP. |
| 80 | Non labor Hour/Qty and Amount fields must equal | Confirm 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.
| 83 | Date cannot be in the future | Correct invoice file and resubmit. |
| 84 | No Type Code | Correct invoice file and resubmit. |
| 85 | Rejected Based on Associated Fee Line | Correct other invoice lines and resubmit. |
| 86 | Double-time not allowed without ST and OT charges | Confirm 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.
| 87 | Invalid Invoice Number | Correct invoice file and resubmit. |
| 88 | SWO Mod No required for travel charge | Correct invoice file and resubmit. |
| 89 | Material, ODC and subcontractor charges cannot be submitted on the same invoice | Confirm 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.
| 92 | Invalid Work Schedule | Contact the CTM for resolution | ||
| 93 | Negative invoice amount exceeds amounts previously invoiced on matched PO lines | Confirm previous billing plus current billing. | ||
| 95 | Retention not required | Review invoice for retention line | ||
| 97 | Retention amount invalid | Review invoice and confirm retention amount | ||
| 103 | Project and Task must be blank for Retention invoice lines | Review invoice | ||
| 104 | Final Retention invoice exceeds amount withheld | Contact Supplier Payment for resolution. | ||
| 105 | Final invoice must have 'final' in invoice number | Review invoice | ||
| 999 | Internal Exception | Contact the JPL Helpdesk | ||
| 112 | Project/Task not authorized for SWO | Contact SCM for resolution. | If a new P/T needs to be added, the CTM must authorize this change via a supplemental PR | |
| 114 | Week Ending Date not within SWO Start/End Date | Contact SCM for resolution. | ||
| 115 | Job classification is not authorized on SWO | Contact SCM for resolution. | ||
| 116 | Second Tier not authorized | Contact SCM for resolution. | ||
| 117 | Travel not authorized | Contact SCM for resolution. | ||
| 118 | Exceeds hours authorized for job classification | Contact SCM for resolution. | ||
| 121 | Billed costs exceed SWO Ceiling | Confirm 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 | |
| 122 | Not eligible for overtime for affiliate | Contact SCM for resolution. | ||
| 124 | Week Ending Date not within job classification Start/End Date | Contact SCM for resolution. | ||
| 125 | Retention amount is invalid | Contact Supplier Payment for resolution. | ||
| 127 | Retention exceeds max retention amount and/or Retention bill back is not allowed | Contact Supplier Payment for resolution. | ||
| 128 | ST hours exceeds maximum allowable hours for week ending date | Confirm previous billing plus current billing. | ||
| 129 | Required fields missing information | Contact the JPL Helpdesk | ||
| 130 | No ST and OT charges for affiliate | Confirm previous billing plus current billing. | ||
| 131 | Double Time is not authorized for job classification | Contact SCM for resolution. | ||
| 133 | Affiliate Expenditure Category Type (labor category) not matched in HR | Contact SCM for resolution. | ||
| 134 | Retention Required | Confirm 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. | |
| 135 | Retention 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 .