By Zain Tareen
Founder, CEO & Managing Partner, Acgile
The $2.3M Recovery:
Rebuilding a US Manufacturer's Accounting & EDI from Scratch
How Acgile took a US consumer goods manufacturer from multi-year reconciliation backlogs to a repeatable monthly close, and built the EDI, inventory, and dispute defense capabilities that defended over $668K in directly tracked revenue and an implied $2.3M across the engagement lifetime.
Industry
Consumer Goods Manufacturing
Systems
NetSuite + TrueCommerce EDI
Engagement
Cleanup + Managed Accounting
Status
Active and ongoing
A US consumer-goods manufacturer carried multi-year reconciliation backlogs across NetSuite, EDI, and dispute defense. Acgile rebuilt all three, closing 3,076 Home Depot disputes, defending roughly $2.3M, and turning a chaotic accounting function into a repeatable monthly close.
Executive Summary
A US-based consumer goods manufacturer engaged Acgile to address an accounting function that had stopped producing reliable financial information. The client operated on NetSuite with multi-tier in-house assemblies, imported finished goods from overseas, shipped to major retail trading partners through TrueCommerce EDI, and depended heavily on third-party invoice factoring to fund operations. Bank accounts, credit cards, customer accounts, vendor accounts, factoring partners, balance sheet schedules, and the income statement itself were all unreconciled, in many cases for multiple years.
Before any work began, Acgile and the client agreed on the most important decision of the engagement: a 1 January 2025 cutoff. Pre-cutoff transactional periods, on which 2024 tax returns had been filed, would not be modified. Everything from that date forward would be brought to a clean state and kept there. Pre-cutoff residual differences were isolated in clearly labeled cleanup accounts on the balance sheet, positioned for resolution by the client's incoming finance leadership.
Within months of the cutoff, the engagement had reconciled all eight bank accounts, all credit card accounts, three factoring and lender relationships, and over $1.09M in open AP across more than 80 vendors. The EDI intake process, which had previously left Monday's 500+ retailer orders unworkable until the following Friday, was rebuilt as an automated overnight pipeline that delivers a clean order book by 6:00 AM Eastern. A Box.com and NetSuite integration turned signed Bills of Lading into a retrievable dispute defense, and over 3,000 Home Depot dispute packages have now been closed with documentation.
The Engagement, In Numbers
$668K+
Revenue defended
Directly defended through Home Depot dispute resolution in the visible 21-month window
~$2.3M
Implied lifetime
Total revenue defended across all 3,076 closed dispute packages
3,076
Disputes closed
Open Invoice POD dispute packages closed with documentation
$1.09M
AP reconciled
Open AP investigated and resolved across 80+ vendors
The 1 January 2025 Cutoff: Why It Mattered
The cutoff was set at 1 January 2025. Bills, expenses, revenue, and cost-of-sales transactions dated before that line were not modified. Tax returns for 2024 had been filed on the historical numbers, and going back into closed and filed periods to restate transactional activity would have created significantly more problems than it solved.
Drawing a clean line in time, however, does not eliminate the past. Vendor and customer balances, bank differences, and accrued purchase imbalances all carry into 2025 whether they are addressed or not. Acgile's solution was a small set of clearly labeled balance sheet accounts that isolate the pre-cutoff residue from the post-cutoff books:
- Vendor Cleanup
- Customer Cleanup
- Accrued Purchases Cleanup
- Bank Accounts Cleanup
- Credit Card Cleanup
These accounts are not a hiding place. They are a labeled, transparent record of what is known to be there and what has not yet been written down. The resolution of those balances (whether through revised returns for 2024 and prior periods, or through write-offs in the current year's income statement) is a decision for the client's leadership and tax advisor. Acgile will proceed as advised. We will not write balances off without authorization.
What We Resolved
The engagement covered 14 distinct problem areas. Each one is summarized in the grid below. Three of them (EDI operations, the inventory and COGS rebuild, and Home Depot dispute defense) are detailed in dedicated companion case studies linked at the end of this page.
Multi-Tier Assembly & In-House Pallet Manufacturing
BOM hierarchy validated; assembly variances reviewed at close
Bank & Credit Card Reconciliation
All 8 banks and all core CCs reconciled and current
Sales Reconciliation Through EDI
810 invoices, 856 ASNs, and 997 acknowledgements tied to retailer statements
EDI Operations & the Monday Morning Problem
500+ orders auto-routed by 6:00 AM Eastern with zero location/carrier errors
Trading Partner Keyrec Dispute Defense
3,076 disputes closed; over $668K directly defended
Vendors & the Purchase Cycle
$1.09M AP investigated; 80+ vendors reconciled or queued for write-off decision
Accrued Purchases Reconciliation
Item receipts matched to warehouse records; bills corrected
Inventory Adjustments & Negative Inventory
Adjustments brought back to controlled, exceptional events; root causes addressed
Inventory Valuation & Retrospective COGS Correction
1 January 2025 cutoff-and-rebuild triggered NetSuite's average-cost recalculation
Expense Misclassification at Scale
Detailed GL review and reclassification; recurring drivers fixed at source
Invoice Factoring & Third-Party Funding
3 funder relationships reconciled; daily Factor A management cycle
Landed Cost on Imported Inventory
Weekly application discipline; monthly reconciliation in place
Multi-Warehouse Inventory (3PL + Self-Owned)
Daily management; reconciled in close across both sites
Balance Sheet Integrity
Prepaids, accrued, fixed assets, loans, equity on documented schedules
From Cleanup to Operating Rhythm
Cleanup is only valuable if the client does not slide back. Acgile's engagement therefore includes the ongoing operating cadence summarized here. This is the structure that prevents the next backlog from forming, and it is what distinguishes a managed accounting engagement from a one-time fix.
Daily
Daily Operational Flow
Customer payments recorded and applied
Inventory managed for fulfillment readiness
Factoring partner receipts and charges reconciled
EDI orders imported, validated, and posted
810 invoices and 856 ASNs transmitted; 997 acknowledgements confirmed
Weekly
Weekly Financial Monitoring
Disputes (RTV, POD) managed
Landed cost applied to received containers
Invoice batches submitted to factoring partner
Monthly
Monthly Financial Control
8 bank accounts and 5 credit cards reconciled
9 retail customer accounts reconciled to retailer statements
Factoring partners and term lenders reconciled
Landed cost reconciled across freight, customs, inventory adjustment
Loan splits, prepaid amortization, expense recategorization
Full month-end review and close
Annual
Annual Compliance & Closure
Full physical inventory count coordinated and reconciled to NetSuite
Year-end close and tax preparation supported with documented schedules
How Acgile Approached the Work
Set the cutoff before doing any work.
The first conversation with the client was about scope. We agreed on a 1 January 2025 cutoff before any cleanup work was contracted, and isolated pre-cutoff residual differences in clearly labeled balance sheet accounts.
Sequence the work by dependency, not by visibility.
Banks and credit cards were prioritized first because they anchor everything else. Customer and factoring reconciliations followed. Vendor reconciliations and landed cost ran in parallel. Balance sheet schedules were built last, on top of clean subledgers.
Use a single tracker as the source of truth.
Every reconciliation, every aged balance, every open question lives in a shared cleanup tracker with priority, status, owner, and decisions needed. The tracker is what allows an engagement of this complexity to remain auditable rather than improvised.
Build the close as you clean.
The cleanup and the monthly close were not run as separate phases. As each area was reconciled, it was added to the close checklist immediately, so the discipline that produced a clean position also kept it clean.
Test in sandbox before touching production.
The 1 January 2025 inventory zero-out, the BOL template rewrite, and changes to scripted workflows all carried real risk. We asked the client to provision a NetSuite sandbox and used it as the proving ground for any change that could disrupt operations or distort the books.
Three Capabilities, Three Companion Stories
The depth behind each of the headline outcomes is captured in three companion case studies. Each one stands alone if you want to skip directly to the capability that matters most to your business.
THE EDI SPECIALIST
Solving the Monday Morning Problem
How we automated 500+ daily orders, eliminated location and carrier errors, and rebuilt the ASN/invoice cycle.
Read the full storyTHE NETSUITE EXPERT
Average Costing Cleanup with the Cutoff-and-Rebuild Method
How we corrected a compromised average-costing engine and made COGS reliable from Day One.
Read the full storyTHE REVENUE DEFENDER
Turning Signed BOLs into Cash with Box.com + NetSuite
How a Box.com integration turned a chaotic dispute resolution problem into 3,076 closed packages and $668K defended.
Read the full storyRelated resources
Keep exploring
Solving the Monday Morning Problem
EDI order intake automated through TrueCommerce and NetSuite, 500+ daily orders routed by 6:00 AM Eastern with zero wrong-location or wrong-carrier errors.
Turning Signed BOLs into Cash with Box.com + NetSuite
3,076 Home Depot keyrec dispute packages closed by integrating Box.com with NetSuite, turning signed BOLs into a real-time documentation defense system.
EDI Maintenance
Seamless, compliant data exchange with your biggest partners.
Financial Cleanup
Turn historical mess into audit-ready financial records.
Want to see what this looks like for your business?
Acgile runs cleanup engagements and ongoing managed accounting for US manufacturers, distributors, and SMBs on NetSuite and QuickBooks. If your books, your EDI, or your dispute defense aren't where they should be, the first conversation is on us.