How to Track Unpaid Customer Invoices in New Zealand

Tracking unpaid customer invoices is essential for maintaining healthy cash flow in any New Zealand small business. It involves keeping an organised record of all invoices sent, noting their due dates, and regularly checking which remain unpaid. Prompt follow-up on overdue invoices helps reduce late payments and improves your business’s financial stability.

Why this comes up / what goes wrong

Many small business owners in New Zealand issue invoices but struggle to keep track of which customers have paid and which have not. This can happen when invoices are recorded in multiple places like spreadsheets, emails, or text messages, making it hard to get a clear picture. Without a systematic approach, invoices can be overlooked, leading to delayed payments and cash flow problems. This is especially common when sales and invoicing rely on informal tools rather than dedicated systems.

Step-by-step

1. Gather all issued invoices: Collect every invoice your business has sent to customers. This includes paper copies, emails, and any digital records.

1. Create a tracking spreadsheet or ledger: Use Excel or Google Sheets to list invoice details in columns: Invoice Number, Customer Name, Issue Date, Due Date, Amount (NZ$), and Payment Status.

1. Enter invoice details accurately: For each invoice, fill in all columns. The due date is usually the issue date plus your payment terms (e.g., 20 days).

1. Regularly update payment status: When you receive a payment, mark the invoice as "Paid" with the payment date. If unpaid, leave it marked as "Unpaid".

1. Identify overdue invoices: Sort or filter your list by due date to find any invoices past their due date still marked unpaid.

1. Follow up promptly: Contact customers with overdue invoices by phone, email, or WhatsApp to remind them of the payment.

1. Record all communications: Keep notes of follow-up attempts and any payment promises.

1. Review your tracking weekly: Consistent review helps catch unpaid invoices early and reduces late payments.

1. Reconcile payments with bank statements: Match your received payments against your invoice list to ensure accuracy.

This manual approach helps you stay organised and aware of your receivables.

Example (fictional figures)

A Christchurch-based building company, KiwiBuild Ltd, issued an invoice on 01/05/2024 to a customer for NZ$12,000. Their payment terms are 20 days.

• Issue Date = 01/05/2024
• Payment Terms = 20 days
• Due Date = 01/05/2024 + 20 days = 21/05/2024
• Invoice Amount = NZ$12,000

KiwiBuild Ltd checks on 25/05/2024 and sees the invoice is unpaid.

Calculation:

NZ$12,000 × 1 (full amount) = NZ$12,000 unpaid

They call the customer on 26/05/2024 to follow up.

If the customer pays NZ$7,000 on 30/05/2024:

NZ$12,000 - NZ$7,000 = NZ$5,000 remaining unpaid

KiwiBuild Ltd updates the payment status to "Part Paid" and sets a reminder to follow up for the remaining NZ$5,000.

Common mistakes

• Not recording all invoices in one place: Leads to missed unpaid invoices. Use a dedicated spreadsheet or CRM to centralise records.
• Ignoring due dates: Without regular review, overdue invoices pile up. Set calendar reminders to check weekly.
• Poor follow-up communication: Delayed or no contact allows late payments. Contact customers promptly and keep records of conversations.
• Mixing sales and invoicing channels: Using text, email, and spreadsheets separately causes confusion. Consolidate sales and invoices in one system like HelloGrowthCRM to avoid this.
• Not reconciling payments with bank statements: Payments can be missed or double counted. Always match bank deposits to invoices.
• Overlooking partial payments: Failing to track partial payments causes errors. Update invoice status accurately.

Using a CRM with features like WhatsApp and SMS sequences can help automate follow-ups and keep communication organised. See how HelloGrowthCRM supports this below.

Doing this in HelloGrowthCRM

HelloGrowthCRM offers a built-in quoting and proposal tool that lets you create, send, and track commercial documents like quotes and invoices directly from a deal record. You can see the status of each quotation—whether sent, viewed, or accepted—on the same screen as your follow-up tasks, helping you stay organised. After the sale, service requests remain linked on the same customer record, making ongoing customer management easier. Learn more about its WhatsApp and SMS CRM features and customer health score to monitor your customers’ engagement. For New Zealand businesses, HelloGrowthCRM offers tailored solutions—see HelloGrowthCRM for New Zealand.

Frequently asked questions

How often should I check for unpaid invoices? It’s best to review your unpaid invoices at least once a week. This helps you identify overdue payments early and follow up promptly to maintain steady cash flow.

What payment terms are common in New Zealand? Many NZ businesses use payment terms of 20 to 30 days from the invoice date. Choose terms that suit your business and clearly state them on your invoices.

How can I handle partial payments? Record partial payments as they arrive and update the invoice status to "Part Paid." Keep track of the remaining balance and follow up until fully paid.

Can I automate invoice reminders? Yes, using a CRM like HelloGrowthCRM, you can send automated follow-up messages via WhatsApp, SMS, or email to remind customers about unpaid invoices, reducing manual work.

What if a customer disputes an invoice? Keep detailed records of all communications and the invoice details. Resolve disputes quickly by clarifying charges and adjusting invoices if necessary.

Key takeaways

• Keep all invoices recorded in one organised list or system.
• Regularly check for unpaid and overdue invoices.
• Follow up promptly with customers on late payments.
• Record all payments accurately, including partial payments.
• Avoid mixing sales and invoicing channels; consolidate in a CRM if possible.
• Use tools like HelloGrowthCRM to streamline tracking and follow-up.

Start managing your unpaid invoices more effectively today. Start on the Free Forever plan (200 leads, no credit card) with HelloGrowthCRM and simplify your invoicing and follow-up processes.