pattern
Charities Services Ngā Rātonga Kaupapa Atawhai
Charities Tag Line - Supporting Charities in New Zealand for Stronger Communities

Automated Cash Book - making your reporting easier

Published 30 July 2025

We understand that financial reporting can be time-consuming, especially for smaller charities. To help make the process easier, we’ve updated the Automated Cash Book, an Excel-based tool designed for Tier 4 charities.

This tool helps you prepare your Statement of Cash Received and Cash Paid, which is required as part of your annual performance report. It automatically organises your bank transactions into the format needed to meet External Reporting Board’s standards.

In simple terms, the statement shows all the money your charity received and spent during the financial year, along with changes to your bank balance and the reasons for those changes.

You can download the Automated Cash Book and a step-by-step guide below.

If you have any questions, you can email us at info@charities.govt.nz

Download the Automated Cash Book Excel Tool
Download the Automated Cash Book Guide