Scott's Add-in for Xero and QuickBooks

by Scott's Add-ins

(2 ratings)

Scott's Add-ins for Xero and QuickBooks. Link general ledger data to your Excel spreadsheet.

Create financial art with Scott's Add-ins. Scott's Add-in for Excel, links Xero and QuickBooks general ledger data to your Excel spreadsheet.....seamlessly. Using Excel, create beautiful financial models, P&Ls, budgets, proformas, forecasts, and more, by leveraging your Xero ledger data. Refresh your spreadsheet with current Xero and QuickBooks data, by simply recalculating your sheet. A Xero or QuickBooks subscription is required to use the add-in. The add-in provides you with new functions:

  • = GL

  • = RANGE

  • = DESC

and more! Using these functions, you can connect general ledger account balances, transaction detail, descriptions, and sums of ranges of account balances to your spreadsheet. As the data changes in your accounting system, simply recalculate your Excel sheet.

App capabilities

When this app is used, it
  • Can read and make changes to your document
  • Can send data over the Internet

At a glance