Trial Balances

Overview

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 trial balance at a single point in time since inception. See Trial Balances endpoint for more details.

Data Model

🚧

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

subSection
sortable, filterable

string

Railz normalized account classification. See Accounts.

group
sortable, filterable

string

Railz normalized account classification. See Accounts.

subGroup
sortable, filterable

string

Railz normalized account classification. See Accounts.

account
sortable, filterable

string

Name of the account in the accounting service provider.

subAccount

string

Name of the sub-account in the accounting service provider.

credit
sortable, filterable

decimal

Credit balance of the account in the accounting service provider.

debit
sortable, filterable

decimal

Debit balance of the account in the accounting service provider.

ytdCredit
sortable, filterable

decimal

Year-to-date credit balance of the account in the accounting service provider.

ytdDebit
sortable, filterable

decimal

Year-to-date debit balance of the account in the accounting service provider.

📘

QuickBooks Online Limitations

Due to a limitation in the QuickBooks Online API, all ytdDebit and ytdCredit are not available through the Railz API.

Example Data

{
  "count": 1,
  "reports":
  [
    {
      "meta":
      {
        "reportId": "5fad8a342a88364234392fb5",
        "serviceName": "xero",
        "businessName": "Railz",
        "createdAt": "2020-11-25T01:02:03Z",
        "updatedAt": "2020-11-30T01:02:03Z",
        "startDate": "2020-12-01T00:00:00Z",        
        "endDate": "2020-12-31T00:00:00Z",
        "reportFrequency": "month",
        "currency": "USD"
      },
      "data":
      [
        {
          "section": "Assets",
          "subSection": "Current Assets",
          "group": "Cash and Cash Equivalents",
          "subGroup": "Bank Accounts",
          "account": "Checking",
          "subAccount": "ABC Bank #4556",
          "credit": 80,
          "debit": 0,
          "ytdCredit": 80,
          "ytdDebit": 0
        }
      ]
    }
  ]
}

Did this page help you?