Cash-Flow Forecast

Forecast daily cash balances from dated receipts and payments, including the first shortfall.

On-device No sign-up Free to use

Forecast daily cash flow controls

Showing an example. Edit to see your own.

?

?

?

?

One row per line; columns separated by |: date | type | amount | description. Up to 100 rows. Use plain decimals, without thousands separators.

Processed in your browser. Your inputs stay on this device.

Result

Showing an example.

Start with 1,000; pay 1,200 on January 5 and receive 800 on January 12 within the displayed month.

Closing balance 600.00; first shortfall 2026-01-05

https://usefreetools.net/dated-cash-flow-forecast · 20 November 2026

Was this helpful?

How to use Cash-Flow Forecast

  1. Set Start date and End date, including both endpoint days. Enter the opening cash balance at the start of the first day, in the same currency as every receipt and payment.
  2. Replace the sample Dated receipts and payments. Give each row a date within the period, receipt or payment, a nonnegative amount and a short description. Use plain decimals without currency symbols or grouping commas.
  3. Select Calculate result. The table includes every calendar day, carrying balances forward even on dates without entries. Receipts and payments sharing a date are grouped before calculating that day’s closing balance.
  4. Read the result text for the minimum balance and first shortfall, including a negative initial opening balance. Download calculation.csv for all daily opening balances, receipts, payments and closing balances.

Example: Cash-Flow Forecast

Start with 1,000; pay 1,200 on January 5 and receive 800 on January 12 within the displayed month.

You add
start: 2026-01-01; end: 2026-01-31; opening: 1000; entries: 2026-01-05 | payment | 1200 | Supplier 2026-01-12 | receipt | 800 | Customer
You get
Closing balance 600.00; first shortfall 2026-01-05

Supported inputs and limits

  • Choose 1 to 1,096 inclusive days, with real dates from 1900 through 2200.
  • Use 1 to 100 entry rows and at most 100,000 characters; all four pipe-separated cells are required and descriptions allow 80 characters.
  • Out-of-period entries are refused.
  • Opening balance may range from -1,000,000,000 to 1,000,000,000; receipt/payment amounts are nonnegative and at most 1,000,000,000 each.
  • Use ordinary decimal notation with up to 12 decimal places.
More details

Opening balance and each entry round half up to cents before grouping.

First shortfall means a negative initial opening or daily closing balance.

Date-only records cannot establish transaction order or reveal a possible intraday shortage.

No collection probability, automatic recurrence, interest, tax, credit line or bank connection is modeled.

This is an entered scenario, not a prediction.

Processing is local without automatic saving.

Where your input is processed

This tool does not upload your inputs. See the limits for anything saved on your device.

Questions about Cash-Flow Forecast

Are entries grouped by their calendar date?

Yes. All receipts and payments on one date produce one daily closing balance. The input does not establish their order within the day.

Does the forecast fill dates without transactions?

Yes. Opening and closing balances carry forward for every calendar date in the selected period.

What counts as the first shortfall?

The first negative starting balance or daily closing balance. A possible intraday shortfall cannot be inferred from date-only entries.

Page updated · Project managed by Tony Hines · Report a problem with Cash-Flow Forecast