FrontierERP
Sign inTalk to Frontier
Applied guide

Why the cash flow won't tie to the balance sheet

NetSuite builds the cash flow statement from balance changes by account type. One group's month footed to the change in Bank, each line named, to zero.

Frontier · November 18, 2026

An applied guide for the controller or FP&A lead who has to tie the cash flow statement to the balance sheet's change in cash.

The short answer. NetSuite's Cash Flow Statement starts from net income and adds the changes in balance-sheet accounts, each in the section its account type selects, so its lines record balance movements, not cash movements (Oracle). When the two ends are right and the lines are not, check five causes, in this order: an account whose type sits in another section, a non-cash entry between two balance-sheet accounts, a report run by transaction date instead of posting period, the Effect of Exchange Rate on Cash row, and, for Cash at Beginning of Period on a customized statement, a custom section (Oracle). Below, one constructed group's October is footed from two balance sheets to the change in Bank, line by line, to zero, and each line that a US GAAP reader would show differently is named.

This is the fifth tie-out on this site, on the same Harbor group. Why a saved search won't match NetSuite's P&L reconciles its October, and Why a saved search won't match the balance sheet its 31 October balance sheet. Why A/R aging won't tie to the balance sheet and Why the consolidated TB isn't the sum of the subs take two more views of the same date. This one puts a second balance sheet a month earlier and reads the cash flow statement between the two.

The five causes, in Oracle's words.

  • Sections follow account type. "Standard section data are selected based on account type and are grouped by accounts." The standard rows put Accounts Receivable, Unbilled Receivable, Inventory Asset, Other Current Asset, Accounts Payable, Payroll Liabilities, Sales Tax Payable and Other Current Liabilities under Operating Activities; Fixed Asset and Other Asset under Investing; Long Term Liabilities, Opening Balance Equity and Other Equity under Financing (Cash Flow Statement Report). An account records whatever is posted to it, so an investing payment booked to an Other Current Asset account lands in Operating Activities.
  • Non-cash entries move lines. "Operating activities begin with the net income amount referenced from the Income Statement, and include adjustments for changes in account balances that affect available cash" (Cash Flow Statement Report, above). The adjustments are the changes in account balances, so a journal or bill between two balance-sheet accounts in different sections moves two lines, one up and one down, though no cash moved. US GAAP reports the cash and discloses the rest: "Information about all investing and financing activities of an entity during a period that affect recognized assets or liabilities but that do not result in cash receipts or cash payments in the period shall be disclosed", and "only the cash portion shall be reported in the statement of cash flows" (ASC 230-10-50-3 and 50-5, quoted in KPMG's Statement of cash flows handbook).
  • Date or period. "If you filter by date range, report records are selected by transaction date. If you filter by period, report records are selected by posting period." The Report by Period preference decides which, and on Never "All reports will be run by transaction dates instead of posting periods" (Reports FAQ). Oracle's pages disagree on where the preference sits. The FAQ says to click "the Reporting/Search subtab"; the Cash Flow Statement page says it is "on the Analytics subtab", and so does the reporting preferences page, which lists the Cash Flow Statement among the reports Financials Only runs by period.
  • The Effect of Exchange Rate on Cash row. "For NetSuite OneWorld with multi-currency enabled, consolidated cash flow statement reports include an Effect of Exchange Rate on Cash row." It "adjusts for the effects of rate differences in cash flow statement accounts for the period", and "This adjustment ensures the cash flow statement's Cash at End of Period is consistent with the balance sheet's Bank or cash equivalent." It "is a calculated amount that accounts for the related amount in the Cumulative Translation Adjustment (CTA) account", and "Generally no postings are made" for it (Cash Flow Statement Report, above). Each account has "a general rate type and a cash flow rate type", and by default "Cash Flow Rate Type: Average - for all accounts except equity" (Consolidated Exchange Rate Types).
  • Custom sections break Cash at Beginning of Period. "If you create a custom Cash Flow Statement that includes custom sections, its value for the Cash at Beginning of Period row is likely to be incorrect" (Cash Flow Statement Report, above). The row "references the Total Cash row in the standard Cash Statement", and "the Total Cash value referenced from the Cash Statement doesn't include the added or changed sections" (Customizing Cash Flow Statement Account Sections).

None of this is a defect. Net income adjusted for the change in every other balance-sheet account is the indirect method's arithmetic, and it reaches the change in cash. The trouble is that the arithmetic doesn't know which changes were cash. A statement can foot to the penny with an investing payment in Operating and a purchase on credit in two sections at once, and nothing in its total tells you.

Harbor's October, between two balance sheets.

This is the group from the earlier pages: Harbor Inc., a US parent reporting in US dollars; Harbor GmbH, its German subsidiary, keeping its books in euros; and Harbor Elimination, the elimination subsidiary. Every amount and rate below is constructed for the example and labelled as such; nothing comes from a live account. A script committed beside this page generates the figures and re-foots them.

October's income is the P&L page's, 78,600, and the 31 October balance sheet is the balance-sheet page's, split here into accounts. Four things happened in October that touch no income account:

  • Harbor Inc. took delivery of USD 40,000 of servers on 20 October, on a vendor bill due in 30 days and unpaid at month-end, booked to an Equipment account of type Fixed Asset. Under Harbor's policy, depreciation starts the month after delivery.
  • Harbor GmbH paid a machinery supplier a EUR 30,000 advance on 12 October for a machine due in January, booked to an Advances to suppliers account of type Other Current Asset.
  • Harbor Inc. wrote off 2,500 of receivables against its bad-debt allowance on 31 October, the journal on the A/R page. The allowance is an Other Current Asset account.
  • Customers paid and vendors were paid, all straight to Bank, so the group holds no undeposited funds.

The 30 September balance sheet is 31 October's less October's postings.

Harbor, consolidated 30 Sep 31 Oct Change Cash flow row
Bank 1,521,400 1,528,000 6,600 Cash
Accounts receivable 273,100 282,400 9,300 Accounts Receivable
Bad-debt allowance (7,500) (5,000) 2,500 Other Current Asset
Advances to suppliers — 33,000 33,000 Other Current Asset
Prepaid expenses 79,800 79,800 — Other Current Asset
Equipment — 40,000 40,000 Fixed Asset
Total assets 1,866,800 1,958,200 91,400
Accounts payable 236,200 249,000 12,800 Accounts Payable
Accrued liabilities 215,000 215,000 — Other Current Liabilities
Share capital 500,000 500,000 — Other Equity
Retained Earnings 348,400 348,400 — none
Net Income 561,450 640,050 78,600 Net Income
CTA 5,750 5,750 — Effect of Exchange Rate on Cash
Liabilities and equity 1,866,800 1,958,200 91,400

USD. Harbor Inc. (Consolidated), primary book, by posting period. Constructed figures; generated and re-footed by the packet script. The 31 October totals, receivables, Retained Earnings, Net Income and CTA are the earlier pages'. Harbor GmbH's assets and liabilities are at the current rate, 1.1000 at both month-ends (the A/R page's 30 September rate and the balance-sheet page's 31 October one), and its equity as on the balance-sheet page; its Bank went from EUR 449,000 to EUR 430,000. Net Income is the year to date, so its change is October's income. The last column is the standard statement's row for each account's type.

NetSuite's Cash Flow Statement for Harbor Inc. (Consolidated), October 2026, primary book, run by period, is the change column, signed and sorted into those rows. The middle column below takes every line from the two balance sheets instead.

Cash Flow Statement, Oct 2026 NetSuite Balance sheets Difference
Net Income 78,600 78,600 0
Accounts Receivable (9,300) (9,300) 0
Other Current Asset: allowance (2,500) (2,500) 0
Other Current Asset: advances (33,000) (33,000) 0
Accounts Payable 12,800 12,800 0
Total Operating Activities 46,600 46,600 0
Fixed Asset: equipment (40,000) (40,000) 0
Total Investing Activities (40,000) (40,000) 0
Total Financing Activities — — 0
Net Change in Cash for Period 6,600 6,600 0
Cash at Beginning of Period 1,521,400 1,521,400 0
Effect of Exchange Rate on Cash — — 0
Cash at End of Period 1,528,000 1,528,000 0

USD. Constructed figures. An increase in an asset is an outflow, an increase in a liability an inflow. Rows with no amount this month are left out. Cash at Beginning of Period is the Cash Statement's Total Cash, which "includes cash in bank accounts as well as undeposited funds" (Cash Statement Report); Harbor holds none of the second.

It foots: net income and five balance changes come to 6,600, and so does the change in Bank. The Effect of Exchange Rate on Cash row is zero, and that is a property of this month, not of the method. Harbor GmbH's flows take October's average rate, its opening cash the 30 September current rate and its closing cash the 31 October current rate, and all three are 1.1000. The CTA is 5,750 at both month-ends for the same reason. In a month where they differ, the row carries their effect on cash, and a foreign subsidiary's line rebuilt from two translated balance sheets will generally differ from NetSuite's line for that account.

From NetSuite's lines to US GAAP's.

The ends are right. Three lines are not the ones a US GAAP statement shows, and each comes from Harbor's own entries:

1 · Write-off. The 2,500 journal took receivables down and the allowance with them. Accounts Receivable reads it as 2,500 collected, Other Current Asset as 2,500 spent. No cash moved; read as one line, receivables net of the allowance, the journal is nothing at all.

2 · Advance. The EUR 30,000 advance is in Operating Activities because its account is an Other Current Asset. US GAAP counts it as investing: "Generally, only advance payments, the down payment, or other amounts paid at the time of purchase or soon before or after purchase of property, plant, and equipment and other productive assets are investing cash outflows" (ASC 230-10-45-13(c), in KPMG's handbook, above).

3 · Equipment. The servers appear twice: 40,000 spent under Fixed Asset in Investing and 40,000 received under Accounts Payable in Operating. Neither happened in October. KPMG lists "purchases of PP&E with unpaid costs accrued within accounts payable" among noncash investing activities, disclosed beside the statement, not in it. The cash goes out as investing when the bill is paid in November.

October 2026 NetSuite 1 · Write-off 2 · Advance 3 · Equipment ASC 230
Net income 78,600 — — — 78,600
Receivables (9,300) (2,500) — — (11,800)
Other current assets (35,500) 2,500 33,000 — —
Accounts payable 12,800 — — (40,000) (27,200)
Operating 46,600 — 33,000 (40,000) 39,600
Equipment and advances (40,000) — (33,000) 40,000 (33,000)
Investing (40,000) — (33,000) 40,000 (33,000)
Financing — — — — —
Net change in cash 6,600 — — — 6,600

USD. Constructed figures; generated and re-footed by the packet script. Each reconciling column sums to zero, so the net change doesn't move. Noncash investing activity, disclosed: equipment bought on account, 40,000.

The last column can be checked without the balance sheets. Read off the Bank lines alone, Harbor received 163,200 from customers and paid 123,600 to suppliers, and the intercompany fee went out of one bank and into the other. That is 39,600 from operations and the 33,000 advance, the same two figures.

The other two causes leave Harbor's statement as run alone, and each is one setting away:

  • Run by date, two lines move. The P&L page's vendor bill dated 30 October is in November's posting period. With Report by Period set to Never, it falls in October: Net Income reads 70,600 and Accounts Payable 20,800, and Total Operating Activities stays 46,600. Cash moved in neither case.
  • Fix line 2 with a custom section, and check Cash at Beginning of Period. The Financial Report Builder lets a section use "dynamic criteria other than account type", account name included (Cash Flow Statement Report, above), so advances can be given a section under Investing Activities. That is a change to a standard account section, the case Oracle's warning covers. Its fix: "create a custom Cash Statement that shares these custom sections and make that custom Cash Statement the referenced report for the Cash at Beginning of Period row" (same page). Oracle's own example customizes the statement "to reflect non-cash additions and deductions to Net Income, such as depreciation and amortization" (Customizing Cash Flow Statement Account Sections, above). Harbor's primary book has none in October; its servers start depreciating in November.

Check before you trust the lines.

Run the statement and both balance sheets for the same subsidiary context, accounting book and Report by Period setting. Then run six checks, each naming the setting, report or field that decides it.

  1. Does the net change equal the change in cash? Take cash as the Cash Statement does, bank accounts and undeposited funds together (Cash Statement Report, above), not bank accounts alone. If it is out on a consolidated statement, look at the Effect of Exchange Rate on Cash row (check 5) before anything else.
  2. Which section did each account get? The statement is "grouped by accounts" (Cash Flow Statement Report, above), so expand each section and read the account type of anything unexpected, such as advances and deposits for equipment, or loans booked as current liabilities. Move them with section criteria and then do check 6.
  3. Which entries moved no cash? List the month's journals and bills with no Bank line that post to two balance-sheet accounts in different sections: equipment on a bill, reclassifications, write-offs. Each moves two lines and leaves the total alone. Under US GAAP the investing and financing ones are disclosed, not shown.
  4. Date or period? Check the Report by Period preference, on Analytics or Reporting/Search depending on which Oracle page you follow. A pull filtered on transaction date behaves like Never. Each document dated in one month and posted in another moves its lines between the two months.
  5. Is there an Effect of Exchange Rate on Cash row? On a consolidated multi-currency statement, check the Cash Flow Rate Type on each account record and, at Lists > Accounting > Consolidated Exchange Rates (Calculating Consolidated Exchange Rates Automatically), the month's average and the two month-end current rates. Where they differ, the row carries their effect on cash, and a translated line can differ from its balance-sheet change. US GAAP shows the same effect "in a separate line item as part of the reconciliation of the change in cash, cash equivalents and restricted cash during the period" (KPMG's handbook, above).
  6. Is the statement customized? Open the Cash at Beginning of Period row in the Financial Report Builder and check its referenced report. With custom sections, it should be a custom Cash Statement that shares them.

A statement that passes all six and still looks wrong has a cause this page doesn't cover, and that one is worth a ticket. One that fails a check has its answer.

What this means for an AI-built cash flow.

The same causes apply to a cash flow statement that an assistant builds from your account, whatever the tool. Frontier's direct cash flow is one of nine standard statements: monthly cash impact split into operating, investing and financing, with a bank validation row, for a date range, an optional subsidiary and one accounting book. The query and the rows come attached.

Its contract states its assumptions, and they decide what it returns:

  • Classified by account type. Its contract says it matches "NetSuite's native cash-flow logic": income-statement, receivable, payable, other current asset, other current liability and credit card types are Operating; Fixed Asset and Other Asset are Investing; Long Term Liability and Equity are Financing. So it puts Harbor's advance and servers where NetSuite does, and the three regroupings above apply to it unchanged.
  • A Bank validation row. The Cash row is the movement on Bank-type accounts, and the contract asks for the three categories to be checked against it before the numbers are presented. NetSuite's Cash Statement also counts undeposited funds; on our own demo account that is an Other Current Asset account, so a receipt not yet deposited is cash in NetSuite's statement and not in Frontier's.
  • By transaction date. It filters on transaction date, not posting period, and its contract accepts a drift of about 2 to 4 % against NetSuite's report at period boundaries. On Harbor, the 30 October bill shows in October's expense and payable rows and nets out inside Operating.
  • Deferral accounts left out. Lines on accounts of the Deferred Revenue, Deferred Expense and Unbilled Receivable types are excluded, so their movement appears in none of the four rows. NetSuite's standard statement carries Unbilled Receivable as a row of its own.
  • No exchange-rate row. Run for one subsidiary, it comes back in that subsidiary's own currency. Run without a subsidiary, it adds each subsidiary's base-currency amounts together without translating them. Its contract carries CTA as an Equity movement, and NetSuite calculates CTA in consolidated reports "dynamically, not posted to the account" (CTA Overview), so by default there is no CTA posting for it to read.

For Harbor that is a run per subsidiary:

Run, October 2026 Operating Investing Financing Bank row
Harbor Inc. (USD) 67,500 (40,000) — 27,500
Harbor GmbH (EUR) (19,000) — — (19,000)
Harbor Elimination (USD) — — — —
Per subsidiary, GmbH at 1.1000 46,600 (40,000) — 6,600
No subsidiary 48,500 (40,000) — 8,500

Constructed figures: what the statement's query returns on Harbor's October postings, derived from its published query and generated by the packet script.

Translated at October's 1.1000, Harbor GmbH's run added to Harbor Inc.'s gives NetSuite's three section totals and its 6,600. Run without a subsidiary, the Bank row reads 8,500: Harbor GmbH's euros counted as dollars. On a multi-currency group, run it one subsidiary at a time and translate. On our own demo account, which had no postings to deferral-type accounts from January 2025 to October 2026, a query with the statement's joins and filters showed the Bank row equal to the three categories in every one of those months.

On access: Frontier reads your NetSuite through one integration role that you create and can revoke at any time: web-services only, view-level record permissions. Every answer carries the query and the rows behind it, so your team can check any figure against the ledger.

One next step: put this month's cash flow statement beside the two balance sheets it sits between, for the same subsidiary context, book and Report by Period setting, and fill in the middle column of the second table. Then walk the six checks. Each line that is left belongs to one of them, and the list you end up with is the reconciliation.

Sources and limits.

Every figure in this guide is constructed to show the mechanism. None comes from a customer account, and the page carries no query. The two demo-account facts come from logged read-only queries and are not figures from a NetSuite report. Statements about NetSuite's behaviour are quoted or paraphrased from Oracle's documentation, linked where they appear: the Cash Flow Statement report, the Cash Statement report, customizing Cash Flow Statement account sections, calculating consolidated exchange rates, consolidated exchange rate types, the CTA overview, period and date filtering and reporting preferences. US GAAP is quoted from KPMG's Statement of cash flows handbook (March 2026), which reproduces ASC 230. Your account's account types, customizations, preferences and currencies decide which of the six checks apply to you, and the checklist is how to find out.

Questions this raises

Why doesn't NetSuite's cash flow statement tie to the balance sheet's change in cash?
NetSuite's Cash Flow Statement starts from net income and adds the changes in balance-sheet accounts, each in the section its account type selects. Its lines therefore record balance movements, not cash movements. When the net change ties but the lines look wrong, check four things: an account whose type sits in a different section from the activity it records, a non-cash entry between two balance-sheet accounts, a report run by transaction date instead of posting period, and the Effect of Exchange Rate on Cash row on a consolidated multi-currency statement. When Cash at Beginning of Period is wrong on a customized statement, Oracle's documentation names custom sections as a cause. The page foots one constructed group's month to the change in Bank, line by line, to zero.
How do I show depreciation as an adjustment to net income on NetSuite's cash flow statement?
Oracle's own customization example does exactly that. In the Financial Report Builder, add an Expense section under Adjustments to Net Income whose criteria select the depreciation and amortization expense accounts, and share it. Then customize the Cash Statement to include the same shared section, and make that custom Cash Statement the referenced report for the Cash at Beginning of Period row. Oracle warns that a custom Cash Flow Statement with custom sections is otherwise likely to show an incorrect Cash at Beginning of Period.
What is the Effect of Exchange Rate on Cash row?
A row that consolidated cash flow statements carry on NetSuite OneWorld accounts with multi-currency enabled. Oracle describes it as a calculated amount that adjusts for rate differences in the cash flow statement's accounts, so that Cash at End of Period is consistent with the balance sheet's Bank or cash equivalent, and says it accounts for the related CTA amount. Generally nothing is posted for it. By default each account's cash flow rate type is Average, except equity's, while the balance sheet translates cash at the current rate. US GAAP presents the same effect as a separate line in the reconciliation of the change in cash.
Why do the lines change when I run the cash flow statement by date?
The Report by Period preference decides whether NetSuite selects records by transaction date or by posting period. Set to Never, every report runs by transaction date; set to All Reports or Financials Only, the Cash Flow Statement runs by period. A bill dated in one month and posted to the next then moves net income and accounts payable by the same amount, and the net change in cash stays where it was. Oracle's pages place the preference on different subtabs of Set Preferences, Analytics on some and Reporting/Search on another.

← All notes

Push the Frontier

Work alongside our team to establish your first operational capabilities, built around the problems that matter most to your business.

Explore the platformTalk to Frontier
FrontierERP

Set a new standard for how businesses operate.

Platform
Solutions
Resources
Company
© 2026 Frontier ERP, Inc.PrivacyTerms