Scott's Add-Ins link Xero™ general ledger data with Excel™. When you install the add-in, you will see the following new Excel™ functions available:
=XGL
Populates the cell with the dollar sum of the transactions for a GL account for a specified start and end date.
=XRANGE
Populates the cell with the dollar sum of the transactions for a range of GL accounts for a specified start and end date.
=XDESC
Populates the cell with the GL account description.
=XTRACK
Populates the cell with the dollar sum of the transactions for a GL account using tracking information for a specified start and end date.