1 / 75

WSCA Quarterly Sales Reporting Process

WSCA Quarterly Sales Reporting Process. Cisco U.S . Public Sector Contracts Management Office 2012. Agenda. WSCA Reporting Process Highlights Key Reporting and Contract Admin Fee Reminders Inaccurate Report Process Report Template Report Template – Example

jael
Télécharger la présentation

WSCA Quarterly Sales Reporting Process

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. WSCA Quarterly Sales Reporting Process Cisco U.S. Public Sector Contracts Management Office 2012

  2. Agenda • WSCA Reporting Process Highlights • Key Reporting and Contract Admin Fee Reminders • Inaccurate Report Process • Report Template • Report Template – Example • Report Submission Process – Cisco Immix Web Portal • Common Reporting Issues & FAQs • Open Floor for Partner Questions • Back up Slides – Reference, Cisco.com WSCA Website, Invoicing, and WSCA State Contracts Overview

  3. WSCA Reporting Process Highlights • Report Submission Process • Submit reports via the Cisco Public Sector Contract Sales Reporting Web Portal: https://pos.immixgroup.com/IGCISCO • Report Template • Download the report template from the Web Portal (https://pos.immixgroup.com/IGCISCO ). • Report Due Dates • Reports are due 15 calendar days following the end of a calendar quarter: • Cal. QtrReporting Period-Date RangeReport Due Date • Q1   January 1 through March 31   April 15th • Q2   April 1 through June 30   July 15th • Q3   July 1 through September 30   October 15th • Q4   October 1 through December 31   January 15th • $0 No Sales to Report • Do NOT complete a report template, but you MUST log into the Web Portal to submit “$0 No Sales” for the quarter. • Authorized IronPort Resellers ONLY • Submit a separate report file for IronPort Quarterly Sales using the same report template.

  4. Quarterly Sales Volume Reporting &WSCA and State Fee Remittance Process Cisco reviews Partner quarterly reports and notifies WSCA and each State when consolidated report is available on Web Portal Partner prepares WSCA Quarterly Sales Volume Report Partner submits WSCA Report via Web Portal by due date Cisco aggregates WSCA and State Fees collected from Partners and sends one (1) check payment to WSCA and one (1) check payment to State (as applicable) Partner receives an Invoice for the WSCA & State fees via email from CISCO with Payment Terms of “Pay Immediately Upon Receipt” Partner submits payment for the invoiced WSCA (0.5%) & State fee (if applicable) amount to CISCO

  5. Key Reporting and Contract Admin Fee Reminders • Which Sales Transactions to Report • All orders placed by Authorized Purchasers using the WSCA contract in their State; AND All sales for which a purchase order has been received and accepted during the reporting interval; • Any order(s) placed as a result of Partner being awarded the deal based on a mini bid (i.e. solicitation for quotes) or mini RFP that leverages the Ts &Cs of the WSCA contract or piggybacks off of it; or • Any order(s) placed as result of Partner being awarded a deal based on a full blown RFP that leverages the Ts & Cs of the WSCA contract or piggyback’s off of it. • NOTE: • Any orders which a customer’s PO has been accepted by the Partner AND order has been placed with Cisco or Disti must be reported. If order has not YET been placed with Cisco or Disti, report order in future reporting period when order has been placed with Cisco or Disti. • It is not necessary to report $0 configured minor line items if it is part of a major line priced SKU. • It is the Partners’ responsibility to verify with the Authorized Purchaser if the order does NOT clearly identify that the order is being placed through WSCA. Underreporting is grounds for removal from the WSCA Contract.

  6. Key Reporting and Contract Admin Fee Reminders • Contract Administrative Fees • Pursuant to Partners’ U.S. Public Sector Subcontract/Supplement (USPSS), Partners are responsible for the following administrative fees based on the invoiced amounts to Authorized Purchasers (adjusted for credits): • WSCA Administrative Fee (0.5% of Net Purchase Price) • State Administrative Fee (if applicable) – See Below Payment Due Date Pursuant to Partners’ USPSS, payment for WSCA & State Fees are due: Immediately Upon Receipt of Invoice. Invoices will be sent from email address edeliveryinvoice@cisco.com. 

  7. Inaccurate Report and Contract AdministrativeFee Process • Process to Address Inaccurate Reports Submitted • Quarterly Reports may only be submitted once. If a Partner needs to resubmit a report for any reason BEFORE the report deadline, you MUST perform the following steps: • Email the Cisco Contract Administrator: wsca-help@external.cisco.com to request approval to resubmit the report. Partner MUST provide a justification for the requested resubmission and contact information of the person who can answer questions that Cisco may have regarding Partner’s request. • Cisco will review the email request and advise Partner if the request is approved. • If approved, Cisco will grant Partner the ability to resubmit the report via the Web Portal. • Resubmitted report will be reviewed by Cisco and may be rejected if any issues are found. • NOTE: If a Partner needs to resubmit a report AFTER the report deadline, the Partner is subject to the following: • Cisco will notify WSCA and the State and jointly determine a correction process. • Partner may be required to correct inaccurate sales data in the NEXT quarter’s sales volume report submission: • Missing sales – add to next quarter’s report as a normal transaction • Unauthorized contract sales – add to next quarter’s report as a credit transaction

  8. Report Template

  9. Report Template Header Section HeaderSection (Rows 1-8): Do this first! Fill in the blue highlighted rows with your Partner information. Drop Down List (Rows 2 & 4 ONLY): Select from available selections to populate “State” and “Quarter-End Date” fields.

  10. Report Template Header Section – Definition of Fields • Partner Name (row 1): Partner/Reseller Full Legal Company Name • State (row 2): Select from Drop-Down List the US State the sales data being reported is in reference to • Contract ID (row 3): US State Prime Contract Number. This is the prime contract between the State and Cisco. WSCA Contract Number is AR-233. Use the state/PA ID#  table below to determine the Contract ID that you should enter (see slide notes for details) • Quarter-End Date (row 4): Select from Drop-Down List Quarter-end date of the sales data being reported • Contact Name (row 5): Partner/Reseller Company Contact Person’s Name • Contact Phone (row 6): Partner/Reseller Company Contact Person’s Phone # • Contact Email (row 7): Partner/Reseller Company Contact Person’s Email • Partner PO# for Cisco Fee Invoicing (row 8): Cisco will invoice Partner for WSCA .5% fee + State fee (if applicable). Enter Partner’s Purchase Order Number that will be used to pay the Cisco Invoice for the Contract Admin Fees. Enter placeholder PO# if not available. (ex. CiscoWSCANJQ1CY11)

  11. Report Template Detail Section DetailSection (Columns B – Q): Start populating data only after completing the Header Section. Begin at row 11 and work your way right  to complete each detail row. One row for each SKU. Do not skip any rows. Spreadsheet Message (Column A): If any detail section cell is blank or is identified to have a problem, a descriptive error message will appear in the “Spreadsheet Message” column for the applicable row.

  12. Report Template Detail Section – Definition of Fields • Report any orders which a customer’s PO has been accepted by the Partner AND order has been placed with Cisco or Disti must be reported. If order has not YET been placed with Cisco or Disti, report order in future reporting period when order has been placed with Cisco or Disti. • It is not necessary to report $0 configured minor line items if it is part of a major line priced SKU. • Cisco Sales Order or Transaction ID (column B): Cisco’s Sales Order Number if the order went direct -OR- the Transaction ID if the order went through distribution. • Partner PO # (To Cisco or Disti) (column C): Partner’s Purchase Order Number associated with the order submitted to Cisco/Distributor. • Partner PO Date (To Cisco or Disti) (column D): Date of Partner’s Purchase Order associated with the order submitted to Cisco/Distributor. • Purchasing Entity's PO Number (column G): Purchasing Entity’s purchase order number placed with Partner. • Purchasing Entity's PO Date (column H): Date of Purchasing Entity’s purchase order number placed with Partner. Date Fields should be formatted as MM/DD/YYYY Example: 01/01/2011

  13. Report Template Detail Section – Definition of Fields • There may be orders where Partner’s Invoice to customer may not have been generated YET by the report submission date, for a variety of timing reasons. If this is the case, do the following: • Enter “TBD” for Invoice ID #. • Enter the last date of Reporting Period for Invoice Date. • IMPORTANT NOTE: Partner may be required to provide the actual Invoice number AFTER the report submission for audit purposes or upon request from the Contract Administrator(s) and/or Cisco. • Partner to Purchasing Entity's Invoice Number for Transaction (column E): Partner's invoice number to the Purchasing Entity associated to the order. Enter “TBD” if invoice has not been generated and sent to the Purchasing Entity yet. • Partner to Purchasing Entity's Invoice Date for Transaction (column F): Date of Partner's invoice number to the Purchasing Entity associated to the order. If invoice has not been generated and sent to Purchasing Entity YET, enter last date of Reporting Period. Ex. Q1CY11 enter “03/31/2011”. Report any orders which a customer’s PO has been accepted by the Partner AND order has been placed with Cisco or Disti.

  14. Report Template Detail Section – Definition of Fields • Columns I-K • Purchasing Entity Type (column I): Select from Drop-Down List the type of Purchasing Public Sector Entity associated to the order • Gov-State • Gov-County • Gov-Local • Edu-K-12 • Edu-HE 2 yr • Edu-HE 4 yr • Edu-Private • Non-Profit • American Indian Tribes • Purchasing Entity Name (column J):Purchasing Public Sector Entity's name as shown on order placed with Partner • Purchasing Entity Bill-To Address (column K): Purchasing Public Sector Entity's full Bill-To (Billing) address: • Address Line 1City, State and Zip Code

  15. Report Template Detail Section Detail Section (Columns B-Q): Sales Volume. Sales Types include: Product, Service, and Basic Installation & Configuration (BI&C) Service. Only one SKU may be reported on each row. Basic Install & Config is only available in SELECT WSCA States.

  16. Report Template Detail Section – Definition of Fields • Type of Sale: Product, Service, or Basic Install & Config (P or S or B) (column L):Select from Drop-Down List the type of sale • Product – Select “P” • Service – Select “S” • Basic Installation & Configuration (BI&C) Service – Select “B” • Product/Service SKU OR "Basic Install & Config" (column M): Enter the EXACT SKU for Product/Service per the published Pricelist OR for BI&C, enter “Basic Install & Config”. • Refer to the current pricelist posted on the WSCA website • Product/Service Description OR "Basic Install & Config" (column N): Enter the EXACT Description for Product/Service per the published Pricelist OR for BI&C, enter “Basic Install & Config”. • Refer to the current pricelist posted on the WSCA website • Prod/Srvc Qty OR BI&C Hours (column O): Actual quantity for each Product/Service SKU OR Total number of Basic Install & Config Hours • Product/Service List Price OR BI&C Hourly Rate(column P): Current List Price for each Product/Service SKU OR Partner’s Basic Install & Config Hourly Rate • Refer to the current pricelist posted on the WSCA website • Product/ Service Discount % (column Q): Actual discount percentage for each Product or Service SKU. Enter 0% for Basic Install & Config. Basic Install & Config is only available in SELECT WSCA States.

  17. Resources & Information for Detail Section Pricelist For Product/Service SKU, Product/Service Description & Product/Service List Price(Columns M, N & P), Partners are REQUIRED to refer to the current pricelist posted on the Cisco.com WSCA website: WSCA Cisco Pricelist (including Basic Maintenance for e-Rate): http://www.cisco.com/web/strategy/government/wsca/states/price_list.html WSCA IronPort Pricelist:  http://www.cisco.com/web/strategy/government/wsca/states/ironport_price_list.html The pricelist posted on the WSCA website is the sole source of state approved contract pricing information that MUST be utilized when supplying product and service price quotes to WSCA Authorized Purchasers. No other source may be used. Basic Installation & Configuration Service Availability Limited Partner Professional Services: Certified and Technical Project Management, Implementation Engineering, Site Survey, High Level Design Review, Staging, Global Implementation Capability, Configuration Development, Knowledge Transfer and Detailed Documentation

  18. Report Template Detail Section Detail Section (Columns B-Q): Amounts automatically populate once all sales volume data is input.

  19. Report Template Detail Section – Definition of Fields • All fee amounts in these columns AUTOMATICALLY calculate once all sales volume data is input. • Product/Service/BI&C Net Amount (column R): This column calculates the Net Purchase Price based on reported items’ Quantity, List Price, and Discount % entered in columns O-Q. • Contract Admin Fee Amount (column S): This is the WSCA Contract administrative fee due and payable to WSCA. The fee is based on 0.5%of the Net Purchase Price (column R). • State Admin Fee Amount (column T): IF APPLICABLE, this is the State Administrative fee due and payable to the Participating State if they impose an administrative fee on WSCA sales activity. The fee amount varies by state and is based on a percentageof the Net Purchase Price (column R), per the table below.

  20. Report Template Formatting & Adding Rows “Auto Format Rows” Button: Will wrap text and adjust column width and row height “Add 10 Blank Rows” Button: This adds 10 additional rows to the bottom of your spreadsheet to add more sales data Allow Excel to enable macros if security warning appears

  21. Report Template – SUMMARY • Do NOT complete a report template, but you MUST log into the Web Portal to submit “$0 No Sales” for the quarter. • Download the report template from the Web Portal • Complete the Header Section (rows 1 to 8) first. • Manual entry for the Detail Section (columns B-Q) begins at row 11. • Each row in the Detail Section MUST be populated with data for columns B to Q. • Each row in the Detail Section must include sales volume data for only one (1) SKU. • Each Product/Service SKU (column M) entry must match the Type of Sale (column L) indicated. For example, when reporting “S” in column L for Service, Product ID in column M must begin with a Service prefix such as ‘CON-’. • Use the Auto Format Rows macro button to resize columns/rows and wrap text within a cell. • Use the Add 10 Blank Rows macro button to add additional rows to the bottom of the spreadsheet. • Cisco.com WSCA Website URL (to access WSCA Price Lists): http://www.cisco.com/web/strategy/government/wsca/index.html • For general questions regarding the WSCA contract, please email Cisco CMO at wsca-help@external.cisco.com

  22. Report Template Example

  23. Report Template Header Section - Example HeaderSection: Input cells change color from blue as information is entered.

  24. Report Template Header Section - Example DetailSection (columns B-Q): In the example below, columns B-K have been entered.

  25. Report Template Header Section - Example Basic Installation and Configuration Services which do not have a Cisco Sales Order or Transaction ID or Partner PO # To Cisco or Disti: Enter N/A Cisco Sales Order or Transaction ID not generated yet: Enter TBD* Allowable Exception Entries: Enter “Signed SOW”, “Signed Quote” or “P-Card” with additional details where available Cisco Sales Order or Transaction ID not retained in Partner’s records: Enter N/R* Invoice # not generated yet: Enter TBD* in Col E and the last day of the quarter in Col F NO other “exception” entries are allowed without Cisco pre-approval

  26. Report Template Detail Section - Example Type of Sale & SKU mismatch: On rows 12 & 13, the type of sale (column L) does NOT match the SKU (column M) Row with empty column: On row 16, the description field is blank. Trade-In: On row 17, enter “TRADE-IN” preceding the SKU description.  Enter the trade-in net amount as a negative amount and 0% discount.  In the following row, enter the new purchase associated to the preceding Trade-In.

  27. Report Template Detail Section - Example General Error Message: The error below appears whenever there are any errors detected and reported in the “Spreadsheet Message” column. Detail Error Messages: If any detail section cell is blank or identified to have a problem, a descriptive error message will appear in the “Spreadsheet Message” column. Do NOT submit report with ERRORS – correct all errors prior to submission.

  28. Report Template Detail Section - Example Clearing the Errors: On row 13, corrected Type of sale to P to match Product SKU. On row 14, corrected Type of sale to S to Service SKU. On row 16, populated column N with the correct SKU description.

  29. Report Template Detail Section - Example Some Cells May be difficult to Read: Cells with longer values are cut off and need to be formatted. “Spreadsheet Messages” column & General Error Message on Row 9: Errors have been eliminated.

  30. Report Template Detail Section - Example If you run out of empty rows, Click “Add 10 Blank Rows” button: This adds 10 lines to the bottom of your spreadsheet. “Auto Format Rows”: Click the macro button to reformat the cells. Allow Excel to enable macros if security warning appears

  31. Cisco Public Sector Contract Sales Reporting Web Portal

  32. Report Submission Process • Cisco Public Sector Contract Sales Reporting Web Portal URL: https://pos.immixgroup.com/IGCISCO/ • If you are reporting “$0 No Sales” for the quarter, Do NOT complete a report template, but you MUST log into the Web Portal to submit “$0 No Sales” for the quarter. • If you are reporting WSCA sales volume for the quarter, review the report for accuracy and save your completed report file. Proceed to the Web Portal to upload and submit your report file. • For any Reporting Web Portal related questions, please email CISCO_Portal-help@immixgroup.com • Web Portal Functionality: • Log-In • User Profile • Partner Profile • Contract Partner Profile • Download Reporting Template • $0 No Sales Report • Quarterly Sales Volume Report Submission • Partner Submission Status Report

  33. Web Portal: Log-In Click the Log In link on top right corner Training Materials & FAQs (no login req) Enter Username and Password Click Log In If you forgot your username or password, enter your email address then click either “Send me my Username” or “Reset my Password” button.

  34. Web Portal: User Profile Click your Username link to update profile Update any user profile information, except Username Click Save once changes are input Change Password

  35. Web Portal: Partner Profile To view and/or edit your Partner Profile, click “Partner Profiles” on the left navigation column.

  36. Web Portal: Contract Partner Profiles To view Contract Partner Profile, click “Contract Partner Profiles” on the left navigation column. Click on the pencil icon to view and/or edit that specific Contract Partner profile. Only contracts and manufacturers specific to the Partner company will be displayed on this screen. Some Partners may see only one option, whereas other Partners who are authorized on several contracts for different manufacturers will see multiple options as exemplified above.

  37. Web Portal: Contract Partner Profiles Partner Contacts may be updated by selecting the appropriate contact tab and editing the open text fields. Some fields are READ-ONLY. To update the read-only information, contact your Cisco Contract Manager.

  38. Web Portal: Download Reporting Template To download a copy of the Reporting Template, click “Download Reporting Templates” on the left navigation column. Click on the Spreadsheet Icon image to download the template file Version and date is indicated below template link. Current version must be used, old versions will be rejected by Web Portal. Save the file to your computer hard drive

  39. Web Portal: Upload POS Data – NO SALES To upload No Sales, click “Upload POS Data” on the left navigation column. Complete all fields and Click the checkbox for “No Sales” before clicking “Submit” Click “Confirm” to officially submit a No Sales Report. Failure to confirm will result in NO submission Verify the below confirmation message is received. If you do not get the confirmation message, the report was NOT submitted successfully.

  40. Web Portal: Upload POS Data – SALES To upload a Sales Report, click “Upload POS Data” on the left navigation column. Browse and select the completed report file saved on your computer’s hard drive • On the report file, ensure: • The most recent version template is used. • Rows 1-8 are completed filled out ACCURATELY • There are NO blank cells that are required fields or NO skipped rows • All Date related cells contains a valid date in the required date format • The Purchasing Entity Type accurately corresponds to the Purchasing Entity • The Purchasing Entity Bill To Address contains a FULL address incl. City, State & Zip Code • Type of Sale accurately corresponds to the SKU – S for Service and P for Products • Total Amounts are accurately calculated • SKU & Description MATCH EXACTLY to the posted WSCA Price List Files on the WSCA website

  41. Web Portal: Data Validation The Web Portal performs several data validation checks and will prevent upload and submission of the report file if errors are found. Detailed descriptions of the errors will be identified either at the top of the screen in a red banner or below the submit button. Errors below the submit button will indicate the specific row and description of the error. Errors must be fixed in order to submit file successfully. For assistance with these errors, please email CISCO_Portal-help@immixgroup.com

  42. Web Portal: Upload POS Data – SALES A summary of the report will appear, including the number of data records, summary of product, service and basic install totals, and grand total amounts. Click “Confirm” to officially submit the Sales Report. Failure to confirm will result in NO submission Verify the below confirmation message is received. If you do not get the confirmation message, the report was NOT submitted successfully.

  43. Web Portal: Partner Submission Status To view status of a submitted report, click “Partner Submission Status” on the left navigation column. Status may be in either “Submitted”, “Rejected”, or “Approved” Status. Cisco will notify Partners if a report is rejected due to errors or issues. Partners are required to correct the errors before the report due date, otherwise the report will be considered late and the report delinquency will be noted for performance reviews.

  44. Web Portal: Email Confirmation An Email confirmation is sent to the user when the report is successfully submitted in the web portal. If you do NOT receive an email confirmation, the report was not successfully submitted.

  45. Common Reporting Issues & FAQs

  46. Common WSCA Reporting Errors • Incorrect State (row 2): Select from Drop-Down List the CORRECT US State the sales data being reported is in reference to • The correct State must be selected for the administrative fees to be calculated correctly. • Incorrect Quarter-End Date (row 4): Select from Drop-Down List the CORRECT Quarter-end date of the sales data being reported • Blank Partner PO# for Cisco Fee Invoicing (row 8): Do NOT leave BLANK.Enter Partner’s Purchase Order Number that will be used to pay the Cisco Invoice for the Contract Admin Fees. Enter placeholder PO# if not available. (ex. CiscoWSCANJQ1CY11) • Invalid Cisco Sales Order or Transaction ID (column B): Enter a VALID Cisco Sales Order Number if the order was placed directly with Cisco -OR- the Transaction ID if the order was placed with distribution. • If the order is for Basic Install & Configuration (BI&C), enter “N/A” in column B. • If your company’s internal systems does not retain the SO or ID, Please enter “N/R” in column B. In event of an audit, Partner may be required to provide this information. • If the order has been placed with Cisco or Disti, but the SO or ID has not yet been generated, enter “TBD”. • Only a valid SO, valid ID, “N/A”, “N/R”, or “TBD” will be accepted in this field. • Invalid Purchasing Entity's PO Number (column G): Enter a VALID Purchasing Entity’s purchase order number placed with Partner or “Signed SOW”, “Signed Quote” or “P-Card” with additional details where available (Quote #, Confirmation # of P-Card, etc.) • Incomplete Purchasing Entity Bill-To Address (column K): Purchasing Public Sector Entity's FULL Bill-To (Billing) address: • Address Line 1City, State and Zip Code

  47. Common WSCA Reporting Errors - continued • Invalid Product or Service SKU (column M): Enter the EXACT Product or Service SKU per the published WSCA Pricelist: http://www.cisco.com/web/strategy/government/wsca/states/price_list.html • Invalid Product or Service Description (column N): Enter the EXACT Description associated to the Product or Service SKU per the published WSCA Pricelist: http://www.cisco.com/web/strategy/government/wsca/states/price_list.html • Out of Scope Sales: WSCA excludes the sale of video conferencing and Partner branded services (i.e. cobranded services and Partner branded). The pricelist posted on the WSCA websitecontains only WSCA authorized SKUs andMUST be utilized when supplying product and service price quotes to WSCA Authorized Purchasers. No other source may be used. • Out of scope sales places a Partner at risk for removal of the contract. • Auto fill: Using auto fill when copying down rows may inadvertently result in ascending numerical values. This is commonly done on Bill to Address (zip code) & PO Number columns. • Errors on Report (Row 9 & Column A): Ensure that Row 9 and Column A do not contain any error messages. If row 9 has an error message, details of the error of the applicable row can be found in column A. • Only LIMITED error checking is performed in Column A. Additional limited error checking is conducted upon submission in the Web Portal. • Excel File and Web Portal error checking does NOT include errors mentioned above. • TBD in Date Fields: Values in the date field must be in date format (MM/DD/YYYY). Enter the last date of the applicable Reporting Period for any TBD Invoices or POs. • Partner PO Date (To Cisco or Disti) (column D) • Partner to Purchasing Entity's Invoice Date for Transaction (column F) • Purchasing Entity's PO Date (column H)

  48. WSCA FAQ’s Q: What types of sales transactions should be reported? A: 1) All orders placed by Authorized Purchasers using the WSCA vehicle in their State AND All sales for which a purchase order has been received and accepted during the reporting interval. 2) Any order placed as a result of Partner being awarded the deal based on a mini bid (i.e. solicitation for quotes) or mini RFP. 3) Any order(s) placed as result of Partner being awarded the opportunity based on a full blown RFP that leverages the terms and conditions of the WSCA contract and piggyback’s off of it. It is the Partners responsibility to verify with the Authorized Purchaser if the order does NOT clearly state that the order is being placed through WSCA. Under reporting is grounds for removal from the WSCA Contract. Q: What if I can’t find the SKU on the posted WSCA Price List?A: 1) The SKU may be out of scope of the WSCA contract. WSCA excludes the sale of video conferencing and Partner branded services (i.e. cobranded services and Partner branded). 2) If you are certain the SKU is in scope, please email the SKUs you are not able to locate to wsca-help@external.cisco.com. Q: What if the Invoice to customer has not been generated yet? A: Please enter “TBD” if invoice has not been generated and sent to the Purchasing Entity yet. Enter the last date of the applicable Reporting Period for any TBD Invoices in column F. Q: What is the Transaction ID?A: A transaction ID is the order confirmation number if the order went through distribution. Cisco will accept any type of identification number that will enable the tracking of the order through the distributor.  This may include a Disti invoice number, sales order number, order confirmation number, order identification number, etc.  Q: What if I don’t have a Transaction ID from distribution?A: If your company does not retain the ID# in your internal systems AND you cannot obtain it from the Distributor, please enter “N/R” in column B. In event of an audit, Partner may be required to provide this information. Q: What do I put in the Partner PO# for invoicing cell in the header section (row 8)? A: Enter Partner’s Purchase Order Number that will be used to pay the Cisco Invoice for the WSCA Contract Admin Fees (and State Admin Fee if applicable). Enter placeholder PO# if not available. (ex. CiscoWSCANJQ1CY11) Q: What is a "Purchasing Entity”?A: The Purchasing Entity is the “Authorized Purchaser” (End Customer), as defined by the WSCA Master Agreement and/or WSCA Participating Addendum of each State, who placed the order with the Partner. Refer to those contracts for a detailed definition of Authorized Purchasers in any particular WSCA State. More FAQ’s are posted on the Immix Web Portal https://pos.immixgroup.com/IGCISCO/Pages/FAQ.aspx

  49. WSCA FAQ’s continued Q: Can I copy and paste data? A: Yes, but please make sure to “Paste Values” otherwise errors and formatting issues will occur on the file. Use caution when using copy and paste as you are contractually obligated to submit accurate reports which may be subject to audit by Cisco, WSCA or the State. Q: What if I can’t update the cell contents after I enter data? A: You may be using an old template version. Download the current version template from the Immix Web Portal. If you have verified your template version and are still having issues. Please email wsca-help@external.cisco.com. • Q: Why aren’t the macro buttons working? A: Please make sure macros are enabled. Excel by default disables macros. Please visit http://office.microsoft.com/en-us/help/enable-or-disable-macros-in-office-documents-HA010031071.aspx for detailed instructions on how to enable macros. Q: I filled in all the rows, but have more sales to enter. How do I add additional rows? A: Click the “Add Ten Blank Rows” button at the top of the file. Please make sure Macro’s are enabled. A: I cannot see all the data I entered in the cell. How can I expand the cell width? A: Use the auto format rows to reformat the entire sheet so all data is visible. Please make sure Macro’s are enabled. Q: Where can I access the current Cisco WSCA pricelist for any current Cisco WSCA Participating State except for the State of Washington?A: WSCA Pricelist (except WSCA WA) URL: http://www.cisco.com/web/strategy/government/wsca/states/price_list.html. Q: Where can I access the current Cisco WSCA pricelist for the State of Washington?A: WSCA Washington Pricelist URL:http://www.cisco.com/web/strategy/government/wsca/states/washington/price_list.html Q: I am no longer the reporting contact. How do I stop receiving the report reminder emails?A: 1) Log into the Web Portal and change the reporting contact under the Contract Partner Profiles Link. 2) Contact your Cisco WSCA Contract Manager and send an updated Partner Info Form with the changes. More FAQ’s are posted on the Immix Web Portal https://pos.immixgroup.com/IGCISCO/Pages/FAQ.aspx

  50. Audits • Cisco will be implementing further comprehensive AUDITS of previously submitted and future Partner Reports, which will include, but are not limited to, verifying the following: • SKUs submitted in reports EXACTLY match SKUs published on the WSCA Price List. SKUs not published on the WSCA Price List are deemed out of scope. Out of scope sales places a Partner at risk for removal from the contract. • List price submitted in reports EXACTLY match SKUs List Price published on the corresponding monthly WSCA Price List per the date of the Purchasing Entity’s PO. • Discount offered to Purchasing Entity matches or exceeds the discount indicated in the executed WSCA Discount Letter. Discounts below those indicated in the Discount Letter places Partner at risk for removal from the contract. • WSCA Quarterly Sales Volume Report sales data will be compared against Cisco Bookings Reports to verify if Partners are under reporting. Under reporting is grounds for removal from the WSCA Contract.

More Related