All the Functions

Functions enabled by Scott's Add-In links Xero™ and QuickBooks™ general ledger data with Excel™

200x200
250X250

=SCOTT.CHART

returns the chart of accounts

=SCOTT.GL

returns GL account balance

=SCOTT.RANGE

returns sum of account balances

=SCOTT.DESC

returns GL account description

=SCOTT.XTRACK

returns GL account balance for a tracking category and option

=SCOTT.XTRACKR

returns sum of account balances for a tracking category and option

=SCOTT.XTRACKM

returns GL account balance filtered by two tracking categories

=SCOTT.XBUDGET

returns budget for a specific general ledger account code

=SCOTT.XNI

returns the Net Income optionally filtered by one or two tracking categories

=SCOTT.CHART

returns the chart of accounts

=SCOTT.GL

returns GL account balance

=SCOTT.RANGE

returns sum of account balances

=SCOTT.DESC

returns GL account description

=SCOTT.QCLASS

returns GL account balance for a specific class

=SCOTT.QCLASSR

returns sum of account balances for a specific class

=SCOTT.QDEPT

returns GL account balance for a specific department

=SCOTT.QDEPTR

returns sum of account balances for a specific department

=SCOTT.QCLASS_DEPT

returns GL account balance for a specific class and department

=SCOTT.QBUDGET

returns budget for a specific account, class, department, customer

=SCOTT.QBUDGETALL

returns budget for a specific account, class, department, customer