Case Study: Transforming Global Data Consolidation and Diversity Spend Reporting for a Rental Car Client

Client Background 

A leading rental car company operating across multiple regions faced major challenges in consolidating and managing global data for enterprise-level reporting. Over the years, the company had implemented several regional Accounts Payable (AP) systems to manage supplier payments and expense tracking. While these systems worked effectively at local levels, they were not designed to communicate seamlessly with one another. 

Each AP system maintained its own structure, data attributes, and reporting framework, which led to data silos. This fragmentation made it increasingly difficult for the company to produce unified reports that could deliver enterprise-wide insights. The finance and supplier diversity teams often had to pull data from several systems, clean it manually in Excel, and then compile the information into custom reports. 

This manual process was time-consuming, inconsistent, and error-prone. Moreover, the client’s cost center structure was highly dynamic. As the business grew and expanded into new markets, cost centers were frequently added, reclassified, or reorganized. Keeping this information up to date across multiple systems required constant maintenance and was extremely costly. 

Without a centralized data and reporting system, the company struggled to get a holistic view of its spending patterns, supplier diversity initiatives, and operational efficiency. The leadership recognized that continuing with manual and disconnected reporting was limiting their ability to make fast, data-driven decisions. 

Challenges and Pain Points Faced by the Client

After several internal reviews, the client identified four key challenges that needed to be addressed: 

1. Fragmented Data Sources:

The company’s global operations relied on multiple AP systems, each with its own set of data fields and reporting standards. There was no common data model or unified view that could be used for enterprise analytics. 

2. Manual Consolidation Process:

Because of incompatible data formats and inconsistent data attributes, the finance team had to spend countless hours exporting data, cleaning it manually, and reconciling differences in Excel. These manual tasks not only slowed down reporting cycles but also introduced the risk of human error. 

3. Inconsistent Reporting and Limited Insights:

Different AP systems produced reports with varying parameters and metrics, making it difficult to compare or consolidate results. Leadership teams lacked the ability to view comprehensive summaries that combined key indicators like spend by product type, cost center, supplier diversity category, and ethnicity. 

4. Complex and Changing Cost Center Hierarchy:

The client’s cost center system was constantly evolving due to organizational restructuring and growth. Managing these frequent changes required IT involvement, which added cost and caused delays. 

The combination of these challenges made it nearly impossible for the client to achieve consistent, reliable, and timely reporting across its global operations. 

Client Goals 

The client’s primary objective was to build a unified data environment that would eliminate manual steps and provide accurate, high-level reporting accessible through a single web portal. 

The specific goals included: 

• Consolidating all global AP data into a centralized, enterprise-level reporting platform. 
• Allowing users to generate and view reports from a single system instead of switching between different regional platforms. 
• Simplifying the process of combining data across locations to deliver accurate and real-time insights. 
• Providing visibility into diverse supplier spending to support the company’s corporate diversity objectives. 
• Enabling dynamic management of cost center hierarchies without requiring technical intervention or redevelopment. 
• Supporting both corporate-level and federal-level reporting standards through a single, unified dataset. 

The company needed a scalable and intelligent solution that could handle complex data ingestion, automate cleansing, and deliver powerful analytics through an intuitive interface. 

STARS’ Solution 

In 2023, STARS Inc. was selected as the technology and data partner to design and implement a robust and future-ready platform. Leveraging its experience in data integration, enterprise analytics, and diversity spend reporting, STARS developed a tailored solution that transformed the client’s approach to financial and supplier reporting. 

1. Data Consolidation Across Multiple AP Systems

The first step involved integrating data from all global AP systems into a centralized repository. STARS identified and mapped common data attributes shared across systems, which served as the foundation for a unified data model. This approach ensured that the most critical financial and supplier information could be consistently captured and compared across geographies. 

Through automated data pipelines, STARS ingested data from each AP source, performed validation, and standardized it into a single, clean dataset. This eliminated the need for manual data manipulation, ensuring accuracy and consistency. 

2. Automated Background Data Optimization

To support real-time analytics and eliminate reporting delays, STARS implemented a background processing system that automatically optimized data soon after ingestion. This process involved enriching data with the latest supplier diversity updates and recalculating metrics so that users could immediately access updated information without waiting for manual refreshes. 

This automation drastically improved performance and reduced the time needed to generate large, complex reports. 

3. Dynamic Cost Center Hierarchy Management

Recognizing the client’s need for flexibility, STARS developed a custom hierarchy management feature that allowed business users to modify cost center relationships directly through the web portal. 

Previously, any change to the cost center hierarchy required IT involvement, additional coding, and downtime. With the new system, users could easily adjust hierarchies themselves as organizational structures evolved. These changes automatically propagated through the portal’s reporting layer, maintaining full data integrity without requiring technical support. 

This innovative feature provided agility and independence to the client’s finance and reporting teams. 

4. Unified Web Portal for Enterprise Reporting

STARS developed a centralized web-based reporting platform that served as the single access point for all global data and reports. The intuitive interface allowed users across departments and regions to run analytics and generate detailed spend reports with a few simple clicks. 

The portal integrated seamlessly with the data warehouse and included advanced filtering options, enabling users to view spend by Cost Center, Product Type, Supplier Diversity, or Ethnicity. It also featured interactive dashboards that displayed key performance indicators, year-over-year comparisons, and diversity trends. 

This eliminated the need to work in Excel or rely on manual data merges. All users, from executives to analysts, could access accurate, consolidated data through one secure web platform. 

5. Dual-Mode Reporting for Corporate and Federal Needs

One of the most significant achievements of this project was the creation of a dual-reporting framework. The client needed to meet two distinct reporting standards: 

• Corporate-level management reporting, where spend data is counted once per supplier (single-counting logic). 
• Federal-level subcontracting reporting, which requires double-counting of specific spend categories for compliance. 

STARS’s architecture was designed to support both reporting modes using the same dataset. This eliminated the need to maintain multiple data sources or reprocess information separately for compliance purposes. 

Business Impact after STARS’ Solution

The implementation of STARS’s solution delivered measurable improvements across multiple areas of the client’s operations. 

1. Centralized Access and Unified Data

The new system provided a single platform for accessing all global spend data. Users no longer had to extract and combine reports from multiple AP systems. The unified portal ensured that everyone from regional finance teams to executive leadership was working from the same, consistent dataset. 

2. Improved Efficiency and Accuracy

Automating data ingestion and processing eliminated manual steps, reducing reporting time from days to minutes. The accuracy of reports improved dramatically, and the risk of errors caused by manual handling was virtually eliminated. 

This allowed the finance team to focus on strategic analysis rather than data cleanup. 

3. Enhanced Reporting and Insights

The portal’s analytics engine allowed users to generate sophisticated reports across multiple dimensions, including cost center, product type, supplier diversity, and ethnicity. These multidimensional insights gave leadership the ability to identify trends, control costs, and strengthen diversity initiatives. 

4. Stronger Forecasting Capabilities

The year-over-year trend analysis and forecasting tools enabled the company to identify performance gaps, allocate resources more effectively, and forecast spending patterns with higher precision. 

5. Streamlined Federal and Corporate Reporting

By supporting both single-counting and double-counting logic within one dataset, the solution simplified compliance reporting. This was especially beneficial for the teams responsible for Federal Subcontracting Reports, reducing their dependency on IT and accelerating their reporting cycles. 

6. Cross-Departmental Value

The benefits extended beyond finance and diversity teams. Departments responsible for procurement strategy, compliance, and supplier management gained access to the same accurate data, which improved collaboration and consistency across the organization. 

Results 

Following the deployment of STARS’s solution, the rental car client achieved significant improvements in both operational efficiency and analytical depth: 

• Reporting turnaround time reduced by over 80%. 
• Error rates in consolidated reports dropped to near zero. 
• Supplier diversity visibility increased significantly, enabling the company to monitor Tier 1 diverse spend in real time. 
• Operational costs related to data maintenance and IT support declined, thanks to the self-service hierarchy management feature. 
• Compliance reporting became faster, more accurate, and audit-ready. 

The new platform also improved transparency and collaboration. Senior management now had access to live dashboards that provided a complete view of spend, diversity metrics, and cost center performance across regions. 

Conclusion 

Through a strong partnership with STARS Inc., the rental car client successfully modernized its global reporting infrastructure. By integrating data from multiple AP systems into a single, centralized platform, the client gained full control over its enterprise data environment. 

The new web portal streamlined the process of data analysis, diversity tracking, and forecasting, allowing the organization to make better, faster, and more strategic decisions. 

STARS’s approach combining automation, flexible architecture, and user empowerment transformed what was once a fragmented and manual process into a powerful, data-driven capability. 

Today, the client operates with greater efficiency, accuracy, and visibility, setting a new standard for enterprise reporting and supplier diversity management in the rental car industry.