Xero Accounting Endpoint: AccountsTotals
Overview
The Xero AccountsTotals endpoint allows you to access the list of account totals that can be used to group yourchart of accounts to produce Profit and Loss and Balance Sheet reports.
This endpoint is not part of the Xero API but specific to OdataLink to ease development.
Fields
The following fields are available for the AccountsTotals endpoint.
- AccountTotal
- A text field that provides the system name (as opposed to display name) of the total. Possible values are:
- INCOME
- DIRECTCOSTS
- GROSSPROFIT
- OTHERINCOME
- EXPENSES
- NETPROFIT
- ASSETS
- LIABILITIES
- NETASSETS
- EQUITY
- AccountTotalName
- A text field that provides a display field you can include on your report. Possible values are:
- Income
- Cost Of Sales
- Gross Profit / (Loss)
- Other Income
- Operating Expenses
- Net Profit / (Loss)
- Assets
- Liabilities
- Net Assets
- Equity
- IsProfitLoss
- A true/false value that indicates if the account total should show on a profit and loss report.
- IsBalanceSheet
- A true/false value that indicates if the account total should show on a balance sheet report.
- IsAccountClassification
- A true/false value that indicates if the account represents a single account classification or total of multiple account classifications.
- This field is useful within DAX to produce totals for Gross Profit / (Loss) and other totals to hide the breakdown of accounts.
- Order
- A true/false value that provides the sort order of the total on a report.
- VarianceImpactSign
- A integer field provides a value of +1 or -1 indicating whether variance calculation based on impact should should be reversed or not.
- As an example, REVENUE would be 1 but EXPENSE would be -1.
- AccountsTypes
- A record field containing account types that are included to generate the total.
AccountsTypes Fields
The AccountsTypes field includes the following fields. It provides access to list of accounts types that are included to generate the total.
- AccountType
- A text field that identifies the high-level type of accounts to include.
- This field can linked to the Accounts Types field of either the Accounts or AccountsTypes endpoints.
- DrCrSign
- A integer field provides a value of +1 or -1 indicating how to include values for the classification.
- As an example, Gross Profit / (Loss) would list Income with a +1 value, but CostOfSales with a -1.
Xero API
This endpoint is not part of the Xero API but specific to OdataLink to ease development.
Related Endpoints