- Home
- The TDR file template’s columns
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.
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
All 18 columns
| # | Column | When to fill it | Format | Example | Checks |
|---|---|---|---|---|---|
| 1 | ColumnContract/BPA Number | When to fill itEvery line | FormatText | Example47QSHA22D0031 | Checks5 |
| 2 | ColumnOrder Number/PIID | When to fill itEvery line | FormatText | ExamplePO-2026-1041 | Checks3 |
| 3 | ColumnDescription of Deliverable | When to fill itEvery line except VD/PPD lines | FormatText | ExampleTask desk, 60 x 30, laminate top | Checks3 |
| 4 | ColumnManufacturer Name | When to fill itProducts; blank for services | FormatText | ExampleHarlan Office Interiors (Demo) | Checks1 |
| 5 | ColumnManufacturer Part Number | When to fill itProducts; blank for services | FormatText | ExampleDSK-6030 | Checks2 |
| 6 | ColumnUnit Measure | When to fill itEvery line | FormatCode from SRP’s unit list | ExampleEA | Checks3 |
| 7 | ColumnQuantity of Item Sold | When to fill itEvery line | FormatNumber | Example6 | Checks4 |
| 8 | ColumnUniversal Product Code | When to fill itProducts with a UPC; else blank | FormatDigits, or blank | Example012345678905 | Checks2 |
| 9 | ColumnSIN Number | When to fill itEvery line | FormatAwarded SIN | Example33721 | Checks3 |
| 10 | ColumnPrice Paid per Unit (US$) | When to fill itEvery line | FormatDollars, no $ or commas | Example418.75 | Checks4 |
| 11 | ColumnTotal Price (US$) | When to fill itEvery line | FormatDollars, no $ or commas | Example2512.50 | Checks5 |
| 12 | ColumnNon-Federal Entity | When to fill itSCP, SDP or OTH; N/A for a federal buyer; blank on VD/PPD | FormatSCP · SDP · OTH · N/A | ExampleN/A | Checks2 |
| 13 | ColumnFederal Customer | When to fill itFunding agency’s two-digit code; NA for SCP/SDP/OTH | FormatTwo-digit Treasury agency code | Example47 | Checks3 |
| 14 | ColumnOrder Date | When to fill itProducts with an awarded part number | FormatMM/DD/YYYY | Example07/06/2026 | Checks2 |
| 15 | ColumnShip Date | When to fill itProducts with an awarded part number | FormatMM/DD/YYYY | Example07/13/2026 | Checks2 |
| 16 | ColumnZip Code Shipped To | When to fill itProducts with an awarded part number | FormatFive-digit ZIP | Example30303 | Checks1 |
| 17 | ColumnUCID | When to fill itOfferings with a UCID in your catalog | FormatText | Example(blank) | Checks1 |
| 18 | ColumnCloud Service Type | When to fill itSIN 518210C only | FormatLCAT · IaaS · PaaS · SaaS | Example(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
- GSA — Help with Transactional Data Reporting
Due dates, when reporting begins, the grace and trial periods, the field list, and the rejection and “cannot find items” troubleshooting table.
- SRP user manual — report data by file upload
Months go in chronological order; a file with an unreported earlier month is rejected; the File Upload page shows the reason for a rejection.
- GSA — MAS TDR User Guide v2.0 (PDF)
Sections 2.2 and 2.3: the monthly deadline, the grace period, the trial-period fields and when a contracting officer can act.
- GSA — MAS Refresh 31 SF30 attachment (PDF)
Section 2.d: the Participate in TDR mod takes effect on the first day of the next sales reporting quarter after acceptance.
- SRP user manual — MAS tables
SRP’s unit-of-measure codes (a set is “ST”, not “SET”) and the Non-Federal Entity codes.
Read next
Run one month of your sales through it.
from $99 / month30-day money-back guarantee