Skip to main content

Free for 14 days · from $9.90/mo

See plans

XO REPORT FOR GOOGLE SHEETS

Xero reports in Google Sheets.
Inserted and refreshed from the sidebar.

Open the XO Report sidebar, pick a report or a list, choose the companies and the dates, and insert. When Xero changes, refresh one table or all of them.

14-day free trial. Same plans as Excel, one subscription for both.

Google Sheets with a Profit and Loss for September 2026 compared with two earlier months, and the XO Report sidebar showing its report cards
Profit & Loss for September, with the two months before it. Scroll sideways to see the whole sheet.Demo company data

Xero reports in Google Sheets.
Ready to insert.

Each report lands as a filtered table with a title row that says what it is: the report, the date, the companies and the basis.

A Balance Sheet as of 30 September 2026 in Google Sheets with the two previous months, next to the XO Report sidebar
Balance Sheet at 30 September, plus the two previous months. Scroll sideways to see the whole sheet.Demo company data

Report documentation →

Pick the period the way you think about it.
Or read it from a cell.

The report wizard walks you through companies, date, tracking and options. The date step is where most of the monthly work disappears.

The XO Report sidebar on the Date step of a Balance Sheet: Smart, Cell and Fixed tabs, End of Last Month selected, and a comparison with the previous 2 months
The Date step: End of Last Month, compared with the previous 2 months. Scroll sideways to see the whole sheet.

WHERE THE DATE COMES FROM

Smart
Presets like End of Last Month. Quarter and year-end presets follow the financial year set in Xero.
Cell
Point at a date in your sheet. Change the cell, refresh, and the report follows.
Fixed
A date or range you choose, for the file that never moves.

PERIOD COMPARISON

Previous periods
On the Profit & Loss and Balance Sheet, add the previous months, quarters or years to the same table.

By department, region or project.
From your Xero tracking.

Tracking categories belong to one company, so tracking works one company at a time.

Filter the Profit & Loss or Balance Sheet by up to two tracking categories. Or split the Profit & Loss by one, with rows for each account and tracking option. A split cannot be combined with period comparison.

Xero transactions and lists in Sheets.
From invoices to tax rates.

Invoices for a date range, the chart of accounts, every contact. Filter them, pivot them, look them up from your own tabs.

Table documentation →

Several companies,
one table.

The first step of the report wizard is Orgs. Tick one company or several. Plans are priced by Xero organizations, with every user included, the same as in Excel.

One Balance Sheet in Google Sheets as of 30 September 2026 for Demo Holdings Ltd, Demo Hotels Ltd and Demo Property Ltd, with OrgID and OrgName columns
One Balance Sheet, three companies, each row naming its company. Scroll sideways to see the whole sheet.Demo company data

Every table in the spreadsheet, in one list.
Refresh one, or all of them.

The Manage tab shows each XO Report table, its row count and when it was last refreshed. Or use Extensions, XO Report for Xero, Refresh Data.

A Trial Balance in Google Sheets with the XO Report Manage tab listing TrialBalance, BalanceSheet, BankSummary and P&L, each with its own refresh button
Four reports in one spreadsheet, each with its own refresh. Scroll sideways to see the whole sheet.Demo company data

Install from Google's Marketplace.
Then open the sidebar.

Connect to Xero from the sidebar and start the 14-day trial. No credit card.

1Click Install on Google Workspace Marketplace

XO Report for Xero on Google Workspace Marketplace, with the Install button

2In any spreadsheet: Extensions, XO Report for Xero, Open Sidebar

Google Sheets Extensions menu: XO Report for Xero, then Open Sidebar

Then click Connect to Xero, sign in on Xero's page and choose the organization to share.

3Pick a report, choose the dates, insert

The XO Report sidebar in Google Sheets on the Tables tab, with report cards for Profit & Loss, Balance Sheet, Trial Balance, Aged Receivables by Contact, Aged Payables by Contact, Bank Summary, Executive Summary and Budget Summary
The Tables tab, connected to three organizations.Demo company data

Open on Google Workspace Marketplace →Install guide for Google Sheets →

Read-only access to Xero, and only the sheet you have open.

Read-only access to Xero
XO Report reads your Xero data. It cannot create, change or delete anything in Xero.
Sign in with Xero
OAuth 2.0 on Xero's own page. Your Xero password is never stored.
One spreadsheet at a time
The add-on sees only the spreadsheet you have open.

Security and trust →

Questions about Google Sheets.

Is it the same subscription as Excel?
Yes. One XO Report subscription covers Excel and Google Sheets, with the same plans, priced by the number of Xero organizations, and unlimited users.
What is in Excel but not in Google Sheets?
The custom functions, such as XO.BALANCE and XO.PROFIT. Every report and every table on this page is in both. In Google Sheets you build your own layout on top of the tables, with lookups and pivot tables.
Can I combine several Xero companies?
Yes. Tick several organizations in the first step of the wizard and get one table, each row naming its company. The aged reports, and tracking, work one company at a time.
How do I refresh a table?
Open the Manage tab and click the refresh icon next to a table, or refresh them all. Or click a cell in the table and choose Extensions, XO Report for Xero, Refresh Data.
What can the add-on see in my Google account?
Only the spreadsheet you have open. It asks to see and edit that spreadsheet, connect to the XO Report service and show its sidebar. In Xero, access is read-only.

Try it on your own Xero file.

Try XO Report free for 14 days. No credit card required.

Free trial · No credit card · Cancel anytime