Ledger listings

Pick the right view

The totals views link to detail routes carrying the selected dimension ids. Plain and budget detail routes encode subsidiary, account and period; extended routes add category and channel. These ids identify the row, not human account numbers or dates.

Use search, column selection and sorting as described in table controls. These are inspection screens, not editors.

Actuals and budgets have different sources

NetSuite supplies actual plain and extended totals. Budgets are loaded from config/reference/budget/gl_accounttotalperperiod_<year>.csv by app/jobs/install/reset_accounttotalperperiod_budget.php. A missing budget period is not repaired by rerunning a NetSuite actuals worker.

The plain and extended full-reset jobs drop and recreate their totals tables and queue a reload. The budget reset drops and recreates its table and reads the CSVs. These totals have no staged swap: a reset can leave a table empty or incomplete while it runs. Use backfill history and the README installation sequence before planning a reset; a reset is not a read-only refresh button.

Reconcile a report

1. Match subsidiary and accounting period before comparing amounts.
2. Match the GL account through accounts.gl_account = gl_accounts.id. A displayed account number is not that internal id.
3. On extended totals, include the category and sales channel. Aggregate those dimensions before comparing with a plain total; do not join a plain total onto every extended row and sum it.
4. In the income statement, match Actual/Budget, date range, Invert, scaling and rounding options.
5. Check refresh status if dimensions agree and amounts still differ. Source totals and computed transaction contribution answer different questions and need not be identical.

Related

• The income statement
• Accounts
• NetSuite
• Data model

Evidence

Code-checked: the named controllers, data endpoints and templates under generalledger, app/models/generalledger.php detail getters, app/models/accounts.php, app/jobs/install/reset_accounttotalperperiod_full.php, reset_accounttotalperperiodextended_full.php and reset_accounttotalperperiod_budget.php.