Acgile Logo
Zain Tareen, Founder, CEO & Managing Partner of Acgile

By

Founder, CEO & Managing Partner, Acgile

Case Study

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

TL;DR

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.

Headline Metrics

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.

Area 01

Multi-Tier Assembly & In-House Pallet Manufacturing

BOM hierarchy validated; assembly variances reviewed at close

Area 02

Bank & Credit Card Reconciliation

All 8 banks and all core CCs reconciled and current

Area 03

Sales Reconciliation Through EDI

810 invoices, 856 ASNs, and 997 acknowledgements tied to retailer statements

Area 04

EDI Operations & the Monday Morning Problem

500+ orders auto-routed by 6:00 AM Eastern with zero location/carrier errors

Area 05

Trading Partner Keyrec Dispute Defense

3,076 disputes closed; over $668K directly defended

Area 06

Vendors & the Purchase Cycle

$1.09M AP investigated; 80+ vendors reconciled or queued for write-off decision

Area 07

Accrued Purchases Reconciliation

Item receipts matched to warehouse records; bills corrected

Area 08

Inventory Adjustments & Negative Inventory

Adjustments brought back to controlled, exceptional events; root causes addressed

Area 09

Inventory Valuation & Retrospective COGS Correction

1 January 2025 cutoff-and-rebuild triggered NetSuite's average-cost recalculation

Area 10

Expense Misclassification at Scale

Detailed GL review and reclassification; recurring drivers fixed at source

Area 11

Invoice Factoring & Third-Party Funding

3 funder relationships reconciled; daily Factor A management cycle

Area 12

Landed Cost on Imported Inventory

Weekly application discipline; monthly reconciliation in place

Area 13

Multi-Warehouse Inventory (3PL + Self-Owned)

Daily management; reconciled in close across both sites

Area 14

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

01

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.

02

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.

03

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.

04

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.

05

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.

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.