The Challenge
What appeared to be an accounts payable backlog was actually a web of interconnected failures spanning multiple departments and creating a cascade of financial damage:
The visible problem:
- $6.5 million in annual rebate losses (17% of eligible rebate value)
- Invoice backlog extending 20 months for some vendors
- Suspended vendor accounts due to late payments
- Unallocated credits aging up to 3 years
The hidden crisis:
- 40% of all invoices required manual investigation – over 150 per day for a 3-person AP team
- Three-way matching failures due to technical errors and missing goods receipt data from store managers
- Many “smaller” vendors deprioritized by AP team were subsidiaries of major suppliers, jeopardizing rebate eligibility with parent companies
- No standardized process for managing credit notes, checks, or bank deposits
- Distribution warehouse discarded goods receipt documentation after 60 days – before AP could investigate many discrepancies
- Goods receipt scanning process to shared drive neither monitored nor consistently followed
- New AP staff unaware critical documentation even existed in shared folders
- Both AP and AR teams investigating variances under $0.50 – sometimes just pennies
The compounding costs: Beyond the $6.5M in lost rebates, the company faced:
- Lost business from suspended vendor accounts
- Reduced rebate agreements from vendors frustrated by late payments
- Deteriorating negotiating leverage leading to unfavorable terms
- Systematic write-offs obscuring true P&L at corporate and store levels
- High attrition in AP department due to impossible workload and poor morale
- Expensive staff time wasted investigating trivial discrepancies
For a parts supplier operating on thin margins in a competitive market, these inefficiencies weren’t just costly – they were undermining the company’s entire business model, which depended on volume purchasing power and rebate capture.
Solution Approach
Financial process optimization requires a different lens than operational improvement. The problems here weren’t just about efficiency – they were about system design, cross-functional accountability, and data integrity. A backlog this deep doesn’t develop overnight; it’s a symptom of fundamental process breakdowns.
Discovery and forensic analysis (Weeks 1-6):
- Mapped critical business processes across Store Operations, Accounts Payable, Accounts Receivable, Warehouse Deliveries, and IT/EDI Management
- Conducted interviews with front-line AP/AR staff, store managers, warehouse personnel, and IT to understand actual workflows vs. intended processes
- Created process flow maps exposing where breakdowns occurred and why workarounds had developed
- Performed in-depth data analysis revealing the full financial impact – the client’s initial 17% rebate loss estimate missed:
- Lost business from suspended accounts
- Future rebate reduction from vendor frustration
- Lost negotiating leverage
- P&L impact of systematic write-offs
- Cost of staff time on trivial investigations
- Attrition costs in AP department
Strategic recommendations (Weeks 7-12):
- Categorized findings into themes and prioritized as:
- Low effort “quick wins” for immediate relief
- Medium-effort items requiring business decisions
- High-effort items requiring technology investment
- Developed Tableau dashboards with Business Intelligence team showing:
- Aged open purchase orders by vendor and location
- Unassigned goods receipts
- Unpaid invoices and unallocated credits aging
- Created downloadable tracker for weekly distribution to locations for documentation submission
Pilot and refinement (Weeks 13-16):
- Formed test group of engaged SMEs to pilot recommendations
- Developed standardized process for investigating variances with rapid turnaround requirements
- Enhanced goods receipt scanning and sharing protocols
- Extended retention periods for critical documentation
- Refined solutions based on pilot feedback and developed comprehensive rollout plan
Key Findings and Recommendations
Our investigation revealed systemic issues requiring both immediate intervention and long-term structural changes:
- Backlog clearance and resource reallocation
- Finding: Current invoices were falling into backlog because all resources were fighting old fires
- Recommendation: Obtain executive approval to write off invoice differences over 12 months below threshold; restructure team with 2 staff on current invoices, 1 dedicated to backlog clearance over defined period
- Impact: Stop the bleeding while systematically clearing historical issues
- Technical improvements and process standardization
- Finding: IT/EDI technical issues causing valid invoices to fail three-way matching; no standard variance investigation process
- Recommendation: Fix technical matching failures; implement standardized investigation process with turnaround SLAs; establish comprehensive training for all impacted departments; create performance monitoring to catch deviations
- Impact: Eliminate 30-40% of manual investigations, reduce turnaround time by 60%
- System evaluation and upgrade
- Finding: Company had outgrown current AP system capabilities
- Recommendation: Mid-term evaluation of AP system to support current scale and future growth
- Impact: Foundation for sustainable scaling
- Resource optimization
- Finding: High-cost skilled staff investigating penny discrepancies
- Recommendation: Set investigation thresholds ($50+ variance or percentage-based); redirect staff to high-value activities
- Impact: Estimated 20+ hours weekly freed for strategic financial analysis
- Documentation and accountability
- Finding: Critical documentation discarded before needed; processes not followed or monitored
- Recommendation: Extended retention periods, monitored compliance with scanning protocols, cross-departmental accountability metrics
- Impact: Eliminate investigation roadblocks, improve first-time resolution rate
The Results
Project scope: 4-month consulting engagement delivering analysis, recommendations, and rollout roadmap
Projected impact (within 12 months of full implementation):
Based on pilot results and data analysis, the company positioned itself to achieve:
- 70% reduction in unmatched invoices older than 90 days (from ~600 to ~180 invoices)
- 82% reduction in unclaimed rebates (recovering ~$5.3M of the $6.5M annual loss)
- 50% faster allocation of credit notes (reducing 3-year backlog to current-month processing)
- Tableau reporting providing real-time visibility into aged POs, unassigned receipts, and unallocated credits for the first time
- Improved vendor relationships through payment reliability and professional communication
- AP team morale improvement by creating manageable workload and clear processes
Why projected vs. actual: Our engagement focused on diagnosis, solution design, and pilot testing rather than full implementation. The client retained the rollout roadmap and tools to execute internally. The projected outcomes are based on pilot results extrapolated across the full operation – conservative estimates grounded in actual data.
The company now has:
- Clear visibility into financial process health through automated dashboards
- Documented processes and accountability structures
- Trained team with right-sized workload
- Technology roadmap for sustainable scaling
- Foundation to support growth and potential acquisitions
Project timeline: 4 months from initial engagement to recommendation delivery and pilot completion
Why This Approach Works
Many consultants would have jumped straight to “implement new AP system.” We took a different path.
Financial process problems are often blamed on people (“they’re not working hard enough”) or technology (“the system is outdated”). Usually, the real culprit is process design that sets people up to fail. By mapping actual workflows, quantifying hidden costs, and piloting solutions before full rollout, we proved that modest process changes could recover millions in lost revenue.
The Tableau dashboards alone – a relatively low-effort intervention – gave the company visibility it had never had. You can’t manage what you can’t measure, and they had been flying blind.
The projected 82% rebate recovery ($5.3M annually) would deliver 250X ROI on the consulting engagement in the first year alone – assuming the company executes the rollout plan. That’s why we built extensive pilot testing and comprehensive training into the roadmap. Implementation success requires organizational buy-in, and we structured the recommendations to build momentum through quick wins while tackling systemic issues.