TDR FILER

The SRP template v4.2, column by column

FAS SRP Excel Upload Reporting Template v4.2, last updated 2026-06-24. Two data tabs — one for MAS, one for GWAC/MAC — and an instructions tab. The columns below are read straight out of the file.

The five rules the template states

The instructions tab lists what not to do, and these are the ones that actually cause rejections:

  1. Do not add tabs to the template.
  2. Do not change the formatting, including the column names on the data tabs.
  3. Do not add formulas or macros.
  4. Do not change the column order.
  5. Do not leave any mandatory column blank.

Rule 3 is the one that traps people. You cannot build your own automation inside the template — no VLOOKUP pulling a SIN from another tab, no =B2*C2 for the line total. Whatever produces the numbers has to happen somewhere else, and what lands in the template has to be plain values. Rule 1 rules out the helper tab you would otherwise use.

Two details worth knowing: every data cell in the template is formatted as text, not as a number or a date; and the workbook ships with a hidden sheet of its own. Rebuilding the file from scratch rather than filling in the original tends to break both.

MAS Data tab — 18 columns

Five of the unstarred columns are a special case: Refresh 31 requires them, but the v4.2 template has not been restarred. GSA does not act on them until 31 December 2026 — what they are and where the values come from.

#ColumnMandatory
1Contract/BPA Number* yes
2Order Number/PIID* yes
3Description of Deliverable* yes
4Manufacturer Name no
5Manufacturer Part Number no
6Unit Measure* yes
7Quantity of Item Sold* yes
8Universal Product Code no
9SIN Number* yes
10Price Paid per Unit (US$)* yes
11Total Price (US$)* yes
12Non-Federal Entity* yes
13Federal Customer required by Refresh 31, unstarred in v4.2
14Order Date* yes
15Ship Date required by Refresh 31, unstarred in v4.2
16Zip Code Shipped To required by Refresh 31, unstarred in v4.2
17UCID required by Refresh 31, unstarred in v4.2
18Cloud Service Type required by Refresh 31, unstarred in v4.2

GWAC-MAC Data tab — 17 columns

#ColumnMandatory
1Contract Number * yes
2Invoice Number * yes
3Paid Date * yes
4Task Order * yes
5Line ID* yes
6SIN/CLIN * yes
7Knowledge/Skill Level no
8Description of Deliverable* yes
9Unit Measure* yes
10Quantity of Items Sold* yes
11Unit Price (US$)* yes
12Total Price (US$)* yes
13Line Item Location* yes
14Purchase Line Fee Category* yes
15Security Clearance Level* yes
16Applicable Labor Law no
17Final Invoice Check no

Note the spacing in the official headers is not consistent — some carry a space before the asterisk and some do not. They must be reproduced exactly as they are.

The version moves

The template has gone from v3.0 in October 2024 to v4.2 in 2026-06-24. Columns get added and the tail of each tab shifts. Anything built against last year's column positions quietly writes into the wrong columns rather than failing outright, which is the worst way for this to break.

The template exists to serve one requirement. What GSA Transactional Data Reporting asks of you explains why these columns and not others, and the SRP is where the finished file goes.

Check your own file. Upload an invoice, order or service export. You get every error and the finished official file, free and without an account.

Open the free validator

Free solves this file. $79/month reuses the saved setup for recurring report files and keeps the record together.