Back-calculate line items from invoice totals
| Description | Ex GST | GST | Inc GST |
|---|---|---|---|
| GST Items | — | — | — |
| Non-GST Items | — | $0.00 | — |
| Total | — | — | — |
Australia's GST applies to some goods and services but not others, which means a single invoice can contain a mix of taxable and GST-free items. When entering bills you're often faced with a wall of line items — and while you don't need to enter every one, you do need to split them into two subtotals: items with GST and items without. You can back-calculate these from the invoice total and GST amount, but this tool saves you the algebra.
How do I split GST and non-GST items on an Australian invoice?
Divide the total GST amount by 0.1 to get the ex-GST value of taxable items. Subtract that from the invoice ex-GST total to get the GST-free subtotal. Or just enter the invoice total and GST total above and get the calculation done for you!
Do I need to enter every line item into my accounting software?
No. You only need two subtotal lines — one for GST items and one for GST-free items. Most accounting software including cloud-based packages handles this with a tax code per line.