NetSuite Financial Management for Ecommerce CFOs: Beyond QuickBooks

Disclosure: This article may contain affiliate links. We may earn a referral fee at no cost to you.

If you're an ecommerce CFO still running your financials on QuickBooks, you already know the pain. Manual revenue recognition. Consolidated reporting across entities cobbled together in Excel. Month-end close that takes two weeks because your team is chasing down marketplace settlement reports and reconciling Amazon fees by hand. You didn't become a CFO to spend your life in spreadsheets — you did it to drive strategic financial decisions.

NetSuite's financial management module is the core of the entire platform, and for ecommerce CFOs, it represents a fundamental shift in how you run your finance function. Instead of data entry and reconciliation, your team focuses on analysis and strategy. Instead of wondering whether your Amazon channel is actually profitable after all fees, you have real-time visibility. Instead of a two-week close, you're closing in five days — or less.

But the transition is not trivial. Your chart of accounts needs restructuring. Your revenue recognition approach changes. Multi-currency transactions require careful setup. And your team needs to unlearn a decade of QuickBooks habits. This guide covers every financial management decision you'll face during your NetSuite migration, with specific guidance for ecommerce businesses.

Key Takeaways

• Chart of accounts redesign is mandatory during migration — you can't just copy your QuickBooks chart. NetSuite uses a multi-segment approach with subsidiaries, departments, classes, and locations that eliminates the need for hundreds of sub-accounts.
• Multi-currency is native in NetSuite OneWorld, supporting automatic exchange rate updates, unrealized gain/loss tracking, and currency revaluation — critical for brands selling internationally.
• Financial close can be reduced from 2+ weeks to 3-5 days with proper NetSuite configuration, automated reconciliation rules, and scheduled reporting.
• Marketplace fee accounting (Amazon, Walmart, Shopify) requires dedicated GL account structures and integration with settlement report data — this is the #1 area where ecommerce brands misconfigure their NetSuite financials.
• Board-ready reporting is possible with NetSuite's financial report builder, eliminating the "export to Excel, reformat, email to board" cycle that wastes hours every month.
• Intercompany elimination for multi-entity brands is automated in OneWorld, replacing the manual elimination entries that make consolidated reporting a nightmare in QuickBooks.

How Should You Structure Your Chart of Accounts for Ecommerce?

Your QuickBooks chart of accounts is probably a mess. Not because you're bad at accounting — but because QuickBooks forces you to create sub-accounts for every dimension you want to track. Want to see revenue by channel? Create sub-accounts. Revenue by product category? More sub-accounts. Revenue by brand? Even more. You end up with 500+ accounts and reports that take an hour to interpret.

NetSuite uses a fundamentally different approach: multi-segment classification. Instead of sub-accounts, you use dimensions — subsidiaries, departments, classes, and locations — that can be combined on any transaction. Revenue goes to one account (4000 - Product Revenue), and the channel, category, and fulfillment location are tagged as dimensions.

Here's the chart of accounts structure I recommend for ecommerce brands:

Revenue (4000 series):

• 4000 - Product Revenue
• 4010 - Shipping Revenue
• 4020 - Subscription Revenue
• 4050 - Returns & Allowances (contra)
• 4060 - Discounts & Promotions (contra)

Cost of Goods Sold (5000 series):

• 5000 - Product COGS
• 5010 - Shipping & Fulfillment Costs
• 5020 - Packaging Materials
• 5030 - Merchant Processing Fees
• 5100 - Amazon Fees (parent)
  • 5101 - Referral Fees
  • 5102 - FBA Fulfillment Fees
  • 5103 - Storage Fees
  • 5104 - Advertising Fees
  • 5105 - Returns Processing Fees
• 5200 - Shopify Fees
• 5300 - Walmart Marketplace Fees

Classes (dimension, not accounts):

• DTC-Shopify, Amazon-FBA, Amazon-FBM, Walmart, Wholesale, Subscription

Departments (dimension):

• Marketing, Operations, Finance, Product, Customer Service

This structure means one GL account for product revenue, with classes tracking the channel. Your P&L can be run for the total business, or filtered by class to show Amazon-only or DTC-only profitability. No more sub-account proliferation.

Pro tip: Resist the urge to over-segment. I've seen brands create 30 classes for every minor sales channel variation. Start with 5-8 classes that represent genuinely different business units, and add more only when you have a specific reporting need. Every class you add increases the tagging burden on every transaction.

How Do You Handle Marketplace Fee Accounting in NetSuite?

Marketplace fee accounting is the single biggest financial management challenge for multi-channel ecommerce brands, and it's where QuickBooks falls flat. Amazon alone has over 20 different fee types, and they're all deducted from your settlement before you receive payment. If you're not breaking these out in your GL, you have no idea whether your Amazon channel is actually making money.

The settlement report reconciliation process in NetSuite works like this:

Step 1: Settlement integration. Use a tool like A2X, Webgility, or a custom integration to parse Amazon/Shopify/Walmart settlement reports and create summarized journal entries in NetSuite. These entries break out gross revenue, each fee category, refunds, and the net deposit amount.

Step 2: GL mapping. Each fee type maps to a specific GL account. Amazon referral fees go to 5101. FBA fees go to 5102. This mapping is configured once in your integration tool and applied automatically to every settlement period.

Step 3: Bank reconciliation. The net settlement deposit hits your bank account. In NetSuite, this matches against the net amount from the journal entry. If they don't match, you have a reconciliation issue to investigate.

Real-world example: A $25M beauty brand was booking Amazon revenue as the net deposit amount — total revenue minus all fees. Their QuickBooks P&L showed Amazon revenue of $8M. After implementing NetSuite with proper settlement accounting, the picture changed dramatically:

• Gross Amazon Revenue: $12.4M
• Referral Fees: ($1.86M)
• FBA Fulfillment: ($2.1M)
• Storage Fees: ($340K)
• Advertising: ($1.8M)
• Returns/Refunds: ($620K)
• Net Amazon Revenue: $5.68M

The gross-to-net bridge revealed that Amazon advertising was consuming 14.5% of gross revenue — a number the CFO had never seen because it was buried in the net deposit. They restructured their Amazon ad strategy and improved channel profitability by $400K annually.

What Does the Financial Close Process Look Like in NetSuite?

The monthly close in QuickBooks for an ecommerce brand is chaos. You're waiting for marketplace settlements, manually entering bank transactions, creating journal entries for accruals, and praying that your trial balance ties out. Two weeks is typical. Some brands I've worked with took 25 business days.

In NetSuite, a well-configured close process takes 3-5 business days. Here's the calendar:

Day 1 (Business Day 1 after period end):

• Lock the prior period (NetSuite period lock prevents backdated entries)
• Run automated bank feeds and matching rules
• Import final marketplace settlement reports for the period
• Run inventory valuation report and compare to GL balance

Day 2:

• Complete bank reconciliations (NetSuite's auto-matching handles 80-90% of transactions)
• Post accrual journal entries (many can be recurring/automated)
• Run accounts receivable aging and investigate old balances
• Complete accounts payable aging and confirm vendor bills are posted

Day 3:

• Run intercompany elimination entries (automated in OneWorld)
• Complete multi-currency revaluation (automated in OneWorld)
• Run trial balance and investigate any unusual variances
• Generate preliminary financial statements

Day 4-5:

• CFO review of financial statements
• Variance analysis vs. budget and prior period
• Finalize and distribute reports to leadership/board
• Lock the period permanently

Key automation that speeds up close:

• Automated bank matching rules: NetSuite learns your transaction patterns and auto-matches bank deposits to invoices, settlement entries, and other sources.
• Recurring journal entries: Rent, insurance, subscription software — all created automatically each month.
• Memorized transactions: Standing POs, recurring vendor bills, standard accruals.
• Period close checklist: NetSuite has a built-in task list that tracks close steps, assignees, and completion status.

Pro tip: Start tracking your "days to close" metric from month one on NetSuite. Set a target of 5 business days and work toward it. The first 2-3 months will be slower as your team learns, but by month 6, you should be hitting your target consistently. I've seen brands get to a 3-day close within a year of go-live.

How Does Multi-Currency Work for International Ecommerce?

If you sell internationally — and most growing ecommerce brands do — multi-currency support is non-negotiable. QuickBooks Online has basic multi-currency that works for simple transactions, but it falls apart when you need currency revaluation, intercompany transfers between entities in different countries, or consolidated reporting in your home currency.

NetSuite OneWorld handles multi-currency comprehensively:

Transaction currency: Each transaction (sales order, purchase order, invoice) can be in any enabled currency. When a UK customer orders on your Shopify UK store, the sales order is created in GBP. NetSuite converts it to your base currency (USD) at the exchange rate on the transaction date.

Automatic exchange rate updates: NetSuite pulls daily exchange rates from a configurable provider. No more manually looking up rates. You can also set a rate source — daily rate, monthly average, or a fixed rate for specific transactions.

Unrealized gain/loss: As exchange rates fluctuate between the transaction date and payment date, NetSuite tracks unrealized gains and losses. When the payment is received, the unrealized gain/loss is reversed and a realized gain/loss is recorded. This happens automatically.

Currency revaluation: At month-end, NetSuite revalues all open foreign currency balances (receivables, payables, bank accounts) to the closing exchange rate. The revaluation entries are created automatically when you run the revaluation process.

Consolidated reporting: If you have separate subsidiaries (US, UK, EU), OneWorld consolidates financial statements in your reporting currency, applying the correct exchange rates for income statement (average rate) and balance sheet (closing rate) items.

Ecommerce-specific consideration: Shopify multi-currency payments present a wrinkle. When Shopify Payments processes a GBP transaction, Shopify converts it to USD before depositing to your bank. The exchange rate Shopify uses differs from the rate NetSuite uses on the transaction date. This creates an FX variance that needs to be captured. Your integration should identify and book these FX differences to an exchange gain/loss account.

What KPIs and Reports Should an Ecommerce CFO Track in NetSuite?

NetSuite's reporting engine is significantly more powerful than QuickBooks, but with power comes complexity. Here are the financial KPIs I recommend every ecommerce CFO configure as dashboard portlets:

Profitability KPIs:

• Gross margin by channel: Product revenue minus COGS minus channel-specific fees. Filtered by class (DTC, Amazon, Wholesale). This is the single most important metric for an ecommerce CFO.
• Contribution margin by SKU: Gross margin minus variable costs (pick/pack, shipping, returns) at the SKU level. Identifies which products actually make money after all variable costs.
• Customer acquisition cost (CAC) by channel: Marketing spend divided by new customers acquired. Requires integration with your ad platforms or manual entry.
• Customer lifetime value (LTV): Total gross margin from a customer over their lifetime. NetSuite's CRM data plus financial data makes this calculable.

Cash Flow KPIs:

• Cash conversion cycle: Days inventory outstanding + Days sales outstanding - Days payable outstanding. For ecommerce, DIO is the critical component — how long does inventory sit before it sells?
• Working capital ratio: Current assets / Current liabilities. Should be monitored weekly, not just monthly.
• Free cash flow: Operating cash flow minus capital expenditures. The board wants to see this trending positive.

Operational Finance KPIs:

• Inventory turns by category: COGS / Average inventory value. Should be calculated by product category, not just total. Supplements might turn 8x while seasonal items turn 3x.
• Return rate by channel and category: Returns as a percentage of gross revenue. Amazon typically runs 15-25% for apparel; if yours is higher, you have a product or listing quality problem.
• Effective tax rate: Particularly important as you expand into new states/countries and sales tax obligations change.

Board reporting template: Create a saved financial report in NetSuite that includes a P&L, balance sheet, cash flow statement, and KPI dashboard — all with prior period and budget comparisons. Schedule it to generate automatically on Day 5 of your close. Export to PDF and send to your board. The entire process takes minutes, not the hours you spend reformatting Excel exports from QuickBooks.

How Do You Handle Multi-Entity Consolidation for Ecommerce Groups?

Many ecommerce brands operate multiple entities — a US LLC for domestic sales, a UK Ltd for European sales, and maybe a holding company. In QuickBooks, consolidating these for board reporting or investor updates means exporting each entity's financials to Excel, manually converting currencies, creating elimination entries for intercompany transactions, and building a consolidated view. It's error-prone and time-consuming.

NetSuite OneWorld automates this:

Subsidiary setup: Each entity is a subsidiary in OneWorld with its own base currency, chart of accounts (or shared chart), and tax configuration. Transactions are entered at the subsidiary level.

Intercompany transactions: When your US entity sells inventory to your UK entity, NetSuite creates linked intercompany journal entries in both subsidiaries. The markup, transfer price, and currency conversion are all handled systematically.

Elimination entries: At consolidation, intercompany receivables, payables, revenue, and expenses are automatically eliminated. You don't create manual elimination journal entries — OneWorld generates them based on your intercompany transaction rules.

Consolidated financial statements: One click generates a consolidated P&L, balance sheet, or cash flow statement across all subsidiaries, in your reporting currency, with all intercompany transactions eliminated. Drill down into any line item to see the subsidiary-level detail.

For ecommerce brands considering international expansion, plan for OneWorld from the start. Retrofitting a single-entity NetSuite instance to OneWorld is possible but painful — it's essentially a re-implementation. If you're currently US-only but plan to launch in the UK or EU within 2 years, invest in OneWorld upfront.

FAQ

How long does it take to migrate financials from QuickBooks to NetSuite? Typically 3-6 months for the full implementation, but the financial migration specifically (chart of accounts mapping, opening balances, historical data) takes 4-6 weeks within that timeline. Most brands migrate 2-3 years of historical data for comparison reporting. You'll need a clean trial balance from QuickBooks as of your go-live date, which becomes your opening balance in NetSuite.

Can NetSuite handle sales tax for ecommerce? NetSuite has a basic sales tax engine, but for ecommerce brands with nexus in multiple states (which is most brands post-Wayfair), I strongly recommend integrating with Avalara or Vertex. These tax engines handle the complexity of product taxability rules, state/local rate lookups, and filing — which NetSuite's native tax engine does not do well. Budget $300-$500/month for Avalara depending on transaction volume.

Should we keep QuickBooks running in parallel during the transition? Yes, for at least one full month-end close cycle, preferably two. Run both systems in parallel so you can compare financial statements and catch any configuration issues in NetSuite. This is painful — your team is doing double the work — but it's essential for validating accuracy. I've never had a client regret running parallel; I've had several regret not doing it.

What's the biggest financial reporting mistake ecommerce brands make in NetSuite? Not using classes to track channel profitability. Too many brands set up NetSuite with a basic chart of accounts and no dimensional reporting, then realize six months later that they can't tell whether Amazon is profitable. Retroactively tagging historical transactions with classes is tedious and error-prone. Set up your class structure (DTC, Amazon, Wholesale, etc.) before entering a single transaction.

How does NetSuite handle accrual vs. cash basis reporting? NetSuite is fundamentally an accrual-basis system. Revenue is recognized when earned (invoice/fulfillment), expenses when incurred (vendor bill). You can generate cash-basis reports using NetSuite's cash basis reporting feature, which recalculates your P&L based on cash receipts and disbursements. This is useful for tax reporting if your entity uses cash basis, but your primary financial management should be accrual-based.

---

Not sure if NetSuite is the right fit? Take our free ERP readiness assessment to find out.