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:
- Do not add tabs to the template.
- Do not change the formatting, including the column names on the data tabs.
- Do not add formulas or macros.
- Do not change the column order.
- 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.
| # | Column | Mandatory |
|---|---|---|
| 1 | Contract/BPA Number* |
yes |
| 2 | Order Number/PIID* |
yes |
| 3 | Description of Deliverable* |
yes |
| 4 | Manufacturer Name |
no |
| 5 | Manufacturer Part Number |
no |
| 6 | Unit Measure* |
yes |
| 7 | Quantity of Item Sold* |
yes |
| 8 | Universal Product Code |
no |
| 9 | SIN Number* |
yes |
| 10 | Price Paid per Unit (US$)* |
yes |
| 11 | Total Price (US$)* |
yes |
| 12 | Non-Federal Entity* |
yes |
| 13 | Federal Customer |
required by Refresh 31, unstarred in v4.2 |
| 14 | Order Date* |
yes |
| 15 | Ship Date |
required by Refresh 31, unstarred in v4.2 |
| 16 | Zip Code Shipped To |
required by Refresh 31, unstarred in v4.2 |
| 17 | UCID |
required by Refresh 31, unstarred in v4.2 |
| 18 | Cloud Service Type |
required by Refresh 31, unstarred in v4.2 |
GWAC-MAC Data tab — 17 columns
| # | Column | Mandatory |
|---|---|---|
| 1 | Contract Number * |
yes |
| 2 | Invoice Number * |
yes |
| 3 | Paid Date * |
yes |
| 4 | Task Order * |
yes |
| 5 | Line ID* |
yes |
| 6 | SIN/CLIN * |
yes |
| 7 | Knowledge/Skill Level |
no |
| 8 | Description of Deliverable* |
yes |
| 9 | Unit Measure* |
yes |
| 10 | Quantity of Items Sold* |
yes |
| 11 | Unit Price (US$)* |
yes |
| 12 | Total Price (US$)* |
yes |
| 13 | Line Item Location* |
yes |
| 14 | Purchase Line Fee Category* |
yes |
| 15 | Security Clearance Level* |
yes |
| 16 | Applicable Labor Law |
no |
| 17 | Final 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 validatorFree solves this file. $79/month reuses the saved setup for recurring report files and keeps the record together.