NetSuite Comparative Cash Flow Statement in Excel
See where cash came from and where it went in two periods side by side, built in Excel from live NetSuite balances.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Standard Reports › Cash Flow opens a submenu with Cash Flow and Comparative Cash Flow. Callout: Standard Reports → Comparative Cash Flow. Comparative Cash Flow adds a Comparative Cash Flow sheet with a parameter block above two columns, D and E. The Subsidiary list opens and Headquarters (Consolidated) is highlighted. Callout: Pick each parameter from Finsyte’s dropdowns. Subsidiary is set to Headquarters (Consolidated), and column E follows it. Column D’s Fiscal Year is set to FY 2025 from its list. Column E’s Fiscal Year starts blank; its list opens and FY 2024 is highlighted. Callout: Add a second year to compare. Column E is set to FY 2024. Period Number is set to 12 from its list, column E follows, and the title line updates to As of December 31, 2025. Period Range is set to RTD from a list of RTD and PTD. Callout: Period and range come from dropdowns too. Column E follows, and Book stays on Primary Accounting Book. Pointing at Load Accounts on the ribbon shows its ScreenTip. Callout: Load Accounts builds the report. After the click, Cancel appears and the statement is listed while the status bar reads Queuing requests, Contacting NetSuite and then Processing Results, and both years fill in. Callout: Live balances from NetSuite. Under Operating Activities, Net Income is 3,312,601 for FY 2025 against 2,053,749 for FY 2024, a variance of 1,258,851, or 61%. Adjustments to Net Income follow, starting with Accounts Receivable, where Total - Accounts Receivable is (2,411,398) against (7,300,458). The parameter rows are collapsed with the outline button. Callout: Collapse the parameters to focus on the numbers. Scrolling to the end of the statement shows Net Change in Cash for Period of $1,484,373 against $1,108,799 and Cash at End of Period of $3,513,363 against $2,035,741, a variance of $1,477,622, or 73%, then the view returns to the top.

Where cash came from and where it went, period against period
The template sorts your NetSuite accounts by type into operating, investing and financing activities and fills both periods from live balances. Variance shows which activity drove the change in cash.
- Operating Activities from Net Income, adjusted for receivables, inventory, payables and other current accounts
- Investing Activities from fixed and other assets, and Financing Activities from long-term liabilities and equity
- Net Change in Cash for Period, Cash at Beginning of Period, Effect of Exchange Rate on Cash and Cash at End of Period
- Signs set for a cash flow, so an increase in receivables shows as a use of cash
- Variance and % Variance on every line
A static snapshot of a finished comparative cash flow statement, so you can see the layout before you connect NetSuite.
A two-period cash flow statement in four steps
Insert the template
On the Finsyte ribbon, choose Standard Reports › Cash Flow › Comparative Cash Flow. A Comparative Cash Flow sheet opens, ready for its parameters.
Set the span
Fill in Subsidiary, Fiscal Year and Period Number in column D, and choose RTD or PTD as the Period Range. Then pick column E’s Fiscal Year.
Load Accounts
Load Accounts groups your accounts into operating, investing and financing activities and fills both periods.
Refresh after the close
Use Refresh Data, or right-click › Refresh Selection for part of the sheet. Both periods update in place.
How the NetSuite comparative cash flow statement is built
The comparative cash flow uses the same pieces as the other Finsyte statements: a parameter block, one function call per account, and Excel arithmetic on top. What makes it a cash flow is how the accounts are grouped and signed. The layout applies the five rules for financial models that scale: inputs live apart from calculations, each Finsyte function has its own cell, and totals use AGGREGATE.
The parameter block
Each period column starts with Subsidiary, Fiscal Year and Period Number, then Period Range and Book. Optional rows follow for Entity, Currency, Transaction Type and Posted, plus the segment fields: Department, Class, Location, Item and your custom segments. Pick the rows you want in Template Parameters. Change any cell and the formulas below it recalculate automatically.
On this template, Period Range offers RTD and PTD only. RTD covers the fiscal year from its first period through the one you pick. PTD covers that single period. On balance sheet accounts, both return the change over that span rather than the balance, which is what a cash flow is built from.
The account tree
Load Accounts builds the statement from account types, following the layout of NetSuite’s Cash Flow report:
- Operating Activities: Net Income, then adjustments for Accounts Receivable, Unbilled Receivables, Inventory Asset, Other Current Asset, Accounts Payable, Payroll Liabilities, Sales Tax Payable and Other Current Liabilities
- Investing Activities: Fixed Asset and Other Asset accounts
- Financing Activities: Long Term Liabilities and Equity accounts
Net Change in Cash for Period, Cash at Beginning of Period, Effect of Exchange Rate on Cash and Cash at End of Period close the statement. Within each type, your accounts keep their NetSuite hierarchy as Excel outline groups.
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.
Consolidating? Choose the top-level (Consolidated) subsidiary in column D first, and Load Accounts picks up accounts from every entity. Where an entity doesn’t use one, its line reads 0.
Two period columns, one function
Each line is a call to GLAccountBalance. Almost every line on a cash flow is sign-reversed, so with every optional filter row turned on, a typical account cell in column D reads:
=-FSN.GLAccountBalance(D$5,D$6,D$7,D$8,$B22,D$9,D$10,D$11,D$12,D$13,D$14,D$15,D$16,D$17)Copy it one column right and it becomes a column E formula: the row-locked parameter references shift to E, while $B22 still points at the same account. The rows shown here are examples; yours shift with your chart of accounts and filter rows.
Both years are your choice: column E’s Fiscal Year is empty until you set it. Its Period Range follows column D’s, and so do its other parameters, through formulas such as =$D5, until you overwrite them. With RTD and your last period, the two columns compare full fiscal years. With PTD, each column covers one period of the year you gave it.
Variance and % Variance
Variance subtracts column E from column D:
=D20-E20% Variance turns it into a percentage of the size of column E, so a line that used less cash than before reads as a positive change. Where column E is 0, it shows n/m:
=IF(E20=0,IF(D20=0,0,"n/m"),(D20-E20)/ABS(E20))Read down the variance column to see whether operations produced more or less cash than in column E’s period, and whether investing or financing made up the difference. Right-click any line and choose Drill Down to see the activity behind it by period, entity or transaction line.
Subtotals and signs
Each activity’s subtotals are AGGREGATE formulas over the lines above them:
=AGGREGATE(9,0,D$20:D$29)AGGREGATE ignores nested subtotals, so no total is counted twice. Every account except Cash at Beginning of Period is sign-reversed, so an increase in receivables shows as a negative number: a use of cash. The leading minus is what right-click › Switch Sign adds.
Change what’s compared
Load Accounts folds the parameter rows away. Open them from the outline bar and change a cell in column E:
- Period Number, to set one month’s PTD cash flow beside the month before
- Subsidiary, to compare how two entities generate and use cash
- Currency, to show both columns in the top-level parent’s currency when the entities’ currencies differ
- Location or a custom segment, for a narrower slice of the ledger
A segment works when your balance sheet postings carry it, including custom segments such as Activity Code, and you can combine several in one column. Each column’s formulas recalculate automatically, and Variance follows. For a single-period statement, see the NetSuite cash flow statement template.
It’s Excel, so extend the cash flow
The template gets you started. In Excel, you make it your own: every line is its own cell formula, so free cash flow, a cash bridge chart or your own subtotals can sit beside the two periods. A refresh updates both columns, and everything you built follows.
- Free cash flow for each period
- Cash conversion from net income
- A bridge chart from opening to closing cash
- Depreciation as an operating add-back
- Notes for the lender or board pack
NetSuite comparative cash flow statement: FAQ
- QHow do I compare two years of cash flow from NetSuite in Excel?
- Insert the Comparative Cash Flow template and fill in column D, with RTD as the Period Range and your last period as the Period Number. Pick a Fiscal Year for each column and choose Load Accounts. It builds both years, and the variance columns show what changed.
- QCan I compare subsidiaries instead of years?
- Yes. Load the statement from the top-level (Consolidated) subsidiary in column D so it includes every account. Keep the year identical in both columns and switch column E to the other subsidiary. Each column shows its subsidiary’s own currency by default; when the two differ, set both columns’ Currency to the top-level parent’s currency. Lines a subsidiary can’t use read 0.
- QHow are Variance and % Variance calculated?
- Variance is column D minus column E, line by line. % Variance is that change as a percentage of the size of column E, so it carries the same sign as Variance, with n/m wherever column E is 0. Click any variance cell to see the formula.
- QCan I add a third period?
- Yes. Duplicate either period column and give the copy its own Fiscal Year or Period Number. Its formulas read the copy’s parameters, so it’s live from the start.
- QWill my own formulas survive a refresh?
- Yes. A refresh recalculates the Finsyte functions, and free cash flow or any other formula built on them recalculates too. Leave Load Accounts alone on a model you’ve customized: it rebuilds the account rows in the template’s columns, and your layout is lost.
Try the comparative cash flow statement template with your own NetSuite data
30-day free trial with every Finsyte template included. No credit card required.
Related templates
- NetSuite Cash Flow Statement in Excel
- NetSuite Balance Sheet in Excel
- NetSuite Income Statement Template for Excel
- NetSuite Trial Balance in Excel
- NetSuite Budget vs Actual in Excel
- Five rules for financial models that scale
- Drill Down into NetSuite from Excel
- Refresh NetSuite Data in Excel
- All NetSuite Excel report templates
- Comparative Cash Flow Template: setup steps in the docs