Financial Reporting and Analysis
This domain tests your ability to produce and interpret NetSuite financial reports: balance sheet, income statement, cash flow statement, trial balance, comparative and consolidated reports, and custom report builder output. Expect questions on report dates, subsidiary context, accounting books, and consolidation logic.
Core concepts
- The balance sheet is as of a date. The income statement and cash flow statement cover a period. Comparative reports add prior-period or prior-year columns.
- Report context includes subsidiary, accounting book (primary or secondary), currency, and period. Consolidated reports roll up child subsidiaries; intercompany balances and transactions must be eliminated.
- Financial Report Builder supports row and column layouts, account groups, segment filters, and formulas. SuiteAnalytics Workbook supports pivots and charts from analytics datasets.
- Saved searches are transaction-level lists; financial reports are GL-based. A saved search may not reconcile to a report unless date, status, and posting filters match.
- Multi-currency consolidated reports translate foreign balances, typically income statement at average rates and balance sheet at period-end rates, and produce translation adjustments.
Worked example
Parent (USD) sells $20,000 of services to its EUR subsidiary, unpaid at month-end. Separate reports show Parent revenue $20,000 and an intercompany receivable $20,000; the subsidiary shows expense $20,000 and an intercompany payable $20,000. A consolidated income statement without elimination shows revenue and expense overstated by $20,000. The elimination removes intercompany revenue and expense and the receivable and payable. The group cannot earn revenue from itself; consolidated revenue should include only external sales.
Traps
Running a report in the wrong subsidiary context; forgetting child subsidiaries or consolidation; mixing accounting books; using transaction date instead of posting period; comparing a saved search total to a GL report without matching filters; ignoring translation adjustments.