Skip to main content

Free for 14 days · from $9.90/mo

See plans

XERO TO EXCEL

How to export Xero to Excel.
And how to stop doing it every month.

Xero's own export is free and fine for a one-off; the steps are right below. If you rebuild the same report every month, keep it live in Excel instead.

Left: a Profit and Loss exported from Xero's Demo Company and opened in Excel, with title rows on top and every total showing 0.00. Right: a September Profit and Loss for another demo company, Demo Hotels Ltd, as an XO Report table in Excel, with AccountCode, Account and Amount columns, already formatted
Left, a real export from Xero's Demo Company: totals at 0.00 until you click Enable Editing. Right, an XO Report table (another demo company) that stays linked to Xero. Scroll sideways to see the whole sheet.Demo company data

Xero's own export, step by step.
Free, and fine for a one-off.

Xero exports most of its data without any add-in. Reports come out as Excel files; lists come out as CSV.

Reports

Profit and Loss, Balance Sheet, Trial Balance, aged reports

  1. 1Go to Reporting, then All reports, and open the report.
  2. 2Set the dates and click Update.
  3. 3Click Export and choose Microsoft Excel (or PDF, or Google Sheets).

Amounts showing 0.00 in Excel? Click Enable Editing and they fill in.

Xero: export or print a report

Invoices and bills

Sales invoices, purchase bills

  1. 1Go to Sales, then Invoices (or Purchases, then Bills).
  2. 2Pick a tab, and search by date if you need a period.
  3. 3Click Export. For bills it sits in the menu next to New Bill.

You get a CSV file, one row per line item, up to 500 transactions per export.

Xero: export invoices and bills

Bank and account transactions

Every transaction on a bank or other account

  1. 1Open the Account Transactions report under Reporting, All reports.
  2. 2Select the accounts and the date range, then click Update.
  3. 3Click Export, like any other report.

Xero: Account Transactions report

Contacts and chart of accounts

Customer and supplier lists, your accounts

  1. 1Contacts: go to Contacts, choose a group, click the three-dot menu at the top right and click Export.
  2. 2Accounts: go to Accounting, then Chart of accounts, and click Export.

Both download as CSV files.

Xero: export contacts and chart of accounts

What the files look like

Reports: totals at 0.00. Excel opens downloaded files in Protected View, and the totals stay at 0.00 until you click Enable Editing. Then come the title rows to delete.

A Profit and Loss exported from Xero's Demo Company, open in Excel in Protected View: line items show amounts, but Total Trading Income, Gross Profit, Total Operating Expenses and Net Profit all read 0.00, with an Enable Editing button in the yellow bar
A Profit and Loss from Xero's Demo Company, exported and opened in Excel. Scroll sideways to see the whole sheet.

Lists: a raw CSV. The invoices file has 44 columns, starting with 16 address columns; the invoice number, dates and amounts come after them. Dates arrive as text and amounts with four decimals, and contacts come with 72 columns.

An invoices CSV exported from Xero's Demo Company, open in Excel: narrow ContactName, EmailAddress and postal and street address columns, with the invoice number, dates and amounts further right off screen
An invoices export from Xero's Demo Company, opened in Excel. Scroll sideways to see the whole sheet.

Menu names can differ a little by region and Xero version; the linked Xero Central articles have the current steps. Xero's overview of exporting data lists everything else it can export.

The catch with exports.
Every change means a new one.

An export is a copy of the day you downloaded it. A late invoice, a corrected bill or a new month, and you start again.

A real Profit and Loss export from Xero's Demo Company with a checklist beside it: click Enable Editing (until then, totals show 0.00), delete the title rows, paste into your pack. A note says a late invoice changed in Xero after the export: every change in Xero, all over again
Enable editing, delete the title rows, paste into your pack. Then a late invoice arrives. Scroll sideways to see the whole sheet.Demo company data
Three companies, Demo Hotels, Demo Property and Demo Holdings, each with Profit and Loss exports dated 1, 6 and 9 October
Demo company data

More than one company? Xero exports one company at a time, so every change means one export per company.

Several versions in a folder. The 1 October file, the 6 October file, the 9 October file. Which one went in the pack?

See the difference in under 90 seconds.
Export once, then Refresh.

The usual export next to an XO Report table, an invoice list, and a new month brought in with Refresh.

Keep it live in Excel instead.
Three steps, once.

XO Report brings the same reports and lists into Excel as tables that stay linked to Xero.

  1. STEP 1

    Add XO Report from inside Excel

    On the Home tab, click Add-ins, type "xo r" in the search box, then click Add next to XO Report. No search box? Choose More Add-ins and search the Store.

    Excel Home tab with the Add-ins button
    XO Report in the add-in search results, with its Add button
  2. STEP 2

    Sign in to Xero

    Open XO Report from the Home tab, click Connect to Xero and pick a company; add more the same way. Access is read-only.

    XO Report pane in Excel with the Connect to Xero button
  3. STEP 3

    Insert what you used to export

    Pick a report or a table, choose the dates and click Insert. It lands as an Excel table you can filter and pivot.

    The XO Report Tables tab with report cards for Profit & Loss, Balance Sheet, Trial Balance and Aged Receivables
An Invoices table in Excel with OrgName, InvoiceNumber, Contact, Date, DueDate, Status, SubTotal and TotalTax columns, one row per invoice
Invoices as an Excel table, one row each, no CSV to clean up. Scroll sideways to see the whole sheet.Demo company data

Want a single figure instead of a table? =XO.BALANCE returns an account's total for two date cells, and balance sheet accounts return the balance on the end date. =XO.PROFIT returns net profit for a period of up to a year. All the formulas →

Next month: Refresh, not export.
Same workbook, new figures.

Change the dates and click Refresh. Every XO Report table in the workbook updates from Xero, and your formatting and added columns stay.

The same Profit and Loss table after a Refresh with October dates: Sales 437,208.36 and net profit 106,955.67, labelled Now October, from Xero
The September table from the top of the page, after new dates and one Refresh: October, straight from Xero. Scroll sideways to see the whole sheet.Demo company data

Formulas recalculate for the new period when you change a date cell, and fetch it from Xero if it isn't loaded yet. Recalculating without changing inputs (F9) may reuse the figures XO Report already has; to pull the very latest straight from Xero, click Refresh in the XO Report pane.

What XO Report covers.
And what to keep exporting.

Live in Excel with XO Report

  • Xero's standard reports →: Profit and Loss, Balance Sheet, Trial Balance, aged receivables and payables, Bank Summary, Executive Summary, Budget Summary
  • Invoices, bills, credit notes, payments, quotes and purchase orders
  • Manual journals →, one row per journal line
  • Contacts, chart of accounts, items, tracking categories, tax rates and currencies
  • Bank transactions → (Beta)

Keep using Xero's export

  • Payroll and employee records
  • The Account Transactions report, Xero's line-by-line general ledger for every transaction

Reports and tables work in Google Sheets too. The formulas are Excel only. XO Report for Google Sheets →

Five ways to get Xero into Excel.
Compared.

They differ in what happens after you close the file.

MethodUpdates itself?SetupGood for
Xero's own exportManual export vs XO ReportNo. Export again after any change.NoneA one-off report or list
Copy and paste from Xero's screensNoNoneA few figures, once. Expect text-formatted numbers and dates to fix.
Power Query on the Xero APIYes, once builtAn API connection you build and maintain, with token renewal and a query per companyTeams with a developer
A data connectorXO Report vs data connectorsOn its sync scheduleA separate service that copies Xero into a sheet or databaseData that also feeds Power BI or a warehouse
An Excel add-in such as XO ReportYes, when you click Refresh in ExcelAdd it from inside Excel and sign in to XeroA workbook you open again next month

Best Xero Excel add-ins compared →

Questions people ask.

Can I export Xero to Excel for free?
Yes. Xero exports its reports to Excel and its invoices, bills, contacts and chart of accounts to CSV at no cost. The steps are at the top of this page. What it can't do is update the file afterwards: after any change in Xero, you export again.
What is the easiest way to export a revenue report from Xero?
Use the Profit and Loss: its income section shows revenue by account. In Xero, go to Reporting, then All reports, open the Profit and Loss, set the dates and click Update, then Export and Microsoft Excel. If you need it every month, insert the Profit and Loss with XO Report and click Refresh next month, or put XO.BALANCE on your sales account codes with two date cells, filtered by a tracking category if you report revenue by region or department.
How is XO Report different from exporting?
An export is a copy of the figures on the day you downloaded it. XO Report inserts the same reports and lists as Excel tables that stay linked to Xero, so next month you change the dates and click Refresh instead of exporting and cleaning up again.
Can XO Report export payroll or employee details?
No. XO Report reads Xero accounting data and does not read payroll or employee records. For those, use the payroll reports and exports in Xero or in your payroll provider.
Can I export several Xero companies at once?
Not with Xero's own export, which works one company at a time. In XO Report you tick several companies and get one table, each row naming its company. Plans go by the number of companies: Solo 1, Lite 3, Pro 10, Business 25, Max 50.
Does it follow an Australian or New Zealand financial year?
Yes. Presets such as This financial year, Last financial year and Year to date read the company's year end from Xero, so a 30 June or 31 March year end works without typing dates (in a table with several companies, the first company's year end sets the dates). With Xero's own export you pick the dates by hand every time.
Does XO Report change anything in Xero?
No. It only reads. Every report, table and formula is a read from Xero, and the access you approve when you sign in has no write permission.
Does it work on a Mac, in Excel for the web, or in Google Sheets?
Yes. The same add-in runs in Excel on Windows, Mac and the web. In Google Sheets you get the reports and tables from a sidebar; the formulas, such as XO.BALANCE, are Excel only.

Stop exporting the same report every month.

Insert it once, refresh it next month. 14-day free trial, no credit card.

Free trial · No credit card · Cancel anytime