Management accounts and the monthly package from a NetSuite trial balance

1. Go to Reports, Financial, Trial Balance.
2. In the footer, set the Date or Period; the As of field shows the result. Which one you get depends on the Report by Period preference; with it on, custom dates aren't available.
3. Set Column to Debit/Credit, two columns, or Total, one; Debit/Credit makes the balance check easy.
4. Click Refresh, then export to Excel or CSV. Avoid PDF for a large chart of accounts.

Sources: Oracle NetSuite Help, Trial Balance Report and Exporting a Report.

NetSuite's Trial Balance includes income statement accounts only from 1 January of the calendar year up to the As of date, with earlier results in retained earnings. If the company's fiscal year starts in another month, don't take the year to date from this report alone: export each month and let Magic MIS build the year to date from the company's own year start, set once.

In OneWorld accounts the Subsidiary Context decides whose figures you see: one subsidiary shows its own, a consolidated parent shows all its children, with a translation adjustment line at the bottom. Magic MIS reports one company at a time and doesn't consolidate, so export each subsidiary separately.

NetSuite charts often carry account numbers and sub-accounts. Choose the level you report at; child accounts can roll into one line. Each account is mapped once to a line of the report, by rules first and the AI only for what the rules can't place, and every choice can be changed on the company's ledger map. Next month only accounts that are new need placing; the rest are remembered.

An invented US subsidiary:

NetSuite's standard year to date would have started in January. Building it from monthly activity gives the April to September figures the board actually uses.