The Trial Balance object
Beta API Versions
API versions labelled as Beta are not subject to our standard versioning policy. As such, they may undergo small breaking changes until they are transitioned to the stable version. We encourage you to exercise caution when using Beta API versions and take the necessary steps to ensure a smooth integration into your applications
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
ytdDebit
andytdCredit
are not available throu