Customise Cash Flow | BrizoConsol Documentation

What this article covers: How to customise the Cash Flow report in BrizoConsol — overriding the system report directly, building a custom rows/columns layout, and converting to a cell-based report. Includes examples of common row types and cell bindings.

The Cash Flow report in BrizoConsol is a system report — generated automatically from your mapped accounts. Depending on your accounting standard it may be labelled Statement of Cash Flows or Cash Flow Statement. It shows cash movements across Operating, Investing, and Financing activities as defined in your chart of accounts mapping. You can customise it in three ways:

Option When to use it

Override the system Cash Flow Edit the rows of the existing report in place — your changes replace what the system shows for every organisation in your subscription. A Restore Default option brings the original back any time.

Create a custom report Build a new rows/columns report under Reports → Custom — give it a name, build it row by row, and pin it to your navigation alongside the standard Cash Flow report.

Convert to Cell-based Create a cell-based override of the system Cash Flow (Override Report → Cell-based report) so it opens in place of the default — full spreadsheet-style control over layout, formulas, and multi-entity views. Not available on the Standard plan.

1. Overriding the System Cash Flow

Open Reports → Cash Flow (or Statement of Cash Flows, depending on your accounting standard) and click the Override Report (edit) icon in the report header (Administrator or Report Admin access). On plans with Cell Reports, choose Row/column report in the dialog that opens. The report editor opens with the current rows pre-loaded — add, remove, or reorder rows, then save. The saved layout replaces the system default for every organisation in your subscription.

To go back to the original at any time, click Restore default in the editor. This removes your override and restores the system-generated Cash Flow report.

💡 Tip: The Cash Flow report is driven by how accounts are mapped in your chart of accounts — Operating, Investing, and Financing activities are determined by your account mapping, not by the report rows. If a line item is missing from the system report, check your account mapping first.

2. Row Types

Whether you are overriding the system Cash Flow or building a custom report, you construct the layout row by row. Seven row types are available:

Row type What it does

Label A heading, subheading, or spacer — text only, no data in period columns. Use for visual structure.

Section A group from your chart of accounts — renders with all its sub-account rows and a section total.

Account A single ledger account — one row showing the cash movement for each period column.

Formula A calculated value — references other rows, sections, KPIs, or fixed numbers. Use for subtotals and net cash totals.

By Entity A group of sub-rows repeated for each entity in the group — useful for entity-level comparison inside one report.

KPI A built-in or custom KPI row — sits alongside financial rows in the same report and updates with every data sync.

Operational Data Operational data held for the group — for example, cash movements broken down by category. Offered only when operational data is available.

3. Row Examples

Adding a Net Cash Flow line

Add a Formula row after your Operating, Investing, and Financing activity rows:

Field Value

Row type Formula

Label Net Cash Flow

Formula Operating Activities + Investing Activities + Financing Activities (reference the section row labels above)

BrizoConsol calculates the result for every period column automatically.

Adding a Free Cash Flow line

Add a Formula row after your Operating Activities and Capital Expenditure rows:

Field Value

Row type Formula

Label Free Cash Flow

Formula Operating Cash Flow − Capital Expenditure

Adding a KPI row

Add a KPI row anywhere in the report. Select the metric from the picker — for example Operating Cashflow or Net Cashflow. The row pulls from BrizoConsol's built-in KPI engine and updates with every data sync.

Adding a Label row as a heading or spacer

Add a Label row between sections. Type your heading text — for example INVESTING ACTIVITIES — or leave it blank for a spacer line. No data appears in the period columns; it is layout only.

💡 Tip: Use Section rows to pull whole activity groups from your chart of accounts, and Formula rows to calculate subtotals across them. This keeps your cash flow layout in sync with your account structure automatically.

4. Converting to a Cell-Based Report

A Cell-based report gives you a blank spreadsheet canvas inside BrizoConsol. Every cell can hold static text, an Excel-style formula, or a live binding to financial data. When linked to the system Cash Flow, it opens in place of the default report for every organisation in your subscription.

Use a Cell Report when you need a layout the rows/columns format cannot achieve — for example, a cash flow with commentary columns, side-by-side entity comparison, or a board pack table with custom formatting.

Cell-based reports are not available on the Standard plan

Cell Reports are available on the Free (trial), Pro and Premium plans. To check your plan, open Subscriptions from the user menu (your initials). See Plans & Pricing for a full comparison.

To create one, go to Reports → Custom Reports → Add a new report and choose Cell-based. Alternatively, choose BrizoBuilder to describe the report in plain language and get an editable cell-based draft. To make a cell-based layout open in place of the system Cash Flow, open the system report, click Override Report and choose Cell-based report.

5. Cell Binding Examples

Bind a cell to cash flow accounts

Cash flow data is accessed through the Accounts by type data source. Click a cell, set the cell type to Financial data, and configure the binding:

Field Value

Data source Accounts by type

Account type Select the account type of the cash accounts

Value Movement — to show the period cash movement for those accounts

The cell shows the live movement figure for that account type and updates automatically with every data sync.

Bind a cell to a financial statement total

To pull a calculated total — such as Net Cash Flow — into a single summary cell, set Data source to Financial statement total and select the relevant total line. This is useful for summary tiles and executive dashboards.

Write a formula across bound cells

Once Operating Cash Flow is bound in cell B2 and Capital Expenditure in B3, click B4 and type =B2-B3 to get Free Cash Flow. BrizoConsol resolves the live values of both cells before calculating.

Side-by-side entity comparison

To compare two entities in the same report, bind each row in column B to Entity A and the same rows in column C to Entity B. Add a formula column D with =B-C for the variance. Link the Entity field to a header cell — change one cell and the whole column switches entity automatically.

💡 Tip: Any binding field can be linked to another cell using the cell reference icon next to the field. This lets one cell drive the entity, period, or account selection for many others — making your report dynamic.