Executive Summary report

The Executive Summary report is an overview showing key cash, profitability, balance sheet, income, performance and position items.

Your user role will determine whether you can see this report, and if so, whether you can edit, save and publish it, or just view it. This report is also available as part of the Management reports which you can access if you have the Adviser user role.

Run the Executive Summary report

  1. In the Reports menu, select All Reports.
  2. Under Financial, click Executive Summary.
  3. Select a Date and if you want the report to Show a Summary only, or a Summary and Ratios.
  4. Click Update to view your report.

rep - exec - fields.png

Executive Summary report options

Date

The month the report will be run for.

Show

Choose the sections that will be included on the report for the month chosen:

  • Summary – transactions in the key sections of Cash, Profitability and Balance Sheet
  • Summary. and Ratios– summary transactions and a section showing ratios for income, performance and position (for example, average debtor/creditor days, net profit margin, comparison of current assets to liabilities).

Sections of the Executive Summary report

If you are using multi-currency the report footnotes show the figures that were converted into your base currency for the purpose of reporting in one currency and at what rate the conversion rate occurred. They also show where the rate was taken from (i.e. whether it was an XE rate or a rate entered by a user). Find out more on how multi-currency reports in Xero work.

rep - exec - transactions.png

Amounts

Summary amounts are shown in each section for the month chosen and the month before.

This report is a summary of totals directly from other financial reports or ratios derived from those reports. Where linked amounts are displayed you can click directly through to the source report.

The Executive Summary shows key amounts, not all amounts, in the summary period. Totals may not match depending on your report settings and other transactions in the summary period. For example, Cash Received and Cash Paid totals in the Executive Summary may not agree with totals in your Cash Summary Report.

If there has been a foreign currency gain or loss in a foreign currency bank account, an additional entry for this shows in the 'Cash' section of the report and you can drill down into the Foreign Currency Gains and Losses report for details.

Summary amounts: cash, profitability and balance sheet

Click on an amount in any section of the report to be taken to the report that is being summarised.

‘Cash’ amounts drill down to the Cash Summary Report.

rep - exec - cash links.png

‘Profitability’ amounts drill down to the Profit and Loss report.

rep - exec - profit links.png

‘Balance Sheet’ amounts drill down into the Balance Sheet.

rep - exec - bal links.png

Summary & ratio amounts: income, performance and position

Ratios

  • The ratio section of the report showing figures for income, performance and position only shows if you've chosen the 'Summary and Ratios' option when running the report (shows by default).
  • The amounts and percentages shown in this section are calculations and figures from other reports in Xero. You can't drill down to other reports from these figures.

Executive Summary report terminology

In very basic terms, this is what each of the items in this section is reporting.

Income

  • Number of invoices or bills issued: number of invoices or bills raised during the month (note: doesn’t include drafts, submitted for approval, voided or credit notes).
  • Average value of invoices or bills: total value of invoices or bills less credit notes raised during the month divided by number of invoices or bills issued.

Performance

  • Gross profit margin: the contribution each individual sale made by your business less any direct costs needed to make those sales (things like labour, materials etc).
  • Net profit margin: the contribution each individual sale made by your business less any direct costs needed to make those sales, as well as any fixed overheads your company has (things like rent, electricity, taxes you need to pay as a result of those sales).
  • Return on investment (p.a.): the ratio of net profit made, to the amount of assets the company used to make those profits.

Position

  • Average debtor days: the average number of days it takes your customers to pay you (fully), across all your customer invoices.
  • Average creditor days: the average number of days it takes you to pay your suppliers (fully) across all your bills.
  • Short term cash forecast: how much cash is expected in or out of your organisation in the next month i.e. balance of your Sales account for the month less the balance of your Purchases account for the month.
  • Current assets to liabilities: (also referred to as 'current ratio') is the ratio of current assets (assets that could be turned into cash within a year) to the current liabilities (liabilities which will be due in the next year). This is typically used as as a measure of a company’s ability to service its debt.
  • Term assets to liabilities: based on account types, calculated as (Fixed Assets - Depreciation) / (Non-current Liabilities + Liabilities). Use this ratio to measure the proportion of your fixed assets backed by term debt.