Preparing the Statement of Cash Received and Cash Paid

November 17, 2025
Share this good article

Overview: What this statement is trying to achieve

The aim of the Statement of Cash Received and Cash Paid is simple:

Take every transaction from your bank accounts for the financial year, assign each one to an official XRB category, then total up the amounts for each category.

These categories are part of the Tier 4 reporting standard and are required for all Tier 4 performance reports.

If you have fewer than around 30 transactions, this can be done manually. For anything more, we strongly recommend using a spreadsheet—or a tool like Good Numbers—to make the job easier.

In this guide:

Note:
This guide only applies if your organisation is not GST registered.
If you are GST registered, you’ll need software like Xero or Prosaic to handle GST calculations correctly.

Step 1: Gather all your transactions

Export all transactions for every bank account used by your organisation, including:

  • main bank accounts
  • savings or term deposits
  • credit cards

Export these as CSV or Excel files.

Make sure the dates line up with your financial year

If your financial year ends on 31 March 2025, you need transactions:

1 April 2024 → 31 March 2025 (inclusive)

Do not include transactions from any day that is outside of these dates. They belong in different financial years.

Step 2: Categorise your transactions

Every transaction needs a category.

There are three types:

1. Money In (Operating Activities)

General income categories, including:

  • Donations, koha, bequests & fundraising
  • General grants received
  • Service delivery grants/contracts
  • Membership fees & subscriptions
  • Sale of goods or services (commercial)
  • Interest or dividends received
  • Other cash received

2. Payments (Operating Activities)

  • Fundraising costs
  • Employee remuneration & related
  • Volunteer related costs
  • Costs of commercial activities
  • Other operating costs
  • Grants & donations paid
  • Other cash paid

3. Other Activities (special types of cash in or out)

Only used when you sell/buy investments or assets, or take/repay a loan:

Other money in:

  • Sale of investments
  • Sale of other assets
  • Loans/borrowings received

Other payments:

  • Purchase of investments
  • Purchase of other assets
  • Repayment of loans & borrowings

Important exceptions

Refunds

  • Refunding someone: Use the category of the original money in.
  • Receiving a refund: Use the category of the original payment.

Don’t treat refunds as new money in or a payment.

Income tax

Income tax is not coded to the 20 categories. Use the specific category ‘Income tax’.

Transfers between accounts

Transferring money between:

  • two of your bank accounts
  • bank account → credit card
  • savings → cheque account

These are not money in or payments. Code all transfers to “Transfers” and do not include them in the statement.

Step 3: Total each category and enter it into the Statement

Add up the amounts in each category and enter these totals into the Statement of Cash Received and Cash Paid.

Things to watch out for

  • Some categories will be blank—that’s normal.
  • If your bank shows payments as negative numbers, change them to positive before entering.
  • Only fill in the “current year” column. Last year’s figures come from last year’s performance report.

Income tax line

If you categorised any transactions as income tax:

  • Refunds appear as positive numbers.
  • Payments appear as negative numbers.

Example Categorisation and Statement

Here is a simple example of 10 transactions, how they've been coded, and how they show up in the statement of cash received and cash paid.

01/04/2024	-$249.00	Accountant fees	Other operating costs
18/04/2024	$2,500.00	Grant from Foundation North	General grants received
16/05/2024	-$23.21	Pizza hut	Volunteer related costs
19/06/2024	-$32.54	Pizza hut	Volunteer related costs
13/06/2024	$100.00	R M McKenzie	Donations, koha, bequests & fundraising
14/06/2024	$250.00	B W Adams	Donations, koha, bequests & fundraising
23/08/2024	-$999.00	PB Tech	Other operating costs
31/08/2024	-$123.12	Microsoft Online	Other operating costs
30/11/2024	-$45.67	Countdown Horowhenua	Volunteer related costs
14/02/2025	$145.23	ASB - Term Deposit Interest	Interest or dividends received
Example: 10 Transactions that have been categorised
Example: Cash received from operating activities
Example: Cash paid for operating activities
Example: Cash received and paid for other activities
Example: Surplus, Deficit, and Represented by

From here, you can return to the main guide to continue finalising your statements.

Tools that can help

Categorising transactions gets much easier if you use a tool to do so.

  • Good NumbersOur Tier 4 tool categorises transactions and produces draft statements in under five minutes. Our Good Numbers App helps make sure you are ready to report to your Funders or Charity Services anytime.
  • Prosaic – A low-cost option with automatic bank feeds.
  • Xero – Widely used accounting software (most expensive option).

Explanation of categories

Money in:

CategoryExamplesExplaination
Donations, koha, bequests & fundraisingraffle proceeds, cash koha at an event, bequest from a supporter.Cash received from general giving or fundraising activities.
General grants receiveda council community grant, a foundation grant for general operations.Grants given for overall support, without a requirement to deliver specific services.
Service delivery grants/contractsfunding to run 10 youth workshops; contract to deliver counselling hours.Funding received to deliver agreed services, programmes or outputs.
Membership fees & subscriptionsannual club fees, subscriptions to join a community group.Fees paid by members in exchange for membership benefits.
Sale of goods or services (commercial)selling merchandise, running a bar or café, ticket sales for a show.Cash earned from activities run on commercial terms.
Interest or dividends receivedinterest from a savings account, dividends from shares.Earnings from bank accounts or investments.
Other cash receivedinsurance payouts, small one-off reimbursements, incidental income.Anything received in cash that doesn’t fit another category.

Other money in:

These categories are only used for special types of money coming in – usually when selling investments, selling assets, or taking out a loan.

CategoryExamplesExplaination
Sale of investmentsselling shares or managed funds.Cash received from selling investments.
Sale of other assets
selling a laptop, sound system, or second-hand equipment.
Cash from selling organisational assets.
Loans/borrowings receiveddrawing down on a loan, receiving an advance from a board member.Cash borrowed from a bank or other lender.

Payments:

CategoryExamplesExplaination
Fundraising costsbuying raffle prizes, venue hire for a fundraiser.Costs of running fundraising activities.
Employee remuneration & relatedpayroll for a coordinator, payment to a freelance tutor.Wages, salaries, contractor payments, and related employment costs.
Volunteer related costspetrol vouchers, food during volunteer events.Expenses paid to support volunteers to do their roles.
Costs of commercial activitiesbuying bar stock, purchasing materials for merchandise.Costs for activities run on commercial terms.
Other operating costsrent, IT, insurance, printing, supplies, professional services.All other operational or administrative spending.
Grants & donations paida hardship payment to a family, a donation to another charity.Cash your organisation gives to others — organisations or individuals.
Other cash paidbank fees, minor miscellaneous expenses.Any cash paid that doesn’t fit a specific payment category.

Other payments:

These categories are only used for special types of money going out – usually when buying investments or assets, or when repaying a loan.

CategoryExamplesExplaination
Purchase of investmentspurchasing shares or managed funds.Cash used to buy investments.
Purchase of other assetsbuying a laptop, sound system, office furniture.Cash used to buy assets that will be used for longer than one year.
Repayment of loans & borrowingsloan instalments, repaying money borrowed from a trustee.Cash used to repay debt.
Was this article helpful?
YesNo

Still have questions?

Ask Duncan anything — big or small. He’ll get back to you ASAP, and your questions will help improve the information here for everyone.

Ask Duncan now >
Illustration of Duncan
Get good news each month by signing up to our newsletter:
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram