1/29/26 Using Scott's Query tool to extract data to Excel Next How to install Scott's add-in You Might Also Like How to drill down to transaction detail. How to use the VAL feature to convert cells with =SCOTT functions, to values. How to install Scott's add-in How to use the =SCOTT.XGLTRX function to display an array of Xero journal transactions. How to use the (3) tracking category functions for Xero. XTRACK, XTRACKR, and XTRACKM.
1/29/26 Using Scott's Query tool to extract data to Excel Next How to install Scott's add-in You Might Also Like How to drill down to transaction detail. How to use the VAL feature to convert cells with =SCOTT functions, to values. How to install Scott's add-in How to use the =SCOTT.XGLTRX function to display an array of Xero journal transactions. How to use the (3) tracking category functions for Xero. XTRACK, XTRACKR, and XTRACKM.
