203x Filetype XLSX File size 0.48 MB Source: www.gsa.gov
FAS Sales Report Template Version:1.3.6 (Last Updated 11/01/2018) Instructions to Upload Sales Data to Federal Acquisition Service (FAS) Sales Reporting Portal (SRP) For a successful and timely submission of sales data by uploading Excel file please follow these step by step instructions: Step 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. Step 2: Enter your sales data in Columns B through L provided. Columns that are marked with Asterisk are required fields. See Definition of Data Fields below for explanation of each column. 2.a: Products (Contract Number, Order Number/PIID, Description of Deliverable, Manufacturer Name, Manufacturer Part Number, Unit of Measure, Quantity of Items Sold, SIN, Unit Price, Total Price, Non Federal Entity). 2.b: Services (Contract Number, Order Number, Description of Deliverable, Unit of Measure, Quantity of Item Sold, SIN, Unit Price, Total Price, Non-Federal Entity). Step 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. Step 4: Login to FAS SRP with a digital certificate and navigate to 'Report data by File Upload' option. Step 5: Once on the 'Report Data by File Upload' page, select the appropriate 'Reporting period' and then browse for the saved file in Step 3 and click on 'Submit'. Step 6: When you click on 'Submit' you will be prompted to certify that all data being submitted is 'True and Accurate'. If you agree, accept and click 'Submit'. If not, go back and make necessary changes to the Excel spreadsheet. Note: if your contract requires you to report additional data elements beyond those detailed in the "Definition of Data Fields" below, please check your contract for further guidance or contact your Contracting Officer. Additional Instructions to Reporting Returns Line Items 1. Enter relevant information for all required fields (Contract Number, SIN Number, Order Number, Description of Deliverable, Unit of Measure, Quantity of Items Sold, Unit Price, Total Price). 1.a: Products (Contract Number, Order Number/PIID, Description of Deliverable, Manufacturer Name, Manufacturer Part Number, Unit of Measure, Quantity of Items Sold, SIN, Unit Price, Total Price, Non Federal Entity). 1.b: Services (Contract Number, Order Number, Description of Deliverable, Unit of Measure, Quantity of Item Sold, SIN, Unit Price, Total Price, Non-Federal Entity). 2. Under Unit Measure specify RTN. 3. Under Quantity of Items Sold, specify the number of items returned. This should be a negative value. 4. Under Price Paid per Unit (US$), enter the unit price of the items returned. This should be a positive US$ amount. 5. Under Total Price (US$), enter the Total Price derived from Quantity of Items Sold * Price Paid per Unit (US$). This should be a negative value. Note: if your contract requires you to report additional data elements beyond those detailed in the "Definition of Data Fields" below, please check your contract for further guidance or contact your Contracting Officer. Additional Instructions to Reporting Discount Line Items 1. Enter relevant information for all required fields (Contract Number, SIN Number, Order Number, Description of Deliverable, Unit of Measure, Quantity of Items Sold, Unit Price, Total Price). 1.a: Products (Contract Number, Order Number/PIID, Description of Deliverable, Manufacturer Name, Manufacturer Part Number, Unit of Measure, Quantity of Items Sold, SIN, Unit Price, Total Price, Non Federal Entity). 1.b: Services (Contract Number, Order Number, Description of Deliverable, Unit of Measure, Quantity of Item Sold, SIN, Unit Price, Total Price, Non-Federal Entity). 2. Under Unit Measure specify either "VD" for Volume Discount or "PPD" for Prompt Payment Discount. 3. Under Quantity of Items Sold, specify the number of discounts applied to a given order. This should be a negative value. 4. Under Price Paid per Unit (US$), enter the dollar amount of the discount. This should be a positive US$ amount 5. Under Total Price (US$) enter the Total Price derived from Quantity of Items Sold * Price Paid per Unit (US$). This should be a negative value. Note: if your contract requires you to report additional data elements beyond those detailed in the "Definition of Data Fields" below, please check your contract for further guidance or contact your Contracting Officer. Definitions of Data Fields: Field Label Contract or BPA Number SIN Number Order Number/Procurement Instrument Identifier (PIID) Description of Deliverable (Maximum 1000 Characters) Manufacturer Name Manufacturer Part Number Universal Product Code (UPC) Unit Measure Quantity of Item Sold Price Paid per Unit Total Price Paid Non Federal Entity Agency Name Tier 3 Agency Name (Subagency Name) or VA Station Number What NOT to do Application will reject the file upload if any of the following are changed on the template. 1. Do NOT add tabs to this Template. 2. Do NOT change the formatting on this template including the column names on the second 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 for products or services blank. Additional Help For a successful and timely submission of sales data by uploading Excel file please follow these step by step instructions. 1. For additional help the Online User Manual is available on the FAS Sales Reporting Portal page. 2. If you need further assistance with respect to the business processes and procedures, please contact your Contracting Officer at GSA. 3. 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. Non-Federal Entity CODE SCP SDP OTH N/A Unit of Measures (Abbreviation and Unit Description) ABBR. 01 02 03 04 05 08 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 32 33 34 35 37 38 40 41 43 44 45 46 47 48 50 51 52 53 54 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 76 77 78 79 80 81 82 83 84 85 86 87 89 90 91 92 93 94 95 96 97 98 1A 1B 1C 1D 1E 1F 1G 1H 1I 1J 1K 1L 1M 1N 1O 1X 2A 2B 2C 2F 2G 2H 2I 2J 2K 2L 2M 2N 2P 2Q 2R 2U 2V 2W 2X 2Y 2Z 3B 3C
no reviews yet
Please Login to review.