Create financial art with Scott's Add-ins. Scott's Add-ins 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. A Xero subscription is required to use the add-in. The add-in provides you with new functions:
=XTRACK [/#LI]. Using these functions, you can connect Xero general ledger account balances, descriptions, and sums of ranges of account balances to your spreadsheet. As the data changes in Xero, simply recalculate your Excel sheet.