Attachment I - FRAL Invoice Tracker.xlsx

XLSX spreadsheet 521 KB Posted Oct 20, 2026

Attached to: Fort Rucker, AL Full Food Service
Solicitation number: W5168W27RA014
Issued by: Department of the Army

About this file

Written by GovTribe AI · Oct 20, 2026

This is an invoice tracking template and instruction document for the PICO ASC Food Service contract. The workbook is designed for contractors to submit invoices across three billing categories: Firm Fixed Price (FFP) Billing for transition-in and Program Management Office costs, Labor Billing for hourly labor charges organized by labor category and CLIN/SLIN structure, and Materials ODC Billing for consumable purchases and other direct costs. Contractors must complete a Pre-Populated Data Table before populating billing tabs, ensuring all CLIN, SLIN, Period of Performance, Location, and Invoice Type values align with established contract data. The template requires completion of all columns with dark blue headers as mandatory fields, while columns with gold/dark green headers are optional. All invoices must be submitted to the Army Sustainment Command Contract Cost Management Division Food Service Mailbox at usarmy.ria.asc.mbx.aim-ccmd-food-service@army.mil.

The workbook maintains separate tracking for current-period and cumulative billing amounts across all cost elements. Key mandatory fields vary by billing type but include contract number, invoice submission date, performer basis, cost element classification, and billed amounts. The Labor Billing tab requires current hours billed, fixed fully burdened labor rates, and cumulative hours and labor dollars, while the Materials ODC Billing tab requires quantity, unit price, current direct costs, and optional material handling and general/administrative add-on charges. The template includes a Ceiling Tracking tab to monitor not-to-exceed amounts and remaining ceiling balances, an Invoice Summary tab for consolidated reporting, and a Cost Element Summary tab for reference. The workbook must remain in its original .xlsx structure without modification to protected elements, tab names, column arrangements, or formulas unless expressly authorized.

View the file

Other files

File	Type	Posted
Attachment R - Past Performance Questionnaire.docx	DOCX document	Oct 20, 2026
Attachment H - FRAL Staffing Matrix Offeror Input Template 7 Oct 26.xlsx	XLSX spreadsheet	Oct 20, 2026
Solicitation Amendment - W5168W27RA0140001.pdf	PDF	Oct 20, 2026
Attachment C - FRAL AFMIS Headcount.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment D3 - FRAL Durable Property.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment O - FRAL Government Estimated Staffing Matrix 7 Oct 26.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment L - FRAL Collective Bargaining Agreement_Language Modification.docx	DOCX document	Oct 20, 2026
Attachment D2 - FRAL Real Property.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment_L___FRAL_Collective_Bargaining_Agreement.pdf	PDF	Oct 20, 2026
Attachment F2 - FRAL Building Plans.pdf	PDF	Oct 20, 2026
Attachment F1 - FRAL Dining Facility Location Map.pdf	PDF	Oct 20, 2026
Attachment A - FRAL FFS PWS 20 Oct 26.pdf	PDF	Oct 20, 2026
Attachment F3 - FRAL Pictures of Facilities.pdf	PDF	Oct 20, 2026
Attachment K - FRAL Contractor Accident Reporting Format.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment Q - Past Performance Consent Letter.docx	DOCX document	Oct 20, 2026
Attachment E - FRAL Sample Materials List.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment B - FRAL Workload Data Capabilities.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment P - Past Performance Reference Sheet.docx	DOCX document	Oct 20, 2026
Attachment D1 - FRAL GFP Listing.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment D4 - FRAL Incidental Property.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment G - FRAL Pricing Matrix 19 Oct 2026.xlsx	XLSX spreadsheet	Oct 20, 2026
Attachment M -FRAL Wage Determination 2015-4631.pdf	PDF	Oct 20, 2026

Show all 22

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions PICO ASC Food Service Invoice Tracker

General Workbook Rules

1. Complete the workbook in the format provided. Do not rename tabs, move columns, hide/unhide columns, change headers, alter formulas, or modify protected/template structure unless expressly instructed.

2. Complete every visible column with dark blue headers for each applicable invoicing row on the Firm Fixed Price, Labor, and Materials ODC Billing tabs.

3. Columns with gold/dark green headers are optional for contractors to utilize.

4. Values input on green tabs for CLIN, SLIN, POP, Location, and Invoice Type must match established values in the Pre-Populated Data Table.

5. Contractors shall input Transition-In and Program Management Office (PMO) invoiced costs on the Firm Fixed Price (FFP) Billing tab.

6. All other labor shall be input on the Labor Billing tab utilizing the CLIN/SLIN structure in the Pre-Populated Data Table.

7. All ODC/Consumable purchases shall be input on the Materials ODC Billing tab.

8. Use one row per SLIN, Labor Category, Labor Rate, Performer, and Billing Period.

9. Current amounts cover the invoice being submitted; Cumulative amounts run through the entire ordering period.

10. Workbook must remain in its original .xlsx structure.

Pre-Populated Data Table

-Contractors must complete the Pre-Populated Data Table prior to completing the FFP Billing, Labor Billing, or Materials ODC Billing tabs . The CLIN, SLIN, POP, Location, and Invoice Type values

used in the billing tabs must align to the values in the Pre-Populated Data Table.

Complete only the designated tabs
Tab(s)	Color	Contractor action
All red tabs	Red	Reference only. Do not edit.
Pre-Populated Data Table	Green	Populate awarded CLIN/SLIN Structure and Location data prior to populating Billing tabs.
FFP Billing; Labor Billing; Materials ODC Billing	Green	Complete all dark blue header columns on each applicable billing row.
CLIN Summary; Cost Element Summary	Orange	Summary tabs for reference. CLIN Descriptions must be populated on the CLIN Summary tab in order for amounts to automatically populate.
Invoice Submission
-Contractors must submit a copy of all invoices to the ASC Contract Cost Management Division Food Service Mailbox at usarmy.ria.asc.mbx.aim-ccmd-food-service@army.mil

Field Dictionary

Sheet	Order	Field Label	Field Key	Mandatory	Type	Description	Instruction
Firm Fixed Price (FFP) Billing	1	Invoice / Voucher Number	invoice_voucher_number	Yes	text	Invoice number, voucher number, or contractor billing identifier.	Populate the invoice or voucher number identifier in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	2	Invoice Submission Date	invoice_submission_date	Yes	date	Date the invoice or voucher is submitted.	Populate the date the invoice or voucher is submitted in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	3	Contract Number	contract_number	Yes	text	Awarded contract number associated with the invoice.	Populate the awarded contract number, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	4	Task Order Number	task_order_number	No	text	Task or delivery order number when applicable.	Populate the task or delivery order number, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	5	Cost Element	cost_element	No	list	Identifies whether the billed line is material, ODC, travel, incidental service, or similar reimbursable cost.	Populate the cost element associated with the line item identifying whether the billed line is labor, material, ODC, travel, etc.in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	6	Resource / Item Description	resource_item_description	No	text	Description of the billed reimbursable line item.	Populate the resource or item description of the billed line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	7	CLIN Type	clin_type	No	list	Billed contract type (i.e., FFP, T&M, LH, etc.) associated with the CLIN and line item.	Populate the CLIN Type associated with the billed line item on the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	8	CLIN	clin	Yes	text	Contract line item number associated with the billed effort.	Populate the CLIN associated with the billed line item on the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	9	CLIN Description	clin_description	No	text	Description associated with the CLIN.	Populate the description associated with the CLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	10	SLIN	slin	No	text	Subline item number when applicable.	Populate the SLIN associated with the billed line item, as applicable, on the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	11	SLIN Description	slin_description	No	text	Description associated with the SLIN when applicable.	Populate the description associated with the SLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	12	PWS/WBS	pws_wbs	No	text	Combined task, requirement, or work-breakdown reference used to match billed effort to proposal baseline.	Populate the PWS/WBS reference used to match the billed effort to the proposal baseline, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	13	PWS/WBS Description	pws_wbs_description	No	text	Description associated with the combined PWS/WBS reference.	Populate the description associated with the PWS/WBS reference, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	14	POP	pop_label	Yes	text	Contract period of performance segment, such as Base, Option, OY1, or other period label applicable to the billed line.	Populate the contract POP label that aligns with the billing period for each row of data in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	15	Contract POP Start Date	contract_pop_start	No	date	Start date of the contract period of performance applicable to the billed line.	Populate the start date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	16	Contract POP End Date	contract_pop_end	No	date	End date of the contract period of performance applicable to the billed line.	Populate the end date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	17	Billing Period Start Date	billing_period_start	Yes	date	Start date of the invoice billing period.	Populate the start date of the invoice billing period in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	18	Billing Period End Date	billing_period_end	Yes	date	End date of the invoice billing period.	Populate the end date of the invoice billing period in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	19	Current Quantity	current_quantity	No	number	Current-period quantity billed when stated.	Populate the current billing period quantity associated with the line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	20	Quantity UOM	quantity_uom	No	text	Unit of measure associated with the quantity.	Populate the unit of measure associated with the current quantity, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	21	Billed Unit Price	billed_unit_price	No	currency	Billed unit price when separately stated.	Populate the billed unit price for the line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	22	Current Direct Cost	current_direct_cost	Yes	currency	Current-period direct reimbursable cost billed.	Populate the current billing period direct cost billed for the line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	23	Current Total Billed	current_total_billed	Yes	currency	Current-period total billed amount for the line.	Populate the current billing period total billed amount for the line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	24	Cumulative Total Billed	cumulative_total_billed	No	currency	Cumulative total billed amount through the invoice when available.	Populate the cumulative total billed amount through the billing period end date of the invoice for the line item, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	25	Location	location	No	text	Location associated with the billed line when relevant to staffing or reporting.	Populate the location associated with the billed line item, as applicable to staffing or reporting, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	26	Performer Basis	performer_basis	Yes	list	Prime, subcontractor, affiliate, or blended performer basis associated with the billed line.	Populate to identify the performer basis whether it is applicable to the prime, subcontractor, affiliate, or blended for the billed line item in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	27	Performing Entity	performing_entity	No	text	Business unit, subcontractor, affiliate, or blended grouping associated with the billed line.	Populate the business name, subcontractor name, affiliate, or blended grouping, as applicable, associated with the line of this worksheet.
Firm Fixed Price (FFP) Billing	28	Proposal Reference ID	proposal_reference_id	No	text	Reference to the corresponding proposal line or normalized proposal key.	Populate the reference to the corresponding proposal line or normalized proposal key, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	29	Invoice Support Reference	invoice_support_reference	No	text	Reference to attached invoice support, labor report, or other supporting file.	Populate the reference to an attached invoice support, labor report, or other supporting file, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	30	Comments	comments	No	text	Optional invoice or review notes.	Populate any comments or notes related to the invoice or review, as applicable, in the appropriate cell of this worksheet.
Firm Fixed Price (FFP) Billing	31	Unique Line ID	unique_line_id	No	text	Stable unique line identifier for PICO ingestion and downstream traceability.	Populate the unique line identifier that aligns with the proposal or any additional downstream document ensuring consistency and traceability, as applicable, in the appropriate cell of this worksheet.
Labor Billing	1	Invoice / Voucher Number	invoice_voucher_number	Yes	text	Invoice number, voucher number, or contractor billing identifier.	Populate the invoice or voucher number identifier in the appropriate cell of this worksheet.
Labor Billing	2	Invoice Submission Date	invoice_submission_date	Yes	date	Date the invoice or voucher is submitted.	Populate the date the invoice or voucher is submitted in the appropriate cell of this worksheet.
Labor Billing	3	Contract Number	contract_number	Yes	text	Awarded contract number associated with the invoice.	Populate the awarded contract number, as applicable, in the appropriate cell of this worksheet.
Labor Billing	4	Task Order Number	task_order_number	No	text	Task or delivery order number when applicable.	Populate the task or delivery order number, as applicable, in the appropriate cell of this worksheet.
Labor Billing	5	Cost Element	cost_element	Yes	list	Identifies whether the billed line is labor, material, ODC, travel, incidental service, etc.	Populate the cost element associated with the line item identifying whether the billed line is labor, material, ODC, travel, etc.in the appropriate cell of this worksheet.
Labor Billing	6	Labor Category ID	labor_category_id	No	text	Stable labor category identifier that should remain consistent between proposal and invoice support.	Populate the labor category identifier and ensure consistency with the LCAT ID from the proposal, as applicable, in the appropriate cell of this worksheet.
Labor Billing	7	Labor Category	labor_category_submitted	Yes	text	Billed labor category title as submitted.	Populate the billed labor category title as submitted in the appropriate cell of this worksheet.
Labor Billing	8	CLIN Type	clin_type	No	list	Billed contract type (i.e., FFP, T&M, LH, etc.) associated with the CLIN and line item.	Populate the CLIN Type associated with the billed line item on the appropriate cell of this worksheet.
Labor Billing	9	CLIN	clin	Yes	list	Contract line item number associated with the billed effort.	Populate the CLIN associated with the billed line item on the appropriate cell of this worksheet.
Labor Billing	10	CLIN Description	clin_description	No	list	Description associated with the CLIN.	Populate the description associated with the CLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Labor Billing	11	SLIN	slin	No	list	Subline item number when applicable.	Populate the SLIN associated with the billed line item, as applicable, on the appropriate cell of this worksheet.
Labor Billing	12	SLIN Description	slin_description	No	list	Description associated with the SLIN when applicable.	Populate the description associated with the SLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Labor Billing	13	PWS/WBS	pws_wbs	No	text	Combined task, requirement, or work-breakdown reference used to match billed effort to proposal baseline.	Populate the PWS/WBS reference used to match the billed effort to the proposal baseline, as applicable, in the appropriate cell of this worksheet.
Labor Billing	14	PWS/WBS Description	pws_wbs_description	No	text	Description associated with the combined PWS/WBS reference.	Populate the description associated with the PWS/WBS reference, as applicable, in the appropriate cell of this worksheet.
Labor Billing	15	POP	pop_label	Yes	list	Contract period of performance segment, such as Base, Option, OY1, or other period label applicable to the billed line.	Populate the contract POP label that aligns with the billing period for each row of data in the appropriate cell of this worksheet.
Labor Billing	16	Contract POP Start Date	contract_pop_start	No	date	Start date of the contract period of performance applicable to the billed line.	Populate the start date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Labor Billing	17	Contract POP End Date	contract_pop_end	No	date	End date of the contract period of performance applicable to the billed line.	Populate the end date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Labor Billing	18	Billing Period Start Date	billing_period_start	Yes	date	Start date of the invoice billing period.	Populate the start date of the invoice billing period in the appropriate cell of this worksheet.
Labor Billing	19	Billing Period End Date	billing_period_end	Yes	date	End date of the invoice billing period.	Populate the end date of the invoice billing period in the appropriate cell of this worksheet.
Labor Billing	20	Current Hours Billed	current_hours_billed	Yes	number	Current-period hours billed for the labor category.	Populate the current-period labor hours billed for the applicable labor category on the line item in the appropriate cell of this worksheet.
Labor Billing	21	Fixed Fully Burdened Labor Rate	fixed_fully_burdened_labor_rate	Yes	currency	Fixed fully burdened labor rate or contract hourly rate billed for the labor category.	Populate the fixed fully burdened labor rate billed for the applicable labor category on the line item in the appropriate cell of this worksheet.
Labor Billing	22	Current Labor Billed	current_labor_billed	Yes	currency	Current-period labor billed for the line.	Populate the current-period labor dollars billed at the hourly rates and hours billed for the applicable labor category on the line item in the appropriate cell of this worksheet.
Labor Billing	23	Cumulative Hours Billed	cumulative_hours_billed	No	number	Cumulative labor hours billed through the invoice when available.	Populate the cumulative labor hours billed through the invoice for the labor category, as applicable, in the appropriate cell of this worksheet.
Labor Billing	24	Cumulative Labor Billed	cumulative_labor_billed	No	currency	Cumulative labor billed through the invoice when available.	Populate the cumulative labor dollars billed through the invoice for the labor category, as applicable, in the appropriate cell of this worksheet.
Labor Billing	25	Performer Basis	performer_basis	No	list	Prime, subcontractor, affiliate, or blended performer basis associated with the billed line.	Populate to identify the performer basis whether it is applicable to the prime, subcontractor, affiliate, or blended for the billed line item in the appropriate cell of this worksheet.
Labor Billing	26	Performing Entity	performing_entity	No	text	Business unit, subcontractor, affiliate, or blended grouping associated with the billed line.	Populate the business name, subcontractor name, affiliate, or blended grouping, as applicable, associated with the line of this worksheet.
Labor Billing	27	Location	location	No	list	Location associated with the billed line when relevant to staffing or reporting.	Populate the location associated with the billed line item, as applicable to staffing or reporting, in the appropriate cell of this worksheet.
Labor Billing	28	Proposal Reference ID	proposal_reference_id	No	text	Reference to the corresponding proposal line or normalized proposal key.	Populate the reference to the corresponding proposal line or normalized proposal key, as applicable, in the appropriate cell of this worksheet.
Labor Billing	29	Qualification Support Reference	qualification_support_reference	No	text	Reference to qualification substantiation or approved alternative support.	Populate the reference to the qualification substantiation or approved alternative support, as applicable, in the appropriate cell of this worksheet.
Labor Billing	30	Invoice Support Reference	invoice_support_reference	No	text	Reference to attached invoice support, labor report, or other supporting file.	Populate the reference to an attached invoice support, labor report, or other supporting file, as applicable, in the appropriate cell of this worksheet.
Labor Billing	31	Comments	comments	No	text	Optional invoice or review notes.	Populate any comments or notes related to the invoice or review, as applicable, in the appropriate cell of this worksheet.
Labor Billing	32	Unique Line ID	unique_line_id	No	text	Stable unique line identifier for PICO ingestion and downstream traceability.	Populate the unique line identifier that aligns with the proposal or any additional downstream document ensuring consistency and traceability, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	1	Invoice / Voucher Number	invoice_voucher_number	Yes	text	Invoice number, voucher number, or contractor billing identifier.	Populate the invoice or voucher number identifier in the appropriate cell of this worksheet.
Materials ODC Billing	2	Invoice Submission Date	invoice_submission_date	Yes	date	Date the invoice or voucher is submitted.	Populate the date the invoice or voucher is submitted in the appropriate cell of this worksheet.
Materials ODC Billing	3	Contract Number	contract_number	Yes	text	Awarded contract number associated with the invoice.	Populate the awarded contract number, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	4	Task Order Number	task_order_number	No	text	Task or delivery order number when applicable.	Populate the task or delivery order number, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	5	Cost Element	cost_element	Yes	list	Identifies whether the billed line is material, ODC, travel, incidental service, or similar reimbursable cost.	Populate the cost element associated with the line item identifying whether the billed line is material, ODC, travel, etc.in the appropriate cell of this worksheet.
Materials ODC Billing	6	Resource / Item Description	resource_item_description	Yes	text	Description of the billed reimbursable line item.	Populate the resource or item description of the billed line item in the appropriate cell of this worksheet.
Materials ODC Billing	7	CLIN Type	clin_type	No	list	Billed contract type (i.e., FFP, T&M, LH, etc.) associated with the CLIN and line item.	Populate the CLIN Type associated with the billed line item on the appropriate cell of this worksheet.
Materials ODC Billing	8	CLIN	clin	Yes	list	Contract line item number associated with the billed effort.	Populate the CLIN associated with the billed line item on the appropriate cell of this worksheet.
Materials ODC Billing	9	CLIN Description	clin_description	No	list	Description associated with the CLIN.	Populate the description associated with the CLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Materials ODC Billing	10	SLIN	slin	No	list	Subline item number when applicable.	Populate the SLIN associated with the billed line item, as applicable, on the appropriate cell of this worksheet.
Materials ODC Billing	11	SLIN Description	slin_description	No	list	Description associated with the SLIN when applicable.	Populate the description associated with the SLIN for the billed line item, as applicable, on the appropriate cell of this worksheet.
Materials ODC Billing	12	PWS/WBS	pws_wbs	No	text	Combined task, requirement, or work-breakdown reference used to match billed effort to proposal baseline.	Populate the PWS/WBS reference used to match the billed effort to the proposal baseline, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	13	PWS/WBS Description	pws_wbs_description	No	text	Description associated with the combined PWS/WBS reference.	Populate the description associated with the PWS/WBS reference, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	14	POP	pop_label	Yes	list	Contract period of performance segment, such as Base, Option, OY1, or other period label applicable to the billed line.	Populate the contract POP label that aligns with the billing period for each row of data in the appropriate cell of this worksheet.
Materials ODC Billing	15	Contract POP Start Date	contract_pop_start	No	date	Start date of the contract period of performance applicable to the billed line.	Populate the start date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	16	Contract POP End Date	contract_pop_end	No	date	End date of the contract period of performance applicable to the billed line.	Populate the end date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	17	Billing Period Start Date	billing_period_start	Yes	date	Start date of the invoice billing period.	Populate the start date of the invoice billing period in the appropriate cell of this worksheet.
Materials ODC Billing	18	Billing Period End Date	billing_period_end	Yes	date	End date of the invoice billing period.	Populate the end date of the invoice billing period in the appropriate cell of this worksheet.
Materials ODC Billing	19	Current Quantity	current_quantity	Yes	number	Current-period quantity billed when stated.	Populate the current billing period quantity associated with the non-labor line item in the appropriate cell of this worksheet.
Materials ODC Billing	20	Quantity UOM	quantity_uom	No	text	Unit of measure associated with the quantity.	Populate the unit of measure associated with the current quantity, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	21	Billed Unit Price	billed_unit_price	Yes	currency	Billed unit price when separately stated.	Populate the billed unit price for the non-labor line item in the appropriate cell of this worksheet.
Materials ODC Billing	22	Current Direct Cost	current_direct_cost	Yes	currency	Current-period direct reimbursable cost billed.	Populate the current billing period direct cost billed for the line item in the appropriate cell of this worksheet.
Materials ODC Billing	23	Material Handling Billed	material_handling_billed	No	currency	Current-period material handling or similar additive amount billed outside the labor hourly rates.	Populate the current billing period material handling or similar additive amount billed for the line item, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	24	General and Administrative Cost Billed	general_administrative_amount	No	currency	Current-period G&A or similar additive amount billed outside the labor hourly rates.	Populate the current billing period general and administrative amount or similar additive amount billed for the line item, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	25	Current Total Billed	current_total_billed	Yes	currency	Current-period total billed amount for the line.	Populate the current billing period total billed amount for the line item in the appropriate cell of this worksheet.
Materials ODC Billing	26	Cumulative Total Billed	cumulative_total_billed	No	currency	Cumulative total billed amount through the invoice when available.	Populate the cumulative total billed amount through the billing period end date of the invoice for the line item, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	27	Location	location	No	list	Location associated with the billed line when relevant to staffing or reporting.	Populate the location associated with the billed line item, as applicable to staffing or reporting, in the appropriate cell of this worksheet.
Materials ODC Billing	28	Item / Part Number	item_number	No	text	Part number, catalog number, or internal item code when applicable.	Populate the item/part number or other applicable item code, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	29	Performer Basis	performer_basis	No	list	Prime, subcontractor, affiliate, or blended performer basis associated with the billed line.	Populate to identify the performer basis whether it is applicable to the prime, subcontractor, affiliate, or blended for the billed line item in the appropriate cell of this worksheet.
Materials ODC Billing	30	Performing Entity	performing_entity	No	text	Business unit, subcontractor, affiliate, or blended grouping associated with the billed line.	Populate the business name, subcontractor name, affiliate, or blended grouping, as applicable, associated with the line of this worksheet.
Materials ODC Billing	31	Proposal Reference ID	proposal_reference_id	No	text	Reference to the corresponding proposal line or normalized proposal key.	Populate the reference to the corresponding proposal line or normalized proposal key, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	32	Invoice Support Reference	invoice_support_reference	No	text	Reference to attached invoice support, labor report, or other supporting file.	Populate the reference to an attached invoice support, labor report, or other supporting file, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	33	Comments	comments	No	text	Optional invoice or review notes.	Populate any comments or notes related to the invoice or review, as applicable, in the appropriate cell of this worksheet.
Materials ODC Billing	34	Unique Line ID	unique_line_id	No	text	Stable unique line identifier for PICO ingestion and downstream traceability.	Populate the unique line identifier that aligns with the proposal or any additional downstream document ensuring consistency and traceability, as applicable, in the appropriate cell of this worksheet.
Ceiling Tracking	1	Contract Number	contract_number	No	text	Awarded contract number associated with the ceiling line.	Populate the awarded contract number, as applicable, in the appropriate cell of this worksheet.
Ceiling Tracking	2	Task Order Number	task_order_number	No	text	Task or delivery order number when applicable.	Populate the task or delivery order number, as applicable, in the appropriate cell of this worksheet.
Ceiling Tracking	3	CLIN	clin	No	list	Associated CLIN number.	Populate the CLIN associated with the billed line item, as applicable, on the appropriate cell of this worksheet.
Ceiling Tracking	4	Ceiling Price	ceiling_price	No	currency	Ceiling price or not-to-exceed amount.	Populate the ceiling price or not to exceed amount attributable to the CLIN or line item, as applicable, on the appropriate cell of this worksheet.
Ceiling Tracking	5	Billed To Date	billed_to_date	No	currency	Cumulative billed amount associated with the same ceiling line.	Poulate the cumulative billed amount associated with the CLIN or line item, as applicable, on the appropriate cell of this worksheet.
Ceiling Tracking	6	Remaining Ceiling Balance	remaining_ceiling_balance	No	currency	Remaining ceiling balance after considering billed-to-date.	As applicable, populate the remaining ceiling balance for the line item, which is the difference between the ceiling price and billed to date amounts, in the appropriate cell of this worksheet.. This cell may be autocalculated.
Ceiling Tracking	7	Ceiling Reference	ceiling_reference	No	text	Reference to the contract, modification, or ceiling tracker source.	Populate the reference to the contract, modification, or ceiling tracker, as applicable, in the appropriate cell of this worksheet.
Ceiling Tracking	8	Comments	comments	No	text	Optional notes related to ceiling review or status.	Populate any comments or notes related to the ceiling review or status, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	1	Invoice / Voucher Number	invoice_voucher_number	No	text	Invoice or voucher identifier.	Populate the invoice or voucher number identifier, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	2	Invoice Type	invoice_type	No	list	Type of invoice or voucher being submitted.	Populate the type of invoice or voucher submitted, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	3	Invoice Submission Date	invoice_submission_date	No	date	Date the invoice or voucher is submitted.	Populate the date the invoice or voucher is submitted in the appropriate cell of this worksheet.
Invoice Summary	4	Prime Contractor	prime_contractor	No	text	Legal name of the prime contractor associated with the invoice.	Populate the legal name of the prime contractor associated with the invoice, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	5	Contract Number	contract_number	No	text	Awarded contract number associated with the invoice.	Populate the awarded contract number, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	6	Task Order Number	task_order_number	No	text	Task or delivery order number when applicable.	Populate the task or delivery order number, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	7	POP	pop_label	No	list	Contract period of performance segment, such as Base, Option, OY1, or other period label applicable to the billed line.	Populate the contract POP label that aligns with the billing period for each row of data in the appropriate cell of this worksheet.
Invoice Summary	8	Contract POP Start Date	contract_pop_start	No	date	Start date of the contract period of performance applicable to the billed line.	Populate the start date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	9	Contract POP End Date	contract_pop_end	No	date	End date of the contract period of performance applicable to the billed line.	Populate the end date of the contract POP applicable to the billed line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	10	Billing Period Start Date	billing_period_start	No	date	Start date of the invoice billing period.	Populate the start date of the invoice billing period in the appropriate cell of this worksheet.
Invoice Summary	11	Billing Period End Date	billing_period_end	No	date	End date of the invoice billing period.	Populate the end date of the invoice billing period in the appropriate cell of this worksheet.
Invoice Summary	12	Current Labor Billed	current_labor_billed	No	currency	Current-period labor billed at T&M hourly rates.	Populate the current billing period for the T&M labor billed for the line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	13	Current Materials Billed	current_materials_billed	No	currency	Current-period reimbursable materials and ODC billed.	Populate the current billing period for the non-labor billed amount associated with the line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	14	Current Total Billed	current_total_billed	No	currency	Current-period total billed amount.	Populate the current billing period total combined labor and non-labor billed amount associated with the line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	15	Cumulative Total Billed	cumulative_total_billed	No	currency	Cumulative total billed amount through the invoice.	Populate the cumulative total combined labor and non-labor billed amount through the end date of the invoice period associated with the line item, as applicable, in the appropriate cell of this worksheet.
Invoice Summary	16	Ceiling Price	ceiling_price	No	currency	Ceiling price or not-to-exceed value when tracked.	Populate the ceiling price or not to exceed amount attributable to the line item, as applicable, on the appropriate cell of this worksheet.
Invoice Summary	17	Remaining Ceiling Balance	remaining_ceiling_balance	No	currency	Remaining ceiling balance after considering cumulative billed amount.	Populate the remaining ceiling balance for the line item, which is the difference between the ceiling price and cumulative total billed amounts, as applicable, in the appropriate cell of this worksheet..
Invoice Summary	18	Summary Support Reference	summary_support_reference	No	text	Reference to invoice cover sheet, voucher summary, or equivalent support.	Populate the summary support reference (i.e., invoice cover sheet, voucher summary, etc.), as applicable, in the appropriate cell of this worksheet.

Mandatory Fields

Sheet	Mandatory Fields
Invoice Summary	Invoice / Voucher Number; Invoice Type; Invoice Submission Date; Prime Contractor; Contract Number; POP, Contract POP Start Date, Contract POP End Date, Billing Period Start Date; Billing Period End Date; Current Total Billed
Firm Fixed Price (FFP) Billing	Contract Number; Resource / Item Description; CLIN; Current Direct Cost; Current Total Billed; Cumulative Total Billed; Performer Basis
Labor Billing	CLIN; Performer Basis; Cost Element; Contract Number; Labor Category; Current Hours Billed; Fixed Fully Burdened Labor Rate; Current Labor Billed; Cumulative Hours Billed; Cumulative Labor Billed
Materials ODC Billing	CLIN; Performer Basis; Contract Number; Cost Element; Resource / Item Description; Current Direct Cost; Current Total Billed; Cumulative Total Billed

Firm Fixed Price (FFP) Billing

FFP Invoice fields and totals.

Mandatory

Optional

Mandatory

Optional

Mandatory

Optional

Mandatory

Optional

Mandatory

Optional

Mandatory

Optional

General

Date

Text

General

General (Drop Down)

General

General (Drop Down)

Text

General

Text

General

General (Drop Down)

Date

Number

General

Currency

General

General (Drop down)

General

Invoice / Voucher Number

Invoice Submission Date

Contract Number

Task Order Number

Cost Element

Resource / Item Description

CLIN Type

CLIN

CLIN Description

SLIN

SLIN Description

PWS/WBS

PWS/WBS Description

POP

Contract POP Start Date

Contract POP End Date

Billing Period Start Date

Billing Period End Date

Current Quantity

Quantity UOM

Billed Unit Price

Current Direct Cost

Current Total Billed

Cumulative Total Billed

Location

Performer Basis

Performing Entity

Proposal Reference ID

Invoice Support Reference

Comments

Unique Line ID

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

FFP

$0.00

Labor Billing

Labor Billing
Detailed labor billing support based on billed labor-category hours and contract hourly rates.
Mandatory	Mandatory	Mandatory	Optional	Mandatory	Optional	Mandatory	Optional	Mandatory	Optional	Optional	Optional	Optional	Optional	Mandatory	Optional	Optional	Mandatory	Mandatory	Mandatory	Mandatory	Mandatory	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional	Optional
General	Date	Text	General	General (Drop down)	General	General	General (Drop Down)	Text (Drop Down)	General (Drop Down)	Text (Drop Down)	General (Drop Down)	General	General	General (Drop Down)	Date	Date	Date	Date	Number	Currency	Currency	Number	Currency	General (Drop Down)	General	General (Drop Down)	General	General	General	General	General
Invoice / Voucher Number	Invoice Submission Date	Contract Number	Task Order Number	Cost Element	Labor Category ID	Labor Category	CLIN Type	CLIN	CLIN Description	SLIN	SLIN Description	PWS/WBS	PWS/WBS Description	POP	Contract POP Start Date	Contract POP End Date	Billing Period Start Date	Billing Period End Date	Current Hours Billed	Fixed Fully Burdened Labor Rate	Current Labor Billed	Cumulative Hours Billed	Cumulative Labor Billed	Performer Basis	Performing Entity	Location	Proposal Reference ID	Qualification Support Reference	Invoice Support Reference	Comments	Unique Line ID
																					$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00
							LH														$0.00

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Oct 20, 2026.