# Quickbooks: Cash Flow Statement

## Description

* Table that provides all line items necessary to construct a cash flow statement.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/quickbooks/resources/quickbooks.svg" alt="" data-size="line"> QuickBooks

## Columns

| Type    | Name                    | Description                                                                                                                                                                                                                                                                     |
| ------- | ----------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATE    | cash\_flow\_period      | Timestamp of the first date for the cash flow period.                                                                                                                                                                                                                           |
| STRING  | source\_relation        | The source of the record if the unioning functionality is being used. If not this field will be null.                                                                                                                                                                           |
| STRING  | account\_class          | Class of the account associated with the cash flow line.                                                                                                                                                                                                                        |
| STRING  | class\_id               | Reference to the class associated with the account.                                                                                                                                                                                                                             |
| BOOLEAN | is\_sub\_account        | Boolean indicating whether the account is a sub account (true) or a parent account (false).                                                                                                                                                                                     |
| STRING  | parent\_account\_number | The parent account number. If the account is the parent account then the account number is recorded.                                                                                                                                                                            |
| STRING  | parent\_account\_name   | The parent account name. If the account is the parent account then the account name is recorded.                                                                                                                                                                                |
| STRING  | account\_type           | The type of account associated with the cash flow line.                                                                                                                                                                                                                         |
| STRING  | account\_sub\_type      | Sub type of the account associated with the cash flow line.                                                                                                                                                                                                                     |
| STRING  | account\_number         | User defined number of the account.                                                                                                                                                                                                                                             |
| STRING  | account\_id             | The identifier of the account associated with the cash flow line.                                                                                                                                                                                                               |
| STRING  | account\_name           | Name of the account associated with the cash flow line.                                                                                                                                                                                                                         |
| DECIMAL | cash\_ending\_period    | The total ending period balance cash for every cash flow account line.                                                                                                                                                                                                          |
| STRING  | account\_unique\_id     | Unique identifier of the cash flow statement account line, dependent on account\_id, class\_id, source\_relation and calendar\_date.                                                                                                                                            |
| STRING  | cash\_flow\_type        | The type of cash flow (Defaults are Cash or Cash Equivalents, Investing, Operating, Financing). The customer can also configure the cash flow type; [see the README for details](https://github.com/fivetran/dbt_quickbooks/blob/main/README.md#customize-the-cash-flow-model). |
| INTEGER | cash\_flow\_ordinal     | Integer value to order the account within final cash flow statement reporting. The customer can also configure the ordinal; [see the README for details](https://github.com/fivetran/dbt_quickbooks/blob/main/README.md#customize-the-cash-flow-model).                         |
| DECIMAL | cash\_beginning\_period | The total beginning period balance cash for every cash flow account line.                                                                                                                                                                                                       |
| DECIMAL | cash\_net\_period       | The net cash change from the beginning to the end of the period for every cash flow account line.                                                                                                                                                                               |


---

# 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://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/quickbooks-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.