Welcome to our Reporting blog series, with Xero Payroll NZ

The existing Xero Payroll NZ reporting tools are numerous and comprehensive. But if you're running multiple accounts and need to consolidate data across your entire organization, things get a little more difficult.

Still exporting CSVs and rebuilding the same pivot tables every month? Point Microsoft Excel at a live copy of your Xero Payroll NZ data instead - your formulas and charts stay put, and updating them becomes a single click.

Querying the Xero Payroll NZ API directly from Power BI is slow and fragile. Stage your data in a relational database first, then build interactive dashboards that combine Xero Payroll NZ with the rest of your business.

Google Sheets is where many teams already share their numbers. With a few lines of Apps Script, you can query your Xero Payroll NZ data straight into a sheet and give everyone one shared, up-to-date view.

Need a dashboard you can share with a link, without paying for BI licences? Connect Looker Studio (formerly Google Data Studio) to your Xero Payroll NZ data using its built-in SQL Server connector - no exports, no plugins.