Reconcile entered GST and mixed price bases on a tax invoice

Start with the fictional example or checked records

Inputs are processed by this page without uploading to an account or saving them. Your browser may restore fields. Existing page/CTA analytics is separate and does not receive these input values.

Original fictional calculation · not a customer result

Worked example: the difference to inspect

In the fictional example, AUD200 exclusive plus AUD20 entered GST gives AUD220. AUD110 inclusive already contains the entered AUD10 GST and stays AUD110. The no-GST line is AUD50. Combined net is AUD350, GST AUD30 and total AUD380. A footer showing AUD35 GST is AUD5 above the line sum even though its grand total matches.

reference,basis,entered_price,entered_gst
DEMO-A,exclusive,200.00,20.00
DEMO-B,inclusive,110.00,10.00
DEMO-C,none,50.00,0.00

35.00

380.00

Download fictional input · Download fictional result

Method and explicit boundaries

exclusive means entered_price is the pre-GST amount, so line total is price + entered GST. inclusive means entered_price is the final price, so net is price − entered GST. none keeps price as both net and total and requires entered GST zero. Add the lines, then compare entered footer GST and grand total separately. All input money has at most two decimals; integer cents are added exactly.

This is not a GST-rate calculator, tax-invoice validity certificate or entitlement check. It does not determine taxable, GST-free or input-taxed status. A numerically matching AUD200/AUD5 entry still needs an independent tax check. It does not spread discounts or determine the tax treatment of expenses, deposits, credits or reimbursements. Use current official guidance or an adviser for those decisions.

Choose the existing template after resolving the result

Confirm the correct GST choices first. In ABN Invoice, check the real business GST state and each line’s inclusive/exclusive/no-GST selection, then compare the actual preview. Nothing from this worksheet is inserted into a saved draft.

• Australian tax invoice template
• Invoice template formats
• Invoice sample

Start without signing in; free use has branding and usage limits. Review any optional membership against real repeat-use needs. Downloading a worksheet is not a successful invoice export.

Checks for different questions

• Check quantities, unit prices and the copied subtotal
• Check overlapping service times before invoicing a job
• Compare ordered, completed and already-invoiced quantities

All worked examples and the download pack

Source and review date

Australian Government guidance describes invoice fields including quantities, prices and GST payable. This arithmetic model is original; the guidance does not endorse the checker or validate a user’s tax decision.

Read the official/primary source

Reviewed 17 October 2026. Exact Australian long-tail volume, indexing and paid outcomes remain unknown; a vendor document or deployment does not establish them.