Accurate and timely financial reporting is critical for every business. Oracle NetSuite provides a comprehensive suite of financial reporting tools—from standard statements like the Income Statement and Balance Sheet to fully customizable reports using the Financial Report Builder. This guide shows you how to leverage both.
Standard Financial Statements
NetSuite includes pre-built financial statements accessible from Reports > Financial:
- Income Statement (Profit & Loss) – Revenue minus expenses for a period
- Balance Sheet – Assets, liabilities, and equity at a point in time
- Cash Flow Statement – Cash inflows and outflows
- Trial Balance – All account balances for verification
- General Ledger – Detailed transaction-level view by account
These reports can be filtered by period, subsidiary, department, class, location, and currency. They update in real-time as transactions are posted.
Using the Financial Report Builder
For custom financial reports, use the Financial Report Builder at Reports > Financial > Financial Report Builder. This tool lets you create reports with custom rows (accounts/groups), columns (periods/subsidiaries), and calculations.
Step 1: Define Rows
Rows represent your account structure. You can:
- Add individual accounts from your chart of accounts
- Add account groups (e.g., all Revenue accounts)
- Add calculated rows – Subtotals, totals, or custom formulas
- Add label rows – Section headers for readability
Step 2: Define Columns
Columns determine what values appear for each row. Common column layouts include:
- Single period – One column showing a specific period's balance
- Period comparison – Current month vs. prior month, or current year vs. prior year
- Budget vs. Actual – Compare actual figures against budget
- Multi-subsidiary – Side-by-side comparison across entities
- Rolling periods – Last 12 months shown month by month
Step 3: Add Calculations
Insert calculated rows for common metrics:
- Gross Profit = Revenue – Cost of Goods Sold
- Gross Margin % = Gross Profit / Revenue × 100
- Operating Income = Gross Profit – Operating Expenses
- EBITDA = Operating Income + Depreciation + Amortization
- Net Income = Total Revenue – Total Expenses
Custom Report Layouts
To create a fully custom layout:
- Start from a blank report or copy an existing one
- Add row sections for each part of your P&L or Balance Sheet
- Use indentation and subtotals to create a clear hierarchy
- Add variance columns (e.g., "Actual vs. Budget" with dollar and percentage differences)
- Apply conditional formatting to highlight variances exceeding thresholds
Using Saved Searches for Management Reports
While the Financial Report Builder is ideal for traditional financial statements, saved searches are better for operational and management reports such as:
- Revenue by product category over time
- Customer profitability analysis
- Expense breakdown by department
- Aging reports with custom buckets
- KPI dashboards combining financial and operational data
Multi-Subsidiary Reporting
If you use NetSuite OneWorld, you can create consolidated reports that combine data across all subsidiaries. Use the subsidiary filter to view individual or combined entity results. Elimination entries and intercompany transactions are handled automatically when configured correctly.
Best Practices
- Keep your chart of accounts clean – A well-organized COA makes financial reporting much easier
- Use account numbering – Number your accounts systematically (e.g., 1000s for Assets, 2000s for Liabilities) for consistent ordering
- Create report templates – Build reusable report layouts that can be applied to different periods or subsidiaries
- Schedule report delivery – Set up email delivery for key reports to stakeholders on a daily, weekly, or monthly basis
- Reconcile before reporting – Ensure all accounts are reconciled before running month-end financial reports
Need help setting up your financial reporting framework? Contact YRK Consulting for expert financial consulting.