It’s the Wednesday after WD3. You’ve walked past the FC’s desk for the third time today. She’s still got NetSuite open in one window, Excel in another, and a coffee that went cold around 4pm.

You ask how it’s going.

“Good, just rebuilding the OPEX pack.”

Rebuilding.

The pack she rebuilt last month. And the month before. And every month for the last four years. Since the day your business signed the NetSuite contract, in fact. The contract that came with a slide deck claiming “real-time financial visibility” and “single source of truth.”

Lol.

Let me tell you what’s actually happening on her screen.

She runs the consolidated P&L. She hits Export. Excel throws a security warning about the XML Spreadsheet 2003 format, because it’s 2026 and NetSuite is still serving up a file format from when George W. Bush was in office. She clicks through. She reformats columns. She rebuilds subtotals. She pastes into last month’s pack template. She starts checking numbers.

Then someone posts a late journal entry.

She does it all again.

This is not a workflow anyone designed. This is a workaround that calcified into process. And there is one of these in every NetSuite-implemented finance team I have ever seen.

“Just train her on the report builder”

Every CFO has, at some point, said the words: “Surely we can get this out of NetSuite directly?”

You bring in the NetSuite admin. You bring in the implementation partner. You spend $40K on a “reporting optimization” engagement.

Six weeks later you are back where you started. Why?

Because the FCs aren’t dumb. They knew about the report builder. They knew about saved searches. They knew about Financial Report Builder. They tried all of it. They went back to Excel because the export-rebuild cycle is faster than fighting the native tools.

That should make you uncomfortable. It means the problem is not your team.

It is the tool.

Why this is structural, not configuration

NetSuite serves more than 40,000 customers across 219 countries, with the bulk of them sitting in the 100-249 employee range (Anchor Group, 2025). Mid-market.

Mid-market FCs need very specific things from their reporting layer. Board packs. Lender covenant calcs. Departmental P&Ls with custom KPIs. Investor updates. Budget-vs-actual with commentary. The kind of output a board chair will actually look at.

The native NetSuite report builder was not built for any of that.

I’ll let NetSuite consultancy Coras Consulting (2025) say it for me: “the system cannot automatically generate a complete monthly reporting pack without external tools.”

Translation: even the consultants who make a living configuring this thing admit it can’t do the job. (Same dynamic plays out across other ERPs and tools like QuickBooks, by the way. NetSuite is just where the problem is most expensive.)

You can’t group accounts outside your COA structure without workarounds. You can’t blend financial and non-financial data in one view. You can’t produce presentation-quality formatting that won’t embarrass your CFO in front of the board. Want a Web Query connection to Excel or Power BI? Available for transactional data. Not available for financial reports. The single feature that would bridge NetSuite to a usable reporting front end is missing exactly where the problem lives.

These aren’t bugs. These are architectural decisions baked in a decade ago.

The real cost

Let me put a number on this.

Each export-rebuild cycle is 10-15 minutes per report. Sounds like nothing. Now count the reports in a typical month-end pack.

Consolidated P&L. Balance sheet. Cash flow. Departmental breakdowns (multiply by however many cost centers you have). Budget-vs-actual at total and department level. KPI summary. Cash position. Headcount. Top customers. Top vendors. Aged debtors. Aged creditors.

Twelve, fifteen, twenty reports. Each a 10-15 minute export-rebuild. Each vulnerable to version drift.

Finance pros burn up to 25% of their time on manual data extraction and prep (Zone & Co, 2025), and half of finance teams take six business days or more to close their books (Ledge, 2025). A quarter of one of your most expensive employees is being torched on work a machine should be doing.

Then the late journal lands and you do it all again.

This is the real cost of manual reporting, and most CFOs run it without ever measuring it.

The bit nobody talks about: governance

Here’s the part that should give every CFO of an audited company a cold sweat.

The moment a NetSuite report leaves the system as an export, it exits NetSuite’s security model. No access controls. No audit trail. No version log.

Five stakeholders ask for the same report at five different times in the close cycle. They get five Excel files. Different cuts. Different timestamps. Different numbers.

Which one did the board actually review? Which one did the auditor sign off on? Which one is “the truth”?

I’ve sat in audit committee meetings where this exact question landed and nobody could answer it. Just a long silence and an FC suddenly searching her downloads folder.

96% of FP&A teams use spreadsheets daily (Association for Financial Professionals [AFP], 2025), not because they prefer it, but because native ERP reporting doesn’t meet the bar. For a private company that’s a process problem. For a listed company, it’s a continuous disclosure problem dressed up as one.

The “have you tried a saved search?” answer

Whenever I raise NetSuite reporting limitations with an admin, the first response is always the same: “have you tried a saved search?”

Yes. Everyone has tried a saved search. Saved searches are great for transactional data. They fall over fast on financial reporting.

Period comparisons need scripting. Budget overlays need scripting. Hierarchical account groupings need scripting. Large datasets hit the 5,000-row CSV export ceiling or time out completely. Building a complete financial picture means stitching together multiple saved searches by hand. Which is just the spreadsheet problem in a NetSuite skin.

The saved search is the ERP equivalent of “have you tried turning it off and on again.” Costs nothing to suggest. Almost never solves anything.

“Well, finance is cross-functional”

Yes. Finance is cross-functional. And 56% of teams cite cross-departmental dependencies as a close blocker (Ledge, 2025). Worth understanding how to structure dimensional variance analysis across departments to address this.

But the real reason your OPEX variance commentary is so thin is not because Sales and Ops are slow. It’s because pulling a single coherent view across NetSuite GL, AP, AR, and the CRM module requires either custom development or external tools. Your FC has spent the close cycle being the integration layer herself.

When “why did OPEX increase 12%” lands in the board meeting, the answer lives across three NetSuite modules and two spreadsheets that someone manually reconciled last Tuesday. By the time it’s pulled together, the conversation has moved on.

What actually fixes this

There are two real categories of fix. Stop wishing for a third.

1) Live data layers. Tools like Zone & Co’s Solution 7 (and a handful of others) create a two-way live sync between NetSuite and Excel. Your FC keeps her spreadsheet workflow, but the data is live. No more export. No more rebuild. Refresh the file, the numbers are current. Cube and Planful do something similar with a more structured planning layer on top. These are not bad answers. They eliminate the mechanical work without forcing your team to learn a new front-end.

2) AI agents that draft the work. Newer model. Tools like Planir connect to NetSuite, look at the data, and draft the financial sections of your board pack, variance analysis, and budget-vs-actual directly. The FC stops being the assembler and becomes the editor. She reviews the AI’s draft, overrides where business context demands it, and writes the strategic narrative on top. Every number traces back to source data through an auditable pipeline, which closes the governance gap that AI in financial reporting was supposed to introduce but actually fixes when implemented properly.

The dividing line: live data layers automate the export. AI agents automate the analysis. Both beat what you have. The right one depends on whether your bottleneck is mechanical work or analytical capacity. (Reporting automation vs the Excel-first approach covers the trade-off in more depth.)

What is not on this list: “more NetSuite training.” “A better admin.” “A new report bundle from your implementation partner.” “Move it to Power BI.” All of these have been tried. None of them have closed the gap.

How to know if you have this problem

Three questions. Be honest.

How many hours per month does your FC spend on mechanical reporting work? Exporting, reformatting, reconciling, version-managing. Most CFOs underestimate by 50% because the work is distributed across many small tasks. Sit with your FC for one close and clock it.

How many versions of the truth exist at any one time? Count the Excel files generated during your last close. If it’s more than one per report, you have a version-control problem that grows every cycle.

What percentage of your close is automated? If it’s under 40%, you’re in the majority. You’re also leaving days of FC capacity on the table every month. The 18% of teams hitting a three-day close (Ledge, 2025) didn’t find a secret NetSuite setting. They layered something on top. Our guide on cutting your close from 6 days to 3 walks through the specifics.

The bottom line

NetSuite is a fine ERP. It is also a structurally limited reporting platform. Those two things are allowed to be true at the same time, and pretending otherwise has cost the mid-market a decade of finance team productivity.

Telling your team to “use it better” is the same thing as telling them to drive nails with a screwdriver more efficiently. The tool is wrong for the job. They are doing what every other FC in your peer group is doing: routing around it.

Your FC is not the problem. The export button is the problem.

Stop treating it as the final step in your reporting workflow.

Start treating it as the symptom of a workflow that needs fixing.

Because the next time you walk past her desk at 9pm and she’s “just rebuilding the OPEX pack,” that one is on you.

References

Anchor Group. (2025). NetSuite customer base and market segmentation analysis. Anchor Group Consulting.

Association for Financial Professionals. (2025). 2025 AFP FP&A benchmarking survey: Technology and spreadsheet usage. AFP.

Coras Consulting. (2025). NetSuite financial reporting: Limitations and workarounds for mid-market finance teams. Coras Consulting.

Ledge. (2025). The 2025 financial close benchmark report. Ledge.

Zone & Co. (2025). The state of NetSuite reporting: Manual work in mid-market finance teams. Zone & Co.