The Trial Balance object
A trial balance is a list of all the general ledger accounts contained in the ledger of a business. This list will contain the name of each nominal ledger account and the value of that nominal ledger balance.
From the Trial Balances endpoint, you can retrieve a business's cash or accrual-based trial balance at a single point in time since inception.
All trial balances are part of an array of reports. See Reports data type for more details on the report structure and its meta-data.
| Field | Type | Description |
|---|---|---|
| section sortable, filterable | string | Railz normalized account classification. See account normalization. |
| subSection sortable, filterable | string | Railz normalized account classification. See account normalization. |
| group sortable, filterable | string | Railz normalized account classification. See account normalization. |
| subGroup sortable, filterable | string | Railz normalized account classification. See account normalization. |
| classification sortable, filterable | string | The classification of an account in the accounting service, e.g. Asset. |
| type sortable, filterable | string | The type of an account in the accounting service, e.g. Fixed Asset. |
| subType sortable, filterable | string | The subtype of an account in the accounting service, e.g. Fixed Asset. |
| account | string | Name of the account. |
| accountId sortable, filterable | string | Identifier for the account, unique for the business in the accounting service. |
| subAccount | string | Name of the subaccount. |
| subAccountId sortable, filterable | string | Identifier for the subaccount, unique for the business in the accounting service. |
| currency sortable, filterable | string | ISO-4217 currency code of the account. |
| credit sortable, filterable | decimal | Credit balance of the account in the accounting service. |
| debit sortable, filterable | decimal | Debit balance of the account in the accounting service. |
| fullyQualifiedName sortable, filterable | string | The fully qualified name prepends the topmost parent, followed by each subaccount separated by colons and takes the form of Parent: Account1:SubAccount1:SubAccount2. |
| depth sortable, filterable | string | The hierarchical level of the account in the Accounts list. The highest level accounts are level 1, the lowest is n. This is an example showing account hierarchy: Assets - Level 1 Current Assets - Level 2 Bank Accounts - Level 3 National Bank Account 1 - Level 4" |
| ytdCredit sortable, filterable | decimal | Year-to-date credit balance of the account in the accounting service. |
| ytdDebit sortable, filterable | decimal | Year-to-date debit balance of the account in the accounting service. |
QuickBooks Online Limitations
Due to a limitation in the QuickBooks Online API, all
ytdDebitandytdCreditare not available through their api.