Spend Analytics

Sysoft Spend Analytics Module can:

1. Extract — support automated extraction of all spend data from internal and external business systems.
2. Validate — ensure spending data files are accurate and complete.
3. Cleanse and classify — enable efficient, accurate, and preferably automated rationalization and classification of data elements and attributes. Eliminate discrepancies between incongruent naming conventions and map spend data to industry-standard classification systems (e.g.,NIGP, UNSPSC, etc.) or enterprise-specific taxonomies.
4. Enhance — enhance cleansed spending data with complementary business information, including existing contract terms, alternative parts references, suppliers’ financial status and performance information, minority, woman-owned business (MWOB) status, etc.
5. Analyze — support role-based analysis of actionable spending information. Enable export of cleansed and enhanced spending information to third-party analytical tools.

 

Features and functionalities:

1. Web-based system – Software as a Service (SaaS)
2. No hardware or software purchase, rental, or installation, cloud storage or server purchase or lease, or direct integration with any agency computer systems required
3. Enterprise licensing
4. System includes and combines data from different sources (ERP system, purchasing card transactions, etc.)
5. Ability to import Agency contract data to match against expenditures
6. A set of standard spend analysis reports
7. Data sorting by categories such as department, purchase type (ie. purchase order, purchasing card, etc.), commodity/vendor code, purchase size (include additional sort categories in the comments field)
8. Ability to create custom reports
9. Ability to filter reports
10. Ability to save charts and graphs to be added to other documents and to export data for use in other applications
11. Identifying transactions where purchase order date is later than invoice date
12. Vendor classification system enabling category analysis to aggregate demand
13. Benchmarking of Agency’s performance during different time periods
14. Benchmarking of Procurement Agency’s spend against other entities
15. Data Transformation Services
16. Procurement agency’s source data can be provided in Excel, Access or .CSV format or Sysoft can build a seamless integration to the procurement system.
17. Automated checks to eliminate possible data corruptions, omissions, inconsistencies, duplicates and other issues
18. Manual resolution of remaining data corruptions, omissions, inconsistencies, duplicates and other issues
19. Matching procurement agency data against Contractor’s vendor database to enrich supplier records
20. Data roll up preventing duplication of vendors
21. Audit existing spend data management capabilities.
22. Access all spend-data sources within and outside the enterprise.
23. Adopt a common classification schema enterprise-wide.
24. Establish efficient and repeatable data cleansing and classification capabilities through the use of software or services.
25. Augment category expertise to ensure data and classification accuracy and validation
26. Classify spending at a detailed level.
27. Enhance core spend data with vital business intelligence.
28. Increase frequency and coverage of spending analyses.
29. Utilize advanced reporting and decision support tools.
30. Continuously expand uses and scope of spend data management program.

 

Standard Spend Analytics Reports:

1. Strategic Sourcing Reports
2. Spend Volume Aggregation and detailed analysis reports
3. Supplier Rationalization Reports
4. Compliance Management Reports
5. Account Group Report
6. Actual Savings Report
7. Classification Percent Report collects spend by segment and identifies how well the spend is classified in each of the UNSPSC or NIGP Levels (e.g. family, class, commodity).
8. Economic Impact Report aggregates spend based on vendor remit to zip codes. Regional Profiles are defined and created that “bucketize” the spend into groups of zip codes. Results are presented in raw dollars and as percentages of total Agency spend for the defined periods.
9. e-Procurement Vendor Report combines e-Procurement vendor spend across UNSPSC or NIGP classification. The data is presented in a table by e-Procurement, other spend (e-Procurement enabled vendors, but via other systems) and standard (non e-Procurement vendors) spend.
10. Potential Savings Report
11. Preferred Vendor Report gathers spend across UNSPSC or NIGP classification and presents the information across standard and preferred vendor spend.
12. Price Comparison Report
13. Run Rate Report shows the impact of contract savings in past, present, and future fiscal periods. Forecasting uses the spend for the base fiscal year to forecast the spend in a future year or a year where some of the spend has been imported but not all of the spend. The average Consumer Price Index is used to adjust all spend numbers back to the base year’s dollars.
14. Rogue Spend Report
15. Spend Analysis Report enables the user to “drill down” from level or view of UNSPSC or NIGP data to a more granular level.
16. Spend Table Report gathers spend across any value and presents it in an x and y table classification. Users have the choice to present spend only, transaction counts only, or both.
17. Vendor Diversity Report collects spend based on the status of the vendor (e.g. minority, women owned, small, veteran owned, hub zone). Users have the ability to select a comparable year and a review year. Results are presented in raw dollars and as percentages of total agency spend for the defined periods.
18. Vendor Type Report amasses spend by a selected “view” and identifies which spend is e-procure, preferred, alternate, contract, and other spend.
19. Dashboard feature allows you to view all your favorite reports at once.
20. Vendor Performance and Key Performance Indicator Report: Visual analytics help in real time manifestation of measures and status.