Cashflow Report
The Cashflow Report spreads your budget over time. It shows how much each account spends in each week or month of the schedule, based on the dates of your locations and phases. You can use it to plan drawdowns with a financier or bond company, including tranche totals and a holdback percentage. It's the only report that can also be exported as a CSV for use in a spreadsheet.
Cashflow is built from your location and phase dates, so set those up in the Element Manager first. Lines with no dates have nowhere to go on the timeline.
Options
In step 1, choose Cashflow Report. The Options panel then offers:
All Locations
Tick the locations to include. There's also an Undefined entry for lines that have no location. You need to tick at least one entry before anything is generated.
Episodes
(Series budgets) Tick episodes to get a separate cashflow table for each one. If a line belongs to several of the ticked episodes, its cost is split evenly between them. Amort lines go entirely to Amort.
Report Sections
- Include Currency Breakdown: adds a breakdown of the cashflow by currency.
Date Range
- All Dates (default): covers everything from the earliest to the latest location or phase date.
- Specific Date Range: choose a Start and an End date to report on part of the schedule, for example the next quarter. You need both dates, and the end date must come after the start date.
Tranches Period
This sets the size of each column: Weekly (default), Bi-Monthly or Monthly.
Tranches Holdback Amount
This is the percentage (0–100, default 0) held back from each tranche. It's shown in the summary rows.
Reading the report
Cashflow reports are always Landscape.
- Columns: Acct, Description, Budget Total, then up to six periods per page. Each period is headed with its number and end date, for example Week: 3 / Week Ending: 03/21/2027.
- Rows: one row per account.
- Summary rows at the bottom:
| Row | Meaning |
|---|---|
| Total ATL / Total BTL | Above-the-line and below-the-line spend for each period |
| Budget Total | Total spend for each period |
| Holdback (N%) | The amount held back |
| Tranche Total | Budget Total minus holdback: the amount drawn in that period |
| Total Drawn | Running total drawn to date |
Pages are titled Cashflow Report. When you report by episode, each table is titled Cashflow Report – episode.
Additional Options for Cashflow
Cashflow has its own layout, so step 4 only offers Page Layout (paper size), Include Accounts with Zero Totals, Alternating Line Color and Watermark. The column pickers and detail-line options don't apply.
Exporting to CSV
On Review and Create, choose Export To → CSV instead of PDF. The CSV has the same period headers, account rows and summary rows as the PDF, ready to use in Excel, Numbers or Google Sheets.
Exporting budget data as CSV may be turned off for some workspace roles and shared budgets. If so, the CSV option will say it isn't available.