• Home
  • About Us
  • Add-Ins
  • Templates
  • Pricing
  • Blog
  • Contact
  • FAQ
  • All the Add-Ins

    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.