Accounts
Query, insert, update and delete accounts for a Xero organisation.
Table Specific Information
The Accounts table allows you to SELECT and INSERT accounts for a Xero organization.
SELECT
The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.
Note: The Xero API does not support filtering on line items or journal lines.
INSERT
Inserting a single row is straightforward, even with line item tables. Simply set the required fields and a new table object will be created as a single entry.
The following fields are required for inserts: Code, Name, and Type.
INSERT INTO Accounts (Name,Code,Type) VALUES ('John Doe','2000','BANK')
Columns
| Name | Type | ReadOnly | Description |
| AccountId [KEY] | String | True |
The unique, Xero-assigned identifier of the account. |
| Code | String | False |
Customer-defined alphanumeric account code. For example, 200 or SALES. |
| Name | String | False |
Name of the account. |
| Type | String | False |
The account type. Valid values are BANK, CURRENT, CURRLIAB, DEPRECIATN, DIRECTCOSTS, EQUITY, EXPENSE, FIXED, LIABILITY, NONCURRENT, OTHERINCOME, OVERHEADS, PREPAYMENT, REVENUE, SALES, TERMLIAB, PAYGLIABILITY, SUPERANNUATIONEXPENSE, SUPERANNUATIONLIABILITY, and WAGESEXPENSE. |
| Description | String | False |
Description of the account. All accounts except bank accounts return this element. |
| TaxType | String | False |
The tax type. For example, INPUT or NONE. |
| EnablePaymentsToAccount | Boolean | False |
Describes whether the account can have payments applied to it. |
| ShowInExpenseClaims | Boolean | False |
Describes whether the account code is available for use with expense claims. |
| Class | String | True |
The account class type. For example, ASSET or EQUITY. |
| Status | String | False |
The account status code. |
| SystemAccount | String | True |
Returned only for system accounts, such as DEBTORS, CREDITORS, etc. |
| BankAccountNumber | String | False |
The bank account number associated with the account. BANK account types only. |
| CurrencyCode | String | False |
The currency code associated with the account. BANK account types only. |
| ReportingCode | String | True |
The reporting code. Only available for NZ organisations. |
| ReportingCodeName | String | True |
The reporting code name. Only available for NZ organisations. |
| UpdatedDateUTC | Datetime | True |
Timestamp of the last change to the user record. |
| HasAttachments | Boolean | True |
This field indicates whether the invoice has an attachment. |
| BankAccountType | String | False |
Valid types are BANK, CREDITCARD, and PAYPAL |
| TenantId | String | False |
The ID of the tenant to query instead of the connection tenant |