Global Retail & E-Commerce Group Flowtaris AI deployment
HomeCase StudiesGlobal Retail & E-Commerce Group
Confidential — AnonymizedRetail / E-CommerceNetSuiteWorkday

84% faster month-end close. $3.2M in recaptured vendor rebates. 8 weeks.

A 450-outlet global retailer with $2.4B in annual revenue compressed its 14-day close cycle to under 3 days and unlocked $3.2M in previously missed vendor rebates using GenAI-powered finance automation.

Q4 2024 8 weeks deployment 9-person team Retail / E-Commerce
Verified Outcomes
2.2 days14 days
Month-End Close Duration84%
28 hrs/mo320 hrs/mo
Manual Reconciliation Time91%
99%61%
Vendor Rebate Capture Rate62%
$3.2M
Recaptured Annual Revenue
28 Entities
Subsidiaries Consolidated
94%
Forecast Accuracy
The Challenge

The Problem: A 14-Day Close and $3.2M Left on the Table Every Year

This 450-outlet retailer had scaled rapidly through acquisition, leaving it with 28 legal entities spread across NetSuite (North America and APAC) and Workday (EMEA). The month-end close was a 14-day ordeal that consumed the entire finance team every month.

The intercompany elimination process alone took 6 days — spreadsheets were emailed between subsidiaries, reconciliation discrepancies were resolved via phone calls, and the consolidated P&L required 3-4 rounds of correction before the CFO would sign off. The accounting team described it as "controlled chaos every month."

But the silent cost was even larger: the company had negotiated volume-based vendor rebates with its top 200 suppliers — agreements worth a combined $5.2M annually at the contracted thresholds. Because rebate qualification calculations were manual and based on monthly-lagged data, the finance team was systematically failing to qualify for 39% of these rebates. $3.2M was being left on the table every year simply because the data wasn't fast enough.

Pain Points at a Glance
  • 14-day month-end close consuming entire finance team every month
  • 6-day intercompany elimination process across 28 entities on two ERP systems
  • $3.2M in vendor rebates missed annually due to slow data and manual calculations
  • 320 person-hours/month spent on manual reconciliation across NetSuite and Workday
  • CFO operating on 2-week-old data for every strategic decision
  • No real-time sales velocity data for inventory and procurement decisions
  • FP&A team unable to produce scenario models without clean close data
  • 12 FTE finance staff in close-crunch mode for half of every working month
Retail finance consolidation dashboard showing 28-entity intercompany elimination
Real-time consolidation dashboard showing intercompany elimination status across all 28 entities. What previously took 6 days now completes in 4 hours.
Implementation Approach

The Solution: Real-Time Intercompany Bridge + Rebate Intelligence Engine

Week 1–2 — ERP Integration Layer

Flowtaris AI deployed real-time integration connectors for both NetSuite (via SuiteQL REST API) and Workday (via Prism Analytics API). A unified financial data model was constructed — every transaction from all 28 entities flowing into a central intelligence layer with currency normalization and entity-level tagging.

  • All 28 entities streaming real-time transaction data within 10 days
  • Automated currency conversion with configurable exchange rate rules
  • Unified chart of accounts mapping across NetSuite and Workday variance eliminated
Week 3–5 — Automated Intercompany Elimination

The 6-day intercompany elimination process was rebuilt as an automated real-time workflow. The AI layer continuously matched intercompany transactions across entities, flagging mismatches in real time rather than at month-end. Elimination journals were auto-generated and posted to the consolidation layer, requiring only a final human sign-off on residual exceptions.

  • Intercompany elimination time reduced from 6 days to under 4 hours
  • Residual exception rate at launch: 1.2% of intercompany volume (vs 8% manually)
  • CFO received first same-day consolidated P&L view in company history
Week 6–8 — Rebate Intelligence Engine

The rebate capture failure was addressed with a dedicated AI module. The Rebate Intelligence Engine ingested all 200 vendor rebate contracts, extracted qualification thresholds and measurement periods, and connected them to real-time purchase volume data. When a subsidiary was within 5% of a rebate threshold, an automated alert was sent to the responsible buyer with a recommendation on how to qualify.

  • $3.2M in rebate qualification gaps identified and systematically recaptured
  • Rebate capture rate improved from 61% to 99% in first full quarter
  • Procurement team now optimizes purchase timing around rebate qualification windows
Conversational finance interface for retail buyer rebate tracking
Retail buyers querying rebate attainment status in real time — enabling procurement decisions optimized for rebate qualification rather than missed by it.
Technical Architecture

Technical Architecture

Real-Time Dual-ERP Consolidation

Live data streaming from NetSuite and Workday into a unified financial model. Currency normalization, chart of accounts mapping, and entity-level tagging applied automatically. Intercompany matching runs continuously — not just at month-end.

Rebate Intelligence Engine

Natural language processing extracts rebate thresholds, qualification periods, and payment terms from vendor contract PDFs. Real-time purchase volume tracking against thresholds with proactive alerts when qualification windows are closing.

Automated Intercompany Journals

Matched intercompany transactions auto-generate elimination journal entries in the consolidation layer. Exceptions routed to the responsible entity controller with pre-populated resolution recommendations.

Close Management Dashboard

Real-time close progress tracking for all 28 entities. CFO sees a single view of which entities are reconciled, which have outstanding items, and projected close completion time — updated every 15 minutes throughout the close.

Verified Results

Verified Results — First Full Quarter Post-Deployment

The first full quarter post-deployment delivered results that exceeded all projected targets. The month-end close compression from 14 days to 2.2 days was the headline outcome — but the $3.2M in recaptured vendor rebates represented an unplanned upside that went directly to gross margin improvement.

The CFO noted in the quarterly review that the quality of financial data had fundamentally changed: "For the first time, I'm making pricing and inventory decisions based on data that's hours old, not weeks old. That's a competitive advantage that doesn't show up in a simple ROI calculation."

Results Summary
  • 84% reduction in month-end close duration — from 14 days to 2.2 days
  • 91% reduction in manual reconciliation effort — 320 hours to 28 hours per month
  • $3.2M in vendor rebates recaptured in first full quarter of deployment
  • Vendor rebate capture rate improved from 61% to 99%
  • CFO receives real-time consolidated P&L updated every 15 minutes
  • All 28 entities consolidated in under 4 hours vs. 6 days previously
  • FP&A scenario modeling cycle reduced from 2 weeks to 2 days
  • 94% cash flow forecast accuracy achieved in first quarter

"We were leaving $3.2M on the table every year and didn't even know it. The rebate intelligence was the surprise — we expected the close compression. What we didn't expect was that real-time data would unlock a completely different way to manage procurement. We now optimize purchase timing around rebate qualification windows. That's a capability we simply didn't have before."

C
CFO
Global Retail & E-Commerce Group
More Case Studies

See More Flowtaris AI Deployments