Financial Reports in NetSuite: Trial Balance, GL, Income Statement, Balance Sheet
The four core reports, the question each one answers, how they connect to each other, and the order to investigate in when the numbers do not tie.
Every financial report in NetSuite reads the same source: the journals produced by transactions. What differs is the level of detail and the point of view. Understanding that relationship turns chasing a discrepancy into an ordered process rather than guesswork.
The four core reports
| Report | Answers | Nature |
|---|---|---|
| General Ledger | Which transactions touched this account? | Most detailed — one line per posting |
| Trial Balance | What is each account's balance, and does the ledger balance? | A summary of every account balance |
| Income Statement | Did we make a profit over this period? | A span of time (January to December) |
| Balance Sheet | What do we own and what do we owe? | A single point in time (as at 31 December) |
That difference in time is important and easily missed. An Income Statement always speaks about a span: profit for July. A Balance Sheet always speaks about a moment: the cash position as at 31 July. The question “what was the profit as at 31 July” has no meaning.
How the four connect
- 01A transaction is saved and produces a journal — visible on the GL Impact subtab.
- 02All journals accumulate in the General Ledger, ordered by account.
- 03Each account balance is summarised into the Trial Balance. Total debits must equal total credits.
- 04Revenue and expense accounts carry into the Income Statement, producing net profit.
- 05Asset, liability and equity accounts carry into the Balance Sheet — and that net profit lands in Retained Earnings.
Assets = Liabilities + Equity
Equity = Capital + Retained Earnings + Profit for the Period
└─ comes from the Income StatementThis is why the Income Statement and the Balance Sheet cannot be checked separately. Wrong profit on the Income Statement immediately unbalances the Balance Sheet, because net profit is the bridge between them.
The operational reports asked for most
- A/R Aging — the age of receivables per customer, the basis for collection.
- A/P Aging — the age of payables per supplier, the basis for payment planning.
- Inventory Valuation — the value of stock, which must agree with the Inventory account on the Balance Sheet.
- Sales by Item / by Customer — sales analysis, not a statutory financial report.
- Budget vs Actual — performance against budget.
- Statement of Cash Flows — the movement of cash, which can look very different from profit.
When the numbers do not tie, work downwards
- 01Start from the report in question and note the account and the period.
- 02Open the Trial Balance for that period to confirm the balance really is off.
- 03Drop into the General Ledger for that account, filter by date, and look for an unreasonable jump.
- 04Open the source transaction and read its GL Impact subtab — the cause shows up here.
- 05Check whether any manual journals were posted in that period; they are the forgotten suspect.
Closing the period
NetSuite provides a Period Close Checklist that closes a period in stages: bank reconciliation, inventory adjustment, currency revaluation, then locking. Once locked, no further transactions can post into it. The discipline of locking on time is what separates a report you can trust from one whose numbers change every time you reopen it.