Meet the functions 👋

These functions make it a breeze to create bespoke Excel reports from your accounting data.

Xero

=SCOTT.XINVOICE
Array of Invoices

=SCOTT.XBILL
Array of Bills

=SCOTT.XINVOICE_SUM
Sum of selected invoices

=SCOTT.XBILL_SUM
Sum of selected bills

=SCOTT.CHART
Chart of accounts

=SCOTT.GL
GL account balance

=SCOTT.XGLTRX
Array of journals

=SCOTT.GLMULTI
SUM of multiple GL account balances

=SCOTT.GLMULTITRACK
Returns GL account balance for multiple accounts filtered by a tracking category

=SCOTT.LIST
Generates a list of accounts or tracking categories / options

=SCOTT.NGL
Negative sign of GL account balance

 =SCOTT.RANGE
Sum of account balances

=SCOTT.DESC
GL account description

=SCOTT.XTRACK
GL account balance for a tracking category and option

=SCOTT.XTRACKR
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

Quickbooks

=SCOTT.CHART
Chart of accounts

=SCOTT.GL
GL account balance

=SCOTT.GLMULTI
Sum of multiple GL account balances

=SCOTT.LIST
Generates a list of accounts, departments / locations, classes, customers, or vendors

=SCOTT.NGL
Negative sign of GL account balance

=SCOTT.RANGE
Sum of account balances

=SCOTT.DESC
GL account description

=SCOTT.QCLASS
GL account balance for a specific class

=SCOTT.QCLASSR
Sum of account balances for a specific class

=SCOTT.QDEPT
GL account balance for a specific department

=SCOTT.QDEPTR
Sum of account balances for a specific department

=SCOTT.QCLASS_DETP
GL account balance for a specific class and department

=SCOTT.QBUDGET
Budget for a specific account, class, department, customer

=SCOTT.QBUDGETALL
Budget for a specific account, class, department, custome

=SCOTT.QVENDOR
Sum of account balances for s specific vendor.

=SCOTT.QCUSTOMER
Sum of account balances for a specific customer.

=SCOTT.QALL
Sum of account balances that meet criteria for Class, Department, Customer, and Vendor

=SCOTT.QNI
Returns the Net Income filtered by a class, customer, department, and/or vendor.

Get started with a free trial today