NZ Sole Trader GST + Invoice Tracker

Quotes, invoices, expenses and your GST position in one spreadsheet, built for NZ sole traders.

NZD 19 incl. GST, one payment

Digital download. If the file doesn't work for you, email support and we'll refund you.

  • Opens in Excel and Google Sheets
  • Download straight after payment
  • Secure checkout by Stripe

What's inside

Eight sheets in one workbook. Each one is listed below as it appears in the file.

Start here

Read-first steps, and how the SAMPLE rows work.

Settings

Business name, GST number, filing period (monthly, two-monthly or six-monthly), first period start date, number prefixes, payment terms, quote validity and an optional late fee %.

Quotes

Quote date, client, description and ex-GST amount. GST, total and valid-until date calculate. Status is a dropdown: Sent, Accepted, Declined or Expired.

Invoices

Ex-GST amount, GST and total, due date, paid date and amount paid. Status updates itself to Draft, Sent, Overdue or Paid.

Expenses

Ex-GST amount. GST counts only when you set "GST on invoice?" to Yes. Eleven category choices, such as Materials, Vehicle & fuel and Insurance.

GST Summary

Sales and purchases for 12 filing periods, with net GST and whether it is to pay IRD or a refund. Groups by invoice date, not payment date.

Dashboard

Outstanding and overdue totals, this period's GST estimate, quotes waiting for a reply, and the top 5 unpaid clients.

Notes & sources

How each figure is worked out, and links to IRD's GST pages.

Who it's for

Good fit for

  • NZ sole traders and tradies who send quotes and invoices.
  • Anyone who wants GST worked out for each filing period in one place.
  • Excel users, and Google Sheets users who import the file.

What it doesn't do

  • It does not file your GST return or send anything to IRD.
  • It is not tax, legal or accounting advice.
  • It does not cover income tax, provisional tax or PAYE.

How it works

Three steps from purchase to a working spreadsheet.

Buy

Pay NZD 19 incl. GST through Stripe checkout.

Download

Your files appear on the thanks page straight after payment.

Enter your invoices

Fill in Settings, clear the SAMPLE rows, then add your quotes, invoices and expenses.

You get: Workbook for Excel and Google Sheets (.xlsx), README (.txt).

Questions

Does this file my GST return for me?

No. It totals what you record for each filing period so you can work out what to pay or claim. You still file with IRD yourself, or through your accountant or software.

Does it work in Google Sheets?

Yes. In Google Sheets, use File > Import and upload the workbook.

Is this tax advice?

No. The workbook is a record-keeping tool. The Notes & sources sheet links to IRD pages for the GST rules, and you should check them before you file.

NZ Sole Trader GST + Invoice Tracker

Receipt from Stripe by email. Support: support@tradeflow.org.nz