NetSuite Cash Flow Statement in Excel

The account tree follows NetSuite’s Financial Report: Cash Flow, so the Excel version and the NetSuite report line up section by section. Each cell is its own formula reading the parameters above its column.

Operating activities

Net Income comes first, followed by adjustments to net income for accounts receivable, unbilled receivables, inventory, other current assets, accounts payable, payroll liabilities, sales tax payable and other current liabilities. Each group collapses to its total, so you can show the summary or open any line.

Investing and financing activities

Investing covers fixed assets and other assets. Financing covers long-term liabilities and equity. Below them sit Net Change in Cash for Period, Cash at Beginning of Period, Effect of Exchange Rate on Cash and Cash at End of Period.

Accumulated depreciation is usually a Fixed Asset account in NetSuite, so depreciation sits in investing activities, netted against capital spending. To show it as a non-cash add-back under operating activities, move those rows up.

Signs that read like a cash flow statement

Each line shows its effect on cash. The template reverses the sign of every account except Cash at Beginning of Period, so an increase in receivables shows as a use of cash. It’s the same reversal that right-click Switch Sign applies to any balance.

Break a line down

Right-click any amount 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.

Read it at any level

Every group in the tree is an Excel outline level. Collapse to the three activity sections for a board summary, or open Accounts Receivable to see which receivables moved. A collapsed group shows its total in place.

One period or the year to date

Period Range takes PTD for a single period or RTD for the fiscal year to date. On balance sheet accounts, both return the change over that span rather than the balance, which is what a cash flow is built from. For a month-by-month view, set Period Range to PTD, then duplicate the balance column and change only the Period Number in each copy.

One subsidiary, or consolidated

Set Subsidiary to one entity, or pick its (Consolidated) entry to roll up that subsidiary and every subsidiary below it. Start from the top-level (Consolidated) subsidiary and Load Accounts brings in every account you have. Accounts an entity doesn’t use show 0. A subsidiary’s column shows its own currency by default, or the top-level parent’s currency when you set the column’s Currency.

Any segment, any combination

Location and your custom segments, such as Activity Code, are parameters on every column. Set one for a cash flow 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.

Compare two periods

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