BalanceSheet
Queries the monthly balance sheet of a Xero organization. The balance sheet provides a snapshot of the organization's assets, liabilities, and equity at a given point in time.
Columns
| Name | Type | Description |
| ID [KEY] | Integer | The unique identifier for each row in the BalanceSheet report. This ID helps to distinguish each entry in the dataset. |
| Label1 | String | The label for the first item in the BalanceSheet report, typically representing a specific financial category or account. |
| Label2 | String | The corresponding value for the first label in the BalanceSheet report, representing the financial amount or balance associated with Label1. |
| Label3 | String | The label for the second item in the BalanceSheet report, typically representing a different financial category or account. |
| Label4 | String | The corresponding value for the second label in the BalanceSheet report, representing the financial amount or balance associated with Label3. |
| Label5 | String | The label for the third item in the BalanceSheet report, typically representing another financial category or account. |
| Label6 | String | The corresponding value for the third label in the BalanceSheet report, representing the financial amount or balance associated with Label5. |
| Label7 | String | The label for the fourth item in the BalanceSheet report, typically representing another financial category or account. |
| Label8 | String | The corresponding value for the fourth label in the BalanceSheet report, representing the financial amount or balance associated with Label7. |
| Label9 | String | The label for the fifth item in the BalanceSheet report, typically representing another financial category or account. |
| Label10 | String | The corresponding value for the fifth label in the BalanceSheet report, representing the financial amount or balance associated with Label9. |
| Label11 | String | The label for the sixth item in the BalanceSheet report, typically representing another financial category or account. |
| Label12 | String | The corresponding value for the sixth label in the BalanceSheet report, representing the financial amount or balance associated with Label11. |
| Label13 | String | The value associated with the thirteenth label in the BalanceSheet report, typically representing another financial metric. |
| AccountId | String | The unique identifier of the account associated with the row in the BalanceSheet report. This ID links the row to a specific account. |
| TenantId | String | The unique identifier for the tenant. This allows the system to query data specific to a tenant other than the default connection tenant, useful in multi-tenant environments. |
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, which represents the date the financial data in the report is accurate up to. It specifies the cut-off date for the report data. |
| Periods | Int | The number of periods to look back from the 'ToDate'. This helps define the timeframe for the data being analyzed, allowing for historical comparisons. |
| Timeframe | String | Defines the size of each period in the query. Valid values are 'MONTH', 'QUARTER', or 'YEAR', indicating whether each period should span a month, a quarter, or a year. |
| TrackingOptionID1 | String | A parameter that filters the report based on a specific tracking option, often used to display payable invoices or other filtered data for a contact. |
| TrackingOptionID2 | String | Another parameter for filtering the report based on a second tracking option, useful for narrowing down the data based on different criteria. |
| PaymentsOnly | Boolean | If the value is set to 'true', the query will only return data related to cash transactions, filtering out non-cash transactions for a more specific financial report. |
| StandardLayout | Boolean | If the value is set to 'true', the report will use the standard layout without applying any custom report layouts, ensuring a consistent output across all users. |