Skip to main content

Cash Flow Template

The Cash Flow Template makes it easy to consume gl accounts (operating activities, investment activities, net change in cash, etc.) and their balances based on parameters of Subsidiary, Fiscal Year, Period Number, and Period Range. The only Period Range options for this template are PTD and RTD.

See the cash flow template in action.

Utilizing the Cash Flow Template

  1. Select Standard Reports > Cash Flow > Cash Flow
  2. View the new sheet that has been created called Cash Flow
  3. Fill in all required parameters (asterisks by the names)
  4. Select the now activated button in the ribbon under Actions of Load Accounts. Finsyte will go to NetSuite to return the appropriate list of GL Account numbers and balances based on the identified Subsidiary input.

Remarks

  • The returned tree structure of GL Accounts matches what you will see in NetSuite for the Financial Report: Cash Flow.
  • Review the Subsidiary column in the GL Accounts list to understand which accounts utilize which subsidiaries. The SubsidiariesHasAccess column generated by Finsyte can also be insightful for this.
  • For a consolidated report, or several subsidiaries side by side, select the top-level (Consolidated) subsidiary before you select Load Accounts so the sheet brings in every account. An account a subsidiary can't use returns 0 and can be ignored.
  • Once you've customized the template, don't select Load Accounts again. It rebuilds the account list for the first balance column only, which undoes your layout.
  • Aggregate functions are utilized on the totals for groups in the financial statement to ensure proper totaling.
  • Every account except Cash at Beginning of Period has reversed signs for totaling purposes.

Note: For more information on viewing the Cash Flow statement inside of NetSuite, view NetSuite's documentation (opens in new tab).

Example Cash Flow Statement

  1. Select Standard Reports > Cash Flow > Cash Flow to get the initial template
  2. Fill in the parameters (required with *) at the top of the sheet and select Load Accounts to get full account list with account balances and totals.
  3. Adjust parameters as needed. The balances update on their own.
  4. The Switch Signs operation has already been applied to corresponding account sections.

CashFlowGIF