Xero Accounting Endpoint: ExecutiveSummary

Overview

The Xero ExecutiveSummary endpoint provides various totals for a given date. These totals range covers Profit and Loss, Balance Sheet, Financial Performance, Financial Position, etc.

It is a function that accepts a series of parameters.

Parameters

The ExecutiveSummary is a function that accepts the following parameters.

Date: A date field that determines the date for which to produce values.; If omitted, it will use the last date of the last calendar month.

Fields

The following fields are available for the ExecutiveSummary endpoint.

Date: A date field that indicates the date used to produce the values.; This will match the Date entered as parameter.

UpdatedDateUTC: A date time field that indicates when the data was calculated.

Lines: A table field that provides the list of values.; See Lines Fields for more information.

Lines Fields

The Lines Fields include the following sub fields.

Description

A text field that indicates the type of value.

Possible values are:

Average creditors days
Average debtors days
Average value of invoices
Cash received
Cash spent
Cash surplus (deficit)
Closing bank balance
Creditors
Current assets to liabilities
Debtors
Direct costs
Expenses
Gross profit (loss)
Gross profit margin
Income
Net assets
Net profit margin
Number of invoices issued
Other Income
Profit (loss)
Return on investment (p.a.)
Short term cash forecast
Term assets to liabilities

Type

A text field that indicates the category of the value.

Possible values are:

Balance Sheet
Cash
Income
Performance
Position
Profitability

ThisMonthAmount: A decimal field that provides the value for the month.

LastMonthAmount: A decimal field that provides the value for the previous month.

VariancePercent: A decimal field that provides a variance between the two months.

Xero API

For a detailed run through of the endpoint, you can see the Xero API.

Related Fields

None

Related Endpoints

None

Xero Accounting Endpoint: ExecutiveSummary

Contents