FINANCE AUTOMATION

Automated Financial Reporting for NZ Small Business: Xero to Inbox

A monthly report that builds itself and lands where you already read. What to include, what Xero does already, and what a workflow adds.

20 October 2026AUXA Team

If you own a small business in New Zealand, you probably find out how last month went in one of two ways. Either your accountant tells you, weeks later, or you log in to Xero on a Sunday night, click through four reports and copy numbers into a spreadsheet.

Automated financial reporting is the third option. A report that builds itself on a schedule, from the figures already in Xero, and arrives in your inbox on the first working day of the month. You read it with your coffee. Nobody exported anything.

This guide walks through how to set that up. It uses Xero because that is what most New Zealand small businesses run, but the shape of the work is the same for any accounting system.

Step one: decide what you actually need to see

Start with the questions, not the software. Most owners want answers to the same five things each month:

  • Cash. What is in the bank today, and which way is it trending?
  • Money owed to you. Who has not paid, how much, and how old is it?
  • Money you owe. Supplier bills due in the next few weeks.
  • Revenue and profit. This month against the same month last year, or against your budget if you have one.
  • GST. Roughly what you will owe at the next return, so it is not a surprise.

Write those down as one page. If your report needs a second page, cut something. The report that gets read is the short one.

Step two: see what Xero already does

Before you build anything, open Xero Central and check the current feature set, because it changes. Xero already produces every report on that list: profit and loss, balance sheet, aged receivables and payables, and a GST return summary. You can save a custom layout so the profit and loss shows the columns you want, and the dashboard shows bank balances and outstanding invoices the moment you log in.

What Xero does not do on its own, at the time of writing, is send those reports to you on a schedule. Xero’s own product feedback forum confirms that scheduled emailing of reports is not currently on its roadmap. That gap is exactly what the automation fills. Everything else, the figures and the layouts, Xero is already doing.

One more thing to switch on before you automate anything: Xero’s own invoice reminders. If your receivables problem is that nobody chases, a reminder schedule fixes more than a report does. We cover the rest of the invoice side in our guide to automating Xero invoice processing in New Zealand.

Step three: the workflow, in plain terms

An automated report is four steps joined together. The tools vary. The steps do not.

  1. A trigger. A schedule, say 7am on the first working day of the month. Nothing clever.
  2. Pull the figures. The workflow connects to Xero through its reporting interface, which Xero publishes for other software to use, and fetches the reports you chose in step one for the period just ended.
  3. Shape them. The raw reports are long. The workflow picks the handful of numbers you asked for, compares them to last month or last year, and lays them out as a short email or a one-page PDF. A line of plain commentary helps: “Receivables over 60 days are up on last month.”
  4. Deliver and file. Email it to you, post it to the team chat if you use one, and save a copy in a folder so there is a monthly record you can scroll back through in a year.

The first three steps can run in a general-purpose workflow tool or in custom code. A no-code tool is quicker for a first version and fine when everything comes from Xero. A custom build makes sense when the report has to combine Xero with your job management system, your CRM or a bank feed, or when you would rather the data did not pass through a third-party service. Either way it is a small, well-defined piece of work, and it is the kind of job described on our business process automation service page.

Step four: the New Zealand specifics

Three things make a New Zealand report different from the template you will find on an American blog.

GST periods. Most small businesses file GST two-monthly, businesses under NZ$500,000 in sales can file six-monthly, and monthly filing is compulsory over NZ$24 million. Inland Revenue sets out the options on its GST filing frequency page. Your report should show the GST position for your actual period, not a calendar month, or the number will mislead you.

The 31 March year end. Most New Zealand businesses have a standard balance date of 31 March, so “year to date” means from 1 April. Set the comparison columns to your financial year, not the calendar year, and check the date with your accountant if you have a non-standard balance date.

Provisional tax. If you pay provisional tax, the report is a good place for a single line showing the next instalment date and the amount set aside for it. The dates depend on your balance date and your filing method, so take them from Inland Revenue or your accountant rather than hard-coding them.

Step five: where a person still has to check

The report is only as good as the bookkeeping behind it. Three things should be true before it runs, and the workflow should say so if they are not.

The bank is reconciled. If there are unreconciled bank lines for the month, the profit figure is wrong. A good workflow checks for this first and puts a warning at the top of the email rather than reporting a clean number.

The coding is right. Automation does not know that the new laptop was coded to stationery. A quick scan of the largest transactions, by a person, once a month, catches most of this. The report can list them to make that scan easier.

Someone owns the numbers. Decide who reads the report and who acts on it. A report nobody is responsible for becomes an unread email by the third month.

If you run an accounting or bookkeeping practice and want to offer this to clients, the same pattern applies across many Xero files at once. That version is on our page on automation for accountants and bookkeeping firms.

Getting started this month

  1. Write your one-page list of what you want to see.
  2. Open Xero and build each of those reports as a saved layout, by hand, once.
  3. Send them to yourself manually for one month-end. Fix whatever confuses you.
  4. Only then automate the delivery. You will know exactly what you are asking for, and the build will be small.

Done in that order, automated reporting is a few hours of set-up for a report you will read every month for years. Done in the other order, it is an expensive way to find out you did not know what you wanted to see.

Common questions

Can Xero email me a report automatically?

Not on its own, at the time of writing. Xero builds the reports and lets you save custom layouts, but the scheduled delivery to your inbox is the piece a workflow adds. Check Xero Central for the current position before you build anything, because features change.

What should be in a monthly finance report for a small business?

Enough to make a decision and no more: cash in the bank, money owed to you and how old it is, money you owe, revenue and profit for the month against the same month last year or your budget, and your running GST position. If it does not fit on one screen, it will not get read.

How often should the report run?

Monthly for the full picture, and a short weekly cash and receivables line if cash is tight. Daily reports get ignored within a fortnight. Whatever the schedule, run it after the bank reconciliation is done, or the numbers will be wrong.

Do I need a developer to set this up?

For a first version, often not. Xero connects to many reporting and workflow tools, and your accountant may already have one. A custom build makes sense when the report needs figures from more than one system, when you want control over where the data goes, or when the off-the-shelf tools cannot produce the view you actually want.

Will automated reporting replace my accountant?

No. It replaces the logging in, exporting and copying into a spreadsheet. The judgement about what the numbers mean, whether the coding is right, and what to do about tax stays with a person, and most businesses find the report makes the conversation with their accountant shorter and more useful.

Sources

Talk to us about it

AUXA is based in Auckland and builds automation for New Zealand and Australian service businesses. If you want a second opinion on what your monthly report should contain before you build anything, that conversation is free.

Get in touch