XERO Functions

Live figures from your connected Xero companies.
Not tested yet.
Functions
=XERO.GL("Demo Ltd","200",DATE(2026,1,1),DATE(2026,1,31)) — GL movement
=XERO.REPORT("connections") — list your companies
=XERO.REPORT("accounts","Demo Ltd") — chart of accounts
Values cache for 60s; Ctrl+Alt+F9 forces a refresh.