Skip to content

What columns does the TDR file template have?

18 columns in a fixed order, one line per sale. What a line needs depends on the sale; VD/PPD lines leave Description and Non-Federal Entity blank.

Columns18, in a fixed order

One line of a sample month

SampleSample line from our demo holder’s month, as the product writes it.

47QSHA22D0031_2026-07_TDR.csv

Contract/BPA NumberOrder Number/PIIDDescription of DeliverableManufacturer NameManufacturer Part NumberUnit MeasureQuantity of Item SoldUniversal Product CodeSIN NumberPrice Paid per Unit (US$)Total Price (US$)Non-Federal EntityFederal CustomerOrder DateShip DateZip Code Shipped ToUCIDCloud Service Type

47QSHA22D0031PO-2026-1041Task desk, 60 x 30, laminate topHarlan Office Interiors (Demo)DSK-6030EA601234567890533721418.752512.50N/A4707/06/202607/13/202630303  

Download the sample month (CSV)

All 18 columns

1ColumnContract/BPA NumberWhen to fill itEvery lineFormatTextExample47QSHA22D0031Checks5
2ColumnOrder Number/PIIDWhen to fill itEvery lineFormatTextExamplePO-2026-1041Checks3
3ColumnDescription of DeliverableWhen to fill itEvery line except VD/PPD linesFormatTextExampleTask desk, 60 x 30, laminate topChecks3
4ColumnManufacturer NameWhen to fill itProducts; blank for servicesFormatTextExampleHarlan Office Interiors (Demo)Checks1
5ColumnManufacturer Part NumberWhen to fill itProducts; blank for servicesFormatTextExampleDSK-6030Checks2
6ColumnUnit MeasureWhen to fill itEvery lineFormatCode from SRP’s unit listExampleEAChecks3
7ColumnQuantity of Item SoldWhen to fill itEvery lineFormatNumberExample6Checks4
8ColumnUniversal Product CodeWhen to fill itProducts with a UPC; else blankFormatDigits, or blankExample012345678905Checks2
9ColumnSIN NumberWhen to fill itEvery lineFormatAwarded SINExample33721Checks3
10ColumnPrice Paid per Unit (US$)When to fill itEvery lineFormatDollars, no $ or commasExample418.75Checks4
11ColumnTotal Price (US$)When to fill itEvery lineFormatDollars, no $ or commasExample2512.50Checks5
12ColumnNon-Federal EntityWhen to fill itSCP, SDP or OTH; N/A for a federal buyer; blank on VD/PPDFormatSCP · SDP · OTH · N/AExampleN/AChecks2
13ColumnFederal CustomerWhen to fill itFunding agency’s two-digit code; NA for SCP/SDP/OTHFormatTwo-digit Treasury agency codeExample47Checks3
14ColumnOrder DateWhen to fill itProducts with an awarded part numberFormatMM/DD/YYYYExample07/06/2026Checks2
15ColumnShip DateWhen to fill itProducts with an awarded part numberFormatMM/DD/YYYYExample07/13/2026Checks2
16ColumnZip Code Shipped ToWhen to fill itProducts with an awarded part numberFormatFive-digit ZIPExample30303Checks1
17ColumnUCIDWhen to fill itOfferings with a UCID in your catalogFormatTextExample(blank)Checks1
18ColumnCloud Service TypeWhen to fill itSIN 518210C onlyFormatLCAT · IaaS · PaaS · SaaSExample(blank)Checks3

GSA’s rules for filling it in

Do

  • Download a fresh template from SRP each time.
  • Multiply unit price by quantity for Total Price.
  • Match manufacturer names and part numbers to your catalog.
  • Use the agency’s PIID, not your contract number.

Don’t

  • Type “N/A” in the UPC column; leave it blank.
  • Report a column SRP does not show; GSA says it isn’t required.
  • Use “EA” for hourly labor; GSA says “HR”.

Frequently asked questions

Which columns can be blank?

It depends on the line: product fields on a service line, a UPC when there is none, Cloud Service Type outside SIN 518210C, and most fields on a VD/PPD line.

Is the Excel template the same as the CSV file?

Two routes to one upload page. SRP takes its Excel template or a delimited file built to the specification published on the SRP site.

What goes in Order Number for an order with no PIID?

GSA says the PIID is usually in block 4 of the SF1449; USAspending can find it; your invoice number is the last resort.

Which SIN do I use when an order spans several?

GSA says to use the SIN with most of the work or value, and to ask the ordering contracting officer if unsure.

Sources, as published on November 1, 2026

Read next

Run one month of your sales through it.