Manufacturers and importers are operating in a very different environment than they were even a few years ago. Volatility has become the norm, not the exception. Costs fluctuate rapidly, supply chains are under constant pressure, and margin errors that once went unnoticed can now threaten profitability. In this environment, the limits of legacy systems and spreadsheet-driven processes are becoming impossible to ignore.
Two areas, in particular, are driving this reckoning: understanding the true cost of goods sold and maintaining reliable visibility into cash flow as conditions change.
The Hidden Risk in Cost of Goods Sold and Cash Flow
For import-heavy businesses, tariffs, freight costs, and currency movements have dramatically increased the complexity of calculating true product costs. When these costs are not accurately allocated down to the unit, case, or batch level, finance teams are forced to rely on estimates. Those estimates don’t just distort margin analysis, they directly impact cash flow planning.
When costs are understated or delayed in reporting, pricing decisions lag reality, working capital requirements are misjudged, and cash shortfalls appear “unexpected.” In reality, the warning signs were there, just buried in disconnected systems or spreadsheets that couldn’t keep up with the pace of change.
Manufacturers face similar challenges on the production side. Without batch-level visibility into inputs, yields, waste, and rework, cost assumptions drift over time. Small inaccuracies compound, leading to forecasts that look stable on paper but break down when actual cash movements hit the bank account.
Accurate cost data is not just about profitability; it is foundational to forecasting cash flow with confidence.
Why Cash Flow Forecasting Breaks Down Without ERP Integration
Many finance teams attempt to forecast cash flow using spreadsheets that sit outside their ERP system. While this may work temporarily, it quickly becomes unsustainable as transaction volume grows and complexity increases.
Disconnected forecasts rely on manual updates, delayed data, and assumptions that grow stale almost immediately. Accounts receivable timing, accounts payable schedules, inventory purchases, and production runs all change faster than spreadsheets can be updated. The result is a forecast that feels precise but lacks credibility.
Integrated cash flow forecasting changes this dynamic. When forecasts are directly connected to ERP data, such as open invoices, bills, purchase orders, inventory receipts, and production plans, finance teams can see how operational decisions translate into cash movements in near real time. This allows teams to:
- Model the cash impact of cost changes, tariffs, or supplier price increases
- Stress-test scenarios such as delayed customer payments or higher-than-expected inventory purchases
- Align operational planning with actual liquidity constraints
- Provide management with forward-looking insight instead of backward-looking explanations
Rather than asking “why did cash miss the forecast,” teams can proactively answer “what happens to cash if this changes.”
The Spreadsheet Illusion of Control
Spreadsheets remain deeply embedded in finance and operations teams because they feel flexible and familiar. Over time, however, many organizations build increasingly complex spreadsheet ecosystems with dozens of tabs, fragile formulas, and manual rollups that are difficult to maintain and nearly impossible to scale.
These spreadsheets often create a false sense of control. Teams see large volumes of data and assume they are well-informed, even as errors, outdated assumptions, and manual workarounds quietly undermine accuracy.
When cash flow forecasting lives in these spreadsheets, the risks multiply. A single broken formula or missed update can materially change projected liquidity, often without anyone noticing until it is too late.
Modern systems replace this fragility with structured processes, shared visibility, and automation, reducing dependency on individual spreadsheet “experts” and enabling forecasts the entire team can trust.
Granularity Is Where Margins and Cash Are Won or Lost
As organizations grow, financial reporting often moves further away from the operational detail where real decisions are made. Yet margins and cash performance are shaped by granular factors: batch yields, spoilage, returns, rebates, freight variances, and production inefficiencies.
When these details are captured directly in the ERP and reflected in integrated forecasts, finance teams gain a powerful advantage. They can see not just what happened, but what is likely to happen next and why.
Granular data enables more accurate short-term and medium-term cash flow forecasting, allowing teams to plan funding needs, manage working capital, and avoid reactive decision-making.
Automation Turns Data into Action
Automation plays a critical role in making ERP and forecasting systems usable at scale. Manual data entry, spreadsheet uploads, and reconciliation work consume time without adding insight. Automation reduces this burden by:
- Automatically capturing transactions from operational systems
- Applying business rules consistently across data
- Updating forecasts as underlying data changes
- Flagging exceptions, variances, or emerging risks
This frees finance teams to focus on analysis, scenario modeling, and strategic guidance rather than data wrangling.
Automation also improves consistency. When processes are standardized and repeatable, forecasts become more reliable, reporting cycles shorten, and leadership gains confidence in the numbers.
Change Management Is the Real Work
Even when leadership understands the value of better forecasting, ERP integration, and automation, adoption is rarely smooth. Change management is often the largest challenge, not the technology itself.
Employees worry about how automation will affect their roles. Long-standing processes feel safe, even when they are inefficient. Successful transformations recognize that change takes time, communication, and training. They also accept that not everyone will make the transition, and that modernizing teams often requires new skills and perspectives.
The payoff is significant. Cloud-based ERPs and integrated forecasting tools eliminate the need for periodic system overhauls and support continuous improvement through regular updates and new capabilities.
From Static Systems to Adaptive Financial Planning
Modern finance teams are moving away from static reporting and toward adaptive planning. Instead of building one forecast and hoping it holds, they continuously model scenarios, test assumptions, and adjust plans as conditions change.
ERP integration ensures forecasts are grounded in operational reality. Automation ensures those forecasts stay current. Cash flow forecasting ties everything together, translating complexity into clarity for leadership.
In an environment defined by uncertainty, this combination is no longer a luxury. It is the foundation for resilience.
The Cost of Standing Still
Many organizations know their systems are outdated but hesitate to invest in change. As legacy platforms approach end-of-life and competitive pressure increases, standing still becomes increasingly expensive.
Companies that modernize gain sharper cost visibility, stronger cash control, and faster decision-making. Those that don’t risk being surprised by problems they could have seen coming.
For manufacturers and importers navigating today’s volatility, the question is no longer whether to modernize, but how quickly they can move from spreadsheet-driven guesswork to integrated, automated, cash-aware decision-making.
Learn More with FinFactor
In this episode of FinFactor, Blaine Bertsch sits down with Jim Harris of Western Computer to uncover the biggest operational and financial challenges facing manufacturers and importers today—especially those still relying on outdated ERPs and massive, error-prone spreadsheets. Jim breaks down why inaccurate COGS, tariff miscalculations, batch-level blind spots, and legacy processes quietly destroy margins, and how a properly implemented ERP can completely transform visibility and control.
They also dive into change management, the realities of ERP timelines, why Excel is the “shared enemy” of scalable finance teams, and how AI is rapidly reinventing supply chain and financial operations. If your business is feeling the pressure of volatility, rising costs, or outdated systems, this is your roadmap to modernization.
________
Dryrun delivers real-time, dynamic cash flow and financial forecasts with complete manual control and unlimited scenario modeling.
START YOUR TRIAL today!