Trial Balances

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.

FieldTypeDescription
section
sortable, filterable
stringRailz normalized account classification. See account normalization.
subSection
sortable, filterable
stringRailz normalized account classification. See account normalization.
group
sortable, filterable
stringRailz normalized account classification. See account normalization.
subGroup
sortable, filterable
stringRailz normalized account classification. See account normalization.
classification
sortable, filterable
stringThe classification of an account in the accounting service, e.g. Asset.
type
sortable, filterable
stringThe type of an account in the accounting service, e.g. Fixed Asset.
subType
sortable, filterable
stringThe subtype of an account in the accounting service, e.g. Fixed Asset.
accountstringName of the account.
accountId
sortable, filterable
stringIdentifier for the account, unique for the business in the accounting service.
subAccountstringName of the subaccount.
subAccountId
sortable, filterable
stringIdentifier for the subaccount, unique for the business in the accounting service.
currency
sortable, filterable
stringISO-4217 currency code of the account.
credit
sortable, filterable
decimalCredit balance of the account in the accounting service.
debit
sortable, filterable
decimalDebit balance of the account in the accounting service.
fullyQualifiedName
sortable, filterable
stringThe 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
stringThe 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
decimalYear-to-date credit balance of the account in the accounting service.
ytdDebit
sortable, filterable
decimalYear-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 and ytdCredit are not available through their api.