This page may contain affiliate links. If you click through and make a purchase or sign up for a service, we may earn a commission at no additional cost to you. This supports our ability to provide free, high-quality content. We only recommend solutions we genuinely believe in.

The Controller's NetSuite Playbook: Close Process, Reconciliation Workflows, and Compliance Controls for Ecommerce

If you're a controller stepping into a NetSuite environment—or trying to bring order to an implementation that was set up by someone who didn't understand month-end close—this playbook is for you. Your job is to make the numbers accurate, timely, and audit-ready. NetSuite gives you the tools to do that faster than any mid-market ERP, but only if the workflows are designed around a controller's actual daily reality.

This isn't a generic "how to use NetSuite" guide. It's a field-tested playbook covering close process optimization, reconciliation workflows, daily task management, and the compliance controls that keep auditors satisfied and executives confident in the numbers.

Key Takeaways

• A well-configured NetSuite close process reduces month-end from 15 days to 5-7 days for most ecommerce businesses
• Build 12 essential saved searches that automate your reconciliation checkpoints
• Implement daily, weekly, and monthly task calendars to prevent the "everything at month-end" crunch
• Set up three layers of controls: transaction-level approvals, period management, and reconciliation documentation
• Automate bank reconciliation using NetSuite's matching rules—manual matching wastes 10+ hours monthly
• Use custom records to track close tasks so nothing falls through the cracks

How Do You Optimize the Month-End Close Process in NetSuite?

The typical ecommerce company on QuickBooks closes in 12-18 business days. On a properly configured NetSuite instance, you should close in 5-7 business days. The difference isn't just speed—it's about distributing work throughout the month instead of cramming everything into the first two weeks.

Day 1-2: Revenue and Cash Reconciliation. Reconcile all payment processor deposits (Shopify Payments, Stripe, PayPal, Amazon) against bank statements. NetSuite's bank reconciliation feature matches transactions automatically using rules you define. For a company processing 10,000+ orders monthly, automated matching saves 8-12 hours compared to manual matching.

Run your channel revenue reconciliation: compare NetSuite sales order totals to Shopify reports, Amazon settlement reports, and wholesale invoices. Discrepancies here usually indicate integration errors (missing orders, duplicate imports, or timing differences). Create a saved search that flags orders in Shopify that don't have corresponding NetSuite records.

Day 2-3: Inventory and COGS. Run a perpetual inventory valuation report and compare it to your 3PL or warehouse system. For average costing, check that your average cost per unit hasn't drifted due to PO receipt errors. For FIFO or LIFO, verify the cost layer calculations.

Accrue for inventory in transit: goods shipped from your vendor but not yet received. Many controllers miss this, understating inventory and COGS simultaneously. Create a saved search for POs with a "shipped" status from the vendor but no item receipt in NetSuite.

Day 3-4: Accruals and Prepaid Expenses. Accrue for: ad spend invoices not yet received (estimate from platform dashboards), 3PL invoices in process, professional services, and any performance-based compensation. Reverse the prior month's accruals first, then book fresh ones.

Process prepaid expense amortization schedules: annual software licenses, prepaid insurance, prepaid marketing commitments. NetSuite's amortization schedule feature automates this if you set it up on the original vendor bill.

Day 4-5: Review and Adjustments. Run a trial balance comparison (current month vs. prior month) and investigate any account with a variance greater than 10% or $5K. Post final adjusting entries. Run your financial statements one more time. Lock the period.

Day 5-7: Reporting Package. Generate the board reporting package: P&L (actual vs. budget vs. prior year), balance sheet, cash flow statement, and KPI dashboard. In NetSuite, build these as financial report layouts that auto-populate each month. Your CFO shouldn't wait for you to build a slide deck—they should be able to log into NetSuite and see the numbers.

What Saved Searches Does Every Controller Need?

Saved searches are the controller's Swiss Army knife in NetSuite. They replace the spreadsheets, pivot tables, and manual queries you relied on in QuickBooks. Here are the 12 essential saved searches:

1. Undeposited Funds Reconciliation. Shows all payments received but not yet deposited. If this balance grows month over month, you have a deposit matching problem.

2. Open AP Aging by Vendor. Standard aging buckets (current, 30, 60, 90+) with vendor payment terms displayed. Use this for cash flow planning and vendor communication.

3. Revenue by Channel and Month. Trend analysis search that shows revenue across all channels for the trailing 12 months. Export to Excel for board presentations.

4. COGS Variance Analysis. Compares expected COGS (based on standard or average cost) to actual COGS posted. Variances indicate pricing errors, cost updates, or inventory adjustment issues.

5. Unapplied Customer Payments. Finds customer payments that haven't been applied to invoices. These distort your AR aging and need to be resolved before close.

6. Unmatched Bank Transactions. Shows imported bank feed transactions that haven't been matched to NetSuite records. These need to be identified and recorded before reconciliation is complete.

7. Intercompany Balance Reconciliation. If you have multiple subsidiaries (US entity, international entity), this search shows intercompany balances that should net to zero.

8. Duplicate Vendor Bill Detection. Searches for vendor bills with the same vendor, amount, and date within a 7-day window. Duplicate payments are surprisingly common in high-volume ecommerce.

9. GL Account Balance Summary. Month-end balance for every GL account, useful for building your trial balance and variance analysis.

10. Open Purchase Order Commitment. All POs with open line items, showing committed but unreceived amounts. Critical for cash flow forecasting.

11. Credit Memo and Refund Tracking. All credit memos and customer refunds by period, with reason codes. This is your returns analysis and shrinkage monitoring tool.

12. Fixed Asset Depreciation Schedule. Monthly depreciation by asset class. Most ecommerce companies have minimal fixed assets, but warehouse equipment, office buildout, and capitalized software development costs need tracking.

What Does a Controller's Daily, Weekly, and Monthly Task Calendar Look Like?

The biggest mistake controllers make is treating close as a monthly event rather than a continuous process. Here's the task calendar that prevents month-end chaos:

Daily Tasks (15-20 minutes)

• Review bank feed imports and match transactions
• Check payment processor deposits against expected amounts
• Review and approve vendor bills in the approval queue
• Scan the error log for failed integrations (Shopify sync, Amazon feed, 3PL)
• Quick check on cash position across all bank accounts

Weekly Tasks (1-2 hours)

• Monday: Review open AR aging and follow up on overdue accounts
• Tuesday: Reconcile payment processor statements for the prior week
• Wednesday: Review inventory adjustment journal entries from warehouse
• Thursday: Check payroll accruals and contractor invoice status
• Friday: Run a flash P&L and compare to weekly targets

Monthly Tasks (Close Calendar)

Day	Task	Owner	Dependency
1	Import final bank feed, start bank reconciliation	Controller	Bank data available
1	Reconcile all payment processors	Staff Accountant	Settlement reports
2	Complete bank reconciliation	Controller	Day 1 tasks
2	Reconcile inventory to 3PL/WMS	Staff Accountant	Inventory count
3	Post accruals (marketing, services, payroll)	Controller	Vendor confirmations
3	Process prepaid amortization	Staff Accountant	None
4	Post intercompany entries (if applicable)	Controller	Sub close
4	Run trial balance, investigate variances	Controller	All entries posted
5	Final adjustments, generate financial statements	Controller	Variance review
5	Lock period, distribute reporting package	Controller	CFO review

How Do You Implement Compliance Controls in NetSuite?

Compliance isn't just about surviving audits. It's about building trust in the numbers so that every decision made from financial data is based on accurate information. Here are the three layers of controls every ecommerce controller should implement:

Layer 1: Transaction-Level Controls

Approval workflows for vendor bills. Any vendor bill over $2,500 requires manager approval. Bills over $10,000 require CFO approval. NetSuite's SuiteFlow workflow engine handles this automatically—the approver receives an email with the bill attached and can approve from their phone.

Journal entry restrictions. Require supporting memo and document attachment for all manual journal entries. Restrict journal entry creation to the controller and CFO roles only. Staff accountants should enter transactions through proper transaction types (vendor bills, customer payments, etc.), not journal entries.

Segregation of duties. The person creating vendor records should not be the same person approving payments. The person entering sales orders should not be the same person processing refunds. Map your team's roles to NetSuite permission levels and eliminate conflicts.

Layer 2: Period Management

Lock periods immediately after close. Once the CFO has reviewed and approved the financials, lock the period. This prevents accidental or unauthorized postings to closed periods. NetSuite's period close checklist feature lets you define the tasks that must be completed before a period can be locked.

Use adjustment periods. When you discover a prior-period error, book the correction in the current period with a clear memo explaining the adjustment. If the error is material, discuss with your auditor before posting. NetSuite allows adjustment periods that are separate from regular operating periods.

Year-end procedures. NetSuite's year-end close process is less dramatic than QuickBooks because NetSuite maintains perpetual books. However, you still need to review your annual close checklist: verify depreciation totals, confirm tax provision entries, reconcile all balance sheet accounts, and generate audit schedules.

Layer 3: Reconciliation and Documentation

Monthly account reconciliation. Every balance sheet account should be reconciled monthly. For ecommerce companies, the critical accounts are: cash (all bank accounts), accounts receivable, inventory, prepaid expenses, accounts payable, accrued liabilities, and deferred revenue (gift cards, subscriptions).

Documentation standards. Attach supporting documents to every reconciliation. NetSuite's file cabinet stores these attachments, creating a permanent audit trail. When your auditor asks for the March bank reconciliation, you should be able to pull it from NetSuite in 30 seconds, not dig through a shared drive.

Variance threshold alerts. Set up workflow alerts that trigger when specific GL accounts change by more than a defined threshold. If your marketing expense account suddenly shows a $50K increase month over month, you want to know about it before close—not after.

How Do You Handle Multi-Entity Consolidation in NetSuite?

If your ecommerce business has multiple legal entities—a US operating company, a Canadian subsidiary, a UK entity—NetSuite's OneWorld module handles consolidation. Here's what the controller needs to know:

Intercompany transactions. When the US entity sells inventory to the Canadian entity, NetSuite can automatically generate the intercompany journal entries. Configure this once and it runs on autopilot. The key is setting up proper intercompany pricing (transfer pricing) that satisfies tax requirements.

Currency translation. NetSuite automatically translates foreign subsidiary financials to your reporting currency using the rates you specify (current rate for balance sheet, average rate for income statement). Set up an automatic exchange rate feed so you're not manually entering rates each month.

Elimination entries. Intercompany revenue, COGS, AR, and AP need to be eliminated in consolidation. NetSuite handles standard eliminations automatically. Custom elimination entries (management fees, royalties) may need to be configured by your implementation partner.

Consolidated reporting. Build consolidated financial reports that show both individual subsidiary results and combined totals. Your board probably wants to see consolidated numbers, but your tax accountant needs individual entity results.

What Are the Most Common Controller Mistakes in NetSuite?

Mistake 1: Not using approval workflows. It's faster to skip approvals, but one unauthorized journal entry can cost you an audit qualification. The 30 seconds it takes to approve a transaction prevents hours of audit investigation.

Mistake 2: Over-customizing transaction forms. Keep your invoice, vendor bill, and sales order forms as close to standard as possible. Every customization is a maintenance burden during NetSuite upgrades and a training challenge for new staff.

Mistake 3: Ignoring the bank feed. NetSuite's bank feed imports transactions daily. If you only look at it during month-end close, you'll have hundreds of unmatched transactions to process. Check it daily—five minutes a day saves five hours at month-end.

Mistake 4: Manual journal entries for recurring items. Rent, depreciation, insurance amortization—these should be memorized transactions that post automatically. If you're manually creating the same journal entry every month, you're wasting time and creating error risk.

Mistake 5: Not locking periods. If a prior period isn't locked, someone will post to it. An AP clerk will backdate a vendor bill. A sales manager will push an order into last month. Lock your periods.

Frequently Asked Questions

How long should month-end close take on NetSuite? Five to seven business days for a mid-market ecommerce company ($5M-$50M revenue). If you're taking longer than 10 days, your processes need optimization—likely in payment reconciliation or inventory valuation.

Can NetSuite handle sales tax compliance automatically? NetSuite has built-in tax calculation, but most ecommerce companies use a third-party tax engine (Avalara or Vertex) integrated with NetSuite. These handle the complexity of multi-state nexus, marketplace facilitator rules, and international VAT. Budget $5K-$15K annually depending on transaction volume.

Should the controller or the NetSuite admin own saved searches? Both. The controller should build financial analysis searches. The admin should build operational and system-level searches. The controller needs the skills to create and modify their own searches—waiting for IT to build reports defeats the purpose of having a real-time system.

How do you handle returns and refunds in the close process? Process returns through NetSuite's Return Authorization (RA) workflow. This creates the proper inventory receipt and credit memo chain. For refunds, use the customer refund transaction linked to the credit memo. Never process refunds as standalone journal entries—it breaks the audit trail.

What's the biggest time saver for controllers on NetSuite? Automated bank reconciliation with matching rules. Set up rules that match transactions by amount, date range, and reference number. For a company with 500+ bank transactions monthly, this saves 6-10 hours of manual matching.

Take the Next Step

The controller's role in a NetSuite environment is fundamentally different from managing books in QuickBooks. You have more power, more automation, and more responsibility to maintain the controls that keep the financial data trustworthy.

Whether you're preparing for your first close on NetSuite or trying to cut your close timeline in half, the foundation is always the same: clean data, proper controls, and automated workflows.

Take our free assessment → to evaluate your current close process and identify the NetSuite optimizations that will have the biggest impact on your month-end timeline.