Batch GST calculator
Paste a list of Australian prices, add or remove GST and copy the results back to your spreadsheet.
One amount per line, or Description and Amount separated by a tab. Two-column CSV is accepted. Use up to 500 rows, with no negative amounts.
Rows and totals
Paste your amounts to see a GST breakdown for each row.
How the totals work
Ex-GST amounts have 10% added. For inclusive amounts, the GST component is one eleventh of the total. Results are rounded on each row, then summed. This can differ from calculating GST once on an aggregate.
Every entered row uses the same selected GST treatment. Leave GST-free or differently treated transactions out of this batch and review them separately.
Keep the context
This is a calculation aid, not a completed BAS. Eligible purchase credits, adjustments and other obligations affect net GST payable. Calculations stay in your browser; amounts and descriptions are not sent to our server.