Invoice generator with GST toggle
Invoice, settings and register in one workbook. Shows INVOICE with no GST if you are not registered, or a TAX INVOICE with 10% GST when you switch it on.
✓ Included in Template Library
Small Biz Sheets
Templates for Australian small business
17 Excel templates, each opened with sample data and checked for broken formulas before it was listed. Prices in AUD; every template works whether or not you are registered for GST.
Invoicing & Getting Paid
Back to contents ↑
GST tax invoice (with ABN)
Single-page tax invoice for GST-registered businesses with every detail the ATO requires, including the buyer’s name or ABN for sales of $1,000 or more. Works out 10% GST per line and warns you if anything is missing.
✓ Included in Template Library
Debtors ageing
See who owes you and for how long: Current, 1-30, 31-60, 61-90 and 90+ days, with totals per bucket.
✓ Included in Template Library
Budgeting & Reporting
Back to contents ↑
12-month budget vs actual
Budget by month, enter actuals as each month closes, and see the variance and year-to-date position.
✓ Included in Template Library
Monthly profit & loss
Twelve months of sales, cost of sales and overheads, with gross margin, net profit, net margin and a monthly chart.
✓ Included in Template Library
Break-even calculator
How many sales you need each month to cover fixed costs. Three inputs, instant answer.
✓ Included in Template Library
Cash Flow
Back to contents ↑
13-week cash flow forecast
Week-by-week cash in and out for the next quarter, so you can see a shortfall before it happens.
✓ Included in Template Library
Job Costing & Quoting
Back to contents ↑
Job quote
Internal costing sheet with labour, materials and markup, plus a clean price-only quote for your customer with GST and a valid-until date.
✓ Included in Template Library
Job costing: quoted vs actual
Track each job by cost line against the quote, see overruns and the real gross margin.
✓ Included in Template Library
Pricing & margin calculator
Price from cost using a target margin or a markup, with an optional GST toggle for the customer price.
✓ Included in Template Library
Inventory
Back to contents ↑
Inventory with reorder alerts
Stock list with reorder points, stock value and a REORDER flag that highlights in red.
✓ Included in Template Library
Payroll & Staff
Back to contents ↑
Payroll summary with super
Pay runs by employee with gross, PAYG withheld, net pay and super guarantee at 12%. Shows the Payday Super deadline for each payday (7 business days, or 20 for a new employee’s first contribution) and flags late super.
✓ Included in Template Library
Weekly staff roster
Monday to Sunday roster with start and finish times, breaks, total hours and a wage estimate.
✓ Included in Template Library
Client Management
Back to contents ↑
Client register
Clients and leads with status, follow-up dates that flag when due, and a dashboard by status.
✓ Included in Template Library
GST, Tax & Admin
Back to contents ↑
GST & BAS set-aside tracker
Log sales and purchases including GST and see how much to set aside for each quarter’s BAS.
✓ Included in Template Library
Expense & receipt log
Business expenses by category with GST credits and a receipt-kept check.
✓ Included in Template Library
Vehicle logbook (12-week)
A 12-week logbook with the details the ATO asks for (odometer readings, trip dates, purpose, business-use percentage), plus a cents-per-km comparison at 91c/km for 2026-27 (max 5,000 km).
✓ Included in Template Library
VBA Fixes
Back to contents ↑Plain-English fixes for the macro errors that stop a workbook on a busy day. Each fix is a complete procedure, compiled and run in desktop Excel against a test workbook. Stuck on one that isn’t here? Book a fix.
Fix: “Microsoft has blocked macros from running”
Why emailed or downloaded .xlsm files show a red security bar, and the safe way to unblock them.
Fix: Run-time error 1004
The most common VBA error: what it means, the usual causes and corrected code.
Fix: Run-time error 9 “Subscript out of range”
VBA can’t find the sheet, workbook or array item you named.
Fix: Run-time error 91 “Object variable not set”
An object used before it was set, often after a Find that found nothing.
Fix: Run-time error 13 “Type mismatch”
A value of the wrong type, such as text or an error where code expects a number.
Fix: Run-time error 424 “Object required”
Usually a typo in a control or variable name, or a missing Set.
Fix: Run-time error 438
The object exists but doesn’t have the property or method you called.
Fix: Compile error “Variable not defined”
Option Explicit caught an undeclared variable (often a typo).
Fix: “Can’t find project or library”
A missing reference that breaks the whole VBA project.
Fix: macro fails on a protected sheet
Let code edit protected sheets while users stay locked out.
Fix: screen flicker and slow macros
Speed up macros and always restore settings, even after an error.
Fix: macros disappeared after saving
Why .xlsx strips macros and how to keep them.
Fix: “PasteSpecial method of Range class failed”
Skip the clipboard and copy values directly.
Information only, not tax or financial advice. Templates reflect ATO rules and rates as at 14 October 2026 (including the 2026-27 car rate of 91c/km, capped at 5,000 km, and Payday Super from 1 July 2026). Check ato.gov.au or your adviser before you rely on them.
Get all 17 with the Template Library
Ongoing access to every premium Small Biz Sheets template, including new ones as they’re added. A$49 a month, cancel any time.