Income Statement report (older version)

Access the older version of the Income Statement report. You will need to use this older version of the report if you want the report to display tracking, or use budgets and show variances.

Your user role will determine whether you can see this report, and if so, whether you can save and publish it or just view it.
Reports and budget role comparison

Run the report

What displays on the report

Report layout options

This report is also available as part of the management reports which you can access if you have the Advisor user role.
Management style reporting packages for month or year end

Run the report

To access the older version of the Income Statement:

  1. On the Reports menu, click All Reports.
  2. Under Financial, click Income Statement.

The default format for the Income Statement report is Current and previous 3 months. This compares the current calendar month with three previous months, and shows a year to date figure.

You can switch to a different view by selecting one of these tabs:

  • Common Formats - choose from five preset formats, and compare tracking categories if you use them
  • Compare Periods - compare a calendar month with previous months
  • Show Date Range - report on a time period between two specific dates, and compare with previous periods.

Common Formats

The Common Formats tab has a range of preset formats for the Income Statement report:

  • Current and previous 3 months (default) shows you the current month, last three months and YTD.

  • Year to date progress - compare how you are tracking so far this financial year with the previous 2 years.

  • Month to date progress - shows the current calendar month up to today's date compared to the same period in previous months. (For example, if today is August 16, it will also show 1 to July 16, 1 to June 16 and 1 to May 16.)

  • Current financial year - shows actual figures for past months, and budgeted figures for present and future months.

    If you're in the last month of your current financial year, all values will show as actuals. (It won't show any budgets as there are no periods in the future for that financial year.)

  • Actual vs Overall budget - shows actual figures with budgeted amounts for the current month and YTD, and the variance for each (value and percentage).

    The Actual vs Overall budget format presents the same information as the default format for the Budget Variance report.
    Budget Variance report

  • Compare [tracking category] - shows the YTD transactions for each option in the named category.

Compare Periods

Compare one calendar month with previous calendar months on the Compare Periods tab.

  1. Select the month and year you want to use as a starting point.
  2. Select a period. Choose from 1 month, 3 months or 12 months as the time blocks for each column on the report.
  3. Select a number of previous periods to compare with the current period. Choose up to 12 periods back from the report date.
  4. From the Budget drop-down, select a budget to compare actual and budgeted figures.
  5. Check the 'Show total' and 'YTD' boxes if you want these to display.
  6. Click More options to see options for sorting and filtering:
    • choose whether to sort by account name or code
    • if you use tracking, you can filter by tracking
    • if you have multi-currency, you can run the report in a non-base currency
    • check Cash Basis to narrow your selection to cash basis transactions.
  7. Click Update to generate the report.

Show Date Range

Select the Show Date Range tab to run the report between two specific dates. You can also compare the current date range with previous periods.

  1. Enter start and end dates into the From and To fields.
  2. From the Compare with drop-down, select the timeframe you want to compare that period with. For example, if you are comparing the period from August 1 to August 14 with 'Previous 1 period', you will also see the period from July 1 to July 14.
  3. Click More options to:
    • sort by account name or code
    • filter by tracking (if you use it)
    • if you have multi-currency, you can run the report in a non-base currency
    • narrow your selection to cash basis transactions using the Cash Basis box.
  4. Click Update to run the report.

Foreign currency and reporting

What displays on the report

The Income Statement report always has a section for income and a section for expenses, to show amounts used in calculating the final net profit figure.

The report only displays accounts with budgeted or actual income or expenses for the period.

If your organization pays employee wages through Pay Run, wages information will be visible as a total figure for each relevant expense account. Only Payroll Admin users will be able to drill into a wage payable invoice or employee payment to see the full details.

Report layout options

You can customize the Income Statement report to have a GAAP format. First, you need to ensure the organization's chart of accounts is structured correctly.
Prepare GAAP style Income Statement and Balance Sheet reports

If you have the Advisor user role you will also be able to Save as Draft, or Publish this report and change the default PDF preferences. If you’re using Partner Edition, your practice logo will display if your Principal has set it up.

Use the Layout Options button to change the format of the report if you wish.

The Layout Options button will show one or more options depending on how the report is currently being displayed:

  • Create new layout - available at all times whether you're viewing the report using the Xero standard layout or one that's been created for the report.
  • Edit this layout - available if you're viewing the report using a layout created by you or someone else in your organization. You can't edit Xero's standard layout.
  • Choose layout - switch to another layout (including Xero's standard layout) created by you or someone else in your organization.
  • Save as favorite - make the layout available for the report in all the organizations you have access to in Xero.