01
About this report
Balances from the general ledger, primary accounting book, for everything posted through today, in base currency. Assets read debit-positive, liabilities and equity credit-positive. NetSuite moves net income into retained earnings only on the statement, so this report adds net income for all years to date as its own equity line. With that line, assets equal liabilities plus equity.
Filter on Section or Account type to read one block, or sort by Balance to see the largest accounts. In a OneWorld account, balances of subsidiaries with different base currencies are added without translation, so the totals only hold for a single base currency.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Section | Account type | Account number | Account | Balance |
|---|---|---|---|---|
| Assets | Bank | 1000 | 1000 Operating account | 842,300.15 |
| Assets | Accounts Receivable | 1200 | 1200 Accounts Receivable | 376,200 |
| Liabilities | Accounts Payable | 2000 | 2000 Accounts Payable | 131,410.30 |
| Liabilities | Other Current Liability | 2200 | 2200 Sales tax payable | 18,244.90 |
| Equity | Equity | 3000 | 3000 Common stock | 100,000 |
| Equity | Equity | Net income, all years to date | 968,844.95 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT section, section_order, account_type, account_number, account, balance
FROM (SELECT CASE WHEN a.accttype IN ('Bank', 'AcctRec', 'UnbilledRec', 'OthCurrAsset', 'FixedAsset', 'OthAsset', 'DeferExpense') THEN 'Assets'
WHEN a.accttype IN ('AcctPay', 'CredCard', 'OthCurrLiab', 'LongTermLiab', 'DeferRevenue') THEN 'Liabilities' ELSE 'Equity' END AS section,
CASE WHEN a.accttype IN ('Bank', 'AcctRec', 'UnbilledRec', 'OthCurrAsset', 'FixedAsset', 'OthAsset', 'DeferExpense') THEN 1
WHEN a.accttype IN ('AcctPay', 'CredCard', 'OthCurrLiab', 'LongTermLiab', 'DeferRevenue') THEN 2 ELSE 3 END AS section_order,
BUILTIN.DF(a.accttype) AS account_type,
a.acctnumber AS account_number,
a.displaynamewithhierarchy AS account,
SUM(CASE WHEN a.accttype IN ('Bank', 'AcctRec', 'UnbilledRec', 'OthCurrAsset', 'FixedAsset', 'OthAsset', 'DeferExpense') THEN tal.amount ELSE -tal.amount END) AS balance
FROM transactionaccountingline tal
JOIN accountingbook ab ON ab.id = tal.accountingbook AND ab.isprimary = 'T'
JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account
WHERE tal.posting = 'T'
AND t.trandate <= SYSDATE
AND a.accttype NOT IN ('Income', 'COGS', 'Expense', 'OthIncome', 'OthExpense', 'NonPosting', 'Stat')
GROUP BY a.accttype, BUILTIN.DF(a.accttype), a.acctnumber, a.displaynamewithhierarchy
UNION ALL
SELECT 'Equity', 3, 'Equity', NULL, 'Net income, all years to date', SUM(-tal.amount)
FROM transactionaccountingline tal
JOIN accountingbook ab ON ab.id = tal.accountingbook AND ab.isprimary = 'T'
JOIN transaction t ON t.id = tal.transaction
JOIN account a ON a.id = tal.account
WHERE tal.posting = 'T'
AND t.trandate <= SYSDATE
AND a.accttype IN ('Income', 'COGS', 'Expense', 'OthIncome', 'OthExpense'))
WHERE ROUND(balance, 2) <> 0
ORDER BY section_order, account_number, account