1. Apps
  2. Accountant tools

Scott's Add-ins

Link Xero general ledger data to your Excel spreadsheet. Refresh your spreadsheet with current Xero data, by simply recalculating your sheet!

Scott's Add-in for Excel, link Xero general ledger data to your Excel spreadsheet.....seamlessly. Using Excel, create beautiful financial models, P&Ls, budgets, proformas, and more, by leveraging your Xero ledger data. Refresh your spreadsheet with current Xero data, by simply recalculating your sheet. Supports Xero Tracking Categories. Create financial art with Scott's Add-ins!

Explore all features of Scott's Add-ins

Scott's Add-ins + Xero

Scott's add-in gives you additional Excel functions such as =XGL, =XRANGE, =XTRACK, and =XDESC. These functions allow you to pull Xero ledger balances directly into your Excel spreadsheet. For example, =XGL (4000, 01012019, 01152019) returns the balance of ledger account #4000, for the first 15 days of January.

scotts add ins logo image
Get this app
Made by Scott's Add-ins
Added in 2019

Countries

Australia, Canada, Global, Hong Kong, Ireland, Malaysia, New Zealand, Philippines, Singapore, South Africa, United Kingdom, United States

Languages

English

Support

Support emailSetup walkthrough

Follow

LinkedIn
Although Xero reviews each app in our App Marketplace, we can’t give any guarantees. It’s up to you to assess the performance, quality and suitability of any app before going ahead.