Scott’s add-in for Xero, gives you powerful, new Excel functions that allow you to leverage your Xero general ledger data. Build real-time financial reports without leaving Excel. Scott's Add-ins automates the sync of General Ledger data from Xero to Excel.

• Quickly build flexible & bespoke reports for clients and stakeholders
• Consolidate groups & multiple entities into one workbook
• Sync Xero data into your existing Excel templates

Save hours of time each month, and reduce errors. Use your Excel templates without building new ones. Recalc your workbook with fresh Xero data in seconds.

Get started with Scott's Add-ins in less than ten minutes. No training is required. If you know how to use Excel, you know how to use Scott's.

For an even faster start, begin with one of our downloadable Excel templates. These templates are contributed by our users, and are free!

Proformas, Operating Reports, Cash Flow, Tracking Category comparisons, budgets, and multi-org consolidations, are just some of what you can do.

Here’s a list of the custom Excel functions:

= SCOTT.CHART. Returns the chart of accounts.

=SCOTT.DESC Returns the account description for a given account code.

=SCOTT.GL Returns the sum of all transactions for a user specified date range.

=SCOTT.RANGE Returns the sum for a range of account codes.

=SCOTT.GLMULTI Returns the sum of multiple gl accounts and ranges.

=SCOTT.XBUDGET Returns the Xero budget

=SCOTT.XTRACK Returns the sum of an account code for a Tracking Category / Option.

=SCOTT.XTRACKR Returns the sum for a range of account codes for a Tracking Category / Option.

=SCOTT. XTRACKM Returns the sum of account transactions that have BOTH Xero Tracking Categories assigned.

As an example, the syntax for =SCOTT.GL

=SCOTT.GL (Organisation ID, Account Code, Start Date, End Date)

https://player.vimeo.com/video/477192450