# Customize a Cash Flow statement

{% hint style="info" %}
This page describes the current experience. A new version of this feature is being rolled out and might already be available to you. See [Overview of Manage financial statements (Beta)](/financial-statements/managing-statements/overview-of-manage-financial-statements-beta.md) for details.
{% endhint %}

{% hint style="info" %}
User permission: Manage Custom Statements
{% endhint %}

In Financial Statements, the Cash Flow statement is derived from the Profit and Loss statement amounts and movements in the Balance Sheet for the selected period. This method takes amounts in the Profit and Loss statement and movements in the Balance Sheet and maps them to the relevant Cash Flow groups, for example Operating, Investing and Financing activities. General ledger accounts can only be mapped to one group, which makes the direct method Cash Flow presentation easier to achieve.

The Cash Flow statement contains the following items:

<table data-header-hidden><thead><tr><th width="190"></th><th></th></tr></thead><tbody><tr><td><strong>Group rows</strong></td><td><strong>Operating</strong>: Displays the business trading activity. The relevant Profit and Loss accounts are displayed along with movements in working capital balance sheet accounts.<br><strong>Investing:</strong> Displays the investing activity of the business, such as CAPEX.<br><strong>Financing:</strong> Displays the financing activity of the business, such as the extension or repayment of loans.</td></tr><tr><td><strong>Calculation row</strong></td><td>The sum of the above three groups to calculate the net cash movement for the period.</td></tr><tr><td><strong>Cash balance rows</strong></td><td>There are two Balance rows, one for the cash at the start and the other for the cash at the end of the period. You can move these Balance rows around, but you cannot delete them.</td></tr></tbody></table>

<div align="left"><figure><img src="/files/fRmLoy3nOJzkUbRrnFRH" alt="" width="612"><figcaption></figcaption></figure></div>

As with the other financial statements, you can add more groups and calculations, and reorder and rename the existing items. See examples below.

## Manage the Cash Flow accounts <a href="#customizeacashflowstatement-managethecashflowaccounts" id="customizeacashflowstatement-managethecashflowaccounts"></a>

For completeness, all General Ledger accounts in the Cash Flow statement must be mapped to a Cash Flow group. Depending on your setup, the mapping might be done for you, in which case you should check it to ensure it is correct, as you might need to make some changes. Otherwise, you must map the accounts yourself. See [Map accounts to a group](/financial-statements/managing-statements/customize-a-financial-statement/customize-groups.md#customizegroups-editagroup) and [Common account mapping for Cash Flow statements](/financial-statements/managing-statements/customize-a-financial-statement/customize-a-cash-flow-statement/common-account-mapping-for-cash-flow-statements.md).

You must specify the General Ledger accounts that are cash balances. These accounts are not mapped. The value of these accounts display in the cash balance rows in the statement. See Set the bank account in a Cash Flow statement and Common account mapping for Cash Flow statements sections below.

The cash balances can equal your net debt (cash plus borrowings) Balance Sheet accounts, if you prefer to manage your business that way. You can have more than one setup, for example, one Cash Flow statement that displays your cash balances and another that displays your net debt balance. See [Create a statement](/financial-statements/managing-statements/create-a-financial-statement.md) to learn how to create multiple statements.

When all the accounts are mapped correctly your Cash Flow statement should balance.

## Set the bank account in a Cash Flow statement

You should set the bank account to enable your Cash Flow statement to have a starting and ending balance.

<div align="left"><figure><img src="/files/9dXxhjfpqleDkM58OWuZ" alt="" width="612"><figcaption></figcaption></figure></div>

1. In the **Statements** menu, click the Cash Flow statement.
2. In the statement setup window, click the **Accounts** tab.
3. Search for the applicable accounts. You can search by code, name or other property, or enter an account range.
4. Select the applicable bank account(s) by clicking the number to the left of the name, then click **Set Bank Accounts** in the bottom left corner.
5. Click **Save** > **Close** > **Yes** to rebuild the database.

***

## Example: Add a group for movements in Accounts Receivable <a href="#customizeacashflowstatement-example-addagroupformovementsinaccountsreceivable" id="customizeacashflowstatement-example-addagroupformovementsinaccountsreceivable"></a>

Suppose you want more visibility on how your Accounts Receivable are affecting your cashflow over the period. You can add a group for Accounts Receivable in your Cash Flow statement.

1. In the **Statements** window, click the **Cash Flow** statement (or if preferred, clone the **Cash Flow** statement and then click that to open it).
2. In the statement setup window, [add a group](/financial-statements/managing-statements/customize-a-financial-statement/customize-groups.md) for the movements in Accounts Receivable and drag it up to where you want it to be positioned, for example, just below the **Operating** group.
3. [Edit the existing calculation](/financial-statements/managing-statements/customize-a-financial-statement/customize-calculations.md) to include reference the new group, then click **Save**.
4. Click the **Accounts** tab, then [map the applicable accounts](/financial-statements/managing-statements/customize-a-financial-statement/customize-groups.md#customizegroups-editagroup) to the new group.

<div align="left"><figure><img src="/files/sa4Wx26j7M2ObnDccIEm" alt="" width="510"><figcaption></figcaption></figure></div>

## Example: Add subgroups for the accounts <a href="#customizeacashflowstatement-example-addsubgroupsfortheaccounts" id="customizeacashflowstatement-example-addsubgroupsfortheaccounts"></a>

Suppose you want to group your accounts into subgroups for easier analysis. You can add a dimension for the subgroups, then add that dimension as a level in your Cash Flow statement.

1. In the **Statements** window, click the **Cash Flow** statement (or if preferred, clone the **Cash Flow** statement and then click that to open it).
2. [Create a new dimension](/financial-statements/managing-statements/customize-a-financial-statement/customize-groups.md#customizegroups-editagroup-1) for the subgroups.
3. [Add the new dimension as a level in the statement grid](/financial-statements/using-statements/manage-statement-levels.md).

<figure><img src="/files/fJe66E0mKUnyWf1Dq4C3" alt=""><figcaption></figcaption></figure>

## Videos

{% hint style="success" %}
Watch this PUG Training video: [Cashflow - direct and indirect](https://www.phocassoftware.com/customer/training-series/financial-statements#session4)
{% endhint %}

{% embed url="<https://phocassoftware.wistia.com/medias/u4x8jfqueo>" %}
Customize your Cash Flow Statement
{% endembed %}

{% embed url="<https://phocassoftware.wistia.com/medias/p5d4fgm4ff>" %}
Create an indirect Cash Flow statement using 'hide rows'
{% endembed %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.phocassoftware.com/financial-statements/managing-statements/customize-a-financial-statement/customize-a-cash-flow-statement.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
