TrialBalance
Provides a trial balance for the Xero organization, showing the debits and credits for all accounts in the general ledger. It's essential for checking the accuracy of financial statements.
Columns
| Name | Type | Description |
| ID [KEY] | Integer | A unique identifier for the row, typically used for indexing. |
| Account | String | The name of the account, representing a financial category (for example, Sales or Expenses). |
| Debit | Decimal | The debit balance for the current month up to the specified date, showing increases to assets or expenses. |
| Credit | Decimal | The credit balance for the current month up to the specified date, showing increases to liabilities or income. |
| YTDDebit | Decimal | The Year-to-Date (YTD) debit amount, representing the cumulative debit balance from the start of the fiscal year up to the current date. |
| YTDCredit | Decimal | The Year-to-Date (YTD) credit amount, representing the cumulative credit balance from the start of the fiscal year up to the current date. |
| AccountId | String | A unique identifier for the account, used to reference the account in financial transactions. |
| TenantId | String | The ID of the tenant to query, which allows for data retrieval from a specific organization rather than the default connection tenant. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Date | Datetime | The 'as at' date for the trial balance, specifying the cutoff date for the financial data being reported. |
| PaymentsOnly | Boolean | Set this to true to filter the report to include only cash-based transactions, excluding non-cash items like accruals. |