How to Create an Income Statement in Xero

Welcome to the Fit Small Business Xero training course! In this lesson, we’re going to cover how to create an income statement (also known as a profit and loss statement) in Xero.

You can follow along on your own Xero account. If you don’t have one already, click here to sign up for a free 30-day trial and follow along below.

To complete this lesson, you can either watch the video below, read through the step-by-step instructions, or do both. Let’s begin!

For some small business owners, Xero will provide enough tools to handle their books all on their own. But, for many, it makes sense to use Xero in conjunction with experienced small business accountants who are also Xero experts, like those at Bookkeeper360.

Bookkeeper360 can handle your monthly bookkeeping, payroll, new employee paperwork, taxes, and more. Basic plans start at $249/month. Get your first consultation free.

Visit Bookkeeper360

Why Is It Important to Create an Income Statement?

Income statements show you the revenue, expenses and net profit (or loss) of your business for a period of time. This report helps you understand your profitability, including insight into what areas of your business are generating revenue, and where you are spending your money. Based on the results of this report, you can determine the following:

• Areas of your business where you need to generate more sales.
• Expenses that can be reduced or eliminated altogether.
• Trends in profitability (i.e. certain times during the year where you are more profitable than others)

Why You Should Review your Income Statement Monthly

Your Income Statement will only be as accurate as the information you have entered into Xero; therefore you must stay on top of entering all invoices, bills, credit notes, and banking transactions into Xero.

By staying on top of entering day to day business transactions, you will have accurate and reliable income statements that you can review at least on a monthly basis. Reviewing your income statement on a monthly basis has the following advantages:

• Identify revenue or expenses that have been categorized to the wrong account.
• Catch missing income/expenses which could over/understate what is reported on your tax return.
• Take proactive steps to increase your profit.

Below is a sample Income Statement for our fictitious company, Acme Web Pros Plus.

How Do I Create an Income Statement?

Follow the steps below to create an Income statement.

Step 1 – Navigate to Reports

From the Xero Dashboard, click on Reports and select All Reports as indicated below.

Step 2 – Select the NEW Income Statement Report

The Income Statement report is located in the Financial section as indicated in the screenshot below.

Note: Notice that there are two Income Statement reports. Xero has redesigned several reports and the Income Statement is one of those reports. For the purposes of this lesson, we will discuss the New Income Statement report which has the “New” button next to it.

Note: You can add a report to your favorites by clicking on the star to the left of the report name. We have done this for the Income Statement report so that the next time it will be available directly on the Reports menu.

Step 3 – Select the Date Range for the report.

In the next screen, you can select the time period you would like to run the report for as indicated in the screenshot below.

1. Date Range – From the dropdown, select custom if you would like to enter specific start/end dates; otherwise select from the list of time periods in the dropdown as indicated in the above screenshot.
2. Update – Once you have selected your date range, click the “Update” button to refresh the report.

Below is a sample Income Statement for our fictitious company, Acme Web Pros Plus.

The Income Statement can be exported to PDF, Excel or Google Sheets. Just scroll down to the very bottom of the report, and click the “Export” button as indicated in the screenshot below:

You can also save the report as a draft, published or custom. Just scroll down to the bottom of the report and click on the “Save as” button as indicated in the screenshot below.

1. Draft – This option allows you to create a report that you or someone else can make changes to later on. You might create several draft reports before you are ready to publish them.
2. Published – This option is used to save reports when you are finalizing the books for the month or the year. A published report will not change if for some reason the information in the system has changed or updated in some way. You can only publish reports if you have the Advisor user role.
3. Custom – Use this option if you want to save the report format so that you don’t have to recreate it each time you run the report. Xero will ask you if you would like to make this template your default. We will show you how to save a custom report format in the next section.

How to Modify Report Settings

You can make changes to the income statement in Xero in the following 3 ways:

• Change Report Title
• Change Report Settings
• Change Layout & Format

We will discuss each of these in detail next.

Change Report Title

You can change the title of most reports in Xero. To do this, just hover your mouse over the title of the report and you will see “Edit Title” appear to the far right as indicated in the screenshot below. Click on that link and make the necessary changes to the report title.

In the example below, we changed the title of the report from Income Statement to Profit & Loss Statement.

Change Report Settings

Each report in Xero allows you to change a few report settings. For the Income Statement, this includes accounting basis, any tracking categories you’re generating the report for and a few other options.

To access report settings, click the blue “Report Settings” link located directly to the right of the date range as indicated in the screenshot below.

Below are the report settings available for the income statement along with a brief description of each.

1. Compare with – If you would like to compare your report to a previous month, quarter or year, select the number of periods from the dropdown.
2. Accounting Basis – In general, most businesses use the cash method of accounting. However, the beauty of using Xero is that you can run your reports using either the accrual or the cash method; just make your selection here. Note: The default reports are generated using the accrual method.
3. Numbers – If you prefer not to have decimals show on your report, you can remove this checkmark to change the default setting.
4. Region – If you have set up tracking categories, then you can filter this report to show all tracking categories you have set up or just certain ones.
5. Update – Be sure to click the “Update” button so that the report will refresh.

Change Layout & Format

The edit layout designer tool allows you to further customize the look of your report. Some of the customizations you can do with this tool are as follows:

• Add additional columns for tracking, notes or totals.
• Change account groupings
• Edit formulas
• Rearrange columns by clicking and dragging.

To show you how this works, let’s dive in and create a set of monthly reports:

How to Modify an Income Statement: Example

Example

Acme Web Pros Plus would like to create a custom income statement that will show the previous month so that they can spot trends and possible red flags. Acme would like to save the report as a custom report and make it their default report. This will allow them to quickly run the report without having to recreate it each time.

Listed below are the steps to create the custom Income Statement for the month of June for Acme Web Pros Plus.

Step 1 – Select Date Range: June 1, 2017 – June 30, 2017

Click the “Update” button to refresh the report.

Step 2 – Go to Report Settings and make the following selections:

Note: Notice that we have indicated 5 for the previous periods comparison. This will display the current month (June) and the previous 5 months that have occurred which will allow Acme to compare income and expenses for all 6 months.

Below is the sample Acme Web Pros Plus Income Statement that compares each month from January to June.

While this report looks great if you are looking at each month individually, we should also be able to see what the total income, expenses and net income are for all 6 months combined. This is where the edit layout designer comes in.

Step 3 – Launch Edit Layout Designer

At the very bottom of the report, click the “Edit Layout” button as indicated in the screenshot below.

Below is a screenshot of Edit Layout Designer.

1. In this section, you can use the toolbar to change text, add a schedule to the bottom of a report, add a column or add a row to the report.
2. In this section, you will be able to see the changes that you make to the report in real time.
3. In this section, you will be able to create a formula which we will do next to add a Total column to this report.

Step 4 – Make modifications to report layout.

To add a total column, click on the column icon and select formula as indicated in the screenshot below.

The following screen will display. Below is a brief description of the steps to create a formula column.

1. Insert: From the dropdown, select a column and it will appear in the box directly below.
2. Mathematical operation: Based on the calculation that you want to make, click on the appropriate mathematical operation; go back to insert and select the next column that should be included in the formula.
3. Name: This should be the title that you want to appear on the report for the new column.
4. Done: Once you have created the formula, click the “Done” button.

Below is the updated Acme Web Pros Plus sample report with the new Total column added.

Wrap Up

That wraps up the section on how to create an income statement. The next lesson in our Xero Training Course will be How to Create a Balance Sheet Report. In this lesson, we will discuss the importance of reviewing your balance sheet report and walk you through how to create and customize the report. To access this lesson or any of the others in the series, click here. For a free 30-day trial of Xero, click the link below.