GWAC/MAC File Upload Instructions

For a successful and timely submission of sales data by uploading Excel file, please follow these instructions.

1. Once you download and save the template to your local drive, enter your contract number(s) in column A for each line item.
   Note: If a contract has multiple orders and line items the contract number must be entered for all lines.
2. Enter your sales data in Columns B through Q provided. Columns that are marked with Asterisk are required fields. See Definitions of Data Fields below for explanation of each column.
3. Once sales data (all orders and line items for all your Contracts) is entered into the spreadsheet, save the file to your local drive.
4. To report data by file upload, please see the Report Data by File Upload section for step-by-step instructions, including how to select the reporting period, upload your file, and certify your submission.

 

Definitions of Data Fields

1. Contract Number
   • Field Description: Enter GSA Formal Contract Number. No dashes required. This is the GSA MAS/GWAC contract number that was assigned by GSA. (Example: 47QTCB22D0221)
   • Data Entry Considerations: None

 

 

2. Invoice Number
   • Field Description: Enter the invoice number from the customer agency's paid invoice.
   • Data Entry Considerations: If using copy and paste functionality, depending on the version of Excel you are using, you must paste 'Values', 'Formulas', or the 'Match Destination Formatting' option within the GWAC-MAC Data tab. For example: copy your data from a source using your mouse or the Ctrl+C keyboard shortcut, then use the Ctrl+Shift+V keyboard shortcut to paste your data with values only. This is to prevent the copying of different cell formats between your source document and the GWAC-MAC Data tab. If you need more assistance with formatting issues, please contact the Vendor Support Center.

 

3. Paid Date
   • Field Description: Enter the date the invoice was paid by the customer agency.
   • Data Entry Considerations: If using copy and paste functionality, depending on the version of Excel you are using, you must paste 'Values', 'Formulas', or the 'Match Destination Formatting' option within the GWAC-MAC Data tab. For example: copy your data from a source using your mouse or the Ctrl+C keyboard shortcut, then use the Ctrl+Shift+V keyboard shortcut to paste your data with values only. This is to prevent the copying of different cell formats between your source document and the GWAC-MAC Data tab. If you need more assistance with formatting issues, please contact the Vendor Support Center.

 

4. Task Order Number
   • Field Description: Enter the task order award document number without hyphens. It should be the Order Number assigned on the Award Document as reported to FPDS-NG. Ex.GSA Form 300, Block 2 or SF1449, Block 4. Do not use the Solicitation Number unless it is the same as the award Order Number.
   • Data Entry Considerations: None

 

5. Line ID
   • Field Description: Enter a unique line item identification number. Entry may be alpha-numeric. Enter without Hyphens.
   • Data Entry Considerations: If using copy and paste functionality, depending on the version of Excel you are using, you must paste 'Values', 'Formulas', or the 'Match Destination Formatting' option within the GWAC-MAC Data tab. For example: copy your data from a source using your mouse or the Ctrl+C keyboard shortcut, then use the Ctrl+Shift+V keyboard shortcut to paste your data with values only. This is to prevent the copying of different cell formats between your source document and the GWAC-MAC Data tab. If you need more assistance with formatting issues, please contact the Vendor Support Center.

 

6. SIN/CLIN
   • Field Description: 
     1. Enter the appropriate CLIN type number only. (example: Non MAS Labor CLINs, enter 111 for Junior Computer and Information Research Scientist (Polaris), 11-2021 for Marketing Managers (OASIS+), or one of the non-labor CLINs like H00 - Fixed Price (Both).)
     2. All orders, except for task orders with Zero Sales, must have a CAF Fee CLIN entered with the other CLIN line items. (Either: D00 - Contract Access Fee (CAF) or E00 - Contract Access Fee (CAF); SPECIAL RATE)
     3. For task orders with no sales in a reporting period, enter: F00 - Zero Invoice.
   • Data Entry Considerations: Only use the D00 CLIN when reporting CAF for OASIS+.
     If using copy and paste functionality, depending on the version of Excel you are using, you must paste 'Values', 'Formulas', or the 'Match Destination Formatting' option within the GWAC-MAC Data tab. For example: copy your data from a source using your mouse or the Ctrl+C keyboard shortcut, then use the Ctrl+Shift+V keyboard shortcut to paste your data with values only. This is to prevent the copying of different cell formats between your source document and the GWAC-MAC Data tab. If you need more assistance with formatting issues, please contact the Vendor Support Center.

 

7. Knowledge/Skill Level
   • Field Description: Enter the experience level of the labor category selected in the SIN/CLIN field. (Junior, Journeyman, Senior, or SME)
   • Data Entry Considerations: Report this field only for OASIS+

 

8. Description of Deliverable
   • Field Description: Enter a short description of the line item.
     Note: Do not enter employee names into this field.
   • Data Entry Considerations: None

 

9. Unit of Measure
   • Field Description: Enter the line item unit of measure. The unit which is suggested based on your task order's Predominant Contract Type and CLIN Type. You can change this unit as desired; however, you're encouraged to utilize the pre-selected unit. Please reach out to your GSA Program Office with any questions. (Unit, Hour, Each)
   • Data Entry Considerations: None

 

10. Quantity of Items Sold
    • Field Description: Enter the line item quantity. Entry must be a number.
    • Data Entry Considerations: None

 

11. Unit Price (US$)
    • Field Description: Enter the line item invoiced price. Entry must be a dollar value.
    • Data Entry Considerations: None

 

12. Total Price (US$)
    • Field Description: Value is calculated based on unit price and quantity. Edits in this field will cause the price to be re-calculated.
    • Data Entry Considerations: None

 

13. Line Item Location
    • Field Description: Select where the work was performed. (Government, Contractor Site, Remote Site, or None)
    • Data Entry Considerations: None

 

14. Purchase Line Fee Category
    • Field Description: Enter the Purchase Line Fee Category displayed here is based on your contract vehicle, the task order's Predominant Contract Type, and the CLIN Type you've selected. This is informational and will not impact your Invoice line item reporting. (example: Labor, Fee, Other).
    • Data Entry Considerations: None

 

15. Security Clearance Level
    • Field Description: Enter the security clearance that is applicable to the work being performed. (Confidential, Secret, Top Secret, TS/SCI, Q (Department of Energy), None)
    • Data Entry Considerations: None

 

16. Applicable Labor Law
    • Field Description: Enter the labor law that is applicable to the work being performed on this task order.
      Note: This is a conditional field that applies to ancillary services. (SCA, DBA, Exempt or None)
    • Data Entry Considerations: None

 

17. Final Invoice Check
    • Field Description: Indicate if the reported invoice line items are part of the final invoice for the task order. (Yes or No)
    • Data Entry Considerations: None

What NOT to Do

1. Do NOT add tabs to this Template.
2. Do NOT change the formatting on this template including the column names on the GWAC-MAC Data tab.
3. Do NOT add formulas or macros to this template.
4. Do NOT change the column order.
5. Do NOT leave any mandatory columns blank. (Mandatory columns are marked by an asterisk (*) or as noted required in the Definitions of Data Fields Table above.)

Additional Help

1. If you need further assistance with respect to the business processes and procedures, please contact your Contracting Officer at GSA.
2. You can also contact the Vendor Support Center staff between Monday - Friday, 8:30 a.m. - 5:30 p.m. Eastern Time, at (877) 495-4849, or via email at vendor.support@gsa.gov. 

Table 1: CLINS (SIN/CLIN Field)

Table 2: Applicable Labor Law Definitions

Table 3: Labor Category Codes and Definitions