# Quickbooks: General Ledger

## Description

* Table that unions all records from each model within the double\_entry\_transactions directory. The table end result is a comprehensive general ledger with an offsetting debit and credit entry for each transaction.

## Supported Data Sources

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

## Columns

| Type    | Name                         | Description                                                                                                                                                                      |
| ------- | ---------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| STRING  | unique\_id                   | Unique identifier of the general ledger line, dependent on `transaction_id`, `transaction_index`, `account_id`, `transaction_type`, `transaction_source`, and `source_relation`. |
| STRING  | transaction\_id              | Unique identifier of the transaction. Each transaction will have an offsetting debit and credit record.                                                                          |
| STRING  | source\_relation             | The source of the record if the unioning functionality is being used. If not this field will be null.                                                                            |
| INTEGER | transaction\_index           | Unique identifier of the individual debit and credit records of the transaction.                                                                                                 |
| DATE    | transaction\_date            | The date that the transaction occurred.                                                                                                                                          |
| STRING  | customer\_id                 | Reference to the customer associated with the transaction.                                                                                                                       |
| STRING  | vendor\_id                   | Reference to the vendor associated with the transaction.                                                                                                                         |
| DECIMAL | amount                       | Monetary amount of the transaction line.                                                                                                                                         |
| STRING  | account\_id                  | The identifier of the account associated with the transaction line.                                                                                                              |
| STRING  | class\_id                    | Reference to the class associated with the transaction line.                                                                                                                     |
| STRING  | department\_id               | Reference to the department with the transaction line.                                                                                                                           |
| STRING  | account\_number              | User defined number of the account.                                                                                                                                              |
| STRING  | account\_name                | Name of the account associated with the transaction line.                                                                                                                        |
| 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 transaction line.                                                                                                                        |
| STRING  | account\_sub\_type           | Sub type of the account associated with the transaction line.                                                                                                                    |
| STRING  | financial\_statement\_helper | Either 'balance sheet' or 'income statement' and is used to determine that financial statement the account impacts.                                                              |
| DECIMAL | account\_current\_balance    | Total current balance of the account associated with the transaction line.                                                                                                       |
| STRING  | account\_class               | Class of the account associated with the transaction line. Will be one of 'Expense', 'Revenue', 'Asset', 'Liability', and 'Equity'.                                              |
| STRING  | transaction\_type            | Identifier of whether the transaction is a debit or credit entry.                                                                                                                |
| STRING  | transaction\_source          | Field signifying the source of transaction (eg. Bill, Invoice, Deposit, Journal Entry, etc.).                                                                                    |
| STRING  | account\_transaction\_type   | Identifier of whether the account is increased by either a debit or credit entry.                                                                                                |
| DECIMAL | adjusted\_amount             | The amount that impacts the account. If the transaction\_type = account\_transaction\_type then the impact will increase, otherwise it will decrease the account.                |
| DECIMAL | running\_balance             | The running balance of the account by each individual day.                                                                                                                       |


---

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