Cash-Flow Forecasting and Management in NetSuite

Start With the Decision, Not the Report

A cash forecast estimates when money will enter and leave the business. It is not the same as a profit forecast. The FDIC's small-business guide says a company can be profitable and still run out of cash. It also defines a cash-flow projection as a view of expected cash in and out over a future period.^[1]

First decide what the forecast must answer. A treasurer may need to time a transfer this week. A CFO may need to test a hiring plan for the next quarter. These choices need different detail.

We conducted a workflow review around one rule: every forecast line should lead back to a NetSuite record, a clear assumption, or a named owner. That rule makes changes easier to check.

What NetSuite Cash 360 Can Show

Cash 360 is a public, managed SuiteApp. Oracle says it can show cash position, forecast cash flow, A/R and A/P aging, subsidiary views, and consolidated views. It can also include sales orders, purchase orders, installments, and added inflow or outflow lines.^[2]

Forecast part	Useful NetSuite input	Question to test
Opening cash	Included bank accounts and undeposited funds	Do the balances agree with recent bank data?
Customer cash	Open invoices, due dates, installments, and selected orders	Will each customer pay on the stated date?
Vendor cash	Open bills, terms, installments, and selected purchase orders	Is the planned pay date both valid and approved?
Other cash	Payroll, tax, debt, capital, and other added lines	Is the amount recurring, fixed, or still uncertain?

Cash position needs its own check. Oracle states that the Cash 360 tiles show the current-period bank balance, total receivables, and total payables for the selected subsidiary or group. The receivable and payable totals come from the A/R and A/P Aging Summary reports.^[3]

Build the Forecast in a Clear Order

Set the opening balance first. Then add likely inflows and outflows. End with items that need human judgment. Oracle documents the Cash 360 formula as opening balance, plus undeposited or future-period funds, plus forecast inflows, minus forecast outflows.^[4]

1. 01
   Confirm Bank Truth

   Check opening cash, bank imports, and unmatched items.

2. 02
   Set Expected Timing

   Review A/R, A/P, orders, payroll, tax, and debt.

3. 03
   Test Scenarios

   Change only the key timing or amount assumptions.

4. 04
   Compare the Result

   Measure the gap and update the next forecast.

NetSuite preferences control the period and what appears in the forecast. Oracle says the default forecast period is three months. The period starts from the current day, week, or month. Preferences can also include the opening balance and set how account categories and added values are used.^[5]

Manage Receivables and Payables by Timing

An invoice amount is not a cash date. Review due dates, customer habits, disputes, credits, and collection notes. Do the same for vendor bills. Check terms, holds, planned payment dates, discounts, and required approvals.

Cash 360 groups A/R and A/P into current, 1–30, 31–60, 61–90, and over-90-day aging bands. Oracle states that its aging charts include posting transactions that affect receivables and payables, including installments.^[6] Aging shows pressure. It does not prove the payment date.

Our analysis separates record facts from timing choices. The invoice balance and due date are facts in the system. A later collection date may be a forecast choice. Save the reason and owner for that choice.

• Focus collection work on large, late, and disputed invoices.
• Do not move vendor dates past agreed terms without approval.
• Keep payroll, tax, debt, and lease cash in the forecast even when no open bill exists.
• Review large sales and purchase orders before including them.
• Remove duplicate manual lines when a source record begins to cover the same cash.

Reconcile Before You Forecast

A clean forecast can still start from the wrong cash balance. NetSuite's Bank Reconciliation and Matching page shows bank and GL balances, the last import time, unmatched items, and matches that need review. Oracle says users can open the related matching work from that summary.^[7]

Set a cut-off time for bank imports. Record in-transit deposits and payments once. Resolve stale unmatched items. If a bank account is left out of Cash 360, note why.

Use Three Scenarios, Not One Precise Guess

Keep a base case for the most supportable view. Add an upside case and a downside case. Change a small set of drivers, such as collection delay, sales conversion, stock buys, or a capital payment.

In this study we ran the same control across each case. We changed one driver at a time, kept its source beside it, and noted the first period in which cash fell below the chosen buffer. This shows which assumption caused the result.

ACCA warns that an expected value is an average and can give a false sense of safety when only one outcome will occur. It also notes that results can depend heavily on assigned probabilities.^[8] A weighted case should not hide a severe downside case.

Review Forecast Versus Actual Cash

A forecast gets better when the team studies misses. Compare forecast and actual cash by week and category. Use the same category map in each review.

Variance	Likely cause	Next action
Opening cash differs	Late bank data, an excluded account, or an unmatched item	Fix the cash source before changing forecast logic.
Customer cash is late	Weak due dates, disputes, or optimistic payment timing	Update the customer rule and collection owner.
Vendor cash is early	Payment runs do not follow the forecast date	Align approved payment runs and forecast rules.
Other cash is missing	Payroll, tax, debt, or capital data has no source line	Add a controlled input with a clear owner.

The U.S. Small Business Administration advises businesses to keep proper books and manage A/R, A/P, available cash, bank reconciliation, and payroll. It also explains that cash and accrual accounting can show timing in different ways.^[9] These records are also the base of a useful short-term forecast.

Keep Forecasting Separate From Cash Reporting

The forecast looks forward. The cash-flow statement reports a past period. Do not use one as a label for the other.

IAS 7 defines cash flows as movements in cash and cash equivalents. It sorts reported cash flows into operating, investing, and financing activities. It also requires a link between cash and cash equivalents in the cash-flow statement and the statement of financial position.^[10] Use the NetSuite Cash Flow Statement to explain history. Use Cash 360 and controlled assumptions to guide near-term choices.

A Practical NetSuite Cash-Management Routine

Keep the routine short enough to repeat. Assign one person to publish the view and named owners to explain major inputs.

• Refresh bank data and clear material reconciliation issues.
• Check opening cash by bank account and subsidiary.
• Review large or late receivables with the collection owner.
• Review the next payment run, payroll, tax, debt, and capital cash.
• Update base, upside, and downside cases.
• Compare the last forecast with actual cash.
• Record changes to rules, sources, dates, and owners.

Conclusion

NetSuite cash flow management works best when system data and human judgment stay easy to tell apart. Reconcile the opening cash. Test the timing of A/R and A/P. Add missing cash with named owners. Then compare each forecast with the result.

SixLakes Consulting helps finance teams set up Cash 360, reporting, dashboards, and repeatable cash review steps. The goal is a forecast the team can explain and use.

References

1. FDIC Money Smart for Small Business: Managing Cash Flow.
2. Oracle NetSuite Applications Suite: Cash 360.
3. Oracle NetSuite Applications Suite: Viewing the Cash Position.
4. Oracle NetSuite Applications Suite: Viewing the Cash Forecast From the Cash 360 Dashboard.
5. Oracle NetSuite Applications Suite: Setting Cash 360 Preferences.
6. Oracle NetSuite Applications Suite: Viewing the A/R and A/P Aging Summary.
7. Oracle NetSuite Applications Suite: Viewing Account Summary for Bank Reconciliation.
8. ACCA Global: Conditional Probability and Expected Values.
9. U.S. Small Business Administration: Manage Your Finances.
10. IFRS Foundation: IAS 7 Statement of Cash Flows.