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
| # | 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 |
no |
| 14 | Order Date* |
yes |
| 15 | Ship Date |
no |
| 16 | Zip Code Shipped To |
no |
| 17 | UCID |
no |
| 18 | Cloud Service Type |
no |
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.
Check your own file. Upload your invoice export or a template you have filled in. You get every error and the finished official file, free and without an account.
Open the free validator Then $79/month if you want it to remember everything.