Cash flow

What the cash flow shows

• Planned value of work per period. Each dated row of the schedule spreads its planned quantity evenly over its working days (by the project's work calendar). The share in each period is multiplied by the unit price of the BoQ position.
• Including profit. The unit price is the same profit-inclusive price you see in the BoQ, so the cash flow adds up to the value of the scheduled work, not to your direct costs.
• Plan only. Reported progress, approved payment applications and invoices do not change it. It answers "how much work do we plan to do and when", which is the basis for a financing plan or a payment schedule with the client.
• Current state. It uses the current schedule version and today's BoQ prices. If you change dates in the Gantt or prices in the BoQ, the cash flow follows.
• Not included: rows without dates, rows with Manual distribution or zero quantity, positions without a price, and BoQ positions that are not in the schedule at all.

A worked example

A position "Concrete C25/30 for slabs" has 100 m³ in the schedule at a unit price of 120.00 EUR including profit. Its schedule row runs over 20 working days: 12 in March and 8 in April.

If you add a public holiday in March to the work calendar, the row gets one more working day at its end, and the split changes accordingly.

How to open the cash flow

1. Open the project's Construction schedule (Строителен график) on its current version.
2. Click Reports (Справки) in the toolbar. The screen opens on the materials report.
3. Click Filters (Филтри), then Clear (Изчисти). This selects Cash flow, groups By task and shows both quantity and value. Alternatively, click the icon "Only this report" on the Cash flow chip.
4. Click Done (Готово). The title reads Cash flow with "{schedule} · breakdown by period" (разчет по периоди).

1. The title Cash flow (Паричен поток) and "breakdown by period".
2. The Pricing report (Ценови отчет) button.
3. The column of the current month tagged "today" (днес).
4. The Value (Стойност) of a row for the whole window.
5. The footer Total per period (Общо по период).
6. The scale controls with Month (Месец), Coarser and More detail.

How to read the cash flow

• Rows. With By task (По СМР) there is one row per BoQ position. With Structure (Структура) you see the schedule tree; collapse a category to see its totals per period, for example the planned value of the rough construction per month.
• Columns. No., Name, Unit, Quantity, Value, then one column per period. With Show set to Value (Стойност) you see money only; with Qty (К-во) or Both (Двете) the BoQ quantities are shown next to it.
• Totals. The footer Total per period sums each period; the Quantity and Value columns of each row sum the whole window (in the Excel export they sit under the heading Total for the whole period). Each schedule row is counted once.
• Periods. Week, Month (default), Quarter, Year. Weeks run Monday to Sunday; quarters are calendar quarters. Use Today to jump to the current period and Fit to the data to fit the window from the first to the last period that has figures.
• Empty periods show "No planned work in this period."

How to export the cash flow to Excel

1. Set the grouping, the scale and the window you want to hand over, for example Structure, Month, the whole year.
2. Click Export (Експорт) and wait for "Preparing the export…".
3. An .xlsx file downloads with the same rows and periods as on screen, the object and the client in the header and the totals at the bottom.

The pricing report for one period

While Cash flow is selected, the toolbar shows Pricing report (Ценови отчет). It gives the value of the work planned between two dates you choose, its breakdown into materials, labor, machinery, services, additional costs and profit, and the rows it had to exclude. The value of the pricing report for a month equals the cash flow of that month. See Pricing report and schedule cash flow.

1. Filters (Филтри), here with Group by set to Structure (Структура) and Show set to Value (Стойност).
2. Export (Експорт).
3. The quarter columns.
4. A collapsed category row with its totals per quarter.

Cash flow, payment applications and the financial dashboard

Common questions

Related

• Reports
• Pricing report and schedule cash flow
• Gantt view and dependencies
• Working days and holidays
• Profit, additional costs and totals