Understanding NetSuite's GL Architecture

NetSuite's GL architecture combines a traditional Chart of Accounts with dimensional segmentation. Unlike legacy systems that embed all classifications in the account number itself, NetSuite separates the "what" (account) from the "who/where/why" (segments).

The Account + Segment Model

Traditional GL (Embedded):   4100-01-NYC-MFG
                             │    │   │   └── Department
                             │    │   └────── Location
                             │    └────────── Division
                             └─────────────── Account

NetSuite GL (Dimensional):
┌─────────────────────────────────────────────────────────────────┐
│ Account: 4100 - Product Revenue                                 │
│ + Subsidiary: US Operations                                     │
│ + Department: Sales                                             │
│ + Class: Hardware                                               │
│ + Location: New York                                            │
│ + Custom Segment: Region = Northeast                            │
└─────────────────────────────────────────────────────────────────┘

Result: Single account, infinitely sliceable by any dimension
        No account explosion, simpler maintenance

Benefits of Dimensional Segmentation

NetSuite's Standard Segments

NetSuite provides four standard classification segments, each with specific characteristics and use cases.

Subsidiary (OneWorld)

Department

Class

Location

Custom Segments

When four standard segments aren't enough, NetSuite supports custom segments for additional classification dimensions.

Custom Segment Types

Creating Custom Segments

Customization › Lists, Records, & Fields › Custom Segments › New

Key Configuration:
┌─────────────────────────────────────────────────────────────────┐
│ Label: Region                                                   │
│ ID: _region (system prefixes with cseg)                        │
│ Record Type: Custom List                                        │
│ Description: Geographic region for sales analysis              │
│                                                                 │
│ Filtering:                                                      │
│   ☑ Filter By: Subsidiary                                       │
│   ☑ Filter By: Location                                         │
│                                                                 │
│ Apply To:                                                       │
│   ☑ GL Impact Transactions                                      │
│   ☑ Non-GL Transactions (quotes, opportunities)                │
│                                                                 │
│ Reporting:                                                      │
│   ☑ Show in Financial Statements                                │
│   ☑ Include in Saved Searches                                   │
└─────────────────────────────────────────────────────────────────┘

Segmentation Design Principles

1. Start with Reporting Requirements

Design segments based on how management needs to view financial data:

• What dimensions do executives need for decision-making?
• What statutory/regulatory reports are required?
• What operational metrics need tracking?
• What budget structures exist?

2. Assign Purpose to Each Segment

Recommended Segment Assignment:

Subsidiary → Legal Entity
  "Who is the legal party to this transaction?"
  Example: US Inc., UK Ltd., Canada Corp.

Department → Cost Center / Organizational Unit
  "Who is responsible for this cost/revenue?"
  Example: Sales, Marketing, Engineering, Finance

Class → Product Line / Service Line
  "What product or service is this related to?"
  Example: Hardware, Software, Services, Support

Location → Physical/Operational Location
  "Where did this transaction occur?"
  Example: NYC Warehouse, London Office, Online

Custom Segment → Any Other Dimension
  "What else do we need to track?"
  Example: Region, Channel, Project, Grant

3. Design for Hierarchy

Department Hierarchy Example:

Department
├── Operations
│   ├── Manufacturing
│   │   ├── Assembly
│   │   └── Quality Control
│   └── Warehouse
│       ├── Receiving
│       └── Shipping
├── Sales
│   ├── Direct Sales
│   │   ├── Enterprise
│   │   └── SMB
│   └── Channel Sales
└── G&A
    ├── Finance
    ├── HR
    └── IT

Benefit: Report at any level (Operations total, or drill to Assembly)

Segment Application on Transactions

Header vs Line Level

Making Segments Required

Path: Setup > Accounting > Accounting Preferences

Configuration Options:
┌─────────────────────────────────────────────────────────────────┐
│ Department:                                                     │
│   ☑ Mandatory on all transactions                               │
│   ○ Mandatory on specific transactions only                     │
│   ○ Optional                                                    │
│                                                                 │
│ Class:                                                          │
│   ○ Mandatory on all transactions                               │
│   ☑ Mandatory on specific transactions only                     │
│      → Check: Invoice, Bill, Journal Entry                      │
│   ○ Optional                                                    │
│                                                                 │
│ Location:                                                       │
│   Follows inventory settings (mandatory for inventory items)    │
└─────────────────────────────────────────────────────────────────┘

Tip: Start optional during implementation, make mandatory at go-live
     after users are trained.

Default Segment Values

NetSuite can default segment values from multiple sources:

Common Segmentation Patterns by Industry

Manufacturing

Subsidiary: Legal entities
Department: Production, Quality, Engineering, Sales, G&A
Class: Product family (Widgets, Gadgets, Components)
Location: Plants, Distribution centers
Custom: Production Line, Shift

Software/SaaS

Subsidiary: Legal entities
Department: R&D, Sales, Customer Success, G&A
Class: Product (Platform, Add-ons, Services)
Location: Office locations (often minimal)
Custom: ARR Segment, Customer Tier

Professional Services

Subsidiary: Legal entities, Practice groups
Department: Service line (Consulting, Audit, Tax)
Class: Industry vertical (Healthcare, Tech, Financial)
Location: Office locations
Custom: Project, Engagement Partner

Nonprofit

Subsidiary: Legal entities, Chapters
Department: Programs, Fundraising, G&A
Class: Program/Fund (restricted vs unrestricted)
Location: Service locations
Custom: Grant, Campaign, Donor restriction

NetSuite Account Types

NetSuite provides predefined account types that control behavior on financial statements and transactions.

Balance Sheet Accounts

Income Statement Accounts

Account Numbering Best Practices

Standard Numbering Scheme

Common 4-5 Digit Numbering:

1XXX - Assets
  1000-1099: Cash & Bank
  1100-1199: Accounts Receivable
  1200-1299: Other Current Assets
  1300-1499: Fixed Assets
  1500-1999: Other Assets

2XXX - Liabilities
  2000-2099: Accounts Payable
  2100-2299: Other Current Liabilities
  2300-2999: Long Term Liabilities

3XXX - Equity
  3000-3099: Capital Stock
  3100-3199: Retained Earnings
  3200-3999: Other Equity

4XXX - Revenue
  4000-4099: Product Revenue
  4100-4199: Service Revenue
  4200-4999: Other Revenue

5XXX - Cost of Goods Sold
  5000-5099: Product COGS
  5100-5199: Direct Labor
  5200-5999: Other Direct Costs

6XXX-8XXX - Operating Expenses
  6000-6999: Selling Expenses
  7000-7999: G&A Expenses
  8000-8999: Other Operating

9XXX - Other Income/Expense
  9000-9099: Interest Income/Expense
  9100-9199: Gains/Losses
  9200-9999: Tax/Extraordinary

Account Hierarchies (Parent/Child)

NetSuite supports account hierarchies for roll-up reporting. Parent accounts are "header" accounts that sum their children.

Hierarchy Example

Account Hierarchy:

1000 - Cash and Cash Equivalents (Header - no posting)
├── 1010 - Operating Checking (Posting)
├── 1020 - Payroll Checking (Posting)
├── 1030 - Money Market (Posting)
└── 1040 - Petty Cash (Posting)

6000 - Salaries and Wages (Header - no posting)
├── 6010 - Salaries - Exempt (Posting)
├── 6020 - Wages - Non-Exempt (Posting)
├── 6030 - Bonuses (Posting)
├── 6040 - Commissions (Posting)
└── 6050 - Overtime (Posting)

Reporting Impact:
  Balance Sheet shows "1000 - Cash and Cash Equivalents: $500,000"
  Drill-down shows individual account balances

Subsidiary Account Restrictions (OneWorld)

In OneWorld, accounts are shared across all subsidiaries by default. You can restrict accounts to specific subsidiaries.

Restriction Scenarios

Path: Lists > Accounting > Accounts > Edit

Subsidiary Restrictions:
┌─────────────────────────────────────────────────────────────────┐
│ Available To:                                                   │
│   ☑ Parent Company                                              │
│   ☑ US Operations                                               │
│   ☐ UK Operations (restricted - has local equivalent)          │
│   ☑ Canada Operations                                           │
│                                                                 │
│ Note: Unchecked subsidiaries cannot post to this account        │
└─────────────────────────────────────────────────────────────────┘

Special Purpose Accounts

System-Controlled Accounts

Some accounts are managed by NetSuite and require special setup:

Inventory Accounts

Items with inventory tracking require linked GL accounts:

Item → Accounting Tab Accounts:

Asset Account: 1300 - Inventory Asset
  Debited: When inventory received (PO receipt, production completion)
  Credited: When inventory sold (invoice, consumption)

COGS Account: 5000 - Cost of Goods Sold
  Debited: When inventory sold
  Credited: (offset to Asset above)

Income Account: 4000 - Product Revenue
  Credited: When inventory sold (invoice)
  Debited: (offset to AR)

Expense Account: (for non-inventory items)
  Debited: When purchased

Sales Cycle GL Impact

Invoice

Transaction: Invoice for $1,000 product sale + $80 tax
┌────────────────────────────────────────────────────────────────┐
│ DR: Accounts Receivable     $1,080                             │
│     CR: Product Revenue              $1,000                    │
│     CR: Sales Tax Payable              $80                     │
│                                                                │
│ If inventory item:                                             │
│ DR: Cost of Goods Sold       $600                              │
│     CR: Inventory                      $600                    │
└────────────────────────────────────────────────────────────────┘

Customer Payment

Transaction: Payment received $1,080
┌────────────────────────────────────────────────────────────────┐
│ DR: Undeposited Funds       $1,080                             │
│     CR: Accounts Receivable          $1,080                    │
│                                                                │
│ After Bank Deposit:                                            │
│ DR: Bank Account            $1,080                             │
│     CR: Undeposited Funds            $1,080                    │
└────────────────────────────────────────────────────────────────┘

Purchase Cycle GL Impact

Vendor Bill

Transaction: Bill for $500 office supplies
┌────────────────────────────────────────────────────────────────┐
│ DR: Office Supplies Expense  $500                              │
│     CR: Accounts Payable               $500                    │
└────────────────────────────────────────────────────────────────┘

Bill Payment

Transaction: Pay vendor $500
┌────────────────────────────────────────────────────────────────┐
│ DR: Accounts Payable         $500                              │
│     CR: Bank Account                   $500                    │
└────────────────────────────────────────────────────────────────┘

Inventory Transactions

Inventory Adjustment (Increase)

Inventory Adjustment - Increase
┌────────────────────────────────────────────────────────────────┐
│ DR: Inventory Asset                    $500.00                 │
│     CR: Inventory Adjustment Account            $500.00        │
└────────────────────────────────────────────────────────────────┘

Inventory Adjustment (Decrease)

Inventory Adjustment - Decrease
┌────────────────────────────────────────────────────────────────┐
│ DR: Inventory Adjustment Account       $500.00                 │
│     CR: Inventory Asset                         $500.00        │
└────────────────────────────────────────────────────────────────┘

Transfer Order (Between Locations)

Transfer Order - Item Fulfillment
┌────────────────────────────────────────────────────────────────┐
│ DR: Inventory In Transit             $1,000.00                 │
│     CR: Inventory Asset (Source)              $1,000.00        │
└────────────────────────────────────────────────────────────────┘

Transfer Order - Item Receipt
┌────────────────────────────────────────────────────────────────┐
│ DR: Inventory Asset (Dest)           $1,000.00                 │
│     CR: Inventory In Transit                  $1,000.00        │
└────────────────────────────────────────────────────────────────┘

Manufacturing Transactions

Assembly Build (Non-WIP)

Assembly Build
┌────────────────────────────────────────────────────────────────┐
│ DR: Finished Goods Inventory         $1,200.00                 │
│     CR: Raw Materials Inventory               $1,200.00        │
└────────────────────────────────────────────────────────────────┘

Work Order Issue (WIP)

Work Order Issue - Material Consumption
┌────────────────────────────────────────────────────────────────┐
│ DR: WIP - Components                   $800.00                 │
│     CR: Raw Materials Inventory                 $800.00        │
└────────────────────────────────────────────────────────────────┘

Work Order Completion (WIP)

Work Order Completion
┌────────────────────────────────────────────────────────────────┐
│ DR: Finished Goods Inventory         $1,200.00                 │
│     CR: WIP - Assemblies                      $1,200.00        │
└────────────────────────────────────────────────────────────────┘

Work Order Close (WIP)

Work Order Close - With Variance
┌────────────────────────────────────────────────────────────────┐
│ DR: WIP - Assemblies (to clear)      $1,200.00                 │
│     CR: WIP - Components (to clear)            $800.00         │
│     CR: WIP Variance                           $400.00         │
└────────────────────────────────────────────────────────────────┘

Banking Transactions

Check

Check - Direct Expense
┌────────────────────────────────────────────────────────────────┐
│ DR: Expense Account                    $500.00                 │
│     CR: Bank Account                            $500.00        │
└────────────────────────────────────────────────────────────────┘

Transfer

Bank Transfer
┌────────────────────────────────────────────────────────────────┐
│ DR: Bank Account (To)               $10,000.00                 │
│     CR: Bank Account (From)                  $10,000.00        │
└────────────────────────────────────────────────────────────────┘

GL Impact Summary Table

Journal Entry Types

Common Journal Entry Scenarios

Accrued Expense (Month End)

Accrue Unbilled Services - Dec 31
┌────────────────────────────────────────────────────────────────┐
│ DR: Professional Services Expense    $5,000.00                 │
│     CR: Accrued Expenses                      $5,000.00        │
└────────────────────────────────────────────────────────────────┘

Reverse Accrual - Jan 1
┌────────────────────────────────────────────────────────────────┐
│ DR: Accrued Expenses                 $5,000.00                 │
│     CR: Professional Services Expense         $5,000.00        │
└────────────────────────────────────────────────────────────────┘

Prepaid Expense Amortization

Monthly Insurance Amortization
┌────────────────────────────────────────────────────────────────┐
│ DR: Insurance Expense                $1,000.00                 │
│     CR: Prepaid Insurance                     $1,000.00        │
└────────────────────────────────────────────────────────────────┘

Reclassification

Reclass Expense to Correct Department
┌────────────────────────────────────────────────────────────────┐
│ DR: Travel Expense (Marketing Dept)    $500.00                 │
│     CR: Travel Expense (Sales Dept)             $500.00        │
└────────────────────────────────────────────────────────────────┘

Opening Balances

Load Opening Balance Sheet
┌────────────────────────────────────────────────────────────────┐
│ DR: Cash                           $100,000.00                 │
│ DR: Accounts Receivable             $50,000.00                 │
│ DR: Inventory                       $75,000.00                 │
│     CR: Accounts Payable                     $30,000.00        │
│     CR: Retained Earnings                   $195,000.00        │
└────────────────────────────────────────────────────────────────┘

Journal Entry Best Practices

Documentation Standards

• Memo field: Always describe the purpose (e.g., "Dec 2024 rent accrual")
• Line memos: Detail each line if multiple purposes
• Attachments: Attach supporting documentation
• Name field: Link to customer/vendor if applicable

Approval Workflows

Journal Entry Approval Workflow:

Criteria:
  - Amount > $10,000 OR
  - Contains specific accounts (intercompany, equity)

Routing:
  Level 1: Controller (all JEs meeting criteria)
  Level 2: CFO (if amount > $100,000)

Actions:
  - Approved: JE posts to GL
  - Rejected: Returns to creator with comments
  - Pending Approval: Does not post

Reversing Entries

• Check "Reversing" box on accrual entries
• System auto-creates reversal on first day of next period
• Use for: Month-end accruals, prepaid allocations
• Do NOT use for: Reclassifications, corrections

Multi-Book Overview

Multi-Book Accounting allows maintaining separate general ledgers with different accounting treatments while sharing a common transactional backbone.

Primary vs Secondary Books

Common Multi-Book Scenarios

• GAAP + IFRS: Different revenue recognition, lease accounting
• GAAP + Tax: Book vs tax depreciation differences
• GAAP + Local Statutory: Country-specific requirements
• Management + Statutory: Internal vs external reporting

Configuring Multi-Book

Enabling Multi-Book

Prerequisites:
  - Cannot be disabled after enabling
  - Existing data becomes primary book
  - Plan secondary books before enabling

Creating Secondary Books

Configuration:
┌─────────────────────────────────────────────────────────────────┐
│ Name: IFRS Book                                                 │
│ Currency: EUR                                                   │
│ Status: Active                                                  │
│                                                                 │
│ Book Settings:                                                  │
│   ☑ Automated (transactions post automatically)                 │
│   ○ Manual (adjustments only)                                   │
│                                                                 │
│ Accounting Method: Accrual                                      │
│                                                                 │
│ Subsidiaries: (select which subsidiaries use this book)         │
│   ☑ Parent Company                                              │
│   ☑ UK Operations                                               │
│   ☑ Germany GmbH                                                │
└─────────────────────────────────────────────────────────────────┘

Book-Specific Account Mapping

When accounting treatment differs between books, map different accounts:

Example: Revenue Recognition Difference

Transaction: Software License Sale $100,000
             2-year term, paid upfront

Primary Book (GAAP - ASC 606):
  Dr: AR $100,000
  Cr: Deferred Revenue $100,000
  (then recognize $4,167/month over 24 months)

Secondary Book (Cash Basis):
  Dr: Cash $100,000
  Cr: Revenue $100,000
  (recognize immediately when paid)

Configuration:
  Item record → Accounting tab → Book-specific accounts
  Or use adjustment journal entries for secondary book

Book-Specific Adjustments

When automatic posting isn't sufficient, use book-specific journal entries.

Creating Book-Specific Journal Entry

Standard JE posts to: All books (unless overridden)

Book-Specific Adjustment:
┌─────────────────────────────────────────────────────────────────┐
│ Journal Entry                                                   │
│ Accounting Book: IFRS Book (dropdown)                           │
│                                                                 │
│ Lines:                                                          │
│   Dr: Depreciation Expense - IFRS   $5,000                     │
│   Cr: Accumulated Depreciation      $5,000                     │
│                                                                 │
│ Note: This entry ONLY posts to IFRS book                       │
│       Primary book is unaffected                                │
└─────────────────────────────────────────────────────────────────┘

Common Book Differences

Reporting Across Books

Financial Reports by Book

Path: Reports → Financial → Balance Sheet

Report Settings:
  Accounting Book: [Select primary or secondary]
  Subsidiary: [Select]
  As Of Date: [Date]

Each book produces separate financial statements
Drill-down shows book-specific transactions

Book Comparison Report

Use saved searches to compare balances across books:

Saved Search: Book Comparison
Type: Transaction

Criteria:
  - Account: [specific accounts]
  - Date: [period]

Results:
  Account | Primary Book | IFRS Book | Difference
  --------|--------------|-----------|------------
  Revenue |   $500,000   | $480,000  |   $20,000
  Deferred|    $50,000   |  $70,000  |  -$20,000

Multi-Currency Fundamentals

Currency Types in NetSuite

Exchange Rate Types

Foreign Currency Transactions

Transaction Recording

Payment with Gain/Loss

Realized vs Unrealized Gains/Losses

Currency Revaluation

Revaluation adjusts open foreign currency balances to current exchange rates at period end.

Running Revaluation

Steps:
1. Select subsidiary
2. Set "As Of" date (period end)
3. Choose accounts to revalue:
   - Bank accounts (foreign currency)
   - AR accounts
   - AP accounts
   - Other balance sheet accounts
4. Review preview
5. Post revaluation

Result: Journal entry created for unrealized gain/loss

Revaluation Example

Exchange Rate Management

Automatic Rate Updates

Options:
1. Manual entry (Lists → Accounting → Currency Exchange Rates)
2. Scheduled auto-update (daily/weekly)
3. Third-party integration (XE, OANDA via SuiteApp)

Rate Providers:
- ECB (European Central Bank) - free, delayed
- XE - real-time, subscription required
- Custom feed via SuiteScript

Rate Override on Transactions

Users can override exchange rates on individual transactions when needed:

• Click "Currency" button on transaction
• Enter custom rate
• Rate locks to transaction regardless of future rate changes

OneWorld Consolidation

NetSuite OneWorld automatically consolidates subsidiary financials up the hierarchy. Key processes include currency translation and intercompany eliminations.

Subsidiary Hierarchy

Example Hierarchy:

Global Holdings (Parent - USD)
├── US Operations (Child - USD)
│   ├── US East (Grandchild - USD)
│   └── US West (Grandchild - USD)
├── UK Operations (Child - GBP)
└── Germany GmbH (Child - EUR)

Consolidation Flow:
  Grandchildren → Children → Parent
  Foreign currencies translated at each level

Consolidation Settings

Key Settings per Subsidiary:
┌─────────────────────────────────────────────────────────────────┐
│ Currency: EUR                                                   │
│ Parent: Global Holdings                                         │
│                                                                 │
│ Elimination Subsidiary: (for IC eliminations)                   │
│   ○ None                                                        │
│   ● Global Holdings                                             │
│   ○ Specific elimination sub                                    │
│                                                                 │
│ Translation Method:                                             │
│   Current rate for balance sheet                                │
│   Average rate for income statement                             │
│   Historical rate for equity                                    │
└─────────────────────────────────────────────────────────────────┘

Intercompany Transactions

Automatic Intercompany Journal Entries

When enabled, NetSuite auto-creates offsetting entries for intercompany transactions.

Enable: Check "Automated Intercompany Journals"

Example: US sub sells $10,000 service to UK sub

System Creates:
┌─────────────────────────────────────────────────────────────────┐
│ US Operations Journal:                                          │
│   Dr: Intercompany Receivable - UK     $10,000                 │
│   Cr: Intercompany Revenue             $10,000                 │
├─────────────────────────────────────────────────────────────────┤
│ UK Operations Journal (auto-created):                           │
│   Dr: Intercompany Expense             £8,000                  │
│   Cr: Intercompany Payable - US        £8,000                  │
└─────────────────────────────────────────────────────────────────┘

Intercompany Account Setup

Required Intercompany Accounts:

Balance Sheet:
  - Intercompany Receivable (by subsidiary)
  - Intercompany Payable (by subsidiary)
  - Due To/Due From accounts

Income Statement (optional for management fees):
  - Intercompany Revenue
  - Intercompany Expense
  - Management Fee Income/Expense

Configure: Lists → Accounting → Accounts
           Check "Intercompany" box on account
           Assign to subsidiaries involved in IC transactions

Elimination Entries

Elimination entries remove intercompany balances during consolidation so the consolidated view shows only external transactions.

Auto-Elimination

NetSuite Auto-Eliminates:
  - Intercompany receivables/payables (when flagged)
  - Intercompany revenue/expense (when flagged)

Process:
1. Mark accounts as "Eliminate Intercompany Transactions"
2. Run consolidation or view consolidated report
3. System auto-eliminates matching IC balances

Manual Elimination Journal

Equity Eliminations (Investments)

Consolidated Reporting

Running Consolidated Reports

Path: Reports → Financial → Balance Sheet (or Income Statement)

Settings:
  Subsidiary: [Parent Company - Consolidated]
              ☑ Include Children

Output Shows:
  - Parent amounts
  - Children amounts (translated)
  - Eliminations (if enabled)
  - Consolidated total

Consolidation Checklist

NetSuite Accounting Periods

Period Structure

Default Structure:
┌─────────────────────────────────────────────────────────────────┐
│ Fiscal Year 2025                                                │
├─────────────────────────────────────────────────────────────────┤
│ Q1 2025                                                         │
│   ├── Jan 2025 (Period 1)                                       │
│   ├── Feb 2025 (Period 2)                                       │
│   └── Mar 2025 (Period 3)                                       │
│ Q2 2025                                                         │
│   ├── Apr 2025 (Period 4)                                       │
│   └── ... and so on                                             │
└─────────────────────────────────────────────────────────────────┘

Custom Calendars:
  - 4-4-5, 4-5-4 retail calendars
  - 13-period calendar
  - Non-calendar fiscal year

Period Status

Month-End Close Checklist

Year-End Close

Year-End Close Process

What Happens:
1. System calculates Net Income for the year
2. Creates journal entry:
   Dr: Income Summary (all revenue accounts)
   Cr: Income Summary (all expense accounts)
   Dr/Cr: Retained Earnings (net)

3. Income statement accounts reset to zero for new year
4. Balance sheet rolls forward with new retained earnings

Note: You can still reopen a closed year if needed
      (with proper permissions)

Lock Dates

Lock dates provide additional control beyond period status to prevent changes to closed periods.

Lock Date Types

Lock Dates:
┌─────────────────────────────────────────────────────────────────┐
│ Lock AR (Receivables):     12/31/2024                           │
│ Lock AP (Payables):        12/31/2024                           │
│ Lock All:                  12/31/2024                           │
│                                                                 │
│ Role Override:                                                  │
│   ☐ Allow Administrator override                                │
│   ☐ Allow specific role override                                │
└─────────────────────────────────────────────────────────────────┘

Behavior:
  - Transactions dated on/before lock date cannot be:
    - Created
    - Edited
    - Deleted
  - Even administrators blocked unless override enabled

Standard Financial Reports

Built-In Financial Statements

Report Customization Options

Common Filters (available on most financial reports):

Subsidiaries:
  - Single subsidiary
  - Consolidated (with or without children)
  - Multiple selected

Periods:
  - Single period
  - Period range
  - Comparative (vs prior period, prior year)
  - YTD, QTD

Segments:
  - Filter by Department
  - Filter by Class
  - Filter by Location
  - Filter by Custom Segments

Display:
  - Summary (account totals)
  - Detail (transactions)
  - Expand to show hierarchy

Financial Report Builder

Report Builder allows creating custom financial reports with complex row/column layouts.

Creating Custom Financial Report

Layout Structure:
┌─────────────────────────────────────────────────────────────────┐
│ ROWS (define what accounts/items to include)                    │
│   Row 1: Revenue (account range 4000-4999)                      │
│   Row 2: COGS (account range 5000-5999)                         │
│   Row 3: Gross Profit (formula: Row1 - Row2)                    │
│   Row 4: Operating Expenses (account range 6000-6999)           │
│   Row 5: Operating Income (formula: Row3 - Row4)                │
├─────────────────────────────────────────────────────────────────┤
│ COLUMNS (define periods/comparisons)                            │
│   Col A: Current Month Actual                                   │
│   Col B: Current Month Budget                                   │
│   Col C: Variance (formula: ColA - ColB)                        │
│   Col D: Variance % (formula: ColC / ColB * 100)                │
│   Col E: YTD Actual                                             │
│   Col F: YTD Budget                                             │
└─────────────────────────────────────────────────────────────────┘

Row Types

Column Types

Departmental/Segment P&L

P&L by Department

Filters: Period, Subsidiary
Rows/Columns: Show Departments as columns

Output:
                    Sales    Marketing   Engineering   G&A     Total
Revenue            500,000    50,000        10,000   5,000   565,000
COGS               300,000         0             0       0   300,000
Gross Profit       200,000    50,000        10,000   5,000   265,000
Operating Exp       50,000   100,000       150,000  75,000   375,000
Operating Inc      150,000   (50,000)     (140,000)(70,000) (110,000)

Custom P&L Layout Example

Board-Ready P&L Report:

Row Layout:                          Column Layout:
1.  Total Revenue                    A. Current Month
2.    Product Revenue                B. Budget
3.    Service Revenue                C. Variance $
4.    Other Revenue                  D. Variance %
5.  (blank line)                     E. Prior Year Month
6.  Cost of Revenue                  F. YoY Change %
7.  Gross Profit (formula)           G. YTD Actual
8.  Gross Margin % (formula)         H. YTD Budget
9.  (blank line)                     I. Full Year Forecast
10. Sales & Marketing
11. Research & Development
12. General & Administrative
13. Total Operating Expenses
14. Operating Income
15. Operating Margin %

Manufacturing WIP Accounts

Work In Process requires specific account setup for tracking production costs through completion.

Required WIP Accounts

WIP GL Flow

Work Order Lifecycle GL:

1. WORK ORDER ISSUE (Material to WIP)
   Dr: WIP - Materials          $10,000
   Cr: Raw Materials Inventory  $10,000

2. LABOR RECORDED (if using time tracking)
   Dr: WIP - Labor              $2,000
   Cr: Labor Clearing           $2,000

3. WORK ORDER COMPLETION (FG to Inventory)
   Dr: Finished Goods Inventory $15,000
   Cr: WIP - Materials          $10,000
   Cr: WIP - Labor              $2,000
   Cr: WIP - Overhead           $3,000

4. WORK ORDER CLOSE (Variance)
   Dr: WIP Variance             $500
   Cr: WIP - Materials          $500
   (if actual costs differed from standard)

Advanced Revenue Management (ARM)

ASC 606/IFRS 15 compliant revenue recognition requires specific GL accounts.

ARM Account Types

ARM GL Flow Example

Scenario: 2-year SaaS subscription, $24,000 paid upfront

1. INVOICE CREATED
   Dr: Accounts Receivable      $24,000
   Cr: Deferred Revenue         $24,000

2. PAYMENT RECEIVED
   Dr: Cash                     $24,000
   Cr: Accounts Receivable      $24,000

3. MONTHLY RECOGNITION (x 24 months)
   Dr: Deferred Revenue         $1,000
   Cr: Subscription Revenue     $1,000

Fixed Assets

Fixed Asset Management module tracks asset lifecycle from acquisition through disposal.

Fixed Asset Accounts

Fixed Asset GL Flow

Asset Lifecycle:

1. ACQUISITION ($50,000 equipment)
   Dr: Equipment                $50,000
   Cr: Accounts Payable         $50,000

2. MONTHLY DEPRECIATION (5-year straight-line)
   Dr: Depreciation Expense     $833
   Cr: Accumulated Depreciation $833

3. DISPOSAL (sold for $10,000, NBV $15,000)
   Dr: Cash                     $10,000
   Dr: Accumulated Depreciation $35,000
   Dr: Loss on Disposal         $5,000
   Cr: Equipment                $50,000

Project Accounting

Project-based businesses track revenue and costs by project for profitability analysis.

Project GL Considerations

• Segment tracking: Use Class or custom segment for projects
• WIP for services: Track unbilled time as project WIP
• Revenue recognition: Percentage-of-completion or milestone
• Cost allocation: Direct vs indirect project costs

Project Accounting GL Flow

Time & Materials Project:

1. LABOR INCURRED
   Dr: Project WIP (Class: Project X)   $5,000
   Cr: Salaries Expense                 $5,000

2. INVOICE CREATED
   Dr: Accounts Receivable              $7,500
   Cr: Service Revenue (Class: Proj X)  $7,500

3. COST RECOGNITION
   Dr: Project COGS (Class: Project X)  $5,000
   Cr: Project WIP (Class: Project X)   $5,000

Project P&L (by Class):
  Revenue:  $7,500
  COGS:     $5,000
  Margin:   $2,500 (33%)

Amortization Overview

NetSuite's native amortization feature automates the systematic allocation of prepaid expenses and deferred revenue across accounting periods. This eliminates manual journal entries, ensures consistency, and provides a complete audit trail from source transaction to recognition.

Enabling Amortization

Required Features

Preferences

• Amortization Source Account: Controls which account is debited/credited
• Amortization Date Override: Allow users to modify calculated dates
• Auto-Create Amortization JE: Automatically post or create in pending status

Creating Amortization Templates

Template Types

Complete Field Reference

The Eliminate Checkbox (OneWorld)

In multi-subsidiary environments, the Eliminate checkbox is critical for proper consolidated financial statements. This field appears at both the template and transaction level.

When to Use Eliminate

How Elimination Works

-- Example: Parent pays $120K group insurance, allocates to 3 subsidiaries

ORIGINAL TRANSACTION (Parent):
  DR 1350 Prepaid Insurance    $120,000
  CR 1000 Cash                 $120,000

IC ALLOCATION TO SUB A ($40K):
  Parent:
    DR 1210 IC Receivable - Sub A    $40,000
    CR 1350 Prepaid Insurance        $40,000

  Sub A:
    DR 1350 Prepaid Insurance        $40,000  [Eliminate = YES]
    CR 2110 IC Payable - Parent      $40,000

MONTHLY AMORTIZATION (Sub A):
  DR 6100 Insurance Expense          $3,333   [Eliminate = YES]
  CR 1350 Prepaid Insurance          $3,333   [Eliminate = YES]

-- At consolidation, Sub A's insurance expense eliminates
-- Parent's net prepaid of $80K remains (other subs' portions)
-- Consolidated P&L shows real expense only once

Verification Steps

1. Run Trial Balance by subsidiary before consolidation
2. Review "Eliminate" column on amortization schedule report
3. Run consolidated Trial Balance
4. Verify eliminated entries don't appear in consolidated totals
5. Reconcile: Sub standalone total - eliminated = consolidated impact

Applying Amortization to Transactions

On Items (Recommended)

Set default amortization on Service Items or Non-Inventory Items that are typically prepaid:

1. Open the item record
2. Navigate to Accounting subtab
3. Check Amortize checkbox
4. Select default Amortization Schedule
5. Set Residual Account if different from item account
6. Save

Benefits: Auto-applies when item used on bills/expenses, ensures consistency across all users, reduces data entry errors, can still override at transaction level.

On Transaction Lines

For one-off or variable amortization, configure at the line level:

1. Create vendor bill, expense report, or journal entry
2. On the expense/item line, enable Amortize
3. Select Amortization Schedule
4. For Variable schedules, enter Amortization Start Date and End Date
5. Set Residual handling preference
6. Check Eliminate if intercompany (OneWorld)
7. Save transaction

Processing Amortization

Manual Processing

1. Select Subsidiary (OneWorld)
2. Set Period to process
3. Click Search to see pending amortization
4. Review the preview list
5. Click Process to create journal entries
6. Verify JEs in transaction list

Scheduled Processing (Recommended)

Automate amortization with a scheduled script:

/**
 * @NApiVersion 2.1
 * @NScriptType ScheduledScript
 * @description Process amortization automatically at month-end
 */
define(['N/record', 'N/search', 'N/runtime'], function(record, search, runtime) {

    function execute(context) {
        var amortSearch = search.create({
            type: 'amortizationschedule',
            filters: [
                ['status', 'is', 'Pending'],
                'AND',
                ['scheddate', 'onorbefore', 'today']
            ]
        });

        amortSearch.run().each(function(result) {
            try {
                var amortRec = record.load({
                    type: 'amortizationschedule',
                    id: result.id
                });
                amortRec.setValue({ fieldId: 'status', value: 'Posted' });
                amortRec.save();
            } catch (e) {
                log.error('Amort Process Error', e);
            }
            return true;
        });
    }

    return { execute: execute };
});

GL Impact Examples

Expense Amortization

-- 12-month prepaid insurance: $12,000

INITIAL BILL ENTRY:
  DR 1350 Prepaid Insurance    $12,000
  CR 2000 Accounts Payable     $12,000

MONTHLY AMORTIZATION (x12):
  DR 6100 Insurance Expense    $1,000
  CR 1350 Prepaid Insurance    $1,000

-- After 12 months, prepaid balance = $0

Revenue Amortization (Deferred Revenue)

-- 12-month subscription received upfront: $24,000

INITIAL INVOICE ENTRY:
  DR 1200 Accounts Receivable  $24,000
  CR 2400 Deferred Revenue     $24,000

MONTHLY RECOGNITION (x12):
  DR 2400 Deferred Revenue     $2,000
  CR 4100 Subscription Revenue $2,000

-- After 12 months, deferred revenue balance = $0

Prorated First Period

-- $12,000 prepaid starting mid-month (Jan 15)
-- 12-month schedule with proration

JANUARY AMORTIZATION (17 days / 31 days):
  DR 6100 Insurance Expense    $548.39  (12000/12 * 17/31)
  CR 1350 Prepaid Insurance    $548.39

FEBRUARY - DECEMBER (11 full months):
  DR 6100 Insurance Expense    $1,000.00 each
  CR 1350 Prepaid Insurance    $1,000.00 each

JANUARY NEXT YEAR (remaining 14 days):
  DR 6100 Insurance Expense    $451.61
  CR 1350 Prepaid Insurance    $451.61

-- Total: $548.39 + $11,000 + $451.61 = $12,000

Reporting

Standard Reports

Custom Saved Search

Saved Search: Amortization Schedule Detail
Type: Amortization Schedule

Criteria:
- Status is Pending or Posted
- Schedule Date within [date range]

Results:
- Name, Source Transaction
- Original Amount, Recognized Amount, Remaining Amount
- Schedule Date, Period
- Eliminate (for OneWorld), Subsidiary

Summary:
- Group by Account
- Sum Remaining Amount

Troubleshooting Amortization

NetSuite Documentation References

Official Oracle NetSuite Help Center documentation for amortization:

Budgeting Overview

NetSuite's native budgeting feature (included with base license) allows organizations to create, manage, and report on financial budgets. Budgets can be created at the account level and optionally segmented by subsidiary, department, class, and location.

Native Budgeting vs NSPB

Enabling and Configuring Budgets

Enable Budgeting Feature

Once enabled, budget fields appear on GL accounts and budget reports become available.

Budget Categories Setup

Budget categories allow multiple budget versions (e.g., Operating, Revised, Forecast):

Configuration:
┌─────────────────────────────────────────────────────────────────┐
│ Budget Category: Operating Budget 2025                          │
│                                                                 │
│ Settings:                                                       │
│   ☑ Active                                                      │
│   ☐ Global                                                      │
│                                                                 │
│ Subsidiary: (select applicable subsidiaries)                    │
│   ☑ Parent Company                                              │
│   ☑ US Operations                                               │
│   ☑ UK Operations                                               │
└─────────────────────────────────────────────────────────────────┘

Common Budget Categories

Budget Structure

Budgets in NetSuite can be as simple or detailed as needed based on your reporting requirements.

Budget Dimensions

Budget Entry Methods

Method 1: Set Up Budgets Page

Provides account dropdown, year selection, monthly amount entry grid, and copy/spread functionality. Best for small number of accounts, simple budgets.

Method 2: CSV Import

Record Type: Budget

Required CSV Columns:
┌─────────────────────────────────────────────────────────────────┐
│ Account,Year,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec   │
│ 4000,2025,50000,52000,48000,55000,60000,58000,...              │
│ 5000,2025,25000,26000,24000,27500,30000,29000,...              │
│ 6100,2025,10000,10000,10000,10000,10000,10000,...              │
└─────────────────────────────────────────────────────────────────┘

Optional columns: Subsidiary, Department, Class, Location,
                  Budget Category, Customer, Item

Method 3: Import via SuiteScript

// Budget record creation via SuiteScript
var budgetRecord = record.create({
    type: record.Type.BUDGET,
    isDynamic: true
});

budgetRecord.setValue({ fieldId: 'account', value: accountId });
budgetRecord.setValue({ fieldId: 'year', value: '2025' });
budgetRecord.setValue({ fieldId: 'subsidiary', value: subId });
budgetRecord.setValue({ fieldId: 'periodamount1', value: 50000 }); // Jan
budgetRecord.setValue({ fieldId: 'periodamount2', value: 52000 }); // Feb
// ... etc
budgetRecord.save();

Which Entry Method to Use?

Budget GL Impact

Unlike transactions, budgets do not post to the General Ledger. They exist as a separate dataset for comparison and reporting purposes.

Budget Record:
┌─────────────────────────────────────────────────────────────────┐
│ NOT a journal entry - no debit/credit impact                   │
│ Stored separately from transaction data                         │
│ Linked to accounts via Account ID                               │
│ Compared to actuals via reports and saved searches              │
└─────────────────────────────────────────────────────────────────┘

Relationship:
  GL Account 4000 (Revenue)
    ├── Actual balance: Sum of posted transactions
    ├── Budget balance: Sum of budget amounts for period
    └── Variance: Actual - Budget

Budget Amounts Don't Affect

• Trial Balance
• Balance Sheet totals
• Income Statement actuals
• Account running balances

Budget Amounts Do Appear In

• Budget vs Actual reports
• Financial Report Builder (with budget columns)
• Saved searches joining to budget records
• SuiteAnalytics workbooks

Budget vs Actual Reporting

Standard Budget Reports

Available Report Variations:
  - Budget vs Actual (Summary)
  - Budget vs Actual by Department
  - Budget vs Actual by Class
  - Budget vs Actual by Location
  - Budget Register

Report Settings:
  - Select Budget Category (if multiple)
  - Select Period Range
  - Subsidiary filter (OneWorld)
  - Show: Amount, Variance, Variance %

Custom Variance Report Example

Income Statement with Budget Comparison:

Account          | Actual  | Budget  | Variance | Var %
-----------------|---------|---------|----------|-------
Revenue          | $525K   | $500K   | +$25K    | +5.0%
COGS             | $210K   | $200K   | -$10K    | -5.0%
Gross Profit     | $315K   | $300K   | +$15K    | +5.0%
                 |         |         |          |
Operating Exp    | $180K   | $175K   | -$5K     | -2.9%
  Salaries       | $100K   | $100K   |    $0    |  0.0%
  Rent           |  $30K   |  $30K   |    $0    |  0.0%
  Marketing      |  $50K   |  $45K   |  -$5K    | -11.1%
                 |         |         |          |
Net Income       | $135K   | $125K   | +$10K    | +8.0%

Convention:
  Revenue variance: Positive = Favorable
  Expense variance: Negative = Unfavorable

Budget Saved Searches

Use saved searches for custom budget analysis beyond standard reports.

Basic Budget vs Actual Search

Saved Search: Budget vs Actual by Account
Type: Transaction

Criteria:
  - Posting = True
  - Main Line = True (or False for detail)
  - Date: Within current period

Results:
  - Account (Group)
  - Formula (Currency): SUM({amount})                 [Actual]
  - Formula (Currency): SUM({account.budget.amount})  [Budget]

Summary Type: Group

Variance Analysis Formulas

-- Variance Amount (Actual - Budget)
{amount} - {budgetamount}

-- Variance % ((Actual - Budget) / Budget)
CASE WHEN {budgetamount} = 0 THEN NULL
     ELSE ROUND((({amount} - {budgetamount})
       / ABS({budgetamount})) * 100, 1)
END

-- Favorable/Unfavorable Flag
CASE
  WHEN {type} IN ('Income','Other Income')
       AND {amount} >= {budgetamount} THEN 'Favorable'
  WHEN {type} IN ('Income','Other Income')
       AND {amount} < {budgetamount} THEN 'Unfavorable'
  WHEN {type} IN ('Expense','COGS','Other Expense')
       AND {amount} <= {budgetamount} THEN 'Favorable'
  WHEN {type} IN ('Expense','COGS','Other Expense')
       AND {amount} > {budgetamount} THEN 'Unfavorable'
  ELSE 'N/A'
END

Budget Import Template

Use this template structure for CSV budget imports:

Simple Account-Level Template

External ID,Account,Year,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec
BUD-4000-2025,4000,2025,50000,52000,48000,55000,60000,58000,62000,65000,68000,70000,72000,85000
BUD-4100-2025,4100,2025,10000,10500,9600,11000,12000,11600,12400,13000,13600,14000,14400,17000
BUD-5000-2025,5000,2025,25000,26000,24000,27500,30000,29000,31000,32500,34000,35000,36000,42500

Multi-Dimension Template

External ID,Account,Subsidiary,Department,Class,Year,Budget Category,Jan,Feb,Mar,...
BUD-4000-US-SALES-PROD-2025,4000,US Operations,Sales,Product A,2025,Operating Budget,30000,...
BUD-4000-US-SALES-SVC-2025,4000,US Operations,Sales,Services,2025,Operating Budget,20000,...
BUD-4000-UK-SALES-PROD-2025,4000,UK Operations,Sales,Product A,2025,Operating Budget,15000,...

Budget Maintenance

Updating Existing Budgets

Method 1: Set Up Budgets Page
  - Navigate to existing budget, modify amounts, save

Method 2: CSV Update Import
  - Export existing budgets
  - Modify in Excel
  - Re-import with "Update" option
  - Match on External ID or Internal ID

Method 3: Mass Update
  - Create saved search of budget records
  - Use Mass Update to modify specific fields

Budget Copy Functions

Copy Budget Between Years:
  1. Export current year budgets to CSV
  2. Modify Year column to new year
  3. Apply growth/reduction factors in Excel
  4. Import as new budgets

Copy Budget to New Category:
  1. Export budgets for source category
  2. Change Budget Category column
  3. Adjust amounts if needed (e.g., Revised vs Operating)
  4. Import as new budgets

Budget History Tracking

NetSuite does not automatically track budget changes. Implement version control:

• Use Budget Categories for official versions (Operating, Revised Q1, etc.)
• Archive exports before major updates
• Custom field on Budget record for "Last Modified Date"
• Script to log budget changes to custom record

Industry Considerations

Documentation References

Official NetSuite documentation for budgeting features:

Trial Balance Out of Balance

Symptoms

• Trial balance debits ≠ credits
• Balance sheet doesn't balance
• Net income ≠ change in retained earnings

Common Causes

Diagnostic Steps

1. Run Trial Balance report
   Reports → Financial → Trial Balance
   Compare total debits vs credits

2. Run GL Audit Trail
   Reports → Financial → General Ledger Audit Trail
   Look for transactions with imbalanced entries

3. Check for orphaned transactions
   Saved Search: Transactions where GL Impact = true
   AND posting = true
   AND (debit total ≠ credit total)

4. Review currency rounding account
   Run GL report filtered to Currency Rounding account
   Large balances indicate FX issues

Subledger to GL Reconciliation

AR Reconciliation

AR Reconciliation Process:

1. Run AR Aging Report
   Reports → Receivables → A/R Aging
   Note total balance

2. Run GL Balance for AR Account
   Reports → Financial → Trial Balance
   Filter to AR accounts

3. Compare totals
   AR Aging Total should = AR GL Balance

Common Differences:
- Unapplied payments (show in GL, not aging)
- Posted deposits (reduce AR but may not show in aging)
- Multi-currency timing (revaluation not run)
- Credit memos unapplied

Resolution:
- Review A/R Register for detail
- Identify transactions in GL but not aging
- Apply unapplied payments/credits

AP Reconciliation

AP Reconciliation Process:

1. Run AP Aging Report
   Reports → Payables → A/P Aging
   Note total balance

2. Run GL Balance for AP Account
   Reports → Financial → Trial Balance
   Filter to AP accounts

3. Compare totals
   AP Aging Total should = AP GL Balance

Common Differences:
- Unapplied credits
- Unbilled receipts (inventory received, no bill)
- Prepayments
- Multi-currency variances

Inventory Reconciliation

Inventory Reconciliation Process:

1. Run Inventory Valuation Report
   Reports → Inventory/Items → Inventory Valuation
   Note total value

2. Run GL Balance for Inventory Accounts
   Reports → Financial → Trial Balance
   Filter to Inventory Asset accounts

3. Compare totals
   Inventory Valuation should = Inventory GL Balance

Common Differences:
- Pending item receipts
- Pending item fulfillments
- Cost adjustments not posted
- Location-specific account variances

Resolution:
- Run Inventory Revalue if using Standard Cost
- Review pending transactions
- Check item account assignments

Common GL Errors

Error: "This transaction is out of balance"

Error: "Cannot post to closed period"

Error: "Account restricted to specific subsidiaries"

GL Health Check

Periodic GL health checks prevent issues from accumulating.