Quickbooks: Cash Flow Statement

Description

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

Supported Data Sources

• 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.
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.
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.