jagomart
digital resources
picture1_Sales Report Format In Excel Free Download 23909 | Fas Srp Reporting Template Vos4 Jul 2020


 203x       Filetype XLSX       File size 0.48 MB       Source: www.gsa.gov


File: Sales Report Format In Excel Free Download 23909 | Fas Srp Reporting Template Vos4 Jul 2020
fas sales report template version136 last updated 11012018 instructions to upload sales data to federal acquisition service fas sales reporting portal srp for a successful and timely submission of sales ...

icon picture XLSX Filetype Excel XLSX | Posted on 30 Jul 2022 | 3 years ago
Partial file snippet.
             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
The words contained in this file might help you see if this file matches what you are looking for:

...Fas sales report template version last updated instructions to upload data federal acquisition service reporting portal srp for a successful and timely submission of by uploading excel file please follow these step once you download save the your local drive enter contract number s in column each line item note if has multiple orders items must be entered all lines columns b through l provided that are marked with asterisk required fields see definition below explanation products order numberpiid description deliverable manufacturer name part unit measure quantity sold sin price total non entity services nonfederal contracts is into spreadsheet login digital certificate navigate option on page select appropriate period then browse saved click submit when will prompted certify being submitted true accurate agree accept not go back make necessary changes requires additional elements beyond those detailed check further guidance or contact contracting officer returns relevant information u...

no reviews yet
Please Login to review.