# 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](https://github.com/fivetran/dbt_quickbooks/blob/main/README.md#customize-the-account-ordering-of-your-profit-loss-and-balance-sheet-models) | --- # 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-general-ledger-by-period.md?ask= ``` 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.