Skip to main content

Free for 14 days · from $9.90/mo

See plans

COMPARE

XO Report vs
Scott's Add-ins

Looking for a Scott's Add-ins alternative? Both put live Xero numbers in Excel. Scott's is well established and has Journals. XO Report costs less as you add companies and users, and works in Google Sheets too.

Try FreeThe short answer

14-day free trial. No credit card.

Excel with a Profit and Loss inserted from Xero for Demo Hotels Ltd, September 2026, and a Month summary beside it where =XO.BALANCE returns Sales 412,751, the same figure as the report
XO Report in Excel: a Profit & Loss straight from Xero on the left, your own live formulas on the right. Scroll sideways to see the whole sheet.Demo company data

The short answer.
It depends on how you work.

Both bring Xero data into a spreadsheet. Here is who each one suits best.

Choose Scott's Add-ins if:

  • You need Journals or GL transaction detail
  • You also report on QuickBooks companies
  • You already use Scott's and it does what you need

Choose XO Report if:

  • You report on several Xero companies
  • Several people on your team need access
  • You want ready-made reports as well as formulas
  • Some of your team work in Google Sheets

The fair view
of Scott's Add-ins.

What Scott's Add-ins does well, and what to know before you choose it.

Strengths

  • On the Xero App Store since 2019, and highly rated
  • Journals and GL transaction data
  • Works with QuickBooks as well as Xero
  • Detailed documentation and support

Limitations

  • Basic ($20/mo) has two functions (=SCOTT.GL, =SCOTT.DESC); everything else needs Pro at $39/mo
  • Each extra organization adds $12 a month
  • Its pricing page lists $8 a month per extra user on both plans (its FAQ still says unlimited users)
  • Multi-currency balance sheets: Scott's own guidance says it works "not so well for Balance Sheet accounts"
  • The first connection builds your transaction history, which can take "a few minutes or a couple of hours"

Where XO Report
is different.

Reports as live tables in Excel and Google Sheets, formulas in any Excel cell, one company or many. Refresh when Xero changes.

Excel with OrgID !Ht9Rx and OrgName Demo Hotels Ltd in the first rows, dates 1 to 30 September 2026 in C4 and C5, and =XO.BALANCE($A$2, A8, C4, C5) in C8 returning 412,751 for account 200 Sales, labelled Same as Sales in the report
In Excel, XO.BALANCE takes the org ID, an account code and two date cells. Scroll sideways to see the whole sheet.Demo company data

Why choose XO Report

  • Every feature on every plan, from $9.90/mo
  • Unlimited users on every plan
  • 84% cheaper at 50 organizations
  • Reports and lists as live tables from the task pane, several companies in one table
  • Compare several periods in one report, ready to filter or pivot
  • Multi-currency balance sheets match Xero: the figures come straight from Xero's own reports
  • No setup wait: connect and pull your numbers right away
  • Works in Google Sheets too, on the same plan

Pricing: Scott's Add-ins Pro is $39/month for the first organization plus $12/month for each additional organization and $8/month for each additional user. A Basic plan costs $20/month for the first organization (plus $12 per additional organization and $8 per additional user) but is limited to two functions (=SCOTT.GL and =SCOTT.DESC). XO Report is 84% cheaper at 50 organizations.

Price comparison

Monthly list prices as published, before tax. Check each vendor's page for today's terms.

OrgsXO ReportScott's Add-insSavings
1$9.90$3975%
5$29.90$8766%
10$29.90$14780%
50$99.90$62784%

See XO Report
at work.

Pictures of XO Report with demo company data. Each one opens a guide.

Frequently asked questions

Is Scott's Add-ins better than XO Report?

It depends on your needs. Scott's Add-ins has a longer track record and access to Journals/GL data. XO Report is significantly cheaper as you add organisations (84% cheaper at 50) and adds tables and reports from the task pane alongside its formulas. Both are solid choices.

Does Scott's Add-ins work on Mac?

Scott's says it works in the desktop and online versions of Excel with a Microsoft 365 subscription. XO Report runs in Excel on Windows, Mac and the web, and in Google Sheets for tables and reports.

How much cheaper is XO Report vs Scott's Add-ins?

XO Report is 84% cheaper at 50 organizations. For 50 orgs: XO Report is $99.90/mo vs Scott's Add-ins Pro at $627/mo, a savings of over $6,300/year.

Is XO Report a true Scott's Add-ins alternative?

Yes. Both are Excel add-ins for live Xero data, and both can report across several Xero organisations. XO Report focuses on lower cost as you add organisations and on tables and reports from the task pane; Scott's focuses on its track record and Journals/GL access. The right alternative depends on whether cost at scale or Journals matters more for your workflow.

How do I migrate from Scott's Add-ins to XO Report?

Sign up with Xero on the install page, then in Excel click Home > Add-ins, type xo r and click Add. Connect your Xero orgs during the 14-day free trial, and rebuild reports using =XO.BALANCE / =XO.PROFIT / =XO.BUDGET formulas. Keep Scott's installed during the trial to verify outputs side-by-side, then remove once XO matches.

Why would I look for a Scott's Add-ins alternative?

Most people looking for a Scotts Add-ins alternative mention price: Scott's Pro at $39/mo + $12 per additional org scales to $627/mo at 50 orgs vs XO Report at $99.90/mo at 50 orgs.

Is Scott's Add-ins accurate for multi-currency organizations?

Scott's own guidance notes the add-in works well for profit & loss accounts but "not so well for Balance Sheet accounts" in a multi-currency Xero organization. For example, receivables and payables show in your home currency, which can differ from your actual balance sheet when you have foreign-currency invoices. XO Report takes its balance figures straight from Xero's own reports, so foreign-currency balances match what Xero shows.

Is Scott's Add-ins slow to set up?

The first time you connect an organization, Scott's runs a one-time build of your transaction history that, by its own documentation, "could take a few minutes or a couple of hours" depending on your transaction volume, and you wait for an email before you can start. XO Report has no build step: connect during the free trial and start pulling numbers immediately.

All comparisons →Compare Xero Excel add-ins →Xero to Excel guide →Pricing →

Sources

  1. Scott's Add-ins: Xero multi-currency considerations (vendor blog)
  2. Scott's Add-ins: FAQ (initial data build)

Try XO Report free

Add it to Excel or Google Sheets, connect Xero, and compare for yourself. 14-day free trial, no credit card required.

Try FreeView Pricing

Free trial · No credit card · Cancel anytime