NetSuite financial statements come ready to run: an income statement, a balance sheet, a cash flow statement and a trial balance, all driven straight from the general ledger. Most finance teams still want them to look like their board pack, with their own groupings, subtotals and comparisons. The Financial Report Builder is where that happens, and it's also where a small layout change can drop an account from the totals without anyone noticing.
Key takeaways
- NetSuite's standard financial statements read directly from posted GL activity, so they are the reference point for every other report.
- The Financial Report Builder changes how a statement is laid out and filtered. It does not change the underlying accounting.
- Row layouts can be shared across several reports, so one change can affect more statements than you expect.
- When a customized statement doesn't balance, look for accounts missing from the layout before suspecting the data.
- In OneWorld, consolidated statements use different exchange rate types for the income statement and balance sheet, which explains many "why doesn't this tie" questions.
Want board-ready statements out of NetSuite? Book a free reporting review
What are NetSuite financial statements?
They are the standard financial reports NetSuite generates from your general ledger: the income statement, balance sheet, statement of cash flows, trial balance and general ledger detail. Each one can be run for a period range, a subsidiary or a consolidated group, and filtered by segments such as department, class or location if you use them.
A financial statement applies accounting rules to periods, posting status and consolidation, while a saved search returns whatever transactions match its criteria. Our guide to NetSuite saved searches explains why the two can show different totals.
How the Financial Report Builder works
When you customize a financial statement, you are working with two parts.
The row layout decides which rows appear and in what order: sections, account groupings, headers, subtotals and formula rows such as gross margin. A layout can be built from account types or from specific accounts.
The report definition decides the columns and filters: which periods, comparisons with prior periods or budgets, and which subsidiaries or segments are included.
Because a layout can be reused by several report definitions, NetSuite lets you edit it from more than one place. Before changing a shared layout, check which reports use it.
Customizing a statement step by step
- Start from a copy. Customize the standard report and save it under a new name, so the original stays available for comparison.
- Group by account type where you can. Rows based on account types pick up new accounts automatically. Rows based on a fixed list of accounts don't.
- Add subtotals and formula rows. Gross profit, EBITDA or contribution margin can be built as formula rows that reference other rows.
- Set up the columns. Add prior period, prior year or budget columns, plus variance columns if your reviewers expect them.
- Compare against the standard report. Before sharing it, run the customized statement and the standard one for the same period and confirm the totals agree.
Why a customized statement doesn't tie out
These are the checks we run first:
- An account isn't in the layout. A new account was created after the layout was built from a fixed list, so its balance falls outside every row.
- Net income on the balance sheet doesn't match the income statement. Usually the two reports are filtered on different periods or subsidiaries.
- Consolidated numbers look wrong. NetSuite translates income statement accounts at an average rate and balance sheet accounts at the period-end rate, with historical rates for equity. The translation difference has to land somewhere, and a custom layout can hide it.
- Prior period numbers changed. Someone posted to a period that should have been locked. Check period close status and who has permission to post to closed periods.
- Cash flow lines are misclassified. The cash flow statement depends on how accounts are set up, so a new account can show up in the wrong section.
Have our team check your custom statements against the GL
If your NetSuite data came from another system, some differences come from the migration rather than the report. Our Xero to NetSuite migration plan covers the cutover checks that prevent this. For teams that want help preparing management packs each month, our financial reporting service covers that work, and our post on offshore accounting for US businesses explains how that kind of support is usually set up.
Frequently asked questions
Can I change the standard NetSuite income statement?
You can customize it with the Financial Report Builder, but it's safer to save the customized version as a new report. That keeps the standard statement available as a reference when you need to check totals.
Why is an account missing from my customized balance sheet?
The most common reason is that the row layout lists specific accounts and the missing account was added later. Building rows from account types avoids this.
How do I add a budget comparison to a NetSuite financial statement?
Budgets have to be entered or imported into NetSuite first. Once they are, you can add budget and variance columns in the report definition for the periods you want to compare.
Why don't consolidated statements match the sum of my subsidiaries?
Consolidation translates each subsidiary into the parent's currency using different rate types for income statement and balance sheet accounts, and it applies intercompany eliminations. Both can make the consolidated figures differ from a simple sum.
Get your reporting sorted with Oakridge Global
Our NetSuite consultants build and maintain custom financial statements, and our accountants can prepare your monthly reporting pack from them. Schedule a consultation with Oakridge Global and send us the report your board actually wants to see.