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-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.
$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 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:
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.
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.
BOM hierarchy validated; assembly variances reviewed at close
All 8 banks and all core CCs reconciled and current
810 invoices, 856 ASNs, and 997 acknowledgements tied to retailer statements
500+ orders auto-routed by 6:00 AM Eastern with zero location/carrier errors
3,076 disputes closed; over $668K directly defended
$1.09M AP investigated; 80+ vendors reconciled or queued for write-off decision
Item receipts matched to warehouse records; bills corrected
Adjustments brought back to controlled, exceptional events; root causes addressed
1 January 2025 cutoff-and-rebuild triggered NetSuite's average-cost recalculation
Detailed GL review and reclassification; recurring drivers fixed at source
3 funder relationships reconciled; daily Factor A management cycle
Weekly application discipline; monthly reconciliation in place
Daily management; reconciled in close across both sites
Prepaids, accrued, fixed assets, loans, equity on documented schedules
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
Weekly
Monthly
Annual
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.
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.
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.
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.
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.
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
How we automated 500+ daily orders, eliminated location and carrier errors, and rebuilt the ASN/invoice cycle.
Read the full storyTHE NETSUITE EXPERT
How we corrected a compromised average-costing engine and made COGS reliable from Day One.
Read the full storyTHE REVENUE DEFENDER
How a Box.com integration turned a chaotic dispute resolution problem into 3,076 closed packages and $668K defended.
Read the full storyAcgile 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.