Quickbooks: General Ledger By Period

Description

• Table that pulls general ledger account level balances per period from int_quickbooks__general_ledger_balances while also creating an offsetting Retained Earnings entry for Revenue - Expenses per year to be added as single Equity line balance per year.

Supported Data Sources

• QuickBooks

Columns

Type	Name	Description
STRING	account_id	The identifier of the account associated with the period balance transactions.
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be null.
STRING	account_number	User defined number of the account. with the account.
STRING	account_name	Name of the account associated with the period balance transactions.
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 period balance transactions.
STRING	account_sub_type	Sub type of the account associated with the period balance transactions.
STRING	account_class	Class of the account associated with the period balance transactions.
STRING	class_id	Reference to the class associated with the period balance transactions.
STRING	financial_statement_helper	Helper field identifying whether the account impacts the balances sheet or income statement.
DATE	date_year	Timestamp of the year.
DATE	period_first_day	Timestamp of the first date of the month.
DATE	period_last_day	Timestamp of the last date of the month.
DECIMAL	period_net_change	Account balance difference from the beginning and ending of the period.
DECIMAL	period_beginning_balance	Balance of the account as of the first date of the period.
DECIMAL	period_ending_balance	Sum of all transaction line adjusted_balances of the account 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