Quickbooks: Profit And Loss

Description

• Table containing all revenue and expense account classes by calendar year and month enriched with account type, class, and parent information.

Supported Data Sources

• QuickBooks

Columns

Type	Name	Description
DATE	calendar_date	Timestamp of the first calendar date of the month.
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 profit and loss line.
STRING	class_id	Reference to the class associated with the record.
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 profit and loss line.
STRING	account_sub_type	Sub type of the account associated with the profit and loss line.
STRING	account_number	User defined number of the account.
STRING	account_id	The identifier of the account associated with the record.
STRING	account_name	Name of the account associated with the profit and loss line.
DECIMAL	amount	The total period net change for the period.
INTEGER	account_ordinal	Integer value to order the account within final financial statement reporting. The customer can also configure the ordinal; see the README for details