Start here
Read-first steps, and how the SAMPLE rows work.
Quotes, invoices, expenses and your GST position in one spreadsheet, built for NZ sole traders.
Eight sheets in one workbook. Each one is listed below as it appears in the file.
Read-first steps, and how the SAMPLE rows work.
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 %.
Quote date, client, description and ex-GST amount. GST, total and valid-until date calculate. Status is a dropdown: Sent, Accepted, Declined or Expired.
Ex-GST amount, GST and total, due date, paid date and amount paid. Status updates itself to Draft, Sent, Overdue or Paid.
Ex-GST amount. GST counts only when you set "GST on invoice?" to Yes. Eleven category choices, such as Materials, Vehicle & fuel and Insurance.
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.
Outstanding and overdue totals, this period's GST estimate, quotes waiting for a reply, and the top 5 unpaid clients.
How each figure is worked out, and links to IRD's GST pages.
Three steps from purchase to a working spreadsheet.
Pay NZD 19 incl. GST through Stripe checkout.
Your files appear on the thanks page straight after payment.
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).
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.
Yes. In Google Sheets, use File > Import and upload the workbook.
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.
Receipt from Stripe by email. Support: support@tradeflow.org.nz