NetSuite Trial Balance in Excel

Each balance is its own formula reading the parameters above its column, so a copied column works on its own. That makes the trial balance easy to lay out across months or entities.

Flat or grouped

The Trial Balance layout is a plain account list, ready to sort, filter or carry into a reconciliation. The Grouped Trial Balance organizes the same accounts by your NetSuite chart of accounts, with Excel outline levels so each group collapses to its total. Both layouts use the same parameters, the same balances and the same Total row.

By month

Set Period Range to YTD to get the trial balance as of the end of the period you pick: balance sheet accounts as balances, income statement accounts as year-to-date activity. For a trial balance by month, duplicate the balance column and change only the Period Number in each copy. Twelve columns give you each month-end of the year, each one live. Each column keeps its own Period Number, so changing one month never touches the others.

By subsidiary

Start from the top-level (Consolidated) subsidiary and Load Accounts brings in every account you have. Then copy the balance column once per subsidiary and change the Subsidiary at the top of each copy; the docs walk through four subsidiaries side by side this way. Accounts a subsidiary doesn’t use show 0.

Local currency or the parent’s, on one sheet

A subsidiary’s column shows its own currency by default. Set the column’s Currency to the top-level parent’s currency and the same balances appear in that currency instead. NetSuite translates them at its own exchange rates, so they match its reports. A NetSuite report shows all its values in the one currency you pick for it. Finsyte works cell by cell, so one trial balance can show each subsidiary in its local currency beside the same accounts in the parent’s currency.

Any segment, any combination

Location and your custom segments, such as Activity Code, are parameters on every column. Set one for a trial balance by location, or combine several in one column. A segment view needs that segment on your balance sheet postings, not only on income and expenses. Choose which parameters appear in Template Parameters.

A Total row that confirms the sheet is complete

NetSuite posts every transaction in balance, so the Total row is a completeness check. Account signs aren’t reversed, and the total nets to zero when every account with a balance is on the sheet. The template lists active accounts, so a total other than zero points to an account that’s missing, such as one made inactive while it still held a balance.

Consolidation translates balance sheet accounts at the period-end rate, income statement accounts at the average rate and equity at historical rates, and those don’t net to zero. The Cumulative Translation Adjustment carries the difference, calculated the way NetSuite does, and is included in the total. For a single entity in its own currency, it’s zero.

Drill into any balance

Right-click a balance and choose Drill Down. A new sheet breaks that number down by subsidiary, period, department, class, location or entity, or lists the transaction lines behind it, all within the same parameters as the cell. It’s the quickest way to trace an account that won’t tie.

Compare two periods

A trial balance with two periods side by side, plus Variance and % Variance columns, has its own template. See the comparative trial balance.